[SQL update errors]

Yes, your "Ragnarok" database is named ragnarok

Do you have the MySQL command-line client installed on your computer?

It might be in a folder like C:\Program Files\MySQL\bin\mysql.exe

You'd have to 'cd' into that folder, then type

mysql -h myip -u myuser -p ragnarok < C:\Desktop\trunk\sql-files\mob_skill_db.sql

[No-IP]

It looks like your ports are still closed.

http://www.yougetsignal.com/tools/open-ports/

[How to update linux packages?]

on CentOS to update everything:

yum -y update

To list what updates will be installed, and prompt Y/N:

yum update

To update just 1 package or several packages that match a search:

yum update gcc

yum update mysql*

[Modify server broadcast for rare drops]

Make sure you have the &

&sd->bl

[No-IP]

201.9.18.91 is your WAN IP right? (click here to check)

"Connection refused" means your router is not properly configured.

You need to open ports 6900, 6121, 5121 and forward them to your computer's LAN IP.

[MD5 Passwords]

You can also search by their login ID:

UPDATE `login` SET `user_pass` = MD5('NEW_PASSWORD') WHERE `userid`='THEIR_LOGIN_ID';

[installing a fresh svn]

In Linux:

1. delete the old folder

rm -rf trunk/

1b. or if you want to keep the folder as a backup, just rename it:

mv trunk/ old_trunk/

 

2. then checkout a new SVN Working Copy.

svn co http://svn.code.sf.net/p/rathena/svn/trunk/ trunk/

[No-IP]

You don't need to replace the IP addresses in the last line.

It should stay as-is:

subnet: 255.0.0.0:127.0.0.1:127.0.0.1

[svn update skipping]

hamburg142:~/Arbeitsfläche/trunk# svn update

Skipping .

 

That probably means your folder is not a SVN Working Copy.

Can you check if there is a .svn folder ?

ls -a ~/Arbeitsfläche/trunk/

[SQL update errors]

The first error "#1062 - Duplicate entry '1' for key 'PRIMARY'"

is probably because you are importing main.sql again.

When you imported main.sql the first time, it already created the server account with account_id = 1.

If you want to re-import main.sql, you should delete all the tables from your Ragnarok database first.

The second error -- you can fix this by using the 'mysql' command-line client instead of phpMyAdmin.

To import a file:

mysql -h 127.0.0.1 -u USER -p DATABASE < /path/to/rathena/sql-files/mob_skill_db.sql

- replace 127.0.0.1 with your MySQL server's IP

- replace USER with your MySQL username

- replace DATABASE with your Ragnarok database name

- when prompted, enter your MySQL password.

[MySQL Issue]

Connect to your MySQL database, then use the REPAIR TABLE query.

Ex:

REPAIR TABLE `char`;

If you use a MySQL client GUI program, it probably has a tool where you can "Select All" tables and click Repair.

[Nameless Island View]

In your client's GRF or data folder, edit /data/viewpointtable.txt

and remove the line(s) for each Abbey map.

[Modify server broadcast for rare drops]

oops I forgot we have to change it to clif_broadcast() so we can include the player's bl.

Find (that same line):

		intif_broadcast(message,strlen(message)+1,0);

Replace with:

		clif_broadcast(&sd->bl, message, (int)strlen(message)+1, 3, SELF);

Save, recompile, and that should work.

PS: to make the rare_drop_announce trigger sooner, you could temporarily set it higher

@setbattleflag rare_drop_announce 9000

[My SQL problem]

<using password: YES>

that means somewhere, a password is set for the 'root' MySQL user.

Check your import folder /conf/import/inter_conf.txt

[My SQL problem]

SQL configurations are in trunk/conf/inter_athena.conf

[How do I check if party exp share is set to even share?]

There are 2 places in script.c you have to add your script command.

For example get_revision:

BUILDIN_FUNC(get_revision) {
	const char * revision;

	if ( (revision = get_svn_revision()) != 0 )
		script_pushint(st,atoi(revision));
	else
		script_pushint(st,-1);//unknown

	return 0;
}

	BUILDIN_DEF(get_revision,""),

[How do I check if party exp share is set to even share?]

In the SQL table `party`, the `exp` column stores the Exp Share status.

I'm guessing 0 is off and 1 is on. You might want to double check that.

Remember that the value in SQL is not updated immediately when they change Exp Share in-game. I think it's autosaved every 300 seconds.

[Moving NPC Waitingroom Pub]

Your server is missing the delchar and charat script commands.

Are you not using rAthena?

[Multiple Map Servers]

Are you doing 1 login, 1 char, 2 map servers?

Or 1 login, 2 char+map servers?

[Control of the Treasure Boxes respawn in agits]

Hm,

Until someone figures something out, I was thinking maybe I should just unload the NPC that gives acces to the TB room...

(Can anyone please tell me where to find the concerned NPC, thanks)

They are located in the individual guild scripts.

For example: trunk/npc/guild/aldeg_cas01.txt you would commend out this NPC

// Guild Treasure Spawns
//============================================================
aldeg_cas01,118,223,0	duplicate(Gld_Trea_Spawn)	Treasure#aldeg_cas01	-1

[Modify server broadcast for rare drops]

trunk/src/map/pc.c around line 4706

		intif_broadcast(message,strlen(message)+1,0);

bc_self is "3", so change that line to:

		intif_broadcast(message,strlen(message)+1,3);

[Make rAthena server's timezone different than physical server's timezone?]

I think you would have to find all localtime in /src

and modify them to use gmtime instead. I'm not sure of the exact syntax.

[Failover Hosting (Multiple Hosts for 1 RO server)]

You can have multiple map-servers with some map(s) on each one, but I don't think there's any way to assign a map to multiple map-servers for failover.

[Utility: Stylist with autoscroll]

File Name: Stylist with autoscroll

File Submitter: Brian

File Submitted: 13 Jun 2013

File Category: Utilities

Content Author: Brian, Euphy

This is a modified version of the rAthena Stylist (trunk/npc/custom/stylist.txt)

It adds 2 new menu options "Next autoscroll" and "Previous autoscroll". When a player picks these options, after they close the NPC message box, the script will begin scrolling through palettes with a 1-second progressbar delay. To stop scrolling, just move your character and interrupt the progressbar.

Other changes from the original rAthena Stylist:

• after selecting "Previous", then Previous appears before Next in the menu
  
• starts at your current palette instead of always starting at #1
  
• the first menu (Cloth color, Hairstyle, Hair color) displays your current palette numbers
  

Click here to download this file

[SQL DB Error Need Help.]

Thanks for the bug report, I will fix this in the SVN.