[PHP] Total Jobs Script

[Matt Clarke]

Hi, I coded this and just wanted to release it. Might not be as good as what other people might be able to come up with.

Basically, it give a number of how many people there are with the same job, it also have a simple server status thing. Heres the code:

<table width="302" border="0">
    <tr>
      <td>Server Status:</td>
      <td><?php
                $fp = @fsockopen("127.0.0.1", 15400, $errno, $errstr, 1);
if($fp >= 1){ 
echo '<font color="#00FF00">Online</font>';}
else{ echo '<font color="#CC0000">Offline</font>'; } 
            ?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><p>GM's Online:</p></td>
      <td><?php 
require('useron.php'); 
        echo '<font size="2" color="#00FF00">' . '3';  
?>
        </font></td>
    </tr>
    <tr>
      <td><p>Total Online:</p></td>
      <td><?php
ini_set('display_errors', 0); 
$connection = mssql_connect(' -PC\SQLEXPRESS', 'sa', ' Password Here'); //Change YOURHOST and YOURPASSWORD!

if(!connection || !mssql_select_db('ACCOUNT_DBF', $connection)) 
{
    die('Unable to connect or select database!');
}
$query = mssql_query("SELECT account FROM ACCOUNT_TBL_DETAIL WHERE isuse = 'J'");
$result = mssql_num_rows($query);
echo mssql_num_rows($query);
?></td>
    </tr>
    <tr>
      <td>Total Characters :</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());

$total_character_query = mssql_query("SELECT * FROM CHARACTER_TBL");

echo mssql_num_rows($total_character_query);

?></td>
    </tr>
    <tr>
      <td>Total Accounts :</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("ACCOUNT_DBF") or die (mssql_error());

$total_account_query = mssql_query("SELECT * FROM ACCOUNT_TBL");

echo mssql_num_rows($total_account_query);

?></td>
    </tr>
    <tr>
      <td><p>Current Lord :</p></td>
      <td><?php 
mssql_select_db ( "CHARACTER_01_DBF" ); 
$lord = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblLord a LEFT JOIN CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC" )); 
if ( $lord [ 'm_szName' ] != "" ) 
echo $lord ; 
else 
echo "-" ; 
?></td>
    </tr>
    <tr>
      <td><p>Current MVP :</p></td>
      <td><?php 
$mvp = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC" )); 
if ( $mvp [ 'm_szName' ] != "" ) 
echo $mvp [ m_szName ]; 
else 
echo "-" ; 
?></td>
    </tr>
    <tr>
      <td><p>Seige Winners :</p></td>
      <td><?php 
$crown = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szGuild FROM tblCombatJoinGuild JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC" )); 
if ( $crown [ 'm_szGuild' ] != "" ) 
echo $crown [ m_szGuild ]; 
else 
echo "-" ; 
?></td>
    </tr>
    <tr>
      <td></td>
      <td></td></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Total Vagrants</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$vagrant_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '0'");

echo mssql_num_rows($vagrant_query);

?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Total Mercenaries:</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$mercenaries_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '1'");

echo mssql_num_rows($mercenaries_query);

?></td>
    </tr>
    <tr>
      <td>Total Acrobats:</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$acrobats_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '2'");

echo mssql_num_rows($acrobats_query);

?></td>
    </tr>
    <tr>
      <td>Total Assists:</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$assist_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '3'");

echo mssql_num_rows($assist_query);

?></td>
    </tr>
    <tr>
      <td>Total Magicians:</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$magicians_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '4'");

echo mssql_num_rows($magicians_query);

?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Total Knights</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$knight_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '6'");

echo mssql_num_rows($knight_query);

?></td>
    </tr>
    <tr>
      <td>Total Blades</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$blade_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '7'");

echo mssql_num_rows($blade_query);

?></td>
    </tr>
    <tr>
      <td>Total Billposters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$billposter_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '11'");

echo mssql_num_rows($billposter_query);

?></td>
    </tr>
    <tr>
      <td>Total Ringmasters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$ringmasters_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '10'");

echo mssql_num_rows($ringmasters_query);

?></td>
    </tr>
    <tr>
      <td>Total Rangers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$ranger_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '9'");

echo mssql_num_rows($ranger_query);

?></td>
    </tr>
    <tr>
      <td>Total Jesters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$jester_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '8'");

echo mssql_num_rows($jester_query);

?></td>
    </tr>
    <tr>
      <td>Total Elementors</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$elementors_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '13'");

echo mssql_num_rows($elementors_query);

?></td>
    </tr>
    <tr>
      <td>Total Psykeepers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$psykeepers_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '12'");

echo mssql_num_rows($psykeepers_query);

?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Master Knights</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterknight_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '16'");

echo mssql_num_rows($masterknight_query);

?></td>
    </tr>
    <tr>
      <td>Master Blades</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterblade_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '17'");

echo mssql_num_rows($masterblade_query);

?></td>
    </tr>
    <tr>
      <td>Master Billposters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterbillposter_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '21'");

echo mssql_num_rows($masterbillposter_query);

?></td>
    </tr>
    <tr>
      <td>Master Ringmasters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterringmaster_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '20'");

echo mssql_num_rows($masterringmaster_query);

?></td>
    </tr>
    <tr>
      <td>Master Rangers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterranger_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '19'");

echo mssql_num_rows($masterranger_query);

?></td>
    </tr>
    <tr>
      <td>Master Jesters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterjester_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '18'");

echo mssql_num_rows($masterjester_query);

?></td>
    </tr>
    <tr>
      <td>Master Elementors</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterelementor_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '23'");

echo mssql_num_rows($masterelementor_query);

?></td>
    </tr>
    <tr>
      <td>Master Psykeepers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$masterpsykeeper_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '22'");

echo mssql_num_rows($masterpsykeeper_query);

?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Hero Knights</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heroknight_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '24'");

echo mssql_num_rows($heroknight_query);

?></td>
    </tr>
    <tr>
      <td>Hero Blades</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heroblade_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '25'");

echo mssql_num_rows($heroblade_query);

?></td>
    </tr>
    <tr>
      <td>Hero Billposters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$herobillposter_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '29'");

echo mssql_num_rows($herobillposter_query);

?></td>
    </tr>
    <tr>
      <td>Hero Ringmasters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heroringmaster_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '28'");

echo mssql_num_rows($heroringmaster_query);

?></td>
    </tr>
    <tr>
      <td>Hero Rangers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heroranger_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '27'");

echo mssql_num_rows($heroranger_query);

?></td>
    </tr>
    <tr>
      <td>Hero Jesters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$herojester_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '26'");

echo mssql_num_rows($herojester_query);

?></td>
    </tr>
    <tr>
      <td>Hero Elementors</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heroelementor_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '31'");

echo mssql_num_rows($heroelementor_query);

?></td>
    </tr>
    <tr>
      <td>Hero Psykeppers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$heropsykeeper_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '30'");

echo mssql_num_rows($heropsykeeper_query);

?></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Total Templars</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$templars_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '32'");

echo mssql_num_rows($templars_query);

?></td>
    </tr>
    <tr>
      <td>Total Slayers</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$slayers_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '33'");

echo mssql_num_rows($slayers_query);

?></td>
    </tr>
    <tr>
      <td>Total ForceMasters</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$forcemasters_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '37'");

echo mssql_num_rows($forcemasters_query);

?></td>
    </tr>
    <tr>
      <td>Total Seraphs</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$seraphs_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '36'");

echo mssql_num_rows($seraphs_query);

?></td>
    </tr>
    <tr>
      <td>Total Crackshooter</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$crackshooter_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '35'");

echo mssql_num_rows($crackshooter_query);

?></td>
    </tr>
    <tr>
      <td>Total Harlequins</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$harlequins_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '34'");

echo mssql_num_rows($harlequins_query);

?></td>
    </tr>
    <tr>
      <td>Total Arcanists</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$arcanists_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '39'");

echo mssql_num_rows($arcanists_query);

?></td>
    </tr>
    <tr>
      <td>Total Mentalists</td>
      <td><?php
mssql_connect(" -PC\SQLEXPRESS","sa"," Password Here") or die (mssql_error());
mssql_select_db("CHARACTER_01_DBF") or die (mssql_error());
$mentalists_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '38'");

echo mssql_num_rows($mentalists_query);

?></td>
    </tr>
  </table>

Credits to Max98 for this PHP Code:

<?php
// all php scriptes here x)

