Useless. Before you did this i just translated the Button to "Suche" (means Search in German).

Why don?t you just rename the Button to "Search" ...:confused:

No i have to translate Search (Suche) and Submit ..(Los / Go) to make a sense in translating this.

Just a Hint ...

Much better! :D

Thanks Abe!

Thanks Abe. Version 2.5 search works for me now at http://www.cywire.com/member-albums.html. Took prefix I had added out:

------------------------------------------------------

$albumcount = $db->query_first("
SELECT COUNT(*) AS total
FROM " . TABLE_PREFIX . "album AS album
WHERE state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
$searchwhere

------------------------------------------------------


// fetch data and prepare data
$albums = $db->query_read("
SELECT album.*,
picture.pictureid, picture.extension, picture.idhash,
picture.thumbnail_dateline, picture.thumbnail_width, picture.thumbnail_height,
user.*
FROM " . TABLE_PREFIX . "album AS album
LEFT JOIN " . TABLE_PREFIX . "picture AS picture ON (album.coverpictureid = picture.pictureid AND picture.thumbnail_filesize > 0)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON (album.userid = user.userid)
WHERE album.state IN ('" . implode("', '", $state) . "')
AND album.visible > 0
$searchwhere
ORDER BY $sortname $sortorder
LIMIT $start, $perpage
");


------------------------------------------------------

I will be upgrading my version soon but was wondering....

Is there any way to show only one album per user (like maybe the last album created)?
It would be nice since vbulletin doesn't have a way to limit the amount of Albums the users can have.

I think you can limit the amount of albums in your AdminCP.?

Upgraded and works fine. Thank you :)

Thanks Abe1 for the search and the update!

Though i was more looking for a "forced" search. When users will go to all_albums i ll need to have them only look up for albums with specific name. Is that possible? (by editing the php probably?)

Very nice mod.....

dont install this mod then. if you want to see just one user at time, this is how vb has it.

No no, this mod is very good.

I don't want a user at a time. I want to have my users create album with a specific name and when they click on all_albums page to search in the db only for albums called "test" for example.

Thanks :)

Edit: Actually i want this: "http://xxx/all_albums.php?s=&sort=lastpicturedate&order=desc& page=1&query=Test" but i don't want users to be able to change the attributes.