Windows Vip end.

[Natan Beckman]

Solved!

 

[Natan Beckman]

you sent me this:

function onThink(interval, lastExecution, thinkInterval)
	local Query = db.getResult("SELECT `id`, `vip_time` FROM `accounts` WHERE `accounts`.`vip` = 1")
	if Query:getID() == -1 then
		return true
	end
	for i = 1, Query:getRows() do
		local AccID = Query:getDataInt('id')
		local VipTime = Query:getDataInt('vip_time')
		if VipTime >= os.time() then
			db.executeQuery("UPDATE `accounts` SET `vip_days` = ".. math.ceil((VipTime - os.time()) / 86400) .." WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")
		else
			db.executeQuery("UPDATE `accounts` SET `vip_time` = 0, `vip_days` = 0, `vip` = 0 WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")
			db.executeQuery("UPDATE `players` SET `reset_temple` = 1 WHERE `players`.`account_id` = ".. AccID ..";")
		end
		Query:next()
	end
	Query:free()
	return true
end

gave this error:

[9:40:02.714] mysql_real_query(): SELECT `id`, `vip_time` FROM `accounts` WHERE `accounts`.`vip` = 1 - MYSQL ERROR: Unknown column 'accounts.vip' in 'where clause' (1054)

all right here says I do not have a column vip.
But I really do not have this column.
i have somente a column vip_time.
will that this work?

function onThink(interval, lastExecution, thinkInterval)
	local Query = db.getResult("SELECT `id`, `vip_time` FROM `accounts` WHERE `accounts`.`vip_time` = 0")
	if Query:getID() == -1 then
		return true
	end
	for i = 1, Query:getRows() do
		local AccID = Query:getDataInt('id')
		local VipTime = Query:getDataInt('vip_time')
		if VipTime >= os.time() then
			db.executeQuery("UPDATE `accounts` SET `vip_days` = ".. math.ceil((VipTime - os.time()) / 86400) .." WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")
		else
			db.executeQuery("UPDATE `accounts` SET `vip_time` = 0, `vip_days` = 0, `vip` = 0 WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")
			db.executeQuery("UPDATE `players` SET `reset_temple` = 1 WHERE `players`.`account_id` = ".. AccID ..";")
		end
		Query:next()
	end
	Query:free()
	return true
end

 

[Natan Beckman]

cyko i modified for:

function onThink(interval, lastExecution, thinkInterval)
    local Query = db.getResult("SELECT `id`, `vip_time` FROM `accounts` WHERE `accounts`.`vip_time` = 0")
    if Query:getID() == -1 then
        return true
    end
    for i = 1, Query:getRows() do
        local AccID = Query:getDataInt('id')
        local VipTime = Query:getDataInt('vip_time')
        if VipTime >= os.time() then
            db.executeQuery("UPDATE `accounts` SET `vip_days` = ".. math.ceil((Vip_Time - os.time()) / 86400) .." WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")
        else
            db.executeQuery("UPDATE `accounts` SET `vip_time` = 0 WHERE `accounts`.`id` = ".. AccID .." LIMIT 1;")

        end
        Query:next()
    end
    Query:free()
    return true
end

no have more erros in console.
more the system no works.

 

[Cykotitan]

Mock's VIP system doesn't need this script.

 

[Natan Beckman]

bump

 

[Natan Beckman]

Vip System.lua

 

[Natan Beckman]

bump ;C

 

[Qbee]

Mock's VIP system doesn't need this script.

So what do you want Natan?

 

[Natan Beckman]

a function to clean when you finish the vip column vip_time

 

[Luke sky walker]

Natan Beckman add me in msn i help you [email protected]