vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Major Additions - Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375)

Blumy 01-26-2009 12:02 AM

Quote:

Originally Posted by Stifmeister2 (Post 1724354)
Urgent: I need to be able to add more than 10 teams!!


We're playing a 16 teams (2vs2) tournament! Now it says I can only add 10 teams. :( Is it possible to add one team twice? (I guess not)

We have 2-3 different teams from one "clan"...


Go to the tournament page and you should be able to change the maximum number of teams allowed to enter a tournament. There are two buttons next to the teams allowed thing on the tournament description and you can change it by clicking the buttons.

WNxWakko 01-26-2009 12:29 PM

So any idea what could be causing the fetch ID to not work? Your previous suggestions didnt exist.

Stifmeister2 01-26-2009 04:51 PM

Quote:

Originally Posted by Blumy (Post 1724754)
Go to the tournament page and you should be able to change the maximum number of teams allowed to enter a tournament. There are two buttons next to the teams allowed thing on the tournament description and you can change it by clicking the buttons.

Yea but I can't create more than 10 teams... :(

bananalive 01-26-2009 06:37 PM

Quote:

Originally Posted by Stifmeister2 (Post 1725376)
Yea but I can't create more than 10 teams... :(

Check your usergroup options 'Maximum teams a user can create '

Gleedo 01-26-2009 07:50 PM

HI banana,

We just had the following scenario take place....

We had two players playing each other.

Player 1 had previously played 1 game prior to this match and lost it.

Player 2 had previously played 0 games.

Player 2 defeated Player 1 by 19 points to 9.

I entered their scores under the 'Admin submit Score' link.

Upon looking at the ladder table, it now says Player 1 has played 3 games (instead of 2), and has lost all 3.

:confused:

Denver Jackson 01-26-2009 10:10 PM

Any chance you can create an actual tournament with group stages and knockouts cheers

XanderZone 01-27-2009 11:53 AM

Looks like a great mod, any chance it will be updated for 3.8.x ?

bananalive 01-27-2009 02:01 PM

Quote:

Originally Posted by XanderZone (Post 1726095)
Looks like a great mod, any chance it will be updated for 3.8.x ?

It's working fine on my vb 3.8 forum

TheBoys 01-27-2009 03:19 PM

A noticed requested feature of notifications upon challanges and applications would be a great boost to an already great script.

It's the only issue we are having at the moment is that requests and such are not noticed, without checking the actual script's pages.

Stifmeister2 01-27-2009 04:46 PM

Quote:

Originally Posted by bananalive (Post 1725469)
Check your usergroup options 'Maximum teams a user can create '

Ohh the setting is there. :D I tried to find it from the wrong place... Thx. ;)

Quote:

Originally Posted by XanderZone (Post 1726095)
Looks like a great mod, any chance it will be updated for 3.8.x ?

Works on my 3.8.x. :)

Fraik 01-27-2009 05:46 PM

Getting this error when rejecting a team challenge request on the ladder:
PHP Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE tmnt_ladder_games SET accepted = -1finished 1 WHERE id=AND agree_u 0agree_u2 0score_u 0score_u2 0, AND u2 IN (1);

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1
Error Number  
1064
Request Date  
TuesdayJanuary 27th 2009 01:38:04 PM
Error Date    
TuesdayJanuary 27th 2009 01:38:05 PM
Script        
http://www.middleearthcenter.com/forums/competitions.php?do=ladderteamreject&id=3
Referrer      http://www.middleearthcenter.com/forums/competitions.php?do=ladderteamchallenges
IP Address    : *******
Username      : ******
Classname     vb_database
MySQL Version 
4.1.22-log 


Jaxel 01-27-2009 07:30 PM

Same...

PHP Code:

Database error in vBulletin 3.8.0:

Invalid SQL:
UPDATE tmnt_ladder_games SET accepted = -1finished 1 WHERE id=306 AND agree_u 0agree_u2 0score_u 0score_u2 0, AND u2 IN (9);

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (9)' at line 1
Error Number  
1064
Request Date  
TuesdayJanuary 27th 2009 04:28:46 PM
Error Date    
TuesdayJanuary 27th 2009 04:28:46 PM
Script        
http://www.8wayrun.com/competitions.php?do=ladderteamreject&id=306
Referrer      http://www.8wayrun.com/private.php?do=showpm&pmid=13447
IP Address    : *******
Username      : *******
Classname     vB_Database
MySQL Version 
5.0.67-community 


