Kaellum

Membros

Perfil Explorar Conteúdo

Total de itens
1
Registro em
Agosto 30, 2008
Última visita
Setembro 2, 2008

Tipo de Conteúdo

Todas Atividades

Perfis

Fóruns

Tudo que Kaellum postou

Stat.php Ajuda.

uma questão postou Kaellum PHP

Olá queridos amigos. Bom sou novato venho aqui buscar ajuda de vocês, Bom o que preciso fazer é uma espécie de Rank, para colocar junto ao site fazer uma pagina em html e incluir . o rank e para um servidor de Lineage II, o servidor e hospedado em um datacenter, tem um ip fixo é Usa Apache e Navicat. um amigo me passou este arquivo. gostaria de saber se tem como fazer a ligação com o banco de dados para exibir as informações do TOp. Através de uma pagina em html. o arquivo e o seguinte. if($config['config_display_statistik'] == "yes") { if(isset($GLOBALS['arr']))$arr = $GLOBALS['arr']; if(isset($GLOBALS['l']))$l = $GLOBALS['l']; function array_key_multi_sort_down(&$arr, $l) { return usort($arr, create_function('$a, $b', "return strnatcasecmp(\$a['$l'], \$b['$l']);")); } function array_key_multi_sort_up(&$arr, $l) { return usort($arr, create_function('$a, $b', "return strnatcasecmp(\$b['$l'], \$a['$l']);")); } if(($step == "top") && ($config['config_display_statistik_top100'] == "yes")) { $get_char_data="SELECT obj_id,char_name,level,exp,karma,pvpkills,pkkills,clanid,race,classid,accesslevel,online FROM characters WHERE accesslevel>=0"; $char_data=MYSQL_QUERY($get_char_data); while(list($obj_id,$char_name,$level,$exp,$karma,$pvpkills,$pkkills,$clanid,$race,$classid,$accesslevel,$online)=mysql_fetch_row($char_data)) { $get_config_data="SELECT clan_id,clan_name,clan_level FROM clan_data WHERE clan_id=".$clanid." LIMIT 1"; $config_data=MYSQL_QUERY($get_config_data); list($clan['id'],$clanid,$clanlevel)=mysql_fetch_row($config_data); if($race == 0)$race="Human"; elseif($race == 1)$race="Elf"; elseif($race == 2)$race="Dark-Elf"; elseif($race == 3)$race="Orc"; elseif($race == 4)$race="Dwarf"; $get_config_data="SELECT class_name FROM class_list WHERE id=".$classid." LIMIT 1"; $config_data=MYSQL_QUERY($get_config_data); list($classid)=mysql_fetch_row($config_data); $classid= ereg_replace("H_", "", $classid); $classid= ereg_replace("E_", "", $classid); $classid= ereg_replace("DE_", "", $classid); $classid= ereg_replace("O_", "", $classid); $classid= ereg_replace("D_", "", $classid); if($accesslevel < 100)$accesslevel="Player"; elseif($accesslevel >= 100)$accesslevel="Game Master"; if($online == 0)$online="No"; elseif($online > 0)$online="Yes"; $get_config_data="SELECT count FROM items WHERE item_id=57 AND owner_id=".$obj_id.""; $config_data=MYSQL_QUERY($get_config_data); $adena=0; while(list($count)=mysql_fetch_row($config_data)) { $adena=$adena+$count; } $get_config_data="SELECT clan_id FROM clan_data WHERE leader_id='".$obj_id."' LIMIT 1"; $config_data=MYSQL_QUERY($get_config_data); list($clan_id)=mysql_fetch_row($config_data); if($clan_id != 0){$clan_id="yes";}else{$clan_id="no";} $data[]=array( "obj_id" => $obj_id, "name" => $char_name, "level" => $level, "exp" => $exp, "karma" => $karma, "pvpkills" => $pvpkills, "pkkills" => $pkkills, "clanidb" => $clan['id'], "clan" => $clanid, "clanlvl" => $clanlevel, "race" => $race, "class" => $classid, "accesslevel" => $accesslevel, "adena" => $adena, "online" => $online, "clanid" => $clan_id ); } if(count($data) != 0) { if(!isset($order))$order="exp"; if(($order=="exp") OR ($order=="karma") OR ($order=="pvpkills") OR ($order=="pkkills") OR ($order=="clanlvl") OR ($order=="adena"))array_key_multi_sort_up($data, $order); if(($order=="online"))array_key_multi_sort_down($data, $order); } ?> Top 100: (order by: <? echo $order; ?>) <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles">Pos.</td> <td class="sTable-titles">Name</td> <td class="sTable-titles"><a class="sTable-titles" href="?page=stat.php&step=top&order=exp">Level & -[Exp]</a></td> <td class="sTable-titles" align="center"><a class="sTable-titles" href="?page=stat.php&step=top&order=karma">Karma</a></td> <td class="sTable-titles" align="center"><a class="sTable-titles" href="?page=stat.php&step=top&order=pvpkills">PvP-Kills</a></td> <td class="sTable-titles" align="center"><a class="sTable-titles" href="?page=stat.php&step=top&order=pkkills">PK-Kills</a></td> <td class="sTable-titles"><a class="sTable-titles" href="?page=stat.php&step=top&order=clanlvl">Clan & -[Level]</a></td> <td class="sTable-titles">Race</td> <td class="sTable-titles">Class</td> <td class="sTable-titles">Accesslevel</td> <td class="sTable-titles" align="right"><a class="sTable-titles" href="?page=stat.php&step=top&order=adena">Adena</a></td> <td class="sTable-titles" align="center">Online</td> </tr> <? if(count($data) != 0) { if($order=="clanlvl") { foreach($data as $value) { if($value['clanid'] == "yes") { $data_sortet[]=array( "obj_id" => $value['obj_id'], "name" => $value['name'], "level" => $value['level'], "exp" => $value['exp'], "karma" => $value['karma'], "pvpkills" => $value['pvpkills'], "pkkills" => $value['pkkills'], "clanidb" => $value['clanidb'], "clan" => $value['clan'], "clanlvl" => $value['clanlvl'], "race" => $value['race'], "class" => $value['class'], "accesslevel" => $value['accesslevel'], "adena" => $value['adena'], "online" => $value['online'], "clanid" => $value['clanid'] ); } } $data=$data_sortet; array_key_multi_sort_up($data, $order); } $count=0; foreach($data as $value) { ?> <tr> <td class="widelist-txt"><? echo $count+1; ?></td> <td class="widelist-txt"><a href="?page=stat.php&step=player&searchid=<? echo $value['obj_id']; ?>"><? echo $value['name']; ?></td> <td class="widelist-txt"><? echo $value['level']; ?>-[<? echo $value['exp']; ?>]</td> <td class="widelist-txt" align="center"><? echo $value['karma']; ?></td> <td class="widelist-txt" align="center"><? echo $value['pvpkills']; ?></td> <td class="widelist-txt" align="center"><? echo $value['pkkills']; ?></td> <td class="widelist-txt"><a href="?page=stat.php&step=clan&searchid=<? echo $value['clanidb']; ?>"><? if($value['clan'] != "") echo $value['clan']."-[".$value['clanlvl']."]"; ?></a></td> <td class="widelist-txt"><? echo $value['race']; ?></td> <td class="widelist-txt"><? echo $value['class']; ?></td> <td class="widelist-txt"><? echo $value['accesslevel']; ?></td> <td class="widelist-txt" align="right"><? echo $value['adena']; ?></td> <td class="widelist-txt" align="center"><? echo $value['online']; ?></td> </tr> <? $count++; if($count == 100)break; } }else{ ?> <tr> <td class="widelist-txt" align="center" colspan="11">No characters are createt!</td> </tr> <? } ?> </table> <? } if(($step == "player") && ($config['config_display_statistik_player'] == "yes")) { if(isset($searchid)) { $get_char_data="SELECT char_name FROM characters WHERE obj_id='".$searchid."' LIMIT 1"; $char_data=MYSQL_QUERY($get_char_data); list($search)=mysql_fetch_row($char_data); } if(!isset($search))$search=""; $search=ltrim($search); $search=rtrim($search); ?> <form action="<? echo $PHP_SELF; ?>" method="get"> Search Player: (use '%' for a joker like "%arname" or "charna%" and "%arna%") <input type="hidden" name="page" value="stat.php"> <input type="hidden" name="step" value="player"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" colspan="2">Name</td> </tr> <tr> <td class="widelist-txt"><input type="text" name="search" value="<? echo $search; ?>" size="100"></td> <td class="widelist-txt" align="right"><input type="submit" value="Start search..."></td> </tr> </table> </form> <? if($search != "") { $get_char_data="SELECT obj_id,char_name,level,sex,exp,karma,pvpkills,pkkills,clanid,race,classid,title,accesslevel,online,lastaccess FROM characters WHERE char_name LIKE '".$search."' ORDER BY char_name"; $char_data=MYSQL_QUERY($get_char_data); $num=mysql_num_rows($char_data); if($num == 0) { ?> Player list: <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles">Info</td> </tr> <tr> <td class="widelist-txt" align="center">No Player with "<? echo $search; ?>" found!</td> </tr> </table> <? } elseif($num > 0) { ?> Player list: <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" width="50%" colspan="3">Name</td> <td class="sTable-titles" width="50%" align="right">Online</td> </tr> <? while(list($obj_id,$char_name,$level,$sex,$exp,$karma,$pvpkills,$pkkills,$clanid,$race,$classid,$title,$accesslevel,$online,$lastaccess)=mysql_fetch_row($char_data)) { ?> <tr> <td class="widelist-txt" colspan="3"><a href="?page=stat.php&step=player&searchid=<? echo $obj_id; ?>"><? echo $char_name; ?></a></td> <td class="widelist-txt" align="right"><? if($online == 0){echo "No";}else{echo "Yes";} ?></td> </tr> <? if($num == 1) { if($accesslevel < 100)$accesslevel="Player"; elseif($accesslevel >= 100)$accesslevel="Game Master"; $get_config_data="SELECT count FROM items WHERE item_id=57 AND owner_id=".$obj_id.""; $config_data=MYSQL_QUERY($get_config_data); $adena=0; while(list($count)=mysql_fetch_row($config_data)) { $adena=$adena+$count; } if($race == 0)$race="Human"; elseif($race == 1)$race="Elf"; elseif($race == 2)$race="Dark-Elf"; elseif($race == 3)$race="Orc"; elseif($race == 4)$race="Dwarf"; $get_config_data="SELECT class_name FROM class_list WHERE id=".$classid." LIMIT 1"; $config_data=MYSQL_QUERY($get_config_data); list($classid)=mysql_fetch_row($config_data); $classid= ereg_replace("H_", "", $classid); $classid= ereg_replace("E_", "", $classid); $classid= ereg_replace("DE_", "", $classid); $classid= ereg_replace("O_", "", $classid); $classid= ereg_replace("D_", "", $classid); $get_config_data="SELECT clan_id,clan_name,clan_level FROM clan_data WHERE clan_id=".$clanid." LIMIT 1"; $config_data=MYSQL_QUERY($get_config_data); list($clanidb,$clanid,$clanlevel)=mysql_fetch_row($config_data); if($online == 0)$online="No"; elseif($online > 0)$online="Yes"; if($sex == 0)$sex="Male"; elseif($sex == 1)$sex="Female"; ?> </table> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" colspan="4">Details</td> </tr> <tr> <td class="sTable-titles" width="15%">Name:</td> <td class="widelist-txt" width="35%"><? echo $char_name; ?></td> <td class="sTable-titles" width="15%">Accesslevel:</td> <td class="widelist-txt" width="35%"><? echo $accesslevel; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Title:</td> <td class="widelist-txt" width="35%"><? echo $title; ?></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" width="15%">Adena:</td> <td class="widelist-txt" width="35%"><? echo $adena; ?></td> <td class="sTable-titles" width="15%">Race:</td> <td class="widelist-txt" width="35%"><? echo $race; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Karma:</td> <td class="widelist-txt" width="35%"><? echo $karma; ?></td> <td class="sTable-titles" width="15%">Sex:</td> <td class="widelist-txt" width="35%"><? echo $sex; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Level:</td> <td class="widelist-txt" width="35%"><? echo $level; ?></td> <td class="sTable-titles" width="15%">Class:</td> <td class="widelist-txt" width="35%"><? echo $classid; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Exp:</td> <td class="widelist-txt" width="35%"><? echo $exp; ?></td> <td class="sTable-titles" width="15%">PvP-Kills:</td> <td class="widelist-txt" width="35%"><? echo $pvpkills; ?></td> </tr> <tr> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> <td class="sTable-titles" width="15%">PK-Kills:</td> <td class="widelist-txt" width="35%"><? echo $pkkills; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Clan:</td> <td class="widelist-txt" width="35%"><a href="?page=stat.php&step=clan&searchid=<? echo $clanidb; ?>"><? echo $clanid; ?></a></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" width="15%">Clan-level:</td> <td class="widelist-txt" width="35%"><? echo $clanlevel; ?></td> <td class="sTable-titles" width="15%">Online:</td> <td class="widelist-txt" width="35%"><? echo $online; ?></td> </tr> <? } } ?> </table> <? } } } if(($step == "clan") && ($config['config_display_statistik_clan'] == "yes")) { if(isset($searchid)) { $get_clan_data="SELECT clan_name FROM clan_data WHERE clan_id='".$searchid."' LIMIT 1"; $clan_data=MYSQL_QUERY($get_clan_data); list($search)=mysql_fetch_row($clan_data); } if(!isset($search))$search=""; $search=ltrim($search); $search=rtrim($search); ?> <form action="<? echo $PHP_SELF; ?>" method="get"> Search Clan: (use '%' for a joker like "%anname" or "clanna%" and "%lanna%") <input type="hidden" name="page" value="stat.php"> <input type="hidden" name="step" value="clan"> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" colspan="2">Clan-Name</td> </tr> <tr> <td class="widelist-txt"><input type="text" name="search" value="<? echo $search; ?>" size="100"></td> <td class="widelist-txt" align="right"><input type="submit" value="Start search..."></td> </tr> </table> </form> <? if($search != "") { $get_clan_data="SELECT clan_id,clan_name,clan_level,hasCastle,ally_id,leader_id FROM clan_data WHERE clan_name LIKE '".$search."' ORDER BY clan_name"; $clan_data=MYSQL_QUERY($get_clan_data); $num=mysql_num_rows($clan_data); if($num == 0) { ?> Clan list: <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles">Info</td> </tr> <tr> <td class="widelist-txt" align="center">No Clan with "<? echo $search; ?>" found!</td> </tr> </table> <? } elseif($num > 0) { ?> Clan list: <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" width="50%" colspan="3">Clan Name-[level]</td> <td class="sTable-titles" width="50%" align="right">Members</td> </tr> <? while(list($clan['id'],$clan['name'],$clan['level'],$clan['hasCastle'],$clan['ally_id'],$clan['leader_id'])=mysql_fetch_row($clan_data)) { $get_member_data="SELECT obj_id,char_name,online FROM characters WHERE clanid='".$clan['id']."'"; $member_data=MYSQL_QUERY($get_member_data); $clan['num']=mysql_num_rows($member_data); ?> <tr> <td class="widelist-txt" colspan="3"><a href="?page=stat.php&step=clan&searchid=<? echo $clan['id']; ?>"><? echo $clan['name']; ?></a>-[<? echo $clan['level']; ?>]</td> <td class="widelist-txt" align="right"><? echo $clan['num']; ?></td> </tr> <? if($num == 1) { if($clan['hasCastle'] == 0)$clan['hasCastle']=""; elseif($clan['hasCastle'] == 1)$clan['hasCastle']="Gludio castle"; elseif($clan['hasCastle'] == 2)$clan['hasCastle']="Dion castle"; elseif($clan['hasCastle'] == 3)$clan['hasCastle']="Giran castle"; elseif($clan['hasCastle'] == 4)$clan['hasCastle']="Oren castle"; elseif($clan['hasCastle'] == 5)$clan['hasCastle']="Aden Castle"; elseif($clan['hasCastle'] == 6)$clan['hasCastle']="Innadril Castle"; $get_leader_data="SELECT char_name FROM characters WHERE obj_id='".$clan['leader_id']."'"; $leader_data=MYSQL_QUERY($get_leader_data); list($clan['leader'])=mysql_fetch_row($leader_data); if($clan['ally_id'] != 0) { $get_ally_data="SELECT clan_name,clan_level,hasCastle,leader_id FROM clan_data WHERE clan_id='".$clan['ally_id']."'"; $ally_data=MYSQL_QUERY($get_ally_data); list($clan['ally_name'],$clan['ally_level'],$clan['ally_hasCastle'],$clan['ally_leader_id'])=mysql_fetch_row($ally_data); if($clan['ally_hasCastle'] == 0)$clan['ally_hasCastle']=""; elseif($clan['ally_hasCastle'] == 1)$clan['ally_hasCastle']="Gludio castle"; elseif($clan['ally_hasCastle'] == 2)$clan['ally_hasCastle']="Dion castle"; elseif($clan['ally_hasCastle'] == 3)$clan['ally_hasCastle']="Giran castle"; elseif($clan['ally_hasCastle'] == 4)$clan['ally_hasCastle']="Oren castle"; elseif($clan['ally_hasCastle'] == 5)$clan['ally_hasCastle']="Aden Castle"; elseif($clan['ally_hasCastle'] == 6)$clan['ally_hasCastle']="Innadril castle"; $get_ally_data="SELECT obj_id FROM characters WHERE clanid='".$clan['ally_id']."'"; $ally_data=MYSQL_QUERY($get_ally_data); $clan['ally_num']=mysql_num_rows($ally_data); $get_leader_data="SELECT char_name FROM characters WHERE obj_id='".$clan['ally_leader_id']."'"; $leader_data=MYSQL_QUERY($get_leader_data); list($clan['ally_leader'])=mysql_fetch_row($leader_data); }else{ $clan['ally_num']=""; $clan['ally_leader']=""; $clan['ally_name']=""; $clan['ally_level']=""; $clan['ally_hasCastle']=""; } ?> </table> <table width="100%" border="0" cellpadding="0" cellspacing="0" class="main-tables"> <tr> <td class="sTable-titles" colspan="4">Details</td> </tr> <tr> <td class="sTable-titles" width="15%">Leader:</td> <td class="widelist-txt" width="35%"><a href="?page=stat.php&step=player&searchid=<? echo $clan['leader_id']; ?>"><? echo $clan['leader']; ?></a></td> <td class="sTable-titles" width="15%">Members:</td> <td class="widelist-txt" width="35%"><? echo $clan['num']; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Clan Name:</td> <td class="widelist-txt" width="35%"><? echo $clan['name']; ?></td> <td class="sTable-titles" width="15%">Castle:</td> <td class="widelist-txt" width="35%"><? echo $clan['hasCastle']; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Clan Level:</td> <td class="widelist-txt" width="35%"><? echo $clan['level']; ?></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" width="15%">Ally-Leader:</td> <td class="widelist-txt" width="35%"><a href="?page=stat.php&step=player&searchid=<? echo $clan['ally_leader_id']; ?>"><? echo $clan['ally_leader']; ?></a></td> <td class="sTable-titles" width="15%">Ally-Members:</td> <td class="widelist-txt" width="35%"><? echo $clan['ally_num']; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Ally-Clan Name:</td> <td class="widelist-txt" width="35%"><a href="?page=stat.php&step=clan&searchid=<? echo $clan['ally_id']; ?>"><? echo $clan['ally_name']; ?></a></td> <td class="sTable-titles" width="15%">Ally-Castle:</td> <td class="widelist-txt" width="35%"><? echo $clan['ally_hasCastle']; ?></td> </tr> <tr> <td class="sTable-titles" width="15%">Ally-Clan Level:</td> <td class="widelist-txt" width="35%"><? echo $clan['ally_level']; ?></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> <td class="sTable-titles" width="15%"></td> <td class="widelist-txt" width="35%"></td> </tr> <tr> <td class="sTable-titles" colspan="4">Members</td> </tr> <? while(list($member['obj_id'],$member['char_name'],$member['online'])=mysql_fetch_row($member_data)) { if($member['online'] == 0)$member['online']="Online-No"; elseif($member['online'] >= 1)$member['online']="Online-Yes"; ?> <tr> <td class="widelist-txt" colspan="2" width="50%"><a href="?page=stat.php&step=player&searchid=<? echo $member['obj_id']; ?>"><? echo $member['char_name']; ?></a></td> <td class="widelist-txt" colspan="2" width="50%" align="right"><? echo $member['online']; ?></td> </tr> <? } } } ?> </table> <? } } } } ?> [/codebox] Obrigado, Aguardo Respostas espero ter postado corretamente.
- Agosto 30, 2008
- 1 resposta

Entrar

Kaellum

Total de itens

Registro em

Última visita

Tipo de Conteúdo

Perfis

Fóruns

Tudo que Kaellum postou

Stat.php Ajuda.

Navegação

Atividades