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)

djlotus 11-24-2008 07:44 PM

Quote:

Originally Posted by Toupsx (Post 1672181)
any clue on this banana?

Is "OD" the correct table prefix?

dirtyfeast 11-25-2008 02:14 AM

Code:

Database error in vBulletin 3.7.4:

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  : Monday, November 24th 2008 @ 09:04:15 PM
Error Date    : Monday, November 24th 2008 @ 09:04:16 PM
Script        : http://www.com/forum/competitions.php?do=ladderteamreject&id=3
Referrer      : http://www.com/forum/competitions.php?do=ladderteamchallenges
IP Address    : ************
Username      : **********
Classname    : vB_Database
MySQL Version : 5.0.51a-community

Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.

honcho 11-25-2008 10:49 PM

Quote:

Originally Posted by honcho (Post 1672090)
how do i do this please


its ok i did it by editing config.php file

KHALIK 11-26-2008 10:24 AM

Quote:

Originally Posted by camomouse (Post 1631329)
Code:

Database error in vBulletin 3.7.3:

Invalid SQL:

                        SELECT t.champion, u.userid FROM tournaments AS t
                        LEFT JOIN user AS u ON (t.champion = u.username)
                        WHERE champion<>'';

MySQL Error  : Unknown column 't.champion' in 'field list'
Error Number  : 1054
Request Date  : Friday, September 26th 2008 @ 08:57:34 PM
Error Date    : Friday, September 26th 2008 @ 08:57:35 PM
Script        : http://xaax.biz/forums/showthread.php?t=12346
Referrer      : http://xaax.biz/forums/halo_3/
IP Address    : 71.28.9.189
Username      : CamoMouse
Classname    : vB_Database
MySQL Version : 5.0.51b-community-nt


How do I get that to stop? There are now plugins installed of Tournaments. As far as I know, Tournaments should not exits on my site but I'm getting nothing but MySql errors when you visit my site. I need help.


Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Table 'fragmast_khalik59.tournaments' doesn't exist
Error Number : 1146
Request Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Error Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Script : http://www.fragmasters.co.uk/forum/s...ad.php?t=28186
Referrer : http://www.fragmasters.co.uk/forum/index.php
IP Address : 194.106.36.230
Username : Fragmaster
Classname : vB_Database
MySQL Version : 5.0.51a

I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.

How do I stop it ?

corizo 11-26-2008 01:49 PM

Feature Requests:
  1. Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
  2. It would be nice to add names without being them registered users
  3. Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
  4. Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
  5. Fight for 2nd and 3rd place in tournaments
  6. Being able to deactivate the ladder system if you don't need it

However, it's already a great modification! :)

Thanks for reading

OcR Envy 11-26-2008 01:54 PM

Quote:

Feature Requests:
  1. Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
  2. It would be nice to add names without being them registered users
  3. Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
  4. Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
  5. Fight for 2nd and 3rd place in tournaments
  6. Being able to deactivate the ladder system if you don't need it
However, it's already a great modification! :)

Thanks for reading
Agreed.

+ Requests:

1. Randomized Map/Gametype that is tournament specific.
2. Ability to Report Wins/Loses to Tournament Mod to make advancement quicker.
3. Addition to the vB Notification system for said reports and Team Invites/Requests to join.

Toupsx 11-26-2008 03:15 PM

Quote:

Originally Posted by djlotus (Post 1672187)
Is "OD" the correct table prefix?

yes.

dirtyfeast 11-26-2008 08:44 PM

Quote:

Originally Posted by KHALIK (Post 1673257)
I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.

How do I stop it ?

I want to say that is your arcade tournaments. No database tables with this mod have the word tournaments in it. They all start tmnt and than whatever the table is for. tournaments is a database table for the arcade system.

dirtyfeast 11-26-2008 08:46 PM

Quote:

Originally Posted by dirtyfeast (Post 1672417)
Code:

Database error in vBulletin 3.7.4:

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  : Monday, November 24th 2008 @ 09:04:15 PM
Error Date    : Monday, November 24th 2008 @ 09:04:16 PM
Script        : http://www.com/forum/competitions.php?do=ladderteamreject&id=3
Referrer      : http://www.com/forum/competitions.php?do=ladderteamchallenges
IP Address    : ************
Username      : **********
Classname    : vB_Database
MySQL Version : 5.0.51a-community

Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.

I want to add that this is with the Teams for the ladders. It works fine with just members of the forum joing the Player ladders. Could this issue be caused because you create a team name rather using the username of the forums.

Techno05 11-29-2008 12:10 AM

How can I place the postbit information under CSS?

Preview:
https://vborg.vbsupport.ru/external/2008/11/4.png

masterwebguy 11-29-2008 04:43 AM

How can I update my current version? Will it erase a tournament I currently have?

http://gamebend.com/forums/competiti...p?do=view&id=2

Revvin 11-29-2008 03:52 PM

Would it be possible for the system to send the challenging player a PM once the challenged player has accepted the challenge.

Also would it be a benefit to add the option to forfeit a match when challenged as wellas the accept and reject options. A player choosing to forfeit a match would result in the system automatically registering a loss to the forfeting player without the need for the challenging player to confirm the result.

At present there doesnot seem to be much of a penalty if a player decides once he's won a few matches and gained a good enough record he can sit at the top rejecting challenge after challenge?

Can we have an option for the admin to enter or confirm scores should a player be challenged and then either refuse to confirm the loss despite evidence to proove the loss or they just go AWOL for some reason.

Is it possible in vBulletin to have mods like this to use a separate theme?

MarceloS 11-30-2008 12:55 AM

Two tournaments completed (last man standing), and I still don't know how to give points to the players and how to classify them.

Can anyone help?

Gamelobby 11-30-2008 09:02 AM

Quote:

Originally Posted by mozik (Post 1669157)
Are you going to make it so we can edit our rosters and team leaders and can edit them. Like remove and invite people by username?

Maybe a button to get to your team.

And for challenges maybe have them so for each ladder they are separate, not just one list.

That would be cool.

or so that a social group can enter a tournament..!!?? (as a team)

Stifmeister2 12-02-2008 05:04 PM

Bananalive, this is a request many of our members would love:

The ability to assign certain members to moderate certain tournaments.

Currently I have only admins & super mods who can moderate tourneys... But some clan are organizing private tourneys and they'd like to moderate their own tourney. Ogf course I could make some secondary usergroup with the permissions (that would probably work?), and put one of the members in it. But I don't want that person to be able to moderate other tourneys!

That's why it would be a welcome additon to assign certain user(s) to moderate certain tourney(s).

GrendelKhan{TSU 12-03-2008 11:03 PM

Quote:

Originally Posted by Stifmeister2 (Post 1677159)
Bananalive, this is a request many of our members would love:


The ability to assign certain members to moderate certain tournaments.

Currently I have only admins & super mods who can moderate tourneys... But some clan are organizing private tourneys and they'd like to moderate their own tourney. Ogf course I could make some secondary usergroup with the permissions (that would probably work?), and put one of the members in it. But I don't want that person to be able to moderate other tourneys!


That's why it would be a welcome additon to assign certain user(s) to moderate certain tourney(s).

good idea :)

OcR Envy 12-04-2008 09:59 AM

After starting our first tournament I have another suggestion.

Link tournament discussion with forum threads.

Farcaster has done this with his Event Forums mod. The tournament discussion is essentially a thread, why not link it to a specific forum so it will auto create a discussion thread when the tournament is created. My members are finding it difficult to remember to check the tournament discussions. If a thread showed up on a new post search I think we'd have far more activity in the tournament.

jlew24asu 12-04-2008 11:03 AM

sigh. I had this same problem a while back and thought I would try again with the latest version.

still no luck.


