Lithium

Re: [V2]Faulty Stats   it seems to me you are not updating indeed... and if 10.000 is what you have, you should check your db fields as it seems you are using a DECIMAL field value.

Re: need help with crons   Well... if you update every single user on your db's at p.e. a situation like this... well you might be right, despite that, those were simply guidelines to make things going. and a mod that notifies the cron has been done... would do exactly the same...

Re: item market cap   Replying to a 2 year old post... and not looking at the recent post that was asking for help! good job! :) @chris3010, the easy way... is an extra field on users setting the limit and on item market, each time they use it decrease the field value up to 0, and hourly reset the field to its value via cron

Re: need help with crons better this way? while (something) { event_add(user,message,connection) }

Re: Hel with [v2] code error just remove function money_formatter($muny,$symb='$') { return $symb.number_format($muny); } and you're done

Re: need help with crons   really? event_add(user,message,connection) this is a "big ass insert"

Re: No Topic LOL, making drama to see people's reactions? well, IF you were really quitting, first you wouldn't be advertising it, second, asking for some moderator to erase your account when you can do it yourself? And wasn't last time you said you were quitting, definetly that time you were quitting? with this one makes two. when is the third one coming?

Re: 5 min cron alternative Correct me if i'm wrong... user has 20% energy 20% (let's say 100 out of a max of 500 energy) $energy = ($user['energy']) + ($e * $n); $e = 301 / 300 = 1 $n = 10 $energy = 100 + 1 * 10 $energy = 110 = 22% best would be $e = ($user['donatordays'] > 0) ? 5 : 10; $energy = $user['energy'] + ($user['maxenergy']/$e) This way you are giving 20% energy to donators and 10% to non donators. From here, you can play around with the values

Re: Have any mod ideas post here!   That has been done already, try searching around you might be able to find it

Re: What would be better to use? The queries are just an example, though i will need to run similar queries on tables with a few thousand entries. I made a few tests, and even second query is faster for lower amount of queries, as they grow... second one becomes painfully slow!

Re: What would be better to use? heh, that is why i was wondering... i got for the first... Affected rows: 2 (Query took 0.0010 sec) and for the second Affected rows: 2 (Query took 0.0006 sec)

When i ask better, mainly speed concern as both queries should do the exact same thing.   UPDATE users u LEFT JOIN userstats us ON u.userid = us.userid SET u.money = u.money + 1, u.crystals = u.crystals + 1, us.IQ = us.IQ + 1 WHERE u.userid = $userid   or this one...   UPDATE users, userstats SET users.money = users.money + 1, users.crystals = users.crystals +1, userstats.IQ = userstats.IQ + 1 WHERE users.userid = $userid AND userstats.userid = $userid

Re: Bandwidth Issues   I'm pretty much inclined on this one as well... i've seen traffic on places where there was use of refreshers that simply shoot up bandwidth usage. that combined with an heavy load of graphics on the site... it might just be the problem. Even this might be the problem, check your ftp accounts if there is no one using them either to transfer files or even fxp as it potentially can be also one of the many possible causes

Re: Nice Day Logout Though this might be a nice addition, only a very low percentage of players will see this... as usually people tend to close browser window/tab instead clicking the logout option ;)

Re: Some help with jobs.php error   i knew it was going to work... i gave you a starting point, try to fix up the rest ;)

Re: Some help with jobs.php error line 32 replace else for this and try from there elseif ($_GET['interview'])

Re: Some help with jobs.php error if elseif else

Re: How often are these games customized? As silly as to have a game set up on ancient greece and having slots or a roulette game? :D

Re: what can it be?   hmmm good point! they are INT indeed :|

Re: Crime help 'You head over to the beach and start searching.', 'You successfully find $34 ', 'You didnt find anything after 2 hours of searching and go home feeling disapointed.) you have a missing ' after "disapointed." That can be the error

Re: captcha or another method   That can be done basicly as the numbers validation, let's say that you have 30 images to be able to use on validation, pick random 9 to show up and from those one is valid to proceed. Interesting concept actually and quite different from the regular captcha's/verification

Re: Changing the SQL on items   As of this... you need to make the nedeed changes either on inventory, forwarding the user to the page you want, and/or on the itemuse page to fill your needs, as you can't use the regular itemuse for the needs you want.   On this one, TMan is right, and if you are using V2 codes, that's the best way to do it.

Re: what can it be? @POG1 thx for the heads up, yet using php floor() was not an option that was why i only refered to SQL functions. And ROUND(value, 0) is possible though it also errored if round value was 0. i managed to make a work around, not perfect but functional though :) UPDATE uBANK SET bMONEY = bMONEY + FLOOR( bINTEREST * bMONEY / 100 ) WHERE bMONEY > 100

Re: what can it be? Crazy-T those will also error... at least up to a certain point! I just found out that FLOOR() errors if its value is 0 :| As soon as i placed bMONEY over 100 it went fine. Also if anyone wants to know, the same thing happens with ROUND()

Re: Ask Staff [Mccodes V2]   They could, but this is more like a short approach to ingame ticketing. Well done once again! :)