//DISABLE ERRORS*
ini_set('display_errors', 0); 

//----------------CONFIG---
$mssql1 = '-PC\SQLEXPRESS'; //host
$mssql2 = 'sa'; //DO NOT MOD
$mssql3 = ''; //pw
$ip12 = '127.0.0.1'; //your cache server's IP | NOT WORLDSERVER
$port12 = '15400'; // cache server's PORT/neuz port ...
//----------------CODE-----

$fp = @fsockopen($ip12, $port12, $errno, $errstr, 1); 
 

//*******MSSQL*****
$connection = mssql_connect($mssql1, $mssql2, $mssql3);  
if (!$connection)
die("Cannot connect to MSSQL Server."); // SERIOUS?
//******END********
//*************ACCOUNT DB****************
$dbA = @mssql_select_db('ACCOUNT_DBF'); 
if (!$dbA)
die("Cannot connect to MSSQL Server."); // SERIOUS?
$query1 = mssql_query("SELECT account FROM ACCOUNT_TBL_DETAIL WHERE isuse = 'J'"); 
$GMS = mssql_num_rows($query1); 
$query2 = mssql_query("SELECT * FROM [ACCOUNT_TBL_DETAIL] WHERE isuse = 'J' AND m_chLoginAuthority='F'"); 
$usersOnline =  mssql_num_rows($query2);
//******************CHAR DB*************
$dbC = @mssql_select_db('CHARACTER_01_DBF'); 
if (!$dbC)
die("Cannot connect to MSSQL Server."); // SERIOUS?
$total_character_query = mssql_query("SELECT * FROM CHARACTER_TBL"); 
$chars = mssql_num_rows($total_character_query); 
$total_account_query = mssql_query("SELECT * FROM ACCOUNT_TBL"); 
$acc = mssql_num_rows($total_account_query); 
$lord = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblLord a LEFT JOIN CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC" ));  
$mvp = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC" ));  
$crown = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szGuild FROM tblCombatJoinGuild JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC" ));  
$vagrant_query = mssql_query("SELECT * FROM CHARACTER_TBL WHERE m_nJob = '0'"); 
$vag = mssql_num_rows($vagrant_query); 


//************************************
//------------------------------------         
?>
<table width="302" border="0"> 
    <tr> 
      <td>Server Status:</td> 
      <td><?php 
if($fp >= 1){  
echo '<font color="#00FF00">Online</font>';} 
else{ echo '<font color="#CC0000">Offline</font>'; }  
 ?></td> 
    </tr> 
    <tr> 
      <td>&nbsp;</td> 
      <td>&nbsp;</td> 
    </tr> 
    <tr> 
      <td><p>GM's Online:</p></td> 
      <td>
<?php  
echo $GMS;
?> 
        </font></td> 
    </tr> 
    <tr> 
      <td><p>Total Online:</p></td> 
      <td><?php 
echo $usersOnline;
?></td> 
    </tr> 
    <tr> 
      <td>Total Characters :</td> 
      <td><?php 
echo $chars;
?></td> 
    </tr> 
    <tr> 
      <td>Total Accounts :</td> 
      <td><?php 
echo $acc;
?></td> 
    </tr> 
    <tr> 
      <td><p>Current Lord :</p></td> 
      <td><?php  
if ( $lord [ 'm_szName' ] != "" )  
echo $lord ;  
else  
echo "-" ;  
?></td> 
    </tr> 
    <tr> 
      <td><p>Current MVP :</p></td> 
      <td><?php  
if ( $mvp [ 'm_szName' ] != "" )  
echo $mvp [ m_szName ];  
else  
echo "-" ;  
?></td> 
    </tr> 
    <tr> 
      <td><p>Seige Winners :</p></td> 
      <td><?php  
if ( $crown [ 'm_szGuild' ] != "" )  
echo $crown [ m_szGuild ];  
else  
echo "-" ;  
?></td> 
    </tr> 
    <tr> 
      <td></td> 
      <td></td></td> 
    </tr> 
    <tr> 
      <td>&nbsp;</td> 
      <td>&nbsp;</td> 
    </tr> 
    <tr> 
      <td>Total Vagrants</td> 
      <td><?php 

echo $vag;

?></td> 
    </tr>

[MentaL]

[Langstra]

Matt I like you making such a script, but it is very inefficient. Using a persistent connection would be already be much better. You could write a query that counts all the amount of players that have a certain job, and do it all in one query.

[Adler]

We love you for being so lovely about this community Langstra.

[Matt Clarke]

Matt I like you making such a script, but it is very inefficient. Using a persistent connection would be already be much better. You could write a query that counts all the amount of players that have a certain job, and do it all in one query.

Not that advance yet xD, I know that you dont have to have the connection to the database on everything, but I made them all seperate and put them together so... IF you would want to clear it up and Id update the post with your credits? Up too you

[Langstra]

We love you for being so lovely about this community Langstra.

At least I do not try to insult everybody and accusing them of stealing/leechen/being stupid/not being with ur server/or w/e.
I just gave some contructive critism, sorry that I made you look stupid in that last post Sir, but I was being honest.

@Matt: I will see what I can do, I do not have so much time these days. I am learning for my tests I have to do in 2 weeks.

[Adler]

At least I do not try to insult everybody and accusing them of stealing/leechen/being stupid/not being with ur server/or w/e.
I just gave some contructive critism, sorry that I made you look stupid in that last post Sir, but I was being honest.

It's okay, you didn't make anybody look stupid.

[Hexadecimal]

As people have commented on my scripts before, using a wildcard, getting all data from the character_tbl, is a bad idea because it uses a lot of memory. A LOT. I suggest selecting the few columns you need.

C;

[Langstra]

It's okay, you didn't make anybody look stupid.

Okay, good to know.

As people have commented on my scripts before, using a wildcard, getting all data from the character_tbl, is a bad idea because it uses a lot of memory. A LOT. I suggest selecting the few columns you need.

C;

I mean that you can use sql functions like count() to get the amount of jobs. Then you only select the results you need. Then you do not have a lot of memory use and very efficient code.

[Hexadecimal]

Okay, good to know.

I mean that you can use sql functions like count() to get the amount of jobs. Then you only select the results you need. Then you do not have a lot of memory use and very efficient code.

mssql_num_rows.

@OP;
Why does there have to be so many mssql connections?

[arnootie]

wow, ty can be helpgull for lots os players

[Langstra]

mssql_num_rows.

I am not talking about that, that is a php function. I am talking about functions in the SQL statement.
"SELECT count(job) FROM table WHERE blah"
This way it is possible to select the total of characters per job in one query, this safes you a lot of memory.

[ShadowDragon]

when you do "mssql_connect" the last connection is dropped and a new one is created, which is entirely unnecessary after the first usage. you can create the connection immediately when someone gets to the website, then use it later as many times as needed without making a new connection.

Edit: I'm not one who really complains about credits, but I just looked through the coding and I think some of it was taken from someone else. There are 2 distinct 'coding styles' that I see.

This first one, is clearly Matt Clarke's style:

$query = mssql_query("SELECT account FROM ACCOUNT_TBL_DETAIL WHERE isuse = 'J'"); 
$result = mssql_num_rows($query); 
echo mssql_num_rows($query); 

But this second one, must be by someone who knows a lot more about what they're doing:

$mvp = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC" ));  
if ( $mvp [ 'm_szName' ] != "" )  
echo $mvp [ m_szName ];  
else  
echo "-" ; 

There are also a lot of errors in the coding. I didn't actually test it, but I saw a lot of missing quotes (most of which in the coding from that second person) and a php require that nobody will have. A page called 'useron.php'?

[Jomex]

This first one, is clearly Matt Clarke's style:

$query = mssql_query("SELECT account FROM ACCOUNT_TBL_DETAIL WHERE isuse = 'J'"); 
$result = mssql_num_rows($query); 
echo mssql_num_rows($query); 

$result = mssql_num_rows($query);
echo mssql_num_rows($query);
Wtf..If you don't use $result don't make it O_o... just an advice.

[Max98]

i think
add ALL the php code at the begining of the file
then use echo to fit in the html x)
this will let you use mssql_connect one time

[Matt Clarke]

It was made by me and I had a little help from my friend Eric. But it isnt stolen by anyone else Shadow. Also, I'm not that good at PHP yet, but I know that the connections dont have to be there on all the scripts, it only has to be there once.