Announcement

Collapse
No announcement yet.

Easy install bbcodes

Collapse
X
Collapse
First Prev Next Last
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Easy install bbcodes

    Here is a collection of custom bbcodes
    1) spoiler (speaks for itself) code used[ sa]spoiler[ /sa]
    2) Word Document (used with Google Docs)Code used example [ gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/ gd]
    3)Excel Spreadsheet(again with Google Docs)code used [ gs]14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM[ /gs]
    4) Presentation (again Google Docs) code used [ gp]dcjktv94_1fcpptwqc/gp]
    5) Party Vibe Radio code used [pvr]hardradio[ /pvr]
    There are 2 very simple ways to install these
    1) in admincp with this method you may need to edit config.php so you are abe to run found here
    $config['SpecialUsers']['canrunqueries'] = '1';
    Then open admincp/maintenance/execute sql query
    then paste the code below


    Code:
    INSERT INTO `bbcode` (`bbcodeid`, `bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`) VALUES
    (2, 'sa', '<div style="margin: 5px 20px 5px 20px;"> \r\n<div style="margin-bottom:2px; font-size: 80%%;">\r\n<strong>Have a guess before you look</strong><input type="button" value="Show" style="width:45px;font-size:10px;margin:0px;padding:0px;" onClick="if (this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display != \'\') { this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display = \'\'; this.innerText = \'\'; this.value = \'Hide\'; } else { this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display = \'none\'; this.innerText = \'\'; this.value = \'Show\'; }" /> \r\n</div> \r\n<div style="background: url(images/misc/bop5-alert-bk.png); margin: 0px; padding: 6px; border: 3px groove red; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; -webkit-box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75); -moz-box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75); box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75);">\r\n<div style="display: none;"><div style="background: rgba(255, 255, 255, 0.8); padding: 6px; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px;">%1$s</div></div>\r\n</div>\r\n</div>', '[sa]spoiler[/sa]', '', 0, 'Spoiler', 'images/spoil.png', 1),
    (3, 'gd', '<div align="center"><iframe src="https://docs.google.com/document/pub?id=%1$s&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id=%1$s">Direct Link to Google Document</a>.</iframe></div>', '[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]', '[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]', 0, 'word', '', 31),
    (5, 'gs', '<div align="center"><iframe width="95%%" height="900" frameborder="0" src="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html&widget=true\'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>', '[gs]14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM[/gs]', '', 0, 'Google Spreadsheet', 'images/icon/sheet.png', 31),
    (6, 'gp', '<div align="center"><iframe src="https://docs.google.com/present/embed?id=%1$s" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id=%1$s">Direct Link to Presentation.</a></iframe></div>', '[gp]dcjktv94_1fcpptwqc[/gp]', '', 0, 'slides', '', 31),
     (7, 'pvr', '<iframe src="http://www.partyviberadio.com/player/embed-dark-scradio/%1$s.html" style="border:0px #FFFFFF none;" name="embed-dark" scrolling="no" frameborder="1" marginheight="0px" marginwidth="0px" height="150px" width="200px">\r\n</iframe>', '[pvr]hardradio[/pvr]', '', 0, 'Party Vibe Radio', '', 31);
    2) or in phpmyadmin (not reccomended if you already have custom bbcodes)
    Goto phpmyamin select the database that holds forums tables then click on sql tab at the top paste in the code below then press go
    Code:
    -- Table structure for table `bbcode`
    --
    
    DROP TABLE IF EXISTS `bbcode`;
    CREATE TABLE `bbcode` (
      `bbcodeid` smallint(5) UNSIGNED NOT NULL,
      `bbcodetag` varchar(191) NOT NULL DEFAULT '',
      `bbcodereplacement` mediumtext,
      `bbcodeexample` varchar(200) NOT NULL DEFAULT '',
      `bbcodeexplanation` mediumtext,
      `twoparams` smallint(6) NOT NULL DEFAULT '0',
      `title` varchar(100) NOT NULL DEFAULT '',
      `buttonimage` varchar(250) NOT NULL DEFAULT '',
      `options` int(10) UNSIGNED NOT NULL DEFAULT '1'
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    --
    -- Dumping data for table `bbcode`
    --
    
    INSERT INTO `bbcode` (`bbcodeid`, `bbcodetag`, `bbcodereplacement`, `bbcodeexample`, `bbcodeexplanation`, `twoparams`, `title`, `buttonimage`, `options`) VALUES
    (2, 'sa', '<div style="margin: 5px 20px 5px 20px;"> \r\n<div style="margin-bottom:2px; font-size: 80%%;">\r\n<strong>Have a guess before you look</strong><input type="button" value="Show" style="width:45px;font-size:10px;margin:0px;padding:0px;" onClick="if (this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display != \'\') { this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display = \'\'; this.innerText = \'\'; this.value = \'Hide\'; } else { this.parentNode.parentNode.getElementsByTagName(\'div\')[1].getElementsByTagName(\'div\')[0].style.display = \'none\'; this.innerText = \'\'; this.value = \'Show\'; }" /> \r\n</div> \r\n<div style="background: url(images/misc/bop5-alert-bk.png); margin: 0px; padding: 6px; border: 3px groove red; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px; -webkit-box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75); -moz-box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75); box-shadow: 1px 1px 5px rgba(50, 50, 50, 0.75);">\r\n<div style="display: none;"><div style="background: rgba(255, 255, 255, 0.8); padding: 6px; -webkit-border-radius: 10px; -moz-border-radius: 10px; border-radius: 10px;">%1$s</div></div>\r\n</div>\r\n</div>', '[sa]spoiler[/sa]', '', 0, 'Spoiler', 'images/spoil.png', 1),
    (3, 'gd', '<div align="center"><iframe src="https://docs.google.com/document/pub?id=%1$s&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id=%1$s">Direct Link to Google Document</a>.</iframe></div>', '[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]', '[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]', 0, 'word', '', 31),
    (5, 'gs', '<div align="center"><iframe width="95%%" height="900" frameborder="0" src="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html&widget=true\'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key=%1$s"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>', '[gs]14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM[/gs]', '', 0, 'Google Spreadsheet', 'images/icon/sheet.png', 31),
    (6, 'gp', '<div align="center"><iframe src="https://docs.google.com/present/embed?id=%1$s" frameborder="0" width="700" height="559">IFRAME Not Available. <a href="https://docs.google.com/present/view?id=%1$s">Direct Link to Presentation.</a></iframe></div>', '[gp]dcjktv94_1fcpptwqc[/gp]', '', 0, 'slides', '', 31),
    
    (7, 'pvr', '<iframe src="http://www.partyviberadio.com/player/embed-dark-scradio/%1$s.html" style="border:0px #FFFFFF none;" name="embed-dark" scrolling="no" frameborder="1" marginheight="0px" marginwidth="0px" height="150px" width="200px">\r\n</iframe>', '[pvr]hardradio[/pvr]', '', 0, 'Party Vibe Radio', '', 31);
    
    --
    -- Indexes for dumped tables
    --
    
    --
    -- Indexes for table `bbcode`
    --
    ALTER TABLE `bbcode`
      ADD PRIMARY KEY (`bbcodeid`),
      ADD UNIQUE KEY `uniquetag` (`bbcodetag`,`twoparams`);
    
    --
    -- AUTO_INCREMENT for dumped tables
    --
    
    --
    -- AUTO_INCREMENT for table `bbcode`
    --
    ALTER TABLE `bbcode`
      MODIFY `bbcodeid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
    Wise men say nothing Fools never listen

    #2
    Ok i was assuming in this that your database has no prefix at start if it has in first method edit this line
    INSERT INTO `bbcode`by adding the prefix in front like this INSERT INTO `vbbbcode` or whatever the prefix is
    Last edited by willie53; 04-09-2017, 02:33 PM. Reason: typo
    Wise men say nothing Fools never listen

    Comment


      #3
      Thanks for sharing.

      I also have Spoiler BBCode. Mine allows you to make parts of a sentence a spoiler without making the hidden text in its own line. The hidden text stays inline.

      https://vbmods.rocks/forum/vbulletin...spoiler-bbcode
      Helpful? Donate. Thanks!
      Fast VPS Host for vBulletin: A2 Hosting & IONOS

      Comment


        #4
        id like to add 2 and 3.....but a manual install would be best, is it possible?
        thank you

        Comment


          #5
          willie53, for #2 using phpmyadmin, why do you have to drop, create and alter the bbcode table? This will delete existing bbcodes. Why not just run the INSERT statements just like you did in #1 Execute SQL Query in AdminCP?
          Helpful? Donate. Thanks!
          Fast VPS Host for vBulletin: A2 Hosting & IONOS

          Comment


            #6
            Originally posted by glennrocksvb View Post
            willie53, for #2 using phpmyadmin, why do you have to drop, create and alter the bbcode table? This will delete existing bbcodes. Why not just run the INSERT statements just like you did in #1 Execute SQL Query in AdminCP?
            you know what that would make more sense it is just the way i do things yes you can execute the first one that way
            Wise men say nothing Fools never listen

            Comment


              #7
              Originally posted by IggyP View Post
              id like to add 2 and 3.....but a manual install would be best, is it possible?
              thank you
              Here is instructions for maually adding
              2)
              Title: Google Word Document
              BB Code Tag Name: gd
              Replacemet
              Code:
              <div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&single=true&gid=0&output=html&widget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>
              Example:[gd]1bhtK-AhiXqfWK5bGJcULvEO3zMahcFgnJEsT1YvYsuc[/gd]

              Use Option No
              Rest of options yes

              3)
              Title:Google Spreadsheet
              BB Code Tag Name: gs
              Replacement
              Code:
              <div align="center"><iframe width="95%" height="900" frameborder="0" src="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html&widget=true'>IFRAME Not Available. <a href="https://spreadsheets.google.com/pub?key={param}"&hl=en&single=true&gid=0&output=html">Direct Link to Spreadsheet.</a></iframe></div>
              Example:[gs]14pmOx9znK02UTHeY7BdQKe792MML1f81CtO7I4DAnfM[/gs]

              Use Option No

              Rest of options yes
              Last edited by willie53; 04-10-2017, 12:37 AM. Reason: some typos
              Wise men say nothing Fools never listen

              Comment


              #8
              hmm i tried the word doc one....got an error but i dont see what its talking about?

              The following BB Code replacement may not be properly formed. All HTML attributes should be enclosed within double quotes.
              • <div align="center"><iframe src="https://docs.google.com/document/pub?id={param}&amp;embedded=true&single=true&gid=0&output=html&w idget=true" width="95%" height="500">IFRAME Not Available. <a href="https://{option}.google.com/document/pub?id={param}">Direct Link to Google Document</a>.</iframe></div>

              Comment


              • IggyP
                IggyP commented
                Editing a comment
                oh i see just needs extra quotes on option and param

              #9
              the error you are gettig is normal it will still work
              Wise men say nothing Fools never listen

              Comment

              Working...
              X