userlist.php (correctly) shows huge number of pages

[Lowball]

I am interested in reducing the size of the output on userlist.php, where it shows all the available pages, and a link to each and every one. When you have several thousand players, this gets quite long.

Does anyone already have a mod for this?

[Lithium]

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

[Dayo]

Re: userlist.php (correctly) shows huge number of pages

yes there is a free mod for this

i think it id this one

http://criminalexistence.com/ceforums/i ... ic=17270.0

[Lithium]

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"

[Dayo]

Re: userlist.php (correctly) shows huge number of pages

soz i thort it showed users 100 at a time not all x amount

[(((TOLK)))]

Re: userlist.php (correctly) shows huge number of pages

I think this is right i couldn't be bothered testing it :lol:

 

$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100")

 

Change the "LIMIT $st,100" to something like "LIMIT $st,500"

hope this helps, hope it's right :lol:

[Lithium]

Re: userlist.php (correctly) shows huge number of pages

 

I think this is right i couldn't be bothered testing it :lol:

 

$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100")

 

Change the "LIMIT $st,100" to something like "LIMIT $st,500"

hope this helps, hope it's right :lol:

hmmm... what is the point to have a list showing 500 users per page? or even 100? slow down even more?

[(((TOLK)))]

Re: userlist.php (correctly) shows huge number of pages

 

I think this is right i couldn't be bothered testing it :lol:

 

$db->query("SELECT u.*,g.* FROM users u LEFT JOIN gangs g ON u.gang=g.gangID ORDER BY $by $ord LIMIT $st,100")

 

Change the "LIMIT $st,100" to something like "LIMIT $st,500"

hope this helps, hope it's right :lol:

hmmm... what is the point to have a list showing 500 users per page? or even 100? slow down even more?

No idea but if someone asks for help and you think you know the answer then i think you should give them the answer. Anyway the limit of 100 per page is the standard userlist.php

[Lithium]

Re: userlist.php (correctly) shows huge number of pages

 

No idea but if someone asks for help and you think you know the answer then i think you should give them the answer. Anyway the limit of 100 per page is the standard userlist.php

Quite wrong, assuming people that ask for help can think (and can code) what you can and SHOULD do is to point them in the right direction. Giving the answer is NOT a way to help. Besides that, my 2nd post on this thread, gives an answer that can be worked to suit the needs according my first post. ;)

[(((TOLK)))]

Re: userlist.php (correctly) shows huge number of pages

Different people learn in different ways, and different people give advice in different ways, my opinion is that different people can do different things with different kinds of advice given. It's up to the person who asked for the advice to use the advice in their own way. When someone gives me the answer to something i look at the solution given and then learn from it  :wink:  SUCK ON THAT!!!! lol :lol:

[Lowball]

Re: userlist.php (correctly) shows huge number of pages

Actually what I'm looking for is more or less an output like:

|< 1 2 3 4 5 6 7 8 9 10 50 100 135 >|

Starting with a "Jump to start", then giving all the pages near the current page, then skipping several blocks of pages, and ending with a "Skip to end"

I can write it (or something like it, depending on how I'd like to go) but if it's already done, or someone has a paid mod, I'd prefer to save my time for other things.

[DELETE ME NOW!]

Re: userlist.php (correctly) shows huge number of pages

I have something simular like it somewhere i done a while back on my pc somewhere

[Dave]

Re: userlist.php (correctly) shows huge number of pages

I have something very simular on www.deadlyghetto.com (Well did untill i sold it) i might be able to sort you out a copy cause i remember it was preety simple :).

[Lowball]

Re: userlist.php (correctly) shows huge number of pages

I just decided to take the time to code it (something I could not decide how to start, or how I wanted it done.) I'd pass it along, but I don't know that my files are anything like the originals any longer, and I'd hate to have to support it if it didn't integrate right.