Your fucking browser doesn't support JavaScript, so you can't post here.
VBsupport перешел с домена .ORG на родной .RU
Ура!
Пожалуйста, обновите свои закладки - VBsupport.ru
Блок РКН снят, форум доступен на всей территории России, включая новые терртории, без VPN
На форуме введена премодерация ВСЕХ новых пользователей
for English speaking users:
Уважаемые пользователи!
На форуме открыт новый раздел "
Каталог фрилансеров "
и отдельный раздел для платных заказов "
Куплю/Закажу "
Если вы хотите приобрести какой то скрипт/продукт/хак из каталогов перечисленных ниже:
Каталог модулей/хаков
Ещё раз обращаем Ваше внимание: всё, что Вы скачиваете и устанавливаете на свой форум, Вы устанавливаете исключительно на свой страх и риск.Убедительная просьба : при обнаружении уязвимостей или сомнительных кодов обязательно отписывайтесь в теме хака/стиля
12-07-2009, 08:54 PM
Простоузер
Join Date: Oct 2009
Posts: 15
Версия vB: 3.8.x
Reputation:
Novice 1
Репутация в разделе: 1
Thread Thumbnails - first attachment
0
установил мод
http://www.vbulletin.org/forum/showthread.php?t=214755
при выборе первого прикрепленного изоражения для отображения
появляется такой код ошибки
при других вариантах всё нормально, но надо именно первый атач.
помогите пожалуйста
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.
Yandex Bot
12-07-2009, 11:24 PM
k0t
Join Date: May 2005
Location: localhost
Posts: 28,711
Версия vB: 3.8.x
Пол:
Reputation:
Гуру 20257
Репутация в разделе: 8432
Quote:
Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
помимо сортировки, нужно еще обязатеное группирование:
GROUP BY tablename.fieldname
12-08-2009, 02:02 AM
Простоузер
Join Date: Oct 2009
Posts: 15
Версия vB: 3.8.x
Reputation:
Novice 1
Репутация в разделе: 1
Kerk спасибо
извините если я не понял
вот код этого продукта, куда надо вставить группирование?
спасибо
извините если по ламерски
Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<product productid="thread_thumbnails" active="1">
<title>Thread Thumbnails</title>
<description>Add a thumbnail to threads from a URL.</description>
<version>2.0.0</version>
<url />
<versioncheckurl />
<dependencies>
</dependencies>
<codes>
<code version="1.0.0">
<installcode><![CDATA[$db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD thumbnailurl varchar(250) NOT NULL");]]></installcode>
<uninstallcode><![CDATA[$vbulletin->db->query_write("ALTER TABLE `". TABLE_PREFIX ."thread` DROP `thumbnailurl`"); ]]></uninstallcode>
</code>
</codes>
<templates>
</templates>
<plugins>
<plugin active="1" executionorder="5">
<title>Edit Post - Show Text Box?</title>
<hookname>editpost_start</hookname>
<phpcode><![CDATA[$showthumbnailedit = false;
if (($vbulletin->options['thread_thumbnails_active'] == '1') && ($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0') && ($postinfo['postid'] == $threadinfo['firstpostid']))
{
if ($vbulletin->options['thread_thumbnails_forum_list'] && $vbulletin->options['thread_thumbnails_forum_list'] != "") {
$forumsallowed = explode(",", $vbulletin->options['thread_thumbnails_forum_list']);
if (in_array($foruminfo['forumid'], $forumsallowed))
{
$showthumbnailedit = true;
}
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Edit Post - Update Start</title>
<hookname>editpost_update_start</hookname>
<phpcode><![CDATA[if ($postinfo['postid'] == $threadinfo['firstpostid'])
{
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$vbulletin->input->clean_gpc('p', 'thumbnailurl', TYPE_STR);
$edit['thumbnailurl'] =& $vbulletin->GPC['thumbnailurl'];
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Edit Post - Update Thumbnail</title>
<hookname>editpost_update_thread</hookname>
<phpcode><![CDATA[if ($vbulletin->options['thread_thumbnails_active'] == '1')
{
$thumbnail = '';
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$vbulletin->input->clean_gpc('p', 'desc_adv_thumb', TYPE_BOOL);
if ($postinfo['postid'] == $threadinfo['firstpostid'] AND $vbulletin->GPC['desc_adv_thumb'])
{
$thumbnail = $db->escape_string(htmlspecialchars_uni($edit['thumbnailurl']));
}
}
else if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '2')
{
preg_match('/\[(img|IMG)\]\s*(https?:\/\/([^*\r\n]+|[a-z0-9\/\\\._\- !]+))\[\/(img|IMG)\]/', $edit['message'], $matches);
$thumbnail = $matches[2];
}
if($thumbnail != '')
{
$threadman->setr('thumbnailurl', $thumbnail);
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Forum Display - Query</title>
<hookname>forumdisplay_query</hookname>
<phpcode><![CDATA[$dothumbnail = false;
if((THIS_SCRIPT == 'forumdisplay') && ($vbulletin->options['thread_thumbnails_active'] == '1')){
if ($vbulletin->options['thread_thumbnails_forum_list'] && $vbulletin->options['thread_thumbnails_forum_list'] != "") {
$forumsallowed = explode(",", $vbulletin->options['thread_thumbnails_forum_list']);
if (in_array($foruminfo['forumid'], $forumsallowed))
{
$dothumbnail = true;
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '1')
{
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))";
$hook_query_fields .= ", MIN(attachment.attachmentid) AS attachmentid";
}
else
{
$hook_query_fields .= ", thread.thumbnailurl AS thumbnailurl";
}
}
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Global - Auto Template Edits</title>
<hookname>global_start</hookname>
<phpcode><![CDATA[if (($vbulletin->options['thread_thumbnails_active'] == '1') && ($vbulletin->options['thread_thumbnails_auto_template_edits'] == '1')) {
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$s = "<!-- / subject field -->";
$append = '<if condition=\"$isfirstpost AND $showthumbnailedit\">
<if condition=\"$vbulletin->GPC[advanced]\">
<input type=\"hidden\" name=\"desc_adv_thumb\" value=\"1\" />
</if>
<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"margin-bottom:$stylevar[formspacer]px\">
<tr>
<td class=\"smallfont\" colspan=\"3\">Thumbnail URL:</td>
</tr>
<tr>
<td><input type=\"text\" class=\"bginput\" name=\"thumbnailurl\" value=\"$threadinfo[thumbnailurl]\" size=\"50\" maxlength=\"250\" tabindex=\"1.5\" title=\"\" /></td>
</tr>
</table>
</if>';
$vbulletin->templatecache["editpost"] = str_replace( $s, $s.$append, $vbulletin->templatecache["editpost"] );
$append = '<if condition=\"$showthumbnailedit\"><table cellpadding=\"0\" cellspacing=\"0\" border=\"0\" style=\"margin-bottom:$stylevar[formspacer]px\"><tr><td class=\"smallfont\" colspan=\"3\">Thumbnail URL:</td></tr><tr><td><input type=\"text\" class=\"bginput\" name=\"thumbnailurl\" value=\"$threadinfo[thumbnailurl]\" size=\"50\" maxlength=\"250\" tabindex=\"1.5\" title=\"\" /></td></tr></table></if> ';
$vbulletin->templatecache["newthread"] = str_replace( $s, $s.$append, $vbulletin->templatecache["newthread"] );
}
$find = '".(($show[\'threadicons\']) ? ("
<td class=\"alt2\">".(($show[\'threadicon\']) ? ("<img src=\"$thread[threadiconpath]\" alt=\"$thread[threadicontitle]\" border=\"0\" />") : (" "))."</td>
") : (""))."';
$replace = '".(($show[threadicons]) ? ("
<td class=\"alt2\" align=\"center\" valign=\"middle\">
".(($thread[thumbnaildisplay] AND (($vbulletin->options[thread_thumbnails_sticky] == \'1\') OR !$thread[sticky])) ? ("
<a href=\"showthread.php?" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . "t=$thread[threadid]\">
<img src=\"$thread[thumbnailurl]\" alt=\"\" border=\"0\" width=\"$thread[thumbnailwidth]\"/>
</a>
") : ("
".(($show[threadicon]) ? ("
<img src=\"$thread[threadiconpath]\" alt=\"$thread[threadicontitle]\" border=\"0\" />
") : (""))."
"))."
</td>
") : (""))."';
$vbulletin->templatecache["threadbit"] = str_replace( $find, $replace, $vbulletin->templatecache["threadbit"] );
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>New Thread - Save Thumbnail, Datamanager</title>
<hookname>newpost_process</hookname>
<phpcode><![CDATA[if ($type == 'thread')
{
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$dataman->setr('thumbnailurl', htmlspecialchars_uni($post['thumbnailurl']));
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>New Thread - Get Thumbnail From Textbox</title>
<hookname>newthread_post_start</hookname>
<phpcode><![CDATA[if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$vbulletin->input->clean_gpc('p', 'thumbnailurl', TYPE_STR);
$newpost['thumbnailurl'] =& $vbulletin->GPC['thumbnailurl'];
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>New Thread - Show Text Box?</title>
<hookname>newthread_start</hookname>
<phpcode><![CDATA[$showthumbnailedit = false;
if ($vbulletin->options['thread_thumbnails_active'] == '1')
{
if ($vbulletin->options['thread_thumbnails_forum_list'] && $vbulletin->options['thread_thumbnails_forum_list'] != "") {
$forumsallowed = explode(",", $vbulletin->options['thread_thumbnails_forum_list']);
if (in_array($foruminfo['forumid'], $forumsallowed))
{
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '0')
{
$showthumbnailedit = true;
}
}
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Search - Query</title>
<hookname>search_results_query_threads</hookname>
<phpcode><![CDATA[if((THIS_SCRIPT == 'search') && ($vbulletin->options['thread_thumbnails_active'] == '1') && ($vbulletin->options['thread_thumbnails_search'] == '1')){
$hook_query_fields .= ", thread.thumbnailurl AS thumbnailurl";
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Search - Query (Tag Search)</title>
<hookname>tags_list_query_data</hookname>
<phpcode><![CDATA[if((THIS_SCRIPT == 'tags') && ($vbulletin->options['thread_thumbnails_active'] == '1') && ($vbulletin->options['thread_thumbnails_search'] == '1')){
$hook_query_fields .= ", thread.thumbnailurl AS thumbnailurl";
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Forum Display - Threadbit Display</title>
<hookname>threadbit_display</hookname>
<phpcode><![CDATA[if($dothumbnail)
{
$thread['thumbnaildisplay'] = true;
$thread['thumbnailwidth'] = $vbulletin->options['thread_thumbnails_thumbnail_width'];
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '1')
{
$thread['thumbnailurl'] = "attachment.php?attachmentid=".$thread[attachmentid]."&stc=1&thumb=1";
}
if (!$thread['thumbnailurl'] || $thread['thumbnailurl'] == "")
{
if($vbulletin->options['thread_thumbnails_no_thumbnail'] == "")
{
$thread['thumbnaildisplay'] = false;
}
else
{
$thread['thumbnailwidth'] = $vbulletin->options['thread_thumbnails_no_thumbnail_width'];
$thread['thumbnailurl'] = $vbulletin->options['thread_thumbnails_no_thumbnail'];
}
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>Search - Set Thumbnail</title>
<hookname>threadbit_process</hookname>
<phpcode><![CDATA[if((THIS_SCRIPT == 'tags' || THIS_SCRIPT == 'search') && ($vbulletin->options['thread_thumbnails_active'] == '1') && ($vbulletin->options['thread_thumbnails_search'] == '1')){
if ($vbulletin->options['thread_thumbnails_forum_list'] && $vbulletin->options['thread_thumbnails_forum_list'] != "") {
$forumsallowed = explode(",", $vbulletin->options['thread_thumbnails_forum_list']);
if (in_array($thread['forumid'], $forumsallowed))
{
$thread['thumbnaildisplay'] = true;
$thread['thumbnailwidth'] = $vbulletin->options['thread_thumbnails_thumbnail_width'];
if($vbulletin->options['thread_thumbnails_thumbnail_source'] == '1')
{
$thread['thumbnailurl'] = "attachment.php?attachmentid=".$thread[attachmentid]."&stc=1&thumb=1";
}
if (!$thread['thumbnailurl'] || $thread['thumbnailurl'] == "")
{
if($vbulletin->options['thread_thumbnails_no_thumbnail'] == "")
{
$thread['thumbnaildisplay'] = false;
}
else
{
$thread['thumbnailwidth'] = $vbulletin->options['thread_thumbnails_no_thumbnail_width'];
$thread['thumbnailurl'] = $vbulletin->options['thread_thumbnails_no_thumbnail'];
}
}
}
}
}]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>New Thread - Datamanager Valid Fields (Thread)</title>
<hookname>threaddata_start</hookname>
<phpcode><![CDATA[$this->validfields['thumbnailurl'] = array(TYPE_STR, REQ_NO);]]></phpcode>
</plugin>
<plugin active="1" executionorder="5">
<title>New Thread - Datamanager Valid Fields (First Post)</title>
<hookname>threadfpdata_start</hookname>
<phpcode><![CDATA[$this->validfields['thumbnailurl'] = array(TYPE_STR, REQ_NO);]]></phpcode>
</plugin>
<plugin active="0" executionorder="5">
<title>Update Thread - Save Thumbnail (Not Supported Yet)</title>
<hookname>threadmanage_update</hookname>
<phpcode><![CDATA[//$vbulletin->input->clean_gpc('p', 'thumbnailurl', TYPE_STR);
//$threadman->setr('thumbnailurl', htmlspecialchars_uni($vbulletin->GPC['thumbnailurl']));]]></phpcode>
</plugin>
</plugins>
<phrases>
<phrasetype name="vBulletin Settings" fieldname="vbsettings">
<phrase name="setting_thread_thumbnails_active_desc" date="0" username="" version=""><![CDATA[Turn Thread Thumbnails On]]></phrase>
<phrase name="setting_thread_thumbnails_active_title" date="0" username="" version=""><![CDATA[Thread Thumbnails Active?]]></phrase>
<phrase name="setting_thread_thumbnails_auto_template_edits_desc" date="1254151717" username="Null Parameter" version="2.0.0"><![CDATA[Enable this to have the template edits done automatically.<br/><br/><b>If you have heavily modified templates, this may not function correctly and you will need to make the template edits manually.</b><br/><br/><i>If you disable this option, you will need to do these edits manually to get this mod to work correctly.</i>]]></phrase>
<phrase name="setting_thread_thumbnails_auto_template_edits_title" date="1254151717" username="Null Parameter" version="2.0.0"><![CDATA[Automatic Template Edits]]></phrase>
<phrase name="setting_thread_thumbnails_forum_list_desc" date="0" username="" version=""><![CDATA[Comma separated list of what forumids thumbnails should be shown in.]]></phrase>
<phrase name="setting_thread_thumbnails_forum_list_title" date="0" username="" version=""><![CDATA[Show in what forums?]]></phrase>
<phrase name="setting_thread_thumbnails_no_thumbnail_desc" date="1254157953" username="Null Parameter" version="2.0.0"><![CDATA[Path of the image file to display if no thumbnail is available.<br/><br/><i>Leave blank to use the status icon if no thumbnail is present.</i>]]></phrase>
<phrase name="setting_thread_thumbnails_no_thumbnail_title" date="1254157953" username="Null Parameter" version="2.0.0"><![CDATA[No Thumbnail Image]]></phrase>
<phrase name="setting_thread_thumbnails_no_thumbnail_width_desc" date="1254157960" username="Null Parameter" version="2.0.0"><![CDATA[Width of the No Thumbnail Image<br><br><i>Leave Blank to use the actual image width.</i>]]></phrase>
<phrase name="setting_thread_thumbnails_no_thumbnail_width_title" date="1254157960" username="Null Parameter" version="2.0.0"><![CDATA[No Thumbnail Image Width]]></phrase>
<phrase name="setting_thread_thumbnails_search_desc" date="1254157900" username="Null Parameter" version="2.0.0"><![CDATA[Show Thumbnails in Search and Tag Search.]]></phrase>
<phrase name="setting_thread_thumbnails_search_title" date="1254157900" username="Null Parameter" version="2.0.0"><![CDATA[Thumbnail in Search]]></phrase>
<phrase name="setting_thread_thumbnails_sticky_desc" date="0" username="" version=""><![CDATA[If you disable this option, Thumbnails will not appear on Sticky Threads.]]></phrase>
<phrase name="setting_thread_thumbnails_sticky_title" date="0" username="" version=""><![CDATA[Thumbnails on Sticky Threads?]]></phrase>
<phrase name="setting_thread_thumbnails_thumbnail_source_desc" date="0" username="" version=""><![CDATA[Where should thumbnails be specified?<br/><br/><b>User Entered URL:</b> When creating or editing a thread, the user can specify the URL of an external image to use as the thumbnail.<br/><b>First Attachment:</b> If the user adds an attachment to the thread, the first image attachment will be used as the thumbnail.<br/<b>First Image In Post:</b> If the user adds an image into their post, via [IMG] tags, then the first image in the post will be used as the thumbnail.]]></phrase>
<phrase name="setting_thread_thumbnails_thumbnail_source_title" date="0" username="" version=""><![CDATA[Thumbnail Source]]></phrase>
<phrase name="setting_thread_thumbnails_thumbnail_width_desc" date="1254157946" username="Null Parameter" version="2.0.0"><![CDATA[Width of the Thumbnails<br><br><i>Leave Blank to use the actual image width.</i>]]></phrase>
<phrase name="setting_thread_thumbnails_thumbnail_width_title" date="1254157946" username="Null Parameter" version="2.0.0"><![CDATA[Thumbnail Width]]></phrase>
<phrase name="settinggroup_thread_thumbnails" date="0" username="" version=""><![CDATA[Thread Thumbnails Options]]></phrase>
</phrasetype>
</phrases>
<options>
<settinggroup name="thread_thumbnails" displayorder="1102">
<setting varname="thread_thumbnails_active" displayorder="1">
<datatype>boolean</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="thread_thumbnails_auto_template_edits" displayorder="2">
<datatype>boolean</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="thread_thumbnails_forum_list" displayorder="3">
<datatype>free</datatype>
</setting>
<setting varname="thread_thumbnails_thumbnail_source" displayorder="4">
<datatype>free</datatype>
<optioncode>select:piped
0|User Entered URL
1|First Attachment
2|First Image In Post</optioncode>
<defaultvalue>0</defaultvalue>
</setting>
<setting varname="thread_thumbnails_sticky" displayorder="4">
<datatype>boolean</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="thread_thumbnails_search" displayorder="5">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="thread_thumbnails_thumbnail_width" displayorder="6">
<datatype>free</datatype>
</setting>
<setting varname="thread_thumbnails_no_thumbnail" displayorder="7">
<datatype>free</datatype>
</setting>
<setting varname="thread_thumbnails_no_thumbnail_width" displayorder="8">
<datatype>free</datatype>
</setting>
</settinggroup>
</options>
<helptopics>
</helptopics>
<cronentries>
</cronentries>
<faqentries>
</faqentries>
</product>
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
All times are GMT +4. The time now is 08:43 PM .
Thread Thumbnails - first attachment
вот код этого продукта, куда надо вставить группирование? 
