newttster

Firstly, I apologize if this is posted in the wrong area. I am drawing a complete blank on how to do this. I have googled it and I have looked through the threads here as well. I am probably using the wrong search for what I need. How do you make something specific to a certain location? For example if you wanted the Roulette game to be in one particular city and no other. Thanks in advance.

Meaning it is the sell price? My mistake ... I don't have my houses mod changed, only have the original table which is why this caught my eye. Hey ... I'm learning too. Sorry about that ... gave it a shot.

Not sure but shouldn't it be hPRICE instead of hSPRICE? Atleast that is what it is called in my house table.

Did you check your globals to make sure that the event_add function is there? Where are you placing that in your code?

It might help if you post what you have tried ... it's possible that you are close to what you want. It's hard for anyone to help if they have no idea what you have tried. Good luck.

11-19-2011, 09:57 AM skooda may I see your site 11-21-2011, 12:28 PM skooda Im just interesting see people site so I can take tips or buy mods ... I admit my error on this one ... he did not say he wanted ideas. He wants to take tips or buy mods. I don't code well enough yet to sell mods ... though I did post one for free around here somewhere. Unfortunately ... it was a mod that someone else had already made a better version of. 01-02-2012, 10:01 PM skooda Are you looking still to buy a game well if so I'm looking for a partner ... this one really confused me as I have never asked anyone or posted anywhere that I want to buy a game or looking for a partner. As for making a Mafia game ... no ... that is certainly not what my game is about. I have a licensed version 2 of Mccodes, thank you. You are correct in saying it is not done yet ... that's because I am taking the time to learn what I am doing first of all. Secondly I want something that will be relatively unique, not something that is just slapped together to try and make a few quick bucks. As I also said ... your ideas come across as very confused ... you do not make yourself clear in what you are asking. I did not intentionally make you out to be a bad guy ... I merely stated what my perception of you is. Right or wrong ... it is still my opinion. Doesn't mean that anyone has to agree with me.

I'm not sure all the players that are involved other than skooda. This person has been on my ignore list for some time. He wanted access to my site so that he could look at my mods so that he could get some "ideas". Being the distrusting type of person that I am I told him, no definitely not. He said why not ... I told him that I do not know him therefore I do not trust him ... he then wanted me to be partners with him. Not happening. When I want help I post here or ask people I have had dealings with that I know I can trust. Not sure if English is his second language or not but he comes across as being somewhat confused about things. Just my opinion of course.

Sniko ... if I understand correctly ... the free_result query that you are talking about ... accesses the table as it does the action and then releases the table and resources when finished doing the action? How would this effect resources on the players profile when accessing all of the various tables? IE user info, banking info, house info etc. Would that create more usage or less in reference to time loading etc?

I hate to keep going over the same point, Andy ... but given what you have put out there so far ... I doubt that anyone will message you for story writing of any kind. Sorry. If you had taken a few moments to check your work to begin with ... you "might" have gotten some takers. As it stands now ... that seems very unlikely.

Sorry ... foget to get back to this one. Thanks lucky ... that and a few other little tweeks is just what I needed to get it working. So thanks again.

Something along the lines of; It's been 50 years since the last bomb dropped ... wiping out the world as we knew it. There are only a few old timers that remember the world the way it was. Once they are gone ... so is most of our history. Each of us fights to make it through the next hour. Survival is the only way of life. There of those of us that choose to fight the roaming bands that go from place to place killing for nothing more than a loaf of bread, a can of food. Then there are those of us that fight to protect those that are weaker. We fight for freedom ... we fight for a better way of life. What will you fight for?

I appreciate that you are trying to make yourself some money ... and I wish you luck with that. However, if you are selling yourself as a story writer you may want to check and make sure that what you have written is correct with the correct spelling. Just sayin'.

Unless your players train their stats with non-donated items, I really don't think you want to set it up so that stats go down after so many days of the gym not being used. Nor would you want to limit how many stats they get if they are using donated items. Donations are what keep your game going ... if you limit what they can do with them you will very shortly find yourself without any donators.

I would say that you would have to (at minimum) triple that amount of time. First you have to understand how the language works and how it interacts with the database. Even with some programming background AND having the McCodes V.2 to work with, I have been at this for 15 months. I would say that I have about 15-20 percent of what I want done - done. And that's with all the help that I get from the generous people here who help when I get stuck. Of course, I do work full time and can't dedicate more than 2-3 hours a night to this. For Asap2Stack to say in post 7 that he will have a demo up in 3-4 days just blows my mind. I can't see anyone being able to do this unless they have 100+ coders and a Kray to work with. Just my opinion of course.

Thanks blue. I have changed the Post to Get. I had tried this before and neither had worked. What I had to do was take out the array. My next question is once my "direction" gets to the maximum number; How do I turn the link off?

I have mine set up pretty much the same way. The number_format function is fine in this case, I believe.

Yes it certainly is.

