SQL Rewriting? does it need extra confirm?

phpBB3 SEO Advanced mod Rewrite support forum.
This mods performs URL rewriting for phpBB, injecting forums and topic titles in their URLs.

Moderator: Moderators

SQL Rewriting? does it need extra confirm?

Postby Kappa » Fri Mar 12, 2010 9:26 am

SQL Rewriting? does it need extra confirm after instal?
Kappa
 
Posts: 15
Joined: Fri Jan 22, 2010 5:41 pm

Advertisement

Re: SQL Rewriting? does it need extra confirm?

Postby Kappa » Fri Mar 12, 2010 9:44 am

1. isntalled
2. activated in php seo module
3. updated .htaces
4. nothing :<
Kappa
 
Posts: 15
Joined: Fri Jan 22, 2010 5:41 pm

Re: SQL Rewriting? does it need extra confirm?

Postby SoonDead » Fri Mar 12, 2010 11:46 am

Exactly what do you install? The Ultimate SEO Url mod, or the premod or what?
What do you mean by nothing? The Url-s are not rewritten? The forum does not work?
User avatar
SoonDead
 
Posts: 32
Joined: Wed May 20, 2009 8:39 pm

Re: SQL Rewriting? does it need extra confirm?

Postby dcz » Fri Mar 12, 2010 3:51 pm

When you first activate it, you should synchronize your topic urls (as suggested in the acp message after your did) using the phpbb_seo/sync_url.php script.

Then, the main difference is that you can change topic URLs when editing a topic first post or posting a new topic. If the URL field does not show up, you did not implement the required template code change for it.

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Re: SQL Rewriting? does it need extra confirm?

Postby Kappa » Fri Mar 12, 2010 4:27 pm

i installed premod ;p
phpbb_seo/sync_url.php done but i use mu own style so i hawe to change something :/
Kappa
 
Posts: 15
Joined: Fri Jan 22, 2010 5:41 pm

Re: SQL Rewriting? does it need extra confirm?

Postby dcz » Sun Mar 14, 2010 1:06 pm

Yes, like with any mod altering templates, you nee to implement the template changes in styles you add. Usually, either prosilver or subsilver2 code change fits well in other styles.

++
Useful links :
SEO Forum || SEO Directory || SEO phpBB || Search
____________________

Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Recherche
dcz
Admin
Admin
 
Posts: 21219
Joined: Fri Apr 28, 2006 9:03 pm

Re: SQL Rewriting? does it need extra confirm?

Postby Kappa » Mon Mar 15, 2010 6:30 pm

Usually

I thought it will be ctrl+f; ctrl+c and ctrl+v
but code dont match ... it just look similar, and i think i will f&ckup ewerything :mrgreen:

Code: Select all
styles/prosilver/template/attachment.html

#
#-----[ FIND ]------------------------------------------
#

         <dt><a href="{_file.U_DOWNLOAD_LINK}"><img src="{_file.THUMB_IMAGE}" alt="{_file.DOWNLOAD_NAME}" title="{_file.DOWNLOAD_NAME} ({_file.FILESIZE} {_file.SIZE_LANG}) {_file.L_DOWNLOAD_COUNT}" /></a></dt>

#
#-----[ REPLACE WITH ]------------------------------------------
#

         <dt><a href="{_file.U_DOWNLOAD_LINK}"><img src="{_file.THUMB_IMAGE}" alt="{_file.DOWNLOAD_NAME}" title="<!-- IF _file.COMMENT_CLEAN -->{_file.COMMENT_CLEAN} / {_file.DOWNLOAD_NAME}<!-- ELSE -->{_file.DOWNLOAD_NAME} ({_file.FILESIZE} {_file.SIZE_LANG}) {_file.L_DOWNLOAD_COUNT}<!-- ENDIF -->" /></a></dt>

#
#-----[ FIND ]------------------------------------------
#

         <dt class="attach-image"><img src="{_file.U_INLINE_LINK}" alt="{_file.DOWNLOAD_NAME}" onclick="viewableArea(this);" /></dt>

#
#-----[ REPLACE WITH ]------------------------------------------
#

         <dt class="attach-image"><img src="{_file.U_INLINE_LINK}" alt="{_file.DOWNLOAD_NAME}" title="<!-- IF _file.COMMENT_CLEAN -->{_file.COMMENT_CLEAN} / <!-- ENDIF -->{_file.DOWNLOAD_NAME}" onclick="viewableArea(this);" /></dt>

#
#-----[ FIND ]------------------------------------------
#

         <dt><!-- IF _file.UPLOAD_ICON -->{_file.UPLOAD_ICON} <!-- ENDIF --><a class="postlink" href="{_file.U_DOWNLOAD_LINK}">{_file.DOWNLOAD_NAME}</a></dt>

#
#-----[ REPLACE WITH ]------------------------------------------
#

         <dt><!-- IF _file.UPLOAD_ICON -->{_file.UPLOAD_ICON} <!-- ENDIF --><a class="postlink" href="{_file.U_DOWNLOAD_LINK}" title="<!-- IF _file.COMMENT_CLEAN -->{_file.COMMENT_CLEAN} / <!-- ENDIF -->{_file.DOWNLOAD_NAME}">{_file.DOWNLOAD_NAME}</a></dt>

#
#-----[ OPEN ]------------------------------------------
## MOD Title:       phpBB SEO Ultimate SEO URL
#

styles/prosilver/template/forum_fn.js

#
#-----[ FIND ]------------------------------------------
#

function jumpto()
{
   var page = prompt(jump_page, on_page);

   if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0)
   {
      if (base_url.indexOf('?') == -1)
      {
         document.location.href = base_url + '?start=' + ((page - 1) * per_page);
      }
      else
      {
         document.location.href = base_url.replace(/&amp;/g, '&') + '&start=' + ((page - 1) * per_page);
      }
   }
}

#
#-----[ REPLACE WITH ]------------------------------------------
#

