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)

Chris11987 10-20-2008 10:55 PM

Quote:

Originally Posted by bananalive (Post 1648896)
Tournament creators' should/ do have full control over their own tournaments.

Oh, sweet. So far only "special" members have had permission to make tournaments, and they had full control already, so I wasn't aware. Thanks.

butler312 10-20-2008 10:59 PM

One suggestion by one of my members was pretty good and I thought I would post it here. He suggested the ability to seed members/teams in tournaments. It would be sweet if for each tournament there was the option to not seed members, seed them according to their place in the ladder (anyone not in the ladder would randomly be seeded at the end), or seed them manually. Players/teams would then be placed in the tournament according to their seed (top seeds playing the lowest seeds or receiving the byes).

Chris11987 10-21-2008 08:43 AM

Quote:

Originally Posted by butler312 (Post 1649325)
One suggestion by one of my members was pretty good and I thought I would post it here. He suggested the ability to seed members/teams in tournaments. It would be sweet if for each tournament there was the option to not seed members, seed them according to their place in the ladder (anyone not in the ladder would randomly be seeded at the end), or seed them manually. Players/teams would then be placed in the tournament according to their seed (top seeds playing the lowest seeds or receiving the byes).

I'd like this as well. It should be easy if the "swap user" icon is still available after brackets have been made. That way, you can still customize them once a tournament is in progress.

Also, I have a question about how players are currently seeded: It seems that each person is given a random number out of about 10 million or so. Why is that? Why don't the players just have a random number from 1-32, or whatever the players maximum is for a tourney? I noticed all of the round 2-77 fields in the database use this way to order spots, so why not on the first round as well? I'm no coder, so forgive me if there's a good reason for that.

darkforce114 10-21-2008 06:14 PM

What the chances of changing the Ladder's from single into team's?

For example instead of Play A challenges Play B, we want it to do Team A challenges Team B and when you click on the team it list's all the players registered with that team.

msimonds 10-21-2008 06:33 PM

Quote:

Originally Posted by msimonds (Post 1647204)
bananlive,

I have to say that this seems to be an outstanding add on. I thought of doing this one time for my sports site for Sports team tournaments, like American College Basketball or other sports.

do you have any thoughts of adding these features to your script?

Outstanding job sir!!!

Sir did you get a chance to read my post? is this something that could be put into place? or plans for it?

Thanks so much for creating this script by the way, it is awesome

mozik 10-21-2008 10:51 PM

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT userid, id, time, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Request Date : Tuesday, October 21st 2008 @ 05:42:50 PM
Error Date : Tuesday, October 21st 2008 @ 05:42:51 PM
Script : http://www.vzrgaming.com/tournament.php
Referrer : http://www.vzrgaming.com/index.php
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.0.45-community-log

keep getting this when updating.

gamerscms 10-22-2008 02:47 PM

Getting a error on the latest install

Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Full Member',
        `description` = 'A full and proud member of thirteen ghosts.',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ispublicgroup` = '0',
        `canoverride` = '0',
        `forumpermissions` = '272363767',
        `genericpermissions` = '1277695619',
        `attachlimit` = '1000000',
        `pmquota` = '50',
        `pmpermissions` = '1',
        `pmsendmax` = '5',
        `calendarpermissions` = '23',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '47',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '25000',
        `avatarmaxwidth` = '150',
        `avatarmaxheight` = '150',
        `avatarmaxsize` = '100000',
        `signaturepermissions` = '237055',
        `sigpicmaxwidth` = '0',
        `sigpicmaxheight` = '0',
        `sigpicmaxsize` = '0',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '100',
        `albumpermissions` = '239',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '31',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '375',
        `mgc_cb_evo_permissions` = '0',
        `mgc_cb_evo_nbmsg_show` = '',
        `mgc_cb_evo_nbmsg_perday_show` = '',
        `awardpermissions` = '1',
        `photoplogpermissions` = '29647',
        `photoplogmaxfilesize` = '0',
        `photoplogmaxfilelimit` = '0',
        `tournamentpermissions` = '339',
        `maxteams` = '1',
        `ladderpermissions` = '3'
WHERE usergroupid=15;

MySQL Error  : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 22nd 2008 @ 04:44:06 PM
Error Date    : Wednesday, October 22nd 2008 @ 04:44:06 PM
Script        : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=update
Referrer      : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=15
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname    : xxxxxxxxxx
MySQL Version : 5.0.67-community

Any ideas why this is happening when trying to update usergroups.

thanks

JAnders 10-22-2008 02:48 PM

something I find can be improved is on the ladder challanges if you add a column with the ladder name.

I have about 4 different ladders and I have about 10 challanges but I can't tell what challange is for which unless I click on the view ladder link.

bananalive 10-22-2008 03:03 PM

Quote:

Originally Posted by Chris11987 (Post 1649562)
I'd like this as well. It should be easy if the "swap user" icon is still available after brackets have been made. That way, you can still customize them once a tournament is in progress.

Also, I have a question about how players are currently seeded: It seems that each person is given a random number out of about 10 million or so. Why is that? Why don't the players just have a random number from 1-32, or whatever the players maximum is for a tourney? I noticed all of the round 2-77 fields in the database use this way to order spots, so why not on the first round as well? I'm no coder, so forgive me if there's a good reason for that.

It decreases probability of two players getting same slot number. I have wrote code to stop this happening but havent added it yet.
Quote:

Originally Posted by darkforce114 (Post 1649864)
What the chances of changing the Ladder's from single into team's?

For example instead of Play A challenges Play B, we want it to do Team A challenges Team B and when you click on the team it list's all the players registered with that team.

Team ladders coming soon
Quote:

Originally Posted by msimonds (Post 1649876)
Sir did you get a chance to read my post? is this something that could be put into place? or plans for it?

Thanks so much for creating this script by the way, it is awesome

I'm sorry I don't fully understand your previous post, could you possibly rephrase it
Quote:

Originally Posted by mozik (Post 1650038)
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT userid, id, time, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Request Date : Tuesday, October 21st 2008 @ 05:42:50 PM
Error Date : Tuesday, October 21st 2008 @ 05:42:51 PM
Script : http://www.vzrgaming.com/tournament.php
Referrer : http://www.vzrgaming.com/index.php
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.0.45-community-log

keep getting this when updating.

Quote:

Originally Posted by gamerscms (Post 1650482)
Getting a error on the latest install

Code:

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
        `title` = 'Full Member',
        `description` = 'A full and proud member of thirteen ghosts.',
        `usertitle` = '',
        `opentag` = '',
        `closetag` = '',
        `passwordexpires` = '0',
        `passwordhistory` = '0',
        `ispublicgroup` = '0',
        `canoverride` = '0',
        `forumpermissions` = '272363767',
        `genericpermissions` = '1277695619',
        `attachlimit` = '1000000',
        `pmquota` = '50',
        `pmpermissions` = '1',
        `pmsendmax` = '5',
        `calendarpermissions` = '23',
        `wolpermissions` = '1',
        `adminpermissions` = '0',
        `genericpermissions2` = '1',
        `genericoptions` = '47',
        `profilepicmaxwidth` = '100',
        `profilepicmaxheight` = '100',
        `profilepicmaxsize` = '25000',
        `avatarmaxwidth` = '150',
        `avatarmaxheight` = '150',
        `avatarmaxsize` = '100000',
        `signaturepermissions` = '237055',
        `sigpicmaxwidth` = '0',
        `sigpicmaxheight` = '0',
        `sigpicmaxsize` = '0',
        `sigmaxrawchars` = '0',
        `sigmaxchars` = '0',
        `sigmaxlines` = '0',
        `sigmaxsizebbcode` = '7',
        `sigmaximages` = '100',
        `albumpermissions` = '239',
        `albumpicmaxwidth` = '600',
        `albumpicmaxheight` = '600',
        `albumpicmaxsize` = '100000',
        `albummaxpics` = '100',
        `albummaxsize` = '0',
        `usercsspermissions` = '31',
        `visitormessagepermissions` = '63',
        `socialgrouppermissions` = '375',
        `mgc_cb_evo_permissions` = '0',
        `mgc_cb_evo_nbmsg_show` = '',
        `mgc_cb_evo_nbmsg_perday_show` = '',
        `awardpermissions` = '1',
        `photoplogpermissions` = '29647',
        `photoplogmaxfilesize` = '0',
        `photoplogmaxfilelimit` = '0',
        `tournamentpermissions` = '339',
        `maxteams` = '1',
        `ladderpermissions` = '3'
WHERE usergroupid=15;

MySQL Error  : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 22nd 2008 @ 04:44:06 PM
Error Date    : Wednesday, October 22nd 2008 @ 04:44:06 PM
Script        : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=update
Referrer      : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=15
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname    : xxxxxxxxxx
MySQL Version : 5.0.67-community

Any ideas why this is happening when trying to update usergroups.

thanks

That is probelm with MGC Chatbox Evo Permission column not existing.

bananalive 10-22-2008 03:05 PM

Quote:

Originally Posted by jackapup (Post 1649310)
Are you going to featuring a double elimination function anytime soon with the script?

Yes, but I've got few more things to do before that
Quote:

Originally Posted by chriskellar (Post 1649178)
Ok got it uninstalled. Now I'm moving forward with installing the upgraded version and here is the error that I'm getting.

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_user ADD tmnt_joins INT(10) NOT NULL DEFAULT '0' ;;

MySQL Error  : Duplicate column name 'tmnt_joins'
Error Number  : 1060
Request Date  : Monday, October 20th 2008 @ 02:27:08 PM
Error Date    : Monday, October 20th 2008 @ 02:27:09 PM


Open product file with notepad or wordpad and remove that line


All times are GMT. The time now is 09:14 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.02772 seconds
  • Memory Usage 1,798KB
  • 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
  • (3)bbcode_code_printable
  • (10)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