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.

[Wachtmeister]

Hello,

is it possible, that DCSEO Linkbacks has a problem with the magic number 65535 ?

No new topics work on my site. All the linkbacks to new articles stop at http://www.webgurus-community.com/fo...ad.php?t=65535 but i have threads higher than 65535. I'm above 75.000... So i guess it has something to do with DCSEO Linkbacks.

Regards, Wachtmeister

[tekstylez]

the linkbacks are not showing. either is the dropdown box

[vinboy]

hi
how do I disable the moderation?
I would like the linkback to appear as soon as possible without moderation.

thanks

[Mesohu]

This Mod work in vB 3.7 Gold or not ?

[P@trick]

I tryed it on vB 3.7.1 and i gain an SQL error when i want to import the product:

Datenbankfehler in vBulletin 3.7.1:

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-Fehler : 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)
Fehler-Nr. : 1064
Fehler-Zeit : Saturday, 31.05.2008 @ 16:15:42
Datum : Saturday, 31.05.2008 @ 16:15:43
Skript : http://www.magicinvasion.de/admincp/...=productimport
Referrer : http://www.magicinvasion.de/admincp/...?do=productadd
IP-Adresse : 87.171.215.96
Benutzername : TheMagicWizard
Klassenname : vb_database
MySQL-Version : 4.0.27-max-log

[FD1Stu]

Originally Posted by Deadly Assassin

Installed and seems to work ok.

One thing though

I get this error at the very top of the main forum page, until i refresh then i dissapears.

Warning: substr_count() [function.substr-count]: Empty substring. in /showthread.php(1953) : eval()'d code on line 83

Any ideas? I will leave it install at the moment as it doesnt seem to make any difference to the job its supposed to do.

I'm using 3.6.4

Thanks, great idea mate :up:

I'm getting the same error as this on 3.7, has anyone fixed this yet? Thanks.

[SAT2M]

I have vb 3.7.1 PL1

I have this hack when I has 3.6.8 until now

What I was doing? It work correct now? Must I update it?

[Reminisce32]

why do i get a database error when i try to import the plug in?

Database error in vBulletin 3.6.7:

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;

[crashys]

Originally Posted by Wachtmeister

Hello,

is it possible, that DCSEO Linkbacks has a problem with the magic number 65535 ?

No new topics work on my site. All the linkbacks to new articles stop at http://www.webgurus-community.com/fo...ad.php?t=65535 but i have threads higher than 65535. I'm above 75.000... So i guess it has something to do with DCSEO Linkbacks.

Regards, Wachtmeister

I think it has somewhere a 16 bit value and cant go further.
http://www.bitsplitter.com/forums : 299.000 postings and have the same.
Can that be changed?

Fred.

[LuBi]

Waiting patiently for DCSEO and more on DCSEO Linkbacks working with 3.7.# :up: