ForgottenNot
Banned User
- Joined
- Feb 10, 2023
- Messages
- 303
- Reaction score
- 29
I use canary + znote in spite i have been updating it im facing an error that have not been able to fixx which is this
in appears in the premium status when someone research for X player. can you gelp me with this?
fixed
in character profile changed
to
LUA:
Fatal error: Uncaught mysqli_sql_exception: Unknown column 'premium_ends_at' in 'field list' in C:\xampp\htdocs\engine\database\connect.php:54 Stack trace: #0 C:\xampp\htdocs\engine\database\connect.php(54): mysqli_query(Object(mysqli), 'SELECT `premium...') #1 C:\xampp\htdocs\layout\sub\characterprofile.php(148): mysql_select_single('SELECT `premium...') #2 C:\xampp\htdocs\engine\init.php(169): require_once('C:\\xampp\\htdocs...') #3 C:\xampp\htdocs\characterprofile.php(1): require_once('C:\\xampp\\htdocs...') #4 {main} thrown in C:\xampp\htdocs\engine\database\connect.php on line 54
Post automatically merged:
fixed
in character profile changed
Code:
$acc_id = $profile_data['account_id'];
$premium_ends_at = mysql_select_single("SELECT `premium_ends_at` FROM `accounts` WHERE `id` = '$acc_id'");
if($premium_ends_at['premium_ends_at'] > 0)
echo '<strong><span style="color: green;">Premium Account</span></strong>';
else
echo 'Free Account';
LUA:
$acc_id = $profile_data['account_id'];
$premium_ends_at = mysql_select_single("SELECT `premdays` FROM `accounts` WHERE `id` = '$acc_id'");
if($premium_ends_at['premdays'] > 0)
echo '<strong><span style="color: green;">Premium Account</span></strong>';
else
echo 'Free Account';
Last edited:
