Follow along with the video below to see how to install our site as a web app on your home screen.
Бележка: This feature may not be available in some browsers.
if(strlen($info) == NULL)
{
//
}
else{
//
}
Styl3rbg каза:http://shoot-bg.info/servers.php
Нещо не се получава?
Това е в графата Инфо ?PHP:if(empty($info)) { echo '<a href="index.php">-</a>'; } else { echo '<a href="'.$info.'">Инфо</a>'; }
Styl3rbg каза:Взимам я от таблицата с сървъри
поле info
![]()
![]()
Styl3rbg каза:http://prikachi.com/images/372/3239372L.png Тази??
Тедо ето целия код ,че малко май някой не разбрахаtedo96 каза:SELECT * FROM `table` WHERE `info` = NULL
Някаква такава заявка. После правиш проверка с mysql_num_rows.
<?php
$category = addslashes(htmlspecialchars($_GET['cat']));
$time = time();
if($category) {
$sql = "SELECT * FROM `$table` WHERE expired>$time AND server_type='$category' ORDER BY `id` DESC";
}
else {
$sql = "SELECT * FROM `$table` WHERE expired>$time ORDER BY `id` DESC";
}
$result = mysql_query($sql) or die(mysql_error());
if(mysql_num_rows($result) == 0) {
echo "<center><b>Все още няма добавени сървъри!</b></center>";
}
else {
while($row = mysql_fetch_assoc($result)) {
//------------------------------------------------------------------------------------------------------------+
// THIS CONTROLS HOW THE PLAYER FIELDS ARE DISPLAYED
$fields_show = array("name", "score", "kills", "deaths", "team", "ping", "bot", "time"); // ORDERED FIRST
$fields_hide = array("teamindex", "pid", "pbguid"); // REMOVED
$fields_other = TRUE; // FALSE TO ONLY SHOW FIELDS IN $fields_show
//------------------------------------------------------------------------------------------------------------+
// GET THE SERVER DETAILS AND PREPARE IT FOR DISPLAY
$server = lgsl_query_cached("", "", "", "", "", "sep", $row[id]);
$fields = lgsl_sort_fields($server, $fields_show, $fields_hide, $fields_other);
$server = lgsl_sort_players($server);
$server = lgsl_sort_extras($server);
$misc = lgsl_server_misc($server);
$server = lgsl_server_html($server);
//------------------------------------------------------------------------------------------------------------+
echo "
<tr bgcolor='#FFFFFF'>
<td><span style='color: "; if($misc[text_status] == "ONLINE") { echo "green"; } else { echo "red"; } echo "; font-weight: bold;'>".htmlspecialchars(addslashes($server['s']['name']))."</span><br /><span style='font-size: 11px;'>{$server['b']['ip']}:{$server['b']['c_port']}</span></td>
<td style='text-align: center;'><a href='./servers.php?cat=$row[server_type]'>$row[server_type]</a></td>
<td style='text-align: center;'>";
if(empty($info)) {
echo '<a href="index.php">-</a>';
} else {
echo '<a href="'.$info.'">Инфо</a>';
}
echo"</td>
<td style='text-align: center;'><span style='color: "; if($misc[text_status] == "ONLINE") { echo "green"; } else { echo "red"; } echo "; font-weight: bold;'> "; if($misc[text_status] == "ONLINE") { echo "{$server['s']['players']} / {$server['s']['playersmax']}"; } else { echo "0 / 0"; } echo "</span></td>
</tr>
";
}
}
?>