Reply to thread

Message

<blockquote data-quote="zMagenta" data-source="post: 212729" data-attributes="member: 4512">Hi there!&nbsp;As you may know, I owned my hotels with a good online users page. It shows the users, changing their username colour depending on their rank, and then also, for rank x+ (x = whatever you choose it to be), it will show the IP Registered and IP Last used - so it's easy to identify what users are multi accounting.&nbsp;This is the page, sorry, I can't put this online therefore I cannot show you the username feature.&nbsp;&nbsp;&nbsp;All you need to do is run these SQL queries.[CODE]DROP TABLE IF EXISTS `site_user_color`;CREATE TABLE `site_user_color` (&nbsp; `id` int(11) NOT NULL AUTO_INCREMENT,&nbsp; `rankid` int(11) NOT NULL,&nbsp; `color` varchar(6) DEFAULT NULL,&nbsp; `is_bold` enum('0','1') DEFAULT NULL,&nbsp; PRIMARY KEY (`id`)) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;&nbsp;-- ------------------------------ Records of site_user_color-- ----------------------------INSERT INTO `site_user_color` VALUES ('1', '1', '000000', '0');INSERT INTO `site_user_color` VALUES ('2', '2', 'F6D8CE', '1');INSERT INTO `site_user_color` VALUES ('3', '3', '3971A8', '1');INSERT INTO `site_user_color` VALUES ('4', '4', 'B404AE', '1');INSERT INTO `site_user_color` VALUES ('5', '5', '40FF00', '1');INSERT INTO `site_user_color` VALUES ('6', '6', 'B40431', '1');INSERT INTO `site_user_color` VALUES ('7', '7', 'B40431', '1');INSERT INTO `site_user_color` VALUES ('8', '8', '0404B4', '1');INSERT INTO `site_user_color` VALUES ('9', '9', '3B240B', '1');INSERT INTO `site_user_color` VALUES ('10', '10', 'FF0000', '1');INSERT INTO `site_user_color` VALUES ('11', '11', '000000', '1');INSERT INTO `site_user_color` VALUES ('12', '12', '0404B4', '1');INSERT INTO `site_user_color` VALUES ('13', '13', '000000', '0');[/CODE]&nbsp;Then, just add this PHP into any page.&nbsp;[PHP]&lt;div id=&quot;container&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;content&quot;&gt;&nbsp; &nbsp; &lt;div id=&quot;column2&quot; class=&quot;column&quot;&gt;&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;box-content1&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;h2 class=&quot;title&quot;&gt;What is this page?&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/h2&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div style=&quot;padding:5px&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;p&gt;This page shows all of the online users; with a colour code next to their name. Below are what the colour means;&lt;br&gt;&lt;/br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Normal User - &lt;font color=&quot;#000000&quot;&gt;This colour&lt;/font&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Low VIP - &lt;font color=&quot;#F6D8CE&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; High VIP - &lt;font color=&quot;#3971A8&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Legend VIP - &lt;font color=&quot;#B404AE&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; eXpert - &lt;font color=&quot;#40FF00&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Moderator - &lt;font color=&quot;#B40431&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Manager - &lt;font color=&quot;#0404B4&quot;&gt;&lt;b&gt;This colour&lt;/font&gt;&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Owner - &lt;b&gt;This colour&lt;/b&gt;&lt;br&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&nbsp;&nbsp;&lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;column1&quot; class=&quot;column&quot;&gt;&nbsp;&nbsp;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix red &quot;&gt;&nbsp;&nbsp;&lt;h2 class=&quot;title&quot;&gt;All Online Users&lt;/h2&gt;&lt;div style=&quot;padding:5px;&quot;&gt;&nbsp;Average users: {average}&lt;br /&gt;{online} user(s) online!, the users are;&lt;br /&gt;&lt;?php$queryUserList = mysql_query(&quot;SELECT * FROM users WHERE online = '1' ORDER BY id ASC&quot;);&nbsp;$allowedRank = '7';$queryRank = mysql_query(&quot;SELECT rank FROM users WHERE id = '&quot;.$_SESSION['user']['id'].&quot;'&quot;);$currentRank = mysql_result($queryRank, 0);?&gt;&nbsp;&lt;table &lt;?php if($currentRank &gt;= $allowedRank){ echo &quot;border=\&quot;1\&quot;&quot;; }?&gt;&gt;&nbsp;&lt;?phpwhile($row = mysql_fetch_array($queryUserList)){&nbsp; &nbsp; echo &quot;&lt;tr&gt;&quot;;&nbsp;&nbsp; &nbsp; $queryColor = mysql_query(&quot;SELECT color,is_bold FROM site_user_color WHERE rankid = '&quot;.$row['rank'].&quot;'&quot;);&nbsp; &nbsp; while($rowRank = mysql_fetch_array($queryColor))&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; if ($rowRank['is_bold'] == 1)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $isBold = &quot;font-weight: bold;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; else&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $isBold= &quot;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td&gt;&lt;font style=\&quot;color:#&quot;.$rowRank['color'].&quot;; &quot;.$isBold.&quot;\&quot;&gt;&quot;. $row['username'] . &quot;&lt;/font&gt;&lt;/td&gt;&quot;;&nbsp; &nbsp; }&nbsp; &nbsp; if ($currentRank &gt;= $allowedRank)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td&gt;&lt;b&gt;IP Last:&lt;/b&gt; &quot; . $row['ip_last'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;td&gt;&lt;b&gt;IP on registration:&lt;/b&gt; &quot; . $row['ip_reg'] . &quot;&lt;/td&gt;&quot;;&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; echo &quot;&lt;/tr&gt;&quot;;}?&gt;&lt;/table&gt;[/PHP]&nbsp;Also, quick note, [PHP]$allowedRank = '7';[/PHP] 7 = the rank+ that an see the IP's, enjoy!&nbsp;(Thanks <a href="http://devbest.com/members/sherlock.9520/" target="_blank">Sherlock</a> for helping out with this)</blockquote>

