Lithium

Re: userlist.php (correctly) shows huge number of pages   hmmm... what is the point to have a list showing 500 users per page? or even 100? slow down even more?

Re: userlist.php (correctly) shows huge number of pages @Dayo: that mod only colors the != user levels And you can use something along these lines...   $query = "SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID WHERE laston BETWEEN unix_timestamp()-(86400*30) AND unix_timestamp() ORDER BY userid ASC LIMIT $st,25"

Re: Setting a max sig size? you can make it, forcing the sig file to be or if you host the user files (which i doubt) you can set a filesize limit and a lock as the first one. Also, forcing the width and height, it makes easier to work with the layout without it getting all screwed up for different file widths and heights

Re: userlist.php (correctly) shows huge number of pages you can always limit the display to show only active users within a certain range of time... http://dev.mysql.com/doc/refman/5.1/en/ ... or_between

Re: viewuser taking ages to load? @ Karlos, you got some point there... but SteveDave says _only_ his account does that, so it might be something else other than the sql ;) @Steve one thing you could do, place your profile as default as you can, no images, no nothing... from there start placing things one at a time and check where it goes down again.

Re: [mccode v2] Crystalbank Mod   Hmmm, seems you should be quite yourself, 10 minutes attempting to make the MTG so called version to work (using your own words), when MTG or a few users around would prolly recode it entirely in less than that... And even your "fix" is even more buggy than actually MTG's one.   echo ( this would error right on the parenthesis, and removing the echo's... on that way of coding... would simply error it all. :) Be sure of what you say first then trash after. Trashing a user WITHOUT knowing what you are doing, it only states how dumb you are. (and yes you can flame after this) :) @MTG i don't know why you have even bothered to reply ;)

Re: [V2] How to make NPC stats depend on players stats I don't know if what you are looking for is an average stat for "combat", if that is what you are looking for... You can make it using a few different ways... (if someone remembers, or has any idea... contribute) player stats * level + weapon - armor = npc stats * npc level Where npc stats could be some random value, depending on the player stats (player stats * rand(1,1000)) Or something along these lines

Re: Injection attempt.   Wrong! "Should never be able" != Can't

Re: Need help on a problem keeping npc's out of hospital is good... though, keeping them with full health all the time is not good as people can keep on hitting them to level up, in no time you will have power levelling raising up as hell if you keep npc's with full health. Also, the best way to keep npc's out of hospital, is to remove the hospital time out from the attack files... something along these lines...   if ($r['user_level'] != 0) { $db->query(" UPDATE users SET hp=1, hospital=$hosptime, hospreason='Left by <a href=\'viewuser.php?u={$userid}\'>{$ir['username']}</a>' WHERE userid={$r['userid']} "); event_add($r['userid'],"[url='viewuser.php?u=$userid']{$ir['username']}[/url] attacked you and left you lying outside the hospital."); } if ($r['user_level'] = 0) { $db->query("UPDATE users SET hp=1 WHERE userid={$r['userid']}"); }

Re: [McCodes V2] Streets Mod   Funny, as people like you, don't thought of that first, making your statement including yourself on that "half brain people". Also you got a point when you say "because its full of crap like this forum post" (as in your post). And finally, and quoting Dazza "Im glad you dont come on here often, but the thing is, you do come back so it must have some things of interest", meaning that all these retards seem to be less retards than probably you as they come with Modifications every single day.

Re: [any version] Removal of 1 minute crons   timestamped actions can be an option, yet it will increase the load more than crons, unless you close open connections, even though the load is higher than crons. One other option... are the mysql events :P

Re: Marriage Proposal @ Luke that was the point indeed, the wrong page... As of this it is fixed already :)

Re: MySQL Configuration   hehe and a lot of them cached i suppose? ;)

Re: Marriage Proposal All the answers should work, though you might be placing it on the wrong place

Re: Exp needed per Level lol still not convinced! need to get home (in 8 days) to see!!1 but see what i am thinking... $ir['exp_needed']=(int) (($ir['level']+1)*($ir['level']+1)*($ir['level']+1)*3.2); let's say that $ir['exp_needed']=(int) ((1+1)*(1+1)*(1+1)*3.2); $ir['exp_needed']= 25.6; that would be how much experience i would need to reach level 2 and i currently have $ir['exp'] = 15 So to show to the user that should be... $show_user = $ir['exp_needed']-$ir['exp']; and display it then like... print 'You need more '.$show_user.' Experience to reach level '.$ir['level']+1; Am i still wrong? ;) hehe

Re: Exp needed per Level   True enough but if you want to print out that info to the user... :P

Re: Exp needed per Level   Correct and apologize me if i am wrong... doesn't $ir['exp_needed'] show you the amount of experience you need to have to go to next level? If so, if you want to show HOW MUCH you need to reach next level you need to subtract the $ir['exp'] you already have, in order to know how much more you need right? ;)

Re: Levels hmmm a level 5 can beat a level 2000? that is not good! Also, i think there's a "level upgrade mod" floating around these forums. If i remember correctly, it simply makes you jump to the correct level, according your experience.

Re: Exp needed per Level     echo $ir['exp_needed'];   Minor correction to MTG ;)   $ir['exp_needed'] - $ir['exp']

Re: Maximum amt   hmmm, they are pretty low indeed... maybe you need a bigint^15... Tht ought to be enough no? :|

Re: Number Problem problem on DB fields perhaps? http://dev.mysql.com/doc/refman/5.0/en/ ... types.html

Re: [mccodes] Pay To Click Addon [$20]   Not quite, if you don't place ads all over, and well, make donators not seeing them... probably this is just a way for people to donate more, just for not seeing the ads :)

Re: Help with Conversion...   http://criminalexistence.com/ceforums/i ... ic=16666.0

Re: Maximum amt   http://dev.mysql.com/doc/refman/5.0/en/ ... types.html

Re: Crons, Timestamp or none?   Same here, though not with mysql, nor game related ;)