vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Show Thread Enhancements - Chief First Post - Every Page - 3.6.x (https://vborg.vbsupport.ru/showthread.php?t=156141)

Wheezy 09-28-2007 03:14 AM

Quote:

Originally Posted by Spermy
To remove the sig form articles read Rat1972's post below.

Thanks much :D

Aeolian 09-28-2007 10:57 AM

I think the developer must incorporate the changes suggested/submitted in the posts above to the actual MOD itself..
Thanks

inciarco 09-28-2007 01:29 PM

Quote:

Originally Posted by elmati (Post 1348661)
Im using Photoplog and vb 3.6.8 with chief 1st post active and works fine :)

i think u have done something wrong or misconfiguration...

Please Tell me what's wrong and where can I locate the Error, because I've tryed reinstalling this Hack and the same Error keeps appearing when I set to yes the Displaying of the First Post in a Forum. :(

Could you Please analyze the Error and Tell me what's wrong?? :confused:

What should I check?? What should I change?? :confused:

The only way for the Hack to Work is by Disabling the Photoplog Hack in my Forum, that's why I deduced that some Incompatibility is Happening, also by the Error Message and the piece of code that says "COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplo g_fileuploads.moderate)) AS photoplog_filecount" that includes "COUNT" and is related with Photoplog; but this Error only happens when the Chief First Post Hack is Activated and set to Yes in a Forum, so something isn't working, at least in Version 3.6.7 PL1; I hope you could analyze the Error and Orient me in what should I check/change/set for this Hack to work Ok in my Forums!! :confused:

I appreciate your Help and your Patience!! ;)

My Best Regards!! :)

I copy/paste again the Error Message for you to Analyze it:

Code:

Database error
The INCIARCO - FOROS - Comunidades Virtuales de Integraci?n database has encountered a problem.

--------------------------------------------------------------------------------
 
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the inciarco.com home page, then try to open another page.
Click the Back button to try another link.
 
The inciarco.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.


Database error in vBulletin 3.6.7:

Invalid SQL:

                SELECT
                        post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
                        user.*, userfield.*, usertextfield.*,
                        icon.title as icontitle, icon.iconpath,
                        avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
                        deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
                        editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
                        editlog.reason AS edit_reason,
                        postparsed.pagetext_html, postparsed.hasimages,
                        sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
                        sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
                       
                        , IF(SUM(photoplog_fileuploads.moderate) > 0 AND 1 = 0,COUNT(photoplog_fileuploads.moderate) - SUM(photoplog_fileuploads.moderate),COUNT(photoplog_fileuploads.moderate)) AS photoplog_filecount
                FROM vb_post AS post
                LEFT JOIN vb_user AS user ON(user.userid = post.userid)
                LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
                LEFT JOIN vb_icon AS icon ON(icon.iconid = post.iconid)
                LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
                        LEFT JOIN vb_deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
                LEFT JOIN vb_editlog AS editlog ON(editlog.postid = post.postid)
                LEFT JOIN vb_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 2)
                LEFT JOIN vb_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 2)
                LEFT JOIN vb_sigpic AS sigpic ON(sigpic.userid = post.userid)
                        LEFT JOIN photoplog_fileuploads AS photoplog_fileuploads ON(photoplog_fileuploads.userid = user.userid)
                WHERE post.postid IN (0,8415,8415)
                ORDER BY post.dateline;

MySQL Error  : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Date        : Tuesday, September 25th 2007 @ 05:12:30 PM
Script      : http://zzz/showthread.php?t=1909
Referrer    : http://zzz/forumdisplay.php?f=85
IP Address  : zzz.zzz.zzz.zzz
Username    : zzz
Classname    : vb_database

:)

mvigod 09-28-2007 04:15 PM

Quote:

Originally Posted by mvigod
Anyone aware of an if condition that would allow only a usergroup to lock the first post instead of it globably applying to the entire forum?
The answered by mvigod below.


Quote:


Originally Posted by mvigod
For other usergroups, just add their usergroup id to the if condition:
= Code:
<if condition="is_member_of($bbuserinfo, 6,5,7)">



Spermy,
That works for the postbit selection, however it is still globally locking the first post. What would be even better is if this had a selection in the usergroup permissions that allowed an admin to set "can lock first post" yes/no. And then have it as a radio button within the postbit.

Failing that I guess a new user field could be generated and then added to the template:

Code:

if ($forum['chiefpost'] AND $vbulletin->userinfo[fieldx]=='Yes'

However change that to a specific bbgroup.

Spermy 09-28-2007 07:12 PM

Sorry, but that I don't know about.

MaXxed 09-29-2007 01:21 AM

Quote:

Originally Posted by Spermy (Post 1348594)
What version of VB? I run 3.6.8
It might be different for another version.

Same, 3.6.8.

Perhaps im pasting it incorrectly? How should it be formatted in there?

xandizitxu 09-29-2007 02:01 AM

I don't get this plugin working with VBTT properly... Disappointed.

Spermy 09-29-2007 10:51 AM

Quote:

Originally Posted by MaXxed (Post 1349302)
Same, 3.6.8.

Perhaps im pasting it incorrectly? How should it be formatted in there?

Can you copy and paste your whole postbit_articles template to me in a PM?

Quote:

Originally Posted by xandizitxu (Post 1349322)
I don't get this plugin working with VBTT properly... Disappointed.

I haven't used vbtt in awhile, but all you should need to do is add the vbtt edits you would do in any of the postbits into the postbit_articles. Can you send me a link to the new vbtt and when I get some time I will look at it.

xandizitxu 09-29-2007 11:36 AM

I already tried it. Didn't work, the link is
www.torrenttrader.org

Freesteyelz 09-30-2007 10:04 PM

For those who just want to keep the "Article" layout and not have the other postbit options in (new thread/edit post) can simply disable plugins:

editpost_edit_complete
editpost_update_complete
newpost_complete
newthread_form_complete


All times are GMT. The time now is 09:59 PM.

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.01386 seconds
  • Memory Usage 1,764KB
  • 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
  • (2)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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