DevonNice

It seam im having trouble with creating table and such with sql What i want to do it create a mod that allows player to purchase upgrades. Like there will be a table and have a list of upgrades you can buy. I have a basic idea on how i wont the sql to be writin Like if someone purchases the first upgrade out of 10 it will be enter into the table 1. And everyone would start off at 0 and every upgrade would make the number rise by 1 I dont know if you guys get what im saying But if anyone wants to team up and help me with the project that would be great I'm wanting to create a reward based system which the upgrades would consist of - Member having a higher chance of finding items. - increase their Health and others when i think of them, and think of a way to add them to the game. Devon.

So many what?

its nothing major just simple save your current mainmenu, then overwrite with this code. If you dont like it, just paste your original back in.

Hey everyone, I'm sure no one in these threads really knows me. But im fairly new to the MCcodes World. I wouldn't exactly call this a mod, more of a rewrite. Since the original Mainmenu.php was very very sloppy and difficult for some people to edit without causing problems. All you need to do is replace your mainmenu.php With this code..   <?php global $db,$c,$ir, $set; $hc=$set['hospital_count']; $jc=$set['jail_count']; $ec=$ir['new_events']; $mc=$ir['new_mail']; if ($ir['location'] == 1 ) { //////Hospital Sidebar if($ir['hospital']) { print "[b]<font color=red>Hospital[/b] - {$ir['hospital']} Minutes</font> "; print "?[url='hospital.php']Hospital[/url] ?[url='inventory.php']Items[/url] "; if($ec > 0) { print "?[url='events.php']Events ($ec)[/url] "; } else { print "?[url='events.php']Events (0)[/url] "; } if($mc > 0) { print "?[url='mailbox.php']Mailbox ($mc)[/url] "; } else { print "?[url='mailbox.php']Mailbox (0)[/url] "; } print "?[url='newspaper.php']Newspaper[/url] ?[url='forums.php']Forums[/url] ?[url='jail.php']Jail[/url] ?[url='search.php']Search[/url] "; if($ir['donatordays']) { print " ?[url='friendslist.php']Friends List[/url] ?[url='blacklist.php']Black List[/url] "; } if($ir['new_announcements']) { print "?[url='announcements.php']News ({$ir['new_announcements']})[/url] "; } else { print "?[url='announcements.php']News[/url] "; } if($ir['gang']) { print "?[url='yourgang.php']Your Gang[/url] "; } } //////Jail Sidebar elseif($ir['jail']) { print "[b]<font color=red>Jail[/b] - {$ir['jail']} Minutes</font> "; print "?[url='jail.php']Jail[/url] "; if($ec > 0) { print "?[url='events.php']Events ($ec)[/url] "; } else { print "?[url='events.php']Events (0)[/url] "; } if($mc > 0) { print "?[url='mailbox.php']Mailbox ($mc)[/url] "; } else { print "?[url='mailbox.php']Mailbox (0)[/url] "; } print "?[url='gym.php']Jail Gym[/url] ?[url='hospital.php']Hospital[/url] ?[url='newspaper.php']Newspaper[/url] ?[url='forums.php']Forums[/url] ?[url='search.php']Search[/url] "; if($ir['donatordays']) { print " ?[url='friendslist.php']Friends List[/url] ?[url='blacklist.php']Black List[/url] "; } if($ir['new_announcements']) { print "?[url='announcements.php']News ({$ir['new_announcements']})[/url] "; } else { print "?[url='announcements.php']News[/url] "; } if($ir['gang']) { print "?[url='yourgang.php']Your Gang[/url] "; } } ////////Sidebar else { print "[b]Areas[/b] "; print "?[url='index.php']Home[/url] ?[url='inventory.php']Items[/url] ?[url='explore.php']City[/url] "; if($ec > 0) { print "?[url='events.php']Events ($ec)[/url] "; } else { print "?[url='events.php']Events (0)[/url] "; } if($mc > 0) { print "?[url='mailbox.php']Mailbox ($mc)[/url] "; } else { print "?[url='mailbox.php']Mailbox (0)[/url] "; } print " ?[url='gym.php']Gym[/url] ?[url='crimes.php']Crimes[/url] ?[url='job.php']Job[/url] ?[url='education.php']Education[/url] ?[url='newspaper.php']Newspaper[/url] ?[url='hospital.php']Hospital[/url] ?[url='jail.php']Jail[/url] ?[url='forums.php']Forums[/url] "; if($ir['donatordays']) { print " ?[url='friendslist.php']Friends List[/url] ?[url='blacklist.php']Black List[/url] "; } print " ?[url='search.php']Search[/url] "; if($ir['new_announcements']) { print "?[url='announcements.php']News ({$ir['new_announcements']})[/url] "; } else { print "?[url='announcements.php']News[/url] "; } if($ir['gang']) { print "?[url='yourgang.php']Your Gang[/url] "; } } ////////Staff Panal if($ir['user_level'] > 1) { print " ?[url='staff.php']Staff Panel[/url] \n"; } ////////Options print " [b]Options[/b] ?[url='preferences.php']Preferences[/url] ?[url='preport.php']Player Report[/url] ?[url='helptutorial.php']Help Tutorial[/url] ?[url='gamerules.php']Game Rules[/url] ?[url='logout.php']Logout[/url] Server Time "; echo date ('F j, Y')." ".date('g:i:s a'); } else { print "Unavalible"; } ?>   It's nothing major, But hey its easier to navigate through. I also did way with the header telling you that your in the hospital or jail Now at the top of the mainmenu, instead of saying Areas it was either have Hospital - TIME or Jail - TIME   Thank you, Devon.

You want me to show you how i did it?

Thanks Illusions, it works perfectly!

Can someone help me with something i cant seem to figure out? OK, In viewusers.php Ive created image to go with Attack, Mail, Add to friend, enemies, and all that and what i want it to do is when someone hovers over the image the image will change. I have all the images i just dont know how to make the hover effect. Someone help me? heres the code.   print " [url='attack.php?ID={$r['][img=pp/au.png][/url] [url='mailbox.php?action=compose&ID={$r['][img=pp/sm.png][/url] [url='sendcash.php?ID={$r['][img=pp/sc.png][/url] [img=pp/break.png] [url='contactlist.php?action=add&ID={$r['][img=pp/ac.png][/url]"; if($ir['donatordays'] > 0) { print " [url='friendslist.php?action=add&ID={$r['][img=pp/af.png][/url] [url='blacklist.php?action=add&ID={$r['][img=pp/ae.png][/url]"; }

wait no this is there error..   Parse error: syntax error, unexpected $end in /home/iconcity/public_html/cron_day.php on line 76

Parse error: syntax error, unexpected '}' in /home/iconcity/public_html/cron_day.php on line 75

Can someone help me with my day crons? Its saying that theres an error on line 76. Thank you, Devon.   <?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 fishing_aloud=20"); $db->query("UPDATE users SET course=0 WHERE cdays=0"); $db->query("TRUNCATE TABLE votes;"); ?>

Thanks guys.

Anyone?

I've been working on this game for quite awhile would appericate it if you guys could check it out and maybe stick around?   Thank you, Devon

Does anyone have a better Newpaper layout? with easy to add articles and Advertisements?     Please mail me or just post below

Hello everyone, Ive been trying and trying but i cant do it.   what im looking for is a Profile signature to go on players Profiles and allows them to edit it. with BBcode. You know what im talking about?   For those of you that know the game Torncity Thats what im looking for. that kind of Profile Signature.   So if you guys happen to have a script lieing around and would like to post it please do so.   I dont have alot of money but im willing to pay if i have too.   Thank you, Devon

Hello everyone, im using MCv2 and im almost done with the site but im having a problem with my crimes. I dont know how to make them easy or make them harder.   its called the Success formula ((WILL*0.8)/2.5)+(LEVEL/4)   how do i change that to make it harder or easier when i started messing with it just makes it where i got to jail every time   If you know how to help me just add me to yahoo its - [email protected]   Thank you soooooo much for the help :)