Thread: Major Additions - Forum Tournaments & Ladders
View Single Post
  #880  
Old 10-22-2008, 03:03 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Chris11987 View Post
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 View Post
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 View Post
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 View Post
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 View Post
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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01293 seconds
  • Memory Usage 1,795KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (5)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete