Forum Tournaments & Ladders

[EvilJohn]

Just installed. Thank you nice mod. I was hoping I could use teams in the ladder. :( Looks like users only. Teams also for ladders would be awesome feature.

[JAnders]

I just updated to the latest version and the elo system is great. However, I have some ladders already in progress.. and it's only calculation on a going forward basis how can I make it calculate for all the matches that were already played.

you can take a look to understand better:
http://fifamexico.net/foros/tournament.php?do=viewladder&id=1

[corazorback]

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT *
FROM tmnt_members JOIN tmnt_teams on tmnt_members.teamid = tmnt_teams.teamid WHERE tmnt_members.leader=1 AND tmnt_members.userid=3 AND tmnt_teams.noplayers >= 999 AND tmnt_teams.noplayerstmnt_teams.noplayers <= 1;

MySQL Error : Unknown column 'tmnt_teams.noplayerstmnt_teams.noplayers' in 'where clause'
Error Number : 1054
Request Date : Sunday, October 12th 2008 @ 09:44:16 PM
Error Date : Sunday, October 12th 2008 @ 09:44:16 PM
Script : http://www.mysite.net/tournament.php?do=join&id=1
Referrer : http://www.mysite.net/tournament.php?do=view&id=1
IP Address : XXXXXXXXXXXXXXXXX
Username : THEHATED
Classname : vB_Database
MySQL Version : 5.0.45-community-log

What do I do now??? It won;t let me join in created tournaments.

[JAnders]

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT *
FROM tmnt_members JOIN tmnt_teams on tmnt_members.teamid = tmnt_teams.teamid WHERE tmnt_members.leader=1 AND tmnt_members.userid=3 AND tmnt_teams.noplayers >= 999 AND tmnt_teams.noplayerstmnt_teams.noplayers <= 1;

MySQL Error : Unknown column 'tmnt_teams.noplayerstmnt_teams.noplayers' in 'where clause'
Error Number : 1054
Request Date : Sunday, October 12th 2008 @ 09:44:16 PM
Error Date : Sunday, October 12th 2008 @ 09:44:16 PM
Script : http://www.teamtoxicity.net/tournament.php?do=join&id=1
Referrer : http://www.teamtoxicity.net/tournament.php?do=view&id=1
IP Address : 75.70.245.87
Username : THEHATED
Classname : vB_Database
MySQL Version : 5.0.45-community-log

What do I do now??? It won;t let me join in created tournaments.

looks like there's an error in the sql statement 'tmnt_teams.noplayerstmnt_teams.noplayers' that looks like it's 2 columns not separated

[Chris11987]

Would we edit "ELO Rank" as "Score" in the Phrases, or templates?

[Spencey]

I'm getting this message now when trying to create a team tournament?

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT *
FROM tmnt_members JOIN tmnt_teams on tmnt_members.teamid = tmnt_teams.teamid WHERE tmnt_members.leader=1 AND tmnt_members.userid=4 AND tmnt_teams.noplayers >= 999 AND tmnt_teams.noplayerstmnt_teams.noplayers <= 1;

MySQL Error : Unknown column 'tmnt_teams.noplayerstmnt_teams.noplayers' in 'where clause'
Error Number : 1054
Request Date : Monday, October 13th 2008 @ 11:38:29 AM
Error Date : Monday, October 13th 2008 @ 11:38:29 AM
Script : http://www.mysite.com/forums/tournament.php?do=join&id=20
Referrer : http://www.mysite.com/forums/tournament.php?do=view&id=20
IP Address : XX.XXX.XX.XXX
Username : admin
Classname : vb_database
MySQL Version : 5.0.67-community

[corazorback]

looks like there's an error in the sql statement 'tmnt_teams.noplayerstmnt_teams.noplayers' that looks like it's 2 columns not separated

Any ideas on how I could fix this?? What if I do a complete fresh installation? Could I go in an clear out the MySQL Database for this mod?

[OcR Envy]

Can't say enough about this mod, the author is actually listening to our requests and keeping periodic updates.

Amazing work again Banana.

[bananalive]

getting thios error when entering a draw i.e 3-3 in fifa09
Sorry, fixed in next version.
Before I try out the new version (I'm still on 2.4.6), do I have to uninstall my current, or can I just overwrite it? Because I remember a lot of problems with tables/fields that were going on during some upgrades before, where something wasn't being overwritten properly.
Upgrade otherwise you will lose your tournament/ladder data.
Would we edit "ELO Rank" as "Score" in the Phrases, or templates?
Edit phrase ladder_elorating
I'm getting this message now when trying to create a team tournament?

Database error in vBulletin 3.7.3:
Sorry, fixed in next version.

[Chris11987]

I want to make the file twice and have one name tournament and one named ladder. Simple enough, but where would I go to edit the url for things like "tournament.php&do=__________"? Is that inside the tournament.php file?

Also, where it says "Forums > Tournaments > Ladders" in the navbar, how would I make it so it doesn't say "Tournaments" when I'm on a ladders page.

[bananalive]

I want to make the file twice and have one name tournament and one named ladder. Simple enough, but where would I go to edit the url for things like "tournament.php&do=__________"? Is that inside the tournament.php file?
tournament.php?do=X
if ($_REQUEST['do'] == 'X') {
//code here
}Also, where it says "Forums > Tournaments > Ladders" in the navbar, how would I make it so it doesn't say "Tournaments" when I'm on a ladders page.
Remove from each ladder page.
'tournament.php' . $vbulletin->session->vars['sessionurl_q'] => $vbphrase['tmnts']
Bu I would recommend you just changing $vbphrase['tmnts'] to your own custom phrase $vbphrase['customphrasename']

[JAnders]

I just updated to the latest version and the elo system is great. However, I have some ladders already in progress.. and it's only calculation on a going forward basis how can I make it calculate for all the matches that were already played.

you can take a look to understand better:
http://fifamexico.net/foros/tournament.php?do=viewladder&id=1
mr banana any word on this?:(

[bananalive]

I just updated to the latest version and the elo system is great. However, I have some ladders already in progress.. and it's only calculation on a going forward basis how can I make it calculate for all the matches that were already played.

you can take a look to understand better:
http://fifamexico.net/foros/tourname...iewladder&id=1


mr banana any word on this?:(
I can't think of a way atm, but if I can I will post it here.

[JAnders]

btw I love this mod and the direction is going, I always find it very hard to know what was changed or modified from version to version.

I can help you document as you add functionality and bug fixes. so you can post what changed in the current version. e-mail me if you'll like me to help

[bananalive]

btw I love this mod and the direction is going, I always find it very hard to know what was changed or modified from version to version.

I can help you document as you add functionality and bug fixes. so you can post what changed in the current version. e-mail me if you'll like me to help

Thanks for your offer. I try and keep a version history in second post of thread here (https://vborg.vbsupport.ru/showpost.php?p=1609081&postcount=2)

[Antek]

Next idea: auto creata event

[JAnders]

the most important feature we currently need is option to manually update ladder challanges as an admin.

and the option for users to drop out of a ladder

[gamerscms]

Thanks for a further update :)
would be great to see teams in ladders, will we be seeing this feature?

[bananalive]

Thanks for a further update :)
would be great to see teams in ladders, will we be seeing this feature?
Yes, it was one of the main reasons for combining the two modifications.

[butler312]

Absolutely wonderful mod. With the ELO rating you have exactly what I've been looking for. Donation will come as soon as I get paid next (I know I should have donated earlier anyways, but oh well).

One suggestion I remember from earlier that I thought I would bring back up is the ability for the admin/moderators to sticky certain tournaments/ladders.

[gamerscms]

One suggestion I remember from earlier that I thought I would bring back up is the ability for the admin/moderators to sticky certain tournaments/ladders.

You can do that now with the latest version :)

[gamerscms]

Yes, it was one of the main reasons for combining the two modifications.

Thats great news to hear look forward to it.

[camomouse]

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE usergroup ADD tournamentpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'tournamentpermissions'
Error Number : 1060
Request Date : Monday, October 13th 2008 @ 10:25:52 PM
Error Date : Monday, October 13th 2008 @ 10:25:52 PM
Script : http://xaax.biz/forums/admincp/plugin.php?do=productimport
Referrer : http://xaax.biz/forums/admincp/plugin.php?do=productadd
IP Address : xxx
Username : CamoMouse
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt

[SpiderFive]

is there a new version for the future without fatal erros ?

[gorentals]

Having an issue. After a tournament has started we have a couple members that for some reason don't want to be part of it. How do we swap them out with an alternative player? I have several going and we cannot continue as we have some holdups.

Thanks

[bananalive]

Database error in vBulletin 3.7.3:
Attached product file has fixed code
is there a new version for the future without fatal errors ?
All errors found get fixed as soon as possible (within a day or two). It is possible for me to test every eventuality to check for every bug which is why some people get errors. As of this post all reported errors have been fixed.
Having an issue. After a tournament has started we have a couple members that for some reason don't want to be part of it. How do we swap them out with an alternative player? I have several going and we cannot continue as we have some holdups.

Thanks
Players can only be swapped for LMS atm

[P.Jackson]

i think the ability to view match results in the ladder for each user , scores who played who date etc would be a a great addition to the ladders.

example
http://www.enemydown.co.uk/clanresults.php?id=44773

[gorentals]

Players can only be swapped for LMS atm

Ok thanks. Shoot my tournaments are Single Elimination. That is exactly what I want to do is swap players, but I guess I can't in SIngle Eliminiation. Is this something you are looking at doing in the future?

Thanks again

[bananalive]

Ok thanks. Shoot my tournaments are Single Elimination. That is exactly what I want to do is swap players, but I guess I can't in SIngle Eliminiation. Is this something you are looking at doing in the future?
Yes it will come soon, not sure when.

[butler312]

You can do that now with the latest version :)

Really, how. I have the latest script installed but don't see it.

[schlottkej]

Banana...

I noticed you removed the $html from the files, but now nothing loads...

http://www.thewrestlingtalk.com/tournament.php

Any suggestions?

[KHALIK]

nice work with the elo system.

Next would love to see a double elimination system enabled.

[oBEAVISo]

Great Mod .. Installed and no issues, fingers crossed. Thanks.

[SpiderFive]

.....

All errors found get fixed as soon as possible (within a day or two). It is possible for me to test every eventuality to check for every bug which is why some people get errors. As of this post all reported errors have been fixed.

......
sorry..
can we upgrade from each version , or must wie upgrade step by step

[P.Jackson]

Banana...

I noticed you removed the $html from the files, but now nothing loads...

http://www.thewrestlingtalk.com/tournament.php

Any suggestions?


If you have upgraded and in the past changed any of the templates you must revert them :)

