Ir para conteúdo
  • Cadastre-se

Project x


marcos-sayan

Posts recomendados


Opa marcos, eu mais uma vez, então cara, tem como adicionar a tabela char_templates no banco de dados de novo? não vai dar nenhum pau? pois adicionei um top pvp e ele precisa da char_template para se conectar e não encontra, oque eu posso estar fazendo?

posta aqui o script em py aqui que arrumo em dois minuto ou mude igual a isso

 

from net.l2jpx.gameserver.datatables.xml import CharTemplateTable;

 

ou

 

from net.l2jpx.gameserver.datatables.xml import char_template;

 

pois do seus npc deve tar sql no lugar de xml

 

entendeu pq nao funciona a dream ve um usa o msm tipo e funciona entao e erro facio de arruma que ta nisso ai que falei a cima

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

posta aqui o script em py aqui que arrumo em dois minuto ou mude igual a isso

 

from net.l2jpx.gameserver.datatables.xml import CharTemplateTable;

 

ou

 

from net.l2jpx.gameserver.datatables.xml import char_template;

 

pois do seus npc deve tar sql no lugar de xml

 

entendeu pq nao funciona a dream ve um usa o msm tipo e funciona entao e erro facio de arruma que ta nisso ai que falei a cima

 

import sys

from net.l2jpx.gameserver.model.actor.instance import L2PcInstance
from java.util import Iterator
from net.l2jpx.gameserver.datatables import SkillTable
from net.l2jpx.util.database import L2DatabaseFactory
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance
from net.l2jpx.gameserver.model.quest import State
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance
from net.l2jpx.gameserver.model.quest import QuestState
from net.l2jpx.gameserver.model.quest.jython import QuestJython as JQuest
NPC=[1006]
ADENA_ID = 57
QuestId = 2121
QuestName = "Rankings"
QuestDesc = "custom"
InitialHtml = "1.htm"
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
count = st.getQuestItemsCount(ADENA_ID)
if event == "88":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=88 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Dreadnought
if event == "89":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=89 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Phoenix Knight
if event == "90":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=90 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Hell Knight
if event == "91":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=91 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Sagittarius
if event == "92":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=92 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Adventurer
if event == "93":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=93 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Archmage
if event == "94":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=94 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Soultaker
if event == "95":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=95 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Arcana Lord
if event == "96":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=96 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Cardinal
if event == "97":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=97 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Hierophant
if event == "98":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=98 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Eva's Templar
if event == "99":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=99 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Sword Muse
if event == "100":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=100 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Wind Rider
if event == "101":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=101 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Moonlight Sentinel
if event == "102":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=102 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Mystic Muse
if event == "103":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=103 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Elemental Master
if event == "104":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=104 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Eva's Saint
if event == "105":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=105 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Shillien Templar
if event == "106":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=106 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Spectral Dancer
if event == "107":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=107 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Ghost Hunter
if event == "108":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=108 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Ghost Sentinel
if event == "109":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=109 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Storm Screamer
if event == "110":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=110 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Spectral Master
if event == "111":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=111 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Shillien Saint
if event == "112":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=112 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Titan
if event == "113":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=113 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Grand Khavatari
if event == "114":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=114 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Dominator
if event == "115":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=115 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Doomcryer
if event == "116":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=116 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Fortune Seeker
if event == "117":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=117 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
# Maestro
if event == "118":
INITIAL_HTML = "<html><head><title>Grand Olympiad Ranking</title></head><body><center><font color=66cc00>Olympiad Ranking Online System</font></center><br><center><img src=\"L2UI.SquareWhite\" width=300 height=1><img src=\"L2UI.SquareBlank\" width=1 height=3></center><table width=300 border=0 bgcolor=\"000000\"><tr><td>Posicao</td><center><td>|</td></center><td><center>Nome</center></td><center><td>|</td></center><td><center>Pontos</center></td><center><td>|</td></center><td><center>Lutas</center></td></tr>"
HTML_INFO =""
POSITION_VALUE_INITIAL = 0
CONNECTION = L2DatabaseFactory.getInstance().getConnection()
pts = CONNECTION.prepareStatement("SELECT char_name, olympiad_points, competitions_done from olympiad_nobles where class_id=118 and competitions_done>=9 order by olympiad_points desc, competitions_done desc");
rs = pts.executeQuery()
while (rs.next()) :
CHAR_NAME = rs.getString("char_name")
POINTS = rs.getString("olympiad_points")
COMP_DONE = rs.getString("competitions_done")
POSITION_VALUE_INITIAL = POSITION_VALUE_INITIAL + 1
STRING_POSITION = str(POSITION_VALUE_INITIAL)
HTML_INFO = HTML_INFO + "<tr><td><center>" + STRING_POSITION + "</td><center><td></td></center><td><center>" + CHAR_NAME +"</center></td><center><td></td></center><td><center>" + POINTS + "</center></td><center><td></td></center><td><center>" + COMP_DONE + "</center></td></tr>"
HTML_END = "</table></body></html>"
HTML_OLY = INITIAL_HTML + HTML_INFO + HTML_END
CONNECTION.close()
return HTML_OLY
if event == "119" and count >= 10000 :
st.takeItems(ADENA_ID,10000)
htmltext_ini = "<html><head><title>PK Information</title></head><body><table width=290><tr><td><center>Rank</center></td><td><center>Character</center></td><td><center>Class</center></td><td><center>Kills</center></td></tr>"
htmltext_info =""
color = 1
pos = 0
con = L2DatabaseFactory.getInstance().getConnection()
pk = con.prepareStatement("SELECT char_name,classid,pkkills FROM characters WHERE pkkills>0 and accesslevel=0 order by pkkills desc limit 30")
rs = pk.executeQuery()
while (rs.next()) :
char_name = rs.getString("char_name")
char_class = rs.getString("classid")
char_pkkills = rs.getString("pkkills")
pos = pos + 1
posstr = str(pos)
classname = con.prepareStatement("SELECT classname FROM char_templates WHERE classid=" + char_class)
rs2 = classname.executeQuery()
while (rs2.next()) :
char_zeor = rs2.getString("classname")
if color == 1:
color_text = "<font color =\"effe00\">"
color = 2
htmltext_info = htmltext_info + "<tr><td><center><font color =\"effe00\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + color_text + char_zeor +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
elif color == 2:
color_text = "<font color =\"06db33\">"
color = 1
htmltext_info = htmltext_info + "<tr><td><center><font color =\"06db33\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + color_text + char_zeor +"</center></td><td><center>" + char_pkkills + "</center></td></tr>"
htmltext_pklist = htmltext_ini + htmltext_info
con.close()
return htmltext_pklist
elif event == "119" and count < 10000 :
htmltext = "<html><head><title>PK Information</title></head><body><font color =\"FF0000\">You don't have enought adena.</body></html>"
return htmltext
if event == "120" and count >= 10000 :
st.takeItems(ADENA_ID,10000)
htmltext_ini = "<html><head><title>PvP Information</title></head><body><table width=290><tr><td><center>Rank</center></td><td><center>Character</center></td><td><center>Class</center></td><td><center>Kills</center></td></tr>"
htmltext_info =""
color = 1
pos = 0
con = L2DatabaseFactory.getInstance().getConnection()
pvp = con.prepareStatement("SELECT char_name,classid,pvpkills FROM characters WHERE pvpkills>0 and accesslevel=0 order by pvpkills desc limit 30")
rs = pvp.executeQuery()
while (rs.next()) :
char_name = rs.getString("char_name")
char_class = rs.getString("classid")
char_pvpkills = rs.getString("pvpkills")
pos = pos + 1
posstr = str(pos)
classname = con.prepareStatement("SELECT classname FROM char_templates WHERE classid=" + char_class)
rs2 = classname.executeQuery()
while (rs2.next()) :
char_zeor = rs2.getString("classname")
if color == 1:
color_text = "<font color =\"effe00\">"
color = 2
htmltext_info = htmltext_info + "<tr><td><center><font color =\"effe00\">" + posstr + "</center></td><td><center>" + color_text + char_name +"</center></td><td><center>" + color_text + char_zeor +"</center></td><td><center>" + char_pvpkills + "</center></td></tr>"
elif color == 2:
color_text = "<font color =\"06db33\">"
color = 1
htmltext_info = htmltext_info + "<tr><td><center><font color =\"06db33\">" + posstr + "</center></td><td><center>" + color_text + char_name +"</center></td><td><center>" + color_text + char_zeor +"</center></td><td><center>" + char_pvpkills + "</center></td></tr>"
htmltext_pklist = htmltext_ini + htmltext_info
con.close()
return htmltext_pklist
elif event == "120" and count < 10000 :
htmltext = "<html><head><title>PvP Information</title></head><body><font color =\"FF0000\">You don't have enought adena.</body></html>"
return htmltext
if event == "121" and count >= 10000 :
st.takeItems(ADENA_ID,10000)
htmltext_ini = "<html><head><title>Clan Information</title></head><body><table width=290><tr><td><center>Rank</center></td><td><center>Level</center></td><td><center>Clan Name</center></td><td><center>Reputation</center></td></tr>"
htmltext_info =""
color = 1
pos = 0
con = L2DatabaseFactory.getInstance().getConnection()
clan = con.prepareStatement("SELECT clan_name,clan_level,reputation_score FROM clan_data WHERE clan_level>0 order by reputation_score desc limit 15")
rs = clan.executeQuery()
while (rs.next()) :
clan_name = rs.getString("clan_name")
clan_level = rs.getString("clan_level")
clan_score = rs.getString("reputation_score")
pos = pos + 1
posstr = str(pos)
if color == 1:
color_text = "<font color =\"effe00\">"
color = 2
htmltext_info = htmltext_info + "<tr><td><center><font color =\"effe00\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + clan_score + "</center></td></tr>"
elif color == 2:
color_text = "<font color =\"06db33\">"
color = 1
htmltext_info = htmltext_info + "<tr><td><center><font color =\"06db33\">" + posstr + "</center></td><td><center>" + color_text + clan_level +"</center></td><td><center>" + clan_name + "</center></td><td><center>" + clan_score + "</center></td></tr>"
htmltext_pklist = htmltext_ini + htmltext_info
con.close()
return htmltext_pklist
elif event == "121" and count < 10000 :
htmltext = "<html><head><title>Clan Information</title></head><body><font color =\"FF0000\">You don't have enought adena.</body></html>"
return htmltext
if event == "122" and count >= 10000 :
st.takeItems(ADENA_ID,10000)
htmltext_ini = "<html><head><title>Time Online Info</title></head><body><table width=300><tr><td><font color =\"FF00FF\">Pos.</td><td><center><font color =\"FFFF00\">*** Player ***</color></center></td><td><center>*** Time ***</center></td></tr>"
htmltext_info =""
color = 1
pos = 0
con = L2DatabaseFactory.getInstance().getConnection()
pks = con.prepareStatement("SELECT char_name,onlinetime FROM characters WHERE onlinetime>0 and accesslevel=0 order by onlinetime desc limit 1000000")
rs = pks.executeQuery()
while (rs.next()) :
char_name = rs.getString("char_name")
char_onlinetime = rs.getString("onlinetime")
pos = pos + 1
posstr = str(pos)
if color == 1:
color_text = "<font color =\"00FFFF\">"
color = 2
htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_onlinetime + "</center></td></tr>"
elif color == 2:
color_text = "<font color =\"FF0000\">"
color = 1
htmltext_info = htmltext_info + "<tr><td><center><font color =\"FF00FF\">" + posstr + "</td><td><center>" + color_text + char_name +"</center></td><td><center>" + char_onlinetime + "</center></td></tr>"
htmltext_end = ""
htmltext_pklist = htmltext_ini + htmltext_info + htmltext_end
con.close()
return htmltext_pklist
elif event == "122" and count >= 10000 :
htmltext = ""
return htmltext
QUEST = Quest(QuestId,str(QuestId) + "_" + QuestName,QuestDesc)
for npcId in NPC:
QUEST.addStartNpc(npcId)
QUEST.addTalkId(npcId)
  • L2JBRASIL

Link para o comentário
Compartilhar em outros sites

 

 

 

import sys

from net.l2jpx.gameserver.model.actor.instance import L2PcInstance
from java.util import Iterator
from net.l2jpx.gameserver.datatables import SkillTable
from net.l2jpx.util.database import L2DatabaseFactory
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance
from net.l2jpx.gameserver.model.quest import State
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance
from net.l2jpx.gameserver.model.quest import QuestState
from net.l2jpx.gameserver.model.quest.jython import QuestJython as JQuest

mude para esse e teste pois se nao funcionar a tarde hora que chegar do servico eu arrumo ele e testo e posto

 

import sys
from net.l2jpx.gameserver.model.actor.instance import L2PcInstance;
from java.util import Iterator;
from net.l2jpx.gameserver.datatables import SkillTable;
from net.l2jpx.gameserver.datatables.xml import CharTemplateTable;
from net.l2jpx.util.database import L2DatabaseFactory;
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance;
from net.l2jpx.gameserver.model.quest import State;
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance;
from net.l2jpx.gameserver.model.quest import QuestState;
from net.l2jpx.gameserver.model.quest.jython import QuestJython as JQuest;

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

Uhum, pode ate ser que funciona, eu também tive alguns erros parecido com esses!

seguinte no vídeo do Raidboss vs boss , vc criou algum tipo de mod ou modificou os npc no Navicat?

poderia me falar o nome da musica também pf!

Link para o comentário
Compartilhar em outros sites

Uhum, pode ate ser que funciona, eu também tive alguns erros parecido com esses!

seguinte no vídeo do Raidboss vs boss , vc criou algum tipo de mod ou modificou os npc no Navicat?

poderia me falar o nome da musica também pf!

A musica e essa o raid boss segredo kkkkkk DUAS COISAS EU FIZ KKKKK

 

Nightwish - 04 The Kinslayer (End of An Era) Live

 

https://www.youtube.com/watch?v=o8gXzDLNWl8&index=11&list=RD2PmPlSC-3o8

Editado por marcos-sayan

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

 

mude para esse e teste pois se nao funcionar a tarde hora que chegar do servico eu arrumo ele e testo e posto

 

import sys
from net.l2jpx.gameserver.model.actor.instance import L2PcInstance;
from java.util import Iterator;
from net.l2jpx.gameserver.datatables import SkillTable;
from net.l2jpx.gameserver.datatables.xml import CharTemplateTable;
from net.l2jpx.util.database import L2DatabaseFactory;
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance;
from net.l2jpx.gameserver.model.quest import State;
from net.l2jpx.gameserver.model.actor.appearance import PcAppearance;
from net.l2jpx.gameserver.model.quest import QuestState;
from net.l2jpx.gameserver.model.quest.jython import QuestJython as JQuest;

 