Fraik 01-28-2009 09:53 AM

Okay, I made this fix myself. It seems to work but I removed a few checks which I think were causing the error.

In competitions.php
FIND (Line 4256)
PHP Code:

$db->query_write("UPDATE " TABLE_PREFIX "tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=$id AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN ($teamids)"); 

REPLACE WITH
PHP Code:

$db->query_write("UPDATE " TABLE_PREFIX "tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=$id AND u2 IN ($teamids)"); 

===

Again this is just a quick fix I made so use at your own risk... I am not yet using this in a live environment myself but have tested it with two test teams and it seems to work OK.

bananalive 01-28-2009 12:23 PM

Quote:

Originally Posted by Fraik (Post 1726359)
Getting this error when rejecting a team challenge request on the ladder:

Will be fixed in next release.

bananalive 01-28-2009 12:24 PM

v2.7.5 Beta 1 - Download in first post
- Additional avatar resizing in ladder and tournament comments
- Date of tournament changed to default 2009
- Profile stats only on showthread & showpost
- Fixed few uncached templates
- Admins (usergroupid: 6) can view mod when it is set as inactive in vboptions
- Latest announcements scrolling at top of mod
- Reduced product file by 35%
- Single Elimination tournaments for up to 128 players

please report any errors so they can be fixed, thanks.

gamerscms 01-28-2009 07:35 PM

Thanks for the update banana, looking forward to the new tournament types :)

Fraik 01-28-2009 08:47 PM

Cool! Does this fix the error I posted above as well?

Also, as a future suggestion I thought it'd be really neat to hook the mod into the notifications area in 3.7 (the one that displays if you have a new PM, a new visitor message etc) so you can add a notice for challenges and new members and the likes. Or maybe just make the 'challenges' link a different colour when there are outstanding invites.

Also what would be really sweet is a "My Teams" page that lists all teams that you are either member and/or leader of.

Keep up the good work!

^SuiCyde^ 01-29-2009 04:38 AM

i was actually looking to see if there was a way to rearrange the users once they are put into the results grid, because i have several tournaments where the matches have already been setup, but i would love to integrate your system and use it for all previous and past tourneys due to the records system..... GREAT MODIFICATION.....

is there anyway to change who is facing who in the results grid besides swapping players each manually?

SSC streezer 01-29-2009 06:26 AM

it works fine - but is there also an other language aviable for this mode? i would need in in german^^

and how can i change the date (create torunament) to 24h ?

bananalive 01-29-2009 09:00 AM

Quote:

Originally Posted by Fraik (Post 1727541)
Cool! Does this fix the error I posted above as well?

Also, as a future suggestion I thought it'd be really neat to hook the mod into the notifications area in 3.7 (the one that displays if you have a new PM, a new visitor message etc) so you can add a notice for challenges and new members and the likes. Or maybe just make the 'challenges' link a different colour when there are outstanding invites.

Also what would be really sweet is a "My Teams" page that lists all teams that you are either member and/or leader of.

Keep up the good work!

Yep it fixes the team reject error.

So far i haen't added the notifications as i want to keep it compatible with 3.6.x.

The ladder challenges page shows you which teams you are leader of., but a my teams page would be good idea

Quote:

Originally Posted by ^SuiCyde^ (Post 1727814)
i was actually looking to see if there was a way to rearrange the users once they are put into the results grid, because i have several tournaments where the matches have already been setup, but i would love to integrate your system and use it for all previous and past tourneys due to the records system..... GREAT MODIFICATION.....

is there anyway to change who is facing who in the results grid besides swapping players each manually?

I'll look into adding this.
Quote:

Originally Posted by SSC streezer (Post 1727874)
it works fine - but is there also an other language aviable for this mode? i would need in in german^^

and how can i change the date (create torunament) to 24h ?

Have a look at vbulletin-germany.org. I believe I gave them permission a while back to translate it.

I think times should be based on forum default, but I'll check this.

deadlySniper 01-31-2009 07:42 PM

I am guessing you can only see these brackets when the tournament is over

https://vborg.vbsupport.ru/attachmen...8&d=1220111828

bananalive 01-31-2009 07:45 PM

Quote:

Originally Posted by deadlySniper (Post 1730254)
I am guessing you can only see these brackets when the tournament is over

The brackets display for single elimination tournaments once the tournament has filled all its slots. i.e. when the tournament is in progress and when the tournament has finished

deadlySniper 01-31-2009 07:52 PM

AH, ok thanks, I was wondering why I couldnt see it. *Installed* *Nominated*

SSC streezer 01-31-2009 08:07 PM

Quote:

Originally Posted by bananalive (Post 1727953)
Have a look at vbulletin-germany.org. I believe I gave them permission a while back to translate it.

I think times should be based on forum default, but I'll check this.


but it doesnt... hmm... and a german version isn't aviable either (on vbulletin-germany.org)

JesterP 02-01-2009 06:38 PM

I just set up our first 16 person tourney, all the slots are full, but no brackets. When I click the tourney in progress, I just get a list of names.

Is there a maintenance step that needs to happen to generate the brackets?

J

*I changed the type to 1v1 and they appeared. I'm wondering why LMS type doesn't show brackets?

bananalive 02-02-2009 07:58 AM

Quote:

Originally Posted by JesterP (Post 1731172)
I just set up our first 16 person tourney, all the slots are full, but no brackets. When I click the tourney in progress, I just get a list of names.

Is there a maintenance step that needs to happen to generate the brackets?


J

*I changed the type to 1v1 and they appeared. I'm wondering why LMS type doesn't show brackets?

LMS stands for Last Man Standing... there are no brackets for this kind of tournament

http://en.wikipedia.org/wiki/Last_ma...g_%28gaming%29

Jaxel 02-02-2009 07:36 PM

I foudn a new issue with this mod... it deals with tournaments that are not evenly split in powers of two. (2, 4, 8, 16, 32, etc). This one tournament I have, has 17 players; which means it has 1 extra player outside of the power of 2. Normally, this wouldn't be a problem, simply by stratifying the brackets, no player would ever get more than one bye. However, with the way this system constructs the bracket, this 1 extra player gets a bye ALL THE WAY TO GRAND FINALS. This should be fixed. Or at least, put in a way that I can remove a player from a tournament to bring it down to 16, after the tournament has already started...

http://www.8wayrun.com/competitions.php?do=view&id=14

The way you fix this is actually relatively easy... instead of filling in bracket spots from 1, 2, 3, 4, etc... you fill them up as follows: 1, 3, 5, 7, etc, and then only start filling in the even spots when all the odd spots have been filled. So with 17 players in a tournament, you need to have a bracket setup for 32 players, not 17 (15 players will get a bye in first round, but no one will ever get more than 1 bye). Its easy to do the calculations to know how many bracket slots you need too:

2 ^ ceil(##/sqrt(2)) = number of slots you need

2 ^ ceil(14/sqrt(2)) = 16
2 ^ ceil(17/sqrt(2)) = 32
2 ^ ceil(45/sqrt(2)) = 64

Noblefist 02-03-2009 06:44 AM

Can this be used with v3.8.1 ? This would help out a lot with our guild site pvp games.

bananalive 02-03-2009 09:32 AM

Quote:

Originally Posted by Noblefist (Post 1732777)
Can this be used with v3.8.1 ? This would help out a lot with our guild site pvp games.

Yes, so far there have been no compatibility issues with vb v3.8.x

astrid1 02-03-2009 07:36 PM

Isn't there also a German version (translation) on vbulletin-germany.org is to be found? I think many Germans would be pleased.

Bradley_Wint 02-04-2009 01:56 AM

Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs :(

bananalive 02-04-2009 01:38 PM

Quote:

Originally Posted by Bradley_Wint (Post 1733707)
Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs :(

You could try LMS (Last Man Standing) tournament for this.

Quote:

Originally Posted by astrid1 (Post 1733366)
Isn't there also a German version (translation) on vbulletin-germany.org is to be found? I think many Germans would be pleased.

No sorry. (They have my permission to translate it.)

Bradley_Wint 02-04-2009 03:01 PM

Oh, so basically, technically I am not eliminating anyone. Rather than scoring on who remains alive (shooting game, the order of last man standing would be the order of who wins the race? Am I right?

Gn_Snake 02-04-2009 07:02 PM

Hi for all,
i have a problem ,when submit score in the ladder gives this error to me:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE HG_tmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1233780968, rank = 987.5, uod = -1, totalpoints = totalpoints + 5, longeststreak = 0 WHERE lid = 3 AND userid = 5574;

MySQL Error : Unknown column 'uod' in 'field list'
Error Number : 1054


any idea??? :confused:

Gamelobby 02-04-2009 09:24 PM

Quote:

Originally Posted by Bradley_Wint (Post 1733707)
Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs :(

This would be great to score like a league.. (think Nascar where each week they get a certain amount of points for each place)
I think both the ladder & tournament system can be altered to work for this.. i just dont know how.


Also i have a question..
My board has this BIG gap between the 2 columns, in the tournament section.?
http://www.gamelobby.com/Forum/competitions.php
Is anyone else having this problem.? (maybe it is an issue with 3.8)

Thanks

Bradley_Wint 02-04-2009 09:39 PM

@bananalive - I got it to work. Thanks man. Also, is there a way to have a championship style event where a number of LMS events fall under a certain main event.

e.g. Race Championship

Under that would be

Event 1 - Track A
Event 2 - Track B
etc

and the aggregate scores would add up to show the winner of the overall event.

Is that possible?

@Gamelobby - I will get back to you tonight via PM.

montesm 02-04-2009 09:58 PM

Running 3.6.4 - and getting this error when creating a tournament. Can you please help??

Invalid SQL:
SELECT comments.id AS id, comments.comment AS comment, comments.userid AS userid, comments.username AS username, comments.time AS time, comments.ed_userid AS ed_userid, comments.ed_username AS ed_username, comments.ed_time AS ed_time, comments.ed_ip AS ed_ip, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM vb_tmnt_comments AS comments
LEFT JOIN vb_user AS user ON (comments.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE comments.tid=4 ORDER BY comments.id ASC LIMIT 0, 5;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

Freakboy380 02-05-2009 08:18 AM

Hmmmm was working fine until I installed some new mods, now it just shows up blank when i go to /competition.php (i renamed it because of another mod, it worked fine, just after the new mods the problem began). Here is the list of mods installed please tell me if anyone knows if one or more are incompatible.
Running 3.8.1

AME - The Automatic Media Embeder 2.5.4
Community News Letter Light 1.0.0 1.0.0
Competitions 1.0.3
Cyb - Advanced 'New Posts' 2.4
Cyb - Advanced Forum Statistics 6.5
Cyb - Last Post Info Enhancements 1.2
Cyb - Login To User Account 2.2
Cyb - PM System Enhancements 1.5
Hide Closed Forum Threadlist 1.0.1
Inferno External 1.0
Invitation System 2.0.3
Live Topic 1.05b
Quick Editor Improver 3.0
Separate Sticky and Normal Threads 2.0.0
Similar thread check v2 2.0
Tag Cloud - Forum Home 2.0.0
vB Tournaments and Ladders 2.7.5
vBjirc 1.0.0

bananalive 02-05-2009 12:40 PM

Quote:

Originally Posted by montesm (Post 1734677)
Running 3.6.4 - and getting this error when creating a tournament. Can you please help??


Invalid SQL:
SELECT comments.id AS id, comments.comment AS comment, comments.userid AS userid, comments.username AS username, comments.time AS time, comments.ed_userid AS ed_userid, comments.ed_username AS ed_username, comments.ed_time AS ed_time, comments.ed_ip AS ed_ip, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM vb_tmnt_comments AS comments
LEFT JOIN vb_user AS user ON (comments.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE comments.tid=4 ORDER BY comments.id ASC LIMIT 0, 5;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

Find and delete in competitions.php
PHP Code:

customavatar.width_thumb AS width_thumbcustomavatar.height_thumb AS height_thumb 


Gn_Snake 02-05-2009 07:33 PM

Quote:

Originally Posted by Gn_Snake (Post 1734525)
Hi for all,
i have a problem ,when submit score in the ladder gives this error to me:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE HG_tmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1233780968, rank = 987.5, uod = -1, totalpoints = totalpoints + 5, longeststreak = 0 WHERE lid = 3 AND userid = 5574;

MySQL Error : Unknown column 'uod' in 'field list'
Error Number : 1054


any idea??? :confused:


Hi bananalive :)
You have a solution for me??

thanx


All times are GMT. The time now is 04:23 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03731 seconds
  • Memory Usage 1,884KB
  • 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
  • (5)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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