Brian

To make everything drop at 25% chance (regardless of what @rates says the drop rates are), set all the _min and _max chances to 2500. conf/battle/drops.conf#L40 // The rate the common items are dropped (Items that are in the ETC tab, besides card) item_rate_common: 100 item_rate_common_boss: 100 item_drop_common_min: 2500 item_drop_common_max: 2500 // The rate healing items are dropped (items that restore HP or SP) item_rate_heal: 100 item_rate_heal_boss: 100 item_drop_heal_min: 2500 item_drop_heal_max: 2500 // The rate at which usable items (in the item tab) other then healing items are dropped. item_rate_use: 100 item_rate_use_boss: 100 item_drop_use_min: 2500 item_drop_use_max: 2500 // The rate at which equipment is dropped. item_rate_equip: 100 item_rate_equip_boss: 100 item_drop_equip_min: 2500 item_drop_equip_max: 2500 // The rate at which cards are dropped item_rate_card: 100 item_rate_card_boss: 100 item_drop_card_min: 2500 item_drop_card_max: 2500 // The rate adjustment for the MVP items that the MVP gets directly in their inventory item_rate_mvp: 100 item_drop_mvp_min: 2500 item_drop_mvp_max: 2500 // The rate adjustment for card-granted item drops. item_rate_adddrop: 100 item_drop_add_min: 2500 item_drop_add_max: 2500 // Rate adjustment for Treasure Box drops (these override all other modifiers) item_rate_treasure: 100 item_drop_treasure_min: 2500 item_drop_treasure_max: 2500

Enabling the mvplog does not automatically display all that info. I was just pointing out that by logging all MVP kills with the mvplog, you could use SQL queries to get that info.- How many times was _____ mvp killed? # count for single MVP (Eddga) SELECT COUNT(mvp_id) FROM mvplog WHERE monster_id=1115; # each MVP name, with count SELECT `kName`, COUNT(mvp_id) AS 'count' FROM mvplog LEFT JOIN ragnarok.mob_db ON mvplog.monster_id=mob_db.`ID` GROUP BY monster_id;- Who killed _____ mvp the most?# who killed Eddga the most? SELECT `name`,COUNT(mvp_id) FROM mvplog LEFT JOIN ragnarok.`char` ON mvplog.kill_char_id=`char`.char_id WHERE monster_id=1115 GROUP BY kill_char_id ORDER BY COUNT(mvp_id) DESC;- When was the last time _____ mvp was killed?# last time Eddga was killed SELECT * FROM mvplog WHERE monster_id=1115 ORDER BY mvp_id DESC LIMIT 1;- Who killed MVPs on maps they do not normally spawn on?# Eddga kills not on pay_fild11 or gld_dun01 SELECT * FROM mvplog WHERE monster_id=1115 AND (`map`!='pay_fild11' OR `map`!='gld_dun01');

Well technically, you could use an in-game NPC to change your login password as many times as you want. It would all work fine, and your password would be whatever you set it to the last time you used the NPC. Maybe Winz was thinking of this query trunk/sql-files/tools/convert_passwords.sql that converts all passwords to MD5 hashes: UPDATE `login` SET `user_pass`=MD5(`user_pass`);^ do NOT execute that more than once, or else you would be converting MD5-passwords to hashes of MD5 hashes.

xdiff patches (XML style) are created using xDiffGen. xDiffPatcher, xDiffGen2, Packet Parser and Packet Extractor For the old style (colon-delimited) one tool is naith_kk's diff gen: diffgen.zip

Yes, that's one way to do it. Or you can copy-paste those queries directly in the "SQL Query" window, then click Execute.

Are you talking about this diff format? http://subversion.assembla.com/svn/ClientSide/Diff_Project/kRO/RagexeRE/2008/2008-08-27/2008-08-27aRagexeRE.diff Or the ".dll" plugin style that I think Shin's Diff Patcher uses?

In each of your SQL queries, you have to qualify the full "database.table" name. Ex: SELECT `value` FROM `ragnarok_db1`.`global_reg_value` WHERE `str`='VOTE_POINTS' AND `account_id`="+getcharid(3), .@value;

You could also add a dispbottom. 40001,5_Cash_Points,5 Cash Points,2,0,,10,,,,,0xFFFFFFFF,63,2,,,,,,{ set #CASHPOINTS, #CASHPOINTS +5; dispbottom "Gained 5 Cash Points. Current balance = " + #CASHPOINTS; },{},{}

Paid requests can be posted in Jobs Available. In your post or topic title, just mention that you are willing to pay someone for their services.

You're right, it seems like rAthena is truncating the hostname to 32 chars (31 + \0). trunk/src/login/account_sql.c // local sql settings char db_hostname[32]; It looks like your Amazon RDS instance is working fine because port 3306 is open.

3873

Searching the card0, card1, card2, card3 slots will find ALL equipment (weapons, headgear, and garments) with that card.

The default search is "Forums" if you are on a forum page. If you are on a Downloads page, the default search is Downloads. To change where you are searching, click the word "Forums" Or you can click the gear icon for Advanced Search.

They add the stat points in-game, and it looks like this in SQL? It sounds like a server-side problem in trunk/conf/battle/player.conf (max_parameter) or /src. If it was a SQL table problem (like the Data Type of those columns not being large enough), then the value "370" would not even be saved in SQL.

*4399 In addition to running the 4 SQL queries on the `inventory` table, you should also run them on - auction - cart_inventory - guild_storage - mail - storage

The warp script command bypasses mapflag#nowarpto.

Edit the client file /data/clientinfo.xml and add your WAN IP. <address>112.206.**.***</address>

If you're editing client files to make Teleport level-selectable, then I guess you could edit trunk/src/map/skill.c and change something in this section. I'm not sure exactly what to change to skip the menu. case AL_TELEPORT: case ALL_ODINS_RECALL: if(sd) { if (map[bl->m].flag.noteleport && skill_lv <= 2) { clif_skill_teleportmessage(sd,0); break; } if(!battle_config.duel_allow_teleport && sd->duel_group && skill_lv <= 2) { // duel restriction [LuzZza] char output[128]; sprintf(output, msg_txt(sd,365), skill_get_name(AL_TELEPORT)); clif_displaymessage(sd->fd, output); //"Duel: Can't use %s in duel." break; } if( sd->state.autocast || ( (sd->skillitem == AL_TELEPORT || battle_config.skip_teleport_lv1_menu) && skill_lv == 1 ) || skill_lv == 3 ) { if( skill_lv == 1 ) pc_randomwarp(sd,CLR_TELEPORT); else pc_setpos(sd,sd->status.save_point.map,sd->status.save_point.x,sd->status.save_point.y,CLR_TELEPORT); break; } clif_skill_nodamage(src,bl,skill_id,skill_lv,1); if( skill_lv == 1 && skill_id != ALL_ODINS_RECALL ) clif_skill_warppoint(sd,skill_id,skill_lv, (unsigned short)-1,0,0,0); else clif_skill_warppoint(sd,skill_id,skill_lv, (unsigned short)-1,sd->status.save_point.map,0,0); } else unit_warp(bl,-1,-1,-1,CLR_TELEPORT); break;

You do a SVN_Checkout (read that wiki page for more info).

Edit trunk/conf/log_athena.conf and set this to 0. log_filter: 0

SourceForge has resolved the issue. http://svn.code.sf.net/p/rathena/svn/

We are aware of the issue and have notified SourceForge Support. They posted this status update last month; I'm not sure if it's related to the current SVN outage.

I checked the latest version of both files (map.h and skill.h) in SVN and Git, and they both have newlines at the end of the files.<br /><br />You can just edit each file and add a blank line at the end.<br />That will fix those warnings.

PD-REPORTZEBRA