new bug "crash"

08/20/2012 22:12 Shifty*#61
Allstar bro, you forgot the i in Right.
08/20/2012 23:02 AllStars-Minty#62
Quote:
Originally Posted by Shifty* View Post
Allstar bro, you forgot the i in Right.
The missing i makes that signature more awesome :P

True story ;)
08/21/2012 09:00 Shifty*#63
Quote:
Originally Posted by AllStars-Minty View Post
The missing i makes that signature more awesome :P

True story ;)
False Story, it looks retarded.
08/21/2012 09:07 Neko*#64
I think it is something of 3 observations

- Some one found an item like ( Horse , armor , etc ) even if level 1 item Or A skill in certain level , and he fixed it by Media.pk2 by anyway , maybe a *.bsr is *.bsrr
any way he fixed it and players no , so players crash , and he not
you should check dhorse_2 n' _3 too btw.

-or duplicated item ID, and the one who fixed the ID and he don't crash and others crash.

- or some skill that appear to the user of the skill different than others see it ( e.g invisible ) and it don't crass him and crash others.
08/21/2012 09:58 intercsaki#65
There are so many ways to crash people, everyone just use mbot to go clientless, and go other cities. :D
08/21/2012 11:39 KraL*#66
I tried from this crash problem, can't fix it, so you guys can't do it also?
08/21/2012 12:13 鳳凰城#67
Its simple . add anything into isro database -.- when someone edit the line of media , when he joins , no1 will get crash . especially .bsr files.
08/21/2012 21:18 InPanic Kev#68
there is the Fix have fun .

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'
i try to tell u how the crash bug is working !!!

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 ;)
08/22/2012 05:51 Mykha*#69
Quote:
Originally Posted by InPanic Kev View Post
there is the Fix have fun .

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'
i try to tell u how the crash bug is working !!!

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 ;)
And most used one for crashing players around is the skill in bard mastery, cap 120.
08/22/2012 11:15 Lord xProdigy#70
Quote:
Originally Posted by InPanic Kev View Post
there is the Fix have fun .

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'
i try to tell u how the crash bug is working !!!

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.

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
Quote:
Originally Posted by InPanic Kev View Post
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
You're kinq kraL developer :D
08/22/2012 13:03 intercsaki#71
Quote:
Originally Posted by Lord xProdigy View Post
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

See, if you have told me instead of him, it wouldn't have been released to the public. :) But it's good as it is, it was about time. ^^
08/22/2012 13:45 InPanic Kev#72
@xProdigy

u told me thats its possible to crash player with a Skill thats right .... but if u remember u have Chrash my Char to so i was see whats wrong ... Silkroad Folder / Dump / 8N[2012-04-24 16-17-47]_38_22 InPanic_[GM]Kev.dmp take a look and u know why ur client was crashing .....

so its easy to syn the client with the database with a own script ;)

Code:
#!/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
PS : Welcome to my Ignor list on Skype ;)
Code:
[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 ;)
08/22/2012 15:59 鳳凰城#73
Quote:
Originally Posted by Lord xProdigy View Post
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
most Guy avatar in world.

@Kev , thanks dude . reallly helpful
@who said 120 bard skill , who using database lines not same as media lines or didnt even saw them , he must close his server :rolleyes:
08/22/2012 16:18 skinner✔#74
Quote:
Originally Posted by Phoenix 1337 View Post
most Guy avatar in world.
that "guy" made my day.
08/22/2012 16:39 intercsaki#75
Quote:
Originally Posted by skinner1337 View Post
that "guy" made my day.
Who do my eyes see here. :"))))))))))