[QUOTE="zMagenta, post: 212729, member: 4512"] Hi there! As you may know, I owned my hotels with a good online users page. It shows the users, changing their username colour depending on their rank, and then also, for rank x+ (x = whatever you choose it to be), it will show the IP Registered and IP Last used - so it's easy to identify what users are multi accounting. This is the page, sorry, I can't put this online therefore I cannot show you the username feature. All you need to do is run these SQL queries. [CODE]DROP TABLE IF EXISTS `site_user_color`; CREATE TABLE `site_user_color` ( `id` int(11) NOT NULL AUTO_INCREMENT, `rankid` int(11) NOT NULL, `color` varchar(6) DEFAULT NULL, `is_bold` enum('0','1') DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of site_user_color -- ---------------------------- INSERT INTO `site_user_color` VALUES ('1', '1', '000000', '0'); INSERT INTO `site_user_color` VALUES ('2', '2', 'F6D8CE', '1'); INSERT INTO `site_user_color` VALUES ('3', '3', '3971A8', '1'); INSERT INTO `site_user_color` VALUES ('4', '4', 'B404AE', '1'); INSERT INTO `site_user_color` VALUES ('5', '5', '40FF00', '1'); INSERT INTO `site_user_color` VALUES ('6', '6', 'B40431', '1'); INSERT INTO `site_user_color` VALUES ('7', '7', 'B40431', '1'); INSERT INTO `site_user_color` VALUES ('8', '8', '0404B4', '1'); INSERT INTO `site_user_color` VALUES ('9', '9', '3B240B', '1'); INSERT INTO `site_user_color` VALUES ('10', '10', 'FF0000', '1'); INSERT INTO `site_user_color` VALUES ('11', '11', '000000', '1'); INSERT INTO `site_user_color` VALUES ('12', '12', '0404B4', '1'); INSERT INTO `site_user_color` VALUES ('13', '13', '000000', '0'); [/CODE] Then, just add this PHP into any page. [PHP]<div id="container"> <div id="content"> <div id="column2" class="column"> <div class="habblet-container "> <div class="box-content1"> <div class="cbb clearfix blue "> <h2 class="title">What is this page? </h2> <div style="padding:5px"> This page shows all of the online users; with a colour code next to their name. Below are what the colour means; Normal User - This colour Low VIP - This colour High VIP - This colour Legend VIP - This colour eXpert - This colour Moderator - This colour Manager - This colour Owner - This colour </div></div></div></div> </div> <div id="column1" class="column"> <div class="habblet-container "> <div class="cbb clearfix red "> <h2 class="title">All Online Users</h2> <div style="padding:5px;"> Average users: {average} {online} user(s) online!, the users are; <?php $queryUserList = mysql_query("SELECT * FROM users WHERE online = '1' ORDER BY id ASC"); $allowedRank = '7'; $queryRank = mysql_query("SELECT rank FROM users WHERE id = '".$_SESSION['user']['id']."'"); $currentRank = mysql_result($queryRank, 0); ?> <table <?php if($currentRank >= $allowedRank){ echo "border=\"1\""; }?>> <?php while($row = mysql_fetch_array($queryUserList)) { echo "<tr>"; $queryColor = mysql_query("SELECT color,is_bold FROM site_user_color WHERE rankid = '".$row['rank']."'"); while($rowRank = mysql_fetch_array($queryColor)) { if ($rowRank['is_bold'] == 1) { $isBold = "font-weight: bold;"; } else { $isBold= ""; } echo "<td>". $row['username'] . "</td>"; } if ($currentRank >= $allowedRank) { echo "<td>IP Last: " . $row['ip_last'] . "</td>"; echo "<td>IP on registration: " . $row['ip_reg'] . "</td>"; } echo "</tr>"; } ?> </table>[/PHP] Also, quick note, [PHP]$allowedRank = '7';[/PHP] 7 = the rank+ that an see the IP's, enjoy! (Thanks [URL='http://devbest.com/members/sherlock.9520/']Sherlock[/URL] for helping out with this) [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members