- 17 Dicembre 2011
- 440
- 0
- Miglior risposta
- 0
Salve, ho un problema con la pagina Staff, credo che ci sia un bug, praticamente quando vado in Comunity/Staff.php
Esce questo:
Unknow column 'ruolo' in 'fieldlist'
Con altre pagine Staff non succede, vi posto la Pagina staff, mi aiutate? Grazie! Senno postatemela una voi Grazie!
Grazie in Anticipo
@Holder
@Jeckoz
@Aqui10
Esce questo:
Unknow column 'ruolo' in 'fieldlist'
Con altre pagine Staff non succede, vi posto la Pagina staff, mi aiutate? Grazie! Senno postatemela una voi Grazie!
<?php
/*===================================================+
|| # HoloCMS - Website and Content Management System
|+===================================================+
|| # Copyright © 2011 trakons. All rights reserved.
|+===================================================*/
$allow_guests = true;
include('core.php');
include('includes/session.php');
if(HoloText(getContent('forum-enabled'), true) !== "1"){ header("Location: index.php"); exit; }
$pagename = "STAFF";
$pageid = "staff";
$body_id = "viewmode";
include('templates/community/subheader.php');
include('templates/community/header.php');
$page = $_GET['page'];
$threads = mysql_evaluate("SELECT COUNT(*) FROM cms_forum_threads WHERE forumid='0'");
$pages = ceil(($threads + 0) / 10);
if($page > $pages || $page < 1){
$page = 1;
}
$key = 0;
?>
<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix green ">
<div class="habblet box-content">
<h2 class="title">Founder & Tecnici
</h2>
<?php
$getem = mysql_query("SELECT username,motto,rank,lastvisit,look,gender,id,ruolo FROM users WHERE rank = 7 ORDER BY username") or die(mysql_error());
$staff_members = mysql_num_rows($getem);
if($staff_members == 7){
echo "Nessun membro dello staff";
} else {
while ($row = mysql_fetch_array($getem, MYSQL_NUM)) {
if(empty($row[7])){
$row[7] = "Nessun Ruolo";
}
if(empty($row[1])){
$row[1] = "Nessuna missione";
}
$badge = GetUserBadge($row[0]);
if($badge !== false){
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badge.".gif\" /></a>";
} else {
$badge= "";
}
$groupbadge = GetUserGroupBadge($row[6]);
if($groupbadge !== false){
$gbadge = "<a href='group_profile.php?id=".GetUserGroup($row[6])."'><img src='./habbo-imaging/badge.php?badge=".$groupbadge."'></a>";
} else {
$gbadge = "";
}
if(IsUserOnline($row[6])){
$online_img = "online_anim";
$online_caption = "online ora";
} else {
$online_img = "offline";
$online_caption = "Offline";
}
printf("<p><img src='http://www.habbo.com/habbo-imaging/avatarimage?figure=%s&size=b&action=wlk&direction=4&head_direction=3&gesture=sml&size=s' alt='%s' align='left' />
<b><a href='user_profile.php?name=%s'>%s</a></b> <img src='./web-gallery/v2/images/habbo_%s.gif' title='%s' alt='%s' border='0'><br />
<i>%s</i><br />
<br />
Ruolo: %s<br />
Ultima visita: %s<br />
<br />%s %s<br /><br /></p>
",$row[4],$row[0],$row[0],$row[0],$online_img,$online_caption,$online_caption,stripslashes($row[1]),$row[7],$row[3], $badge, $gbadge);
}
}
?>
<br>
<h2 class="title">Amministratori
</h2>
<?php
$getem = mysql_query("SELECT username,motto,rank,lastvisit,look,gender,id,ruolo FROM users WHERE rank = 6 ORDER BY username") or die(mysql_error());
$staff_members = mysql_num_rows($getem);
if($staff_members == 6){
echo "No staff to display yet.";
} else {
while ($row = mysql_fetch_array($getem, MYSQL_NUM)) {
if(empty($row[7])){
$row[7] = "Nessun Ruolo";
}
if(empty($row[1])){
$row[1] = "Nessuna missione";
}
$badge = GetUserBadge($row[0]);
if($badge !== false){
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badge.".gif\" /></a>";
} else {
$badge= "";
}
$groupbadge = GetUserGroupBadge($row[6]);
if($groupbadge !== false){
$gbadge = "<a href='group_profile.php?id=".GetUserGroup($row[6])."'><img src='./habbo-imaging/badge.php?badge=".$groupbadge."'></a>";
} else {
$gbadge = "";
}
if(IsUserOnline($row[6])){
$online_img = "online_anim";
$online_caption = "Online ora!";
} else {
$online_img = "offline";
$online_caption = "Offline";
}
printf("<p><img src='http://www.habbo.com/habbo-imaging/avatarimage?figure=%s&size=b&action=wlk&direction=4&head_direction=3&gesture=sml&size=s' alt='%s' align='left' />
<b><a href='user_profile.php?name=%s'>%s</a></b> <img src='./web-gallery/v2/images/habbo_%s.gif' title='%s' alt='%s' border='0'><br />
<i>%s</i><br />
<br />
Ruolo: %s<br />
Ultima visita: %s<br />
<br />%s %s<br /><br /></p>
",$row[4],$row[0],$row[0],$row[0],$online_img,$online_caption,$online_caption,stripslashes($row[1]),$row[7],$row[3], $badge, $gbadge);
}
}
?>
<br>
<h2 class="title">Moderatori
</h2>
<?php
$getem = mysql_query("SELECT username,motto,rank,lastvisit,look,gender,id,ruolo FROM users WHERE rank = 5 ORDER BY username") or die(mysql_error());
$staff_members = mysql_num_rows($getem);
if($staff_members == 5){
echo "No staff to display yet.";
} else {
while ($row = mysql_fetch_array($getem, MYSQL_NUM)) {
if(empty($row[7])){
$row[7] = "Nessun Ruolo";
}
if(empty($row[1])){
$row[1] = "Nessuna missione";
}
$badge = GetUserBadge($row[0]);
if($badge !== false){
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badge.".gif\" /></a>";
} else {
$badge= "";
}
$groupbadge = GetUserGroupBadge($row[6]);
if($groupbadge !== false){
$gbadge = "<a href='group_profile.php?id=".GetUserGroup($row[6])."'><img src='./habbo-imaging/badge.php?badge=".$groupbadge."'></a>";
} else {
$gbadge = "";
}
if(IsUserOnline($row[6])){
$online_img = "online_anim";
$online_caption = "Online ora!";
} else {
$online_img = "offline";
$online_caption = "Offline";
}
printf("<p><img src='http://www.habbo.com/habbo-imaging/avatarimage?figure=%s&size=b&action=wlk&direction=4&head_direction=3&gesture=sml&size=s' alt='%s' align='left' />
<b><a href='user_profile.php?name=%s'>%s</a></b> <img src='./web-gallery/v2/images/habbo_%s.gif' title='%s' alt='%s' border='0'><br />
<i>%s</i><br />
<br />
Ruolo: %s<br />
Ultima visita: %s<br />
<br />%s %s<br /><br /></p>
",$row[4],$row[0],$row[0],$row[0],$online_img,$online_caption,$online_caption,stripslashes($row[1]),$row[7],$row[3], $badge, $gbadge);
}
}
?> <br>
<h2 class="title">Arbitri Cornuti
</h2>
<?php
$getem = mysql_query("SELECT username,motto,rank,lastvisit,look,gender,id,ruolo FROM users WHERE rank = 4 ORDER BY username") or die(mysql_error());
$staff_members = mysql_num_rows($getem);
if($staff_members == 4){
echo "Nessun membro dello staff";
} else {
while ($row = mysql_fetch_array($getem, MYSQL_NUM)) {
if(empty($row[7])){
$row[7] = "Nessun Ruolo";
}
if(empty($row[1])){
$row[1] = "Nessuna missione";
}
$badge = GetUserBadge($row[0]);
if($badge !== false){
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badge.".gif\" /></a>";
} else {
$badge= "";
}
$groupbadge = GetUserGroupBadge($row[6]);
if($groupbadge !== false){
$gbadge = "<a href='group_profile.php?id=".GetUserGroup($row[6])."'><img src='./habbo-imaging/badge.php?badge=".$groupbadge."'></a>";
} else {
$gbadge = "";
}
if(IsUserOnline($row[6])){
$online_img = "online_anim";
$online_caption = "online ora";
} else {
$online_img = "offline";
$online_caption = "Offline";
}
printf("<p><img src='http://www.habbo.com/habbo-imaging/avatarimage?figure=%s&size=b&action=wlk&direction=4&head_direction=3&gesture=sml&size=s' alt='%s' align='left' />
<b><a href='user_profile.php?name=%s'>%s</a></b> <img src='./web-gallery/v2/images/habbo_%s.gif' title='%s' alt='%s' border='0'><br />
<i>%s</i><br />
<br />
Ruolo: %s<br />
Ultima visita: %s<br />
<br />%s %s<br /><br /></p>
",$row[4],$row[0],$row[0],$row[0],$online_img,$online_caption,$online_caption,stripslashes($row[1]),$row[7],$row[3], $badge, $gbadge);
}
}
?>
<br>
<h2 class="title">Arbitri / Moderatori ( a Pagamento )
</h2>
<?php
$getem = mysql_query("SELECT username,motto,rank,lastvisit,look,gender,id,ruolo FROM users WHERE rank = 3 ORDER BY username") or die(mysql_error());
$staff_members = mysql_num_rows($getem);
if($staff_members == 3){
echo "Nessun membro dello staff";
} else {
while ($row = mysql_fetch_array($getem, MYSQL_NUM)) {
if(empty($row[7])){
$row[7] = "Nessun Ruolo";
}
if(empty($row[1])){
$row[1] = "Nessuna missione";
}
$badge = GetUserBadge($row[0]);
if($badge !== false){
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badge.".gif\" /></a>";
} else {
$badge= "";
}
$groupbadge = GetUserGroupBadge($row[6]);
if($groupbadge !== false){
$gbadge = "<a href='group_profile.php?id=".GetUserGroup($row[6])."'><img src='./habbo-imaging/badge.php?badge=".$groupbadge."'></a>";
} else {
$gbadge = "";
}
if(IsUserOnline($row[6])){
$online_img = "online_anim";
$online_caption = "online ora";
} else {
$online_img = "offline";
$online_caption = "Offline";
}
printf("<p><img src='http://www.habbo.com/habbo-imaging/avatarimage?figure=%s&size=b&direction=3&head_direction=3&gesture=sml' alt='%s' align='left' />
<b><a href='user_profile.php?name=%s'>%s</a></b> <img src='./web-gallery/v2/images/habbo_%s.gif' title='%s' alt='%s' border='0'><br />
<i>%s</i><br />
<br />
Ruolo: %s<br />
Ultima visita: %s<br />
<br />%s %s<br /><br /></p>
",$row[4],$row[0],$row[0],$row[0],$online_img,$online_caption,$online_caption,stripslashes($row[1]),$row[7],$row[3], $badge, $gbadge);
}
}
?>
<br>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<div id="column2" class="column">
<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<div class="habblet box-content">
<h2 class="title">Tu Potresti Essere il prossimo! </h2><br>Benvenuto nella Pagina Staff <b><?php echo $name; ?></b> !<br><br>
Hey Vorresti <img alt="<?php echo $name; ?>" src="http://www.habbo.it/habbo-imaging/avatarimage?figure=<?php echo $myrow['look']; ?>&size=b&direction=3&head_direction=3&gesture=sml" width="64" height="110" align="left" />far parte dello Staff ma non sai come fare ? bene! allora preparati perche' questa e la tua occasione!<br><br> Entra in Hotel e vai da un membro dello staff Preferibilmente <b>Amministratore/Founder</b> e chiedigli quando si terranno i prossimi provini dopo di che attendi e spamma!<br><br><br><br>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<div id="container">
<div id="content">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix green ">
<div class="habblet box-content">
<h2 class="title">Notifiche</h2><br><br>
<?php
$getAlert = mysql_query("select * from cms_alert");
while($alert = mysql_fetch_assoc($getAlert)) {
?>
<li id="feed-item-campaign" class="contributed">
<div class="hotcampaign-container">
<p><b><?php echo $alert['title']; ?></b></p>
<p><?php echo $alert['desc']; ?></p>
</div>
<?php } ?>
</li>
</div> </div>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div>
</div>
<?php
include('templates/community/footer.php');
?>
Grazie in Anticipo
@Holder
@Jeckoz
@Aqui10
