Brian

1 hour to ms = 3600000 3 hours to ms = 10800000

For example: setarray .item_id[0], 2199, 1599;

Did you stop, recompile, and restart your servers? Did you disable the script trunk/npc/kafras/functions_kafras.txt on your server? If you did, you'd have to put the "StoragePassword" NPC in a different file. // Kafra Storage Password prompt when using @storage - script StoragePassword -1,{ if (#kafra_code != 0) { mes "[Storage password system]"; callfunc("F_CheckKafCode"); close2; } openstorage; dispbottom "Storage opened."; }It works for me:@storage @set #kafra_code 12345 @storage

Yes, you put your IP Address that EasyVPN assigns your computer. That's also the IP you will put in clientinfo.xml so your players can connect.

Since the script checks their VIP time every time they login (and adjusts their GM level to 1 if they still have VIP time left), it's not necessary to edit their `group_id` in SQL. But if you really want the script to do that, find these lines (line 32 and 40) atcommand "@adjgroup 1 "+strcharinfo(0); atcommand "@adjgroup 0 "+strcharinfo(0);and right after each of those lines, you can add query_sql to change their group_id in SQL.

Double check your MySQL user and password (root // inuaitis). Use your MySQL client program to connect to your MySQL Server, and type in the user/pass to verify you can connect. The error in all 3 servers says : Access denied for user 'root'@'localhost' (Using password: YES)

prontera,155,180,0 script Skull Points 910,{ switch(select("View PVP Skull Points Ladder:" + (countitem(.ITEMID_SKULL_) ? ("Exchange "+countitem(.ITEMID_SKULL_)+" "+((countitem(.ITEMID_SKULL_)==1)?"Skull":"Skulls")+" --> Points") : "") )) { case 1: query_sql "SELECT `char`.`name`, CAST(`value` AS UNSIGNED) " + "FROM global_reg_value " + "LEFT JOIN `char` ON global_reg_value.char_id=`char`.char_id " + "WHERE global_reg_value.`str`='skull_points' AND CAST(`value` AS UNSIGNED) > 0 " + "ORDER BY CAST(`value` AS UNSIGNED) DESC LIMIT 10", .@name$, .@points; mes "[Top 10 Skull Points]"; for (set .@i,0; .@i<getarraysize(.@name$); set .@i,.@i+1) { mes (.@i+1) +". ^0000FF"+ .@name$[.@i] +"^000000 ("+ .@points[.@i] +((.@points[.@i]==1)?" pt":" pts")+")"; } break; case 2: set .@skulls, countitem(.ITEMID_SKULL_); if (.@skulls < 1) { mes "You don't have any PVP Skulls."; } else { delitem .ITEMID_SKULL_, .@skulls; set skull_points, skull_points + .@skulls; dispbottom "Gained "+.@skulls+" skull points. Total = " + skull_points; } break; } close; OnInit: // should match /src/map/itemdb.h set .ITEMID_SKULL_, 7420; end; }

Here's one example: vip_rental.txt Usage: (can be used in an item script or NPC script) { callfunc "F_VIPstart", <ticks>; }ticks = how long their VIP will last, in seconds 1 day = 86400 7 days = 604800 14 days = 1209600 etc. Example item script:55555,VIP_7day,VIP Membership (7 days),2,2,,10,,,,,0xFFFFFFFF,7,2,,,,,,{ callfunc "F_VIPstart", 604800; },{},{}

Are you looking for the Kafra Express scripts? !svn/bc/16163/trunk/npc/custom/eAAC_Scripts/kafraExpress/ read the readme.txt

[Employee Ahee] is in trunk/npc/merchants/inn.txt (line 79) //======================= Payon ====================================== payon_in01,132,62,5 script Inn Employee#Ahee 53,{ callfunc "F_InnMaid","[Employee Ahee]","Payon Inn","payon_in01",136,61; warp "payon_in01",132,11; end; }

Switching to rAthena will also fix the 2nd error .@mobcount = mobcount( "1@room",instance_npcname( "Helper#Breaker Room",instance_id(1) )+"::OnMyMobDead" );(eAthena does not support direct variable assignment. You have to use set)set .@mobcount, mobcount( "1@room",instance_npcname( "Helper#Breaker Room",instance_id(1) )+"::OnMyMobDead" );

I don't see the part with your insert query query_sql "INSERT INTO `cp_credits` ... "; Can you paste that part of the script?

The `charlog` table is part of the "ragnarok" database. (reasoning was: so the char server does not have to make a 2nd MySQL connection to the "logs" database) The `charlog` table will be created when you import trunk/sql-files/main.sql -- -- Table structure for table `charlog` -- CREATE TABLE IF NOT EXISTS `charlog` ( `time` datetime NOT NULL default '0000-00-00 00:00:00', `char_msg` varchar(255) NOT NULL default 'char select', `account_id` int(11) NOT NULL default '0', `char_num` tinyint(4) NOT NULL default '0', `name` varchar(23) NOT NULL default '', `str` int(11) unsigned NOT NULL default '0', `agi` int(11) unsigned NOT NULL default '0', `vit` int(11) unsigned NOT NULL default '0', `int` int(11) unsigned NOT NULL default '0', `dex` int(11) unsigned NOT NULL default '0', `luk` int(11) unsigned NOT NULL default '0', `hair` tinyint(4) NOT NULL default '0', `hair_color` int(11) NOT NULL default '0' ) ENGINE=MyISAM;

Can you double check that you set your MySQL user, pass, database in 4 sections in trunk/conf/inter_athena.conf // Global SQL settings // overriden by local settings when the hostname is defined there // (currently only the login-server reads/obeys these settings) sql.db_hostname: 127.0.0.1 sql.db_port: 3306 sql.db_username: ragnarok sql.db_password: ragnarok sql.db_database: ragnarok sql.codepage: // MySQL Character SQL server char_server_ip: 127.0.0.1 char_server_port: 3306 char_server_id: ragnarok char_server_pw: ragnarok char_server_db: ragnarok // MySQL Map SQL Server map_server_ip: 127.0.0.1 map_server_port: 3306 map_server_id: ragnarok map_server_pw: ragnarok map_server_db: ragnarok // 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

Yea, that message was removed/changed in rAthena r15121. Were there any other errors after this warning? If you're running the servers through SSH, the output should still show in the SSH window. If you're running the servers in a GUI and the windows close, open a terminal (Ctrl+Alt+T), cd to your *Athena folder, and start each server. Then the window should stay open so you can see all output, even after it crashes. *create a non-root Linux user to run Athena

To merge 2 "ragnarok" databases into 1 server: http://www.eathena.ws/board/index.php?showtopic=237661&view=findpost&p=1296053 (after reading post #4) Now I see what you want to do. You should have just said that in the first post xD Yes, just do what clydelion said and add a second <connection> block to your clientinfo.xml Here's an example: <?xml version="1.0" encoding="euc-kr" ?> <clientinfo> <desc>RO Client Information</desc> <servicetype>america</servicetype> <servertype>sakray</servertype> <connection> <display>192.168.1.101</display> <address>192.168.1.101</address> <port>6900</port> <version>23</version> <langtype>1</langtype> <aid> <admin>PUT_YOUR_ACCOUNT_ID_HERE</admin> </aid> </connection> <connection> <display>^FF0000test^000000</display> <address>123.45.67.89</address> <port>6900</port> <version>23</version> <langtype>1</langtype> </connection> <connection> <display>RMS Test Server</display> <balloon>RateMyServer.net</balloon> <address>69.197.158.197</address> <port>6900</port> <version>20</version> <langtype>1</langtype> <registrationweb>http://play.ratemyserver.net/ragnarok/</registrationweb> </connection> </clientinfo>

When you create your MySQL users, set hostnames too so they can only connect from the host you specify. Only give each MySQL user the minimum privileges it needs. rAthena only needs SELECT, INSERT, UPDATE, DELETE on the ragnarok database and INSERT on the log database.

One char was completely deleted? This is the general outline of how you can restore it: http://www.eathena.ws/board/index.php?showtopic=182299&st=0&p=1001526entry1001526

Then I posted 3780, then your post (should have been) 3781 .. and now this post is 3782

Are you setting up rAthena on your computer? Windows? Are the login, char, and map servers all running on the same computer? In char_athena.conf, what did you set login_ip to?

so now we're on 3780

Keep in mind that if you use a VPN (like Comodo EasyVPN or Hamachi), this means all your players have to install the VPN software and connect to your VPN. Instead, it would be better to just use your WAN IP and setup your router to forward ports 6900,6121,5121 to your computer's LAN IP.

If you have a separate "logs" database for the logs table, then you need to edit trunk/conf/inter_athena.conf and change this to the name of your "logs" database: log_db_db: ragnarokIf you only have 1 database (ragnarok), then follow what David said and import trunk/sql-files/logs.sql into your ragnarok database.

Here is the diff, updated for the latest rAthena (r17160): storagepass-r17160.diff stop your login,char,map servers apply the diff recompile your map-server start your servers