vb.org Archive - Miscellaneous Hacks - DCSEO Linkbacks (Refbacks implementation)

Page 1 of 7

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Miscellaneous Hacks - DCSEO Linkbacks (Refbacks implementation) (https://vborg.vbsupport.ru/showthread.php?t=157031)

Dean C

09-03-2007 10:00 PM

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

09-04-2007 06:21 PM

Changelog

v1.5 - Released 24/01/08
- * New: admins can moderate all linkbacks, or delete all linkbacks at once via the admincp.

v1.4 - Released 21/01/08
- Fixed: users could only choose to delete one linkback at a time.

v1.3 - Released 07/10/07
- Fixed: choosing to approve certain linkbacks and leave others in the moderation queue would result in all linkbacks being approved.
* New: admins can delete linkbacks directly from the showthread page

v1.2 - Released: 11/09/07
- Update to v1.1 whereby some code changes didn't make it through to the package.

v1.1 - Released: 05/09/07
- Fixed: users not using the www prefix for your domain would send duplicate linkbacks
- Fixed: SQL error in admincp if you're using a table prefix
- Fixed: PHP errors when trying to get the page titles of certain URLs
- Fixed: Blank linkbacks appearing on showthread page
* New: Added ability to blacklist certain URLs/domains from incoming linkbacks

Dean C

09-04-2007 06:21 PM

FAQs

Nothing is showing in any of my threads
Have you moderated any incoming refbacks in your admincp? If so, then did you approve them? If the answer to both of these questions is yes, then make sure you edited your templates correctly.

There's nothing to be approved in my admincp
Maybe no-one is linking to any of your threads ;) Consider improving your content, or writing some content that people deem worthy of linking to.

TheBlackPoet

09-04-2007 06:39 PM

im testing now... I will be back

Dean C

09-04-2007 06:43 PM

Quote:

Originally Posted by TheBlackPoet (Post 1332353)

im testing now... I will be back

Excellent. Please let me know if it all goes okay. To actually get the linkback to work, you'll have to place a link to one of your threads on a different domain, then click on it to take you to that thread. Then the linkback should appear in your moderation queue in the admincp :) You could always edit your post here and link to one of your threads!

TheBlackPoet

09-04-2007 07:02 PM

it works perfectly.... after i accept the linkback in the ACP.. it shows in that thread that was linked. for my members this will be great to know if other people are linking their work on other sites.. for me.., it will be good so i can know who is doing what!!

thanks.... installed, voted, and nominated..

Dean C

09-04-2007 07:04 PM

Quote:

Originally Posted by TheBlackPoet (Post 1332374)

Many thanks! Your link did raise a query in my head though. Your forums are closed to guests, so perhaps I should disable the logging of refbacks for threads that are not viewable to guests. I'll mull on that overnight and decide in the morning ;)

ragtek

09-04-2007 07:05 PM

yes, my first idee was: wow, must have
but on the other side my site is not visible for the guests, so i don't need it:D

TheBlackPoet

09-04-2007 07:06 PM

no!! keep it..., actually it would be good to know if ANYONE is linking to a my site... that is a good thing..

kaptanblack

09-04-2007 07:14 PM

Thanks.. perfect mod

TheBlackPoet

09-04-2007 07:30 PM

i just thought of something... how feasible would be to have the admin recieve a pm/email when there is something to moderate???

Dean C

09-04-2007 07:36 PM

Quote:

Originally Posted by TheBlackPoet (Post 1332403)

i just thought of something... how feasible would be to have the admin recieve a pm/email when there is something to moderate???

It's possible. But I would not reccomend it. On a large board you may have quite a lot to moderate, which means a lot of emails/pms ;)

Cybertims

09-04-2007 07:37 PM

I am moderating about 10 every 15 mins, dont need any PM's LOL

Is it normal though that linkbacks are usually just my main page URL?

Cheers

Dean C

09-04-2007 07:37 PM

Quote:

Originally Posted by Cybertims (Post 1332409)

I am moderating about 10 every 15 mins, dont need any PM's LOL

Is it normal though that linkbacks are usually just my main page URL?

Cheers

That is not normal. It should filter out any linkbacks from your own domain. Can you link me to an example of where you're getting this problem?

EDIT: ah I know what's causing this. It will only filter out linkbacks from your forums URL, not domain. I'll fix that tonight if I can :) Also I guess it would be useful to have a blacklist of domains/urls that you dont want to be processed as linkbacks.

