[ABD] Images from posts

[Miri4ever]

Still having the problem some forums display images and the other half of the forum does not. I'm only having one forum on ignore list so all other forums should display it, but doing not. I'm always searching if there somewhere permissions inside the forum to set witch allowed to display images and witch not, but there isn't something like this.

Also restarted the exentsion but still nothing on the forum who still missing display images. Don't know what to try else.

[Galixte de EzCom]

Hi Anvar,

Is it possible to keep the ratio for pictures in portrait ?

[Fast_Eddie]

Hello, just wondering if anyone has noticed a increase load on your server with this ext.?

[Galixte de EzCom]

Hi,

not for me except during the creation of thumbnails.

[rrbailey89]

There seems to be a limit to the amount of forums that are ignorable. I got this message when trying to limit forums images should not be displayed from.

Code: Select all

General Error
SQL ERROR [ mysqli ]

Data too long for column 'config_value' at row 1 [1406]

SQL

UPDATE jcp_config SET config_value = '21,23,208,137,270,7,237,258,238,239,241,246,247,248,249,250,242,243,251,252,253,254,255,256,257,9,10,8,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,126,48,49,50,51,52,53,127,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,146,147,148,70,71,72,73,74,75,76,77,78,271,262,263,264,267,22,24,25' WHERE config_name = 'last_images_attachment_ignore'

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 148
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/config/db.php
LINE: 122
CALL: phpbb\config\db->set_atomic()

FILE: [ROOT]/includes/functions.php
LINE: 162
CALL: phpbb\config\db->set()

FILE: [ROOT]/ext/bb3mobi/imgposts/acp/imgposts_module.php
LINE: 240
CALL: set_config()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: bb3mobi\imgposts\acp\imgposts_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Also it does not display images from gallery even when that setting is set.

[Galixte de EzCom]

Hi,

Fantastic extension - thanks

It would be great if there was an ACP option to exclude reply photos from the carousels
i.e. add the following to helper.php function last_images

Code: Select all

AND p.post_id = t.topic_first_post_id

and also in helper.php function last_images_attachment

Code: Select all

AND t.topic_first_post_id = a.post_msg_id

So that the carousel only displays the photo attachments from the first post within each topic

could you explain to us, the exact modification that we have to do to obtain the displaying only for the image from the first post of topics, please 

[HillClimb]

OK, my previous note was written for the extension author Anvar.

But if you'd like to make the same modification, hopefully Anvar will incorporate this change in to another version in future, he is all you need to do
In \ext\bb3mobi\imgposts\core\helper.php, around line 100, find the sql query that retrieves the image paths

Code: Select all

		$sql = 'SELECT p.post_id, p.topic_id, p.forum_id, p.post_text, p.post_subject, p.post_time, t.topic_id, t.topic_title
			FROM ' . POSTS_TABLE . ' p
			LEFT JOIN ' . TOPICS_TABLE . ' t ON t.topic_id = p.topic_id
			WHERE post_text '. $this->db->sql_like_expression($this->db->get_any_char() . $chars . $this->db->get_any_char()) . '
			' . $sql_where . '
			' . $sql_where_forbidden . '
			' . $sql_where_topic . '
			' . $sql_forum . '
			AND p.post_visibility = 1
			ORDER BY p.post_time DESC';

And replace all of the above, with this:

Code: Select all

		$sql = 'SELECT p.post_id, p.topic_id, p.forum_id, p.post_text, p.post_subject, p.post_time, t.topic_id, t.topic_title
			FROM ' . POSTS_TABLE . ' p
			LEFT JOIN ' . TOPICS_TABLE . ' t ON t.topic_id = p.topic_id
			WHERE post_text '. $this->db->sql_like_expression($this->db->get_any_char() . $chars . $this->db->get_any_char()) . '
			' . $sql_where . '
			' . $sql_where_forbidden . '
			' . $sql_where_topic . '
			' . $sql_forum . '
			AND p.post_visibility = 1
			AND p.post_id = t.topic_first_post_id
			ORDER BY p.post_time DESC';

