Utility: Account Management System

[Patskie]

Simple and useful script intended to boost players capability to manage their own account in-game. Feel free to use. Report bug and glitches immediately by messaging me here. Also suggestions are welcome and appreciated.
 
How to use :
- Just use @account in-game.
 
Script capabilities :
• My Account = Information of the current account.
• Change Mail = Change the e-mail of the current account.
• Change Gender = Change the gender of the current account ( 1 use per day limit ).
• Users Online = Show the list of user's online with their corresponding jobs.
• Set Password = Set a password for the account
• Delete Password = Delete a password for the account
• View Character = View all characters in an account
• Reset Position = Reset the position of the character in an account
• Reset Style = Reset the style of the character in an account.
• Reset Equipment = Reset the equipment of the character in an account.
 
Changelog :

1.0 - Initial release
1.1 - Remove unnecessary variables

 
Additional Information : 
• When password is set, Every time you log in it will asked for your password.
• To set the change sex time limit. Go to the script and find :

set #timer,gettimetick(2) + 86400;

86400 seconds is equivalent to 1 day.
 
TODO : Working on SQL OFFSET that will hold > 128 online players.
 
accountsystem.txt
accountsystem v1.1.txt

 

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Edited July 25, 2013 by Patskie

[pakz]

Tagumoay idol

[Patskie]

Tagumoay idol

Lol

[xilence01]

nice bro.

-khayam

[ShogS]

Good Job

[Patskie]

nice bro.

-khayam

 

 

Good Job

Thanks!

[KeyWorld]

Hi Patskie,

Some comments to help you to improve your script :

• Avoid setting #var for just some check : #insertlp$, #insertlp$, #accountvpw$, #cpassword$, ... you don't need to cache this variables on player account (we are limited so it's better to not polluate).
• In this line, the @email$ variable is never set

  mes "Old e-mail: " +@email$;

• The query will throw an error if there is more than 128 players online (an array can't store more than 128 values):

  query_sql "SELECT `name` , `class` , `base_level` , `job_level` FROM `char` WHERE `online` = '1'",.@name$,.@class,.@b_level,.@j_level;

• It missing a escape_sql() in the line (can't be inject but can throw an error):

  query_sql "SELECT `online` FROM `char` WHERE `name` = '"+@name$[@m]+"'",@online;

• I don't see the point to have 3 accounts variables to detect if a password is set (#setpwd, #dontp, #lockpw$), isn't it better to just use #lockpw$ and check if the variable is empty or not ?

[Patskie]

@KeyWorld 

 

Ohh i see. why is it i must use escape_sql on these line query_sql "SELECT `online` FROM `char` WHERE `name` = '"+@name$[@m]+"'",@online; I know it can't be injected but how this line will throw an error? Thanks for suggesting

[KeyWorld]

Patskie

It can throw an error in the case the player has an apostrophe on his name (some servers allowed it), but can't be injected because the pseudo can't contain more than 24 characters (and with 24 characters it's hard to do an interesting hack ).

[Patskie]

Ohhh i see thannks for that...

 

 

Patskie
It can throw an error in the case the player has an apostrophe on his name (some servers allowed it), but can't be injected because the pseudo can't contain more than 24 characters (and with 24 characters it's hard to do an interesting hack  ).

 

I just check the script_commands.txt on the doc folder. Is this what you are saying? )

 

 

*escape_sql(<value>)

 

Converts the value to a string and escapes special characters so that it is safe to use in query_sql().

Returns the escaped form of the given value.

 

Example:

    set .@str$, "John's Laptop";

    set .@esc_str$, escape_sql(.@name$); // Escaped string: John\'s Laptop

Edited April 12, 2013 by Patskie

[maynard]

nice but I have some problems in reseting the style, it doesnt work on me, Then the reset equip doesnt realy work actually to me, You can see that it reset the equip but if you alt+q it is still there. 

[Patskie]

nice but I have some problems in reseting the style, it doesnt work on me, Then the reset equip doesnt realy work actually to me, You can see that it reset the equip but if you alt+q it is still there. 

You can reset equipment of a character when he or she is not online

[maynard]

how can I reset the character equip if he or she is not online using your script? Your script is like a control panel in game, right?

Lets say I'm having error in one of my character due to sprite error, Do I have to make another account then reset my account that having error?

[youtube]

this script work EA?

[Patskie]

this script work EA?

I guess so.

 

how can I reset the character equip if he or she is not online using your script? Your script is like a control panel in game, right?

Lets say I'm having error in one of my character due to sprite error, Do I have to make another account then reset my account that having error?

Use your other character with the same account ( with your character having error ) and there's an option there which character you want to reset.

[maynard]

is it me? can you double check your script ingame, Try to reset your equip, Then check your equipment items if it goes into the inventory then check your display window if its gone. alt+q.I use a script like yours that i found here in rathena and he also get the same problem like yours and he didnt know the answer to that problem.Kindly check if your not busy because it's a good script for me if this script of yours work as intended.

 

This works for EA and im using it, except the reset equip. 

Edited August 6, 2013 by maynard

[youtube]

i try not work! i got error and when i type @account say no command unknow 

[maynard]

My bad,I forgot to tell you that i manually diff  have bindatcmd, Ea doesnt have bindatcmd only rathena has it. Search for bindatcmd and manually add it, Thats what I did to make it work. bindatcmd make my life easier, you can customized/make more @commands.

 

Back to topic I hope Patskie have a solution.

[Famous]

thanks for this

Edited August 16, 2013 by zhen

[Noel Gallagher]

What if i forgot my password?