Help me on query_sql

[Limestone]

how to put this sql script in my npc and change my name like this. for example:

From Super Hero to [ Cool ] Super Hero

thank you!

[Emistry]

change permanently ??

try

.@name$ = "[Cool] "+strcharinfo(0);
query_sql( "UPDATE `char` SET `name`='"+.@name$+"' WHERE `char_id`='"+getcharid(0)+"' );

[Winz]

basically, this is a cut of the script

set .@new_name$, "[Cool] "+strcharinfo(0)+;
query_sql("UPDATE `char` SET name='"+escape_sql(.@new_name$)+"' WHERE `char_id`='"+escape_sql(getcharid(0))+"');

CMIIW

Have a nice day!

*started typing 3 hrs ago..==, able to send a minute ago

Edited January 25, 2013 by Winz

[Limestone]

hmm.. thank you emistry, i try it.. no its not permanently, how about if the name expires, what i mean, i want to put that script on my pvp ladder, but if the name expires, what should i put to revert back to its original name?

[Capuche]

If the player own a guild, you must uptade his name in guild table too. But I think uptade table for this is too complicated. I believe fakename is better but you aren't forced to believe me XD

prontera,150,180,5    script    I like Rabbit    456,{

   Timepgm = gettimetick(2) + 20;
   dispbottom "Display [Cool] during 20 sec.";
   end;

OnPCLoginEvent:
   if( Timepgm > gettimetick(2) )
       atcommand "@fakename [Cool] "+ strcharinfo(0);
   else
       Timepgm = 0;
   end;
}