Newbie

upload the zip file and right click on it on your cpanel and click extract then just move all the files into your main directory

  if you tried to import the sql txt file in the gl folder it wont work open up your sql.txt file and copy the tables 1 by 1 then try again

thanks Octarine for pointing that out :)

another version of torn city :S thats about the 4th game iv seen that looks the same as torn

i wish i could lol wouldt have a clue where to start ill just see if i can find a better one and try to add to it

alright after your comment i was confused so i went back and checked my searchdo.php and found what your talking about (well atleast i think i have)   $q=$db->query("SELECT * FROM users $levelmin_clause$levelmax_clause$id_clause$name_clause$location_clause$online_cl ause$daysmin_clause$ daysmax_clause$moneymin_clause",$c);   i changed to $q=$db->query("SELECT * FROM users $levelmin_clause$levelmax_clause$id_clause$name_clause$location_clause$online_clause$daysmin_clause$ daysmax_clause$moneymin_clause",$c); now i get this error lol QUERY ERROR: Query was SELECT * FROM users WHERE level >= 1 AND level <= 500 AND location LIKE('1') AND daysold >= 1$ daysmax_clause AND money > 50   that was me searching for users with 1 days or older and $50 or more

i dunno illusions when i go onto my search.php everything works fine when i try to search say anyone with 1000 or more in london and hit search i get that error people on the other post said they added it to there game and it worked fine but that was like 2010

QUERY ERROR: Query was SELECT * FROM users WHERE level >= 1 AND level <= 500 ause AND location LIKE('1')$ daysmax_clause AND money > 1000 i got the mod from here but i couldnt reply there for some reason http://makewebgames.io/showthread.php/33382-New-member-search?highlight=search in the sql bit it doesnt say anything like ALTER TABLE users ADD etc

its not my script i got it off here but last comment was in 2010 and when i tried to reply there it wouldnt let me so i posted it here ok spudinski your way gives me this error Parse error: syntax error, unexpected T_STRING in /home/getty/public_html/searchdo.php on line 57   <td> . $r['level'] . '</td>   and prototype thanks :) worked fine just got a error with the stupid sql file now :(

Ok basicly iam having problems with this part of an search mod file is called searchdo.php   <?php include "globals.php"; $_POST['search'] = mysql_real_escape_string($_POST['search']); $_POST['save'] = mysql_real_escape_string($_POST['save']); $_POST['clear'] = mysql_real_escape_string($_POST['clear']); if($_POST['search']) { $_POST['moneymin'] = abs(@intval($_POST['moneymin'])); $_POST['daysmax'] = mysql_real_escape_string($_POST['daysmax']); $_POST['daysmin'] = mysql_real_escape_string($_POST['daysmin']); $_POST['levelmin'] = abs(@intval($_POST['levelmin'])); $_POST['levelmax'] = abs(@intval($_POST['levelmax'])); $_POST['id'] = mysql_real_escape_string($_POST['id']); $_POST['location'] = abs(@intval($_POST['location'])); $_POST['name'] = mysql_real_escape_string($_POST['name']); $levelmin_clause="WHERE level >= {$_POST['levelmin']}"; $levelmax_clause=" AND level <= {$_POST['levelmax']}"; $id_clause=($_POST['id']) ? " AND userid LIKE('%{$_POST['id']}%')" : ""; $name_clause=($_POST['name']) ? " AND username LIKE('%{$_POST['name']}%')" : ""; $location_clause=($_POST['location']) ? " AND location LIKE('{$_POST['location']}')" : ""; $online_clause=($_POST['online']) ? " AND laston >= unix_timestamp()" : ""; $daysmin_clause=($_POST['daysmin']) ? " AND daysold >= {$_POST['daysmin']}" : ""; $daysmax_clause=($_POST['daysmax']) ? " AND daysold <= {$_POST['daysmax']}" : ""; $moneymin_clause=($_POST['moneymin']) ? " AND money > {$_POST['moneymin']}" : ""; $q=$db->query("SELECT * FROM users $levelmin_clause$levelmax_clause$id_clause$name_cl ause$location_clause$online_clause$daysmin_clause$ daysmax_clause$moneymin_clause",$c); print " <table width='75%' cellspacing='1' class='table'><tr><th><h3>User Search Results</h2></th></tr></table>"; print"<table width='75%'><tr><td colspan='5'>";print mysql_num_rows($q)." Users found. </td></tr><tr class='table'><th>User</th><th>Level</th><th>Money</th><th>Mug</th><th>Attack</th></tr>"; while($r=mysql_fetch_array($q)) { print "<tr><td><a href='viewuser.php?u={$r['userid']}'>"; print" {$r['username']}"; print"</a></td><td>{$r['level']}</td><td>\${$r['money']}</td><td><a href='mug.php?ID={$r['>[Mug]</a></td><td><a href='attack.php?ID={$r['>[Attack]</a></td></tr>"; } print "</table>"; } else if($_POST['save']) { $_POST['moneymin'] = abs(@intval($_POST['moneymin'])); $_POST['daysmax'] = mysql_real_escape_string($_POST['daysmax']); $_POST['daysmin'] = mysql_real_escape_string($_POST['daysmin']); $_POST['levelmin'] = abs(@intval($_POST['levelmin'])); $_POST['levelmax'] = abs(@intval($_POST['levelmax'])); $_POST['id'] = mysql_real_escape_string($_POST['id']); $_POST['location'] = abs(@intval($_POST['location'])); $_POST['name'] = mysql_real_escape_string($_POST['name']); $levelmin_clause="WHERE level >= {$_POST['levelmin']}"; $levelmax_clause=" AND level <= {$_POST['levelmax']}"; $id_clause=($_POST['id']) ? " AND userid LIKE('%{$_POST['id']}%')" : ""; $name_clause=($_POST['name']) ? " AND username LIKE('%{$_POST['name']}%')" : ""; $location_clause=($_POST['location']) ? " AND location LIKE('{$_POST['location']}')" : ""; $online_clause=($_POST['online']) ? " AND laston >= unix_timestamp()" : ""; $daysmin_clause=($_POST['daysmin']) ? " AND daysold >= {$_POST['daysmin']}" : ""; $daysmax_clause=($_POST['daysmax']) ? " AND daysold <= {$_POST['daysmax']}" : ""; $moneymin_clause=($_POST['moneymin']) ? " AND money > {$_POST['moneymin']}" : ""; $q=$db->query("SELECT * FROM users $levelmin_clause$levelmax_clause$id_clause$name_cl ause$location_clause$online_clause$daysmin_clause$ daysmax_clause$moneymin_clause",$c); print " <table width='75%' cellspacing='1' class='table'><tr><th><h3>Prisoner <span class='highlight'>Search</span> Results</h2></th></tr></table>"; print"<table width='75%'><tr><td colspan='5'>";print mysql_num_rows($q)." Users found. </td></tr><tr colspan=1 class='table'><th>User</th><th>Level</th><th>Money</th><th>Mug</th><th>Attack</th></tr>"; while($r=mysql_fetch_array($q)) { print "<tr><td><a href='viewuser.php?u={$r['userid']}'>"; print" {$r['username']}"; print"</a></td><td>{$r['level']}</td><td>\${$r['money']}</td><td><a href="http://mug.php?ID={$r[" target="_blank">[Mug]</a></td><td><a href="http://attack.php?ID={$r[" target="_blank">[Attack]</a></td></tr>"; } print "</table>"; $sql = sprintf("SELECT * FROM <span class='highlight'>search</span> WHERE userid = %d ", $ir['userid']); $q1 = mysql_query($sql); if(mysql_num_rows($q1) > 0) { $updatesearch = sprintf ( "UPDATE `search` SET `id` = '%s', `moneymin` = '%d', `daysmax` = '%s', `daysmin` = '%s', `levelmin` = '%d', `levelmax` = '%d', `location` = '%d', name = '%s', `online` = '%s' WHERE `userid` = ('%u')", $_POST['id'], $_POST['moneymin'], $_POST['daysmax'], $_POST['daysmin'] , $_POST['levelmin'], $_POST['levelmax'], $_POST['location'], $_POST['name'], $_POST['online'], $ir['userid'] ); $db->query($updatesearch); } else { $insertsearch = sprintf ( "INSERT INTO `search` values ('' , '%u' , '%u' , '%s' , '%s' , '%u' , '%u' , '%s' , '%u' , '%s', '%s' )", $ir['userid'], $_POST['moneymin'], $_POST['daysmax'], $_POST['daysmin'] , $_POST['levelmin'], $_POST['levelmax'], $_POST['id'], $_POST['location'], $_POST['name'], $_POST['online'] ); $db->query($insertsearch); } } else if($_POST['clear']) { $sql = sprintf("SELECT * FROM <span class='highlight'>search</span> WHERE userid = %d ", $ir['userid']); $q1 = mysql_query($sql); if(mysql_num_rows($q1) > 0) { $deletesearch = sprintf ( "DELETE FROM `search` WHERE `userid` = ('%u')", $ir['userid'] ); $db->query($deletesearch); print"last <span class='highlight'>Search</span> has been Deleted"; } else { print"You have no searches saved to delete... Stupid!!"; } } ?>     im getting this error Parse error: syntax error, unexpected T_STRING, expecting ']' in /home/getty/public_html/searchdo.php on line 56 line 56 print"</a></td><td>{$r['level']}</td><td>\${$r['money']}</td><td><a href='mug.php?ID={$r['>[Mug]</a></td><td><a href='attack.php?ID={$r['>[Attack]</a></td></tr>";   any help would be great

hey is this mod still availble i like it and is it easy to add to like search cash out city level etc

  well from what you posted it seems the error is coming from the logged in file you have properly put the $db->query("UPDATE users SET active=1 WHERE userid=$userid"); in the wrong place heres how the start of my loggedin.php   <?php $housequery=1; include "globals.php";   i added the $db->query("UPDATE users SET active=1 WHERE userid=$userid"); right under globals like this   <?php $housequery=1; include "globals.php"; $db->query("UPDATE users SET active=1 WHERE userid=$userid");   if this doesnt fix it post up a copy of your logged in file or pm me and ill have a look at it for you.

i used the one from cronwerks its the same mod but it installed much better no errors at all theres bits of code in the codes on this fourm due to moving fourms or sumthing

Thanks all this time i been trying to select it from db and it was simple as that oh ended up with another error on like 80 but i just removed the date from it I think it said second because the mod was from redux but i converted it to v2 just need to remeber that for next time i see a redux mod :)

Ok iam having trouble with this one its been converted from redux everything is showing up fine but when i enter my bet it says You are trying to bet more than you have iam not to sure but i think theres a line of code missing to check your crystals but cant seem to figure it out really ennoying me now any help would be good   <?php include "globals.php"; global $h,$ir; //original mod by mark mascola August 11, 2011 if(isset($_POST['match']) && is_numeric($_POST['match'])){ $q=$db->query("SELECT * FROM fifty WHERE bet_id = {$_POST['match']}"); $r = $db->fetch_row($q); $win = floor($r['wager']*(1.8)); if($ir['second'] < $r['wager']){ echo"<br />You are trying to bet more than you have"; $h->endpage(); exit; }elseif($ir['userid'] == $r['bettor']){ echo"<br />You cannot match your own bets"; $h->endpage(); exit; }else{ $db->query("UPDATE users SET second = second - {$r['wager']} WHERE userid={$ir['userid']}"); $j=rand(1,2); if($j==1){//the winner is the original bettor $db->query("UPDATE users SET second = second + ".$win." WHERE userid = {$r['bettor']}"); event_add($r['bettor'], "You won your 50/50 bet of ".$r['wager']." points and earned ".floor($r['wager']*(1.8))." points!"); event_add($ir['userid'], "You lost your 50/50 bet of ".$r['wager']." points."); } if($j==2){//the winner is the matcher $db->query("UPDATE users SET second = second + ".$win." WHERE userid = {$ir['userid']}"); event_add($r['bettor'], "You lost your 50/50 bet of ".$r['wager']." points."); event_add($ir['userid'], "You won your 50/50 bet of ".$r['wager']." points and earned ".floor($r['wager']*(1.8))." points"); } //need to add events to both the bettor and the taker.. need to delete the bet and update players with points $db->query("DELETE FROM fifty WHERE bet_id = {$r['bet_id']}"); } } if(isset($_POST['points']) && is_numeric($_POST['points'])){ if($_POST['points'] < 10){ echo "<br />You are not betting enough"; $h->endpage(); exit; } elseif($_POST['points'] > 5000){ echo "<br />You are trying to bet too much"; $h->endpage(); exit; } elseif($ir['second'] < $_POST['points']){ echo "<br />You are trying to bet more than you have"; $h->endpage(); exit; } else{ $db->query("UPDATE users SET `second` = `second` - {$_POST['points']} where userid={$userid}"); $db->query("INSERT INTO fifty VALUES('',{$ir['userid']},{$_POST['points']},unix_timestamp())"); } } echo"<h2>50/50 Points Game</h2>"; echo"<p>The rules are simple.<br /> 2 players wager the same bet, the winner gets 90% of the pot. The house keeps 10%</p>"; echo"<p>The maximum bet is 5000 points but you may wager more than once.</p>"; echo "<p> <form method='post'> <input type='text' name='points' size='8' maxlength='7'> points (10-5000)<br /><br /> <input type='submit' name='bet' value='Place Bet'> </form> </p> <h3>Awaiting Bets</h3> <p> <table width='90%'> <tr> <th><b>Mobster</b></td> <th><b>Points</b></td> <th><b>Bet Age</b></td> <th align='center'><b>Bet</b></td> </tr>"; $q = $db->query("SELECT f.*,u.username FROM fifty f LEFT JOIN users u ON f.bettor = u.userid ORDER BY bet_id ASC"); while($r = $db->fetch_row($q)) { echo"<tr>"; echo"<td>".$r['username']."</td>"; echo"<td>".$r['wager']."</td>"; echo"<td>".DateTime_Parse($r['bet_time'])."</td>"; echo "<td><form method='post'>"; echo"<input type='hidden' name='match' value='".$r['bet_id']."' /><input type='submit' value='Match Bet'></form></td>"; echo"</tr>"; } echo"</table></p>"; ?>

Hourly Rewards V1.01 Recoded ** Updates ** > Recoded my way > Added Random payouts ** SQL ** ALTER TABLE `users` ADD `hourlyReward` INT( 3 ) NOT NULL DEFAULT '0'; ** CRON ** $db->query("UPDATE users SET hourlyReward = hourlyReward - 1 WHERE hourlyReward > 0"); download zipped folder below http://snk.to/f-ctks6jmh for a paste bin copy click the link below here http://pastebin.com/5kv9jvDa and last but least a code version on here <?php /* Hourly Rewards v1.01 * This is a free modifaction for mccodes v2 */ require("globals.php"); switch($_GET['action']) { case "claim": claim_reward(); break; default: index(); break; } function index() { echo "<h2>Hourly Rewards<br> <p>You can come claim a reward once every hour<br> <a href='hourly.php?action=claim'><input type='button' value='Claim Reward Now'></a>"; } function claim_reward() { global $db, $ir, $userid, $h; if($ir['hourlyReward'] > 0) { echo "Sorry you can only claim a reward once every hour come back in ".$ir['hourlyReward']." minutes."; exit; } else { if($ir['level'] <= 10) { /*Edit $hourlymoney & $hourlypoints to increase payout for level 1-10 money & points*/ $hourlymoney = rand(100,500); $hourlypoints = rand(1,3); echo "You have earned $".$hourlymoney." & ".$hourlypoints." points for playing this hour."; $db->query("UPDATE `users` SET `money` = `money` +$hourlymoney, `crystals` = `crystals` +$hourlypoints, `hourlyReward` = 60 WHERE `userid` = $userid"); $h->endpage(); exit; } if($ir['level'] <= 50) { /*Edit $hourlymoney & $hourlypoints to increase payout for level 11-50 money & points*/ $hourlymoney = rand(550,1000); $hourlypoints = rand(1,5); echo "You have earned $".$hourlymoney." & ".$hourlypoints." points for playing this hour."; $db->query("UPDATE `users` SET `money` = `money` +$hourlymoney, `crystals` = `crystals` +$hourlypoints, `hourlyReward` = 60 WHERE `userid` =$userid"); $h->endpage(); exit; } if($ir['level'] <= 150) { /*Edit $hourlymoney & $hourlypoints to increase payout for level 51-150 money & points*/ $hourlymoney = rand(1500,2500); $hourlypoints = rand(1,10); echo "You have earned $".$hourlymoney." & ".$hourlypoints." points for playing this hour."; $db->query("UPDATE `users` SET `money` = `money` +$hourlymoney, `crystals` = `crystals` +$hourlypoints, `hourlyReward` = 60 WHERE `userid` =$userid"); $h->endpage(); exit; } if($ir['level'] <= 250) { /*Edit $hourlymoney & $hourlypoints to increase payout for level 151-250 money & points*/ $hourlymoney = rand(3500,7000); $hourlypoints = rand(1,12); echo "You have earned $".$hourlymoney." & ".$hourlypoints." points for playing this hour."; $db->query("UPDATE `users` SET `money` = `money` + $hourlymoney, `crystals` = `crystals` + $hourlypoints, `hourlyReward` = 60 WHERE `userid` =$userid"); $h->endpage(); exit; } } } ?> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ Ok first this wasnt made by me it was made by windsor on cronwerks fourm but his version didnt work he missed tables and other stuff so heres a working version for V2 iv tested it and it works SQL ALTER TABLE `users` ADD `hourlyReward` INT( 3 ) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `main` INT( 3 ) NOT NULL DEFAULT '0'; ALTER TABLE `users` ADD `second` INT( 3 ) NOT NULL DEFAULT '0'; hourly.php <?php include "globals.php"; global $h,$ir; //original mod by mark mascola August 11, 2011 echo "<h2>Welcome to Hourly Rewards</h3>"; echo "<p>Once an hour you may come here to collect a reward</p>"; if($_POST['valid']=='yes' && isset($_POST['bet'] )){ if($ir['hourlyReward'] > 0){ echo "You cannot refresh this page."; $h->endpage(); exit; } else{ $hourlyMoney = $ir['level']*rand(200,300); $hourlyPoints = rand(1,3); echo "You have earned $".$hourlyMoney." ,".$hourlyPoints." Points for playing this hour"; $db->query("UPDATE users SET main = main +{$hourlyMoney},second = second+{$hourlyPoints},hourlyReward = 60 WHERE userid={$ir['userid']}"); $_POST['valid']='no'; $db->query("UPDATE users SET crystals=crystals+$hourlyPoints WHERE userid=$userid"); $db->query("UPDATE users SET money=money+$hourlyMoney WHERE userid=$userid"); $h->endpage(); exit; } } else{ if($ir['hourlyReward']==0){ echo "<p><form method='post'><input type='hidden' name='valid' value='yes' /><input type='submit' name='bet' value='Claim Your Reward' /></form></p>"; } else{ $wait= $ir['hourlyReward']; echo"You must wait <font color=red>".$wait."</font> minutes before you can claim your next reward."; } } ?> open cron_minute.php Add near bottom or wherever suits you $db->query("UPDATE users SET hourlyReward = hourlyReward - 1 WHERE hourlyReward > 0"); almost forgot add a link to where you want them to go to get rewarded explore , mainmenu , etc <a href='hourly.php'>Get Your Reward</a><br /> Screenshots [ATTACH=CONFIG]249[/ATTACH] [ATTACH=CONFIG]250[/ATTACH] [ATTACH=CONFIG]251[/ATTACH] I have took alot of stuff from MWG and got plenty of help so thought it was time to start giving back enjoy and any problems let me know ill see if i can fix im still learning

I dunno if this is the right place to post this or not if not then sorry. I recently downloaded a free psd file from peter and i have been trying to code it i managed to open it up in photoshop slice it and get the code for it but cant seem to implement it into my login page lol keep getting errors does anyone know of any good websites that could help me learn a bit more or give me some advice thanks steven

does anyone have the sql for this i know its old just hoping somone does as link is dead :(

thanks peter your work is amazing gona give it a blast at coding it ( lol probz fail but goto try ) ill give ya a message if i need it coded ty again :)

  you can add it in manaly or sumthing like this   ALTER TABLE `staff` ADD int(11) NOT NULL DEFAULT '0'   never used the gl enine before so i dunno

company I cant get the company to pay out any money each day heres what iv tried so far iv copyed the whole business cron to my min cron to see if it would pay out no luck at all iv also tried to include the business file instead of copying the whole file like above also made a cron for it every day in the cron bit on cpanel iv managed to get to get it to pay out before buy doing that but cant seem to figure it out now any ideas? thanks

its nice i like it pitty i dont have $100 :(

thanks mabyee its easy for you but im still learning :) ill try it later and see if it works

hey all im planning on buying a licence for mccodes v2 and i have been playing around with ravens mmorpg script which is mccodes v2   so anyways i managed to get past all his encoded files but when i replaced his core file with one i found it has removed the number of members in game and the online members is does anyone know how to put it back in so it shows up like this Total Members: 100 for example Online: 10   it just says members online   any help is apreacted thanks

i dunno if your using free hosting or not but heres 2 that accept curls 000webhosting.com or x10hosting.com there both alright only thing is 000 doesnt use cpanel hosting now on free hosting but x10 does :)