Rap Battle System

[K a M a L]

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 .

[K a M a L]

Reserved for screenshots

[Justinphx]

I get a invalid file when installing the xml file. I believe the upload files were in the correct place as it is pretty straight forward. No instructions were in the zip file. The files do go into the forum root, admincp and includes, right?

[Krusty1231]

Agreed. The XML file seems to be missing code. Uninstalled.

Looks quite a bit like this mod.

https://vborg.vbsupport.ru/showthread.php?t=210950

[K a M a L]

so sorry , the xml file attached was the xml file for admincp navigation
Corrected

[K a M a L]

Agreed. The XML file seems to be missing code. Uninstalled.

Looks quite a bit like this mod.

https://vborg.vbsupport.ru/showthread.php?t=210950
yes , it is the vb4 version of the mod including premium features

[Krusty1231]

Awesome. Working fine here. Thanks

[Krusty1231]

Database error in vBulletin 4.2.0:

Invalid SQL:

SELECT *
FROM _vbuser
ORDER BY bs_wins DESC
Limit 0,10;

MySQL Error : Unknown column 'bs_wins' in 'order clause'
Error Number : 1054
Request Date : Tuesday, March 12th 2013 @ 06:14:25 PM
Error Date : Tuesday, March 12th 2013 @ 06:14:25 PM
Script : http://www.xxxx.com/forum/admincp/battle.php?do=main
Referrer : http://www.xxxx.com/forum/admincp/index.php?do=nav
IP Address : 71.17.xxx.xxx
Username : Jerry
Classname : vB_Database
MySQL Version : 5.5.23-55

Tried to uninstall - and get this.

Fix?

[AndrewSimm]

I would check mysql to see if any of the tables are left and if so delete them. Mext you need to delete the xml file so it stops showing in your admincp.

[K a M a L]

Tried to uninstall - and get this.

Fix?

I will post an update , but did you get this error while the uninstall ?

[Krusty1231]

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]

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]

bump?

[Brandon Sheley]

Very nice looking mod!

[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:
$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:

$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]

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.

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:
$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:

$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

[Lon]

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.

<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]

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

[NudnikStudios]

Is this add-on now working?

[WindVoice]

Anyone found a way to uninstall this mod?

[bridge2heyday]

Anyone found a way to uninstall this mod?
What problem do you get while uninstalling ?
do you want to uninstall because it is not working or you don't need it ..
I can look for the working version on my PC if someone interested .

[CiXelSiD]

yeah i am

[WindVoice]

What problem do you get while uninstalling ?
do you want to uninstall because it is not working or you don't need it ..
I can look for the working version on my PC if someone interested .

I am not using it anymore right now, maybe I will use it in future, it is a nice mod.

When I try to uninstall it I get this error:
MySQL Error : Can't DROP 'bs_wins'; check that column/key exists
Error Number : 1091


It won't let me uninstall it.

[bridge2heyday]

yeah i am

Ok , I will upload it shortly

[bridge2heyday]

I am not using it anymore right now, maybe I will use it in future, it is a nice mod.

When I try to uninstall it I get this error:


It won't let me uninstall it.

you can edit the product and remove uninstall code before uninstalling it .. this will leave some useless columns on database but it is not very bad.