Unknown column 'user_one_id' in 'where clause' 25.01.13 14:48 Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 14:49 Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 14:49 Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 14:50
✘Bigarde • 25.01.13 14:48
OnzeDolares • 25.01.13 14:49
<?php
require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');
if($_GET['do'] == "RemoveFeedItem" && is_numeric($_GET['key'])){
mysql_query("DELETE FROM cms_alerts WHERE userid = '".$my_id."' AND id = '".FilterText($_GET['key'])."' ORDER BY id ASC LIMIT 1") or die(mysql_error());
}
$pagename = $name;
$pageid = "1";
$messages = mysql_query("SELECT COUNT(*) FROM cms_minimail WHERE receiver_id = '".$my_id."'") or $messages = 0;
header("X-JSON: {\"totalMessages\":".$messages."}");
include('templates/community_subheader.php');
include('templates/community_header.php');
srand ((double) microtime() * 1000000);
$chosen = rand(0,count($randomq)-1);
$tag_question = $randomq[$chosen];
$get_flashclient = mysql_query("SELECT * FROM cms_settings WHERE variable = 'cms_flashclient' AND value = '1'");
?>
<div id="container">
<div id="content" style="position: relative" class="clearfix">
<div id="column1" class="column">
<div class="habblet-container ">
<div class="cbb clearfix ">
</div>
</div>
<div class="habblet-container ">
<div id="new-personal-info" style="background-image:url(images/htlview_habbore_v3.0.png)">
<div id="enter-hotel">
<div class="enter-hotel-btn">
<?php if(mysql_num_rows($get_flashclient) < 1 && $server['status'] !== "1"){ ?>
<div class="closed enter-btn">
<span>Closed Beta</span>
<b></b>
</div></div>
<?php } else { ?>
<div class="open enter-btn">
<a href="client.php" target="client" onclick="openOrFocusHabbo(this); return false;"> Entra no <?php echo $shortname; ?> Hotel <i></i></a>
<b></b>
</div></div>
<?php } ?>
</div>
<div style="background:url(images/lupe.gif) no-repeat;width:244px;height:244px;position:absolute;margin-left:-75px;margin-top:-130px;">
<a href="<?php echo $path; ?>/profile">
<img style="position:absolute;margin-left:125px;margin-top:17px;" alt="<?php echo $name; ?>" src="http://www.habbo.co.uk/habbo-imaging/avatarimage?figure=<?php echo $myrow['look']; ?>&size=b&action=sit&direction=4&head_direction=4&gesture=sml&size=s" width="64" height="110"/>
</a>
</div>
<div id="habbo-info">
<div id="motto-container" class="clearfix">
<strong><?php echo $name; ?>:</span></strong>
<div>
<span title="¿En qué piensas hoy?"><?php if(!empty($myrow['motto'])){ echo HoloText($myrow['motto']); } else { echo "¿En qué piensas hoy?"; } ?></span>
<p style="display: none"><input type="text" length="30" name="motto" value="<?php echo HoloText($myrow['motto']); ?>"/></p>
</div>
</div>
<div id="motto-links" style="display: none"><a href="#" id="motto-cancel">Cancelar</a></div>
</div>
<ul id="link-bar" class="clearfix">
<li class="credits">
<a href="./credits"><?php echo $myrow['credits']; ?></a> <span style="color: yellow" size:="" 2=""><b>Moedas</b></span></li>
<li class="id">
<b>ID</b> <a><?php echo $my_id; ?></a></li>
<li class="activitypoints">
<a href="./credits/pixels"><?php echo $myrow['activity_points']; ?></a> <span style="text-shadow: 0px 0px 0px blue"><span style="color: blue" size:="" 2=""><b>Pixels</b></span></li>
<li class="respect">
<a><?php echo $userinfo['Respect']; ?></a> <span style="text-shadow: 0px 0px 0px orange"><span style="color: orange" size:="" =2""><b>Respeitos</b></span></li>
<li class="club">
<?php if($hc > 0){ ?>
<a href="./credits/habboclub"><?php echo getHCDays($my_id); ?></a> <span style="text-shadow: 0px 0px 0px brown"><span style="color: brown" size:="" 2=""><b>Dias HC</b></span>
<?php } else { ?>
<a href="./credits/habboclub">Juntar ao <?php echo $shortname; ?> clube »</a><?php } ?></li>
<lo class="userid">
<img src="/Premiun_Images/dolares.png" /><a href="./tienda"><?php echo $myrow['dolares']; ?></a> <span style="color: green" size:="" 2=""><b>Dólares</b></span></lo>
</ul>
<div id="habbo-feed">
<ul id="feed-items">
<span>
<script type="text/javascript">
L10N.put("subscription.title", "<?php echo $shortname; ?> CLUB");
</script>
<div id="habbo-feed">
<ul id="feed-items">
<center>
<br>
<p><span style=": 0px 0px 7px black"><span style="color: black" size:="" 2=""><b>Você tem atualmente <u><?php if(!isset($_GET['n'])) {
$usuario = $name;
} else {
$usuario = mysql_real_escape_string($_GET['n']);
}
$query = mysql_query("SELECT COUNT(id) AS aantalleden FROM users_referidos WHERE usuario ='". $usuario ."' ORDER BY ID") or die(mysql_error());
$data = mysql_fetch_assoc($query); echo $data['aantalleden'];?></u> Referidos</b></span></span></p>
<textarea style="height: 15px; width: 350px; "><?php echo $path; ?>/refer.php?r=<?php echo $name; ?></textarea>
</center>
<br>
</div>
<?php
$tmp = mysql_query("SELECT * FROM cms_alerts WHERE userid = '".$my_id."'") or die(mysql_error());
$alerts = mysql_num_rows($tmp);
if($alerts > 0){
$row = mysql_fetch_assoc($tmp);
$id = $row['id'];
$alert = $row['alert'];
if($alerts > 0){ ?>
<li id="feed-item-campaign" class="contributed">
<a href="#" class="remove-feed-item" id="remove-feed-item-6107" title="Löschen">Borrar</a>
<div>
<span style="text-shadow: 0px 0px 0px green"><span style="color: green" size:="" 2=""><b>Mensagem da Equipe do <?php echo $sitename; ?>Hotel</b></span><br><br>
<?php echo $alert; ?>
</span>
</div>
</li>
<?php while($row = mysql_fetch_assoc($tmp)){ ?>
<?php } } }
$sql = mysql_query("SELECT * FROM messenger_requests WHERE to_id = '".$my_id."'");
$count = mysql_num_rows($sql);
if($count > 0){ ?>
<li id="feed-notification">Você tem <a href="/client.php" onclick="HabboClient.openOrFocus(this); return false;"><?php echo $count; ?> pedidos de amizade.</a></li>
<?php }
$sql = mysql_query("SELECT * FROM users,messenger_friendships WHERE users.online = '1' AND (messenger_friendships.user_two_id = '".$my_id."') AND messenger_friendships.user_one_id = users.id AND users.id != '".$my_id."' ORDER BY username");
$count = mysql_num_rows($sql);
$i = 0;
if($count > 0){
?>
<li id="feed-friends">
Você tem <strong><?php echo $count; ?></strong> amigo<?php if($count > 1){ ?>s<?php } ?> Online:
<span>
<?php while($row = mysql_fetch_assoc($sql)){
$i++;
echo"<a href=\"../home/".$row['username']."\">"; echo $row['username']; echo"</a>";
if($i < $count){ echo ", "; }
echo "\n"; } ?>
</span>
</li>
<?php }
if($vip > 0 && $date_normal !== $myrow['getmoney_date']){
mysql_query("UPDATE users SET credits = credits + 50000, vip_points = vip_points + 15000, getmoney_date = '".$date_normal."' WHERE id = '".$my_id."'");
mysql_query("UPDATE user_stats SET DailyRespectPoints = '3', DailyPetRespectPoints = '3' WHERE id = '".$my_id."'");
mysql_query("INSERT INTO cms_transactions (userid,descr,date,amount) VALUES ('".$my_id."','VIP para conexão com Gabba.','".$date_full."','+70000')") or die(mysql_error());
echo"<li id=\"feed-item-dailygift\">[<b>Regalo VIP</b>] - Ligou hoje para o que você ganha <b>+50000</b> creditos e <b>+15000</b> pontos VIP. Tenha um bom dia!</li>";
}elseif($vip < 1 && $date_normal !== $myrow['getmoney_date']){
mysql_query("UPDATE users SET credits = credits + 50000, getmoney_date = '".$date_normal."' WHERE id = '".$my_id."'") or die(mysql_error());
mysql_query("UPDATE user_stats SET DailyRespectPoints = '3', DailyPetRespectPoints = '3' WHERE id = '".$my_id."'") or die(mysql_error());
mysql_query("INSERT INTO cms_transactions (userid,descr,date,amount) VALUES ('".$my_id."','Conectar-se a presente Gabba.','".$date_full."','+25000')") or die(mysql_error());
echo"<li id=\"feed-item-dailygift\">Ligou hoje para o que você ganha <b>25000</b> creditos.</li>";
}
if($vip == 1){
//Sacar ID de Usuario
$sql = "SELECT id FROM users WHERE username='".$name."'";
$result= mysql_query($sql);
$row = mysql_fetch_assoc($result);
//Coger ID
$userid = $row[id];
//Sacar tiempo de expiración Vip
$sql = "SELECT timestampend FROM vip WHERE id_user=$userid ORDER BY timestampend DESC LIMIT 1";
$result= mysql_query($sql);
$row = mysql_fetch_assoc($result);
//Tiempo para finalizar
$expiretime = $row[timestampend];
//Sacar días restantes
$daysLeft = 0;
if ( $expiretime>time() ){
$daysLeft = $expiretime - time();
$daysLeft = round($daysLeft/86400);
}
//Si Expira el tiempo el vip será quitado
if($expiretime < time()){
$sql = "UPDATE users SET vip='0' WHERE id='$my_id'";
mysql_query($sql);
//Degradamos rango
$sql = "UPDATE users SET rank='1' WHERE id='$my_id'";
mysql_query($sql);
//Alertamos al Usuario
$sql = "INSERT INTO cms_alerts (userid,alert) VALUES ('".$my_id."','Por favor note que a sua subscrição terminou VIP.')";
mysql_query($sql);
//Quitamos placa VIP
$sql = "DELETE FROM user_badges WHERE user_id = '".$my_id."' AND badge_id = 'VIP'";
mysql_query($sql);
//Eliminar de tabla vip
$sql = "DELETE FROM vip WHERE id_user=$userid";
mysql_query($sql);
}
}
$dob = $myrow['birth'];
$bits = explode(".", $dob);
$day = $bits[0];
$month2 = $bits[1];
$year2 = $bits[2];
$date = $date_normal;
if($day == $d && $month2 == $m){ ?>
<li id="feed-birthday">
<div>
Parabéns <?php echo $name; ?>! Hoje é seu aniversário.<br />Tenha um bom dia.
</div>
</li>
<?php }
$get_em = mysql_query("SELECT id FROM homes_stickers WHERE userid = '".$my_id."' AND subtype = '4'") or die(mysql_error());
$row_em = mysql_num_rows($get_em);
if($row_em > 0){
$row_em = mysql_fetch_assoc($get_em);
$sql = mysql_query("SELECT * FROM homes_guestbook WHERE widget_id = '".$row_em['id']."' AND pickup = '1'");
$count = mysql_num_rows($sql);
if($count > 0){ ?>
<li class="small" id="feed-guestbook">
Você tem <a href="../home/<?php echo $name; ?>"><?php echo $count; ?> novas mensagens no seu livro de visitas.</a></li>
<?php } } ?>
<li class="small" id="feed-trading-enabled">As trocas estão ativadas </li>
<li class="small" id="feed-lastlogin">
Última conexão: <?php echo date('d-m-Y H:i:s', $myrow['last_online']); echo""; ?>
</li>
</ul>
</div>
<p class="last"></p>
</div>
<script type="text/javascript">
HabboView.add(function() {
L10N.put("personal_info.motto_editor.spamming", "Hey, não há spam!");
PersonalInfo.init("");
});
</script>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<h2 class="title">Emblemas em uso:</h2>
<div id="hotcampaigns-habblet-list-container">
<center>
<?php
$badge = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$my_id."' AND badge_slot = '1'");
$badge2 = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$my_id."' AND badge_slot = '2'");
$badge3 = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$my_id."' AND badge_slot = '3'");
$badge4 = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$my_id."' AND badge_slot = '4'");
$badge5 = mysql_query("SELECT * FROM user_badges WHERE user_id = '".$my_id."' AND badge_slot = '5'");
$get_groups = mysql_query("SELECT * FROM group_members WHERE id_user = '".$my_id."' AND is_current = '1'");
$members_row = mysql_fetch_assoc($get_groups);
if(mysql_num_rows($badge) > 0){
$badgerow = mysql_fetch_assoc($badge);
$badge = "<img src=\"".$cimagesurl.$badgesurl.$badgerow['badge_id'].".gif\">";
}else{
$badge = "<br>";
}
if(mysql_num_rows($badge2) > 0){
$badgerow2 = mysql_fetch_assoc($badge2);
$badge2 = "<img src=\"".$cimagesurl.$badgesurl.$badgerow2['badge_id'].".gif\">";
}else{
$badge2 = "<br>";
}
if(mysql_num_rows($badge3) > 0){
$badgerow3 = mysql_fetch_assoc($badge3);
$badge3 = "<img src=\"".$cimagesurl.$badgesurl.$badgerow3['badge_id'].".gif\">";
}else{
$badge3 = "";
}
if(mysql_num_rows($badge4) > 0){
$badgerow4 = mysql_fetch_assoc($badge4);
$badge4 = "<img src=\"".$cimagesurl.$badgesurl.$badgerow4['badge_id'].".gif\">";
}else{
$badge4 = "";
}
if(mysql_num_rows($badge5) > 0){
$badgerow5 = mysql_fetch_assoc($badge5);
$badge5 = "<img src=\"".$cimagesurl.$badgesurl.$badgerow5['badge_id'].".gif\">";
}else{
$badge5 = "";
}
?>
<p><?php echo $badge; ?> <?php echo $badge2; ?> <?php echo $badge3; ?> <?php echo $badge4; ?> <?php echo $badge5; ?></p>
</center>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<?php
// #########################################################################
// Noticiones
// #########################################################################
$hotcampaigns = mysql_query("SELECT * FROM cms_hotcampaigns ORDER BY id DESC LIMIT 10") or die(mysql_error());
if(mysql_num_rows($hotcampaigns) > 0){ ?>
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<h2 class="title">Notícias Recentes</h2>
<div id="hotcampaigns-habblet-list-container">
<?php while($row = mysql_fetch_assoc($hotcampaigns)){ ?>
<ul id="hotcampaigns-habblet-list">
<li class="even">
<div class="hotcampaign-container">
<a href="<?php echo $row['url']; ?>"><img src="<?php echo $row['image_url']; ?>" align="left" alt="" /></a>
<h3><?php echo $row['caption']; ?></h3>
<p><?php echo $row['descr']; ?></p>
<p class="link"><a href="<?php echo $row['url']; ?>">Ir »</a></p>
</div>
</li>
</ul>
<?php } ?>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template)) { Rounder.init(); }</script>
<?php
error_reporting(0);
define('CMS', 'LAVVOCMS'); // Sólo se puede usar en Uber && LAVVOCMS
define('id', (CMS == 'uber' ? USER_ID : $my_id));
define('moneda', 'dolares');
define('nombre_moneda', 'Dólares');
define('price', '2');
if(CMS == 'uber')
$online = $users->GetUserVar(USER_ID, 'online');
else
$online = $myrow['online'];
if(isset($_POST['cnombre'])):
$moneda = (CMS == 'uber' ? $users->GetUserVar(USER_ID, moneda) : $myrow[moneda]);
$error = array();
$tmp = mysql_query("SELECT id FROM users WHERE username = '".mysql_real_escape_string($_POST['new_nombre'])."' LIMIT 1");
$tmp = mysql_num_rows($tmp);
$newname = mysql_real_escape_string($_POST['new_nombre']);
if(strlen($newname) < 3)
$error[] = "Desculpe, o nome é muito curto.";
if(strlen($newname) > 15)
$error[] = "Desculpe, o nome é muito longo.";
if($tmp > 0)
$error[] = "Desculpe, o nome já está em uso.";
if($moneda < price)
$error[] = "Desculpe, não têm o suficiente ".nombre_moneda;
if(empty($_POST['new_nombre']))
$error[] = "Desculpe, você deve escolher um nome.";
if(empty($error)):
$sucess = "O nome foi alterado com sucesso!";
$cambio = $moneda-price;
mysql_query("UPDATE rooms SET owner = '".mysql_real_escape_string($_POST['new_nombre'])."' WHERE owner = '".$name."' LIMIT 1000");
mysql_query("UPDATE users SET ".moneda." = '".$cambio."' WHERE id = '".$my_id."'");
mysql_query("UPDATE users SET username = '".mysql_real_escape_string($_POST['new_nombre'])."' WHERE id = '".$my_id."'");
mysql_query("INSERT INTO cms_transactionsvip (userid,amount,date,descr) VALUES ('".$my_id."',-'".price."','".$date_full."','Combio de nombre.')");
endif;
foreach($error as $errors)
$errorz = $errors;
endif;
?>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<?php }
// #########################################################################
// Minimail
// #########################################################################
?>
<div class="habblet-container minimail" id="mail">
<div class="cbb clearfix blue ">
<h2 class="title">Minhas Mensagens</h2>
<div id="minimail">
<div class="minimail-contents">
<?php
$bypass = true;
$page = "inbox";
include('./minimail/loadMessage.php');
?>
</div>
<div id="message-compose-wait"></div>
<form style="display: none" id="message-compose">
<div>Para</div>
<div id="message-recipients-container" class="input-text" style="width: 426px; margin-bottom: 1em">
<input type="text" value="" id="message-recipients" />
<div class="autocomplete" id="message-recipients-auto">
<div class="default" style="display: none;">Escreva o nome do seu amigo</div>
<ul class="feed" style="display: none;"></ul>
</div>
</div>
<div>Assunto<br/>
<input type="text" style="margin: 5px 0" id="message-subject" class="message-text" maxlength="100" tabindex="2" />
</div>
<div>Mensagem<br/>
<textarea style="margin: 5px 0" rows="5" cols="10" id="message-body" class="message-text" tabindex="3"></textarea>
</div>
<div class="new-buttons clearfix">
<a href="#" class="new-button preview"><b>Previa</b><i></i></a>
<a href="#" class="new-button send"><b>Enviar</b><i></i></a>
</div>
</form>
</div>
<?php
$sql = mysql_query("SELECT * FROM messenger_friendships WHERE user_one_id = '".$my_id."' OR user_two_id = '".$my_id."'") or die(mysql_error());
$count = mysql_num_rows($sql);
$sql = mysql_query("SELECT * FROM cms_minimail WHERE receiver_id = '".$my_id."' OR sender_id = '".$my_id."'") or die(mysql_error());
$mescount = mysql_num_rows($sql);
?>
<script type="text/javascript">
L10N.put("minimail.compose", "Escrever").put("minimail.cancel", "Cancelar")
.put("bbcode.colors.red", "Vermelho").put("bbcode.colors.orange", "Laranja")
.put("bbcode.colors.yellow", "Amarelo").put("bbcode.colors.green", "Verde")
.put("bbcode.colors.cyan", "Ciano").put("bbcode.colors.blue", "Azul")
.put("bbcode.colors.gray", "Cinza").put("bbcode.colors.black", "Preto")
.put("minimail.empty_body.confirm", "Tem certeza de que deseja enviar uma mensagem sem texto?")
.put("bbcode.colors.label", "Color").put("linktool.find.label", " ")
.put("linktool.scope.habbos", "Habbos").put("linktool.scope.rooms", "Salas")
.put("linktool.scope.groups", "Grupos").put("minimail.report.title", "Reportar Post para Moderadores");
L10N.put("date.pretty.just_now", "Justo ahora");
L10N.put("date.pretty.one_minute_ago", "Atrás 1 minuto");
L10N.put("date.pretty.minutes_ago", "Atrás {0} minutos");
L10N.put("date.pretty.one_hour_ago", "Atrás 1 hora");
L10N.put("date.pretty.hours_ago", "Atrás {0} horas");
L10N.put("date.pretty.yesterday", "Ayer");
L10N.put("date.pretty.days_ago", "Atrás {0} días");
L10N.put("date.pretty.one_week_ago", "Atrás 1 semana");
L10N.put("date.pretty.weeks_ago", "Atrás {0} semanas");
new MiniMail({ pageSize: 10,
total: <?php echo $mescount; ?>,
friendCount: <?php echo $count; ?>,
maxRecipients: 50,
messageMaxLength: 20,
bodyMaxLength: 4096,
secondLevel: <?php if($count = 0){ echo "true"; }else{ echo "false"; } ?>});
</script>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<?php
// #########################################################################
// News
// #########################################################################
require_once('./data_classes/server-data.php_data_classes-news.php.php');
// #########################################################################
// Selección Staff
// #########################################################################
?>
<div class="habblet-container ">
<div class="cbb clearfix red ">
<div class="box-tabs-container clearfix">
<h2>Dâ Gerência</h2>
<ul class="box-tabs">
<li id="tab-1-3-1"><a href="#">Quartos</a><span class="tab-spacer"></span></li>
<li id="tab-1-3-2" class="selected"><a href="#">Grupos</a><span class="tab-spacer"></span></li>
</ul>
</div>
<div id="tab-1-3-1-content" style="display: none">
<div id="staffpicks-rooms-habblet-list-container" class="habblet-list-container groups-list">
<ul class="habblet-list">
<?php $sql = mysql_query("SELECT * FROM cms_recommended WHERE type = 'room' ORDER BY id ASC") or die(mysql_error());
while($row = mysql_fetch_assoc($sql)) {
$i++;
$roomsql = mysql_query("SELECT * FROM rooms WHERE id = '".$row['id_rec']."' LIMIT 1");
$roomrow = mysql_fetch_assoc($roomsql);
if(IsEven($i)){
$even = "even left";
} else {
$even = "even2";
}
$roomcount = $roomrow['users_now'] / $roomrow['users_max'] * 100;
if($roomcount == 99 || $roomcount > 99){
$rl = 5;
} elseif($roomcount > 65){
$rl = 4;
} elseif($roomcount > 32){
$rl = 3;
} elseif($roomcount > 0){
$rl = 2;
} elseif($roomcount < 1){
$rl = 1;
}
$getOwner = mysql_query("SELECT * FROM users WHERE id = '".$roomrow['owner']."'");
$owner = mysql_fetch_assoc($getOwner);
?>
<li class="<?php echo $even; ?> room-occupancy-<?php echo $rl; ?>" roomid="<?php echo $roomrow['id']; ?>">
<div>
<span class="room-name"><a href="../client?forwardId=2&roomId=<?php echo $roomrow['id']; ?>" onclick="HabboClient.roomForward(this, '<?php echo $roomrow['id']; ?>', '<?php echo $roomrow['roomtype']; ?>'); return false;" target="85d327955e5fc804ac33675ef8d05e3c9d3ef7ed"><?php echo $roomrow['caption']; ?></a></span>
<span class="room-owner"><a href="/home/<?php echo $owner['username']; ?>"><?php echo $owner['username']; ?></a></span>
<p><?php echo $roomrow['description']; ?></p>
</div>
</li>
<?php } ?>
</ul>
</div>
</div>
<div id="tab-1-3-2-content" >
<div id="staffpicks-groups-habblet-list-container" class="habblet-list-container groups-list">
<ul class="habblet-list two-cols">
<?php $sql = mysql_query("SELECT * FROM cms_recommended WHERE type = 'group' ORDER BY id ASC") or die(mysql_error());
while($row = mysql_fetch_assoc($sql)) {
$i++;
$groupsql = mysql_query("SELECT * FROM group_details WHERE id = '".$row['id_rec']."' LIMIT 1");
$grouprow = mysql_fetch_assoc($groupsql);
if(IsEven($i)){
$even = "even left";
} else {
$even = "even right";
}
?>
<li class="<?php echo $even; ?>" style="background-image: url(<?php echo $path; ?>/habbo-imaging/badge.php?badge=<?php echo $grouprow['badge']; ?>)">
<?php if($grouprow['roomid'] !== 0) { ?><a href="<?php echo $path; ?>/client?forwardId=2&roomId=<?php echo $grouprow['roomid']; ?>" onclick="HabboClient.roomForward(this, '<?php echo $grouprow['roomid']; ?>', 'private'); return false;" target="9cf76b1ff4b99b02656456ee94e0271ab56272ee" class="group-room"></a><?php } ?>
<a class="item" href="./groups/<?php echo $grouprow['id']; ?>"><?php echo HoloText($grouprow['name']); ?></a>
</li>
<?php } ?>
</ul>
</div>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<?php
// #########################################################################
// Logs
// #########################################################################
?>
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<div class="box-tabs-container clearfix">
<h2>Logs</h2>
<ul class="box-tabs">
<li id="tab-4-1" class="selected"><a href="#">Home</a><span class="tab-spacer"></span></li>
</ul>
</div>
<div class="box-content" >
<div id="tab-4-1-content">
<div id="staffpicks-rooms-habblet-list-container" class="habblet-list-container">
<ul class="habblet-list">
<?php $get_visitedhomes = mysql_query("SELECT * FROM logs_visitedhomes WHERE id_target = '".$my_id."' ORDER BY ID DESC LIMIT 5"); ?>
<table cellpadding='4' cellspacing='0' width='100%'>
<tr>
<td class='tablesubheader' width='1%' align='center'><b>ID</b></td>
<td class='tablesubheader' width='10%' align='left'><b><?php echo $shortname; ?> Nome</b></td>
<td class='tablesubheader' width='89%' align='left'><b>Data</b></td>
</tr>
<?php
$i = 0;
while($row = mysql_fetch_assoc($get_visitedhomes)){
$get_user = mysql_query("SELECT username FROM users WHERE id = '".$row['id_user']."'");
$row_user = mysql_fetch_assoc($get_user);
$i++; ?>
<tr>
<td class='tablerow1'><?php echo $i; ?></td>
<td class='tablerow1'><a href="./home/<?php echo $row_user['username']; ?>"><?php echo $row_user['username']; ?></a></td>
<td class='tablerow2'><?php if(date('d.m.Y', $row['timestamp']) == $date_normal){ echo"<b>Hoje</b> as ".date('H:i:s', $row['timestamp']).""; }elseif(date('d.m.Y', $row['timestamp']) == $date_normal -1){ echo"Ontem às ".date('H:i:s', $row['timestamp']).""; }else{ echo date('d-m-Y - H:i:s', $row['timestamp']); } ?></td>
</tr>
<?php } ?>
</table>
</ul>
</div>
</div>
</div></div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>
<script type="text/javascript">
HabboView.add(LoginFormUI.init);
</script>
<?php require_once('./templates/community_footer.php'); ?> Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 15:53ALTER TABLE `messenger_friendships` ADD COLUMN `user_one_id` int(10) Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 16:15 Re: Unknown column 'user_one_id' in 'where clause' 25.01.13 16:34Recomendamos a BH Servers com proteção DDOS gratuita em Cloud Server de alta performance. Entrega imediata.
