vb.org Archive - Major Additions

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Major Additions - Rap Battle System (https://vborg.vbsupport.ru/showthread.php?t=295992)

Hello, yes I got the error after I tried to uninstall it.

I did as AndrewSimm advised - found the table - and dropped it.

I am now getting this:

Database error in vBulletin 4.2.0:

Invalid SQL:
ALTER TABLE _vbuser DROP bs_wins;

MySQL Error : Can't DROP 'bs_wins'; check that column/key exists
Error Number : 1091

The column is now gone, but the uninstall fails.

It's most likely an ID 10 T error on my part - as the mod disables fine - and is not causing me any grief other than when I click on "main" is when I get the error.

Thanks for helping tho I do appreciate it fellas.

After I post the battle thread and it refreshes to enter the poll options I get a blank screen.

The thread is created but the poll is not. Also the battle does not show in the cpanel.

Very nice looking mod!

So, in trying to un-install this mod I'm noticing that some of the tables aren't created upon installation.

user.bs_wins
user.titleids
bs_catagories
bs_titles
bs_favlines

Those are messing up the un-install and I'm guessing my install as well.

Install code:

PHP Code:


		
			
$vbulletin->db->hide_errors();
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bs_wins smallint(6) NOT NULL DEFAULT '0'");

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bs_losses smallint(6) NOT NULL DEFAULT '0'");

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD isbattlethread tinyint(1) NOT NULL DEFAULT '0'");

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD isbattleforum tinyint(1) NOT NULL DEFAULT '0'");

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "prefixset VALUES ('bs_battle', '99') ");

$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "prefix VALUES ('bs_battleprefix', 'bs_battle', '99', '1') ");

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD `battlecat` VARCHAR(30) NOT NULL ");

$vbulletin->db->show_errors();

Uninstall code:

PHP Code:


		
			
$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP bs_wins");

$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP titleids");

$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP bs_losses");

$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."thread DROP isbattlethread");

$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."forum DROP isbattleforum");

$vbulletin->db->query_write("DELETE FROM ".TABLE_PREFIX."prefix WHERE prefixid = 'bs_battleprefix' ");

$vbulletin->db->query_write("DELETE FROM ".TABLE_PREFIX."prefixset WHERE prefixsetid = 'bs_battle' ");

$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_catagories");

$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_titles");

$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_favlines");

$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."`thread` DROP `battlecat`");

I got this working again just gotta find out how I did it lol. Works well for a Battledome Modification for Anime/Manga/Comic sections.

Quote:

Originally Posted by Father Juan (Post 2411637)

PHP Code:


		
			
$vbulletin->db->hide_errors();

$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bs_wins smallint(6) NOT NULL DEFAULT '0'");



$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD bs_losses smallint(6) NOT NULL DEFAULT '0'");



$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD isbattlethread tinyint(1) NOT NULL DEFAULT '0'");



$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD isbattleforum tinyint(1) NOT NULL DEFAULT '0'");



$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "prefixset VALUES ('bs_battle', '99') ");



$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "prefix VALUES ('bs_battleprefix', 'bs_battle', '99', '1') ");



$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "thread ADD `battlecat` VARCHAR(30) NOT NULL ");



$vbulletin->db->show_errors();

Uninstall code:

PHP Code:


		
			
$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP bs_wins");



$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP titleids");



$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."user DROP bs_losses");



$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."thread DROP isbattlethread");



$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."forum DROP isbattleforum");



$vbulletin->db->query_write("DELETE FROM ".TABLE_PREFIX."prefix WHERE prefixid = 'bs_battleprefix' ");



$vbulletin->db->query_write("DELETE FROM ".TABLE_PREFIX."prefixset WHERE prefixsetid = 'bs_battle' ");



$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_catagories");



$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_titles");



$vbulletin->db->query_write("DROP TABLE ".TABLE_PREFIX."bs_favlines");



$vbulletin->db->query_write("ALTER TABLE ".TABLE_PREFIX."`thread` DROP `battlecat`");

It's actually adding it's own rows in current tables. For example "user ADD bs_losses" It's adding bs_losses into the _forum table under each individual user.

https://vborg.vbsupport.ru/external/2014/05/35.png

Quote:

Originally Posted by Father Juan (Post 2410214)

After I post the battle thread and it refreshes to enter the poll options I get a blank screen.

The thread is created but the poll is not. Also the battle does not show in the cpanel.

From what I gathered it's missing a template that was supposed to be added but didn't.

bs_newbattle is registered but there is no code within the install file that creates the actual template.

Code:

<plugin active="1" executionorder="5">

                        <title>Replace Poll Template</title>

                        <hookname>poll_newform_complete</hookname>

                        <phpcode><![CDATA[if ($foruminfo['isbattleforum'] AND $vbulletin->options['bs_enable']){

$templater = vB_Template::create('bs_newbattle');

                $templater->register_page_templates();

                $templater->register('checked', $checked);

                $templater->register('forumrules', $forumrules);

                $templater->register('navbar', $navbar);

                $templater->register('polldate', $polldate);

                $templater->register('pollnewbits', $pollnewbits);

                $templater->register('polloptions', $polloptions);

                $templater->register('pollpreview', $pollpreview);

                $templater->register('question', $question);

                $templater->register('threadid', $threadid);

                $templater->register('threadinfo', $threadinfo);

                $templater->register('timeout', $timeout);

                $templater->register('usernamecode', $usernamecode);

        print_output($templater->render());}]]></phpcode>

                </plugin>

Disable that plugin and it should work for the most part.

Ohhh , I really forgot this mod and didn't think some people are interested about it .. I will a fixed version soon

Is this add-on now working?

Anyone found a way to uninstall this mod?

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 (1)bbcode_code_printable (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (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.01363 seconds Memory Usage 1,794KB 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 (1)bbcode_code_printable (4)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (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: