vb.org Archive - Major Additions - Tournaments, Ladders & Leagues Manager v4.x

Superb work again Thanks!

Bananalive would there be any chance we could get a system for the match finder that would give members a random game to play,So when there is any more then 2 players on a singles ladder looking for games the system would auto match them up.I would be more then happy to Donate any amount needed for your work on this as this mod is becoming a Great!!!

LichtMann

04-22-2011 11:43 PM

I have two suggestions for next version:

1. The possibility to add moderators for each competition, not for the whole system.

2. The possibility to edit the Rules for each competition, not for the whole system.

Do you think it will be possible?

hossgher

04-24-2011 02:34 PM

hey mate, receiving the following error after upgrading to 4.3.9 from 4.2.6, any idea what i can do?

Quote:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Unknown column 'ladders.league' in 'on clause'
Error Number : 1054
Request Date : Sunday, April 24th 2011 @ 09:27:58 AM
Error Date : Sunday, April 24th 2011 @ 09:27:58 AM
Script : http://www.teamichor.net/tournaments.php

i read earlier that this was fixed in 4.3.8, is there a hotfix that i can apply to 4.3.9? thanks in advance!

bananalive

04-24-2011 02:47 PM

1 Attachment(s)

Quote:

Originally Posted by hossgher (Post 2188125)

hey mate, receiving the following error after upgrading to 4.3.9 from 4.2.6, any idea what i can do?

i read earlier that this was fixed in 4.3.8, is there a hotfix that i can apply to 4.3.9? thanks in advance!

You may be missing some columns in your mysql forum database. Did you import the v4.3.9 product file without any errors?

Try importing attached file.

hossgher

04-24-2011 03:07 PM

thanks mate it worked a treat, appreciate your prompt reply and love your work!

Gamelobby

04-25-2011 05:57 PM

When i go to "League List"

Code:

/ladders.php?showonly=leagues

It shows ladder categories. (is that the correct way it works.?)

I fully understand Ladders, & Tournaments, but the "Seasons", & "Leagues" are really confusing.

Also i think description should go back up to the title area rather than down beloew in a tab. imo

.

stwan

04-26-2011 03:36 PM

Quote:

Originally Posted by bananalive (Post 2187015)

2. Is this just since an upgrade to vbulletin v4.1.3? or did it not show on vbulletin v4.1.2?

Do not know, I've noticed this bug only in 4.1.3

bananalive

04-27-2011 02:08 PM

Quote:

Originally Posted by Gamelobby (Post 2188548)

When i go to "League List"

Code:

/ladders.php?showonly=leagues

It shows ladder categories. (is that the correct way it works.?)

Yes.

Quote:

I fully understand Ladders, & Tournaments, but the "Seasons", & "Leagues" are really confusing.

Seasons - allow you to link ladders/leagues together. So if you run the same ladder each month, then you can contain them all in a seasons group. Then the previous ladders are easier to find. Seasons are completely optional.

Leagues are similar to ladders, apart from players/teams cannot choose how they play, instead they are allocated an opponent.

Quote:

Also i think description should go back up to the title area rather than down beloew in a tab. imo

It's an option in vBulletin Options:

Ladder Description as Tab
Tournament Description as Tab

ProFifaLeagues

04-28-2011 09:19 AM

I have just noticed that some match reports comments dont appear to show up after making them on ladder matches any ideas???

It just says No comments yet...

All times are GMT. The time now is 07:46 PM.

Page 88 of 229

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04434 seconds Memory Usage 1,746KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: