jds137

Re: [mccode v2] Lottery   Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/ml/public_html/lottery.php on line 26     QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unix_timestamp(),0,'You won the weekly lottery and were credited $')' at line 1 Query was INSERT INTO events VALUES('',,unix_timestamp(),0,'You won the weekly lottery and were credited $')

Re: [mccode v2] Display Cabinet Only thing I noticed was it lets a player go negative. So a little snippet needs to be added to tell them they dont have enough crystals.

I did not make this mod, and I forgot who did. I have a question on it? How do I restrict gang sales to just the president/ leader? In this mod, anyone in the gang is allowed to sell it?   <?php include "globals.php"; function escapeString($string) { if (get_magic_quotes_gpc()) $string = stripslashes($string); return mysql_real_escape_string($string); } if($ir['prison'] or $ir['hospital']) { die("This page cannot be accessed while in prison or hospital."); } print "<h3>Gangs Market</h3>"; switch($_GET['action']) { case "buy": gang_buy(); break; case "remove": gang_remove(); break; case "add": gang_add(); break; default: gangmarket_index(); break; } function gangmarket_index() { global $ir,$c,$userid,$h; print "<table width=75% border=1 bordercolor=#666666><tr><td>"; if($ir['gang']) { print "[url='gangmarket.php?action=add']> Add Your Gang[/url]"; } print "</td> </tr> </table> <table width=75% border=1 bordercolor=#666666><th>Seller</th> <th>Gang </th> <th> Price </th> <th>Average Rating</th> <th>Links</th> </tr>"; $q=mysql_query("SELECT gm.*, u.*,g.* FROM gangsmarket gm LEFT JOIN users u ON u.userid=gm.gm_from LEFT JOIN gangs g ON gm.gm_gang=g.gangID",$c) or die(mysql_error()); while($r=mysql_fetch_array($q)) { if($r['gang'] != $r['gangID']) { mysql_query("DELETE FROM gangsmarket WHERE gm_id={$r['gm_id']}",$c); } if($r['gm_from'] == $userid) { $link = "[url='gangmarket.php?action=remove&ID={$r[']Remove[/url]"; } else { $link = "[url='gangmarket.php?action=buy&ID={$r[']Buy[/url]"; } $total=$r['gangRESPECT']+mysql_num_rows(mysql_query("SELECT * FROM users WHERE gang={$r['gangID']}")); $total=$total/10; if($total > 1000) { $rate=10; } elseif($total > 900) { $rate=9; } elseif($total > 800) { $rate=8; } elseif($total > 700) { $rate=7; } elseif($total > 600) { $rate=6; } elseif($total > 500) { $rate=5; } elseif($total > 400) { $rate=4; } elseif($total > 300) { $rate=3; } elseif($total > 200) { $rate=2; } else { $rate=1; } print "\n<tr> <td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td> <td>[b]{$r['gangNAME']}[/b]</td> <td> \$" . number_format($r['gm_price'])."</td> <td>$rate/10</td> <td>[$link]</td> </tr>"; } print "</table>"; } function gang_remove() { global $ir,$c,$userid,$h; $q=mysql_query("SELECT * FROM gangsmarket WHERE gm_id={$_GET['ID']} AND gm_from=$userid",$c); if(!mysql_num_rows($q)) { print "Error, either this gang do not exist, or you are not the owner. [url='gangmarket.php']> Back[/url]"; $h->endpage(); exit; } $r=mysql_fetch_array($q); mysql_query("DELETE FROM gangsmarket WHERE gm_id={$_GET['ID']}",$c); print "Your gang removed from market! [url='gangmarket.php']> Back[/url]"; } function gang_buy() { global $ir,$c,$userid,$h; $q=mysql_query("SELECT * FROM gangsmarket WHERE gm_id={$_GET['ID']}",$c); if(!mysql_num_rows($q)) { print "Error, either this gang do not exist, or they have already been bought. [url='gangmarket.php']> Back[/url]"; $h->endpage(); exit; } elseif($ir['gang'] != 0) { print "Error, you are already in a gang so you cannot purchase this one. [url='gangmarket.php']> Back[/url]"; $h->endpage(); exit; } $r=mysql_fetch_array($q); if($r['gm_price'] > $ir['money']) { print "Error, you do not have the funds to buy this gang. [url='gangmarket.php']> Back[/url]"; $h->endpage(); exit; } mysql_query("UPDATE users SET gang={$r['gm_gang']},daysingang=0 where userid=$userid",$c) or die(mysql_error()); mysql_query("DELETE FROM gangsmarket WHERE gm_id={$_GET['ID']}",$c); mysql_query("UPDATE gangs SET gangPRESIDENT={$userid},gangVICEPRES={$userid} WHERE gangID={$r['gm_gang']}",$c); mysql_query("UPDATE users SET gang=0,daysingang=0 where userid={$r['gm_from']}",$c); mysql_query("UPDATE users SET money=money-{$r['gm_price']} WHERE userid=$userid",$c); mysql_query("UPDATE users SET money=money+{$r['gm_price']} WHERE userid={$r['gm_from']}",$c); event_add($r['gm_from'],"[url='viewuser.php?u=$userid']{$ir['username']}[/url] bought your gang from the market for \$".number_format($r['gm_price']).".",$c); print "You bought the gang from the market for \$".number_format($r['gm_price'])."."; } function gang_add() { global $ir,$c,$userid,$h; $_POST['price'] = abs((int) $_POST['price']); if($_POST['price']) { $q=mysql_query("SELECT * FROM gangsmarket WHERE gm_from=$userid",$c); if($_POST['price'] > 20000000000) { die("Your limit is \$20billion "); } elseif(mysql_num_rows($q)) { die ("You have already added your gang to the market."); } elseif(!$ir['gang']) { die ("You dont have a gang."); } $tp=$_POST['price']; mysql_query("INSERT INTO gangsmarket (gm_id,gm_from,gm_gang,gm_price) VALUES ('NULL', '{$userid}', '{$ir['gang']}', '{$tp}');", $c); print "Gang added to market! [url='gangmarket.php']> Back[/url]"; } else { print "<table width=75% border=1 bordercolor=#666666><tr><td>[b]Here you are adding your whole gang including the contents.[/b]</td> </tr> </table> <form action='gangmarket.php?action=add' method='post'><table width=75% border=1 bordercolor=#666666><tr> <td>Price:</td> <td>[b]Maximum price is \$20,000,000,000[/b] <input type='text' name='price' value='20000000' /></td></tr><tr> <td colspan=2 align=center><input type='submit' value='Add To Market' /></tr></table></form>"; } } $h->endpage(); ?>

