Jump to content

cunhado

Members
  • Posts

    103
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by cunhado

  1. They look nice but sql didnt work for me. Added them all manual tho :) Thanks
  2. Thank you for the share. Its really appreciated.
  3. This one really helps me out. Was just busy changing some stats on tattoos and... this makes life a lot easier! Many thanks.
  4. Got it working for 50% now, but it seems very usefull. Thanks for sharing.
  5. This sounds promising. Sure am going to test this one out. Thank you very much for the upload.
  6. Hi Matim, I'm a fanatic reader of this forum and learning every day about all I want to learn. Yes sometimes I just can't find it and ask for help. But i allready got it. I must have looked over it and passed it completely :p Am at work now, but tonight ill give the custom clanhalls a try :) Thanks for this share.
  7. :o Searched the whole forum but cant find it. How can I use a .diff file? Sorry for the noob question. I am just starting to learn.
  8. Nice job. Good animations I guess if you like them. (Purple isnt realy my thing) Altho i'm looking for new and unique weapons i'm gonna test them anyways on my testserver. Thank you
  9. Thank you guys. Problem is solved
  10. I'm using Gracia Final.
  11. Thank you and i'll try it asap :) EDIT: CAnt seem to get it going but i try to figure it out and learn a bit more about qusts :)
  12. So what would it be? com.l2jserver instead of ...
  13. Sorry for the double post, but I dont know any other way to bump my helpquestion :/
  14. I get the following error: My init file looks as follows: #Jython-based Top PvP Manger import sys from java.util import Iterator from net.sf.l2j.gameserver.model.quest import State from net.sf.l2j.gameserver.model.quest import QuestState from net.sf.l2j.gameserver.model.quest.jython import QuestJython as JQuest from net.sf.l2j.gameserver.network.serverpackets import CreatureSay from net.sf.l2j import L2DatabaseFactory # *************************************** # Info of custom quest * # *************************************** qn = "7206_CustomInfo" NPCS = [7206] Precio_ID = 57 QuestId = 7206 QuestName = "CustomInfo" QuestDesc = "custom" InitialHtml = "1.htm" # *************************************** # Jython Code * # *************************************** class Quest (JQuest) : def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr) def onTalk (self,npc,player): return InitialHtml def onEvent(self,event,st): htmltext = event cantidad_pago = st.getQuestItemsCount(Precio_ID) # ********* # PK info * # ********* if event == "1" : total_asesinados = 0 htmltext_ini = "<html><head><title>TOP PK</title></head><body><table width=300><tr><td><font color =\"FF0000\"><center>Pos.</center></td><td><center><font color =\"FF0000\">Player name</color></center></td><td><center>Kills</center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT char_name,pkkills FROM characters WHERE pkkills>0 and accesslevel=0 order by pkkills desc limit 15") rs = pks.executeQuery() while (rs.next()) : char_name = rs.getString("char_name") char_pkkills = rs.getString("pkkills") total_asesinados = total_asesinados + int(char_pkkills) pos = pos + 1 posstr = str(pos) if color == 1: color_text = "<font color =\"FFFFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\"><center>" + posstr + "</center></td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" elif color == 2: color_text = "<font color =\"23ADC2\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"23ADC2\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" htmltext_end = "</table></body></html>" htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_pklist elif event == "1" and cantidad_pago < 3000 : htmltext = "<html><head><title>PK info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 3000 adenas.</body></html>" return htmltext # ********** # PvP info * # ********** if event == "2" : total_asesinados = 0 htmltext_ini = "<html><head><title>TOP PvP</title></head><body><table width=300><tr><td><font color =\"FF0000\"><center>Pos.</center></td><td><center><font color =\"FF0000\">Player name</color></center></td><td><center>Kills</center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT char_name,pvpkills FROM characters WHERE pvpkills>0 and accesslevel=0 order by pvpkills desc limit 15") rs = pks.executeQuery() while (rs.next()) : char_name = rs.getString("char_name") char_pkkills = rs.getString("pvpkills") total_asesinados = total_asesinados + int(char_pkkills) pos = pos + 1 posstr = str(pos) if color == 1: color_text = "<font color =\"FFFFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" elif color == 2: color_text = "<font color =\"23ADC2\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"23ADC2\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" htmltext_end = "</table></body></html>" htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_pklist elif event == "2" and cantidad_pago < 3000 : htmltext = "<html><head><title>PK info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 3000 adenas.</body></html>" return htmltext # ************* # Adenas info * # ************* if event == "3" : total_cantidad = 0 htmltext_ini = "<html><head><title>Top Adena</title></head><body><table width=300><tr><td><font color =\"FF0000\"><center>Pos.</center></td><td><center><font color =\"FF0000\">Player name</color></center></td><td><center>Adenas</center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT count,owner_id FROM items WHERE item_id=57 order by count desc limit 20") rs = pks.executeQuery() while (rs.next()) : cantidad = rs.getString("count") pj_id = rs.getString("owner_id") total_cantidad = total_cantidad + long(cantidad) pos = pos + 1 posstr = str(pos) charname = con.prepareStatement("SELECT char_name FROM characters WHERE charId=" + pj_id) rs2 = charname.executeQuery() while (rs2.next()) : char_name = rs2.getString("char_name") if color == 1: color_text = "<font color =\"FFFFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + cantidad + "</center></td></tr>" elif color == 2: color_text = "<font color =\"23ADC2\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"23ADC2\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + cantidad + "</center></td></tr>" htmltext_end = "</table></body></html>" htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_pklist elif event == "3" and cantidad_pago < 3000 : htmltext = "<html><head><title>Adenas info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 100k adenas.</body></html>" return htmltext # ************* # Nobless info * # ************* if event == "4" : total_asesinados = 0 htmltext_ini = "<html><head><title>Top Nobless order by PvP</title></head><body><table width=300><tr><td><center><font color =\"FF0000\">Pos.</td></center><td><center><font color =\"FF0000\">Player name</color></center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT char_name,pkkills,nobless FROM characters WHERE pkkills>0 and accesslevel=0 order by pkkills desc limit 10") rs = pks.executeQuery() while (rs.next()) : char_name = rs.getString("char_name") char_pkkills = rs.getString("nobless") pos = pos + 1 posstr = str(pos) if color == 1: color_text = "<font color =\"FFFFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td></tr>" elif color == 2: color_text = "<font color =\"23ADC2\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"23ADC2\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td></tr>" htmltext_end = "</table></body></html>" htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_pklist elif event == "4" and cantidad_pago < 3000 : htmltext = "<html><head><title>PK info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 3000 adenas.</body></html>" return htmltext # ********** # Clan Top * # ********** if event == "5" : total_asesinados = 0 htmltext_ini = "<html><head><title>TOP Clan</title></head><body><table width=300><tr><td><font color =\"FF0000\"><center>Pos.</center></td><td><center><font color =\"FF0000\">Clan name</color></center></td><td><center>Level</center></td></tr>" htmltext_info ="" color = 1 pos = 0 con = L2DatabaseFactory.getInstance().getConnection() pks = con.prepareStatement("SELECT clan_name,clan_level,reputation_score FROM clan_data WHERE clan_level>0 order by clan_level desc limit 10") rs = pks.executeQuery() while (rs.next()) : char_name = rs.getString("clan_name") char_pkkills = rs.getString("clan_level") total_asesinados = total_asesinados + int(char_pkkills) pos = pos + 1 posstr = str(pos) if color == 1: color_text = "<font color =\"FFFFFF\">" color = 2 htmltext_info = htmltext_info + "<tr><td><center><font color =\"FFFFFF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" elif color == 2: color_text = "<font color =\"23ADC2\">" color = 1 htmltext_info = htmltext_info + "<tr><td><center><font color =\"23ADC2\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_pkkills + "</center></td></tr>" htmltext_end = "</table></body></html>" htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end con.close() return htmltext_pklist elif event == "5" and cantidad_pago < 3000 : htmltext = "<html><head><title>PK info Online</title></head><body><font color =\"FF0000\">Primero pagame...!! son 3000 adenas.</body></html>" return htmltext QUEST = Quest(QuestId,str(QuestId) + "_" + QuestName,QuestDesc) for npcId in NPCS: QUEST.addStartNpc(npcId) QUEST.addTalkId(npcId) I cant find the problem :/ Thanks for any help received.
  15. cool guide. Thank you gonna try it asap, just for loz.
  16. Was looking for this. Thank you :)
  17. Its just one of many servers and i happen to have some friends on it. That makes the fun ;)
  18. Lineage has gone wild the last couple of years. Better times were Interlude but thats my opinion. Not waiting and hoping for L3
  19. Normal pvp with +16 max Better for newbies and more balanced pvp :D
  20. For l2net go to: http://insane-gamers.com/forum.php Download latest revision and enjoy! A guide that helped me a lot was: http://insane-gamers.com/showthread.php/4750-RETAIL-PSERVER-IG-Connection-guide?p=45429&viewfull=1#post45429 Have fun!
  21. Welcome to MxC :) Lot of good stuff can be found here. Enjoy!
  22. Welcome to MxC :)
  23. i love Ajax...the club xD Welcome btw
  24. Hi Have a small problem with l2net. I can log in OOG and run scripts, but cant use the IG. I just want it to use cp scripts ingame xD To give some more info: I use L2NET version 384. My host: 127.0.0.1 localhost 127.0.0.1 l2authd.lineage2.com 92.240.236.2 l2authd.lineage2.com Edited my ini file: ServerAddr=127.0.0.1 OOG settings (which work): Protocol 146 on CT G+ Server: L2Inc ip: 92.240.236.2 port: 2106 IG settings (which wont log in): Protocol 146 on CT G+ Server: L2Inc ip: 92.240.236.2 Login serverport: 2106 Local ip: 127.0.0.1 Port: 2106 Stuck at: 22:48:40 :[client -> bot gameserver : using port 7777 Have been using it about a year ago, but seem to get no further this time. Thanks =================== SOLVED BY FOLLOWING THE NEXT GUIDE: http://insane-gamers.com/showthread.php/4750-RETAIL-PSERVER-IG-Connection-guide?p=45429&viewfull=1#post45429
  25. This might be handy xD Sure gonna try it on my test server. Thanks
×
×
  • Create New...