+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Programmers Gateway (https://lckb.dev/forum/forumdisplay.php?fid=196)
+---- Forum: Coders Talk (https://lckb.dev/forum/forumdisplay.php?fid=192)
+---- Thread: To custom helps for my website (/showthread.php?tid=964)
- andre922007 - 07-15-2012
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
- someone - 07-15-2012
3)Include Enough information in what your trying to do(Explaining too little will take too long to solve your problem).
4)Dont dump your problem and let us fix it for you, this section is to help you figure it out, a solution to your problem.
Source:
2
If this is max website, I dont think you will receive any help from anybody except max.
- roseon - 07-16-2012
lol
- andre922007 - 07-17-2012
Can you please help me a really important is the best in German would be really great of you to thank
- andre922007 - 07-17-2012
lol
Kannste me say his name here would be really nice
- andre922007 - 07-17-2012
hier der php code kann mir einer sagen wo der fehler jetzt ist
<?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() );
//@@@@@@@@@@@@@@@@@@@@@@@@@@@
// Top 100 NO-GM Players Ranks
//@@@@@@@@@@@@@@@@@@@@@@@@@@@
$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
FROM t_characters
WHERE a_admin = 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_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);
$tpl->Assign(maxhp , htmlspecialchars( $list_1[a_max_hp] ) );
$tpl->Assign(str , htmlspecialchars( $list_1[a_str] ) );
$tpl->Assign(dex , htmlspecialchars( $list_1[a_dex] ) );
$tpl->Assign(int , htmlspecialchars( $list_1[a_int] ) );
$tpl->Assign(con , htmlspecialchars( $list_1[a_con] ) );
}
}
else
{
$tpl->newBlock(error);
$tpl->Assign(msg , Please Login);
}
$tpl->printToScreen();
?>
2