And again around line 250, find this SQL query:

Code: Select all

			$sql = 'SELECT a.attach_id, a.post_msg_id, a.physical_filename, a.real_filename, a.extension, a.filetime, t.topic_title
			FROM ' . ATTACHMENTS_TABLE . ' a, ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
				' . $sql_where . '
				AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")
				AND a.topic_id = t.topic_id
				GROUP BY a.post_msg_id DESC';

And replace all of this 2nd query with:

Code: Select all

			$sql = 'SELECT a.attach_id, a.post_msg_id, a.physical_filename, a.real_filename, a.extension, a.filetime, t.topic_title
			FROM ' . ATTACHMENTS_TABLE . ' a, ' . FORUMS_TABLE . ' f, ' . TOPICS_TABLE . ' t
				' . $sql_where . '
				AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif")
				AND a.topic_id = t.topic_id
				AND t.topic_first_post_id = a.post_msg_id
				GROUP BY a.post_msg_id DESC';

That is it - just added a one new line to each of the SQL queries that limits the selection of images shown so that it only ever shows the images from the original topic post rather than replies etc - good luck

[Mess]

Thanks for sharing HillClimb.

[Galixte de EzCom]

Thanks to HillClimb.

[[email protected]]

Thanks to HillClimb, + Update version..

[koraldon]

Hi,
Installed it on my forum and works great, however it appears images do not update. What do I need to do?

Also, it seems to only recognize images in the first post, and not all images from a thread. Is it possible to make this an ACP selection?

[Galixte de EzCom]

Hi,

revert those changes to display all images: viewtopic.php?p=14194301&sid=08c7403cad ... #p14194301.

[girello]

i have this error with new version:

Code: Select all

Errore Generale
SQL ERROR [ mysql4 ]

Query execution was interrupted [1317]

SQL

SELECT a.attach_id, a.post_msg_id, a.extension, p.post_id, p.topic_id, p.post_time, p.post_visibility FROM phpbb_attachments a, phpbb_posts p, phpbb_topics t WHERE a.post_msg_id = p.post_id AND (mimetype = "image/jpeg" OR mimetype = "image/png" OR mimetype = "image/gif") AND p.post_visibility = 1 GROUP BY a.post_msg_id DESC LIMIT 9 

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/ext/bb3mobi/imgposts/core/helper.php
LINE: 485
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/bb3mobi/imgposts/cron/task/tidy_images.php
LINE: 78
CALL: bb3mobi\imgposts\core\helper->clear_cache()

FILE: [ROOT]/ext/bb3mobi/imgposts/cron/task/tidy_images.php
LINE: 71
CALL: bb3mobi\imgposts\cron\task\tidy_images->cron_tidy_images()

FILE: [ROOT]/phpbb/cron/task/wrapper.php
LINE: 65
CALL: bb3mobi\imgposts\cron\task\tidy_images->should_run()

FILE: [ROOT]/phpbb/cron/manager.php
LINE: 79
CALL: phpbb\cron\task\wrapper->is_ready()

FILE: [ROOT]/includes/functions.php
LINE: 5386
CALL: phpbb\cron\manager->find_one_ready_task()

FILE: [ROOT]/index.php
LINE: 207
CALL: page_footer()

hi anvaral i have again this problem with last release and i only can use 1.02 version.
Hi have disabled, clear cache, leave installation folder and install 1.05 but problem again.
Can help me pls?
tnx

[ouiouiphoto]

Hello

Very nice extension. Use it on my forum with Subway theme. ALl is ok except for the button next and previous. They dont show. I have search in the code and it seems that the

<a id="prev" href="#" class="button2" title="Previous" >«</a>

By

<a id="prev" href="#" class="button2 hidden" title="Previous" style="display: none;">«</a>

ANy idea where i could search for. If i ask the guy of Subway he will answer me that the extension is in beta and he don't support it.

So i take any idea

[bttan]

hi, needs the ability to grab script picture. It is too tedious to upload picture attachment for every post.