[EWGF]

Haven't upgraded in a while... wow, nice improvements :D

[bananalive]

Really, how. I have the latest script installed but don't see it.
Edit tournament and at the bottom there is option to sticky tournament to appear at top of tournaments list
Banana...

I noticed you removed the $html from the files, but now nothing loads...

http://www.thewrestlingtalk.com/tournament.php

Any suggestions?
Try reverting all tournament templates

(Edit: just visited your board and you can view pages for 'Transparent' style so you must have edited the templates)
can we upgrade from each version , or must wie upgrade step by step
Yes, just upgrade to latest version.

[bananalive]

Just released v2.5.5 with new tournament layout

Players can only be swapped for LMS atm

Ok thanks. Shoot my tournaments are Single Elimination. That is exactly what I want to do is swap players, but I guess I can't in SIngle Eliminiation. Is this something you are looking at doing in the future?

Thanks again

Added in v2.5.5

[JAnders]

awesome can version 2.5.5 also remove players from ladders?

[bananalive]

awesome can version 2.5.5 also remove players from ladders?

No, but I have been thinking about it though... I think it would have to just 'deactivate' player to prevent those with less than starting rank, leaving the ladder, then returning and getting their rating reset.

[JAnders]

No, but I have been thinking about it though... I think it would have to just 'deactivate' player to prevent those with less than starting rank, leaving the ladder, then returning and getting their rating reset.

right I think something like active = Y and if we remove him active = N then if the user wants to join again on a later time by him clicking join will activate the account.

Of course he wouldn't start from scratch he would just resume wherever he left off when he was deactivated.

[gorentals]

Awesome Bananalive. I'm off to install it now. Thanks for the great mod!

[gorentals]

Ok everything looks good. Except the brackets are broken up. If someone hasn't won there match yet, it doesn't show a box and looks kinda funny.

[gamerscms]

Tournament mod working perfect, thanks for the new update.

[Chris11987]

I just installed the newest version. I haven't gotten around to testing it yet, but I noticed an error in the style. The one in the top bar is on every page, and the one on the right is for ladder pages only:

http://img406.imageshack.us/img406/9850/tourneyserrorjo7.png

Suggestions/Feedback:
- To be able to change the amount of tournaments/ladders to be shown under the 'Recent ___" listings on the main page.
- Ability to swap players position in a tournament.
- Ability to edit ranks for a team from Member - Leader
- I think the elo needs to be tweaked a little. The losing person shouldn't lose the same amount of points as the winning person gains.
- Just me being picky, but I think the ladder stat list should be displayed "wins, losses, draws, streak", rather than the current "streak, wins, draws, losses".

Also, again, everyone remember to vote this for MOTM!:
https://vborg.vbsupport.ru/showthread.php?t=192376

[bananalive]

Ok everything looks good. Except the brackets are broken up. If someone hasn't won there match yet, it doesn't show a box and looks kinda funny.
I've added some spaces to make it display better
I just installed the newest version. I haven't gotten around to testing it yet, but I noticed an error in the style. The one in the top bar is on every page, and the one on the right is for ladder pages only:

http://img406.imageshack.us/img406/9850/tourneyserrorjo7.png

Cheers fixed

- I think the elo needs to be tweaked a little. The losing person shouldn't lose the same amount of points as the winning person gains.

It should only do that if two players have same rank, otherwise it works out the probability of win.

[P.Jackson]

Also i think the ability to have a image of the game the ladder or tournament is in the decription would be great!

[mlthmp]

I just updated to the newest version.

I am still having one of the same issues Chris11987 was having. I still have a "gap area" between the Announcements and Tournaments links when viewing tournament.php

[bananalive]

I just updated to the newest version.

I am still having one of the same issues Chris11987 was having. I still have a "gap area" between the Announcements and Tournaments links when viewing tournament.php
I'm just about to released v2.5.7 which includes the fix.

[JAnders]

is the new version going to have the option to include user custom fields?

they really want the gamertag and the msn of the participants displayed

[mlthmp]

Installed latest version. The Rules link is now showing up. However when you click on it it gives you a DB error.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'smallbal_vbforums.vb_tmnt_rules' doesn't exist
Error Number : 1146

Installed with yes for overwrite selected.

[gamerscms]

Testing latest release, will report any bugs i find.

[bananalive]

Installed latest version. The Rules link is now showing up. However when you click on it it gives you a DB error.

Database error in vBulletin 3.7.2:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'smallbal_vbforums.vb_tmnt_rules' doesn't exist
Error Number : 1146

Installed with yes for overwrite selected.
have you tried the rules fix here (https://vborg.vbsupport.ru/showpost.php?p=1641238&postcount=712)

[MarceloS]

Hi!

When I try to import the product, i get this:

Database error in vBulletin 3.7.2:

Invalid SQL:
ALTER TABLE vbpd_tmnt_tmnts ADD threadid INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'threadid'
Error Number : 1060

[Timmsy]

Same here MarceloS

[darkforce114]

Same here MarceloS

Same issue.

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE tmnt_tmnts ADD threadid INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'threadid'
Error Number : 1060

[mlthmp]

have you tried the rules fix here (https://vborg.vbsupport.ru/showpost.php?p=1641238&postcount=712)



:o

Nope, I missed that one. Im sorry.. That did the trick! Thanks!

[TrIn@dOr]

Same here.

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;

MySQL Error : Duplicate column name 'rank'
Error Number : 1060

[IGCEMA]

Same problem as above.

[P.Jackson]

anyone got any ideas how to place an image into the description?

[JAnders]

the guys with the alter issue?

what version are you updating to? I'm looking at the xml for the lastest version and I don't see the alter statement is giving you a hard time.

[Revvin]

Will there be a feature to add a separate rules page for each ladder/tournament and can ladder challenges be automatically PM'd to the challenger?

[Fivetide]

this looks great !

[bananalive]

For those with database errors which version are you upgrading from?

[powerbook]

Upgrading from 2.4.9

For those with database errors which version are you upgrading from?

[drmitaly]

<font color="DarkRed">Database error in vBulletin 3.7.0:

Invalid SQL:
ALTER TABLE vb_tmnt_tmnts ADD threadid INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'threadid'
Error Number : 1060</font>

im not upgrading.
Its a new install of 2.5.7

... can you help me?

[Timmsy]

For those with database errors which version are you upgrading from?

im not upgrading.
Its a new install of 2.5.7

[msimonds]

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!!!

[bananalive]

For New Installs:
Use 88248 to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Then import 88249 which is updated product file for mod

For upgrades:
Import 88249 which is updated product file for mod

[RK1gaming]

ok thanks ... just got the error and came back for you new xml and saw this post ..

[powerbook]

ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;


For New Installs:
Use 88248 to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Then import 88249 which is updated product file for mod

For upgrades:
Import 88249 which is updated product file for mod

[bananalive]

ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;

Are you new install or upgrade?

[conker1]

i got this error

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO `vbtmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here');

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062

and errorfix2008.xml

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vbusergroup DROP COLUMN tournamentpermissions;;

MySQL Error : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number : 1091

[powerbook]

I had a install...Run the errorfix checked DB removed tables then run install..

Are you new install or upgrade?

[bananalive]

i got this error



Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here')");

[powerbook]

There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...

I had a install...Run the errorfix checked DB removed tables then run install..

[bananalive]

I had a install...Run the errorfix checked DB removed tables then run install..

The product-errorfix.xml has code (see below) to remove ladder players data tables so you should not get multiple column error.
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");

[bananalive]

There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...
it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.

[powerbook]

From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");


it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.

[bananalive]

From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
Everything in installcode execs on product install and everything in uninstall execs on product uninstall
<code version="2.4.2.1">
<installcode><![CDATA[
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`description` text NOT NULL,
`noplayers` int(3) NOT NULL,
`status` int(3) NOT NULL,
`cr_userid` int(10) NOT NULL,
`cr_username` varchar(100) NOT NULL,
`cr_time` int(10) NOT NULL,
`cr_ip` varchar(100) NOT NULL,
`ed_userid` int(10) NOT NULL,
`ed_username` varchar(100) NOT NULL,
`ed_time` int(10) NOT NULL,
`ed_ip` varchar(50) NOT NULL,
`threadid` int(10) NOT NULL,
`views` int(10) NOT NULL default '0',
`winpoints` int(10) NOT NULL default '2',
`drawpoints` int(10) NOT NULL default '1',
`losepoints` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
`id` int(11) NOT NULL auto_increment,
`u` int(10) NOT NULL,
`u2` int(10) NOT NULL,
`time` int(10) NOT NULL,
`accepted` int(10) NOT NULL,
`lid` int(11) NOT NULL,
`score_u` int(20) NOT NULL,
`score_u2` int(20) NOT NULL,
`agree_u` int(10) NOT NULL,
`agree_u2` int(10) NOT NULL,
`finished` int(10) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
`id` int(11) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`username` varchar(100) NOT NULL,
`lid` int(11) NOT NULL,
`time` int(10) NOT NULL,
`ip` varchar(100) NOT NULL,
`wins` int(10) NOT NULL,
`draws` int(10) NOT NULL,
`loses` int(10) NOT NULL,
`challenges` int(10) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM");
]]></installcode>
<uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
</code>

[powerbook]

Sorry only realized that after I posted..

Everything in installcode execs on product install and everything in uninstall execs on product uninstall
<code version="2.4.2.1">
<installcode><![CDATA[
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL,
`description` text NOT NULL,
`noplayers` int(3) NOT NULL,
`status` int(3) NOT NULL,
`cr_userid` int(10) NOT NULL,
`cr_username` varchar(100) NOT NULL,
`cr_time` int(10) NOT NULL,
`cr_ip` varchar(100) NOT NULL,
`ed_userid` int(10) NOT NULL,
`ed_username` varchar(100) NOT NULL,
`ed_time` int(10) NOT NULL,
`ed_ip` varchar(50) NOT NULL,
`threadid` int(10) NOT NULL,
`views` int(10) NOT NULL default '0',
`winpoints` int(10) NOT NULL default '2',
`drawpoints` int(10) NOT NULL default '1',
`losepoints` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
`id` int(11) NOT NULL auto_increment,
`u` int(10) NOT NULL,
`u2` int(10) NOT NULL,
`time` int(10) NOT NULL,
`accepted` int(10) NOT NULL,
`lid` int(11) NOT NULL,
`score_u` int(20) NOT NULL,
`score_u2` int(20) NOT NULL,
`agree_u` int(10) NOT NULL,
`agree_u2` int(10) NOT NULL,
`finished` int(10) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
`id` int(11) NOT NULL auto_increment,
`userid` int(10) NOT NULL,
`username` varchar(100) NOT NULL,
`lid` int(11) NOT NULL,
`time` int(10) NOT NULL,
`ip` varchar(100) NOT NULL,
`wins` int(10) NOT NULL,
`draws` int(10) NOT NULL,
`loses` int(10) NOT NULL,
`challenges` int(10) NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM");
]]></installcode>
<uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
</code>

[conker1]

Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.
$vbulletin->db->query_write("
INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here')");

i did, new error message

Database error in vBulletin 3.7.3:

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

MySQL Error : Duplicate column name 'tmnt_joins'
Error Number : 1060

and thanks for reply

[RK1gaming]

never mind brain cramp

[fernas]

My suggestions:

- Teams for ladders.
- vbAdvanced modules for newest teams and recent matches.

Tnis hack is great!!

[Antek]

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number : 1146
Request Date : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date : Saturday, October 18th 2008 @ 12:36:58 PM
Script : http://xxx/tournament.php?do=rules
Referrer : http://xxx/tournament.php?do=view&id=8
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.37-standard

[bananalive]

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:
Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number : 1146
Request Date : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date : Saturday, October 18th 2008 @ 12:36:58 PM
Script : http://xxx/tournament.php?do=rules
Referrer : http://xxx/tournament.php?do=view&id=8
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.37-standard
have you tried the rules fix here (https://vborg.vbsupport.ru/showpost.php?p=1641238&postcount=712)

[bananalive]

i did, new error message

Database error in vBulletin 3.7.3:

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

MySQL Error : Duplicate column name 'tmnt_joins'
Error Number : 1060

and thanks for reply

Re-import 88261 (this is modified version just for you) and then try installing product-tournament2008.xml

[Antek]

bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php

Database error in vBulletin 3.7.3:

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

MySQL Error : Table 'xxx.vb_tmnt_announcements' doesn't exist
Error Number : 1146
Request Date : Saturday, October 18th 2008 @ 07:18:31 PM
Error Date : Saturday, October 18th 2008 @ 07:18:32 PM
Script : http://xxx/tournament.php
Referrer : xxx/
IP Address : xxx
Username : xxx
Classname : vB_Database
MySQL Version : 5.0.37-standard

[bananalive]

bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php

You are missing table which means you need to reinstall product.

[Antek]

Ops :D It's working now :)

[Chris11987]

I'm on 2.5.5 and I have some usergroups that are set to be unable to view any ladders, however, these usergroups are able to see them and see the rankings and everything.

[RK1gaming]

Did the update and fixed the error with the database -

Allowed a small number of people to use the system right now ...

But I don't see an option to turn off in post bit till I am ready for public release .... itsnot in

VBoptions--->Turn... options

[P.Jackson]

just empty the tournamant postbit template

[TrIn@dOr]

Uninstalled & Installed worked.

[chriskellar]

I've been looking over all the posts here and I've done everything stated but I still get an issue when trying to upgrade the tournament script to the new version.

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 : Saturday, October 18th 2008 @ 08:28:45 PM
Error Date : Saturday, October 18th 2008 @ 08:28:45 PM

Suggestions?

[butler312]

I noticed that when you sticky a tournament it doesn't sticky on the tounament.php page, just the tournament.php?do=tournaments. Is this supposed to be like this?

[RK1gaming]

just empty the tournamant postbit template

Yea I know that but I think that in the above description it says option to turn off that function ... that's what I want the availability to turn it off and on as I see fit not have it just show up in the postbit...

I also have a few skins some light ones that this hack works great in but a dark on that the brackets don't show up in because of the dark back ground on the skin ...

Where can I play with this to get it to work on all my skins

[shane greer]

Ok Im running this and liking it but a question.

I ran a few test tournaments then set it up so my players could join in but the tournament winners/joined info is out of synch due to my test tournaments.

Can I reset it now we are going live and if so how??

[bananalive]

I'm on 2.5.5 and I have some usergroups that are set to be unable to view any ladders, however, these usergroups are able to see them and see the rankings and everything.
Check their secondary usergroups; if that doesn't work can you pm me the settings for that usergroup(s) and the place where it doesnt work and I will look into it.
I've been looking over all the posts here and I've done everything stated but I still get an issue when trying to upgrade the tournament script to the new version.

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 : Saturday, October 18th 2008 @ 08:28:45 PM
Error Date : Saturday, October 18th 2008 @ 08:28:45 PM

Suggestions?
Remove that line from product file.
I noticed that when you sticky a tournament it doesn't sticky on the tounament.php page, just the tournament.php?do=tournaments. Is this supposed to be like this?
Yes, frontpage shows latest 5 tournaments
Yea I know that but I think that in the above description it says option to turn off that function ... that's what I want the availability to turn it off and on as I see fit not have it just show up in the postbit...

I also have a few skins some light ones that this hack works great in but a dark on that the brackets don't show up in because of the dark back ground on the skin ...

Where can I play with this to get it to work on all my skins
open template tmnt_results find and replace all instances of #000000 and replace with another html colour
Ok Im running this and liking it but a question.

I ran a few test tournaments then set it up so my players could join in but the tournament winners/joined info is out of synch due to my test tournaments.

Can I reset it now we are going live and if so how??
The only way atm, is manually through phpmyadmin.

[shane greer]

The only way atm, is manually through phpmyadmin.

Can you advise how to do that??

[Toupsx]

Can you advise how to do that??

Go to your database through phpmyadmin find the table called YOUR PREFIX tmnt_tmnts
(your prefix will be w/e you used for your Vbulletin prefix for the tables) and find the tournaments that you used to test.. and just delete them from the table. It will take the stats of the users out that were in it and everything will be all good :)

[chriskellar]

I've tried that plus doing all the extra edits that continues to display. Is there another way to remove the old product to do a fresh install?

This is the error message I get when trying to uninstall the old product.

Database error in vBulletin 3.7.3:

Invalid SQL:

DROP TABLE vB_tmnt_tmnts;;

MySQL Error : Unknown table 'vB_tmnt_tmnts'
Error Number : 1051
Request Date : Sunday, October 19th 2008 @ 09:20:51 PM
Error Date : Sunday, October 19th 2008 @ 09:20:51 PM

If I need to drop the tables manually in phpmyadmin can you tell me which tables I need to remove?

I have Tournament 1.3 and I did have the ladders 1.0 (I believe) but that uninstalled properly but won't reinstall at all.

Thanks can't wait to get this up and running.

[Dragonsys]

If I need to drop the tables manually in phpmyadmin can you tell me which tables I need to remove?

any tables that start with vB_tmnt

[chriskellar]

any tables that start with vB_tmnt

Any others that might need to be dropped as well?

[Chris11987]

Any others that might need to be dropped as well?

There's a COLUMN for the tournaments underneath the "usergroups" table. There might be one under "users" as well. DON'T DELETE THOSE TABLES, only delete the COLUMN INSIDE those tables.

[bananalive]

Why uninstall it manually when you can just click uninstall in admincp, which removes all data :confused:

[Chris11987]

Fix needed:
- If a team edits their name, and are already entered in a tournament, the tournament bracket doesn't update their new name.

Permissions Suggestions:
- Tournament Options: Option to allow a tournament creator to advance/edit/delete a tournament they start.
- Perhaps a "Co-Leader" rank for teams? Seeing as only the leader can perform many functions, how about another rank that can be given those permissions by the leader. (Maybe all team permissions for that specific team, except for deletion)

[bananalive]

Permissions Suggestions:
- Tournament Options: Option to allow a tournament creator to advance/edit/delete a tournament they start.
Tournament creators' should/ do have full control over their own tournaments.

[RK1gaming]

thanks for the html edit ... did you see my post about the postbit ... are u going to add a way to turn it off and on or do I need to just blow away the post bit templates like the poster 2 pages back said ??

[bananalive]

thanks for the html edit ... did you see my post about the postbit ... are u going to add a way to turn it off and on or do I need to just blow away the post bit templates like the poster 2 pages back said ??
I have tried to do it before and couldn't find a way. However, I have just thought of a way to do it and I'll add it in the next version.

[chriskellar]

Why uninstall it manually when you can just click uninstall in admincp, which removes all data :confused:

I've tried that many times and it won't work. This is the error I get when trying to uninstall it.

Database error in vBulletin 3.7.3:

Invalid SQL:

DROP TABLE vB_tmnt_tmnts;;

MySQL Error : Unknown table 'vB_tmnt_tmnts'
Error Number : 1051
Request Date : Monday, October 20th 2008 @ 11:48:22 AM
Error Date : Monday, October 20th 2008 @ 11:48:23 AM

[bananalive]

I've tried that many times and it won't work. This is the error I get when trying to uninstall it.

Database error in vBulletin 3.7.3:

Invalid SQL:

DROP TABLE vB_tmnt_tmnts;;

MySQL Error : Unknown table 'vB_tmnt_tmnts'
Error Number : 1051
Request Date : Monday, October 20th 2008 @ 11:48:22 AM
Error Date : Monday, October 20th 2008 @ 11:48:23 AM
Admincp -> Plugins & Products -> Manage Products -> Edit vB Tournaments and Ladders -> Existing Install/Uninstall Code ( You may need to scroll down page to see it)
For every Uninstall Code box (all the ones on the right) change DROP TABLE to DROP TABLE IF EXISTS in product

[SpiderFive]

no problems:)

[RK1gaming]

yup upgraded no problems ... so far I am liking this add in ... very nice

I would add in the following for your next build or future builds

The ability to add in more Tournament Modes: - I know we would use more or custom ones for our site

I like the post bit and the bracket colors I think thats a good add in ... keep up the good work

[chriskellar]

Admincp -> Plugins & Products -> Manage Products -> Edit vB Tournaments and Ladders -> Existing Install/Uninstall Code ( You may need to scroll down page to see it)
For every Uninstall Code box (all the ones on the right) change DROP TABLE to DROP TABLE IF EXISTS in product

Ok tried that and got a different error.

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_usergroup DROP COLUMN tournamentpermissions;;

MySQL Error : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number : 1091
Request Date : Monday, October 20th 2008 @ 12:58:01 PM
Error Date : Monday, October 20th 2008 @ 12:58:01 PM

I tried to put "IF EXISTS" for that part, but it gives me a sql error.

[bananalive]

Ok tried that and got a different error.

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_usergroup DROP COLUMN tournamentpermissions;;

MySQL Error : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number : 1091
Request Date : Monday, October 20th 2008 @ 12:58:01 PM
Error Date : Monday, October 20th 2008 @ 12:58:01 PMI tried to put "IF EXISTS" for that part, but it gives me a sql error.
Unfortunately that mysql function (DROP COLUMN IF EXISTS) doesn't exist so just remove that query

[chriskellar]

Unfortunately that mysql function (DROP COLUMN IF EXISTS) doesn't exist so just remove that query

Ok got it uninstalled. Now I'm moving forward with installing the upgraded version and here is the error that I'm getting.

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

[The DaveyG]

This is great. Has a player invite system been set up yet? I don't see one and would love the feature. Also a league setup would be awesome. Thanks for this mod.

[butler312]

This is great. Has a player invite system been set up yet? I don't see one and would love the feature. Also a league setup would be awesome. Thanks for this mod.

A league would be freaking sweet, that automatically would generate schedules and then have playoff options and all sorts of stuff. But that is almost a completely different mod. What might be a good idea in the future though from banana's perspective is to make that a professional mod that will integrate with this one.

[jackapup]

Are you going to featuring a double elimination function anytime soon with the script?

[Chris11987]

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]

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]

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]

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]

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]

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]

Getting a error on the latest install

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]

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]

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.
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
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
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.

Getting a error on the latest install

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]

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
Ok got it uninstalled. Now I'm moving forward with installing the upgraded version and here is the error that I'm getting.

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

[fodvapor]

Request :

Can you add a double elimination option ? :)

[gamerscms]

Cheers banana fixed my error other than that silly error i look forward to more great features.


GREAT WORK :)

[gamerscms]

Can't seem to join a tournament once i created a team i get the following message:

You are not Leader of any team which can join this tournament. Click here to go back to the tournament.

any ideas why i would be getting this message?

EDIT: ok small problem if the selected number of players are not in the team before you join a tournament you get the above message which will confuse some members can you edit the message to say there are not enough members in the team to join this tournament please add more members, etc

[chriskellar]

Sweet.

Finally got everything going. Looks great so far. I like the furture updates, and I would even suggest maybe allowing more of a tree like structure so you can easily separate the ladders into different sections (IE Xbox, Playstation, PC) and maybe even allow a second tier for more advanced separation into game types (Sports, First Person Shooters)

I would also look at expanding the information for each team in each members personal page. That way it will be easier to see what team a member is on by clicking their profile page. Maybe even making it a mini stat on the site. Just a thought.

[john102774]

Good stuff! Keep up the GREAT work BananaLive!

Waiting on 2.5.9. :D

[MarceloS]

Suggest feature:
1. Images in postbit for winners (like one gold medal per win, silver for 2nd and bronze for 3rd)
2. Leagues (like a racing league, each tournament gives out points according to position and a leaderboard)
2.1. League position and/or points in postbit
2.2. (related to suggestion 1): trpy image in post-bit for the winner of the league.

Any way, congrats on the mod, it's great!

By the way, I don't understand what a ladder...

[MarceloS]

It's like a league?

[butler312]

Are there any plans to increase the maximum number of players for each tournament? 64 would really be ideal for me, and I would absolutely love the chance to try for 128.

[mozik]

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


I upload all the files needed. Then when im importing the product i get this error. I do use overwrite.

[bananalive]

That query is not in the product file, make sure you are importing the correct file (product-tournament2008.xml) as a product file.

(AdminCP -> Plugins & Products -> Manage Products -> [Add/Import Product])
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


I upload all the files needed. Then when im importing the product i get this error. I do use overwrite.

[mozik]

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO `tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here');

MySQL Error : Duplicate entry '1' for key 1
Error Number : 1062
Request Date : Thursday, October 23rd 2008 @ 04:00:18 PM
Error Date : Thursday, October 23rd 2008 @ 04:00:19 PM
Script : http://www.vzrgaming.com/admincp/plugin.php?do=productimport
Referrer : http://www.vzrgaming.com/admincp/plugin.php?do=productadd
IP Address : *************
Username : **********
Classname : vB_Database
MySQL Version : 5.0.45-community-log


Now i get this.


And this when clicking tournaments

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 : Thursday, October 23rd 2008 @ 04:01:53 PM
Error Date : Thursday, October 23rd 2008 @ 04:01:55 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

[bananalive]

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO `tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here');



Remove that line from product file and try reimporting product

[bananalive]

My computer hard-drive has been corrupted (not sure how) unfortunately this means there will be no new releases until I get a new pc or hard drive. The only access to the internet I will have (until my pc is fixed) will be on public computers so support will be limited during this time.

(I will be back online shortly today on public computer to help those who are having problems with upgrades.)

[gamerscms]

Sorry to hear that banana, hope to see you back soon :)

[MarceloS]

Another suggestion (this is big for me, and I saw other post about that):

Allow us to edit the number of slots. If I have a tournament with 100 slots, will I have to click "+" 99 times?

By the way, nominated and installed, of course.

[EHSkaRMa]

Just marked as uninstalled. I had the first version going ok, then tried to update it and now have nothing but mysql errors. IF this product gets to the point where it dont mess with the rest of the board functions, I might reinstall it.

Till then, Im stuck with a half uninstalled script that generates database errors. Thanks

[XStealth6]

BananaLive,

Post your Paypal Email. I think on behalf on everyone on this thread, i think we can all chip in here and buy you a new harddrive/parts you need if we all donated to you for your support, fast response times, and updates.

I think that is fair and everyone here should agree.

I'm donating the first 10$ towards this. please PM/Post your paypal email for donation.

[Gleedo]

Hello, firstly great mod, im loving it :)

I do have a minor problem, but i dont know if its something i should post here...

When i view the ladder challenges page, its renders nicely under one template (dark one), but not under the green one. The text in the column headers dont wrap like in the dark one.

Any ideas how i should go about fixing this? Be warned, i am a total noob as of today in vBulletin land:

Dark Template
https://vborg.vbsupport.ru/

Bad one
https://vborg.vbsupport.ru/

[bananalive]

Update: I've got my PC working again (with new hard drive). Unfortunately I've lost all my data, including some of the new features for this modification I've been working on. There wont be any new releases until my pc is back functioning how i like it with all the proghrams installed.

[Mahar]

What exactly is this for though? I mean can we have a tournament set so it tries to boost activity around the forums? Something such as "Tournament for whoever can get the most meaningful posts within one month"? Something like that? If possible, That would be awesome...I just want to know a little about it before I install it.

[Gleedo]

What exactly is this for though? I mean can we have a tournament set so it tries to boost activity around the forums? Something such as "Tournament for whoever can get the most meaningful posts within one month"? Something like that? If possible, That would be awesome...I just want to know a little about it before I install it.

I can tell you this is a great little mod. Im gutted because only 3 or so weeks ago, i paid $120 for some ladders and tounrmanetns scripts to run on a dedicated ladder site that isnt anywhere near as good or easy to use as this mod....dang it lol

Ive added this mod to my new site for testing and its really good. Will be great for holding friendly clan tournaments as well as having guests join ladders and tournaments too.

Best mod ive found yet and i voted for it too :)

[Shop]

BananaLive,

1. In previous versions you can see who joined the tournament, for some reason I can't see who has joined my tournaments.

2. Also how do you unsticky a tournament. It only has a delete option, now that it's finished. I don't want to delete it but I want to unsticky it so that when people look at the tournament list the one that needs to be filled is on top.

also looking forward to the invite option for teams, keep up the good work.

[Koidl]

hello,

very nice add on but unfortunately "Create Tournament" not work i can fill in all information after clicking ADD i end on a white side the rest is working fine like Ladder ..

thx

[gamerscms]

What exactly is this for though? I mean can we have a tournament set so it tries to boost activity around the forums? Something such as "Tournament for whoever can get the most meaningful posts within one month"? Something like that? If possible, That would be awesome...I just want to know a little about it before I install it.

Why not try and read the opening post to the mod, that would help a lot to find out.

[djlotus]

When i view the ladder challenges page, its renders nicely under one template (dark one), but not under the green one. The text in the column headers dont wrap like in the dark one.


Anyone have a quick fix for this before I start to dissect my templates?

[WNxWakko]

2.5.8 database error when I try to confirm someone's score (a draw, both with one point)

Database error in vBulletin 3.6.8:

Invalid SQL:
UPDATE tmnt_ladder_players SET wins = wins + 1, wstreak = wstreak + 1, lstreak = 0, latime =1225138471, rank = 1012.1368737784, uod = 1 WHERE lid = 14 AND userid = 33265;

MySQL Error : Unknown column 'uod' in 'field list'
Error Number : 1054
Date : Monday, October 27th 2008 @ 03:14:32 PM
Script : http://warriornation.net/Forum/tourn...mitscore&id=28
Referrer : http://warriornation.net/Forum/tourn...mitscore&id=28
IP Address : xxx
Username : WNxDarkAngel
Classname : vB_Database

[bananalive]

2.5.8 database error when I try to confirm someone's score (a draw, both with one point)
Your missing a column 'uod' which should have been created in version 2.5.2
Anyone have a quick fix for this before I start to dissect my templates?
It is to do with the css of thead, including nowrap
hello,

very nice add on but unfortunately "Create Tournament" not work i can fill in all information after clicking ADD i end on a white side the rest is working fine like Ladder ..

thx

BananaLive,

1. In previous versions you can see who joined the tournament, for some reason I can't see who has joined my tournaments.

2. Also how do you unsticky a tournament. It only has a delete option, now that it's finished. I don't want to delete it but I want to unsticky it so that when people look at the tournament list the one that needs to be filled is on top.

also looking forward to the invite option for teams, keep up the good work.
Make sure you have reverted your tournament templates
use http://yourforum/tournament.php?do=edit&id=
(add id of tournament at end of link)

[Koidl]

Make sure you have reverted your tournament templates
use http://yourforum/tournament.php?do=edit&id=
(add id of tournament at end of link)

i dont have templates to revert its a fresh installation i tryed this link to add a tournament over edit .. but i end in a blank screen again no chance to add a tournament here

[djlotus]

Discovered an error when challenging someon on the ladder. If the use has a ">" or "<" in thier name, it returns and error saying the PM was not sent because user "xxxx" could not be found. For example, my username is "[>F<]djlotus", here is the error presented to someone who tries to challenge me on the ladder:

"You have successfully challenged this player. However, there was error(s) PM'ing your opponent.
The following users were not found:
[&gt
F&lt
]djlotus"

I receive the challenge, and it displays on the challeges page, however the PM is not sent.

[Revvin]

Would it be possible/good idea to add a system where if a user has too many challenges outstanding then anyone who tries to challenge them is told 'Joe Bloggs has already been challenged by x number of players and cannot accept any further challenges' where x could be an admin set figure. Top ranked players could find themselves deluged with challenges.

[rob01]

someone know why this tmnt_profile adds 10 queries to the user profile page?

and is there other way for making this mod working withought calendar php extension?

[KrU$ty]

I'm getting the following database error when trying to access the rules:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM maintmnt_rules;

MySQL Error : Table 'eveprovi_mainforum.maintmnt_rules' doesn't exist
Error Number : 1146
Request Date : Saturday, November 1st 2008 @ 04:45:01 PM
Error Date : Saturday, November 1st 2008 @ 04:45:01 PM
Script : http://www.url.com/tournament.php?do=rules (http://www.eveprovide.com/tournament.php?do=rules)
Referrer : http://www.url.com/tournament.php?do=viewladder&id=2 (http://www.eveprovide.com/tournament.php?do=viewladder&id=2)
IP Address : my ip

Username : user
Classname : vB_Database
MySQL Version : 4.1.22-standard

[bananalive]

someone know why this tmnt_profile adds 10 queries to the user profile page?
It doesn't add any queries as it just gets the data from userinfo, which is cached by vBulletin. However, I believe the profile is slightly different so I've slightly altered the code.
and is there other way for making this mod working withought calendar php extension?
Not that I am aware of. (Although you could just delete that line, its not necessary it only checks to see someone doesn't type, for example, 45 of December)
I'm getting the following database error when trying to access the rules:
have you tried the rules fix here (https://vborg.vbsupport.ru/showpost.php?p=1641238&postcount=712)

[KorsatH]

where I can fin a demo?
the link is broken.

Is possible insert a global rank (tournament+ladder)?

[Koidl]

ive updated the new version but i still cant creat tournament after trying to add i end on a white screen
and by the side is there any chance to get the old ladder view back without detail box on right and with icons in the middle?

[Chris11987]

What's new in this version?

[bananalive]

ive updated the new version but i still cant creat tournament after trying to add i end on a white screen
and by the side is there any chance to get the old ladder view back without detail box on right and with icons in the middle?
download old version get template tmnt_ladder_display and use that
where I can fin a demo?
the link is broken.

Is possible insert a global rank (tournament+ladder)?
Fixed link
Sorry, I don't understand your second question, could you rephrase it.
What's new in this version?

https://vborg.vbsupport.ru/showpost.php?p=1609081&postcount=2

v2.6.1: 1 October 2008
- Team Ladders
- Fixed tournament stats in profile
- Close ladder - no new challenges/ joins
- Sticky Ladders - appear at top of ladder list
- Global name for modification (set in Tournament Options)
- Updated design of few templates

[fernas]

I suggest ladder categories, for example, Xbox 360 Ladders, PlayStation 3 Ladders, Wii Ladders, etc.

[KorsatH]

Fixed link
Sorry, I don't understand your second question, could you rephrase it.

Thank you for the demo's link.

I ask if is possible insert a global ranking system for players:
if you participate in ladders or tournaments your rank will reflect your successes and failures.


edit: the leader in the Game Competition is http://gamebattles.com/

[gamerscms]

Thanks for the new update banana, i will try it now and report any bugs :)

Will this update effect any current tournaments in progress?

Also you may want to remove:
Note: New Releases have temporarily been suspended see this post.

may discourage users from downloading just thought i would let you know.

thanks again for this great hack.

[OneShot]

I get the following error when clicking on the link "Team Challenges"

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM tmnt_ladder_games WHERE (u IN () OR u2 IN ()) AND finished = 0 AND accepted != -1 AND pot = 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 ') OR u2 IN ()) AND finished = 0 AND accepted != -1 AND pot = 1' at line 1
Error Number : 1064
Request Date : Saturday, November 1st 2008 @ 12:42:35 PM
Error Date : Saturday, November 1st 2008 @ 12:42:36 PM
Script : http://www.commanders-academy.com/forum/competitions.php?do=ladderteamchallenges
Referrer : http://www.commanders-academy.com/forum/competitions.php
IP Address : 82.113.121.16
Username : OneShot
Classname : vB_Database
MySQL Version : 5.0.51a-community

[bananalive]

Thanks for the new update banana, i will try it now and report any bugs :)

Will this update effect any current tournaments in progress?
No

Also you may want to remove:
Note: New Releases have temporarily been suspended see this post.

may discourage users from downloading just thought i would let you know.

thanks again for this great hack.
(Woops thanks)

[Koidl]

i still cant creat tournaments after trying to add i end on a white screen any fix for this now ?

[gamerscms]

Thanks banana for confirming my questions :)

[bananalive]

I get the following error when clicking on the link "Team Challenges"
I'll release update shortly to fix this.

[gamerscms]

Ok all imported and working fine, cant see any issue's with the hack great work.

[bananalive]

I'll release update shortly to fix this.

Re-uploaded vB_Competitions 2.6.1 .zip. Just re-upload the competitions.php if you are currently running 2.6.1

[Revvin]

Ladder appears to be working but when i create a tournament I get the following error:


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 77824 bytes) in /home/revvin/public_html/vbtest/includes/class_dm_user.php on line 2480


It fails to create the tournament but still automatically makes the announcement post in my tournaments announcement forum. This happened in v2.5.8 and v2.6.1

[gamerscms]

Ladder appears to be working but when i create a tournament I get the following error:


Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 77824 bytes) in /home/revvin/public_html/vbtest/includes/class_dm_user.php on line 2480


It fails to create the tournament but still automatically makes the announcement post in my tournaments announcement forum. This happened in v2.5.8 and v2.6.1

That error is not a error with the hack that is a server issue, you need to increase your MB edit your PHP.ini file to allow more if unsure contact your host.

[Revvin]

Thanks, will go and hit him now :up: Just seemed odd that earlier versions the tournaments worked fine

[WNxWakko]

Your missing a column 'uod' which should have been created in version 2.5.2


I never got that update. I must have missed it. I would have grabbed the latest you had available at the time. Shouldnt updates following that also add that column? How do I get this added now?

[gamerscms]

Just thought i would point out when updating your team name it does not update on the tournament brackets that are in progress.

[bananalive]

I never got that update. I must have missed it. I would have grabbed the latest you had available at the time. Shouldnt updates following that also add that column? How do I get this added now?

Yes it should.

Upload attached file as product and it should work.

[WNxWakko]

When I try and import that file you just attached I get this,

XML Error: Mismatched tag at Line 19

[bananalive]

When I try and import that file you just attached I get this,

XML Error: Mismatched tag at Line 19

sorry i forgot to close <codes>

[WNxWakko]

Thanks that imported with no issue. I will have my testers do their thing.

[djlotus]

Discovered an error when challenging someon on the ladder. If the use has a ">" or "<" in thier name, it returns and error saying the PM was not sent because user "xxxx" could not be found. For example, my username is "[>F<]djlotus", here is the error presented to someone who tries to challenge me on the ladder:

"You have successfully challenged this player. However, there was error(s) PM'ing your opponent.
The following users were not found:
[&gt
F&lt
]djlotus"

I receive the challenge, and it displays on the challeges page, however the PM is not sent.

Any ideas on w to work around this?

[icekola]

Very impressive bananalive. Quick question tho, I can promote a co-leader as leader but I can't demote him? is that a bug or not an option? Can it be added in a future version?

Also, It would be nice for a master admin to be able to admin all of it as oposed to only team leaders can admin their challenges, teams, and wutnot.

Again, I am loving this mod. Great work.

[WNxWakko]

just to note the fix worked.

I was wondering, is there a who's online feature in this? I remember reading a post about it but ive not seen that feature. Have you considering adding that and if its already there, how do I get it to work?

[rob01]

i mean this

Page generated in 0.17683 seconds with 47 queries (2 queries for uncached templates) [Server Loads: 2.37 2.42 : 2.18]
Uncached templates: gifts_list_member_nogifts (1)
Uncached templates: tmnt_profile (10)

this part -> Uncached templates: tmnt_profile (10) :(

[Toupsx]

When trying to install the new product for 2.6.1... It goes to
Importing Product, Please Wait...

[:]
and never goes. Just sits there with the page being done.. which of course means mine doesn't work now because of sql errors because it didn't finish installing..

Any reason this is happening?

[SpiderFive]

hi this hack use also competitions.php

https://vborg.vbsupport.ru/showthread.php?t=100150&page=15

[bananalive]

Very impressive bananalive. Quick question tho, I can promote a co-leader as leader but I can't demote him? is that a bug or not an option? Can it be added in a future version?

Also, It would be nice for a master admin to be able to admin all of it as oposed to only team leaders can admin their challenges, teams, and wutnot.

Again, I am loving this mod. Great work.
Its currently not an option.
just to note the fix worked.

I was wondering, is there a who's online feature in this? I remember reading a post about it but ive not seen that feature. Have you considering adding that and if its already there, how do I get it to work?
Yes, it only displays that user is viewing the modification not specific page of mod.
i mean this

Page generated in 0.17683 seconds with 47 queries (2 queries for uncached templates) [Server Loads: 2.37 2.42 : 2.18]
Uncached templates: gifts_list_member_nogifts (1)
Uncached templates: tmnt_profile (10)

this part -> Uncached templates: tmnt_profile (10) :(
Have you updated to latest version?
When trying to install the new product for 2.6.1... It goes to
Importing Product, Please Wait...

[:]
and never goes. Just sits there with the page being done.. which of course means mine doesn't work now because of sql errors because it didn't finish installing..

Any reason this is happening?
Hmm, I cannot think why that would occur, might have been due to server timing out.
hi this hack use also competitions.php

https://vborg.vbsupport.ru/showthread.php?t=100150&page=15
Never noticed that modification before. Save competitions.php with new name and open product file and competitions.php and find and replace all instances of 'competitions.php'

[Toupsx]

Hmm, I cannot think why that would occur, might have been due to server timing out.



Well.. what should I do now? I can't update to the new one apparently. .and can't install back to the old one.. and it doesn't work right now because of trying to update..

[WNxWakko]

Regarding who is online. I mean a bit that shows at the top of the competition mod showing the users viewing.

[Stifmeister2]

I still have version 2.2.1. My tournament is over now and I'm ready to upgrade. But I'm still afraid that I'l lose my current tourbeys or some database errors, since many people have posted about them...

Can you quarantee that I will not lose my old tourneys?

[gamerscms]

I still have version 2.2.1. My tournament is over now and I'm ready to upgrade. But I'm still afraid that I'l lose my current tourbeys or some database errors, since many people have posted about them...


Can you quarantee that I will not lose my old tourneys?

You will not lose any info i have ongoing tournaments and they are still all there after the upgrade to the new version.

[jdelator]

So I searched through this thread and I am not quite certain on this.

Is tournaments just for tournaments and compeitions just for ladders? Or what is the difference between the two?

[bananalive]

Well.. what should I do now? I can't update to the new one apparently. .and can't install back to the old one.. and it doesn't work right now because of trying to update..
Use product-errorfix2008.xml (https://vborg.vbsupport.ru/attachment.php?attachmentid=88248&d=1224274620) to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Regarding who is online. I mean a bit that shows at the top of the competition mod showing the users viewing.
Oh no sorry.
So I searched through this thread and I am not quite certain on this.

Is tournaments just for tournaments and competitions just for ladders? Or what is the difference between the two?
Sorry https://vborg.vbsupport.ru/external/2010/10/8.gif vB_Competitions 2.6.1 .zip (https://vborg.vbsupport.ru/attachment.php?attachmentid=88844&d=1225559639) contains both tournaments and ladders. (The other file was just an old version)

[p33r]

I got to say this mod is simply awesome. We are currently using most of the features and are very happy. Diffrent categories for tournaments and ladders would be a pretty nice feature. Keep up the good work.

[EHSkaRMa]

I finally got the old version uninstalled completely. Ive installed the new version, and everything was working great. Now, when I click teams list, I get this db error:


Invalid SQL:
SELECT COUNT(*) AS countrows FROM vbtmnt_teams WHERE payment_status='Completed' AND item_number='Donation';

MySQL Error : Unknown column 'payment_status' in 'where clause'
Error Number : 1054


I guess its conflicting with my donation system. Why would it call on that?
Any help?

[Shop]

So we need to uninstall the old version and install 2.6.1? Do we need to delete all the ladders and tournaments in progress? I'm confused ...

[bananalive]

I finally got the old version uninstalled completely. Ive installed the new version, and everything was working great. Now, when I click teams list, I get this db error:

Invalid SQL:
SELECT COUNT(*) AS countrows FROM vbtmnt_teams WHERE payment_status='Completed' AND item_number='Donation';

MySQL Error : Unknown column 'payment_status' in 'where clause'
Error Number : 1054


I guess its conflicting with my donation system. Why would it call on that?
Any help?
I'm not sure why its doing that. What donation modification are you using?
So we need to uninstall the old version and install 2.6.1? Do we need to delete all the ladders and tournaments in progress? I'm confused ...
No and no. Download archive and follow readme.txt

[gamerscms]

This mod is working perfect on our site just hitting the semi finals of a COD4 2v2 tournament.

Will we see an invite system added at a later date?

thanks again banana for your great work so far, you have saved us a lot of money in getting a custom script made.

[OcR Envy]

invite system

Eye, still waiting on some kind of invite system/notification system. Also I'd still really like to see a way for people to report wins/loses.

[p33r]

Another idea: Teams should fullfill a social role, maybe aproach it like a Social Group? With comment's and discussions. Would be the perfect place to have important strategy meetings! Anyways, some kind of comment/discussion function on the Team pages would be nice.

(would help if it was limited to the team and mods/admins, so you could keep your important strategy for your team)

[EHSkaRMa]

[QUOTE=bananalive;1658508]I'm not sure why its doing that. What donation modification are you using?


AWCoding- Donation System LITE

https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=DSL


This is the one I use. Thanks for any help

[bananalive]

I'm not sure why its doing that. What donation modification are you using?

AWCoding- Donation System LITE

https://vborg.vbsupport.ru/misc.php?do=producthelp&pid=DSL

This is the one I use. Thanks for any help
Have a go at this... it should hopefully disable Donation System for whole of tournament & ladders modification.

Open plugin 'DSL-Parse Modules'
Find... if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna") Replace With... if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna" && THIS_SCRIPT!="tournament2008")

[bananalive]

v2.6.2 Just Releases...

- Fixed LMS tournament minor bug
- Added ajax edit score for LMS tournament (double click on score to edit it and click away to save it)
- Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member

[XShava]

v2.6.2 Just Releases...

- Fixed LMS tournament minor bug
- Added ajax edit score for LMS tournament (double click on score to edit it and click away to save it)
- Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member

Instal and gets error in Team page when clik team name.

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/competitions.php on line 2987

[bananalive]

Install and gets error in Team page when click team name.

Warning: in_array() [function.in-array]: Wrong datatype for second argument in [path]/competitions.php on line 2987

Hmmm... not sure why you get that error, works fine on my vB

Find in competitions.php
$array = implode(",", $array);
Replace with
//$array = implode(",", $array);

[Toupsx]

Use product-errorfix2008.xml (https://vborg.vbsupport.ru/attachment.php?attachmentid=88248&d=1224274620) to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)


Okay.. well I have tournament data.. so that would erase it.. :confused:

[gamerscms]

There is a bug in the add new user to team, when adding a user no matter which user i enter i get the following message

Ultra Shotz is not a forum member, please check your spelling. Click here to go back to the team page.

[gamerscms]

There is a bug in the add new user to team, when adding a user no matter which user i enter i get the following message and he is a forum member all spelt correct.

Ultra Shotz is not a forum member, please check your spelling. Click here to go back to the team page.

[EHSkaRMa]

Have a go at this... it should hopefully disable Donation System for whole of tournament & ladders modification.

Open plugin 'DSL-Parse Modules'
Find... if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna") Replace With... if (substr(THIS_SCRIPT,-6,6)!="verify" && !defined(IN_MKP) && substr(THIS_SCRIPT,0,4)!="dyna" && THIS_SCRIPT!="tournament2008")

Where would I find DSL-Parse Modules?
I looked in my plugins but dont see anything like that. I have the newest version (0.2.1) of the donation system

[iogames]

why don't u make the graphics from bottom to top?

[Gamelobby]

Hmmm... not sure why you get that error, works fine on my vB

Find in competitions.php
$array = implode(",", $array);
Replace with
//$array = implode(",", $array);

Sorry, but where do i find "competitions.php"
What is it under.?

Also if you put in a "team logo" it pushes it off the page to the right.?
Any ideas.?

[valendono]

I try "Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member" .. that username or user id ?

Add User to Team: testing

than

testing is not a forum member, please check your spelling. Click here to go back to the team page.

error or bugs ?

[mikeo9043]

Cool, I will give this one a try later

[bananalive]

Where would I find DSL-Parse Modules?
I looked in my plugins but dont see anything like that. I have the newest version (0.2.1) of the donation system
Oh, i downloaded v1.0.0, I'll have a look again for you.
There is a bug in the add new user to team, when adding a user no matter which user i enter i get the following message and he is a forum member all spelt correct.
Yep, sorry. I'll release fix in next version but here's the manual fix
Find in competitions.php $u = $result['userid'];
if ($userid == '') {Replace with $u = $result['userid'];
if ($u == '') {
why don't u make the graphics from bottom to top?
Sorry I don't understand. What graphics are you referring to?
Sorry, but where do i find "competitions.php"
What is it under.?

Also if you put in a "team logo" it pushes it off the page to the right.?
Any ideas.?
competitions.php is the main php file for this modification included in the archive of the first post of this thread.
I try "Special Usergroups can add Forum Members to Any Team without confirmation from team leader or the forum member" .. that username or user id ?

Add User to Team: testing

than

testing is not a forum member, please check your spelling. Click here to go back to the team page.

error or bugs ?
You enter the Username of the forum member. See above.

[cscgirl]

Is the visual (flow chart type) ladder created when the tournament starts? So far I just see a team list of those that have joined but the tournament has not started yet.

Also, when you upload a team logo where is this supposed to be displayed? I uploaded one to my team but I don't see it anywhere.

[Gamelobby]

The logo appears in the "team stats", but on mine it cuts off half of the image. (right half of image is off the page)

[es-league.com]

I have the 2.62 installed here (http://www.combatrevolution.net/competitions.php)

and have added a few test ladders and tournaments.
When trying to view a test team profile I get the following error message :

Warning: in_array() [function.in-array (http://www.combatrevolution.net/function.in-array)]: Wrong datatype for second argument in [path]/competitions.php on line 2987


any ideas ???

[Strafe]

Yep, sorry. I'll release fix in next version but here's the manual fix

Hey banana, just a quick note - I haven't came back to check on the mod for awhile and there's a really big reason to it.

EVERY new version always seem to have some problems so I always want to wait for the next patch before installing them.

Bottom line is, maybe try to check your work a bit more before releasing versions (or get some volunteer testers). All the new version bugs scares me away.

I think you should stick to bigger and sturdy releases instead of tossing out small (and deadly) patches every other day.

Don't mean any offense, I still thank you for this useful mod, but lines I quoted above are way too common for me to try the newer versions.

Thanks for understanding.

[jdelator]

How do you remove
Tournaments Joined: 10
Tournament Wins: 2
these fields from a user's post?

This mod rocks btw.

[Revvin]

In the tournament options near the bottom there is an option to turn 'Stats in Postbit' on or off

[Stifmeister2]

Bottom line is, maybe try to check your work a bit more before releasing versions (or get some volunteer testers). All the new version bugs scares me away.


This always happens to me too. :( I still have that very old 2.2.1 version installed. Every time there is a new version many people complain about database errors so I'm too afraid to upgrade. The 2.2.1 works perfectly for me now, but I really need some features (like the teams etc) so I want to upgrade.


I can't afford to lose any of my tournament data, it would be a killer for me, since the tounaments can't be reproduced.


And I have no experience of phpmyadmin or stuff like that.

[gamerscms]

This always happens to me too. :( I still have that very old 2.2.1 version installed. Every time there is a new version many people complain about database errors so I'm too afraid to upgrade. The 2.2.1 works perfectly for me now, but I really need some features (like the teams etc) so I want to upgrade.


I can't afford to lose any of my tournament data, it would be a killer for me, since the tounaments can't be reproduced.


And I have no experience of phpmyadmin or stuff like that.

Your data will not be lost at all, just follow the install notes and you will be fine i have active tournaments and i have upgraded with no issue's or lose of data.

chill and have some faith in your self and this hack :up:

[cscgirl]

I have redone the whole thing and now there is no option for team leaders to add users to their team? I am confused.

[valendono]

Team Members (3) but the members is 4 id, why not counted because 1 user added by Admin ? And also about the future team swap not just user swap pls.. Thanks.

[es-league.com]

this mod has messed up my vb :(
I just got home to 177 vbulletin database error messages
in my inbox all relating to this tournament mod.

It wont let me uninstall from the vb admincp either !!

very frustrating !! :(

I have been running vb for years without hiccups too !!

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 'xxxxxxxxx.tournaments' doesn't exist
Error Number : 1146
Request Date : Wednesday, November 5th 2008 @ 04:23:59 PM
Error Date : Wednesday, November 5th 2008 @ 04:23:59 PM
Script : http://www.combatrevolution.net/private.php?do=showpm&pmid=1268
Referrer : http://www.combatrevolution.net/private.php

[bananalive]

this mod has messed up my vb :(
I just got home to 177 vbulletin database error messages
in my inbox all relating to this tournament mod.

It wont let me uninstall from the vb admincp either !!

very frustrating !! :(

I have been running vb for years without hiccups too !!

The error mentioned in your code was encountered by another user. The problem was traced to ibproArcade

[es-league.com]

ok thanks for the prompt reply...

any suggestiond as to how we fix this ??

ibproarcade has been on my site for years running
alongside other mods with no issues...

we cant use pm messaging now either with same
error message coming up

[fodvapor]

Can you add "Double Elimination" to the options please?

[es-league.com]

I get the following error when trying to uninstall this mod :

Invalid SQL:
ALTER TABLE usergroup DROP COLUMN maxteams;;
MySQL Error : Can't DROP 'maxteams'; check that column/key exists
Error Number : 1091
Request Date : Wednesday, November 5th 2008 @ 04:43:30 PM
Error Date : Wednesday, November 5th 2008 @ 04:43:30 PM
Script : http://www.combatrevolution.net/admincp/plugin.php?do=productkill
Referrer : http://www.combatrevolution.net/admincp/plugin.php?do=productdelete&productid=tournament2008&s=
MySQL Version : 5.0.51a-community

[fodvapor]

es-league....i run the arcade and tourney mod, and have not seen the errors you have posted. Have you installed any other mods lately that could of "screwed" with them ? Did you just upgrade to 3.7.4 ? Cuz im still running 3.7.3

[es-league.com]

es-league....i run the arcade and tourney mod, and have not seen the errors you have posted. Have you installed any other mods lately that could of "screwed" with them ? Did you just upgrade to 3.7.4 ? Cuz im still running 3.7.3

upgraded to 3.74 last night....

do you think there could be a conflict with 3.74 then ??

this is the 1st time I have never been able to uninstall a mod on vb before though ??

[fodvapor]

It could be conflicting ....im not sure.

[CvP]

Can you add "Double Elimination" to the options please?
++SUPPORT

and group matches before knockout matches (like you see in FIFA).

verrrrrrrrry nice mod.

[gamerscms]

New error when trying to admin add a player to the team:
Database error in vBulletin 3.7.4:

Invalid SQL:
UPDATE tmnt_teams SET noplayers=noplayers+1 WHERE teamid=;

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 : Wednesday, November 5th 2008 @ 09:31:25 PM
Error Date : Wednesday, November 5th 2008 @ 09:31:25 PM
Script : http://www.xboxhive.co.uk/forums/competitions.php?do=viewteam&id=11
Referrer : http://www.xboxhive.co.uk/forums/competitions.php?do=viewteam&id=11
IP Address : *******
Username : ********
Classname : *********
MySQL Version : 5.0.67-community

[Gleedo]

Great mod, testing it now.

My only issue so far might not be a mod problem but a vbCMPS problem....

For some reason, the link to 'Tournaments' on the homepage is not looking at /forums/tournaments.php, its lookiing mydomain.com/tournaments.php which is incorrect...

See here:
http://www.urbanstrikeforce.com/index.php

Any idea what i need to do to correct this?:confused:

[EHSkaRMa]

Oh, i downloaded v1.0.0, I'll have a look again for you.



Any luck with this one yet banana? All other functions are working properly.
But this is holding me back from opening my tourneys to my community.
Thanks.

[Toupsx]

any chance you could send me the 2.5.8 version? any version I've tried above it my server times out because of the script connecting to my database over and over to run sql queries using up too much memory apparently according to my host.. so.. yeah that was the last working version for me =\

[iogames]

Graphics pyramid style?

does it works for 3.6x?

[bananalive]

Great mod, testing it now.

My only issue so far might not be a mod problem but a vbCMPS problem....

For some reason, the link to 'Tournaments' on the homepage is not looking at /forums/tournaments.php, its lookiing mydomain.com/tournaments.php which is incorrect...

See here:
http://www.urbanstrikeforce.com/index.php

Any idea what i need to do to correct this?:confused:
In Plugin Tournament AutoInsert Links
Findhref=\"competitions.php
Replace withhref=\"".$vbulletin->options['bburl']."/competitions.php
Any luck with this one yet banana? All other functions are working properly.
But this is holding me back from opening my tourneys to my community.
Thanks.
I've download it now and have a look.
any chance you could send me the 2.5.8 version? any version I've tried above it my server times out because of the script connecting to my database over and over to run sql queries using up too much memory apparently according to my host.. so.. yeah that was the last working version for me =\
Attached. If anything the queries have been streamlined.
Graphics pyramid style?

does it works for 3.6x?
Ye but see first post for instructions to install on version 3.6.x

[fodvapor]

Is double elimination possible ?
Please...lol

[bananalive]

Any luck with this one yet banana? All other functions are working properly.
But this is holding me back from opening my tourneys to my community.
Thanks.

Plugin: Donation System Bar and Menu

Findif (substr(THIS_SCRIPT,-6,6)!="verify"){
Replace withif (substr(THIS_SCRIPT,-6,6)!="verify" AND THIS_SCRIPT!="tournament2008"){

[bananalive]

v2.6.4: 6 November 2008
- Viewing team page auto-checks and corrects Team's Member Count
- Recent Matches added on Ladder page
- Upcoming matches added on Ladder page

[Denver Jackson]

Awsome keep them updates coming :)

[Strafe]

Hey banana, could you do us a huge favorite?

Could you keep a 'stable' release version posted? That way you can do all the experimental ones while still providing a stable version for everyone to use in the meantime.

Thanks a bunch.