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]

OOooO man
thack u very much

[Robert7]

Thanks, it's realy good idea, but your mode can be more developed.

Also there is a problem for me: when I want to moderate more than one linkback at once it doesn't work. It works on the last linkback and nothng happens to others while I have choose to approve or disapprove them...

[fredang85]

we need the links shortened so that it will not go out of screen!

[ChaosProgrammer]

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 : XXXXXX
Username : XXXXX
Classname : vb_database




I have zoints SEO if that helps

Anyone has an idea?

[ragtek]

why have you commented

		print_cells_row(array($vbphrase['dcseo_approve_all_linkbacks'], '<input type="button" class="button" value=" ' . $vbphrase['all_yes'] . ' " onclick="js_check_all_option(this.form, 1)" /> <input type="button" class="button" value=" ' . $vbphrase['all_no'] . ' " onclick="js_check_all_option(this.form, 0)" />'), 1);
		print_table_break();

out?
its very usefull

[Dean C]

Originally Posted by ChaosProgrammer

Anyone has an idea?

Not sure. It works for everyone else.

Originally Posted by ragtek

why have you commented

		print_cells_row(array($vbphrase['dcseo_approve_all_linkbacks'], '<input type="button" class="button" value=" ' . $vbphrase['all_yes'] . ' " onclick="js_check_all_option(this.form, 1)" /> <input type="button" class="button" value=" ' . $vbphrase['all_no'] . ' " onclick="js_check_all_option(this.form, 0)" />'), 1);
		print_table_break();

out?
its very usefull

Because it didn't work correctly originally, so I removed it

[ragtek]

hm strange
for me its working fine

[Dean C]

Originally Posted by ragtek

hm strange
for me its working fine

I'll look into uncommenting it next time around

[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:

[Dean C]

Can you run me through the exact scenario, with URLs that I can test on, so I can try and replicate your problem Deadly Assassin?