Brian

Just do 'make sql' instead of 'make all' (or 'make'). Currently, the console.c plugin is not compatible on 64-bit systems.

Or maybe log file rotation, like what Linux does.

I think we should leave it enabled. Our default client date in trunk/src/common/mmo.h is #define PACKETVER 20111116 //#define PACKETVER 20100730 I am using a 2010-07-30 client and it has the MVP Tomb sprite, so I assume it works fine on 2011-11-16 too.

It works for me. Is your rAthena version older than r15872 ?

To also show the next respawn time, you would have to store the respawn time of every MVP in the npc script. Currently, there is no script command to get the next respawn time. And by "boss", do you mean MVPs only ? - script MVP_death_announce -1,{ OnNPCKillEvent: if (getmonsterinfo(killedrid,MOB_MVPEXP)) { announce getmonsterinfo(killedrid,MOB_NAME)+" has been killed by "+strcharinfo(0)+" on "+strcharinfo(3)+".", bc_blue|bc_all; } end; } * requires rAthena r15872 or later, for MOB_MVPEXP to work

http://sourceforge.net/apps/trac/raijero/log/fluxcp/?verbose=on Those modified FluxCP pages are designed to work with this NPC: /raijero/trunk/npc/custom/pvp.txt OnPCKillEvent: query_sql "UPDATE `char` SET `kills` = `kills`+1 WHERE `char_id` = "+ getcharid(0); if (attachrid(killedrid)) query_sql "UPDATE `char` SET `deaths` = `deaths`+1 WHERE `char_id` = "+ getcharid(0); end; and these SQL modifications - /raijero/trunk/sql-files/main2.sql -- Add columns to table `char` ALTER TABLE `char` ADD `kills` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', ADD `deaths` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0', ADD `empbreak` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0';

1946

You probably missed some lines when applying the diff patch. Try again and double check your work.

You got that error on FluxCP, right? Edit your FluxCP file /config/error.php and change this to 'true': $showExceptions = true; // Whether or not to show exceptions (only applies to error.php) refresh the page that was giving you the error that will display a more detailed error message. If you still can't figure it out, post the full error message here Remember to set $showExceptions back to false for a production environment.

Would multi-line mes work for you? (r15072)

To reset them to their save point: UPDATE `char` SET last_map=save_map, last_x=save_x, last_y=save_y WHERE `name`='CHAR_NAME_HERE'; To reset them to prontera: UPDATE `char` SET last_map='prontera', last_x=155, last_y=188 WHERE `name`='CHAR_NAME_HERE';

Here's another example that works for offline players too: kafrapoints_transfer.txt (just change all #KAFRAPOINTS to #CASHPOINTS) Add something like mes "You have " + #CASHPOINTS + " Cash Points.";

@Will Suranol: oh, it's because direct variable assignment was just added 3 days ago. r15982: Script Engine Update. @Jam: sorry, thought you were using SQL because there's no more TXT in rAthena

Might be easier to write a new script Here's one that runs off the SQL logs table. First enable the mvplog in trunk/conf/log_athena.conf // Use MySQL Logs? [sql Version Only] (Note 1) sql_logs: yes // Log MVP Monster Drops (Note 1) // Outdated. Use Pick_Log instead. But this log could be useful to keep track slayed MVPs log_mvpdrop: yes Then the NPC script: prontera,155,188,0 script MVP Rank 910,{ // get database names, for join query_sql "SELECT DATABASE()", .@rag_db$; query_logsql "SELECT DATABASE()", .@log_db$; query_sql "SELECT `name`,COUNT(mvp_id) FROM "+.@log_db$+".mvplog " + "LEFT JOIN "+.@rag_db$+".`char` ON mvplog.kill_char_id=`char`.char_id " + "GROUP BY kill_char_id ORDER BY COUNT(mvp_id) DESC LIMIT 10", .@name$, .@kills; mes "[MVP Rank Top 10]"; for (.@i=0; .@i<getarraysize(.@name$); .@i++) { mes "Top ^FF0000"+(.@i+1)+"^000000 "+.@name$[.@i]+" with ^FF0000"+.@kills[.@i]+"^000000 MVPs killed."; } close; }

The pushpc script command sounds promising, though I have never used or tested: *pushpc <direction>,<cells>; This command will push the currently attached player to given direction by given amount of square cells. Direction is the same as used when declaring NPCs, and can be specified by using one of the DIR_* constants (db/const.txt). The knock-back is not restricted by items or map flags, only obstacles are taken into account. If there is not enough space to perform the push (e.g. due to a wall), the character is pushed only up to the obstacle. // pushes the character 5 cells in 3 o'clock direction from it's // current position. pushpc DIR_EAST, 5;

And in case anyone needs it NOW before recompiling and restarting, you could use a script function: function script abs { .@i = atoi(getarg(0)); return ( (.@i < 0) ? -.@i : .@i ); } thanks to the r15982: Script Engine Update !

We think it's a Chrome issue http://code.google.c...etail?id=113983 It's more noticeable here because IPB 3 pages consume more browser memory than other pages. Ex: IPB 2 board index ~ 10 MB IPB 3 board index ~ 40 MB

I don't spend enough time on any other IPB 3 forums to notice. XD But.. I think it also happens on [build.rathena.org] after refreshing the page many times. Set it to something like http://build.rathena.org/waterfall?reload=15&num_events=100 and come back in a few hours (2 hours = 480 page loads).

Updating status to: Confirmed (and moved to bugreport:5653) Bug exists since r15657.

What I do to "fix" it is close all tabs from that domain [rathena.org] You don't have to restart the browser completely.

It's your map cache. You need to add the custom maps to /db/map_cache.dat Here's one tool you can use: WeeMapCache by Shinryo.

I'm curious which do people use more? (what is your setting in trunk/conf/log_athena.conf) // Use MySQL Logs? [sql Version Only] (Note 1) sql_logs: no

If you're still looking for help with this, I can show/teach you how or do it for you.

Yes you can, there are several ways you can set it up. Just make sure the 2 servers either listen on different ports or different IP addresses. If you configure both of them to listen on the same IPs/ports, then the 2nd server you try to start will get a "can't bind to socket" error.

This (below) will truncate all tables except `login`, and the item/mob tables. TRUNCATE TABLE `auction`; TRUNCATE TABLE `cart_inventory`; TRUNCATE TABLE `char`; ALTER TABLE `char` AUTO_INCREMENT=150000; TRUNCATE TABLE `charlog`; TRUNCATE TABLE `friends`; TRUNCATE TABLE `elemental`; TRUNCATE TABLE `global_reg_value`; TRUNCATE TABLE `guild`; TRUNCATE TABLE `guild_alliance`; TRUNCATE TABLE `guild_castle`; TRUNCATE TABLE `guild_expulsion`; TRUNCATE TABLE `guild_member`; TRUNCATE TABLE `guild_position`; TRUNCATE TABLE `guild_skill`; TRUNCATE TABLE `guild_storage`; TRUNCATE TABLE `homunculus`; TRUNCATE TABLE `hotkey`; TRUNCATE TABLE `interlog`; TRUNCATE TABLE `inventory`; TRUNCATE TABLE `ipbanlist`; TRUNCATE TABLE `mail`; TRUNCATE TABLE `mapreg`; TRUNCATE TABLE `memo`; TRUNCATE TABLE `mercenary`; TRUNCATE TABLE `mercenary_owner`; TRUNCATE TABLE `party`; TRUNCATE TABLE `pet`; TRUNCATE TABLE `quest`; TRUNCATE TABLE `ragsrvinfo`; TRUNCATE TABLE `sc_data`; TRUNCATE TABLE `skill`; TRUNCATE TABLE `skill_homunculus`; TRUNCATE TABLE `sstatus`; TRUNCATE TABLE `storage`;