Agora ta dando esse erro

 

http://imgur.com/a/JPp8F

  • L2JBRASIL

Link para o comentário
Compartilhar em outros sites

Agora ta dando esse erro

 

http://imgur.com/a/JPp8F

ta ai prontinho so fazer download

 

http://www.mediafire.com/download/7697hz280dtxxdg/ranking+%28px%29.rar

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

  • 3 weeks later...

Galera vou dar um ultimo presente a todos do l2jbrasil

e agradecer a todos por todos esse anos junto com voces.

e minha caminhada ta chegando ao fim aqui no l2jbrasil.

mais para fechar o ano e minha caminhada aqui ,

e que surja gente boa para ajudar ,ai ta meu ultimo presente

 

source px para todos nao se preocupe nao sera apagada por mim

ate pq ja cedi a alguns amigos para continuar o trabalho

 

http://www.mediafire.com/file/8sflm9978vsunee/pxGameServer.rar

 

ate mais galera boa sorte a todos

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

Galera vou dar um ultimo presente a todos do l2jbrasil

e agradecer a todos por todos esse anos junto com voces.

e minha caminhada ta chegando ao fim aqui no l2jbrasil.

mais para fechar o ano e minha caminhada aqui ,

e que surja gente boa para ajudar ,ai ta meu ultimo presente

 

source px para todos nao se preocupe nao sera apagada por mim

ate pq ja cedi a alguns amigos para continuar o trabalho

 

http://www.mediafire.com/file/8sflm9978vsunee/pxGameServer.rar

 

ate mais galera boa sorte a todos

 

muito bom :bom:

Link para o comentário
Compartilhar em outros sites

 

Obrigado marcos pelo belo projeto que disponibilizou a todos.., eu que acompanhei o projeto desdo inicio mais tive que para por alguns motivos sei o que voce fez na revisão e todo esforço que você fez e q ate hoje a staff da l2jbrasil não reconheceu isso mais é uma pena perde um membro como você aqui no forum.

1gGxjAH.png

 

 

Link para o comentário
Compartilhar em outros sites

Perca de tempo foi pra quem ajudou tbm achando os bugs '-'

Gleyce123 se acha isso a source ta na pagina 98 pra quem quiser continuar ........

eu acho que ta ai os meus esforços e de voces.

nao fui um pilantra que pego o que vc´s reporto e saiu vendendo ,e vc´s fico no vaco e a msm source que tava mechendo e postando sem tirar nada

 

a source ta na pagina 98

 

agora a todos o negocio e com voces

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

Não estou falando neste sentido, estou falando que desistir por causa de gente fraca é uma coisa e desistir por outra coisa é outra você poderia muito bem continuar o projeto so para os que estão te ajudando no privado como eu te ajudei... eu estou ajudando o wiliams agora no projeto Acis ja que você desistiu tive que partir para outro partido sabe.....

pra quem estava te ajudando no privado você poderia muito bem passar contado e se comunicar... responder... responder as duvidas por que esses são os realmente que se interessam no assunto quem so quer uma coisa na boca pra ver um char gm e uma coisa quer quer ter um seriviidor de qualidade é outra pensa nisso ai pfv,...

Link para o comentário
Compartilhar em outros sites

Não estou falando neste sentido, estou falando que desistir por causa de gente fraca é uma coisa e desistir por outra coisa é outra você poderia muito bem continuar o projeto so para os que estão te ajudando no privado como eu te ajudei... eu estou ajudando o wiliams agora no projeto Acis ja que você desistiu tive que partir para outro partido sabe.....

