Smokey

INSERT INTO `crimes` (`crimeID`, `crimeNAME`, `crimeBRAVE`, `crimePERCFORM`, `crimeSUCCESSMUNY`, `crimeSUCCESSCRYS`, `crimeSUCCESSITEM`, `crimeGROUP`, `crimeITEXT`, `crimeSTEXT`, `crimeFTEXT`, `crimeJTEXT`, `crimeJAILTIME`, `crimeJREASON`, `crimeXP`) VALUES (1, 'Search the Bins for Cash', 2, '(WILL*1000/1)', 6, 0, 0, 1, 'You walk around looking for a bin to search for cash!', '<font color=green>You begin moving rubbish inside the bin,Then you find a burger wrapper in the bin with <b>${money}</b> scrunched inside!</font>', '<font color=brown>You begin moving rubbish inside the bin,You feel the bottom of the bin and realise their is nothing inside.</font>', '<font color=red>You begin moving rubbish inside the bin,Then you hear <b>OI!</b>, You run But you couldnt hide no where! \"Your Nicked!\"</font>', 2, 'Caught looting the bins', '0.5000'); Try this..

$gain+=rand(1,3)/rand(800,1000)*rand(800,1000)*(($ir['will']+20)/150); try raising the 150 at the end there, if im not mistaken that will lower gains

This is what I have and for some reason it just gives me the else message all the time, no matter if i have the items or not   include "globals.php"; $_GET['ID'] = abs((int) $_GET['ID']); //Food if(!$_GET['ID']) { print "Invalid use of file"; } else { $i=$db->query("SELECT * 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(mysql_num_rows($i) == 0) { print "Invalid item ID"; } $r=$db->fetch_row($i); if($r['itmid'] == 168 && $r['itmid'] == 169) { print "<br>You planted your Marijuana Seed and fertilized it with a Fish Head resulting in a Weed item<br><br><a href='inventory.php'>[back]</a>"; item_add($userid, 170, 1); item_remove($userid, 168, 1); item_remove($userid, 169, 1); $h->endpage(); } else { print "You do not have the ingredients needed to grow weed"; } $h->endpage(); }   It works fine if its just if($r['itmid'] == 168) so its only checking to see if its the itemid i click to make the item, not whether i have them both in my inventory.

I had this same error but i didnt add the SQL, after I did it worked just fine.

Overall nice mod, my users seem to enjoy it, though i changed a few things, users can use so many clicks per hour, i took out the daily limit, and upon completion of some give special items that can be combined to make special weapons, thanks to a combine mod i got from here. here is a small addon i made if anyone wants it, it is a guide to show users exactly what they're getting when they complete a course and the costs. Though as you see you'll have to change some things as its made for my game.   <?php include "globals.php"; $q=$db->query("SELECT * FROM schools ORDER BY crID ASC"); print "<h2>Mayhem Institute of Learning Class guide</h2>Find the knowledge you need for your studies, here you can find out what each class offers upon completion.<hr> <table width='100%' cellspacing='0'><tr><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;'>Course</th><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;'>Cost<br>Money/Energy</th><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;'>Stat Gains <br>Str/agil/Gua/Lab/IQ</th><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;'>Payout <br>Money/Points</th><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;'>Payout <br>Item</th><th align='center' bgcolor='#7D7764' style='border:1px solid #A39B83;' width='10%'>Studies Per Hour</th></tr>"; while($r=$db->fetch_row($q)) { $r['crSTR']=round($r['crSTR']); $r['crAGIL']=round($r['crAGIL']); $r['crGUARD']=round($r['crGUARD']); $r['crLABOUR']=round($r['crLABOUR']); $r['crIQ']=round($r['crIQ']); $r['crCOST']=money_formatter($r['crCOST']); $r['crCASHPRIZE']=money_formatter($r['crCASHPRIZE']); print "<tr><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crNAME']}</td><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crCOST']} / {$r['crENERGY']}</td><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crSTR']} / {$r['crAGIL']} / {$r['crGUARD']} / {$r['crLABOUR']} / {$r['crIQ']}</td><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crCASHPRIZE']} / {$r['crCRYSTALS']}</td><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crQTY']} {$r['crITEMNAME']}</td><td align='center' bgcolor='#A39B83' style='border:1px solid #7D7764;'>{$r['crPERCLICKS']}</td></tr>"; } print "</table>"; $h->endpage(); ?>   It's not much but then I'm not a qualified coder...yet :P

