Ob4j4 Posted November 26, 2022 Posted 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 Quote
orsino Posted November 26, 2022 Posted 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 Quote
lucky3809 Posted November 26, 2022 Posted 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. Quote
Ob4j4 Posted November 26, 2022 Author Posted 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 Quote
Veramys Posted November 26, 2022 Posted 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. Quote
Ob4j4 Posted November 26, 2022 Author Posted November 26, 2022 I only have a license on mccodes.com Quote
Veramys Posted November 26, 2022 Posted 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 Quote
Veramys Posted November 26, 2022 Posted November 26, 2022 Learn to code or buy the fresh copy of mccodes on here. Quote
Veramys Posted November 26, 2022 Posted 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. Quote
Uridium Posted November 26, 2022 Posted November 26, 2022 ob4J4 can you lower your php version from your host usually 5.6 Quote
Veramys Posted November 26, 2022 Posted 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 Quote
KyleMassacre Posted November 26, 2022 Posted 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 Quote
Ob4j4 Posted November 27, 2022 Author Posted 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 /> > <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> > <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 Quote
KyleMassacre Posted November 27, 2022 Posted 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 Quote
Ob4j4 Posted November 27, 2022 Author Posted 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 Quote
AlizHarb Posted November 27, 2022 Posted November 27, 2022 (edited) 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 Quote
Ob4j4 Posted November 27, 2022 Author Posted 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 Quote
Veramys Posted November 27, 2022 Posted November 27, 2022 (edited) 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 Quote
AlizHarb Posted November 27, 2022 Posted 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` -- Quote
Ob4j4 Posted November 27, 2022 Author Posted 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 Quote
AlizHarb Posted November 27, 2022 Posted 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 Quote
Ob4j4 Posted November 27, 2022 Author Posted 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 Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.