[snelvuur]

well in the database it does indeed miss a default value, but i never got this error message. You can see the database correctly with the tables right? Btw, you can also just add me on steam if thats easier..

[TnTSCS]

request sent - there were two matching steam names..

Anyways, here's the database:

[TnTSCS]

line 48 of servers.php:

PHP Code:

if( mysql_query_trace( "INSERT INTO servers ( ip, port, rconpass ) VALUES( '$ip','$port','$rcon' )" ) ) 


Even if I try the following directly as a sql statement on the database server:

INSERT INTO servers ( ip, port, rconpass ) VALUES( '192.168.1.100','27015','testpw' )

I get the error: Field 'servername' doesn't have a default value

Is this an issue with the database setup? I executed the ssms-1.0.1.sql and nothing else.

...:: TnT Edit ::...
Ha... after setting default values in the table design on the sql server, everything seems to be working...

[snelvuur]

i've added a dummy default value for servername now too, thanks for that. i believe its a sql issue yes, because at some point i made it that you only need the ip/port/rcon and it will query the server for you. But if it wants to insert it while the query for servername is not done yet then it fails (since servername = not null)

was servername the only one that had a issue? Otherwise i might need to change it proper.

[TnTSCS]

no, all of the ones that didn't have a default defined gave issues... I went one by one, setting a default value, then trying to add a server, and all that didn't have a default value assigned needed one... I just set the default to NULL instead of "No Default"

[snelvuur]

did you use the icon with the + on server overview or the addserver.php?

Also, CS:GO images added on experimental.

INSERT INTO `ssms`.`games` (`shortname`, `longname`, `appID`, `version`, `expired`, `minplayers`) VALUES ('csgo', 'Counter-Strike: Global Offensive', '730', '0', 'no', '4');

You can add something like this, but i dont see any xml app info so i cant do a version check yet. (maybe appid will change too later on)

[snelvuur]

Also tested the server redirect/ads and it still works fine on CS:GO to.

[TnTSCS]

I used the + on the servers.php

I added my own CS:GO stuff and put in the version info, but no auto version check yet, however, there is an API to check the version:
http://api.steampowered.com/ISteamAp...=730&version=0

[snelvuur]

My first sql insert line had appid 740, it should be 730.. now it checks..

[poppin-fresh]

Everything seems to be working fine with no errors, rcon works and everything. I try and run walk on my css server and it says 'update complete' but everything's blank