Have you created a useful tool? or Do you want to get help building one? This is the right place!
antara
Posts: 71 Joined: Sun Jun 29, 2008 1:57 pm
Post
by antara » Mon Sep 13, 2010 8:36 pm
Hi all, I am using the last L2jServer and L2jDatapack epilogue version, and I want to modify a php code to show the hero list, but I don't know so much of php and javascript, can somebody help me please?
Heres the code.
Code: Select all
<?php//Script cirado por Rayder//www.portal1533.com.br//www.virtualmu.com.br $servidor = 'localhost';$usuario = 'root';$senha = 'contraseña';$db = 'l2jdb'; $con = mysql_connect($servidor, $usuario, $senha) or die(mysql_error());mysql_select_db($db, $con) or die(mysql_error());?><h1>Heros</h1><div id="rank_geral"> <div id="barra_lateral"> <div id="borda_lateral_e"></div> <ul id="topo_rank"> <li class="nomej">Nombre del PJ</li> <li class="level">Level</li> <li class="classe">Clase</li> <li class="clanh">Clan</li> <li class="vezes">Veces</li> </ul> <div id="barra_lateral_d"></div> </div> <?php $sql = mysql_query("SELECT * FROM heroes ORDER BY char_name") or die(mysql_error());$i = 1;while($c = mysql_fetch_array($sql)) { $h = mysql_query("SELECT * FROM characters WHERE Obj_Id = '".$c['char_id']."'") or die(mysql_error()); $n = mysql_fetch_array($h); $l = mysql_query("SELECT * FROM class_list WHERE id = '".$n['base_class']."'") or die(mysql_error()); $g = mysql_fetch_array($l); $i = mysql_query("SELECT * FROM clan_data WHERE clan_id = '".$n['clanid']."'") or die(mysql_error()); $j = mysql_fetch_array($i); $g['class_name'] = explode("_", $g['class_name']); $n['class_name'] = explode("_", $n['char_name']); $j['clan_name'] = empty($n['clanid']) ? 'Sin Clan.' : $j['clan_name'];?> <div class="li_r_bl"> <ul class="list_rank"> <li class="nomej"><?php echo $n['char_name']; ?></li> <li class="level"><?php echo $n['level']; ?></li> <li class="classe"><?php echo ucwords($g['class_name'][1]); ?></li> <li class="clanh"><?php echo $j['clan_name']; ?></li> <li class="vezes"><?php echo $c['count']; ?></li> </ul> <div class="clear"></div> </div> <?php $i++;}?> <div class="clear"></div> <div id="borda_e_cgr"></div> <div id="barra_rodape_cg_3"></div> <div id="borda_d_cgr"></div></div><div class="clear"></div>
Sory for my bad inglish ^_^"
wonderweiss
Posts: 16 Joined: Mon Aug 02, 2010 9:23 pm
Post
by wonderweiss » Tue Sep 14, 2010 12:05 am
Olympiad.php
Code: Select all
<?php require("config/olymp.php");$activity = mysql_query("SELECT characters.$OBJ_ID, characters.char_name, characters.level, olympiad_nobles.char_id, olympiad_nobles.class_id, olympiad_nobles.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassId, char_templates.ClassNameFROM charactersLEFT JOIN olympiad_nobles ON characters.$OBJ_ID = olympiad_nobles.char_idJOIN char_templates ON char_templates.ClassId = olympiad_nobles.class_idORDER BY olympiad_nobles.olympiad_points DESC,olympiad_nobles.competitions_doneDESC LIMIT $LIMIT");$i = 1; while($row = mysql_fetch_array($activity)) { if (!($i%2)) echo "<tr bgcolor='#000000' align='center'>"; else echo "<tr bgcolor='#161616' align='center'>"; echo "<td>"."<center>".$i."</center>"."</td>"; echo "<td>"."<center>".$row['char_name']."</center>"."</td>"; echo "<td>"."<center>".$row['level']."</center>"."</td>"; echo "<td>"."<center>".$row['ClassName']."</center>"."</td>"; echo "<td>"."<center>".$row['olympiad_points']."</center>"."</td>"; echo "<td>"."<center>".$row['competitions_done']."</center>"."</td>"; $i++;}?>
Olymp.php
Code: Select all
<?php$L2JBS_config["mysql_host"]="localhost"; // MySQL Host ["localhost"]$L2JBS_config["mysql_port"]="3306"; // MySQL Port ["3306"]$L2JBS_config["mysql_db"]=""; // MySQL Database ["l2jdb"]$L2JBS_config["mysql_login"]=""; // MySQL User ["root"] $L2JBS_config["mysql_password"]=""; // MySQL Password ["root"]$LIMIT="60"; // TOP PAGE LIMIT$OBJ_ID="obj_Id"; // Characters Table object id field name$ACCS_LVL="accesslevel"; // Characters Table access level field name$minenchant="5"; // Safe Enchant of Server$maxenchant="20"; // Max Enchant of Server$ETCITEMS="4037,57"; // Top Items Ids$MAX_ACCESS="1"; // Full Access level$EGM_ACCESS="5"; // Event GM Access level$NORMAL_ACCESS="2"; // Normal GM Access levelinclude("config/_config_procs.php");error_reporting(0);?>
antara
Posts: 71 Joined: Sun Jun 29, 2008 1:57 pm
Post
by antara » Tue Sep 14, 2010 2:40 pm
Don't load in the servers page, I will try to fix it, thx ^^