OpenSteam: Bans and User Management System

[Decicus]

Sounds already good.

Basically: Fork, create the new file, make a remote pull request.
If you have any questions do not hesitate to ask me about details ;-)

Regards

I think I did this right, at least I did some sort of pull request.

[Grief-Code]

Yea all is fine :-)

[matthall]

This looks like a great addon, except for a couple issues.

Commands. I should be able to use ulx adduser, ban, banid etc

I could learn to use these commands but the problem is other admins. I don't feel like re-training admins, plus, due to habit, seasoned admins will forget and use the standard commands, causing a mess of the bans. For example, ULX Global Ban [0.5] does this. It makes it seamless for players, only the server operators would know of the change.

Also, I think it is preventing XGUI from editing user permissions.

If these issues can be fixed, I will use this system.

[RalphORama]

When I go to the webpage I have this installed on, I get the following screen:


No CSS, nothing. Is there something I'm doing wrong here?

[Neku]

Clear your internet cache.

[RalphORama]

Clear your internet cache.

Didn't work. Same thing happens on other browsers as well (IE, Chrome, and WaterFox)

EDIT: in config.php I had my website as 'http://bans.corerp.co' but changing it to 'http://bans.corerp.co/' fixed it

[Neubivljiv]

Open config.php and change:
$cfg["website"]
to match your website.

[Storm]

I have to agree with Matthall. Admins without rcon access need an easier way to ban. Opening the console means you briefly can't see what is happening on the server and is a cumbersome way to ban. And yes my admins will use the old way too when they need to quickly ban. I would then have to move all those bans to the database daily (which I don't yet know how to do).

[RalphORama]

On the OpenSteam site I've created, at http://bans.corerp.co/?option=login I get the following error:
Notice: Undefined index: openid_signed in /home/nginx/bans.corerp/inc/steam_class.php on line 54 (note that this is obscured by the header navbar)
I haven't touched any of the files, save for the required configuration. This error is preventing me from logging into the site with Steam altogether.

[Neubivljiv]

There seems to be a problem with Steam service (I noticed yesterday too).
See file in attachement.

However, I planned to separate admin account with steam service.

About GUI...there is plan to do (display all data from the database via ulx menu or similiar command), but currently nothing I can not promise.  I think that every admin should use the console, but it depends on habits. However, there is a great advantage of using a database.

[Neubivljiv]

...seasoned admins will forget and use the standard commands, causing a mess of the bans. For example, ULX Global Ban [0.5] does this.

Didn't tested that addon, but I looked into code (a bit). Then I saw this:

Code: [Select]

ULX_DB:query("SELECT * FROM bans ORDER BY BanID DESC")It's pretty bad, especially when you have a lot of bans. This can drastically affect the performance of the server, and the query time is constantly repeated. Realistically, there's no point then use the database with this. 
Then back to the same issues: http://forums.ulyssesmod.net/index.php/topic,7224.msg36417.html#msg36417

I might add a graphical interface in one of the next version, similar to that on the website, only in the game (ulx menu or similiar command like ulx banmenu)...

[RalphORama]

There seems to be a problem with Steam service (I noticed yesterday too).

I don't think it's that, it's an issue with the file itself. Where did steam_class.php come from? It looks like something from the steam web API, but I can't find any files with similar contents.

On the other hand, I'm also getting the following error on the server itself (during startup):

Code: [Select]

[ERROR] addons/ulx/lua/ulx/modules/sh/opensteam.lua:41: attempt to index local 'queryQ' (a nil value)
  1. fn - addons/ulx/lua/ulx/modules/sh/opensteam.lua:41
   2. unknown - addons/ulib/lua/ulib/shared/hook.lua:183

[ERROR] addons/ulx/lua/ulx/modules/sh/opensteam.lua:41: attempt to index local 'queryQ' (a nil value)
  1. fn - addons/ulx/lua/ulx/modules/sh/opensteam.lua:41
   2. unknown - addons/ulib/lua/ulib/shared/hook.lua:183
Again, the only part I've modified reads as follows (and all the DB information is correct):

Code: [Select]

local ULX_HOST = "localhost"
local ULX_PORT = 3306
local ULX_DATABASE = "<removed>"
local ULX_USERNAME = "<removed>"
local ULX_PASSWORD = "<removed>"
local ULX_BANS_TABLE    = "dr_bans"
local ULX_PLAYERS_TABLE = "dr_users"
local ULX_GROUPS_TABLE  = "dr_groups"
local ULX_CONFIG_TABLE  = "dr_config"
local ULXDB

[Neubivljiv]

Steam class: https://developer.valvesoftware.com/wiki/Server_queries
(look at bottom - PHP library)

I see problem (fixed it). Quick fix: open inc/pages/login.php and find:

Code: [Select]

$Validate = SteamSignIn::validate();replace with

Code: [Select]

if(isset($_GET["openid_ns"])) $Validate = SteamSignIn::validate();
About other errors...do you have mysqloo installed?

[RalphORama]

About other errors...do you have mysqloo installed?

Yep, the addon doesn't work without it. I have the lua file in garrysmod/addons/ulx/lua/ulx/modules/sh/opensteam.lua, libmysqlclient.so.18 in my root folder (next to srcds_linux), and gmsv_mysqloo_linux.dll in garrysmod/lua/bin/.

As for logging in, I added your line of code, and while it does get rid of the error on the login page, nothing happens/changes when I log in (or try to register).

[Storm]

I was about to download this but saw the comment that it can cause major server lag. I probably just misunderstood the reference. Can you explain?