[RELEASE] Location, Interests, etc. in post!

Well, it's so simple, it's not even a hack in my book

I'm only giving example code for Location and Interests, but the rest are similar.

1.1.4 compliant

Find:
-----------
$posts=$DB_site->query("SELECT post.dateline as dateline,post.postid as postid,post.pagetext as pagetext,
                               post.allowsmilie as allowsmilie,post.signature AS showsignature,post.title as title,
                               post.ipaddress as ipaddress,post.iconid as iconid,post.username as fakename,
                               post.userid as userid, 
                               user.userid as userid,user.email as email,user.username as username,
                               user.usertitle as usertitle,user.signature as signature,user.showemail as showemail,
                               user.homepage as homepage,user.icq as icq,user.aim as aim,user.yahoo as yahoo,
                               user.joindate as joindate,user.posts as posts 
                        FROM post 
                        LEFT JOIN user ON (user.userid = post.userid) 
                        WHERE post.threadid=$threadid AND visible=1 
                        ORDER BY dateline $postorder
                        LIMIT $limitlower,$perpage");
-----------

Add to the end of the SELECT portion:
-----------
,user.biography as biography
-----------

Find:
-----------
$userinfo=$post;
-----------

Under it, add:
------------
    $bio = split("\n", trim($userinfo[biography]));
    $location = "";
    $interests = "";
    while(list($key,$val)=each($bio)) {
    	if (strlen(strpos($val, 'Location:'))) {
    		$location = eregi_replace("^Location:([^\\[]*)", "\\1", "$val");
    	} elseif (strlen(strpos($val, 'Interests:'))) {
    		$interests = eregi_replace("^Interests:([^\\[]*)", "\\1", "$val");
    	}
    }
    if ($location) { $location = "Location: $location"; }
    if ($interests) { $interests = "Interests: $interests"; }
------------

Then reference $location and/or $interests in the postbit template.

Now, just reference $location and $interests in the postbit template.

Enjoy!

[Edited by Ed Sullivan on 12-04-2000 at 02:08 PM]

Thank you, thank you, thank you!!!!!!

This works perfectly! It was so important for me to have the interest & location fields on the posts, and now they are there!

thanks great work.. i added it to my forum and it works great

i have a problem in this thread is an example

http://www.animeboards.net/forums/sh...p?threadid=565

my location display is repeated as the thread goes down ?

it seems that if a member does not have a location field in their profile the previous posts' user's location is added ?

ahh - oops. Simple fix.

change:
if ($location) { $location = "Location: $location"; }
if ($interests) { $interests = "Interests: $interests"; }

to

if ($location) { $location = "Location: $location"; } else { $location = ""; }
if ($interests) { $interests = "Interests: $interests"; } else { $interests = ""; }

thanks ed, but it didn't work ?

in this thread
http://www.animeboards.net/forums/sh...p?threadid=539

user called Hiyoku

keeps on displaying the previous poster's location with an added 'Location:' in it

i.e.

Hiyoku
Member

Registered: Jul 2000
Location: Location: USA
Posts: 77

-------

Hiyoku
Member

Registered: Jul 2000
Location: Location: Brisbane, Australia
Posts: 77

from this thread
http://www.animeboards.net/forums/sh...p?threadid=539 ?

oh yeah the exact same thing occurs with the interest info

where a user does not have an interest in their profile, they take the previous poster's interests

i.e. in the last post in

http://www.animeboards.net/forums/sh...p?threadid=571


sorry not last post but further up

[Edited by eva2000 on 07-15-2000 at 10:50 AM]

Doh! Stupid me. Fixed the glitches in the original code.

Just add this code above the while(... line:

$location = "";
$interests = "";

but it's already there ?

whoops... sorry i didn't realise you edited and corrected the original post



[Edited by eva2000 on 07-15-2000 at 04:08 PM]