Jump to content

disorder25

Members
  • Posts

    451
  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by disorder25

  1. What do you mean? user data is the characters table isn't it? This code I think is for L2 OFF, need to convert it to L2j database>
  2. Can anybody help me fix this code to make it work with L2j database. Right now I got it to show the table with name, class, etc but I don't get the hero info. Please if you can help I will appreciate. Thank you. <html> <head> <title>Heroes</title> <style> body { margin: 0px; padding: 0px; background: #2E0601; color: #ffffff; font-family: tahoma, verdana; font-size: 8pt; } td { font-family: tahoma, verdana; font-size: 8pt; margin: 0; color: #ffffff; } b { font-weight: bold; color: #84c3f8; } A { color: #ffe155; text-decoration: none; } A:link { color: #ffe155; } A:visited { color:#e8a400; } A:active { color: #ffff99; } A:hover { color: #ffff99; text-decoration: underline; } .tabletitle { color: #FFFFFF; background-color: #4B150E; border-width: 2; border-style: solid; border-color: #000000; } </style> </head> <body> <center> <table class='info'> <tr class='info'><td align='center'><b>Current Heroes</b></td></tr> </table> <? $class_list=array( 0=>"Fighter",1=>"Warrior",2=>"Gladiator",3=>"Warlord",4=>"Knight",5=>"Paladin",6=>"Dark Avenger",7=>"Rogue", 8=>"Treasure Hunter",9=>"Hawkeye",10=>"Mage",11=>"Wizard",12=>"Sorcerer",13=>"Necromancer",14=>"Warlock",15=>"Cleric", 16=>"Bishop",17=>"Prophet",18=>"Elven Fighter",19=>"Elven Knight",20=>"Temple Knight",21=>"Swordsinger",22=>"Elven Scout",23=>"Plains Walker", 24=>"Silver Ranger",25=>"Elven Mage",26=>" Elven Wizard",27=>" Spellsinger",28=>"Elemental Summoner ",29=>"Oracle", 30=>"Elder",31=>"Dark Fighter",32=>"Palus Knightr",33=>"Shillien Knight",34=>"Bladedancer",35=>"Assasin",36=>"Abyss Walker", 37=>"Phantom Ranger",38=>"Dark Mage",39=>"Dark Wizard",40=>"Spellhowler",41=>"Phantom Summoner",42=>"Shillien Oracle",43=>"Shilien Elder", 44=>"Orc Fighter",45=>"Orc Raider",46=>"Destroyer",47=>"Orc Monk",48=>"Tyrant",49=>"Orc Mage",50=>"Orc Shaman",51=>"Overlord", 52=>"Warcryer",53=>"Dwarven Fighter",54=>"Scavenger",55=>"Bounty Hunter",56=>"Artisan", 57=> "Warsmith", 88=>"Duelist",89=>"Dreadnought",90=>"Phoenix Knight",91=>"Hell Knight",92=>"Sagittarius",93=>"Adventurer",94=>"Archmage",95=>"Soultaker", 96=>"Arcana Lord",97=>"Cardinal",98=>"Hierophant",99=>"Evas Templar",100=>"Sword Muse",101=>"Wind Rider",102=>"Moonlight Sentinel", 103=>"Mystic Muse",104=>"Elemental Master",105=>"Evas Saint",106=>"Shillien Templar",107=>"Spectral Dancer",108=>"Ghost Hunter", 109=>"Ghost Sentinel",110=>"Storm Screamer",111=>"Spectral Master",112=>"Shillien Saint",113=>"Titan",114=>"Grand Khavatari", 115=>"Dominator",116=>"Doomcryer",117=>"Fortune Seeker",118=>"Maestro", 123=>"Male Soldier",124=>"Female Soldier",125=>"Trooper",126=>"Warder",127=>"Berserker", 128=>"Male Soulbreaker",129=>"Female Soulbreaker",130=>"Arbalester",131=>"Doombringer", 132=>"Male Soulhound",133=>"Female Soulhound",134=>"Trickster",135=>"Inspector",136=>"Judicator" ); // db config $db_user = "root"; //your sql username goes here $db_pass = ""; //your sql password goes here $db_name = "l2jdb"; //your database name goes here $db_serv = "localhost"; //the address of the database goes here // db connection! $db = mysql_connect ( $db_serv, $db_user, $db_pass ) or die ("Coudn't connect to [$db_serv]"); mysql_select_db ( $db_name ); function do_query($query) { $arr = array(); $result = mssql_query($query) or die("Error SQL: ".mssql_get_last_message()); for ($x=0; $arr[$x] = mssql_fetch_assoc($result); $x++); unset($arr[count($arr)-1]); return $arr; } $query = mysql_query("SELECT char_name,subjob0_class,pledge.name as 'pname',alliance.name as 'aname',pledge.crest_id as 'pcrest',alliance.crest_id as 'acrest',win_count,race FROM user_data LEFT JOIN pledge ON pledge.pledge_id = user_data.pledge_id INNER JOIN user_nobless ON user_nobless.char_id = user_data.char_id LEFT JOIN alliance ON alliance.id = pledge.alliance_id WHERE hero_type > 0 AND win_count > 0 AND builder = 0 AND account_id > 0 ORDER BY subjob0_class "); $heroes_actuales = mysql_query($query); if (sizeof($heroes_actuales) == 0) echo "No heros found."; else { echo " <table class='info'><tr bgcolor='333333' align='center'>\n <tr bgcolor='333333' align='center'> <td width='24%' align='left'><b>Name</b></td> <td width='24%' align='left'><b>Class</b></td> <td width='24%' align='left'><b>Clan</b></td> <td width='24%' align='left'><b>Alliance</b></td> <td width='4%' align='left'><b>Wins</b></td> </tr> "; $i=0; foreach($heroes_actuales as $hero) { if (!($i%2)) echo "<tr bgcolor='000000' align='center'>"; else echo "<tr bgcolor='333333' align='center'>"; echo " <td align='left'>".$hero['char_name']."</td> <td align='left'>".$class_list[$hero['subjob0_class']]."</td> <td align='left'> "; if ($hero['pcrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['pcrest']."'> "; echo $hero['pname']."</td><td align='left'>"; if ($hero['acrest'] != 0) echo "<img height='12' src='crest.php?id=".$hero['acrest']."'> "; echo $hero['aname']."</td><td align='left'>".$hero['win_count']."</td></tr>"; $i++; } echo "</table>"; } ?> <body> </html>
  3. Nice work I hope ypu finish it soon and post it in here.
  4. Was looking for php codes like this, thank you for share then.
  5. Does this event work for all of you or this is just to increase your posts? Because on my server it didn't work and I asked for help and nobody helped me so I guess people just say the share was good to get more posts. Update on 09/08/09 I finally fixed this event, it is working now.
  6. Oh sorry I didn't see the word OFF on the subject, but this is the coolest hero script I haven't seen and all the other ones i seen in here aren't as good as this. I wish I could find a script like this for L2j. Can somebody post a similar script that will work with L2j. Thanks for telling me.
  7. can you make a tutorial of how to get this and the other script to work, like do we have to add anything to one of the php files to call the other one. Please explain how we set this thing up, I downloaded both phps but they don't work. My server is l2j latest revision. Thanks in advance.
  8. very cool site. Thanks bro
  9. oOO Brother very nice definitely this map is gonna be on my web page< Thanks for the share
  10. Nobody to help me with this?
  11. If a posted in Lineage II Private Servers how can it be wrong?
  12. found 2 virus on it. LOl
  13. Link doesn't work, can you upload it again
  14. It look like a good share but for some reason I can't get it to work. I put in the ip, user, pass and database name and I always get the: Mysql connection failed! Unable to connect to any of the specified Mysql database. How can i fix that? I enter my ip, root pass (leave empty because i didn't set a pass) l2jdb
  15. Laugh what nice guide you made. You made it look so easy. I'm gonna follow you guide and see if I can change some glows. Thanks
  16. New server located in the Usa. Server Rates: Exp: 200x Sp: 200x Adena: 800x Safe Enchant: 12 Max Enchant: 25 Enchant Rate: 75% Blessed Enchant Rate: 85% For more info visit: l2profanity.myfineforum.org
  17. nice share, it worked on L2j ct3 but the only problem is when I changed add a subclass it keep my lv at 85 instead of delevel to 40 and it keep all the skills from both classes.
  18. Can somebody help me fix this event? Well when I register 2 or 3 players, only one gets ported to the event, the other ones for some reason get ported to goddard, they get registered in the event fine and get the color circle around it but they don't go to the event. Everything else works good but I can put this in the server because of this little problem. Please help me fix it. Thanks. Also I get an error on attack and i need help to fix that. C:\L2jserver_lauq\gameserver\data\scripts\custom\5556_base\__init__.py Traceback (innermost last): (no code object) at line 0 TypeError: onAttack() too many arguments; expected 5 got 6 at org.python.core.Py.TypeError(Unknown Source) at org.python.core.PyTableCode.call(Unknown Source) at org.python.core.PyTableCode.call(Unknown Source) at org.python.core.PyFunction.__call__(Unknown Source) at org.python.core.PyMethod.__call__(Unknown Source) at org.python.core.PyObject.__call__(Unknown Source) at org.python.core.PyObject._jcallexc(Unknown Source) at org.python.core.PyObject._jcall(Unknown Source) at org.python.proxies.main$Quest$439.onAttack(Unknown Source) at net.sf.l2j.gameserver.model.quest.Quest.notifyAttack(Quest.java:343) at net.sf.l2j.gameserver.model.actor.L2Attackable.addDamage(L2Attackable .java:794) at net.sf.l2j.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Atta ckable.java:377) at net.sf.l2j.gameserver.model.actor.instance.L2GrandBossInstance.reduce CurrentHp(L2GrandBossInstance.java:65) at net.sf.l2j.gameserver.model.actor.L2Attackable.reduceCurrentHp(L2Atta ckable.java:349) at net.sf.l2j.gameserver.model.actor.L2Character.onHitTimer(L2Character. java:5252) at net.sf.l2j.gameserver.model.actor.instance.L2PcInstance.onHitTimer(L2 PcInstance.java:4377) at net.sf.l2j.gameserver.model.actor.L2Character$HitTask.run(L2Character .java:2495) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. access$301(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask. run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source ) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) And here is the part geting the error def onAttack (self,npc,player,damage,isPet,) : npcId = npc.getNpcId() if npcId == BASE2 and player.getName() not in TEAM1 : player.reduceCurrentHp(99999,player) if npcId == BASE1 and player.getName() not in TEAM2 : player.reduceCurrentHp(99999,player) return
  19. Hi i'm looking for a Npc that trade a item for clan reputation. Anybody have something like that to share or wanna help me create one. Thank you in advance.
  20. I tested on my server L2j Latest revision but i'm getting the error like everybody else (on kill). King of the hill i haven't tested yet. Also i want to add extra rewards for the raid boss event. how can i do that? Also i like to make a suggestion for the kill the raid boss event: you should make an event manager so players can join the event and get teleported to location where the boss was spawned. Thanks anyway.
  21. Was looking for that. Thanks
  22. My friend this is the best share i have seen in here, so far it is working good. Keep it up. Thanks
  23. Hey brother keep up with the good work. Great share. I was looking for some like this.
  24. Yes I did, as a matter of fact i read a guide on multisell here somewhere. But everybody says that you can't sell enchanted itens with multisell anymore. I don't know if it is true but I added the code in front of the item after count on production and it didn't do anything. If it still possible to do a enchanted item sell please post a example for me on how did you right the code. Thanks a lot.
  25. where exactly i have to put the code because i tried in diferent places and it did not work. Thanks anyway. Obrigado
×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock