vb.org Archive
Page 5 of 9 « First 34 5 67 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   New Posting Features - Thread Thumbnails (https://vborg.vbsupport.ru/showthread.php?t=214755)

Ghostt 11-09-2009 01:52 PM
Quote:
Originally Posted by realdx (Post 1911985)
since the performance is more important is better having to load a 2kb thumbnail than load the original and then resize it in realtime everytime the thread list is viewed.. not to mention that if user grab the image for his thread from somewhere, and then that somewhere delete the image, you have the thread without any thumb.
the images are normaly stored at imagehost so noone care

realdx 11-09-2009 02:03 PM
Quote:
Originally Posted by Ghostt (Post 1911990)
the images are normaly stored at imagehost so noone care
you are wrong in thinking that what for you is normal, so it should be for everybody.. yes, I really see users uploading on an image host their tiny thumbs for the thread.. and maybe have the thumb link to the image hosting service.. would you care of uploading to an image host service your thumbs for the thread??
IMO is more easy to see users stealing images they found surfing around, copy the link, and paste it in your board(mine too).
I dont even see why your arguing, probably, if one day we'll see the req I made, you'll have a nifty switch in the ACP, "host thumbs on your server?", yes and no.. so you can keep you images outside, and have a slow thread list, that you dont know how long it will keep the thumbs, while I will have a lighting fast thread list with the thumbs staying in their place as long as the thread is not deleted.. everybody's happy!:D

steve71 11-09-2009 04:00 PM
Will "first image in post" option work if thread is posted through the "easy forms" hack? If not I will have to revert back to the previous version where the members can manually edit in their thumbnails after posting.

Ghostt 11-10-2009 03:04 PM
Is it possible to show the last 6 images or so >> in the forumhome >> in the horizontal >> from certain forums?
would be a great upgrade on this mod^^

example: http://www.wowzio.com/widgets/module...getBuilder=yes

/edit
i see that guy allready done it :
http://freeonlinemoviesforum.com/2009-movies-f126.html?

JHarford 11-10-2009 07:51 PM
Thanks for the great mod. It seems to work well except for one issue.

When I create a new thread, the thread does not appear. Only the first thread I created shows in the forum, the others not at all. The threads only show when I turn off the plugin , or switch to 'first img', but that's not useful when we use the attachment system so much.

Thanks and hope there is a solution

phkk 11-11-2009 01:22 AM
Does this work on v3.7.3?

I installed it. No Thumbnail appear. ( After manual edited template)

phkk 11-11-2009 05:27 PM
It doesn't automatic show thread thumb. It was only show AFTER I edited the post.

Help me please

Ghostt 11-11-2009 05:57 PM
Quote:
Originally Posted by phkk (Post 1912783)
It doesn't automatic show thread thumb. It was only show AFTER I edited the post.

Help me please
read our last post for solution!

phkk 11-11-2009 06:38 PM
Where is your last posts Ghostt?

phkk 11-11-2009 06:40 PM
<a href="https://vborg.vbsupport.ru/showpost.php?p=1911387&postcount=154" target="_blank">https://vborg.vbsupport.ru/showp...&postcount=154</a>

phkk 11-11-2009 06:42 PM
woaaaaaaaaaa

phkk 11-11-2009 06:43 PM
work fineeeee. if took me a day to edited my template back and forth. woa fixed

praveenbv 11-12-2009 04:05 AM
Nice MOD, Thanks for this

tlwwolfseye 11-13-2009 07:56 AM
Quote:
Originally Posted by tlwwolfseye (Post 1911891)
Even with that Script I still get the same Database Error as soon as I enable this Mod. I am using vB 3.8.4 PL1.
Any idea how to use this Mod without screwing up the Forum with a DB Error ?
Thanks.
Anyone help here ? :eek::eek:

realdx 11-13-2009 08:08 AM
Quote:
Originally Posted by tlwwolfseye (Post 1913454)
Anyone help here ? :eek::eek:
Could be some other conflict with some other mods, I have it running on 3.8.4 PL1 flawlessy since installation..

tlwwolfseye 11-13-2009 08:15 AM
Well, how should I know if its a conflict with one of my other Mods, since they all work together fine. So disabling other Mods that all work perfectly together, just for one other Mod that doesn't work with some or one of them, is out of the question.

Seems I won't be using this one here then, too bad.

megamoose 11-14-2009 05:02 PM
Quote:
Originally Posted by tlwwolfseye (Post 1913461)
Well, how should I know if its a conflict with one of my other Mods, since they all work together fine. So disabling other Mods that all work perfectly together, just for one other Mod that doesn't work with some or one of them, is out of the question.

Seems I won't be using this one here then, too bad.
Tell me what the Database error you get is when using that script. You can get the actual error in the source of the page.

Mum 11-14-2009 05:13 PM
Can you choose to have 0 as the placeholder, so there is no image if there isn't one?

marianoblesa 11-14-2009 10:07 PM
I work in VB4?

tlwwolfseye 11-15-2009 06:52 AM
Quote:
Originally Posted by megamoose (Post 1914162)
Tell me what the Database error you get is when using that script. You can get the actual error in the source of the page.
The previous quote didn't let me put the Code in I had in my post one page before. Here again the Code of the Error.

Code:
<?php $STEP_AMOUNT = 600; ?>

<input type="button" id="btnNext" value="Process Next Results" onClick="window.location='?start='+(<?php echo $_GET["start"]; ?>+<?php echo $STEP_AMOUNT;?>)" disabled=true><br>
The button above should enable once this batch is complete!<br>
<br>

<?php
error_reporting(E_ALL & ~E_NOTICE & ~8192);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('SKIP_SESSIONCREATE', 1);
define('NOCOOKIES', 1);
define('THIS_SCRIPT', 'xupdate');
define('CSRF_PROTECTION', true);

// #################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

if (!$_GET["start"]) { $_GET["start"] = 0; }


        $threads = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "thread
        LIMIT ".$db->escape_string($_GET["start"]).",". $db->escape_string($_GET["start"]+$STEP_AMOUNT));

while ($thread = $db->fetch_array($threads)){
    echo "<b>Thread:</b> ".$thread["title"]."<br>";

    $posts = $db->query_read_slave("SELECT * FROM `" . TABLE_PREFIX . "post` WHERE `postid` = '".$thread["firstpostid"]."'");
    $post = $db->fetch_array($posts);
    echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <b>First Post:</b> ".$post["title"]."<br>";
preg_match('/\[img\](.*?)\[\/img\]/i',$post["pagetext"],$matches);
$query = "UPDATE `" . TABLE_PREFIX . "thread` set `thumbnailurl` = '".$db->escape_string($matches[1])."' WHERE threadid = " . $thread["threadid"];
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <b>SQL:</b>".$query."<br><br>";
$db->query_write($query);

}
?>

<script> document.getElementById("btnNext").disabled = false; </script>

megamoose 11-15-2009 08:33 AM
Quote:
Originally Posted by tlwwolfseye (Post 1914466)
The previous quote didn't let me put the Code in I had in my post one page before. Here again the Code of the Error.
tlwwolfseye, I mean give me the DataBase Error. Goto the file in your web browser, then when the Database Error page comes up, view the source of the file and at the very bottom there is a detailed SQL error.

g0rdy 11-15-2009 01:17 PM
For those of you that have it working what is the mysql version you are using ?

It errors for me on 5.0.45 when using attachment method vB 3.8.X

Ghostt 11-17-2009 11:48 AM
what about the rise on mouseover function, any lucky solutions?

/edit
ok i have one now

if you need it just PM me

Ghostt 11-19-2009 07:20 PM
hey i found a bug. if there are 2 [img] bbcodes in the same line the thumbnail bugs and is not showing image. do you have the same bug and would a reinstall solve the problem?

marianoblesa 11-21-2009 04:29 AM
please, update to VB4

phkk 11-22-2009 09:23 PM
Can you update so it can auto show Thread Thumbnail on VBADVANCED

vBB-vietnam 12-04-2009 03:22 AM
Quote:
Originally Posted by phkk (Post 1919160)
Can you update so it can auto show Thread Thumbnail on VBADVANCED
yes. i need it too :(
can you help me

spmatrix 12-04-2009 08:33 AM
Problem with attachment
Please help !!!!

Database error in vBulletin 3.8.4:

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.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, MIN(attachment.attachmentid) AS attachmentid, post.pagetext AS previewbbcode
FROM thread AS thread
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 attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
WHERE thread.threadid IN (0,2466,2505,2469,2468,2465,2464,2463,2296,2295,22 94)
ORDER BY sticky DESC, lastpost DESC;

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
Request Date : Friday, December 4th 2009 @ 12:26:18 PM
Error Date : Friday, December 4th 2009 @ 12:26:18 PM
Script : http://www.my.gr/forum/forumdisplay.php?f=195
Referrer : http://www.my.gr/forum/f195/%CE%9A%C...-2-a-2465.html
IP Address : 7.252.53
Username : T
Classname : vB_Database
MySQL Version : 5.0.45-log

SoloX 12-04-2009 02:01 PM
Hi,
I have a large forum as well. How can I modify the following to process threads from one particular forum only?

Quote:
Originally Posted by tlwwolfseye (Post 1914466)
The previous quote didn't let me put the Code in I had in my post one page before. Here again the Code of the Error.

Code:
<?php $STEP_AMOUNT = 600; ?>

<input type="button" id="btnNext" value="Process Next Results" onClick="window.location='?start='+(<?php echo $_GET["start"]; ?>+<?php echo $STEP_AMOUNT;?>)" disabled=true><br>
The button above should enable once this batch is complete!<br>
<br>

<?php
error_reporting(E_ALL & ~E_NOTICE & ~8192);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('SKIP_SESSIONCREATE', 1);
define('NOCOOKIES', 1);
define('THIS_SCRIPT', 'xupdate');
define('CSRF_PROTECTION', true);

// #################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array();

// pre-cache templates used by all actions
$globaltemplates = array();

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

if (!$_GET["start"]) { $_GET["start"] = 0; }


        $threads = $db->query_read_slave("
        SELECT *
        FROM " . TABLE_PREFIX . "thread
        LIMIT ".$db->escape_string($_GET["start"]).",". $db->escape_string($_GET["start"]+$STEP_AMOUNT));

while ($thread = $db->fetch_array($threads)){
    echo "<b>Thread:</b> ".$thread["title"]."<br>";

    $posts = $db->query_read_slave("SELECT * FROM `" . TABLE_PREFIX . "post` WHERE `postid` = '".$thread["firstpostid"]."'");
    $post = $db->fetch_array($posts);
    echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <b>First Post:</b> ".$post["title"]."<br>";
preg_match('/\[img\](.*?)\[\/img\]/i',$post["pagetext"],$matches);
$query = "UPDATE `" . TABLE_PREFIX . "thread` set `thumbnailurl` = '".$db->escape_string($matches[1])."' WHERE threadid = " . $thread["threadid"];
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <b>SQL:</b>".$query."<br><br>";
$db->query_write($query);

}
?>

<script> document.getElementById("btnNext").disabled = false; </script>

VBUsers 12-04-2009 03:25 PM
when i add this mod i only get 1 thread per page with the image from the first attachment. i did the manual and auto edits to test it out and its doing the same thing.

let me know the steps to fix this and its a great mod for my forum. hopefully we can get it fixed.

SoloX 12-04-2009 05:51 PM
Quote:
Originally Posted by SoloX (Post 1925243)
Hi,
I have a large forum as well. How can I modify the following to process threads from one particular forum only?
I changed
PHP Code:
FROM " . TABLE_PREFIX . "thread 
to

PHP Code:
FROM " . TABLE_PREFIX . "thread where forumid='14' 
where 14 was my target forum. This way I will only do the forums I need. Maybe useful for larger boards.

SoloX 12-04-2009 06:02 PM
Strange.
My test board worked fine but in production version I am getting the error reported by others:
Quote:
MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

SoloX 12-04-2009 06:04 PM
Ohh! I had set it to attachments and possibly I have attachments disabled. :D .. I set it to first image and all is gud in my land. loving it.

SoloX 12-04-2009 07:37 PM
Q folks:
If I have another image tag, say MEDIA, can I do the following?

PHP Code:
preg_match('/\[(img|MEDIA|IMG)\]\s*(https?:\/\/([^*\r\n]+|[a-z0-9\/\\\._\- !]+))\[\/(img|MEDIA|IMG)\]/', $edit['message'], $matches); 
Is there anything else I have to do to read those images?

SoloX 12-05-2009 03:00 AM
If you have RSS posts going to a forum like I do, you will have to do this:
in includes/cron/rssposter.php find
PHP Code:
$threadactiontime = (($feed['threadactiondelay'] > 0) ? (TIMENOW + $feed['threadactiondelay']  * 3600) : 0); 
right under it, put
PHP Code:
$pat = '/\[IMG\](.*?)\[\/IMG\]/i';
preg_match($pat,$pagetext,$matches);
$thumburl = escape_string($matches[1]);
$itemdata->set('thumbnailurl', $thumburl); 

vBB-vietnam 12-05-2009 06:03 PM
Can you update so it can auto show Thread Thumbnail on VBADVANCED

gantonr 12-05-2009 11:14 PM
ok i installed and get this when set to first attachment
Code:
Database error in vBulletin 3.8.4:

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.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
                        thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
                        thread.prefixid, thread.taglist, hiddencount, deletedcount
                        , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
                       
                        , threadredirect.expires
                        , MIN(attachment.attachmentid) AS attachmentid
                FROM vbf_thread AS thread
                        LEFT JOIN vbf_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
                        LEFT JOIN vbf_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
                       
                        LEFT JOIN vbf_post AS post ON(post.postid = thread.firstpostid)
                       
                        LEFT JOIN vbf_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
                        LEFT JOIN vbf_attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
                WHERE thread.threadid IN (0,17)
                ORDER BY sticky DESC, lastpost DESC;

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
Request Date  : Sunday, December 6th 2009 @ 12:39:28 AM
Error Date    : Sunday, December 6th 2009 @ 12:39:28 AM
IP Address    : 95.132.62.79
Username      : admin
Classname    : vB_Database
MySQL Version : 5.0.51a-24+lenny2+spu1-log
it seems common problem? ;-) how i get rid of it? if you can please simple and step by step ;-)

cheers, Tong.

VBUsers 12-07-2009 06:56 AM
Quote:
Originally Posted by VBUsers (Post 1925281)
when i add this mod i only get 1 thread per page with the image from the first attachment. i did the manual and auto edits to test it out and its doing the same thing.

let me know the steps to fix this and its a great mod for my forum. hopefully we can get it fixed.

anyone on this issue?

SoloX 12-07-2009 02:02 PM
^ check your HTML edits. You are missing either a TD or TR tag.

mykkal 12-08-2009 06:47 AM
This is cool... Question for the creator of the mod. is it possible to be able to define the images for the members?

Just curious...I want to use the mod. I just don't want them to be able to choose any type of image.

Gotta keep control, ya know. This is a really nice mod that could be abused badly.


All times are GMT. The time now is 03:42 AM.
Page 5 of 9 « First 34 5 67 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.01570 seconds
  • Memory Usage 1,865KB
  • 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
  • (5)bbcode_php_printable
  • (13)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