-
Posts
451 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Everything posted by disorder25
-
Need help fixing this hero php code
disorder25 replied to disorder25's question in Request Server Development Help [L2J]
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> -
Need help fixing this hero php code
disorder25 posted a question in Request Server Development Help [L2J]
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> -
[share]Website-my work nr 2 ;) update by help Sur3x
disorder25 replied to DeTusiN's topic in Off-Topics
Nice work I hope ypu finish it soon and post it in here. -
[Share]Event Capture Buzz [Interlude]
disorder25 replied to CriticalError's topic in Server Shares & Files [L2J]
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. -
[Share] Current Heros website script - OFF
disorder25 replied to GoDofAdeN's topic in Server Shares & Files [L2OFF]
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. -
[Share] Current Heros website script - OFF
disorder25 replied to GoDofAdeN's topic in Server Shares & Files [L2OFF]
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. -
very cool site. Thanks bro
-
oOO Brother very nice definitely this map is gonna be on my web page< Thanks for the share
-
[Share]Event Capture Buzz [Interlude]
disorder25 replied to CriticalError's topic in Server Shares & Files [L2J]
Nobody to help me with this? -
If a posted in Lineage II Private Servers how can it be wrong?
-
found 2 virus on it. LOl
-
[Request] Tattoo Stats
disorder25 replied to *~!ĈħâðيȘ۸μấيŧۼŔ™'s question in Request Server Development Help [L2J]
Link doesn't work, can you upload it again -
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
-
[Guide]Complete Weapon Glow Guide [11-09-09]
disorder25 replied to LauQ's topic in Client Development Discussion
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 -
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
-
[REQUEST] L2J SubClass Manager for Gracia Final.
disorder25 replied to gkarmas's question in Request Server Development Help [L2J]
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. -
[Share]Event Capture Buzz [Interlude]
disorder25 replied to CriticalError's topic in Server Shares & Files [L2J]
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 -
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.
-
[Share]Kill The RaidBoss & King of the hill events!
disorder25 replied to xMaylox's topic in Server Shares & Files [L2J]
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. -
Was looking for that. Thanks
-
[Share]Kill The RaidBoss & King of the hill events!
disorder25 replied to xMaylox's topic in Server Shares & Files [L2J]
My friend this is the best share i have seen in here, so far it is working good. Keep it up. Thanks -
Help with enchanted weapons
disorder25 replied to disorder25's question in Request Server Development Help [L2J]
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. -
Help with enchanted weapons
disorder25 replied to disorder25's question in Request Server Development Help [L2J]
where exactly i have to put the code because i tried in diferent places and it did not work. Thanks anyway. Obrigado
