WebWoW

stady234 · 2010-01-27 20:49:29

Was hoping someone could help with making a working mod to the "account list".

(admincp3)

would like to make a working Pagination, but every time i try.. it either doesn't link another page, or kills the page entirely... and the page numbers don't end up where they should...

clarkeez · 2010-01-28 15:12:20

I don't fully understand what you are trying to acheive

stady234 · 2010-01-28 20:58:04

I would like to have the "30 Results for '' (displaying 30 max)"
in the "User Manager" page.. have "pagination" (page numbers) for the 31+....

clarkeez · 2010-01-29 08:40:26

There really isnt any need, just search for the players.

Phenom · 2010-01-29 09:48:17

It could be very usefull...

maverfax · 2010-01-29 16:27:19

Here's a quick go at it:

(I HAVEN'T TESTED THIS, SO THERE'S PROBABLY A MISTAKE SOMEWHERE IN HERE)

Code:

<?php
$host = '127.0.0.1';   #MySQL Server host
$user = 'root';          #MySQL Server Username
$pass = '';               #MySQL Server Password
$db = 'Site';             #MySQL Database for Website

$page = '0';            #Default Page
$results = '15';        #Default Result Amounts
$more = false;        #Default show next page (leave false)

if(isset($_GET['page']))
  $page = (is_numeric($_GET['page'])) ? $_GET['page'] : '0';

mysql_connect($host, $user, $pass);
mysql_select_db($db);

#Get News
$query = mysql_query("SELECT title, news, author FROM news ORDER BY id DESC LIMIT $page, $results");

if(mysql_num_rows($query) > $results) {
  $total_pages = mysql_num_rows($query) / $results;
  $more = true;
}

while($row = mysql_fetch_array($query)) {
  echo "Title: <b>{$row['title']}</b> - Posted by {$row['author']}
             <br>
          {$row['news']}";
}
echo "Showing {$results} posts per page, {$total_pages} total pages. <a href='?page={$next}'>Next -></a>";
if($more) {
  $next = $page + $results;
  echo "<a href='?page={$next}'>Next -></a>";
?>

Just change this to work with your site, and you're done!

Post edited by maverfax (2010-01-29 16:31:03)

stady234 · 2010-01-29 21:35:16

test code didn't work.. but i wanted a mod of the admincp3 SPECIFICALLY..

not other code to put somewhere else... nice try anyway..

BTW this was the original line in the admincp3 that got me thinking....

Code:

 
 //print "<br>".paginate($b,$start,'quest.php?name=admincp3');

Post edited by stady234 (2010-01-29 21:37:15)

Axe · 2010-01-30 03:36:20

may i remind there is already function to paginate included with script check out functions.php

stady234 · 2010-01-30 07:08:39

if i uncomment your original code i get this:

===

It looks like it is based on your entry in the "function.php".. either way.. how do i implement your function??

Cause when you click on 1,2..30... nothing happens... i have 67 accounts currently.. so page 2 should come up with names, but it gives me a blank screen...

stady234 · 2010-02-05 07:31:39

any help??

WebWoW

#1 2010-01-27 20:49:29

Account Pagination...

#2 2010-01-28 15:12:20

Re: Account Pagination...

#3 2010-01-28 20:58:04

Re: Account Pagination...

#4 2010-01-29 08:40:26

Re: Account Pagination...

#5 2010-01-29 09:48:17

Re: Account Pagination...

#6 2010-01-29 16:27:19

Re: Account Pagination...

Code:

#7 2010-01-29 21:35:16

Re: Account Pagination...

Code:

#8 2010-01-30 03:36:20

Re: Account Pagination...

#9 2010-01-30 07:08:39

Re: Account Pagination...

#10 2010-02-05 07:31:39

Re: Account Pagination...

Board footer