Could Adding Admins to SQL Database Be Any More Vague??
 

I think the Procedure for this is very poorly written. I think AMXx is a great Engine as compared to Adminmod. But one weak point to the documentation and procedures is how to add Admin reserve slots to the MySQL Database when you use the admin_mysql.sma module. I have presented many questions regarding this and no one seems to want to touch it. Is there a problem implementing this? I feel I am proficient at configuring AMxx with My HLDs Server and have had no problems with it except for this section.

I am running mysql 4.0.17 with Windows 2003 Server

amxx list
00:09:21 Currently loaded plugins:
name version author file status
[ 1] Admin Base for My 0.16 AMXX Dev Team admin_mysql.amx running
[ 2] Admin Commands 0.16 AMXX Dev Team admincmd.amx running
[ 3] Admin Help 0.16 AMXX Dev Team adminhelp.amx running
[ 4] Slots Reservation 0.16 AMXX Dev Team adminslots.amx running
[ 5] Menus Front-End 0.16 AMXX Dev Team menufront.amx running
[ 6] Commands Menu 0.16 AMXX Dev Team cmdmenu.amx running
[ 7] Players Menu 0.16 AMXX Dev Team plmenu.amx running
[ 8] Maps Menu 0.16 AMXX Dev Team mapsmenu.amx running
[ 9] Anti Flood 0.16 AMXX Dev Team antiflood.amx running
[ 10] Admin Chat 0.16 AMXX Dev Team adminchat.amx running
[ 11] Admin Votes 0.16 AMXX Dev Team adminvote.amx running
[ 12] NextMap 0.16 AMXX Dev Team nextmap.amx running
[ 13] TimeLeft 0.16 AMXX Dev Team timeleft.amx running
[ 14] Info. Messages 0.16 AMXX Dev Team imessage.amx running
[ 15] Welcome Message 0.16 AMXX Dev Team welcomemsg.amx running
[ 16] Stats Configurati 0.16 AMXX Dev Team statscfg.amx running
[ 17] Cheesy's Respawn 1.4a Cheesy Peteza respawnsystem.a running
[ 18] Spawn Invulnerabi 1.02 Cheesy Peteza spawninvns2.amx running
[ 19] Display rules on 1.00 [TeamHoward]Papa serverrules.amx running
[ 20] PsychoStats 1.1 Jason Morriss ps_amxx.amx running
[ 21] NS Bug Fixes 1.2 Cheesy Peteza bugfixes.amx running
[ 22] High Ping Kicker 0.16.2 OLO/shadow high_ping_kicke running
[ 23] AFK Kicker 1.0a Cheesy Peteza afkkicker.amx running
23 plugins, 23 running

Metamod plugins
meta list
00:10:31 Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxx_mm.dll v0.16 ini ANY ANY
[ 2] Booster RUN - booster_686_mm.d v2.40 ini Chlvl Pause
[ 3] HLGuard RUN - hlguard_mm_i686. v1.60 ini Chlvl Chlvl
[ 4] mm_awards RUN - mm_award.dll v2.2 ini Chlvl Chlvl
[ 5] RCBot For Half- RUN - hpb_bot.dll v1.37_mm ini Start Never
[ 6] ENGINE RUN - engine_amx.dll v0.16 cmd ANY ANY
[ 7] NS2AMX RUN - amxx_ns2amx.dll v1.0.0.5 cmd ANY ANY
7 plugins, 7 running

Can someone please explain how this procedure is done in as much detail as possible. I would really appreciate it.

I have my Psychostats 2.1.1 running fine from the MySQL Database using the AMX SQL Module fine, what am I missing here?

Thanks

I don't think it's vague. If you're using SQL you should be familiar with this sort of thing. However we're rewriting the docs so maybe it will be better in the future.

The plugin will automatically create a table in your database for you, with four fields. Each field corresponds to one of the admin parameters:
AuthId Password Flags AuthFlags

It even names the fields appropriately, so it's fairly self explanatory. Again if you're not familiar with SQL you shouldn't use this.

This may be helpful however:
http://forums.alliedmods.net/showthread.php?t=306

reservation via MySQL is achieved by adding the information to the tables mentioned by Bailopan (use phpmyadmin or MySQL Control Center to achieve this ). The crucial information that is needed for reservation to work is the reserved flag ( b ) which needs to be included in the Access table ( i.e. bcefimu ) and for the amx_reservation cvar to be set to a number greater than 0 in your amxx.cfg file.

Couple of questions:

1. Is AuthId, Password, Flags, AuthFlag,s the actual correct names for the fields in the database?
2. Is the actual name of the table "admin"?
3. In the amx_sql.sma source, is password_field the "Password" field in the Table?
4. If I was running more than 1 database in that amx_sql.sma (.amx) do I just list the different databases after each other with the same type parameters or can I only run one database from this amx plugin. reason I ask is that I have Psychostats running out of this amx also, which is functioning perfect.

You help is much appreciated, I am somewhat new to MySQL but not new to databases and I am certainly new to AMX but I understand how they both work completely along with the information you have provided me already and the answers to these questions above.

Have the reservation amount already set. If the answer is Yes to all of the questions above I should be ready to go. Will test tonight when I get home form work.

Does NOT work.

I think according the the amx sql source code it looks like it is looking for fields.

auth
password
access
flags

I have entered these, and also changed the sql.cfg and amxx.cfg to reflect these changes. I have also found from the source code the it is looking for a table called "admins" and I have created it with the Fields indicated above with the appropriate data in each field. Still does not work. Isn't the amxx sql plugin supposed to create these entries on it's own? ...it does not appear to be doing that. Still don't know the format to list multiple databases in the amxx sql source code to compile so I just stacked them on top of eachother in the source and compiled. Well looks like I am at a dead end, I feel like the answers are right in front of me but I need to know where I went wrong on this. What are your feeling on amxbans? I have tried this once but I again am not sure of the syntax of the configuration script i.e. do I replace dirroot entries with a c:\inetpub\wwwroot entry" and do I replace wwwroot entries with "http://www.<domain>/<amxbansdir>

Please help, whichever way that will work.



Still do not know also if

Sounds like you dont have your sql server set up correctly...or maybe your using an accout with incorrect permissions.

As bailopan said, the admin_mysql.sma should be creating the table for you. If its not, your mysql is set up incorrectly.

I would suggest deleting your "admin" table, and starting up your server...and then checking if the admin table was created. If not, troubleshoot your mysql configuration from there.