newttster

Are you going to be doing everthing yourself? Like the coding, images, db management, etc. Are you planning to pay someone to do all of this for you? If you are planning to do all of this yourself, there are plenty of threads here to assist you. Start with going to the forum tab, scroll down til you see the Technics section and browse through there to start learning. The web has tons of resources to help with this also. If this is something that you plan to undertake yourself with no prior knowledge then expect to spend a great deal of time to produce something that people will want to play. You are probably looking at minimum 1 year plus, and that's assuming that you learn really fast and do nothing but this. If you plan to pay someone to do all of this for you ... well then ... I would say you are looking at minimum around $5,000 and that would be just a bare bones game. No special features, systems, graphics. For someone to do an outstanding game for you with everything included ... depending on who does it for you ... $15,000 plus if not thousands more than that. High? You bet ... they would be doing everything for you and that takes time, I would say around $15-$20 per hour. Good luck.

Nice addition. Some people are visual learners; so no matter how many times you explain it, until they actually see it being done they won't get it. Good job.

The game is new so we do not have many members so please get more people to join and the game will be more better. More better???

As Kyle and ruler said ... the easiest way to do this is to use the actual ID number from the items table. The other thing you may have to do is do a time check as well for how long the user is in jail. This of course is assuming that you are talking about using a release item for you as the player, not another player release. For that there is the bail and bust systems.

Yes ... I am back to this. :) I am trying to set it up so that when my war ends ... it will delete the record from the table. I realize that I have to do a comparison of the current time and the time that the war ends, which is already stored in a table. My confusion lies in how and where I would implement this code. I have read all the various time type functions that I can find ... but they all give examples with interval or do comparisons to show the difference. I already know how to do the difference comparison as I have set up a count down clock for the players to see how much time is left until the end of the war. I really am stumped on this. I don't know how to write it, which file it would go in or even if I should use php or something else.

You may want to double check your information about that ... because it does run in the background. Check your resource monitor.

I use Microsoft essentials as well. To date, never had a problem with it.

I notice that you don't mention anything about security ... can you handle this as well?

