vb.org Archive
Page 4 of 7 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Mini Mods - Last Poster Avatar (https://vborg.vbsupport.ru/showthread.php?t=275406)

phpdesk 01-06-2012 08:53 PM
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
Quote:
Originally Posted by bada_bing (Post 2284319)
I have uninstalled this mod because it it not working with vb 4.19 it give a database errro

HTML Code:
Database error in vBulletin 4.1.9:

Invalid SQL:

                SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
                post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS de

sadiq6210 01-07-2012 08:40 AM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
What about this?
https://vborg.vbsupport.ru/showpost....&postcount=115

Thanks

I.G.O.T.A. 01-08-2012 06:52 PM
Quote:
Originally Posted by Fready (Post 2284008)
Found a bug/problem.

On the Forums Home, say you have Sub-Forums, if a poster posts on a Thread in the Sub-Forum it doesn't show their av on the Forums Home, it will show the av of the last poster within the main Forum not the Sub Forum even though the last post showing on the Forums Home is from the Sub Forum.

Hope you understand what I mean.
Check it out and test it with a Forum which has a Sub Forum to it.
I have the same problem. I'm on 4.1.8

I.G.O.T.A. 01-10-2012 12:06 PM
Is there a way to fix this issue?

garybrun 01-10-2012 11:26 PM
works ok for me in 4.19a
http://Www.minelabowners.com

bada_bing 01-11-2012 02:24 AM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
That is the exact copy and past of the error message I get this this plugin enabled

goshalim 01-11-2012 05:39 AM
Hi , this is a very nice mod , good job man !!

I have only a small problem which iam sure that you will help me to solve it.
Please see the link from my web site.

The user name is shown twice and also a part of the code.

http://www.canarybreeder.net/up/forum/forum.php

chiggy 01-11-2012 04:44 PM
Hey Bro U Done Great Job Installed And Working Perfectly And Realy I Like Your Mod And Ur Work
This Modification Give My Forum Something Good Look Bcoz My All Forum Members Almost Using GIF Animated Avatars And In Home Page Its Looking Coolll Man Than You Very Much...... U R The Man
My Side +1000 For You.

bada_bing 01-11-2012 06:10 PM
Quote:
Originally Posted by phpdesk (Post 2284583)
The quoted error message seems to be cut and does not include the actual note related to the error. Would it be possible to post the full error message so that I could track it down?

Either way, I have reuploaded the previous version of the mod for those of you having issues with v1.1.1.

Thanks.
Here is the full error

HTML Code:
Database error in vBulletin 4.1.9:

Invalid SQL:

                SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
                post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                       
                        , threadredirect.expires
                        ,IF(customavatar.userid, 1, 0) AS useavatar, user.avatarrevision
, user.avatarrevision AS avatarrevision, thread.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                FROM thread AS thread
                        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
                        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                        LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                       
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                       
                        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
                       
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = thread.postuserid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                WHERE thread.threadid IN (0,7,1)
                ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error  : Not unique table/alias: 'customavatar'
Error Number  : 1066
Request Date  : Wednesday, January 11th 2012 @ 01:07:59 PM
Error Date    : Wednesday, January 11th 2012 @ 01:07:59 PM
Script        : http://www.mysite.com/forums/forumdisplay.php?2-mysite-com-Announcements
Referrer      : http://www.mysite.com/forums/forum.php
IP Address    : 67.59.x.x
Username      : adminaccount
Classname    : vB_Database
MySQL Version : 5.0.90-community-nt

bremereric 01-11-2012 07:22 PM
Will this hack also grab pre-defined avatars or only the one's that members have uploaded?

bremereric 01-12-2012 02:57 AM
1 Attachment(s)
Okay I installed your 1.1.1 version and it didn't have the default avatar option in the admin options. It also had some of the same avatars overriding others on another new post. I did not take screen shots of this. I rolled back to 1.0.5a version and got the default avatar back and they worked like a charm. Lost the option to move the avatar to the left though. I have attached screen shots of the 1.0.5a version installed.

TheSupportForum 01-12-2012 10:47 PM
Quote:
Originally Posted by bremereric (Post 2286799)
Okay I installed your 1.1.1 version and it didn't have the default avatar option in the admin options. It also had some of the same avatars overriding others on another new post. I did not take screen shots of this. I rolled back to 1.0.5a version and got the default avatar back and they worked like a charm. Lost the option to move the avatar to the left though. I have attached screen shots of the 1.0.5a version installed.
i've had the same problem

i created a new forum/category
i was the first person to post in it, it decided to show a different users avatar and profile, this mod needs to be checked for errors in coding it seriously messed up my board showing the other guys avatar as the last peron who posted even though i was the only poster in that forum

TheSupportForum 01-12-2012 10:51 PM
current issues

Hook Forumbit Query Fields & Joins

Code:
if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
    $counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
    $tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}

