Installer not working

Ob4j4 · November 26, 2022

The mccodes installer does not work for me. I keep getting errors after errors about deprecated code. Does someone a working version of the installer and its related files

orsino · November 26, 2022

hi there

what errors do you get ?

what version of mccodes do you get ?

what is your php version and so on please give us more so we can help you

lucky3809 · November 26, 2022

If it's deprecated, you need to update the coding, because it's no longer valid with the PHP version your host/server is using.

Ob4j4 · November 26, 2022

I'm using Xampp. The error I get is

Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in C:\xampp\htdocs\installer.php:289 Stack trace: #0 C:\xampp\htdocs\installer.php(303): gpc_cleanup('[email protected]') #1 C:\xampp\htdocs\installer.php(46): install() #2 {main} thrown in C:\xampp\htdocs\installer.php on line 289

When I remove that function and anywhere where its mentioned in the installer file, I get further errors

Veramys · November 26, 2022

I'm not sure how updated the version of mccodes Dave sells on here but I know that from the old mccodes website the code will not work on later version of php without some serious updating.

Ob4j4 · November 26, 2022

I only have a license on mccodes.com

Veramys · November 26, 2022

4 minutes ago, Ob4j4 said:

I only have a license on mccodes.com

Yep that means it's older code and it won't work stock on later php versions

Ob4j4 · November 26, 2022

So what do I do here?

Veramys · November 26, 2022

Learn to code or buy the fresh copy of mccodes on here.

Ob4j4 · November 26, 2022

You have to rebuy a license?

Veramys · November 26, 2022

As far as I'm aware the mccodes license is not transferable so yes you'd need to buy the copy from makewebgames instead. You'd have to talk to @Daveabout that though.

Ob4j4 · November 26, 2022

That's ridiculous

Uridium · November 26, 2022

ob4J4 can you lower your php version from your host usually 5.6

Veramys · November 26, 2022

1 minute ago, Uridium said:

ob4J4 can you lower your php version from your host usually 5.6

They're running a xampp server on localhost so they'll need to download an older version of php

KyleMassacre · November 26, 2022

2 hours ago, Ob4j4 said:
I'm using Xampp. The error I get is

Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in C:\xampp\htdocs\installer.php:289 Stack trace: #0 C:\xampp\htdocs\installer.php(303): gpc_cleanup('[email protected]') #1 C:\xampp\htdocs\installer.php(46): install() #2 {main} thrown in C:\xampp\htdocs\installer.php on line 289
Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc() in C:\xampp\htdocs\installer.php:289 Stack trace: #0 C:\xampp\htdocs\installer.php(303): gpc_cleanup('[email protected]') #1 C:\xampp\htdocs\installer.php(46): install() #2 {main} thrown in C:\xampp\htdocs\installer.php on line 289
When I remove that function and anywhere where its mentioned in the installer file, I get further errors

What errors do you get when you remove that function? That function has been deprecated since php 5.4 or so

Ob4j4 · November 27, 2022

installer

<?php
/**
 * MCCodes Version 2.0.5b
 * Copyright (C) 2005-2012 Dabomstew
 * All rights reserved.
 *
 * Redistribution of this code in any form is prohibited, except in
 * the specific cases set out in the MCCodes Customer License.
 *
 * This code license may be used to run one (1) game.
 * A game is defined as the set of users and other game database data,
 * so you are permitted to create alternative clients for your game.
 *
 * If you did not obtain this code from MCCodes.com, you are in all likelihood
 * using it illegally. Please contact MCCodes to discuss licensing options
 * in this case.
 *
 * File: installer.php
 * Signature: 54bc6a599c341bbb61a8ec498fa78f68
 * Date: Fri, 20 Apr 12 08:50:30 +0000
 */

if (file_exists('./installer.lock'))
{
    exit;
}
define('MONO_ON', 1);
session_name('MCCSID');
session_start();
if (!isset($_SESSION['started']))
{
    session_regenerate_id();
    $_SESSION['started'] = true;
}
require_once('installer_head.php');
require_once('global_func.php');
require_once('lib/installer_error_handler.php');
set_error_handler('error_php');
if (!isset($_GET['code']))
{
    $_GET['code'] = '';
}
switch ($_GET['code'])
{
case "install":
    install();
    break;
case "config":
    config();
    break;
default:
    diagnostics();
    break;
}

function menuprint($highlight)
{
    $items =
            array('diag' => '1. Diagnostics', 'input' => '2. Configuration',
                    'sql' => '3. Installation & Extras',);
    $c = 0;
    echo "<hr />";
    foreach ($items as $k => $v)
    {
        $c++;
        if ($c > 1)
        {
            echo ' >> ';
        }
        if ($k == $highlight)
        {
            echo '<span style="color: black;">' . $v . '</span>';
        }
        else
        {
            echo '<span style="color: gray;">' . $v . '</span>';
        }
    }
    echo '<hr />';
}

function diagnostics()
{
    menuprint("diag");
    if (version_compare(phpversion(), '5.2.0') < 0)
    {
        $pv = '<span style="color: red">Failed</span>';
        $pvf = 0;
    }
    else
    {
        $pv = '<span style="color: green">OK</span>';
        $pvf = 1;
    }
    if (is_writable('./'))
    {
        $wv = '<span style="color: green">OK</span>';
        $wvf = 1;
    }
    else
    {
        $wv = '<span style="color: red">Failed</span>';
        $wvf = 0;
    }
    if (function_exists('mysql_connect') || function_exists('mysqli_connect'))
    {
        $dv = '<span style="color: green">OK</span>';
        $dvf = 1;
    }
    else
    {
        $dv = '<span style="color: red">Failed</span>';
        $dvf = 0;
    }
    echo "
    <h3>Basic Diagnostic Results:</h3>
    <table width='80%' class='table' cellspacing='1' cellpadding='1' align='center'>
    		<tr>
    			<td>PHP version >= 5.2.0</td>
    			<td>{$pv}</td>
    		</tr>
    		<tr>
    			<td>Game folder writable</td>
    			<td>{$wv}</td>
    		</tr>
    		<tr>
    			<td>MySQL support in PHP present</td>
    			<td>{$dv}</td>
    		</tr>
    		<tr>
    			<td>MCCodes up to date</td>
    			<td>
        			<iframe
        				src='http://www.mccodes.com/update_check.php?version=20503'
        				width='250' height='30'></iframe>
        		</td>
        	</tr>
    </table>
       ";
    if ($pvf + $wvf + $dvf < 3)
    {
        echo "
		<hr />
		<span style='color: red; font-weight: bold;'>
		One of the basic diagnostics failed, so Setup cannot continue.
		Please fix the ones that failed and try again.
		</span>
		<hr />
   		";
    }
    else
    {
        echo "
		<hr />
		&gt; <a href='installer.php?code=config'>Next Step</a>
		<hr />
   		";
    }
}

function config()
{
    menuprint("input");
    echo "
    <h3>Configuration:</h3>
    <form action='installer.php?code=install' method='post'>
    <table width='75%' class='table' cellspacing='1' cellpadding='1' align='center'>
    		<tr>
    			<th colspan='2'>Database Config</th>
    		</tr>
    		<tr>
    			<td align='center'>MySQL Driver</td>
    			<td>
    				<select name='driver' type='dropdown'>
       ";
    if (function_exists('mysql_connect'))
    {
        echo '<option value="mysql">MySQL Standard</option>';
    }
    if (function_exists('mysqli_connect'))
    {
        echo '<option value="mysqli">MySQLi Enhanced</option>';
    }
    echo "
    				</select>
    			</td>
    		</tr>
    		<tr>
    			<td align='center'>
    				Hostname<br />
    				<small>This is usually localhost</small>
    			</td>
    			<td><input type='text' name='hostname' value='localhost' /></td>
    		</tr>
    		<tr>
    			<td align='center'>
    				Username<br />
    				<small>The user must be able to use the database</small>
    			</td>
    			<td><input type='text' name='username' value='' /></td>
    		</tr>
    		<tr>
    			<td align='center'>Password</td>
    			<td><input type='text' name='password' value='' /></td>
    		</tr>
    		<tr>
    			<td align='center'>
    				Database Name<br />
    				<small>The database should not have any other software using it.</small>
    			</td>
    			<td><input type='text' name='database' value='' /></td>
    		</tr>
    		<tr>
    			<th colspan='2'>Game Config</th>
    		</tr>
    		<tr>
    			<td align='center'>Game Name</td>
    			<td><input type='text' name='game_name' /></td>
    		</tr>
    		<tr>
    			<td align='center'>
    				Game Owner<br />
    				<small>This can be your nick, real name, or a company</small>
    			</td>
    			<td><input type='text' name='game_owner' /></td>
    		</tr>
    		<tr>
    			<td align='center'>
    				Game Description<br />
    				<small>This is shown on the login page.</small>
    			</td>
    			<td><textarea rows='6' cols='40' name='game_description'></textarea></td>
    		</tr>
    		<tr>
    			<td align='center'>
    				PayPal Address<br />
    				<small>This is where the payments for game DPs go. Must be at least Premier.</small>
    			</td>
    			<td><input type='text' name='paypal' /></td>
    		</tr>
    		<tr>
    			<th colspan='2'>Admin User</th>
    		</tr>
    		<tr>
    			<td align='center'>Username</td>
    			<td><input type='text' name='a_username' /></td>
    		</tr>
    		<tr>
    			<td align='center'>Password</td>
    			<td><input type='password' name='a_password' /></td>
    		</tr>
    		<tr>
    			<td align='center'>Confirm Password</td>
    			<td><input type='password' name='a_cpassword' /></td>
    		</tr>
    		<tr>
    			<td align='center'>E-Mail</td>
    			<td><input type='text' name='a_email' /></td>
    		</tr>
    		<tr>
    			<td align='center'>Gender</td>
    			<td>
    				<select name='gender' type='dropdown'>
    					<option value='Male'>Male</option>
    					<option value='Female'>Female</option>
    				</select>
    			</td>
    		</tr>
    		<tr>
    			<td colspan='2' align='center'>
    				<input type='submit' value='Install' />
    			</td>
    		</tr>
    </table>
    </form>
       ";
}
if (!function_exists('get_magic_quotes_gpc'))
{

    function get_magic_quotes_gpc()
    {
        return 0;
    }
}

function gpc_cleanup($text)
{
    if (get_magic_quotes_gpc())
    {
        return stripslashes($text);
    }
    return $text;
}

function install()
{
    menuprint('sql');
    $paypal =
            (isset($_POST['paypal'])
                    && filter_input(INPUT_POST, 'paypal',
                            FILTER_VALIDATE_EMAIL))
                    ? gpc_cleanup($_POST['paypal']) : '';
    $adm_email =
            (isset($_POST['a_email'])
                    && filter_input(INPUT_POST, 'a_email',
                            FILTER_VALIDATE_EMAIL))
                    ? gpc_cleanup($_POST['a_email']) : '';
    $adm_username =
            (isset($_POST['a_username']) && strlen($_POST['a_username']) > 3)
                    ? gpc_cleanup($_POST['a_username']) : '';
    $adm_gender =
            (isset($_POST['gender'])
                    && in_array($_POST['gender'], array('Male', 'Female'),
                            true)) ? $_POST['gender'] : 'Male';
    $description =
            (isset($_POST['game_description']))
                    ? gpc_cleanup($_POST['game_description']) : '';
    $owner =
            (isset($_POST['game_owner']) && strlen($_POST['game_owner']) > 3)
                    ? gpc_cleanup($_POST['game_owner']) : '';
    $game_name =
            (isset($_POST['game_name'])) ? gpc_cleanup($_POST['game_name'])
                    : '';
    $adm_pswd =
            (isset($_POST['a_password']) && strlen($_POST['a_password']) > 3)
                    ? gpc_cleanup($_POST['a_password']) : '';
    $adm_cpswd =
            isset($_POST['a_cpassword']) ? gpc_cleanup($_POST['a_cpassword'])
                    : '';
    $db_hostname =
            isset($_POST['hostname']) ? gpc_cleanup($_POST['hostname']) : '';
    $db_username =
            isset($_POST['username']) ? gpc_cleanup($_POST['username']) : '';
    $db_password =
            isset($_POST['password']) ? gpc_cleanup($_POST['password']) : '';
    $db_database =
            isset($_POST['database']) ? gpc_cleanup($_POST['database']) : '';
    $db_driver =
            (isset($_POST['driver'])
                    && in_array($_POST['driver'], array('mysql', 'mysqli'),
                            true)) ? $_POST['driver'] : 'mysql';
    $errors = array();
    if (empty($db_hostname))
    {
        $errors[] = 'No Database hostname specified';
    }
    if (empty($db_username))
    {
        $errors[] = 'No Database username specified';
    }
    if (empty($db_database))
    {
        $errors[] = 'No Database database specified';
    }
    if (!function_exists($db_driver . '_connect'))
    {
        $errors[] = 'Invalid database driver specified';
    }
    if (empty($adm_username)
            || !preg_match("/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                    $adm_username))
    {
        $errors[] = 'Invalid admin username specified';
    }
    if (empty($adm_pswd))
    {
        $errors[] = 'Invalid admin password specified';
    }
    if ($adm_pswd !== $adm_cpswd)
    {
        $errors[] = 'The admin passwords did not match';
    }
    if (empty($adm_email))
    {
        $errors[] = 'Invalid admin email specified';
    }
    if (empty($owner)
            || !preg_match("/^[a-z0-9_]+([\\s]{1}[a-z0-9_]|[a-z0-9_])+$/i",
                    $owner))
    {
        $errors[] = 'Invalid game owner specified';
    }
    if (empty($game_name))
    {
        $errors[] = 'Invalid game name specified';
    }
    if (empty($description))
    {
        $errors[] = 'Invalid game description specified';
    }
    if (empty($paypal))
    {
        $errors[] = 'Invalid game PayPal specified';
    }
    if (count($errors) > 0)
    {
        echo "Installation failed.<br />
        There were one or more problems with your input.<br />
        <br />
        <b>Problem(s) encountered:</b>
        <ul>";
        foreach ($errors as $error)
        {
            echo "<li><span style='color: red;'>{$error}</span></li>";
        }
        echo "</ul>
        &gt; <a href='installer.php?code=config'>Go back to config</a>";
        require_once('installer_foot.php');
        exit;
    }
    // Try to establish DB connection first...
    echo 'Attempting DB connection...<br />';
    require_once("class/class_db_{$db_driver}.php");
    $db = new database;
    $db->configure($db_hostname, $db_username, $db_password, $db_database, 0);
    $db->connect();
    $c = $db->connection_id;
    // Done, move on
    echo '... Successful.<br />';
    echo 'Writing game config file...<br />';
    echo 'Write Config...<br />';
    $code = md5(rand(1, 100000000000));
    if (file_exists("config.php"))
    {
        unlink("config.php");
    }
    $e_db_hostname = addslashes($db_hostname);
    $e_db_username = addslashes($db_username);
    $e_db_password = addslashes($db_password);
    $e_db_database = addslashes($db_database);
    $lit_config = '$_CONFIG';
    $config_file =
            <<<EOF
<?php
            {$lit_config} = array(
	'hostname' => '{$e_db_hostname}',
	'username' => '{$e_db_username}',
	'password' => '{$e_db_password}',
	'database' => '{$e_db_database}',
	'persistent' => 0,
	'driver' => '{$db_driver}',
	'code' => '{$code}',
);
?>
EOF;
    $f = fopen('config.php', 'w');
    fwrite($f, $config_file);
    fclose($f);
    echo '... file written.<br />';
    echo 'Writing base database schema...<br />';
    $fo = fopen("dbdata.sql", "r");
    $query = '';
    $lines = explode("\n", fread($fo, 1024768));
    fclose($fo);
    foreach ($lines as $line)
    {
        if (!(strpos($line, "--") === 0) && trim($line) != '')
        {
            $query .= $line;
            if (!(strpos($line, ";") === FALSE))
            {
                $db->query($query);
                $query = '';
            }
        }
    }
    echo '... done.<br />';
    echo 'Writing game configuration...<br />';
    $ins_username =
            $db->escape(htmlentities($adm_username, ENT_QUOTES, 'ISO-8859-1'));
    $salt = generate_pass_salt();
    $e_salt = $db->escape($salt);
    $encpsw = encode_password($adm_pswd, $salt);
    $e_encpsw = $db->escape($encpsw);
    $ins_email = $db->escape($adm_email);
    $IP = $db->escape($_SERVER['REMOTE_ADDR']);
    $ins_game_name =
            $db->escape(htmlentities($game_name, ENT_QUOTES, 'ISO-8859-1'));
    $ins_game_desc =
            $db->escape(htmlentities($description, ENT_QUOTES, 'ISO-8859-1'));
    $ins_paypal = $db->escape($paypal);
    $ins_game_owner =
            $db->escape(htmlentities($owner, ENT_QUOTES, 'ISO-8859-1'));
    $db->query(
            "INSERT INTO `users`
             (`username`, `login_name`, `userpass`, `level`, `money`,
             `crystals`, `donatordays`, `user_level`, `energy`, `maxenergy`,
             `will`, `maxwill`, `brave`, `maxbrave`, `hp`, `maxhp`, `location`,
             `gender`, `signedup`, `email`, `bankmoney`, `lastip`,
             `lastip_signup`, `pass_salt`)
             VALUES ('{$ins_username}', '{$ins_username}', '{$e_encpsw}', 1,
             100, 0, 0, 2, 12, 12, 100, 100, 5, 5, 100, 100, 1,
             '{$adm_gender}', " . time()
                    . ", '{$ins_email}', -1, '$IP', '$IP',
             '{$e_salt}')");
    $i = $db->insert_id();
    $db->query(
            "INSERT INTO `userstats`
    		 VALUES($i, 10, 10, 10, 10, 10)");
    $db->query(
            "INSERT INTO `settings`
             VALUES(NULL, 'game_name', '{$ins_game_name}')");
    $db->query(
            "INSERT INTO `settings`
             VALUES(NULL, 'game_owner', '{$ins_game_owner}')");
    $db->query(
            "INSERT INTO `settings`
             VALUES(NULL, 'paypal', '{$ins_paypal}')");
    $db->query(
            "INSERT INTO `settings`
             VALUES(NULL, 'game_description', '{$ins_game_desc}')");
    echo '... Done.<br />';
    $path = dirname($_SERVER['SCRIPT_FILENAME']);
    echo "
    <h2>Installation Complete!</h2>
    <hr />
    <h3>Cron Info</h3>
    <br />
    This is the cron info you need for section <b>1.2 Cronjobs</b> of the installation instructions.<br />
    <pre>
    */5 * * * * php $path/cron_fivemins.php $code
    * * * * * php $path/cron_minute.php $code
    0 * * * * php $path/cron_hour.php $code
    0 0 * * * php $path/cron_day.php $code
    </pre>
       ";
    echo "<h3>Installer Security</h3>
    Attempting to remove installer... ";
    @unlink('./installer.php');
    $success = !file_exists('./installer.php');
    echo "<span style='color: "
            . ($success ? "green;'>Succeeded" : "red;'>Failed")
            . "</span><br />";
    if (!$success)
    {
        echo "Attempting to lock installer... ";
        @touch('./installer.lock');
        $success2 = file_exists('installer.lock');
        echo "<span style='color: "
                . ($success2 ? "green;'>Succeeded" : "red;'>Failed")
                . "</span><br />";
        if ($success2)
        {
            echo "<span style='font-weight: bold;'>"
                    . "You should now remove installer.php from your server."
                    . "</span>";
        }
        else
        {
            echo "<span style='font-weight: bold; font-size: 20pt;'>"
                    . "YOU MUST REMOVE installer.php "
                    . "from your server.<br />"
                    . "Failing to do so will allow other people "
                    . "to run the installer again and potentially "
                    . "mess up your game entirely." . "</span>";
        }
    }
    else
    {
        require_once('installer_foot.php');
        @unlink('./installer_head.php');
        @unlink('./installer_foot.php');
        exit;
    }
}
require_once('installer_foot.php');

removed lines

287 to 294

function gpc_cleanup($text)
{
    if (get_magic_quotes_gpc())
    {
        return stripslashes($text);
    }
    return $text;
}

then i removed all the

gpc_cleanup

and i got this error:

Attempting DB connection...
... Successful.
Writing game config file...
Write Config...
... file written.
Writing base database schema...

Fatal error: Uncaught mysqli_sql_exception: BLOB, TEXT, GEOMETRY or JSON column 'fp_text' can't have a default value in C:\xampp\htdocs\class\class_db_mysqli.php:123 Stack trace: #0 C:\xampp\htdocs\class\class_db_mysqli.php(123): mysqli_query(Object(mysqli), 'CREATE TABLE IF...') #1 C:\xampp\htdocs\installer.php(456): database->query('CREATE TABLE IF...') #2 C:\xampp\htdocs\installer.php(46): install() #3 {main} thrown in C:\xampp\htdocs\class\class_db_mysqli.php on line 123

KyleMassacre · November 27, 2022

It’s real difficult on my phone but in your dbdata.sql file it’s telling you that you cannot of a default value so you will have to remove that default value from a text column

Ob4j4 · November 27, 2022

dbdata

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

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `a_text` text NOT NULL,
  `a_time` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `announcements`
--


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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `appID` int(11) NOT NULL auto_increment,
  `appUSER` int(11) NOT NULL default '0',
  `appGANG` int(11) NOT NULL default '0',
  `appTEXT` text NOT NULL,
  PRIMARY KEY  (`appID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `applications`
--


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

--
-- Table structure for table `attacklogs`
--

CREATE TABLE `attacklogs` (
  `log_id` int(11) NOT NULL auto_increment,
  `attacker` int(11) NOT NULL default '0',
  `attacked` int(11) NOT NULL default '0',
  `result` enum('won','lost') NOT NULL default 'won',
  `time` int(11) NOT NULL default '0',
  `stole` int(11) NOT NULL default '0',
  `attacklog` longtext NOT NULL,
  PRIMARY KEY  (`log_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `attacklogs`
--


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

--
-- Table structure for table `bankxferlogs`
--

CREATE TABLE `bankxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxBANK` enum('bank','cyber') NOT NULL default 'bank',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `bankxferlogs`
--


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

--
-- Table structure for table `blacklist`
--

CREATE TABLE `blacklist` (
  `bl_ID` int(11) NOT NULL auto_increment,
  `bl_ADDER` int(11) NOT NULL default '0',
  `bl_ADDED` int(11) NOT NULL default '0',
  `bl_COMMENT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`bl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `blacklist`
--


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

--
-- Table structure for table `cashxferlogs`
--

CREATE TABLE `cashxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `cashxferlogs`
--


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

--
-- Table structure for table `challengebots`
--

CREATE TABLE `challengebots` (
  `cb_npcid` int(11) NOT NULL default '0',
  `cb_money` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `challengebots`
--


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

--
-- Table structure for table `challengesbeaten`
--

CREATE TABLE `challengesbeaten` (
  `userid` int(11) NOT NULL default '0',
  `npcid` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `challengesbeaten`
--


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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `cityid` int(11) NOT NULL auto_increment,
  `cityname` varchar(255) NOT NULL default '',
  `citydesc` longtext NOT NULL,
  `cityminlevel` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cityid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`cityid`, `cityname`, `citydesc`, `cityminlevel`) VALUES
(1, 'Default City', 'A standard city added to start you off', 1);

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

--
-- Table structure for table `contactlist`
--

CREATE TABLE `contactlist` (
  `cl_ID` int(11) NOT NULL auto_increment,
  `cl_ADDER` int(11) NOT NULL default '0',
  `cl_ADDED` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `contactlist`
--


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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `crID` int(11) NOT NULL auto_increment,
  `crNAME` varchar(255) NOT NULL default '',
  `crDESC` text NOT NULL,
  `crCOST` int(11) NOT NULL default '0',
  `crENERGY` int(11) NOT NULL default '0',
  `crDAYS` int(11) NOT NULL default '0',
  `crSTR` int(11) NOT NULL default '0',
  `crGUARD` int(11) NOT NULL default '0',
  `crLABOUR` int(11) NOT NULL default '0',
  `crAGIL` int(11) NOT NULL default '0',
  `crIQ` int(11) NOT NULL default '0',
  PRIMARY KEY  (`crID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `courses`
--


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

--
-- Table structure for table `coursesdone`
--

CREATE TABLE `coursesdone` (
  `userid` int(11) NOT NULL default '0',
  `courseid` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `coursesdone`
--


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

--
-- Table structure for table `crimegroups`
--

CREATE TABLE `crimegroups` (
  `cgID` int(11) NOT NULL auto_increment,
  `cgNAME` varchar(255) NOT NULL default '',
  `cgORDER` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cgID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crimegroups`
--


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

--
-- Table structure for table `crimes`
--

CREATE TABLE `crimes` (
  `crimeID` int(11) NOT NULL auto_increment,
  `crimeNAME` varchar(255) NOT NULL default '',
  `crimeBRAVE` int(11) NOT NULL default '0',
  `crimePERCFORM` text NOT NULL,
  `crimeSUCCESSMUNY` int(11) NOT NULL default '0',
  `crimeSUCCESSCRYS` int(11) NOT NULL default '0',
  `crimeSUCCESSITEM` int(11) NOT NULL default '0',
  `crimeGROUP` int(11) NOT NULL default '0',
  `crimeITEXT` text NOT NULL,
  `crimeSTEXT` text NOT NULL,
  `crimeFTEXT` text NOT NULL,
  `crimeJTEXT` text NOT NULL,
  `crimeJAILTIME` int(10) NOT NULL default '0',
  `crimeJREASON` varchar(255) NOT NULL default '',
  `crimeXP` int(11) NOT NULL default '0',
  PRIMARY KEY  (`crimeID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crimes`
--


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

--
-- Table structure for table `crystalmarket`
--

CREATE TABLE `crystalmarket` (
  `cmID` int(11) NOT NULL auto_increment,
  `cmQTY` int(11) NOT NULL default '0',
  `cmADDER` int(11) NOT NULL default '0',
  `cmPRICE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cmID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crystalmarket`
--


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

--
-- Table structure for table `crystalxferlogs`
--

CREATE TABLE `crystalxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crystalxferlogs`
--


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

--
-- Table structure for table `dps_accepted`
--

CREATE TABLE `dps_accepted` (
  `dpID` int(11) NOT NULL auto_increment,
  `dpBUYER` int(11) NOT NULL default '0',
  `dpFOR` int(11) NOT NULL default '0',
  `dpTYPE` varchar(255) NOT NULL default '',
  `dpTIME` int(11) NOT NULL default '0',
  `dpTXN` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dpID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `dps_accepted`
--


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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `evID` int(11) NOT NULL auto_increment,
  `evUSER` int(11) NOT NULL default '0',
  `evTIME` int(11) NOT NULL default '0',
  `evREAD` int(11) NOT NULL default '0',
  `evTEXT` text NOT NULL,
  PRIMARY KEY  (`evID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `events`
--


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

--
-- Table structure for table `fedjail`
--

CREATE TABLE `fedjail` (
  `fed_id` int(11) NOT NULL auto_increment,
  `fed_userid` int(11) NOT NULL default '0',
  `fed_days` int(11) NOT NULL default '0',
  `fed_jailedby` int(11) NOT NULL default '0',
  `fed_reason` text NOT NULL,
  PRIMARY KEY  (`fed_id`),
  UNIQUE (`fed_userid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `fedjail`
--


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

--
-- Table structure for table `forum_forums`
--

CREATE TABLE IF NOT EXISTS `forum_forums` (
  `ff_id` int(11) NOT NULL auto_increment,
  `ff_name` varchar(255) NOT NULL default '',
  `ff_desc` varchar(255) NOT NULL default '',
  `ff_posts` int(11) NOT NULL default '0',
  `ff_topics` int(11) NOT NULL default '0',
  `ff_lp_time` int(11) NOT NULL default '0',
  `ff_lp_poster_id` int(11) NOT NULL default '0',
  `ff_lp_poster_name` text NOT NULL,
  `ff_lp_t_id` int(11) NOT NULL default '0',
  `ff_lp_t_name` varchar(255) NOT NULL default '',
  `ff_auth` enum('public','gang','staff') NOT NULL default 'public',
  `ff_owner` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ff_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_forums`
--


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

--
-- Table structure for table `forum_posts`
--

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `fp_id` int(11) NOT NULL auto_increment,
  `fp_topic_id` int(11) NOT NULL default '0',
  `fp_forum_id` int(11) NOT NULL default '0',
  `fp_poster_id` int(11) NOT NULL default '0',
  `fp_poster_name` text NOT NULL,
  `fp_time` int(11) NOT NULL default '0',
  `fp_subject` varchar(255) NOT NULL default 'No Subject',
  `fp_text` text NOT NULL,
  `fp_editor_id` int(11) NOT NULL default '0',
  `fp_editor_name` text NOT NULL,
  `fp_editor_time` int(11) NOT NULL default '0',
  `fp_edit_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fp_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_posts`
--


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

--
-- Table structure for table `forum_topics`
--

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `ft_id` int(11) NOT NULL auto_increment,
  `ft_forum_id` int(11) NOT NULL default '0',
  `ft_name` varchar(150) NOT NULL default '',
  `ft_desc` varchar(255) NOT NULL default '',
  `ft_posts` int(11) NOT NULL default '0',
  `ft_owner_id` int(11) NOT NULL default '0',
  `ft_owner_name` text NOT NULL,
  `ft_start_time` int(11) NOT NULL default '0',
  `ft_last_id` int(11) NOT NULL default '0',
  `ft_last_name` text NOT NULL,
  `ft_last_time` int(11) NOT NULL default '0',
  `ft_pinned` tinyint(4) NOT NULL default '0',
  `ft_locked` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ft_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_topics`
--


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

--
-- Table structure for table `friendslist`
--

CREATE TABLE `friendslist` (
  `fl_ID` int(11) NOT NULL auto_increment,
  `fl_ADDER` int(11) NOT NULL default '0',
  `fl_ADDED` int(11) NOT NULL default '0',
  `fl_COMMENT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`fl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `friendslist`
--


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

--
-- Table structure for table `gangevents`
--

CREATE TABLE `gangevents` (
  `gevID` int(11) NOT NULL auto_increment,
  `gevGANG` int(11) NOT NULL default '0',
  `gevTIME` int(11) NOT NULL default '0',
  `gevTEXT` text NOT NULL,
  PRIMARY KEY  (`gevID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangevents`
--


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

--
-- Table structure for table `gangs`
--

CREATE TABLE `gangs` (
  `gangID` int(11) NOT NULL auto_increment,
  `gangNAME` varchar(255) NOT NULL default '',
  `gangDESC` text NOT NULL,
  `gangPREF` varchar(12) NOT NULL default '',
  `gangSUFF` varchar(12) NOT NULL default '',
  `gangMONEY` int(11) NOT NULL default '0',
  `gangCRYSTALS` int(11) NOT NULL default '0',
  `gangRESPECT` int(11) NOT NULL default '0',
  `gangPRESIDENT` int(11) NOT NULL default '0',
  `gangVICEPRES` int(11) NOT NULL default '0',
  `gangCAPACITY` int(11) NOT NULL default '0',
  `gangCRIME` int(11) NOT NULL default '0',
  `gangCHOURS` int(11) NOT NULL default '0',
  `gangAMENT` longtext NOT NULL,
  PRIMARY KEY  (`gangID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangs`
--


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

--
-- Table structure for table `gangwars`
--

CREATE TABLE `gangwars` (
  `warID` int(11) NOT NULL auto_increment,
  `warDECLARER` int(11) NOT NULL default '0',
  `warDECLARED` int(11) NOT NULL default '0',
  `warTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`warID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangwars`
--


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

--
-- Table structure for table `houses`
--

CREATE TABLE `houses` (
  `hID` int(11) NOT NULL auto_increment,
  `hNAME` varchar(255) NOT NULL default '',
  `hPRICE` int(11) NOT NULL default '0',
  `hWILL` int(11) NOT NULL default '0',
  PRIMARY KEY  (`hID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `houses`
--

INSERT INTO `houses` (`hID`, `hNAME`, `hPRICE`, `hWILL`) VALUES
(1, 'Default House', 0, 100);

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

--
-- Table structure for table `imarketaddlogs`
--

CREATE TABLE `imarketaddlogs` (
  `imaID` int(11) NOT NULL auto_increment,
  `imaITEM` int(11) NOT NULL default '0',
  `imaPRICE` int(11) NOT NULL default '0',
  `imaINVID` int(11) NOT NULL default '0',
  `imaADDER` int(11) NOT NULL default '0',
  `imaTIME` int(11) NOT NULL default '0',
  `imaCONTENT` text NOT NULL,
  PRIMARY KEY  (`imaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imarketaddlogs`
--


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

--
-- Table structure for table `imbuylogs`
--

CREATE TABLE `imbuylogs` (
  `imbID` int(11) NOT NULL auto_increment,
  `imbITEM` int(11) NOT NULL default '0',
  `imbADDER` int(11) NOT NULL default '0',
  `imbBUYER` int(11) NOT NULL default '0',
  `imbPRICE` int(11) NOT NULL default '0',
  `imbIMID` int(11) NOT NULL default '0',
  `imbINVID` int(11) NOT NULL default '0',
  `imbTIME` int(11) NOT NULL default '0',
  `imbCONTENT` text NOT NULL,
  PRIMARY KEY  (`imbID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imbuylogs`
--


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

--
-- Table structure for table `imremovelogs`
--

CREATE TABLE `imremovelogs` (
  `imrID` int(11) NOT NULL auto_increment,
  `imrITEM` int(11) NOT NULL default '0',
  `imrADDER` int(11) NOT NULL default '0',
  `imrREMOVER` int(11) NOT NULL default '0',
  `imrIMID` int(11) NOT NULL default '0',
  `imrINVID` int(11) NOT NULL default '0',
  `imrTIME` int(11) NOT NULL default '0',
  `imrCONTENT` text NOT NULL,
  PRIMARY KEY  (`imrID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imremovelogs`
--


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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `inv_id` int(11) NOT NULL auto_increment,
  `inv_itemid` int(11) NOT NULL default '0',
  `inv_userid` int(11) NOT NULL default '0',
  `inv_qty` int(11) NOT NULL default '0',
  PRIMARY KEY  (`inv_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `inventory`
--


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

--
-- Table structure for table `itembuylogs`
--

CREATE TABLE `itembuylogs` (
  `ibID` int(11) NOT NULL auto_increment,
  `ibUSER` int(11) NOT NULL default '0',
  `ibITEM` int(11) NOT NULL default '0',
  `ibTOTALPRICE` int(11) NOT NULL default '0',
  `ibQTY` int(11) NOT NULL default '0',
  `ibTIME` int(11) NOT NULL default '0',
  `ibCONTENT` text NOT NULL,
  PRIMARY KEY  (`ibID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itembuylogs`
--


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

--
-- Table structure for table `itemmarket`
--

CREATE TABLE `itemmarket` (
  `imID` int(11) NOT NULL auto_increment,
  `imITEM` int(11) NOT NULL default '0',
  `imADDER` int(11) NOT NULL default '0',
  `imPRICE` int(11) NOT NULL default '0',
  `imCURRENCY` enum('money','crystals') NOT NULL default 'money',
  `imQTY` int(11) NOT NULL default '0',
  PRIMARY KEY  (`imID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemmarket`
--


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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `itmid` int(11) NOT NULL auto_increment,
  `itmtype` int(11) NOT NULL default '0',
  `itmname` varchar(255) NOT NULL default '',
  `itmdesc` text NOT NULL,
  `itmbuyprice` int(11) NOT NULL default '0',
  `itmsellprice` int(11) NOT NULL default '0',
  `itmbuyable` int(11) NOT NULL default '0',
  `effect1_on` tinyint(4) NOT NULL default '0',
  `effect1` text NOT NULL,
  `effect2_on` tinyint(4) NOT NULL default '0',
  `effect2` text NOT NULL,
  `effect3_on` tinyint(4) NOT NULL default '0',
  `effect3` text NOT NULL,
  `weapon` int(11) NOT NULL default '0',
  `armor` int(11) NOT NULL default '0',
  PRIMARY KEY  (`itmid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `items`
--


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

--
-- Table structure for table `itemselllogs`
--

CREATE TABLE `itemselllogs` (
  `isID` int(11) NOT NULL auto_increment,
  `isUSER` int(11) NOT NULL default '0',
  `isITEM` int(11) NOT NULL default '0',
  `isTOTALPRICE` int(11) NOT NULL default '0',
  `isQTY` int(11) NOT NULL default '0',
  `isTIME` int(11) NOT NULL default '0',
  `isCONTENT` text NOT NULL,
  PRIMARY KEY  (`isID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemselllogs`
--


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

--
-- Table structure for table `itemtypes`
--

CREATE TABLE `itemtypes` (
  `itmtypeid` int(11) NOT NULL auto_increment,
  `itmtypename` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`itmtypeid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemtypes`
--


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

--
-- Table structure for table `itemxferlogs`
--

CREATE TABLE `itemxferlogs` (
  `ixID` int(11) NOT NULL auto_increment,
  `ixFROM` int(11) NOT NULL default '0',
  `ixTO` int(11) NOT NULL default '0',
  `ixITEM` int(11) NOT NULL default '0',
  `ixQTY` int(11) NOT NULL default '0',
  `ixTIME` int(11) NOT NULL default '0',
  `ixFROMIP` varchar(255) NOT NULL default '',
  `ixTOIP` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ixID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemxferlogs`
--


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

--
-- Table structure for table `jaillogs`
--

CREATE TABLE `jaillogs` (
  `jaID` int(11) NOT NULL auto_increment,
  `jaJAILER` int(11) NOT NULL default '0',
  `jaJAILED` int(11) NOT NULL default '0',
  `jaDAYS` int(11) NOT NULL default '0',
  `jaREASON` longtext NOT NULL,
  `jaTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`jaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jaillogs`
--


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

--
-- Table structure for table `jobranks`
--

CREATE TABLE `jobranks` (
  `jrID` int(11) NOT NULL auto_increment,
  `jrNAME` varchar(255) NOT NULL default '',
  `jrJOB` int(11) NOT NULL default '0',
  `jrPAY` int(11) NOT NULL default '0',
  `jrIQG` int(11) NOT NULL default '0',
  `jrLABOURG` int(11) NOT NULL default '0',
  `jrSTRG` int(11) NOT NULL default '0',
  `jrIQN` int(11) NOT NULL default '0',
  `jrLABOURN` int(11) NOT NULL default '0',
  `jrSTRN` int(11) NOT NULL default '0',
  PRIMARY KEY  (`jrID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jobranks`
--


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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `jID` int(11) NOT NULL auto_increment,
  `jNAME` varchar(255) NOT NULL default '',
  `jFIRST` int(11) NOT NULL default '0',
  `jDESC` varchar(255) NOT NULL default '',
  `jOWNER` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`jID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jobs`
--


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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `mail_id` int(11) NOT NULL auto_increment,
  `mail_read` int(11) NOT NULL default '0',
  `mail_from` int(11) NOT NULL default '0',
  `mail_to` int(11) NOT NULL default '0',
  `mail_time` int(11) NOT NULL default '0',
  `mail_subject` varchar(255) NOT NULL default '',
  `mail_text` text NOT NULL,
  PRIMARY KEY  (`mail_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `mail`
--


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

--
-- Table structure for table `oclogs`
--

CREATE TABLE `oclogs` (
  `oclID` int(11) NOT NULL auto_increment,
  `oclOC` int(11) NOT NULL default '0',
  `oclGANG` int(11) NOT NULL default '0',
  `oclLOG` text NOT NULL,
  `oclRESULT` enum('success','failure') NOT NULL default 'success',
  `oclMONEY` int(11) NOT NULL default '0',
  `ocCRIMEN` varchar(255) NOT NULL default '',
  `ocTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`oclID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `oclogs`
--


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

--
-- Table structure for table `orgcrimes`
--

CREATE TABLE `orgcrimes` (
  `ocID` int(11) NOT NULL auto_increment,
  `ocNAME` varchar(255) NOT NULL default '',
  `ocUSERS` int(11) NOT NULL default '0',
  `ocSTARTTEXT` text NOT NULL,
  `ocSUCCTEXT` text NOT NULL,
  `ocFAILTEXT` text NOT NULL,
  `ocMINMONEY` int(11) NOT NULL default '0',
  `ocMAXMONEY` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ocID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `orgcrimes`
--


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

--
-- Table structure for table `papercontent`
--

CREATE TABLE `papercontent` (
  `content` longtext NOT NULL
) ENGINE=MyISAM ;

INSERT INTO `papercontent` VALUES('Here you can put game news, or prehaps an update log.');


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

--
-- Table structure for table `polls`
--

CREATE TABLE `polls` (
  `id` int(11) NOT NULL auto_increment,
  `active` enum('0','1') NOT NULL default '0',
  `question` varchar(255) NOT NULL default '',
  `choice1` varchar(255) NOT NULL default '',
  `choice2` varchar(255) NOT NULL default '',
  `choice3` varchar(255) NOT NULL default '',
  `choice4` varchar(255) NOT NULL default '',
  `choice5` varchar(255) NOT NULL default '',
  `choice6` varchar(255) NOT NULL default '',
  `choice7` varchar(255) NOT NULL default '',
  `choice8` varchar(255) NOT NULL default '',
  `choice9` varchar(255) NOT NULL default '',
  `choice10` varchar(255) NOT NULL default '',
  `voted1` int(11) NOT NULL default '0',
  `voted2` int(11) NOT NULL default '0',
  `voted3` int(11) NOT NULL default '0',
  `voted4` int(11) NOT NULL default '0',
  `voted5` int(11) NOT NULL default '0',
  `voted6` int(11) NOT NULL default '0',
  `voted7` int(11) NOT NULL default '0',
  `voted8` int(11) NOT NULL default '0',
  `voted9` int(11) NOT NULL default '0',
  `voted10` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `winner` int(11) NOT NULL default '0',
  `hidden` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `polls`
--


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

--
-- Table structure for table `preports`
--

CREATE TABLE `preports` (
  `prID` int(11) NOT NULL auto_increment,
  `prREPORTER` int(11) NOT NULL default '0',
  `prREPORTED` int(11) NOT NULL default '0',
  `prTEXT` longtext NOT NULL,
  PRIMARY KEY  (`prID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `preports`
--


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

--
-- Table structure for table `referals`
--

CREATE TABLE `referals` (
  `refID` int(11) NOT NULL auto_increment,
  `refREFER` int(11) NOT NULL default '0',
  `refREFED` int(11) NOT NULL default '0',
  `refTIME` int(11) NOT NULL default '0',
  `refREFERIP` varchar(15) NOT NULL default '127.0.0.1',
  `refREFEDIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`refID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `referals`
--


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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `conf_id` int(11) NOT NULL auto_increment,
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text NOT NULL,
  PRIMARY KEY  (`conf_id`)
) ENGINE=MyISAM ;

INSERT INTO `settings` VALUES (NULL, 'validate_period', '15');
INSERT INTO `settings` VALUES (NULL, 'validate_on', '0');
INSERT INTO `settings` VALUES (NULL, 'regcap_on', '0');
INSERT INTO `settings` VALUES (NULL, 'hospital_count', '0');
INSERT INTO `settings` VALUES (NULL, 'jail_count', '0');
INSERT INTO `settings` VALUES (NULL, 'sendcrys_on', '1');
INSERT INTO `settings` VALUES (NULL, 'sendbank_on', '1');
INSERT INTO `settings` VALUES (NULL, 'ct_refillprice', '12');
INSERT INTO `settings` VALUES (NULL, 'ct_iqpercrys', '5');
INSERT INTO `settings` VALUES (NULL, 'ct_moneypercrys', '200');
INSERT INTO `settings` VALUES (NULL, 'staff_pad', 'Here you can store notes for all staff to see.');
INSERT INTO `settings` VALUES (NULL, 'willp_item', '0');
INSERT INTO `settings` VALUES (NULL, 'jquery_location', 'js/jquery-1.7.1.min.js');


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

--
-- Table structure for table `shopitems`
--

CREATE TABLE `shopitems` (
  `sitemID` int(11) NOT NULL auto_increment,
  `sitemSHOP` int(11) NOT NULL default '0',
  `sitemITEMID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sitemID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `shopitems`
--


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

--
-- Table structure for table `shops`
--

CREATE TABLE `shops` (
  `shopID` int(11) NOT NULL auto_increment,
  `shopLOCATION` int(11) NOT NULL default '0',
  `shopNAME` varchar(255) NOT NULL default '',
  `shopDESCRIPTION` text NOT NULL,
  PRIMARY KEY  (`shopID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `shops`
--


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

--
-- Table structure for table `stafflog`
--

CREATE TABLE `stafflog` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `action` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `stafflog`
--


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

--
-- Table structure for table `staffnotelogs`
--

CREATE TABLE `staffnotelogs` (
  `snID` int(11) NOT NULL auto_increment,
  `snCHANGER` int(11) NOT NULL default '0',
  `snCHANGED` int(11) NOT NULL default '0',
  `snTIME` int(11) NOT NULL default '0',
  `snOLD` longtext NOT NULL,
  `snNEW` longtext NOT NULL,
  PRIMARY KEY  (`snID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `staffnotelogs`
--


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

--
-- Table structure for table `surrenders`
--

CREATE TABLE `surrenders` (
  `surID` int(11) NOT NULL auto_increment,
  `surWAR` int(11) NOT NULL default '0',
  `surWHO` int(11) NOT NULL default '0',
  `surTO` int(11) NOT NULL default '0',
  `surMSG` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`surID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `surrenders`
--


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

--
-- Table structure for table `unjaillogs`
--

CREATE TABLE `unjaillogs` (
  `ujaID` int(11) NOT NULL auto_increment,
  `ujaJAILER` int(11) NOT NULL default '0',
  `ujaJAILED` int(11) NOT NULL default '0',
  `ujaTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ujaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `unjaillogs`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `userpass` varchar(255) NOT NULL default '',
  `level` int(11) NOT NULL default '0',
  `exp` decimal(11,4) NOT NULL default '0.0000',
  `money` int(11) NOT NULL default '0',
  `crystals` int(11) NOT NULL default '0',
  `laston` int(11) NOT NULL default '0',
  `lastip` varchar(255) NOT NULL default '',
  `job` int(11) NOT NULL default '0',
  `energy` int(11) NOT NULL default '0',
  `will` int(11) NOT NULL default '0',
  `maxwill` int(11) NOT NULL default '0',
  `brave` int(11) NOT NULL default '0',
  `maxbrave` int(11) NOT NULL default '0',
  `maxenergy` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `maxhp` int(11) NOT NULL default '0',
  `lastrest_life` int(11) NOT NULL default '0',
  `lastrest_other` int(11) NOT NULL default '0',
  `location` int(11) NOT NULL default '0',
  `hospital` int(11) NOT NULL default '0',
  `jail` int(11) NOT NULL default '0',
  `jail_reason` varchar(255) NOT NULL default '',
  `fedjail` int(11) NOT NULL default '0',
  `user_level` int(11) NOT NULL default '1',
  `gender` enum('Male','Female') NOT NULL default 'Male',
  `daysold` int(11) NOT NULL default '0',
  `signedup` int(11) NOT NULL default '0',
  `gang` int(11) NOT NULL default '0',
  `daysingang` int(11) NOT NULL default '0',
  `course` int(11) NOT NULL default '0',
  `cdays` int(11) NOT NULL default '0',
  `jobrank` int(11) NOT NULL default '0',
  `donatordays` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `login_name` varchar(255) NOT NULL default '',
  `display_pic` text NOT NULL default '',
  `duties` varchar(255) NOT NULL default 'N/A',
  `bankmoney` int(11) NOT NULL default '0',
  `cybermoney` int(11) NOT NULL default '-1',
  `staffnotes` longtext NOT NULL,
  `mailban` int(11) NOT NULL default '0',
  `mb_reason` varchar(255) NOT NULL default '',
  `hospreason` varchar(255) NOT NULL default '',
  `lastip_login` varchar(255) NOT NULL default '127.0.0.1',
  `lastip_signup` varchar(255) NOT NULL default '127.0.0.1',
  `last_login` int(11) NOT NULL default '0',
  `voted` text NOT NULL,
  `crimexp` int(11) NOT NULL default '0',
  `attacking` int(11) NOT NULL default '0',
  `verified` int(11) NOT NULL default '0',
  `forumban` int(11) NOT NULL default '0',
  `fb_reason` varchar(255) NOT NULL default '',
  `posts` int(11) NOT NULL default '0',
  `forums_avatar` varchar(255) NOT NULL default '',
  `forums_signature` varchar(250) NOT NULL default '',
  `new_events` int(11) NOT NULL default '0',
  `new_mail` int(11) NOT NULL default '0',
  `friend_count` int(11) NOT NULL default '0',
  `enemy_count` int(11) NOT NULL default '0',
  `new_announcements` int(11) NOT NULL default '0',
  `boxes_opened` int(11) NOT NULL default '0',
  `user_notepad` text NOT NULL,
  `equip_primary` int(11) NOT NULL default '0',
  `equip_secondary` int(11) NOT NULL default '0',
  `equip_armor` int(11) NOT NULL default '0',
  `force_logout` tinyint(4) NOT NULL default '0',
  `pass_salt` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM ;
--
-- Dumping data for table `users`
--


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

--
-- Table structure for table `userstats`
--

CREATE TABLE `userstats` (
  `userid` int(11) NOT NULL default '0',
  `strength` float NOT NULL default '0',
  `agility` float NOT NULL default '0',
  `guard` float NOT NULL default '0',
  `labour` float NOT NULL default '0',
  `IQ` float NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `userstats`
--


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

--
-- Table structure for table `votes`
--

CREATE TABLE `votes` (
  `userid` int(11) NOT NULL default '0',
  `list` varchar(255) NOT NULL default ''
) ENGINE=MyISAM ;

--
-- Dumping data for table `votes`
--


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

--
-- Table structure for table `willps_accepted`
--

CREATE TABLE `willps_accepted` (
  `dpID` int(11) NOT NULL auto_increment,
  `dpBUYER` int(11) NOT NULL default '0',
  `dpFOR` int(11) NOT NULL default '0',
  `dpAMNT` varchar(255) NOT NULL default '',
  `dpTIME` int(11) NOT NULL default '0',
  `dpTXN` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dpID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `willps_accepted`
--

class db mysqli php

<?php
/**
 * MCCodes Version 2.0.5b
 * Copyright (C) 2005-2012 Dabomstew
 * All rights reserved.
 *
 * Redistribution of this code in any form is prohibited, except in
 * the specific cases set out in the MCCodes Customer License.
 *
 * This code license may be used to run one (1) game.
 * A game is defined as the set of users and other game database data,
 * so you are permitted to create alternative clients for your game.
 *
 * If you did not obtain this code from MCCodes.com, you are in all likelihood
 * using it illegally. Please contact MCCodes to discuss licensing options
 * in this case.
 *
 * File: class/class_db_mysqli.php
 * Signature: 0bd885c66484350e8b0130c39e932e20
 * Date: Fri, 20 Apr 12 08:50:30 +0000
 */

if (!defined('MONO_ON'))
{
    exit;
}

if (!function_exists('error_critical'))
{
    // Umm...
    die('<h1>Error</h1>' . 'Error handler not present');
}

if (!extension_loaded('mysqli'))
{
    // dl doesn't work anymore, crash
    error_critical('Database connection failed',
            'MySQLi extension not present but required', 'N/A',
            debug_backtrace(false));
}

class database
{
    var $host;
    var $user;
    var $pass;
    var $database;
    var $persistent = 0;
    var $last_query;
    var $result;
    var $connection_id;
    var $num_queries = 0;
    var $start_time;
    var $queries = array();

    function configure($host, $user, $pass, $database, $persistent = 0)
    {
        $this->host = $host;
        $this->user = $user;
        $this->pass = $pass;
        $this->database = $database;
        return 1; //Success.
    }

    function connect()
    {
        if (!$this->host)
        {
            $this->host = "localhost";
        }
        if (!$this->user)
        {
            $this->user = "root";
        }
        $conn =
                mysqli_connect($this->host, $this->user, $this->pass,
                        $this->database);
        if (mysqli_connect_error())
        {
            error_critical('Database connection failed',
                    mysqli_connect_errno() . ': ' . mysqli_connect_error(),
                    'Attempted to connect to database on ' . $this->host,
                    debug_backtrace(false));
        }
        // @overridecharset mysqli
        $this->connection_id = $conn;
        return $this->connection_id;
    }

    function disconnect()
    {
        if ($this->connection_id)
        {
            mysqli_close($this->connection_id);
            $this->connection_id = 0;
            return 1;
        }
        else
        {
            return 0;
        }
    }

    function change_db($database)
    {
        if (!mysqli_select_db($this->connection_id, $database))
        {
            error_critical('Database change failed',
                    mysqli_errno($this->connection_id) . ': '
                            . mysqli_error($this->connection_id),
                    'Attempted to select database: ' . $database,
                    debug_backtrace(false));
        }
        $this->database = $database;
    }

    function query($query)
    {
        $this->last_query = $query;
        $this->queries[] = $query;
        $this->num_queries++;
        $this->result =
                mysqli_query($this->connection_id, $this->last_query);
        if ($this->result === false)
        {
            error_critical('Query failed',
                    mysqli_errno($this->connection_id) . ': '
                            . mysqli_error($this->connection_id),
                    'Attempted to execute query: ' . nl2br($this->last_query),
                    debug_backtrace(false));
        }
        return $this->result;
    }

    function fetch_row($result = 0)
    {
        if (!$result)
        {
            $result = $this->result;
        }
        return mysqli_fetch_assoc($result);
    }

    function num_rows($result = 0)
    {
        if (!$result)
        {
            $result = $this->result;
        }
        return mysqli_num_rows($result);
    }

    function insert_id()
    {
        return mysqli_insert_id($this->connection_id);
    }

    function fetch_single($result = 0)
    {
        if (!$result)
        {
            $result = $this->result;
        }
        //Ugly hack here
        mysqli_data_seek($result, 0);
        $temp = mysqli_fetch_array($result);
        return $temp[0];
    }

    function easy_insert($table, $data)
    {
        $query = "INSERT INTO `$table` (";
        $i = 0;
        foreach ($data as $k => $v)
        {
            $i++;
            if ($i > 1)
            {
                $query .= ", ";
            }
            $query .= $k;
        }
        $query .= ") VALUES(";
        $i = 0;
        foreach ($data as $k => $v)
        {
            $i++;
            if ($i > 1)
            {
                $query .= ", ";
            }
            $query .= "'" . $this->escape($v) . "'";
        }
        $query .= ")";
        return $this->query($query);
    }

    function escape($text)
    {
        return mysqli_real_escape_string($this->connection_id, $text);
    }

    function affected_rows()
    {
        return mysqli_affected_rows($this->connection_id);
    }

    function free_result($result)
    {
        return mysqli_free_result($result);
    }

}

lines 123 - 133

               mysqli_query($this->connection_id, $this->last_query);
        if ($this->result === false)
        {
            error_critical('Query failed',
                    mysqli_errno($this->connection_id) . ': '
                            . mysqli_error($this->connection_id),
                    'Attempted to execute query: ' . nl2br($this->last_query),
                    debug_backtrace(false));
        }
        return $this->result;
    }

error:

Attempting DB connection...
... Successful.
Writing game config file...
Write Config...
... file written.
Writing base database schema...

Fatal error: Uncaught mysqli_sql_exception: Table 'announcements' already exists in C:\xampp\htdocs\class\class_db_mysqli.php:123 Stack trace: #0 C:\xampp\htdocs\class\class_db_mysqli.php(123): mysqli_query(Object(mysqli), 'CREATE TABLE `a...') #1 C:\xampp\htdocs\installer.php(455): database->query('CREATE TABLE `a...') #2 C:\xampp\htdocs\installer.php(46): install() #3 {main} thrown in C:\xampp\htdocs\class\class_db_mysqli.php on line 123

AlizHarb · November 27, 2022

try this

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `fp_id` int(11) NOT NULL auto_increment,
  `fp_topic_id` int(11) NOT NULL default '0',
  `fp_forum_id` int(11) NOT NULL default '0',
  `fp_poster_id` int(11) NOT NULL default '0',
  `fp_poster_name` text NOT NULL,
  `fp_time` int(11) NOT NULL default '0',
  `fp_subject` varchar(255) NOT NULL default 'No Subject',
  `fp_text` text NULL,
  `fp_editor_id` int(11) NOT NULL default '0',
  `fp_editor_name` text NOT NULL,
  `fp_editor_time` int(11) NOT NULL default '0',
  `fp_edit_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fp_id`)
) ENGINE=MyISAM ;

but firstly make your database empty, delete all tables from there and install

Edited November 27, 2022 by AlizHarb

Ob4j4 · November 27, 2022

Attempting DB connection...
... Successful.
Writing game config file...
Write Config...
... file written.
Writing base database schema...
... done.
Writing game configuration...

Fatal error: Uncaught mysqli_sql_exception: Field 'display_pic' doesn't have a default value in C:\xampp\htdocs\class\class_db_mysqli.php:123 Stack trace: #0 C:\xampp\htdocs\class\class_db_mysqli.php(123): mysqli_query(Object(mysqli), 'INSERT INTO `us...') #1 C:\xampp\htdocs\installer.php(488): database->query('INSERT INTO `us...') #2 C:\xampp\htdocs\installer.php(46): install() #3 {main} thrown in C:\xampp\htdocs\class\class_db_mysqli.php on line 123

Veramys · November 27, 2022

Like Kyle said you need to remove all the places in the dbdata.sql and delete all the spots that say default '0'

Edit** to say remove the default value for fp_text, not everywhere

Also for the display_pic change the default value to something. When it is set to not null the default has to have a value.

Edited November 27, 2022 by Veramys

AlizHarb · November 27, 2022

Well, seems you have to try each text column lol , i hate mccode but anyway try this

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

--
-- Table structure for table `announcements`
--

CREATE TABLE `announcements` (
  `a_text` text NOT NULL,
  `a_time` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `announcements`
--


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

--
-- Table structure for table `applications`
--

CREATE TABLE `applications` (
  `appID` int(11) NOT NULL auto_increment,
  `appUSER` int(11) NOT NULL default '0',
  `appGANG` int(11) NOT NULL default '0',
  `appTEXT` text NOT NULL,
  PRIMARY KEY  (`appID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `applications`
--


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

--
-- Table structure for table `attacklogs`
--

CREATE TABLE `attacklogs` (
  `log_id` int(11) NOT NULL auto_increment,
  `attacker` int(11) NOT NULL default '0',
  `attacked` int(11) NOT NULL default '0',
  `result` enum('won','lost') NOT NULL default 'won',
  `time` int(11) NOT NULL default '0',
  `stole` int(11) NOT NULL default '0',
  `attacklog` longtext NOT NULL,
  PRIMARY KEY  (`log_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `attacklogs`
--


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

--
-- Table structure for table `bankxferlogs`
--

CREATE TABLE `bankxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxBANK` enum('bank','cyber') NOT NULL default 'bank',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `bankxferlogs`
--


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

--
-- Table structure for table `blacklist`
--

CREATE TABLE `blacklist` (
  `bl_ID` int(11) NOT NULL auto_increment,
  `bl_ADDER` int(11) NOT NULL default '0',
  `bl_ADDED` int(11) NOT NULL default '0',
  `bl_COMMENT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`bl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `blacklist`
--


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

--
-- Table structure for table `cashxferlogs`
--

CREATE TABLE `cashxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `cashxferlogs`
--


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

--
-- Table structure for table `challengebots`
--

CREATE TABLE `challengebots` (
  `cb_npcid` int(11) NOT NULL default '0',
  `cb_money` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `challengebots`
--


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

--
-- Table structure for table `challengesbeaten`
--

CREATE TABLE `challengesbeaten` (
  `userid` int(11) NOT NULL default '0',
  `npcid` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `challengesbeaten`
--


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

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `cityid` int(11) NOT NULL auto_increment,
  `cityname` varchar(255) NOT NULL default '',
  `citydesc` longtext NOT NULL,
  `cityminlevel` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cityid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`cityid`, `cityname`, `citydesc`, `cityminlevel`) VALUES
(1, 'Default City', 'A standard city added to start you off', 1);

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

--
-- Table structure for table `contactlist`
--

CREATE TABLE `contactlist` (
  `cl_ID` int(11) NOT NULL auto_increment,
  `cl_ADDER` int(11) NOT NULL default '0',
  `cl_ADDED` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `contactlist`
--


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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `crID` int(11) NOT NULL auto_increment,
  `crNAME` varchar(255) NOT NULL default '',
  `crDESC` text NOT NULL,
  `crCOST` int(11) NOT NULL default '0',
  `crENERGY` int(11) NOT NULL default '0',
  `crDAYS` int(11) NOT NULL default '0',
  `crSTR` int(11) NOT NULL default '0',
  `crGUARD` int(11) NOT NULL default '0',
  `crLABOUR` int(11) NOT NULL default '0',
  `crAGIL` int(11) NOT NULL default '0',
  `crIQ` int(11) NOT NULL default '0',
  PRIMARY KEY  (`crID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `courses`
--


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

--
-- Table structure for table `coursesdone`
--

CREATE TABLE `coursesdone` (
  `userid` int(11) NOT NULL default '0',
  `courseid` int(11) NOT NULL default '0'
) ENGINE=MyISAM ;

--
-- Dumping data for table `coursesdone`
--


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

--
-- Table structure for table `crimegroups`
--

CREATE TABLE `crimegroups` (
  `cgID` int(11) NOT NULL auto_increment,
  `cgNAME` varchar(255) NOT NULL default '',
  `cgORDER` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cgID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crimegroups`
--


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

--
-- Table structure for table `crimes`
--

CREATE TABLE `crimes` (
  `crimeID` int(11) NOT NULL auto_increment,
  `crimeNAME` varchar(255) NOT NULL default '',
  `crimeBRAVE` int(11) NOT NULL default '0',
  `crimePERCFORM` text NOT NULL,
  `crimeSUCCESSMUNY` int(11) NOT NULL default '0',
  `crimeSUCCESSCRYS` int(11) NOT NULL default '0',
  `crimeSUCCESSITEM` int(11) NOT NULL default '0',
  `crimeGROUP` int(11) NOT NULL default '0',
  `crimeITEXT` text NOT NULL,
  `crimeSTEXT` text NOT NULL,
  `crimeFTEXT` text NOT NULL,
  `crimeJTEXT` text NOT NULL,
  `crimeJAILTIME` int(10) NOT NULL default '0',
  `crimeJREASON` varchar(255) NOT NULL default '',
  `crimeXP` int(11) NOT NULL default '0',
  PRIMARY KEY  (`crimeID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crimes`
--


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

--
-- Table structure for table `crystalmarket`
--

CREATE TABLE `crystalmarket` (
  `cmID` int(11) NOT NULL auto_increment,
  `cmQTY` int(11) NOT NULL default '0',
  `cmADDER` int(11) NOT NULL default '0',
  `cmPRICE` int(11) NOT NULL default '0',
  PRIMARY KEY  (`cmID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crystalmarket`
--


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

--
-- Table structure for table `crystalxferlogs`
--

CREATE TABLE `crystalxferlogs` (
  `cxID` int(11) NOT NULL auto_increment,
  `cxFROM` int(11) NOT NULL default '0',
  `cxTO` int(11) NOT NULL default '0',
  `cxAMOUNT` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `crystalxferlogs`
--


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

--
-- Table structure for table `dps_accepted`
--

CREATE TABLE `dps_accepted` (
  `dpID` int(11) NOT NULL auto_increment,
  `dpBUYER` int(11) NOT NULL default '0',
  `dpFOR` int(11) NOT NULL default '0',
  `dpTYPE` varchar(255) NOT NULL default '',
  `dpTIME` int(11) NOT NULL default '0',
  `dpTXN` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dpID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `dps_accepted`
--


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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `evID` int(11) NOT NULL auto_increment,
  `evUSER` int(11) NOT NULL default '0',
  `evTIME` int(11) NOT NULL default '0',
  `evREAD` int(11) NOT NULL default '0',
  `evTEXT` text NOT NULL,
  PRIMARY KEY  (`evID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `events`
--


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

--
-- Table structure for table `fedjail`
--

CREATE TABLE `fedjail` (
  `fed_id` int(11) NOT NULL auto_increment,
  `fed_userid` int(11) NOT NULL default '0',
  `fed_days` int(11) NOT NULL default '0',
  `fed_jailedby` int(11) NOT NULL default '0',
  `fed_reason` text NOT NULL,
  PRIMARY KEY  (`fed_id`),
  UNIQUE (`fed_userid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `fedjail`
--


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

--
-- Table structure for table `forum_forums`
--

CREATE TABLE IF NOT EXISTS `forum_forums` (
  `ff_id` int(11) NOT NULL auto_increment,
  `ff_name` varchar(255) NOT NULL default '',
  `ff_desc` varchar(255) NOT NULL default '',
  `ff_posts` int(11) NOT NULL default '0',
  `ff_topics` int(11) NOT NULL default '0',
  `ff_lp_time` int(11) NOT NULL default '0',
  `ff_lp_poster_id` int(11) NOT NULL default '0',
  `ff_lp_poster_name` text NOT NULL,
  `ff_lp_t_id` int(11) NOT NULL default '0',
  `ff_lp_t_name` varchar(255) NOT NULL default '',
  `ff_auth` enum('public','gang','staff') NOT NULL default 'public',
  `ff_owner` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ff_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_forums`
--


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

--
-- Table structure for table `forum_posts`
--

CREATE TABLE IF NOT EXISTS `forum_posts` (
  `fp_id` int(11) NOT NULL auto_increment,
  `fp_topic_id` int(11) NOT NULL default '0',
  `fp_forum_id` int(11) NOT NULL default '0',
  `fp_poster_id` int(11) NOT NULL default '0',
  `fp_poster_name` text NOT NULL,
  `fp_time` int(11) NOT NULL default '0',
  `fp_subject` varchar(255) NOT NULL default 'No Subject',
  `fp_text` text NULL,
  `fp_editor_id` int(11) NOT NULL default '0',
  `fp_editor_name` text NOT NULL,
  `fp_editor_time` int(11) NOT NULL default '0',
  `fp_edit_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`fp_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_posts`
--


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

--
-- Table structure for table `forum_topics`
--

CREATE TABLE IF NOT EXISTS `forum_topics` (
  `ft_id` int(11) NOT NULL auto_increment,
  `ft_forum_id` int(11) NOT NULL default '0',
  `ft_name` varchar(150) NOT NULL default '',
  `ft_desc` varchar(255) NOT NULL default '',
  `ft_posts` int(11) NOT NULL default '0',
  `ft_owner_id` int(11) NOT NULL default '0',
  `ft_owner_name` text NOT NULL,
  `ft_start_time` int(11) NOT NULL default '0',
  `ft_last_id` int(11) NOT NULL default '0',
  `ft_last_name` text NOT NULL,
  `ft_last_time` int(11) NOT NULL default '0',
  `ft_pinned` tinyint(4) NOT NULL default '0',
  `ft_locked` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`ft_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `forum_topics`
--


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

--
-- Table structure for table `friendslist`
--

CREATE TABLE `friendslist` (
  `fl_ID` int(11) NOT NULL auto_increment,
  `fl_ADDER` int(11) NOT NULL default '0',
  `fl_ADDED` int(11) NOT NULL default '0',
  `fl_COMMENT` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`fl_ID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `friendslist`
--


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

--
-- Table structure for table `gangevents`
--

CREATE TABLE `gangevents` (
  `gevID` int(11) NOT NULL auto_increment,
  `gevGANG` int(11) NOT NULL default '0',
  `gevTIME` int(11) NOT NULL default '0',
  `gevTEXT` text NOT NULL,
  PRIMARY KEY  (`gevID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangevents`
--


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

--
-- Table structure for table `gangs`
--

CREATE TABLE `gangs` (
  `gangID` int(11) NOT NULL auto_increment,
  `gangNAME` varchar(255) NOT NULL default '',
  `gangDESC` text NOT NULL,
  `gangPREF` varchar(12) NOT NULL default '',
  `gangSUFF` varchar(12) NOT NULL default '',
  `gangMONEY` int(11) NOT NULL default '0',
  `gangCRYSTALS` int(11) NOT NULL default '0',
  `gangRESPECT` int(11) NOT NULL default '0',
  `gangPRESIDENT` int(11) NOT NULL default '0',
  `gangVICEPRES` int(11) NOT NULL default '0',
  `gangCAPACITY` int(11) NOT NULL default '0',
  `gangCRIME` int(11) NOT NULL default '0',
  `gangCHOURS` int(11) NOT NULL default '0',
  `gangAMENT` longtext NOT NULL,
  PRIMARY KEY  (`gangID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangs`
--


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

--
-- Table structure for table `gangwars`
--

CREATE TABLE `gangwars` (
  `warID` int(11) NOT NULL auto_increment,
  `warDECLARER` int(11) NOT NULL default '0',
  `warDECLARED` int(11) NOT NULL default '0',
  `warTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`warID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `gangwars`
--


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

--
-- Table structure for table `houses`
--

CREATE TABLE `houses` (
  `hID` int(11) NOT NULL auto_increment,
  `hNAME` varchar(255) NOT NULL default '',
  `hPRICE` int(11) NOT NULL default '0',
  `hWILL` int(11) NOT NULL default '0',
  PRIMARY KEY  (`hID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `houses`
--

INSERT INTO `houses` (`hID`, `hNAME`, `hPRICE`, `hWILL`) VALUES
(1, 'Default House', 0, 100);

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

--
-- Table structure for table `imarketaddlogs`
--

CREATE TABLE `imarketaddlogs` (
  `imaID` int(11) NOT NULL auto_increment,
  `imaITEM` int(11) NOT NULL default '0',
  `imaPRICE` int(11) NOT NULL default '0',
  `imaINVID` int(11) NOT NULL default '0',
  `imaADDER` int(11) NOT NULL default '0',
  `imaTIME` int(11) NOT NULL default '0',
  `imaCONTENT` text NOT NULL,
  PRIMARY KEY  (`imaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imarketaddlogs`
--


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

--
-- Table structure for table `imbuylogs`
--

CREATE TABLE `imbuylogs` (
  `imbID` int(11) NOT NULL auto_increment,
  `imbITEM` int(11) NOT NULL default '0',
  `imbADDER` int(11) NOT NULL default '0',
  `imbBUYER` int(11) NOT NULL default '0',
  `imbPRICE` int(11) NOT NULL default '0',
  `imbIMID` int(11) NOT NULL default '0',
  `imbINVID` int(11) NOT NULL default '0',
  `imbTIME` int(11) NOT NULL default '0',
  `imbCONTENT` text NOT NULL,
  PRIMARY KEY  (`imbID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imbuylogs`
--


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

--
-- Table structure for table `imremovelogs`
--

CREATE TABLE `imremovelogs` (
  `imrID` int(11) NOT NULL auto_increment,
  `imrITEM` int(11) NOT NULL default '0',
  `imrADDER` int(11) NOT NULL default '0',
  `imrREMOVER` int(11) NOT NULL default '0',
  `imrIMID` int(11) NOT NULL default '0',
  `imrINVID` int(11) NOT NULL default '0',
  `imrTIME` int(11) NOT NULL default '0',
  `imrCONTENT` text NOT NULL,
  PRIMARY KEY  (`imrID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `imremovelogs`
--


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

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `inv_id` int(11) NOT NULL auto_increment,
  `inv_itemid` int(11) NOT NULL default '0',
  `inv_userid` int(11) NOT NULL default '0',
  `inv_qty` int(11) NOT NULL default '0',
  PRIMARY KEY  (`inv_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `inventory`
--


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

--
-- Table structure for table `itembuylogs`
--

CREATE TABLE `itembuylogs` (
  `ibID` int(11) NOT NULL auto_increment,
  `ibUSER` int(11) NOT NULL default '0',
  `ibITEM` int(11) NOT NULL default '0',
  `ibTOTALPRICE` int(11) NOT NULL default '0',
  `ibQTY` int(11) NOT NULL default '0',
  `ibTIME` int(11) NOT NULL default '0',
  `ibCONTENT` text NOT NULL,
  PRIMARY KEY  (`ibID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itembuylogs`
--


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

--
-- Table structure for table `itemmarket`
--

CREATE TABLE `itemmarket` (
  `imID` int(11) NOT NULL auto_increment,
  `imITEM` int(11) NOT NULL default '0',
  `imADDER` int(11) NOT NULL default '0',
  `imPRICE` int(11) NOT NULL default '0',
  `imCURRENCY` enum('money','crystals') NOT NULL default 'money',
  `imQTY` int(11) NOT NULL default '0',
  PRIMARY KEY  (`imID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemmarket`
--


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

--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `itmid` int(11) NOT NULL auto_increment,
  `itmtype` int(11) NOT NULL default '0',
  `itmname` varchar(255) NOT NULL default '',
  `itmdesc` text NOT NULL,
  `itmbuyprice` int(11) NOT NULL default '0',
  `itmsellprice` int(11) NOT NULL default '0',
  `itmbuyable` int(11) NOT NULL default '0',
  `effect1_on` tinyint(4) NOT NULL default '0',
  `effect1` text NOT NULL,
  `effect2_on` tinyint(4) NOT NULL default '0',
  `effect2` text NOT NULL,
  `effect3_on` tinyint(4) NOT NULL default '0',
  `effect3` text NOT NULL,
  `weapon` int(11) NOT NULL default '0',
  `armor` int(11) NOT NULL default '0',
  PRIMARY KEY  (`itmid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `items`
--


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

--
-- Table structure for table `itemselllogs`
--

CREATE TABLE `itemselllogs` (
  `isID` int(11) NOT NULL auto_increment,
  `isUSER` int(11) NOT NULL default '0',
  `isITEM` int(11) NOT NULL default '0',
  `isTOTALPRICE` int(11) NOT NULL default '0',
  `isQTY` int(11) NOT NULL default '0',
  `isTIME` int(11) NOT NULL default '0',
  `isCONTENT` text NOT NULL,
  PRIMARY KEY  (`isID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemselllogs`
--


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

--
-- Table structure for table `itemtypes`
--

CREATE TABLE `itemtypes` (
  `itmtypeid` int(11) NOT NULL auto_increment,
  `itmtypename` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`itmtypeid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemtypes`
--


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

--
-- Table structure for table `itemxferlogs`
--

CREATE TABLE `itemxferlogs` (
  `ixID` int(11) NOT NULL auto_increment,
  `ixFROM` int(11) NOT NULL default '0',
  `ixTO` int(11) NOT NULL default '0',
  `ixITEM` int(11) NOT NULL default '0',
  `ixQTY` int(11) NOT NULL default '0',
  `ixTIME` int(11) NOT NULL default '0',
  `ixFROMIP` varchar(255) NOT NULL default '',
  `ixTOIP` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ixID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `itemxferlogs`
--


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

--
-- Table structure for table `jaillogs`
--

CREATE TABLE `jaillogs` (
  `jaID` int(11) NOT NULL auto_increment,
  `jaJAILER` int(11) NOT NULL default '0',
  `jaJAILED` int(11) NOT NULL default '0',
  `jaDAYS` int(11) NOT NULL default '0',
  `jaREASON` longtext NOT NULL,
  `jaTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`jaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jaillogs`
--


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

--
-- Table structure for table `jobranks`
--

CREATE TABLE `jobranks` (
  `jrID` int(11) NOT NULL auto_increment,
  `jrNAME` varchar(255) NOT NULL default '',
  `jrJOB` int(11) NOT NULL default '0',
  `jrPAY` int(11) NOT NULL default '0',
  `jrIQG` int(11) NOT NULL default '0',
  `jrLABOURG` int(11) NOT NULL default '0',
  `jrSTRG` int(11) NOT NULL default '0',
  `jrIQN` int(11) NOT NULL default '0',
  `jrLABOURN` int(11) NOT NULL default '0',
  `jrSTRN` int(11) NOT NULL default '0',
  PRIMARY KEY  (`jrID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jobranks`
--


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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `jID` int(11) NOT NULL auto_increment,
  `jNAME` varchar(255) NOT NULL default '',
  `jFIRST` int(11) NOT NULL default '0',
  `jDESC` varchar(255) NOT NULL default '',
  `jOWNER` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`jID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `jobs`
--


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

--
-- Table structure for table `mail`
--

CREATE TABLE `mail` (
  `mail_id` int(11) NOT NULL auto_increment,
  `mail_read` int(11) NOT NULL default '0',
  `mail_from` int(11) NOT NULL default '0',
  `mail_to` int(11) NOT NULL default '0',
  `mail_time` int(11) NOT NULL default '0',
  `mail_subject` varchar(255) NOT NULL default '',
  `mail_text` text NOT NULL,
  PRIMARY KEY  (`mail_id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `mail`
--


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

--
-- Table structure for table `oclogs`
--

CREATE TABLE `oclogs` (
  `oclID` int(11) NOT NULL auto_increment,
  `oclOC` int(11) NOT NULL default '0',
  `oclGANG` int(11) NOT NULL default '0',
  `oclLOG` text NOT NULL,
  `oclRESULT` enum('success','failure') NOT NULL default 'success',
  `oclMONEY` int(11) NOT NULL default '0',
  `ocCRIMEN` varchar(255) NOT NULL default '',
  `ocTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`oclID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `oclogs`
--


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

--
-- Table structure for table `orgcrimes`
--

CREATE TABLE `orgcrimes` (
  `ocID` int(11) NOT NULL auto_increment,
  `ocNAME` varchar(255) NOT NULL default '',
  `ocUSERS` int(11) NOT NULL default '0',
  `ocSTARTTEXT` text NOT NULL,
  `ocSUCCTEXT` text NOT NULL,
  `ocFAILTEXT` text NOT NULL,
  `ocMINMONEY` int(11) NOT NULL default '0',
  `ocMAXMONEY` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ocID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `orgcrimes`
--


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

--
-- Table structure for table `papercontent`
--

CREATE TABLE `papercontent` (
  `content` longtext NOT NULL
) ENGINE=MyISAM ;

INSERT INTO `papercontent` VALUES('Here you can put game news, or prehaps an update log.');


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

--
-- Table structure for table `polls`
--

CREATE TABLE `polls` (
  `id` int(11) NOT NULL auto_increment,
  `active` enum('0','1') NOT NULL default '0',
  `question` varchar(255) NOT NULL default '',
  `choice1` varchar(255) NOT NULL default '',
  `choice2` varchar(255) NOT NULL default '',
  `choice3` varchar(255) NOT NULL default '',
  `choice4` varchar(255) NOT NULL default '',
  `choice5` varchar(255) NOT NULL default '',
  `choice6` varchar(255) NOT NULL default '',
  `choice7` varchar(255) NOT NULL default '',
  `choice8` varchar(255) NOT NULL default '',
  `choice9` varchar(255) NOT NULL default '',
  `choice10` varchar(255) NOT NULL default '',
  `voted1` int(11) NOT NULL default '0',
  `voted2` int(11) NOT NULL default '0',
  `voted3` int(11) NOT NULL default '0',
  `voted4` int(11) NOT NULL default '0',
  `voted5` int(11) NOT NULL default '0',
  `voted6` int(11) NOT NULL default '0',
  `voted7` int(11) NOT NULL default '0',
  `voted8` int(11) NOT NULL default '0',
  `voted9` int(11) NOT NULL default '0',
  `voted10` int(11) NOT NULL default '0',
  `votes` int(11) NOT NULL default '0',
  `winner` int(11) NOT NULL default '0',
  `hidden` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `polls`
--


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

--
-- Table structure for table `preports`
--

CREATE TABLE `preports` (
  `prID` int(11) NOT NULL auto_increment,
  `prREPORTER` int(11) NOT NULL default '0',
  `prREPORTED` int(11) NOT NULL default '0',
  `prTEXT` longtext NOT NULL,
  PRIMARY KEY  (`prID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `preports`
--


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

--
-- Table structure for table `referals`
--

CREATE TABLE `referals` (
  `refID` int(11) NOT NULL auto_increment,
  `refREFER` int(11) NOT NULL default '0',
  `refREFED` int(11) NOT NULL default '0',
  `refTIME` int(11) NOT NULL default '0',
  `refREFERIP` varchar(15) NOT NULL default '127.0.0.1',
  `refREFEDIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`refID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `referals`
--


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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `conf_id` int(11) NOT NULL auto_increment,
  `conf_name` varchar(255) NOT NULL default '',
  `conf_value` text NOT NULL,
  PRIMARY KEY  (`conf_id`)
) ENGINE=MyISAM ;

INSERT INTO `settings` VALUES (NULL, 'validate_period', '15');
INSERT INTO `settings` VALUES (NULL, 'validate_on', '0');
INSERT INTO `settings` VALUES (NULL, 'regcap_on', '0');
INSERT INTO `settings` VALUES (NULL, 'hospital_count', '0');
INSERT INTO `settings` VALUES (NULL, 'jail_count', '0');
INSERT INTO `settings` VALUES (NULL, 'sendcrys_on', '1');
INSERT INTO `settings` VALUES (NULL, 'sendbank_on', '1');
INSERT INTO `settings` VALUES (NULL, 'ct_refillprice', '12');
INSERT INTO `settings` VALUES (NULL, 'ct_iqpercrys', '5');
INSERT INTO `settings` VALUES (NULL, 'ct_moneypercrys', '200');
INSERT INTO `settings` VALUES (NULL, 'staff_pad', 'Here you can store notes for all staff to see.');
INSERT INTO `settings` VALUES (NULL, 'willp_item', '0');
INSERT INTO `settings` VALUES (NULL, 'jquery_location', 'js/jquery-1.7.1.min.js');


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

--
-- Table structure for table `shopitems`
--

CREATE TABLE `shopitems` (
  `sitemID` int(11) NOT NULL auto_increment,
  `sitemSHOP` int(11) NOT NULL default '0',
  `sitemITEMID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sitemID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `shopitems`
--


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

--
-- Table structure for table `shops`
--

CREATE TABLE `shops` (
  `shopID` int(11) NOT NULL auto_increment,
  `shopLOCATION` int(11) NOT NULL default '0',
  `shopNAME` varchar(255) NOT NULL default '',
  `shopDESCRIPTION` text NOT NULL,
  PRIMARY KEY  (`shopID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `shops`
--


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

--
-- Table structure for table `stafflog`
--

CREATE TABLE `stafflog` (
  `id` int(11) NOT NULL auto_increment,
  `user` int(11) NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `action` varchar(255) NOT NULL default '',
  `ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `stafflog`
--


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

--
-- Table structure for table `staffnotelogs`
--

CREATE TABLE `staffnotelogs` (
  `snID` int(11) NOT NULL auto_increment,
  `snCHANGER` int(11) NOT NULL default '0',
  `snCHANGED` int(11) NOT NULL default '0',
  `snTIME` int(11) NOT NULL default '0',
  `snOLD` longtext NOT NULL,
  `snNEW` longtext NOT NULL,
  PRIMARY KEY  (`snID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `staffnotelogs`
--


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

--
-- Table structure for table `surrenders`
--

CREATE TABLE `surrenders` (
  `surID` int(11) NOT NULL auto_increment,
  `surWAR` int(11) NOT NULL default '0',
  `surWHO` int(11) NOT NULL default '0',
  `surTO` int(11) NOT NULL default '0',
  `surMSG` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`surID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `surrenders`
--


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

--
-- Table structure for table `unjaillogs`
--

CREATE TABLE `unjaillogs` (
  `ujaID` int(11) NOT NULL auto_increment,
  `ujaJAILER` int(11) NOT NULL default '0',
  `ujaJAILED` int(11) NOT NULL default '0',
  `ujaTIME` int(11) NOT NULL default '0',
  PRIMARY KEY  (`ujaID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `unjaillogs`
--


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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL default '',
  `userpass` varchar(255) NOT NULL default '',
  `level` int(11) NOT NULL default '0',
  `exp` decimal(11,4) NOT NULL default '0.0000',
  `money` int(11) NOT NULL default '0',
  `crystals` int(11) NOT NULL default '0',
  `laston` int(11) NOT NULL default '0',
  `lastip` varchar(255) NOT NULL default '',
  `job` int(11) NOT NULL default '0',
  `energy` int(11) NOT NULL default '0',
  `will` int(11) NOT NULL default '0',
  `maxwill` int(11) NOT NULL default '0',
  `brave` int(11) NOT NULL default '0',
  `maxbrave` int(11) NOT NULL default '0',
  `maxenergy` int(11) NOT NULL default '0',
  `hp` int(11) NOT NULL default '0',
  `maxhp` int(11) NOT NULL default '0',
  `lastrest_life` int(11) NOT NULL default '0',
  `lastrest_other` int(11) NOT NULL default '0',
  `location` int(11) NOT NULL default '0',
  `hospital` int(11) NOT NULL default '0',
  `jail` int(11) NOT NULL default '0',
  `jail_reason` varchar(255) NOT NULL default '',
  `fedjail` int(11) NOT NULL default '0',
  `user_level` int(11) NOT NULL default '1',
  `gender` enum('Male','Female') NOT NULL default 'Male',
  `daysold` int(11) NOT NULL default '0',
  `signedup` int(11) NOT NULL default '0',
  `gang` int(11) NOT NULL default '0',
  `daysingang` int(11) NOT NULL default '0',
  `course` int(11) NOT NULL default '0',
  `cdays` int(11) NOT NULL default '0',
  `jobrank` int(11) NOT NULL default '0',
  `donatordays` int(11) NOT NULL default '0',
  `email` varchar(255) NOT NULL default '',
  `login_name` varchar(255) NOT NULL default '',
  `display_pic` text NULL,
  `duties` varchar(255) NOT NULL default 'N/A',
  `bankmoney` int(11) NOT NULL default '0',
  `cybermoney` int(11) NOT NULL default '-1',
  `staffnotes` longtext NULL,
  `mailban` int(11) NOT NULL default '0',
  `mb_reason` varchar(255) NOT NULL default '',
  `hospreason` varchar(255) NOT NULL default '',
  `lastip_login` varchar(255) NOT NULL default '127.0.0.1',
  `lastip_signup` varchar(255) NOT NULL default '127.0.0.1',
  `last_login` int(11) NOT NULL default '0',
  `voted` text NULL,
  `crimexp` int(11) NOT NULL default '0',
  `attacking` int(11) NOT NULL default '0',
  `verified` int(11) NOT NULL default '0',
  `forumban` int(11) NOT NULL default '0',
  `fb_reason` varchar(255) NOT NULL default '',
  `posts` int(11) NOT NULL default '0',
  `forums_avatar` varchar(255) NOT NULL default '',
  `forums_signature` varchar(250) NOT NULL default '',
  `new_events` int(11) NOT NULL default '0',
  `new_mail` int(11) NOT NULL default '0',
  `friend_count` int(11) NOT NULL default '0',
  `enemy_count` int(11) NOT NULL default '0',
  `new_announcements` int(11) NOT NULL default '0',
  `boxes_opened` int(11) NOT NULL default '0',
  `user_notepad` text NOT NULL,
  `equip_primary` int(11) NOT NULL default '0',
  `equip_secondary` int(11) NOT NULL default '0',
  `equip_armor` int(11) NOT NULL default '0',
  `force_logout` tinyint(4) NOT NULL default '0',
  `pass_salt` varchar(8) NOT NULL default '',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM ;
--
-- Dumping data for table `users`
--


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

--
-- Table structure for table `userstats`
--

CREATE TABLE `userstats` (
  `userid` int(11) NOT NULL default '0',
  `strength` float NOT NULL default '0',
  `agility` float NOT NULL default '0',
  `guard` float NOT NULL default '0',
  `labour` float NOT NULL default '0',
  `IQ` float NOT NULL default '0',
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `userstats`
--


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

--
-- Table structure for table `votes`
--

CREATE TABLE `votes` (
  `userid` int(11) NOT NULL default '0',
  `list` varchar(255) NOT NULL default ''
) ENGINE=MyISAM ;

--
-- Dumping data for table `votes`
--


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

--
-- Table structure for table `willps_accepted`
--

CREATE TABLE `willps_accepted` (
  `dpID` int(11) NOT NULL auto_increment,
  `dpBUYER` int(11) NOT NULL default '0',
  `dpFOR` int(11) NOT NULL default '0',
  `dpAMNT` varchar(255) NOT NULL default '',
  `dpTIME` int(11) NOT NULL default '0',
  `dpTXN` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`dpID`)
) ENGINE=MyISAM ;

--
-- Dumping data for table `willps_accepted`
--

Ob4j4 · November 27, 2022

Okay, I removed default values in some places in the dbdata sql and got the installer to work. Is there any way to execute crons on xampp?


1. Diagnostics >> 2. Configuration >> 3. Installation & Extras
Attempting DB connection...
... Successful.
Writing game config file...
Write Config...
... file written.
Writing base database schema...
... done.
Writing game configuration...
... Done.
Installation Complete!
Cron Info

This is the cron info you need for section 1.2 Cronjobs of the installation instructions.
    */5 * * * * php C:/xampp/htdocs/cron_fivemins.php f1117449c91394f07448555021006431
    * * * * * php C:/xampp/htdocs/cron_minute.php f1117449c91394f07448555021006431
    0 * * * * php C:/xampp/htdocs/cron_hour.php f1117449c91394f07448555021006431
    0 0 * * * php C:/xampp/htdocs/cron_day.php f1117449c91394f07448555021006431
    
Installer Security
Attempting to remove installer... Succeeded

AlizHarb · November 27, 2022

i have never tried to setup cron on xampp, but you can try this

Create a cron.php file
Open the file cron.php and paste or type the code given below
C:\xampp\php\php.exe D:\xampp\htdocs\executecron.php
The path may be varies depending upon your xampp folder
And now we had to schedule the task to run
Click on start > All Programs > Accessories > System Tools > Scheduled Tasks and put a name for the task and in the run text field give the path of the Cron.php file and set the schedule job and its done

Ob4j4 · November 27, 2022

Okay, so everything is more or less working by the looks of it but I still get errors here and there like so

A non-critical error has occurred. Page execution will continue. Below are the details:
PHP Deprecation Notice: htmlentities(): Passing null to parameter #1 ($string) of type string is deprecated (8192)

So I changed this by removing the htmlentities etc.

<textarea rows='10' cols='50' name='pn_update'>"
        . htmlentities($ir['user_notepad'], ENT_QUOTES, 'ISO-8859-1')
        . "</textarea><br />

to

<textarea rows='10' cols='50' name='pn_update'>".($ir['user_notepad'])."</textarea><br />

6 minutes ago, AlizHarb said:

i have never tried to setup cron on xampp, but you can try this

Create a cron.php file

Open the file cron.php and paste or type the code given below

C:\xampp\php\php.exe D:\xampp\htdocs\executecron.php

The path may be varies depending upon your xampp folder

And now we had to schedule the task to run

Click on start > All Programs > Accessories > System Tools > Scheduled Tasks and put a name for the task and in the run text field give the path of the Cron.php file and set the schedule job and its done

D:\ is my cd/dvd drive? And I don't have an executecron.php

Installer not working

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation