Smilies After UBB Import

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #16
    This is from the my UBB 5.45c board which was upgraded to vB in May. I have no idea why the conversion didn't take care of these icons. Most of the message icons imported just fine. However these particular ones all show:

    <img src="" alt="" border="0">

    I just want to fix these along with the smilies if that's possible.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Mike Sullivan
      Former vBulletin Developer
      • Apr 2000
      • 13327
      • 3.6.x

      #17
      The code you posted should work then.

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #18
        Thanks for the help!
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • Steve Machol
          Former Customer Support Manager
          • Jul 2000
          • 154488

          #19
          Ed, the smilie fix worked fine! However the message icons weren't fixed. Here's a URL:

          Does anyone know if there is a required minimum size for the B measurement on a frame when using trifocals?
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment

          • Mike Sullivan
            Former vBulletin Developer
            • Apr 2000
            • 13327
            • 3.6.x

            #20
            I believe that's what happens when a post references an iconid that doesn't actually exist in the database.

            Try to run this query, and if it works, let me know what it returns:

            SELECT DISTINCT post.iconid FROM post LEFT JOIN icon ON icon.iconid=post.iconid WHERE icon.iconid IS NULL;

            Comment

            • Steve Machol
              Former Customer Support Manager
              • Jul 2000
              • 154488

              #21
              Here's what it returns:

              iconid
              Edit Delete 0
              Edit Delete 6
              Edit Delete 7
              Edit Delete 8
              Edit Delete 10
              Edit Delete 11
              Edit Delete 12
              Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
              Change CKEditor Colors to Match Style (for 4.1.4 and above)

              Steve Machol Photography


              Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


              Comment

              • Mike Sullivan
                Former vBulletin Developer
                • Apr 2000
                • 13327
                • 3.6.x

                #22
                UPDATE post SET iconid=0 WHERE iconid IN (6,7,8,10,11,12);

                That should fix it.

                Comment

                • Steve Machol
                  Former Customer Support Manager
                  • Jul 2000
                  • 154488

                  #23
                  Great Ed - this fixed it in the thread displays. However the image is still broken in forumdisplay:



                  The offending code here is:

                  <img src="" alt="" width="15" height="15" border="0">
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

                  • Mike Sullivan
                    Former vBulletin Developer
                    • Apr 2000
                    • 13327
                    • 3.6.x

                    #24
                    Same thing, different table:

                    UPDATE thread SET iconid=0 WHERE iconid IN (6,7,8,10,11,12);

                    Comment

                    • Steve Machol
                      Former Customer Support Manager
                      • Jul 2000
                      • 154488

                      #25
                      Excellent!!! Worked like a charm. Thanks a bunch!
                      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                      Change CKEditor Colors to Match Style (for 4.1.4 and above)

                      Steve Machol Photography


                      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                      Comment

                      • Hellburn
                        New Member
                        • Feb 2002
                        • 11

                        #26
                        The smiliefix does not work by me. When i start the fix is oki than i become the message:

                        8 done.
                        20 done.
                        89 done.
                        93 done.
                        125 done.
                        131 done.
                        138 done. usw.

                        but the thread is the same bevor. This code i have insert the fix:

                        $text = str_replace('<img src="graemlins/rotaeye.gif" border="0" alt="[LeichtBescheuert]" />', ':%-!:', $text);

                        The post have this ubbcode what i wont clean: bla bla bla (exmpl.) <img src="graemlins/rotaeye.gif" border="0" alt="[LeichtBescheuert]" />


                        P.S.Sorry for my bad english.


                        mfg Hellburn
                        Last edited by Hellburn; Sun 17 Feb '02, 1:40pm.

                        Comment

                        • RAH
                          New Member
                          • Nov 2005
                          • 18
                          • 3.5.x

                          #27
                          Did Mike post a script? It looks like he did but it's not showing for me.

                          Comment

                          • peterska2
                            Senior Member
                            • Oct 2003
                            • 8869
                            • 3.7.x

                            #28
                            Please do not bump old threads. For support please start your own thread in the relevant forum.

                            Comment

                            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                            Working...