[ABD] User Topic Count

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.
Locked
User avatar
eunaumtenhoid
Registered User
Posts: 1007
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [ALPHA] User Topic Count

Post by eunaumtenhoid »

martti wrote:
eunaumtenhoid wrote:MANY users are with the number of topics to 0 , it's a bug? and the same has various topics
It's ALPHA. This project is on halt because lack of the right event-triggers.
but it shows the topics of some users of other non

will fix?


it is possible to add the option to select which acp forums want to show the topics

e g
I want to show somento the topics of the forum id = 27 and no more
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
back4ever
Registered User
Posts: 19
Joined: Tue Oct 04, 2016 5:52 pm

Re: [ALPHA] User Topic Count

Post by back4ever »

not possible to download more ?
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [ALPHA] User Topic Count

Post by Galixte de EzCom »

back4ever wrote:not possible to download more ?
On first post, it’s indicated: viewtopic.php?p=13890606#p13890606.
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
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

@back4ever Github was one of the sites that was victime of massive ddos attack today.

https://www.nixcraft.com/ddos-attack-ag ... t-2016/53/
User avatar
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

This extension has been updated to version 0.2.1 and uses now the strategy of recounting all the topics for a user instead of adding/substracting from previous count.
To resyncronise all the topic counts you can always disable/enable the extension.
Notice that the result number of the topics in the search page may be different due to the permissions of the current user.
User avatar
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [ALPHA] User Topic Count

Post by martti »

And the requirements are now moved to phpBB 3.2.2+, PHP 7+
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [3.2][BETA] User Topic Count

Post by Galixte de EzCom »

Thanks for this update!
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
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [3.2][BETA] User Topic Count

Post by martti »

Somebody reported an issue on enabling this extension.

Is anyone else experiencing this?
User avatar
Toxyy
Registered User
Posts: 942
Joined: Mon Oct 24, 2016 3:22 pm
Location: Namek
Contact:

Re: [3.2][BETA] User Topic Count

Post by Toxyy »

martti wrote: Sat Jun 16, 2018 6:43 am Somebody reported an issue on enabling this extension.

Is anyone else experiencing this?
That's a strange issue. It almost seems like migration didn't add the column at all.
I am a web developer/administrator, specializing in forums. If you have work you need done or are too lazy to do, pm me!

Some of my extensions:
[3.3][BETA] Post Form Templates || [3.3][BETA] Anonymous Posts || [3.2][3.3][BETA] ACP Merge Child Forums || [3.2][BETA] Sticky Ad || [3.2][DEV] User Delete Topics || [3.3][DEV] Moderate While Searching || [3.3][RC] Short Number Twig Extension
User avatar
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [3.2][BETA] User Topic Count

Post by martti »

Toxyy wrote: Sat Jun 16, 2018 8:21 am
martti wrote: Sat Jun 16, 2018 6:43 am Somebody reported an issue on enabling this extension.

Is anyone else experiencing this?
That's a strange issue. It almost seems like migration didn't add the column at all.
The error occurs in ext.php and that's were the column is add in the first step:

Code: Select all

	/**
	* @param mixed $old_state
	* @return mixed false after last step, otherwise temporary state
	*/
	public function enable_step($old_state)
	{
		$db = $this->container->get('dbal.conn');
		$posts_table = $this->container->getParameter('tables.posts');
		$topics_table = $this->container->getParameter('tables.topics');
		$users_table = $this->container->getParameter('tables.users');		

		if (!$old_state)
		{
			$db_tools = $this->container->get('dbal.tools');

			// the user_topic_count column has to be present
			$db_tools->perform_schema_changes([
				'add_columns'	=> [
					$users_table	=> [
						'user_topic_count'		=> ['UINT', 0],
					],
				],
			]);
// ...
Maybe it has something to do with a difference between MySQL and SQLite3 (what I am using). That's why I ask if anyone (with another database than me and especially MySQL or MariaDB) is experiencing this.
User avatar
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: [3.2][BETA] User Topic Count

Post by david63 »

Out of curiosity why are you adding this in ext.php and not in migration where you have the update_schema and revert_schema functions to handle this?
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [3.2][BETA] User Topic Count

Post by martti »

david63 wrote: Sat Jun 16, 2018 8:37 am Out of curiosity why are you adding this in ext.php and not in migration where you have the update_schema and revert_schema functions to handle this?
Because the "Topic Count" for all users is calculated and stored in the column when enabling the extension.
User avatar
Galixte de EzCom
Registered User
Posts: 1106
Joined: Mon Oct 04, 2004 11:14 pm
Location: France
Name: Raphaël M.
Contact:

Re: [3.2][BETA] User Topic Count

Post by Galixte de EzCom »

martti wrote: Sat Jun 16, 2018 8:42 am
david63 wrote: Sat Jun 16, 2018 8:37 am Out of curiosity why are you adding this in ext.php and not in migration where you have the update_schema and revert_schema functions to handle this?
Because the "Topic Count" for all users is calculated and stored in the column when enabling the extension.
Is the only way to resyncronise all the topic counts?
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
david63
Registered User
Posts: 20646
Joined: Thu Dec 19, 2002 8:08 am

Re: [3.2][BETA] User Topic Count

Post by david63 »

martti wrote: Sat Jun 16, 2018 8:42 am Because the "Topic Count" for all users is calculated and stored in the column when enabling the extension.
Fair enough - I was just curious
David
Remember: You only know what you know and - you don't know what you don't know!

I now no longer support any of my extensions but they will start to become available here
User avatar
martti
Registered User
Posts: 911
Joined: Thu Jul 31, 2014 8:23 am
Location: Belgium

Re: [3.2][BETA] User Topic Count

Post by martti »

Galixte de EzCom wrote: Sat Jun 16, 2018 10:45 am Is the only way to resyncronise all the topic counts?
Yes, disable and enable. But if you need to resynchronize it means something is missing in the extension.
Do you have the extension installed with MySQL/MariaDB?
Locked

Return to “Abandoned Extensions”