Worldcomer
New Member
- Jul 30, 2013
- 21
- 3
Hello! I thought I'd release my staff pages here. One was coded by me (based off Find's) the other was created by a mate of mine.
I'll release the main bit of the staff page, the core codes, not the whole page itself. Feel free to edit these as you like.
Staff Page 1
SQL's for it
Code
Enjoy.
Staff Page 2
Please use the SQL's above for this one too. In your theme, please create a folder called 'includes'. Inside that folder, create a php file called 'staff1.php'. Inside that file, put this code.
Simple CTRL + H 'StaffUser' to your staff members name. The code for the main staff page is;
I'll release the main bit of the staff page, the core codes, not the whole page itself. Feel free to edit these as you like.
Staff Page 1
SQL's for it
PHP:
ALTER TABLE `users` ADD `age` TEXT;
ALTER TABLE `users` ADD `country` TEXT;
ALTER TABLE `users` ADD `role` TEXT;
Code
PHP:
<div id="container">
<div id="content">
<div id="column2" class="column">
<?php
error_reporting(0);
$getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 8 ORDER BY id DESC");
$Bans = mysql_query("SELECT * FROM `bans` WHERE `username` = '" . $Users['username'] . "'");
$BanCount = mysql_num_rows($Bans);
echo $BanCount;
while ($Ranks = mysql_fetch_assoc($getRanks))
{
echo '<div class="habblet-container ">
<div class="cbb clearfix red ">
<h2 class="title"><span style="float: left;">Führers</span> <span style="float: right; font-weight: normal; font-size: 75%;"></span></h2>';
$getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,role,age,country FROM users WHERE rank = '" . $Ranks['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;
}
$Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'");
$BanCount = mysql_num_rows($Bans);
echo '<table width="107%" height="50px" 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="http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml">
</td>
<td valign="top">
</br><p style="margin-top: -10px;" style="font-size: 100%;"><strong><a><u>' .$member['username'] . '</a></u></strong><br>Last online: <i>' . date('d M, Y', $member['last_online']) . '</i><br>Motto: "<i>' . $member['motto'] . '</i>"<br>' . (($member['online'] == "1") ? '<font color="darkgreen"><p style="margin-left: 165px; margin-top: -37px;"><strong>Online</stromg>': '<font color="darkred"><strong><p style="margin-left: 165px; margin-top: -37px;">Offline</stromg>') . '</p></font></font></strong>
<hr>
Role: <b>' . $member['role'] . '</b><br>
Age: ' . $member['age'] . '</br>
Registered on: <b>' . date('d M, Y', $member['account_created']) . '</b></br>
Bans: <b>'; echo $BanCount;
echo '<br><img src="http://uber-hotel.net/r63/c_images/album1584/ADM2.gif"><img src="http://uber-hotel.net/app/tpl/skins/Powah/images/flags/' .$member['country'] . '.png">
</td>
</td>
</tr>
</tbody>
</table>';
}
}
else
{
echo '<i>No information available.</i>';
}
echo '</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> ';
}
?>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<div id="column2" class="column"><div class="habblet-container ">
<?php
$getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 7 ORDER BY id DESC");
while ($Ranks = mysql_fetch_assoc($getRanks))
{
echo '<div class="habblet-container ">
<div class="cbb clearfix settings ">
<h2 class="title"><span style="float: left;">Manager</span> <span style="float: right; font-weight: normal; font-size: 75%;"></span></h2>';
$getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,role,age FROM users WHERE rank = '" . $Ranks['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;
}
$Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'");
$BanCount = mysql_num_rows($Bans);
echo '<table width="107%" height="50px" 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="http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml">
</td>
<td valign="top">
</br><p style="margin-top: -10px;" style="font-size: 100%;"><strong><a><u>' .$member['username'] . '</a></u></strong><br>Last online: <i>' . date('d M, Y', $member['last_online']) . '</i><br>Motto: "<i>' . $member['motto'] . '</i>"<br>' . (($member['online'] == "1") ? '<font color="darkgreen"><p style="margin-left: 165px; margin-top: -37px;"><strong>Online</stromg>': '<font color="darkred"><strong><p style="margin-left: 165px; margin-top: -37px;">Offline</stromg>') . '</p></font></font></strong>
<hr>
Role: <b>' . $member['role'] . '</b><br>
Age: ' . $member['age'] . '</br>
Registered on: <b>' . date('d M, Y', $member['account_created']) . '</b></br>
Bans: <b>'; echo $BanCount;
echo '<p style="margin-top: 0px;"><img src="http://uber-hotel.net/r63/c_images/album1584/ADM2.gif"></p>
</td>
</tr>
</tbody>
</table>';
}
}
else
{
echo '<i>No information available.</i>';
}
echo '</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> ';
}
?>
<div id="column2" class="column"><div class="habblet-container ">
<?php
$getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 500 ORDER BY id DESC");
while ($Ranks = mysql_fetch_assoc($getRanks))
{
echo '<div class="habblet-container ">
<div class="cbb clearfix green ">
<h2 class="title"><span style="float: left;">Administrator</span> <span style="float: right; font-weight: normal; font-size: 75%;"></span></h2>';
$getMembers = mysql_query("SELECT id,username,motto,look,online,last_online FROM users WHERE rank = '" . $Ranks['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;
}
$Bans = mysql_query("SELECT * FROM `bans` WHERE `added_by` = '" . $member['username'] . "'");
$BanCount = mysql_num_rows($Bans);
echo '<table width="107%" height="50px" 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="http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml">
</td>
<td valign="top">
</br><p style="margin-top: -10px;" style="font-size: 100%;"><strong><a><u>' .$member['username'] . '</a></u></strong><br>Motto: ' . $member['motto'] . '' . (($member['online'] == "1") ? '<font color="darkgreen"><p style="margin-left: 165px; margin-top: -37px;"><strong>Online</stromg>': '<font color="darkred"><strong><p style="margin-left: 165px; margin-top: -37px;">Offline</stromg>') . '</p></p><p style="margin-top: -8px;"><img src="http://uber-hotel.net/r63/c_images/album1584/ADM.gif"></p>
';
echo '</td>
</td>
</tr>
</tbody>
</table>';
}
}
else
{
echo '<i>No information available.</i>';
}
echo '</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> ';
}
?>
</div></div></div></div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<div id="column2" class="column"><div class="habblet-container ">
<?php
$getRanks = mysql_query("SELECT id,name FROM ranks WHERE id = 6 ORDER BY id DESC");
while ($Ranks = mysql_fetch_assoc($getRanks))
{
echo '<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title"><span style="float: left;">Player Support</span> <span style="float: right; font-weight: normal; font-size: 75%;"></span></h2>';
$getMembers = mysql_query("SELECT id,username,motto,look,account_created,online,last_online,role,age FROM users WHERE rank = '" . $Ranks['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%" height="50px" 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="http://www.habbo.nl/habbo-imaging/avatarimage?figure=' .$member['look'] . '&size=m&direction=2&head_direction=3&gesture=sml">
</td>
<td valign="top">
</br><p style="margin-top: -10px;" style="font-size: 100%;"><strong><a><u>' .$member['username'] . '</a></u></strong><br>Last online: <i>' . date('d M, Y', $member['last_online']) . '</i><br>Motto: "<i>' . $member['motto'] . '</i>"<br>' . (($member['online'] == "1") ? '<font color="darkgreen"><p style="margin-left: 165px; margin-top: -37px;"><strong>Online</stromg>': '<font color="darkred"><strong><p style="margin-left: 165px; margin-top: -37px;">Offline</stromg>') . '</p></font></font></strong>
<hr>
Role: <b>' . $member['role'] . '</b><br>
Age: ' . $member['age'] . '</br>
Registered on: <b>' . date('d M, Y', $member['account_created']) . '</b></br>
Bans: <b>'; echo $BanCount;
echo '<p style="margin-top: 0px;"><img src="http://uber-hotel.net/r63/c_images/album1584/ADM2.gif"></p>
</td>
</tr>
</tbody>
</table>';
}
}
else
{
echo '<i>No information available.</i>';
}
echo '</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName(\'process-template\')) { Rounder.init(); }</script> ';
}
?>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<script type="text/javascript">
HabboView.run();
</script>
<!--[if lt IE 7]>
<script type="text/javascript">
Pngfix.doPngImageFix();
</script>
<![endif]-->
</div></div>
Enjoy.
Staff Page 2
Please use the SQL's above for this one too. In your theme, please create a folder called 'includes'. Inside that folder, create a php file called 'staff1.php'. Inside that file, put this code.
PHP:
<div class="habblet-container" style="width:280px; float:left">
<?php
$getstaff = mysql_query("SELECT look FROM users WHERE username = 'StaffUser'");
while($jew2 = mysql_fetch_array($getstaff))
{
?>
<div class="cbb clearfix blue">
<h2 class="title">StaffUser</h2>
<div style="float:left"><img src="http://www.habbo.it/habbo-imaging/avatarimage?action=crr=6&figure=<?php echo $jew2['look']; ?>&size=b&direction=2&head_direction=3&gesture=sml&size=m" align="left"></img><?php } ?>
<?php
$getstaff4 = mysql_query("SELECT online FROM users WHERE username = 'StaffUser'");
while($jew5 = mysql_fetch_array($getstaff4))
{
?>
<div style="float:left; padding-top: 5px;">
<img src="{url}/app/tpl/skins/{skin}/images/<?php echo $jew5['online']; ?>.gif"></img>
<?php } ?>
<br /><img src="{url}/r63/c_images/album1584/ADM2.gif?13"/><br /></div>
<?php
$getstaff2 = mysql_query("SELECT role FROM users WHERE username = 'StaffUser'");
while($jew4 = mysql_fetch_array($getstaff2))
{
?>
<div style="float:left; padding:5px 5px 0 5px; font-weight:bold; text-align:center"><font style="color:#595959;"><?php echo $jew4['role']; ?></font></div><?php } ?>
<?php
$getstaff1 = mysql_query("SELECT country FROM users WHERE username = 'StaffUser'");
while($jew3 = mysql_fetch_array($getstaff1))
{
?>
<div style="float:left; width:140px; padding:5px 5px 0 5px;"><br /><img src="{url}/app/tpl/skins/{skin}/images/flags/<?php echo $jew3['country']; ?>.png?1" alt="CH" title="CH"/></div><?php } ?>
</div>
</div>
</div>
Simple CTRL + H 'StaffUser' to your staff members name. The code for the main staff page is;
PHP:
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div class="content">
<div class="habblet-container" style="float:left;">
<div class="cb settings">
<div class="bt"><div></div></div><div class="i1"><div class="i2"><div class="i3">
<div class="box-tabs-container box-tabs-left clearfix">
<h2 class="page-owner">Staff</h2>
<ul class="box-tabs"></ul>
</div>
<div class="box-content" style="background-image:url('http://i.imgur.com/jtJ7RD2.gif'); width:857px; height:1340px; padding-left:55px;">
<div style="display:block;">
<?php include 'includes/staff1.php'; ?>
</div></div></div><div class="bb"><div></div></div></div>
</div></div>
</div>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<script type="text/javascript">
HabboView.run();
</script>[/CODE]
For online and offline images, save these images below as '0.gif' for the offline (zero not o) and '1.gif' for online. Save within your skin image folder.
[URL='http://uber-hotel.net/app/tpl/skins/Powah/images/1.gif']http://uber-hotel.net/app/tpl/skins/{skin}/images/0.gif[/URL]
[URL='http://uber-hotel.net/app/tpl/skins/Powah/images/1.gif']http://uber-hotel.net/app/tpl/skins/{skin}/images/1.gif[/URL]
Save these in your theme and you're good to go! Enjoy. If you like, pop me a like. =D