Marked 197 Report post Posted January 30, 2010 Hi all, I was thinking about creating a Hall of Fame component. Actually now that I think about it, Hall of Fame probably isn't a fitting name. This component is a page of global forum statistics. It will be written in a similar way to the User Stats component, but I'll probably use 2 columns for stats. I hope you guys don't mind the forum-type components on the website. It may look a bit odd since they look completely different. One day hopefully they will look identical. So what I need from you guys is statistic ideas. What do you want to see? The obvious ones are top posters, most topics, most points, etc. Remember they can be from anything around the forum, including downloads, gallery etc. Share this post Link to post Share on other sites
FranklinX 37 Report post Posted January 30, 2010 How about Hall of Fame Members and Staff? Share this post Link to post Share on other sites
Chief 30 Report post Posted January 30, 2010 how bout a section dedicated to my and my complete pwn-ness? Share this post Link to post Share on other sites
Marked 197 Report post Posted January 30, 2010 How about Hall of Fame Members and Staff? I don't quite get what you mean. The page will just contain statistics made from lists. For example: Top 5 Posters. Top 5 most view topics. Stuff like that. It can even be something like most topics started in the contest forum, so it would be called "Most Contests Started" then a list of the top x topic starts in the contest forum. how bout a section dedicated to my and my complete pwn-ness? Sigh. Share this post Link to post Share on other sites
evil cabbage 9 Report post Posted January 30, 2010 Normal Ideas: -Top 5 Most Popular Games -Top 5 Longest Games -Top 5 Most Downloaded Files -Top 5 Members with the most profile views -Top 5 PM Inbox Size -First 5 Members -The Top 5 Active Members (that is, those who are on the site the most, regardless of their post count or points.) Wacky Ideas: -Top 5 Closest to being banned -Top 5 Necroposters (the five who have made the most necroposts) Share this post Link to post Share on other sites
Polraudio 122 Report post Posted January 30, 2010 Some nice ideas. Top 5 Uploaders/Downloaders for gallery and downloads(Who downloaded and uploaded the most) Top 5 Rep(Who has most rep) Top 5 topic viewers (How many topics member viewed) Top 5 Poll makers(Who made the most polls) Top 5 Voters(Who made the most total votes) Top 5 commenters(Who made the most comments on profiles. Maybe do same for blogs) Share this post Link to post Share on other sites
Marked 197 Report post Posted January 30, 2010 Normal Ideas: -Top 5 Most Popular Games -Top 5 Longest Games -Top 5 Most Downloaded Files -Top 5 Members with the most profile views -Top 5 PM Inbox Size -First 5 Members -The Top 5 Active Members (that is, those who are on the site the most, regardless of their post count or points.) Wacky Ideas: -Top 5 Closest to being banned -Top 5 Necroposters (the five who have made the most necroposts) Most of these are nice ideas. Although things like longest games and closest to being banned are impossible to do. I don't know if you will understand this or not, but all statistics are drawn from our forums database using SQL queries, so no one even knows what any of these stats will be until we query the database for them. Top Necroposters I think I can do, quite a complicated query i would imagine, although I think I will leave them out. Reason being that they are likely to be random members who on one knows. I like the rest though, very good. @pol: All good ideas, will include them :alright: Share this post Link to post Share on other sites
evil cabbage 9 Report post Posted January 30, 2010 Oh, okay, sorry. Share this post Link to post Share on other sites
Marked 197 Report post Posted January 30, 2010 Why? No no, thank you for your suggestions, I am going to include them. Share this post Link to post Share on other sites
miguel1 17 Report post Posted January 30, 2010 here are some examples: Top 5 Point Per Post ( who has more points per post) Top 5 rep givers ( who has given more rep to other members) Top 5 friends collecter ( who has more friends in the profile) Top 5 profile ratings Top 5 trend starters Top 5 spammers ( who spams a lot) Top 5 forums ( the forums with more posts) Top 5 avatars ( members with origional/cool avatars) hope this is useful :rolleyes: Share this post Link to post Share on other sites
erosthanatos 7 Report post Posted January 30, 2010 Top 5 avatars ( members with origional/cool avatars) Only because you would win :) <<<<<<< Top 5 Coolest New People Share this post Link to post Share on other sites
miguel1 17 Report post Posted January 30, 2010 Only because you would win :) <<<<<<< Top 5 Coolest New People :biggrin_002: Let's face it, eric cartman is the coolest avatar ever! :jay: Share this post Link to post Share on other sites
Marked 197 Report post Posted February 2, 2010 Very helpful indeed, thank you miguel. Each of your suggestions will be included except avatars and trend starters. Reason being is that no information of these are stored in the database, and obviously someone would have to choose the avatars by their own preference. You see all the stats come from information from the database and as a result the stats change by themselves once the code is written. Ok I finally started work on this. I had to keep myself awake so early in the morning... LINK Alright I've only done the hard part so far, the styling. It's a pain. Complete forum styled tables. I have it set to top 50 at the moment, just for demo purposes. The code is written so you alter the one variable(top x stats) and then the title, ranks and table cell styling(white,blue,white,blue etc.) is done automatically. So I decided that when I learn how to, I am going to have a drop-down box where you can choose how many stats to display. The default will probably remain at 5, and a max of 100. I will continue adding stats over the next couple of days. It takes a very long time to write all the sql, so it will take me a while. And you guys know how i like to pace myself :) Share this post Link to post Share on other sites
Polraudio 122 Report post Posted February 2, 2010 Looking good so far. Share this post Link to post Share on other sites
Broken Messiah 20 Report post Posted February 3, 2010 Sweet! Im actually on there! oh and a good idea would to include the top resource suppliers, and tool makers, along with sccripts. those ppl worked really hard and our website wouldnt be much competition with HBGames or RRR Share this post Link to post Share on other sites
Marked 197 Report post Posted February 3, 2010 Glad you like it ^_^ Yep I'll add those. The trouble is which section to get the top authors from. For example, the scripts in the downloads manager, or scripts archive. The tools and utilities from the page on the website, or download manager. And the other thing is, this page is going to be HUGE. But we'll see how it goes. I'm thinking at the moment of having 3 columns instead of 2 to decrease size. Share this post Link to post Share on other sites
Marked 197 Report post Posted February 5, 2010 I need some advice from you guys... http://www.rmxpunlimited.net/index.php/stats.html There are examples of 2 columns, or 3. Which do you like the best? I really can't decide. Share this post Link to post Share on other sites
Leon 55 Report post Posted February 5, 2010 Go with 3 columns. Share this post Link to post Share on other sites
Polraudio 122 Report post Posted February 5, 2010 Yea 3 looks way better. Looks more clean and organized. Share this post Link to post Share on other sites
miguel1 17 Report post Posted February 5, 2010 I like it with 2 columms. Share this post Link to post Share on other sites
FranklinX 37 Report post Posted February 5, 2010 I don't quite get what you mean. The page will just contain statistics made from lists. For example: Top 5 Posters. Top 5 most view topics. Stuff like that. It can even be something like most topics started in the contest forum, so it would be called "Most Contests Started" then a list of the top x topic starts in the contest forum. Sigh. What I mean is have a hall of fame section for the most active members and best staff members. Share this post Link to post Share on other sites
Marked 197 Report post Posted February 5, 2010 Thanks guys, 3 columns it is. @RKO: Ah I see. Well I am definitely making this a member-orientated component. I have been working on it since I started this topic. The active members and staff will certainly get the most out of this component, so in a way this is for them. At the moment I am working on a 'members overall effectiveness' section. You get points for each rank, the higher you rank the higher the points. Add 'em all together and you get a nice number, which is a measure of your overall contribution to RMXPUnlimited. Share this post Link to post Share on other sites
Arkbennett 16 Report post Posted February 5, 2010 I like this idea, though it appears and am more unpopular than I thought. lol. ;) Share this post Link to post Share on other sites
Marked 197 Report post Posted February 6, 2010 Haha, perhaps your absence has been longer than you think. I haven't actually finished creating the stat modules, probably not even close. But this is actually the easiest thing to do because I'm working on the member features of the component. This is actually a reasonably complicated and smart code, utilizing a lot of the websites php framework. I have finished most of the member efficiency part of the component(i may add more). You guys should go on the page and check it out, I have written down how it works. The numbers are going to change as I add more stat modules in. The number is calculated literally from the code of each stat module, so every time a stat module appears, it adds to the member efficiency variable. It is difficult to calculate other members member efficiency value, but you can do it if you use a calculator and the formula i have provided on the page. Unless you are a smart and wrote the component, its hard. But I can tell you at the moment EmilyAnnCoons has a decent winning margin from the 11 modules on the page at the moment. Share this post Link to post Share on other sites
Arkbennett 16 Report post Posted February 6, 2010 Sounds like a bit of complex math involved. How annoying. lol. Well good luck with that, I'm not really sure of any suggestion I can put on the board. And as far as Emily goes: This should be remedied. Share this post Link to post Share on other sites
Kiriashi 117 Report post Posted February 6, 2010 Why is "Amazing" highlighted with green at the bottom? Share this post Link to post Share on other sites
Marked 197 Report post Posted February 7, 2010 Sounds like a bit of complex math involved. How annoying. lol. Well good luck with that, I'm not really sure of any suggestion I can put on the board. And as far as Emily goes: This should be remedied. Not too complicated. A complicated part in particular was getting the average posts per day because it's not actually stored in the database on its on, and the info used MUST come from the query. But once i figured out you could use math operations in queries i was able to do it, it looks like this(selection of the posts per day, just a snipped of the full query): (posts/(($now-joined + 1)/86400)) As for remedies, perhaps so. I hope that this will give some of our loyal members recognition for what they have contributed to RMXPUnlimited. Writing this component, even though it appears simple but the way it is done is not, has boosted my php and sql knowledge a ton. And I think I'm nearly ready to start writing components to submit scripts, projects, reviews to the website. And then I will have completed my goals here. Why is "Amazing" highlighted with green at the bottom? Ah, that is a work in progress. I cannot complete the part of the component because I need to know members final member efficiency value, and I cant do that until I have completed writing all of the stat modules. This system is basically like your reputation ranks. If you have 10+ reps you get the title 'Good', over 20 'Great' and so on. This is a similar system, but it will always be unofficial because of the inaccuracy of it. However, you will always have the title 'Amazing' because your member efficiency value is over the mark i have set(the mark being your average points per stat module where your rank is counted toward your member efficiency value). Your average is rather high, it clears the mark rather well, as well as 3 other members. The 4 of these members will always remain in the 'Amazing' ranks. The difference between the 4th highest and 5th highest is large, a big margin, so i have made the middle of that margin the cutoff point from where you go from 'Great' to 'Amazing'. I wanted to include all the titles, with your own highlighted. This way members can see where they are, and newbies can watch as they advance up the list. I hope that wasn't too complicated. I tried to keep this post short but ended up writing far too much again :sweatdrop: EDIT: I just changed the formula that calculates the member efficiency value. But don't worry Kiriashi, you will still qualify for 'Amazing'. The new formula is less bias towards #1 ranks. Due to using the square of the rank to calculate points, you got 20 points from rank 1 and 10 points from rank 2, so you needed very few #1's to get a high member efficiency value. I won't say how many points each rank gives you with the new formula, but the formula is much more fair now and the effects of the dominating members is smaller. Share this post Link to post Share on other sites