Help with SPORA

I got SPORA and WAMP5 set up, but for some reason it doesnt work how it should.

Can you please goto http://zidwow.homeip.net/ and try to create an account, and help me with the error it shows.

Thanks in advance

Information needed. Btw your page doesnt work.

For Ascent I got a good spora I used when I tested the DB's in RaGezone.

http://mucski.evonet.ro/stuff/ascentnobug/ascentwww.rar

Go to config.php ... everything is self explanatory. 100% runs. Well at least it did for me.

Sorry, try now... Firewall was blocking access.

If the DNS domain doesnt work, you can also get to the page by going to:
Ziddy's WoW Server is offline

++ Bump ++

"Ziddy's WoW Server is offline"

Code:

---

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479

---

Did you downloaded the spora I used? Mine worked fine with no MYSQL errors.

I listed the link up there....

If you trying to install that Spora for Mangos , than it wont work because the table differs from Ascent ....

Its one that has been modified for Ascent

And yea, i tried your version and got the same problem.

Quote:

---

Originally Posted by ziddy1232

Its one that has been modified for Ascent

And yea, i tried your version and got the same problem.

---

post your index PHP file here. ill take a look

Quote:

---

Originally Posted by mucski

Information needed. Btw your page doesnt work.

For Ascent I got a good spora I used when I tested the DB's in RaGezone.

http://mucski.evonet.ro/stuff/ascentnobug/ascentwww.rar

Go to config.php ... everything is self explanatory. 100% runs. Well at least it did for me.

---

carefull darling.....

your Config file in your download link has your information, i suggest to remove it. for your own security

Here you go... (I edited out my PW, it isnt actually ****)


[php]
<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.

Original Creation by mirage666 for MaNGOS http://pomm.da.ru/

Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // 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="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // 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...

Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '

[quote=ziddy1232;3091879]Here you go... (I edited out my PW, it isnt actually ****)


[php]
<?php
/*
SPORA for Ascent v1.4
Simple Page Of Registration of Accounts for Ascent
It is made in the form of one page with fields of input of the
information of an account and the list of players being on a server.

Original Creation by mirage666 for MaNGOS http://pomm.da.ru/

Modified for Ascent by Kandyman http://www.burning-wow.com
*/
$lang="en"; // Language ("en" - english, "ru" - russian)
$title="Ziddy WoW Server"; // Insert the title of your server here
$host="127.0.0.1"; // HOST for Character database
$user="root"; // USER for Character database
$password="****"; // PASS for Character database
$db="character"; // 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="world"; // NAME of Logonserver database
$database_encoding = 'CP1251'; // Set encoding
$img_base = "img/"; // Image dir
$server = "127.0.0.1"; // Ascent Server Address
$port = "8129"; // 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...

Switch ($lang)
{
case "en":
$button="create_en.gif";
$text = Array(
'acc' => 'Creation of account',
'create' => 'is completed !',
'failed' => 'was not possible !',
'not_all' => 'Fields are filled not all',
'taken' => 'is already taken !',
'playerson' => 'players online',
'off' => 'is offline',
'name' => 'Account Name',
'password' => 'Password',
'ip_limit' => Array('From your IP ',' accounts are already created'),
'char' => Array('Name','Race','Class','LvL','Location'),
);
break;
case "ru":
$button="create_ru.gif";
$text = Array(
'acc' => '

When i goto the page i see it, and its fine. I can access it through localhost and external I.P.

I am behind a router, and i have forwarded port 80, and disabled my firewall, but i still get the same issue.

And im from the U.K. My ISP is BT Broadband and i use thier router, called the BT Home Hub.

Quote:

---

Originally Posted by ziddy1232

When i goto the page i see it, and its fine. I can access it through localhost and external I.P.

I am behind a router, and i have forwarded port 80, and disabled my firewall, but i still get the same issue.

And im from the U.K. My ISP is BT Broadband and i use thier router, called the BT Home Hub.

---

hmm ...

tell you the truth

i never got my wamp working with my ISP (videotron)

so i simply pay 2.99$ / month to webhostfreaks.com to host my php file

Yea, i think i might have to do the same...

Thanks for trying anyway

btw, i have sent you a PM :)

Edited post:

Please ignore what I had just originally posted, I actually thoroughly read it..

Code:

---

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\wamp\www\index.php on line 479

---

This is indicating that your number of rows (in this case, I believe it is your columns) in your accounts table, is counting a different amount than what it should be.

Take a screenshot of your accounts table, and post it here.

Here you go...

[img=http://img176.imageshack.us/img176/2503/34993286mq8.th.jpg]

++EDIT++

Heres a slightly better view:

http://img176.imageshack.us/img176/4...5933at2.th.jpg

Wow for me worked everytime ... mhmm ... it did always.

I apologize, I wasn't right. Your table is completely fine. However, if that is being called bad in your .php file, go check it out, see what it is reading in. Could be a typo by someone. :P

I have no idea what the problem could be... I posted my .php file, so why dont you check it for a typo xP

Sorry wasn't paying attention to that.

Maybe this line is your culprit?

Code:

---

if($realm_db->query("INSERT INTO `accounts` (`login`,`password`,`email`,`lastip`,`gm`,`banned`,`flags`) VALUES ('$username','$passw','$email','$ip','0','0','$tbc')"))

---

Sorry im a real noob when it comes to php...

What do i change?

Sorry for being such an idiot, its probably really obvious too

Perhaps rr2739 would have better knowledge of this than I would... I'm not really too sure why I highlighted that.

Okay, i have got some free hosting from x10 Hosting, and i have uploaded the files but im still getting the same error...

rr2739, could you take a look through my .php file for me?

Also, could you suggest any other simple registration page? I dont want a huge Blizzlike one as it takes forever to upload and configure, and im pritty lazy xD lol

Would be of much help if we can see your PHP page.

How do I fix this up:
Error: Unable to connect to MySQL server. MySQL reported: Can't connect to MySQL server on '[my ip filled in here]' (4).
Well.. When I fill in localhost it gives me this:
Error: Unable to connect to MySQL server. MySQL reported: Access denied for user 'root'@'localhost' (using password: YES). So idk what to do lol. Site is hosted at:
Bloody WoW. A part of the BloodyScape Comunity is offline

Does anyone has a solution?

Quote:

---

Originally Posted by ziddy1232

I have no idea what the problem could be... I posted my .php file, so why dont you check it for a typo xP

---

well i hope that 127.0.0.1 / locahost is not in your index file right?

cause when someone else access it , localhost/127.0.0.1 means nothing.

so change it to your dyndns address or external ip


also jsut a thought.

can you kinda show me a picture of an error , caus eicant seem to find it ion this thread.


and to be sure. So everyting woprks , except others cant access your page?