Raised This Month: $ Target: $400
 0% 

Sql based admins not working.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
TheDragonfiend
Junior Member
Join Date: Dec 2012
Old 12-23-2012 , 00:23   Sql based admins not working.
Reply With Quote #1

Well today I finally hooked my test server up to my sql database activated the plugins etc etc and yes it is successfully connecting and downloading the tables.

Problem is I had my co-owner/server manager test the perms and even tho he was flagged with root he couldn't access any commands.

I've also followed the table template and his steam I'd is correct... I seriously have no idea what's going on.

Oh and it's a tf2 server.

Code:

CREATE TABLE IF NOT EXISTS `sm_admins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `authtype` enum('steam','name','ip') NOT NULL,
  `identity` varchar(65) NOT NULL,
  `password` varchar(65) DEFAULT NULL,
  `flags` varchar(30) NOT NULL,
  `name` varchar(65) NOT NULL,
  `immunity` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `sm_admins`
--

INSERT INTO `sm_admins` (`id`, `authtype`, `identity`, `password`, `flags`, `name`, `immunity`) VALUES
(2, 'steam', 'STEAM_0:0:30066717 ', '', 'z', 'Kael - Alucard', 10);

Last edited by TheDragonfiend; 12-23-2012 at 00:39. Reason: sql
TheDragonfiend is offline
4bdul
AlliedModders Donor
Join Date: Dec 2011
Location: United Kingdom
Old 12-23-2012 , 08:32   Re: Sql based admins not working.
Reply With Quote #2

Try removing the space after the SteamID.
__________________
4bdul is offline
TheDragonfiend
Junior Member
Join Date: Dec 2012
Old 12-23-2012 , 16:40   Re: Sql based admins not working.
Reply With Quote #3

Quote:
Originally Posted by 4bdul View Post
Try removing the space after the SteamID.
...
...
...
How the fuck did I not see that.

Ill try that and see if it works (I had thought it was the wrong id or a broken set of sql plugins or something)
TheDragonfiend 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 09:41.


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