Link to member profile

[Diana13]

Hi,

I want to modify the link of members from the home page (those with last posts) from http://www.example.com/forum/member....tposter&t=1652 to their profiles, eg www.example.com/forum/member.php?u=256

I've tried to modify in forumhome_lastpostby, but it didn't work, because I don't have $userinfo[userid] defined there.

[Lynne]

You can't do that easily. When someone clicks on the link, the forumid is passed and the lastposter *at that moment* is looked up and you are sent to their member.php page. The last poster can change between when a page is spit out and when a user clicks on that link.

[Diana13]

Thanks Lynne. After I've read your post, I've made the following changes (I'm not a programmer so please don't laugh)

I've replaced in forumhome_lastpostby:

PHP Code:

<phrase 1="member.php?$session[sessionurl]find=lastposter&amp;f=$lastpostinfo[forumid]" 2="$lastpostinfo[lastposter]">$vbphrase[by_x]</phrase> 


width

PHP Code:

<if condition="$lastpostinfo[lastposter]">{
$sql = "SELECT * FROM " . TABLE_PREFIX . " user WHERE username = '$lastpostinfo[lastposter]'";
$result = mysql_query($sql) or die(mysql_error()); 
$userinfo = mysql_fetch_array($result);}</if>

by <a href="member.php?$session[sessionurl]u=$userinfo[userid]">$lastpostinfo[lastposter]</a> 


But something is wrong, because instead of "by username_x" it displays the code between { and }.

Can somebody enlight me?

--------------- Added [DATE]1247658203[/DATE] at [TIME]1247658203[/TIME] ---------------

If nobody have a clue about the stuff above, maybe you can help me to solve another issue; in this case I don't need to solve the problem in the previous post.

I wanted different meta description and keywords for members. So I've made the following changes:

I've made a new plugin in global_start hook:

PHP Code:

if (THIS_SCRIPT == 'member'){
$sql = "SELECT * FROM " . TABLE_PREFIX . " user WHERE userid = " . $_REQUEST[u];
$result = mysql_query($sql) or die(mysql_error()); 
$userinfo = mysql_fetch_array($result);} 


I've added in headinclude:

PHP Code:

<if condition="THIS_SCRIPT == 'member'">
<meta name="keywords" content="$userinfo[username], $vboptions[keywords]" />
<meta name="description" content="$userinfo[username] is $userinfo[usertitle] in Forum" /> 


So now, when I call www.example.com/forum/member.php?u=234, the user profile displays right and have different description and keywords than other members.

But when I call, for example:
http://www.example/forum/member.php?...astposter&f=43

I have this message in a blank page:
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"

I thought that if I choose another hook for my plugin, it works. But which hook? I've tried different hooks but none of them was right.

Any clue on this?

--------------- Added [DATE]1247658982[/DATE] at [TIME]1247658982[/TIME] ---------------

Ok, while I wrote the above issue, I had an enlightened moment and I've solved the problem. I've changed the if statement:

PHP Code:

if (THIS_SCRIPT == 'member' && isset($_REQUEST[u])) 


[Lynne]

I don't know why you should have to do any query. If you go to view Member X's member.php page, you should be able to use the variable $userinfo[username] to get Member X's username without doing any query. That variable should already be available for use.

[Gio~Logist]

They already have username, no? So why not do member.php?username=$lastpostinfo[lastposter]

Or if not, try lastposterid or lastpostuserid

[Diana13]

@Lynne: I was able to use $userinfo[userid] in <title>, but in headinclude, for meta description and keywords, userinfo isn't available.

@Gio~Logist: the member's page is called with: member.php?u=$userinfo[userid]
I didn't find in any table the fields lastposterid or lastpostuserid. It would have been easier if there had been.

[Lynne]

Originally Posted by Diana13

@Gio~Logist: the member's page is called with: member.php?u=$userinfo[userid]
I didn't find in any table the fields lastposterid or lastpostuserid. It would have been easier if there had been.

Gio is correct in that you can also call the member page using the username - member.php?username=xxxx so you may want to try his method.

[Diana13]

Yes, it works. I can call a member like you said, but I have to do another changes to have username in description an keywords, so I'll leave my version.
Thank you all for your answers.