Since the server is moving / has moved to MySQL, and it's an easy database to work with, I figure some small amount of polling would show some interesting statistics here on the SZR site. I'm a sysadmin by trade, so making some headway into these wouldn't be a problem for me if you think they're a good idea:
Average/Max # of users online (24 hrs, 7 days, whatever)
Average/Max level/money/whatever
Biggest gang, or stats on all gangs
Most popular profession (by avg. level)
Players currently online (I know it's in SA-MP but still)
Most arrests
Longest playtime / age
And the like. I'm fairly sure the SQL calls would be lightweight, and we can generate stats every hour (or more/less often to taste) to further reduce load. After the eventual move to MTA, it shouldn't take much effort to tweak the queries, provided we know what data we want, and how we want it presented.
Site Enhancements (MySQL)
Moderators: Forum Moderators, Server Moderators
Forum rules
Suggestions is a moderated OOC forum.
Inflammatory bullshit, thread de-railing, or anything other than suggestions or constructive criticism may result in punitive action.
Suggestions is a moderated OOC forum.
Inflammatory bullshit, thread de-railing, or anything other than suggestions or constructive criticism may result in punitive action.
-
- Posts: 3.0
- Joined: November 29th, 2010, 3:27 pm
- Game Name(s): Fresh_McFeesh
Site Enhancements (MySQL)
Jeremy "Fresh" McFeesh -- SAPD Cadet
Re: Site Enhancements (MySQL)
Revealing who's the most richest, the biggest gang and so on is just dumb.
The size of one gang may not compare to the dedication of another.
I highly doubt that Rachael would hire you.
Also, I kinda doubt that you even know how to make all of this.
Making a simple function to see who's the richest in PHP isn't that hard, on the other hand...
Making a full scale user-system, for players and admins, that's a pretty big job, you'd have to get a decent design to code it in and of course code the design, then you'd have to code the whole user-system which again, with the amount of functions SZR has(I'm referring to the new gamemode, as the current gamemode has numerous functions the new one will most likely be way more complicated) You wouldn't be done in a heartbeat.
>> I wrote this while under the influence of stress and tiredness, I have a pretty good understanding of HTML, CSS and PHP, so I know what I'm talking about.
The size of one gang may not compare to the dedication of another.
I highly doubt that Rachael would hire you.
Also, I kinda doubt that you even know how to make all of this.
Making a simple function to see who's the richest in PHP isn't that hard, on the other hand...
Making a full scale user-system, for players and admins, that's a pretty big job, you'd have to get a decent design to code it in and of course code the design, then you'd have to code the whole user-system which again, with the amount of functions SZR has(I'm referring to the new gamemode, as the current gamemode has numerous functions the new one will most likely be way more complicated) You wouldn't be done in a heartbeat.
>> I wrote this while under the influence of stress and tiredness, I have a pretty good understanding of HTML, CSS and PHP, so I know what I'm talking about.
Terrence McDonut - Junior Agent
Mojima Jeffersuni - I help dudes
¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
-
- Posts: 838.0
- Joined: September 29th, 2009, 4:03 am
Re: Site Enhancements (MySQL)
backseat admin
-
- Posts: 3.0
- Joined: November 29th, 2010, 3:27 pm
- Game Name(s): Fresh_McFeesh
Re: Site Enhancements (MySQL)
Sorry if I was misunderstood -- I'm not looking to be 'hired' or push in on Rachel's job, I just figured it'd be cool to see some statistics on the site.
As for the difficulty of coding that all in PHP/perl, it's just a matter of getting the right queries and presenting the data -- a few joins and nothing more, there's no architectural user framework or anything of the type. It wouldn't be interactive, just a statistics page or the like that would refresh with a cron job.
Just a suggestion and an offer to help if it were something the site would be interested in having, that's all.
As for the difficulty of coding that all in PHP/perl, it's just a matter of getting the right queries and presenting the data -- a few joins and nothing more, there's no architectural user framework or anything of the type. It wouldn't be interactive, just a statistics page or the like that would refresh with a cron job.
Just a suggestion and an offer to help if it were something the site would be interested in having, that's all.
Jeremy "Fresh" McFeesh -- SAPD Cadet