1.0.8 MuCore

[hcxd3333]

Where can I change the ranking of class codes???
For example:
In ranking is the page_id = Rankings & rank = characters & class = 2
I need that there should be class = 3

And :

<span style=" float:left;  padding-top:3px; font-family:Arial, Helvetica, sans-serif; 

font-size:12px;"><?=Total_Accounts;?>: <?

$statistics_accounts=mssql_query("SELECT count(*) memb___id FROM MuOnline.dbo.MEMB_INFO");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['accounts_reults']=$row['memb___id'];
?><strong><?=$core['accounts_reults'];?></strong><?

}
?> | <?=Total_Characters;?>: <?

$statistics_accounts=mssql_query("SELECT count(*) AccountID FROM MuOnline.dbo.Character");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['character_reults']=$row['AccountID'];
?><strong><?=$core['character_reults'];?></strong><?

}
?> | <?=Total_Guilds;?>: 

<?

$statistics_accounts=mssql_query("SELECT count(*) G_Name FROM MuOnline.dbo.Guild");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['guild_reults']=$row['G_Name'];
?><strong><?=$core['guild_reults'];?></strong><?

}
?>| <?=Online_Players;?>: <?

$statistics_players=mssql_query("SELECT count(*) ConnectStat FROM MuOnline.dbo.MEMB_STAT WHERE ConnectStat='1'");
while($row=mssql_fetch_assoc($statistics_players)){
$core['config']['statistics_results']=$row['ConnectStat'];
?><strong><?=$core['config']['statistics_results'];?></strong><?

}
?></span>

But when this code in place the Mucor do not represent the number of
What if I use SQL 2008 RC2 [if something wrong in the code]

[MentaL]

[hcxd3333]

Please help mee

[jacubb]

Hello.

Characters ID you can find in engine/custom_variables.php.

And I dont understand what problem you have with SQL Server 2008 R2... Try to explain more your problem.

[hcxd3333]

<span style=" float:left;  padding-top:3px; font-family:Arial, Helvetica, sans-serif; 

font-size:12px;"><?=Total_Accounts;?>: <?

$statistics_accounts=mssql_query("SELECT count(*) memb___id FROM MuOnline.dbo.MEMB_INFO");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['accounts_reults']=$row['memb___id'];
?><strong><?=$core['accounts_reults'];?></strong><?

}
?> | <?=Total_Characters;?>: <?

$statistics_accounts=mssql_query("SELECT count(*) AccountID FROM MuOnline.dbo.Character");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['character_reults']=$row['AccountID'];
?><strong><?=$core['character_reults'];?></strong><?

}
?> | <?=Total_Guilds;?>: 

<?

$statistics_accounts=mssql_query("SELECT count(*) G_Name FROM MuOnline.dbo.Guild");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['guild_reults']=$row['G_Name'];
?><strong><?=$core['guild_reults'];?></strong><?

}
?>| <?=Online_Players;?>: <?

$statistics_players=mssql_query("SELECT count(*) ConnectStat FROM MuOnline.dbo.MEMB_STAT WHERE ConnectStat='1'");
while($row=mssql_fetch_assoc($statistics_players)){
$core['config']['statistics_results']=$row['ConnectStat'];
?><strong><?=$core['config']['statistics_results'];?></strong><?

}
?></span>

This is my code, but dont show the have many acc, who online, and other
Screen :

[jacubb]

Use this:

$query            =    mssql_query("SELECT count(*) FROM MEMB_INFO");
$acc            =    mssql_result($query, 0, 0);
$query            =    mssql_query("SELECT count(*) FROM Character");
$chars            =    mssql_result($query, 0, 0);
$query            =    mssql_query("SELECT count(*) FROM Guild");
$guilds            =    mssql_result($query, 0, 0);
$query            =    mssql_query("SELECT count(*) FROM MEMB_STAT WHERE ConnectStat     =    '1'");     
$online            =    mssql_result($query, 0, 0); 

<TABLE cellSpacing="0" cellPadding="0" width="100%" border="0">
  <TBODY>
   <TR>
    <TD colSpan=2>Total Accounts</td>
    <TD width=100><?php echo $acc;?></td></tr>
  <TR>
    <TD colSpan=2>Total Characters</td>
    <TD width=100><?php echo $chars;?></td></tr>
  <TR>
    <TD colSpan=2>Total Guilds</td>
    <TD width=100><?php echo $guilds;?></td></tr>
  <TR>
    <TD colSpan=2>Online Players</td>
    <TD width=100><?php echo $online;?></td></tr>
  <TR>
  </TBODY>
<TABLE>

Just edit table and CSS as you want.