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]

Can you take a screenshot in the admincp of it for me please ?

[bazzup]

cheers matey installed

[Slave]

Originally Posted by Dean C

Can you take a screenshot in the admincp of it for me please ?

Nothing to see as there isn't anything in the list .. I've declined them as they have appeared

[bazzup]

one question everytime a new post happens on my forum it links back

[Cybertims]

Same here, I get quite a few of the exact same URL and usually it is my own URL.

I think the blacklist would be good also since I run my Forum using multiple domain names, and of course if users enter the site using one of the other domain names they a show as linkbacks.

Cheers.

[Dean C]

Originally Posted by Slave

Nothing to see as there isn't anything in the list .. I've declined them as they have appeared

Well next time it happens, a screenshot would be great mate!

Originally Posted by bazzup

one question everytime a new post happens on my forum it links back

Can you screenshot an example of what is happening?

Originally Posted by Cybertims

Same here, I get quite a few of the exact same URL and usually it is my own URL.

I think the blacklist would be good also since I run my Forum using multiple domain names, and of course if users enter the site using one of the other domain names they a show as linkbacks.

Cheers.

Sure, the blacklist is ready and working. Just need to update the zip when I get home. Did you apply the fix on page 2 for now?

[Cybertims]

Sure, the blacklist is ready and working. Just need to update the zip when I get home. Did you apply the fix on page 2 for now?

I did mate, but that doesnt take care of the other domain names I use....and I still get a few of my own URL's in there, even with the fix.

Cheers.

[clarksta]

tryed to install this but get a db error

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;

any ideas on how to fix this

[Wulfnoth]

If i want to moderare the links i geht the following error in acp.

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

		SELECT l.*,t.title as threadtitle FROM vb3_linkback as l
		LEFT JOIN thread as t ON (t.threadid = l.threadid)
		WHERE l.approved=0
		ORDER BY dateline ASC;

MySQL-Fehler : Table 'd005b5c9.thread' doesn't exist
Fehler-Nr.   : 1146
Datum        : Wednesday, September 5th 2007 @ 11:39:17 AM
Skript       : http://www.example.org/forum/admincp...=viewlinkbacks
Referrer     : http://www.example.org/forum/admincp/index.php?do=nav
IP-Adresse   : ********
Benutzername : ******
Klassenname  : vB_Database_MySQLi

[Dean C]

Originally Posted by Wulfnoth

If i want to moderare the links i geht the following error in acp.

Datenbankfehler in vBulletin 3.6.8:

Invalid SQL:

		SELECT l.*,t.title as threadtitle FROM vb3_linkback as l
		LEFT JOIN thread as t ON (t.threadid = l.threadid)
		WHERE l.approved=0
		ORDER BY dateline ASC;

MySQL-Fehler : Table 'd005b5c9.thread' doesn't exist
Fehler-Nr.   : 1146
Datum        : Wednesday, September 5th 2007 @ 11:39:17 AM
Skript       : http://www.example.org/forum/admincp...=viewlinkbacks
Referrer     : http://www.example.org/forum/admincp/index.php?do=nav
IP-Adresse   : ********
Benutzername : ******
Klassenname  : vB_Database_MySQLi

Yep, bug will be fixed in the new package this evening.