Reecey12345

I deleted it, as i said i have entered the original file, and it still doesnt work

<?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("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 mailban=mailban-1 WHERE mailban > 0"); $db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0"); $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;"); ?> - - - Updated - - - Looking at that im guessing i need a } at the end before ?>, i already added this and ran it again, nothing worked

For some weird reason, my cron day started to fail i entered some coding from a mod into it first and it was entered correctly but somehow started to fail, i removed it and put the original file in to see if my cron day will still work. It executes but still, donator days dont increase, lucky boxes cant be opened & Fedjailers days aint decreasing, so yes it isn't working. Any tips to fixing this? I can't go for a fresh reinstall, i have done hell of alot in my game now, got active members & donators, but an error like this they aint happy with and ive put my effort into fixing it and dont know what else to do as i cant know for sure until it executes yet again. All help appreciated.

Sorry for bump but when you request the trade it works but when the other user accepts the trade i cant view it? Any help?

Hey Sniko, im glad you shared this with us! Im just in need of a set of commands now to Delete chat history and to ban users and whatever else works:)

How do i do that D:

Still the page remains blank

Sorry for the bump, but any idea when i put this in my staff list it all goes blank? Yes i have done it correctly i think, but when i remove the Review part out again my stafflist works? <td>$on</td><td><a href="http://review.php?review={$r[" target="_blank">Review</a></td>

I fiddled around abit with the crime sql and ive managed to fix it:) thanks for the replys anyway.

I have installed MCCodes many times before, it was around 2 year ago I bought them and at the time when i gave them a try everything worked perfectly, unsure what the error could be now as i havent modified them, they should be the same as when i bought. Oh and if you mean it adds all the crimes for you? i didnt mean that, i meant it inserts the sqls for you thats all.

This is an error i get in the game, i didnt insert it, MCCodes automatically does it when installing and usually this works totally fine. If it is the problem anyway could i get a working one to enter?

So when i make one crime it works totally fine, when i try to make another i get this error: 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 ' 0, '1', '', '', '', '', , '', )' at line 1 Query was INSERT INTO crimes (crimeNAME, crimeBRAVE, crimePERCFORM, crimeSUCCESSMUNY, crimeSUCCESSCRYS, crimeSUCCESSITEM, crimeGROUP, crimeITEXT, crimeSTEXT, crimeFTEXT, crimeJTEXT, crimeJAILTIME, crimeJREASON, crimeXP) VALUES( '', '', '((WILL*0.8)/2.5)+(LEVEL/4)', '', , 0, '1', '', '', '', '', , '', ) Could someone fix this? I'm using an original MCCodes V2 testing it on a PAID domain & host, crons are also running. Any help appreciated.