~ AUTHORIZED RELEASE ~ NIVADE V1.2, RAPIDSHARE PREMIUM LINK

Quote:

---

Originally Posted by Colin-Roberts

thought of that, was on my register page

---

Impossible, as it is connecting to localhost not the nivade IP for the db.

http://zetolic.com/social/ try and register, register apparently works but the login doesn't and theres nothing in phpmyadmin

Quote:

---

Originally Posted by Colin-Roberts

http://zetolic.com/social/ try and register, register apparently works but the login doesn't and theres nothing in phpmyadmin

---

Hmm, strange.

I've done a core, similar to yours, that has the line:

PHP Code:

---

$check_ban_number = mysql_fetch_object( $check_ban ); 


---

But I get this error;

Quote:

---

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in \\nas-001\winspace002\10-didehvar.com\www\fivid\includes\core.php on line 23

---

Any ideas, is it worth contacting host or is it a bad php mistake?

Full File:

Show Hide

( do you like my fivid copy? ) ( and this is only for a personal project :) )

PHP Code:

---

<?
session_start();

/*    
     _ _ _                _
    |  _ _|              | |
    | |_ _(_)_   _ (_) __| |
    |  _ _| | \ / /| |/ _  |
    | |   | |\ V / | | (_) |
    |_|   |_| \_(c)|_|\__,_|
                        core.    
            Code & graphics copyrighted (c).
            Created by.

*/

mysql_connect( 'i loled, i posted these details' );
mysql_select_db( 'user_data' );

$username = $_SESSION['username'];

$check_ban = mysql_query( "SELECT * FROM `user_data` WHERE `username` = '$username'");
$check_ban_number = mysql_fetch_object( $check_ban );

if ( $check_ban_number->banned == 'true' );
{
    echo("Sorry, you have been banned for: " . $check_ban_number->ban_reason);
    
    session_destroy();
    exit();
}

?>

---

Quote:

---

Originally Posted by Jam-ez

I've done a core, similar to yours, that has the line:

PHP Code:

---

$check_ban_number = mysql_fetch_object( $check_ban ); 


---

But I get this error;



Any ideas, is it worth contacting host or is it a bad php mistake?

Full File:

Show Hide

( do you like my fivid copy? ) ( and this is only for a personal project :) )

PHP Code:

---

<?
session_start();

/*    
     _ _ _                _
    |  _ _|              | |
    | |_ _(_)_   _ (_) __| |
    |  _ _| | \ / /| |/ _  |
    | |   | |\ V / | | (_) |
    |_|   |_| \_(c)|_|\__,_|
                        core.    
            Code & graphics copyrighted (c).
            Created by.

*/

mysql_connect( 'i loled, i posted these details' );
mysql_select_db( 'user_data' );

$username = $_SESSION['username'];

$check_ban = mysql_query( "SELECT * FROM `user_data` WHERE `username` = '$username'");
$check_ban_number = mysql_fetch_object( $check_ban );

if ( $check_ban_number->banned == 'true' );
{
    echo("Sorry, you have been banned for: " . $check_ban_number->ban_reason);
    
    session_destroy();
    exit();
}

?>

---

---

Ensure that you have fields named "username", "ban_reason", "banned"

Quote:

---

Originally Posted by Calon

Ensure that you have fields named "username", "ban_reason", "banned"

---

I have, but perhaps it would be because there's no accounts at the moment.

Oh, and it's actually saying I'm banned as well (after that error).

Thanks, a nice bit of code to play around with :)

Quote:

---

Originally Posted by Calon

Ensure that you have fields named "username", "ban_reason", "banned"

---

Just added myself to the table, and still doesn't work. I do have all them fields...

Anyone have any ideas?

Edit: Found problem, I was connecting to table instead of database.
(DUH)

Edit2: Now it's saying I'm banned, when I'm not even logged in and the field isn't set to true..

Can't edit:

Is it because its doing this:

PHP Code:

---

$username = $_SESSION['username'];

$check_ban = mysql_query( "SELECT * FROM `user_data` WHERE `username` = '$username'"); 


---

But the session username hasn't been set?

Quote:

---

Originally Posted by Jam-ez

Can't edit:

Is it because its doing this:

PHP Code:

---

$username = $_SESSION['username'];

$check_ban = mysql_query( "SELECT * FROM `user_data` WHERE `username` = '$username'"); 


---

But the session username hasn't been set?

---

If I remember correctly, I removed the ban code.

And the session hasn't been set, it's so $username can be called instead of $_SESSION[ 'username' ]