lua command for..

[theory18]

1. Hi i'm looking for a lua command wich gives me the gm permissions of a player.
Like when he is an admin i can now it or not.

2. Can i make vip player permissions without the vip column in the accounts table?
I had other databases where there was a vip column, but now i only have gm.
Is there a way i can make custom permission based on a rank?

Thanks in advance +rep!

[Death_Master]

look here Abyssal WoW - Lua Library this is most of the lua commands. if it's not there you probaly cant

[theory18]

thanks for your reply i'll check it out!
+Rep

[Claiver]

Hello Theory18,

You can make entire custom tables with information, using the Database commands supplied by the GuaEngine. Question: Do you use ArcEmu? If yes, then I'd have a great solution for this matter.

Copy and Paste the following code ontop of your Lua script:

--------------------------------------------------------------------------------------|
--\ Function: GetTableData
--------------------------------------------------------------------------------------|
	function GetTableData(_DATABASE,_TABLE,_COLUMN,_ROW,_VALUE1,_VALUE2) local _T={}
		if (string.upper(_DATABASE) == "CHARACTER") then _DB=1 end
		if (string.upper(_DATABASE) == "WORLD") then _DB=0 end
		_Q=Query(_DB, _ROW, "SELECT * FROM `".._TABLE.."` WHERE `".._VALUE1.."`='".._VALUE2.."'",0)		
		if (_Q ~= nil) then	_T.L=_Q end if (_T.L ~= nil) then return _T.L end
	end	
	
--------------------------------------------------------------------------------------|
--\ Function: SetTableData
--------------------------------------------------------------------------------------|
	function SetTableData(_DATABASE,_TABLE,_COLUMN,_NEWVALUE,_VALUE1,_VALUE2)
		if (string.upper(_DATABASE) == "CHARACTER") then _DB=1 end
		if (string.upper(_DATABASE) == "WORLD") then _DB=0 end	
		Query(_DB,1, "UPDATE `".._TABLE.."` SET `".._COLUMN.."`='".._NEWVALUE.."' WHERE `".._VALUE1.."`='".._VALUE2.."'",0)	
	end

You can use the functions like this:

	GetTableData(DATABASE,TABLENAME,ROWNAME,ROWNUMBER,VALUE1,VALUE2)
	
Example:
GetTableData("Character","guilds","motd",9,"Guildname","The Uber Guild")
The above code will get the Message of the Day (9th row) of the guild where
the name is 'Uber Guild'. (where VALUE1 is equal to VALUE2)



SetTableData(DATABASE,TABLE,ROWNAME,NEWVALUE,VALUE1,VALUE2)
	
Example:
SetTableData("World","creature_names","name","Lord New Name","entry","200000")
The above function will change the name of the creature with entry 200000 
to 'Lord New Name'.

Hope it helped, if there are any questions, just ask .

Claiver