[PHP] Need to merge online vocs count, tfs0.3.5pl1

[hodleo]

Could someone merge these codes so my gesior shows me only 4 vocs instead of the eight ones, so the promo voc and the normal one counts together. rep++
This code was extracted from gesior 0.3.4beta4

//Ile kto online

$connect = new mysqli ("".$config['server']['mysqlHost']."","".$config['server']['sqlUser']."","".$config['server']['sqlPass']."","".$config['server']['sqlDatabase']."");

$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=25% CLASS=white><B>Vocacion</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>Druids</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>MS</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>ED</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>RP</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>EK</B></td><td>'.$sork7[0].'</td></tr>';

 

[XMarkoX]

//Ile kto online

$connect = new mysqli ("".$config['server']['mysqlHost']."","".$config['server']['sqlUser']."","".$config['server']['sqlPass']."","".$config['server']['sqlDatabase']."");

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

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

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

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



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

Should work

 

[hodleo]

Should work

<_<ah? what's the difference? you just deleted some lines -.-

ofc it didn't work, -rep for u