Vip System v2.0

Shawak · Aug 30, 2009

Hello,
Since I noticed that a storage value isn't very good for a vip system,
I decided to make a new one, with db qeurys and entrys ^_^.

Credits:
- Idea:
http://otland.net/f82/vip-system-19426/
- Script:
100% by me

Version:
- Tested on TFS 0.3.5pl1.
- Should work with other TFSs.

New lua functions:

Code:

setPlayerVipTime(cid, days, hours, minutes, seconds)       -- set player XXX Vip days // return TRUE
getPlayerVipTime(cid, "days"/"hours"/"minutes"/"seconds")  -- get player current Vip time left // return type
isPlayerVip(cid)                                           -- check if player is vip // return TRUE (if player is Vip) or FALSE (if player isn't Vip)
doPlayerAddVipTime(cid, days/hours/minutes/seconds)        -- add player vip time // return TRUE
doPlayerRemoveVip(cid)                                     -- remove player Vip and set Vip time to 0 // return TRUE

Changelog:
v2.0:

Code:

- Changed some lua functions.
- Added db entry + querys.
- Added types in lua functions.

v1.0:
[Old Version] - http://otland.net/f163/full-working-vip-system-shawak-44840/

Script:
- go to your database and enter this query:

HTML:

ALTER TABLE `players` ADD `vip_time` BIGINT(32) NOT NULL DEFAULT 0;

- data/lib/data.lua, at the end:

Lua:

dofile("vip.lua")

After that go to your server file, where you .exe is, and paste this .lua file:

Lua:

--[[
	VIP System by Shawak
	Db Query: "ALTER TABLE `players` ADD `vip_time` BIGINT(32) NOT NULL DEFAULT 0;"
]]--

function setPlayerVipTime(cid, days, hours, minutes, seconds)
	return db.executeQuery("UPDATE `players` SET `vip_time` = ("..os.time().." + "..days.."*86400+"..hours.."*3600+"..minutes.."*60+"..seconds..") WHERE `id` = "..getPlayerGUID(cid)..";")
end

function getPlayerVipTime(cid, type)
	times, r = {
		["days"] = 86400,
		["hours"] = 3600,
		["minutes"] = 60,
		["seconds"] = 1
	}, 0
        query = db.getResult("SELECT `vip_time` FROM `players` WHERE `id` = "..getPlayerGUID(cid)..";")
	if(query:getID() ~= -1) then
		time = times[type]
		if time ~= FALSE then
	 		left = query:getDataInt("vip_time") - os.time()
		 	while left >= time do
				left = left - time
				r = r+1
			end
		end
	end
	query:free()
        return r
end

function isPlayerVip(cid)
	query = db.getResult("SELECT `vip_time` FROM `players` WHERE `id` = "..getPlayerGUID(cid)..";")
	if(query:getID() ~= -1) then
		return query:getDataInt("vip_time") >= os.time() and TRUE or FALSE
	end
	query:free()
	return FALSE
end

function doPlayerAddVipTime(cid, days, hours, minutes, seconds)
	query = db.getResult("SELECT `vip_time` FROM `players` WHERE `id` = "..getPlayerGUID(cid)..";")
	if(query:getDataInt("vip_time") < os.time()) then
		now = os.time()
	else
		now = query:getDataInt("vip_time")
	end
        db.executeQuery("UPDATE `players` SET `vip_time` = "..now.." + ("..days.."*86400+"..hours.."*3600+"..minutes.."*60+"..seconds..") WHERE `id` = "..getPlayerGUID(cid)..";")
	query:free()
	return TRUE
end

function doPlayerRemoveVip(cid)
        return db.executeQuery("UPDATE `players` SET `vip_time` = 0 WHERE `id` = "..getPlayerGUID(cid)..";")
end

Regards,
Shawak

Arlaxis · Aug 31, 2009

good job ; )

husam · Aug 31, 2009

sucks

Shawak · Aug 31, 2009

Arlaxis said:
good job ; )

Thanks, I hope more comments are comming.

husam said:
sucks

You are NOOB!
Alltime when I post something, you asnwer with "sucks", look at other threads in download section, can a mod please delete this spamms?
Thanks, ^_^.

Guitar Freak · Aug 31, 2009

This way is better than using Storage values? if so, why? Just wondering, dont get me wrong

Also, you should upload the file on uploadhyper or use Znote's tutorial to upload it here on otland, because on that site when you open it, a HUGE advertisement comes in the window and doesnt let you see anything, and since its on a language I dont understand, I couldnt find the close button

so it took me a while, I was almost going to quit lol.

Anyways its better to upload it here on otland as an attachment.

Shawak · Aug 31, 2009

Guitar Freak said:
This way is better than using Storage values? if so, why? Just wondering, dont get me wrong

Also, you should upload the file on uploadhyper or use Znote's tutorial to upload it here on otland, because on that site when you open it, a HUGE advertisement comes in the window and doesnt let you see anything, and since its on a language I dont understand, I couldnt find the close button so it took me a while, I was almost going to quit lol.

Anyways its better to upload it here on otland as an attachment.

If I upload it here I can't see how much have downloaded it <_<.
And yes, database entrys are better then storages values.
Also you can add it to the character info at the website.

Master-m · Aug 31, 2009

husam said:
sucks

Yes we all know u like to do such things

Saj · Aug 31, 2009

Good job mate! I love your scripts as I said before!

Ezzam · Aug 31, 2009

Lol... Perfect timing

Really great script

I just needed a VIP system with minutes xD

Shawak · Aug 31, 2009

Ezzam said:
Lol... Perfect timing
Really great script
I just needed a VIP system with minutes xD

:thumbup:

vDk · Aug 31, 2009

aff can you re-upload file to other website?

@down
http://uploadhyper******malware.localhost

Shawak · Aug 31, 2009

vDk said:
aff can you re-upload file to other website?

What website?

Guitar Freak · Sep 1, 2009

Shawak said:
If I upload it here I can't see how much have downloaded it <_<.

Im pretty sure you can :blink:
Example (Tut):
http://otland.net/f258/forum-tutorial-use-otland-instead-speedyshare-similar-sites-46742/

Scrolling down you see it says:

Attached Files
File Type: zip quara.zip (64.9 KB, 4 views)

4 views = 4 downloads..

Well anyways nice scriptek :thumbup:

Shawak · Sep 1, 2009

I downloaded it and views are still 4.

Guitar Freak · Sep 1, 2009

Weird, maybe the dont update inmediatly or something. If anything, Id use Upload Files - UploadHyper.com, its simple to upload, no annoying ads and you can count the downloads aswell (just use the image link like in this post: http://otland.net/f19/otitemeditor_0-3-3-a-13041/index5.html#post368016 and you'll see the downloads here)

Cheers.

Shawak · Sep 1, 2009

Guitar Freak said:
Weird, maybe the dont update inmediatly or something. If anything, Id use Upload Files - UploadHyper.com, its simple to upload, no annoying ads and you can count the downloads aswell (just use the image link like in this post: http://otland.net/f19/otitemeditor_0-3-3-a-13041/index5.html#post368016 and you'll see the downloads here)

Cheers.

Uploadhyper is deleting files after 90 days no downloading

.

PHBS · Sep 25, 2009

Please, post a exemple for use:
getPlayerVipTime(cid, "days"/"hours"/"minutes"/"seconds")

Ty! =D

Shawak · Sep 26, 2009

Example:

Lua:

doPlayerSendTextMessage(cid, 22, "You have "..getPlayerVipTime(cid, "days").." days, "..getPlayerVipTime(cid, "hours").." hours, "..getPlayerVipTime(cid, "minutes").." minutes and "..getPlayerVipTime(cid, "seconds").." seconds vip left.")

husam · Sep 26, 2009

Master-m said:
Yes we all know u like to do such things

it rly sucks
db queries will lag serv ;s

Shawak said:
Uploadhyper is deleting files after 90 days no downloading .

90 days are very good!

Shawak · Sep 26, 2009

Stfu husam, your post is just spamming,
"it rly sucks
db queries will lag serv ;s"

@dd queries; HAHA, make better script newbie, you post those spamm post, since I ignored you in msn.

Vip System v2.0

Intermediate OT User

www.arlaxis.com

Member

Intermediate OT User

_LüA_n☺b_

Intermediate OT User

Need help? Just ask!

Remember my name

New Member

Intermediate OT User

Member

Intermediate OT User

_LüA_n☺b_

Intermediate OT User

_LüA_n☺b_

Intermediate OT User

New Member

Intermediate OT User

Member

Intermediate OT User

Similar threads