Allstar bro, you forgot the i in Right.
update [SRO_VT_SHARD].[dbo].[_RefSkill] Set Service = '0' where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382' SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefSkill] where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382'
And most used one for crashing players around is the skill in bard mastery, cap 120.Quote:
there is the Fix have fun .
i try to tell u how the crash bug is working !!!Code:update [SRO_VT_SHARD].[dbo].[_RefSkill] Set Service = '0' where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382' SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefSkill] where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382'
we have some skills in database "enable" but not in the Client , so u just need to add the "enable/hiden" skills to ur client and u have new skills like "Happy Song" or something ...
2. way to Fix this Crash Bug add all this skills to ur Client ;)
hope i can help with this ;)
greetz Kev from InPanic ;)
Congrats for that.Quote:
there is the Fix have fun .
i try to tell u how the crash bug is working !!!Code:update [SRO_VT_SHARD].[dbo].[_RefSkill] Set Service = '0' where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382' SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefSkill] where id = '8321' OR id = '8328' OR id = '8331' OR id = '8384' OR id = '8418' OR id = '8585' OR id = '8586' OR id = '8587' OR id = '8588' OR id = '8589' OR id = '8590' OR id = '8591' OR id = '8592' OR id = '8593' OR id = '9263' OR id = '9264' OR id = '9265' OR id = '9266' OR id = '9267' OR id = '9268' OR id = '9269' OR id = '9270' OR id = '9271' OR id = '9272' OR id = '9273' OR id = '9274' OR id = '11285' OR id = '11286' OR id = '11287' OR id = '11288' OR id = '11289' OR id = '11323' OR id = '11324' OR id = '11325' OR id = '11326' OR id = '11327' OR id = '11328' OR id = '11329' OR id = '11330' OR id = '11331' OR id = '11332' OR id = '11401' OR id = '11402' OR id = '11403' OR id = '11404' OR id = '11405' OR id = '11414' OR id = '11415' OR id = '11416' OR id = '11417' OR id = '11418' OR id = '11419' OR id = '11420' OR id = '21206' OR id = '21207' OR id = '21218' OR id = '30216' OR id = '30217' OR id = '30218' OR id = '31198' OR id = '33078' OR id = '33381' OR id = '33382'
we have some skills in database "enable" but not in the Client , so u just need to add the "enable/hiden" skills to ur client and u have new skills like "Happy Song" or something ...
2. way to Fix this Crash Bug add all this skills to ur Client ;)
hope i can help with this ;)
greetz Kev from InPanic ;)
You're kinq kraL developer :DQuote:
we have some skills in database "enable" but not in the Client , so u just need to add the "enable/hiden" skills to ur client and u have new skills like "Happy Song" or something
Quote:
Congrats for that.
I really hope you're happy now...
Have fun with the new skills and fixing my bug :)
Oh and you shouldn't use my words barely translated from our Skype conversation next time :D
You're kinq kraL developer :D
#!/usr/bin/python
db = file('datenbank_standart.txt')
client = file('client_standart.txt')
# Als erstes die Liste der Client-Skills ermitteln
client_skills = []
for line in client:
parts = line.split()
skill = parts[1]
client_skills.append(skill)
# Dann die Liste der aktiven DB-Skills ermitteln
db_skills = []
for line in db:
parts = line.split()
service = parts[0]
skill = parts[1]
basic_code = parts[3]
if service == "1" and not basic_code.startswith('CSKILL') and not basic_code.startswith('MSKILL'):
db_skills.append(skill)
# Nun die Liste der fehlenden Skills berechnen
missing_skills = []
for skill in db_skills:
if skill not in client_skills:
missing_skills.append(skill)
# Anzahl ausgeben
print "Client-Skills", len(client_skills)
print "DB-Skills", len(db_skills)
print "Fehlende Skills", len(missing_skills)
# Query zusammenbauen
query = 'SELECT * FROM [SRO_VT_SHARD].[dbo].[_RefSkill] where '
parts = []
for skill in missing_skills:
parts.append('id = \'%s\'' % skill)
query += ' OR '.join(parts)
# Query ausgeben
print query
[10:54:28] xProdigy ☭: bah du miese ratte [10:54:49] xProdigy ☭: was fällt dir eigentlich ein [10:54:54] xProdigy ☭: den crash bug public zu fixen [10:55:11] xProdigy ☭: damit hilfste nur irgendwelchen turk servern [10:55:26] xProdigy ☭: bitte BRING DICH DOCH SELBST UM [10:55:41] xProdigy ☭: du bist das wertloseste was ich jemals in meinem leben gesehen habe [10:56:46] xProdigy ☭: ich wusste doch das du eine verdammte miese ratte bist [10:56:49] xProdigy ☭: du verfickter bastard [10:56:52] xProdigy ☭: ._. [10:57:08] xProdigy ☭: normalerweiße ist der wortschatz sogar für mich zu tief [10:57:18] xProdigy ☭: aber für dich trifft nichts anderes mehr zu [10:57:29] xProdigy ☭: komm und sei glücklich [11:11:44] xProdigy ☭: auch noch zu feige um zu antworten? [13:34:42] Kev: gibt leute die arbeiten ;)
most Guy avatar in world.Quote:
Congrats for that.
I really hope you're happy now...
Have fun with the new skills and fixing my bug :)
Oh and you shouldn't use my words barely translated from our Skype conversation next time :D
You're kinq kraL developer :D