[3.2][DEV] Ultimate Teams

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!
Scam Warning
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)
User avatar
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

[3.2][DEV] Ultimate Teams

Post by posey » Thu Dec 07, 2017 2:34 pm

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
Extension Download: Direct download
        • root/ext/mrgoldy/ultimateteams/readme.md
Last edited by posey on Mon Dec 11, 2017 1:25 pm, edited 3 times in total.
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
Froddelaar
Registered User
Posts: 503
Joined: Tue Mar 29, 2016 3:45 am
Location: Aalst (Belgium)
Name: Andy Dm
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by Froddelaar » Thu Dec 07, 2017 4:32 pm

Will this also show up in JV Arcade?
Would be great for my team challenges ! :D :D
I'm A Stupid F*ck.. And Proud Of it!
Download +34.000 arcade extension games @ ~ https://www.froddelpower.be ~

Dutch Extension Translations @ https://github.com/Solidjeuh
Donations are always welcome @ https://www.froddelpower.be/donation

User avatar
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [3.2][DEV] Ultimate Teams

Post by posey » Thu Dec 07, 2017 4:47 pm

Probably not, as I have no access to that extension, so I can't have a look at it.
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
eunaumtenhoid
Registered User
Posts: 603
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid » Thu Dec 07, 2017 8:51 pm

amazing, nice work
congratulations^^
compatible with utimate points?
My translations of the extensions for Brazilian Portuguese
https://github.com/phpBBTraducoes

User avatar
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [3.2][DEV] Ultimate Teams

Post by posey » Thu Dec 07, 2017 9:03 pm

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?
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
eunaumtenhoid
Registered User
Posts: 603
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid » Thu Dec 07, 2017 9:32 pm

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: 705
Joined: Fri Sep 05, 2014 6:48 am
Location: The Netherlands
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by dmzx » Fri Dec 08, 2017 2:06 pm

Nice to see you back again ;)
dmzx-web.net - Need a Host? - Want to Donate

User avatar
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [3.2][DEV] Ultimate Teams

Post by posey » Sat Dec 09, 2017 11:00 am

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.
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
3Di
Registered User
Posts: 11864
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milano - Frankfurt
Name: Marco
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by 3Di » Sat Dec 09, 2017 4:25 pm

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. :)
Want to compensate me for my interest? Donate
Please PM me only to request paid works. Thx.
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 » Sun Dec 10, 2017 12:35 am

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
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [3.2][DEV] Ultimate Teams

Post by posey » Sun Dec 10, 2017 4:37 pm

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.
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
«THÖMÅS®©»
Registered User
Posts: 504
Joined: Sun Feb 27, 2011 5:38 pm
Location: UK
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by «THÖMÅS®©» » Mon Dec 11, 2017 2:13 am

@ 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 is 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
posey
Registered User
Posts: 545
Joined: Tue Oct 06, 2009 7:34 pm
Location: The Netherlands
Name: Gijs

Re: [3.2][DEV] Ultimate Teams

Post by posey » Mon Dec 11, 2017 1:19 pm

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
Ultimate Extensions:
Image Ultimate Blog (coming soon)
Image Ultimate Teams

''I'm pretty sure there's a lot more to life than being really, really, ridiculously good looking. And I plan on finding out what that is.''

User avatar
eunaumtenhoid
Registered User
Posts: 603
Joined: Wed Jun 03, 2009 12:46 am
Location: ????

Re: [3.2][DEV] Ultimate Teams

Post by eunaumtenhoid » Mon Dec 11, 2017 8:55 pm

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: 504
Joined: Sun Feb 27, 2011 5:38 pm
Location: UK
Contact:

Re: [3.2][DEV] Ultimate Teams

Post by «THÖMÅS®©» » Mon Dec 11, 2017 11:20 pm

@ 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 is an equal and opposite reaction". - Sir Isaac Newton
"In honor there is hope" - Alaska State Troopers

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

Post Reply

Return to “Extensions in Development”

Who is online

Users browsing this forum: posey, takufner and 31 guests