Dean C

09-04-2007 07:44 PM

Quick fix until I update the zip tomorrow night with a blacklist:

In your 'Process incoming linkbacks' plugin find:

PHP Code:


		
			
if(substr_count($ref, $vbulletin->options['bburl']) == 0 && verify_link($ref))

Replace with:

PHP Code:


		
			
if(substr_count($ref, $vbulletin->options['bburl']) == 0 && substr_count($ref, $vbulletin->options['homeurl']) == 0 && verify_link($ref))

Cybertims

09-04-2007 08:06 PM

Ok mate, did that and I just emptied the linkback table of all the old ones and will keep an eye on things now.

Cheers.

Brandon Sheley

09-04-2007 08:06 PM

Good job Dean :)

Dean C

09-04-2007 08:09 PM

Just realised that people might get a lot of refbacks from search engines too, i've added the 3 big ones to the default blacklist (yahoo, msn, google). I'll release 1.1 tomorrow night with all the fixes in! I did label it as beta ;)

Mecho

09-04-2007 08:41 PM

great mod .. i will install tomorrow night :)

good job Dean :)

already Clicked installed

Hornstar

09-05-2007 02:04 AM

Question: you are developing this new SEO product, dont you think it is time to upgrade your forums from vBulletin Version 3.0.7 to the latest o_O

Dean C

09-05-2007 04:30 AM

Quote:

Originally Posted by hornstar1337 (Post 1332601)

Question: you are developing this new SEO product, dont you think it is time to upgrade your forums from vBulletin Version 3.0.7 to the latest o_O

With all due respect, whatever version I choose to run my forums on, is none of your business :)

Slave

09-05-2007 05:13 AM

Working on a 3.6.0 forum .. thanks :)

Dean C

09-05-2007 05:18 AM

Quote:

Originally Posted by Slave (Post 1332648)

Working on a 3.6.0 forum .. thanks :)

Excellent. Do you have a link to one of your showthread pages with some linkbacks on? I'd like to take a better screenshot today :)

Slave

09-05-2007 05:29 AM

removed

I will in a min :)

Slave

09-05-2007 05:32 AM

That page above has one now .. but why the blank line one min after the correct one?

Slave

09-05-2007 05:42 AM

Ok .. seems like it creates a blank line every time the link above is hit. Even if the linkback is denied the blank line stays.

Could you make it so if a linkback is ok'ed it is then ignored, else you'll start to get a lot of items in the moderated list which you've already ok'ed and you don't need in the linkback list again do you?

Also, could you stick in a delete button for admin against a linkback, in case you change your mind and want to delete a link off the list?

Dean C

09-05-2007 06:05 AM

It should not ask you to process linkbacks if they've already been approved once. This is very odd. I'll try and replicate it when I get home :)

Slave

09-05-2007 06:10 AM

Just to note, it stopped doing it once I'd clicked the link more than about 3 times. It was only when you clicked on the link did it then add another blank line and showed up in the mod list (again) ..

So you might need more than one person clicking the link to see it happen?

Dean C

09-05-2007 06:27 AM

Did it appear in your admincp to be approved more than once then?

Slave

09-05-2007 07:02 AM

Yep .. every blank line I've declined it in the mod list ..

Dean C

09-05-2007 07:05 AM

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

bazzup

09-05-2007 07:40 AM

cheers matey installed

Slave

09-05-2007 07:53 AM

Quote:

Originally Posted by Dean C (Post 1332698)

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

09-05-2007 07:55 AM

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

Cybertims

09-05-2007 07:55 AM

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

09-05-2007 07:59 AM

Quote:

Originally Posted by Slave (Post 1332720)

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!

Quote:

Originally Posted by bazzup (Post 1332721)

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

Can you screenshot an example of what is happening?

Quote:

Originally Posted by Cybertims (Post 1332722)

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

09-05-2007 08:16 AM

Quote:

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

09-05-2007 08:37 AM

tryed to install this but get a db error

Quote:

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

09-05-2007 08:41 AM

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

Code:

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

09-05-2007 08:43 AM

Quote:

Originally Posted by Wulfnoth (Post 1332735)

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

Code:

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.

All times are GMT. The time now is 06:25 PM.

Page 1 of 7

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01432 seconds Memory Usage 1,840KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: