[Antrix] Integrated Web Account Signup and Status Page (SPORA for Antrix)

Quote:

---

Originally Posted by leway21

If you are using a logon and ascent db.. Just connect both in the config to logon. Worked for me.

$lang="en"; // Language ("en" - english, "ru" - russian)
$host="localhost"; // HOST for Antrix database
$user="root"; // USER for Antrix database
$password="*****"; // PASS for Antrix database
$db="ascentlogon"; // NAME of Antrix database
$hostr="127.0.0.1"; // HOST for Login database
$userr="root"; // USER for Login database
$passwordr="****"; // PASS for Login database
$dbr="ascentlogon"; // NAME of Login database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Antrix Server Address
$port = "8129"; // Antrix Server Port
$title="Server name"; // Insert the title of your server here
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...

---

Ty it worked =D

im getting the
"403 Forbidden problem"
When I look at my Apache Error Logs it says
[Fri Oct 05 14:52:07 2007] [error] [client 12.206.201.233>>My external IP] client denied by server configuration: C:/wamp/www/

Quote:

---

Originally Posted by Kandy

You may find some columns dont have defaults set, which could be an issue. Check the default values on all your columns and make sure gm, flags and banned have a default attached to them.

Execute this code on your Antrix SQL database if you need to, it may help you out:

Code:

---

ALTER TABLE `accounts` CHANGE COLUMN `gm` `gm` varchar(50) NOT NULL default '0';
ALTER TABLE `accounts` CHANGE COLUMN `flags` `flags` int(30) NOT NULL default '8';
ALTER TABLE `accounts` CHANGE COLUMN `banned` `banned` int(30) NOT NULL default '0';

---

Try making an account after correcting all the default values for those columns.

---

i am trying to do this but i don't use SQL Database so my database and realmd are just in a folder. but i cant create a account and i am trying to do this please tell me how do i do this without SQL ?.:scratch:

The latest versions do not require you to run those queries, because the php code takes care of any missing default values.

You don't need to run that script for the page to work. That script i wrote months ago during the early days of Antrix (Ascent), when the code required you to have default values defined, but now it has been taken care of.

Okay. For some reason my friend can't post here....anyways. I think he's has done everything right, but when I go to the DNS link it displays this:

http://img137.imageshack.us/img137/179/screenqm4.png

I'm receiving this error after trying to create an account:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Wamp\www\index.php on line 479 at the top of the screen...

And in the middle it says "Creation of account test was not possible!" after trying to create an account called "test".

Thanks in advance,

Jay

Nevermind I fixed my problem, logonserver info is your character db.. not world db (I had my world db in place).

Thanks.

hey sorry for me english no good
i use mangos tbc 2.2.3 db rave 18 project silvermoon
and i configure a site php + i go in create account and have one erro and are:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479

$lang="en"; // Language ("en" - english, "ru" - russian)
$title="WoW BLOODLOST"; // WOW BLOODLOST
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="*******"; // PASS for Character database
$db="Mangos"; // NAME of Character database
$hostr="127.0.0.1"; // HOST for Logonserver database
$userr="root"; // USER for Logonserver database
$passwordr="******"; // PASS for Logonserver database
$dbr="Mangos"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "3306"; // Ascent Server Port
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...



me port mangos are 3306 *

hey, i cant get wamp to install apeche! it says cant use the port... can i change it somehow?

Kandy, can you please tell me why when i run that web page ,it dont show players online ....,i will be happy if you help me (my english is bad)

this was being developed for wow ver 2.2.3
i doubt it will work for 2.3.0

Quote:

---

Originally Posted by Linkinpark

Kandy, can you please tell me why when i run that web page ,it dont show players online ....,i will be happy if you help me (my english is bad)

---

Make sure the $host, $user, $password and $db values are pointing to your Character Database for players to be detected and show.

@Pepster, it works for 2.3.0. The only recent account table change was ForceLanguage, which if you set up that new column according to the Ascent SVN, it will have a default value if no other value is given, so the page will still insert new accounts fine.

Tips to getting the Page running:

Use WAMP
Open Port 80


How I Got The Page Running:
Opened Port 80
Downloaded SPORA, Extracted It, Put It In C:\wamp\www
Setup the config file that was included in the SPORA Download
Thats all i did.

It makes account fine , my problem is why the page dont show users online :S

fixed, never mind

So its to create only? Is there a web UI that allows GMs to modify users accounts? Add GM status, turn on/off BC, etc?

Rofl nice work.... Keep it up :D

http://127.0.0.1/index.php?f=1&s=0

Does this site work?

Quote:

---

Originally Posted by 1337Jewer

http://127.0.0.1/index.php?f=1&s=0

Does this site work?

---

127.0.0.1 is a loopback address, it always points back to what ever computer you are currently on. So not, that would loop me back to my computer, which is not running a web server.

hey im having trouble with mine
i can get on it but no one else can
when i run my server -nonhamachi people get on it so i dont think firewall is the problem, do you absolutely need mysql on wamp running? cause when i start it it stays on for...5 seconds then shuts off
what should i do?

$lang="en"; // Language ("en" - english, "ru" - russian)
$host="projectwow.servebbs.net"; // HOST for Antrix database
$user="root"; // USER for Antrix database
$password="pass"; // PASS for Antrix database
$db="ascent"; // NAME of Antrix database
$hostr="projectwow.servebbs.net"; // HOST for Login database
$userr="root"; // USER for Login database
$passwordr="pass"; // PASS for Login database
$dbr="character"; // NAME of Login database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "projectwow.servebbs.net"; // Antrix Server Address
$port = "8129"; // Antrix Server Port
$title="Project WoW"; // Insert the title of your server here
$lock_acc=0; // Lock created account to IP address (1 - on, 0 - off)
$lock_reg=0; // Registration only one (or more) account from one IP address
// 0 - not limit, 1 - one acc, 2 - two acc, etc...

Omg this sucks I can't get this to work for some reason. I could make accounts on my account at epixwow.ath.cx but others can't go on Http://epixwow.ath.cx/ even when i do have DNS and that stuff. It says that they are forbidden to join that server or something like that.

Help please?

Port forward 80?

ok so i am guessing the port is not forwarded. Anyway how do i forward it.

Quote:

---

Originally Posted by Kandy

Nesis i do help people, you can see i do post, but i don't like repeating myself when the answer you are looking for are mostly already in this thread.

Those errors you are getting are either because you have not configured your MySQL settings in the configuration section correctly or your user settings need checking. The page is not connecting to your SQL database!

Now with reloading of accounts. This is done automatically by Antrix, you specify the amount of time it takes to reload accounts in logonserver.conf.

Code:

---

# Account Refresh Time
#
#    This controls on which time interval accounts gets
#    refreshed. (In seconds)
#    Default = 600
#
<Rates AccountRefresh = "600">

---

Default is 10 minutes.

If you wish do reload accounts quicker, reducer the amount of seconds to make it reload faster.

---

Still I dunno what's bad about it. Everything set to right.
I have the EXACT Probelm as Nesis.

Can you help me, out, pretty pelase?

hey since i cant get it to work with nonhamachi public i made it so it will work on hamachi people can now get on the account creation site but they get this error:
Error: Unable to connect to MySQL server. MySQL reported: Host 'KOLE' is not allowed to connect to this MySQL server.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479
Error: Unable to connect to MySQL server. MySQL reported: Host 'KOLE' is not allowed to connect to this MySQL server.