[Costume_Converter.diff error, need help fixing script.c]

They refactored the script_rid2sd command. To fix, change the instances of

sd = script_rid2sd(st);

into

script_rid2sd(sd);

If you check script.c you can see how they use the command.

[SQL, access denied for user "root@localhost" and incorrect client version]

That has to do with your data folder or grf. In the clientinfo.xml file, it needs to look something like this:

<address>127.0.0.1</address>
<port>6900</port>
<version>53</version>

 

Make sure you have the version tag and it's set to 53.

[SQL, access denied for user "root@localhost" and incorrect client version]

Okay! Your problem is that while you set the password fields in inter_athen.conf to blank... the server does not read those lines when the password is blank. So it's trying to use the default password of "ragnarok".

I would suggest going into Workbench as root and creating a new user for your server with a username and password.

 

You could run these commands in workbench to setup a user using the default rA username and password.

CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok';
GRANT SELECT,INSERT,UPDATE,DELETE ON ragnarok.* TO 'ragnarok'@'localhost';

 

[please Help Cannot Connect mysql]

What you have to configure is the MySQL user, which is different from the user inside the login table. The userid and passwd fields inside map_athena.conf are for the login table. But all those db_id and db_pw inside the inter_athena.conf are for MySQL users.

A quick fix will be to run these two lines in phpMyAdmin under the SQL option. I based the values on your last screenshot.

CREATE USER 'ragnarok'@'localhost' IDENTIFIED BY 'ragnarok2';
GRANT SELECT,INSERT,UPDATE,DELETE ON ragnarok.* TO 'ragnarok'@'localhost';

And then make sure in inter_athena.conf all the db_id are ragnarok and all the db_pw are ragnarok2. 

Similarly, make sure the userid and passwd fields in the other conf files match what you have in the login table.

 

[Modifying @whosell Command]

This will do what you want. http://pastebin.com/5Kwt41h6