[JaySingh]

I won't be needing SourceMod anymore, so it looks like I'll be using SourceOP only from now on. As a result of this, I'll have to use reserved slots as a way to support my servers. So a couple of questions regarding reserved slots and MySQL.

- what the hell is DF_rslots_slots?
- how do reserved slots work? does it kick players with the lowest kpdr?
- does reloading the reserved slot database at a set interval cause the server to lag?
- does DF_sql_playerdatabase 1 log everyone's name and steam id to the database?
- do all the tables and what not get generated by SourceOP?

Oh, and how would I get the hlx / gameME plugin for SourceOP to work?

[Drunken F00l]

DF_rslots_slots controls the maximum number of players allowed to connect using their reserved slot. For example, if set to 16, once there are 16 players on the server with reserved slots, no more players can use their reserved slot to kick someone off. This ensures you maintain at least a few new or non-paying members. Just set it to the number of maxplayers if you don't want the limit.

It kicks based on points per death.

Yes, DF_sql_playerdatabase will log names and connections.

SourceOP doesn't generate the tables. You'll need this sql file.

The hlx/gameME stuff should just work if you have lua enabled. There should be some lua scripts included for the hlx_ commands. This is the same as the "Beetlesmod" option in the gameME control panel.

[JaySingh]

SourceOP doesn't generate the tables. You'll need this sql file.

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 23

[JaySingh]

Well, what I did was manually copy and paste each section of the SQL file. Hopefully that works.

EDIT: Yup, looks like it did.

[JaySingh]

Alright so I got the database to connect to the server (bans work and what not), but I'm having trouble getting reserved slots to work.

I hooked up the database and what not with my donate page so here's what the tables are at the moment.

id - 1
steamid - my steamid
name - my in-game name
ip1, ip2, ip3 - 00000000
donated - tested $5, $15, $200, $2000, non worked
time stamp / last update - 0
expiration - 1311627531
profileid - 0

We tested on a 4 slot server. We had 4 people connect to the server and the guy who was added to the database tried to connect. It said the server was full. We have sv_visiblemaxplayers set to 4 as well.

[Drunken F00l]

Is DF_rslots_enabled 1

[zachcheatham]

How is the expiration field used in the rslots table?

[Drunken F00l]

It's for when the slot expires. If the expiration time passes the slot is expired and the table row is deleted eventually.

[JaySingh]

Well, I got reserved slots working. My problem was not entering the profile ID of the user. Looks like I'll have to grab that from the database as well.

I got another problem .

Is there any reason why the gameME plugin doesn't display any in-game chat text information?

Here's my situation.

Server A - works as it should (rank displays the rank menu, the points gained and lost are displayed in chat, place displays your rank to the entire server in chat)

Server B - has the same settings in the gameME panel as Server A, has SourceOP installed / same server-side settings as server A, but only the rank command works. The points gained and lost are NOT displayed in chat, and place displays nothing. In other words, anything dealing with the chat that gameME is supposed to output doesn't work.

Here's a random part of the console of the server that isn't working:

Code:

22:18:12 "PolecatEZ<926><STEAM_0><Red>" triggered "kill assist" against "MoTh??La?dâ„¢<960><STEAM_0><Blue>" (assister_position "487 -761 3") (attacker_position "-78 -153 12") (victim_position "-307 -686 4")
22:18:13

rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xc5ba560)" 1 "GEPs are FOREVER (2,723) got 5 points for Built Object - Sentrygun""
22:18:13

rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xa550880)" 1 "P. Jacob (2,163) got 7 points [-2] for killing MoTh??La?dâ„¢ (3,704)""
22:18:13

rcon from "85.214.223.36:56973": command "hlx_psay "ARRAY(0xb5df0a0)" 1 "PolecatEZ (21,083) got 2 points for Kill Assist""

It looks like it should be working, but it just won't display for some odd reason.

[Drunken F00l]

Ya something is definitely wrong on their end. Check out that command they're sending you. hlx_psay ARRAY(0xbleh). Wtf is that?