[help... phpmyadmin]

Only you would know the correct directly of your files. I'm guessing it's /home/YOURUSERNAME/trunk/sql-files

It is beyond our scope, and really, you should ask Wanhosting for support. It is part of their job, isn't it?\

 

Ah, even worse, you're using VNC. So it must be /home/YOURUSERNAME/Desktop/trunk/sql-files

[help... phpmyadmin]

You don't have to log on to mysql before issuing the command.

Does the database ragnarok exist in your MySQL installation? You can use the command SHOW DATABASES to confirm.

 

If it doesn't, then omit the -D part, making the command. (Execute the commands on a new Terminal session)

cd /trunk/sql-files

mysql - u root -p ragnarok < main.sql

[Golden Thief Bug Effect]

I have it installed on my rAthena (rAmod) installation. I'll see if I can dissect it to parts and create a .diff for the bNoMagicDamage only.

[help... phpmyadmin]

At least let us know how it didn't work. What error(s) did it give out (if any)?

Or any other useful information that would help us help you resolve the issue.

 

Alternatively, you can do;

cd /rAthena/sql-files

mysql -u root -p -D YOURDATABASE < main.sql

Then type your root MySQL password when prompted to.

[ANTI DL IP]

This becomes a problem when you reach the 128 entry limit for arrays. Other than that, this should work.

-	script	dual_ip	-1,{
OnPCLoadMapEvent:
	getmapxy(.@amap$,.@mapx,.@mapy,0);
	
	if(.@amap$!="xmas") end; 
          
		query_sql("SELECT last_ip FROM `login` WHERE account_id = "+getcharid(3)+"", .@LastIP$);
		query_sql("SELECT account_id FROM `login` WHERE last_ip = '"+.@LastIP$+"'", .@AccountId);
		set .@aidtemp,getcharid(3,strcharinfo(0));

		for(set .@i ,0;.@i<getarraysize(.@AccountId);set .@i,.@i+1)
			{
				if(attachrid(.@AccountId[.@i]))
				{
					getmapxy(.@qmap$,.@qmapx,.@qmapy,0);
					if (.@qmap$== .@amap$) set .@j,.@j+1;
				}
				detachrid;
			}
		attachrid .@aidtemp;
		if(.@j > 1) {
			dispbottom "You may not dual client on this map.";
			warp "prontera",156,183;   
		}
	end;
}
   
   //------Enable map OnPCLoadMapEvent-------------------
xmas	mapflag	loadevent

Just replace xmas with the map of your choice.

[Golden Thief Bug Effect]

This is more of a Source Request than a Script Request. I've moved it to Source Request.

Have you taken a look at Epoque's old Extra Bonuses Pack? I think I saw that bNoMagicDamage effect from there.

[help... phpmyadmin]

You can use this command:

mysql -u root -p -D YOURDATABASE < /path/to/rAthena/sql-files/main.sql

[Need Help For Map Server Crashed!]

As Luciar suggested, a buggy script is causing it. Open /npc/scripts_custom.conf and examine each script that you've added there.

Open them all on Notepad++, press Ctrl+F, type bonus and click "Find All in All Opened Documents". Also, I've moved this topic to Scripting Support.

[Increase Storage Items]

If you're using a newer client, be careful and test your storage each time you decide to increase the max capacity.

I remember going only up to 700 before items magically vanish from my storage. Increase it by 50 or 100 incrementally.

[need need client and server file]

Please keep it on-topic. And @Tales, I understand that this guy is trying to ask for the sun and the moon.

However, telling them to buy something for you so that you'll help them is downright extortion. I wont give you warning points this time.

 

Also, I've moved this to Client-side request. Be nice to one another. It's what an open-source community is for.

[SC_SPECIALEFFECT or SPECIALEFFECT2 ?]

This is actually more of a Scripting Support.

@Tales, I think you must use freeloop(1) to prevent loop errors / crashes.

 

PS: Our Scripting Leaders should be able to provide you with a more precise answer.

[Harmony Patch Help]

This topic serves no purpose. You already have posted that here and here.

Really, how do you expect your patch to work if you don't even know how to properly add stuff to Makefiles?

 

This topic will be closed.

[Help weapon sprite (Rudra Bow)]

Edited topic title.

[How to add color in enchanted armor?]

I'm speculating here, but have you tried putting a value on cartprefixnametable.txt (postfixnametable) for the Enchants?

You can put "Str +X" or "Strenght" for the enchantments which increases Str, and so on.

[Editing of File Detected]

I'm a bit lost on this. Are you saying this is a feature on rAthena?

Can you please tell me the steps to properly reproduce this issue on a clean rAthena installation?

[Why payout taking too long?]

How about helping those who have purchased your products?

[compiling mapcache]

I think he wants to recompile his mapcache.dat, in that case you can use this tool, WeeMapCache.

[how to make custom mvp spawn at 7PM and 9PM?]

I have merged both topics. @dongkeyg, avoid making another post for the same problem / request.

[FluxCP Problem]

What did you change on your FluxCP installation? I noticed the Labels on the left menu are literally named Label, which shouldn't be.

Also, for your issue, I think it (/module) requires you to confirm the e-mail, by entering it twice, but your theme (/themes) doesn't show the text-box for it.

[Making SH file to Run 2 Servers]

 

Try and start each server manually;

cd /path/to/your/server

./login-server

./char-server

./map-server

./char-server2 (?)

./map-server2 (?)

 

Now if that works for you, then putting them on a shell script should be the easier part.

(?) - cause I really have no idea what your second char / map server are called.

 

It has the same name with char-server & map-server with the first server.

 

That's a really unhelpful feedback. Anyway, this Wiki article explains it best.

It even tells you what to do with your athena-start so you can start both servers at once. (Which solves your first problem)

[update emulator]

I've tried doing it on my Ubuntu test server, forcing shutdown in the middle of svn update, however, svn cleanup fixed it.

Can you not download a fresh copy instead? Or, try following the instructions (fix) I've found on this page.

[Making SH file to Run 2 Servers]

Try and start each server manually;

cd /path/to/your/server

./login-server

./char-server

./map-server

./char-server2 (?)

./map-server2 (?)

 

Now if that works for you, then putting them on a shell script should be the easier part.

(?) - cause I really have no idea what your second char / map server are called.

[Dynamically change the Level Share Range]

Variable       Full Name              Description
--------       ---------              -----------
sd             session data           represents the session of a client into a serv (login, char, or map)

You can find some interesting stuff regarding source from /doc/source_doc.txt

[cPanel to Windows Server]

Might have problems with how Windows handles authentications. I've once used a Windows machine,

but the server and website were both hosted inside, so just localhost. Anyway, here's a good read, you might find it useful.

[compilation error]

Please make sure your login-server / char-server / map-server are closed before trying to recompile.

Also, on where you see Debug, change it and make it Release. That would get rid of most warnings, but would still halt your compilation in case of an error.