i have ucash installed, works fine. I cant delete the tables, becuase it never creates them. I get syntax errors..
Quote:
$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..
|
More Information