Dragon Blade

Thanks RockWood, didn't work unfortunately. @KyleMassacre - I tried that but the only problem is, it doesn't show the price or the item. Just the row with my name on it.

Try this.   print "Marital Status: "; if ($r['married'] > 0) { $part=mysql_query("SELECT * FROM users WHERE userid={$r['married']}"); $pr=mysql_fetch_array($part); print "Married to <a href='viewuser.php?u={$pr['userid']}'>{$pr['username']}</a> for {$pr['married_days']} days<br />"; } else { print "Single<br />"; }

Hey there MWG once again! I need your help guys, Well in the itemmarket. I don't want the itemtypeid 9 to be shown there.   $q=mysql_query("SELECT im.*, i.*, u.*,it.* FROM itemmarket im LEFT JOIN items i ON im.imITEM=i.itmid LEFT JOIN users u ON u.userid=im.imADDER LEFT JOIN itemtypes it ON i.itmtype=it.itmtypeid ORDER BY i.itmtype, i.itmname ASC LIMIT $st, $app");   Any help will be great!

MySQL query returns a bool, i'm going to assume that item doesn't exist, therefore you need to check if it exists before doing the loop. Im not using the query to show the items? Im using another query

That only show's.... here   [ATTACH=CONFIG]1073[/ATTACH]

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/****/public_html/****/drugfarm.php on line 114   Line 114 - while($r=mysql_fetch_array($q))     function grow() { global $ir,$h; echo" <h3><u>Drug Farm</u></h3>"; $q=mysql_query("SELECT * FROM items WHERE itmid = {$_GET['id']}"); while($r=mysql_fetch_array($q)) if($r['itmtype'] != 9) { echo"<hr width='50%'>Please read the error message.<hr width='50%'><h3>! ERROR</h3>*** .<br/><br/> <hr width='50%'><a href='drugfarm.php'>> Go Back</a><hr width='50%'><br />"; $h->endpage(); exit; } if(isset($_GET['id'])) { echo" <hr width='50%'>Please read the confirmation message.<hr width='50%'><h3>! CONFIRMATION</h3>You have planted the drug, you will have to wait for 3 days to receive them.<br/><br/> <hr width='50%'><a href='drugfarm.php'>> Go Back</a><hr width='50%'><br />"; mysql_query("INSERT INTO drug_farm VALUES('','{$ir['userid']}','{$_GET['id']}',3)"); $h->endpage(); exit; } else { echo"<hr width=75%>Here to grow some drugs? Well you came to the right place!<hr width=75%><br /><br />"; print "<hr width='75%'> <table width=75% cellspacing=1 class='table'> <tr style='background:gray'> <th>Drug Name</th> <th width=35%>Drug Description</th> <th>Buy Price</th> <th>Sell Price</th> <th>Links</th> </tr>"; $q=mysql_query("SELECT * FROM items WHERE itmtype=9"); while($r=mysql_fetch_array($q)) { print " <td><a href='iteminfo.php?ID={$r['itmid']}'>{$r['itmname']}</a></td> <td><div style='text-align: left; padding-left: 5px;'>{$r['itmdesc']}</div></td> <td>\${$r['itmbuyprice']}</td> <td>\${$r['itmsellprice']}</td> <td><a href='drugfarm.php?action=grow&id={$r['itmid']}'>Grow</a></td> </tr>"; } print "</table><hr width='75%'><br /><hr width='50%'><a href='drugfarm.php'>> Go Back</a><hr width='50%'><br />"; $h->endpage(); exit; } }     If anyone can help me out, that would be great!

Sorry about that, just not good with titles..but Ill try next time.

Thanks Kyle! That worked perfect!

Hello there MWG! I need your help guys! I am trying to make all peoples inventory not show the itemtypedrugs along with item. This is my query   $inv = mysql_query( "SELECT `inv_qty`, `itmsellprice`, `itmid`, `inv_id`, `effect1_on`, `effect2_on`, `effect3_on`, `itmname`, `weapon`, `armor`, `itmtypename` FROM `inventory` AS `iv` INNER JOIN `items` AS `i` ON `iv`.`inv_itemid` = `i`.`itmid` INNER JOIN `itemtypes` AS `it` ON `i`.`itmtype` = `it`.`itmtypeid` WHERE `iv`.`inv_userid` = {$userid} ORDER BY `i`.`itmtype` ASC, `i`.`itmname` ASC");   How do I make it not show the item drugs?

Hmmm, okay what if I re-coded everything? If its not allowed then I only can sell the factions mod and CyberBank and Bank. Which I dont mind of course...

Hey there, I got that Car Race Modfication from MCCodes Market (Free) I completly fixed it up and re-coded everything. May I upload it as a paid mod? Its for both versions. I also got a Bug Report Modification...I want to put that up for free. (I re-coded that to)   I have my Faction Modfication, I want to put that as a paid modification. (Both Version) I have a Bank and Cyber Bank Modfication want to put that up for a paid mod aswell. You have to upgrade your bank to able to store more money, and if you upgrade your intrest rate goes up. And you gain x amout of money daily from intrest... (This also haves a staff feature, Both Version) Richard Estate Mod. Come along with marriage and sharing house with partner! (I re-coded everything!, Both Version) Any intrest mail me and I will show you the modifications...

I don't like using sprint f in my game, as I never used them. I will probaly make one today :)

Is there any gang allies modification around? If not I will make one. If there is I will re-code the modification and fix everything up.

On the title.

Or if your clever enough make your own. Start of with the DataBase. Code the rest.

{$bg['userBG']} is the user I am attacking bodyguard. If the userBG is in jail or hosp then I can't attack the user unless the userBG is in jail or hospital. But theres only rows if you get a BG (Hire someone)

Well I created a modification before...but I didn't finish it off.   http://makewebgames.io/showthread.php/43647-User-Bodyguard

Hello all, I need someone to help me out. When a userbodyguard is not in jail or hosp then they cant attack. I try to code it but it flops...   $bg=mysql_query("SELECT * FROM bodyguards WHERE userID = {$_GET['ID']}"); $bgcheck=mysql_query("SELECT * FROM users WHERE userid = {$bg['userBG']}"); if($bgcheck['hospital'] == 0 && $bgcheck['jail'] ==0) { print "<hr width='50%'>Please read the error message.<hr width='50%'><h3>! ERROR</h3>This player bodyguard is not in jail or hospital, therefore you cannot attack.<br/><br/> <hr width='50%'><a href='index.php'>> Go Home</a><hr width='50%'><br /> "; $h->endpage(); exit; }   I am quite sleepy if someone helps that would be great!

This is my DB for attacklogs...   log_id attacker attacked result time stole attacklog

Well wouldn't call it a modfication, more of a little addon, thanks :)

My members were really annoyed about getting attacked every secound. So I decided to create a little thing to attack.php Its a limit You can only attack 1 person 3 times every 30 minute. Add this in attack.php - $limit=mysql_query("SELECT * FROM attacklogs WHERE attacked = {$odata['userid']} AND attacker = {$ir['userid']} AND time > unix_timestamp()-1800"); if(mysql_num_rows($limit) >= 3) { print "<hr width='50%'>Please read the error message.<hr width='50%'><h3>! ERROR</h3>You already attack this user 3 times in the past 30 minutes.<br/><br/> <hr width='50%'><a href='index.php'>> Go Home</a><hr width='50%'><br /> "; $h->endpage(); exit; }

Great addon Ian! I like it! I actually love it! And Guest, thanks for the other bit! That helped to!

Hey there, thanks. And nice to see the new owner http://mccodemods.com/. Good luck!

Hello there, I have created a modification for V2. Sends an item to all users. So open up staff_users.php and find - case 'forcelogout': forcelogout(); break; Below it add - case 'massitemgive': mass_give_item(); break; case 'massitemgivesub': mass_give_item_sub(); break; Then find - $h->endpage(); ?> Above it add - function mass_give_item() { global $db,$ir,$c, $h; if($ir['user_level'] != 2) { print "<hr width='50%'>Please read the error message.<hr width='50%'><h3>! ERROR</h3>Admin Only<br/><br/> <hr width='50%'><a href='../index.php'>> Go Home</a><hr width='50%'><br />"; $h->endpage(); exit; } print "<h3>Giving Item To All Users</h3> <form action='staff_users.php?action=massitemgivesub' method='post'> Item: ".item_dropdown($c,'item')." Quantity: <input type='text' name='qty' value='1' /> Event: <input type='text' name='event' value='Event Word's Here' /> <input type='submit' value='Mass Send' /></form>"; } function mass_give_item_sub() { global $db,$ir,$c; $q=mysql_query("SELECT * FROM users WHERE fedjail=0"); while($r=mysql_fetch_array($q)) { $qty=abs(intval($_POST['qty'])); $item=abs(intval($_POST['item'])); $event=($_POST['event']); item_add($r['userid'], $item, $qty); event_add($r['userid'],"$event",$c); print "Item Sent To {$r['username']}</br>"; } print "Mass item sending complete!</br>"; stafflog_add("Gave {$_POST['qty']} of item ID {$_POST['item']} to all users"); } And your done.

BBcode enable, Well you can attack members for points, at the end of the month who ever has the most points will win something... (Money, Crystals, Items) 1st 2nd 3rd And a staff feature will come along with this...