03laceys

Re: [MOD] Item Market Auction This auction market is the one by DBS i belive. I think the only auction markets that have been created are by dbs and lostone. (lostone's is more sucure and dosn't use a cron) Paid mod im pretty sure.

Re: Gang surrender accept, SQL error. I completly uploaded all original gang files and sql's and i still got the error managed to fix it though. try doing what i done it help me.

Re: Gang surrender accept, SQL error. According to the error the problem is: Here, $db->query("DELETE FROM gangwars WHERE warID={$_POST['war']}"); Or Here, $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}");   Ummmm any help?   Whole function if it help's function gang_staff_viewsurrenders() { global $db,$ir,$c,$userid,$gangdata; if(!isset($_POST['subm'])) { print "<form action='yourgang.php?action=staff&act2=viewsurrenders' method='post'> Choose who to accept the surrender from. <input type='hidden' name='subm' value='submit' /> Gang: <select name='sur' type='dropdown'>"; $wq=$db->query("SELECT s.*,w.* FROM surrenders s LEFT JOIN gangwars w ON s.surWAR=w.warID WHERE surTO={$ir['gang']}"); while($r=$db->fetch_row($wq)) { if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; } $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]); $them=$db->fetch_row($ggq); print "<option value='{$r['surID']}'>War vs. {$them['gangNAME']} (Msg: {$r['surMSG']})</option>"; } print "</select> <input type='submit' value='Accept Surrender' /></form>"; } else { $_POST['sur'] = abs((int) $_POST['sur']); $q=$db->query("SELECT surWAR FROM surrenders WHERE surID={$_POST['sur']}"); list($_POST['war']) = $db->fetch_row($q); $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}"); $r=$db->fetch_row($wq); if($gangdata['gangID'] == $r['warDECLARER']) { $w="You"; $f="warDECLARED"; } else { $w="Them"; $f="warDECLARER"; } $db->query("DELETE FROM surrenders WHERE surID={$_POST['sur']}"); $db->query("DELETE FROM gangwars WHERE warID={$_POST['war']}"); $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]);$them=$db->fetch_row($ggq);$event=str_replace("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have accepted the surrender from [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url], the war is over!");$db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')");print "You have accepted surrender, the war is over."; }}   There is no gang_surrender_accept() so it must be in the fuction provided. Any help?

Re: Gang surrender accept, SQL error. Thinking about it your correct it would be in this function :-o Oops, Hopefully i should be able to fix this now :D

Re: Has Chedburn of TC gone nuts? Are are some many people always talking about "chedburn". I have never played TC and never will. If he used to play "hobo wars" before TC came about how can he claim the original idea was his :?. I have not posted anything about "chedburn" before but i have truthly had enough hearing about this guy so many times on so many bored's allways moaning about him just forget him and get on with things!

Re: Gang surrender accept, SQL error. Ok, I am guessing it must make a difference then. I will have another crack at fixing it. if anyone else can help with the new info. Thank you.

Re: Gang surrender accept, SQL error. I have gang pic's that shouldn't make a difference should it?

Re: Gang surrender accept, SQL error. nope just errors.

Re: Gang surrender accept, SQL error. It just gives the same error.

Re: Gang surrender accept, SQL error. the form page look's fine no error's, the error only appears when submit it clicked.

Re: Gang surrender accept, SQL error. Any more help?

Re: Gang surrender accept, SQL error. Nope not working, same error.

Re: Gang surrender accept, SQL error.   function gang_staff_surrender() { global $db,$ir,$c,$userid,$gangdata; if(!isset($_POST['subm'])) { print "<form action='yourgang.php?action=staff&act2=surrender' method='post'> Choose who to surrender to. <input type='hidden' name='subm' value='submit' /> Gang: <select name='war' type='dropdown'>"; $wq=$db->query("SELECT * FROM gangwars where warDECLARER={$ir['gang']} or warDECLARED={$ir['gang']}"); while($r=$db->fetch_row($wq)) { if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; } $d=date('F j, Y, g:i:s a',$r['warTIME']); $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]); $them=$db->fetch_row($ggq); print "<option value='{$r['warID']}'>{$them['gangNAME']}</option>"; } print "</select> Message: <input type='text' name='msg' /> <input type='submit' value='Surrender' /></form>"; } else { $_POST['war'] = abs((int) $_POST['war']); $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}"); $r=$db->fetch_row($wq); if($gangdata['gangID'] == $r['warDECLARER']) { $w="You";$f="warDECLARED"; } else { $w="Them";$f="warDECLARER"; } $db->query("INSERT INTO surrenders VALUES('',{$_POST['war']},{$ir['gang']},".$r[$f].",'{$_POST['msg']}')"); $ggq=$db->query("SELECT * FROM gangs WHERE gangID=".$r[$f]); $them=$db->fetch_row($ggq); $event=str_replace("'","''","[url='gangs.php?action=view&ID={$ir[']{$gangdata['gangNAME']}[/url] have asked to surrender the war against [url='gangs.php?action=view&ID={$them[']{$them['gangNAME']}[/url]"); $db->query("INSERT INTO gangevents VALUES('',{$ir['gang']},unix_timestamp(),'$event') , ('',".$r[$f].",unix_timestamp(),'$event')"); print "You have asked to surrender."; } }   The function.

If any tries to accept a surrender they get the following error,   The error is in this line but i cant see the error.   $wq=$db->query("SELECT * FROM gangwars where warID={$_POST['war']}");   Any help? Thank you.

Re: News Latter V1 You are able to change it zebba. Also i belive zaver has to contact staff to get it removed.

Re: News Latter V1 Why hasn't this been removed?

Re: Cron trouble? thank you will edit and re-upload now and we will find out tomorrow. Thank you.

i am having a slight problem with my voting and schools... They are not resetting.   <?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 log=log-1 WHERE log > 0"); $db->query("UPDATE users SET gymp=gymp-1 WHERE gymp > 0"); $db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0"); $db->query("UPDATE users SET daysold=daysold+1"); $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 daysmarried=daysmarried+1 WHERE married > 0"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes"); $db->query("TRUNCATE TABLE rating"); $db->query("UPDATE users SET boxes_opened=0"); $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 bankmoney=bankmoney*bankpercent+bankmoney WHERE bankmoney>0 AND laston>unix_timestamp()-432000"); $db->query("UPDATE users SET banklevel=1 WHERE bankmoney>0"); $db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) WHERE cybermoney>0 laston>unix_timestamp()-432000"); $db->query("UPDATE users set ttime=ttime-1 WHERE ttime>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!')")"); } ?>   Any help?

Re: A Donator Pack System all Mccoders will want.... So where is the mod?

Re: MCCode v3 I would say $10 if it is like v2 not very secure and also easily distibuted.... If the secuirty has been upped severly then $25 If it has protection then around $200 for people who have bought mccode 1 or 2 and $250 for people who havn't If it has some nice new unique ideas then well the price could go up and up depending on the features. But if it has security at a reasonable level and copyright e.t.c.. to help stop it being redistubed then around $400 for first time buyers and $300 for second if you get what i mean.

Re: Your views on new layout mainmenu??? (Very unique i believe)   I kind of guessed it would have, thats why i stated as unique as possible...   Good idea i will do this.

Re: Your views on new layout mainmenu??? (Very unique i believe) Thank you for all the great comments... (i am looking for all good/bad comments) Keep them comming :)

Re: Mailbox popup... in header??? Ok i have had a play around and have got this far...   <?php global $db, $ir; if ($ir['new_mail'] > 0) { echo '<script> alert("You have 1 new mail!") </script>'; } else { } ?>   I have named that file mainmenu.php and got the header.php to call it. The pop up box works but pops up even if you dont have a new mail. Any more help?

Re: Your views on new layout mainmenu??? (Very unique i believe) I am adding a popup box like ce for when you recive a new message. I am trying to stray away from mccode base as much as possible.

Re: Your views on new layout mainmenu??? (Very unique i believe) Ok thank you for your opinion. I'm just trying to make it as unique as possible.