[Eluna] Grumbo`z VIP System

[slp13at420]

Arcemu : ArcEmu 2.4.3 Not Full Supported [ LUA Part ] and your scripts dont work 1% on arcEmu 2.4.3
TrinityCore : We Have TrinityCore 2.4.3 ?? Eluna ?? if have send link download to me .
Cmangos : I just can use your sripts on Cmangos but no 100% .

here is the repo for Eluna pre-added to trinitycore wotlk and cata along with cmangos 1 and higher:

https://github.com/ElunaLuaEngine

 

[m8fun]

hey . BRave Man : ))

new updates ? D i waiting for your new updatings ..... or new scripts ,, [ ELUNA ]

 

[Marko]

ERROR lua_scripts/VIP/VIP_stone.lua:8: attempt to index global 'player' (a nil value)
ERROR lua_scripts/VIP/VIP_MG_Banker.lua:52: attempt to call method 'SendVendorWindow' (a nil value)
ERROR lua_scripts/VIP/VIP_world_chat.lua:51: attempt to index field '?' (a nil value)
ERROR lua_scripts/VIP/VIP_Item_Require_VIP_Rank.lua:15: attempt to index field '?' (a nil value)
:surprised: :notokay:

 

[slp13at420]

gotta roll back my test server by removing my CPP VIP system so i can test properly.

make sure you have all your sql updates for the system added and the Core script added.

also what rev are you using ?

does it do what it is supposed to do then throw the error?..
what were you trying to do when it threw the error/'s ?

 

[Marko]

used latest trinitycore with eluna from 29.10.2016
the magic gold vendor seems broken, when clicking any option in his menu:
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63030), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63031), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63032), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63033), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63034), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (62006), ignore
ERROR lua_scripts/VIP/VIP_MG_Banker.lua:52: attempt to call method 'SendVendorWindow' (a nil value)
VIP vendor when anything clicked does not work ERROR lua_scripts/VIP/VIP_Vendor.lua:178: attempt to index field '?' (a nil value)
ERROR lua_scripts/VIP/VIP_1_CORE.lua:156: attempt to index field '?' (a nil value)
ERROR lua_scripts/VIP/VIP_pvp_item_reward.lua:11: attempt to index field '?' (a nil value)
ERROR lua_scripts/VIP/VIP_pvp_gold_reward.lua:3: attempt to index field '?' (a nil value)
When other player is killed no item is ever rewarded - VIP_pvp_item_reward.lua fails
Everything is buggy, but some things don't work at all. If anything editable changed in any lua script, all VIP scripts fail to function and .reload eluna does not fix it, entire server must be restarted. Otherwise players can not even chat or use any scripts.
And when server does get restarted, everyone looses all their VIP ranks back to rank 1
:foreveralone:

 

[slp13at420]

the magic gold vendor seems broken, when clicking any option in his menu:
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63030), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63031), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63032), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63033), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (63034), ignore
Table `(game_event_)npc_vendor` for Vendor (Entry: 60120) have in item list non-existed item (62006), ignore

those errors are self explained. those item id's dont exist in your db. i just used those as placeholders for examples. you just replace them with the id's of the items you want the vendor the sell, and you can use them as examples to add more items.

 

[slp13at420]

can you export your DB? auth,char,world then upload somewhere?
i cant get my test server to update without completely crashing?

 

[Marko]

well that would be troublesome since i am hosting my classless server i cant exacly give it away, worked a lot on it and made many custom contents and stuff. You can use latest trinitycore db it is the same except all the custom stuff ofc.


But yes the vendor is just one of things, main problem is the restart issue if i restart server everyone looses VIP rank.
Would also be nice to know how to direct script to point in auth db to vp table i see the line where it has to be changed but dont know what to put there so it points to that table for vote points.
PVP item reward is also broken and gives nothing instead of some item that victim had equipped.
I'm also going to try convert your Guild Warz into latest trinity core, atm having trouble with game objects template being different but will somehow figure it out what to put instead of "faction" etc.

It would be nice to have both of your works fully functional and working with latest revisions and am glad i'm contributing a little at least for the testing part

 

[Marko]

small fix

Have fixed the issue where server restart also restarts all players vip lvls, by deleting this in VIP Core lua script

local tmplvl = (math.ceil(ACCT[Paccid].Votes / ACCT["SERVER"].Vote_count));
		
			if(ACCT[Paccid].Votes <= ACCT["SERVER"].Vote_count)then
				tmplvl = 1;
			end
				
			if(ACCT[Paccid].Votes >= (ACCT["SERVER"].Vote_count*ACCT["SERVER"].Vip_max))then
				tmplvl = ACCT["SERVER"].Vip_max;
			end
			
		SetVip(player,tmplvl);

But other issues not resolved yet. Like the VIP titles stone and MG banker, PVP item reward etc.
Sent Grumbo some of my files over skype

 

[slp13at420]

Have fixed the issue where server restart also restarts all players vip lvls, by deleting this in VIP Core lua script

local tmplvl = (math.ceil(ACCT[Paccid].Votes / ACCT["SERVER"].Vote_count));
		
			if(ACCT[Paccid].Votes <= ACCT["SERVER"].Vote_count)then
				tmplvl = 1;
			end
				
			if(ACCT[Paccid].Votes >= (ACCT["SERVER"].Vote_count*ACCT["SERVER"].Vip_max))then
				tmplvl = ACCT["SERVER"].Vip_max;
			end
			
		SetVip(player,tmplvl);

But other issues not resolved yet. Like the VIP titles stone and MG banker, PVP item reward etc.
Sent Grumbo some of my files over skype

Ok that block you deleted is the cheater checker. it readjusts a players VIP rank to its proper value based on stored votes in case some one finds a way to hack there VIP rank higher it will re adjust back when they log in again.

https://github.com/BlackWolfsDen/Eluna-Grumboz_VIP_System-Complete/blob/master/VIP_1_Core.ext#L56

 

[slp13at420]

does your website use a vote system ? if so where does it store it?

 

[Marko]

Votes = Q:GetUInt32(2), -- you can table this independantly if you want to query the data from a different db location
idk what to change here so it points to auth db - account table - column called "vp"

That vp checker is not so good because if even pointed properly to vp table instead of votes, when player buys something with vp it will get reduced and then his vip might fall as well. better to keep that part of script removed then

oh, and also had to deactivate the leveling part of script because it gives all players max lvl and my players do not start with max lvl, and then it adds lvls per VIP rank, but yes the part which makes them max lvl is fatal. wish there was a way it does not give max lvl but gives lvl per vip rank after they reach max lvl. But guess that is too complicated to code

 

[slp13at420]

yea your gonna have to edit your website to support storing `total` amount of votes. i.e. find the block of code in your website that updates the sql votes tally for the website and add a second query to update another entry that it wont use for buying items via vote points.

- - - Updated - - -

my site uses `vp` as a column name to store and update the vote count @ each vote. i found where this is done in the vote system and added a second query that will update a column named `votes` that will only be used by the VIP System.

 

[Marko]

seems the VIP buff only uses first 3 lines of buffs + stone buffs
and i have made 9 lines of buffs (made 9VIP ranks), how can i make them work?

[1] = {works},
[2] = {works},
[3] = {works},
[4] = {Not Working},
[5] = {Not Working},
[6] = {Not Working},
[7] = {Not Working},
[8] = {Not Working},
[9] = {Not Working},

- - - Updated - - -

yea your gonna have to edit your website to support storing `total` amount of votes. i.e. find the block of code in your website that updates the sql votes tally for the website and add a second query to update another entry that it wont use for buying items via vote points.

- - - Updated - - -

my site uses `vp` as a column name to store and update the vote count @ each vote. i found where this is done in the vote system and added a second query that will update a column named `votes` that will only be used by the VIP System.

I'm just using azer cms nothing fancy. Since am doing everything by myself and am not a web dev. Will take me some time to check all files there and find where it is configured and then figure out how to change it if possible.. and probably will fail. also have other 100 things that i do on server so this can't really be high on to do list, so will take time..

BTW when the bonus hp of VIP ranks goes over certain percentage, it bugs out and reduces the players hp back to 7k hp , while i set the script to give 30% hp per rank and have 9ranks, and even without hp buff players have over 200k hp so with buffs + this VIP rank percentage they should have over 1mil and if all the buffs i made worked, it would be like 2 or 3 mill hp
player:SetMaxHealth(ACCT[Paccid].Health + ((ACCT[Paccid].Health * 0.3) * ACCT[Paccid].Vip))

 

[slp13at420]

seems the VIP buff only uses first 3 lines of buffs + stone buffs
and i have made 9 lines of buffs (made 9VIP ranks), how can i make them work?

the player will recieve buffs based on vip rank. the total count of buffs will be divided by the max vip rank and then the player recieve (x*player_vip_rank) amount of buffs.

[COLOR="#808080"]
local BUFFIDS = {
	[1] = {24752, 48074},
	[2] = {43223, 36880, 467, 48469, 48162}, 
	[3] = {48170, 16877, 10220, 13033, 11735, 10952} 
	} -- add/remove spell IDs for buffs (used in the buff command).     
[/COLOR]

line #1 is for all players. <-- buffs you want all players to be able to gain.(not to include bonus buffs)
line #2 is for players in guild.(bonus buffs for being a guild member)
line #3 is for players who have reached the mid-point in VIP ranks or higher.(bonus buffs for seeking higher VIP ranks)
- - - Updated - - -



I'm just using azer cms nothing fancy. Since am doing everything by myself and am not a web dev. Will take me some time to check all files there and find where it is configured and then figure out how to change it if possible.. and probably will fail. also have other 100 things that i do on server so this can't really be high on to do list, so will take time..

yea i agree with you totally .
it took me a while of searching thru the php files and reading line after line searching for that `UPDATE INTO` blah blah blah and woohoooo \o/
they do keep everything fairly labeled well so searching thru stuff with names that may relate to the vote system.

 

[slp13at420]

[COLOR="#808080"]
local BUFFIDS = {
	[1] = {24752, 48074},
	[2] = {43223, 36880, 467, 48469, 48162}, 
	[3] = {48170, 16877, 10220, 13033, 11735, 10952} 
	} -- add/remove spell IDs for buffs (used in the buff command).     
[/COLOR]

let me re-state that lol
ok `KEY` '1' or first line will be where you add all the buffs you want any player to access.

KEY '2' is where you put bonus buffs for players in a Guild.

KEY '3' is where you will add bonus buffs for players who reach half-way point or higher in the VIP ranks.

 

[Marko]

[COLOR="#808080"]
local BUFFIDS = {
	[1] = {24752, 48074},
	[2] = {43223, 36880, 467, 48469, 48162}, 
	[3] = {48170, 16877, 10220, 13033, 11735, 10952} 
	} -- add/remove spell IDs for buffs (used in the buff command).     
[/COLOR]

let me re-state that lol
ok `KEY` '1' or first line will be where you add all the buffs you want any player to access.

KEY '2' is where you put bonus buffs for players in a Guild.

KEY '3' is where you will add bonus buffs for players who reach half-way point or higher in the VIP ranks.

Hehe Ok, have made em now to work with that system.. (but i wish they could have worked with each rank more and more buffs :thoughtful: ) now to figure out how to fix hp modification bug.. will try increasing even more the % then decreasing etc. Don't know why it bugs out :jackiechanwtf: ====> figured it out, as suspected the multiplication does not work well with some numbers. When changed max vip rank to 10 then works fine, but with 9 gets bugged.

 

[Marko]

oh and when i set the wintergrasp mark of honor to be used as Magic Gold
local MAGICGOLD = 43589;
The entire server crashes
[1146] Table 'auth_434.account' doesn't exist
Your database structure is not up to date. Please make sure you've executed all queries in the sql/updates folders.
:yuno: what the... i am using normal 3.3.5a
and in eluna logs:
ERROR lua_scripts/VIP/VIP_stone.lua:8: attempt to index global 'player' (a nil value)
ERROR lua_scripts/VIP/VIP_Vendor.lua:189: attempt to call method 'SendVendorWindow' (a nil value)
:herpderp: :fffffuuuuuuuuuuuu:

 

[slp13at420]

Hehe Ok, have made em now to work with that system.. (but i wish they could have worked with each rank more and more buffs :thoughtful: )

yea this is an older version. just kept updated to revs.
My CPP version does disperse the buffs per rank , and has a ton of buffs to give lol. my CPP version is way more advanced than this system....

now to figure out how to fix hp modification bug.. will try increasing even more the % then decreasing etc. Don't know why it bugs out :jackiechanwtf: