cm31

I have tryed that and it breaks the page

Thats for making a DP into an item i want to put an item into a DP

Stop trolling me man I have tried that -.-

I have an have found nothing on it that explains how to do it -.-

Hey I'm trying to get it so that way when a user uses a Donater pack that will get stats money crystals level and an item but I can get the item to work Help me thanks MyDp.php   <?php include "globals.php"; $_GET[iD] = abs((int) $_GET[iD]); if(!$_GET[iD]) { echo '<h2>Oops</h2>Invalid use of file'; } else { $i=$db->query("SELECT iv.*,i.*,it.* FROM inventory iv LEFT JOIN items i ON iv.inv_itemid=i.itmid LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid WHERE iv.inv_id={$_GET[iD]} AND iv.inv_userid=$userid"); } if(!$db->num_rows($i)) { print "<h2>Oops</h2>Invalid item ID"; } else { $r=$db->fetch_row($i); if($r[itmid] == 32) { $db->query("UPDATE users SET donatordays=donatordays+365 WHERE userid=$userid"); $db->query("INSERT INTO inventory VALUES('',$itemid,$userid,1)); $db->query("UPDATE users SET money=money+1500000000 WHERE userid=$userid"); $db->query("UPDATE users SET crystals=crystals+75000 WHERE userid=$userid"); $db->query("UPDATE userstats SET IQ=IQ+1000000 WHERE userid=$userid"); echo '<h2>Donator Pack</h2>You have used your donator pack!'; } item_remove($userid, $r['inv_itemid'], 1); } $h->endpage(); ?>

No it will send the mail but no (1) Will come up but we do get the mail's

When I get new mail it wont show Mailbox (1) it will just stay at (0) and I have looked and it looks to me the codes are right if any one can help thanks   Mainmenu.php   <?php global $db,$c,$ir, $set; $hc=$set['hospital_count']; $jc=$set['jail_count']; $ec=$ir['new_events']; $mc=$ir['new_mail']; $var2['num_users_on'] = mysql_query("SELECT userid FROM users WHERE laston >= UNIX_TIMESTAMP()-900", $c); $var['num_users_on'] = mysql_num_rows($var2['num_users_on']); if($ir['hospital']) { print "[url='hospital.php']Hospital ($hc)[/url] [url='inventory.php']Inventory[/url] "; } elseif($ir['jail']) { print "[url='jail.php']Jail ($jc)[/url] "; } else { print "<a href='index.php'><font>Home</font> [url='inventory.php']Inventory[/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] "; } if($ir['jail'] and !$ir['hospital']) { print "[url='inventory.php']Inventory[/url] [url='gym.php']Jail Gym[/url] [url='hospital.php']Hospital ($hc)[/url] "; } else if (!$ir['hospital']) { print "<a href='explore.php'><font>Explore</font> [url='street.php']Streets[/url] [url='gym.php']Gym[/url] [url='criminal.php']Crimes[/url] [url='job.php']Your Job[/url] [url='education.php']Local School[/url] [url='hospital.php']Hospital ($hc)[/url] [url='jail.php']Jail ($jc)[/url] "; } else { print "[url='jail.php']Jail ($jc)[/url] "; } print "<a href='donator.php'><font color=red size=+1>Donate</font> "; print "<a href='forums.php'><font color=white>Forums</font> "; if($ir['new_announcements']) { print "[url='announcements.php']Announcements ({$ir['new_announcements']})</font>[/url] "; } else { print "<a href='announcements.php'><font color=white>Announcements (0)</font> "; } print " <a href='newspaper.php'><font color=white>News Paper</font> [url='chat.php']Chat[/url] [url='usersonline.php']Users Online [b]({$var['num_users_on']})[/b][/url] [url='search.php']Search[/url] "; if(!$ir['jail'] && $ir['gang']) { print "<a href='yourplatoon.php'><font color=red>Your Platoon</font> "; } if($ir['user_level'] > 1) { print "<hr /> [b]Staff Only[/b] \n"; if($ir['user_level']==7) { print "[url='owner.php']Owner Panel[/url] \n"; } if($ir['user_level']==2) { print "[url='admpanel.php']Admin Panel[/url] \n"; } if($ir['user_level']==3) { print "[url='secpanel.php']Secretary Panel[/url] \n"; } if($ir['user_level']==4) { print "[url='asspanel.php']Assistant Panel[/url] \n"; } if($ir['user_level']==5) { print "[url='modpanel.php']Moderator Panel[/url] \n"; } if($ir['user_level']==6) { print "[url='helperpanel.php']Helper Panel[/url] "; } } if($ir['user_level'] > 0) { print "<hr />[b]DS Staff Online:[/b] "; $q=$db->query("SELECT * FROM users WHERE laston>(unix_timestamp()-15*60) AND user_level > 1 ORDER BY userid ASC"); while($r=$db->fetch_row($q)) { $la=time()-$r['laston']; $unit="secs"; if($la >= 60) { $la=(int) ($la/60); $unit="mins"; } if($la >= 60) { $la=(int) ($la/60); $unit="hours"; if($la >= 24) { $la=(int) ($la/24); $unit="days"; } } print "[url='viewuser.php?u={$r[']{$r['username']}[/url] ($la $unit) "; } } if($ir['donatordays']) { print "<hr /> [b]Donators Only[/b] [url='ddreward.php']Daily Donator Reward[/url] [url='friendslist.php']Friends List[/url] [url='blacklist.php']Black List[/url] [url='calc.php']Calculator[/url]"; } print "<hr /> [url='preferences.php']Preferences[/url] [url='preport.php']Report Player[/url] [url='bugtracker.php']Bug Report[/url] [url='helptutorial.php']Help Tutorial[/url] [url='gamerules.php']Game Rules[/url] [url='viewuser.php?u={$ir[']My Profile[/url] [url='logout.php']Logout[/url] Time is now "; echo date ('F j, Y')." ".date('g:i:s a'); ?>     Mailbox.php   <?php include "globals.php"; include "bbcodestyle.css"; include "bbcode.php"; if($ir['mailban']) { die("<font color=red><h3>! ERROR</h3> You have been mail banned for {$ir['mailban']} days. [b]Reason: {$ir['mb_reason']}</font>[/b]"); } $_GET['ID'] = abs((int) $_GET['ID']); print "<table width=90% class='' cellspacing=''><tr><td>[url='mailbox.php?action=inbox']Inbox[/url]</td> <td>[url='mailbox.php?action=outbox']Sent Messages[/url]</td> <td>[url='mailbox.php?action=compose']Compose Message[/url]</td> <td>[url='mailbox.php?action=delall']Delete All Messages[/url]</td> <td>[url='mailbox.php?action=archive']Archive Messages[/url]</td><td>[url='contactlist.php']My Contacts[/url]</td> <tr><td>[url='ignore.php?action=inbox']Ignore List[/url]</td> </tr></table> "; switch($_GET['action']) { case 'inbox': mail_inbox(); break; case 'outbox': mail_outbox(); break; case 'compose': mail_compose(); break; case 'delete': mail_delete(); break; case 'send': mail_send(); break; case 'delall': mail_delall(); break; case 'delall2': mail_delall2(); break; case 'archive': mail_archive(); break; default: mail_inbox(); break; } function mail_inbox() { global $db,$ir,$c,$userid,$h; print <<<OUT Only the last 25 messages sent to you are visible. <table width=75% class=\"\" border=\"1\" cellspacing=\"1\"> <tr> <td class="h" width="30%">From</td> <td class="h" width="70%">Subject/Message</td> </tr> OUT; $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_from=u.userid WHERE m.mail_to=$userid ORDER BY mail_time DESC LIMIT 25"); while($r=$db->fetch_row($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>"; if($r['userid']) { print "[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]"; } else { print "SYSTEM"; } $fm=urlencode($r['mail_text']); print <<<EOF </td> <td>{$r['mail_subject']}</td> </tr> <tr> <td>Sent at: {$sent} [url='mailbox.php?action=compose&ID={$r[']Reply[/url] [url='mailbox.php?action=delete&ID={$r[']Delete[/url] [url='preport.php?ID={$r[']Report[/url] </td> <td>{$r['mail_text']}</td> </tr> EOF; } if($ir['new_mail'] > 0) { $db->query("UPDATE mail SET mail_read=1 WHERE mail_to=$userid"); $db->query("UPDATE users SET new_mail=0 WHERE userid=$userid"); } echo '</table>'; } function mail_outbox() { global $db,$ir,$c,$userid,$h; print "Only the last 25 messages you have sent are visible. <table width=75% cellspacing=1 class=\"\" border=\"1\" cellspacing=\"1\"><tr style='background:gray'><th>To</th><th>Subject/Message</th></tr>"; $q=$db->query("SELECT m.*,u.* FROM mail m LEFT JOIN users u ON m.mail_to=u.userid WHERE m.mail_from=$userid ORDER BY mail_time DESC LIMIT 25"); while($r=$db->fetch_row($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>[url='viewuser.php?u={$r[']{$r['username']}[/url] [{$r['userid']}]</td><td>{$r['mail_subject']}</td></tr><tr><td>Sent at: $sent </td><td>{$r['mail_text']}</td></tr>"; } } function mail_compose() { global $ir,$c,$userid,$h; print "<form action='mailbox.php?action=send' method='post'> <table width=75% border=2> <tr> <td>ID to send to:</td> <td><input type='text' name='userid' value='{$_GET['ID']}' /></td></tr><tr> <td>Subject:</td> <td><input type='text' name='subject' /></td></tr><tr> <td>Message:</td> <td><textarea rows=5 cols=40 name='message'></textarea> <input type='submit' value='Send' /></td></tr></table></form>"; if($_GET['ID']) { print " <table width=75% border=2><tr><td colspan=2>[b]Your last 5 mails to/from this person:[/b]</td></tr>"; $q=mysql_query("SELECT m.*,u1.username as sender from mail m left join users u1 on m.mail_from=u1.userid WHERE (m.mail_from=$userid AND m.mail_to={$_GET['ID']}) OR (m.mail_to=$userid AND m.mail_from={$_GET['ID']}) ORDER BY m.mail_time DESC LIMIT 5",$c); while($r=mysql_fetch_array($q)) { $sent=date('F j, Y, g:i:s a',$r['mail_time']); print "<tr><td>$sent</td> <td>[b]{$r['sender']} wrote:[/b] {$r['mail_text']}</td></tr>"; } print "</table>"; } } function mail_send() { global $ir,$c,$userid,$h; $subj=str_replace(array("\n"),array(" "),strip_tags($_POST['subject'])); $msg=bb2html($_POST['message']); $newmsg = str_replace($codes, $images, $msg); $to= (int) $_POST['userid']; mysql_query("INSERT INTO mail VALUES ('',0,$userid,$to,unix_timestamp(),'$subj','$newmsg')",$c) or die(mysql_error()); print "Message sent. [url='mailbox.php']> Back[/url]"; } function mail_delete() { global $db,$ir,$c,$userid,$h; $db->query("DELETE FROM mail WHERE mail_id={$_GET['ID']} AND mail_to=$userid"); print "Message deleted. [url='mailbox.php']> Back[/url]"; } function mail_delall() { global $ir,$c,$userid,$h; print "This will delete all the messages in your inbox. There is [b]NO[/b] undo, so be sure. [url='mailbox.php?action=delall2']> Yes, delete all messages[/url] [url='mailbox.php']> No, go back[/url]"; } function mail_delall2() { global $db,$ir,$c,$userid,$h; $db->query("DELETE FROM mail WHERE mail_to=$userid"); print "All ".$db->affected_rows()." mails in your inbox were deleted. [url='mailbox.php']> Back[/url]"; } function mail_archive() { global $ir,$c,$userid,$h; print "This tool will download an archive of all your messages. [url='dlarchive.php?a=inbox']> Download Inbox[/url] [url='dlarchive.php?a=outbox']> Download Outbox[/url]"; } $h->endpage(); ?>   Thanks guys for the help and if you can let me know how to fix this THANKS =D :D

Thanks but I found what i was looking for right here [mccode] Main menu users online count

lol I'm still lost is there a way to add it to the mainmenu.php file

Do you have any codes for the data base menu I'm a noob when it comes to coding xD Thanks

I am wondering How To get my main menu to Shoe How may players Thats areOn Line Like if there were 5 Players online it will show Player Online (5) Thanks