Drop the old sql table then import the new sql table. What framework are you using? Workbench or?
Got confused with the question >.< just apply the changes?
Please use spoiler tag >.<
1. Is your username and password on char_athena and map_athena.conf is the same on the login table?
2. Make sure your database credentials are properly set on inter_athena and ....._sql.c on scr/login/
Casting rate yan.
-5% after cast delay
bonus bDelayRate,-5;
Ung sa additional damage para sa emperium. Walang specific na script para dian. Ang ma susuggest ko ilagay mo nalang sa item mo ito
bonus2 bAddEle,Ele_Holy,20;
Additional damage on Holy elements. Since emperium eh isang holy type.
You can easily have an NPC that can sell anything you want.
prontera,150,150,0 shop <NPC Name> <NPC Look>,<Item ID>:<Price>
prontera,150,150,0 shop Armor 99,2304:10000,2306:20000
@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
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.
1. Download http://www.mediafire.com/download.php?ldgt7ml3oru75j6
2. Do not include ChatWindInfo, OptionInfo and UserKeys [LUA FILES] on your GRF. Put them in a data folder.