Brian

Does Harmony add a `last_mac` column to the `login` SQL table? (Assuming it does), adjust the script like this: http://kpaste.net/0bbff5?raw

All of that is controlled in /fluxcp/config/access.php In that file, you can set the minimum account level required to view a page or do an action. (Level constants are listed in /fluxcp/config/levels.php)

This is the part of code causing the "Proxy is not allowed" message: http://rathena.org/board/files/file/2344-fluxcp-addon-vote-for-points/ ../modules/voteforpoints/vote.php //Somewhat Prevent of using Proxy Servers $xforward= $_SERVER["HTTP_X_FORWARDED_FOR"]; if (!empty($xforward)) { $error = Flux::message('PROXY_NOT_ALLOWED'); }

Use this script snippet: You could create a new menu within the NPC, or trigger that script snippet with an OnTime label, or make a separate GM npc that GMs could click or PM to reset the ladder -- however you want to do it. http://rathena.kpaste.net/60f0ec?raw Actually I misread the original request and forgot to make it "just the last one who broke the emp". Currently, the script records every empbreak.PS: another way (that allows resetting the ladder while the server is online) is store the "emp break points" in a new column in the `char` SQL table like this: http://trac.assembla.com/raijero/changeset/536/#file1 query_sql "UPDATE `char` SET `empbreak` = `empbreak`+1 WHERE `char_id` = "+ getcharid(0);

<mob_id> -1 = Dead Branch trunk/db/re/mob_branch.txt -4 = Red_Pouch_Of_Surprise trunk/db/mob_pouch.txt -3 = Bloody Branch trunk/db/re/mob_boss.txt -2 = Poring Box trunk/db/re/mob_poring.txt

I just thought of another way: trunk/conf/battle/monster.conf // Respawn rate of monsters on a map. 50 would make mobs respawn twice as fast (half delay time) (Note 2) //Note: This does not affects mobs with inmediate respawn (most normal mobs) mob_spawn_delay: 100 plant_spawn_delay: 100 boss_spawn_delay: 100 You could change boss_spawn_delay to 0, but this would affect all boss monsters (monsters with the MD_BOSS mode).

getmapmobs was removed from rAthena in r15530/. You can use mobcount instead. if ( mobcount("this","all") > 0 ) {

Stop your map/char/login servers. execute these SQL queries:DELETE FROM global_reg_value WHERE `str`='breaker_points'; DELETE FROM global_reg_value WHERE `str`='breaker_tcg';

Correct, TRUNCATE TABLE basically deletes all the rows in the table. It also resets AUTO_INCREMENT values to their start values.

For each MVP monster spawn, edit the file in /npc/re/mobs/ and change its respawn delay (delay1 and delay2) to zero. Ex: abbey02,236,78,21,18 boss_monster Fallen Bishop 1871,1,0,0,1

Thanks for the suggestion, we will consider installing Tapatalk.

trunk/conf/inter_athena.conf // MySQL Log SQL Database log_db_ip: 127.0.0.1 log_db_port: 3306 log_db_id: ragnarok log_db_pw: ragnarok log_db_db: ragnarok log_codepage: log_login_db: loginlog Make sure you set log_db_db to the name of your "log" database.

1. to reset agit_points, run this SQL query (the server can be online or offline) UPDATE `guild` SET `agit_points`=0;2. `agit_points` is a new SQL column in the `guild` table. Points are directly associated with the guild (emp break counts, and the character who breaks the emp is not recorded at all). 3. Since agit_points are part of the guild table, when a guild is deleted their agit_points are deleted too. Guilds that have been disbanded will not appear in the list.

Here you go: http://rathena.kpaste.net/01a815b8cf?raw point values for each castle are set in the OnInit section when the script loads, it will attempt to add the `agit_points` column to the `guild` table. (If you see a MySQL error in the map-server, it means your MySQL user doesn't have the ALTER privilege. You will have to connect to your MySQL server as root and manually execute the ALTER TABLE query.)

Done, now the script will only allow a Guild Package once-per-account. Make sure you delete the 2 SQL table and re-run the SQL queries lines 4-21, because I added a SQL column. guild_pack_info.txt NOTE: this script reads guild info from SQL (since there are no script commands to get guild member info). Guild info is only saved to SQL every 60 seconds (autosave_time in trunk/conf/char_athena.conf). This means if a member was just added to guild, the guild master will have to wait 60 seconds before it's saved to SQL and the NPC can see that information.

Not appropriate for this forum. Avatar removed and topic closed.

Fixed. Did you mean once per character? https://code.google.com/p/athena-scripts/source/detail?r=30Or do you really want once per account? Here's the updated version: guild_pack_info.txt drop the 2 SQL tablesDROP TABLE IF EXISTS guildpack_guilds; DROP TABLE IF EXISTS guildpack_members; execute the SQL queries (lines 4-20) load the script

Did you restart Apache to apply the changes?

Yes you can use "portable MySQL Server" (rAsql) with eAthena. checkout rAsql from the SVN: rAsql/ run mysql_start.bat run udrive/bin/heidisql.exe and connect to the SQL server import eAthena's SQL tables then continue setting up and configuring eAthena.

(But it compiled with no errors, right?) hmm if you're not self-muting, maybe that feature was removed from kRO clients ?

We still have to re-apply our custom IPB edits (one of them was the "Select Text" codebox).

In trunk/src/common/mmo.h, did you accidentally put "YYYYMMDD" instead of an actual date? #ifndef PACKETVER #define PACKETVER 20120410 #endif

Setup rAthena like you normally would, except these steps: Installation_(CentOS)#Create_SQL_database_for_rAthena and Installation_(CentOS)#Import_MySQL_Tables you would execute on your remote MySQL Server. Then when you edit trunk/conf/inter_athena.conf, you would put the MySQL host, user, pass for your remote MySQL server.

Yes it looks like the URL bbcode changed. If I type the old way, it automatically converts it to the new format. I don't think the URL bbcode changed. This still works: [url=http://rathena.org/board/][img=http://cdn.rathena.org/images/userbar1.png][/url]

Actually, maybe you should search your whole /trunk folder because the nocommand mapflag might be in /conf or /npc or somewhere else, or in a source edit. It's easy in Notepad++ PS: are you sure you don't have any source edit that adds the nocommand mapflag?