For the life of me, I can not figure out why this is not updating the db. What am I missing?   <?php include "globals.php"; $direction=array( 'North' => 'north', 'West' => 'west', 'East' => 'east', 'South' => 'south',); $dir=$direction[$_POST['direction']]; if($dir=="north") { $db->query("UPDATE catacomb SET north=north+1 WHERE userid=$userid"); } elseif($dir=="west") { $db->query("UPDATE catacomb SET east=east-1 WHERE userid=$userid"); } elseif($dir=="east") { $db->query("UPDATE catacomb SET east=east+1 WHERE userid=$userid"); } elseif($dir=="south") { $db->query("UPDATE catacomb SET north=north-1 WHERE userid=$userid"); } echo"<table align='center'> <tr > <td ><th colspan='15'> <a href='catacomb.php?direction=north'>North</a><br /><br /></td></tr> <tr > <td ><th> <a href='catacomb.php?direction=west'>West</a> <th> <th> <th> <th> <th> <th> <th> <th> <th> <th> <th> <th> <th> <a href='catacomb.php?direction=east'>East</a><br /></td></tr> <tr > <td ><th colspan='15'><br /> <a href='catacomb.php?direction=south'>South</a><br /></td></tr></table>"; $h->endpage(); ?>

Do you mean that you want to add more than one item at a time or multiples of one item?

Q7 ... any hints, Bert?

Stuck on Q4. All I can find is Dart or dash ... and neither is right. Grrrrr!

I know it's a real pain in the ass ... but what I have to do to avoid the whole 1 line and square blocks crappage is to import it into a Word program first ... then from there to Notepad++. So far this is the only way that I have found to top the garbled crap. Not sure if that helps or not.

Not sure ... but are you calling the globals more than once. Instead of "include" try "require once" for your globals.

@ Sniko ... I tried the new code ... now it doesn't update either. I added the or die(mysql_error()); and it is giving me no errors with it. Argghh ... who thought what would appear to be so simple is so damn hard to get working.

Can anyone tell me why I am getting this error? Obviously I am not defining something correctly, but I can't figure out what it is. The storagebox table has sbox_id, sbox_itemid, sbox_userid, sbox_qty. This is the error that I am getting. QUERY ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= `sbox_itemid` AND `sbox_userid` = '1'' at line 1 Query was UPDATE `storagebox` SET `sbox_qty` = `sbox_qty` + 1000 WHERE = `sbox_itemid` AND `sbox_userid` = '1' This is the code that I am working with.   <?php include "globals.php"; switch ($_GET['action']) { case 'gotransfer': go_transfer(); break; case 'transferdone': transfer_done(); break; default: index(); break; } //~~~~~~~~~~~~~~~~~~~~~~~~ function index() { global $db,$ir,$c,$userid,$h; $item=mysql_query("SELECT `inv_qty` FROM `inventory` WHERE `inv_itemid`='564' AND `inv_userid`='$userid'"); $item1=mysql_fetch_assoc($item); echo "<h2><u>Welcome to the transfer center</u></h2>"; echo "<table bordercolor=red border=1><td><h4>You currently have {$item1['inv_qty']} Silver Flakes to transfer.</h4><br /> <form action='transfer.php?action=gotransfer' method='post'> <input type='hidden' size='5'name='transfergem' /> <center><input type='submit' value='Transfer' /></center></form></td></table> "; $h->endpage(); exit; } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ function go_transfer() { global $db,$ir,$c,$userid,$h; $item=mysql_query("SELECT `inv_qty` FROM `inventory` WHERE `inv_itemid`='564' AND `inv_userid`='$userid'"); $item1=mysql_fetch_assoc($item); if($_POST['transfergem'] > $item1['inv_qty']) { echo "You are trying to transfer more than you have.<hr /> <a href='transfer.php'>Back</a>"; } else { echo"You've chosen to transfer {$item1['inv_qty']}.<br /> <form action='transfer.php?action=transferdone' method='post'> How many do you want to transfer? <input type='text' size='5' name='transfergem' value='' /> <input type='submit' value='Transfer Item' /></form>"; } } //~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ function transfer_done() { global $db,$ir,$c,$userid,$h; $item=mysql_query("SELECT `inv_qty` FROM `inventory` WHERE `inv_itemid`='564' AND `inv_userid`='$userid'"); $item1=mysql_fetch_assoc($item); $inc=$item1['inv_qty']-$_POST['transfergem']; $tabs=$_POST['transfergem']; $gain=$_POST['transfergem']; $db->query("UPDATE `storagebox` SET `sbox_qty` = `sbox_qty` + ". $gain ." WHERE {$item1['inv_itemid']} = `sbox_itemid` AND `sbox_userid` = '$userid'"); item_remove($userid,564,$tabs); echo "Congratulations!<br /> You have transferred {$tabs} to your Storage box.<br /> You now have {$inc} left in your inventory.<br /> <a href='transfer.php'>Transfer more</a><br /> <a href='explore.php'>Back to town</a>"; } $h->endpage(); ?>