a blank page loads when I try to create a new tournament. I know others had this problem. is there a fix? :(

P@trick 12-06-2008 01:11 PM

Hi I've got the same error like 2 other gus in this thread and there was no help till yet. so lets have a third try:

When I want to import the product I got:
Quote:

Importing Product, Please Wait...

[:]
I also tied to disable the plugin system, import and then activate, but nothing happens. So whats the Problem, maybe my SQL version (4.0.27) is to old?

King Fly 12-07-2008 12:03 AM

everything is working smooth for me now...have a last man standing, single elimination and ladder rankings all going on right now...my one suggestion would be what was already suggested ....the admins have the ablility to submit scores..i have some slackers on my ladder that arent entering their scores so it not rolling along as smoothly as i hoped

LT Mote 12-07-2008 07:29 PM

How many tables does this add to the current db?

rob01 12-08-2008 05:29 AM

do this work on vb 3.8?

P@trick 12-08-2008 02:34 PM

Quote:

Originally Posted by rob01 (Post 1680727)
do this work on vb 3.8?

yes

And again, please help me (and all the others who asked this question):
Quote:

Originally Posted by P@trick
Hi I've got the same error like 2 other gus in this thread and there was no help till yet. so lets have a third try:

When I want to import the product I got:
Quote:

Importing Product, Please Wait...

[:]
I also tied to disable the plugin system, import and then activate, but nothing happens. So whats the Problem, maybe my SQL version (4.0.27) is to old?


rob01 12-08-2008 02:50 PM

but i get this error

Warning: Unexpected character in input: ' in /home/robtbs/public_html/bbs/competitions.php on line 2432

Parse error: syntax error, unexpected T_IF in /home/robtbs/public_html/bbs/competitions.php on line 2434

any idea?

anyway P@trick this only happen with this mod? and what more happens after that?

jlew24asu 12-08-2008 02:53 PM

Quote:

Originally Posted by jlew24asu (Post 1678369)
sigh. I had this same problem a while back and thought I would try again with the latest version.

still no luck.


a blank page loads when I try to create a new tournament. I know others had this problem. is there a fix? :(

:confused: :(

yathyo 12-08-2008 03:02 PM

I'm testing the script, it looks great! But I got a problem. "Create Team" link does no appears :(

EDITED: Also Create new annoucement is not visible.

I have all permissions ON

Several bug detected, ie links pointing base forum not "competitions.php"

EDITED AGAIN :D : bananalive got a PM ;)

Thanks in advance ;)

bananalive 12-08-2008 05:18 PM

A security flaw was reported in v2.6.8. I strongly recommend you to upgrade to v2.6.9 as soon as possible.

Upgrading from v2.6.8 to v2.6.9
- re-upload competitions.php

jlew24asu 12-08-2008 05:44 PM

Quote:

Originally Posted by bananalive (Post 1681099)
A security flaw was reported in v2.6.8. I strongly recommend you to upgrade to v2.6.9 as soon as possible.

Upgrading from v2.6.8 to v2.6.9
- re-upload competitions.php

do you know of a reason why I still can not get this to work? a blank page loads when I try to create a tournament

bananalive 12-08-2008 06:47 PM

Quote:

Originally Posted by jlew24asu (Post 1681115)
do you know of a reason why I still can not get this to work? a blank page loads when I try to create a tournament

Find in competitions.php
Code:

        $days = cal_days_in_month(CAL_GREGORIAN, $month, $year);
Replace with
Code:

        //$days = cal_days_in_month(CAL_GREGORIAN, $month, $year);
Find in competitions.php
Code:

        if ($day > $days OR $day == 0) {
Replace with
Code:

        if (/*$day > $days OR */$day == 0) {

KrU$ty 12-08-2008 07:59 PM

<u>Feature Requests</u>

It would be good to have dates and times for when each challenge was made on the upcoming match list.

The admin should be able to see all challenges.

My league requires the person who is challenged to provide three dates and times that the challenger can choose from to set the match. This functionality would be good.

The ability for an admin to forfeit a match or delete a challenge or match.

The ability for an admin to change ELO, win/loss and streak etc.

Blumy 12-08-2008 11:03 PM

I need to update to the newest version, but I am currently running a tournament. Would anything happened if I went ahead with the update?

jlew24asu 12-09-2008 12:47 AM

Quote:

Originally Posted by bananalive (Post 1681150)
Find in competitions.php
Code:

        $days = cal_days_in_month(CAL_GREGORIAN, $month, $year);
Replace with
Code:

        //$days = cal_days_in_month(CAL_GREGORIAN, $month, $year);
Find in competitions.php
Code:

        if ($day > $days OR $day == 0) {
Replace with
Code:

        if (/*$day > $days OR */$day == 0) {

I really appreciate your support on this but its still not working :( blank page loads after I click add

http://www.chicagophotoshop.com/foru...php?do=addtmnt

bananalive 12-09-2008 08:39 AM

Quote:

Originally Posted by jlew24asu (Post 1681343)
I really appreciate your support on this but its still not working :( blank page loads after I click add

http://www.chicagophotoshop.com/foru...php?do=addtmnt

Upgrade to v2.6.9
Another person had same problem as you and the fix mentioned above fixed it for them.
Quote:

Originally Posted by Blumy (Post 1681289)
I need to update to the newest version, but I am currently running a tournament. Would anything happened if I went ahead with the update?

No tournament data should be lost during an upgrade.

jlew24asu 12-09-2008 09:52 AM

Quote:

Originally Posted by bananalive (Post 1681501)
Upgrade to v2.6.9
Another person had same problem as you and the fix mentioned above fixed it for them.

I did install 2.6.9 :(

juanpablo 12-09-2008 01:29 PM

where can I get the translation into Spanish?

Thanks

bananalive 12-09-2008 01:45 PM

1 Attachment(s)
Quote:

Originally Posted by jlew24asu (Post 1681525)
I did install 2.6.9 :(

Try uploading attached file
Quote:

Originally Posted by juanpablo (Post 1681644)
where can I get the translation into Spanish?

Thanks

I don't think there is one available, translate the custom phrases used in the modification

jlew24asu 12-09-2008 02:10 PM

Quote:

Originally Posted by bananalive (Post 1681651)
Try uploading attached file

I don't think there is one available, translate the custom phrases used in the modification

still blank :(

http://www.chicagophotoshop.com/foru...php?do=addtmnt

I noticed ajax_competitions.php in my root. is that cause some sort of conflict? im not sure what that is

Stifmeister2 12-09-2008 02:52 PM

Quote:

Originally Posted by Blumy (Post 1681289)
I need to update to the newest version, but I am currently running a tournament. Would anything happened if I went ahead with the update?

I updated last night and I had 2 ongoing tournaments - nothing happened to them. :)

Blumy 12-09-2008 03:12 PM

Okay, thanks.

King Fly 12-10-2008 07:32 PM

hmmm there was suppose to be an updated today....is that delayed?


All times are GMT. The time now is 05:32 AM.

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.02606 seconds
  • Memory Usage 1,861KB
  • 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
  • (11)bbcode_code_printable
  • (25)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