Ok, say you want to combine 2 different items to make one, lets say itemid's 10 and 12...getting it to do this is easy enough, but, the problem im having is combining items that arent there. Say i have itemid 10 but i dont have any itemid 12, and i click combine next to itemid 10 it will create the new item anyway, so how would you keep from making the new item unless you have BOTH the original items?

I'm having an issue, which is an error on this line: $db->query("INSERT INTO schoolhomework VALUES({$ir['userid']},{$ir['course']}, crtimes=crtimes+1)");   The error: QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO schoolhomework VALUES(1,4, crtimes=crtimes+1) It isnt counting lastcourse in that so i get an error, but when i add lastcourse to it, it takes the error away, but it inserts into schoolhomework 11 times so it credits the user 11 times when finishing a course lol. But only stats..... the money, crystals and items are crediting correctly. IF i were to leave it so that the error shows up upon completion, then it actually credits like it should, just have the error, but if i add in any value for lastcourse, it does the multiple crediting.

I'm not sure if its even possible, but what about making the tabs smaller when minimized? The reason being is I have 1 chat for global, 1 for trade, 1 for staff, and then gang chats, so a staff member that is in a gang will have 4 boxes. 4 boxes are too many for the screen, one of the 4 is cut off close to half of it.

I'm using this and it works ok, but for some reason its inserting the successful crime into the gang events twice.

Well, my codes are edited quite a bit, so in my case they are in a box in the middle of the index.php with a lot of other info, next to the persons level. But assuming you're using the base codes, it should be changed from this:   <b>Name:</b> $gn{$u} [{$ir['userid']}] $d<br /> <b>Money:</b> {$fm}<br /> <b>Level:</b> {$ir['level']}<br /> <b>Crystals:</b> {$ir['crystals']}<br /> [<a href='logout.php'>Emergency Logout</a>]   To something like this:   <b>Name:</b> $gn{$u} [{$ir['userid']}] $d<br /> <b>Money:</b> {$fm}<br /> <b>Level:</b> {$ir['level']}"; if($upgrade == "Y") { print"<a href=upgrade.php> [upgrade]</a>"; } print"<br /> <b>Crystals:</b> {$ir['crystals']}<br /> [<a href='logout.php'>Emergency Logout</a>]   Which is pretty simple really, you're just adding in the if statement but you have to make sure you close the print right before it and open a print after it. And if you don't replace the function check_level as stated in the first post, it surely wont show up because the Y won't be defined, it'll have no clue what the Y means. The only other thing is the upgrade.php file and it should work perfectly with those 3 things.

I'm curious Dave, how hard would it be to add an event sent to me when someone makes a purchase telling me what they bought? I know event_adds are pretty easy but I'm not fooling around with the files for this except for maybe a bit of styling :P

If you added it correctly it should work, I just added it just as its posted (minus a couple edits because my energy and brave are different) and it worked perfectly. And only shows when there is enough EXP to level.

Well, if no users could use or equip the items then yea maybe they weren't set correctly, but as I stated, only newer users couldn't use or equip them. also that's what I did, I got rid on the auto-quantifier that was causing the issue and coded it using the item_add function. Much simpler and less hassle.

It was Win 7 and Firefox, which is the same as I use and I haven't seen this problem, so it may have been something on the users end but I have no idea what that would be. He said it also only showed up on the index page, It started doing it this morning for a while, and worked fine after that all day, and then started doing it again a few minutes ago.   PHP is such a peculiar language sometimes, I think I narrowed down the problem but I'm not sure. Users were saying the font was too small and they had to squint to see it, so I added: font-size: 14px; under .chat_box .chat_contents { position: absolute; overflow-y: scroll; left: 6px; right: 6px; top: 40px; text-align: left; height: 270px; to change the font size, I'm not sure why or if that would cause the problem, but the person its happening to is a staff member so I had him login to the test server, which everything is still default. And it didn't do it there, I took the font bit out that I put in and he doesn't seem to be having the issue now..but it comes and goes so I'll know for sure later. Nope that isn't it, it did it again without the font bit. Unless it happens to more than just the 1 user I'm going to assume its on his end.

My users have the same issue chika, for some reason in IE they say it cuts off the bottom of the chat and cant see what they are trying to input, also some users are having trouble inputting anything at all, when they try it goes into the address bar in this type of format: /index.php?global_giveaways=hello+world# global_giveaways being the channel and hello world being the input.

Awesome I hope to see that play out. It's an excellent chat by the way, great customizable features and works very well, though I did have to get the tables out of the staff file and run them myself. I got an error for line 4 for chat_globals which is a settings query when I tried to run that file, of course it was probably something on my end, just thought I'd let you know just in case.

Maybe an open/close option in preferences for users. Also the ability to PM users would be a wonderful addition.

our order on Oxyden Store is complete. You have chosen the PayPal method. Your order will be sent very soon. Wo0t! I cant wait to see this in action.

There seems to be some sort of problem, i get this error on your site when trying to purchase. Please refer to logs: 1. PayPal response: 2. TIMESTAMP -> 2011-09-03T17:05:40Z 3. L_ERRORCODE0 -> 10736 4. L_SHORTMESSAGE0 -> Shipping Address Invalid City State Postal Code 5. L_LONGMESSAGE0 -> A match of the Shipping Address City, State, and Postal Code failed. 6. L_SEVERITYCODE0 -> Error Yet i double checked all my info and its all correct, I have never seen this error before and I use paypal everyday, as soon as I get it sorted I will purchase. EDIT: Ok I should have triple checked, i see the error in my postal code :P

Having bought and knowing how well your DP system works, and is constructed, you most definitely have me as a customer, and I'm purchasing this chat as we speak ;)

yes either way works, but still for some reason just the new players cant use items, its gives them an invalid ID error when trying use use or equip anything.

I still cannot seem to fix this, I want to be able to use the auto-quantifier, but when i do new players cannot use items, this is the code that I am using, which I got from here somewhere:   $used=array(); $q=mysql_query("SELECT * FROM inventory WHERE inv_userid=$userid"); while ( $r=mysql_fetch_array($q) ) { if ( ! in_array ( $r['inv_id'], $used ) ) { $currdel=array(); $used[] =$r['inv_id']; $currdel[]=$r['inv_id']; $amount=$r['inv_qty']; $q2=mysql_query("SELECT * FROM inventory WHERE inv_userid=$userid AND inv_itemid = {$r['inv_itemid']} AND inv_id != {$r['inv_id']}"); while ( $r2 = mysql_fetch_array($q2) ) { $used[]=$r2['inv_id']; $currdel[]=$r2['inv_id']; $amount+=$r2['inv_qty']; } mysql_query("DELETE FROM inventory WHERE inv_id IN(".implode(",",$currdel).")"); mysql_query("INSERT INTO inventory VALUES('', {$r['inv_itemid']}, $userid, $amount)"); } }

Does anyone have a gym formula that has a tighter gains range that will not allow higher statted players to gain much larger amounts while lower statted players gain a very small amount? I have tried and tried with my current formula but no matter what I do, I just cant get it tighter.

Correct me if I'm wrong but this looks an awful lot like Cronus's marriage mod, which I have, with a few visual alterations. And you forgot to change the partners "will" to "happy" also.

I can understand where you're coming from, sorta like when you leave Wal-Mart and they check your receipt, it is insulting and accusatory...BUT, there are a lot of cheaters out there that will use automated programs to surpass the honest players without deserving it, so if you ask me it is the lesser of two evils. The validation is actually to protect the honest players from falling behind someone that doesn't deserve to get where they are. And I have been looking for a validation just like this one for some time now with no luck, and just acquired one 2 days ago, though I don't think quite as good as this one, so I'm going to check it out. Thanks for posting it. ;)     You could possibly add a field to the user table for so many tries, it wouldnt be foolproof but it would slow down the chances of that happening if you set it to say 5 tries, if they fail 5 times, auto-fed for a day or 2, or revoke privileges to that page for a day, or an hour etc.