How to create/add a admin in MySQL

wizzkidon · **Author**

Hi. How i can add/create an admin in mysql?
I have admin_sql.amxx activated, etc.

Photo (mysql)
http://i.imgur.com/DOhdUtO.png

Anyone can learn me? Thx!

nea · *Last edited by nea; 03-14-2017 at 21:52.*

u don't need to add them manual in ur database

use amx_addadmin and he will add it for u
Command Parameters :

Quote:

amx_addadmin <playername|auth> <accessflags> [password] [authtype]

AuthType : "name/nick" "ip" "steam/steamid/auth"

but if u want to edit it from database :
make a table with name 'admins' or other value of cvar 'amx_sql_table'
with this columes name by order :

Quote:

auth password access flags

Image :

Notice : make sure to change amx_sql_db to your database name in sql.cfg file [in /cstrike/addons/amxmodx/configs folder]
Good Luck

wizzkidon · 03-15-2017 , 03:34 Re: How to create/add a admin in MySQL

Quote:

Originally Posted by nea

make a table with name 'admins' or other value of cvar 'amx_sql_table

I don't understand. I think i have this table with name admins, look at photo:
http://i.imgur.com/YMohgM7.png

But now i don't know how i need to add/edit/change. I'm = 0 with mySQL.

nea · *Last edited by nea; 03-15-2017 at 09:07.*

Quote:

I don't understand. I think i have this table with name admins, look at photo:
http://i.imgur.com/YMohgM7.png

But now i don't know how i need to add/edit/change. I'm = 0 with mySQL.

i know that u have it , i want to know if server really connected with mysql?

if yes , so just use amx_addadmin from server console,or make a new query in table admins and add ur self for example :

Code:

auth      password      access      flags
Nea       UrPassword   abcdef..    a

if no , add ur info of mysql in sql.cfg
and also make sure :

Code:

amx_sql_db "gpkr_3633"

wizzkidon · *Last edited by wizzkidon; 03-15-2017 at 09:40.*

@nea, is 100% connected to mysql.
I can't add amx_addmin in my server console, because i can't write in this. (my host su*ks, i know)
How i can make this table? This is my problem because i don't know. Have you skype or steam? Give me please.

nea · *Last edited by nea; 03-15-2017 at 15:22.*

Anyway plugin will create the table if not exist ..
so here's photo how to add admin manual :

Quote:

1. Click On 'Insert'
http://i.imgur.com/jrLJkGM.jpg
2. Write Value for Each Column then click on 'Go'
http://i.imgur.com/X9Bj3ie.jpg
3. Change Map And Admins List Will Be Updated.

About My Contact Steam : akami20

ORiginalDevils · 04-25-2017 , 15:37 Re: How to create/add a admin in MySQL

I can get some .php files from which you can pack admine