_Eagle

Re: [V1] V1 Help Please   Wolfe.. Had I wanted to, I could have put up a V2 game as far back as November 2006, when someone sent me the V2 code. It has been passed around like candy since then. Expect it.. the code is available out there in several places now.. for FREE. The set was not built to be anything BUT passed around.. plain text files with no configuration setup.. of course its going to get passed about. And no, I am not trying to be negative or anything. I am being factual. Lets see.. I am not even clear on who sent me the zips, but I received 2 of them. 1 was a copy from Battle Mafia (?) I think.. and one was GoldenZero.. thems the 2 I was sent, matter of fact, still have those original zips. never messed with it.

Re: If you have an item, you can create another?   Told ya. I am rusty.. not up to speed..

Re: If you have an item, you can create another? but I dont have all your file man.. you were asking about a query to give an item.. I am really trying to help you.. its not often I even speak on here..

Re: If you have an item, you can create another? he does not want it to just echo true or false though. he wants the system to give another item. Then, be sure to take that new item into account and be sure to wipe the ingredients, or you will find a whole ton of pizzas made on just one set of ingredients. Maybe this scenario. $pizza=$db->query("SELECT * FROM inventory WHERE inv_userid=$userid"); while($p=$db_fetch_row($pizza)) { if($p['inv_itemid']==32 && $p['inv_itemid']==33 && $p['inv_itemid']==34) { $db->query("INSERT INTO inventory VALUES('',35,$userid,1)"); $db->query("DELETE FROM inventory WHERE inv_itemid=32 and inv_userid=$userid LIMIT 1"); $db->query("DELETE FROM inventory WHERE inv_itemid=33 AND inv_userid=$userid LIMIT 1"); $db->query("DELETE FROM inventory WHERE inv_itemid=34 AND inv_userid=$userid LIMIT 1"); print"You have made a Pizza using all the need ingredients"; } else { print"You do not have the required ingredients to make pizza. You need to have Tomato, Cheese, and Crust."; } }

Re: If you have an item, you can create another? ok.. I will really honestly work on this. as I said.. that was one possible. another way would be to select all from a users inventory, then look for those particular items, 32, 33, and 34.. and if present, they can make the pizza. v2 code is not much different to write.. my game is still "v1".. if I had to version, prob v1.8 by now.. so much rewrite has gone on.. give me a bit.. I will find a workable solution for you.

Re: If you have an item, you can create another? could probably do it one of several ways. select those items like.. maybe.. $pizza=$db->query("SELECT * FROM inventory WHERE inv_itemid=32 && inv_itemid=33 && inv_itemid=34 AND inv_userid=$userid"); if($db->num_rows($pizza)){ $db->query("INSERT INTO inventory VALUES('',35,$userid,1)"); print"You made a pizza with all the required ingredients"; } else { print"You do not have all the required ingredients to create a pizza. You need Tomato, Cheese, and a Crust"; } that is one way possible. Course I am a rusty old sot.. others probably have a far better way.

Re: *special* McCodes v3 BETA Release I have not spoken much on here of late, but answer one question. When was the copyright officially filed, and what website can I contact to see an official copyright filed on "MC Code" ?.. Thanks.

Re: I'm at a dead end with my mccode modifications please help... I think I would make one little change to that cron Luke.. remember, he wanted his Females to get 20% energy ONLY if they were on one particular Island....(Location number.. whatever loc is supposed to be. if($ir['location']==1 && $ir['gender']=='Female') { mysql_query("UPDATE users SET energy=energy+maxenergy*.20 WHERE userid=$userid",$c); } else { mysql_query("UPDATE users SET energy=energy+maxenergy*.08 WHERE userid=$userid",$c); }   Or something along that line..

Re: i dont get it {$db->num_queries} queries</body> </html> OUT; } } ?> (line 230)   How about... {$db->num_queries} queries OUT; </body> </html> } } ?> (line 230)

Re: who likes mccodes? Having run with the DBS/mcCode for as long as I have, and having seen both sets.... Let us first get one thing clear.. V2 only added Bells and Whistles, and some layout changes.. the FILES were just about the very very same Version 1 files.... whatsit to change mysql_ to $db->, take out the v1 top structure and add include "globals.php"; change mysql_fetch_array to $db->fetch_row and have a working v2 file from v1.. done it.. hell, I had a v2 set GIVEN to me as far back as November 2006.. never launched it.. what DO I like about v2? php5 compliant. v1 is not. what DO I like about v1? easy to code. what do I NOT like about mccode? Database optimization-Non existant.. Am I saying DBS/MC Code is shit? No... it takes a LOT of work to improve, secure, and remove exploits. It is a good stepping stone to learn. v2 code: added a LOT more exploits.. for those that love to find them.. Give me a base game, I will exploit it in a new york second. I aint had a lot to say in a long time. I still am around, but... seems this is not the only time this question has ever been asked. I just figured to have my say this time.

Re: about Lucky Boxes?     Well, whatever your Will item ID is, you would change the query to...   case 4: $will=rand(1,5); print"Outcome(gained ".$will." Will Potions"; $db->query("INSERT INTO inventory VALUES('',willitemnr,$userid,$will)"); break; Just change the 'willitemnr' to your Will Item ID and you should be all set.

Re: Hall Of Fame Money Help (v1)   function hof_money() { global $ir,$c,$userid; print "Showing the 20 users with the highest amount of money <table width=75%><tr style='background:gray'> <th>Pos</th> <th>User</th> <th>Money</th> </tr>"; $q=mysql_query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON g.gangID=u.gang WHERE u.user_level != 0 ORDER BY money+bankmoney DESC,userid ASC LIMIT 20", $c); $p=0; while($r=mysql_fetch_array($q)) { $moneytotal=$r['money']+$r['bankmoney']; $p++; if($r['userid'] == $userid) { $t="[b]";$et="[/b]"; } else { $t="";$et=""; } print "<tr> <td>$t$p$et</td> <td>$t{$r['gangPREF']} {$r['username']} [{$r['userid']}]$et</td> <td>$t\$".money_formatter($moneytotal,'')."$et</td> </tr>"; } print "</table>"; }   Try that

Re: Monorail   try changing the $r['location'] to $ir['location']. Should function fine then.

User Notepad While Criminal Country was the first to employ any type of Note Structure(quite handy, actually)... Others out there can probably improve upon the original design. What I see is everyone making a complex operation out of something that really turned out to be extremely simple.