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)

K a M a L

03-10-2013 11:00 PM

Rap Battle System

1 Attachment(s)

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

03-11-2013 06:16 PM

1 Attachment(s)

Reserved for screenshots

Justinphx

03-12-2013 04:07 AM

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

03-12-2013 06:59 AM

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

03-12-2013 10:35 AM

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

K a M a L

03-12-2013 10:40 AM

Quote:

Originally Posted by Krusty1231 (Post 2409445)

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

03-12-2013 10:27 PM

Awesome. Working fine here. Thanks

Krusty1231

03-12-2013 11:15 PM

Quote:

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

03-13-2013 07:56 AM

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

03-13-2013 09:43 AM

Quote:

Originally Posted by Krusty1231 (Post 2409606)

Tried to uninstall - and get this.

Fix?

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

Krusty1231

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

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

03-21-2013 09:58 PM

bump?

Brandon Sheley

03-22-2013 12:41 AM

Very nice looking mod!

Father Juan

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

Lon	05-18-2014 08:56 PM

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.

K a M a L

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

10-16-2016 11:43 PM

Is this add-on now working?

WindVoice

05-06-2017 03:36 AM

Anyone found a way to uninstall this mod?

bridge2heyday

05-07-2017 03:30 AM

Quote:

Originally Posted by WindVoice (Post 2586232)

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

05-08-2017 10:01 PM

yeah i am

WindVoice

05-09-2017 04:30 PM

Quote:

Originally Posted by bridge2heyday (Post 2586263)

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:

Quote:

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

It won't let me uninstall it.

bridge2heyday

05-10-2017 04:11 AM

Quote:

Originally Posted by CiXelSiD (Post 2586317)

yeah i am

Ok , I will upload it shortly

bridge2heyday

05-10-2017 04:14 AM

Quote:

Originally Posted by WindVoice (Post 2586336)

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.

All times are GMT. The time now is 11:58 PM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01507 seconds Memory Usage 1,844KB 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 (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (25)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: