[PAID] clan profile and match statistics mod

[Rav33n]

This is a request I've seen a few times on the boards but never in proper detail. I'm hoping someone will take this on since a lot of people will benefit

Functionality

Create Clan/Team profile page

An admin or member should be able to create a page dedicated to an e-sports team.

Team Name: [text field]

Team tag: [text field]

Games played: [checkboxes]
game list (possibly predefined in an admin page for this mod)

Members: [text field] similar to the moderator field for boards. The first name in the list will be made leader of the clan. Maybe if its not too complicated, a ranking system for each member... but lets keep it simple.

About: memo field

Clan logo: upload field, maybe allowing a 200x200 image?

Clan header image: upload field, allowing a 500x100 image which will be displayed on the profile page

Alternatively, this could be a public form where clans can create their own profile pages. But upon submission it is put into an "unapproved" group where an admin will have to take a look and approve it for public access.

Profile page mockup attached.

Reporting match results

Won: dropdown box with registered clans
Lost: dropdown box with registered clans

Game: dropdown box with list of games

Number of maps/games played: text field

Map/game 1 result
team 1 score [text field] | team 2 score  [text field]
[checkbox] overtime? (checking it makes another textfield visible
team 1 OT score [text field] | team 2 OT score  [text field]
Refereed by: [text field]
Upload screenshot

Map/game 2 result
team 1 score [text field] | team 2 score  [text field]
[checkbox] overtime? (checking it makes another textfield visible
team 1 OT score [text field] | team 2 OT score  [text field]
Refereed by: [text field]
Upload screenshot

....

Map/game X result
team 1 score [text field] | team 2 score  [text field]
[checkbox] overtime? (checking it makes another textfield visible
team 1 OT score [text field] | team 2 OT score  [text field]
Refereed by: [text field]
Upload screenshot

This will update each clans profile page with the matches results.

Database

The tables were put together by JPDeni over at the TinyPortal boards.

Table: teams
------------
team_id (autoincrement)
team_name
team_tag
game_types
about
logo
header
approved


Table: team_members
-------------------
team_member_id (autoincrement)
team_id (relates to teams table)
member_name (repeats value from smf_members table for speed in retrieval)
member_id (relates to smf_members table)
ranking


Table: team_matches
-------------------
team_match_id (autoincrement)
game_type
number_of_games_played
winner (relates to teams table)
winner_based_on


Table: team_match_games
-----------------------
team_match_games_id (autoincrement)
team_match_id (relates to team_matches table)
referee_id (relates to smf_members table)
referee_name (repeats value from smf_members table for speed in retrieval and in case it's not a member)
screenshot
game_match_order


Table: team_game_scores
-----------------------
team_game_score_id (autoincrement)
team_match_games_id (relates to team_match_games table)
team_id (relates to teams table)
score
ot_score

[Goudreault]

looks like an awesome idea!  Sort of like a slimmed down replacement for a full clan management addon.

[Rav33n]

looks like an awesome idea!  Sort of like a slimmed down replacement for a full clan management addon.

I have actually put together a similar functionality list for a full knockout tournament system, but didn't post it since I was doubtful anyone would take it on for free .

[Futbolero90]

SMF really needs a mod like this! even phpBB has one, i hope somebody can do it =(

[Hitwalker]

looks like a good idea hope some 1 can make that

[iGate]

YES!!!

can we please have somebody, please please please, make such a mod. i've spent weeks convincing other clans from americas army to use smf as their forum and just when they were about to make the switch, they discovered there was now such mod for smf and remained with phpbb etc.

we desperately need a mod like this. the gaming community is HUGE and smf cannot tap into it because it doesn't offer a mod that ALL clans want.
the only reason my clan has stayed with smf is because i have a great members who enter and format the data manually - (as well as the fact that it's comparatively safe)

if someone could make this MUCH REQUESTED mod it would be VERY MUCH APPRECIATED.

thanks
iGate


PS: thanks rav33n for pm'ing me on this issue.

[improv]

In my opinion it would be awesome if SMF had this kind of mod.
For the moment we may only find stand alone scripts and stuff like that yet many gaming clans (like mine) is using smf.
Introducing a mod like this would be great for the gaming community and bring a new dimension towards smf.

I am willing to support this mod in different ways if this mod is taken on.

[zach21uk]

I would like to have a mod like this as well and I would even be willing to put some money into getting a system like this done.

I would like to establish a clan directory for my community and have pages for each clan with information about them, members lists, link to their website, etc.

Seems like this would be perfect!

[Christian Otto]

Like told in the discussion on tinyportal, I think it would be a great idea. I don't know if we would need some more specs to manage a more general cover of gametypes, eg. more than two teams on an match, ...
Am currently working on my bachelor thesis but afterwards I would like to help on this, with my knowledge of many different types of games and their needs of a script like this and on doing some work in php, mysql, ... (But haven't done any TP/SMF-AddOn untill now).

And one thing we should think about is:
- Is this thing better done for SMF or TP?

Besides the clan war management system vwar is having a relaunch after 3 years! The version 1.7.0 will be released soon (currently in closed beta test). So another possibility would be a bridge for this system. But I would prefer a clean solution on SMF/TP!

[TheMortician4]

YES!!!

can we please have somebody, please please please, make such a mod. i've spent weeks convincing other clans from americas army to use smf as their forum and just when they were about to make the switch, they discovered there was now such mod for smf and remained with phpbb etc.

we desperately need a mod like this. the gaming community is HUGE and smf cannot tap into it because it doesn't offer a mod that ALL clans want.
the only reason my clan has stayed with smf is because i have a great members who enter and format the data manually - (as well as the fact that it's comparatively safe)

if someone could make this MUCH REQUESTED mod it would be VERY MUCH APPRECIATED.

thanks
iGate


PS: thanks rav33n for pm'ing me on this issue.

I agree...!!! SOCOM clan leaders would love to have this mod, I am one, and there are hundreds upon hundreds of us that would love to have a mod like this.  That would enable us to really bring the SOCOM community into SMF in a huge way...!!!

See http://www.HHHbrotherhood.com, http://www.BBIClan.com, http://Unresolvedconflict.net for just a few.

[Rav33n]

Good to see some support for this, though there hasn't been any response from developers.

Would anyone like to give this a shot? Alternatively, a bunch of us who have some knowledge of SMF/PHP can collaborate on this. If a developer hasn't picked this up in the next few weeks, I'll start a development thread where we can give this a shot ourselves.

[n-joy]

Yea, This would be REALLY AWESOME!

[I JaR oF JaM I]

Yep, this would be an awesome mod.

[zapiy]

Well i am willing to donate some cash to get this rolling??

I guess $10 - $20 each might get a developer on board?

[Rav33n]

Well i am willing to donate some cash to get this rolling??

I guess $10 - $20 each might get a developer on board?

Great. I'll pitch in too. I changed topic title to "PAID". Hope it gets picked up.

[iGate]

i think we're starting to ask for too much. many developers have been "scared off" because of its size.
lets just keep it simple.

[improv]

Maybe we should start it ourselves, using the money to find help and support.
Only if we start, we should do it step by step.

[SkyLineR34]

ya this is a really awesome idea....coming up with a layout is a small contribute to whoever is going to write this type of mod....I see that the tournament mod was created which i suggested a long time ago...just to remember that these guys who create mods are also busy with other ones also.  If you guys are just patient enough it will eventually come around...and probably bigger and better than what is already out there with phpbb or vb and such.

[improv]

Well, where should we start if we get started?

[I JaR oF JaM I]

Seems like no one is willing to make this even though it'd be paid for... Unfortunate... =(