Vip check Error

[melegy]

Player has logged in.
Mysql_real_query(): select 'vipdays' from ' accounts' where 'id' = 1 - mysql error: unkown column 'vipdays' in ' field list' <1054>
[ Error - creaturescript interface]
data/creaturescript/scripts/vipcheck.luanlogin
Description:
data/lib/004-database.lua:60: [result:getdataint] result not set!
stack traceback:
[c]: in function 'error'
data/lib/004-database.lua:60: in function 'getdataint'
datalib/050-funcation.lua:764: in funcation 'getplayervipdays'
data/creaturescripts/scripts/vipcheck.lua:3: in funcation <data/creaturescripts/scripts/vipcheck.lua:2>
Player has logged out.

Vip check script

--- Script by Kekox
function onLogin(cid)
         if getPlayerVipDays(cid) >= 1 then
            doPlayerSendTextMessage(cid, 19, "You have ".. getPlayerVipDays(cid) .." vip days left.")
         end
         return true
end

Help !
Regards.

 

[melegy]

UP!

 

[president vankk]

ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

 

[melegy]

works ok

 

[melegy]

ALTER TABLE `accounts` ADD `vipdays` int(11) NOT NULL DEFAULT 0;

thanks alot i've other issue in my site "guild war" section

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'voldera.guild_wars' doesn't exist' in C:\xampp\htdocs\wars.php:36 Stack trace: #0 C:\xampp\htdocs\wars.php(36): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(98): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\wars.php on line 36

 

[president vankk]

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT 0,
  `end` BIGINT NOT NULL DEFAULT 0,
  `frags` INT NOT NULL DEFAULT 0,
  `payment` BIGINT NOT NULL DEFAULT 0,
  `guild_kills` INT NOT NULL DEFAULT 0,
  `enemy_kills` INT NOT NULL DEFAULT 0,
  `status` TINYINT(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) 
)