Rare Values Script

[Invent]

Hi,

I know a few people on Habbo who want one of these, so I've decided to make a (quite) advanced Habbo Rare Values System.

The system will have all the basics you would imagine and it will be displayed in rows (like on Habbox).

If you have any ideas for the script, post them below.

Thanks!
Simon

P.S: I expect this to be done by the end of the week.

[GoldenMerc]

Hover over,
So the manager can choose what it says,E.g This was released in 2003
Will this be free(Hopes not)

[redtom]

POWERvalues!

Sorry had to say it, Goodluck, I think you'll do a great job.

[Invent]

POWERvalues!

Sorry had to say it, Goodluck, I think you'll do a great job.

Lol!

Hover over,
So the manager can choose what it says,E.g This was released in 2003
Will this be free(Hopes not)

I'll have a form which will be used for Hover text
And yes, it will be free and open source!

OH and should I code this in Classes or just regular PHP? What would people prefer (bearing in mind you may want to tweak the panel).

[GoldenMerc]

Please dont make it open source
It just ruins it :[
I enjoy buying products that people have to put money into

[craigg.]

I would use classes. Keep it classy! Ha! Get it?

It's a good thing you are releasing as opensource, gives others the opportunity to change the panel to suit their needs. I would still reserve some rights if I were you.

[Invent]

I would still reserve some rights if I were you.

Of course

[Invent]

Just started the script.

Just done part of the SQL class.

<?php
/**
 #######################################################################
 # Database Class - For use with RVS
 #######################################################################
 # @copyright    The original creator of this script (Invent!) reserves
 #                 the right to be able to cease any use of this panel by
 #                 anyone at any time. The copyright must also stay intact
 #                 on every page the panel uses.
 # @author       Invent!/Simon Fletcher
 # @version      1 (BETA)
 #######################################################################
**/ 

class db
{

    var $hostname;
    var $username;
    var $password;
    var $database;
    
    /**
    ### Connection function    
    ###        This is used to check if the script can connect to the server and database, if it can it runs the next function, if it cant it dies.
    **/
    
    function startConnection()
    {
    
        if(empty($this->hostname) || empty($this->username) || empty($this->database))
        {
        
            die("You have not defined the required connection variables, see the readme for information on how to define them.");
            exit;
            
        }
        else
        {
        
            $this->sqlConnect();
            
        }
    
    }
    
    /**
    ### SQL Connect function    
    ###        This is used to connect to the SQL Server and Database if the variables are set and specified.
    **/
    
    function sqlConnect()
    {
    
        $connect = mysql_pconnect($this->hostname, $this->username, $this->password) or die("RVS could not connect to the MySQL Server using the specified details, MySQL says: ".mysql_error());
        
        $select_db = mysql_select_db($this->database, $connect) or die("RVS could not tell MySQL to select the specified database, MySQL said: ".mysql_error());
        
    }
    
    /**
    ### Query function
    ###        This is used to run SQL Queries throughout the system.
    **/
    
    function query( $query )
    {
    
        $query_action = mysql_query( $query ) or die("Could not perform SQL Query (".$query."), MySQL Said: ".mysql_error());
        
        return $query_action;
    
    }    
    
    /**
    ### Fetch function
    ###        This is used to fetch information from a database by using a query variable.
    **/
    
    function fetch( $fetch, $assoc )
    {
    
        if($assoc == "yes")
        {
        
            ## Associative array
        
            $fetch_action = mysql_fetch_assoc( $fetch ) or die("Could not perform SQL Fetch, MySQL Said: ".mysql_error());
            
        }
        else
        {
        
            $fetch_action = mysql_fetch_array( $fetch ) or die("Could not perform SQL Fetch, MySQL Said: ".mysql_error());
            
        }
        
        return $fetch_action;
        
    }
    
    /**
    ### Num function
    ###        This is used to get the amount of rows in an SQL Table by using a query variable.
    **/
    
    function num( $num )
    {
    
        $num_action = mysql_num_rows( $num) or die("Could not number SQL Rows, SQL Said: ".mysql_error());
        
        return $num_action;
        
    }
    
}        
            
?>

!

[Blob]

Simon, why do you put spaces after your brackets?

[Invent]

I only use spaces in some circumstances, like in the bottom functions in the above Class.

I like using spaces as it makes variables more clearer which helps with debugging