goshalim 01-13-2012 09:33 AM
Quote:
Originally Posted by goshalim (Post 2286399)
Hi , this is a very nice mod , good job man !!

I have only a small problem which iam sure that you will help me to solve it.
Please see the link from my web site.

The user name is shown twice and also a part of the code.

http://www.canarybreeder.net/up/forum/forum.php
Please i really need some help here ............

https://vborg.vbsupport.ru/external/2012/01/47.jpg

bulldog51981 01-13-2012 02:30 PM
Quote:
Originally Posted by bada_bing (Post 2286633)
Here is the full error

HTML Code:
Database error in vBulletin 4.1.9:

Invalid SQL:

                SELECT
                        IF(votenum >= 1, votenum, 0) AS votenum,
                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
                post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
                        thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
                        thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount,
                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
                        user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                       
                        , threadredirect.expires
                        ,IF(customavatar.userid, 1, 0) AS useavatar, user.avatarrevision
, user.avatarrevision AS avatarrevision, thread.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
                FROM thread AS thread
                        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
                        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                        LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                       
                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
                       
                        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
                       
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = thread.postuserid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
                WHERE thread.threadid IN (0,7,1)
                ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error  : Not unique table/alias: 'customavatar'
Error Number  : 1066
Request Date  : Wednesday, January 11th 2012 @ 01:07:59 PM
Error Date    : Wednesday, January 11th 2012 @ 01:07:59 PM
Script        : http://www.mysite.com/forums/forumdisplay.php?2-mysite-com-Announcements
Referrer      : http://www.mysite.com/forums/forum.php
IP Address    : 67.59.x.x
Username      : adminaccount
Classname    : vB_Database
MySQL Version : 5.0.90-community-nt
I upgraded to ver 1.1.1 last night and didn't realize it until this morning but I am getting the same error on Sub Forums only. Reverted back to 1.0.5a and problem solved. Will upgrade again after issue is fixed.

I.G.O.T.A. 01-13-2012 05:04 PM
I just upgraded forum to 4.1.10 and now my avatars are not lining up like they where on 4.1.8. Any got any ideas?

kfyonur 01-13-2012 06:41 PM
same database problem.

TheSupportForum 01-13-2012 07:12 PM
Quote:
Originally Posted by IGOTASTi (Post 2287352)
I just upgraded forum to 4.1.10 and now my avatars are not lining up like they where on 4.1.8. Any got any ideas?
Quote:
Originally Posted by kfyonur (Post 2287393)
same database problem.
its a plugin issue

look at the plugins you will see references to the database fieldnames
they may of changed in 4.1.10

details below on which one to check

Hook Forumbit Query Fields & Joins

Code:
if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
    $counter_select .= iif($vbulletin->options['avatarenabled'], ',  user.avatarrevision AS avatarrevision, forum.lastposterid AS userid,  avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,  customavatar.dateline AS avatardateline,customavatar.width AS  avwidth,customavatar.height AS avheight');
    $tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT  JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid =  user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS  customavatar ON(customavatar.userid = user.userid)");
}

kevius 01-13-2012 07:41 PM
Quote:
Originally Posted by Fready (Post 2284008)
Found a bug/problem.
On the Forums Home, say you have Sub-Forums, if a poster posts on a Thread in the Sub-Forum it doesn't show their av on the Forums Home, it will show the av of the last poster within the main Forum not the Sub Forum even though the last post showing on the Forums Home is from the Sub Forum.
Hope you understand what I mean.
Hi there, i've got the same problem too !

Can anybody help us to resolve this bug with sub-forum ?

I.G.O.T.A. 01-13-2012 07:53 PM
Quote:
Originally Posted by simonhind (Post 2287401)
its a plugin issue

look at the plugins you will see references to the database fieldnames
they may of changed in 4.1.10

details below on which one to check

Hook Forumbit Query Fields & Joins

