Halo

Re: Total Crime Income FREE fanx

Re: Total Crime Income FREE This is the crime failed mod, i only did crime failed because when you try and do both they both go up even when you didn't fail a crime, SQL   ALTER TABLE `users` ADD `cfailed` INT(11) NOT NULL DEFAULT '0';   Add in viewuser.php Crimes Failed: {$r['cfailed']}   Add in docrime.php mysql_query("UPDATE users SET cfailed=cfailed+1 WHERE userid=$userid", $c);

Re: Total Crime Income FREE kk i signing up

Re: Total Crime Income FREE   yh i'm doing that for my new mods

Re: Total Crime Income FREE Danny6 whats wrong with your game when i want to sign up the register page is full with queries and text that should be invisble when its on the web

Re: Total Crime Income FREE yh it works, but i will just keep it like it is I am going to be making other stuff e.g Total Crime Failed, Total Crime Success etc...

Re: Total Crime Income FREE   I'm on my PSP atm so i cant but when i get on the PC or laptop i will

Re: Total Crime Income FREE   gd idea

Re: Money,crystals cap   LOL!! Can (92,4) also be used on money/banks so you can have that much, instead of a 'tiny' cap of 9,223,372,036,854,775,807!! :-D :-D To change how much you can keep in banks you just have to change (int) to (float)

This is a very easy code but for people who ain't bothered to make it here it is: SQL QUERY   ALTER TABLE `users` ADD `cincome` INT(11) NOT NULL DEFAULT '0';   Add In docrime.php   mysql_query("UPDATE users SET cincome=cincome+{$r['crimeSUCCESSMUNY']} WHERE userid=$userid",$c);   Add in veiwuser.php   Crime Income: \${$r['cincome']}   And your done

Re: My Newist Discovery Thanks for thta mate i was trying to find out how to stop it

Re: Updated Mailbox [v1] It dosn't display the smilies when you are composing but it displays them in the mail

Re: [Free] MySQL Control Panel Well i did this for now, not sure if it works   <?php /*----------------------------------------------------- -- MySQL Admin -- Copyright held 2007-2008 by Isomerizer.com -- Free Source Script. -- sqladmin.php -----------------------------------------------------*/ session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); if($ir['userid'] != 1) { print "Only ID 1 Can Access The MySQL Panel, [url='explore.php']go back[/url]!"; $h->endpage(); exit(); } echo '<h3>MySQL Control Panel</h3>'; switch($_GET['sql']) { case 'update': update(); break; case 'select': select(); break; case 'drop': drop(); break; case 'delete': delete(); break; case 'truncate': truncate(); break; default: sql_index(); break; } function select_tables() { global $c; $tables = mysql_query("SHOW TABLES"); echo '<select name="table">'; $databasename = 'yourdb_yourdb'; // <---- PSST Edit Database name! $table = 'Tables_in_'.$databasename; while($tab = mysql_fetch_object($tables)) { $name = $tab->$table; echo '<option value="'.$name.'">'.$name.'</option>'; } echo '</select>'; } function sql_commands() { echo '<select name="sql_commands"> <option value="=">=</option> <option value="!=">!=</option> </select>'; } function check_pass() { global $h; // Password Verification $salt="helloce"; // Edit Salt! $password=md5("$salt"."lol"); // Edit Password! $input=$_POST['password']; $input_password=md5("$salt"."$input"); if ($input_password != $password) { echo '<font color="red">Access Denied!</font> [url="'.$_SERVER['PHP_SELF'].'"]Back[/url]'; $h->endpage(); exit; } } function anti_injection($string) { global $c; if (ini_get('magic_quotes_gpc')) { $string = stripslashes($string); } $string = mysql_real_escape_string(htmlentities(trim($string)), $c); return $string; } if ($_GET['sql']!='update' && $_GET['sql']!='select' && $_GET['sql']!='drop' && $_GET['sql']!='delete' && $_GET['sql']!='truncate') { echo 'Invalid use of file!'; $h->endpage(); exit; // If sql is unknown } function back_index() { echo ' [url="'.$_SERVER['PHP_SELF'].'"]Back[/url]'; } function end_script() { global $h; $h->endpage(); exit; } function sql_index() { global $ir,$c,$userid,$h; echo '<form action="'.$_SERVER['PHP_SELF'].'" method="GET"> Command: <select name="sql"> <option value="update">UPDATE</option> <option value="select">SELECT</option> <option value="delete">DELETE</option> <option value="drop">DROP</option> <option value="truncate">TRUNCATE</option> </select> <input type="submit" value="Perform" /></form> <hr width="75%" /> Information... Here you can execute an MySQL command without editing your source code or accessing PhpMyAdmin.</p>'; end_script(); } function update() { global $ir,$c,$userid,$h; if (isset($_POST['execute']) && isset($_POST['password'])) { check_pass(); $table = anti_injection($_POST['table']); $where = anti_injection($_POST['where']); $where_what = anti_injection($_POST['where_what']); $commands = anti_injection($_POST['sql_commands']); $equals = anti_injection($_POST['equals']); $limit = anti_injection($_POST['limit']); $column = anti_injection($_POST['column']); if (empty($limit)) { $limit=0; } if (abs(@intval($where_what))) { $where_what = ''.$where_what.''; } mysql_query ("UPDATE `$table` SET `$column` $commands '$equals'"); if (!empty($where) && !empty($where_what)) { mysql_query("UPDATE `$table` SET `$column` = '$equals' WHERE `$where` $commands $where_what"); } $finish = mysql_query($query, $c); if (!$finish) { echo 'Error: '.mysql_error(); back_index(); end_script(); } else { echo 'MySQL Query Successful! Table: '.$table.' Colum Updated: '.$column.' Updated to: '.$equals; if (!empty($where) && !empty($where_what)) { echo ' WHERE '.$where.' '.$commands.' '.$where_what; } back_index(); end_script(); } } else { echo '<form action="'.$_SERVER['PHP_SELF'].'?sql=update" method="POST"> UPDATE '; select_tables(); echo ' SET <input type="text" size="6" name="column" /> = <input type="text" size="6" name="equals" /> WHERE <input type="text" size="6" name="where" /> '; sql_commands(); echo '<input type="text" size="6" name="where_what" /> Password: <input type="password" name="password" value="" /> <input type="submit" name="execute" value="Execute MySQL" /></form>'; back_index(); end_script(); } } function select() { global $ir,$c,$userid,$h; if (isset($_POST['execute']) && isset($_POST['password'])) { check_pass(); $table = anti_injection($_POST['table']); $where = anti_injection($_POST['where']); $where_what = anti_injection($_POST['where_what']); $commands = anti_injection($_POST['sql_commands']); $equals = anti_injection($_POST['equals']); $limit = anti_injection($_POST['limit']); $select = anti_injection($_POST['select']); if (empty($limit)) { $limit=0; } if (abs(@intval($where_what))) { $where_what = ''.$where_what.''; } mysql_query("SELECT $select FROM `$table` ", $c); if (!empty($where) && !empty($where_what)) { mysql_query("SELECT $select FROM `$table` WHERE `$where` $commands $where_what", $c); } $finish = mysql_query($query, $c); if (!$finish) { echo 'Error: '.mysql_error(); back_index(); end_script(); } else { echo 'MySQL Query Successful! Results (Selecting '.$select.')... '; while($result = mysql_fetch_object($finish)) { echo $result->$select.' '; } back_index(); end_script(); } end_script(); } else { echo '<form action="'.$_SERVER['PHP_SELF'].'?sql=select" method="POST"> SELECT <input type="text" name="select" size="6" /> FROM '; select_tables(); echo ' WHERE <input type="text" size="6" name="where" /> '; sql_commands(); echo '<input type="text" size="6" name="where_what" /> Password: <input type="password" name="password" value="" /> <input type="submit" name="execute" value="Execute MySQL" /></form>'; back_index(); end_script(); } } function delete() { global $ir,$c,$userid,$h; if (isset($_POST['execute']) && isset($_POST['password'])) { check_pass(); $table = anti_injection($_POST['table']); if (empty($limit)) { $limit=0; } if (abs(@intval($where_what))) { $where_what = ''.$where_what.''; } mysql_query ("DELETE FROM `$table`", $c); if (!empty($where) && !empty($where_what)) { mysql_query("DELETE FROM `$table` WHERE `$where` $commands $where_what ", $c); } $finish = mysql_query($query, $c); if (!$finish) { echo 'Error: '.mysql_error(); back_index(); end_script(); } else { echo 'MySQL Query Successful! Selected Content Deleted!'; back_index(); end_script(); } } echo '<form action="'.$_SERVER['PHP_SELF'].'?sql=delete" method="POST"> DELETE FROM '; select_tables(); echo ' WHERE <input type="text" size="6" name="where" /> '; sql_commands(); echo '<input type="text" size="6" name="where_what" /> Password: <input type="password" name="password" value="" /> <input type="submit" name="execute" value="Execute MySQL" /></form>'; back_index(); end_script(); } function drop() { global $ir,$c,$userid,$h; if (isset($_POST['execute']) && isset($_POST['password'])) { check_pass(); $table = anti_injection($_POST['table']); mysql_query ("DROP TABLE `$table`", $c); $finish = mysql_query($query, $c); if (!$finish) { echo 'Error: '.mysql_error(); back_index(); end_script(); } else { echo 'MySQL Query Successful! Table: '.$table.' Dropped!'; back_index(); end_script(); } } echo '<form action="'.$_SERVER['PHP_SELF'].'?sql=drop" method="POST"> DROP TABLE '; select_tables(); echo ' Password: <input type="password" name="password" value="" /> <input type="submit" name="execute" value="Execute MySQL" /></form>'; back_index(); end_script(); } function truncate() { global $ir,$c,$userid,$h; if (isset($_POST['execute']) && isset($_POST['password'])) { check_pass(); $table = anti_injection($_POST['table']); mysql_query("TRUNCATE TABLE `$table`", $c); $finish = mysql_query($query, $c); if (!$finish) { echo 'Error: '.mysql_error(); back_index(); end_script(); } else { echo 'MySQL Query Successful! Table: '.$table.' Emptied!'; back_index(); end_script(); } } echo '<form action="'.$_SERVER['PHP_SELF'].'?sql=truncate" method="POST"> TRUNCATE TABLE '; select_tables(); echo ' Password: <input type="password" name="password" value="" /> <input type="submit" name="execute" value="Execute MySQL" /></form>'; back_index(); end_script(); } ?>

Re: [Free] MySQL Control Panel   lol you should change your name if no one has done it for you when i get home if i rember i will do it lol, i just had to think of a name and this was the first that popped into my head

Re: [Free] MySQL Control Panel Can anyone convert it?

Re: [Free] MySQL Control Panel Great mod, i always was annoyed when i had to login to phpMyAdmin, but thats fixed that! +1 :-D

Re: Updated Mailbox [v1] Richard has made the game very different from TC, i play both Richards and Chedburns game and there are loads of stuff that are different.

Re: Updated Mailbox [v1]   Well Richard's codes are great and his game looks great anyway. c0der aka JJ

Re: Updated Mailbox [v1] Great mod m8, i'm adding it to my game NOW!

Re: Money,crystals cap   [quote="webster2001"] [quote="Dragon_killer123"] [code]ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0', CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0', CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0', CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` bigint( 92 )NOT NULL DEFAULT '0', CHANGE `IQ` `IQ` bigint( 92 )NOT NULL DEFAULT '0', CHANGE `agility` `agility` bigint( 92 )NOT NULL DEFAULT '0', CHANGE `guard` `guard` bigint( 92 )NOT NULL DEFAULT '0', CHANGE `labour` `labour` bigint( 92 )NOT NULL DEFAULT '0',   ALTER TABLE `users` CHANGE `money` `money` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `crystals` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `bankmoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' CHANGE `cybermoney` `crystals` bigint( 92 ) NOT NULL DEFAULT '0' ALTER TABLE `userstats` CHANGE `strength` `strength` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `IQ` `IQ` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `agility` `agility` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `guard` `guard` bigint( 92 )NOT NULL DEFAULT '0' CHANGE `labour` `labour` bigint( 92 )NOT NULL DEFAULT '0' [/code]   Never ever do that with the user stats. To do userstats you just need to replace a few numbers these are the original numbers:   `userid` int(11) NOT NULL default '0', `strength` decimal(10,4) NOT NULL default '0.0000', `agility` decimal(10,4) NOT NULL default '0.0000', `guard` decimal(10,4) NOT NULL default '0.0000', `labour` decimal(10,4) NOT NULL default '0.0000', `IQ` decimal(10,4) NOT NULL default '0.000000' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;   Just rename the first part of the code from 10 to 92   `userid` int(11) NOT NULL default '0', `strength` decimal(92,4) NOT NULL default '0.0000', `agility` decimal(92,4) NOT NULL default '0.0000', `guard` decimal(92,4) NOT NULL default '0.0000', `labour` decimal(92,4) NOT NULL default '0.0000', `IQ` decimal(92,6) NOT NULL default '0.000000' ) ENGINE=MyISAM DEFAULT CHARSET=latin1;   It really works i was testing it and my stats went up to: Stats Info: Strength: 99,214,223,234,200,011,344,822,808,748,263,406,361,903,104 [Ranked: 1] Agility: 99,214,742,342,300,009,209,442,067,094,969,171,025,330,176 [Ranked: 1] Guard: 99,214,234,234,199,994,435,209,344,265,839,831,941,120 [Ranked: 1] Labour: 99,214,723,423,399,996,459,476,023,615,915,747,704,832 [Ranked: 1] IQ: 99,214,742,342,300,002,710,256,860,846,722,727,804,928 [Ranked: 1] Total stats: 198,726,609,276,499,937,337,431,600,879,931,034,014,056,448 [Ranked: 1] LOL THATS A LOT +1 Please!

