vb.org Archive
Page 132 of 213 « First 3282122130131 132 133134142182 Last »
Show 40 post(s) from this thread on one page

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)

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_thumb, customavatar.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:26 AM.
Page 132 of 213 « First 3282122130131 132 133134142182 Last »
Show 40 post(s) from this thread on one page

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.03058 seconds
  • Memory Usage 1,759KB
  • 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
  • (1)bbcode_php_printable
  • (5)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