• 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!

PLEASE HELP!! Website problem.

Sort by date Sort by votes
I want it so that under vocations it says what vocation the char is, instead of being blank

who is online.php

<?PHP
$order = $_REQUEST['order'];
if($order == 'level')
$orderby = 'level';
elseif($order == 'vocation')
$orderby = 'vocation';
if(empty($orderby))
$orderby = 'name';

//How much online



$sor = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 1 AND `promotion` = 0 AND `online` = 1");
$sork = $sor->fetch_array();

$sor1 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 2 AND `promotion` = 0 AND `online` = 1");
$sork1 = $sor1->fetch_array();

$sor2 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 3 AND `promotion` = 0 AND `online` = 1");
$sork2 = $sor2->fetch_array();

$sor3 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 4 AND `promotion` = 0 AND `online` = 1");
$sork3 = $sor3->fetch_array();

$sor4 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 1 AND `promotion` = 1 AND `online` = 1");
$sork4 = $sor4->fetch_array();

$sor5 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 2 AND `promotion` = 1 AND `online` = 1");
$sork5 = $sor5->fetch_array();

$sor6 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 3 AND `promotion` = 1 AND `online` = 1");
$sork6 = $sor6->fetch_array();

$sor7 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 4 AND `promotion` = 1 AND `online` = 1");
$sork7 = $sor7->fetch_array();


$sor->close();
$sor1->close();
$sor2->close();
$sor3->close();
$sor4->close();
$sor5->close();
$sor6->close();
$sor7->close();

$main_content.= '<TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=80%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD WIDTH=10% CLASS=white><B>Vocation</B></TD><TD WIDTH=75% CLASS=white><B>Online</B></TD>';
$main_content .= '</TR>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Sorcerer</B></td><td>'.$sork[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Druid</B></td><td>'.$sork1[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Paladin</B></td><td>'.$sork2[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Knight</B></td><td>'.$sork3[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Master Sorcerer</B></td><td>'.$sork4[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Elder Druid</B></td><td>'.$sork5[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Royal Paladin</B></td><td>'.$sork6[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Elite Knight</B></td><td>'.$sork7[0].'</td></tr>';

$main_content .= '</table><br><br>';

$players_online_data = $SQL->query('SELECT * FROM players WHERE online = 1 ORDER BY '.$orderby.'');
$number_of_players_online = 0;
foreach($players_online_data as $player) {
$acc = $SQL->query('SELECT * FROM '.$SQL->tableName('accounts').' WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].'')->fetch();
$number_of_players_online++;
if(is_int($number_of_players_online / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];
$players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=5%><center><image src="flags/'.$acc['flag'].'.gif"></center></TD><TD WIDTH=70%><A HREF="index.php?subtopic=characters&name='.$player['name'].'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$world_id][$player['promotion']][$player['vocation']].'</TD></TR>';
}
if($number_of_players_online == 0)
//server status - server empty
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently no one is playing on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
else
{
//server status - someone is online
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently '.$number_of_players_online.' players are online.</TD></TR></TABLE></TD></TR></TABLE><BR>';
//list of players
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD><center><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>#</A></center></TD><TD><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>Name</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=level" CLASS=white>Level</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=vocation" CLASS=white>Vocation</TD></TR>'.$players_rows.'</TABLE>';
//search bar
$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post> <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';
}

?>
 
Last edited:
Upvote 0 Downvote
damn,.... put it in "
PHP: 
" tags...

[COLOR="Red"]DELETE IT $connect = new mysqli ("localhost","root","x","x");
[/COLOR]


Try It:

[php]
<?PHP
$order = $_REQUEST['order'];
if($order == 'level')
$orderby = 'level';
elseif($order == 'vocation')
$orderby = 'vocation';
if(empty($orderby))
$orderby = 'name';

//How much online

$connect = new mysqli ("localhost","root","PASS","DB");

$sor = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 1 AND `promotion` = 0 AND `online` = 1");
$sork = $sor->fetch_array();

$sor1 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 2 AND `promotion` = 0 AND `online` = 1");
$sork1 = $sor1->fetch_array();

$sor2 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 3 AND `promotion` = 0 AND `online` = 1");
$sork2 = $sor2->fetch_array();

$sor3 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 4 AND `promotion` = 0 AND `online` = 1");
$sork3 = $sor3->fetch_array();

$sor4 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 1 AND `promotion` = 1 AND `online` = 1");
$sork4 = $sor4->fetch_array();

$sor5 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 2 AND `promotion` = 1 AND `online` = 1");
$sork5 = $sor5->fetch_array();

$sor6 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 3 AND `promotion` = 1 AND `online` = 1");
$sork6 = $sor6->fetch_array();

$sor7 = $connect->query("SELECT COUNT(*) FROM `players` WHERE `vocation` = 4 AND `promotion` = 1 AND `online` = 1");
$sork7 = $sor7->fetch_array();


$sor->close();
$sor1->close();
$sor2->close();
$sor3->close();
$sor4->close();
$sor5->close();
$sor6->close();
$sor7->close();

$main_content.= '<TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=80%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD WIDTH=10% CLASS=white><B>Vocation</B></TD><TD WIDTH=75% CLASS=white><B>Online</B></TD>';
$main_content .= '</TR>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Sorcerer</B></td><td>'.$sork[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Druid</B></td><td>'.$sork1[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Paladin</B></td><td>'.$sork2[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Knight</B></td><td>'.$sork3[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Master Sorcerer</B></td><td>'.$sork4[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Elder Druid</B></td><td>'.$sork5[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Royal Paladin</B></td><td>'.$sork6[0].'</td></tr>';
if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++; $number_of_rows1++;
$main_content .= '<tr bgcolor="'.$bgcolor.'"><td><B>Elite Knight</B></td><td>'.$sork7[0].'</td></tr>';

$main_content .= '</table><br><br>';

$players_online_data = $SQL->query('SELECT * FROM players WHERE online = 1 ORDER BY '.$orderby.'');
$number_of_players_online = 0;
foreach($players_online_data as $player) {
$acc = $SQL->query('SELECT * FROM '.$SQL->tableName('accounts').' WHERE '.$SQL->fieldName('id').' = '.$player['account_id'].'')->fetch();
$number_of_players_online++;
if(is_int($number_of_players_online / 2))
$bgcolor = $config['site']['darkborder'];
else
$bgcolor = $config['site']['lightborder'];
$players_rows .= '<TR BGCOLOR='.$bgcolor.'><TD WIDTH=5%><center><image src="flags/'.$acc['flag'].'.gif"></center></TD><TD WIDTH=70%><A HREF="index.php?subtopic=characters&name='.$player['name'].'">'.$player['name'].'</A></TD><TD WIDTH=10%>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$player['$world_id']][$player['promotion']][$player['vocation']].'</TD></TR>';
}
if($number_of_players_online == 0)
//server status - server empty
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently no one is playing on '.$config['server']['serverName'].'.</TD></TR></TABLE></TD></TR></TABLE><BR>';
else
{
//server status - someone is online
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><B>Server Status</B></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1><TR><TD>Currently '.$number_of_players_online.' players are online.</TD></TR></TABLE></TD></TR></TABLE><BR>';
//list of players
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD><center><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>#</A></center></TD><TD><A HREF="index.php?subtopic=whoisonline&order=name" CLASS=white>Name</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=level" CLASS=white>Level</A></TD><TD><A HREF="index.php?subtopic=whoisonline&order=vocatio n" CLASS=white>Vocation</TD></TR>'.$players_rows.'</TABLE>';
//search bar
$main_content .= '<BR><FORM ACTION="index.php?subtopic=characters" METHOD=post> <TABLE WIDTH=100% BORDER=0 CELLSPACING=1 CELLPADDING=4><TR><TD BGCOLOR="'.$config['site']['vdarkborder'].'" CLASS=white><B>Search Character</B></TD></TR><TR><TD BGCOLOR="'.$config['site']['darkborder'].'"><TABLE BORDER=0 CELLPADDING=1><TR><TD>Name:</TD><TD><INPUT NAME="name" VALUE=""SIZE=29 MAXLENGTH=29></TD><TD><INPUT TYPE=image NAME="Submit" SRC="'.$layout_name.'/images/buttons/sbutton_submit.gif" BORDER=0 WIDTH=120 HEIGHT=18></TD></TR></TABLE></TD></TR></TABLE></FORM>';
}

?>
 
Last edited:
Upvote 0 Downvote

Similar threads

Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
357
Jpstafe
Jpstafe
conman
  • Question
Canary RL 13.21 - Loyalty System (and other) questions - newbie needs experienced users' help
Replies
6
Views
365
conman
conman
J
  • Question
Npc Problem Help Please
Replies
2
Views
371
Mateus Robeerto
Mateus Robeerto
Back
Top