new bug "crash"

[Shifty*]

Allstar bro, you forgot the i in Right.

[AllStars-Minty]

Originally Posted by Shifty*

Allstar bro, you forgot the i in Right.

The missing i makes that signature more awesome :P

True story

[Shifty*]

Originally Posted by AllStars-Minty

The missing i makes that signature more awesome :P

True story

False Story, it looks retarded.

[Neko*]

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.

[intercsaki]

There are so many ways to crash people, everyone just use mbot to go clientless, and go other cities.

[KraL*]

I tried from this crash problem, can't fix it, so you guys can't do it also?

[鳳凰城]

Its simple . add anything into isro database -.- when someone edit the line of media , when he joins , no1 will get crash . especially .bsr files.

[InPanic Kev]

there is the Fix have fun .

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

[Mykha*]

Originally Posted by InPanic Kev

there is the Fix have fun .

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.

[Lord xProdigy]

Originally Posted by InPanic Kev

there is the Fix have fun .

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

Originally Posted by InPanic Kev

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

[intercsaki]

Originally Posted by Lord xProdigy

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


You're kinq kraL developer

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. ^^

[InPanic Kev]

@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

#!/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

[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 ;)

[鳳凰城]

Originally Posted by Lord xProdigy

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


You're kinq kraL developer

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

[skinner✔]

Originally Posted by Phoenix 1337

most Guy avatar in world.

that "guy" made my day.

[intercsaki]

Originally Posted by skinner1337

that "guy" made my day.

Who do my eyes see here. :"))))))))))