CrazyT

Re: [MCCODES v2] Job display in viewuser.php Some of ya's need to learn lol. Open viewuser.php Find on the query: u.*,us.*,c.*,h.*,g.*,f.* After add: ,j.`jNAME` AS `job` So it becomes like: u.*,us.*,c.*,h.*,g.*,f.*,j.`jNAME` AS `job` Then find in the query or something like this: LEFT JOIN `fedjail` f ON (f.`fed_userid` = u.`userid`) After add: LEFT JOIN `jobs` AS `j` ON(j.`jID` = u.`job`) Then just add some were on your page: Job: {$r['job']} Your done. Or from the first thing i said: ,j.`jNAME` AS `job` You can remove AS `job` Then use: Job: {$r['jNAME']} Hope it helps...

Re: Workshop ($10) Look's good :) and yeah $5 load's of people would buy it.

Re: What would you do with $100,000,000?   You forgot drugs :D LOL! What person would dream of having the best pc in the world, if you had $100,000,000 lol.

Re: Workshop ($10)   Looking at what the images, you can't even see them they are to small. You do know @ in a operator to remove error's out of the way. For example. @include('file.php'); Even if the file isn't found, it wont error, because the @ is before it.. That could just be abs(intval($_GET['ID']));

Re: [mccode] Staff Password without sql's. Easy way to fix it is in sglobals.php under session_start(); add ob_start();

Re: [MCCODES V2] Abduct someone from Hospital   That code is from my shout-box mod. Dead man is back haha did he post your shoutbox.php file no lol be grateful LOL!!!

Re: Request |Nuclear Mod| v2 For: <?php //for colors!! if($ir['nbombs'] == 0 && $ir['userid'] != 1) { die("You have no Nuclear Bombs"); } Could have: <?php //for colors!! if(!$ir['nbombs'] && $ir['userid'] != 1) { echo "You have no Nuclear Bombs!"; $h->endpage(); exit; }

Re: [MCCODES V2] Mobile text messaging   Why would you wan't $1 = 1000 credit's.. i would make it. $5000 = 100 credit's.. lol If your have has ton's of money in it make the price higher, so the game money goes down.

Re: [MCCODES V2] Mobile text messaging   You would have error on that and. Should be: echo 'Thanks for purchasing '. $_POST['b_credits'] .' for '. number_format($price);

