Major Additions - Zoints SEO

********Please do not use this modification unless you are VERY well educated on SEO and forum modification********

Zoints is a company that believes that forums are the killer application of the internet. We want to empower forum owners to take their community to the next level. Therefore, Zoints has been developing an extremely powerful vBulletin forum SEO and revenue enhancing solution for more than two years now. However, because we are focusing on our Forum Network and Thread Tagging System, we have decided to release this SEO solution to the vBulletin community under the lgpl license. Zoints SEO is now open source and NOT supported by us. We hope that the vBulletin dev community comes together to take this already powerful solution and make it even better. Empower yourselves

Zoints SEO can be discussed here or http://network.zoints.com (again, we will not be providing official support).


Known bugs

1. If a user disables cookies, infinite redirect loop.
2. index2, index3 pagination breaks some things. Standard p2, p3 works fine.


Zoints SEO is currently incompatible with: POSSIBLE FIX. PLEASE TRY THIS AND REPORT BACK. THANK YOU!
1. Incompatibility with vBA Gallery link.
2. Incompatibility with vBA Links
3. Improper linking from vBA CMPS Recent threads
4. Google Maps
[s]5. Non english characters[/s] - Character replacement is now available.


Without further ado:

[MrLeN]

I installed Zoints SEO, but it started causing conflicts with other software that I am using with the forums and unfortunately, I had to remove it. I came here for instructions how to remove it and I was told to use the uninstall via the product manager and remove the files from the installation.

I did this, but I am still getting database errors in my email. It says:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT linkid, name, links.catid, userid, username, dateline, links.lastpostdateline, title
FROM wgreen_adv_links AS links
LEFT JOIN wgreen_adv_links_categories AS categories USING (catid)
WHERE links.dateline > 1162098001 AND suspended = 0 AND valid = 1;

MySQL Error : Column: 'valid' in where clause is ambiguous
Error Number : 1052
Date : Monday, October 30th 2006 @ 12:59:01 AM
Script : http://www.mysite.com/community/cron.php?rand=801531
Referrer : http://www.mysite.com/community/
IP Address : 211.28.xxx.xxx
Username : Unregistered
Classname : vb_database

How can I repair my vBulletin database to get it working without errors, before the Zoints SEO installation altered it? Or, what did Zoints SEO do to alter my database?

Any advice/direction appreciated.

[rogersnm]

Run every cron job until you find the one that errors. And then tell me which product it is for. It looks like Advanced Navbars.

[Hoffi]

Did you use the vbAdvanced Linkdirectory or something similar?
The Tables are not vBulletin Standard oder ZOINTS related.

[gsm4arab1]

Very wonderful zointsseo-2.2.2 I have installed on the site, but unfortunately became servers Special me very slow and very high

Server Load 4.78 (4 cpus)

Is there a solution to the lack of high Load server

thanks ......................

[Greek76]

Problem with mod rewrite. I added the code to the .htaccess and uploaded it. I click enable mod rewrite. Now when you visit the categories I get the page can not be found what am I doing wrong?

This how I added the code...

Options +FollowSymlinks
RewriteEngine on



RewriteRule ^([a-z0-9_\-]*-(f|all)[0-9]+(p[0-9]+|/index[0-9]*)?\.html)$ forumdisplay.php/$1 [QSA,L]
RewriteRule ^([a-z0-9_\-]*-(t|p)[0-9]+(p[0-9]+|/index[0-9]*)?\.html)$ showthread.php/$1 [QSA,L]
RewriteCond %{REQUEST_URI} !(index\.php|\.css) [NC]
RewriteRule ^(archive|sitemap)/(.*)$ $1/index.php/$2 [QSA,L]

[Ramsesx]

Originally Posted by phlogiston

I'm pretty certain I've figured out why I haven't experienced problems with vBGallery (and other addons) while using Zoints SEO - I have vBa CMPS wrapped around everything and forums in root dir = not standard.


So I worked out a possible fix.
If anyone wants to try this (without guarantee!) to get Zoints SEO working on sites with photopost's vBGallery (may also solve the incompatibility with vBadvanced Links Directory) I'm fairly/quite confident it may work. (I apologise for the vagueness but I don't have good test installs at present )

in the "Zoints SEO" plugin at parse_templates (on line #1),
originally (Zoints SEO v 2.2.2) it should be

PHP Code:

if ($vbulletin->options['zointsseo_on'] AND $vbulletin->options['zointsseo_rewrite_urls'] AND VB_AREA == 'Forum' AND !defined('VBA_PORTAL')) 


change VBA_PORTAL to VBA_SCRIPT,
ie REPLACE line#1 with

PHP Code:

if ($vbulletin->options['zointsseo_on'] AND $vbulletin->options['zointsseo_rewrite_urls'] AND VB_AREA == 'Forum' AND !defined('VBA_SCRIPT')) 


this should prevent the <base href=""> tag being added to the header which I think was the problem.


Again, apologies for the lack of testing of this before offering it as a possible solution.

Seems to work for me, thanks.

[phlogiston]

Originally Posted by Ramsesx

Seems to work for me, thanks.

cool

I've been doing some more prodding at the code to see if it's extendable to rewriting the vBGallery urls, so far it looks doable. Not quite at a usable stage yet,
although www.spoiltcat.com/julian_cope-i1444.html is much prettier than unrewritten www.spoiltcat.com/photos/showimage.php?i=1444 !!

[Zoints]

A vbgooglemap fix?

Those of you who have had trouble with vbgooglemap, please give this fix a shot and see if it works for you and report back. Thanks

[Zoints]

Originally Posted by phlogiston

I'm pretty certain I've figured out why I haven't experienced problems with vBGallery (and other addons) while using Zoints SEO - I have vBa CMPS wrapped around everything and forums in root dir = not standard.

Nice! Can others confirm if this is working for them?

Keep this up and we'll need to create a phlogiston SEO fork

[Floris]

********Please do not use this modification unless you are VERY well educated on SEO and forum modification********


Well, that rules me out I want the plugin to take care of things and not having to educate myself first .. if I am educated on this ..... I didn't need the plugin