Re: I am having a huge problem with my fed jail The easiest way to edit user data is via phpMyAdmin

Re: Donator's Bank[MCV2] For V.1 :-D   <?php session_start(); require "global_func.php"; if($_SESSION['loggedin']==0) { header("Location: login.php");exit; } $userid=$_SESSION['userid']; require "header.php"; $h = new headers; $h->startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['crystals'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); if($ir['hospital'] || $ir['jail']) { print "You cannot access this page."; exit; } if($ir['donatordays']==0) die("Donators only"); print "<h3>Donator's Bank</h3>"; if($ir['donatormoney']>-1) { switch($_GET['action']) { case "deposit": deposit(); break; case "withdraw": withdraw(); break; default: index(); break; } } else { if(isset($_GET['buy'])) { if($ir['money']>9999) { print "Congratulations, you bought a bank account for \$10,000! [url='donatorbank.php']Start using my account[/url]"; mysql_query("UPDATE users SET money=money-10000,donatormoney=0 WHERE userid=$userid"); } else { print "You do not have enough money to open an account. [url='explore.php']Back to town...[/url]"; } } else { print "Open a bank account today, just \$10,000! [url='donatorbank.php?buy']> Yes, sign me up![/url]"; } } function index() { global $db,$ir,$c,$userid,$h; print "\n[b]You currently have \${$ir['donatormoney']} in the bank.[/b] At the end of each day, your bank balance will go up by 20%. <table width='75%' border='2'> <tr> <td width='50%'>[b]Deposit Money[/b] It will cost you 8% of the money you deposit, rounded up. The maximum fee is \$10,000.<form action='donatorbank.php?action=deposit' method='post'> Amount: <input type='text' name='deposit' value='{$ir['money']}' /> <input type='submit' value='Deposit' /></form></td> <td> [b]Withdraw Money[/b] There is no fee when you withdraw.<form action='donatorbank.php?action=withdraw' method='post'> Amount: <input type='text' name='withdraw' value='{$ir['donatormoney']}' /> <input type='submit' value='Withdraw' /></form></td> </tr> </table>"; } function deposit() { global $db,$ir,$c,$userid,$h; $_POST['deposit']=abs((int) $_POST['deposit']); if($_POST['deposit'] > $ir['money']) { print "You do not have enough money to deposit this amount."; } else { $fee=ceil($_POST['deposit']*8/100); if($fee > 10000) { $fee=10000; } $gain=$_POST['deposit']-$fee; $ir['donatormoney']+=$gain; mysql_query("UPDATE users SET donatormoney=donatormoney+$gain, money=money-{$_POST['deposit']} where userid=$userid"); print "You hand over \${$_POST['deposit']} to be deposited, after the fee is taken (\$$fee), \$$gain is added to your account. [b]You now have \${$ir['donatormoney']} in the Donator's Bank.[/b] [url='donatorbank.php']> Back[/url]"; } } function withdraw() { global $db,$ir,$c,$userid,$h; $_POST['withdraw']=abs((int) $_POST['withdraw']); if($_POST['withdraw'] > $ir['donatormoney']) { print "You do not have enough banked money to withdraw this amount."; } else { $fee=ceil($_POST['withdraw']*0/1000); if($fee > 0) { $fee=0; } $gain=$_POST['withdraw']-$fee; $ir['donatormoney']-=$gain; mysql_query("UPDATE users SET donatormoney=donatormoney-$gain, money=money+$gain where userid=$userid"); print "You ask to withdraw $gain, the bank lady hands it over. [b]You now have \${$ir['donatormoney']} in the donator's Bank.[/b] [url='donatorbank.php']> Back[/url]"; } } $h->endpage(); ?>   There might be a few snags but they will be easy to fix!

Re: [v1]Virus Mod[v1] How do you create a new item type? :?