-
[Help] KoPanel Rank
Code:
<?php
$dbname = "KN_online"; // Database Name
$dbuser = "knight"; // Username
$dbpass = "knight"; // Password
$msconnect=odbc_connect("$dbname","$dbuser","$dbpass");
$getrankacc = "SELECT donator FROM tb_user WHERE strACcountID = '$accname'";
$getrankacc2=odbc_exec($msconnect,$getrankacc) or die(odbc_error());
odbc_fetch_row($getrankacc2);
$newrankacc = odbc_result($getrankacc2, 1);
if (odbc_result($newrankacc,1) == 1) {
$rankacc = 'Gold Member';
header("Location: index.php");
}
if (odbc_result($newrankacc,1) == 0) {
$rankacc = 'Regular Member';
header("Location: index.php");
}
?>
Script loads fine but it somehow always says: Regular member rank.
i want it to say Rank: Gold Member, when column donator in TB_USER is: 1 and Regular Member when column donator in TB_USER is: 0
please help me with this!
i worked like 2 hours long trying to fix it lol