VBleague

Downloads for this modification have been removed according to Official Policy: When Security Vulnerabilities in Hacks are Found


Hi all

This download containe 2 versions of the league.

One with ucash/ushop
And the other with out

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

All screen shots are in this post
https://vborg.vbsupport.ru/showthread.php?t=96468

[evenmonkeys]

I have the one with the ucash. That must be my problem then. I had to create all the sql tables myself. Took forever. >_<

[micheal332001]

Hi there

I have now tryed both versions of the product-league.xml file
And both worked fine.
You might have to goto your sql and delete the tables manuly.
Then run the product-league.xml file again.

A few site have this running and iv tested the files and so has blaine and we have it working.
If you want me to install this for you i will do it free of any charge.
Just pm me or add me to your msn mmilton67@hotmail.com
and we will talk on there.
I want to help all i can and giving my msn will help as i can talk you through it or install it for you.
The choose is yours.

[micheal332001]

Oh also if you install the one with ucash you need to install the ucash hack

[Sooner95]

i have ucash installed, works fine. I cant delete the tables, becuase it never creates them. I get syntax errors..

$db->query("CREATE TABLE '.TABLE_PREFIX.'league_news (
`newsid` int(5) NOT NULL,
`newstitle` varchar(50) NOT NULL default '',
`newsinfo` text NOT NULL,
`newsdate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`newsid`)
) TYPE=MyISAM");
$db->query("CREATE TABLE '.TABLE_PREFIX.'league_settings (
`active` int(1) NOT NULL default '0',
`cashrow` varchar(20) NOT NULL default '',
`winners` tinyint(3) NOT NULL default '0',
`leaguesignupfee` int(10) NOT NULL default '50',
`makeateamfee` int(10) NOT NULL default '100'
) TYPE=MyISAM");
$db->query("CREATE TABLE '.TABLE_PREFIX.'league_stats (
`userid` varchar(20) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`place` varchar(15) NOT NULL default 'Not Ranked Yet',
`rating` int(10) NOT NULL default '1500',
`gamewins` int(10) NOT NULL default '0',
`gamelosses` int(10) NOT NULL default '0',
`winstreak` int(10) NOT NULL default '0',
`lossestreak` int(10) NOT NULL default '0',
`teamid` tinyint(3) NOT NULL default '0',
`totalwins` int(11) NOT NULL default '0',
`totallosses` int(11) NOT NULL default '0'
) TYPE=MyISAM");
$db->query("CREATE TABLE '.TABLE_PREFIX.'league_teams (
`teamid` INT( 20 ) NOT NULL AUTO_INCREMENT ,
`teamname` varchar(40) NOT NULL default '',
`teamdiscription` tinytext NOT NULL,
`teamimage` varchar(100) NOT NULL default 'images/league/noimage.gif',
`teamroll` varchar(50) NOT NULL default '',
`username` varchar(40) NOT NULL default '',
`teamuserid` int(11) NOT NULL default '0',
`teamwins` int(11) NOT NULL default '0',
`teamlosses` int(11) NOT NULL default '0',
PRIMARY KEY ( `teamid` )
) TYPE=MyISAM AUTO_INCREMENT=1");
$db->query("CREATE TABLE '.TABLE_PREFIX.'league_tournament_reports (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`winnersname` varchar(100) NOT NULL default '',
`lossersname` varchar(100) NOT NULL default '',
`winreported` int(1) NOT NULL default '0',
`losereported` int(1) NOT NULL default '0',
PRIMARY KEY ( `id` )
) TYPE=MyISAM AUTO_INCREMENT=1");
$db->query("CREATE TABLE '.TABLE_PREFIX.'league_tournaments (
`tid` int(11) NOT NULL auto_increment,
`gamename` varchar(50) NOT NULL default '',
`numplayers` int(11) NOT NULL default '0',
`champion` varchar(100) NOT NULL default '',
`datestarted` datetime NOT NULL default '0000-00-00 00:00:00',
`forumlink` varchar(150) NOT NULL default '',
PRIMARY KEY ( `tid` )
) TYPE=MyISAM AUTO_INCREMENT=1");
$db->query("CREATE TABLE '.TABLE_PREFIX.'leaguetournament_players (
`playerid` int(5) NOT NULL default '0',
`tid` int(11) NOT NULL default '0',
`playerusername` varchar(50) NOT NULL default '',
`playerwins` int(11) NOT NULL default '0',
`playerlosses` int(11) NOT NULL default '0',
`round1` int(5) NOT NULL default '1',
`round2` int(2) NOT NULL default '0',
`round3` int(2) NOT NULL default '0',
`round4` int(2) NOT NULL default '0',
`champion` int(1) NOT NULL default '0',
`team` varchar(100) NOT NULL default ''
) TYPE=MyISAM");
$db->query("INSERT INTO '.TABLE_PREFIX.'league_news (newsid, newstitle, newsinfo, newsdate) VALUES (0, 'Vbleague Installed', 'Your League is now installed, We hope you will like this league addon to your site.', '')");
$db->query("INSERT INTO '.TABLE_PREFIX.'league_settings (`active`, `cashrow`, `winners`, `leaguesignupfee`, `makeateamfee`) VALUES (0, 'uttpoints', 5, 50, 100)");

Looking at other SQL (which i know very little about) and comparing them to this one. " before the table thats created instead of ' ?

Its wont create the tables at all, and of course it wont uninstall, beucase their are no tables to drop. I am hoping its just a typo in the SQL query..

[Sooner95]

btw, this is the error i get when uninstalling the product

Database error in vBulletin 3.5.0:

Invalid SQL:
DROP TABLE IF EXISTS '.TABLE_PREFIX.'league_news;

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 ''.TABLE_PREFIX.'league_news' at line 1
Error Number : 1064

I get the same error, when importing, cept its creating the table.

[micheal332001]

Hi there Sooner95

I have tested both the xml files and i have not had a problem with the install.
If you want give me admin access to your site and ill try the xml file i have here.

If you want me to PM me with the info for me to install this for you.
I hope its not a problem with the zip files them self.
I will try rezipping them and reupload the files as well.

[micheal332001]

Hi there

You see this part the part i have made yellow and bold i think you will find thats the problem.
''.TABLE_PREFIX.'

PHP Code:

version for the right syntax to use near ''.TABLE_PREFIX.' league_news' at line 1 


then look at bit closer it tells you were the problem is and i think you will find it should look like this.

From line 95

PHP Code:

$db->query_write("DROP TABLE IF EXISTS ".TABLE_PREFIX."league_news"); 


If yours does not look like this change that part to this.

[Blaine0002]

i re sent him the fixed version (i think he forgot to upload it first time :P)

[micheal332001]

hehehehe

I have uploaded the new files blaine sent me.
let me know if its all ok

[twitch]

Thanks for all the work on this project Hope to even see it further developed