slp13at420
Mad Scientist
Grumbo'z VIP System
VIP System:
=========
ok we only have a couple basic Vip/Premium systems so far that I have found on our site
so I figured I would release a complete version of my VIP System.
--Built Tested and Approved for TC2 3.3.5a Eluna ONLY--
--Tested and Approved for TC2 4.3.4 Eluna ONLY--
--Tested and Approved for TC2 4.3.4 Eluna ONLY--
For TrinityCore2 3.3.5a
add 1 column to your auth.account db:
Code:
[COLOR="#A9A9A9"]
ALTER TABLE `account`
ADD COLUMN `vip` TINYINT(2) UNSIGNED NOT NULL DEFAULT '1' AFTER `recruiter`;
[/COLOR]Add the scripts you choose, to the VIP folder also.
- Allows for VIP 1 to xx. max VIP level set in the core (VIPMAX) currently set to 5.
- A VIP Coin to give access to extra commands and perks.
- A VIP Stone that will level-up a player's VIP level.
- Stone is a one shot use. it will vanish after use.
- A '#resetTP' command for players to reset there own talent points.
- The command will add extra points based on VIP level also.
- A '#hp' command to buff a players health points based on there VIP level.
"VIP_1_CORE.lua"
Core Script:
Code:
-- [B][U][COLOR="#FFD700"]this MUST be the first script of the VIP System to load[/COLOR][/U][/B] --
[COLOR="#808080"] print("\n----------------------------")
print("Grumbo'z VIP Engine starting:\n")
local VIPMAX = 5; -- you can set it to what ever your little heart desires.
local VIPCOIN = 63020; -- item id for the VIP Coin.
local VIPSTONE = 63021; -- item id for the VIP Stone.
local VIPTPBONUS = 14; -- how many extra talent points for each vip level.
ACCT = {}
print("VIP Table Allocated.")
ACCT["SERVER"] = {
Vip_max = VIPMAX,
Vip_coin = VIPCOIN,
Vip_stone = VIPSTONE,
Tp_mod = VIPTPBONUS
};
print("CORE settings loaded.")
function Player_Vip_Table(event, player)
local Q = WorldDBQuery("SELECT username, vip FROM auth.account WHERE `id` = '"..player:GetAccountId().."';");
ACCT[player:GetAccountId()] = {
Name = Q:GetString(0),
Vip = Q:GetUInt32(1),
Health = player:GetMaxHealth()
};
end
RegisterPlayerEvent(3, Player_Vip_Table)
print("Player VIP Table prepared.")
function SetVip(player, vip)
if((vip or 0)==0)then
return
end
ACCT[player:GetAccountId()].Vip = vip
WorldDBQuery("UPDATE auth.account SET `vip`='"..vip.."' WHERE `username`='"..player:GetAccountName().."';");
player:SendBroadcastMessage("|cff00cc00Your VIP is set to "..ACCT[player:GetAccountId()].Vip..".|r")
end
print("\nGrumbo'z VIP Engine running.")
print("----------------------------\n")
[/COLOR]"VIP_coin.sql"
This needs to be added to your world.item_template table.
The Vip Coin will allow players to get extra perks and access to extra commands when a player has one in there inventory.:" [SUB]may be required for some scripts to work properly.[/SUB]"
Code:
[COLOR="#808080"]
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `InventoryType`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `maxcount`, `stackable`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `bonding`, `description`) VALUES
(63020, 15, 0, -1, 'VIP Coin', 32282, 1, 64, 0, 1, 0, -1, -1, 1, 1, 1, 1, 13567, 0, 0, 0, -1, 0, -1, 1, 'A MUST HAVE item for all your VIP needs.');
[/COLOR]"VIP_stone.sql"
The VIP stone will upgrade a players VIP level by 1 when used then vanishes.
the VIP Stone SQL file:
Code:
[COLOR="#808080"]
INSERT INTO `item_template` (`entry`, `class`, `subclass`, `SoundOverrideSubclass`, `name`, `displayid`, `Quality`, `Flags`, `FlagsExtra`, `BuyCount`, `AllowableClass`, `AllowableRace`, `ItemLevel`, `RequiredLevel`, `maxcount`, `stackable`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellppmRate_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `bonding`, `description`) VALUES
(63021, 15, 0, -1, 'VIP Stone', 32282, 1, 64, 0, 1, -1, -1, 1, 1, 1, 1, 13567, 0, 0, 0, -1, 0, -1, 1, '!!Wooooohooooooo!!\r\n!!ClickMe!!!ClickMe!!\r\n!!VIP+1!!SuperFun!!');
[/COLOR]"VIP_stone.lua"
the Vip Stone can be added to your site store for donors or add it as a drop from your major boss's:
Code:
[COLOR="#808080"]
-- this will update a player's VIP +1 then delete the stone.
-- the timer is set to 1ms to avoid double tapping exploit.
local timer = 1
local itemid = ACCT["SERVER"].Vip_stone
local function RemoveVIPstone(event, _, _, player)
SetVip(player, ACCT[player:GetAccountId()].Vip+1)
player:RemoveItem(ACCT["SERVER"].Vip_stone, 1)
end
function VIPstone(event, player, spellID, effindex, item)
if(ACCT[player:GetAccountId()].Vip<=(ACCT["SERVER"].Vip_max-1))then
player:RegisterEvent(RemoveVIPstone, timer, 1, player)
else
player:SendBroadcastMessage("you are Max VIP "..ACCT[player:GetAccountId()].Vip..".")
return
end
end
RegisterItemEvent(itemid, 2, VIPstone)[/COLOR]"VIP_ResetTP.lua"
Just use local chat /say and type #resettp to reset talent points:
Code:
[COLOR="#808080"]
function VIPresetTP(event, player, message, type, language)
if(message:lower() == "#resettp") then
player:ResetTalents()
local Tp = (78+(ACCT[player:GetAccountId()].Vip*ACCT["SERVER"].Tp_mod))
player:SetFreeTalentPoints(Tp, 0)
player:SetFreeTalentPoints(Tp, 1)
player:SendBroadcastMessage("|cff00cc00All your talents are reset!|r")
else
end
end
RegisterPlayerEvent(18, VIPresetTP)
[/COLOR]"VIP_buff.lua"
Just use local chat /say and type #hp to buff your health:
Code:
[COLOR="#808080"]
-- using local chat /say type #hp
-- adds 5%(0.05) of health max PER players vip level :: 0.10 = 10% :: 0.75 = 75% :: 1.25 = 125%
function VIPbuff(event, player, message, Type, lang)
if(message:lower() == "#hp") then
player:SetMaxHealth(ACCT[player:GetAccountId()].Health + ((ACCT[player:GetAccountId()].Health * 0.05) * ACCT[player:GetAccountId()].Vip))
end
end
RegisterPlayerEvent(18, VIPbuff)
[/COLOR]"VIP_pvp_gold_reward.lua"
This is a PvP reward script. it will reward the killer 5% of the victims gold multiplied by the killers VIP level. :
Code:
[COLOR="#808080"]
function Pvp_Gold_Reward(_, killer, killed)
killer:ModifyMoney(killed:GetCoinage()*(0.05 * ACCT[killer:GetAccountId()].Vip)) -- reward is 0.05 = 5% of victims gold multiplied by killers VIP level
end
RegisterPlayerEvent(6, Pvp_Gold_Reward)
print("Grumbo'z VIP Gold loot loaded.")
[/COLOR]This is a dynamic system so you can use the global ACCT table in other scripts if you wish to use stored values for something or add new scripts using the table entries or expand with new table entries and scripts.
Pick and choose which scripts you wish to use, its dynamic, or write your own scripts. The value is stored in RAM so you can access the stored value in either Lua or C++.[SUP]ooooh maybe a new community project?...[/SUP]
if you have your own scripts you have wrote to work with this and want to add them here in a post , just remember to be thorough with a very verbose 'how-to' whether it is Lua or C++ .. oh yea and it should work too :RpS_flapper:
>> The Complete System <<
Enjoy everyone :rock: and have fun makin kewl new addonz for your server.
Thanks to the following:
Lightning Blade for the Sticky :bump2: I owe you a sticky
Rochet2 and FoeReaper for the tons of info that got me to this point.
3.3.5a, Eluna script, TrinityCore, Trinity Core, VIP System, VIP, wotlk, Grumbo
Last edited:
