Using phpmyadmin open smallbal_vbforums, remove/drop table starting with vb_tmnt_ and vb_ladder

Awesome, I didn't think you were gonna be combining them already. I'll try it out later. I have a few suggestions already for it, but I'll wait until any bugs are sorted out.

OK.. done.

I also physically went through and deleted all the ladder and tournament files. Now, whenever I try and install again, I get the very same errors as above.

Also,, after removing all the files and deleting the plugins.. "vB Tournament" is still showing as installed, and when I try to uninstall it it comes up


Invalid SQL:

DROP TABLE vb_tmnt_activity;;

MySQL Error : Unknown table 'vb_tmnt_activity'
Error Number : 1051

Admincp -> Plugins & Products -> Manage Products -> Edit vB Tournament

remove text from 2.4 uninstallation box

click save

Then try uninstalling it

When I tried that, I get

Invalid SQL:
ALTER TABLE vb_usergroup DROP COLUMN maxteams;;

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

Looking back, maxteams was listed under the uninstall box for 2.3.8

so I removed everything from all uninstall boxes, and then it let me remove the product. I hope this was ok, lol.. but everytime I deleted the info from one box, when I tried to uninstall it referenced info from another.

Should it be safe now to try a new installation? If so, I have a question. The new Beta install you listed above, does it include all files needed to run both the ladders and tournaments? Only reason I ask, is because the ladder script no longer has any download available, and I have removed it from my forums.

The beta version above is combined Tournament and Ladder Modification. All files are included in the zip archive.

This is great news about the beta, could we get a list of features you plan to add in the first post so we know what to post up with ideas i would fully support this hack by donating more cash as i think you have worked hard with this.

thanks a lot i will be adding some ideas soon :)

Getting the following error when i try to challenge someone.

Sorry yes there's an error with PM sending to user being challenged. (Fix released with next version.)

OK no problem thanks for the update :)

v2.4.2 BETA 2
- contains ladder challenge fix

OK.. just uploaded the files form the BETA 2 zip.
When I tried to import the file, I get this.

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

MySQL Error : Duplicate column name 'ladderpermissions'
Error Number : 1060
Request Date : Monday, September 29th 2008 @ 05:22:50 PM
Error Date : Monday, September 29th 2008 @ 05:22:53 PM

find and delete in product file

When I did that, I kept getting the same error, for different tables.

So, instead I went in via myphpadmin and physically found, and deleted every table, or addition to existing tables the modification created. Took awhile, but when I was done, it installed correctly.

I have one suggestion. Is it possible to create, and include an additional file that will delete all modification DB changes encase anyone ever wants or needs to uninstall? I know some phpbb mods include an install / uninstall file you can upload, and click on to add/remove tables. Maybe something like that is possible here?

I know it was sure a hassle to find, and remove all the DB tables by hand, lol. Maybe save someone some heartbreak if they ever need to remove to upgrade or something?

BTW, I like the merged mods. Looks great together! Great job!

Still getting the PM error:

Please complete both the subject and message fields.

Found one small error to add.

When a user adds a comment to an event, it pops up the message that its been entered, and click here if you do not wish to wait. Clicking does nothing, and the message just stalls.

No biggie, the guys can just use the back button.. but just wanted to let you know.

Small sugestion: Maybe you could add a section to put rules? That would be great.

hey im trying to install the new tournament
but if i drop the tournament mob i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_tmnt_activity;;
MySQL Error : Unknown table 'vbb_tmnt_activity'

and if i drop ladder i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_ladders;;
MySQL Error : Unknown table 'vbb_ladders'

but i already try adding the vbb_ladders table with mysql, but still i get the same error :(
any help? pleas thanks :)

is there a way to change the color of the brackets?? I have an all black VB and no one can see the actual brackets :o

I'm having a big problem.... I can't update usergroups because of a table from the tournament. I tried to uninstall the tournament and this is what I get everytime:

I tried reinstalling and upgrading the tournament as well, and no luck. I haven't even used the tournament software in about a week, so I'm unsure as to why it suddenly did this. I checked phpmyadmin and the table doesn't exist. What do I do here?

fyi: I was using/reinstalled/upgraded with version 2.4.

edit: This is the error I get when trying to update a usergroup:
Both of those are missing form the db, even after I update the product again.