Okay ... one of the things that I have been struggling to get to work is the way the attacks work. The way I want it to work is this; Gang A and B are at war. Gang A player can hit Gang B player, Player C and Player D and another member of Gang A Gang B player can hit Gang A player, Player C and Player D and another member of Gang B Player C can hit Player D but not Gang A player or Gang B player Player D can hit Player C but not Gang A player or Gang A player So ... it all works except for Gang A Player being able to hit another member of Gang A or Gang B Player being able to hit another member of Gang B. This is the code that has the above working. $t=($db->fetch_row($db->query("SELECT * FROM gangwars WHERE (warDECLARER={$them['gang']} OR warDECLARED={$them['gang']})"))); if(($them['gang'] == $t['warDECLARER']) AND ($me['gang']!= $t['warDECLARED']) OR ($them['gang'] == $t['warDECLARED']) AND ($me['gang']!= $t['warDECLARER'])) { echo"This players gang is at war. You cannot attack them unless you are in the same war.<br /> <a href='explore.php'>Back to town</a><br /> $h->endpage(); $_SESSION['attacking']=0; $me['attacking']=0; $db->query("UPDATE users SET attacking=0 WHERE userid=$userid"); exit; }   I have tried all the variations that I can think of to accomplish the final bit where Players can attack their own gang members during war ... and I just can't see how to do this. Any ideas would be appreciated.

You could set it up so that the result of the crime is posted into a sesssion ... have a refresh set to 0 seconds where it echoes out the message as well as having a link that they have to click to go back to the crime and then unset the session.

Do you have any references? Someone we could contact about your work?

If you mean by that a table ... then I would create a table with all the pertinent data specific to the user. I would also index on userid instead of username.

Thank you for your input, Octarine. I will be testing that shortly. Can you explain this though. There is some sense in pre-locking the inventory table, but given the ""engine"" the code is running on, that appears overkill as so many other things are liable to fail. Specifically ... locking the table and what things are liable to fail. I know very few people care for McCodes as an engine ... as this is what I am currently learning on I would like to know all that I can in order to improve what I have.

*facepalms* That works wonderfully. Thanks HD. Any idea how I would get it to add the items that were removed to another players inventory. I've tried item_add ... doesn't work. Tried ... $db->query("UPDATE `inventory` SET `inv_qty` = (`inv_qty` + 1) WHERE `inv_itemid` = `{$i['inv_itemid']}` AND `inv_userid` = '{$ir['userid']}'"); and it doesn't work either. Forgot to mention that is saying that the {$i['inv_itemid']} is what is throwing an error.

First part of the code that displays the table.   echo"<h3><font color=steelblue><u>Users Inventory Items Are Listed Below</u></h3>"; $inv=$db->query("SELECT iv.inv_id,iv.inv_qty,iv.inv_applied,iv.inv_itemid,iv.inv_userid, i.itmid,i.itmname,i.itmtype, i.effect1_on,i.effect2_on,i.effect3_on,i.itmuseable,i.itmsendable, i.itmtransferable, i.itmapplied,i.weapon,i.head,i.neck,i.arms,i.torso,i.legs,i.feet,i.special1,i.special2,i.special3, i.itmsellprice,it.itmtypename 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_userid={$_GET['oneall']} AND i.itmtype!=1 AND i.itmtype!=45 AND iv.inv_qty >5 ORDER BY i.itmtype ASC, i.itmsellprice ASC, i.itmname ASC"); if ($db->num_rows($inv) == 0) { echo "<b>This user has no items!</b>"; } else { echo "Click on the Take button at the bottom of the table to take one of each item.<br /> <table border='1' bordercolor='red' cellspacing='0'> <tr style='background: gray'> <td class='tableleft'><font color=black>Item</td> <td class='tableleft' ><font color=black>Quantity</td> </tr>"; } while($i=$db->fetch_row($inv)) { echo "<tr><td>{$i['itmname']}</td> <td>".number_format($i['inv_qty'])."</td> </tr>"; } echo "</table><br />"; echo" <form action='casting5a.php?id={$i['inv_userid']}' method='post'> <input type='hidden' name='taking'/> <input type='submit' value='Take one of Each' /> </form>";   Then the code that has me stuck is the taking part $inv=$db->query("SELECT iv.inv_id,iv.inv_qty,iv.inv_applied,iv.inv_itemid,iv.inv_userid,i.itmid,i.itmname,i.itmtype, i.effect1_on,i.effect2_on,i.effect3_on,i.itmuseable,i.itmsendable, i.itmtransferable, i.itmapplied,i.weapon,i.head,i.neck,i.arms,i.torso,i.legs,i.feet,i.special1,i.special2,i.special3, i.itmsellprice,it.itmtypename 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_qty>5 and iv.inv_userid={$_GET['id']}"); $i=$db->fetch_row($inv);   From there ... I have no idea how to proceed.

I am trying to write a mod that will take 1 of each inventory item that is over a quantity of 5. That part I have gotten to work so that it displays to the screen. It lists every item that is over a quantity of 5. No problem. I can get it to take 1 from just 1 item. No problem. The problem comes in when trying to go through the list of items that have been displayed. I'm pretty sure that it obviously has to be a loop of some sort with a counter ... but I can't figure out what kind of loop and how to get it to stop after it has gone through theitem list once. I have been reading up on loops and from what I have come to understand ... (granted that isn't much) it has to also include an array. Once I hit arrays ... I am lost. gumballs = 6 candy sticks = 7 chocolate bar = 9 ... then once the loop is finished you are left with gumballs = 5 candy sticks = 6 chocolate bar = 8. Anyone have any idea how I can accomplish this? Or if it can be done.

You know ... it's been one of those days. Grr. I had it there ... the only problem ... forgot the brackets. Thanks Dj. This can be closed. *walks away really embarrassed*

For the life of me I cannot figure out why this is cutting my page off and not displaying the bottom half of my css. As far as I can tell I have all the tags closed. Anyone have an idea why this code would be doing this? Any suggestions would be greatly appreciated.       function index() { global $db,$ir,$c,$h,$userid; echo"<center><font color=steelblue><h3>Yada Yada</h3> Blurb<br />Blah<br /><br />"; echo" <table> <tr> <td> <a href='link><img src='uparrow.png'></a> </td> </tr> <tr> <td> <a href='link'><img src='leftarrow.png'></a> <a href='link'><img src='rightarrow.png'></a> </td> </tr> <tr> <td> <a href='link'><img src='downarrow.png'></a> </td> </tr> </table></font></center>"; }

Congratz! Good job!

You are editing, right ... not creating a new one from what I can see. Could it have to do with the field not being defined in your table? Or it's a different type of field. int instead of decimal ... or vice versa? Just throwing some ideas that have snagged me in the past.

I'm not sure how v1 works ... but in v2 certain fields have to be filled or it throws an error. *shrugs*

I could be wrong ... but where are you gathering the data for the nlevel, nomoney, ncrystals etc? Where are you declaring that they have to be set (isset)?

Every time I'm finished doing any thing with my game files and db ... I do a backup before signing out. Would this accomplish the same thing? I keep atleast 3 backups at all times .. just in case the latest 2 have errors in them.

I like this idea ... but doesn't that eliminate potential players in the same house, apartment builiding, school dial up etc???

Woot!! And we have a winner!! Thank you so much for that Dj ... works like a dream. sniko ... thank you for all of your time and effort on helping me with this. It is very much appreciated.