Page 1 of 4

[ABD] Ultimate Teams

Posted: Thu Dec 07, 2017 2:34 pm
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

Re: [3.2][DEV] Ultimate Teams

Posted: Thu Dec 07, 2017 4:32 pm
by </Solidjeuh>
Will this also show up in JV Arcade?
Would be great for my team challenges ! :D :D

Re: [3.2][DEV] Ultimate Teams

Posted: Thu Dec 07, 2017 4:47 pm
by mrgoldy
Probably not, as I have no access to that extension, so I can't have a look at it.

Re: [3.2][DEV] Ultimate Teams

Posted: Thu Dec 07, 2017 8:51 pm
by eunaumtenhoid
amazing, nice work
congratulations^^
compatible with utimate points?

Re: [3.2][DEV] Ultimate Teams

Posted: Thu Dec 07, 2017 9:03 pm
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?

Re: [3.2][DEV] Ultimate Teams

Posted: Thu Dec 07, 2017 9:32 pm
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

Re: [3.2][DEV] Ultimate Teams

Posted: Fri Dec 08, 2017 2:06 pm
by dmzx
Nice to see you back again ;)

Re: [3.2][DEV] Ultimate Teams

Posted: Sat Dec 09, 2017 11:00 am
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.

Re: [3.2][DEV] Ultimate Teams

Posted: Sat Dec 09, 2017 4:25 pm
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. :)

Re: [3.2][DEV] Ultimate Teams

Posted: Sun Dec 10, 2017 12:35 am
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!

Re: [3.2][DEV] Ultimate Teams

Posted: Sun Dec 10, 2017 4:37 pm
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.

Re: [3.2][DEV] Ultimate Teams

Posted: Mon Dec 11, 2017 2:13 am
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?

Re: [3.2][DEV] Ultimate Teams

Posted: Mon Dec 11, 2017 1:19 pm
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

Re: [3.2][DEV] Ultimate Teams

Posted: Mon Dec 11, 2017 8:55 pm
by eunaumtenhoid
nice
looking forward to RC version

Re: [3.2][DEV] Ultimate Teams

Posted: Mon Dec 11, 2017 11:20 pm
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.