Lithium

Re: Print once? background-image: url('background.gif'); background-repeat: no-repeat

Re: [mccodes v2] Free Login   That and previous posts, assuming he used Photoshop... I just ask... How many image editors are out there?

Re: Count Users Clicks   Well if you can count mouse clicks using sessions only... go for it. Just my .02

Re: Big thanks to Killah @ Iso This one fits better overall :D

Re: Count Users Clicks i know this is quite an old post, and seems killah was on the early begining, and as it has been said... not a very good option! but you can effectivelly grab the user "clicks" with javascript mouse events... so killah, it is time to update this post as i can pretty much guess that you are more comfortable nowadays to make that work with javascript (as long as users have it active) :)

Re: Print once? background: url(background.gif) no-repeat

Re: PHPMYADMIN query lol the problem is that most of people around uses SQL statements as they have seen it (limited to 4 or 5). So why bother using more? ;) you could also use it as a "regular query format" as you call it! UPDATE users SET crystals=1 WHERE crystals>4000 AND crystals<6050 though using BETWEEN is faster ;)

Re: Event add problem by any chance all other events work fine? Because that seems a problem with the event_add() function

Re: PHPMYADMIN query UPDATE users SET crystals=1 WHERE crystals BETWEEN 4000 AND 6050

Re: McCodes v2.0.2 attack   pft! who needs details when you got... a pair of eyes? :P

Re: McCodes v2.0.2 attack not only attacktake.php (attack*.php), but also attack.php (ratios) and global_func.php concerning the exp_needed. as they are all "linked".

Re: Item display Just don't forget to consider the "idea" i gave you :roll:

Re: Item display "themed" items or just a big dump on all?

Re: MyIsam or InnoDB or ? If you are looking for speed... definetly.. MyISAM, reliability... InnoDB. Maybe you should consider reading around as opinions differ on the usage on one or another. http://dev.mysql.com/tech-resources/articles/storage-engine/part_3.html Just a small comparision on both.

Re: All in one Cron I don't see the point on posting something that ought to be unique for each game, i myself am currently doing such a thing, and i even doubt that it would work on any other setup...

Re: Member-list   as of "intervals" sql does have specific calls for those "BETWEEN" or even interval() just in case you need to use them ;)

Re: Inventry Help! i suggest that you start that file right from the begining again, Also, try to separate HTML from PHP, its more readable and its faster.

Re: Inventry Help! <td align='center' valign='middle'><div align='center'>Unequip Item</div></td> "; }   this line is closing... nothing! it seems to me you have the code messed up as from the while, as you are closing it almost immediat. It might not be that, but the line i pasted above is faulty for sure, maybe while dependent but out of it! also,   <td><div align='left'>Item Name:</div></td> <td align='center' valign='middle'><div align='center'>"; if($equip[$ir['equip_primary']]['itmid']) { print $equip[$ir['equip_primary']]['itmname']."</div></td> <td align='center' valign='middle'><div align='center'>"; if($equip[$ir['equip_secondary']]['itmid']) { print $equip[$ir['equip_secondary']]['itmname']."</div></td> <td align='center' valign='middle'><div align='center'>"; if($equip[$ir['equip_armor']]['itmid']) { print $equip[$ir['equip_armor']]['itmname']."</div></td>   You are not closing if's here.

Re: Weird Situation   One of those things that makes me angry with myself, lol !!! a few hours looking at it, a couple of persons also looked, no one noticed the bad math! out of the box, a pair of fresh eyes note the error on the spot!

Re: Weird Situation Seems i messed up calculating the seconds, though no one noticed it too. Thanks everyone that somehow tried to give an hand to it. SELECT userid FROM users WHERE (unix_timestamp() - laston) <= 86400*45 86400 = total seconds in a day 45 = days you want to get If you want to show active users for a certain period only, just replace the 1st query on userlist for a query like that and you're done! Once again thx :)

Re: Weird Situation An update... laston value = 1229278774 SELECT userid FROM users WHERE laston > unix_timestamp()-(1440*24*amount_of_days) AND userid=XXX Tends to NOT showing any results, up to 81 days, at 82 it gives a result as expected... SELECT laston, unix_timestamp( ) - (1440 *24 *amount_of_days) FROM users WHERE userid=XXX also shows the correct timestamped values!

Re: Weird Situation @POG using select * is not an option ;) as you should call things by their names as best practices say, also, if you read my post, i have no trouble making users to show up, only 1 specific user that is within the range for the SELECT, is not showing, not even placing the SELECT directly on the DB., but thx for the effort though :)

Re: Weird Situation   Not an NPC and used to be an active player. :|

Re: Weird Situation   That would only show users that were last online on the last 5 minutes ;)

A friend asked me for a little change on the users online to show only users active since a certain amount of days... so far so good, though there is 1 user that simply doesn't show. Not even with direct input of the query on phpmyadmin. Let's say the code is as follows SELECT userid FROM users WHERE laston>unix_timestamp()-(1440*24*45) Shows the list on the users active within 45days or less... but 1 player, inactive for 32 days, simply doesn't show! I am pointing to an account problem, but as i have no access to the phpadmin, i'm only guessing. Anyone as any idea on what can cause the problem?