07-15-2012, 07:36 PM
if one can help me if I log in and on player of rank goes this comes
<?php
session_start();
include_once( "Addons/TemplatePower.php" );
$tpl = new TemplatePower( "Template/player_ranks.tpl" );
$tpl->assignInclude( "menu", "Template/menu.tpl" );
$tpl->assignInclude( "header", "Template/header.tpl" );
$tpl->assignInclude( "blocks", "Template/blocks.tpl" );
$tpl->assignInclude( "footer", "Template/footer.tpl" );
$tpl->prepare();
include Site_Settings/Configuration.php;
include Addons/Classes.php;
include Addons/Globals.php;
include Addons/addons.php;
if( $User->LoggedIn == true )
{
$tpl->newBlock(player_ranks);
mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$Rank = 1;
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_full )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb0 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 0
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb1 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 1
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb2 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 2
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb3 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 3
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb4 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 4
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
if( isset( $_GET[Do] ) && $_GET[Do] == ranks_rb5 )
{
$query_1 =
SELECT a_name, a_level, a_max_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn
FROM t_characters
WHERE a_admin = 0 AND a_enable = 1 AND a_reborn = 5
ORDER BY a_level desc
LIMIT 100;
$result_1 = mysql_query ($query_1);
while($list_1 = mysql_fetch_array( $result_1 ))
{
$Info = new Info();
$Info->ClassJob( $list_1[a_job] , $list_1[a_job2] );
$ClassImage = Template/Img/ . $Info->Class . ".gif";
$tpl->newBlock(ranks_loop);
$tpl->Assign(Top100_rank , $Rank++ );
$tpl->Assign(Reborn , htmlspecialchars( $list_1[a_reborn] ) );
$tpl->Assign(Top100_NOGM_Names , htmlspecialchars( $list_1[a_name] ) );
$tpl->Assign(Top100_NOGM_Levels , htmlspecialchars( $list_1[a_level] ) );
$tpl->Assign(Top100_teach_complete , htmlspecialchars( $list_1[a_teach_complete] ) );
$tpl->Assign(Icon , $ClassImage);
}
}
}
else
{
$tpl->newBlock(error);
$tpl->Assign(msg , Please Login);
}
$tpl->printToScreen();
?>php