View Single Post
muukis
Veteran Member
Join Date: Apr 2009
Old 02-07-2010 , 12:03   Re: [L4D & L4D2] Custom Player Stats v1.4B66
Reply With Quote #208

Quote:
Originally Posted by kwski43 View Post
muukis, you're awesome! Need more ideas? ^^'

There is a problem with updatetable.php it takes some time(16 mins I think) and it stops and gives white screen and feature doesn't work, its due to city db, too many mb's.
New ideas are always welcomed

Yes I noticed the installing can be very slow. If your web server settings won't wait for the script to finish, you can try different approaches with the installation.
  1. Run updatetable.php multiple times, but each time with different CSV-file.
  2. Modify if ($insert_counter > 200) to something much higher value than 200 (or what ever is in there). Your MySQL will probably tell you when you have put too big value in there.
  3. Split the big CSV-files and modify the scripts to not clear the tables before running the insert queries, and then do approach #1.
It took me a lot of time to run updatetable.php too, but it did go under 10 minutes. I can do an executable (MS Windows) what you can use to install the database, if it turns out to be too big of a problem.

Quote:
Originally Posted by NaRyan View Post
Nice

I do have a suggestion, if it's possible.
For the "Team Survivors can use this many Medkits for free without any reduction to the score"

Would it be possible to add options to have that based on the difficulty?
So that on Normal they could get 0, advanced 2, expert 4 and for realism the option adds the number to the difficulty version.

so if you had it like
l4d_stats_medkitpenaltyfree_Normal = "0"
l4d_stats_medkitpenaltyfree_Advanced = "2"
l4d_stats_medkitpenaltyfree_Expert = "4"
l4d_stats_medkitpenaltyfree_Realism = "2"

Then the survivors would get, when playing realism (since it can be enabled on any difficulty) 2, 4, 6 "free" medkits.

Also I don't know if you missed the post I made a few pages back.
When I made the suggestion below.
Sorry if you did see it and thought it was a bad idea.
Yeah, I did see it, but... I've also thought about it before you posted the idea. The problem for me is, that I don't want the group to be polluted by spammers etc. I'd like it to be clean. I was hoping there was a feature that allowed group admins to "kick" servers and block them so they do not appear on the group list... I have not decided yet.

Yes, the medkit suggestion is doable, and very nice. I'll put it on todos. Thanks
__________________
Monster Hunter

Though certainly not superhuman, the man's prowess inspires an excess of whispered rumors. But those rumors remain in the realm of speculation.

Last edited by muukis; 02-07-2010 at 12:13.
muukis is offline