[xmagicboyx]

Originally Posted by .=QUACK=.Major.pain You need to rent a web hosting server if you don't already have one. Then in the cpanel, you have to create a database for the stats to be stored. You also have to setup remoteSql to allow the game server to communicate with the web site database.

It seems very complicated =\
what you mean "web hosting server" website for my server ?
i didnt have and i dont know how to create it..
and have many types of websites..
also i cant go to cpanel if i dont have website.
and i dont know how to download and how to use the remoteSql, and dont know how to allow the game server to communicate with the web site database.......... oh thats hard
have some guides for it ?..

[muukis]

Originally Posted by xmagicboyx It seems very complicated =\ what you mean "web hosting server" website for my server ? i didnt have and i dont know how to create it.. and have many types of websites.. also i cant go to cpanel if i dont have website. and i dont know how to download and how to use the remoteSql, and dont know how to allow the game server to communicate with the web site database.......... oh thats hard have some guides for it ?..

MySQL tutorial
MySQL remote access
cPanel tutorial
Web hosting PHP MySQL cPanel

The webstats web site is not required for the plugin to operate. You will need the webstats if you want to share your player stats to the public or for some other reason want to browse them yourself. The plugin will still require MySQL however.

[muukis]

Originally Posted by PeterFreimann Thats exactly the problem I try updatetable.php hmm. didn't do much except many Duplicate column name ... and some Timed Maps table altered successfully! and Players table altered successfully!

The update script passed OK, I believe. It is supposed to give you a lot of duplicate column name errors when everything is already set.

If your game server is showing statistics ok and still you don't see those stats in your webstats, your game servers are not writing to the same database. Make sure that you gain score from playing at both servers and then make sure your stats in both servers are the same.

[RasterMan]

Are we gonna have an update soon as the spam logs are doing my head in!

[muukis]

The development has been on halt for some time now, but just the other day I was thinking about caveing in again. I could do a quick patch to fix some of the easiest problems first.

Could you make it easier for me and memorize me about the issues you want me to focus on. I would appreciate it a lot!

[PeterFreimann]

Don't know what did it but it works now :-/ perhaps the updatetables did it

[terminator2k2]

hi there wandering if some one can help me.?

ive got a webserver with a mysql data base........ive put the ip addys in there to accept connections from webserver and game server.....

only problem i had was, with remote mysql it wouldnt accept the port of the game server only the ip addy...does this matter.?

instead of say 89.345.234.23:28012 i could only put 89.345.234.23

here is my webserver as it is http://www.mastersofthedead.clan7.nu

im getting errors as i dont have the config file quite right in the plugin config.....

the problem im having is finding out wat the host name is and also the other details to input into database.cfg in sourcemod........

can i find these in cpanel.? ive never used cpanel before so finding it quite hard for now.......

cheers chris

[.=QUACK=.Major.pain]

Originally Posted by terminator2k2 hi there wandering if some one can help me.? ive got a webserver with a mysql data base........ive put the ip addys in there to accept connections from webserver and game server..... only problem i had was, with remote mysql it wouldnt accept the port of the game server only the ip addy...does this matter.? instead of say 89.345.234.23:28012 i could only put 89.345.234.23 here is my webserver as it is http://www.mastersofthedead.clan7.nu im getting errors as i dont have the config file quite right in the plugin config..... the problem im having is finding out wat the host name is and also the other details to input into database.cfg in sourcemod........ can i find these in cpanel.? ive never used cpanel before so finding it quite hard for now....... cheers chris

Just ip without port is ok. This allows connection through all ports.

I guess the errors are because you haven't created a database.

Go to cPanel
Go to MySql Databases
Create a new database
Near the bottom, if you don't have a user, create a user and password.
Then you need to add user to the database, also at the bottom.
When you click on add, add all permissions to the user/database.
Now you have to add the info in the databases.cfg.

Open the file and add before the last "}"

"l4dstats"
{
"driver" "mysql"
"host" "your database url or ip"
"database" "your database name"
"user" "your database user"
"pass" "your database user password"
//"port" "3306"
}

[terminator2k2]

thanks for that i think it may be down to the mysql "host name"

and i cant seem to find wat it is...so i used the website addy which i know is possibly wrong.....i cant seem to find the ip or addy of the mysql database

[RasterMan]

When are we getting an update to stop the spamming in the logs?