• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Coder easy

Natan Beckman

Natan Beckman

Well-Known Member
Joined
Aug 1, 2010
Messages
548
Reaction score
54
Location
Teresina-PI/Br
PHP: 
<?PHP
$zapytanie = $SQL->query(`SELECT `vip_time` FROM `.$SQL->tableName(`accounts`).` WHERE `.$SQL->fieldName(`id`).` = `.$player[`account_id`].` LIMIT 1;`)->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
            if(is_int($kolor / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
                
                    if($zap['online'] == 0)
                        $player_list_status = '<font color="red"><b>Offline</b></font>';
                    else
                        $player_list_status = '<font color="green"><b>Online</b></font>';
                
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a href="?subtopic=characters&name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
                        
}
$main_content .= '<center><hr/><b>Jogadores Vip Do '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b></small></div><br />';

?>

PHP: 
Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\viplist.php on line 2
 
Sort by date Sort by votes
Maybe o.0


PHP: 
<?PHP
$SQL->query(`SELECT `vip_time` FROM `.$SQL->tableName(`accounts`).` WHERE `.$SQL->fieldName(`id`).` = `.$player[`account_id`].` LIMIT 1;`)->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
            if(is_int($kolor / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
                
                    if($zap['online'] == 0)
                        $player_list_status = '<font color="red"><b>Offline</b></font>';
                    else
                        $player_list_status = '<font color="green"><b>Online</b></font>';
                
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a href="?subtopic=characters&name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
                        
}
$main_content .= '<center><hr/><b>Jogadores Vip Do '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b></small></div><br />';

?>
 
Upvote 0 Downvote
PHP: 
<?PHP
$zapytanie = $SQL->query(`SELECT `vip_time` FROM `.$SQL->tableName(`accounts`).` WHERE `.$SQL->fieldName(`id`).` = `.$player[`account_id`].` LIMIT 1;`)->fetchall());
foreach($zapytanie as $zap) {
$kolor++;
            if(is_int($kolor / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
                
                    if($zap['online'] == 0)
                        $player_list_status = '<font color="red"><b>Offline</b></font>';
                    else
                        $player_list_status = '<font color="green"><b>Online</b></font>';
                
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a rel="nofollow" href="?subtopic=characters&amp;name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
                        
}
$main_content .= '<center><hr/><b>Jogadores Vip Do '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b></small></div><br />';

?>

This should be fine now.
 
Upvote 0 Downvote
PHP: 
<?PHP
$zapytanie = $SQL->query('SELECT vip_time FROM accounts WHERE id = '.$player['account_id'].' LIMIT 1')->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
    if(is_int($kolor / 2))
        $bgcolor = $config['site']['lightborder'];
    else
        $bgcolor = $config['site']['darkborder'];
    if($zap['online'] == 0)
        $player_list_status = '<font color="red"><b>Offline</b></font>';
    else
        $player_list_status = '<font color="green"><b>Online</b></font>';
        
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a href="?subtopic=characters&name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
                        
}
$main_content .= '<center><hr/><b>Jogadores Vip Do '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b></small></div><br />';

?>
 
Upvote 0 Downvote
No works.

tatu hunter solved.

PHP: 
<?PHP
$zapytanie = $SQL->query('SELECT p.name, p.online, p.level FROM players p JOIN accounts a ON a.id = p.account_id WHERE a.vip_time > 0;')->fetchall();
foreach($zapytanie as $zap) {
$kolor++;
            if(is_int($kolor / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
                
                    if($zap['online'] == 0)
                        $player_list_status = '<font color="red"><b>Offline</b></font>';
                    else
                        $player_list_status = '<font color="green"><b>Online</b></font>';
                
$tresc .= '<TR BGCOLOR='.$bgcolor.'><TD><center><a rel="nofollow" href="?subtopic=characters&amp;name='.urlencode($zap['name']).'">'.$zap['name'].'</a></TD><TD><center>'.$zap['level'].'</TD><TD><center>'.$player_list_status.'</center></TD></TR>';
                        
}
$main_content .= '<center><hr/><b>Jogadores Vip Do '.$config['server']['serverName'].'.</b><hr/><br><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white WIDTH=32%><b><center>Name</center></b></TD><TD class="white" WIDTH=32%><b><center>Level</center></b></TD><TD class="white" WIDTH=32%><b><center>Status</center></b></TD></TR>'.$tresc.'</TABLE>';

$main_content .= '<div align="right"><small><b></small></div><br />';

?>
 
Upvote 0 Downvote
Back
Top