arzzzae

Getting an error when I tried to recompile my server. Nevermind. Got it working now. Thanks for the release!

Thanks Brian! By the way, what does the ==0 in your query_sql does? Edit: Got it now.

Can someone show me an example of calling values in a row from a table when a player input something? For example. I have a npc which requires input from the player then the npc will send a query and check and return values. I'm currently trying to make an npc where if you enter a code, it will give you an item depending on what values you entered in the sql table. mes "Please enter the code."; next; input .@pc$; query_sql ("SELECT codes,reward FROM `pcodes` WHERE `codes`='"+escape_sql(#pc$)+"'", .@pc$,.@re); mes "Congratulations"; next; getitem .@re,1; set .@pc$, 1; close; Sorry for terribad engrish.

trunk/npc/cities/payon.txt

So, computer specs comes into the play.

Thanks for the help! Will start reading it!

What emulator do you use?

I know that this topic has been asked alot. I do have 0 base knowledge about SQL except for the fact that I know SQL stores server data like string, integer variables and etc. I want to know a lot more about rA scripting with a mix SQL Query. For example, I want to add a new table in SQL that handles string variables and the new SQL Table will be called in scripts to check if the string variable is already in use. --------------------------------------- *query_sql("your MySQL query"{, <array variable>{, <array variable>{, ...}}}); *query_logsql("your MySQL query"{, <array variable>{, <array variable>{, ...}}}); Executes an SQL query. A 'select' query can fill array variables with up to 128 rows of values, and will return the number of rows (i.e. array size). Note that 'query_sql' runs on the main database while 'query_logsql' runs on the log database. Example: set @nb, query_sql("select name,fame from `char` ORDER BY fame DESC LIMIT 5", @name$, @fame); mes "Hall Of Fame: TOP5"; mes "1."+@name$[0]+"("+@fame[0]+")"; // Will return a person with the biggest fame value. mes "2."+@name$[1]+"("+@fame[1]+")"; mes "3."+@name$[2]+"("+@fame[2]+")"; mes "4."+@name$[3]+"("+@fame[3]+")"; mes "5."+@name$[4]+"("+@fame[4]+")"; --------------------------------------- I have read that part in the script_commands.txt but I want to see more examples. Thank you.

No problem man. I still have several suggestions in my mind, but I guess it will be a hassle for you.

Oh I forgot renewal spawn is different. Try Copying the files in npc/re/mobs into your npc/pre-re/mobs. You should now have the renewal respawn system. Again do a back-up.

Wow, funny video with awesome map package. Thank you very much and keep doing awesome job!

Just copy the mob_db.txt in your re folder into your pre-re folder. /// renewal drop rate algorithms /// (disable by commenting the line) /// /// leave this line to enable renewal item drop rate algorithms /// while enabled a special modified based on the difference between the player and monster level is applied /// based on the http://irowiki.org/wiki/Drop_System#Level_Factor table #define RENEWAL_DROP /// renewal exp rate algorithms /// (disable by commenting the line) /// /// leave this line to enable renewal item exp rate algorithms /// while enabled a special modified based on the difference between the player and monster level is applied #define RENEWAL_EXP and make sure you leave the #define RENEWAL_DROP and #define RENEWAL_EXP without '//' to implement the renewal drops and renewal exp. After you are done with the source code compile and run your server and check for errors. I'm not sure if it'll work though. Also, don't forget to backup your files.

You have to set the number of days in order for the item to work. The example below will make you a Premium user for 7 days once you use it. { set #Premium,#Premium + ( 7 * 24 * 3600 ); }This example is also the same thing as above except it doesn't use the mathematical formula.{ set #Premium,#Premium + 604800; }

Just edit it in your friend list settings by doing "Alt+H'. Screenshot Note: Run your client in admin mode so it will save the settings.

if( !#Freebies ){ set #Freebies,1;

Add '#' prefix to your Freebie variable. "#" - A permanent local account variable. They are stored with all the account data in "save\accreg.txt" in TXT versions and in the SQL versions in the 'global_reg_value' table using type 2. /trunk/doc/script_commands.txt

Thank you for your release! Anyways I have a suggestion. How about letting the players whisper the said npc to let them know the remaining time for their next reward? or use a custom @command for checking the remaining time?

Go to your trunk and run the runserver-sql.exe after you have done everything. (Compile and server setup)

Here is a sample script to check if the character is a 3rd job. set @eac, eaclass(); if(@eac&EAJL_THIRD) mes "Wow, you've really grown!"; To learn more about the job system goto to /trunk/doc/ea_job_system.txt

There is nothing in rA 1705 that says about debuffing when someone enters a castle.

- script ResetPosition -1,{ OnWhisperGlobal: if (@whispervar0$ == "reset") { save "new_1-1",53,111; warp "new_1-1",53,111; end; } }

Hi, does anyone has a working auction system? I'm using the rAthena auction system but it is not working.

I just want a simple script where for example; Resurrection or Yggdrasil Leaf has been used on a player, it will save the count of the skill/item use then after a certain condition has been met. ( e.x.Resurrect any player 100 times) a dialogue will appear.

Thanks!

I just want to know that if possible, you can add an exp modifier in 1 map. For example, Endless Tower will have 25% more experience than other places.