[ABD] Ultimate Teams

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
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

[ABD] Ultimate Teams

Post by mrgoldy »

Extension Name: Ultimate Teams
Author: posey (vendor name: mrgoldy)

Extension Repository: GitHub Repo & GitHub Pages
Extension Version: 1.0.0
Requirements: phpBB 3.2.x
This phpBB 3.2.x extension will allow users to create teams. They can upload a team image (logo), set the team's website, location and type: open | request | closed (similar to groups). The team tag will be displayed infront of their username on the Viewtopic page. Membership functions (joining, leaving, inviting, promoting, demoting, etc..) is fully ajaxified.
Screenshots:To do list:
  • Notifications
  • Teams list ordering
  • Teams list pagination
  • Detailed viewonline
  • Space between Team Tag and Username
  • Team tag before username on Index and Forum / Topic list
  • Make team default
  • PM to team
  • Ultimate Points integration
Extension Download: Direct download
        • root/ext/mrgoldy/ultimateteams/readme.md
Last edited by mrgoldy on Mon Dec 18, 2017 10:20 pm, edited 5 times in total.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
</Solidjeuh>
Registered User
Posts: 1788
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by </Solidjeuh> »

Will this also show up in JV Arcade?
Would be great for my team challenges ! :D :D
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by mrgoldy »

Probably not, as I have no access to that extension, so I can't have a look at it.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
eunaumtenhoid
Registered User
Posts: 1007
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid »

amazing, nice work
congratulations^^
compatible with utimate points?
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by mrgoldy »

I have been out of it for quite a while - understatement - and dmzx maintained Ultimate Points (deep bow).
So I haven't looked at that extensions code for a long time.

But once again, what has to be 'compatible' with Ultimate Points? What's the overlap between the two extensions?
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
eunaumtenhoid
Registered User
Posts: 1007
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid »

pay for create team for example
users of team gain more points

UPDATE:
I tested it's fantastic
add:
more info about team; creation date, team moderators (leaders), sub-mod

in Teams page could show every team with your photo
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
dmzx
Registered User
Posts: 853
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by dmzx »

Nice to see you back again ;)
Contact me on dmzx-web.net
Buy me a beer Donate and try binance.com or try CentOS Web Panel
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by mrgoldy »

Download link and GitHub repository have been added.
WIll look into integration with Ultimate Points.
JV-Arcade will not be an option, I tried registering twice over there, still doesn't work. So I'm done with that.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
3Di
I've Been Banned!
Posts: 17538
Joined: Mon Apr 04, 2005 11:09 pm
Location: I'm with Ukraine 🇺🇦
Name: Marco
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by 3Di »

Gijs, may I suggest you to offer versioned downloads instead and use the master branch just for your own needs? ;) And a direct link to the repo as well would be interesting, thanks. :)
🆓 Free support for our extensions also provided here: phpBB Studio
🚀 Looking for a specific feature or alternative option? We will rock you!
Please PM me only to request paid works. Thx. Buy me a coffee -> Image
My development's activity º PhpStorm's proud user º Extensions, Scripts, MOD porting, Update/Upgrades
etericelf
Registered User
Posts: 1
Joined: Sun Dec 10, 2017 12:25 am

Re: [3.2][DEV] Ultimate Teams

Post by etericelf »

Hello Posey!

MySQL(i) 5.7.19 / PHP 7.1.9 / PhpBB 3.2.1
Same thing with MySQL 5.7.19 / PHP 5.6.31 / PhpBB 3.2.1

Trying to enable the extension in ACP.

Code: Select all

