Pedido Loja de Emblemas

--
-- Estrutura da tabela `cms_marktplatz`
--
 
CREATE table IF NOT EXISTS `cms_marktplatz` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `image` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `diamonds` INT(15) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
 
--
-- Extraindo dados da tabela `cms_marktplatz`
--
 
INSERT INTO `cms_marktplatzvip` (`id`, `image`, `name`, `description`, `diamonds`) VALUES
(1, 'BR100', 'Teste', 'Para os bobba', 5000),
(2, 'ADM', 'Tabares', 'Para os bobba', 12);





outro códigoo 



--
-- Estrutura da tabela `cms_marktplatzfurni`
--
 
CREATE table IF NOT EXISTS `cms_marktplatzfurni` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `image` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  `diamonds` INT(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;








outro códigoo






--
-- Estrutura da tabela `cms_marktplatzfurnivip`
--
 
CREATE table IF NOT EXISTS `cms_marktplatzfurnivip` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `image` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `diamonds` INT(11) NOT NULL,
  `description` VARCHAR(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 


e esse códigoo 





--
-- Estrutura da tabela `cms_marktplatzvip`
--
 
CREATE table IF NOT EXISTS `cms_marktplatzvip` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `image` VARCHAR(255) NOT NULL,
  `name` VARCHAR(255) DEFAULT NULL,
  `diamonds` INT(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
 
--
-- Extraindo dados da tabela `cms_marktplatzvip`
--
 
INSERT INTO `cms_marktplatzvip` (`id`, `image`, `name`, `diamonds`) VALUES
(2, 'BR100', 'Corinthians', 2),
(3, 'ADM', 'Admis', 2);

http://adf.ly/246619/http://www.mediafire.com/download/by8b5br4ysscjl6/FutureCMS+-+The+Future+PROJECT.zip

<?php

require_once('./data_classes/server-data.php_data_classes-core.php.php');
require_once('./data_classes/server-data.php_data_classes-config.php.php');
require_once('./data_classes/server-data.php_data_classes-session.php.php');

$siteurl = "$hotel_url";
$pagename = "Loja de Emblemas";
$pageid = "8b";

require_once('./templates/community_subheader.php');
require_once('./templates/community_header.php');

?>

<style>
.ssh {
float:right;
align:right;
width:67px;
height: 19px;
-moz-border-radius:2px;
-webkit-border-radius:2px;
margin-left:10px;
margin-right:15px;
margin-bottom:15px;
margin-top:11px;
border-radius: 2px;
text-align: center;
border:1px solid #808080;
text-decoration:none;
background: #e9e9e9; /* Old browsers */
text-color:# ffffff
}

.ssh2 {
display:block;
float: right;
width: 60px;
height: auto;
margin-left:0px;
margin-right:8px;
margin-bottom:0px;
margin-top:-8px;
border-radius: 2px;
text-align: center;
border:1px solid #808080;
background: #e9e9e9; /* Old browsers */
}
.ssh:hover {
background: #ffffff; /* Old browsers */
}

</style>

<script src="<?php echo $path; ?>/web-gallery/static/js/shop_badgevip.js" type="text/javascript"></script>

<div id="container">
<div id="content" style="position: relative; left: 0px; top: 0px;" class="clearfix">

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


<div class="habblet-container ">
<div class="cbb clearfix blue"> 
<h2 class="title"><font style="float: left; margin-left:5px">Lista de Emblemas</font> <span style="float: right; font-weight: normal; font-size: 75%;">(<?php echo mysql_evaluate("SELECT COUNT(*) FROM cms_marktplatz"); ?> Emblemas disponiveis)</span></h2> 

<div id="Layer1" style="width:444px; height:400px; overflow: scroll;">
<div id="credits-safety" class="box-content credits-info">
<div class="credit-info-text clearfix">
<center>

<?php

$i = 0;
$sql = mysql_query("SELECT * FROM cms_marktplatz ORDER BY id ASC LIMIT 100 OFFSET ".$page*20);
while($row = mysql_fetch_assoc($sql)) { 

$i++;
        if(IsEven($i)){
            $even = "even";
        } else {
            $even = "odd";
        }

?>

<li class="<?php echo $even; ?>">
 <table cellpadding='4' cellspacing='0' width='100%'>

 <tr>
  <td class='tablesubheader' width='15%' align='left'><b></b></td>
  <td class='tablesubheader' width='30%' align='left'><b></b></td> 
  <td class='tablesubheader' width='15%' align='center'><b></b></td>
 </tr>
<tr>
  <td class='tablerow1' align='left'><div class="ssh2"><img src="<?php echo $cimagesurl ?>album1584/<?php echo $row['image']; ?>.gif"></td></div>
  <td class='tablerow1' align='left'><font size="3pt"><?php echo $row['name']; ?></span></td></div>
  <td class='tablerow1' align='right'><font size="3pt"><?php echo $row['credits']; ?></font> <img src="<?php echo $siteurl ?>/web-gallery/v2/images/diamantes.png"></div></td>
  <td class='tablerow1' align='right'><a class="ssh" onclick="habboclub.buttonClick(<?php echo $row['id']; ?>,'Confirmar compra'); return false; "href="#" id="webstore-purchase-disabled"><font size="2pt" color="#444444">Comprar<i></i></a></td></font>



</td>
</tr>
</table>
</li>


<?php } ?>

</div>
</div>
</div>
</div>
</div></div>

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

<div class="habblet-container">        
<div class="cbb clearfix blue">
<h2 class="title"><font style="float: left; margin-left:3px">Teus Diamantes</font></h2>


<div class="habblet box-content">

<center>Olá <?php echo $name; ?>, tens um total de:</center>
<center><br><b style="font-size:15px;"><?php echo $myrow['crystals']; ?> Diamantes</b></br><br>
<img src="<?php echo $siteurl ?>/web-gallery/v2/images/diamantes2.png">
<center><br>Poderás conseguir diamantes trocando-os por 1 referido. 1 Referido = 2 diamantes</br></center>


</div>
</div></div>

<?php
$status = NULL;
if(isset($_POST['canjear'])){
$query = mysql_query("SELECT COUNT(id) AS aantalleden FROM users_referidos WHERE usuario ='".$name."' ORDER BY ID") or die(mysql_error());
$data = mysql_fetch_assoc($query);


if($data['aantalleden'] <= '0')
{
$status = '<div class="error" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Não tens nenhum referido.</div>';
}

elseif($data['aantalleden'] >= '1') {


mysql_query("UPDATE users_referidos SET usuario = '' WHERE usuario = '".$name."' LIMIT 1");



//dar creditos
$sql = "UPDATE users SET crystals = crystals  + '2' WHERE id = '".$my_id."'";
//echo $sql;
//exit;
mysql_query($sql);

$status = '<div class="goodmsg" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Você trocou 1 referido por 2 diamantes!</div>';
}

else
{
$status = '<div class="error" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Nao tens referidos suficientes</div>';
}

}

?>

<style>
.error {
padding: 7px;
background-color: #fff4f2;
border: 1px solid #a63c29;
color: #E2001A;
margin-top: 5px;
}

.error > h3 {
font-weight: Arial;
margin: 0px;
padding: 0px;
font-size: 13px;
}
div.goodmsg {
padding: 7px;
background-color: #d8f3d8;
border: 1px solid #4da04d;
color: #205220;
margin-top: 5px;
}

div.goodmsg > h3 {
font-weight: Arial;
margin: 0px;
padding: 0px;
font-size: 13px;
}
div.display_none {
display: none;
}
</style>

<div class="habblet-container">        
<div class="cbb clearfix green">
<h2 class="title"><font style="float: left; margin-left:3px">Consiga Diamantes!</font></h2>

</br>
<div align="center">

<b>Troca 1 referido por 2 Diamantes</b><br />
<br /> 
<center><img src="<?php echo $siteurl ?>/web-gallery/v2/images/referidos.png"></center>
                         <br />
                         <br />
<?php echo $status; ?>
                        </br>

<form method="post" action="">
<center><?php if(isset($my_id)) { echo '<input type="submit" value="Trocar" name="canjear" />'; } ?></center>
</form>
 </div>
                      </div>
 <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
</div>








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