hello just want to add a store of rare in cms from the sql?
for phoenix
$itemid = mysql_fetch_array(mysql_query("Select * from `items` order by id desc limit 1"));
$itmd = $itemid['id'] ;
mysql_query("Insert into items (id, user_id, base_item) VALUES ('".$itmd."', '".$my_id."', '".$valor."') ");
but to my emulator using different tables?
tables ...
items_users values are user_id and item_id
and the other table is
table items and values are item_id and base_id
code php
PHP Code:<?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');
$pagename = "Tienda de Rares Limitados";
$pageid = "25";
$all = "15000";
require_once('./templates/community_subheader.php');
require_once('./templates/community_header.php');
$status = NULL;
if(isset($_POST['compraa'])){
$user = $_POST['user'];
$my_id = $my_id;
$valor = $_POST['valor'];
$precio = $_POST['precio'];
$placa = $_POST['placa'];
$userid = $my_id;
$query = mysql_query("SELECT compra FROM tienda WHERE nombre ='".$placa."'") or die(mysql_error());
$dataa = mysql_fetch_assoc($query);
if($dataa['compra'] < '1')
{
$status = '<div class="error" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Ya no Queda ningun Rare</div>';
}else{
$query = mysql_query("SELECT credits FROM users WHERE username ='".$name."'") or die(mysql_error());
$data = mysql_fetch_assoc($query);
if($data['credits'] <= '1')
{
$status = '<div class="error" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">No tienes ningún Credito.</div>';
}
elseif($data['credits'] >= '15000') {
$row = mysql_fetch_array(mysql_query("SELECT credits FROM username WHERE id = '".$my_id."' LIMIT 1"));
{
mysql_query("UPDATE users SET credits = credits - 15000 WHERE id = '".$my_id."' LIMIT 1");
}
$itemid = mysql_fetch_array(mysql_query("Select * from `items` order by id desc limit 1"));
$itmd = $itemid['id'] ;
mysql_query("Insert into items (id, user_id, base_item) VALUES ('".$itmd."', '".$my_id."', '".$valor."') ");
//give pixels
$sql = "UPDATE tienda SET compra = compra - 1 WHERE nombre='".$placa."'";
//echo $sql;
//exit;
mysql_query($sql);
$status = '<div class="goodmsg" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Listo, Acabas De comprar Un Rare Limitado!</div>';
}
else
{
$status = '<div class="error" style="-moz-border-radius: 7px; -webkit-border-radius: 7px; padding: 10px;">Error Ocurrido</div>';
}
}
}
?>
<?php
$sql = "SELECT * FROM users WHERE username='".$name."'";
$result= mysql_query($sql);
$row = mysql_fetch_assoc($result);
$vip = $row['vip'];
?>
<style>
.error {
padding: 7px;
background-color: #fff4f2;
border: 1px solid #a63c29;
color: #E2001A;
margin-top: 5px;
}
.error > h3 {
font-weight: bold;
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: bold;
margin: 0px;
padding: 0px;
font-size: 13px;
}
div.display_none {
display: none;
}
</style>
<div id="container">
<div id="content">
<div id="column1" class="column">
<?php if($user_rank == 10 && $logged_in == true){ ?>
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Agrega Rares<span style="float: right; font-weight: normal; font-size: 75%;">(Solo Admins)</span></h2></h2>
<?php
if(isset($_POST['nuevo'])) {
$prc = strip_tags($_POST['prc']);
$nombre = strip_tags($_POST['nombre']);
$img = strip_tags($_POST['img']);
$totall = strip_tags($_POST['totall']);
$comprao = strip_tags($_POST['totall']);
$meter = [MENTION=1333341228]Mysql[/MENTION]_query('INSERT INTO tienda (tipo,imagen,nombre,compra,precio,valor,totales) values ("limi","'.$img.'","'.$nombre.'","'.$comprao.'","'.$prc.'","'.$nombre.'","'.$totall.'")');
$meterx = [MENTION=1333341228]Mysql[/MENTION]_query('INSERT INTO tienda_adm (autor,midm,placa) values ("'.$name.'","'.$my_id.'","'.$nombre.'")');
if($meter)
{
echo '<span style="color: green;">Listo, Se agrego Rare</span><hr>';
}else{
echo '<span style="color: red;">No se pudo insertar el rare<br /></span><hr>';
}
}
?>
<form method="post" action="" OnSubmit="return validar(this);">
<input type="hidden" value="<?php echo $my_id; ?>" name="my_id" />
<input type="hidden" value="<?php echo $name; ?>" name="name" />
ID del RARE: <input type="text" name="nombre" /><br />
Imagen del Rare: <input type="text" name="img" /><br />
Total de Rares: <input type="text" value="100" name="totall" /><br />
<input type="hidden" value="15000" name="prc" />
<input type="submit" name="nuevo" value="Agregar" />
</form>
<hr> Recuerda Que los rares que tu Agregues Serán al mismo tiempo Enviadas a una tabla en la que podremos ver los rares que Tu has Colocado!
</div></div>
<?php } ?>
<div class="habblet-container ">
<div class="cbb clearfix blue ">
<h2 class="title">Rares Limitados</h2></h2>
Los rares Limitados son de Gran utilidad, Estos solo salen una vez, Normalmente se sacan mas de 100,<img src="http://habbocreditfree.h.a.pic.centerblog.net/o/26cb9b62.png" align="right">
De este modo el Hotel podrá ver la cantidad existente y podra su precio subir o bajar. Normalmente se sacaran Rares Customs o Mega Rares.</center>
</div>
</div>
<div class="habblet-container ">
<div class="cbb clearfix orange ">
<h2 class="title"><span style="float: left;">Lista de Rares</span> <span style="float: right; font-weight: normal; font-size: 75%;">(<?php echo mysql_evaluate("SELECT COUNT(*) FROM tienda WHERE tipo = 'limi'"); ?> disponibles)</span></h2>
<center><b><?php echo $status; ?></B></center>
<div style="height:330px;overflow:auto;width:99.5%;">
<?php
$hoteles = mysql_query("SELECT * FROM tienda WHERE tipo='limi' ORDER BY id DESC");
while($hotel=mysql_fetch_array($hoteles)){
?>
<?php
$i ;
if(IsEven($i)){
$even = "#e6e6e6";
} else {
$even = "#ffffff";
}
?>
<div style="width:100%;height:100px;padding-top:10px;background-color:<?php echo $even ?>;">
<table cellspacing="0" cellpadding="0" style="width:100%;">
<tr>
<td style="padding-left:20px;"><img src="<?php echo $hotel['imagen']; ?>"></td>
<td><b style="font-size:15px;"><?php echo $all; ?> Creditos </b><br><b style="font-size:9px;"><?php echo $hotel['compra']; ?> Restantes | <?php echo $hotel['totales']; ?> Totales </b></td>
<td><div style="margin-top:15px;margin-right:20px;" align="right" class="redeem-redeeming-button">
<form method="post" action="">
<input type="hidden" value="<?php echo $my_id; ?>" name="my_id" />
<input type="hidden" value="<?php echo $name; ?>" name="user" />
<input type="hidden" value="<?php echo $hotel['precio']; ?>" name="precio" />
<input type="hidden" value="<?php echo $hotel['nombre']; ?>" name="placa" />
<input type="hidden" value="<?php echo $hotel['valor']; ?>" name="valor" />
<center>
<?php
session_start();
$sql = "SELECT compra FROM tienda";
$result= mysql_query($sql);
$row = mysql_fetch_assoc($result);
$compra = $row['compra'];
?>
<?php if($hotel['compra'] > 0 && $logged_in == true){ ?>
<input type="submit" name="compraa" a onclick="javascript: question=confirm('¿Estás seguro de comprar este rare?');if (question !='0'){document.NOMBREDELFORM.submit()};return false;" href="javascript:void();" value="Comprar Ahora" />
<?php } ?>
<?php if($hotel['compra'] < 1 && $logged_in == true){ ?>
<span style="color: red;">Agotado </span>
<?php } ?>
</form>
</div>
</td>
</tr>
</table>
</div>
<?php
}
?>
</div></div></div>
</div>
<div id="column2" class="column">
<div class="habblet-container">
<div class="cbb clearfix green">
<h2 class="title">Saldo</h2>
<div class="habblet box-content">
<p>
<img src="http://3.bp.blogspot.com/__btg8VfR57Y/Snt86kZXdsI/AAAAAAAAAAc/Weaqya6JDS4/s320/habbo_purse_big_64.gif" align="right">
Hasta los momentos posees un saldo de: <h3>
<?php echo $myrow['credits']; ?> Creditos
</h3>
Esto puedes canjearlo en cualquier parte de nuestra tienda.
<hr >
</div></div></div>
<style>
.error {
padding: 7px;
background-color: #fff4f2;
border: 1px solid #a63c29;
color: #E2001A;
margin-top: 5px;
}
.error > h3 {
font-weight: bold;
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: bold;
margin: 0px;
padding: 0px;
font-size: 13px;
}
div.display_none {
display: none;
}
</style>
</div></div>
</div></div>
<script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script>
<?php require_once('./templates/community_footer.php'); ?>
anyone can help me please?
Reply With Quote