// http://www.phpBB-SEO.com SEO TOOLKIT BEGIN
function jumpto() {
   var page = prompt(jump_page, on_page);

   if (page !== null && !isNaN(page) && page == Math.floor(page) && page > 0) {
      var seo_page = (page - 1) * per_page;
      var anchor = '';
      var anchor_parts = base_url.split('#');
      if ( anchor_parts[1] ) {
         base_url = anchor_parts[0];
         anchor = '#' + anchor_parts[1];
      }
      if ( base_url.indexOf('?') >= 0 ) {
         document.location.href = base_url.replace(/&amp;/g, '&') + '&start=' + seo_page + anchor;
      } else if ( seo_page > 0 ) {
         var seo_type1 = base_url.match(/\.[a-z0-9]+$/i);
         if (seo_type1 !== null) {
            document.location.href = base_url.replace(/\.[a-z0-9]+$/i, '') + seo_delim_start + seo_page + seo_type1 + anchor;
         }
         var seo_type2 = base_url.match(/\/$/);
         if (seo_type2 !== null) {
            document.location.href = base_url + seo_static_pagination + seo_page + seo_ext_pagination + anchor;
         }
      } else {
         document.location.href = base_url + anchor;
      }
   }
}
// Open external links in new window in a XHTML 1.x compliant way.
/**
*  phpbb_seo_href()
*  Fixes href="#something" links with virtual directories
*  Optionally open external or marked with a css class links in a new window
*  in a XHTML 1.x compliant way.
*/
function phpbb_seo_href() {
   var current_domain = document.domain.toLowerCase();
   if (!current_domain || !document.getElementsByTagName) return;
   if (seo_external_sub && current_domain.indexOf('.') >= 0) {
      current_domain = current_domain.replace(new RegExp(/^[a-z0-9_-]+\.([a-z0-9_-]+\.([a-z]{2,6}|[a-z]{2,3}\.[a-z]{2,3}))$/i), '$1');
   }
   if (seo_ext_classes) {
      var extclass = new RegExp("(^|\s)(" + seo_ext_classes + ")(\s|$)");
   }
   if (seo_hashfix) {
      var basehref = document.getElementsByTagName('base')[0];
      if (basehref) {
         basehref = basehref.href;
         var hashtest = new RegExp("^(" + basehref + "|)#[a-z0-9_-]+$");
         var current_href = document.location.href.replace(/#[a-z0-9_-]+$/i, "");
      } else {
         seo_hashfix = false;
      }
   }
   var hrefels = document.getElementsByTagName("a");
   var hrefelslen = hrefels.length;
   for (var i = 0; i < hrefelslen; i++) {
      var el = hrefels[i];
      var hrefinner = el.innerHTML.toLowerCase();
      if (el.onclick || (el.href == '') || (el.href.indexOf('javascript') >=0 ) || (el.href.indexOf('mailto') >=0 ) || (hrefinner.indexOf('<a') >= 0) ) {
         continue;
      }
      if (seo_hashfix && el.hash && hashtest.test(el.href)) {
         el.href = current_href + el.hash;
      }
      if (seo_external) {
         if ((el.href.indexOf(current_domain) >= 0) && !(seo_ext_classes && extclass.test(el.className))) {
            continue;
         }
         el.onclick = function () { window.open(this.href); return false; };
      }
   }
}
if (seo_external || seo_hashfix) {
   onload_functions.push('phpbb_seo_href()');
}
// http://www.phpBB-SEO.com SEO TOOLKIT END


and i hawe this

Code: Select all
<!-- BEGIN _file -->

   <!-- IF _file.S_DENIED -->
      <span class="genmed">[{_file.DENIED_MESSAGE}]</span><br />
   <!-- ELSE -->

      <!-- IF _file.COMMENT -->
         <span class="gensmall"><b>{L_FILE_COMMENT}:</b> {_file.COMMENT}</span><br />
      <!-- ENDIF -->

      <!-- IF _file.S_THUMBNAIL -->
         <a href="{_file.U_DOWNLOAD_LINK}"><img src="{_file.THUMB_IMAGE}" alt="{_file.DOWNLOAD_NAME}" /></a><br />
         <span class="gensmall">{_file.DOWNLOAD_NAME} [ {_file.FILESIZE} {_file.SIZE_LANG} | {_file.L_DOWNLOAD_COUNT} ]</span>
      <!-- ENDIF -->

      <!-- IF _file.S_IMAGE -->
         <img src="{_file.U_INLINE_LINK}" alt="{_file.DOWNLOAD_NAME}" /><br />
         <span class="gensmall">{_file.DOWNLOAD_NAME} [ {_file.FILESIZE} {_file.SIZE_LANG} | {_file.L_DOWNLOAD_COUNT} ]</span>
      <!-- ENDIF -->

      <!-- IF _file.S_FILE -->
         <span class="genmed">
            <!-- IF _file.UPLOAD_ICON -->{_file.UPLOAD_ICON} <!-- ENDIF -->
            <a href="{_file.U_DOWNLOAD_LINK}">{_file.DOWNLOAD_NAME}</a> [{_file.FILESIZE} {_file.SIZE_LANG}]
         </span><br />
         <span class="gensmall">{_file.L_DOWNLOAD_COUNT}</span>
      <!-- ENDIF -->

      <!-- IF _file.S_WM_FILE -->
         <!-- method used here from http://alistapart.com/articles/byebyeembed / autosizing seems to not work always, this will not fix -->
         <object width="320" height="285" classid="CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6" id="wmstream_{_file.ATTACH_ID}">
            <param name="url" value="{_file.U_DOWNLOAD_LINK}" />
            <param name="showcontrols" value="1" />
            <param name="showdisplay" value="0" />
            <param name="showstatusbar" value="0" />
            <param name="autosize" value="1" />
            <param name="autostart" value="0" />
            <param name="visible" value="1" />
            <param name="animationstart" value="0" />
            <param name="loop" value="0" />
            <param name="src" value="{_file.U_DOWNLOAD_LINK}" />
            <!--[if !IE]>-->
               <object width="320" height="285" type="video/x-ms-wmv" data="{_file.U_DOWNLOAD_LINK}">
                  <param name="src" value="{_file.U_DOWNLOAD_LINK}" />
                  <param name="controller" value="1" />
                  <param name="showcontrols" value="1" />
                  <param name="showdisplay" value="0" />
                  <param name="showstatusbar" value="0" />
                  <param name="autosize" value="1" />
                  <param name="autostart" value="0" />
                  <param name="visible" value="1" />
                  <param name="animationstart" value="0" />
                  <param name="loop" value="0" />
               </object>
            <!--<![endif]-->
         </object>

      <!-- ELSEIF _file.S_FLASH_FILE -->
         <object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" codebase="http://active.macromedia.com/flash2/cabs/swflash.cab#version=5,0,0,0" width="{_file.WIDTH}" height="{_file.HEIGHT}">
            <param name="movie" value="{_file.U_DOWNLOAD_LINK}" />
            <param name="play" value="true" />
            <param name="loop" value="true" />
            <param name="quality" value="high" />
            <param name="allowScriptAccess" value="never" />
            <param name="allowNetworking" value="internal" />
            <embed src="{_file.U_DOWNLOAD_LINK}" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" width="{_file.WIDTH}" height="{_file.HEIGHT}" play="true" loop="true" quality="high" allowscriptaccess="never" allownetworking="internal"></embed>
         </object>
      <!-- ELSEIF _file.S_QUICKTIME_FILE -->
         <object id="qtstream_{_file.ATTACH_ID}" classid="clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B" codebase="http://www.apple.com/qtactivex/qtplugin.cab#version=6,0,2,0" width="0" height="16">
            <param name="src" value="{_file.U_DOWNLOAD_LINK}">
            <param name="controller" value="true">
            <param name="autoplay" value="false" />
            <param name="type" value="video/quicktime">
            <embed name="qtstream_{_file.ATTACH_ID}" src="{_file.U_DOWNLOAD_LINK}" pluginspage="http://www.apple.com/quicktime/download/" enablejavascript="true" controller="true" width="0" height="16" type="video/quicktime" autoplay="false">
         </object>
      <!-- ELSEIF _file.S_RM_FILE -->
         <object id="rmstream_{_file.ATTACH_ID}" classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA" width="200" height="50">
            <param name="src" value="{_file.U_DOWNLOAD_LINK}">
            <param name="autostart" value="false">
            <param name="controls" value="ImageWindow">
            <param name="console" value="ctrls_{_file.ATTACH_ID}">
            <param name="prefetch" value="false">
            <embed name="rmstream_{_file.ATTACH_ID}" type="audio/x-pn-realaudio-plugin" src="{_file.U_DOWNLOAD_LINK}" width="0" height="0" autostart="false" controls="ImageWindow" console="ctrls_{_file.ATTACH_ID}" prefetch="false"></embed>
         </object>
         <br />
         <object id="ctrls_{_file.ATTACH_ID}" classid="clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA" width="0" height="36">
            <param name="controls" value="ControlPanel">
            <param name="console" value="ctrls_{_file.ATTACH_ID}">
            <embed name="ctrls_{_file.ATTACH_ID}" type="audio/x-pn-realaudio-plugin" width="200" height="36" controls="ControlPanel" console="ctrls_{_file.ATTACH_ID}"></embed>
         </object>

         <script type="text/javascript">
         // <![CDATA[
            if (document.rmstream_{_file.ATTACH_ID}.GetClipWidth)
            {
               while (!document.rmstream_{_file.ATTACH_ID}.GetClipWidth())
               {
               }

               var width = document.rmstream_{_file.ATTACH_ID}.GetClipWidth();
               var height = document.rmstream_{_file.ATTACH_ID}.GetClipHeight();

               document.rmstream_{_file.ATTACH_ID}.width = width;
               document.rmstream_{_file.ATTACH_ID}.height = height;
               document.ctrls_{_file.ATTACH_ID}.width = width;
            }
         // ]]>
         </script>
      <!-- ENDIF -->

      <!-- IF _file.S_WM_FILE or _file.S_RM_FILE or _file.S_FLASH_FILE or _file.S_QUICKTIME_FILE -->
         <br />
         <!-- IF _file.S_QUICKTIME_FILE --><a href="#" onclick="play_qt_file(document.qtstream_{_file.ATTACH_ID}); return false;">[ {L_PLAY_QUICKTIME_FILE} ]</a> <!-- ENDIF -->
         <span class="gensmall"><a href="{_file.U_DOWNLOAD_LINK}">{_file.DOWNLOAD_NAME}</a> [ {_file.FILESIZE} {_file.SIZE_LANG} | {_file.L_DOWNLOAD_COUNT} ]</span>
      <!-- ENDIF -->

      <br />
   <!-- ENDIF -->

<!-- END _file -->



MACHES NOT PURFECTLY :///
Kappa
 
Posts: 15
Joined: Fri Jan 22, 2010 5:41 pm

Re: SQL Rewriting? does it need extra confirm?

Postby SeO » Tue Mar 16, 2010 5:12 pm

If you look at the code change, it's only adding the title attribute in the href tag.
So you can either bypass these code change in attachment.html or add the title="" code added in the corresponding link (should not be hard to figure out, just search for what stands for the url in the hrefs to match the parts).
SeO
Admin
Admin
 
Posts: 6333
Joined: Wed Mar 15, 2006 9:41 pm


Return to Advanced SEO URL

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 3 guests