Brian

Yes, import those SQL files into your "ragnarok" SQL database. This will create the item & mob tables that FluxCP needs. Then refresh your CP page and the error should be gone.

Import the item and mob SQL files from /trunk/sql-files/ item_db.sql item_db2.sql item_db_re.sql mob_db.sql mob_db2.sql

set $showExceptions to true in /config/error.php refresh the page --> see the full error

Windows: - stop your servers - right click your rathena folder --> SVN Update - recompile - restart servers Linux: - stop your servers - cd into your rathena folder - svn update - recompile - restart servers

You have MD5 enabled in FluxCP. If you don't want to use MD5, disable it: /config/servers.php 'UseMD5' => false,

The script engine will read ANY filename, extension does not matter. Just define the npc script in a /npc/scripts_*****.conf file npc: npc/custom/my_npc.txt npc: npc/custom/my_other_npc.c npc: npc/custom/my_third_npc.ras npc: npc/custom/filename_with_no_extension I vote to keep .txt as the extension for RAthena-provided scripts.

Right now we do have a status, "Needs More Info". Does that fit what you're suggesting?

No objections here.

I like Heal.

239

private server. Toilet paper over or under?

The pow script command is already in our SVN. You don't need to do any additional edits, just checkout a clean copy from the SVN, compile, and it should work.

Is this an issue with the latest rAthena version (from the SVN) ? or do you have some custom edits to /src/map/script.c that caused this?

Sounds like you want someone to do all the work for you... How about you at least try? Do what you can, and then ask for help. Or if you are trying to hire staff (to do the work for you), post in the Jobs Available section.

If anyone wants to help, send me a PM and I'll add you for SVN write access.

Done.

237

The REPLACE INTO syntax looks more like INSERT (not like Update): REPLACE INTO `fishladder` (char_id,`name`,score) VALUES ("+getcharid(0)+",'"+strcharinfo(0)+"',"+.@score+")";

oops, thanks KeyWorld! hmm somewhere after post #11 we lost WHERE xD

Yes something like that. Make sure your variable name (@noitem or .@amt ?) is the same in all places. To give them 2x the points, just do @noitem * 2 bFish: next; mes "Checking inventory..."; set .@amt,countitem(6096); if (.@amt) { if ( query_sql("SELECT `score` FROM `fishladder` WHERE `char_id`="+getcharid(0), .@score) ) { // row exists, update it query_sql "UPDATE `fishladder` SET `score` = `score` + "+ .@amt*2 +",`char_id` = "+getcharid(0); } else { // else, insert new row query_sql "INSERT INTO fishladder (char_id,`name`,score) VALUES ("+getcharid(0)+",'"+escape_sql(strcharinfo(0))+"',"+ .@amt*2 +")"; } delitem 6096,.@amt; next; mes "[Fishing Board]"; mes "Fish have been retreived and score updated."; } else { mes "[Fishing Board]"; mes "You have no fish to turn in."; } close;

Sorry about that, after I posted that reply, I reset the SVN because Yommy requested it. I have re-added the files, links should work now. Mysterious: do you want the name change to be permanent or temporary (like @fakename) ?

set .@amt, countitem(6096); delitem 6096, .@amt; if ( query_sql("SELECT `score` FROM `fishladder` WHERE `char_id`="+getcharid(0), .@score) ) { // row exists, update it query_sql "UPDATE `fishladder` SET `score` = `score` + "+.@amt+" WHERE char_id="+getcharid(0); } else { // else, insert new row query_sql "INSERT INTO fishladder (char_id,`name`,score) VALUES ("+getcharid(0)+",'"+strcharinfo(0)+"',"+.@amt+")"; } ^ the 'countitem' needs to be outside the string and concatenated in. Or else your query will just be: UPDATE table SET points = points + countitem(FISHID) WHERE ...

Here are some example scripts that use 'query_sql' to change a char's name: namechange.txt namechange2.txt namechange_charat.txt

Would countitem(6096) work?