[About SQL INSTALLING!]

Hi moneymuch,

Make sure you have a table named 'loginlog' in your 'ragnarok' database.

#Database: ragnarok
#Table: loginlog
CREATE TABLE `loginlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `ip` varchar(15) NOT NULL default '',
 `user` varchar(23) NOT NULL default '',
 `rcode` tinyint(4) NOT NULL default '0',
 `log` varchar(255) NOT NULL default '',
 INDEX (`ip`)
) ENGINE=MyISAM ;

Source: https://rathena.svn....-files/logs.sql

[Settings Problem]

Hi Mindless,

It seems that the Apache process cannot bind itself to port 80; usually this is because of 1 of the following reasons...

1) Another applications/process is currently using that port.

2) You have disabled that port via Firewall Settings.

3) Your ISP has blocked that port. (Only happens when you're using your WAN IP instead of LAN/Localhost)

[How to make 1 client 2 different setup?]

Hi V e r T i g O,

I'm pretty sure you'll only be using 1 login server; just create another login entry for the 2nd server so that you can use the same logins.

[Extract Rar. file in Linux]

Hi Aether,

Aerlinniel is right; that is specifically how to install un-rar on a CentOS/Scientific Distro. Here's a more detailed guide:

http://www.cyberciti.biz/faq/open-rar-file-or-extract-rar-files-under-linux-or-unix/

[Flux v4p paid addon]

Hi Thanna,

I've heard that Paradox sells this add-on; you should try to contact him.

[Need suggestions for full client hosting]

Hi Bahmut,

http://www.filedropper.com/

But if you're willing to spend some money, I would suggest going for a VPS with un-metered bandwidth.

1) You can host a seedbox which can upload to your leechers; enabling people to also put in the effort to share and seed as well.

2) You could host a webserver (Lighttpd, Apache, or nGinx) and then host the file there. With this, you can easily get a CDN (content delivery network) and provide fast download speeds all around the world; and you can use IPtables to limit the speed or max connections per IP to prevent Disk IO abuse from people who try to abuse your download.

[Fluxcp not showing "Mob database" only.]

Hi Chief,

Try turning on debug mode in application.php and also error reporting in error.php. Then see what errors it gives you when you try to search for the mob.

[Closed connection after login]

Hi Whales,

Did you use the bind_ip in 'char_athena.conf' and 'map_athena.conf'? Try commenting it out/removing it, then reloading your server.

[Is it possible to use sql table of an old server.]

Hi sampang99,

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/sql-files/

Run all the .sql files to your database starting from "upgrade_svn14036.sql", until you finish with "upgrade_svn15572.sql".

[How to compile mapcache in Linux?]

Hi Aether,

I believe you have to go to '/src/tool' and then type 'make mapcache'. It should be compiled, and then you have to go back to the root directory of the rAthena server files and then use it by typing './mapcache'.

[how to make this in php or in Mysql Query]

Hi Kariton Revolution,

simplehan is right. Here's a hint:

/*************
* SQL Table
*
CREATE TABLE `vote_point` (
`account_id` int(11) NOT NULL default '0',
`point` int(11) NOT NULL default '0',
`last_vote1` int(11) NOT NULL default '0',
`last_vote2` int(11) NOT NULL default '0',
`last_vote3` int(11) NOT NULL default '0',
`last_vote4` int(11) NOT NULL default '0',
`last_vote5` int(11) NOT NULL default '0',
`date` text NOT NULL,
PRIMARY KEY (`account_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
*
*
*************/

Good luck.

[phpMyAdmin]

Hi Janet,

Please read: http://www.thegeekstuff.com/2010/09/install-phpmyadmin/

Or use: http://lmgtfy.com/?q=phpmyadmin+linux

[[FluxCP] Warning: set_time_limit() has been disabled for security reasons]

Hi glemor123,

Try: http://www.wallpaperama.com/disp-post52.html

[[FluxCP] Warning: set_time_limit() has been disabled for security reasons]

Hi glemor123,

Use Google.com: http://lmgtfy.com/?q=windows+how+to+restart+php

http://www.phpfreaks.com/forums/index.php?topic=267521.0

[[FluxCP] Warning: set_time_limit() has been disabled for security reasons]

as far as I know you dont need to restart the server when you use init_set();

and also clear your fluxCP cache here at data/tmp/

Not the server itself, the PHP process. If he just edited the config, the PHP will still be on safe mode until he restarts the PHP service.

[[FluxCP] Warning: set_time_limit() has been disabled for security reasons]

Hi glemor123,

Did you restart your PHP service after you made that modification? You need to restart.

[Is it possible to use sql table of an old server.]

Hi sampan99,

Brian said to do the following...

1) Find out what SVN version you are using right now with the old SQL tables.

2) Look in rAthena's 'sql-files' folder and find the closest number for the revision that is above your revision number.

3) Then start running all the .sql files which are considered new updates from where your currently old revision left off at.

[error in login-server_sql (Database error)]

Hi Winz,

Go to the file, '/etc/my.ini'; do you see anywhere mentioning 'bind-address'? Is it active or is it commented out? (commented out: '#bind-address:')

[Preventing Wipeout when changing VPS host]

Hi noobsai,

Log in with PuTTY and type what trenx had already mentioned...

mysqldump -u USERNAME -p, --password=PASSWORD DATABASE_NAME > FILE_NAME.sql

Then just use WinSCP and transfer the file over to your computer. Also, a reminder... every name is CaSe-SeNsiTiVe.

[help, Access denied for user 'ragnarok@localhost']

Hi black_knighthood,

Do you have some sort of firewall? Try turning that off for a second and see if it works with it off. If not; then I'm out of ideas for you.

[Is it possible to use sql table of an old server.]

Hi sampang99,

Yes, it's possible. You would just need to adjust some tables to fit the format of the renewal databases.

[error in login-server_sql (Database error)]

Hi Winz,

That's correct. Make sure when you perform './configure' it outputs the value 'yes' for mySQL.

[help, Access denied for user 'ragnarok@localhost']

Hi black_knighthood,

I'm out of ideas, at a desperate attempt... I would suggest trying:

inter_athena.conf

sql.db_hostname: localhost
char_server_ip: localhost
map_server_ip: localhost
log_db_ip: localhost

If that doesn't work, I don't know what else you can do.

[help, Access denied for user 'ragnarok@localhost']

Hi black_knighthood,

Are you using a pre-compiled version of rAthena? Or did you compile this yourself? If you did get a pre-compiled, where did you get it from?

[error in login-server_sql (Database error)]

Hi Winz,

Did you compile rAthena correctly by including the mysql packages?

Source: http://rathena.org/w...g_Visual_Studio