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)

When I try to write the tournament description in Russian - After I can see only question marks

Quote:

?????????????????????????????????

Pls help to fix it

pls see here - http://www.fifamanager.com.ua/forum/...p?do=view&id=2

Quote:

Originally Posted by WNxWakko (Post 1637877)

Something else to consider here. On the ladder once the challange is over, it pretty much disappears. Shouldnt there be some sort of challangers summary page showing all challanges in progress and completed?

Yea, I like this. Maybe a Team/Player page in a ladder should show the last X matches they've done (maybe 5 or 10_ and have an option to click and view all matches. Perhaps the last X amount to display could be definable in the Admin CP.

Request:

On the type of Match: ie; Single Elimination, Team Deathmatch, etc. Can we make it so we can add our own type of "Match" For example: Duel, Highest Score in X Game, or whatever we feel the tournament should be about? Im just wondering since we can make our own type of matches and not be restricted to the 2 types?

We'll give it a shot ... might just be what we been looking for. I will let you know. Thanks for the hard work.

Bug: Whenever I try to update the description for a tournament is says "Error: Invalid Type". This is on tournaments that are in progress, if that matters.

I cannot update usergroups! If I disable the the Tournaments product, I can update usergroups again. If I have Tournaments enable, nothing but database errors.

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

UPDATE usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

    `title` = 'xAAx Members',

    `description` = '',

    `usertitle` = '',

    `opentag` = '<span style=\"color: gray\">',

    `closetag` = '</span>',

    `passwordexpires` = '0',

    `passwordhistory` = '0',

    `awardpermissions` = '1',

    `fcpermissions` = '1',

    `gb_permissions` = '15',

    `memberindex` = '27',

    `mgc_cb_evo_permissions` = '263',

    `mgc_cb_evo_nbmsg_show` = '0',

    `mgc_cb_evo_nbmsg_perday_show` = '0',

    `showrosteraccesspermissions` = '1',

    `showrosterviewpermissions` = '0',

    `tournamentpermissions` = '1',

    `maxteams` = '',

    `ladderpermissions` = '7',

    `vbblog_general_permissions` = '126',

    `vbblog_entry_permissions` = '32380',

    `vbblog_comment_permissions` = '2014',

    `vbgmepermissions` = '19',

    `forumpermissions` = '8122879',

    `genericpermissions` = '1554882507',

    `attachlimit` = '0',

    `pmquota` = '300',

    `pmpermissions` = '1',

    `pmsendmax` = '5',

    `calendarpermissions` = '63',

    `wolpermissions` = '5',

    `adminpermissions` = '0',

    `genericpermissions2` = '1',

    `genericoptions` = '55',

    `profilepicmaxwidth` = '200',

    `profilepicmaxheight` = '200',

    `profilepicmaxsize` = '65535',

    `avatarmaxwidth` = '100',

    `avatarmaxheight` = '100',

    `avatarmaxsize` = '102400',

    `signaturepermissions` = '245759',

    `sigpicmaxwidth` = '800',

    `sigpicmaxheight` = '400',

    `sigpicmaxsize` = '10000',

    `sigmaxrawchars` = '1000',

    `sigmaxchars` = '800',

    `sigmaxlines` = '800',

    `sigmaxsizebbcode` = '7',

    `sigmaximages` = '5',

    `albumpermissions` = '255',

    `albumpicmaxwidth` = '995',

    `albumpicmaxheight` = '2000',

    `albumpicmaxsize` = '999999',

    `albummaxpics` = '1000',

    `albummaxsize` = '999999',

    `usercsspermissions` = '31',

    `visitormessagepermissions` = '63',

    `socialgrouppermissions` = '375',

    `mgc_cb_evo_default_color` = '000000'

WHERE usergroupid=2;



MySQL Error   : Unknown column 'maxteams' in 'field list'

Error Number  : 1054

Request Date  : Sunday, October 5th 2008 @ 07:25:58 PM

Error Date    : Sunday, October 5th 2008 @ 07:25:58 PM

Script        : http://xaax.biz/forums/admincp/usergroup.php?do=update

Referrer      : http://xaax.biz/forums/admincp/usergroup.php?do=edit&usergroupid=2

IP Address    : xxx.xxx.xxx.xxx

Username      : CamoMouse

Classname     : vB_Database

MySQL Version : 5.0.51b-community-nt

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

UPDATE usergroup SET



### UPDATE QUERY GENERATED BY fetch_query_sql() ###

    `title` = 'Administrators',

    `description` = '',

    `usertitle` = '',

    `opentag` = '',

    `closetag` = '',

    `passwordexpires` = '0',

    `passwordhistory` = '0',

    `awardpermissions` = '1',

    `fcpermissions` = '8',

    `gb_permissions` = '31',

    `memberindex` = '63',

    `mgc_cb_evo_permissions` = '383',

    `mgc_cb_evo_nbmsg_show` = '0',

    `mgc_cb_evo_nbmsg_perday_show` = '0',

    `showrosteraccesspermissions` = '1',

    `showrosterviewpermissions` = '0',

    `tournamentpermissions` = '0',

    `maxteams` = '',

    `ladderpermissions` = '15',

    `vbblog_general_permissions` = '126',

    `vbblog_entry_permissions` = '32380',

    `vbblog_comment_permissions` = '2014',

    `vbgmepermissions` = '31',

    `forumpermissions` = '8388607',

    `genericpermissions` = '2113929151',

    `attachlimit` = '0',

    `pmquota` = '300',

    `pmpermissions` = '7',

    `pmsendmax` = '5',

    `calendarpermissions` = '63',

    `wolpermissions` = '31',

    `adminpermissions` = '3',

    `genericpermissions2` = '1',

    `genericoptions` = '63',

    `profilepicmaxwidth` = '200',

    `profilepicmaxheight` = '200',

    `profilepicmaxsize` = '65535',

    `avatarmaxwidth` = '100',

    `avatarmaxheight` = '100',

    `avatarmaxsize` = '102400',

    `signaturepermissions` = '245759',

    `sigpicmaxwidth` = '800',

    `sigpicmaxheight` = '400',

    `sigpicmaxsize` = '10000',

    `sigmaxrawchars` = '0',

    `sigmaxchars` = '0',

    `sigmaxlines` = '0',

    `sigmaxsizebbcode` = '7',

    `sigmaximages` = '0',

    `albumpermissions` = '255',

    `albumpicmaxwidth` = '995',

    `albumpicmaxheight` = '2000',

    `albumpicmaxsize` = '0',

    `albummaxpics` = '1000',

    `albummaxsize` = '0',

    `usercsspermissions` = '31',

    `visitormessagepermissions` = '63',

    `socialgrouppermissions` = '511',

    `mgc_cb_evo_default_color` = '000000'

WHERE usergroupid=6;



MySQL Error   : Unknown column 'maxteams' in 'field list'

Error Number  : 1054

Request Date  : Sunday, October 5th 2008 @ 07:27:54 PM

Error Date    : Sunday, October 5th 2008 @ 07:27:55 PM

Script        : http://xaax.biz/forums/admincp/usergroup.php?do=update

Referrer      : http://xaax.biz/forums/admincp/usergroup.php?do=edit&usergroupid=6

IP Address    : xxx.xxx.xxx.xxx

Username      : CamoMouse

Classname     : vB_Database

MySQL Version : 5.0.51b-community-nt

Manually adding the SQL Query for those two fields that were missing fixed he problem for me earlier.

Where am I suppose to add them? Sorry...

Am I suppose to make a new table with tmnt_maxteams or am I suppose to add a maxteams field to something.?

