Ulysses Stuff > Releases

UBan -- Global ban system. Ban users from all servers connected to a single DB!

<< < (38/40) > >>

talmera:
*EDIT*

i got it working and is adding bans to the database :3

now to just make it so it shows the server ip it was made from

saintwubbles:
Modified it to work with MySQLOO and Garry's Mod 13. I've also changed it to use normal steamIDs.

Cyborg_delta1:
Hmmm not working? I have every thing installed the MYsqloo module downloaded the updated version of this code. When I ban some one on the gban command it bans them from the server but there info is not on the database there are no errors when banning some one and no errors when the server starts up can any one help?

Edit....

Ok I put this after server.onConnected = function()

print( "Database has connected!" )

And as soon as the server starts up it prints "Database has connected!" but yet it still not putting the bans into the database?

saintwubbles:
It sounds like it's an issue with your database table based on the lack of lua errors. You will have to change the steamid field to be longer to accommodate the 'STEAM_' which the broken official release stripped out. Here is the modified table structure:


--- Code: ---CREATE TABLE IF NOT EXISTS `gbans` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `steamid` char(20) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `name` char(31) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `unban_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comment` char(128) DEFAULT NULL,
  `serverip` varchar(15) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `serverport` smallint(5) unsigned NOT NULL,
  `adminname` char(31) DEFAULT NULL,
  `adminsteamid` char(35) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,
  UNIQUE KEY `id` (`id`),
  KEY `steamid` (`steamid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=812 ;

--- End code ---

To debug it print() out the query and copy it into phpmyadmin/whatever you control your database with, that will let you see what is going wrong.

Bite That Apple:
I'm using saintwubbles version of this, but it seems to still not be sending the ban to the database.

I do !gban PLAYERNAME 1 reason it sure bans me for one minute, but it doesn't write it in the database.

Navigation

[0] Message Index

[#] Next page

[*] Previous page