vb.org Archive
Page 6 of 9 « First 45 6 78 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)
-   -   End-User Options - Starred Posts (https://vborg.vbsupport.ru/showthread.php?t=323063)

Snowhog 02-07-2017 05:15 PM
Totally understand. It isn't a big deal.

MarkFL 02-07-2017 05:17 PM
Quote:
Originally Posted by Snowhog (Post 2582036)
Totally understand. It isn't a big deal.
When I get some time, I will install DBTech's product on my local dev site and see if I can resolve the conflict. :)

Snowhog 02-07-2017 05:17 PM
That would be great. Thank you.

DSemen 03-31-2017 04:39 PM
Help me please. DB Error. Very good and useful mod, for a long time can someone tell me how to make it work on 4.1.3
Quote:
Database error in vBulletin 4.1.3:

Invalid SQL:

SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.postercount AS threadpostercount, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
FROM starposts AS starposts
LEFT JOIN post AS post
ON post.postid = starposts.postid
LEFT JOIN thread AS thread
ON thread.threadid = post.threadid
LEFT JOIN forum AS forum
ON forum.forumid = thread.forumid
WHERE starposts.userid = 1
ORDER BY starposts.dateline ASC;

MySQL Error : Unknown column 'thread.postercount' in 'field list'
Error Number : 1054
Request Date : Friday, March 31st 2017 @ 09:35:00 PM
Error Date : Friday, March 31st 2017 @ 09:35:00 PM
Script : http://forum.mysite.net/mystarpost.php

MarkFL 03-31-2017 04:57 PM
Quote:
Originally Posted by DSemen (Post 2584530)
Help me please. DB Error. Very good and useful mod, for a long time can someone tell me how to make it work on 4.1.3
I don't have access to vB 4.1.x to test, but that column is a part of the thread table by default in vB 4.2.x.

After a quick check, I see it is not present in vB 3.8.11, so perhaps it was added in vB 4.2.x.

The quickest solution here would be for you to update to vB 4.2.4 (or vB 4.2.5 if you want to upgrade to PHP 7.x) ;)

DSemen 03-31-2017 05:00 PM
Unfortunately it will not be possible to update. Many mods require a serious alteration. I already tried several times to update myself and it always ended in failure. I ask you, I am ready to pay, help me.

MarkFL 03-31-2017 05:22 PM
Quote:
Originally Posted by DSemen (Post 2584532)
Unfortunately it will not be possible to update. Many mods require a serious alteration. I already tried several times to update myself and it always ended in failure. I ask you, I am ready to pay, help me.
Locate the following code in the file "mystarpost.php":

PHP Code:
$posts = $vbulletin->db->query_read("
    SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.postercount AS threadpostercount, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
    FROM " . TABLE_PREFIX . "starposts AS starposts
    LEFT JOIN " . TABLE_PREFIX . "post AS post
    ON post.postid = starposts.postid
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread
    ON thread.threadid = post.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum
    ON forum.forumid = thread.forumid
    WHERE starposts.userid = " . $vbulletin->userinfo['userid'] . "
    ORDER BY starposts.dateline ASC
"); 
Change if to read:

PHP Code:
$posts = $vbulletin->db->query_read("
    SELECT starposts.dateline AS stardateline, post.*, thread.title AS threadtitle, thread.postusername as postusername, thread.postuserid AS postuserid, thread.dateline AS threaddateline, thread.replycount AS replycount, thread.views AS views, thread.lastpost AS threadlastpost, forum.forumid AS forumid, forum.title AS forumtitle, forum.description AS forumdescription, forum.parentlist AS forumparents
    FROM " . TABLE_PREFIX . "starposts AS starposts
    LEFT JOIN " . TABLE_PREFIX . "post AS post
    ON post.postid = starposts.postid
    LEFT JOIN " . TABLE_PREFIX . "thread AS thread
    ON thread.threadid = post.threadid
    LEFT JOIN " . TABLE_PREFIX . "forum AS forum
    ON forum.forumid = thread.forumid
    WHERE starposts.userid = " . $vbulletin->userinfo['userid'] . "
    ORDER BY starposts.dateline ASC
"); 
Now, in the template "markfl_starpost_postbit", locate the line:

HTML Code:
<tr><td>Poster Count</td><td>{vb:raw post.threadpostercount}</td><tr>
And remove it.

Let me know if this works. :)

DSemen 03-31-2017 05:45 PM
DB error has disappeared. But nowhere is there a reference to mystarpost.php
Also, when clicking on a link that is also not found anywhere (enter in the address bar) on the starpost.php forum posts:
Quote:
vBulletin Message
DSe, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
"Go To Post" - Does not lead to a message, but leads to the first page

MarkFL 03-31-2017 05:55 PM
The file "mystarpost.php" is accessed via the navbar, under "Quick Links." It could be that vB 4.1.x is incompatible with this...this is one of many reasons I marked this product for vB 4.2.x.

I'm sorry, but I just don't have the time to rewrite this product for vB 4.1.x. There are simply too few people still using it to make it worth the effort for me. vB 4.1.x is obsolete, and I would recommend anyone still using it to upgrade.

DSemen 03-31-2017 06:04 PM
Adding to the navigation bar is not a problem at all, I'll do it myself. The problem remains that by clicking the transfer is done not to the selected post, but to the first message in the topic.


All times are GMT. The time now is 05:11 PM.
Page 6 of 9 « First 45 6 78 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.01219 seconds
  • Memory Usage 1,760KB
  • 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
  • (1)bbcode_html_printable
  • (2)bbcode_php_printable
  • (5)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
  • (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