General Error
SQL ERROR [ mysqli ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT '' NOT NULL, team_image varchar(100) DEFAULT '' NOT NULL, team_webs' at line 8 [1064]

SQL

CREATE TABLE sm_ut_teams ( team_id mediumint(8) UNSIGNED NOT NULL auto_increment, team_type smallint(4) UNSIGNED DEFAULT '2' NOT NULL, team_name varchar(255) DEFAULT '' NOT NULL, team_tag varchar(20) DEFAULT '' NOT NULL, team_tag_clean varchar(20) DEFAULT '' NOT NULL, team_colour varchar(6) DEFAULT '' NOT NULL, team_description DEFAULT '' NOT NULL, team_image varchar(100) DEFAULT '' NOT NULL, team_website varchar(200) DEFAULT '' NOT NULL, team_location varchar(100) DEFAULT '' NOT NULL, PRIMARY KEY (team_id) ) CHARACTER SET `utf8` COLLATE `utf8_bin`;

BACKTRACE

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

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

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

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

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 444
CALL: phpbb\db\tools\tools->_sql_run_sql()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 489
CALL: phpbb\db\tools\tools->sql_create_table()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/ext/mrgoldy/ultimateteams/ext.php
LINE: 42
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 190
CALL: mrgoldy\ultimateteams\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 209
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

FILE: [ROOT]/adm/index.php
LINE: 82
CALL: p_master->load_active()
Thank you!
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by mrgoldy »

Ah yeah, sorry about that.

Fixed Line 37 from the install_user_schema.php migration. Changed it from VARCHAR:255 to TEXT_UNI.
VARCHAR:255 is not a viable database type, which should of been VCHAR:255 in the first place.
But TEXT_UNI is a better choice for what I'm after with the team description.

Pushed fix to GitHub.
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
«THÖMÅS®©»
Registered User
Posts: 542
Joined: Sun Feb 27, 2011 5:38 pm
Location: UK
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by «THÖMÅS®©» »

@ posey... When I enable this ext, I get this error...

Code: Select all

General Error
Index name 'phpbb_ut_correlation_team_leader' on table 'phpbb_ut_correlation' is too long. The maximum is 30 characters.

BACKTRACE

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

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1561
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 1515
CALL: phpbb\db\tools\tools->check_index_name_length()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 430
CALL: phpbb\db\tools\tools->sql_create_index()

FILE: [ROOT]/phpbb/db/tools/tools.php
LINE: 489
CALL: phpbb\db\tools\tools->sql_create_table()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\tools\tools->perform_schema_changes()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 711
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 658
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 400
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: [ROOT]/phpbb/extension/base.php
LINE: 78
CALL: phpbb\db\migrator->update()

FILE: [ROOT]/ext/mrgoldy/ultimateteams/ext.php
LINE: 42
CALL: phpbb\extension\base->enable_step()

FILE: [ROOT]/phpbb/extension/manager.php
LINE: 185
CALL: mrgoldy\ultimateteams\ext->enable_step()

FILE: [ROOT]/includes/acp/acp_extensions.php
LINE: 197
CALL: phpbb\extension\manager->enable_step()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: acp_extensions->main()

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

Would this help you diagnose this issue?
“No, this trick won't work... How on earth are you ever going to explain in terms of chemistry and physics so important a biological phenomenon as first love?” - Albert Einstein
"For every action has an equal and opposite reaction". - Sir Isaac Newton
"In honor there is hope" - Alaska State Troopers

Owner & President @ =DN= Dark Nexus Multi-Gaming Clan
User avatar
mrgoldy
Former Team Member
Posts: 1394
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by mrgoldy »

Alright, learning new things everytime. It's saying the field / name for the team leader column in the correlation table is too long. It's containing 32 characters, and only 30 are allowed.

I am thinking of updating the table name, so instead of correlation it will say corr, that's probably the easiest way.
This will however mean you will have to disable the extension, delete the data and enable it again.
Seeing it's still in development phase and a main table name, I'm not going to write a seperate migration for it.

Update
Okay, pushed to GitHub.
  • Disable the extension
  • Delete the data
  • Add the new files (or download from github, paste it and overwrite)
  • Enable extension
phpBB Studio / Member of the Studio

Contributing: You can do it too! Including testing Pull Requests (PR).
phpBB Development and Testing made easy.
User avatar
eunaumtenhoid
Registered User
Posts: 1007
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid »

nice
looking forward to RC version
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes
User avatar
«THÖMÅS®©»
Registered User
Posts: 542
Joined: Sun Feb 27, 2011 5:38 pm
Location: UK
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by «THÖMÅS®©» »

@ posey, I cannot not me delete the data, keeps giving me a 500 error...

Also, could I get a link to download from "GitHub" please posey?

**EDIT**

I figured it out...

If I may make a suggestion, could I add that you could make some minor tweaks to make it so you can add more customisation's, for example the use of BBCode in the team name or something similar? Also might want to use a selector or drop down menu to be able to select weather the tag is displayed on the left or right of ones username. Also, I may suggest linking this extension to be integrated with "Groups" as well so that when added to a group, it adds you to a team as well that is linked to that group. Another suggestion, make it so that there is no space between the tag that is added and the username. And finally, make it so that the tag is displayed in the forum index and the thread list inside forums too.

Also, thank you Posey, this extension is awesome and I cannot wait until it's final release with all the tweaks both I and other members of this board have suggested integrated.
“No, this trick won't work... How on earth are you ever going to explain in terms of chemistry and physics so important a biological phenomenon as first love?” - Albert Einstein
"For every action has an equal and opposite reaction". - Sir Isaac Newton
"In honor there is hope" - Alaska State Troopers

Owner & President @ =DN= Dark Nexus Multi-Gaming Clan
Locked

Return to “Abandoned Extensions”