Re: [ADDON] V2 Refill A Specific User Aswell as Refill All Users Some of you may need to edit it like this: In order for this to work. Please keep up the good work

I would like a poker game, and if anyone has a treasure hunt mod. I tried contacting the 2 owners of the mod, but I never get a reply.

Re: [V2] Robbery Good Mod, just 1 thing. I can still do a robbery after I lose all members. Ill see if I can resolve it.

Re: [mccode v2] Improved Robbery Parse error: syntax error, unexpected '[' in /home/ml/public_html/rob.php on line 31

Re: mccodes V2] Upgrade IPFINDER original Script by Magicaltallguy Works just fine for my site. A+

Re: [mccode v2] New re-designed bank.php!! Money & Crystals in 1 bank   http://criminalexistence.com/ceforums/index.php?topic=21147.0

Re: [mccode v2] New re-designed bank.php!! Money & Crystals in 1 bank I tried it with illusions, and saw it is buggy as well. 1 issue is it doesnt let you open an acct, it automatically gives you one.

Re: [requests] V2 Mod There is a rehab mod, but its a paid mod.

Re: [mccodes v1 & v2] Click Count which parts of your site isnt being used ? I like the idea, and I agree third party stuff is no comparison to adding a custom script.

Re: New re-designed bank.php!! Money & Crystals in 1 bank Community Bank You hand over $1284 to be deposited, after the fee is taken ($30), $1254 is added to your account. You now have $0 crystals in the bank. > Back Is what I was referring to, it may confuse people.

Re: New re-designed bank.php!! Money & Crystals in 1 bank Tis fine cept for depositing crystals doesnt list the amnt. And you did not give a cron for intrest.

Re: [mccodes V2] Bounty Hunter Game Where do you search? I got it working just fine.

Re: [mccode] Treasure Hunting [$20.00] Nice Mod, Maybe someday, it will be for sale again

Re: Secure Bank! [V2] You are missing a } Heres the fixed one...   <?php include (DIRNAME(__FILE__) . "/globals.php"); // Secured Up By Karlos // Helped By MTG To Fix A Few Errors print "<h3>Bank</h3>"; if($ir['bankmoney']>-1) { $_GET['action'] = isset($_GET['action']) && is_string($_GET['action']) ? strtolower(trim($_GET['action'])) : ""; switch($_GET['action']) { case "deposit": deposit(); break; case "withdraw": withdraw(); break; default: index(); break; } } else { if(isset($_GET['buy'])) { if($ir['money']>4999) { print "Congratulations, you bought a bank account for \$5,000! [url='bank.php']Start using my account[/url]"; $sql = sprintf("UPDATE users SET money = money - %u WHERE (userid = %u)", 5000, $userid); $db->query($sql); } 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 \$5,000! [url='bank.php?buy']> Yes, sign me up![/url]"; } } function index() { global $db, $ir, $c, $userid, $h; echo sprintf("[b]You currently have \$%s in the bank.[/b] ", number_format($ir['bankmoney'])); echo ("<table width='85%' cellspacing=1 class='table'>"); echo ("<tr>"); echo ("<td width='50%'>[b]Deposit money[/b] "); echo ("It will cost you 15% of the money you deposit, rounded up. The maximum fee is \$3,000.<form action='bank.php?action=deposit' method='post'>"); echo sprintf("Amount: <input type='text' name='deposit' value='%s' /> ", $ir['bankmoney']); echo ("<input type='submit' value='Deposit' /></form></td>"); echo ("<td width='50%'>[b]Withdraw money[/b] "); echo ("There is no fee on withdrawals.<form action='bank.php?action=withdraw' method='post'>"); echo sprintf("Amount: <input type='text' name='withdraw' value='%s' /> ", $ir['bankmoney']); echo ("<input type='submit' value='Withdraw' /></form></td>"); echo ("</tr>"); echo ("</table>"); } function deposit() { global $db,$ir,$c,$userid,$h; $_POST['deposit'] = (float) $_POST['deposit']; if($_POST['deposit'] > $ir['money']) { print "You do not have enough money to deposit this amount."; } else { $fee=ceil($_POST['deposit']*15/100); if($fee > 3000) { $fee=3000; } $gain=$_POST['deposit']-$fee; $ir['money']+=$gain; $sql = sprintf("UPDATE users SET bankmoney = bankmoney + %u, money = money - %u WHERE (userid = %u)", @intval($gain), $_POST['deposit'], $userid); $db->query($sql); echo sprintf("You hand over \$%s to be deposited, after the fee is taken (\$%s), \$%s is added to your account. [b]You now have \$%s in the bank.[/b] [url='bank.php']> Back[/url]", number_format($_POST['deposit']), number_format($fee), number_format($gain), number_format($ir['bankmoney'])); } function withdraw() { global $db,$ir,$c,$userid,$h; $_POST['withdraw'] = (float) $_POST['withdraw']; if($_POST['withdraw'] > $ir['bankmoney']) { print "You do not have enough banked money to withdraw this amount."; } else { $_POST['withdraw'] = (float) $_POST['withdraw']; $gain=$_POST['withdraw']; $ir['bankmoney']-=$gain; $sql = sprintf("UPDATE users SET bankmoney = bankmoney - %u, money = money + %u WHERE (userid = %u)", $gain, $gain, $userid); $db->query($sql); echo sprintf("You ask to withdraw %s, the banking lady grudgingly hands it over. [b]You now have \$%s in the bank.[/b] [url='bank.php']> Back[/url]", number_format($gain), number_format($ir['bankmoney'])); } } } $h->endpage(); ?>

Re: Staff Applications [FREE] You would need to make the rules as per your own site. :-P

Re: Staff Applications [FREE] Theres the screen shot, and here is the code for the staff rules, if you want to add it. call it stafftos.php <?php include "globals.php"; print <<<EOF <center> <h1><font color=white>[b]Terms & Conditions[/b]</font></h1> </center> [list=1] <center> <font color=red> [*] Do not abuse your power or else you will be fed jailed without warning. [*] If Admin want competitions please mail John of Mudd or Selentra with you idea and they will tell you if will be able to or not. [*] Do not threaten people with you power or else you will be fed jailed without warning. We do keep logs of everything staff does. [*] If you are asked a question you must answer unless its not what your job description is. [*] If you have had a warning or have been in federal jail you can possibly still be staff depending on what you have done. [*] If an admin should ask you to do something you must do it unless it not in your job description. [*] If you are unsure of any other rules that may not be mentioned here please contact jsmigle[2] . </font></center> [i]<center><font color=gray>Copyright © 2008 Psycho Killa Entertainment</center>[/i][/list] EOF; $h->endpage(); ?>

