[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]

Hi, I'm really whit all that.

Where i put the code. I really dont know what to do whit that code in the first post of that tread.

I dont find the line whit the SELECT thing in any templates. If i search at the right place. Anyone can help me a bit Pls.

you put it in the showthread.php file

Thx a lot Goldfinger, i will try it this morning.

not a problem thats what the forums are for.

Thx you very much guy