local ULX_HOST = "127.0.0.1" local ULX_PORT = 3306 local ULX_DATABASE = "prop_hunt" local ULX_USERNAME = "root" local ULX_PASSWORD = "password" |
sv_loadingurl "http://YOUR_WEBSITE/loading/?mapname=%m&steamid=%s"
(note: change YOUR_WEBSITE to match yours)1)will this also record permabans to banned_user.cfg?No, record permabans is done only through the database.
2)will this also record information to bans.txt?No.
3)how will this deal with bans across multiple servers or will it?Depends on how you've set in Lua. I do not see why someone set the different databases for each server. So that the system natively supports multiple servers.
I do not see why someone set the different databases for each server.
Do you think you could also add ban reasons?Yes, that was planned...but somehow I forgot to add.
Will admin groups be automatically loaded? (In the admins page, if a group inherits from admin, will it show up as its group name?) Or, is it configurable in any way?Groups are automatically loaded. However, only superadmins can modify configurations and bans. Will add more options for this.
When running commands such as sid, is the player's name searched like ULX does it where it's like a search system? (Example: !sid short would return the SteamID of Short Circuit?)
Sourcebans still uses mysql_connect(); functions, when the MySQL library is deprecated as of PHP 5.5. (Hopefully you guys use MySQLi :P)Even better. We are using Data Object (PDO).
Sourcebans 2 (built under Bootstrap) is still in early development.Bootstrap is only template. We are using it because of responsive design. It's easy to create a template for OpenSteam. However, I never tried and tested Sourcebans...will look into it...
Yes, that was planned...but somehow I forgot to add.Groups are automatically loaded. However, only superadmins can modify configurations and bans. Will add more options for this.Nice! :D
ulx sid command return data from the database. Currently it only returns Steam ID (not Community ID), but can be easily added.
On the web you can search users by Name, SteamID, CommunityID (it will automatically recognize).
However, this is how loading screens looks like:
screen1 (http://ohsystem.net/public_images/loading_01.jpg) screen2 (http://ohsystem.net/public_images/loading_02.jpg)
Edit user: screen2 (http://ohsystem.net/public_images/edit_user.jpg)
Even better. We are using Data Object (PDO).
Personally, I like MySQLi, but that's just my preferenceWell, maybe you can try PDO and like it. :)
Will this system ever be opened for translations into other languages?Yes, you have languages in lang/ folder. I will add dropdown so each user can change the language.
Ok, added option to set Group permissions, create, edit or remove group. Group superadmin can not be changed or removed.I'd recommend a few things with that:
When group is updated or removed it's also updated on all players for that group. For example, if you change group name it will be changed on all players that is in that group automatically.
group permissions (http://ohsystem.net/public_images/group_02.jpg)
If possible, dynamically find the permissions available (added by plugins) and add those to the permissions edit.There is a list of commands that are used on the server. Command list can be updated. In this way, it's possible to globally remove/add a command. I still have not figured out how privileges work (inherit from other group), because it looks like to me is not working properly or probably I'm doing wrong.
If not possible, at least allow for configs for more permissions.
#moreconfigs (rank badges).
Also, a question- are you guys open to pull requests? I'd love to help you out if you need it. I'm good with Bootstrap and decent with PHP, so... yeh.Well, that's okay, but would be better if someone who knows LuA scripting, we already have a lot of support for php/MySQL, C++ ...however, it is good to have as much support.
If someone's ban has expired, does it get deleted or does it stay there?Currently, the record stored in the database, but user is not banned (ban expired). The main reason for this is that I plan to add the number of bans for players, so we can see how many times a player has been banned. So, when the ban expired, penalty point remains.
Well, that's okay, but would be better if someone who knows LuA scripting, we already have a lot of support for php/MySQL, C++ ...however, it is good to have as much support.I do know enough Lua to get by, same with PHP, CSS, and HTML. :P
As said PHP, CSS, HTML is not wanted ;-)Well remember...
I do know enough Lua to get by
-snip-Hmmm... most likely location- Dallas, TX, USA (my location) gets about a 1s response time.
And your site is very slow.... ~25 seconds to load. Im not sure if this is my location or whatever.
-snip
Tracing route to ponypwnage.net [83.253.91.106]
over a maximum of 100 hops:
1 1 ms 1 ms <1 ms 192.168.1.254
2 22 ms 23 ms 21 ms 108-79-32-3.lightspeed.rcsntx.sbcglobal.net [108.79.32.3]
3 23 ms 21 ms 23 ms 70.143.193.44
4 21 ms 22 ms 22 ms 12.83.80.161
5 25 ms 22 ms 22 ms ggr3.dlstx.ip.att.net [12.122.138.17]
6 26 ms 21 ms 21 ms 192.205.37.50
7 125 ms 66 ms 66 ms nyk-bb1-link.telia.net [213.155.133.176]
8 149 ms 149 ms 147 ms kbn-bb1-link.telia.net [80.91.249.25]
9 159 ms 159 ms 159 ms s-bb3-link.telia.net [80.91.246.106]
10 160 ms 159 ms 159 ms s-b5-link.telia.net [62.115.137.159]
11 167 ms 167 ms 170 ms comhem-ic-118784-s-b3.c.telia.net [213.248.99.86]
12 167 ms 166 ms 166 ms 83.255.253.205
13 191 ms 193 ms 189 ms sv-bb-r-01-to-mx-bbr-2.comhem.se [83.255.252.52]
14 180 ms 184 ms 185 ms osk-bb-r-01-to-sv-bb-r-01.comhem.se [83.255.252.50]
15 176 ms 182 ms 185 ms 83.255.251.161
16 * * * Request timed out.
17 * * * Request timed out.
18 * * * Request timed out.
19 * * * Request timed out.
20 * * * Request timed out.
21 * * * Request timed out.
22 * * * Request timed out.
23 * * * Request timed out.
24 * * * Request timed out.
25 * * * Request timed out.
26 * * * Request timed out.
27 ^C
--Broke here because I hit something... huh.--
No idea what I hit around hop 16. I'll have to check with my provider on that one.
You, Princess Twilight Sparkle, have our permission (included in the license!) to change the theme in your mind AS LONG AS you keep footer credits which definitely link to us directly.Sweet, good to know! Thanks! :D
-snip-
Yea I was just interested how the theme would look like, so I looked it up. I first thought its my location which occur that problem so I did a speed test. ;-)Apparently it's my and my lead web developer's PHP skills. xD
Short Circuit: DudeEDIT: We know the host semi-personally, which would explain the Skype convo. :P
Short Circuit: the site
Short Circuit: is slower than the old host
Short Circuit: wat
LordNature: You <censor>ed something up
LordNature: [10:50 AM] <host>: Well something is up with your code
Of course, feel free to add "Template by" or "Template modification" or whatever you want in footer.I will most likely- though mostly it's just Yeti on Bootswatch with a modded CSS scheme, but meh.
However, I added server remote control and server list (with server query from steamAPI). Now it's possible to include banned message on loading screen for banned players.Nice! Looks great!
server info (http://ohsystem.net/public_images/servers.jpg) | server rcon (http://ohsystem.net/public_images/rcon_01.jpg)
Is there a timeline for your work- its completion I mean?
There's no timeline for this project. However, OpenSteam can already be used and in time we add a new features.
Suggestion: Ban requests/appeals.We had a simlair system on OS where everyone could amke ban requests/appeals. It was made back in tiem by Neubivljiv, after we started to work together and started with hosting aswell we also used the forum for it. Its more prefereable and also for this kind of requests etc, how are you able to proof it?
Specifics: In game command for ban requests if no admins are online ("ulx reqban <steamid/name> <reason>" as an example). Web interface for appeals/requests. (If possible) Notify admins via notification on home page or in e-mail (add interface for admins to link e-mail to account and add interface/config for linking an IMAP or SMTP server to send e-mails [maybe? :3])
Reason: As a server owner I find it very difficult to keep up with ban requests and rule breakers. Having a utility such as this would definitely help!
If this gets added, that'd be cool! :D
Why would anyone want to ban everyone form a country?Illegal immigration wastes country's resources?
Why would anyone want to ban everyone form a country?
Why would anyone want to ban everyone form a country?What question is that? :) Why you even want to ban anyone? :)
I would like to start using this but, as I said, I am afraid of losing all my current bans. Is there a way currently to migrate current bans from banned_user.cfg or is that a future option? I know I asked this before but I was confused about your answer, sorry.Currently you wouldnt loose the bans, but there is atm no way to import bans, this can be added as feature soon.
If there is, can you tell me how to do that? Also, if I just want to use the permissions I have on each server for staff, is there a way to turn off that option in your system?What do you mean exactly by that? Global permissions for each staff member or certain for specific servers?
I assume the loading screen doesn't have to be used if we have a custom one?You dont need to use our loading screen, it can be disabled i think
Another thing that is stopping me (and others might have this concern) is that I am rather a MySql noob :-[ .You dont need to have any knowledge about MySQL :-) You only need to set up the MySQL database and create a user for it. The rest is done through the panel.
Sounds already good.I think I did this right, at least I did some sort of pull request.
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
Clear your internet cache.Didn't work. Same thing happens on other browsers as well (IE, Chrome, and WaterFox)
...seasoned admins will forget and use the standard commands, causing a mess of the bans. For example, ULX Global Ban [0.5] does this.
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. 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.
[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
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
$Validate = SteamSignIn::validate();
replace withif(isset($_GET["openid_ns"])) $Validate = SteamSignIn::validate();
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/.
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?Storm, the reference was to a query statement within another 'global' system, ULX Global Ban 0.5.
I am trying to install this and get this error. What am I doing wrong?Make sure that you have PDO enabled. Also, open config.php and modify the settings for your database (see first post - Installation)
Warning: Creating default object from empty value in /usr/www/myuserid/public/WEB/inc/class.db.PDO.php on line 18
Error!: Unable to connect to the database
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).
[ERROR] addons/opensteam/lua/opensteam/os_mysqloo.lua:25: attempt to index local 'queryQ' (a nil value)I don't know if this is it, but are you using the most updated mysqloo? http://facepunch.com/showthread.php?t=1357773 (http://facepunch.com/showthread.php?t=1357773)
1. fn - addons/opensteam/lua/opensteam/os_mysqloo.lua:25
2. unknown - addons/ulib/lua/ulib/shared/hook.lua:183
I don't know if this is it, but are you using the most updated mysqloo? http://facepunch.com/showthread.php?t=1357773 (http://facepunch.com/showthread.php?t=1357773)
Please check all before asking a question about database connection. If your installation of MySQLOO is not good, we do not provide support for it. So before posting, make sure that your MySQLOO is working (and without OpenSteam).;)
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql_mode=NO_ENGINE_SUBSTITUTION
DROP TABLE IF EXISTS `ph_servers`;
CREATE TABLE IF NOT EXISTS `ph_servers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`server_name` varchar(150) NOT NULL,
`server_ip` varchar(20) NOT NULL,
`server_port` varchar(16) NOT NULL,
`server_rcon` varchar(128) NOT NULL,
`enabled` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `server_ip` (`server_ip`,`server_port`),
KEY `enabled` (`enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[ERROR] addons/opensteam/lua/opensteam/os_mysqloo.lua:343: attempt to index local 'queryQ' (a nil value)
1. call - addons/opensteam/lua/opensteam/os_mysqloo.lua:343
2. __fn - addons/ulib/lua/ulib/shared/commands.lua:943
3. unknown - addons/ulib/lua/ulib/shared/commands.lua:1296
4. unknown - lua/includes/modules/concommand.lua:69
My mysqloo version is 8.1. Any fixes?