Learn Japanese with JapanesePod101.com

View topic - searching posts by a certain member

searching posts by a certain member

Spotted any errors or found anything that doesn't work?

RE: searching posts by a certain member

Postby zengargoyle » Fri 09.22.2006 10:57 pm

when i wrote the superview.php page it was my intention to provide a 'my posts' and 'posts by user' function. i don't remember the details, but there was some little PHP-Fusion implementation detail that made it really hard to do. i may eventually go back and try again, but there are so many other things on the 'todo list'.....

a lot of the difficulty is the trade-off required for ease of use. it's pretty trivial to whip up a simple page that shows all posts by a user, but much more involved to do things like 20 posts per page or checking user name validity or coming up with error messages for invalid inputs or keeping everything themed so the pages look like other TJP pages or making sure to only give pages that a user is allowed to view... it's the little details and the absolute horror of PHP-Fusion that make what should be simple requests into hours and hours and hours of work. :(
User avatar
zengargoyle
 
Posts: 1200
Joined: Sun 05.29.2005 10:16 pm

RE: searching posts by a certain member

Postby zengargoyle » Tue 09.26.2006 12:49 am

you can now use the Search page to search for posts by a certain UserId. the easiest way to go about this is to Search Members for the username, move your mouse pointer over the matching name, and look at the link. for example: search Members for 'tanuki', in the results move your mouse over 'tanuki' and you'll see the link in your status bar: "http://www.thejapanesepage.com/profile.php?lookup=6010", 'tanuki's UserId is "6010". now you can enter '6010' in the Search box, select By UserId and find the posts by tanuki.

sorry it's a bit rough, the MySQL version on the server doesn't allow sub-selects :(
User avatar
zengargoyle
 
Posts: 1200
Joined: Sun 05.29.2005 10:16 pm

RE: searching posts by a certain member

Postby tanuki » Tue 09.26.2006 12:50 pm

That's great!!! Thanks a lot, zen-san, I can imagine that was a lot of work.
僕の下手な日本語を直してください。
User avatar
tanuki
 
Posts: 2302
Joined: Sun 09.25.2005 9:00 pm
Location: South America

RE: searching posts by a certain member

Postby Infidel » Tue 09.26.2006 1:44 pm

Thank you Zen.
なるほど。
さっぱりわからん。
User avatar
Infidel
 
Posts: 3093
Joined: Sun 10.09.2005 1:12 am
Native language: 英語

RE: searching posts by a certain member

Postby clay » Tue 09.26.2006 1:52 pm

Very neat. Maybe we should add Coco's number (2612) on the page for quick reference ;)
User avatar
clay
Site Admin
 
Posts: 2809
Joined: Fri 01.21.2005 9:39 am
Location: Florida

RE: searching posts by a certain member

Postby tanuki » Tue 09.26.2006 2:15 pm

Police.............110
Fire Dept. ......119
Coco..............2612
:D
僕の下手な日本語を直してください。
User avatar
tanuki
 
Posts: 2302
Joined: Sun 09.25.2005 9:00 pm
Location: South America

RE: searching posts by a certain member

Postby coco » Wed 09.27.2006 7:17 am

Tanukiさん。110番(ひゃくとお・ばん)と119番をよくご存知で。これでいつ日本に来ても緊急時の対応はバッチリですね。 :D

Tanukiさんが質問してくださったおかげで、便利な機狽ェ増えました。ありがとう!
Zenさん。ご多忙のところ、いつもお骨折り頂きありがとうございます。m(_)m
Last edited by coco on Wed 09.27.2006 7:22 am, edited 1 time in total.
coco
 
Posts: 3061
Joined: Mon 05.30.2005 12:43 am
Location: 東京都
Native language: 日本語(Japanese)

Previous

Return to Problems

Who is online

Users browsing this forum: No registered users and 5 guests