Database Question

[Randomess]

Someone hacked my friends database and put [DEKARON] Before and after ever character name. Is there any way for her to remove that tag without deleteing the whole database?

Thanks

[elitepvpersfans]

i remembered someone here has posted about how to check GM , use search button .

[Hesorio1u]

That mean's the 10000 port is open, search how to disable a port's. and when u learned it, disable 10000.

[Randomess]

the port shows that its disabled. But im looking for a query that will take the [DEKARON] away.

[Decima]

[lobo161]

so i guess nobody knows how to do this at all huh? this guy is asking for a sql quary something that is simple to make im sure but nobody wants to give it to them? i could use this quarry too if anyone actually knows how to make it.

[alexmak96]

Use character;
Go
Update [user_character] Set character_name= 'NAME' Where character_name= '[DEKARON]NAME[DEKARON]'

something like that?

[Decima]

i posted the sql tutorial so they could learn how to do it, of course ppl here know, but guess how we know? we went to a tutorial or something like it and taught ourselves how to run a query, its a good place to start, as what he is asking for is actually rather trivial tbh, im not in the business of spoonfeeding ppl

teach a man to fish and he eats for a life time

[ihatehacks]

Originally Posted by Decima

i posted the sql tutorial so they could learn how to do it, of course ppl here know, but guess how we know? we went to a tutorial or something like it and taught ourselves how to run a query, its a good place to start, as what he is asking for is actually rather trivial tbh, im not in the business of spoonfeeding ppl

teach a man to fish and he eats for a life time

I learned by looking at Zombe's sql script to clean the DB. Not much needs to be changed through common sense to get a script to remove [DEKARON] from all names.