vb.org Archive - Major Additions - Forum Tournaments & Ladders

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)

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 = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);

MySQL Error   : 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 ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1
Error Number  : 1064
Request Date  : Tuesday, January 27th 2009 @ 01:38:04 PM
Error Date    : Tuesday, January 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

Same...

PHP Code:


		
			
Database error in vBulletin 3.8.0:



Invalid SQL:

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



MySQL Error   : 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 ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (9)' at line 1

Error Number  : 1064

Request Date  : Tuesday, January 27th 2009 @ 04:28:46 PM

Error Date    : Tuesday, January 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

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.

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.

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.

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

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!

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?

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 ?

Quote:

Originally Posted by Fraik (Post 1727541)

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'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.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (4)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02960 seconds Memory Usage 1,773KB 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 (4)bbcode_php_printable (4)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: