This site is a testing version, but all data is shared with the live forum.


Raised This Month: $ Target: $400
 0% 

Problems with Amxx cmds and MySQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
DemonicFuzzball
Junior Member
Join Date: Jun 2004
Old 06-24-2004 , 22:43   Problems with Amxx cmds and MySQL
Reply With Quote #1

Whenever i load the MySQL module, it makes it so that no one who is normally an admin, can log in. It seems like it no longer recognize anyone's STEAM_ID...When i dont load MySQL, everything works fine. Anyone know wut the problem is? Do i have to do something with the MySQL.cfg config file? Right now it looks like:

// MySQL configuration file
// File location: $moddir/addons/amxx/configs/mysql.cfg

// *NOTE* Linux users may encounter problems if they specify "localhost" instead of "127.0.0.1"
// We recommend using your server IP address instead of its name
amx_mysql_host "localhost"
amx_mysql_user "root"
amx_mysql_pass ""
amx_mysql_db "amx"
DemonicFuzzball is offline
devicenull
Veteran Member
Join Date: Mar 2004
Location: CT
Old 06-24-2004 , 22:48  
Reply With Quote #2

Did you actually set the admins up in the mysql table?
__________________
Various bits of semi-useful code in a bunch of languages: http://code.devicenull.org/
devicenull is offline
pendragon
Senior Member
Join Date: Mar 2004
Location: In a bubble
Old 06-24-2004 , 22:50  
Reply With Quote #3

god i hope you cahnged your MySQL access right after posting that info (or that u just used that login and pass as a means to get a point accross).
__________________
pendragon is offline
Send a message via ICQ to pendragon
DemonicFuzzball
Junior Member
Join Date: Jun 2004
Old 06-24-2004 , 23:11  
Reply With Quote #4

Neways, i got my MySQL server working and stuff, and so far my admin table looks like:
+-------------------+----------+-----------------------+-------+
| auth | password | access | flags |
+-------------------+----------+-----------------------+-------+
| STEAM_0:0:1774047 | | abcdefghijklmnopqrstu | ce |
| STEAM_0:1:2711603 | | abcdefghijklmnopqrstu | ce |
| STEAM_0:0081945 | | bcdefghijklmnopqrstu | ce |
| STEAM_0:0:1719531 | | bcdefghijklmnopqrstu | ce |
| STEAM_0:0:417520 | | bcdefghijklmnopqrstu | ce |
| STEAM_0:0:1835344 | | bcdefghijklmnopqrstu | ce |
+-------------------+----------+-----------------------+-------+
And when i look in my MySQLCC, it shows it being under the amx database...
BUT IT STILL DOESNT WORK!!!Wut am i doing wrong?

BTW, for the password, i left blank cause i usually dont bother with them when i got the account flags ce on...
DemonicFuzzball is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 14:15.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode