[ABD] Images from posts

Any abandoned Extensions will be moved to this forum.

WARNING: Extensions in this forum are not currently being supported or maintained by the original Extension author. Proceed at your own risk.
Forum rules
IMPORTANT: Extension Development Forum rules

WARNING: Extensions in this forum are not currently being supported nor updated by the original Extension author. Proceed at your own risk.
User avatar
Miri4ever
Registered User
Posts: 618
Joined: Sat Mar 07, 2015 11:18 am

Re: [BETA] Images from posts

Post by 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.
Homepage: Terra Oceanica

Extension Developments:
PHPBB Games Solitaire, MChat Poker, MChat Black Jack, MChat Cards, MChat Trivia
PHPBB Special Effects, Mousepointers, X-Mas Themes and Designs for PBWoW Style.
Supported work: (**New Updated** UCP Sidebar), Tables, Hide, PBWow3 Style
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.

Re: [BETA] Images from posts

Post by Galixte de EzCom »

Hi Anvar,

Is it possible to keep the ratio for pictures in portrait ?
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
User avatar
Fast_Eddie
Registered User
Posts: 260
Joined: Tue Jun 09, 2015 8:32 pm
Name: Ed

Re: [BETA] Images from posts

Post by Fast_Eddie »

Hello, just wondering if anyone has noticed a increase load on your server with this ext.?
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.

Re: [BETA] Images from posts

Post by Galixte de EzCom »

Hi,

not for me except during the creation of thumbnails.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
rrbailey89
Registered User
Posts: 248
Joined: Fri Oct 24, 2014 3:00 pm

Re: [BETA] Images from posts

Post by 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.
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.

Re: [BETA] Images from posts

Post by Galixte de EzCom »

Hi,
HillClimb wrote: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 
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
HillClimb
Registered User
Posts: 7
Joined: Thu Mar 27, 2014 4:08 am

Re: [BETA] Images from posts

Post by 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
User avatar
Mess
Registered User
Posts: 985
Joined: Wed Jul 01, 2009 6:37 am
Name: Kim

Re: [BETA] Images from posts

Post by Mess »

Thanks for sharing HillClimb. :)
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.

Re: [BETA] Images from posts

Post by Galixte de EzCom »

Thanks to HillClimb. ;)
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
User avatar
[email protected]
Registered User
Posts: 191
Joined: Sun Sep 15, 2013 11:49 am
Location: bb3.mobi
Name: Anvar Stybaev

Re: [BETA] Images from posts

Post by [email protected] »

Thanks to HillClimb, + Update version..
[DEV/Beta] More extensions

Hopefully Google correctly translate my text// I do not support in private messages!
koraldon
Registered User
Posts: 530
Joined: Sat Jun 30, 2007 12:42 pm

Re: [BETA] Images from posts

Post by 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?
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.

Re: [BETA] Images from posts

Post by Galixte de EzCom »

Hi,

revert those changes to display all images: viewtopic.php?p=14194301&sid=08c7403cad ... #p14194301.
Communau EzCom
📖 « Traductions d’extensions & styles pour phpBB 3.2.x & 3.3.x ».
📋 Lists of all extensions identified for phpBB 3.1.x & 3.2.x.
📋 Lists of all styles identified for phpBB 3.1.x & 3.2.x.
Image Tu as un forum et tu veux aussi un site web ? Regarde par ici.
User avatar
girello
Registered User
Posts: 169
Joined: Tue Mar 30, 2010 8:53 am
Location: italia

Re: [BETA] Images from posts

Post by girello »

girello wrote: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
User avatar
ouiouiphoto
Registered User
Posts: 91
Joined: Mon Jun 15, 2015 5:30 am

Re: [BETA] Images from posts

Post by 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
Registered User
Posts: 83
Joined: Mon Feb 16, 2015 4:37 pm

Re: [BETA] Images from posts

Post by bttan »

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

Return to “Abandoned Extensions”