gurpreet

Re: [REVIEW]Battle Century - Please review!! Looks pretty good. Need a <title> and a little bit less vertical scrolling and a new banner, but other than that, very nice. :-)

Re: [mccode v2] Gang Recruit http://death-wars.com/yourgang.php?acti ... t2=recruit Nothing happens when I click gang recruit, the adress bar changes to the above but it's stil on the same page as before (staff room panel in gangs) any ideas?

Re: [REVIEW] The Mafia Brotherhood - Please review!! Login - Everything all over the place, 1/10 Register - Default Mccodes stuff 0/10 In-game - Take off shoutbox, too much vertical scrolling. Change crystal temple because you can get tonnes of crystals to get stats, causing mass failage. 2/10

Re: [MCCodes V2] Jail/Hosp Count +1 working perfectly.

Re: Adding an event_add Thanks works great :) Just the staff member who gives it getts a little error on line blah blah, but for the user everything is fine ;)

So I want it to make it so when I credit a user, it will send an event saying they have been credited. Under $db->query("UPDATE users u SET money=money+{$_POST['money']}, crystals=crystals+{$_POST['crystals']} WHERE u.userid={$_POST['user']}"); print "User credited.";   I add:   event_add("You were given ${$_POST['money']} and/or {$_POST['crystals']} crystals from the administration. If you would like to know why you were given this, mail GurpZ ID1.",$c);   Then I get that error with manual thing. The user still gets the money/crystals but no event, and the admin who credits them gets an error.

Re: [mccode] - ADV Search Nice killah, +1 My old advsearch didn't get correct jobs, had pre-made ones so didnt get the current jobs.

Re: New but old game. Money: $-10 On demo account. Also your exp bar is broken, the one that goes up as you get more %

Re: [mccode v2] Annoucements Upgrade! Just started getting this error this morning:   Warning: sprintf() [function.sprintf]: Too few arguments in /home/gurpreet/public_html/staff.php on line 150 QUERY ERROR: Query was empty Query was (blank bit here)   Just noticed you can't put a % in the announcement.

Re: [mccodes v2.0] Yet Another Attack   Warning: mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 16 in /home/gurpreet/public_html/class/class_db_mysql.php on line 91 1. You tried to hit Average bot you but missed (33350) 2. Average bot tried to hit you but missed (550)   Still getting that, even though I done everything you said.

Re: [mccode V2] Attack :) This is awesome so far, stops my players having to click for 1000 rounds :P +1 mate, but does it always hosp them and stuff? Also got a little bug...I think   Death-Wars Battles The fight Ratio is 7.56818181818% You are in a Battle with |< @ ? H ! You come in with your Fists With a Strength of 0 (+%) Takes their turn to swing at you! |< @ ? H ! hit you for 181,830,000 damage using their Heat-Seeking Rocket Launcher. beat you and stole $10055 from you.   I had 1,000 strength. Also notice the "Takes their turn", doesn't have a name for me.

Re: Some crons not working It comes up with the blank page (meaning it's working), but I need the actual query for the job, seems I don't have it.

Re: [mccode] Free Starter Pack   Can you give a donator pack as an item (aka starter pack, but just downgraded donator pack) using this?

Re: [mccodes v2] Advanced Crystal Temple. bump :mrgreen:

Re: [mccodes v2] Advanced Crystal Temple. I add this to my header next to the Brave, so it looks like Brave: 20/20 [Refill] Refill but it doesn't take away the 12 crystals, any ideas?

Re: [mccodes] Quote Mod When I add my quote under quote change, i get a blank page...

Re: [mccodes] Quote Mod So uhhmm...Where would be best to put this? Viewuser it might be too long (Varchar 255) so...yeah

Re: [mccode v2] Crystal Smuggling So I just replace the print " with sprintf "?

Re: [mccodes] Quote Mod Where would you put this? Viewuser?

Re: [mccode v2] Crystal Smuggling Tezza what did you edit?

Removed at request of OP.

Re: Gym Help Don't think you can...Don't want to mess with the $_POST['amnt']; unless you know what you want to do, or like you've seen, it will mess up your gym.

Re: Jail reason/Crime fail? Bump

In my day cron I seem to not have my job pay or job stat gains...Or the education gains.   <?php include "config.php"; global $_CONFIG; if($_GET['code'] != $_CONFIG['code']) { die(""); } 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; $db->query("UPDATE fedjail set fed_days=fed_days-1"); $q=$db->query("SELECT * FROM fedjail WHERE fed_days=0"); $ids=array(); while($r=$db->fetch_row($q)) { $ids[]=$r['fed_userid']; } if(count($ids) > 0) { $db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")"); } $db->query("UPDATE users SET csmuggling=csmuggling+10 WHERE csmuggling > 0"); $db->query("DELETE FROM fedjail WHERE fed_days=0"); $db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0"); $db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0"); $db->query("UPDATE users SET daysmarried=daysmarried+1 WHERE married !=0"); $db->query("UPDATE users SET userCONTRACT = userCONTRACT - 1 WHERE userCONTRACT > 0"); $db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*5.5) WHERE userBANKAMMT > 0 AND investlevel = 1"); $db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*3.0) WHERE userBANKAMMT > 0 AND investlevel = 0"); $db->query("UPDATE users SET userBANKAMMT = userBANKAMMT + (userBANKAMMT/100*7.2) WHERE userBANKAMMT > 0 AND investlevel = 2"); $db->query("UPDATE users SET userDAYS = userDAYS - 1 WHERE userDAYS != 0"); $db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0"); $db->query("UPDATE users SET turns=100"); $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0"); $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0"); $db->query("UPDATE users SET rates=1"); $db->query("UPDATE passreset SET time=time-1 WHERE time > 0") or die(mysql_error()); $db->query("DELETE FROM passreset WHERE time<=0") or die(mysql_error()); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0 && bankmoney < 15000000000"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0 && cybermoney < 750000000000"); $q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0"); while($r=$db->fetch_row($q)) { $cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}"); $coud=$db->fetch_row($cd); $userid=$r['userid']; $db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})"); $upd=""; $ev=""; if($coud['crSTR'] > 0) { $upd.=",us.strength=us.strength+{$coud['crSTR']}"; $ev.=", {$coud['crSTR']} strength"; } if($coud['crGUARD'] > 0) { $upd.=",us.guard=us.guard+{$coud['crGUARD']}"; $ev.=", {$coud['crGUARD']} guard"; } if($coud['crLABOUR'] > 0) { $upd.=",us.labour=us.labour+{$coud['crLABOUR']}"; $ev.=", {$coud['crLABOUR']} labour"; } if($coud['crAGIL'] > 0) { $upd.=",us.agility=us.agility+{$coud['crAGIL']}"; $ev.=", {$coud['crAGIL']} agility"; } if($coud['crIQ'] > 0) { $upd.=",us.IQ=us.IQ+{$coud['crIQ']}"; $ev.=", {$coud['crIQ']} IQ"; } $ev=substr($ev,1); if ($upd) { $db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid"); } $db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')"); } $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes;"); ?>   Any ideas what the queries are?

Nothing, working now, I put the code in the wrong place.