4 horas atrás, Vodkart disse:

executa no seu bando de dados:

 

ALTER TABLE `accounts` ADD `premiumgift` INT NOT NULL DEFAULT '0'

 

e usa seu script assim:

 

function onLogin(cid)
	local days = 3
	if db.getResult("SELECT `premiumgift` FROM `players` WHERE `id = "..getPlayerGUID(cid)):getDataInt("premiumgift") <= 0 then
		doPlayerAddPremiumDays(cid, days)
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Sua account acabou de receber "..days.." dias de premium, boa diversão!")
		db.executeQuery("UPDATE `accounts` SET `premiumgift` = 1 WHERE `id` = "..getPlayerAccountId(cid))
	end
	return true
end

[28/8/2016 7:49:15] mysql_real_query(): SELECT `premiumgift` FROM `players` WHERE `id = 55 - MYSQL ERROR: Unknown column 'premiumgift' in 'field list' (1054) 

[28/8/2016 7:49:15] [Error - CreatureScript Interface] 
[28/8/2016 7:49:15] data/creaturescripts/scripts/menor.lua:onLogin 
[28/8/2016 7:49:15] Description: 
[28/8/2016 7:49:15] data/lib/004-database.lua:60: [Result:getDataInt] Result not set! 
[28/8/2016 7:49:15] stack traceback: 
[28/8/2016 7:49:15] [C]: in function 'error' 
[28/8/2016 7:49:15] data/lib/004-database.lua:60: in function 'getDataInt' 
[28/8/2016 7:49:15] data/creaturescripts/scripts/menor.lua:3: in function 
[28/8/2016 7:49:15] Abnaroasaz has logged out. 

 

Deu esse erro ao logar o char

UP

vc nem executou a query na db

11 horas atrás, Vodkart disse:

vc nem executou a query na db

 

executei sim, as tabelas já estão la!

up