Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Ola meu problema é o seguinte estou arrumando um sistema de top sites ai eu quero colokar uma função assim
o Usuario registra seu site depois é enviado para o banco de dados com os status off
ai na index.php eu quero mostrar so os sites que estao com status ok no bando de dados vou deixa o codigo da pagina index.php eu queria que coloca-se os status ja nesta pagina se puder Ajuda
<?
require("config.php");
if($_GET["id"]){
$query = mysql_query("SELECT * FROM $table WHERE memberid = '".$_GET["id"]."'") or die(mysql_error());$rank = $object->rank;
$ip = $object->ip;
$port = $object->port;
$days = $object->date;
$days = explode(" | ",$days);
$daytoday = $days[0];
$dayplus = $days[1];
$dayplus = $dayplus + 1;
if($date != $daytoday){ $c = "UPDATE $table SET date = '$date | $dayplus' WHERE memberid = '".$_GET["id"]."'"; }if($daytoday != $date){ mysql_query($c) or die(mysql_error()); }
header("Location: $script_url");
}
}
else{
?>
<? include("header.inc"); ?>
<?
if(file_exists("install.php")){
?>
<p>
O arquivo <b>install.php</b> ainda existe no diretório onde o topsite é, eliminar
o arquivo desta pasta depois que você instalou o topsite ...<br><br>
> <a href="install.php">Install <?php echo $topsite_name; ?></a><br>
> <a href="install.php?del=1">Apagar install.php</a><br></p>
<?
}
else{
?>
<title>echo htmlspecialchars($topsite_name);
?>
</title>
<center>
<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%" align="center">
<?
$req1 = mysql_fetch_array(mysql_query('select memberid from portal where status="ok"'));
$query = mysql_query("SELECT * FROM $table") or die (mysql_error());
$total = mysql_num_rows($query);
if(!$_GET["page"]){
$page = 0;
$prev = "<font class=\"inactive\"><< Anterior $pp</font>";
}
else{ $page = $_GET["page"]; }
$a = $page * $pp;
$b = $a + $pp - $page * $pp;
$pages = $total / $pp;
$pageplus = $page + 1;
$pagemin = $page - 1;
if($page + 1 < $pages OR $pageplus=="$pages"){ $next = "<a href=\"?action=list&page=$pageplus\">Proxima $pp >></a>"; }
if($page - 1 < $pages AND $page){ $prev = "<a href=\"?action=list&page=$pagemin\"><< Anterior $pp</a>"; }
else{ $prev = "<font class=\"inactive\"><< Anterior $pp</font>"; }
if($pageplus > $pages){ $next = "<font class=\"inactive\">Proxima $pp >></font>"; }
?>
<?
$query = mysql_query("SELECT * FROM $table ORDER BY hitsday1 DESC LIMIT $a,$b") or die (mysql_error());
if(!isset($rank)){ $rank = 1 + $_GET["page"] * $pp; }
ob_start();$object->sitename = htmlspecialchars($object->sitename);
$object->url = htmlspecialchars($object->url);
$posup = mysql_query("UPDATE $table SET rank = '$rank' WHERE memberid = '$object->memberid'") or die(mysql_error());
$hitstotal = $object->hitsday1 + $object->hitsday2 + $object->hitsday3 + $object->hitsday4 + $object->hitsday5 + $object->hitsday6 + $object->hitsday7;
$days = explode(" | ",$object->date);
$average = round($hitstotal / $numdays);
$today = $object->hitstoday;
$hitstoday = $object->hitsday1;
?>
<?
if(($object->buttonurl AND $img_visible=="all" AND !$_GET["page"]) || ($object->buttonurl AND $rank <= $img_visible AND !$_GET["page"])){
?>
<?
}
$object->description = wordwrap($object->description, 75, "\n", 1);
$object->description = htmlspecialchars($object->description);
?></a></strong>
<!-- Inicio da Tabela 1 -->
<div class="table_border">
<table cellpadding="1" cellspacing="1" border="0" width="100%">
<tr>
<td class="table_top_title" colspan="4" width="100%">#<a href="out.php?id=<? echo $object->memberid ?>" target="_blank"><font color="#FFFFFF"><? echo $rank; ?></font></a> | <? echo $object->sitename ?> | <a href="<? echo $object->url ?>" target="_blank" onclick="out('<? echo $nome ?>');" class="table_top"><? echo $nome ?></a> - <a href="#" onclick="window.open('stats.php?id=<? echo $object->memberid ?>', null, 'height=260, width=550, toolbar=0, location=0, status=1, scrollbars=1'); return false"><font color="#FFFFFF"> Estadísticas </font></a></td>
</tr>
<tr>
<td rowspan="3" class="table_description" width="50%">
<center><a href="<? echo $object->url ?>" target="jogar"><img src="<? echo $object->banner ?>" font color="#FFFFFF"> </a></a><br /><? echo $object->descri ?><br />
<b>Categoría:</b> <? echo $object->tipo ?> | <strong>Votos</strong>: <? echo $object->votes ?> | <strong>Visitas</strong>: <? echo $object->visits ?>
</center></td>
</tr>
</table>
</div><?
$rank++;
}
ob_end_flush();
$a = $rank - 1;
$b = $pp * ($_GET["page"] + 1);
for($c = $b - $a; $c > 0; $c--){
?>
<font color="#FFFFFF">
<!-- Inicio da Tabela 2 -->
<div class="table_border">
<table cellpadding="1" cellspacing="1" border="0">
<tr>
<a onmouseover="tooltip.show('Todos os Sites Cadastrodos');" onmouseout="tooltip.hide();" > <td class="table_top_title" colspan="4" width="100%">#<a href="out.php?id=0" target="_blank"></a> | <a href="registrar.php"><font color="#FFFFFF">ADD SEU SITE AQUI</font></a> | <a href="#" target="_blank" onclick="out('#');" class="table_top"></a> - <a href="#" onclick="window.open('stats.php?id=0', null, 'height=260, width=550, toolbar=0, location=0, status=1, scrollbars=1'); return false"></a></td>
</tr>
<tr>
<td rowspan="3" class="table_description" width="50%">
<center><a href="registrar.php">ADD SEU SITE AQUI</a><BR>
</center></td></a>
</tr>
</table>
</div><?
}
?>
</table>
<p align="center"><?
echo "[ $prev ] -- [ $next ] <br>\n";
?></p>
</center>
<?
}
}
?>
<? include("footer.inc"); ?>Carregando comentários...