I installed everything and it works BUT comments don't show vb user

[thomor25]

its giving me an error saying
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /gallery/forums/vb3.php on line 143

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /gallery/forums/vb3.php on line 143

but its able to grab the users names and gallerys fine its only on the comments section. All that hsows up is their ip address for me but not the user info that is usually in the postbit like if you would post in a regular forum.

[Chuck S]

Hello

Your VB location profile field has been deleted from your vb mysql tables and we code our program to a default vb install and thus your issue

You can do a couple things here. You can add field2 back to the vbulletin mysql userfield table or you can change our field2 call in the get_profiledata function in our vb3.php file to the name of the new field you made to house the user location.

[thomor25]

this section of teh code does not deal with field 2 it desls with the user info nothing about fields

if( $vboptions['avatarenabled'] ) {
list( $cuser, $chomepage, $ctitle, $cposts, $regdate, $clocation, $conline, $csig, $avpath, $hasav, $avrev ) = mysql_fetch_row($results);
}
else {
list( $cuser, $chomepage, $ctitle, $cposts, $regdate, $clocation, $conline, $csig ) = mysql_fetch_row($results);
}
ppmysql_free_result( $results );

if ( $chomepage != "" ) {
$hpage = "<a href=\"$chomepage\" target=\"_blank\"><img src=\"{$Globals['idir']}/home.gif\" alt=\"Visit ".$cuser."'s homepage!\" border=\"0\" /></a>";
}

if ($conline == "") {
$isonline = "<img src=\"{$Globals['idir']}/vb2off.gif\" border=\"0\" alt=\"{$Globals['pp_lang']['offline']}\" align=\"absmiddle\" /> ";
}
else {
$isonline = "<img src=\"{$Globals['idir']}/vb2on.gif\" border=\"0\" alt=\"{$Globals['pp_lang']['online']}\" align=\"absmiddle\" /> ";
}

$userprofile[0] = $cuser; // Username
$userprofile[1] = $chomepage; // Homepage
$userprofile[2] = $cposts; // Total Posts
$userprofile[3] = $ctitle; // Title
$userprofile[4] = $regdate; // Registered Date
$userprofile[5] = $clocation; // Location
$userprofile[6] = ""; // Avatar

[Chuck S]

Of course it does. Look at the query not the defination of variables part. There is definately a field2 parameter and in a normal vb3 install that is the user location field.

[thomor25]

cool saw it on line 123 I added teh myspace had and I had to change all teh field numbers. it works now thanks.

[sinjix]

can u tell me how to add field2?