-
1.0.8 MuCore
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 :
Code:
<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]
-
Re: [Help] 1.0.8 MuCore
-
Re: [Help] 1.0.8 MuCore
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.
-
Re: [Help] 1.0.8 MuCore
Code:
<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 :
http://www.bildites.lv/images/qc61vbpppz3cv044yzga.png
-
Re: [Help] 1.0.8 MuCore
Use this:
PHP Code:
$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);
PHP Code:
<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.
