vb.org Archive
Page 10 of 18 « First 89 10 1112 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)
-   -   Miscellaneous Hacks - Featured Threads (https://vborg.vbsupport.ru/showthread.php?t=320387)

MarkFL 01-20-2016 03:27 PM
If I had to wager a guess, it would be the MariaDB that's at the heart of the issue...:)

jagtpf 01-20-2016 03:34 PM
Poor old Maria !

MarkFL 01-20-2016 04:52 PM
Quote:
Originally Posted by ikopylov (Post 2563018)
1.
It is very necessary. Put it at 1st line in you TODO list. )))
As I said, it is on my list. I plan to use phrasing in all of my products, and so it could be a while before I get to this one. I apologize if this causes you any inconvenience. I am just one person, doing this in my spare time, for free.

Quote:
Originally Posted by ikopylov (Post 2563018)
2.
If we used the specification DOCTYPE HTML it would be appropriate to use <br>
But in VB we use specification DOCTYPE XHTML in this case it is necessary to use <br />, <hr />, <input />, <img /> and then the code is valid
It appears vB (all of the sites I use) employs:

HTML Code:
<!DOCTYPE html...
And so the closing slashes are optional. :)

Quote:
Originally Posted by ikopylov (Post 2563018)
3.
php substr() function with utf-8 leaves "�" marks at the end before "..."
I showed how to solve this little problem
As I said, I will look into that.

Quote:
Originally Posted by ikopylov (Post 2563018)
4.
Maybe you can add settings option SEO link | Standard Link
I may look into that, as part of the next update. :)

MarkFL 01-21-2016 04:22 AM
Quote:
Originally Posted by ikopylov (Post 2563018)
2.
If we used the specification DOCTYPE HTML it would be appropriate to use <br>
But in VB we use specification DOCTYPE XHTML in this case it is necessary to use <br />, <hr />, <input />, <img /> and then the code is valid
I looked more into this, and I discovered that the Style Variable "htmldoctype" uses the XHTML 1.0 transitional declaration, and so admit I was wrong, and will add the closing slashes when I update this product, so that the code is valid.

Thank you for bringing this to my attention. :)

hazem_aliraqi 01-21-2016 06:10 PM
Quote:
Originally Posted by MarkFL (Post 2562991)
I sort of already have this, if you set "Recognize "Featured Threads" Authors In Postbits/Profiles" to "Yes" in the "Icons" section of the settings. The icon has a tooltip that indicates how many "Featured Threads" the user has authored. :)
i get this

PHP Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

        SELECT COUNT(*) AS thread_count, thread.postuserid
        FROM thread AS thread
        INNER JOIN featuredthreads AS featuredthreads
        ON thread.threadid = featuredthreads.threadid
        WHERE thread.postuserid = 1; 

hazem_aliraqi 01-21-2016 06:28 PM
can i get the number like this {vb:raw post.posts} in postbit ?

MarkFL 01-21-2016 06:41 PM
Quote:
Originally Posted by hazem_aliraqi (Post 2563141)
i get this

PHP Code:
Database error in vBulletin 4.2.2:

Invalid SQL:

        SELECT COUNT(*) AS thread_count, thread.postuserid
        FROM thread AS thread
        INNER JOIN featuredthreads AS featuredthreads
        ON thread.threadid = featuredthreads.threadid
        WHERE thread.postuserid = 1; 
I don't see where the SQL is invalid...is there any information regarding the error?

Quote:
Originally Posted by hazem_aliraqi (Post 2563142)
can i get the number like this {vb:raw post.posts} in postbit ?
Yes, I will include this in the next update. :)

MarkFL 01-22-2016 03:33 AM
Quote:
Originally Posted by hazem_aliraqi (Post 2563142)
can i get the number like this {vb:raw post.posts} in postbit ?
I have added this to the product, but it relies on the same query that is giving you an error, so we need to figure out why it is not working on your installation. :)

I will wait to publish it though, because I am working on a major upgrade, and this will be part of it.

hazem_aliraqi 01-23-2016 06:31 AM
Quote:
Originally Posted by MarkFL (Post 2563177)
I have added this to the product, but it relies on the same query that is giving you an error, so we need to figure out why it is not working on your installation. :)

I will wait to publish it though, because I am working on a major upgrade, and this will be part of it.


thank you mark i have made the COUNT from sql using php file

how can i find the Featured Threads for each user ?

i don't want a major upgrade its hard to translate for arabic language :)

hazem_aliraqi 01-23-2016 06:38 AM
Quote:
Originally Posted by MarkFL (Post 2563143)
I don't see where the SQL is invalid...is there any information regarding the error?



Yes, I will include this in the next update. :)
this


PHP Code:
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 


All times are GMT. The time now is 03:10 PM.
Page 10 of 18 « First 89 10 1112 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.01712 seconds
  • Memory Usage 1,758KB
  • 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
  • (3)bbcode_php_printable
  • (11)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