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.

[dj_f16]

----------------------------------------------------------------------------------------------------

oky
i add black list but it has long link again.how can i solve this problem?

----------------------------------------------------------------------------------------------------

tamam mı? hocam.. ben ?eviriyorum anlamıyorsun, bulgaristandan 3 adam oturdu ?evirdi şunu, artık anla g?z?n? seviyim...

----------------------------------------------------------------------------------------------------

[Dave-M]

Originally Posted by Dean C

The odd thing about this, is I can't replicate the bug locally. Can those who are experiencing this bug post up what version of PHP you are using, and also the vBulletin version

And at the moment, there is no way to delete refbacks once they are approved. That's coming soon

I'm relieved that its not just me

PHP Version 4.4.7
VB 3.6.8

In the linkbacks, all I did was leave the ones I didn't want to show (or wasn't sure about), on "leave", and the rest I gave the ok to, but they all showed up, so I definitely need to prune before I can use it.

Thanks for the help so far

[Dean C]

Originally Posted by dj_f16

----------------------------------------------------------------------------------------------------

oky
i add black list but it has long link again.how can i solve this problem?

----------------------------------------------------------------------------------------------------

tamam mı? hocam.. ben ?eviriyorum anlamıyorsun, bulgaristandan 3 adam oturdu ?evirdi şunu, artık anla g?z?n? seviyim...

----------------------------------------------------------------------------------------------------

If I understand you correctly, you want to delete existing refbacks. This feature will be coming soon

[Dean C]

Originally Posted by Dave-M

I'm relieved that its not just me

PHP Version 4.4.7
VB 3.6.8

In the linkbacks, all I did was leave the ones I didn't want to show (or wasn't sure about), on "leave", and the rest I gave the ok to, but they all showed up, so I definitely need to prune before I can use it.

Thanks for the help so far

Ah, gotcha. I'll take a look into it this weekend

[Dean C]

v1.3 released

[Dave-M]

Thanks for this mate

Just installed now, but nothing to moderate yet..in fact I havent got the moderation thing in the admincp.

Forums.

Ill link here and see if it works

Edit: yes, it works now

I have a suggestion!

Where you put the delete link in the list of linkbacks, would it be possible to put a tickbox for each one, so that we can just go through the list, tick the ones we want to ditch and then click delte at the bottom of the page maybe?

The reason I ask is because the first thread I've tested it on, is quite a long series of posts, and then a shedload of links, so editing them all will take a long time

thanks!

[Dean C]

Originally Posted by Dave-M

Thanks for this mate

Just installed now, but nothing to moderate yet..in fact I havent got the moderation thing in the admincp.

Forums.

Ill link here and see if it works

Edit: yes, it works now

I have a suggestion!

Where you put the delete link in the list of linkbacks, would it be possible to put a tickbox for each one, so that we can just go through the list, tick the ones we want to ditch and then click delte at the bottom of the page maybe?

The reason I ask is because the first thread I've tested it on, is quite a long series of posts, and then a shedload of links, so editing them all will take a long time

thanks!

Maybe something for the future, it's a good idea for sure

[Dave-M]

Yep, no rush, it was just my list of links frightened me - thanks again for this

[Dean C]

Originally Posted by Dave-M

Yep, no rush, it was just my list of links frightened me - thanks again for this

No problem Dave

[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