Link to member profile

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