Anyone able to help with a PHP script by chance?

[DoxramosPS]

So I found Aquaflame CMS which I'm quite fond of and I was wondering if anyone could help with the registration section of it.
The current PHP code for the registration is set at

mysql_select_db($server_adb,$connection_setup)or die(mysql_error());
                $accinfoq = mysql_query("SELECT * FROM account WHERE username = '".$accountName."'");
                $accinfo = mysql_num_rows($accinfoq);
          
                if ($accinfo == 0)
                {
                    $sha_pass_hash= sha1(strtoupper($accountName ) . ":" . strtoupper($accountPass));
                    $register_logon = mysql_query("INSERT INTO account (username,sha_pass_hash,email,last_ip,expansion) VALUES (UPPER('".$accountName."'),  CONCAT('".$sha_pass_hash."'),'".$accountEmail."','".$ip."','3')")or die(mysql_error());
              
                    mysql_select_db($server_adb,$connection_setup)or die(mysql_error());
                              $accountinfo = mysql_fetch_assoc(mysql_query("SELECT * FROM account WHERE username = UPPER('".$accountName."')"));
                    mysql_select_db($server_db,$connection_setup)or die(mysql_error());
                    $register_cms = mysql_query("INSERT INTO users (id,class,firstName,lastName,registerIp,country,birth,quest1,ans1) VALUES ('".mysql_real_escape_string($accountinfo['id'])."','0','".$firstName."','".$lastName."','".$ip."','".$country."','".$dob."','".$question."',UPPER('".$answer."'))");  

I don't see any issues with the current setup, so if anyone has any idea please help. Thanks

[ev0]

So what's the problem, error wise? also wrap the code in the php /php tags.

[DoxramosPS]

When the user goes to register it simply gives the error that a problem has occured; trying to put echo $register_logon but it's not displaying any results at all.

[ev0]

When the user goes to register it simply gives the error that a problem has occured; trying to put echo $register_logon but it's not displaying any results at all.

I'd have to see how the whole page processes, but it looks like that you forgot a } at the end there to close the if statement.... Not sure if that's the error, but that's all i can see at this second. haha.

[ev0]

Also, throw a die(mysql_error()); at the end of all the queries, see if we can print some sort of error

[DoxramosPS]

Finally got it to output, but it only displays 1 in the query result. What could be used to try to help find the issue here?
Sorry; just saw your newer posts. I'll give it a go and see what we can come up with.

[ev0]

Finally got it to output, but it only displays 1 in the query result. What could be used to try to help find the issue here?
Sorry; just saw your newer posts. I'll give it a go and see what we can come up with.

It displays a 1 because that user is found in the database. You want a 0, non-registered account.

mysql_select_db($server_adb,$connection_setup)or die(mysql_error());
                $accinfoq = mysql_query("SELECT * FROM account WHERE username = '".$accountName."'");
                $accinfo = mysql_num_rows($accinfoq);  

This queries the database, checks if the user name is already there. If the database returns with a result other than 0 it will error (error because your code doesn't have an }else{ )

[DoxramosPS]

Odd; I checked the DB and the user doesn't exist =/

[ev0]

Odd; I checked the DB and the user doesn't exist =/

Code doesn't lie. It's searching by username, mind you.

[DoxramosPS]

Yeah; gonna try to query the error and clear the databases out and see if maybe that resolves the issue.

[DoxramosPS]

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /register.php on line 174

Line 174 is actually completely blank.

[ev0]

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /register.php on line 174

Line 174 is actually completely blank.

That's an error with your database connection lol.

[DoxramosPS]

lol yes it is! Double checked my website database and the issue lied in my script to update with the new values didn't work. Got the new values in and working like a charm =D Thanks a ton for the help.

[ev0]

lol yes it is! Double checked my website database and the issue lied in my script to update with the new values didn't work. Got the new values in and working like a charm =D Thanks a ton for the help.

Always my pleasure, PHP is my life. I have it tattooed on my arm :P

[Fisher]

Always my pleasure, PHP is my life. I have it tattooed on my arm :P

I want to see that. And if its not mysql_select_tits no rep for you sir