Brian

Can we see the last section of your trunk/db/map_index.txt ? //====================================================================================== //Place your custom maps with a starting ID here. //====================================================================================== //Example: // //mymap 1250 //mymap-2

Follow these instructions to reset the root MySQL password: http://dev.mysql.com/doc/refman/5.5/en/resetting-permissions.html

Revert the changes in r14790 Save Recompile

2394

It's been a few years since I used InnoSetup, but I think you can put your server's URL/link there. The installer will create a URL shortcut to your server's website in the Start Menu programs folder.

Sorry =[ I updated post #4, and this time I tested it. poring_c01,100,100,0 script test 910,{ npctalk "hello"; sleep 5000; npctalk2 "hello2"; }

$col = 'ID as monster_id, Sprite AS sprite, kName AS kro_name, iName AS iro_name, LV AS level, HP AS hp, '; $col .= 'EXP AS base_exp, JEXP as job_exp, Range1 AS range1, Range2 AS range2, Range3 AS range3, '; $col .= 'DEF AS defense, MDEF AS magic_defense, ATK1 AS attack1, ATK2 AS attack2, DEF AS defense, MDEF AS magic_defense, '; $col .= 'STR AS strength, AGI AS agility, VIT AS vitality, `INT` AS intelligence, DEX AS dexterity, LUK AS luck, '; $col .= 'Scale AS scale, Race AS race, (Element%10) AS element_type, (Element/20) AS element_level, Mode AS mode, '; $col .= 'Speed AS speed, aDelay AS attack_delay, aMotion AS attack_motion, dMotion AS delay_motion, '; $col .= 'MEXP AS mvp_exp, ExpPer AS mvp_exp_chance, '; rAthena dropped the ExpPer column (r15531), this is probably what's causing the SQL query to fail. I submitted a pull request to CalciumKid: https://github.com/calciumkid/fluxcp-renewal/pull/5/files

No!! re-importing main.sql will overwrite (delete) all your server data too! players, their items, everything! ONLY re-import the new item_db.sql and mob_db.sql

apply this diff patch: save script.c recompile

Just import the new item_db.sql (the same way as when you setup rAthena) and it will overwrite the old data. If you put your custom items in the item_db2 and mob_db2 tables, these will NOT be overwritten.

Edit the script command in [src=trunk/src/map/script.c] /*========================================== * npctalk (sends message to surrounding area) *------------------------------------------*/ BUILDIN_FUNC(npctalk) { const char* str; char name[NAME_LENGTH], message[256]; struct npc_data* nd = (struct npc_data *)map_id2bl(st->oid); str = script_getstr(st,2); if(nd) { safestrncpy(name, nd->name, sizeof(name)); strtok(name, "#"); // discard extra name identifier if present safesnprintf(message, sizeof(message), "%s : %s", name, str); clif_message(&nd->bl, message); } return 0; } You could make it: 1. not announce the npc name at all 2. change 'npctalk' to accept a 2nd parameter to specify whether or not to show the NPC's name Which do you want to do?

Fix these types of bugs Also, they are usually the ones who add/update items, mobs, and everything in the /db folder.

Try the Build menu instead of Run. Run is to compile+test the installer, Build just compiles it.

What data are you storing in `Description` ? If it's text, I think CHAR or VARCHAR data type would be better, or if it's longer then TINYTEXT, TEXT, MEDIUMTEXT, or LONGTEXT. http://dev.mysql.com/doc/refman/5.5/en/blob.html

If the computer I'm on has TortoiseSVN installed, I use SVN Log to view the history. Or I view it on Trac: http://trac.rathena.org/log/rathena/trunk/npc/custom/quests/sunglasses.txt What you're suggesting has already been added to trunk/doc/script_commands.txt (r15473) but I am not sure if we will do this for EVERY file.

No it's not possible. Scripts can only do SQL queries on the ragnarok and log databases defined in /conf/inter_athena.conf You can use query_sql to access other databases on the same host, as long as the rAthena MySQL user has privileges on those databases and in the SQL query you use the full `database`.`table` name.

2354

I think something like this: http://tournasdimitrios1.wordpress.com/2010/09/17/storing-binary-data-in-mysql-databases-with-php/

Are you uploading the files to your server over FTP? Try using Binary transfer mode (instead of ASCII or Auto). Or try downloading the file directly from the SVN to your server: cd path/to/folder/src/map/ rm battle.c wget https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/src/map/battle.c http://stackoverflow.com/questions/2340930/stray-342-in-c-program It looks like something (your text editor, or maybe the way you're transferring files) is converting neutral quotes to smart quotes.

I think your login-server crashed (I see "Restarting" in the window behind. Can you switch to the login-server window and check what the error is?

I think you just have to find the right people. There are still some people out there who like running a server for free because they enjoy it!

Was this where you saw it? http://trac.assembla.com/raijero/search?q=changegm

To check for mobs that have no attached event label, use an empty string: mobcount("prontera", "")

In PHP you can use addslashes with fread to convert a binary file into a string of characters that can be used in a SQL query to insert the binary file.