The Arcive of Official vBulletin Modifications Site.

Rap Battle System · **Released**: 03-10-2013

Presenting The Rap Battle System!

What is it?

This is an addon targetted at Rap/Hip-Hop forums. It adds a feature that allows users to battle against each other using text/audio/graphics etc. See screenshots for more information.

What features does it have?

New Battle Page In Battle Forums.
Multiple Battle Forums.
Scoring System.
Users Can't Vote On Own Battles.
New battle page in battle forums
Scoring system
Redesigned thread layout for battles
Users must post before voting
Votes to win setting
Votes for knockout setting
Battle standings page
Customisable title format for new battles
Multiple battle forums
Battle editing from admincp
Score editing from admincp
Automatic battle moderation
Battle archive forum
Auto-PM on new battle
And many more...!

How do I use it?

Set which forums are battle forums in forum manager (admincp).
Go to that forum.
Click the new battle button.
Input message/rules and opponent.
Success!

How do I install?

Follow the installation instructions provided .

Krusty1231 · #12 03-13-2013, 10:34 AM

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.

Father Juan · #13 03-15-2013, 07:22 PM

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.

Father Juan · #14 03-21-2013, 09:58 PM

bump?

Brandon Sheley · #15 03-22-2013, 12:41 AM

Very nice looking mod!

Father Juan · #16 03-22-2013, 09:42 PM

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`");

Lon · #17 05-12-2014, 07:29 AM

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

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`");

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.

Lon · #18 05-18-2014, 08:56 PM

Quote:

Originally Posted by Father Juan

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.

K a M a L · #19 11-28-2014, 08:26 AM

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

NudnikStudios · #20 10-16-2016, 11:43 PM

Is this add-on now working?

WindVoice · #21 05-06-2017, 03:36 AM

Anyone found a way to uninstall this mod?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07119 seconds Memory Usage 2,382KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (4)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (11)post_thanks_box (2)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (1)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

2 благодарности(ей) от:
andro140, Brandon Sheley

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!