Jump to content
MakeWebGames

Ob4j4

Members
 View Profile  See their activity

  • Posts

    21

  • Joined

  • Last visited

Recent Profile Visitors

346 profile views

Ob4j4's Achievements

Contributor

Contributor (5/14)

  • Collaborator Rare
  • One Month Later
  • Week One Done
  • Dedicated Rare
  • First Post Rare

Recent Badges

0

Reputation

  1. Ob4j4
    <?php class headers { function startheaders() { global $ir, $set; echo <<<EOF <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <link href="css/game.css" type="text/css" rel="stylesheet" /> <title>{$set['game_name']}</title> </head> <body> <center> <table width="970" border="0" cellpadding="0" cellspacing="0" class="table2"> <tr> <td class="lgrad"></td> <td class="center"> EOF; } function userdata($ir, $lv, $fm, $cm, $dosessh = 1) { global $db, $c, $userid, $set; $IP = $db->escape($_SERVER['REMOTE_ADDR']); $db->query( "UPDATE `users` SET `laston` = {$_SERVER['REQUEST_TIME']}, `lastip` = '$IP' WHERE `userid` = $userid"); if (!$ir['email']) { global $domain; die( "<body>Your account may be broken. Please mail help@{$domain} stating your username and player ID."); } if (!isset($_SESSION['attacking'])) { $_SESSION['attacking'] = 0; } if ($dosessh && ($_SESSION['attacking'] || $ir['attacking'])) { echo "You lost all your EXP for running from the fight."; $db->query( "UPDATE `users` SET `exp` = 0, `attacking` = 0 WHERE `userid` = $userid"); $_SESSION['attacking'] = 0; } $enperc = min((int) ($ir['energy'] / $ir['maxenergy'] * 100), 100); $wiperc = min((int) ($ir['will'] / $ir['maxwill'] * 100), 100); $experc = min((int) ($ir['exp'] / $ir['exp_needed'] * 100), 100); $brperc = min((int) ($ir['brave'] / $ir['maxbrave'] * 100), 100); $hpperc = min((int) ($ir['hp'] / $ir['maxhp'] * 100), 100); $enopp = 100 - $enperc; $wiopp = 100 - $wiperc; $exopp = 100 - $experc; $bropp = 100 - $brperc; $hpopp = 100 - $hpperc; $d = ""; $u = $ir['username']; if ($ir['donatordays']) { $u = "<span style='color: red;'>{$ir['username']}</span>"; $d = "<img src='donator.gif' alt='Donator: {$ir['donatordays']} Days Left' title='Donator: {$ir['donatordays']} Days Left' />"; } $gn = ""; global $staffpage; $bgcolor = 'FFFFFF'; $time=time(); $timediff=time()-$ir['lastupdate']; while($timediff > 299) $timediff=$timediff-300; //Update our lastupdate field in the users table if we are finished. if($timediff<300) { $ir['lastupdate']=$time-$timediff; $db->query("UPDATE `users` SET `lastupdate` = {$ir['lastupdate']} WHERE `userid` = {$userid}"); } print <<<OUT <img src="title.jpg" alt="Mccodes Version 2" /><br /> <!-- Begin Main Content --> <table width="100%" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="20%" bgcolor="#$bgcolor" valign="top"> <!-- Side Panel --> <b>Name:</b> $gn{$u} [{$ir['userid']}] $d<br /> <b>Money:</b> {$fm}<br /> <b>Level:</b> {$ir['level']}<br /> <b>Crystals:</b> {$ir['crystals']}<br /> [<a href='logout.php'>Emergency Logout</a>] <hr /> <b>Energy:</b> {$enperc}%<br /> <img src='greenbar.png' width='$enperc' height='10' /><img src='redbar.png' width='$enopp' height='10' /><br /> <b>Will:</b> {$wiperc}%<br /> <img src='bluebar.png' width='$wiperc' height='10' /><img src='redbar.png' width='$wiopp' height='10' /><br /> <b>Brave:</b> {$ir['brave']}/{$ir['maxbrave']}<br /> <img src='yellowbar.png' width='$brperc' height='10' /><img src='redbar.png' width='$bropp' height='10' /><br /> <b>EXP:</b> {$experc}%<br /> <img src='navybar.png' width='$experc' height='10' /><img src='redbar.png' width='$exopp' height='10' /><br /> <b>Health:</b> {$hpperc}%<br /> <img src='greenbar.png' width='$hpperc' height='10' /><img src='redbar.png' width='$hpopp' height='10' /><br /> <b>Regen:</b> {$timediff} <hr /> <!-- Links --> OUT; if ($ir['fedjail'] > 0) { $q = $db->query( "SELECT * FROM `fedjail` WHERE `fed_userid` = $userid"); $r = $db->fetch_row($q); die( "<span style='font-weight: bold; color:red;'> You have been put in the {$set['game_name']} Federal Jail for {$r['fed_days']} day(s).<br /> Reason: {$r['fed_reason']} </span></body></html>"); } if (file_exists('ipbans/' . $IP)) { die( "<span style='font-weight: bold; color:red;'> Your IP has been banned from {$set['game_name']}, there is no way around this. </span></body></html>"); } } function menuarea() { define('jdsf45tji', true); include 'mainmenu.php'; global $ir, $c; $bgcolor = 'FFFFFF'; print '</td><td width="2" class="linegrad" bgcolor="#' . $bgcolor . '">&nbsp;</td><td width="80%" bgcolor="#' . $bgcolor . '" valign="top"><br /><center>'; if ($ir['hospital']) { echo "<b>NB:</b> You are currently in hospital for {$ir['hospital']} minutes.<br />"; } if ($ir['jail']) { echo "<b>NB:</b> You are currently in jail for {$ir['jail']} minutes.<br />"; } echo "<a href='donator.php'><b>Donate to {$set['game_name']} now for game benefits!</b></a><br />"; } function smenuarea() { define('jdsf45tji', true); include 'smenu.php'; global $ir, $c; $bgcolor = 'FFFFFF'; print '</td><td width="2" class="linegrad" bgcolor="#' . $bgcolor . '">&nbsp;</td><td width="80%" bgcolor="#' . $bgcolor . '" valign="top"><center>'; } function endpage() { global $db, $ir; $query_extra = ''; if (isset($_GET['mysqldebug']) && $ir['user_level'] == 2) { $query_extra = '<br />' . implode('<br />', $db->queries); } print <<<OUT </center> </td> </tr> </table></td> <td class="rgrad"></td> </tr> <tr> <td colspan="3"> <table cellpadding="0" cellspacing="0" border="0" width="100%"> <tr> <td class="dgradl">&nbsp;</td> <td class="dgrad">&nbsp;</td> <td class="dgradr">&nbsp;</td> </tr> </table> </td> </tr> </table> {$db->num_queries} queries{$query_extra}</body> </html> OUT; } } This is my header file. And this is my globals: <?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: globals.php * Signature: 7b716433581858a154d2ae09ab90f269 * Date: Fri, 20 Apr 12 08:50:30 +0000 */ if (strpos($_SERVER['PHP_SELF'], "globals.php") !== false) { exit; } session_name('MCCSID'); session_start(); if (!isset($_SESSION['started'])) { session_regenerate_id(); $_SESSION['started'] = true; } ob_start(); if (function_exists("get_magic_quotes_gpc") == false) { function get_magic_quotes_gpc() { return 0; } } if (get_magic_quotes_gpc() == 0) { foreach ($_POST as $k => $v) { $_POST[$k] = addslashes($v); } foreach ($_GET as $k => $v) { $_GET[$k] = addslashes($v); } } require "lib/basic_error_handler.php"; set_error_handler('error_php'); require "global_func.php"; $domain = determine_game_urlbase(); if (!isset($_SESSION['loggedin']) || $_SESSION['loggedin'] == 0) { $login_url = "http://{$domain}/login.php"; header("Location: {$login_url}"); exit; } $userid = isset($_SESSION['userid']) ? $_SESSION['userid'] : 0; require "header.php"; include "config.php"; define("MONO_ON", 1); require "class/class_db_{$_CONFIG['driver']}.php"; $db = new database; $db->configure($_CONFIG['hostname'], $_CONFIG['username'], $_CONFIG['password'], $_CONFIG['database'], $_CONFIG['persistent']); $db->connect(); $c = $db->connection_id; $set = array(); $settq = $db->query("SELECT * FROM `settings`"); while ($r = $db->fetch_row($settq)) { $set[$r['conf_name']] = $r['conf_value']; } global $jobquery, $housequery; if (isset($jobquery) && $jobquery) { $is = $db->query( "SELECT `u`.*, `us`.*, `j`.*, `jr`.* FROM `users` AS `u` INNER JOIN `userstats` AS `us` ON `u`.`userid`=`us`.`userid` LEFT JOIN `jobs` AS `j` ON `j`.`jID` = `u`.`job` LEFT JOIN `jobranks` AS `jr` ON `jr`.`jrID` = `u`.`jobrank` WHERE `u`.`userid` = {$userid} LIMIT 1"); } else if (isset($housequery) && $housequery) { $is = $db->query( "SELECT `u`.*, `us`.*, `h`.* FROM `users` AS `u` INNER JOIN `userstats` AS `us` ON `u`.`userid`=`us`.`userid` LEFT JOIN `houses` AS `h` ON `h`.`hWILL` = `u`.`maxwill` WHERE `u`.`userid` = {$userid} LIMIT 1"); } else { $is = $db->query( "SELECT `u`.*, `us`.* FROM `users` AS `u` INNER JOIN `userstats` AS `us` ON `u`.`userid`=`us`.`userid` WHERE `u`.`userid` = {$userid} LIMIT 1"); } $ir = $db->fetch_row($is); if ($ir['force_logout'] != '0') { $db->query( "UPDATE `users` SET `force_logout` = 0 WHERE `userid` = {$userid}"); session_unset(); session_destroy(); $login_url = "http://{$domain}/login.php"; header("Location: {$login_url}"); exit; } global $macropage; if ($macropage && !$ir['verified'] && $set['validate_on'] == 1) { $macro_url = "http://{$domain}/macro1.php?refer=$macropage"; header("Location: {$macro_url}"); exit; } //Crons for Energy, Will, Brave, and HP. $willadded=$set['willregen']; $braveadded=$set['braveregen']; $donatorenergy=$set['donatorenergyregen']; $nondonatorenergy=$set['nondonatorenergyregen']; $donatorhp=$set['donatorhpregen']; $nondonatorhp=$set['nondonatorhpregen']; $time=time(); $timediff=time()-$ir['lastupdate']; while($timediff > 299) { //Update Will, if needed. if($ir['will']<$ir['maxwill']) { $db->query("UPDATE `users` SET `will` = `will` + {$willadded} WHERE `userid` = {$userid}"); $ir['will']=$ir['will']+$willadded; } //Update Brave, if needed. if($ir['brave']<$ir['maxbrave']) { $db->query("UPDATE `users` SET `brave` = `brave` + {$braveadded} WHERE `userid` = {$userid}"); $ir['brave']=$ir['brave']+$braveadded; } //Determine how much Energy/HP should be added based on Donator Status. if($ir['donatordays']>0) { $energyadded=$donatorenergy; $hpadded=round($ir['hp']*$donatorhp); }else{ $energyadded=$nondonatorenergy; $hpadded=round($ir['hp']*$nondonatorhp); } //Update Energy, if needed. if($ir['energy']<$ir['maxenergy']) { $energyupdate=$ir['energy']+$energyadded; if($energyupdate>$ir['maxenergy']) { $db->query("UPDATE `users` SET `energy` = `maxenergy` WHERE `userid` = {$userid}"); $ir['energy']=$ir['maxenergy']; }else{ $db->query("UPDATE `users` SET `energy` = {$energyupdate} WHERE `userid` = {$userid}"); $ir['energy']=$energyupdate; } } //Update HP, if needed. if($ir['hp']<$ir['maxhp']) { $hpupdate=$ir['hp']+$hpadded; if($hpupdate>$ir['maxhp']) { $db->query("UPDATE `users` SET `hp` = `maxhp` WHERE `userid` = {$userid}"); $ir['hp']=$ir['maxhp']; }else{ $db->query("UPDATE `users` SET `hp` = {$hpupdate} WHERE `userid` = {$userid}"); $ir['hp']=$hpupdate; } } $timediff=$timediff-300; //Update our lastupdate field in the users table if we are finished. if($timediff<300) { $ir['lastupdate']=$time-$timediff; $db->query("UPDATE `users` SET `lastupdate` = {$ir['lastupdate']} WHERE `userid` = {$userid}"); } } check_level(); $h = new headers; if (isset($nohdr) == false || !$nohdr) { $h->startheaders(); $fm = money_formatter($ir['money']); $cm = money_formatter($ir['crystals'], ''); $lv = date('F j, Y, g:i a', $ir['laston']); global $atkpage; if ($atkpage) { $h->userdata($ir, $lv, $fm, $cm, 0); } else { $h->userdata($ir, $lv, $fm, $cm); } global $menuhide; if (!$menuhide) { $h->menuarea(); } } I'm getting really big numbers, in some cases minus ones.
  2. Ob4j4
  3. Ob4j4
    I've added the code into the header. Just don't know what line of code to add to view the regen counter.
  4. Ob4j4
    How do I add the timediff variable in the header?
  5. Ob4j4
    Parse error: syntax error, unexpected string content "", expecting "-" or identifier or variable or number in C:\xampp\htdocs\index.php on line 60
  6. Ob4j4
    Parse error: syntax error, unexpected identifier "notepad", expecting "," or ";" in C:\xampp\htdocs\index.php on line 58
  7. Ob4j4
    Like this? Does not work
  8. Ob4j4
    Yes I assume taking away the htmlentities makes it less secure. But I'm working offline and I don't know how to secure it in a different way. 1. The First thing you should do is to create a cron.php file 2. Open the file cron.php and paste or type the code given below D:\xampp\php\php.exe D:\xampp\htdocs\executecron.php The path may be varies depending upon your xampp folder 3. 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 Also are you sure this is not missing a step? I created a cron.php file In it I added the line C:\xampp\php\php.exe C:\xampp\htdocs\executecron.php Should I make a execute cron file too? If so, what do I put in it?
  9. Ob4j4
    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 /> D:\ is my cd/dvd drive? And I don't have an executecron.php
  10. Ob4j4
    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
  11. Ob4j4
    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
  12. Ob4j4
    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
  13. Ob4j4
    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
  14. Ob4j4
    That's ridiculous
  15. Ob4j4
    You have to rebuy a license?
×
×
  • Create New...