ULX Global Ban - Garry's Mod

[QUOTE=bcool14;39943975]I'll check gatekeeper tomorrow[/QUOTE] Forget gatekeeper. It's deprecated since Garry added the same functionality to GMod. It's the CheckPassword hook.

Can no one answer my question? You keep ignoring it and answering everyone else's [B]Console spams this on player connect:[/B] [QUOTE][ULX GB] - Server not present, creating... [ULX GB] (NewServer) - Error: [Query:0ABB51C0][/QUOTE] Database connection is made successfully though.

i made the whole folder and files to permission 777 and still i get this error, [url]www.Fearsome.info/bans[/url]

I have an issue where the bans won't show up on the website, every thing works fine, the player gets banned, but they won't show up on Q4's skin theme, nor your theme. Database is clearly connected, and the ban gets inserted into the table, it shows "Bans List - 1 Bans and Counting" but not the information.

[QUOTE=Question Mark;39946166]Can no one answer my question? You keep ignoring it and answering everyone else's [B]Console spams this on player connect:[/B] Database connection is made successfully though.[/QUOTE] SORRY D:! It shouldn't error there if it's all connected fine, double check the tables, reupload the SQL file. If all else fails manually insert the server into the database and go from there. [QUOTE=Auanking;39946315]i made the whole folder and files to permission 777 and still i get this error, [URL="http://www.Fearsome.info/bans"]www.Fearsome.info/bans[/URL][/QUOTE] I'll get Q4 on here to take a look. [QUOTE=Jeremey Kingrey;39950336]I have an issue where the bans won't show up on the website, every thing works fine, the player gets banned, but they won't show up on Q4's skin theme, nor your theme. Database is clearly connected, and the ban gets inserted into the table, it shows "Bans List - 1 Bans and Counting" but not the information.[/QUOTE] Does it show up in-game fine? [QUOTE=danielga;39944655]Forget gatekeeper. It's deprecated since Garry added the same functionality to GMod. It's the CheckPassword hook.[/QUOTE] Awesome! I'll convert the default hook to that now!

Server finally stopped making that error when i added it manually, but bans still arent reading or writing to the database and all my current bans aren't importing. The user i created has the following permissions to the database: [QUOTE] ALTER CREATE CREATE ROUTINE CREATE TEMPORARY TABLES DELETE DROP INDEX INSERT LOCK TABLES REFERENCES SELECT UPDATE[/QUOTE] Are any others needed?

[QUOTE=Question Mark;39958393]Server finally stopped making that error when i added it manually, but bans still arent reading or writing to the database and all my current bans aren't importing. The user i created has the following permissions to the database: Are any others needed?[/QUOTE] I believe I am having the same problem as you + one other problem, it does not echo in console that the addon has even loaded, but after a minute or so my server will crash. Once I removed the addon the crashes stopped.

[QUOTE=Question Mark;39958393]Server finally stopped making that error when i added it manually, but bans still arent reading or writing to the database and all my current bans aren't importing. The user i created has the following permissions to the database: Are any others needed?[/QUOTE] That should be fine. [QUOTE=grazingbacon;39961502]I believe I am having the same problem as you + one other problem, it does not echo in console that the addon has even loaded, but after a minute or so my server will crash. Once I removed the addon the crashes stopped.[/QUOTE] Are you both running any other addons that may be conflicting with it? I can't reproduce any of the errors stated with the latest version of GMOD Server, ULX, ULiB and my addon. Could you provide me with the server information? OS, MySQL version, MySQLOO version, List of addons installed and what gamemode your running? Thanks!

[QUOTE]Does it show up in-game fine?[/QUOTE] Yes

What about my error?? :(

[QUOTE=Jeremey Kingrey;39964260]Yes[/QUOTE] Do you happen to use a different user for the website? Or is it on a different server to the MySQL? [QUOTE=Auanking;39965009]What about my error?? :([/QUOTE] I've asked Q4 to come check it out, I really have no clue.

[QUOTE=bcool14;39965423]Do you happen to use a different user for the website? Or is it on a different server to the MySQL? [/quote] No it inserts it into the MySQL and successfully bans people but it doesn't show up in the bans list on the website.

When I get home i'll retry my webpage and Q4's to see if it works. [B]EDIT[/B] Both work fine on my local machine...

-snip- Found the problem, but created another. To my knowledge, everything is correct such as the sql information and the installation of libmysql and the mysqloo module. Error: [CODE]08:49:40 [ERROR] addons/ulx_globalbanmodule/lua/globalban/gb_mysqloo.lua:6: Couldn't load module library! 1. require - [C]:-1 2. unknown - addons/ulx_globalbanmodule/lua/globalban/gb_mysqloo.lua:6 3. include - [C]:-1 4. unknown - addons/ulx_globalbanmodule/lua/autorun/ulx_globalban.lua:9[/CODE]

[QUOTE=grazingbacon;39968408]-snip- Found the problem, but created another. To my knowledge, everything is correct such as the sql information and the installation of libmysql and the mysqloo module. Error: [CODE]08:49:40 [ERROR] addons/ulx_globalbanmodule/lua/globalban/gb_mysqloo.lua:6: Couldn't load module library! 1. require - [C]:-1 2. unknown - addons/ulx_globalbanmodule/lua/globalban/gb_mysqloo.lua:6 3. include - [C]:-1 4. unknown - addons/ulx_globalbanmodule/lua/autorun/ulx_globalban.lua:9[/CODE][/QUOTE] It's not correct since you get this error... *Your MySQLoo module isn't installed correctly.

[QUOTE=ms333;39973406]It's not correct since you get this error... *Your MySQLoo module isn't installed correctly.[/QUOTE] Mysqloo is installed in garrysmos/lua/bin. Is that not correct? The exact name of the file is gmsv_mysqloo_win32.dll. Should i change it to mysqloo.dll?

[QUOTE=grazingbacon;39975775]Mysqloo is installed in garrysmos/lua/bin. Is that not correct? The exact name of the file is gmsv_mysqloo_win32.dll. Should i change it to mysqloo.dll?[/QUOTE] No. If you're running Windows it should work.

[QUOTE=grazingbacon;39975775]Mysqloo is installed in garrysmos/lua/bin. Is that not correct? The exact name of the file is gmsv_mysqloo_win32.dll. Should i change it to mysqloo.dll?[/QUOTE] You also need libMysql.dll in the root (same folder as srcds.exe)

[QUOTE=BlackVoid;39978513]You also need libMysql.dll in the root (same folder as srcds.exe)[/QUOTE] I'm pretty sure you get another error if that's the reason, but yes, that's required as well.

[QUOTE=BlackVoid;39978513]You also need libMysql.dll in the root (same folder as srcds.exe)[/QUOTE] libmysql.dll is installed in the root. Everything thing is up to date since I got everything from OPs links. To verify: [URL="http://www.facepunch.com/showthread.php?t=1220537"]MySQLOO[/URL] [URL="http://www.mysql.com/downloads/connector/cpp/"]libmysql.dll[/URL] I downloaded the 32 bit ZIP Archive.

Typically the "couldn't load module library" error means the module is there but it can't load libmysql or some other component.

Not sure if anyone has written one yet, but a quick converter from ULX keyvalues bans to mysql: [url]https://github.com/darkimmortal/ulx-globalban-converter[/url]

There is a problem where we unban people who have a timed ban and it doesn't actually unban them.

i want my freaking ulx global ban to work!

[QUOTE=koz;40011810]There is a problem where we unban people who have a timed ban and it doesn't actually unban them.[/QUOTE] I'll check into it. [QUOTE=Auanking;40012697]i want my freaking ulx global ban to work![/QUOTE] Sorry dammit! I do have other things to do... Q4 said comment line 9, then un-comment line 10 and see if that works.

ok so the skin etc showed up but i get other errors. look [url]http://www.fearsome.info/bans/index.php[/url]

Fixed This error :) Now I get this: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/a1307745/public_html/GlobalBans/index.php on line 45 Any ideas on whats going wrong? Thanks!

Anybody help me? I still got the errors on my bans, look in [url]www.fearsome.info/bans/[/url]

You must import the .sql file into your MySQL database and be sure you have entered the correct MySQl information.

[QUOTE=EVERYONE]ERROR ERROR ERROR[/QUOTE] I added messages that should tell you the proper error now! Changelog: [code] [1.1 Beta] [CHG] Replaced old error messages with new ones that will tell you what's going the f*ck on.. [1.0 Beta] [ADD] A beta conversion system for old ULX Bans, (Each ban needs all the standard information so it will convert properly!) [CHG] Moved over the Auth Code Section to the new CheckPassword hook. Which makes the refresh timer to be required at all times! [REM] Removed GateKeeper code. [REM] Some unused code. [/code] If you stopped using this addon because of the errors, please try it once again, the errors should be easily fixable now!