Simple Account Rankings

[HellFire]

<?php
// Connection parameters
$sqlserver = "1";
$username = "1";
$password = "1";

session_start();



// Make connection
$conn = odbc_connect($sqlserver, $username, $password);
// Execute query
$sql = "SELECT Rank FROM TB_USER WHERE strAccountID = '".$_SESSION['sesuser']."'";
$myrank = odbc_exec($conn,$sql);

// Display information

while ($row = odbc_fetch_array($myrank)){

if ($row == 1)
{
$rankacc = "Regular Member";
}

}

?>

when i include this to main.php,

and so a simple thing like echo $rankacc; it wont display anything. the code seems pretty alright to me.

 

[HellFire]

woops fixed it already, hum strange i couldnt fix it 7 days ago lol.

anyway for teh leechers:

<?php





// Make connection
$conn = odbc_connect($sqlserver, $username, $password);
// Execute query
$sql = "SELECT Rank FROM TB_USER WHERE strAccountID = '".$_SESSION['sesuser']."'";
$myrank = odbc_exec($conn,$sql);

// Display information

while ($row = odbc_fetch_row($myrank)){

if ($row == 1)
{
$rankacc = "Regular Member";
}

}

?>

 

[HellFire]

too quick with posting, it shows regular member regardless of row data,
if i add

if ($row == "2")
{
$rankacc = "Gold Member";
}

it shows goldmember while my row is still 1/NULL

 

[HellFire]

nvm, got it all fixed.

 

[OMEGAbuffer]

woops fixed it already, hum strange i couldnt fix it 7 days ago lol.

anyway for teh leechers:

<?php
// Connection parameters
$sqlserver = "KN_online";
$username = "knight";
$password = "knight";




// Make connection
$conn = odbc_connect($sqlserver, $username, $password);
// Execute query
$sql = "SELECT Rank FROM TB_USER WHERE strAccountID = '".$_SESSION['sesuser']."'";
$myrank = odbc_exec($conn,$sql);

// Display information

while ($row = odbc_fetch_row($myrank)){

if ($row == 1)
{
$rankacc = "Regular Member";
}

}

?>

You posted your database password in there.

 

[HellFire]

you can edit your quote?

 

[IceMan1300]

you can edit your quote?

Just change your database password...

 

[HellFire]

lol? i got it hex edited in all my exes..........

 

[IceMan1300]

lol? i got it hex edited in all my exes..........

Only one, Ebenezer.

So hex it again?.. it isn't that hard..

This page has been cached, added to archives, and a bzillion people have already read it.
Anyone stupid enough to retain the same old password doesn't deserve to host a server at all...

 

[HellFire]

already got it changed,

close this topic.