Page 2 of 3 FirstFirst 1 2 3 LastLast
Results 16 to 30 of 31

Does vBseo also work with vBadvanced and vBadvanced links directory?

This is a discussion on Does vBseo also work with vBadvanced and vBadvanced links directory? within the General Discussion forums, part of the vBSEO SEO Plugin category; Do you have any idea why I got a database error when I first tried it though? It made some ...

  1. #16
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Do you have any idea why I got a database error when I first tried it though? It made some mention of "duplicate entry" or something like that.

    I guess I can try and do it manually, but that just seems like it'll be a big pain.

  2. #17
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    What exactly did the error say?
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  3. #18
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    It gets to the first template where it should replace something and then gives me this error:

    Code:
    Database error in vBulletin 3.5.2:
    Invalid SQL:
          INSERT INTO template
           (styleid, title, template, template_un, dateline, username, version)
          VALUES
           (23,
            'adv_links_directorybit_level1',
            '</tbody>\n<tbody>\n<tr>\n <td colspan=\\\"2\\\" class=\\\"alt1\\\">\n\n  <table border=\\\"0\\\" cellpadding=\\\"0\\\" cellspacing=\\\"0\\\">\n   <tr>\n    <td><img alt=\\\"\\\" border=\\\"0\\\" src=\\\"$stylevar[imgdir_statusicon]/forum_$onoff.gif\\\" /></td>\n    <td><img alt=\\\"\\\" src=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bburl\'] . \"/\" . $GLOBALS[\'vbulletin\']->options[\'cleargifurl\'] . \"\\\" width=\\\"9\\\" /></td>\n    <td><b><a href=\\\"browselinks.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"c=$cats[catid]\\\">$cats[title]</a></b>\n     <div class=\\\"smallfont\\\">$cats[description]</div>\n     \".(($show[\'subscribe_options\']) ? (\"\n      <div class=\\\"smallfont\\\">\n       [<a href=\\\"misc.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"do=unsubscribe&amp;type=dir&amp;c=$cats[catid]&amp;return=subscriptions\\\">$vbphrase[unsubscribe_from_this_directory]</a>]\n      </div>\n     \") : (\"\")).\"\n    </td>\n   </tr>\n  </table>\n </td>\n\n\n <td class=\\\"alt2\\\" nowrap=\\\"nowrap\\\">\n  \".(($cats[\'lastlinkid\']) ? (\"\n   <span class=\\\"smallfont\\\"><b><a href=\\\"showlink.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"ltitle=$link_seo_title&do=showdetails&amp;l=$cats[lastlinkid]\\\">$cats[lastlinktitle]</a></b><br />\n   $vbphrase[by]\n   \".(($cats[\'lastuserid\']) ? (\"\n    <a href=\\\"\" . $GLOBALS[\'vbulletin\']->options[\'bburl\'] . \"/member.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"u=$cats[lastuserid]\\\">$cats[lastposter]</a>\n   \") : (\"\n    $vbphrase[guest]\n   \")).\"\n   </span><div class=\\\"smallfont\\\" align=\\\"right\\\">$cats[lastupdateddate] <span class=\\\"time\\\">$cats[lastupdatedtime]</span> <a href=\\\"showlink.php?\" . $GLOBALS[\'vbulletin\']->session->vars[\'sessionurl\'] . \"ltitle=$link_seo_title&do=showdetails&amp;l=$cats[lastlinkid]\\\"><img alt=\\\"\\\" border=\\\"0\\\" src=\\\"$stylevar[imgdir_button]/lastpost.gif\\\" /></a></div>\n  \") : (\"\n   <div align=\\\"center\\\">$vbphrase[never]</div>\n  \")).\"\n </td>\n\n <td align=\\\"center\\\" class=\\\"alt1\\\"><span class=\\\"smallfont\\\">$cats[linkcount]</span></td>\n\n \".(($vba_options[\'links_allowreplies\']) ? (\"\n  <td align=\\\"center\\\" class=\\\"alt2\\\"><span class=\\\"smallfont\\\">$cats[postcount]</span></td>\n \") : (\"\")).\"\n\n \".(($show[\'modcolumn\']) ? (\"\n  <td align=\\\"center\\\" class=\\\"\".(($vba_options[\'links_allowreplies\']) ? (\"alt1\") : (\"alt2\")).\"\\\">$cats[moderator]</td>\n \") : (\"\")).\"\n\n</tr>\n',
            '</tbody>\n<tbody>\n<tr>\n <td colspan=\"2\" class=\"alt1\">\n\n  <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n   <tr>\n    <td><img alt=\"\" border=\"0\" src=\"$stylevar[imgdir_statusicon]/forum_$onoff.gif\" /></td>\n    <td><img alt=\"\" src=\"$vboptions[bburl]/$vboptions[cleargifurl]\" width=\"9\" /></td>\n    <td><b><a href=\"browselinks.php?$session[sessionurl]c=$cats[catid]\">$cats[title]</a></b>\n     <div class=\"smallfont\">$cats[description]</div>\n     <if condition=\"$show[\'subscribe_options\']\">\n      <div class=\"smallfont\">\n       [<a href=\"misc.php?$session[sessionurl]do=unsubscribe&amp;type=dir&amp;c=$cats[catid]&amp;return=subscriptions\">$vbphrase[unsubscribe_from_this_directory]</a>]\n      </div>\n     </if>\n    </td>\n   </tr>\n  </table>\n </td>\n\n\n <td class=\"alt2\" nowrap=\"nowrap\">\n  <if condition=\"$cats[\'lastlinkid\']\">\n   <span class=\"smallfont\"><b><a href=\"showlink.php?$session[sessionurl]ltitle=$link_seo_title&do=showdetails&amp;l=$cats[lastlinkid]\">$cats[lastlinktitle]</a></b><br />\n   $vbphrase[by]\n   <if condition=\"$cats[\'lastuserid\']\">\n    <a href=\"$vboptions[bburl]/member.php?$session[sessionurl]u=$cats[lastuserid]\">$cats[lastposter]</a>\n   <else />\n    $vbphrase[guest]\n   </if>\n   </span><div class=\"smallfont\" align=\"right\">$cats[lastupdateddate] <span class=\"time\">$cats[lastupdatedtime]</span> <a href=\"showlink.php?$session[sessionurl]ltitle=$link_seo_title&do=showdetails&amp;l=$cats[lastlinkid]\"><img alt=\"\" border=\"0\" src=\"$stylevar[imgdir_button]/lastpost.gif\" /></a></div>\n  <else />\n   <div align=\"center\">$vbphrase[never]</div>\n  </if>\n </td>\n\n <td align=\"center\" class=\"alt1\"><span class=\"smallfont\">$cats[linkcount]</span></td>\n\n <if condition=\"$vba_options[\'links_allowreplies\']\">\n  <td align=\"center\" class=\"alt2\"><span class=\"smallfont\">$cats[postcount]</span></td>\n </if>\n\n <if condition=\"$show[\'modcolumn\']\">\n  <td align=\"center\" class=\"<if condition=\"$vba_options[\'links_allowreplies\']\">alt1<else />alt2</if>\">$cats[moderator]</td>\n </if>\n\n</tr>\n',
            1176682565,
            'thehalogod',
            '3.5.2');
    MySQL Error  : Duplicate entry 'adv_links_directorybit_level1-23' for key 2
    Error Number : 1062
    Date         : Sunday, April 15th 2007 @ 08:16:05 PM
    Script       : http://www.gamingvidz.com/forum/xxxxxx/template.php
    Referrer     : http://www.gamingvidz.com/forum/xxxx....php?do=search
    IP Address   : xx.xx.xx.xx
    Username     : thehalogod
    Classname    : vb_database
    Note x's signify characters I've taken out.

    Edit: Should I just try the syles and templates / replacement variable manager?

  4. #19
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    I'm not sure why does it happen, you should try to do it manually then. You can also copy template into your text editor, perform search and replace operation and copy it back to vB admincp.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  5. #20
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Ok, I'll go grab the appropriate templates and put them in notepad and try it. Will post back once I've done it.

  6. #21
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    When I try and reinput the text that I've changed in my text editor it gives me this message when I try and save the template:

    "A template named adv_links_directorybit_level1 already exists.

    If you click 'Save' the existing template will be overwritten."

    But if I click save and look at the template my changes are not saved. Now what do I do to fix that? :(

  7. #22
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Update:

    I reuploaded one of my old styles before I did all these changes and after reuploading it for some crazy unknown reason the stuff was fixed.

    In other words, my search and replace thing worked but only after I uploaded a new style.

    So now my links look like this (hover over them to see what I'm talking about):

    Gaming Videos - Video Database- Shadz Hayz & The Crack's Halo 2 Dualtage

    Is there a way to get rid of the "displaylink" part of it?

    My category url's look like this (hover over them to see what I'm talking about):

    Gaming Videos - Video Database - Montages

    Is there a way to make it look like forum categories do? Because rather than having /linkcat-2.html it'd probably be much better for it to be: http://www.gamingvidz.com/vidz/montages.html

    Any ideas on how to get these fixs? Thanks so far Oleg, we're getting close

    Here is my .htaccess for the "vidz" folder:

    Code:
    RewriteEngine On
    RewriteCond %{QUERY_STRING} !vbseourl=
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule ^(.*)$  /forum/vbseo.php?vbseourl=$1&vbseorelpath=../vidz/&%{QUERY_STRING} [L]
    RewriteCond %{REQUEST_FILENAME} !forum/
    RewriteRule ^(.*\.php)$ /forum/vbseo.php?vbseourl=$1&vbseorelpath=../vidz/&%{QUERY_STRING} [L]
    and my CRR's:

    Code:
    //vidz Rewrites
    'browselinks\.php\?do=newlinks$' => 'newlinks.html'
    'browselinks\.php\?do=poplinks$' => 'top.html'
    'browselinks\.php\?do=poplinks&orderby=rating$' => 'toprating.html'
    'browselinks\.php\?do=poplinks&orderby=posts$' => 'topposts.html'
    'browselinks\.php\?c=(\d+).*$' => 'linkcat-$1.html'
    'vidz/search\.php' => 'search.html'
    'vidz/search\.php\?do=searchresults&string=(\w+)&catid= 0&quicksearch=1' => 'search-$1.html' 
    'browselinks\.php\?do=browselinks&catid=(\d+)<r=(\w+)&linkuserid=(\d+)' => 'linkcat-$1-$2.html'
    'browselinks\.php\?do=poplinks&orderby=views' => 'topviews.html'
    'misc\.php\?do=linktous' => 'linktous.html'
    'addlink\.php\?c=(\d*)' => 'addlink$1.html'
    'misc\.php\?do=report&linkid=(\d+)&catid=(\d+)' => 'reportlink-$1-$2.html'
    'showlink\.php\?ltitle=(.+)&do=showdetails&l=(\d+)&catid=(\d+)' => 'displaylink-$1-$2-c$3.html'
    'showlink\.php\?ltitle=(.+)&do=showdetails&l=(\d+)' => 'displaylink-$1-$2.html'

  8. #23
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Is there a way to get rid of the "displaylink" part of it?
    You can change "displaylink" to something else in right part of CRRs for that.
    Is there a way to make it look like forum categories do?
    That will require additional modifications in vBa Links code/templates (similar to showlink URLs).
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  9. #24
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Can I just remove "displaylink" entirely? Or do I still get the SEO advantage?

    Also, do you have an idea of what changes I'd have to make (i.e. experience with doing them) for the categories that is? Or would it require so much work that it's probably not even worth doing?

    And lastly, I have this module on the front page of my vbadvanced that displays the latest links put into the the links directory, but it still shows those links as dynamic urls and not the changes that have affected the links in the link directory?

    I did find a template for that particular module and did the find and replace for "do=showdetails" but that didn't seem to fix the problem.

    Again, thank you for all your help thus far. The other site I purchased vbseo for uses vbadvanced links directory as well, so I'll be able to use what you've taught me from this one and apply it to that site.
    Last edited by ChrisGuthrie.net; 04-16-2007 at 02:22 AM.

  10. #25
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Can I just remove "displaylink" entirely? Or do I still get the SEO advantage?
    It will be conflicting with other URLs in this case.

    Also, do you have an idea of what changes I'd have to make (i.e. experience with doing them) for the categories that is? Or would it require so much work that it's probably not even worth doing?
    The complexity of the changes would be similar to the changes required for displaylink URLs.

    And lastly, I have this module on the front page of my vbadvanced that displays the latest links put into the the links directory, but it still shows those links as dynamic urls and not the changes that have affected the links in the link directory?
    Do you mean the link in the dropdown menu? It looks like:
    Code:
    http://www.gamingvidz.com/vidz/showlink.php?l=1071
    So, there must be another showlink.php instance that was not updated with ltitle=X
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  11. #26
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Quote Originally Posted by Oleg Ignatiuk View Post
    Do you mean the link in the dropdown menu? It looks like:
    Code:
    http://www.gamingvidz.com/vidz/showlink.php?l=1071
    So, there must be another showlink.php instance that was not updated with ltitle=X
    Well, actually I was talking about the "Recent Vidz" module on the front page (beneath the log in box).

    But I think you're right. I did have to upload a seperate php file called "hotlinks.php" to help get that module to work on the front page (It takes the newest 5 links in the video directory and displays them there).

    So does that mean I need to go into the php code and add that little string of code that I had to place in the links directory php files to get it to show up?

  12. #27
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Yes, that is correct.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  13. #28
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Ok, if I can't find the right spot to place the code perhaps I could post it here?

  14. #29
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Yes.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  15. #30
    Senior Member
    Real Name
    Chris Guthrie
    Join Date
    Mar 2007
    Posts
    104
    Liked
    0 times
    Ok, I had upgraded GamingVidz to the newest version of vBulletin and upgraded links directory at the same time... unfortunately now that means links directory is not vBSEO'd anymore.

    Do you think the steps I followed before will work the same for vB links directory 2.01?

Page 2 of 3 FirstFirst 1 2 3 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •