VIP Medal that inserts VIPDAYS into mysql database

[Extrodus]

Im making this thread to ask the community if its possible to take the common vip medal script, and make it so the vip medal adds 7 days to the database.

It would have to be something along the lines of <insert into structure "accounts' column "vipdays" of "player using medal" the amount of "7">

Thats not what it would look like, but thats what it would have to do. (I cant script code like that luls)

Code from vip medal for storage:

local days = 30
local levelToBeVIP = 1
 
function onUse(cid, item, fromPosition, itemEx, toPosition)
	if getPlayerLevel(cid) >= levelToBeVIP then
		if isPlayerVip(cid) == FALSE then
			doCreatureSay(cid, "CONGRATULATIONS! You are now a VIP for "..days.." days! You can now enter the VIP-area and use unique features!. ", TALKTYPE_ORANGE_1)
		end
		doSendAnimatedText(getPlayerPosition(cid), "Welcome!", TEXTCOLOR_RED) 
		doPlayerAddVipDays(cid, days)
		doRemoveItem(item.uid, 1)
		doSendAnimatedText(getCreaturePosition(cid), "+"..days.." days", 30)
	else
		doPlayerSendCancel(cid, "You need level "..levelToBeVIP.." to be a VIP player.")
	end	
	return TRUE
end

Hopefully someone can help me on this, or even understands what Im talking about and can give me some info.

 

[sikkee]

Sounds like a good idea, i want it too!

 

[Acubens]

db.executeQuery("UPDATE `accounts` SET `vipdays` = `vipdays` + "..days.." WHERE `id` = "..getPlayerAccountId(cid)..";")

??

 

[Tovar]

Here you can found it. http://otland.net/f163/best-vip-system-ever-action-movevent-globalevent-71638/