avatars not showing in comments PP-5.31 and VB-3.6

[rstarke]

all user information is showing up in comments except for their avatars

Im running PP with vB3 INTEGRATION turned off, however when I turn it on- avatars do show. Why is that? how can I make them show up with my PP's current configuration

The forum path is correct, avatars are being saved in the defalt VB location. All other user information is being ported over. so why not those pesky little avatars?

check this page and see for yourself- http://www.paint-sculpt.com/gallery/.../9/limit/views
any help would be greatly appreciated
-Richard

[Chuck S]

Avatars need you to turn on the vb3 integration if you choose to use the enhanced features. If you do not choose to use the enhanced features your simply going to have nothing more than user login integration. Therefore if you wish stuff like avatars and wysiwyg editors etc etc you need to use the vb3 integration in edit integration turn the 3 options on.

[rstarke]

Ok so if I do this how can I change the css and alter the templates without changeing my VB forum?

[Chuck S]

what do you mean?

[rstarke]

Well I have enabled Vb integration and removed the navbar (takes up too much space)
but I would like to add a login-logout function on the menubar (like it is when VB integration is turned off)
how would I go about this?

here is my current menubar template:

<?php
echo<<<PPPRINT
<!-- BEGIN TEMPLATE: menubar.tmpl -->
<form method="get" action="{$Globals['maindir']}/showgallery.php">
$ppopen

<tr>
<td colspan="5" align="left" class="menubar2">
<table width="100%" border="0" cellpadding="15" cellspacing="0">
<tr>
<td class="{$Style['menubarnb']}">
<span>&nbsp;$childnav</span>
</td>
<td align="right">
PPPRINT;

include( "{$Globals['PP_PATH']}/{$Globals['TMPL_PATH']}/searchbox.tmpl" );

echo<<<PPPRINT
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="menubarlinks" width="100%" colspan="2">
<table width="100%" cellpadding="0" cellspacing="0">
<tr>
<td class="{$Style['menubarnb']}" width="50%" align="left" valign="middle">
&nbsp;$menu2 <span class="medium"> · <a href="http://www.paint-sculpt.com/gallery/showmembers.php"> Member Galleries<a/></span>
</td>
<td class="{$Style['menubarnb']}" width="50%" align="right"valign="middle">
$menu&nbsp;
</td>
</tr>
</table>
</td>
</tr>
$ppclose
</form>
<br />
PPPRINT;

if ( !empty($posternav) ) {
echo<<<PPPRINT
$ppopen
$ppclose

<!-- END TEMPLATE: menubar.tmpl -->
PPPRINT;
}

?>

how would I adjust this template to have a login-logout function on my menubar?


Click here to see my photopost pages

[Chuck S]

You dont adjust the template. You would hack your pp-inc.php and remove this code in bold around the $log lines you will see two of em.

Content visible to verified customers only.

[rstarke]

ok that worked however I have a question about security
When you use the VB navbar login- you get 5 chances at loging in correctly and then are banned for 15 minutes if you were wrong 5 times (would take forever to hack)

but if you use the PP login- you can keep trying without this protection (much less protection against hacking)

Is there a feature or setting that I'm overlooking or is this just the way it goes?

and one last thing before I'm all setup
when you use the recent images feature (1day,7days,...,all) and then try to group by member I'm getting this error:
"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rstarke/public_html/gallery/showmembers.php on line 360"
How might I fix this?

thanks again for all your help

[Chuck S]

How ya going to hack it if the username and password are wrong they simply do not get in.

http://www.paint-sculpt.com/gallery/showmembers.php

I do not see any errors when viewing this page

[rstarke]

try to group by member on this page-
http://www.paint-sculpt.com/gallery/...it=last14&cat=
found by following the Recent Gallery Images (14 days) link

cant the password be cracked by a bot?

[Chuck S]

md5 passwords can not be cracked it is a one way encryption. Now if someone wants to sit around and try typing passwords all day maybe they could guess one if someone had a real simple one.

[Chuck S]

Try encapsulting the userid variable in this line in showmembers.php. You can replace your lines with these.

Content visible to verified customers only.

[rstarke]

ok i put the code in here but get another error
-here is where I put the code in showgallery.php

if ( $cat == 500 || $cat == MOBILE_CAT )
{
list( $tuserid, $tusername, $tmail ) = get_userinfo( "", $ppuser);
$thecatname = "$tusername {$Globals['pp_lang']['gallery']}";
$titlereplace = "$tusername's {$Globals['pp_lang']['gallery']}";

if ( $Globals['memformat'] == "no" )
{
$pquery = ppmysql_query("SELECT id, bigimage, cat, storecat, height, width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND userid='{$memrec['userid']}' AND cat=$cat ORDER BY date DESC LIMIT 1", $link);
}
else
{
$pquery = ppmysql_query("SELECT id, bigimage, cat, storecat, height, width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND userid='{$memrec['userid']}' ORDER BY date DESC LIMIT 1", $link);
}
$photorec = mysql_fetch_array($pquery);

if ( $Globals['spider'] == "yes" )
{
$conurl = construct_ppurl( "{$Globals['maindir']}/showgallery.php/cat/all" );
$seemore = "<a href=\"$conurl\">{$Globals['pp_lang']['tosee']} $tusername's {$Globals['pp_lang']['littlephotos']}</a>";
}
else

and here is the new error-

Parse error: syntax error, unexpected '}' in /home/rstarke/public_html/gallery/showgallery.php on line 354

[Chuck S]

My post said to edit showmembers.php not showgallery.php

[rstarke]

Oops sorry
ok I tried putting it here in showmembers.php

$cc++;
if ($cc >= $startnumb)
{
if ($cc < ($startnumb+$perpage))
{
if ($Globals['membthumb'] == "yes")
{
if ( $Globals['memformat'] == "no" )
{
$pquery = ppmysql_query("SELECT id, bigimage, cat, storecat, height, width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND userid='{$memrec['userid']}' AND cat=$cat ORDER BY date DESC LIMIT 1", $link);
}
else
{
$pquery = ppmysql_query("SELECT id, bigimage, cat, storecat, height, width FROM {$Globals['pp_db_prefix']}photos WHERE approved=1 AND userid='{$memrec['userid']}' ORDER BY date DESC LIMIT 1", $link);
}
$photorec = mysql_fetch_array($pquery);

if ( $photorec['storecat'] != 0 )
{
$photorec['cat'] = $photorec['storecat'];
}

$is_private = is_image_private( $photorec['cat'] );

but I'm getting that old error again- it is showing up 3 times in a row like so

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rstarke/public_html/gallery/showmembers.php on line 360

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rstarke/public_html/gallery/showmembers.php on line 360

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rstarke/public_html/gallery/showmembers.php on line 360

[Chuck S]

Try turning on display errors in debug to show your true error

[rstarke]

Where is this on / off selection?

[Chuck S]

in admin => Global options

[rstarke]

Ok , done
Here is the new error

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT id, bigimage, cat, storecat, height, width FROM pp_photos WHERE approved=1 AND userid=6 AND cat=all ORDER BY date DESC LIMIT 1

Result: 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 'ORDER BY date DESC LIMIT 1' at line 1

Database handle: Resource id #25

[Chuck S]

Reapply the edit in post 11 and try again

[rstarke]

ok, well now there is no error but also no thumbnails
try to group this page by member to see what I mean

http://www.paint-sculpt.com/gallery/...it=all&cat=all