Here is what you have been waiting for my first hack of my own.
What is this hack, Well its a online league managment tool for running a online league system.
This league system will run a 16 player tournament, Tournament signup, league signup and resign,
News for the admin to let his members know when the next tournament is.
members are able to join a team or make a team.
Admin area
The admin and make delete edit tournaments,
The admin can also make teams as and when he like where members of the site can only make one team.
The admin can report wins for each player when viewing players in the admincp.
He can also edit delete and report losses.
When players have signed up to a tournament in the admincp on touenaments the admin will see
All players in the tournaments and the tournament ID next to each player.
When a player reports a lose the admin will see all reports in the tournaments page.
Install.
This is so simple anyone can install this.
Unzip the vbleague_3.5 file in a folder on your pc
Upload the files to the root of your forum like
root/forums/admincp
root/forums/images/league
root/forums/league.php
Login to your admin cp and put this to install.
goto you plugin system
click manage products
[Add/Import Product]
Browse for the product-league.xml file
dont click Allow Overwrite
Do this as a new install only
If you have any problems please post here and i will help as soon as i can.
Please click the install button
A big thanks to Blaine0002 for converting this over to 3.5
After install I recived the below error trying to use and update teams!
Invalid SQL:
UPDATE league_stats SET teamid = WHERE userid='4';
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 'WHERE userid='4'' at line 1
Error Number : 1064
Date : Wednesday, October 12th 2005 @ 10:34:43 AM
Script : http://www.vbli.com/forums/league.ph...msignupconfirm
Referrer : http://www.vbli.com/forums/league.php?do=teamsignup
IP Address : xxxxxxxxxxxxxxxxxx
Username : VBLIStaff
Classname : vb_database
and a phrase was missing!
See attached, I love the idea but no good here!
If you had looked at some other posts you would know that the phrases are not working as i have said so many times.
As to this UPDATE league_stats SET teamid = WHERE userid='4';
it looks like you have not put a team id number in as set teamid = ??
if you dont put a number in it will not update.
There is alot of sites that have installed this now with out a problem so you must have downloaded one of the older versions or you have installed it wrong some how
I have been on your site and its still not working but it should be if you are using the new files, as the new files are working on other sites.
If you could uninstall the league and delete the league files then download the new files again and reupload them.
If that dont work could you pm me with your ftp and i will try it all from here, with the files i have.
VBleague Details »»
About Developer
Visit Web Site
DB Changes 
Is in Beta Stage 
10-12-2005, 07:07 PM