Fresh install here, and we are loving it. Thank you for a great mod!

Installed

is anyone else getting a blank page when they click add for a new tournament?

3.6.x ???

Works for 3.6, just grab this file and import it (it contains memberinfo css from 3.7).

Members profile / stats page shows multiple tournament listings !? :-

"tournament.php?do=addteam"

Dont have load team logos bar, when click edit team link you can see them.

and ppls can create new team with same name, can you fix them ?

Thanks. Great Mod

When Creating a new Tournament with teams i get this Error
Above the page, it reloads and then shows the correct information.
Any ideas?

In response to my above post (#540), I fixed the usergroups. I just went into the profduct's xml file and manually entered the commands to fix the usergroups. Everytime there was a new error, I fixed it one by one until it was working fine again. I still can't upgrade or uninstall the tourney, but I'll give that an attempt later on tonight and give an update.

edit: Every time some of the tables are created again, different ones are deleted. I don't understand why the entire product won't install o reinstall and I'm getting pretty upset with it. Is there a way for me to manually UNinstall the whole thing, through phpmyadmin? I can try deleting every table/field, but how will it be taken out of the admincp and actual system?

edit: Turns out the error was from the ibProArcade Mod, not this one.

For future Release its possible to integrate it with VbExperience ?? :p

Just released v2.4.6 which should address all current bugs, etc. along with new features.

Any problems post below

only need to override the xml file?

I'm liking how things are shaping up. I think there really needs to be some sort of XP that teams can gain via the ladders they compete in so that there's kind of like a "true skill" ranking for overall competitors.

A great list of features, some may already be in.. but this is a huge overview.

»Ladder and Tournament Features«

* Unlimited Ladder Capacity (Singles, Team)
* Automated Ranking System
* Challenge Based System
* Strike / Warning System
* Map Randomizer
* Ladder Page Organized By Admin Defined Groups
* Clan Manager With Profile Editor, and War Light
* Members Can Join Current Teams, or Make Their Own.
* Clan Profile Page With Full Contact Details (MSN, Yahoo, AIM, Co-L AIM, ect.)
* Ladder standings with Crown, Blasts, AIM , Stats, ladder assistant, ect.
* King System (War for Crown)
* Full Tournament System Player or Admin Reported
* Fully Automated Tournament Brackets

»Social Networking Features«

* Each Members Gets Their Own Mailbox With Team Invites, And Friend Invites
* Member Profiles With Contact Information, About Me, Comments And More
* Friends System / Ability To Become Private

»Admin Control Panel«

* Admin Control Panel / Staff System
* Different Permissions For Each Staff Member
* Referee Ticket Manager
* Ladder and Staff Group Manager

»Other Features«

* Find a Match System With War Lights Integrated
* Ticket System With Admin Reply's Staff Member Assign
* Multiple Templates - Your members can choose their own template
* Full Member List With Letter Select
* News System Displayed On Front Page
* Full Featured Free Agent System With Commenting
* Full Search System By ID or Name

Open template tmnt_results copy into notepad/wordpad

Replace all #000000 with html hex code

Here's few examples...

#FFFFFF = White
#FF0000 = Red
#00FF00 = Green
#0000FF = Blue
#FFFF00 = Yellow
#00FFFF = Aqua Greeny Blue
#FF00FF = Pink
#C0C0C0 = Grey

You will need to upgrade product file and re-upload all files (remember to check overwrite)

THANK YOU bananalive for the time to develop and support this mod ;)

Hi,

After installing the new Tournaments and Ladder combined the old ladder info and all its players and players stats are gone... there is no ladder unless I create a new one.
is there anyway to call the info from the stand alone ladder into the combined ladder?

Since the Ladder and Tournaments are combined, I tried changing the name appearing in the navbar from Tournaments to ===> Ladders & Tournaments or League.
Members are asking what happened to the Ladder. however after changing the phrase and saving it the name on the navbar does not change.

How can I change the name in navbar from Tournaments to another name?

Thanks

Just installed new version. Everything working good. 3.7.3

Good job and like the combination.

Working all fine, thanks :)

Would be great to see some rules pages added.

It uses different tables but I will create product file to move ladders info across.

Edit vbphrase tmnts though this edits all instances of the phrase