phpBB • Free and Open Source Forum Software

There is nothing simple about notifications!! See - https://area51.phpbb.com/docs/dev/3.2.x/extensions/tutorial_notifications.html Why is it not this simple That is question we have been asking for years I see :shock: Think I'll pass on the notifications bit then. Too much faff lol. Hopefully it wi...

Hi, Been trying to figure out how to send a user a notification but everything I've looked at has driven my mind insane. Looks like you need to create another file in a "notification" folder and use several bits of code between files to do it. Isn't there just a simple class or anything, s...

I'd like guests to be able to view images in my posts but not be able to download files but the only option/permission I can find is "Can download files" but that also disables images from showing in posts. Is there a file type permission somewhere? I'm not sure why "Can download file...

Perfect. Thank you so much.

I'm trying to change the class in the avatar HTML but I'm stuck and can't get it to work. I have: 'core.get_avatar_after' => 'avatar_change', public function avatar_change($event) { $ava_data = $event['html']; $ava_data = str_replace('avatar', 'newavatar', $ava_data); $event['html'] = $ava_data; } W...

Hi

In phpbb language files if you have something like:
How do I go about replacing %1$s with whatever text I need to replace it with before showing it in template?

I can't find how its done.

Thank you

Without seeing your code and what you are trying to do it is impossible to say. A link to your GitHub would be a start. Bascially its just this in the template: <!-- INCLUDE overall_header.html --> <!-- INCLUDE posting_buttons.html --> <form id="postform" method="post" action=&q...

Hi, I've managed to get a form in my extension with the BBCodes displaying above it, they are working but its not showing my custom BBcodes. Also when I hover over the buttons it shows the "title" popup as "BBCODE_B_HELP" instead of "Bold Text". Is there something I nee...

Hi, I've been running my site for nearly 12 years now and over the years the database has had fields and tables added for loads of mods. Mods which were removed many moons ago but left their database changes behind. There used to be a tool that did a database clean-up and removed all the junk fields...

You create another migration file that has a depends_on() function in it that checks that the first migration has been run. So say I made a file called "scheme_data_v2" I would use this code in it to add new data: class scheme_data_v2 extends \phpbb\db\migration\migration { static public ...

Hi, Just another quick question regarding the schema file. I know how to add configs in the file under: public function update_data() That works fine. But how to I add new configs to my extension once the extension is installed and running? The only way I can get it to work is by uninstalling the ex...

kasimi wrote: ↑Sat Feb 06, 2021 12:49 pm The query I posted should return only distinct users. Can you post your code?

I had the query part wrong. This code worked perfectly.

Thank you so much

My bad, left join won't work. You should run two separate queries: first the post data, then the user data. For the user data you can use the user_loader service: $sql_ary = [ 'SELECT' => 'p.post_id, MIN(p.post_time), p.topic_id, p.poster_id', 'FROM' => [POSTS_TABLE => 'p'], 'WHERE' => 'p.topic_id ...

Don't cross join. Only select from USERS_TABLE and left join the POSTS_TABLE. How does one do that please? I'm new to these queries. david63 suggestion didn't work. This is the code I have: $sql_ary = array( 'SELECT' => 'u.username, u.user_id, p.post_id, p.post_time, p.topic_id, p.poster_id', 'FROM...

Hi, I have this query which gets all the members usernames who have posted in a topic: $sql_ary = array( 'SELECT' => 'u.username, u.user_id, p.post_id, p.post_time, p.topic_id, p.poster_id', 'FROM' => array( USERS_TABLE => 'u', POSTS_TABLE => 'p', ), 'WHERE' => 'u.user_id = p.poster_id AND p.topic_i...