Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 380501" data-attributes="member: 36373">Hey Devbest,I am here to release a nice top stat page its going to be dynamic and simple <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /> Doesn't take up much space at all. Everything is manageable via the database.First Add the table to the database:[CODE]DROP TABLE IF EXISTS `cms_topstats`;CREATE TABLE `cms_topstats` (&nbsp; `stat` varchar(120) NOT NULL,&nbsp; `limit` int(11) NOT NULL,&nbsp; `table` varchar(80) NOT NULL,&nbsp; `display` varchar(120) NOT NULL,&nbsp; `order` varchar(5) NOT NULL DEFAULT '' COMMENT 'ASC or DESC',&nbsp; `after` varchar(50) NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;[/CODE]Next put the code in the stats page:[CODE]&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; function GetTimeDiff($time)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $d = floor($time/86400);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_d = ($d &lt; 10 ? '' : '').$d;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $h = floor(($time-$d*86400)/3600);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $_h = ($h &lt; 10 ? '' : '').$h;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $time_str = $_d . ' days ' . $_h . ' hours';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return $time_str;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getTopStats = mysql_query(&quot;SELECT * FROM `cms_TopStats`&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($currentStat = mysql_fetch_assoc($getTopStats)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;c-box&quot; style=&quot;width:220px;display:inline-block;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;c-title red&quot; style=&quot;width:220px;display:inline-block;&quot;&gt;&lt;?php echo $currentStat['display']; ?&gt;&lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;c-main&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($currentStat['table'] == &quot;users&quot;){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserStats = mysql_query(&quot;SELECT * FROM &quot;.$currentStat['table'].&quot; WHERE rank &lt; 3 ORDER BY &quot;.$currentStat['stat'].&quot; &quot;.$currentStat['order'].&quot; LIMIT &quot;.$currentStat['limit'].&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }else{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getUserStats = mysql_query(&quot;SELECT * FROM &quot;.$currentStat['table'].&quot; ORDER BY &quot;.$currentStat['stat'].&quot; &quot;.$currentStat['order'].&quot; LIMIT &quot;.$currentStat['limit'].&quot;&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($currentWinner = mysql_fetch_assoc($getUserStats)){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $userStats = mysql_fetch_assoc(mysql_query(&quot;SELECT `look`,`username` FROM users WHERE id = '&quot;.$currentWinner['id'].&quot;'&quot;));&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;float:left;display:inline-block;&quot; src=&quot;http://www.habbo.com/habbo-imaging/avatarimage?figure=&lt;?php echo $userStats['look']; ?&gt;&amp;direction=2&amp;head_direction=3&amp;size=s&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p style=&quot;overflow:none;&quot;&gt;&lt;span style=&quot;color:blue;&quot;&gt;&lt;?php echo $userStats['username'];?&gt; ~ &lt;/span&gt;&lt;span style=&quot;color:red;&quot;&gt;&lt;?php $value = $currentStat['stat'];if($currentStat['stat'] != &quot;OnlineTime&quot;){echo $currentWinner[$value];}else{echo GetTimeDiff($currentWinner[$value]);}echo $currentStat['after'];?&gt;&lt;/span&gt;&lt;/p&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/div&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;[/CODE]How it works:Just add the stat into the database as follows;Stat Name = The name of the column in the database (Credits/Activity_points/RoomVisits)Limit = The number of records you would like to display (5/8/10)Table = The name of the table the column is in (Users/user_stats)Display = Text on the div box (Credits, Duckets, Online Time, Room Visits)Order = ASC/DESC&nbsp; (Ascending or Descending)After = Text after the output example: 500c&nbsp; 8 giftsDefaults I made for you:[CODE]INSERT INTO `cms_topstats` VALUES ('credits', '5', 'users', 'Credits', 'DESC', 'c');INSERT INTO `cms_topstats` VALUES ('vip_points', '5', 'users', 'Diamonds', 'DESC', ' Diamonds');INSERT INTO `cms_topstats` VALUES ('activity_points', '5', 'users', 'Duckets', 'DESC', ' Duckets');INSERT INTO `cms_topstats` VALUES ('OnlineTime', '5', 'user_stats', 'Online Time', 'DESC', '');INSERT INTO `cms_topstats` VALUES ('RoomVisits', '5', 'user_stats', 'Room Visits', 'DESC', ' Visits');INSERT INTO `cms_topstats` VALUES ('Respect', '5', 'user_stats', 'Respects Recieved', 'DESC', ' Respects');INSERT INTO `cms_topstats` VALUES ('RespectGiven', '5', 'user_stats', 'Respects Given', 'DESC', ' Respects');INSERT INTO `cms_topstats` VALUES ('GiftsGiven', '5', 'user_stats', 'Gifts Given', 'DESC', ' Gifts');[/CODE]You can just add more if you would like, or change the ones already there. TIP: Change the &lt;div class=&quot;c-box&quot;&gt; and other div's to match your revcms edit, otherwise it will not display correctly.Notice: This is a basic top stats, it just shows a small image of them with their username and then the stat. There is nothing special on the front end <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /> Feel free to edit that, and maybe re-release in the comments a nice front end and I will put it in the thread !Thanks,- JayCustom</blockquote>

[QUOTE="JayC, post: 380501, member: 36373"] Hey Devbest, I am here to release a nice top stat page its going to be dynamic and simple :) Doesn't take up much space at all. Everything is manageable via the database. First Add the table to the database: [CODE]DROP TABLE IF EXISTS `cms_topstats`; CREATE TABLE `cms_topstats` ( `stat` varchar(120) NOT NULL, `limit` int(11) NOT NULL, `table` varchar(80) NOT NULL, `display` varchar(120) NOT NULL, `order` varchar(5) NOT NULL DEFAULT '' COMMENT 'ASC or DESC', `after` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;[/CODE] Next put the code in the stats page: [CODE]<?php function GetTimeDiff($time) { $d = floor($time/86400); $_d = ($d < 10 ? '' : '').$d; $h = floor(($time-$d*86400)/3600); $_h = ($h < 10 ? '' : '').$h; $time_str = $_d . ' days ' . $_h . ' hours'; return $time_str; } $getTopStats = mysql_query("SELECT * FROM `cms_TopStats`"); while($currentStat = mysql_fetch_assoc($getTopStats)){ ?> <div class="c-box" style="width:220px;display:inline-block;"> <div class="c-title red" style="width:220px;display:inline-block;"><?php echo $currentStat['display']; ?></div> <div class="c-main"> <?php if($currentStat['table'] == "users"){ $getUserStats = mysql_query("SELECT * FROM ".$currentStat['table']." WHERE rank < 3 ORDER BY ".$currentStat['stat']." ".$currentStat['order']." LIMIT ".$currentStat['limit'].""); }else{ $getUserStats = mysql_query("SELECT * FROM ".$currentStat['table']." ORDER BY ".$currentStat['stat']." ".$currentStat['order']." LIMIT ".$currentStat['limit'].""); } while($currentWinner = mysql_fetch_assoc($getUserStats)){ $userStats = mysql_fetch_assoc(mysql_query("SELECT `look`,`username` FROM users WHERE id = '".$currentWinner['id']."'")); ?> <img style="float:left;display:inline-block;" src="http://www.habbo.com/habbo-imaging/avatarimage?figure=<?php echo $userStats['look']; ?>&direction=2&head_direction=3&size=s"> <?php echo $userStats['username'];?> ~ <?php $value = $currentStat['stat'];if($currentStat['stat'] != "OnlineTime"){echo $currentWinner[$value];}else{echo GetTimeDiff($currentWinner[$value]);}echo $currentStat['after'];?> <?php } ?> </div> </div> <?php } ?>[/CODE] How it works: Just add the stat into the database as follows; Stat Name = The name of the column in the database (Credits/Activity_points/RoomVisits) Limit = The number of records you would like to display (5/8/10) Table = The name of the table the column is in (Users/user_stats) Display = Text on the div box (Credits, Duckets, Online Time, Room Visits) Order = ASC/DESC (Ascending or Descending) After = Text after the output example: 500[B]c[/B] 8 [B]gifts[/B] Defaults I made for you: [CODE] INSERT INTO `cms_topstats` VALUES ('credits', '5', 'users', 'Credits', 'DESC', 'c'); INSERT INTO `cms_topstats` VALUES ('vip_points', '5', 'users', 'Diamonds', 'DESC', ' Diamonds'); INSERT INTO `cms_topstats` VALUES ('activity_points', '5', 'users', 'Duckets', 'DESC', ' Duckets'); INSERT INTO `cms_topstats` VALUES ('OnlineTime', '5', 'user_stats', 'Online Time', 'DESC', ''); INSERT INTO `cms_topstats` VALUES ('RoomVisits', '5', 'user_stats', 'Room Visits', 'DESC', ' Visits'); INSERT INTO `cms_topstats` VALUES ('Respect', '5', 'user_stats', 'Respects Recieved', 'DESC', ' Respects'); INSERT INTO `cms_topstats` VALUES ('RespectGiven', '5', 'user_stats', 'Respects Given', 'DESC', ' Respects'); INSERT INTO `cms_topstats` VALUES ('GiftsGiven', '5', 'user_stats', 'Gifts Given', 'DESC', ' Gifts'); [/CODE] You can just add more if you would like, or change the ones already there. TIP: Change the <div class="c-box"> and other div's to match your revcms edit, otherwise it will not display correctly. Notice: This is a basic top stats, it just shows a small image of them with their username and then the stat. There is nothing special on the front end :) Feel free to edit that, and maybe re-release in the comments a nice front end and I will put it in the thread ! Thanks, - JayCustom [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members