Brian

if (isloggedin(<account id>,<char id>)) { attachrid <account_id>; // use 'set' to modify variable } else { // char is offline or on a different char of the account // use 'query_sql' }

Add an if/else in your loop: if they are online (use 'attachrid' to check), then use set to update their variable else if they are offline, use query_sql to modify the variable in SQL. As you said, modifying their variables in SQL while they are online has no effect.

Several developers and other members have suggested and want to help with this too! We are still deciding on some back-end stuff (like how to structure the repository), but right now it looks like: separate project (not in the rAthena SVN) we'll be using GIT: http://localhost-ro.googlecode.com/git/

This is the part in /src/map/skill.c that affects which brewed potions give Alchemist Rank points: (search for //Apply quantity modifiers and that should find it) } else { int fame = 0; tmp_item.amount = 0; for (i=0; i< qty; i++) { //Apply quantity modifiers. if (rand()%10000 < make_per || qty == 1) { //Success tmp_item.amount++; if(nameid < 545 || nameid > 547) continue; if(skill_id != AM_PHARMACY && skill_id != AM_TWILIGHT1 && skill_id != AM_TWILIGHT2 && skill_id != AM_TWILIGHT3) continue; //Add fame as needed. switch(++sd->potion_success_counter) { case 3: fame+=1; // Success to prepare 3 Condensed Potions in a row break; case 5: fame+=3; // Success to prepare 5 Condensed Potions in a row break; case 7: fame+=10; // Success to prepare 7 Condensed Potions in a row break; case 10: fame+=50; // Success to prepare 10 Condensed Potions in a row sd->potion_success_counter = 0; break; } } else //Failure sd->potion_success_counter = 0; } This line: if(nameid < 545 || nameid > 547) continue; means "if item_id is less than 545 or greater than 547, do NOT apply fame" i.e. "only apply fame points to item_id 545, 546, 547" Add your new potion's item_id there, save, and recompile.

Solution: use mobcount() instead *mobcount("<map name>","<event label>") This function will count all the monsters on the specified map that have a given event label and return the number or 0 if it can't find any. Naturally, only monsters spawned with 'monster' and 'areamonster' script commands can have non-empty event label. If you pass this function an empty string for the event label, it will return the total count of monster without event label, including permanently spawning monsters. With the dynamic mobs system enabled, where mobs are not kept in memory for maps with no actual people playing on them, this will return a 0 for any such map. If the event label is given as "all", all monsters will be counted, regardless of having any event label attached. If the map name is given as "this", the map the invoking character is on will be used. If the map is not found, or the invoker is not a character while the map is "this", it will return -1.

You could try restarting in Safe Mode (as computer is booting, after BIOS, press F8 repeatedly, then pick "Safe Mode") then try deleting the folder.

^ that error is different than the first. while(.@i < getarg(1)) { should be while(.@i < getarg(1)) {

Is your rAthena version before or after 15572? If it's after r15572, there's no `login`.`level` column which could be causing the error. Also, as Skyrim mentioned, you could use the script command getgmlevel() to check their level getgroupid() to check their group.

Yes, just like running upgrade_svn15572.sql

Actually, the column name in SQL must match what is coded in the rAthena source, or else when it does a SQL query, the server won't be able to find what it's looking for. If your rAthena version is before 15572, the column should still be named `login`.`level` For version 15572 and after, the column should be named `login`.`group_id`

In r15572, the `account`.`level` column has been replaced with `account`.`group_id` r15572: New GM, Commands & Permissions system

Add them in the SQL table named `cp_links`.

You could also update to r15659 (this will update ALL, including r15653). 2. then right-click the folder --> Tortoise SVN --> SVN Log. 3. find r15653 in the SVN Log, right-click it and pick "Revert changes from this revision" This will revert the changes from r15653, but your working copy still did a SVN Update that included r15653. This way, in the future when you do SVN Update, it won't re-try to merge changeset 15653.

1251 !

eAthena and rAthena do not have this feature because kRO clients do not support it. http://www.eathena.ws/board/index.php?showtopic=256935&view=findpost&p=1402668

I think this link is better! Hehe. Found it on the second page of the link you gave him. http://www.eathena.w...howtopic=199843 It's explained in the 1st link Emistry posted: eAthena and rAthena do not have this feature because kRO clients do not support it. The 2nd link Eden posted is a different feature: when using @storage, also enforce the Kafra Password (numeric password that you type in). Numeric password (input box) is already support by rAthena. I forget what Kafra menu option you use to change it.

1222

Where are you downloading this pre-compiled rAthena from? I uploaded these: http://sourceforge.net/projects/rathena/files/trunk/ and they do have all the item/mob text databases. (Did you know the /db folder has been split into /db/re/ and /db/pre-re/ ?)

1212

Topic closed.

1156

Well, currently it is not in /src/map/script.c I don't remember if it used to be a command and was removed. ah it was removed in r15530

It's because you are using the command wrong. The syntax is: mobcount("<map name>","<event label>") Read the documentation in /trunk/doc/script_commands.txt or on the wiki page: mobcount.

getmapmobs is not a script command anymore. It was removed in r15530 and merged into mobcount.

1144