I can not install the product, install it when I get an error message:

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:



  CREATE TABLE IF NOT EXISTS `tmnt_tmnts` (

  `id` int(11) NOT NULL auto_increment,

  `title` varchar(50) collate latin1_general_ci NOT NULL default '',

  `description` text collate latin1_general_ci NOT NULL,

  `type` varchar(50) collate latin1_general_ci NOT NULL default '',

  `date` varchar(50) collate latin1_general_ci NOT NULL default '',

  `noplayers` int(3) NOT NULL,

  `freeslots` int(3) NOT NULL,

  `status` varchar(50) collate latin1_general_ci NOT NULL,

  `userid` int(10) NOT NULL,

  `username` varchar(100) collate latin1_general_ci NOT NULL,

  `time` int(10) NOT NULL,

  `le_userid` int(10) NOT NULL,

  `le_username` varchar(100) collate latin1_general_ci NOT NULL,

  `le_time` int(10) NOT NULL,

  `slots` int(10) NOT NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM;



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 'collate latin1_general_ci NOT NULL default '',

  `description`

Error Number  : 1064

Request Date  : Sunday, October 5th 2008 @ 10:18:42 PM

Error Date    : Sunday, October 5th 2008 @ 10:18:43 PM

Script        : http://www.darkmlg.com/foro/admincp/plugin.php?do=productimport

Referrer      : http://www.darkmlg.com/foro/admincp/plugin.php?do=productadd

IP Address    : xxx.xxx.xxx.xxx

Username      : XxBOSSMASTERxX

Classname     : vB_Database

MySQL Version : 4.0.27-standard

Many errors in the product file.

Not sure if this was already addressed, but a "[" precedes the "here" link in PM's received after receiving a challenge.

Quote:

Originally Posted by djlotus (Post 1638283)

Many errors in the product file.

Not sure if this was already addressed, but a "[" precedes the "here" link in PM's received after receiving a challenge.

To fix the error with the PM link to challenges:

Replace:

HTML Code:

$title. Click        [url=[url=$vboptions[bburl]/tournament.php?do=ladderchallenges]]here[/url]to view all your challenges.

With:

HTML Code:

$title. Click [url=$vboptions[bburl]/tournament.php?do=ladderchallenges]]here[/url] to view all your challenges.

One question: I use this product but now need to pass all languages variables to vbphrase..
If I edit templates and files, is possible to send to you all files modified?
If you have any other system to give me support to this hack, explain to me.. :)

