Page that will display a user's pets (non layout destroying update)

[kisazeky]

This script will neatly display a given user's pets, in rows of 5, up to 100.

Everybody's profile link will be:

profile.php?owner=username

See an example here:
http://digiadopt.l4rge.com/profile.php?owner=kisazeky

[zhiichiro]

we have that already yey!!

[mattalien]

It destroys my layout though.....

http://www.pokeframesadoptionstation.comuf.com/profile.php?owner=Mattalien

[rosepose]

How would one change the number of pets per row?

[kisazeky]

Rose find this line:

PHP Code:

$query = "SELECT * FROM owned_adoptables WHERE owner = '$owner' ORDER BY uid DESC LIMIT 0,5 "; 


Change the 5 to the number of pets you'd like to display. But that means, you have to change every $query to reflect that new number. For example if you want 8, you'd have to change the next $query from

PHP Code:

$query = "SELECT * FROM owned_adoptables WHERE owner = '$owner' ORDER BY uid DESC LIMIT 5,5"; 


to

PHP Code:

$query = "SELECT * FROM owned_adoptables WHERE owner = '$owner' ORDER BY uid DESC LIMIT 8,8"; 


and then...

PHP Code:

$query = "SELECT * FROM owned_adoptables WHERE owner = '$owner' ORDER BY uid DESC LIMIT 10,5"; 


to

PHP Code:

$query = "SELECT * FROM owned_adoptables WHERE owner = '$owner' ORDER BY uid DESC LIMIT 16,8"; 


and so on.

Just find next $query and replace the values.

[Killgore]

Slight issue: Some of my members have spaces in their username, and it refuses to even acknowledge that the user exists. Is there a way to fix this, or am i over-looking something?

[Seapyramid]

Originally Posted by Killgore

Slight issue: Some of my members have spaces in their username, and it refuses to even acknowledge that the user exists. Is there a way to fix this, or am i over-looking something?

I had the same issue but was able to fix the problem

if you replace line 77 with

$owner = preg_replace("/[^a-zA-Z0-9\x20]/", "", $owner);

it will accept the space but still disallow other chara for security

Sea

[Ashje]

Awesome, Thanks =). But how do I make a table like zhiichiro on the users page, with the ID, Username and Currency shown?

[kisazeky]

Like this. *download the file I included*

Note for the pets link you also need the profile.php, which I also inclded.

[Hall of Famer]

This can be easily remade into a pokedex system. XD