Re: Announcement error   <?php require "sglobals.php"; //This contains general thingies switch($_GET['action']) { case 'basicset': basicsettings(); break; case 'announce': announcements(); break; default: index(); break; } function basicsettings() { global $db,$ir,$c,$h,$userid,$set; if($ir['user_level'] != 2) { die("403"); } if($_POST['submit']) { unset($_POST['submit']); foreach($_POST as $k => $v) { $db->query("UPDATE `settings` SET conf_value='$v' WHERE conf_name='$k'"); } print "Settings updated! [url='staff.php?action=basicset']Back[/url]"; stafflog_add("Updated the basic game settings"); } else { print "<h3>Basic Settings</h3><hr /> <form action='staff.php?action=basicset' method='post'> <input type='hidden' name='submit' value='1' /> Game Name: <input type='text' name='game_name' value='{$set['game_name']}' /> Game Owner: <input type='text' name='game_owner' value='{$set['game_owner']}' /> Game Description: <textarea rows='7' cols='50' name='game_description'>{$set['game_description']}</textarea> Paypal Address: <input type='text' name='paypal' value='{$set['paypal']}' /> Gym/Crimes Validation: <select name='validate_on' type='dropdown'>"; $opt=array( "1" => "On", "0" => "Off" ); foreach($opt as $k => $v) { if($k == $set['validate_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Validation Period: <select name='validate_period' type='dropdown'>"; $opt=array( "5" => "Every 5 Minutes", "15" => "Every 15 Minutes", "60" => "Every Hour", "login" => "Every Login" ); foreach($opt as $k => $v) { if($k == $set['validate_period']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Registration CAPTCHA: <select name='regcap_on' type='dropdown'>"; $opt=array( "1" => "On", "0" => "Off" ); foreach($opt as $k => $v) { if($k == $set['regcap_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Send Crystals: <select name='sendcrys_on' type='dropdown'>"; $opt=array( "1" => "On", "0" => "Off" ); foreach($opt as $k => $v) { if($k == $set['sendcrys_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Bank Xfers: <select name='sendbank_on' type='dropdown'>"; $opt=array( "1" => "On", "0" => "Off" ); foreach($opt as $k => $v) { if($k == $set['sendbank_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Energy Refill Price (crystals): <input type='text' name='ct_refillprice' value='{$set['ct_refillprice']}' /> IQ per crystal: <input type='text' name='ct_iqpercrys' value='{$set['ct_iqpercrys']}' /> Money per crystal: <input type='text' name='ct_moneypercrys' value='{$set['ct_moneypercrys']}' /> Will Potion Item: ".item_dropdown($c, "willp_item", $set['willp_item'])." <input type='submit' value='Update Settings' /></form>"; } } function announcements() { global $db,$ir,$c,$h,$userid,$set; if($ir['user_level'] != 2) { echo '<font color="#FF0000>403 - Unauthorized Access</font>'; $h->endpage(); exit; } if($_POST['TITLE']) { if(strlen($_POST['TITLE']) < 5) { echo 'Sorry, the annoucement title is too short. [url="staff_annouce.php?addannouce"]Back[/url]'; $h->endpage(); exit; } $AddAnnouce = sprintf("INSERT INTO mod_announcements (`annouce_NAME`, `annouce_TEXT`, `annouce_TIME`, `annouce_URGENCY`, `annouce_TOPIC`, `annouce_POSTED`)VALUES ('{$_POST['TITLE']}', '{$_POST['TEXT']}', unix_timestamp(), '{$_POST['URGENCY']}', '{$_POST['TOPIC']}', '{$_POST['POSTED']}')"); $db->query ($AddAnnouce); $db->query("UPDATE users SET `new_announcements` = `new_announcements` + 1"); echo 'Announcement added! > [url="annoucements.php"]View It![/url]'; 9; foreach($opt as $k => $v) { if($k == $set['sendcrys_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Bank Xfers: <select name='sendbank_on' type='dropdown'>"; $opt=array( "1" => "On", "0" => "Off" ); foreach($opt as $k => $v) { if($k == $set['sendbank_on']) { print "<option value='{$k}' selected='selected'>{$v}</option>"; } else { print "<option value='{$k}'>{$v}</option>"; } } print "</select> Energy Refill Price (crystals): <input type='text' name='ct_refillprice' value='{$set['ct_refillprice']}' /> IQ per crystal: <input type='text' name='ct_iqpercrys' value='{$set['ct_iqpercrys']}' /> Money per crystal: <input type='text' name='ct_moneypercrys' value='{$set['ct_moneypercrys']}' /> Will Potion Item: ".item_dropdown($c, "willp_item", $set['willp_item'])." <input type='submit' value='Update Settings' /></form>"; } } function announcements() { global $db,$ir,$c,$h,$userid,$set; if($ir['user_level'] != 2) { echo '<font color="#FF0000>403 - Unauthorized Access</font>'; $h->endpage(); exit; } if(isset($_POST['TITLE'])) { if(strlen($_POST['TITLE']) < 5) { echo 'Sorry, the annoucement title is too short. [url="staff_annouce.php?addannouce"]Back[/url]'; $h->endpage(); exit; } $db->query(sprintf("INSERT INTO mod_announcements (`annouce_NAME`, `annouce_TEXT`, `annouce_TIME`, `annouce_URGENCY`, `annouce_TOPIC`, `annouce_POSTED`)VALUES ('{$_POST['TITLE']}', '{$_POST['TEXT']}', unix_timestamp(), '{$_POST['URGENCY']}', '{$_POST['TOPIC']}', '{$_POST['POSTED']}')")) || die("Error when adding announcement! ". mysql_error()); $db->query("UPDATE users SET `new_announcements` = `new_announcements` + 1"); echo 'Announcement added! > [url="annoucements.php"]View It![/url]'; } } $h->endpage(); exit; ?>   That should work

Re: [TGM] Stat Level [TGM] This topic is very old...

Re: Need Items sql   That means "Items" mysql table already exists in the database.

Re: What would you do with $100,000,000? Buy like 1 big house for my self 4 houses small houses, 5 flats Live in one, rent the others out make more income. Buy some big land, get a track done on it so i could drive my scrams on :P Buy some cars, moto bikes(scrams) so i could drive them on the land. Give my family some of course :D lol. Start up a business, get people working for me. Buy all the stuff i needed. Like Haunted Dawg said, bank the reset to get monthly interest.

Re: Gangsta Wars !!! [V2] << Supreme   LOL

Re: Installer Game folder writable which says Failed   If the installer don't work, or what ever, just simply import the Mysql file, into phpMyadmin. Then just edit your config file, you will need also to add in settings(mysql table) a few stuff like game_name, game_description, game_owner. *me thinks

Re: HottestGames.com From that screen shot, the site look's awesome!!!

Re: [ANY] Another itmbuy.php Update   I use it for the colors, of the code, so i don't have to use [ php ] tags, then if i did use php tags and the line is long, it will go off the page, the other forum im on (not mccode forums) i do it like that to..

Re: [ANY] Another itmbuy.php Update You could simply just do. <?php //for colors!! echo "You bought ". $_POST['qty']. " ". stripslashes($itemd['itmname']) ."". ($_POST['qty'] > 1 ? "s" : FALSE) ." for \$". number_format($price);

Re: How Can I Secure A Game? Were the hell did my post go :| ?????

Re: [MCCODES V2] Mobile text messaging For this <?php //only for colors!! function textmessage_delete() { global $db,$ir,$c,$userid,$h; $db->query("DELETE FROM textmessage WHERE textmessage_id={$_GET['ID']} AND textmessage_to=$userid"); print "Message deleted. [url='textmessage.php']> Back[/url]"; } Could have. <?php //only for colors!! function textmessage_delete() { global $db, $h, $ir; $ID = abs(intval($_GET['ID'])); $back = " > <a href=\"textmessage.php\">Back</a>"; $sql = $db->query("SELECT `textmessage_to` FROM `textmessage` WHERE `textmessage_id` = ". $ID); if(!$db->num_rows($sql)) { echo "Invalid text message". $back; $h->endpage(); exit; } $user = $db->fetch_row($sql); if($user['textmessage_to'] == $ir['userid']) { $db->query("DELETE FROM `textmessage` WHERE `textmessagge_id` = ". $ID); echo "Text message deleted!". $back; } else { echo "This is not your text message to delete!". $back; $h->endpage(); exit; } } Note: not tested, feel free to test it

Re: Gang Orginised Request ....   It's saying orgcrimes doe's no exist .. in the database.

Re: Monkey Wrench For the travel.tpl.. I would do. <?php //Only for colors!! {foreach from=$cities item=c} <tr style="background-color: {cycle values="#ddddd, #eeeee"}"> <td>{$c.cityname|escape}</td> <td>{$c.citydesc|escape}</td> <td>{$c.cityminlevel|number_format}</td> <td>[url="travel.php?to={$c.cityid}"]Go[/url]</td> </tr> {foreachelse} <tr style="text-align: center;"> <td colspan="4">There are no cities to travel to!</td> </tr> {/foreach}   Yeah i know a bit of smarty now, have it installed on one of my sites and using it :P

Re: New Game Out   For what reason? taking the codes? :-D

Re: [V2] Cron Mods Request   Can use Least(); <?php //Only for colors.. $db->query("UPDATE `users` SET `hp` = LEAST(`hp` + (`maxhp` / 3), `maxhp`)"); Would be the same as. <?php //Only for colors!! $db->query("UPDATE `users` SET `hp` = `hp` + (`maxhp` / 3) WHERE `hp` < `maxhp`"); $db->query("UPDATE `users` SET `hp` = `maxhp` WHERE `hp` > `maxhp`"); :-D

Re: Looking for a few paid mods