pra quem estava te ajudando no privado você poderia muito bem passar contado e se comunicar... responder... responder as duvidas por que esses são os realmente que se interessam no assunto quem so quer uma coisa na boca pra ver um char gm e uma coisa quer quer ter um seriviidor de qualidade é outra pensa nisso ai pfv,...

gleyce vou te fala pq tudo isso e pq to querendo para ......

 

primeiro nao consingo mais ficar no pc por muito tempo me da um dor de cabeca sem fim ......

pode ser por causa da visao que ta dando dor de cabeca ....

e tem mais uma agora eu tava pintando a casa e colocando piso. e sempre trabalhei em servico pesado e de fazer grande esforço eu nao to conseguindo levantar meu braco direito na altura do meu ombro doi muito ta ruim ate para dirrigir entende pq parei com lineage e de programa e eu para escrever aqui se nao sabe o esforço que to fazendo pois doi muito meu braço. quem conversa comigo direto no skype what face sabe disso pois nao e de hoje que tou com isso..

 

mais de qualquer forma deixei ai o trabalho para um pessoa boa continuar

 

obrigado e espero que voce´s me entenda ate galera

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

kk seria pedir de mais as diffs desse projeto ? você usava alguma svn ? tem muito mod e correções interessantes

Link para o comentário
Compartilhar em outros sites

Os caras são muito mal agradecidos. muito bom postou a source pra galera tem nego ai que se quiser até vender vende um serviço totalmente feito pelo marcos com nossa ajuda. mais ainda acham pouco. fez o certo marcos. as coisas estão cada vez mais difíceis. você é um membro ativo a anos. nada vai apagar sua ajuda a todos aqui.

:boxing: é tóiz :boxing:

Link para o comentário
Compartilhar em outros sites

gleyce vou te fala pq tudo isso e pq to querendo para ......

 

primeiro nao consingo mais ficar no pc por muito tempo me da um dor de cabeca sem fim ......

pode ser por causa da visao que ta dando dor de cabeca ....

e tem mais uma agora eu tava pintando a casa e colocando piso. e sempre trabalhei em servico pesado e de fazer grande esforço eu nao to conseguindo levantar meu braco direito na altura do meu ombro doi muito ta ruim ate para dirrigir entende pq parei com lineage e de programa e eu para escrever aqui se nao sabe o esforço que to fazendo pois doi muito meu braço. quem conversa comigo direto no skype what face sabe disso pois nao e de hoje que tou com isso..

 

mais de qualquer forma deixei ai o trabalho para um pessoa boa continuar

 

obrigado e espero que voce´s me entenda ate galera

Sem palavras mano, testei algumas vezes seu projeto, isso pq não foi revisão atual e sim algumas antigas quando saiu! Foi um belo trabalho.

Pena que eu não sei nada de java, se não dava continuidade nesse projeto! Obrigado cara, você sim é firmeza, melhoras ai no seu braço. quem sabe sarando e passando esse seu sofrimento de agora, vc volte com outro projeto. ^^

Link para o comentário
Compartilhar em outros sites

Marcos você vai continuar a fazer avançar o projecto ou o fim?

entao é o fim pois ta dificl com meu braco ruim dor de cabeça ate eu ver porque ta dando isso de dor de cabeça na frente do pc mais deixei a source para uma alma boa continuar ate mais

 

 

 

obrigado a todos

Atitudes Que Fazem A Diferença! 

Não vou dar suporte via mp e nem skype obrigado 

Eu não tenho mais arquivos antigos não tem como ajudar em questões antigas abrigado

Galera todos meus conteúdo estão no fórum..video do meu canal no youtube com revisão npc´s e etc.. estão aqui se não achar e pq não tem mais ...obrigado e espero que de tudo certo a vcs.....

 

Link para o comentário
Compartilhar em outros sites

Nossa que maravilha :D....


Olá... alguém tem a system desse projeto x? estou meio enferrujado... apesar de que mal mal participei do forum com contribuições... mais e que preciso daquele glow hero de gracia final parece e tbm desse mod que tem da gk. eu fiz como ele pediu adicionei na system os arquivos que ele pediu mais não funcionou não. alguém disponibiliza a system pra min? se tiverem e claro.... e se puder.

Link para o comentário
Compartilhar em outros sites

  • Nattan Felipe featured, pinned, unpinned e unfeatured this Tópico
  • Registre-se

    Faça parte da maior e  mais antigas comunidades sobre Lineage2 da América Latina.






  • Patrocinadores

  • Quem Está Navegando

    • Nenhum usuário registrado visualizando esta página.
  • Posts

    • Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?    
    • muchas gracias muy lindos NPC 🙂
    • relaxa jovem gafanhoto, testa as quests. e posTa os erros indesejaveis.  
    • Se alguém pudesse me ensinar como codificar as missões, eu ficaria feliz em fazer isso sozinho ou pelo menos ajudar. Eu realmente quero jogar em um servidor onde todas as quests funcionem bem e melhor ainda se você puder fazer quests customizadas!
    • mas no interlude, nem todas as quests de class,  vai mostrar onde tem que ir, ate o reborn nao mostrava quando era interlude, só mostrou depois que eles colocaram client classic pra rodar, e ficou melhor ainda quando virou hellbound em diante, mas ha sim alguma chance de modificar isso direto no script para fazer igualmente, só basta te um pouco de paciencia e persistencia exato
    • 408_PathToElvenwizard dá Orion eu tive que mexer tbm, até modifiquei e consegui deixar ela igual do Classic, com a seta e a marcação no mapa. (não retail IL) Dá pra importar py de várias revs, o foda é que não da regular as quest py através do debug em tempo real, pelo menos eu não consegui rsrs
    • Hasta el momento todas las QUESTS son completables si te guias con un tutorial de youtube. El problema es que tienen bugs de locacion y de subquests que no avanzan o no te marcan correctamente a donde ir en el mapa, cosa que en Retail si se ve como corresponde.
    • estranho, mas pelo menos a galera nunca reclamo das quests quando tinha aberto 5x, geral fez class primeira e segunda job, poucos que compraram a class
    • en RUSaCis-3.5 data pack, las Quests estan en formato .java y son diferentes a como estan redactadas en jOrion y jFrozen 1.5 (ProyectX) package net.sf.l2j.gameserver.scripting.quest; import net.sf.l2j.commons.random.Rnd; import net.sf.l2j.gameserver.enums.Paperdoll; import net.sf.l2j.gameserver.enums.QuestStatus; import net.sf.l2j.gameserver.enums.actors.ClassId; import net.sf.l2j.gameserver.model.actor.Creature; import net.sf.l2j.gameserver.model.actor.Npc; import net.sf.l2j.gameserver.model.actor.Player; import net.sf.l2j.gameserver.network.serverpackets.SocialAction; import net.sf.l2j.gameserver.scripting.QuestState; public class Q224_TestOfSagittarius extends SecondClassQuest { private static final String QUEST_NAME = "Q224_TestOfSagittarius"; // Items private static final int BERNARD_INTRODUCTION = 3294; private static final int HAMIL_LETTER_1 = 3295; private static final int HAMIL_LETTER_2 = 3296; private static final int HAMIL_LETTER_3 = 3297; private static final int HUNTER_RUNE_1 = 3298; private static final int HUNTER_RUNE_2 = 3299; private static final int TALISMAN_OF_KADESH = 3300; private static final int TALISMAN_OF_SNAKE = 3301; private static final int MITHRIL_CLIP = 3302; private static final int STAKATO_CHITIN = 3303; private static final int REINFORCED_BOWSTRING = 3304; private static final int MANASHEN_HORN = 3305; private static final int BLOOD_OF_LIZARDMAN = 3306; private static final int CRESCENT_MOON_BOW = 3028; private static final int WOODEN_ARROW = 17; // Rewards private static final int MARK_OF_SAGITTARIUS = 3293; // NPCs private static final int BERNARD = 30702; private static final int HAMIL = 30626; private static final int SIR_ARON_TANFORD = 30653; private static final int VOKIAN = 30514; private static final int GAUEN = 30717; // Monsters private static final int ANT = 20079; private static final int ANT_CAPTAIN = 20080; private static final int ANT_OVERSEER = 20081; private static final int ANT_RECRUIT = 20082; private static final int ANT_PATROL = 20084; private static final int ANT_GUARD = 20086; private static final int NOBLE_ANT = 20089; private static final int NOBLE_ANT_LEADER = 20090; private static final int BREKA_ORC_SHAMAN = 20269; private static final int BREKA_ORC_OVERLORD = 20270; private static final int MARSH_STAKATO_WORKER = 20230; private static final int MARSH_STAKATO_SOLDIER = 20232; private static final int MARSH_STAKATO_DRONE = 20234; private static final int MARSH_SPIDER = 20233; private static final int ROAD_SCAVENGER = 20551; private static final int MANASHEN_GARGOYLE = 20563; private static final int LETO_LIZARDMAN = 20577; private static final int LETO_LIZARDMAN_ARCHER = 20578; private static final int LETO_LIZARDMAN_SOLDIER = 20579; private static final int LETO_LIZARDMAN_WARRIOR = 20580; private static final int LETO_LIZARDMAN_SHAMAN = 20581; private static final int LETO_LIZARDMAN_OVERLORD = 20582; private static final int SERPENT_DEMON_KADESH = 27090; public Q224_TestOfSagittarius() { super(224, "Test Of Sagittarius"); setItemsIds(BERNARD_INTRODUCTION, HAMIL_LETTER_1, HAMIL_LETTER_2, HAMIL_LETTER_3, HUNTER_RUNE_1, HUNTER_RUNE_2, TALISMAN_OF_KADESH, TALISMAN_OF_SNAKE, MITHRIL_CLIP, STAKATO_CHITIN, REINFORCED_BOWSTRING, MANASHEN_HORN, BLOOD_OF_LIZARDMAN, CRESCENT_MOON_BOW); addQuestStart(BERNARD); addTalkId(BERNARD, HAMIL, SIR_ARON_TANFORD, VOKIAN, GAUEN); addMyDying(ANT, ANT_CAPTAIN, ANT_OVERSEER, ANT_RECRUIT, ANT_PATROL, ANT_GUARD, NOBLE_ANT, NOBLE_ANT_LEADER, BREKA_ORC_SHAMAN, BREKA_ORC_OVERLORD, MARSH_STAKATO_WORKER, MARSH_STAKATO_SOLDIER, MARSH_STAKATO_DRONE, MARSH_SPIDER, ROAD_SCAVENGER, MANASHEN_GARGOYLE, LETO_LIZARDMAN, LETO_LIZARDMAN_ARCHER, LETO_LIZARDMAN_SOLDIER, LETO_LIZARDMAN_WARRIOR, LETO_LIZARDMAN_SHAMAN, LETO_LIZARDMAN_OVERLORD, SERPENT_DEMON_KADESH); } @Override public String onAdvEvent(String event, Npc npc, Player player) { String htmltext = event; QuestState st = player.getQuestList().getQuestState(QUEST_NAME); if (st == null) return htmltext; // BERNARD if (event.equalsIgnoreCase("30702-04.htm")) { st.setState(QuestStatus.STARTED); st.setCond(1); playSound(player, SOUND_ACCEPT); giveItems(player, BERNARD_INTRODUCTION, 1); if (giveDimensionalDiamonds39(player)) htmltext = "30702-04a.htm"; } // HAMIL else if (event.equalsIgnoreCase("30626-03.htm")) { st.setCond(2); playSound(player, SOUND_MIDDLE); takeItems(player, BERNARD_INTRODUCTION, 1); giveItems(player, HAMIL_LETTER_1, 1); } else if (event.equalsIgnoreCase("30626-07.htm")) { st.setCond(5); playSound(player, SOUND_MIDDLE); takeItems(player, HUNTER_RUNE_1, 10); giveItems(player, HAMIL_LETTER_2, 1); } // SIR_ARON_TANFORD else if (event.equalsIgnoreCase("30653-02.htm")) { st.setCond(3); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_1, 1); } // VOKIAN else if (event.equalsIgnoreCase("30514-02.htm")) { st.setCond(6); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_2, 1); } return htmltext; } @Override public String onTalk(Npc npc, Player player) { String htmltext = getNoQuestMsg(); QuestState st = player.getQuestList().getQuestState(QUEST_NAME); if (st == null) return htmltext; switch (st.getState()) { case CREATED: if (player.getClassId() != ClassId.ROGUE && player.getClassId() != ClassId.ELVEN_SCOUT && player.getClassId() != ClassId.ASSASSIN) htmltext = "30702-02.htm"; else if (player.getStatus().getLevel() < 39) htmltext = "30702-01.htm"; else htmltext = "30702-03.htm"; break; case STARTED: int cond = st.getCond(); switch (npc.getNpcId()) { case BERNARD: htmltext = "30702-05.htm"; break; case HAMIL: if (cond == 1) htmltext = "30626-01.htm"; else if (cond == 2 || cond == 3) htmltext = "30626-04.htm"; else if (cond == 4) htmltext = "30626-05.htm"; else if (cond > 4 && cond < 8) htmltext = "30626-08.htm"; else if (cond == 8) { htmltext = "30626-09.htm"; st.setCond(9); playSound(player, SOUND_MIDDLE); takeItems(player, HUNTER_RUNE_2, 10); giveItems(player, HAMIL_LETTER_3, 1); } else if (cond > 8 && cond < 12) htmltext = "30626-10.htm"; else if (cond == 12) { htmltext = "30626-11.htm"; st.setCond(13); playSound(player, SOUND_MIDDLE); } else if (cond == 13) htmltext = "30626-12.htm"; else if (cond == 14) { htmltext = "30626-13.htm"; takeItems(player, BLOOD_OF_LIZARDMAN, -1); takeItems(player, CRESCENT_MOON_BOW, 1); takeItems(player, TALISMAN_OF_KADESH, 1); giveItems(player, MARK_OF_SAGITTARIUS, 1); rewardExpAndSp(player, 54726, 20250); player.broadcastPacket(new SocialAction(player, 3)); playSound(player, SOUND_FINISH); st.exitQuest(false); } break; case SIR_ARON_TANFORD: if (cond == 2) htmltext = "30653-01.htm"; else if (cond > 2) htmltext = "30653-03.htm"; break; case VOKIAN: if (cond == 5) htmltext = "30514-01.htm"; else if (cond == 6) htmltext = "30514-03.htm"; else if (cond == 7) { htmltext = "30514-04.htm"; st.setCond(8); playSound(player, SOUND_MIDDLE); takeItems(player, TALISMAN_OF_SNAKE, 1); } else if (cond > 7) htmltext = "30514-05.htm"; break; case GAUEN: if (cond == 9) { htmltext = "30717-01.htm"; st.setCond(10); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_3, 1); } else if (cond == 10) htmltext = "30717-03.htm"; else if (cond == 11) { htmltext = "30717-02.htm"; st.setCond(12); playSound(player, SOUND_MIDDLE); takeItems(player, MANASHEN_HORN, 1); takeItems(player, MITHRIL_CLIP, 1); takeItems(player, REINFORCED_BOWSTRING, 1); takeItems(player, STAKATO_CHITIN, 1); giveItems(player, CRESCENT_MOON_BOW, 1); giveItems(player, WOODEN_ARROW, 10); } else if (cond > 11) htmltext = "30717-04.htm"; break; } break; case COMPLETED: htmltext = getAlreadyCompletedMsg(); break; } return htmltext; } @Override public void onMyDying(Npc npc, Creature killer) { final Player player = killer.getActingPlayer(); final QuestState st = checkPlayerState(player, npc, QuestStatus.STARTED); if (st == null) return; switch (npc.getNpcId()) { case ANT: case ANT_CAPTAIN: case ANT_OVERSEER: case ANT_RECRUIT: case ANT_PATROL: case ANT_GUARD: case NOBLE_ANT: case NOBLE_ANT_LEADER: if (st.getCond() == 3 && dropItems(player, HUNTER_RUNE_1, 1, 10, 500000)) st.setCond(4); break; case BREKA_ORC_SHAMAN: case BREKA_ORC_OVERLORD: if (st.getCond() == 6 && dropItems(player, HUNTER_RUNE_2, 1, 10, 500000)) { st.setCond(7); giveItems(player, TALISMAN_OF_SNAKE, 1); } break; case MARSH_STAKATO_WORKER: case MARSH_STAKATO_SOLDIER: case MARSH_STAKATO_DRONE: if (st.getCond() == 10 && dropItems(player, STAKATO_CHITIN, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, MITHRIL_CLIP, REINFORCED_BOWSTRING)) st.setCond(11); break; case MARSH_SPIDER: if (st.getCond() == 10 && dropItems(player, REINFORCED_BOWSTRING, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, MITHRIL_CLIP, STAKATO_CHITIN)) st.setCond(11); break; case ROAD_SCAVENGER: if (st.getCond() == 10 && dropItems(player, MITHRIL_CLIP, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, REINFORCED_BOWSTRING, STAKATO_CHITIN)) st.setCond(11); break; case MANASHEN_GARGOYLE: if (st.getCond() == 10 && dropItems(player, MANASHEN_HORN, 1, 1, 100000) && player.getInventory().hasItems(REINFORCED_BOWSTRING, MITHRIL_CLIP, STAKATO_CHITIN)) st.setCond(11); break; case LETO_LIZARDMAN: case LETO_LIZARDMAN_ARCHER: case LETO_LIZARDMAN_SOLDIER: case LETO_LIZARDMAN_WARRIOR: case LETO_LIZARDMAN_SHAMAN: case LETO_LIZARDMAN_OVERLORD: if (st.getCond() == 13) { if (((player.getInventory().getItemCount(BLOOD_OF_LIZARDMAN) - 120) * 5) > Rnd.get(100)) { playSound(player, SOUND_BEFORE_BATTLE); takeItems(player, BLOOD_OF_LIZARDMAN, -1); addSpawn(SERPENT_DEMON_KADESH, player, false, 300000, true); } else dropItemsAlways(player, BLOOD_OF_LIZARDMAN, 1, 0); } break; case SERPENT_DEMON_KADESH: if (st.getCond() == 13) { if (player.getInventory().getItemIdFrom(Paperdoll.RHAND) == CRESCENT_MOON_BOW) { st.setCond(14); playSound(player, SOUND_MIDDLE); giveItems(player, TALISMAN_OF_KADESH, 1); } else addSpawn(SERPENT_DEMON_KADESH, player, false, 300000, true); } break; } } }  
×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.