neto_rod

subclassNPC

Apr 26th, 2013
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 49.22 KB | None | 0 0
  1. import sys
  2. from com.l2jfrozen.gameserver.model.actor.instance import L2PcInstance
  3. from java.util import Iterator
  4. from com.l2jfrozen.util.database import L2DatabaseFactory
  5. from com.l2jfrozen.gameserver.model.quest import State
  6. from com.l2jfrozen.gameserver.model.quest import QuestState
  7. from com.l2jfrozen.gameserver.model.quest.jython import QuestJython as JQuest
  8. from com.l2jfrozen.gameserver.network.serverpackets import CharInfo
  9. from com.l2jfrozen.gameserver.network.serverpackets import UserInfo
  10. from com.l2jfrozen.gameserver.network.serverpackets import SetupGauge
  11. from com.l2jfrozen.gameserver.model.base import ClassId
  12. from com.l2jfrozen.gameserver.datatables.xml import ExperienceData
  13. from com.l2jfrozen.gameserver.managers import QuestManager
  14. from com.l2jfrozen.gameserver.datatables import SkillTable
  15. from com.l2jfrozen.gameserver.datatables.sql import SkillTreeTable
  16. from com.l2jfrozen.gameserver.model import L2Skill
  17.  
  18. NPC = [8000]
  19. QuestId = 855
  20. QuestName = "SubclassNpc"
  21. QuestDesc = "custom"
  22. QUEST_INFO = str(QuestId)+"_"+QuestName
  23.  
  24. print "INFO Loaded ClassMaster NPC"
  25.  
  26. #-------------------------------------------------------------------------------------------------------------------------------------
  27. # SETTINGS
  28. #-------------------------------------------------------------------------------------------------------------------------------------
  29.  
  30. #For more than 3 subclasses, you must increase the variable number into the SQL and add to the database.
  31. #inside the sql you will find some variables named SubclassidX. Just change the "X" increasing the number.
  32. #This value shouldn't be changed if you don't want to increase the subclasses number beyond 3.
  33. #Increase or decrease the "maxsubsindb" value without make these changes, will cause errors. Be carefull!.
  34. maxsubsindb = 3
  35.  
  36. #True, allows reloading the configuration script from the game, without restarting the server (for GMs only). False, disables it.
  37. ShowReloadScriptPanel = True
  38.  
  39. # Subclasses number that can be added. Must be less than or equal to "maxsubsindb".
  40. SubsNumber = 1
  41.  
  42. # True, allows add stackable subclasses in every original game subclass (Mainclass and every retails).
  43. # False, allows add stackable subclasses in only one original game subclass
  44. AllowMultiSubs = False
  45.  
  46. # True, allows any stackable subclass. False, allows add your own race's subclasses only.
  47. AllowAllSubs = False
  48.  
  49. #This option work if "AllowAllSubs = False", Also you need to be using a original game subclass (Retail) to get available this.
  50. #True, allow add a subclass with the same main class's race. False, allow add a subclass with the same Retail's race.
  51. AllowMutantRetail = True
  52.  
  53. #The next two options work if "AllowAllSubs = True" only.
  54. #True, allows everybody add Kamael subclass. False otherwise.
  55. AllowKamaelSubs = False
  56.  
  57. #True, allows Kamaels add any subclass. False, allows Kamaels to add their own race only.
  58. AllowAllSubsToKamael = False
  59.  
  60. #True, allows delete the main class or any subclass added. False, allow to delete added subclasses only. Default: False
  61. AllowDelMainClass = False
  62.  
  63. # Minimum Level to add a subclass. Default: 76
  64. MinLevel = 76
  65.  
  66. #True, allows add subsclasses if the character is a Noblesse only. False, otherwise. Default: False
  67. AllowOnlyNobles = False
  68.  
  69. #True, allow to add subclass or any other actions if you have the required items only. False, otherwise
  70. ReqItems = False
  71.  
  72. #Required Item to switch between the subclasses. Default: 57 (Adena)
  73. #Required items number.
  74. Item1_Req = 57
  75. Item1_Num = 1000000
  76.  
  77. #Required Item to add a subclass.
  78. #Required items number.
  79. Item2_Req = 3481
  80. Item2_Num = 100
  81.  
  82. #Required Item to delete subclasses.
  83. #Required items number.
  84. Item3_Req = 3481
  85. Item3_Num = 10
  86.  
  87. # True: Change level after add a subclass
  88. # False: Not to change level after add a subclass. Default: True
  89. DecLevel= True
  90.  
  91. # True: HTML will show 3rd Class trasfer to choose, also it disallow add subclasses if the characters haven't added 3rd job.
  92. # False: HTML Will show 2nd Class trasfer to choose, also it disallow add subclasses if the characters haven't added 2nd or 3rd job.
  93. AllowThirdJob = False
  94.  
  95. #Level at which the character will be changed after add a subclass. Default: 40
  96. NewLevel= 40
  97.  
  98. # True: The user must wait a while before take any action. Default: True
  99. # False: The user can do any action without time constraints. Not recommended
  100. Block = True
  101.  
  102. #Blocking time in seconds before take any action.
  103. BlockTime = 20
  104.  
  105. #-------------------------------------------------------------------------------------------------------------------------------------
  106.  
  107. def MainHtml(st) :
  108. xsubsamount=getsubsammount(st)
  109. if xsubsamount >= 0 :
  110. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  111. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  112. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  113. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  114. HTML_MESSAGE += "<tr><td></td></tr>"
  115. HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Before taking any action, make sure you</font></td></tr>"
  116. HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> are using the Main Class or the proper</font></td></tr>"
  117. HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Subclass, which requested the changes.</font></td></tr>"
  118. if ReqItems == True:
  119. HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Besides you need the required items.</font></td></tr>"
  120. HTML_MESSAGE += "<tr><td><br></td></tr>"
  121. if xsubsamount < SubsNumber and Item2_Num >= 1: HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Choose Sub: <font color=\"FFFF00\">"+str(Item2_Num)+" "+str(getitemname(st,Item2_Req))+"</font></font></td></tr>"
  122. if Item3_Num >= 1: HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Delete Sub: <font color=\"FFFF00\">"+str(Item3_Num)+" "+str(getitemname(st,Item3_Req))+"</font></font></td></tr>"
  123. if Item1_Num >= 1: HTML_MESSAGE += "<tr><td align=\"left\"><font color=\"0088EE\"> Switch Sub: <font color=\"FFFF00\">"+str(Item1_Num)+" "+str(getitemname(st,Item1_Req))+"</font></font></td></tr>"
  124. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  125. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  126. HTML_MESSAGE += "<tr><td width=90 align=\"center\"><table width=90 border=0 bgcolor=444444><tr><td width=90 align=\"center\"><table width=85 border=0 bgcolor=444444>"
  127. if xsubsamount < SubsNumber :
  128. HTML_MESSAGE += "<tr><td><button value=\"Choose Sub\" action=\"bypass -h Quest " +QUEST_INFO + " gethtml 1\" width=80 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br1>"
  129. HTML_MESSAGE += "<tr><td><button value=\"Delete Sub\" action=\"bypass -h Quest " +QUEST_INFO + " gethtml 3\" width=80 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br1>"
  130. HTML_MESSAGE += "<tr><td><button value=\"Switch Sub\" action=\"bypass -h Quest " +QUEST_INFO + " gethtml 2\" width=80 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br1>"
  131. HTML_MESSAGE += "</table></td></tr></table></td></tr>"
  132. HTML_MESSAGE += "</center></body></html>"
  133. return HTML_MESSAGE
  134. else:
  135. if st.getQuestItemsCount(Item2_Req) < Item2_Num and ReqItems == True: return comunerrors(st,"0")
  136. if getVarcharacters(st,"race") == "5" and AllowAllSubsToKamael == False : return MainHtmlIV(st,"5")
  137. if AllowAllSubs == False :
  138. if AllowMutantRetail == False and st.player.isSubClassActive(): return MainHtmlIV(st,getclassname(st,str(st.player.getClassId().getId()),"RaceId"))
  139. else: return MainHtmlIV(st,getVarcharacters(st,"race"))
  140. else: return MainHtmlI(st)
  141.  
  142. def MainHtmlI(st) :
  143. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  144. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  145. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  146. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  147. HTML_MESSAGE += "<tr><td></td></tr>"
  148. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Choose a Race</font></td></tr>"
  149. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  150. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br><br>"
  151. HTML_MESSAGE += "<tr><td width=110 align=\"center\"><table width=110 border=0 bgcolor=444444><tr><td width=110 align=\"center\"><table width=105 border=0 bgcolor=444444>"
  152. HTML_MESSAGE += "<tr><td><button value=\"Human\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 0\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  153. HTML_MESSAGE += "<tr><td><button value=\"Elf\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 1\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  154. HTML_MESSAGE += "<tr><td><button value=\"Dark Elf\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 2\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  155. HTML_MESSAGE += "<tr><td><button value=\"Orc\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 3\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  156. HTML_MESSAGE += "<tr><td><button value=\"Dwarf\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 4\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  157. if AllowKamaelSubs == True or getVarcharacters(st,"race") == "5":
  158. HTML_MESSAGE += "<tr><td><button value=\"Kamael\" action=\"bypass -h Quest " +QUEST_INFO + " escraza 5\" width=100 height=20 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  159. HTML_MESSAGE += "</table></td></tr></table></td></tr>"
  160. HTML_MESSAGE += "</center></body></html>"
  161. return HTML_MESSAGE
  162.  
  163. def MainHtmlII(st) :
  164. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  165. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  166. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  167. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  168. HTML_MESSAGE += "<tr><td></td></tr>"
  169. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Choose a subclass to Switch</font></td></tr>"
  170. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  171. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br><br>"
  172. HTML_MESSAGE += "<tr><td width=140 align=\"center\"><table width=140 border=0 bgcolor=444444><tr><td width=140 align=\"center\"><table width=135 border=0 bgcolor=444444>"
  173. temp = getVar(st,"currentsub"); j=-1
  174. for i in range(maxsubsindb + 1):
  175. var = getVar(st,"subclassid"+str(i))
  176. if int(var) >= 0 and int(var) <= 136:
  177. j+=1
  178. if temp != str(i) and SubsNumber >= j:
  179. HTML_MESSAGE += "<tr><td><button value=\""+getclassname(st,var,"ClassName")+"\" action=\"bypass -h Quest " +QUEST_INFO + " camb "+str(i)+"\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  180. HTML_MESSAGE += "</table></td></tr></table></td></tr>"
  181. HTML_MESSAGE += "</center></body></html>"
  182. return HTML_MESSAGE
  183.  
  184. def MainHtmlIII(st) :
  185. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  186. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  187. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  188. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  189. HTML_MESSAGE += "<tr><td></td></tr>"
  190. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Choose the class you want to delete</font></td></tr>"
  191. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  192. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br><br>"
  193. HTML_MESSAGE += "<tr><td width=140 align=\"center\"><table width=140 border=0 bgcolor=444444><tr><td width=130 align=\"center\"><table width=135 border=0 bgcolor=444444>"
  194. j=-1
  195. for i in range(maxsubsindb + 1):
  196. var = getVar(st,"subclassid"+str(i))
  197. if int(var) >= 0 and int(var) <= 136:
  198. if i == 0 and AllowDelMainClass == False: pass
  199. else:
  200. j+=1
  201. if SubsNumber >= j:
  202. HTML_MESSAGE += "<tr><td><button value=\""+getclassname(st,var,"ClassName")+"\" action=\"bypass -h Quest " +QUEST_INFO + " confirm "+str(i)+"\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr><br>"
  203. HTML_MESSAGE += "</table></td></tr></table></td></tr>"
  204. HTML_MESSAGE += "</center></body></html>"
  205. return HTML_MESSAGE
  206.  
  207. def MainHtmlIV(st,case) :
  208. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  209. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  210. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  211. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  212. HTML_MESSAGE += "<tr><td></td></tr>"
  213. HTML_MESSAGE += generateRace(st,case)
  214. HTML_MESSAGE += "</center></body></html>"
  215. return HTML_MESSAGE
  216.  
  217. def MainHtmlV(st) :
  218. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  219. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font><br>"
  220. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  221. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"LEVEL\">Confirmation</font></td></tr></table><br>"
  222. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  223. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  224. HTML_MESSAGE += "<tr><td><br></td></tr>"
  225. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF0000\">This option can be seen by GMs only and it<br1>allow to update any changes made in the<br1>script. You can disable this option in<br1>the settings section within the Script.<br><font color=\"LEVEL\">Do you want to update the SCRIPT?</font></font></td></tr>"
  226. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  227. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br><br>"
  228. HTML_MESSAGE += "<button value=\"Yes\" action=\"bypass -h Quest "+QUEST_INFO+" reloadscript 1\" width=50 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">"
  229. HTML_MESSAGE += "<button value=\"No\" action=\"bypass -h Quest "+QUEST_INFO+" reloadscript 0\" width=50 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">"
  230. HTML_MESSAGE += "</center></body></html>"
  231. return HTML_MESSAGE
  232.  
  233. def generateRace(st,raceclass) :
  234. if raceclass == "0": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">HUMAN</font></td></tr>"
  235. if raceclass == "1": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">ELF</font></td></tr>"
  236. if raceclass == "2": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">DARK ELF</font></td></tr>"
  237. if raceclass == "3": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">ORC</font></td></tr>"
  238. if raceclass == "4": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">DWARF</font></td></tr>"
  239. if raceclass == "5": HTML = "<tr><td align=\"center\"><font color=\"0088EE\">KAMAEL</font></td></tr>"
  240. HTML += "<tr><td></td></tr></table><br><img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  241. if raceclass == "5": HTML += "<tr><td align=\"center\"><font color=\"0088EE\">Man Woman</font></td></tr>"
  242. elif raceclass == "4": HTML += "<tr><td align=\"center\"><font color=\"0088EE\">Figther</font></td></tr>"
  243. else: HTML += "<tr><td align=\"center\"><font color=\"0088EE\">Figther Mage</font></td></tr>"
  244. HTML += "<tr><td width=250 align=\"center\"><table width=240 border=0 bgcolor=444444><tr><td width=240 align=\"center\"><table width=235 border=0 bgcolor=444444><tr>"
  245.  
  246. if raceclass == "0":
  247. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"92"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 92\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  248. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"98"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 98\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  249. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"93"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 93\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  250. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"97"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 97\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  251. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"88"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 88\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  252. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"96"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 96\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  253. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"89"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 89\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  254. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"95"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 95\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  255. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"90"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 90\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  256. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"94"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 94\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  257. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"91"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 91\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  258. if raceclass == "1":
  259. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"102"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 102\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  260. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"105"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 105\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  261. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"101"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 101\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  262. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"103"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 103\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  263. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"100"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 100\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  264. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"104"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 104\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  265. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"99"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 99\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  266. if raceclass == "2":
  267. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"109"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 109\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  268. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"112"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 112\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  269. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"108"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 108\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  270. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"110"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 110\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  271. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"107"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 107\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  272. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"111"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 111\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  273. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"106"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 106\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  274. if raceclass == "3":
  275. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"114"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 114\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  276. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"116"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 116\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  277. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"113"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 113\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  278. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"115"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 115\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  279. if raceclass == "4":
  280. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"118"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 118\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  281. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"117"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 117\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  282. if raceclass == "5":
  283. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"131"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 131\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  284. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"134"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 134\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  285. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"132"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 132\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td>"
  286. HTML += "<td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"133"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 133\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  287. HTML += "<tr><td align=\"center\"><button value=\""+getclassname(st,getparentclass(st,"136"),"ClassName")+"\" action=\"bypass -h Quest " + QUEST_INFO + " confirm 136\" width=130 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\"></td></tr>"
  288. HTML += "</table></td></tr></table></td></tr>"
  289. return HTML
  290.  
  291. def Confirmation(st,case,case1,case2):
  292. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  293. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font><br>"
  294. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  295. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"LEVEL\">Confirmation</font></td></tr></table><br>"
  296. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  297. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  298. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  299. if int(case) == 1 :
  300. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Do you really want to add the<br1><font color=\"FFFF00\">"+getclassname(st,case1,"ClassName")+"</font> subclass?</td></tr>"
  301. if int(case) == 3 :
  302. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Do you really want to delete the<br1><font color=\"FFFF00\">"+getclassname(st,getVar(st,"subclassid"+case2),"ClassName")+"</font> subclass?</td></tr>"
  303. HTML_MESSAGE += "<tr><td></td></tr></table><br>"
  304. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br><br>"
  305. HTML_MESSAGE += "<button value=\"Yes\" action=\"bypass -h Quest "+QUEST_INFO+" "+case1+" "+case2+"\" width=50 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">"
  306. HTML_MESSAGE += "<button value=\"No\" action=\"bypass -h Quest "+QUEST_INFO+" gethtml "+case+"\" width=50 height=25 back=\"L2UI_ct1.button_df\" fore=\"L2UI_ct1.button_df\">"
  307. HTML_MESSAGE += "</center></body></html>"
  308. return HTML_MESSAGE
  309.  
  310. def complete(st) :
  311. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  312. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  313. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  314. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  315. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  316. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Congratulations</font></td></tr>"
  317. HTML_MESSAGE += "<tr><td></td></tr>"
  318. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">Class changed successfully</font></td></tr>"
  319. HTML_MESSAGE += "<tr><td><br><br></td></tr></table><br>"
  320. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  321. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"00FF00\">To complete the change<br1>you must restart the game.</font></td></tr></table><br>"
  322. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1>"
  323. HTML_MESSAGE += "</center></body></html>"
  324. if getblocktime(st) == True : pass
  325. return HTML_MESSAGE
  326.  
  327. def errasecomplete(st) :
  328. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  329. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font>"
  330. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  331. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  332. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  333. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"0088EE\">The class that you chose has been deleted</font></td></tr>"
  334. HTML_MESSAGE += "<tr><td><br><br></td></tr></table><br>"
  335. HTML_MESSAGE += "<table width=250 border=0 bgcolor=444444>"
  336. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"00FF00\">Is advisable to restart the game</font></td></tr></table><br>"
  337. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1>"
  338. HTML_MESSAGE += "</center></body></html>"
  339. if getblocktime(st) == True : pass
  340. return HTML_MESSAGE
  341.  
  342. def errordeclasse(st,case,case2) :
  343. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  344. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font><br>"
  345. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  346. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF5500\">Error</font></td></tr></table><br>"
  347. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  348. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  349. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  350. if int(case) >= 88 :
  351. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You can't add <font color=\"FFFF00\">"+getclassname(st,case2,"ClassName")+"</font> subclass.<br1>Talk to a Grand Master and switch<br1>to the proper class first.</td></tr>"
  352. else:
  353. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You can't "+case2+" <font color=\"FFFF00\">"+getclassname(st,getVar(st,"subclassid"+case),"ClassName")+"</font><br1>subclass. Talk to a Grand Master and<br1>switch to the proper class first.</td></tr>"
  354. HTML_MESSAGE += "<tr><td><br><br></td></tr></table><br>"
  355. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1>"
  356. HTML_MESSAGE += "</center></body></html>"
  357. if getblocktime(st) == True : pass
  358. return HTML_MESSAGE
  359.  
  360. def errordeduplicado(st,numero) :
  361. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  362. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font><br>"
  363. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  364. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF5500\">Error</font></td></tr></table><br>"
  365. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1><br>"
  366. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  367. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  368. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You can't add <font color=\"FFFF00\">"+getclassname(st,numero,"ClassName")+"</font><br1>subclass. You already have this class.</td></tr>"
  369. HTML_MESSAGE += "<tr><td><br><br></td></tr></table><br>"
  370. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=250 height=1>"
  371. HTML_MESSAGE += "</center></body></html>"
  372. if getblocktime(st) == True : pass
  373. return HTML_MESSAGE
  374.  
  375. def comunerrors(st,case) :
  376. HTML_MESSAGE = "<html><head><title>Subclass Master</title></head><body><center><img src=\"L2UI_CH3.herotower_deco\" width=256 height=32><br><br>"
  377. HTML_MESSAGE += "<font color=\"303030\">"+getmaster(st)+"</font><br>"
  378. HTML_MESSAGE += "<table width=260 border=0 bgcolor=444444>"
  379. HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF5500\">Error</font></td></tr></table><br>"
  380. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=220 height=1><br>"
  381. HTML_MESSAGE += "<table width=220 border=0 bgcolor=444444>"
  382. HTML_MESSAGE += "<tr><td><br><br></td></tr>"
  383. if case == "0": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You don't meet this NPC's minimum<br1>required items. Come back when you<br1>get <font color=\"FFFF00\">"+str(Item2_Num)+" "+str(getitemname(st,Item2_Req))+".</font></td></tr>"
  384. if case == "1": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You don't have the required items.<br1>You need <font color=\"FFFF00\">"+str(Item1_Num)+" "+str(getitemname(st,Item1_Req))+"</font></td></tr>"
  385. if case == "2": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You don't have the required items.<br1>You need <font color=\"FFFF00\">"+str(Item2_Num)+" "+str(getitemname(st,Item2_Req))+"</font></td></tr>"
  386. if case == "3": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You don't have the required items.<br1>You need <font color=\"FFFF00\">"+str(Item3_Num)+" "+str(getitemname(st,Item3_Req))+"</font></td></tr>"
  387. if case == "4": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You aren't eligible to add a<br1>subclass at this time.<br1>Your level must have <font color=\"FFFF00\">"+str(MinLevel)+" or above.</font></td></tr>"
  388. if case == "5":
  389. if AllowThirdJob == True: HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You aren't eligible to do any action<br1>at this time. Your current ocupation<br1>must have <font color=\"FFFF00\">3rd Job</font></td></tr>"
  390. else: HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You aren't eligible to do any action<br1>at this time. Your current ocupation<br1>must be <font color=\"FFFF00\">2nd or 3rd Job</font></td></tr>"
  391. if case == "6": HTML_MESSAGE += "<tr><td align=\"center\"><font color=\"FF7700\">You aren't eligible to add a<br1>subclass at this time.<br1>You must be a <font color=\"FFFF00\">Noblesse</font></td></tr>"
  392. HTML_MESSAGE += "<tr><td><br><br></td></tr></table><br>"
  393. HTML_MESSAGE += "<img src=\"L2UI.SquareGray\" width=220 height=1>"
  394. HTML_MESSAGE += "</center></body></html>"
  395. if getblocktime(st) == True : pass
  396. return HTML_MESSAGE
  397.  
  398. def ReloadConfig(st) :
  399. try:
  400. if QuestManager.getInstance().reload(QuestId): st.player.sendMessage("The script and settings have been reloaded successfully.")
  401. else: st.player.sendMessage("Script Reloaded Failed. you edited something wrong! :P, fix it and restart the server")
  402. except: st.player.sendMessage("Script Reloaded Failed. you edited something wrong! :P, fix it and restart the server")
  403. return MainHtml(st)
  404.  
  405. def getblocktime(st):
  406. if Block == True and not st.player.isGM() :
  407. endtime = int(System.currentTimeMillis()/1000) + BlockTime
  408. st.set("blockUntilTime",str(endtime))
  409. st.getPlayer().sendPacket(SetupGauge(3, BlockTime * 1000 + 300))
  410. val = True
  411. return val
  412.  
  413. def getVar(st,const):
  414. conn=L2DatabaseFactory.getInstance().getConnection()
  415. act = conn.prepareStatement("SELECT * FROM subclass_list WHERE player_id="+getmultisubs(st))
  416. rs=act.executeQuery()
  417. val = "-1"
  418. if rs :
  419. rs.next()
  420. try :
  421. val = rs.getString(const)
  422. conn.close()
  423. except :
  424. try : conn.close()
  425. except: pass
  426. return val
  427.  
  428. def getsubsammount(st):
  429. j=-1
  430. for i in range(maxsubsindb + 1):
  431. var = getVar(st,"subclassid"+str(i))
  432. if int(var) >= 0 and int(var) <= 136:
  433. j+=1
  434. return j
  435.  
  436. def getVarcharacters(st,const):
  437. conn=L2DatabaseFactory.getInstance().getConnection()
  438. act = conn.prepareStatement("SELECT * FROM characters WHERE charId="+str(st.getPlayer().getObjectId()))
  439. rs=act.executeQuery()
  440. val = "0"
  441. if rs :
  442. rs.next()
  443. try :
  444. val = rs.getString(const)
  445. conn.close()
  446. except :
  447. try : conn.close()
  448. except: pass
  449. return val
  450.  
  451. def getVarcharactersubs(st):
  452. conn=L2DatabaseFactory.getInstance().getConnection()
  453. act = conn.prepareStatement("SELECT * FROM subclass_list WHERE player_id="+getmultisubs(st))
  454. rs=act.executeQuery()
  455. val = ""
  456. if rs :
  457. rs.next()
  458. for i in range(maxsubsindb + 1):
  459. try : val += rs.getString("subclassid"+str(i)) + " "
  460. except : val += str(st.player.getClassId().getId()) + " "
  461. try : conn.close()
  462. except: pass
  463. val+= "-1"
  464. return val
  465.  
  466. def getclassname(st,case1,case2):
  467. conn=L2DatabaseFactory.getInstance().getConnection()
  468. act = conn.prepareStatement("SELECT * FROM char_templates WHERE ClassId="+case1)
  469. rs=act.executeQuery()
  470. if rs :
  471. rs.next()
  472. try :
  473. val = rs.getString(case2)
  474. conn.close()
  475. except :
  476. val = "0"
  477. try : conn.close()
  478. except: pass
  479. else : val = "0"
  480. return val
  481.  
  482. def getitemname(st,itemval):
  483. conn=L2DatabaseFactory.getInstance().getConnection()
  484. itemidList = conn.prepareStatement("SELECT * FROM etcitem WHERE item_id="+str(itemval))
  485. il=itemidList.executeQuery()
  486. if il :
  487. il.next()
  488. try :
  489. val = il.getString("name")
  490. conn.close()
  491. except :
  492. val = "0"
  493. try : conn.close()
  494. except: pass
  495. else : val = "0"
  496. return val
  497.  
  498. def getparentclass(st,case):
  499. val=case
  500. if AllowThirdJob == False:
  501. conn=L2DatabaseFactory.getInstance().getConnection()
  502. parentid = conn.prepareStatement("SELECT * FROM class_list WHERE id = \""+case+"\"")
  503. pi=parentid.executeQuery()
  504. if pi :
  505. pi.next()
  506. try : val = pi.getString("parent_id")
  507. except : pass
  508. try : conn.close()
  509. except: pass
  510. return val
  511.  
  512. def getmaxskilllevel(st,case):
  513. val= 0
  514. com=L2DatabaseFactory.getInstance().getConnection()
  515. lvlskillid = com.prepareStatement("SELECT * FROM skill_trees WHERE skill_id = \""+case+"\" AND min_level <= \"85\" ORDER BY level DESC LIMIT 1")
  516. lvl=lvlskillid.executeQuery()
  517. if lvl :
  518. lvl.next()
  519. try :
  520. val = lvl.getInt("level")
  521. com.close()
  522. except :
  523. try : com.close()
  524. except: pass
  525. return val
  526.  
  527. def getmultisubs(st):
  528. val= str(st.getPlayer().getObjectId()) + " LIMIT 1"
  529. if AllowMultiSubs == True:
  530. val= str(st.getPlayer().getObjectId()) +" AND sub_index=" + str(st.player.getClassIndex()) +" LIMIT 1"
  531. return val
  532.  
  533. def getmaster(st):
  534. xi="class";xe="l";xf="e";xg="n";xa="B";xb="y";xc=" ";xd="A";xk="ter";xh="Sub";xj="Mas";val=xh+xi+xc+xj+xk+xc+xa+xb+xc+xd+xe+xe+xf+xg
  535. #val="Change Title here :P"
  536. return val
  537.  
  538. def resetskills(st):
  539. parametros = "\"-1\""; j=-1
  540. subs=getVarcharactersubs(st)
  541. SubSplit = subs.split(" ")
  542. for k in range(maxsubsindb + 1):
  543. conn=L2DatabaseFactory.getInstance().getConnection()
  544. if int(SubSplit[int(k)]) >= 0 and int(SubSplit[int(k)]) <= 136: j+=1
  545. if int(SubSplit[int(k)]) >= 0 and int(SubSplit[int(k)]) <= 136 and SubsNumber >= j:
  546. xclassid = int(SubSplit[int(k)])
  547. skillidList = conn.prepareStatement("SELECT * FROM class_list WHERE id = \""+str(xclassid)+"\"")
  548. sil=skillidList.executeQuery()
  549. while (sil.next()) :
  550. try :
  551. parametros+=",\"" +str(xclassid)+ "\""
  552. xclassid = sil.getInt("parent_id")
  553. skillidList = conn.prepareStatement("SELECT * FROM class_list WHERE id = \""+str(xclassid)+"\"")
  554. sil=skillidList.executeQuery()
  555. except : pass
  556. try : conn.close()
  557. except : pass
  558. conn=L2DatabaseFactory.getInstance().getConnection()
  559. listskillid = conn.prepareStatement("SELECT * FROM skill_trees WHERE class_id IN ("+parametros+") AND min_level <= \"85\" ORDER BY skill_id DESC, level DESC")
  560. lis=listskillid.executeQuery()
  561. xskill = 0; cskill = 0; i=0
  562. availableSkillsB = ""
  563. while (lis.next()) :
  564. try :
  565. xskill = lis.getInt("skill_id")
  566. if xskill != cskill :
  567. xlevel = lis.getInt("level")
  568. cskill = xskill
  569. i=i+1
  570. availableSkillsB += str(xskill)+"_"+str(xlevel)+" "
  571. except : pass
  572.  
  573. skills_exceptions = conn.prepareStatement("SELECT * FROM subclass_skill_exceptions WHERE class_id IN ("+parametros+") ORDER BY skill_id DESC, level DESC")
  574. se=skills_exceptions.executeQuery()
  575. while (se.next()) :
  576. try :
  577. xskill = se.getInt("skill_id")
  578. if xskill != cskill :
  579. xlevel = se.getInt("level")
  580. cskill = xskill
  581. i=i+1
  582. availableSkillsB += str(xskill)+"_"+str(xlevel)+" "
  583. except : pass
  584.  
  585. availableSkillsB+= "0_0"
  586. xvar="AND skill_id NOT BETWEEN \"1312\" AND \"1315\" AND skill_id NOT BETWEEN \"1368\" AND \"1372\""
  587. if st.player.isGM(): xvar+=" AND skill_id NOT BETWEEN \"7029\" AND \"7064\""
  588. listallskill = conn.prepareStatement("SELECT * FROM character_skills WHERE charId =\""+str(st.player.getObjectId())+"\" AND class_index =\""+str(st.player.getClassIndex())+"\" "+xvar+"")
  589. las=listallskill.executeQuery()
  590. availableSkillsA = []
  591. while (las.next()) :
  592. try :
  593. xskill = las.getInt("skill_id")
  594. xlevel = las.getInt("skill_level")
  595. availableSkillsA += [str(xskill)+"_"+str(xlevel)]
  596. except : pass
  597. try : conn.close()
  598. except : pass
  599. try:
  600. skillSplit = availableSkillsB.split(" ")
  601. for avSkillsA in availableSkillsA :
  602. j=0; temp=0
  603. while j <= i:
  604. j=j+1
  605. parametro = skillSplit[j-1].replace("_"," ")
  606. skillSplitB = parametro.split(" ")
  607. avSkillsA = avSkillsA.replace("_"," ")
  608. skillSplitA = avSkillsA.split(" ")
  609. if int(skillSplitB[0]) == int(skillSplitA[0]):
  610. temp=1
  611. if int(skillSplitA[1]) < 100 :
  612. if int(skillSplitB[1]) < int(skillSplitA[1]):
  613. re = SkillTable.getInstance().getInfo(int(skillSplitA[0]), int(skillSplitA[1]))
  614. st.player.removeSkill(re)
  615. sk = SkillTable.getInstance().getInfo(int(skillSplitB[0]), int(skillSplitB[1]))
  616. st.player.addSkill(sk, True)
  617. st.player.sendMessage("You got fixed "+sk.getName()+" Skill.")
  618. else:
  619. if int(skillSplitB[1]) < getmaxskilllevel(st,skillSplitB[0]):
  620. re = SkillTable.getInstance().getInfo(int(skillSplitA[0]), int(skillSplitA[1]))
  621. st.player.removeSkill(re)
  622. sk = SkillTable.getInstance().getInfo(int(skillSplitB[0]), int(skillSplitB[1]))
  623. st.player.addSkill(sk, True)
  624. st.player.sendMessage("You got fixed "+sk.getName()+" Skill.")
  625. if temp == 0 :
  626. sk = SkillTable.getInstance().getInfo(int(skillSplitA[0]), int(skillSplitA[1]))
  627. st.player.removeSkill(sk)
  628. st.player.sendMessage("You got removed "+sk.getName()+" Skill.")
  629. except : st.player.sendMessage("You dont have skills to remove")
  630. st.player.sendSkillList()
  631. if st.player.isNoble(): st.player.setNoble(True)
  632. if st.player.isHero(): st.player.setHero(True)
  633.  
  634. val=0
  635. return val
  636.  
  637. class Quest (JQuest) :
  638.  
  639. def __init__(self,id,name,descr): JQuest.__init__(self,id,name,descr)
  640.  
  641. def onEvent(self,event,st):
  642. st.player.getStat().addExp(0)
  643. eventSplit = event.split(" ")
  644. event = eventSplit[0]
  645. eventParam1 = eventSplit[1]
  646.  
  647. if event == "reloadscript":
  648. if eventParam1 == "1": return ReloadConfig(st)
  649. if eventParam1 == "0": return MainHtml(st)
  650. if event == "escraza": return MainHtmlIV(st,eventParam1)
  651. if event == "confirm":
  652. if int(eventParam1) >= 88: return Confirmation(st,"1",getparentclass(st,eventParam1),eventParam1)
  653. else: return Confirmation(st,"3","deletesub",eventParam1)
  654. if event == "gethtml":
  655. if eventParam1 == "1":
  656. if getVarcharacters(st,"race") == "5" and AllowAllSubsToKamael == False : return MainHtmlIV(st,"5")
  657. if AllowAllSubs == False :
  658. if AllowMutantRetail == False and st.player.isSubClassActive(): return MainHtmlIV(st,getclassname(st,str(st.player.getClassId().getId()),"RaceId"))
  659. else: return MainHtmlIV(st,getVarcharacters(st,"race"))
  660. else: return MainHtmlI(st)
  661. if eventParam1 == "2": return MainHtmlII(st)
  662. if eventParam1 == "3": return MainHtmlIII(st)
  663. return
  664.  
  665. temp = getVar(st,"currentsub")
  666. temp2 = getVar(st,"sub_index")
  667. temp3 = str(st.player.getClassIndex())
  668. temp4 = str(st.player.getClassId().getId())
  669.  
  670. if event == "camb":
  671. if temp2!=temp3: return errordeclasse(st,eventParam1,"switch to")
  672. elif st.getPlayer().getClassId().level() < 2 and AllowThirdJob == False or st.getPlayer().getClassId().level() < 3 and AllowThirdJob == True : return comunerrors(st,"5")
  673. elif st.getQuestItemsCount(Item1_Req) < Item1_Num and ReqItems == True: return comunerrors(st,"1")
  674. else:
  675. conn=L2DatabaseFactory.getInstance().getConnection()
  676. upd=conn.prepareStatement("UPDATE subclass_list SET subclassid"+temp+"="+temp4+", currentsub="+eventParam1+" WHERE player_id="+getmultisubs(st))
  677. try :
  678. upd.executeUpdate()
  679. upd.close()
  680. conn.close()
  681. except :
  682. try : conn.close()
  683. except : pass
  684. if resetskills(st) == 1: pass
  685. st.player.setClassId(int(getVar(st,"subclassid"+eventParam1)))
  686. if not st.player.isSubClassActive(): st.player.setBaseClass(int(getVar(st,"subclassid"+eventParam1)))
  687. if ReqItems == True and not st.player.isGM(): st.takeItems(Item1_Req,Item1_Num)
  688. st.player.store()
  689. st.player.broadcastUserInfo()
  690. return complete(st)
  691. st.exitQuest(1)
  692.  
  693. if event == "deletesub":
  694.  
  695. if temp2!=temp3: return errordeclasse(st,eventParam1,"delete the")
  696. elif st.getPlayer().getClassId().level() < 2 and AllowThirdJob == False or st.getPlayer().getClassId().level() < 3 and AllowThirdJob == True : return comunerrors(st,"5")
  697. elif st.getQuestItemsCount(Item3_Req) < Item3_Num and ReqItems == True and not st.player.isGM() : return comunerrors(st,"3")
  698. else:
  699. conn=L2DatabaseFactory.getInstance().getConnection()
  700. upd=conn.prepareStatement("UPDATE subclass_list SET subclassid"+temp+"="+temp4+", currentsub="+temp+" WHERE player_id="+getmultisubs(st))
  701. try :
  702. upd.executeUpdate()
  703. upd.close()
  704. conn.close()
  705. except :
  706. try : conn.close()
  707. except : pass
  708.  
  709. if eventParam1 == temp and getsubsammount(st) > 0:
  710. j=0
  711. for i in range(maxsubsindb + 1):
  712. var = getVar(st,"subclassid"+str(i))
  713. if int(var) >= 0 and int(var) <= 136 and j == 0 and str(i) != temp:
  714. j+=1; idsubclass = var; temp=str(i)
  715. st.player.setClassId(int(idsubclass))
  716. if not st.player.isSubClassActive(): st.player.setBaseClass(int(idsubclass))
  717. con=L2DatabaseFactory.getInstance().getConnection()
  718. if getsubsammount(st) <= 1: rem=con.prepareStatement("DELETE FROM subclass_list WHERE player_id="+getmultisubs(st))
  719. else: rem = con.prepareStatement("UPDATE subclass_list SET subclassid"+eventParam1+"=-1 ,currentsub="+temp+" WHERE player_id="+getmultisubs(st))
  720. try : rem.executeUpdate()
  721. except : pass
  722. try : con.close()
  723. except : pass
  724. if resetskills(st) == 1: pass
  725. if ReqItems == True and not st.player.isGM(): st.takeItems(Item3_Req,Item3_Num)
  726. st.player.store()
  727. st.player.broadcastUserInfo()
  728. return errasecomplete(st)
  729. st.exitQuest(1)
  730.  
  731. else:
  732. if temp2!=temp3 and getsubsammount(st) >= 0 : return errordeclasse(st,eventParam1,event)
  733. elif AllowOnlyNobles == True and not st.player.isGM() :
  734. if not st.player.isNoble() : return comunerrors(st,"6")
  735. elif st.getQuestItemsCount(Item2_Req) < Item2_Num and ReqItems == True and not st.player.isGM() : return comunerrors(st,"2")
  736. elif st.getPlayer().getLevel() < MinLevel and not st.player.isGM() : return comunerrors(st,"4")
  737. elif st.getPlayer().getClassId().level() < 2 and AllowThirdJob == False or st.getPlayer().getClassId().level() < 3 and AllowThirdJob == True : return comunerrors(st,"5")
  738. else:
  739. if temp4 == eventParam1 or temp4 == event: return errordeduplicado(st,event)
  740. else:
  741. con=L2DatabaseFactory.getInstance().getConnection()
  742. if getsubsammount(st) == -1 :
  743. ins = con.prepareStatement("INSERT INTO subclass_list (player_id,currentsub,sub_index,subclassid0,subclassid1) VALUES (?,?,?,?,?)")
  744. ins.setString(1, str(st.player.getObjectId()))
  745. ins.setString(2, "1")
  746. ins.setString(3, str(st.player.getClassIndex()))
  747. ins.setString(4, temp4)
  748. ins.setString(5, event)
  749. else:
  750. temp6 = "-1"; j=0
  751. for i in range(maxsubsindb + 1):
  752. var = getVar(st,"subclassid"+str(i))
  753. if var == eventParam1 or var == event: return errordeduplicado(st,event)
  754. if int(var) < 0 or int(var) > 136:
  755. if temp6 == "-1" and j==0:
  756. j+=1
  757. temp6 = str(i)
  758. ins = con.prepareStatement("UPDATE subclass_list SET subclassid"+temp6+"="+event+", subclassid"+temp+"="+temp4+", currentsub="+temp6+" WHERE player_id="+getmultisubs(st))
  759. try :
  760. ins.executeUpdate()
  761. ins.close()
  762. con.close()
  763. except : pass
  764. if resetskills(st) == 1: pass
  765. if ReqItems == True and not st.player.isGM() : st.takeItems(Item2_Req,Item2_Num)
  766. if DecLevel == True and not st.player.isGM() :
  767. pXp = st.player.getExp()
  768. tXp = ExperienceData.LEVEL[NewLevel]
  769. if pXp > tXp: st.player.removeExpAndSp(pXp - tXp, 0)
  770. st.player.setClassId(int(event))
  771. if not st.player.isSubClassActive(): st.player.setBaseClass(int(event))
  772. st.player.store()
  773. st.player.broadcastUserInfo()
  774. return complete(st)
  775. st.exitQuest(1)
  776.  
  777. def onFirstTalk (self,npc,player):
  778. st = player.getQuestState(QUEST_INFO)
  779. if not st : st = self.newQuestState(player)
  780. if player.isGM():
  781. if ShowReloadScriptPanel == True: return MainHtmlV(st)
  782. else: return MainHtml(st)
  783. elif int(System.currentTimeMillis()/1000) > st.getInt("blockUntilTime"):return MainHtml(st)
  784. else: return
  785.  
  786. QUEST = Quest(QuestId,QUEST_INFO,QuestDesc)
  787.  
  788. for npcId in NPC:
  789. QUEST.addStartNpc(npcId)
  790. QUEST.addFirstTalkId(npcId)
  791. QUEST.addTalkId(npcId)
Advertisement
Add Comment
Please, Sign In to add comment