Code:
if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
    $counter_select .= iif($vbulletin->options['avatarenabled'], ',  user.avatarrevision AS avatarrevision, forum.lastposterid AS userid,  avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar,  customavatar.dateline AS avatardateline,customavatar.width AS  avwidth,customavatar.height AS avheight');
    $tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT  JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid =  user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS  customavatar ON(customavatar.userid = user.userid)");
}
So how do I fix this?

TheSupportForum 01-13-2012 08:00 PM
Quote:
Originally Posted by IGOTASTi (Post 2287412)
So how do I fix this?
Admicp > Plugins & Products > Plugin Manager >
look for Hook Forumbit Query Fields & Joins

ensure that the fieldnames match the query

I.G.O.T.A. 01-13-2012 08:10 PM
Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}

TheSupportForum 01-13-2012 09:01 PM
Quote:
Originally Posted by IGOTASTi (Post 2287422)
Here is my code.

if( $vbulletin->options['lpavatar_enable'] == 1 && $vbulletin->options['lpavatar_forumbit'] == 1 )
{
$counter_select .= iif($vbulletin->options['avatarenabled'], ', user.avatarrevision AS avatarrevision, forum.lastposterid AS userid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight');
$tachyjoin .= iif($vbulletin->options['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON(customavatar.userid = user.userid)");
}
there are also other plugins that go with this
login to your hosting control panel and open up PHPMySQL or similar
you have to ensure that the fieldname e.g. avatarid etc exists

or the other option who be to uninstall it and reinstall the mod
sometimes it resolves the issue

I.G.O.T.A. 01-13-2012 09:17 PM
I uninstalled it and reloaded it in and it stayed the same. When I log into my PHPMySQL what do I do?

bremereric 01-13-2012 10:30 PM
Phpdesk posted the following. Did you guys uninstall and reinstall the older version. I did and it's working fine.

https://vborg.vbsupport.ru/showpost....&postcount=121

phpdesk 01-14-2012 04:54 PM
Hi guys, you have the two versions of the mod, this is a free contribution, so feel free to suggest a merge between the two, and I'll be more than happy to include it into a new release.

goshalim 01-15-2012 04:07 AM
Hi Alex ( phpdesk )
Iam just wondering whyn none of you is to replying to my request !!!!

I cant wait any longer otherwise i will delete this addon.

Someone please can tell me what is going wrong and the username is shown twice next to the picture and also a part of the code is visable to the users?

thanks

phpdesk 01-15-2012 02:44 PM
Hi, goshalim,

I'll work on an update to fix the reported issues as soon as I get a moment, you can use 1.0.5a meanwhile.

kevius 01-15-2012 03:52 PM
and what about "sub-forum" bug ? any idear ?

goshalim 01-15-2012 06:31 PM
i did try 1.0.5 but still the same problem

Khalid-B 01-17-2012 07:21 AM
installed...

working fine with 4.1.10

bperkins88 01-17-2012 08:16 PM
cool mod, i like this

I.G.O.T.A. 01-18-2012 06:52 PM
Still having issues with it aligning.

goshalim 01-19-2012 07:00 AM
UNFORTUNATELY what i see is than the owner does not care about our problems , not even tried to help.

No reasnon then to keep this addon on my website.

as from now its Un installed !

New Joe 01-19-2012 08:29 AM
Quote:
Originally Posted by goshalim (Post 2289753)
UNFORTUNATELY what i see is than the owner does not care about our problems , not even tried to help.

No reasnon then to keep this addon on my website.

as from now its Un installed !
Yep, no matter which version i use, I still have problems with it showing the last av for Sub-forums.

kitawanita 01-19-2012 11:40 AM
Hey Alex,
Your mod not working on my custom style.If i switch to default style,it working well.
Any idea ?

I.G.O.T.A. 01-23-2012 12:31 PM
So I guess no update. That sucks. :(

phpdesk 01-23-2012 01:04 PM
I've been running a pretty crowded schedule since new year, an important (money-wise) high load project that I'm working on. I hope to make some time for these little mods, too...

aussiev8 01-24-2012 12:53 PM
it didn't float the by line, title and time correctly.

kylek 01-24-2012 07:39 PM
Disabling it for now until the sub forum problem can be fixed, getting too many members complaining that someone elses avatar is showing as theirs. Otherwise this is a great feature. Any chance for a temporary fix on this in the meantime?


All times are GMT. The time now is 08:01 PM.
Page 4 of 7 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07648 seconds
  • Memory Usage 1,873KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (3)bbcode_html_printable
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete