Hello people,
At first i searched the whole forum for help (not only this forum ;);))
Some days ago i started my own CSS server. For now i use an dedicated server (located home) and these are the specs.
Amd 2400+/Asrock mobo/1gb ram/ati9600 Its not a great server but its just for testing.
Its running fine without the WCS3mod and i played with friends on it. It also works with the WCS3Mod without a database (or stored in a .txt). Ports and all that other stuff is forwared on the right way and is also working.
But......
The software:
Windows xp SP1
Kaspersky (up to date)
hldsupdatetool
srcds counterstrike dedicated server (up to date)
Wamp 1.7.2 (apache & MySQL)
Counterstrike plugins/addons
Source_Utils_v1.6_mms (metamod version)
sourcemm-1.4.2 (metamod itself)
Mattie eventscript
Eventscript_ver 1.3.0.006
Est_eversion 0.418
WCS3 version 0.75
The problem:
Because i just started with all this stuff, i have no idea how it actually works.
So here are my main questions:
1. Does Source_Utils have anything to do with MySQL (the MySQL from
www.mysql.com)?
2. If no, where does this Source Utils stores its data? (databases)
3. If yes, how to set up a decent connection for the WCS3 mod because it just wont connect to the MySQL server.
4. What is the default root password for Source Utils? And how or where do i change it?
5. Could somebody give me a link with a tutorial or something about this all ?
I think it could be something with the code of the WCS3mod:
Code:
block load
{
// DB settings
es_xsetinfo wcs_sql_user "this is the place where i put my MySQL username"
es_xsetinfo wcs_sql_password "************"
es_xsetinfo wcs_sql_host "192.168.1.206"
es_xsetinfo wcs_sql_port "3306" // 3306 is default
es_xsetinfo wcs_sql_dbname "wcs_users" // can be modified !
es_xsetinfo wcs_sql_tablename "player_levels" // can be modified !
es es_xexists wcs_exists command wcs_sql_setplayer
es es_xif (server_var(wcs_exists) = "0") then es_xregcmd wcs_sql_setplayer wcs/WCSsql/wcs_sql_setplayer "saves a player"
es es_xexists wcs_exists command wcs_sql_getplayer
es es_xif (server_var(wcs_exists) = "0") then es_xregcmd wcs_sql_getplayer wcs/WCSsql/wcs_sql_getplayer "get a player"
es_xsetinfo wcs_sql_query 0
es_xsetinfo wcs_sql_query2 0
es_xsetinfo wcs_sql_query_result 0
es_xsetinfo wcs_sql_tmp1 0
es_xsetinfo wcs_sql_tmp2 0
alias wcs_runquery "es_xsetinfo wcs_sql_query_result 0; es su_mysql server_var(wcs_sql_host) server_var(wcs_sql_port) server_var(wcs_sql_user) server_var(wcs_sql_password) server_var(wcs_sql_dbname) server_var(wcs_sql_query) wcs_sql_query_result;"
alias wcs_runquery "es est_strlen wcs_strlen server_var(wcs_sql_query);es es_xif (server_var(wcs_debug) = 1) then echo qry: server_var(wcs_sql_query) len: server_var(wcs_strlen) result: ' server_var(wcs_sql_query_result) '"
// init the DB, table 1
es es_xformat wcs_sql_query "CREATE TABLE %1 (steamid VARCHAR(30) NOT NULL, lastplayed INT DEFAULT 0, race TINYINT DEFAULT 0, PRIMARY KEY (steamid))" server_var(wcs_sql_tablename)
wcs_runquery
es_xsetinfo wcs_counter 1
while "server_var(wcs_counter) <= server_var(wcs_numberofraces)" "es_xdoblock wcs/WCSsql/wcs_sql_createloop;es_xmath wcs_counter + 1"
// get the name as last column
es es_xformat wcs_sql_query "ALTER TABLE %1 ADD name_1 VARCHAR(50) DEFAULT 0" server_var(wcs_sql_tablename)
wcs_runquery
es es_xformat wcs_sql_query "UPDATE %1 set name_1 = name" server_var(wcs_sql_tablename)
wcs_runquery
es es_xformat wcs_sql_query "ALTER TABLE %1 DROP COLUMN name" server_var(wcs_sql_tablename)
wcs_runquery
es es_xformat wcs_sql_query "ALTER TABLE %1 CHANGE name_1 name VARCHAR(50) DEFAULT 0" server_var(wcs_sql_tablename)
wcs_runquery
}
This is just a piece of the code .
These are my questions so far (yeah im a big noob(^^)).
Any help would be greatfull.
Thanks,
PsYcH