Sorry for bad english.. :(

Quote:

Originally Posted by ss20 (Post 1638063)

When I try to write the tournament description in Russian - After I can see only question marks
Pls help to fix it

pls see here - http://www.fifamanager.com.ua/forum/...p?do=view&id=2

You'll need to change the ". TABLE_PREFIX ."tmnt_tmnts description row to encoding which supports Russian characters (default is latin1_general_ci)

Quote:

Originally Posted by djlotus (Post 1638010)

Same here. I don't see the SQL in the Product file to install the tmnt_rules Row to the DB.

Code Version 2.4.7

PHP Code:


		
			
$vbulletin->db->query_write("

  INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES

(1, 'Your Rules Here')");

Quote:

Originally Posted by Revvin (Post 1637920)

Did you have to put the code in as with regular custom BBcode's? and if so is it limited to the ladder script of can it be used in forum posts? I'm just wondering if that may cause some problems in regaulr forum threads if people use the code?

Nope, you don't have to add it to custom bbcode, and it only works in the tournament description.

Quote:

Originally Posted by WNxWakko (Post 1637850)

When I click rules I get this,

I'm looking into it.

Quote:

Originally Posted by djlotus (Post 1638298)

To fix the error with the PM link to challenges:

Replace:

HTML Code:

$title. Click        [url=[url=$vboptions[bburl]/tournament.php?do=ladderchallenges]]here[/url]to view all your challenges.

With:

HTML Code:

$title. Click [url=$vboptions[bburl]/tournament.php?do=ladderchallenges]]here[/url] to view all your challenges.

Woops, fixed in next release

Quote:

Originally Posted by XxBOSSMASTERxX (Post 1638274)

I can not install the product, install it when I get an error message:

The sql syntax has changed. Open product file with notepad or wordpad and remove all instances of ''collate latin1_general_ci '' Will be fixed in next version.

Quote:

Originally Posted by camomouse (Post 1638256)

Where am I suppose to add them? Sorry...

Am I suppose to make a new table with tmnt_maxteams or am I suppose to add a maxteams field to something.?

Not quite sure why it hasnt already created column for you but, if you wait for v2.4.9 then it will be fixed.

Quote:

Originally Posted by camomouse (Post 1638149)

I cannot update usergroups! If I disable the the Tournaments product, I can update usergroups again. If I have Tournaments enable, nothing but database errors.

Not quite sure why it hasnt already created column for you but, if you wait for v2.4.9 then it will be fixed.

Quote:

Originally Posted by Namaless (Post 1638517)

I am trying to use phrases for everything, if you see a place where I haven't used vbphrases, then I'll fix it in next version.

Any news on the PM problem with the new BB code?, it adds the tags into the PM.

Quote:

Originally Posted by gamerscms (Post 1638637)

Any news on the PM problem with the new BB code?, it adds the tags into the PM.

Fixed in next version (also fixed bbcode for tournament thread)

nice I just voted for this to be the mod of the month.

bananalive I have so many sugestions for this mod, how can I contact you?

I use vB CODE and get debug uncached template:

Code:

bbcode_code

Thanks.. :)

Still showing tags in PM messages :(

Code:

Welcome to call of duty 4 knock out tournament consisting of 10 teams and only one team walks with the medal.





[newbox=Tournament Rules]

Rule #1

Rule #2

Rule #3



Good luck teams.[/newbox]

Quote:

Originally Posted by JAnders (Post 1638769)

nice I just voted for this to be the mod of the month.

bananalive I have so many sugestions for this mod, how can I contact you?

Thanks, if you send me a pm then I'll give you my email address.

Quote:

Originally Posted by Namaless (Post 1638779)

I use vB CODE and get debug uncached template:

Code:

bbcode_code

Thanks.. :)

Which page?

Quote:

Originally Posted by gamerscms (Post 1638785)

Still showing tags in PM messages :(

Code:

Welcome to call of duty 4 knock out tournament consisting of 10 teams and only one team walks with the medal.





[newbox=Tournament Rules]

Rule #1

Rule #2

Rule #3



Good luck teams.[/newbox]

Sorry forgot to edit 'pm self' I did 'pm all competitors'. Will be included in next release.

Quote:

Originally Posted by bananalive (Post 1638793)

Sorry forgot to edit 'pm self' I did 'pm all competitors'. Will be included in next release.

Ok no problem, just thought i would post it up :)

Still have DB error in 2.4.9 when viewing tourney rules.

Code:

Database error in vBulletin 3.7.2:



Invalid SQL:

SELECT * FROM tmnt_rules;



MySQL Error   : Table 'XXXXXXXX.tmnt_rules' doesn't exist

Error Number  : 1146

Request Date  : Monday, October 6th 2008 @ 03:49:45 PM

Error Date    : Monday, October 6th 2008 @ 03:49:45 PM

Script        : http://www.battlefieldsofhonor.com/forums/tournament.php?do=rules

Referrer      : http://www.battlefieldsofhonor.com/forums/tournament.php

IP Address    : 71.62.57.109

Username      : djlotus

Classname     : vB_Database

MySQL Version : 5.0.51a-community

Im also getting the Database error when trying to view the rules.

Any Idea when we`ll be able to move the Stand alone ladder tables into the Combined mod to allow use of 1 mod instead of 2? 1?

**Thanks, There is no Rush at all..Just asking**

Are there any plans on creating two files, on "tournament.php" and "ladder.php" to sort of separate the directory for ladders and tournaments. Personally, I just don't really care for ladders being under a file called "tournament".

First I would like to say thanks this mod works great. A few of my members came up with a suggestion. So say a member(non staff) created a tournament and everything went fine, They would like to be able to end there tournament with out having to pm a tournament moderator.

I hope you understand what I'm saying if not please respond with any question.
Thanks.

Quote:

Originally Posted by Nightcast (Post 1639019)

I think this was brought up before. Basically give the creator special permissions, such as being able to advance people, etc

How do I delete a player from a tournament? Anyway to let them unregister themselves too?

Installed your plugin and it's really great otherwise, thanks again!

so far so good.. still testing but loving it so far...
members are already pysched for what they see so far. This is gunna be a staple for couple of my boards :):D

current: vb3.7.3 patch 1 / tourament v2.4.9

Request/Suggestions:

**Double Elmination!!** Pretty PLEEEEEASE!! :)
**Calendar integration**
HTML markup for tournament/ladder titles in List (hard to read or would like to highlight some)
Ability to sticky for Tournament/Ladder Lists

Team logos

upload team logo when create new team (currently can only do so when edit team)
team logo thumbs on Team List
ability to choose from stock logos (maybe link to vbulletin avatar?)

Weird:
tree_ltr.gif
seems to be missing from the file package (wouldn't load, couldn't find it so jacked from your demo site. lol)

BUG?
Ladder combined script with tournaments is great... but since I upgraded...
creating new ladders doesn't create a new thread :(

I voted for this Mod to be MOTM did you? :D

Here is the link to show your support to Bananalive so go and vote! :) ->https://vborg.vbsupport.ru/showthread.php?t=192376

Guys Guys Guys,
This might be a very stupid question but unfortunately I am not a "games guru" like most of you out here...

I installed the mod but I am not sure how this thing works??? I went through all the posts but did not get much idea except that there are two modes i.e. LSM and 1v1.

My main question is, what GAME are the users competing against?? Does the user who creates the tournament, adds a mult-player game where people can compete against each other??? If this is case, where to download these multi-player games??

Any pointers would be appreciated.

Thanks
Wicked80

Quote:

Originally Posted by GrendelKhan{TSU (Post 1639358)

**Double Elmination!!** Pretty PLEEEEEASE!! :)
**Calendar integration**
HTML markup for tournament/ladder titles in List (hard to read or would like to highlight some)
Ability to sticky for Tournament/Ladder Lists

Team logos

upload team logo when create new team (currently can only do so when edit team)
team logo thumbs on Team List
ability to choose from stock logos (maybe link to vbulletin avatar?)

I Second This. With the addition of adding the custom titles!

I'm going to wait for 2.5.0 Before i install again. BananaLive is a great at updates, but sometimes i think he speed codes :P

/waits for stable release.:p

I'm sorry to ask again, but how a member can unregister from a tournament?
(and can I delete him myself as moderator/administrator)
I feel a bit stupid but I still can't find...

Thanks!

Click the little person icon next to their name before a tournament begins to delete them.

Those little person icons aren't listed when tournament got more than a few players registered, I can't see who's in and then can't click there... Any idea?

Make sure you have the permissions to remove players form a Tournament in Usergroup Permissions.

I have, I can now remove players on my tournaments with a small number of registered players, but as soon as I have more than a few (not sure but something about 10+) registered yet the list of registered players disappear and then I can't remove them.

any info on how the ELO ranking system (or something similar) is coming along?

Quote:

Originally Posted by butler312 (Post 1639828)

any info on how the ELO ranking system (or something similar) is coming along?

I can write it if Bananalive needs help.

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02805 seconds Memory Usage 1,881KB 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 (8)bbcode_code_printable (4)bbcode_html_printable (1)bbcode_php_printable (20)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
Messages: