[PEDIDO] Código de notícias

<?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 = Principal;
$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');

$fetch_tags = mysql_query("SELECT tag,id FROM user_tags WHERE user_id = '".$my_id."' LIMIT 20") or die(mysql_error());
$tags_num = mysql_num_rows($fetch_tags);

$randomq[] = "¿Quién es tu actor favorito?";
$randomq[] = "¿Prefieres deporte o siesta?";
$randomq[] = "¿Tienes un sobrenombre?";
$randomq[] = "¿Cuál es tu canción favorita?";
$randomq[] = "¿Cuál es tu época del año favorita?";
$randomq[] = "¿Cuál es tu banda favorita?";
$randomq[] = "¿No puedes vivir sin qué programa de televisión? ";
$randomq[] = "¿Qué instrumento te gustaría tocar?";
$randomq[] = "Elige: ¿Pizza? ¿Hamburguesa? ¿Hot-Dog?";
$randomq[] = "El Deporte que más te gusta";
$randomq[] = "Para salir de fiesta vistes con...";
$randomq[] = "¿Cuál es tu película favorita?";
$randomq[] = "Perros, Gatos o algo más exótico.";
$randomq[] = "¿Rojo? ¿Azul? ¿Rosa? u otro color.";
$randomq[] = "Elige: ¿MCR? ¿Panda? ¿Jonas Brothers?";
$randomq[] = "Elige: ¿Rock? ¿Pop? ¿Rap?";
$randomq[] = "¿Qué palabra te define?";
$randomq[] = "Elige ¿Habbo? ¿".$shortname."?";
$randomq[] = "¿Cuál es tu Staff favorito?";
$randomq[] = "¿Postre o Jamón?";
$randomq[] = "¿Qué otro idioma hablas?";
$randomq[] = "Lo mejor del mundo es...";
$randomq[] = "¿Qué furni te gusta más?";
$randomq[] = "Elige: ¿Laptop? ¿Escritorio?";

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'");

///////////////////////////////////////////////////// ALEJO.MASTER97 ////////////////////////////////////////////////////////
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."','Le informamos que su suscripción Vip ah finalizado.')";
mysql_query($sql);

//Eliminar de tabla vip
$sql = "DELETE FROM vip WHERE id_user=$userid";
mysql_query($sql);
} }
///////////////////////////////////////////////////// ALEJO.MASTER97 ////////////////////////////////////////////////////////


?>

<link rel="stylesheet" href="./web-gallery/static/styles/lightweightmepage.css" type="text/css" />
<script src="./web-gallery/static/js/lightweightmepage.js" type="text/javascript"></script>

<div id="container">
<div id="content" style="position: relative" class="clearfix">

<?PHP
$rand =rand(0,100);
if($rand < 85){
//PUBLI EDU
?>


<?PHP
} else {
//PUBLI HECTOR
?>


<?PHP
}
?>

<div id="wide-personal-info">

<div id="habbo-plate">
<a href="<?php echo $path; ?>/profile">
<img alt="<?php echo $name; ?>" src="<?php echo $avatar; echo $myrow['look']; ?>&direction=3&head_direction=3&gesture=sml&action=&size=l" width="64" height="110"/>
</a>
</div>

<div id="name-box" class="info-box">
<div class="label">Nome:</div>
<div class="content"><?php echo $name; ?></div>
</div>
<div id="motto-box" class="info-box">
<div class="label">Missão:</div>
<div class="content"><?php echo $myrow['motto']; ?></div>
</div>
<div id="last-logged-in-box" class="info-box">
<div class="label">Último Acesso:</div>
<div class="content"><?php echo date('d-m-Y H:i:s', $myrow['last_online']); echo""; ?> </div>
</div>

<div class="enter-hotel-btn">
<div class="open enter-btn">
<a href="/client" target="01080cec2ad93526df3c8baaeb130bf04025261d" onclick="HabboClient.openOrFocus(this); return false;">Entrar no Desert Hotel<i></i></a>
<b></b>
</div>
</div>

</div>

<?php

require_once('./noticiasmobiles.php');

?>


<div id="column1" class="column">

<div class="habblet-container ">

<div id="twitterfeed-habblet-container">
<div id="twitterfeed-habblet-content"></div>
<script>new TWTR.Widget({
version: 2,
id: 'twitterfeed-habblet-content',
type: 'profile',
rpp: 5,
interval: 30000,
width: 453,
height: 163,
theme: {
shell: {
background: '#4a4d4f',
color: '#ffffff'
},
tweets: {
background: '#ffffff',
color: '#4a4d4f',
links: '#fe6301'
}
},
features: {
scrollbar: true,
loop: false,
live: false,
behavior: 'default'
} }).render().setUser('_MaciielGomes').start();
</script>
</div>




</div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>

</div>


<div id="column2" class="column">

<div class="habblet-container ">
<div class="ad-container">
<script type="text/javascript"><!--
google_ad_client = "ca-pub-1382853577805762";
/* Bloco Hab Lateral */
google_ad_slot = "7953676792";
google_ad_width = 300;
google_ad_height = 250;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</div>



<!--
<div class="habblet-container ">
<div class="cbb clearfix red ">
<div class="box-tabs-container clearfix">

<h2>Selección Staff</h2>

<ul class="box-tabs">
<li id="tab-1-3-1"><a href="#">Salas</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&amp;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&amp;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> </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>

<script type="text/javascript">
HabboView.add(LoginFormUI.init);
</script>-->
</div>



<?php require_once('./templates/community_footer.php'); ?>