[Mr. Man]

The plugin still works fine but sometimes completely drop local DB connection for unknown reasons. I've just had an instance yesterday where I am able to use all of the commands but cannot get scoring updates sent to the local DB at all unless I restarted the game server.

[ShambleS]

just coming back to confirm it is working 100% with a properly setup mysql server (still not sure what i did wrong setting mine up as it seemed fine)
unfortunatly as i opted for a free host the page is rediculosuly slow to load. and most of the time it times out im unable to check if the database has the same issue or only the php page(s)

really need to work on my own mysql db server, but as that is not the plugins fault i will go try and figure it out my self.

[muukis]

Originally Posted by Mr. Man The plugin still works fine but sometimes completely drop local DB connection for unknown reasons. I've just had an instance yesterday where I am able to use all of the commands but cannot get scoring updates sent to the local DB at all unless I restarted the game server.

I'm sorry to hear that. I don't think there is anything that can be done from the plugin to make that change. Try searching the answer from Google?

Originally Posted by ShambleS just coming back to confirm it is working 100% with a properly setup mysql server (still not sure what i did wrong setting mine up as it seemed fine) unfortunatly as i opted for a free host the page is rediculosuly slow to load. and most of the time it times out im unable to check if the database has the same issue or only the php page(s) really need to work on my own mysql db server, but as that is not the plugins fault i will go try and figure it out my self.

It shouldn't be very difficult. My test server consists of MySQL database, IIS and PHP, and the dedicated game server. It has always been like that. I don't have the game client in that machine.

[Mr. Man]

Originally Posted by muukis I'm sorry to hear that. I don't think there is anything that can be done from the plugin to make that change. Try searching the answer from Google?

It's giving me a headache too since it throws no errors whatsoever. At some point when the server is running it just suddenly drops the connection which it should not be doing.

[ShambleS]

where would i add this in the php files to get it to show up on every page alligned center left?

echo  '<a href="http://www.gametracker.com/server_info/shamserver.no-ip.info:9459"><img src="http://cache.www.gametracker.com/server_info/shamserver.no-ip.info:9459/b_160_400_0_FFFFFF_C5C5C5_FFFFFF_000000_1_1_1.png"  /></a>';

pretty damend sure i did it last time using like 3 of the files including styles.css because i also eidited it for clan colours and logo. "dont need that now just want to add the image i posted above" but i have forgotten almost everything i ever knew about php in the last 4 years, funny enough i still remember my html which is now useless.

Edit

never mind. i found it. I needed to use the layout page to get it done.

[petraunas]

Hi, I'm new to this so please bear with me. Let's say the code is correct, do we need to restart a service or something for the changes to take effect?

[muukis]

Originally Posted by petraunas Hi, I'm new to this so please bear with me. Let's say the code is correct, do we need to restart a service or something for the changes to take effect?

Welcome!

You need to give us more information. What code you are referring to? What service you are referring to?

If you change the plugin configurations, they are read every time the map starts. I'm not 100% sure of that. To be 100% sure they are read, restart the game server process or reload the plugin. PHP changes should always work instantly.

[Tiger50]

Hi

I've been using this on all 20 of my (L4D2) servers and so far it has been perfect

6 are windows servers, and 14 Ubuntu servers and Ive had upto 56 players on at once, with no problems at all.

MY question is I would like to run a competition once a month

Is their a way to keep the total scores fore each player, and monthly score for each player

I was thinking I could run 2 databases, one as it is now for the total scores, install this plugin again on the webserver and run it as a monthly score sheet

The only trouble with this idea i can see is would the plugn load twice on the game server? 1 for the main database and then again for the month database

All my group members love this plugin, as it adds more fun to the game, we use to play for highest times in survival now we play for highst points.

Thank you very much for this plugin its brilliant

[muukis]

Originally Posted by Tiger50 MY question is I would like to run a competition once a month Is their a way to keep the total scores fore each player, and monthly score for each player I was thinking I could run 2 databases, one as it is now for the total scores, install this plugin again on the webserver and run it as a monthly score sheet

Hello!

Running two databases and update them both at runtime is not easy. Two same plugins at one game server wont work, because SourceMod will block the second from running due to same signatures? The "easiest" way I see this working is to create a blank database for the competition and then when it's finished, migrate it to your main database. This too will also not be a trivial task, but if you (or someone that has access to your database) have any SQL skills, it should be doable. It should be possible with only a few update queries, in addition to a few insert queries. You should be able to use those same queries later on, if you want to do a competition again. If I have the time, I could write you an example for those queries.

[Tiger50]

@muukis

Thank you for your reply

It sounds like a lot of work to merge the databases

But we are happy to have the running totals and will stay with that

Once again thank you for all your hard work