Miscellaneous Hacks - DCSEO Linkbacks (Refbacks implementation)

Introduction

Dear Friends,

After much thought I have decided to release part of my upcoming DCSEO modification to the community for free.

What does this modification do?

This modification offers you the facility to track URLs that link to threads on your forum. Instead of me trying to explain to you what a linkback actually is I'll link you to wikipedia's explanation of it: http://en.wikipedia.org/wiki/Linkback

This modification implements refbacks, but not trackbacks or pingbacks (these will be included in the DCSEO modification). Any sites that the system *thinks* link to you, are put into an approval queue in the admincp which you will see in the left-hand nav after you install the mod. This moderation queue can be turned off, but I would strongly reccomend never turning it off!

The reason this will offer you a major benefit to your search engine rankings and PR (for google), is that it will create relevant inbound and outbound traffic to your forum which the search engines love.

Installation

Download the attached zip and open the readme.txt file, and follow the instructions within it.

Support

I will be around to offer support wherever possible, but please do not PM me asking for support, as I will not respond. If you have any bugs, report them in this thread and I'll fix them as soon as possible. I am rather busy at the moment with work during the day, and full-time development of the DCSEO product in the evenings, so please be patient with me if I take a little while responding to your posts.

[Dean C]

Updated to 1.4

This is a bug fix release which fixed the bug in the admincp where you can only moderate one linkback at a time.

Regards,
- Dean (DCSEO Developer)

[DanaRVT]

Woo hoooooo Dean you got it! It lets me moderate them all at once now YAY! Great work!

[Dean C]

Hehe no problem Dana Should have got around to it sooner, but I've been so busy lately!

[dartho]

Originally Posted by ChaosProgrammer

Help!

Mistake I get while trying to import the xml file

Database error in vBulletin 3.6.8:

Invalid SQL:
CREATE TABLE linkback (
`linkbackid` smallint(6) unsigned NOT NULL auto_increment,
`pageurl` varchar(250) collate latin1_general_ci NOT NULL,
`pagetitle` varchar(250) collate latin1_general_ci NOT NULL,
`approved` tinyint(1) NOT NULL default '0',
`type` tinyint(1) unsigned NOT NULL,
`dateline` int(10) unsigned NOT NULL,
`threadid` smallint(6) unsigned NOT NULL,
PRIMARY KEY (`linkbackid`),
KEY `threadid` (`threadid`)
) ENGINE=MyISAM;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'collate latin1_general_ci NOT NULL,
`pagetitle` varchar(250)
Error Number : 1064
Date : Monday, October 8th 2007 @ 11:31:25 AM
Script : http://www.chaosprogramming.com/foru...=productimport
Referrer : http://www.chaosprogramming.com/foru...?do=productadd
IP Address : XXXXX
Username : XXXXX
Classname : vb_database




I have zoints SEO if that helps

It's to do with the "collate latin1_general_ci " part in the
`pageurl` varchar(250) collate latin1_general_ci NOT NULL,
and
`pagetitle` varchar(250) collate latin1_general_ci NOT NULL,
lines.

I had the same error on one site which is hosted on a box with an old version of MySQL. Removing the collate latin1_general_ci in teh product XML and then install allows the process to go through, but I am unsure of any side effects.

[dartho]

I've created a small add-on to this which will display if and how many linkbacks need to be moderated in your AdminCP main page HERE

[BlizzardHQ]

Has anyone tried this with 3.7b?

[dartho]

Yep - seems to work OK, although not heavily tested

[BlizzardHQ]

k, thanks

/clicks install

[Dean C]

Thanks for the feedback guys. Let me know if you have any problems with 3.7 as I haven't tested it on that yet.

[Dean C]

v1.5 released

Added the ability for admins to moderate all backlinks at once again. So now you can select All yes, or all no. Use sparingly and wisely