vb.org Archive - Major Additions - Forum Tournaments & Ladders

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Major Additions - Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375)

Sorry only realized that after I posted..

Quote:

Originally Posted by bananalive (Post 1647267)

Everything in installcode execs on product install and everything in uninstall execs on product uninstall

Code:

<code version="2.4.2.1">

                        <installcode><![CDATA[

$vbulletin->db->query_write("

  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (

  `id` int(11) NOT NULL auto_increment,

  `title` varchar(50) NOT NULL,

  `description` text NOT NULL,

  `noplayers` int(3) NOT NULL,

  `status` int(3) NOT NULL,

  `cr_userid` int(10) NOT NULL,

  `cr_username` varchar(100) NOT NULL,

  `cr_time` int(10) NOT NULL,

  `cr_ip` varchar(100) NOT NULL,

  `ed_userid` int(10) NOT NULL,

  `ed_username` varchar(100) NOT NULL,

  `ed_time` int(10) NOT NULL,

  `ed_ip` varchar(50) NOT NULL,

  `threadid` int(10) NOT NULL,

  `views` int(10) NOT NULL default '0',

  `winpoints` int(10) NOT NULL default '2',

  `drawpoints` int(10) NOT NULL default '1',

  `losepoints` int(10) NOT NULL default '0',

  PRIMARY KEY  (`id`)

) TYPE=MyISAM");

$vbulletin->db->query_write("

  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (

  `id` int(11) NOT NULL auto_increment,

  `u` int(10) NOT NULL,

  `u2` int(10) NOT NULL,

  `time` int(10) NOT NULL,

  `accepted` int(10) NOT NULL,

  `lid` int(11) NOT NULL,

  `score_u` int(20) NOT NULL,

  `score_u2` int(20) NOT NULL,

  `agree_u` int(10) NOT NULL,

  `agree_u2` int(10) NOT NULL,

  `finished` int(10) NOT NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM");

$vbulletin->db->query_write("

  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (

  `id` int(11) NOT NULL auto_increment,

  `userid` int(10) NOT NULL,

  `username` varchar(100) NOT NULL,

  `lid` int(11) NOT NULL,

  `time` int(10) NOT NULL,

  `ip` varchar(100) NOT NULL,

  `wins` int(10) NOT NULL,

  `draws` int(10) NOT NULL,

  `loses` int(10) NOT NULL,

  `challenges` int(10) NOT NULL,

  PRIMARY KEY  (`id`)

) TYPE=MyISAM");

]]></installcode>

                        <uninstallcode><![CDATA[

$vbulletin->db->query_write("

DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;

");

$vbulletin->db->query_write("

DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;

");

$vbulletin->db->query_write("

DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;

");

$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");

]]></uninstallcode>

                </code>

Quote:

Originally Posted by bananalive (Post 1647245)

Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.

Code:

$vbulletin->db->query_write("

  INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES

(1, 'Your Rules Here')");

i did, new error message

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

ALTER TABLE vbuser ADD tmnt_joins INT(10) NOT NULL DEFAULT '0' ;;



MySQL Error   : Duplicate column name 'tmnt_joins'

Error Number  : 1060

and thanks for reply

never mind brain cramp

My suggestions:

- Teams for ladders.
- vbAdvanced modules for newest teams and recent matches.

Tnis hack is great!!

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

SELECT * FROM vb_tmnt_rules;



MySQL Error   : Table 'xxx.vb_tmnt_rules' doesn't exist

Error Number  : 1146

Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM

Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM

Script        : http://xxx/tournament.php?do=rules

Referrer      : http://xxx/tournament.php?do=view&id=8

IP Address    : xxx

Username      : xxx

Classname     : vB_Database

MySQL Version : 5.0.37-standard

Quote:

Originally Posted by Antek (Post 1647572)

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

SELECT * FROM vb_tmnt_rules;



MySQL Error   : Table 'xxx.vb_tmnt_rules' doesn't exist

Error Number  : 1146

Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM

Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM

Script        : http://xxx/tournament.php?do=rules

Referrer      : http://xxx/tournament.php?do=view&id=8

IP Address    : xxx

Username      : xxx

Classname     : vB_Database

MySQL Version : 5.0.37-standard

have you tried the rules fix here

Quote:

Originally Posted by conker1 (Post 1647273)

i did, new error message

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

ALTER TABLE vbuser ADD tmnt_joins INT(10) NOT NULL DEFAULT '0' ;;



MySQL Error   : Duplicate column name 'tmnt_joins'

Error Number  : 1060

and thanks for reply

Re-import Attachment 88261 (this is modified version just for you) and then try installing product-tournament2008.xml

bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php

Code:

Database error in vBulletin 3.7.3:



Invalid SQL:

SELECT userid, id, time, title FROM vb_tmnt_announcements ORDER BY id DESC LIMIT 0, 2;



MySQL Error   : Table 'xxx.vb_tmnt_announcements' doesn't exist

Error Number  : 1146

Request Date  : Saturday, October 18th 2008 @ 07:18:31 PM

Error Date    : Saturday, October 18th 2008 @ 07:18:32 PM

Script        : http://xxx/tournament.php

Referrer      : xxx/

IP Address    : xxx

Username      : xxx

Classname     : vB_Database

MySQL Version : 5.0.37-standard

Quote:

Originally Posted by Antek (Post 1647751)

bananalive, still doesn't work :(
After patched I get error here: http://xxx/tournament.php

You are missing table which means you need to reinstall product.

Ops :D It's working now :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (7)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02652 seconds Memory Usage 1,756KB 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 (7)bbcode_code_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (5)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
Messages: