PDA

View Full Version : Yearly Gun Game psychostats reset?



ZERO
11-21-2011, 01:22 PM
For those of you that noticed gg has not been updating any more and I temp disabled the stats display in the forums. The reason for this is that the database for GG has grown too large due to poor programming of the old PS version. I have been trying to get an updated version of ps made to fix this issue but now the load that this database places on the server causes it to lag up on a regular basis.

Currently the stats on the GG database go back for 4 years! That is right you can find every player that has been in there for 4 years and their stats. I actually think this is pretty cool which is why I want to keep it. So that also means that if we do replace this I will keep it up at an address like /gg_stats2007-2011.

Here is what I propose to do:

Copy the current gg stats you all have at a new address so we all have it for player records.
Reset the stats on the current gg stats
Start the current stats at Jan2011 and then reset them every year on that date until we get a solution.
All yearly databases will be accessible @ /gg_stats2011 /gg_stats2012 ect.

I think this solution is cool for one big reason that it does sort of allow of an annual winner and top 10 of gg.

So what do you all think? If we ever get a new version of ps that supports gg I can still go and re import all the stats together.

Disflux
11-21-2011, 02:31 PM
+1 :wtg:

Steamer
11-21-2011, 03:25 PM
So fresh and so clean clean, how about zmod next after the spawn fix. :wtg:

Xerenix
11-21-2011, 04:50 PM
Sounds great.

Penis シ
11-21-2011, 05:15 PM
I'm cool with it as long as it doesn't reset wins in game. I worked hard for #4 and intend to keep climbing.

ZERO
11-21-2011, 06:12 PM
It will not effect the !rank settings.

Penis シ
11-21-2011, 06:18 PM
Then I'm sold!

Carmichal
11-21-2011, 06:31 PM
But I like having an 47% rate of headshots

maynard
11-21-2011, 07:05 PM
But I like having an 47% rate of headshots

very nice

BladeTwinSwords
11-21-2011, 07:18 PM
I heartily agree with Steamer. ZMOD needs a massive reset. People are coming back to play for like 5 minutes so they can just keep their rank on the stats.

GG could use some stats cleaning. I say clean it up.

ZERO
11-21-2011, 08:18 PM
But I like having an 47% rate of headshots
Yes one of the reasons for never resetting it was to not effect my 47.63% HS ratio.

Carmichal
11-21-2011, 08:55 PM
is it possible to see who has the highest head shot ratio?

acolyte_to_jippity
11-21-2011, 09:20 PM
is it possible to see who has the highest head shot ratio?

not you.

http://www.ibisgaming.com/gg_stats/player.php?id=188836

a (http://www.ibisgaming.com/gg_stats/player.php?id=188836)nd it was very easy to find this. all i did was go to the weapons page, sort by headshots, then copy the string after ".php" from the url, paste it onto the end of the players list url, then changed it to "headshotkillspct"

done.

http://www.ibisgaming.com/gg_stats/index.php?sort=headshotkillspct&order=desc

maynard
11-21-2011, 09:24 PM
who cares about someone who has 2 hours on the server and 30 something kills lol...

ZERO
11-21-2011, 10:51 PM
But we will always remember his amazing 37 hs from exactly 37 kills........ wait a second, we are sure this guy is banned right? :smirk:

Oh good: http://www.vacbanned.com/view/detail/id/76561197970094065

maynard
11-21-2011, 10:53 PM
Lol... pwwnd.

Carmichal
11-22-2011, 09:12 AM
not you.

http://www.ibisgaming.com/gg_stats/player.php?id=188836

a (http://www.ibisgaming.com/gg_stats/player.php?id=188836)nd it was very easy to find this. all i did was go to the weapons page, sort by headshots, then copy the string after ".php" from the url, paste it onto the end of the players list url, then changed it to "headshotkillspct"

done.

http://www.ibisgaming.com/gg_stats/index.php?sort=headshotkillspct&order=desc

well I kind knew I didn't since I knew zero has a better ratio than me. also i have like 5x as many kills than those people on that list. guess its not really a easy stat to look at.

bigcraig77
11-22-2011, 10:54 AM
The GG stats are a little antiquated. Some of my top victims are still Cloud and insanity from back in the day (09)

Looks like my plan of beating Shady at most online time is spoiled.
Is there any way to see who's been actively playing the longest?

I gutta be up there (2007-12-06 10:56:55)

Should i be proud, or embarrassed?

c-loc

acolyte_to_jippity
11-22-2011, 01:02 PM
he's got you beat by like, 180 hours dude.

Nemesis
12-02-2011, 11:52 PM
What about instead of deleting everything just clearing anyone who hasn't logged on in a year or who is below 5000 player rank? that way we don't loose everything and the regs still keep the stats we like.

Fluffy Frufflebottoms
12-03-2011, 12:20 AM
It'll be good to see if anyone can topple my KDR from a clean slate.

Spasm
12-03-2011, 07:40 PM
It'll be good to see if anyone can topple my KDR from a clean slate.

Nah you da best at gg sir. Prolly make your lead even harder to catch.

ZERO
12-17-2011, 03:31 AM
I am finally getting the database swapped now. Hopefully, this will allow me to easily reset the stats on a new database and then re-import all the stats from this year. Stats should become valid again within a few days. :wtg:

Carmichal
12-17-2011, 04:06 AM
zero i love you... <3

ZERO
12-21-2011, 03:59 AM
Finally after days I have compleated the data transfer to ensure the settings for the subsequent gg databases will be the same. It took days for the sql transfers!

Now I am uploading 11gb of log files to the server for importing. Import will start within the next 24 hours and by Thursday/Friday gg data will be live again!

---------- Post added at 03:59 AM ---------- Previous post was at 03:47 AM ----------

wow 33,000+ log files this might be a while... :banghead:

Rellikdloc
12-21-2011, 08:20 PM
Nah you da best at gg sir. Prolly make your lead even harder to catch.

haha. thats funny considering ive only been on this server for exactly 1 year and already have over 600 wins. Wasnt to hard for penis either.

brett friggin favre
12-21-2011, 09:23 PM
haha. thats funny considering ive only been on this server for exactly 1 year and already have over 600 wins. Wasnt to hard for penis either.

if you're trying to insinuate that you and/or penis is better than fluffy?

please, don't make me laugh so hard. my internal organs are beginning to rupture.

ZERO
12-21-2011, 10:24 PM
Logs being read in now, it will take a day or 2 before it finishes. :wtg:

Penis シ
12-22-2011, 03:13 AM
:( Brett.

brett friggin favre
12-22-2011, 03:36 AM
:( Brett.

nothin against you penis. i just find rellik to be a dick and fluffy is more of a god than this guy.
http://www.the-atheist.com/wp-content/themes/NewTA/God.png

which is a lot

Nemesis
12-22-2011, 08:35 AM
So, so much for us keeping our wins?

ZERO
12-22-2011, 09:17 AM
? you are keeping your wins. There is one stats for all time to this November and then a record that is currently importing for this entire year.

We will then have a record for each year. Every year will be accessible for records.

Nemesis
12-22-2011, 11:44 AM
ah, so its just waiting for all that to get set up now, right?

Rellikdloc
12-22-2011, 09:23 PM
its ok penis. brett is on the gay side just a tad bit, hes still flaming on and on about me. guess he just cant get me off his mind.

ZERO
12-23-2011, 12:55 PM
Apparently the old version of ps is so crap that it can not do such a large import in 1 go. So I got to break it up one month at a time. I am now re uploading the logs and will import 1 month at a time. Expect to get this year's results by year end. I will then logically create a new database for 2012 which will import in real time. :wtg:

ZERO
12-26-2011, 05:24 PM
March data is now being imported. :wtg:

Penis シ
01-23-2012, 12:13 PM
are the /gg_stats2011 extensions available yet, or soon?

ZERO
01-23-2012, 04:45 PM
Now importing November then just 1 month to go! :wtg:

ZERO
01-25-2012, 01:00 PM
Importing December! Once this is done I will try tommorow to get this years stats started. If not we will need to wait until after next week.

ZERO
01-25-2012, 10:39 PM
The old stats are now updated. I realise that decay was in place which is why the rankings are mesed up however all your stats are still there.

Now lets move on to the future that involves stats that are not fucked up. First there obviously will not be decay. Also here is a list of commands I can track and who can get points for them:
gg_win = winner (can track who they won from)
gg_levelup = player who leveled up
gg_team_lose = player on losing team
gg_team_win = player on wining team
gg_leveldown = player leveled down
gg_knife_steal = player stole a level from another player (can track who lost a level from this)
gg_last_level = player is on last level
gg_leader = current leader
gg_knife_level = player is on knife level

What I suggest for the new system is that players start with a base skill of zero and just get points for particular actions with the following formula:

gg_levelup +5
gg_leveldown -5
gg_leader +1
gg_last_level +1
gg_knife_steal +10 (-5 if you lost a level from this)
gg_team_win +2
gg_team_lose -2
gg_win = 5000 (-2500 if someone won by killing you)

This implies the following difficulty logic winning once is 1000 times as hard as leveling up. Winning is 500 times harder than stealing a level. Winning is 2500 times harder than being on the wining team. Winning is 5000 times harder than being the game leader. Winning is 5000 times harder than getting to the last level. The parts in () may not be possible but regardless I think this will create a system where players with more wins are ranked high and then players with similar numbers of wins or the same number of win are ranked over each other based on the other data.

What do you all think?

---------- Post added at 10:39 PM ---------- Previous post was at 10:30 PM ----------

To show also that using the stats like that is easy to verify:


Levels Gained:
45,975



Levels Given:
32,199


Levels Stolen:
2,224



Levels Lost:
683


Wins:
83



(83*5000)= 415000
(5*45,975)= 229875
(10*2,224)= 22240
(-5*683)= -3415
=663,700 score

Note this does not include the points from being a leader or on last level or winning/losing team.

Rosie
01-26-2012, 10:38 AM
That looks like a great formula. It also gives everyone an idea of what they need to gain rank.

acolyte_to_jippity
02-03-2012, 11:54 AM
I have played this game and i have almost completed it 80 percent of the game so it is amazing.When i was a beginner in this game i was also think about this game but yet i have finished it.

this might just be sig-worthy

bigcraig77
02-03-2012, 04:59 PM
it hurts me to read it.

Nemesis
02-03-2012, 10:49 PM
I would take out the team win. GG is individual and teamwork shouldn't be brought in. especially when you can me leading the game but your team is still losing, not really your fault or concern.

And what about making it rank sensitive? so ppl who play against a bunch of nobodies dont gain as much as people who constantly play against the top 100?

And also, all my winds haven't been added back, had 700 now only about 150....

Xerenix
02-04-2012, 07:37 PM
And also, all my wins haven't been added back, had 700 now only about 150....

Same for me. I had atleast 1,100 but now only around 300.

Spasm
06-04-2012, 02:35 AM
Any update on whats going on with the gungame ranks?

Nemesis
06-04-2012, 11:28 PM
Any update on whats going on with the gungame ranks?

not yet! all the things that aren't broken need to be fixed first!

ZERO
06-07-2012, 01:46 PM
I have tried for a long time now to get a programer to update the new version of ps for gg but at this point I need to just mass import the last few months of logs in and go to the old version. I will have it done by next week.

ZERO
06-08-2012, 11:09 PM
I have transfered the last few months of logs to my local system so that they can be uploaded to the web server for faster importing. I expect to have stats restored sometime next week. :wtg:

ZERO
06-15-2012, 11:14 AM
I am currently clearing out the old 2011 import data from the web server to make space for the 2012 log uploads for the mass import. This will take some time and then a few days worth of data uploading.

I have finished downlaoding all the logs to and backuping them up on my local system as of right now.

ZERO
06-30-2012, 04:11 PM
OK I am finshing Jan2012 right now I will then confirm the stats are good and update the rest of the year. I have also created a method to make this faster in the future so there will be no issue for 2013.

ZERO
06-30-2012, 09:46 PM
I can not get the ranks to actually update. It will record all the player data but it will not rank anyone... :banghead:

ZERO
07-01-2012, 12:53 AM
Great news everyone I finally got gungame stats to work with a new version of ps. I will now proceed with the haxoring needed to make it like how it was in the past and incorporate all the stuff we want!

This also means due to the database size that we can have perma stats again for gg. In fact I may even mass import the old stats.

I can go back to 2010 or would you all rather have the stats start now?

XX0wnsXY
07-01-2012, 01:04 AM
Great news everyone I finally got gungame stats to work with a new version of ps. I will now proceed with the haxoring needed to make it like how it was in the past and incorporate all the stuff we want!

This also means due to the database size that we can have perma stats again for gg. In fact I may even mass import the old stats.

I can go back to 2010 or would you all rather have the stats start now?

I think starting now would be a good idea. Granted, my stats back then were better, it's always nice to have a fresh start.

maynard
07-01-2012, 02:46 AM
am I gonna lose my wins?

Carmichal
07-01-2012, 02:51 AM
start the stats now please.

ZERO
07-01-2012, 03:09 AM
Ok I got a test version to run correctly!

Now I will make another version to run starting from scratch with the correct data!