About query_sql

[Lil Troll]

Greetings fellas!

 

Anyone knows how to revert name back to normal? using this script?

mes "blablablabla"
menu ("yes",1nn,"revert",2nn)
1nn:
set @charname$,"+strcharinfo(0)+";
set @title$,[TITLE];
query_sql "UPDATE `char` SET name,'"+escape_sql(@title$)"' '"+ escape_sql(@charname$) + "'; WHERE `name`='" + escape_sql(@charname$) + "'";
2nn: ??

Edited August 18, 2013 by Lil Troll

[Skorm]

There is a mod drifting around that allows @fakename to show guild and party it would be much better to use that method instead of this one.

 

Then you could just do @fakename to remove the title...

 

I'll do I little looking for it and post back if I find it.

 

Edit--

http://rathena.org/board/topic/60188-fakename-show-guildparty/

[Patskie]

Greetings fellas!

 

Anyone knows how to revert name back to normal? using this script?

mes "blablablabla"
menu ("yes",1nn,"revert",2nn)
1nn:
set @charname$,"+strcharinfo(0)+";
set @title$,[TITLE];
query_sql "UPDATE `char` SET name,'"+escape_sql(@title$)"' '"+ escape_sql(@charname$) + "'; WHERE `name`='" + escape_sql(@charname$) + "'";
2nn: ??

Try : 

// Extract name with title
    explode(.@name$, strcharinfo(0), " ");
    set .@real_name$, .@name$[1];
    query_sql "UPDATE `char` SET `name` = '" + escape_sql(.@real_name$) + "' WHERE `char_id` = '" + getcharid(0) + "'";
    end;

[Emistry]

it wont work perfectly...certain players name have alots of spacing...

 

the best way you can try...i think is these...

• save Original Name into a Permanent Character Variable. or other storing way like new sql table...or etc
• when player want to revert their name, just set back the name according to the variable ..

[Patskie]

it wont work perfectly...certain players name have alots of spacing...

 

the best way you can try...i think is these...

• save Original Name into a Permanent Character Variable. or other storing way like new sql table...or etc
• when player want to revert their name, just set back the name according to the variable ..

Lol i am thinking of that too. but too lazy to edit hahaha

[Joseph]

Hmm.. 'replacestr' might work as well.
 

[Skorm]

I'm still sticking with this isn't a good idea... SQL updates in-game are very slow and often require a re-log. The fakename mod would be a much better choice and wouldn't write and rewrite entries to the database.

[Patskie]

Ang besides if player update his name through sql and exceeds 23 characters it will be deleted.