Re: Staff Applications [FREE] Great Mod. I modified it just a little bit, so that you can add the staff rules, as well as amount of staff you are looking for. I did not make this mod at all, like I said I modified it a tiny bit....   <?php /* -- Staff Applications V2 -- Coded By Zero-Affect */ require "globals.php"; if($set['stafflock'] == 'Locked') { echo "Staff Applications are locked at the moment, please try again later. >[url='index.php']Go Home[/url]"; $h->endpage(); exit; } echo "<h3>Staff Applications</h3><font color=red>Please read the [url='stafftoc.php']<font color='blue'><s>Terms & Conditions</s></font>[/url] of being staff first.[/b] <center> <font color='green'>Admin: Positions Open 0 </font> <font color='yellow'>Secretary: Positions Open 0 </font> <font color='red'>Assistants: Positions Open 0 </font> <font color='blue'>Chat Mod: Positions Open 0 </font> </center>"; $_POST['ID'] = abs((int) $_POST['ID']); if($_POST['ID']) { $sql = sprintf('SELECT COUNT(ID) AS `count` FROM `staffaps` WHERE ID = %u', $userid); $sql = $db->query($sql); $gaps = $db->fetch_row($sql); if($gaps['count']) { echo "Invalid Command. You already have submitted a application. >[url='index.php']Go Home[/url]"; $h->endpage(); exit; } else if(!$gaps['count']) { $_POST['staff'] = abs((int) $_POST['staff']); $_POST['about'] = mysql_real_escape_string(htmlentities($_POST['about'])); $_POST['exp'] = mysql_real_escape_string(htmlentities($_POST['exp'])); if(strlen($_POST['about']) > 75 OR strlen($_POST['exp']) > 75) { echo 'Invalid Command. You cannot input more than 75 characters. >[url="StaffApps.php"]Go Back[/url]'; $h->endpage(); exit; } $_POST['about'] = strip_tags($_POST['about'], '[b][i]<u><s>'); $_POST['exp'] = strip_tags($_POST['exp'], '[b][i]<u><s>'); $query = sprintf("INSERT INTO `staffaps` VALUES ('%u', '%s', '%s', '%u')", $userid, $_POST['about'], $_POST['exp'], $_POST['staff']); $db->query($query); echo "Application sent please wait atleast 5 days for reply from staff. >[url='index.php']Go Home[/url]"; } } else { echo " <form action='StaffApps.php' method='post'> <input type=hidden value='$userid' name='ID'> <table width=80% border=1 class=h> <tr><th colspan=2>Application Form.</th></tr> <tr> <td>Position: </td> <td> <select name='staff' type='dropdown'> <option value='2'>Admin <option value='3'>Secretary <option value='5'>Assistant </select> </td> </tr> <tr> <td>Why: </td> <SCRIPT LANGUAGE='JavaScript'> function textCounter(field, countfield, maxlimit) { if (field.value.length > maxlimit) field.value = field.value.substring(0, maxlimit); else countfield.value = maxlimit - field.value.length; } </script> <td> <textarea name=about maxlength=75 wrap=physical cols=75 rows=5 onKeyDown='textCounter(this.form.about,this.form.remLen,75);' onKeyUp='textCounter(this.form.about,this.form.remLen,75);'></textarea> <input readonly type=text name=remLen size=3 maxlength=2 value='75'> characters left</font> </td> </tr> <tr> <td>Experience [i](Sites worked on)[/i]: </td> <SCRIPT LANGUAGE='JavaScript'> function textCounter1(field, countfield, maxlimit) { if (field.value.length > maxlimit) field.value = field.value.substring(0, maxlimit); else countfield.value = maxlimit - field.value.length; } </script> <td> <textarea name=exp maxlength=75 wrap=physical cols=75 rows=5 onKeyDown='textCounter1(this.form.exp,this.form.remLen1,75);' onKeyUp='textCounter1(this.form.exp,this.form.remLen1,75);'></textarea> <input readonly type=text name=remLen1 size=3 maxlength=2 value='75'> characters left</font> </td> </tr> <tr> <td colspan=2><input type='submit' value='Submit'></form></td> </tr> </table> "; } $h->endpage(); ?>

Re: [mod] very small mod to restrict reg name size What about making it so you can only use abc 123 in a name, and no special characters?

Re: [FREE][V2] Club Mod (my version) They are exatly as you posted em. Ill look into it, and see what I can find.

Re: Basic Stock Market [V2] thats like think dont drink... lol

Re: Passport [V2] Does anyone know what is needed to have the passport expire? You could do a weekly cron, but I dont know if thats the best option.

Re: [V2] Give Money To Tramps EDITED All set