vb.org Archive
Page 10 of 51 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   VBleague (https://vborg.vbsupport.ru/showthread.php?t=97672)

evenmonkeys 10-09-2005 04:45 PM
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 10-09-2005 05:53 PM
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 10-09-2005 05:57 PM
Oh also if you install the one with ucash you need to install the ucash hack

Sooner95 10-09-2005 09:14 PM
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..

Sooner95 10-09-2005 09:23 PM
btw, this is the error i get when uninstalling the product

Quote:
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 10-09-2005 09:24 PM
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 10-09-2005 09:35 PM
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 10-09-2005 09:55 PM
i re sent him the fixed version (i think he forgot to upload it first time :P)

micheal332001 10-09-2005 10:13 PM
hehehehe

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

twitch 10-09-2005 10:32 PM
Thanks for all the work on this project :) Hope to even see it further developed


All times are GMT. The time now is 09:32 AM.
Page 10 of 51 « First 89 10 111220 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01449 seconds
  • Memory Usage 1,752KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete