Reply to thread

Message

<blockquote data-quote="Cronus" data-source="post: 221610" data-attributes="member: 35689">Hey i wanna make my staff page like this:&nbsp;<img src="http://d.pr/i/p5k5.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />&nbsp;&nbsp;I want it on the right all I really need is the mysql code then I can do it &nbsp;&nbsp;and I also wanna have hidden ranks how do it is slecet ranks 5 thur 12...&nbsp;&nbsp;here ubercms staff code:&nbsp;[spoiler][CODE]&lt;?php&nbsp;function GetDescr($level){&nbsp; &nbsp; switch ($level)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 10:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Hotel Management &amp; Developers';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 9:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Habzon Management Team';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 8:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Senior Administrative Staff';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 7:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Administrative Staff';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 6:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Moderator Coordinators/Leaders';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 5:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'Moderation in training!';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; case 4:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return 'HabZon Event staff!';&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; default:&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return '';&nbsp; &nbsp; }}&nbsp;$getGroups = dbquery(&quot;SELECT id,name FROM ranks WHERE id &gt;= 4 ORDER BY id DESC&quot;);&nbsp;while ($group = mysql_fetch_assoc($getGroups)){&nbsp;&nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &lt;div class=&quot;cbb clearfix blue &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;&lt;span style=&quot;float: left;&quot;&gt;' . clean($group['name']) . 's&lt;/span&gt; &lt;span style=&quot;float: right; font-weight: normal; font-size: 75%;&quot;&gt;' . GetDescr($group['id']) . '&lt;/span&gt;&lt;/h2&gt;';&nbsp;&nbsp; &nbsp; &nbsp; $getMembers = dbquery(&quot;SELECT id,username,motto,look,online FROM users WHERE rank = '&quot; . $group['id'] . &quot;'&quot;);&nbsp;&nbsp; &nbsp; &nbsp; echo '&lt;div class=&quot;box-content&quot;&gt;';&nbsp;&nbsp; &nbsp; &nbsp; if (mysql_num_rows($getMembers) &gt; 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($member = mysql_fetch_assoc($getMembers))&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ($oe == 2)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $oe = 1;&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; &nbsp; $oe = 2;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;table width=&quot;107%&quot; style=&quot;padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;middle&quot; width=&quot;25&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img style=&quot;margin-top: -10px;&quot; src=&quot;%www%/includes/imager.php?figure=' . $member['look'] . '&amp;size=m&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;b style=&quot;font-size: 110%;&quot;&gt;&lt;a href=&quot;%www%/home/' . clean($member['username']) . '&quot;&gt;' . clean($member['username']) . '&lt;/a&gt;&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;i&gt;' . clean($member['motto']) . '&lt;/i&gt;&lt;br /&gt;&nbsp; &nbsp; &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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $getBadges = dbquery(&quot;SELECT * FROM user_badges WHERE user_id = '&quot; . $member['id'] . &quot;' AND badge_slot &gt;= 1 ORDER BY badge_slot DESC LIMIT 5&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($b = mysql_fetch_assoc($getBadges))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;img src=&quot;http://habzon.net/r63/c_images/album1584/' . $b['badge_id'] . '.gif&quot; style=&quot;float: left;&quot;&gt;&amp;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; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td valign=&quot;top&quot; style=&quot;float: right;&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ' . (($member['online'] == &quot;1&quot;) ? '&lt;b style=&quot;color: darkgreen;&quot;&gt;Online&lt;/b&gt;' : '&lt;b style=&quot;color: darkred;&quot;&gt;Offline&lt;/b&gt;') . '&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/tbody&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/table&gt;';&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; echo '&lt;i&gt;There are no users in this staff group yet.&lt;/i&gt;';&nbsp; &nbsp; }&nbsp;&nbsp; &nbsp; &nbsp; echo '&lt;/div&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }&lt;/script&gt; ';}&nbsp;?&gt;[/CODE][/spoiler]</blockquote>

[QUOTE="Cronus, post: 221610, member: 35689"] Hey i wanna make my staff page like this: [IMG]http://d.pr/i/p5k5.png[/IMG] I want it on the right all I really need is the mysql code then I can do it and I also wanna have hidden ranks how do it is slecet ranks 5 thur 12... here ubercms staff code: [spoiler] [CODE]<?php function GetDescr($level) { switch ($level) { case 10: return 'Hotel Management & Developers'; case 9: return 'Habzon Management Team'; case 8: return 'Senior Administrative Staff'; case 7: return 'Administrative Staff'; case 6: return 'Moderator Coordinators/Leaders'; case 5: return 'Moderation in training!'; case 4: return 'HabZon Event staff!'; default: return ''; } } $getGroups = dbquery("SELECT id,name FROM ranks WHERE id >= 4 ORDER BY id DESC"); while ($group = mysql_fetch_assoc($getGroups)) { echo '<div class="habblet-container "> <div class="cbb clearfix blue "> <h2 class="title">' . clean($group['name']) . 's ' . GetDescr($group['id']) . '</h2>'; $getMembers = dbquery("SELECT id,username,motto,look,online FROM users WHERE rank = '" . $group['id'] . "'"); echo '<div class="box-content">'; if (mysql_num_rows($getMembers) > 0) { $oe = 1; while ($member = mysql_fetch_assoc($getMembers)) { if ($oe == 2) { $oe = 1; } else { $oe = 2; } echo '<table width="107%" style="padding: 5px; margin-left: -15px; background-color: ' . (($oe == 2) ? '#fff' : '#E6E6E6') . ';"> <tbody> <tr> <td valign="middle" width="25"> <img style="margin-top: -10px;" src="%www%/includes/imager.php?figure=' . $member['look'] . '&size=m"> </td> <td valign="top"> <a href="%www%/home/' . clean($member['username']) . '">' . clean($member['username']) . '</a> ' . clean($member['motto']) . ' '; $getBadges = dbquery("SELECT * FROM user_badges WHERE user_id = '" . $member['id'] . "' AND badge_slot >= 1 ORDER BY badge_slot DESC LIMIT 5"); while ($b = mysql_fetch_assoc($getBadges)) { echo '<img src="http://habzon.net/r63/c_images/album1584/' . $b['badge_id'] . '.gif" style="float: left;"> '; } echo '</td> <td valign="top" style="float: right;"> ' . (($member['online'] == "1") ? 'Online' : 'Offline') . ' </td> </tr> </tbody> </table>'; } } else { echo 'There are no users in this staff group yet.'; } echo '</div> </div> </div> <script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> '; } ?>[/CODE] [/spoiler] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members