illegalife

Re: [mccode] A better Safer Forum for your members to enjoy yea these forums are way better but would only add them if users wouldnt have to register again :/

I have a custom template on my website and it looks perfect when i use Firefox but its messed up on internet explorer it looks like this: http://i34.tinypic.com/rvm3v7.jpg anyone know how to fix this?

Re: Education Stuck, Voting Stuck hmm still didnt help idk whats with the day cron

Re: Full Crimes Commited yes but how do i make it so everytime somoene does a crime it adds to it? i think that would be   $db->query("UPDATE users SET crimes=crimes+1 WHERE userid=$userid");   but where do i put it?

Re: Education Stuck, Voting Stuck Do i change all the $r and $q variables only or all the variables like: $coud, $c, $ids, $upd, $ev etc... ?

I've been trying to figure this out but i cant. The education days doesnt go down and the voting doesnt reset so they can vote the next day this is my day cron. Edit: Seems like the whole day_cron.php is messed up cuz the job pay doesnt work either :(   <?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 mod_slots SET Tokens=Tokens+75"); $db->query("UPDATE users SET turns=25"); $db->query("UPDATE users SET daysmarried=daysmarried+1 WHERE married !=0"); $db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0"); $db->query("UPDATE users SET happiness=happiness-1 WHERE married != 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!')"); } $fo=fopen("jailshouts.txt","w"); $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes;"); fclose($fo); ?>

Re: [mccode v2] Ranks okay for busts i just put $db->query("UPDATE users SET busts=busts+1 WHERE userid={$r['userid']}"); in jailbust.php but i cant figure out the crimes

Warning: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/illegali/public_html/class/class_db_mysql.php on line 46 FATAL ERROR: Could not connect to database on localhost (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2))   what is this??? i woke up and i see this in my game

Re: [MCcode V2] Ranks   can somoeone help me with adding the SQL for busts and crimes please ? :(

Re: Making it harder to level up? thank u

Re: Limiting Characters in username -register,game thanks but it didnt really help me i didnt understand it :(

How do i limit the characters the username can have to 9 ? i want people to not be able to register with a name longer then 9 and then cant change their name in the game to anything longer then 9. can someone help me?

I want to make it harder for the users to level up. Like raise the exp needed for the next level what do i do and where do i do it? Need help please.

Re: item_add function so instead of $db->query("INSERT INTO inventory VALUES('',40,$userid,1)"); we write item_add("INSERT INTO inventory VALUES('',40,$userid,1)"); ???

So for example in the lucky boxes, i want one of the cases to give an item ID 99 to that user - how would i change this query? $money=rand(330, 3300); print "You find \${$money} in the box.)"; $db->query("UPDATE users SET money=money+{$money} WHERE userid={$userid}"); break;

This shows up when i click [remove] from a user form a black list. QUERY ERROR: Unknown column 'fl_ADDER' in 'where clause' Query was DELETE FROM blacklist WHERE bl_ID=4 AND fl_ADDER=127   can someone please help me fix this?

My users are geting negative numbers with their money... -$50 whats goin on? I need help asap please.

Re: Query Question (Energy) okay it worked fine but it took away 8% energy the first time i tried and 9% the second time i tried

Re: Query Question (Energy) it's actually for the jailbust.php im trying to fix it it's just messed up does anyone maybe have a fixed one?

Re: Query Question (Energy) i know its a noob question but what variables do i need to edit in the code for the 10% energy

How do i make it so it takes away 10% energy from a user, this query just $db->query("UPDATE users SET energy=maxenergy-10 WHERE userid=$userid"); $db->query("UPDATE users SET energy=maxenergy WHERE energy>maxenergy"); and also how do i make it so it dies if its less then 10% energy if($ir['energy'] < 1) { die("Sorry, it costs 10 energy to bust someone. You only have {$ir['energy']} energy. Come back later.");

Re: [mccode v2] Numbers Game i think that as long as theres more then 2 players it should work...

Re: [mccode v2] Numbers Game my cron doesnt work either :/

Re: Weird cron problem my host just replied me back he said the crons should be working everything is turned on what am i gonna do :(

Re: Weird cron problem Yes i just did a while ago didnt get the reply yet, anything else that could be wrong?