» Find Revision
L2J Revision 4110:
L2JDP Revision 7305:
Hi i just want to know someone can help me to fix this script pls ^^
i used it on the 2.3 Server but now it didnt work anymore.
It is an AiO Buffer.
1st.
Code: Select all
import sysfrom com.l2jserver. import Configfrom com.l2jserver. import L2DatabaseFactoryfrom java.lang import Systemfrom java.util import Iteratorfrom com.l2jserver.gameserver.model.quest import Statefrom com.l2jserver.gameserver.model.quest import QuestStatefrom com.l2jserver.gameserver.model.quest.jython import QuestJython as JQuestfrom com.l2jserver.gameserver.datatables import SkillTablefrom com.l2jserver.gameserver.datatables import SkillTreeTablefrom com.l2jserver.gameserver.datatables import ClanTablefrom com.l2jserver.gameserver.datatables import HennaTreeTablefrom com.l2jserver.gameserver.model import L2Objectfrom com.l2jserver.gameserver.model import L2HennaInstancefrom com.l2jserver.gameserver.model import L2Clanfrom com.l2jserver.gameserver.model.base import ClassIdfrom com.l2jserver.gameserver.model.actor import L2Characterfrom com.l2jserver.gameserver.model.actor.instance import L2PcInstancefrom com.l2jserver.gameserver.model.actor.instance import L2PetInstancefrom com.l2jserver.gameserver.model.actor.instance import L2SummonInstancefrom com.l2jserver.gameserver.instancemanager import QuestManagerfrom com.l2jserver.gameserver.instancemanager import TownManagerfrom com.l2jserver.gameserver.instancemanager import CastleManagerfrom com.l2jserver.gameserver.instancemanager import FortManagerfrom com.l2jserver.gameserver.instancemanager import FortSiegeManagerfrom com.l2jserver.gameserver.instancemanager import SiegeManagerfrom com.l2jserver.gameserver.network import SystemMessageIdfrom com.l2jserver.gameserver.network.serverpackets import SellListfrom com.l2jserver.gameserver.network.serverpackets import PackageToListfrom com.l2jserver.gameserver.network.serverpackets import ActionFailedfrom com.l2jserver.gameserver.network.serverpackets import WareHouseDepositListfrom com.l2jserver.gameserver.network.serverpackets import WareHouseWithdrawalListfrom com.l2jserver.gameserver.network.serverpackets import SystemMessagefrom com.l2jserver.gameserver.network.serverpackets import NpcHtmlMessagefrom com.l2jserver.gameserver.network.serverpackets import SetSummonRemainTimefrom com.l2jserver.gameserver.network.serverpackets import SetupGaugefrom com.l2jserver.gameserver.network.serverpackets import MagicSkillLaunchedfrom com.l2jserver.gameserver.network.serverpackets import MagicSkillUsefrom com.l2jserver.gameserver.network.serverpackets import AcquireSkillListfrom com.l2jserver.gameserver.network.serverpackets import AcquireSkillDonefrom com.l2jserver.gameserver.network.serverpackets import HennaEquipList ##############################AllowVIP = False ###############################VIPaccesLevel = 1 ###############################CLASSMASTER_GIFT = 6622 ###############################CLASSMASTER_ITEM_NUM= 1 # ##############################NOBLE_ITEMID = 6673 ###############################NOBLE_NumITEM = 20000 ###############################NOBLE_Level = 80 # ##############################NOBLESS_TIARA = 7694 ###############################ALLOW_KARMA_PLAYER=True ###############################FREE_TELEPORT = False ###############################ShowReloadScriptPanel = False###############################FREE_BUFFS = False ###############################CONSUMABLE_ID = 57 ###############################BUFFS_PRICE = 100000 ###############################BUFF_REMOVE_PRICE = 10000 ###############################HEAL_PRICE = 10000 ###############################TIME_OUT = False ###############################TIME_OUT_TIME = 1 ###############################BlockTime = 20 ############################### npcId = 955QuestId = 955QuestName = "NpcService"QUEST_INFO = str(QuestId)+"_"+QuestNameQuestDesc = "custom" print "============================="print "INFO Loaded SERVICES MANAGER"print "=============================" def MainHtml3(st) : MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">.::Subclass Master Options::.</font><br><br1>" if st.player.getTotalSubClasses() < Config.MAX_SUBCLASS : MAIN_HTML += "<button value=\"Add Subclass\" action=\"bypass -h Quest " +QUEST_INFO+ " getracemenu addsub 0 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Change Subclass\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass changesub 0 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Remove Subclass\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass deletesub 0 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<br><font color=\"303030\">"+getmaster()+"</font>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def MainHtml4(st) : MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">.::Clan Options::.</font><br><br1>" if st.player.getClanId() == 0: MAIN_HTML += "<button value=\"Create New Clan\" action=\"bypass -h Quest " +QUEST_INFO+ " createclan 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" else: MAIN_HTML += "<button value=\"Delegate Clan Leader\" action=\"bypass -h Quest " +QUEST_INFO+ " giveclanl 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Increase Clan Level\" action=\"bypass -h Quest " +QUEST_INFO+ " increaseclan 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Disband Clan\" action=\"bypass -h Quest " +QUEST_INFO+ " DisbandClan 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Restore Clan\" action=\"bypass -h Quest " +QUEST_INFO+ " RestoreClan 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Acquire Clan Skill\" action=\"bypass -h Quest " +QUEST_INFO+ " learn_clan_skills 0 0 0\" width=140 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<br><font color=\"FF0000\">.::Alliance Options::.</font><br><br1>" clan=st.player.getClan() if clan.getAllyId() == 0: MAIN_HTML += "<button value=\"Create a Alliance\" action=\"bypass -h Quest " +QUEST_INFO+ " createally 0 0 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" else: MAIN_HTML += "<button value=\"Dissolve Alliance\" action=\"bypass -h Quest " +QUEST_INFO+ " dissolve_ally 0 0 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<br><font color=\"303030\">"+getmaster()+"</font>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def RaceMenu(st,case,case2) : temp = getVarcharacters(st,"race") if temp == "5": return subclassopcions(st, case, "5", case2) else: MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">.::Chooce a Race::.</font><br><br1>" MAIN_HTML += "<button value=\"Human\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+case+" 0 "+case2+"\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" if temp != "2": MAIN_HTML += "<button value=\"Elf\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+case+" 1 "+case2+"\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" if temp != "1": MAIN_HTML += "<button value=\"Dark Elf\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+case+" 2 "+case2+"\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Orc\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+case+" 3 "+case2+"\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<button value=\"Dwarf\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+case+" 4 "+case2+"\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<br><font color=\"303030\">"+getmaster()+"</font>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def NobleMenu(st): MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">.::Noblesse Manager::.</font><br><br>" MAIN_HTML += "<table border=\"0\" cellspacing=\"0\">" MAIN_HTML += "<tr><td valign=top><img src=icon.skill0325 width=32 height=32 align=left></td><td valign=top><img src=icon.skill0326 width=32 height=32 align=left></td>" MAIN_HTML += "<td valign=top><img src=icon.skill0327 width=32 height=32 align=left></td><td valign=top><img src=icon.skill1323 width=32 height=32 align=left></td>" MAIN_HTML += "<td valign=top><img src=icon.skill1324 width=32 height=32 align=left></td><td valign=top><img src=icon.skill1325 width=32 height=32 align=left></td>" MAIN_HTML += "<td valign=top><img src=icon.skill1326 width=32 height=32 align=left></td><td valign=top><img src=icon.skill1327 width=32 height=32 align=left></td></tr>" MAIN_HTML += "</table><br><br><br>" MAIN_HTML += "<font color=\"FFFFFF\">If you want to be Noblesse first you need<br1>reach level <font color=\"FFFF00\">"+str(NOBLE_Level)+"</font> and get <font color=\"FFFF00\">"+str(NOBLE_NumITEM)+" "+str(getitemname(st,NOBLE_ITEMID))+"</font>.</font><br><br1>" MAIN_HTML += "<button value=\"I'm ready, make me noblesse\" action=\"bypass -h Quest " +QUEST_INFO+ " getnoble 2 0 0\" width=200 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" MAIN_HTML += "<br><font color=\"303030\">"+getmaster()+"</font>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def classmaster(st): classId = st.player.getClassId().getId() level = st.player.getLevel() jobLevel=st.getPlayer().getClassId().level() MAIN_HTML = "<html><title>Class Master</title><body><center>" if jobLevel ==2 and level > 75 or jobLevel ==1 and level > 39 or jobLevel ==0 and level > 19: MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">Change Subclass:<br1>Which class do you wish to change?</font><br><br1>" conn=L2DatabaseFactory.getInstance().getConnection() act = conn.prepareStatement("SELECT * FROM class_list WHERE parent_id = \""+str(classId)+"\"") rs=act.executeQuery() while (rs.next()) : try : xid = rs.getString("id") xclassname= getnames(st,xid) MAIN_HTML += "<button value=\""+xclassname+"\" action=\"bypass -h Quest " +QUEST_INFO+ " changeclass "+xid+" 0 0 0\" width=150 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" except : MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">There is no class change available<br>for you anymore.</font><br>" try : conn.close() except : pass else: if jobLevel ==0 and level < 20: MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">Come back here when you reach level 20<br1>to change your class.</font><br>" elif jobLevel <=1 and level < 40: MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">Come back here when you reach level 40<br1>to change your class.</font><br>" elif jobLevel <=2 and level < 76: MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">Come back here when you reach level 76<br1>to change your class.</font><br>" else: MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">There is no class change available<br>for you anymore.</font><br>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def getitemname(st,itemval): conn=L2DatabaseFactory.getInstance().getConnection() itemidList = conn.prepareStatement("SELECT * FROM etcitem WHERE item_id="+str(itemval)) il=itemidList.executeQuery() val = "0" if il : il.next() try : val = il.getString("name") except : pass try : conn.close() except: pass return val def subclassopcions(st,cases,id,index) : if st.player.isCastingNow() or st.player.isAllSkillsDisabled(): st.player.sendPacket(SystemMessage(SystemMessageId.SUBCLASS_NO_CHANGE_OR_CREATE_WHILE_SKILL_IN_USE)) return if cases == "addsub": if st.player.getTotalSubClasses() >= Config.MAX_SUBCLASS : if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass st.player.sendMessage("You can now only change one of your current sub classes.") return else: MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += subclasslist(st,"acceptsub",id,"0") MAIN_HTML += "</center></body></html>" return MAIN_HTML if cases == "acceptsub": if not st.player.addSubClass(int(id),st.player.getTotalSubClasses() + 1): st.player.sendMessage("The sub class could not be added.") return st.player.setActiveClass(st.player.getTotalSubClasses()) MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br>Add Subclass:<br>The sub class of <font color=\"LEVEL\">"+getnames(st,id)+"</font><br> has been added.<br>" MAIN_HTML += "</center></body></html>" st.player.sendPacket(SystemMessage(SystemMessageId.CLASS_TRANSFER)) return MAIN_HTML if cases == "acceptchangesub": if not st.player.setActiveClass(int(index)): if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass st.player.sendMessage("The sub class could not be changed.") return else: MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br>Change Subclass:<br>Your active class is now a:<br><font color=\"LEVEL\">"+getnames(st,id)+"</font>" MAIN_HTML += "</center></body></html>" st.player.sendPacket(SystemMessage(SystemMessageId.ADD_NEW_SUBCLASS)) if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass return MAIN_HTML if cases == "changesub": if st.player.getTotalSubClasses() > Config.MAX_SUBCLASS : st.player.sendMessage("You can now only delete one of your current sub classes.") if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass return else: i=0 MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">Change Subclass:<br1>Which sub class do you wish to change?</font><br><br1>" xcharid = st.getPlayer().getObjectId() conn=L2DatabaseFactory.getInstance().getConnection() sub = conn.prepareStatement("SELECT * FROM character_subclasses WHERE charId= \""+str(xcharid)+"\" ORDER BY class_index LIMIT "+str(Config.MAX_SUBCLASS)+"") ss=sub.executeQuery() if st.player.isSubClassActive(): MAIN_HTML += "<font color=\"LEVEL\">Main-class</font>" MAIN_HTML += "<button value=\""+getnames(st,str(st.player.getBaseClass()))+"\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass acceptchangesub "+str(st.player.getBaseClass())+",0\" width=150 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"><br>" while (ss.next()) : try: xsubclassid = ss.getString("class_id") xindex = ss.getString("class_index") xclassname= getnames(st,xsubclassid) i+=1 if int(st.player.getClassId().getId()) != int(xsubclassid): MAIN_HTML += "<font color=\"LEVEL\">Sub-class "+str(i)+"</font>" MAIN_HTML += "<button value=\""+xclassname+"\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass acceptchangesub "+xsubclassid+" "+xindex+"\" width=150 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" except : MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">There are no sub classes available<br>to change at this time.</font><br>" if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass MAIN_HTML += "</center></body></html>" try : conn.close() except : pass return MAIN_HTML if cases == "deletesub": if st.player.getTotalSubClasses() > Config.MAX_SUBCLASS : if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass st.player.sendMessage("You can now only delete one of your current sub classes.") return else: i=0 MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" MAIN_HTML += "<font color=\"FF0000\">Which sub class do you wish to delete?</font><br><br1>" conn=L2DatabaseFactory.getInstance().getConnection() xcharid = st.getPlayer().getObjectId() sub = conn.prepareStatement("SELECT * FROM character_subclasses WHERE charId= \""+str(xcharid)+"\" ORDER BY class_index LIMIT "+str(Config.MAX_SUBCLASS)+"") ss=sub.executeQuery() while (ss.next()) : try: xsubclassid = ss.getString("class_id") xindex = ss.getString("class_index") xclassname= getnames(st,xsubclassid) xlevel = ss.getInt("level") i+=1 MAIN_HTML += "<font color=\"LEVEL\">Sub-class "+str(i)+"</font>" MAIN_HTML += "<button value=\""+xclassname+"\" action=\"bypass -h Quest " +QUEST_INFO+ " getracemenu acceptnewsub "+xindex+" 0\" width=150 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" except : pass MAIN_HTML += "<br>If you change a sub class, you'll start at level 40<br1>after the 2nd class transfer." MAIN_HTML += "</center></body></html>" try : conn.close() except : pass if i !=0 : return MAIN_HTML else: if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass st.player.sendMessage("There are no sub classes available at this time.") if cases == "acceptnewsub": MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += subclasslist(st,"acceptdelsub",id,index) MAIN_HTML += "</center></body></html>" return MAIN_HTML if cases == "acceptdelsub": if st.player.modifySubClass(int(index), int(id)): st.player.stopAllEffects() st.player.setActiveClass(int(index)) MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br>Change Subclass:<br>Your sub class has been changed to<br1><font color=\"LEVEL\">"+getnames(st,id)+"</font>" MAIN_HTML += "</center></body></html>" st.player.sendPacket(SystemMessage(SystemMessageId.ADD_NEW_SUBCLASS)) if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass return MAIN_HTML else: player.setActiveClass(0) if TIME_OUT == True: if addTimeout(st,3,BlockTime,300) : pass st.player.sendMessage("The sub class could not be added, you have been reverted to your base class.") return def subclasslist(st,cases,case2,index) : baseClassId = st.player.getBaseClass() charClassId = st.player.getClassId().getId() xcharid = st.getPlayer().getObjectId() if charClassId >= 88 and charClassId <= 118 or charClassId >= 131 and charClassId <= 134 or charClassId == 136: if st.player.getClassId().getParent() != None: charClassId = st.player.getClassId().getParent().ordinal() num=0 temp="88" if case2 == "5": temp="131" avsubClass=[] yclassid="0" HTML = "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br>" if int(index) ==0: HTML += "<font color=\"FF0000\">Add Subclass:<br>Which sub class do you wish to add?</font><br><br1>" if int(index) > 0: HTML += "<font color=\"FF0000\">Please choose a new sub class to change to.</font><br1><font color=\"LEVEL\">Warning!</font> All classes and skills for this class<br1>will be removed." conn=L2DatabaseFactory.getInstance().getConnection() sub = conn.prepareStatement("SELECT * FROM character_subclasses WHERE charId= \""+str(xcharid)+"\"") ss=sub.executeQuery() while (ss.next()) : try : xsubclassid = ss.getInt("class_id") xlevel = ss.getInt("level") if xlevel <= 74 and int(index) ==0: num=1 avsubClass += [str(xsubclassid)] except : pass if num == 0 or st.player.getLevel() >= 75: act = conn.prepareStatement("SELECT * FROM char_templates WHERE RaceId="+case2+" AND ClassId NOT IN (\"115\",\"118\",\"135\") AND ClassId >= \""+temp+"\" ORDER BY RaceId, STR DESC, ClassName") rs=act.executeQuery() while (rs.next()) : try: xclassid = rs.getString("ClassId") yclassid = getsecondclass(st,xclassid) xclassname= getnames(st,yclassid) if str(charClassId) != yclassid and xclassid not in avsubClass and yclassid not in avsubClass and baseClassId != int(xclassid) and baseClassId != int(yclassid): HTML += "<button value=\""+xclassname+"\" action=\"bypass -h Quest " +QUEST_INFO+ " subclass "+cases+" "+yclassid+" "+index+"\" width=150 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">" except : pass try : conn.close() except : pass if yclassid == None or yclassid == "0": HTML = "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">There are no sub classes available<br> at this time.</font><br>" st.player.sendMessage("There are no sub classes available at this time.") if num == 1 or st.player.getLevel() < 75: HTML = "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">You may not add a new sub class before <br>you are level 75 on your previous class.</font><br>" return HTML def getsecondclass(st,const): con=L2DatabaseFactory.getInstance().getConnection() skillList = con.prepareStatement("SELECT * FROM class_list WHERE id = \""+const+"\"") sil=skillList.executeQuery() val = "0" if sil : sil.next() try : val = sil.getString("parent_id") except : pass try : con.close() except: pass return val def getnames(st,const): cn=L2DatabaseFactory.getInstance().getConnection() nameList = cn.prepareStatement("SELECT * FROM char_templates WHERE ClassId = \""+const+"\"") nl=nameList.executeQuery() val = "0" if nl : nl.next() try : val = nl.getString("ClassName") except : pass try : cn.close() except: pass return val def getVarcharacters(st,const): conn=L2DatabaseFactory.getInstance().getConnection() act = conn.prepareStatement("SELECT * FROM characters WHERE charId="+str(st.getPlayer().getObjectId())) rs=act.executeQuery() val = "0" if rs : rs.next() try : val = rs.getString(const) except : pass try : conn.close() except: pass return val def optionsymbol(st, cases,num): if cases == "draws": henna = HennaTreeTable.getInstance().getAvailableHenna(st.player.getClassId()) hel = HennaEquipList(st.player, henna) st.player.sendPacket(hel) elif cases == "deletes": MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>" MAIN_HTML += "<font color=\"FF0000\">.::Select symbol you would like to remove::.</font><br><br><br1>" hasHennas = False i=0 if num != "0": st.player.removeHenna(int(num)) while i <= 2 : i+=1 henna = st.player.getHenna(i) if henna != None: hasHennas = True MAIN_HTML += "<button value=\""+henna.getName()+"\" action=\"bypass -h Quest " +QUEST_INFO+ " symbol deletes "+str(i)+" 0\" width=120 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"><br>" if hasHennas == False: MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">You don't have any symbol to remove!</font><br>" MAIN_HTML += "</center></body></html>" return MAIN_HTML def noleader(st): MAIN_HTML = "<html><title>Services Manager</title><body><center>" MAIN_HTML += "<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><font color=\"FF0000\">You are not a Clan Leader.</font><br>" MAIN_HTML += "</center></body></html>" return MAIN_HTML