re: [Development] Custom MU Core Template
Quote:
Originally Posted by
FCV2005
i have here some scripts if u want for mucore , if u want more i will post here !
that i use in my own templates ....
Accounts
PHP Code:
<?
$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'];
?>
<?=$core['accounts_reults'];?>
<?
}
?>
Characters
PHP Code:
<?
$statistics_accounts=mssql_query("SELECT count(*) AccountID FROM MuOnline.dbo.Character");
while($row=mssql_fetch_assoc($statistics_accounts)){
$core['character_reults']=$row['AccountID'];
?>
<?=$core['character_reults'];?>
<?
}
?>
Guilds
PHP Code:
<?
$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'];
?>
<?=$core['guild_reults'];?>
<?
}
?>
Online Characters
PHP Code:
<?
$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'];
?>
<?=$core['config']['statistics_results'];?>
<?
}
?>
Top 10 Characters
PHP Code:
<?
include("config.php");
$cnn=@mssql_connect($core['db_host'],$core['db_user'],$core['db_password']) or die('Error al conectar al sql');
$db=@mssql_select_db($core['db_name'],$cnn) or die('Error al conectar la database');
$query=mssql_query("select TOP 10 * from MuOnline.dbo.Character Where ctlcode !='32' and ctlcode !='8' order by Resets desc, cLevel desc");
while($row=mssql_fetch_assoc($query)){
$namez=$row['Name'];
$rst[37]=$row['Resets'];
$resetsz=$row['Resets'];
?>
<?=++$count2;?>
<?=$namez;?>
<?=$rst[37];?>
<?
}
?>
Guilds
PHP Code:
<?
include("config.php");
$cnn=@mssql_connect($core['db_host'],$core['db_user'],$core['db_password']) or die('Error al conectar al sql');
$db=@mssql_select_db($core['db_name'],$cnn) or die('Error al conectar la database');
$Guild=mssql_query("select TOP 10 * from MuOnline.dbo.guild order by G_Score desc");
while($row=mssql_fetch_assoc($Guild)){
$G_Namez=$row['G_Name'];
$G_Markz=$row['G_Mark'];
$G_Scorez=$row['G_Score'];
$Resetsz=$row['Resets'];
$logo=urlencode(bin2hex($G_Markz));
?>
<?=++$count1;?>
<?=$G_Namez;?>
<?=$G_Scorez;?><img src="get.php?aL=<?=$logo;?>.png" alt="" width="15" height="15">
<?
}
?>
Title Page
PHP Code:
<?if(isset($page_title)){ echo ''.$page_title .'';}else{ echo '';}?>
Server Time
PHP Code:
<?php echo date(" H:i:s"); ?> <?php echo date("d,M Y"); ?>
nothing works, only server time
the difference that i see its the "echo" thing..maybe thats why its not working?
PS : i add them on index.php in template
