Does vBseo also work with vBadvanced and vBadvanced links directory?

ChrisGuthrie.net · #16 04-15-2007, 09:05 PM

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.

Oleg Ignatiuk · #17 04-15-2007, 09:10 PM

What exactly did the error say?

ChrisGuthrie.net · #18 04-15-2007, 09:19 PM

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?

Oleg Ignatiuk · #19 04-15-2007, 09:26 PM

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.

ChrisGuthrie.net · #20 04-15-2007, 09:27 PM

Ok, I'll go grab the appropriate templates and put them in notepad and try it. Will post back once I've done it.

ChrisGuthrie.net · #21 04-15-2007, 09:37 PM

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

ChrisGuthrie.net · #22 04-15-2007, 10:12 PM

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'

Oleg Ignatiuk · #23 04-16-2007, 12:03 AM

Quote:

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.

Quote:

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).

ChrisGuthrie.net · #24 04-16-2007, 02:07 AM

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.

Oleg Ignatiuk · #25 04-16-2007, 05:57 AM

Quote:

Can I just remove "displaylink" entirely? Or do I still get the SEO advantage?

It will be conflicting with other URLs in this case.

Quote:

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.

Quote:

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

ChrisGuthrie.net · #26 04-17-2007, 06:50 PM

Quote:

Originally Posted by Oleg Ignatiuk

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?

Oleg Ignatiuk · #27 04-17-2007, 07:08 PM

Yes, that is correct.

ChrisGuthrie.net · #28 04-17-2007, 07:57 PM

Ok, if I can't find the right spot to place the code perhaps I could post it here?

Oleg Ignatiuk · #29 04-17-2007, 08:17 PM

Yes.

ChrisGuthrie.net · #30 05-12-2007, 10:01 PM

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?