SA-MP Forums Archive
Setting my Admin Level - MySQL ! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Setting my Admin Level - MySQL ! (/showthread.php?tid=472138)



Setting my Admin Level - MySQL ! - hewittpro - 27.10.2013

Hey Guys, I'm new to MySQL And I've got the server up and running with a database, but i'm used to .ini user files which is easy to set your admin level. How would I do it with a MySQL Database? Thanks guys!!




Re: Setting my Admin Level - MySQL ! - hewittpro - 27.10.2013

Anyone? I'm sure its not complicated!


Re: Setting my Admin Level - MySQL ! - Mattakil - 27.10.2013

double click on the current admin level and it should bring up a dialog to change it.

The other thing you can do is allow /makeadmin or whatever to work if(IsPlayerAdmin) (logged into RCON), and if you are uncomfortable with it, remove it after making yourself admin, or require an additional pass if they are logged into rcon


(Sorry if I make no sense xD)


Re: Setting my Admin Level - MySQL ! - hewittpro - 27.10.2013

haha yeah it makes sence! but when I click on the current level it nothing happens are you sure theres no other way?? without going into rcon?


Re: Setting my Admin Level - MySQL ! - hewittpro - 27.10.2013

Anyone


Re: Setting my Admin Level - MySQL ! - rickisme - 27.10.2013

Mysql Query ( create column AdminLevel in accounts table after column key ) :
Quote:

ALTER TABLE `accounts`
ADD COLUMN `AdminLevel` int(11) NOT NULL DEFAULT 0 AFTER `Key`;

and save your admin level to this column ( like save username, password, etc )


Re: Setting my Admin Level - MySQL ! - Jerm - 27.10.2013

hewitt with the gamemode you are using:

Open the PWN with PAWNO and then find where it says OWNER_IP or CO_OWNER_IP: and add your IP address to it. Once you have done that it enable you to use /makeadmin or /authmakeadmin