Ed - help with Location, Interests Hack

Ed, would it be too much to ask to give me this hack for 1.1.4? I'd really appreciate it! The first part of the code no longer exists

http://vbulletin.com/forum/showthread.php?threadid=1776

in showthread.php.

find:

 if ($userid!=0) {
      $userinfo=$DB_site->query_first("SELECT userid,email,username,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");

replace with:

 if ($userid!=0) {
      $userinfo=$DB_site->query_first("SELECT userid,email,username,biography,usertitle,signature,showemail,homepage,icq,aim,yahoo,joindate,posts FROM user WHERE userid=$userid");
    $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"; }

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.

Yeah!!

Is there any way that you can simplify that for me?
You see I am a new licensed user and before my board/database gets populated...

I would like to add a place from City, State, Zip
in the database.

On the page the user signs up appropriate code would be needed.

Then under their name in a post.. I would like to display their city, state.

Now when it's time to send a mass email.. I can accurately send messages.

Is that too much to ask ? :-(

Thanks for your reply,

JackG

Works on 1.1.5 in case anyone is interested!

Originally posted by JackG
Is there any way that you can simplify that for me?
You see I am a new licensed user and before my board/database gets populated...

I would like to add a place from City, State, Zip
in the database.

On the page the user signs up appropriate code would be needed.

Then under their name in a post.. I would like to display their city, state.

Now when it's time to send a mass email.. I can accurately send messages.

Is that too much to ask ? :-(

Thanks for your reply,

JackG

This does not add any extra fields to the user profile. Instead it parses the existing Biography field. If you don't know how to alter your tables and work in PHP, it will be safer to wait until 2.0 where you can create as many fields as you want.