Hey again guys,
As Phoenix is still not using an SWF that allows you to buy LTD Rares from inside of the client, I decided to create a little LTD Script that you can set up on your homepage :)
Its mainly compatible with UberCMS, and with a little editing, it should work great on other CMS's too.
This script lets you add an LTD Rare, and then put it on sale, and let people buy it via your homepage.
Example: 
PHP :
PHP Code:
<div class="limited-edition">
<?php
$getRare = dbquery("SELECT * FROM rares ORDER BY timestamp DESC LIMIT 1");
$rare = mysql_fetch_assoc($getRare);
$getUser = dbquery("SELECT * FROM users WHERE id = '".USER_ID."' LIMIT 1");
$user = mysql_fetch_assoc($getUser);
if(isset($_POST['submit'])){
if($user['credits'] >= $rare['credits'] AND $user['vip_points'] >= $rare['vip_points'] AND $rare['amount'] >= 1){
dbquery("UPDATE rares SET amount = amount - 1 WHERE id = '".$rare['id']."'");
dbquery("UPDATE users SET credits = credits - ".$rare['credits'].", vip_points = vip_points - ".$rare['vip_points']." WHERE id = '".USER_ID."'");
$item = $rare['item_ids'];
$page = $rare['page_id'];
$core->Mus( 'giveitem', USER_ID . ' '.$item.' '.$page.' Enjoy your Limited Edition furni! Keep checking for more Limited Edition furnis!');
$core->Mus( 'updatepoints', USER_ID );
$core->Mus( 'updatecredits', USER_ID );
header("Location: ".WWW."/client");
}
}
echo'
<div class="image" style="background:url(\''.$rare['image'].'\') no-repeat;background-position:center center;"></div>
<div class="details">
<div class="header"></div>
<span class="item-name"><b>'.$rare['name'].'</b> '.$rare['caption'].'</span>
<span class="item-desc">Amount available: <b>'.$rare['amount'].'</b>
<BR>Price:<b>';
if($rare['credits'] >= 1 & $rare['vip_points'] >= 1){
echo' '.$rare['credits'].' credits + '.$rare['vip_points'].' shells ';
}
elseif($rare['credits'] >= 1 & $rare['vip_points'] == 0) {
echo' '.$rare['credits'].' credits ';
}
elseif($rare['credits'] == 0 & $rare['vip_points'] >= 1) {
echo' '.$rare['vip_points'].' shells ';
}
elseif($rare['credits'] == 0 & $rare['vip_points'] == 0) {
echo' Free! ';
}
echo '</b></span>';
if($rare['amount'] >= 1 & $user['credits'] >= $rare['credits'] & $user['vip_points'] >= $rare['vip_points']) {
echo' <form method="post"><input type="submit" name="submit" value="Buy" /></form> ';
}
elseif($rare['amount'] >= 1 & $user['credits'] < $rare['credits']) {
echo' <input type="submit" name="currency" value="Not enough credits!" /> ';
}
elseif($rare['amount'] >= 1 & $user['vip_points'] < $rare['vip_points']) {
echo' <input type="submit" name="currency" value="Not enough shells!" /> ';
}
elseif($rare['amount'] == 0) {
echo'<input type="submit" name="none" value="Sold Out!" />';
}
echo'</div>';
?>
</div>
SQL:
PHP Code:
CREATE TABLE IF NOT EXISTS `rares` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`item_ids` int(120) NOT NULL,
`page_id` int(120) NOT NULL,
`name` varchar(100) NOT NULL,
`caption` varchar(150) NOT NULL,
`amount` int(10) NOT NULL,
`credits` int(10) NOT NULL DEFAULT '0',
`vip_points` int(10) NOT NULL DEFAULT '0',
`image` varchar(500) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
I think it needs a little bit of re-coding considering I created this script when I was still in the process of getting a grip of PHP (which was a few months ago).
There is also no style sheet associated with the script, so you will need to design the look and feel of it.
This script is also compatible with Phoenix, as once you "buy" the furni, it will update your credits/pixels/shells and also automatically insert the item into your Inventory using MUS.
At the time of coding this, I tried to make it as flexible as possible, meaning that you are able to pick the currency the LTD is - credits / pixels / shells. If you want an image of the LTD Rare to display, you will need to save the image in your directory, and in the "image" area of the "rares" table, the link to the image will go there.
If you have any questions about this release, feel free to ask. I'll try to help you as best as possible.
Like + Rep if you like this release 
Thanks
- Nicholas
LTD Script [CROSS-COMPATIBLE][PHOENIX]
![LTD Script [CROSS-COMPATIBLE][PHOENIX]](http://ragezone.com/hyper728.png)
Originally Posted by Weytin
