need help how can i delete skill on p-server

[memosaber019]

like the title say please help me

[Unionteams]

you need help for too many things today

[memosaber019]

check my 1st topic need help i wanna make great server if u can help me

[tkblackbelt]

delete from player_skills where char_id = 100000 and skill_id = 1002;

[memosaber019]

Originally Posted by tkblackbelt

delete from player_skills where char_id = 100000 and skill_id = 1002;

i have delete skills at navicat skills and spells but the skill still works what should i do

[tkblackbelt]

Originally Posted by memosaber019

i have delete skills at navicat skills and spells but the skill still works what should i do

Learn how to debug an application and some problem solving skills.

[memosaber019]

Originally Posted by tkblackbelt

Learn how to debug an application and some problem solving skills.

what do u think about delete the skills from the npcs like trojan master if i cleaned the row skill hercules ?

[pintinho12]

Originally Posted by memosaber019

what do u think about delete the skills from the npcs like trojan master if i cleaned the row skill hercules ?

huh

[Spirited]

You're asking very basic questions.... obviously if your server doesn't offer a skill, you shouldn't be offering that skill to players through NPCs.

[pintinho12]

Originally Posted by Spirited

You're asking very basic questions.... obviously if your server doesn't offer a skill, you shouldn't be offering that skill to players through NPCs.

As i checked other of his threads lol
he cant even handle a "if else"
he will reply you with another question

[Spirited]

Originally Posted by pintinho12

As i checked other of his threads lol
he cant even handle a "if else"
he will reply you with another question

If he can't even program an if-else conditional statement, he REALLY shouldn't be hosting a private server, at all. Especially since he absolutely insists on using a broken source from another community. He should be supporting another private server instead. It's not our job to teach people how to program. There's a level of self-study that newcomers need to have before asking for help; otherwise, our help is meaningless.


"If you have no programming experience, it is best to back out completely"

[memosaber019]

Originally Posted by pintinho12

As i checked other of his threads lol
he cant even handle a "if else"
he will reply you with another question

no i won't server on now without errors skills don all done i just need to add elite pvp in my bag to make topic

[pintinho12]

Originally Posted by memosaber019

no i won't server on now without errors skills don all done i just need to add elite pvp in my bag to make topic

No, i wont,
server is on now without errors,
skills done, all done,
i just need to add elite pvp in my bag to make topic

I didnt get the red part

[tkblackbelt]

This is just a guess, I think he means he has to add a elite pvper link back on his website.

[OverKillasdwqe]

i duno if this is solved but here

if you want to just delete the skill from everyone that owns it then a lambda expression or even sql statement to loop on skills table would do the trick

if you also want to disable the skill you can simply delete it's entire from the spell information table at the database or from a flat file w/e but that's a dirty solution (it should return at the handler if it couldn't retrieve the spell information)

to make it more elegant then you shouldn't handle it at handlers so it won't even cast

finally just remove it's visibility from the server by removing it's skill book from shops if it exists and remove it's option from npcs

and to make it vanish i would do all the above, except that i would leave it's spell information in-case i needed it again