Points shop ~ ubercms *must read*

[JaydenC]

This cute little release is an A example if great thinking hehe
What the fuc* is this shizzle?
Well, it will replace ALL the paypal items and scripts by using a new currency. Points! The table already exists with no use whatsoever. But now you can change that! Essentially what this is, you can buy a amount of points and buy stuff like credits, pixels and even VIP (So you don't have to work your ass off coding a IPN).
This has made me alot of $$$ on my hotel and I know thats what you want. It is just more complex for the users to buy 1 item with paypal then several.

**HOW DO I INSTALL THIS**

Okay, start by opening the ZIP folder.
Now copy + paste the whole thing into your htdocs.
If there is any replace issues just replace the files.
Now run this sexy SQL code

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 19, 2012 at 04:58 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `sulakeh`
--

-- --------------------------------------------------------

--
-- Table structure for table `cred_shop`
--

CREATE TABLE IF NOT EXISTS `cred_shop` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `badge_id` varchar(12) NOT NULL,
  `cost` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `cred_shop`
--

INSERT INTO `cred_shop` (`id`, `badge_id`, `cost`) VALUES
(1, '5000', 20),
(2, '100000', 100),
(3, '500000', 250),
(4, '750000', 500),
(6, '1000000', 1000),
(7, '10000000', 1250);

-- --------------------------------------------------------

--
-- Table structure for table `pixell_shop`
--

CREATE TABLE IF NOT EXISTS `pixell_shop` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `badge_id` varchar(13) NOT NULL,
  `cost` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=124 ;

--
-- Dumping data for table `pixell_shop`
--

INSERT INTO `pixell_shop` (`id`, `badge_id`, `cost`) VALUES
(1, '1000', 5),
(2, '2000', 10),
(3, '3000', 15),
(4, '4000', 20),
(6, '5000', 30),
(12, '10000', 70),
(123, '50000', 350);

-- --------------------------------------------------------

--
-- Table structure for table `site_navi`
--

CREATE TABLE IF NOT EXISTS `site_navi` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order_id` int(11) NOT NULL,
  `caption` text NOT NULL,
  `class` text NOT NULL,
  `url` text NOT NULL,
  `visibility` enum('0','1','2','3') NOT NULL COMMENT '0 = Never, 1 = Always, 2 = Logged in only, 3 = Guests only',
  PRIMARY KEY (`id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=123124 ;

--
-- Dumping data for table `site_navi`
--

INSERT INTO `site_navi` (`id`, `parent_id`, `order_id`, `caption`, `class`, `url`, `visibility`) VALUES
(14, 0, 4, 'Points shop (%vipbalance%)', 'viptab', '%www%/badgeshop.php', '2'),
(19, 14, 2, 'Badge shop', '', '%www%/badgeshop.php', '2'),
(20, 14, 1, 'Shop home', '', '%www%/shop.php', '2'),
(21, 14, 3, 'Buy credits', '', '%www%/creditsshop.php', '2'),
(22, 14, 4, 'Buy pixels', '', '%www%/pixelshop.php', '2'),
(25, 14, 6, 'Buy V.I.P', '', '%www%/vip-shop.php', '2');

-- --------------------------------------------------------

--
-- Table structure for table `vip_shop`
--

CREATE TABLE IF NOT EXISTS `vip_shop` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `badge_id` varchar(6) NOT NULL,
  `cost` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `vip_shop`
--

INSERT INTO `vip_shop` (`id`, `badge_id`, `cost`) VALUES
(3, 'VIP', 750); 

Your finished the uploading!
**TWEAKS**
On my hotel it has it so you automaticly get points on register.
Go into your database, click on users!
Now click structure.
Find "vip_points" and click the pencil icon.
Change the 'default' value from 0 to whatever you want your amount of register points to be.
If you want to change the prices go into your DB and edit them.

MUST READ
This was all based off of jontys badge shop.
So, credits!
Me - 10%
Jonteh - 90%

DOWNLOAD MEEHHHH!

If you like it, like it

Someone upload screenies and mirrors pls <3

Coming in V2 - I will allow the you too add points from the userlookup in houskeeping - api with points. By the way, on the front page where you buy the points, replace that with your own paypal form. Someone link to a tut or something

[MentaL]

[Poizone2]

Wow this looks good.. thanks for this going to test it out now :D

[JaydenC]

SCREENIES :

[Jam32]

That looks pretty sweet :O

Good job (y)

[JaydenC]

Thanks for postitive feedback guys ;3

[Aaron]

Create a Paypal IPN automatic check out now.
It'd be the ideal package to have. =P

[zMatty]

Is very very interesting

[JaydenC]

Create a Paypal IPN automatic check out now.
It'd be the ideal package to have. =P

Working on it!

[DarkoroDragon]

ASDF - Login and Buzz: And so it begins... have pretty much this exact thing already but we call it "Tokens", combined with Paypal IPN so its all automatic :) also includes custom rooms available to purchase.

I'd just like to note, we did it first and buzz "Stole with permission" ^.^

However for us, we have a furniture item that represents tokens, so that they can be traded on the hotel, called token bars. Users buy tokens with paypal or onebip (only paypal is automatic at the moment) and then they can go on the website and purchase token bars, or redeem them through the website too.

Our tokens allow users to purchase VIP, Coins, Badges and Custom room layouts through the website. We are also looking to add a build-a-badge type thing, although my co-owner adam got stuck at the image-merging side of it >.<

Our tokens system works, so I dont see why a points system shouldnt seeing as its the same thing, pretty much.

[Poizone2]

How do you award people points? I'm a bit confused on this point system thing :/

[JaydenC]

I'd just like to note, we did it first and buzz "Stole with permission" ^.^

However for us, we have a furniture item that represents tokens, so that they can be traded on the hotel, called token bars. Users buy tokens with paypal or onebip (only paypal is automatic at the moment) and then they can go on the website and purchase token bars, or redeem them through the website too.

Our tokens allow users to purchase VIP, Coins, Badges and Custom room layouts through the website. We are also looking to add a build-a-badge type thing, although my co-owner adam got stuck at the image-merging side of it >.<

Our tokens system works, so I dont see why a points system shouldnt seeing as its the same thing, pretty much.

I didn't steal your idea kid, I have had this on my hotel for 4 months. Before you rudley go accusing people of 'stealing' your idea how do you suggeset i got your idea? trail of thought? I would never go near your ugly hotel nor would I steal stupid ideas you have on there from it. So shut up, And even if someone 'stole' the idea, i released it first so yeah

[DarkoroDragon]

I didn't steal your idea kid, I have had this on my hotel for 4 months. Before you rudley go accusing people of 'stealing' your idea how do you suggeset i got your idea? trail of thought? I would never go near your ugly hotel nor would I steal stupid ideas you have on there from it. So shut up, And even if someone 'stole' the idea, i released it first so yeah

I wasnt talking about YOU stealing it, I was talking about Buzz hotel. And even then, it was a joke because I know the owner of Buzz hotel well, and I gave him permission. I only said "Stealing with permission" because he went onto my side of the shared dedi and got the code himself. So before you "rudely" go accusing me of "rudely" accusing you of stealing, learn to read posts.

And as for the kid remark, I'm 19. Even if I'm younger than you, I aint no kid.

What I said in relation to this post is that we have a similar system to your points system called tokens, and that Buzz hotel got it from us.

How do you award people points? I'm a bit confused on this point system thing :/

Although our tokens system is slightly different to Habbro's points system, we award our users with tokens a) automatically through paypal b) via the in-game furniture item that represents the tokens (staff catalogue for 5c each). These are redeemed on our website with a handy piece of php code. Im not sure how Habbro's points system would handle the awarding of points, however.

[Jonteh]

Force Hotel was actually the first hotel to implement this system, and I took the idea and implemented points into Zap, which are now removed FYI.

I haven't downloaded the script, but i hope it's secure and I hope lots of people use it, looks nice enough =D
Thanks for the credits btw.

Also Darkoro, Buzz Hotel is filled with those that aren't welcome anywhere else ;)

Oh, also, if you want, feel free to modify my newest badge shop script, it's secure + looks a lot nicer but you might want to tweak how it works a bit if you feel so.

90% of the people that see this code & put it on their hotel won't include credits.

<?php

$getSettings = dbquery("SELECT * FROM users WHERE username = '" . USER_NAME . "'");
$userAccount = mysql_fetch_assoc($getSettings);

$checkUserBadges = dbquery("SELECT * FROM user_badges WHERE user_id = '" . USER_ID . "'");
$userBadges = mysql_fetch_assoc($checkUserBadges);

$getBadges = dbquery("SELECT * FROM badge_shop");

    if(isset($_POST["BUY_BADGE"]))
    {
        $badge_id = filter($_POST["lolcats"]);
        $user_creds = $userAccount["credits"];
        if (mysql_num_rows(mysql_query("SELECT * FROM badge_shop WHERE badge_id = '" . $badge_id . "'")))
        {
            $getPrice = mysql_result(mysql_query("SELECT cost FROM badge_shop WHERE badge_id = '" . $badge_id . "'"), 0);
            
            if($user_creds < $getPrice)
            {
                header("Location: badgeshop.php?err=bal");
            }
            elseif($user_creds > $getPrice)
            {
                if(mysql_result(mysql_query("SELECT `online` FROM `users` WHERE `id` = '" . USER_ID . "'"), 0) == 1)
                {
                    Header("Location: badgeshop.php");
                }
            
                dbquery("INSERT INTO user_badges (user_id, badge_id, badge_slot) VALUES ('" . USER_ID . "', '" . $badge_id . "', '0')");
                dbquery("UPDATE users SET credits = credits - '" . $getPrice . "' WHERE id = '" . USER_ID . "'");
            
                $_SESSION["badge"] = $badge_id;
                Header("Location: badgeshop.php?bought=" . $_SESSION["badge"] . "");
            }
        }    
    }
?>
<div class="habblet-container ">        
<div class="cbb clearfix red "> 

<h2 class="title">Badge Shop</h2>
<center>

You have <b><?php echo number_format($userAccount["credits"]); ?> coins</b> to spend<br>
<?php
if($userAccount["online"] == 1 && USER_ID != 1)
{
    echo "<b><font color='darkred'><h3>Stop! It seems you're currently logged into the hotel.<br />Please close your client to continue.</b></font></h3>";
}
elseif(isset($_GET["err"]) && $_GET["err"] == "bal")
{
    echo "<b><font color='darkred'><h3>Aha! It seems you don't have the right amount of coins.<br />That sucks, but you can always <a href='badgeshop.php'>return to the shop</a>.</b></font></h3>";
}
elseif(isset($_GET["bought"]))
{
    if(!isset($_SESSION["badge"])) { header("Location: badgeshop.php"); }
    
    unset($_SESSION["badge"]);
    
    $bought = filter($_GET["bought"]);
    echo "<img src='c_images/album1584/" . $bought . ".gif'><br />Badge purchased, <a href='badgeshop.php'>continue shopping</a>.";
}
else
{ 
        echo '<table border="0">';
    while($badgeShit = mysql_fetch_assoc($getBadges))
    {
        echo '
            <tr>
            <td align="center"><img src="./c_images/album1584/' . $badgeShit['badge_id'] . '.gif"> </td>
            <td>This badge costs <b>' . number_format($badgeShit['cost']) . ' credits</b>. <form method="post"><input type="submit" value="Buy" name="BUY_BADGE"><input type="hidden" value="' . $badgeShit['badge_id'] . '" name="lolcats"></form></td>
            </tr>';
    } 
        echo '</table> <br /><br /><font size="1">Script by Jonteh</font>';
}
?>
</center>
</div></div>

[owen212]

Gave myself points and when I go to buy coins or pixels, it says i got 0 points, if I go to badgeshop I have my points

[JaydenC]

Force Hotel was actually the first hotel to implement this system, and I took the idea and implemented points into Zap, which are now removed FYI.

I haven't downloaded the script, but i hope it's secure and I hope lots of people use it, looks nice enough =D
Thanks for the credits btw.

Also Darkoro, Buzz Hotel is filled with those that aren't welcome anywhere else ;)

Oh, also, if you want, feel free to modify my newest badge shop script, it's secure + looks a lot nicer but you might want to tweak how it works a bit if you feel so.

90% of the people that see this code & put it on their hotel won't include credits.

<?php

$getSettings = dbquery("SELECT * FROM users WHERE username = '" . USER_NAME . "'");
$userAccount = mysql_fetch_assoc($getSettings);

$checkUserBadges = dbquery("SELECT * FROM user_badges WHERE user_id = '" . USER_ID . "'");
$userBadges = mysql_fetch_assoc($checkUserBadges);

$getBadges = dbquery("SELECT * FROM badge_shop");

    if(isset($_POST["BUY_BADGE"]))
    {
        $badge_id = filter($_POST["lolcats"]);
        $user_creds = $userAccount["credits"];
        if (mysql_num_rows(mysql_query("SELECT * FROM badge_shop WHERE badge_id = '" . $badge_id . "'")))
        {
            $getPrice = mysql_result(mysql_query("SELECT cost FROM badge_shop WHERE badge_id = '" . $badge_id . "'"), 0);
            
            if($user_creds < $getPrice)
            {
                header("Location: badgeshop.php?err=bal");
            }
            elseif($user_creds > $getPrice)
            {
                if(mysql_result(mysql_query("SELECT `online` FROM `users` WHERE `id` = '" . USER_ID . "'"), 0) == 1)
                {
                    Header("Location: badgeshop.php");
                }
            
                dbquery("INSERT INTO user_badges (user_id, badge_id, badge_slot) VALUES ('" . USER_ID . "', '" . $badge_id . "', '0')");
                dbquery("UPDATE users SET credits = credits - '" . $getPrice . "' WHERE id = '" . USER_ID . "'");
            
                $_SESSION["badge"] = $badge_id;
                Header("Location: badgeshop.php?bought=" . $_SESSION["badge"] . "");
            }
        }    
    }
?>
<div class="habblet-container ">        
<div class="cbb clearfix red "> 

<h2 class="title">Badge Shop</h2>
<center>

You have <b><?php echo number_format($userAccount["credits"]); ?> coins</b> to spend<br>
<?php
if($userAccount["online"] == 1 && USER_ID != 1)
{
    echo "<b><font color='darkred'><h3>Stop! It seems you're currently logged into the hotel.<br />Please close your client to continue.</b></font></h3>";
}
elseif(isset($_GET["err"]) && $_GET["err"] == "bal")
{
    echo "<b><font color='darkred'><h3>Aha! It seems you don't have the right amount of coins.<br />That sucks, but you can always <a href='badgeshop.php'>return to the shop</a>.</b></font></h3>";
}
elseif(isset($_GET["bought"]))
{
    if(!isset($_SESSION["badge"])) { header("Location: badgeshop.php"); }
    
    unset($_SESSION["badge"]);
    
    $bought = filter($_GET["bought"]);
    echo "<img src='c_images/album1584/" . $bought . ".gif'><br />Badge purchased, <a href='badgeshop.php'>continue shopping</a>.";
}
else
{ 
        echo '<table border="0">';
    while($badgeShit = mysql_fetch_assoc($getBadges))
    {
        echo '
            <tr>
            <td align="center"><img src="./c_images/album1584/' . $badgeShit['badge_id'] . '.gif"> </td>
            <td>This badge costs <b>' . number_format($badgeShit['cost']) . ' credits</b>. <form method="post"><input type="submit" value="Buy" name="BUY_BADGE"><input type="hidden" value="' . $badgeShit['badge_id'] . '" name="lolcats"></form></td>
            </tr>';
    } 
        echo '</table> <br /><br /><font size="1">Script by Jonteh</font>';
}
?>
</center>
</div></div>

Great script, and no problem. I have your credis on my site!

[Jake7383]

Thanks my hotel needs this. We are hamachi (when opens) and we are going to use this. So VIP T-Mod, Point Shop, Donations we should get VPS Very soon (: thanks

[Fearhotel]

Great released
I had too fix up a few things but other thing that nice,
I Coded a IPN for it so it's all auto The user getting the points
them buying the items with out Database errors and so on,
I'm currently Coding a Rare shop for the system, And so on :)
10/10

[Jake7383]

Great released
I had too fix up a few things but other thing that nice,
I Coded a IPN for it so it's all auto The user getting the points
them buying the items with out Database errors and so on,
I'm currently Coding a Rare shop for the system, And so on :)
10/10

Could you release that?

[Identified]

do have release this system for revCMS?

[JaydenC]

do have release this system for revCMS?

I will never code for revCMS.

[Identified]

I will never code for revCMS.

Why not?