AlabamaHit

Re: V2 Education days go negative don't doubt it...you miss understood.. I was saying you had the same thing in there 2 times. and you took out the wrong one... Try this..   <?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"); $q2=$db->query("SELECT * FROM fedjail WHERE fed_days=0"); $ids=array(); while($r2=$db->fetch_row($q2)) { $ids[]=$r2['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 splatturns=3"); $db->query("UPDATE users SET strategoturns=0"); $db->query("UPDATE users SET tokens=0"); $db->query("UPDATE users SET brothel=0",$c); $db->query("UPDATE users SET turns=25"); $db->query("UPDATE users SET tired=0"); $db->query("UPDATE users SET dare=5"); $db->query("UPDATE users SET popularity=2"); $db->query("UPDATE users SET clubvisits=0"); $db->query("UPDATE users SET happiness=happiness-1 WHERE married != 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 AND cdays > 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($r2=$db->fetch_row($q2)) { $cd=$db->query("SELECT * FROM courses WHERE crID={$r2['course']}"); $coud=$db->fetch_row($cd); $userid=$r2['userid']; $db->query("INSERT INTO coursesdone VALUES({$r2['userid']},{$r2['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("TRUNCATE TABLE votes"); $fo=fopen("jailshouts.txt","w"); fclose($fo); ?>

Re: [REVIEW] Crime-Network.com - Please review! http://www.thegrpg.com/ Ok....its not gRPG......what ever...you didn't code this from stratch....

Re: IPN Issue? well you really didn't tell us what th eproblem was.....Just that you had one...Explain the actual problem we will try to help :wink:

Re: V2 Education days go negative Your problem :-P   $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0"); $db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0 AND cdays > 0");

Re: Brave goes to minus its nothing to do with "int" Its got to do with somethign they added to the game which takes brave. And they didnt secure it by telling it not to take it if they don't have enough. Or somthing along that lines. With that said how the hell is someone supposed to help them when they can't help us help them.......He could have 5000 pages on his game or 50 pages...it don't matter but that problem can be from any of those pages. They need to track it down. And find where error is coming from...then explain better post small bit of code...THEN someon CAN help.....

Re: [mccode] Crimes give random money yeah but what is worst most of the time to change from v1 to v2 all you have to do is chagne the top to include globals.. mysql_query works Perfect on V2.........lol why change it? lol

Re: adjusting "left in the streets" Hospital time that is what you change. Are you sure you even are editing the right page?

Re: [mccode v1]Attack Stats you put the information in the wrong attack files i would say.... When I bought v2 the attack files where not right. attackleave was for muggin and such.

Re: Job Rank editing.   global $db, $ir, $userid; if($_POST['stage2']) { $sql = sprintf("UPDATE jobranks SET jrNAME = '%s', jrJOB = '%u', jrPAY = '%u', jrIQG = '%u' jrLABOURG = '%u', jrSTRG = '%u', jrIQN = '%u', jrLABOURN = '%u', jrSTRN = '%u' WHERE jrID = '%u' ", ($_POST['jrNAME']), ($_POST['jrJOB']), ($_POST['jrPAY']), ($_POST['jrIQG']), ($_POST['jrLABOURG']), ($_POST['jrSTRG']), ($_POST['jrIQN']), ($_POST['jrLABOURN']), ($_POST['jrSTRN']), ($_POST['jrID'])); mysql_query($sql); echo "Job rank updated!

Re: "if location =" ... query I'm not sure what you mean?

Re: "if location =" ... query   [url='shops.php']All Shops[/url] $q=$db->query("SELECT * FROM shops WHERE shopLOCATION={$ir['location']}"); while($r=$db->fetch_row($q)) { print "[url='shops.php?shop={$r[']{$r['shopNAME']}[/url] "; } echo" [url='itemmarket.php']Item Market[/url]   thats yours   [url='shops.php']All Shops[/url] "; $q=$db->query("SELECT * FROM shops WHERE shopLOCATION={$ir['location']}"); while($r=$db->fetch_row($q)) { print "[url='shops.php?shop={$r[']{$r['shopNAME']}[/url] "; } echo" [url='itemmarket.php']Item Market[/url]   Look at first Line... See the "; All Shops "; You didn't close a print or echo.Thats what I was meaning. And NO your statement to me was not obvious that you wanted me to help you current what you did. It sounded like you where getting smart saying it was not different from what You said before.

Re: V2 Staff password with admin function   VALUES ( '19', 'game_pass', 'default' )   can be   VALUES ( '', 'game_pass', 'default' )   its auto increment So. it will update the number for ya :-P

Re: Member-list Yup what Floydian said :-D lol he beat me back :-P

Re: Inventry Help! Good eye i didnt even notice that

Re: "if location =" ... query you have a pointless query. Thats how. why select the WHOLE shops table. when you already know the ID?? And your NOT closing the PRINT OR ECHOS nevermind...figure it out yourself..

Re: Weird Situation i ahve done that numerous times, lol. Look for hours and find out it was just i misspelled a word, lol.. like if($ir['usernmae']) and get no error, just not working, lol...and hours go by before i notice it, lol

Re: [mccode v2.0] Timestamp?   $check = mysql_query("SELECT userid, username, email FROM users WHERE laston < (unix_timestamp() -2592000) AND fedjail = 0 AND user_level != 0 reminder =0)"; $do = mysql_fetch_array($check);

Re: Weird Situation no one was checking stufrf like taht cause you said it worked perfect except for one Person.......   But I'm glad you got it working.

Re: Inventry Help! Its because your using else in places that should be else if

Re: "if location =" ... query make sure your closing and prints or echos before.. the code you used First is right.   echo "make sure this part is closed"; if($ir['location'] == 2) { echo "Show something here."; } echo "the rest of the page";   Thats right. It has to be something else on that page OR your not in location 2. That query says. IF "You" are in "location" "2" echo "Show something here" if your Not in location 2 it wont.

Re: Weird Situation i think POG was pointing you in direction........He was showing a way to try to see if taht 1 user shows with that code.......of course change the * to whatever fields your using...hes not coding your game, lol...Just helping :-P

Re: explorer.php is blank? no errors just blank? Quick glance..   [b]<u>Unknown</u>[/b] print "[url='battletent.php']Dub War[/url] "; print "</td></tr></table> This is your referal link: http://{$domain}/register.php?REF=$userid Every signup from this link earns you two dubplates!"; $h->endpage(); ?>   thats at the bottom of your page.....   [b]<u>Unknown</u>[/b] [url='battletent.php']Dub War[/url] </td></tr></table> This is your referal link: http://{$domain}/register.php?REF=$userid Every signup from this link earns you two dubplates!"; $h->endpage(); ?>

Re: Member-list Thats what i was saying was use limit..... I didn't say you was using mccodes...you did....or at least mentioned it so i though you was. $sql_1 = mysql_query("SELECT username FROM users LIMIT 25"); $sql_2 = mysql_query("SELECT username FROM users LIMIT 25,25"); Maybe something along that lines.

Re: Member-list I think their is a limit already.............100 or something like that... Just change the LIMIT 100 to LIMIT 25.....

Re: Need Help - Extra turns for donators No problem.