[3.2][3.3][RC] AI Labs with Midjourney, ChatGPT, DALL-E, Gemini, Gemini Vision and Stable Diffusion support

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Post Reply
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

[3.2][3.3][RC] AI Labs with Midjourney, ChatGPT, DALL-E, Gemini, Gemini Vision and Stable Diffusion support

Post by privet.fun »

Extension Name: AI Labs

Author: privet.fun

Extension Description:
Incorporate AI into your phpBB board and get ready for an exciting experience.
Currently supported Midjourney, ChatGPT and DALL-E (OpenAI), Gemini and Gemini Vision (Google), Stable Diffusion (Stability AI).

Extension Version: 1.0.8 (March 10, 2024)

Requirements:
PHP >= 7.4
phpBB >= 3.2

Version: 1.0.8 (March 10, 2024) changelog release:
- Added support for Gemini and Gemini Vision by Google
- Added support for Simple mentions phpBB extension version 2.x

Demo URLs:
Midjourney v6 quoted text prompt (December 26, 2023)
Midjourney (added October 1, 2023)
Gemini (added March 10, 2024)
Gemini Vision (added March 10, 2024)
ChatGPT (updated October 1, 2023)
ChatGPT, custom prompt
DALL-E
Stable Diffusion
Stable Diffusion by Leonardo AI, coming soon 🚀 also available as Telegram bot https://t.me/stable_diffusion_superbot

Extension Download: https://github.com/privet-fun/phpbb_ailabs
Last edited by privet.fun on Mon Mar 11, 2024 2:09 am, edited 12 times in total.
User avatar
Miri4ever
Registered User
Posts: 608
Joined: Sat Mar 07, 2015 11:18 am
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by Miri4ever »

Code: Select all

Table 'Forum.phpbblt_forums' doesn't exist [1146]
It does not use users table prefix. I was able to fix this error inside ACP_CONTROLLER.PHP

But not I got: Unable to locate user xxx, Regardless of what user I pick up inside of this. After some tests, I found out something is blocking this. I not sure what extension it will be. I needed to shut down all for adding my already Main BOT for this extension.

Likewise, I can call them via mention yes, and there is a message coming up AI is thinking. But there is no reply yet. However, I noticed the linking for the name display of my AI is wrong. This might result in this not working correctly.

The AI Profile is linked to: http://webpage.de/memberlist... but it should correctly look like this: http://webpage.de/subforum/memberlist....
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
Thank you
Registered User
Posts: 22
Joined: Mon Apr 17, 2023 6:07 pm

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by Thank you »

q.jpg
q.jpg (32.84 KiB) Viewed 4142 times

Hello, How can i add the "user replied" function on my board?
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

Miri4ever wrote: Mon May 29, 2023 10:07 am...
Miri4ever, I fixed all reported issues, can you please give it another try?
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

Thank you wrote: Mon May 29, 2023 7:36 pm Hello, How can i add the "user replied" function on my board?
AI Labs extension maintains cross-linked list of replies to track progress and such, that code is not all that complex
User avatar
stone23
Registered User
Posts: 177
Joined: Sat Nov 02, 2019 4:44 pm
Location: France

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by stone23 »

Hello,
There are apparently a lot of missing language keys in the translation files...
I am French and there are many gaps, even on the English language files...
encreuse.net
Forum version : 3.3.11
php version : 8.2.10

Excuse my English, I'm French...
User avatar
ssl
Registered User
Posts: 1606
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by ssl »

I did not notice any problem in the French translation regarding the language keys

Capture d’écran 2023-05-30 à 22.21.14.png
Sorry for my English ... I do my best!

phpBB: 3.3.11 | PHP: 8.2.16
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
User avatar
stone23
Registered User
Posts: 177
Joined: Sat Nov 02, 2019 4:44 pm
Location: France

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by stone23 »

My bad, I had an untranslated language file... :oops:
encreuse.net
Forum version : 3.3.11
php version : 8.2.10

Excuse my English, I'm French...
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

ssl & stone23 - thank you guys for trying extension!
Any word of advice/suggestions?
Which version of php/phpBB/SQL you've used?

As far as translation goes all user facing / ACP stuff should be trasnslated.
There's log feature (shown as tiny document icon to admins and moderators only) - that one is not translated, I added it to help with debugging troubleshooting so folks can send me logs if needed, naturally I'd prefer it in english hence it is not trsanslated :)
User avatar
Miri4ever
Registered User
Posts: 608
Joined: Sat Mar 07, 2015 11:18 am
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by Miri4ever »

Code: Select all

Unable to locate user xx
It still doesn't work adding a member if all my extensions running and what result still this error. It only works if this AI is the only running program. If a user has been added, settings could be changed without problems. Adding users of the search user function works fine inside my forum, so I am not certain why something stops this inside this extension.

Can those Bots reply even on locked topics if they have moderator rights? Or complete locked forums?

Did they conflict with the Chatbot AI extension? Has anybody made some tests?

I use for now all 3 BOT the same key. Did this result trouble and need one for each? The issue at my testing board if anything is disabled everything works fine. But it's something different from getting things running in a safe environment. Did Spambots Blockers block out this AI their selves?

And if I click at this AI is thinking Username it still redirects to: http://forum.de/memberlist... as to use my subfolder prefix http://forum.de/forum/memberlist...
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
stone23
Registered User
Posts: 177
Joined: Sat Nov 02, 2019 4:44 pm
Location: France

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by stone23 »

privet.fun wrote: Wed May 31, 2023 3:54 pm ssl & stone23 - thank you guys for trying extension!
Any word of advice/suggestions?
When I create a configuration and I activate it I have a general error on all forums of my forum:
ScreenShot077.jpg
encreuse.net
Forum version : 3.3.11
php version : 8.2.10

Excuse my English, I'm French...
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

Miri4ever wrote: Wed May 31, 2023 4:54 pm

Code: Select all

Unable to locate user xx
It still doesn't work adding a member if all my extensions running and what result still this error. It only works if this AI is the only running program. If a user has been added, settings could be changed without problems. Adding users of the search user function works fine inside my forum, so I am not certain why something stops this inside this extension.
Does the xx correctly reflect name of the user you selected?
What if you type/copy&paste user name?

Here's actual code where user_id by located by username:

Code: Select all

	protected function find_user_id($username)
	{
		$user_id = null;
		if (!empty($username)) {
			$where = ['username' => $username];
			$sql = 'SELECT user_id FROM ' . USERS_TABLE . ' WHERE ' . $this->db->sql_build_array('SELECT', $where);
			$result = $this->db->sql_query($sql);
			$row = $this->db->sql_fetchrow($result);
			if (!empty($row) && !empty($row['user_id']))
				$user_id = $row['user_id'];
			$this->db->sql_freeresult($result);
		}
		return $user_id;
	}
Any chance you can try another user of perhaps try to run query

Code: Select all

SELECT user_id FROM <YOUR_USERS_TABLE>  WHERE  username="<your_user_name>"
and see what's coming back?
Miri4ever wrote: Wed May 31, 2023 4:54 pm Can those Bots reply even on locked topics if they have moderator rights? Or complete locked forums?
If you can quote AI bot in locked topic it will reply, that would be my guess.
There's no rights attached this action - it simply replies to posts where it is mentioned/quoted or when new post created (if you configured bot to reply to new posts).
Miri4ever wrote: Wed May 31, 2023 4:54 pm I use for now all 3 BOT the same key. Did this result trouble and need one for each? The issue at my testing board if anything is disabled everything works fine. But it's something different from getting things running in a safe environment. Did Spambots Blockers block out this AI their selves?
Are you referring to OpenAI keys?
If so that should be fine, OpenAI does not have any restrictions based on keys - your either have valid key and can user their API or you don't.
Miri4ever wrote: Wed May 31, 2023 4:54 pm And if I click at this AI is thinking Username it still redirects to: http://forum.de/memberlist... as to use my subfolder prefix http://forum.de/forum/memberlist...
That's the bug, thank you for reporting, I'll fix it.
User avatar
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

stone23 wrote: Wed May 31, 2023 6:28 pm
privet.fun wrote: Wed May 31, 2023 3:54 pm ssl & stone23 - thank you guys for trying extension!
Any word of advice/suggestions?
When I create a configuration and I activate it I have a general error on all forums of my forum:

ScreenShot077.jpg
AI Labs extension does not have queries like that, I'm 100% sure about that.
Can't quite explain why you have _ailabs_users table there.

Error you seeing coming from devspace/forumsubs extension, not from privet/ailabs.
Perhaps try to reinstall and clear cache?
User avatar
Miri4ever
Registered User
Posts: 608
Joined: Sat Mar 07, 2015 11:18 am
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by Miri4ever »

I always use select username and then pick up the name from the display member list, from already both running AI. I don't need to input any name. If I select it from member list it should work. But as I told if I shut down all extensions of the board and create the AI, then it's fine. I can also modify and edit them later without trouble, it only the thing to pick up the name for creation.

That why I ask can a lot of spam and robot protection tools shut down this AI or keep it stop creating new users? Because I got the reply AI is thinking, and it remains inside this topic and never doing any kind of progress.

@stone23: I saw the same error with that username thing when opening an ACP Module for one extension, but it was not the Chat Bot one for. For my Registration Age gives me this kind of error. I am uncertain if this is something to do with your problem as well, or if you got this entry inside the user table to appear to be wrong.

Ok some Update: This SQL give me the correct result. Typing the username says the user already exists. But the system has trouble with upper and lowercase. PHPBB has no issue with upper / lowercase usernames being typed in. But if I open the search user tab, and it displays me the member list. I selected the name from the memberlist, and it's the same, but it did not type in manually. Then this error user does not exist coming up.

The name the same and upper lower case totally the same, but it was not pick up for some reason from select from the member list if some extensions running.
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
privet.fun
Registered User
Posts: 54
Joined: Sun May 07, 2023 8:46 pm
Contact:

Re: [3.2][3.3][RC] AI Labs with ChatGPT, DALL-E (OpenAI) and Stable Diffusion (Stability AI) support

Post by privet.fun »

I just released 1.0.3 https://github.com/privet-fun/phpbb_ailabs with multiple fixes (changelog), please give it a try.
Last edited by privet.fun on Thu Jun 01, 2023 9:42 pm, edited 1 time in total.
Post Reply

Return to “Extensions in Development”