DCSEO Linkbacks (Refbacks implementation)

[Dean C]

Introduction

Dear Friends,

After much thought I have decided to release part of my upcoming DCSEO modification (http://www.teckreviews.com/forum/forumdisplay.php?f=24) 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 (http://www.teckreviews.com/forum/forumdisplay.php?f=24)). 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]

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]

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]

im testing now... I will be back

[Dean C]

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]

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]

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..

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]

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]

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

[kaptanblack]

Thanks.. perfect mod

[TheBlackPoet]

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]

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]

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]

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]

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

In your 'Process incoming linkbacks' plugin find:


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


Replace with:


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

[Cybertims]

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]

Good job Dean :)

[Dean C]

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]

great mod .. i will install tomorrow night :)

good job Dean :)

already Clicked installed

[Hornstar]

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]

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]

Working on a 3.6.0 forum .. thanks :)

[Dean C]

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]

removed

I will in a min :)

[Slave]

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

[Slave]

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]

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]

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]

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

[Slave]

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

[Dean C]

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

[bazzup]

cheers matey installed

[Slave]

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]

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!

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

Can you screenshot an example of what is happening?

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/dcseo.php?do=viewlinkbacks
Referrer : http://www.example.org/forum/admincp/index.php?do=nav
IP-Adresse : ********
Benutzername : ******
Klassenname : vB_Database_MySQLi

[Dean C]

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/dcseo.php?do=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.

[Wulfnoth]

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

[Dean C]

tryed to install this but get a db error


any ideas on how to fix this

Do you have any more information from that screen?

[projectego]

* projectego clicks install :)

[clarksta]

Do you have any more information from that screen?
no thats all i get
ive looked to see if the db has been created which it has
im puzzled my self on this tbh
sreenie for you
http://img530.imageshack.us/img530/2622/errorax7.jpg


MySQL Error : Table 'linkback' already exists Error Number : 1050
Date : Wednesday, September 5th 2007 @ 02:04:29 PM
Script : http://www.*******.co.uk/forums/admincp/plugin.php?do=productimport
Referrer : http://www.*******.co.uk/forums/admincp/plugin.php?do=productadd
IP Address : **.***.**.***
Username : *******
Classname : vB_Database

[Dean C]

no thats all i get
ive looked to see if the db has been created which it has
im puzzled my self on this tbh
sreenie for you
http://img530.imageshack.us/img530/2622/errorax7.jpg

Haha, i need all the text from inside of that textarea. There's an important error message that should be at the bottom :)!

Edit: ah, okay I know the problem. It's because you've tried to install the product twice. Am i right?

[clarksta]

Edit: ah, okay I know the problem. It's because you've tried to install the product twice. Am i right?

lol no this is the first time ive ever tryed to install this but i am going to look and let you know

[Dean C]

lol no this is the first time ive ever tryed to install this but i am going to look and let you know

Have you installed vBSEO before by any chance? Also, can you show me the structure of your linkback table, and tell me what fields it has, and some sample data?

[Slave]

Here you go ..

After having a look in the db I can see why there is more than one entry coming into the mod queue .. however that isn't explaining the extra empty rows in the linkback table at the bottom of the page ..

Perhaps it's getting confused due to the similarity of the URL?

[Dean C]

Here you go ..

Ok .. after having a look in the db I can see why there is more than one entry coming into the mod queue .. however that isn't explaining the extra empty rows in the linkback table at the bottom of the page ..

Perhaps it's getting confused due to the similarity of the URL?

Hmmm, this may present a problem with dynamic URLs. There's nothing I can really do about it other than fix the empty lines appearing.

[clarksta]

no never used vbseo dont want to spend that sort of money out
ive taken a ss of the tables in phpmyadmin
http://img454.imageshack.us/img454/131/tablesdi7.jpg

[Slave]

Hmmm, this may present a problem with dynamic URLs. There's nothing I can really do about it other than fix the empty lines appearing.
That would be a good start .. heh :D .. Thanks :)

[Dean C]

no never used vbseo dont want to spend that sort of money out
ive taken a ss of the tables in phpmyadmin
http://img454.imageshack.us/img454/131/tablesdi7.jpg

Well I have no idea what that table is and why it's there. What other mods have you installed in the past, or do you have running at the moment?

[clarksta]

ok i had to drop the table and install the product again
im going to give this some testing now
thanks for the fast replys

[Dean C]

ok i had to drop the table and install the product again
im going to give this some testing now
thanks for the fast replys

Beware of just dropping tables. That may be in use by something else you are using!

[clarksta]

Beware of just dropping tables. That may be in use by something else you are using!
i did once install a reffering stat mod but it never worked
im thinking that might have created the tebles
ill soon see if anything is wrong :D

[Slave]

Oh .. an idea btw ..

Instead of having the mod queue in the AdminCP .. how about having the option of having the, yet to be moderated links, to show up in the linkback table on the page itself. Of course only usergroups that have the permission to see them would be able to ok/decline the link. This would enable you to 1/ See if the link is already in the list .. and 2/ Enable forum moderators to ok links and not just the admin.

Of course, on very large boards, admin might prefer to do the job themselves, so you would still have the option of doing it from the AdminCP .. but perhaps you need to show them if there is a similar link already listed, perhaps from the same domain?

[Dean C]

Oh .. an idea btw ..

Instead of having the mod queue in the AdminCP .. how about having the option of having the, yet to be moderated links, to show up in the linkback table on the page itself. Of course only usergroups that have the permission to see them would be able to ok/decline the link. This would enable you to 1/ See if the link is already in the list .. and 2/ Enable forum moderators to ok links and not just the admin.

Of course, on very large boards, admin might prefer to do the job themselves, so you would still have the option of doing it from the AdminCP .. but perhaps you need to show them if there is a similar link already listed, perhaps from the same domain?

That isn't really feasible as the links would only ever be moderated when you view a thread. So say for example you had a thread no-one has posted to for a year, but someone linked to it, you'd never realise there was a refback waiting to be moderated.

[Slave]

That isn't really feasible as the links would only ever be moderated when you view a thread. So say for example you had a thread no-one has posted to for a year, but someone linked to it, you'd never realise there was a refback waiting to be moderated.
Which is why I suggested having both ways of doing it .. from the thread and the admincp ..

Just a thought anyway :)

[Dean C]

Which is why I suggested having both ways of doing it .. from the thread and the admincp ..

Just a thought anyway :)

You could do I guess. I'll see :)

[bazzup]

Can you screenshot an example of what is happening?

Here you go screenshot attached, this is happening when people browse the forum or make a new post it adds it to the moderation queue


regards

[Slave]

Here you go screenshot attached, this is happening when people browse the forum or make a new post it adds it to the moderation queue


regards
Something to do with not having www. at the front of those URLs maybe?

[bazzup]

Something to do with not having www. at the front of those URLs maybe?

Your right in my browser I had http://fone.........

and it added it all to the moderation queue


i changed it to http://www.fone........

and it stopped why would that be?


regards

[Dean C]

Your right in my browser I had http://fone.........

and it added it all to the moderation queue


i changed it to http://www.fone........

and it stopped why would that be?


regards

Don't worry about it, will be fixed tonight :) Just disable the product for now.

[gforce75]

Nice!

[bazzup]

Don't worry about it, will be fixed tonight :) Just disable the product for now.

nah its ok if i have www typed in my browser (just being lazy not typing the whole thing)works just fine, its just when i dont lol


regards

[Dean C]

nah its ok if i have www typed in my browser (just being lazy not typing the whole thing)works just fine, its just when i dont lol


regards

Yeah I already know what the problem is and how to fix it. Just can't do anything til I get back from work :)

[bazzup]

Yeah I already know what the problem is and how to fix it. Just can't do anything til I get back from work :)

cool i'll look for an update tonight sometime ;)

[ericgtr]

Nice mod here Dean! Just a couple of issues, one is that I am getting a ton from google is that something you are working on omitting? The other is that I said no to all on approve refback but they won't go away. It just takes me to the successfully moderated and then back with all the links still there.

Edit: I see what it's doing, it removes them one at a time even though I selected No to all. Then when I click Go at the bottom it only removes one, then Go again removes the next one, etc.

[Dean C]

Nice mod here Dean! Just a couple of issues, one is that I am getting a ton from google is that something you are working on omitting? The other is that I said no to all on approve refback but they won't go away. It just takes me to the successfully moderated and then back with all the links still there.

Edit: I see what it's doing, it removes them one at a time even though I selected No to all. Then when I click Go at the bottom it only removes one, then Go again removes the next one, etc.

Hi eric :)

Just as I'm about to release the update, you go and find another bug for me ;) I'll go off and fix it now and release 1.1. And yes, a blacklist feature is being added which includes google/yahoo/msn by default and you can add anything else you want to it

[ericgtr]

haha, I am usually the bringer of bugs! I always love your work man, thanks for making this available to us. I will keep an eye out for the update.

[Dean C]

I couldn't replicate your bug eric. Nevertheless, upgrade to v1.1 which is now released :)!

Upgrade instructions:
- Reupload all the files
- Reimport the product

[clarksta]

thanks for the fast update

[Mecho]

would u plz tell me why u suggest us that we u recommend that we never turning moderation queue off ???

and plz explain how we can turn it off ?

thanks

[Cybertims]

Since upgrading I cant tell you whether it's working since I haven't had a single linkback show up now in the admincp LOL

Can someone try clicking here http://www.MonTheHoops.co.uk

Cheers.

[Dean C]

would u plz tell me why u suggest us that we u recommend that we never turning moderation queue off ???

and plz explain how we can turn it off ?

thanks

Simply, don't turn it off. Else I could link to your threads off one of my many hypothetical spam sites, and spam my URL on all your threads :)

[Dean C]

Since upgrading I cant tell you whether it's working since I haven't had a single linkback show up now in the admincp LOL

Can someone try clicking here http://www.MonTheHoops.co.uk

Cheers.

That won't work, you have to link to a thread..

[Mecho]

Simply, don't turn it off. Else I could link to your threads off one of my many hypothetical spam sites, and spam my URL on all your threads :)


yea got ya :) i came to edit my post and add the second question but u answered so fast :D

would u plz tell me why google and yahoo or msn is in blacklist by default ?!!??! it doesnt effected if we have their links back in that showthread ?? or what ?

thanks

[Cybertims]

That won't work, you have to link to a thread..


ok...

http://www.monthehoops.co.uk/showthread.php?p=138336#post138336

Cheers

[Cybertims]

works like a charm now...cool.

Many Thanks and voted !!

[Dean C]

yea got ya :) i came to edit my post and add the second question but u answered so fast :D

would u plz tell me why google and yahoo or msn is in blacklist by default ?!!??! it doesnt effected if we have their links back in that showthread ?? or what ?

thanks

Yes, because search engines have an index of every single thread on your forum. It's of no benefit to you, to link to the exact search page that the user used to click on to reach that thread. The idea behind this modification is to create relevant outbound links to content that links to you. This is the kind of thing that search engines love!

[Dean C]

works like a charm now...cool.

Many Thanks and voted !!

Glad to see it's working okay for you :) Please let me know if you encounter any problems!

[ericgtr]

All works now, including the "no to all". This thing is slicker than a safeway chicken! Thanks Dean.

[Mecho]

ok Great .. thanks for answer my questions :)

btw i forgot to say that it works perfect and without a single problem in vb 3.6.8 :)

Cheers ;)

[Dean C]

All works now, including the "no to all". This thing is slicker than a safeway chicken! Thanks Dean.

It's called morrisons now! Oh wait, you're from US. You won't have a clue what i'm talking about lol. English folks will know what I mean ;)

[ericgtr]

It's strange but now it's back to doing it one at a time again, no biggie though all you have to do is just click Go every time it reloads until they are gone. Does the blacklist take wildcards? For example Google has sites in a ton of countries (see here for example http://c.asselin.free.fr/french/googleworldwide.htm ) and it would be cool to exclude them all if possible.

Yeah after I wrote that I realized they probably don't have a Safeway in the UK but I bet they still have lots of slimy chickens just like we do in the US. ;)

[Dean C]

I did think about adding wildcard support. It wouldn't be hard. For now just imagine that there's a wildcard inserted before and after each thing you type in the box ;) You can put anything you like there btw, but be very careful that you don't filter out good results!

[Cybertims]

Yeah, if you have multiple linkbacks to mod, if you click yes to all, it will only remove one at a time, it keeps reloading and waiting for a click to remove another one, till they are all gone.

[kaptanblack]

installed.

[ericgtr]

I did think about adding wildcard support. It wouldn't be hard. For now just imagine that there's a wildcard inserted before and after each thing you type in the box ;) You can put anything you like there btw, but be very careful that you don't filter out good results!
For now I have turned it off, just because I am getting about 20 different google countries an hour and there are way too many for me to decifer and add one at a time. Still have it installed though, looking forward to this update. :)

[Slave]

1.1 now installed .. thanks for the update and I'll let you know if I find any problems.

Before I did the update I too also saw the "moderate one at a time" issue btw ..

[Dean C]

For now I have turned it off, just because I am getting about 20 different google countries an hour and there are way too many for me to decifer and add one at a time. Still have it installed though, looking forward to this update. :)

You could just add "google." to the blacklist. The problem with allowing wildcards, is that the way this works, wildcards automatically added at the beginning and end of every item. So if i started giving people the ability to wildcard domains like google, they'd type "google.*" right? Well by typing "google." in the box anyway, you'd do exactly the same. I might add wildcard/regex support tonight, and let people risk ++++ing things up at their own risk ;)

[Mecho]

today when i woke up i saw many links waiting for moderate .. a huge list . when i want to moderate them and approve server goes down :D what shall i do ???

thank u

[Dean C]

You're saying it crashes your server moderating the links? What error message does it give? Can you take a screenshot? I will be splitting up the moderation of links on to pages, so that'll take the load off if you have 1000s ;)

[Mecho]

I will be splitting up the moderation of links on to pages, so that'll take the load off if you have 1000s ;)

yea great idea . if u can make a system like Send Email system in vb that would be great . Automatic system will approve all links ( 10 by 10 or N by N ) . so u dont need to check all to yes in page then save then again do that in new page(s) . what u think ?

there is no error message that i can show u any screenshot . but after about 4 or 5 minutes the dcseo.PHP file comes for download and still none of those links approved

[Dean C]

It asks you to download the file O_O. That's baffling. Seems more like a server issue than an issue with my code, but I'll look into it.

[ericgtr]

Thanks for the info Dean, I didn't realize I could just use google without the .com, it appears to be working now.

On the the next issue (I am happy to help test this out though) it appears that some of the google's got through even though I thought I said no to all of them, no big deal though. The thing is my display has empty cells in the thread. Here's a screenshot.

[Dean C]

It doesn't look like you are using the latest code from the plugin. Can you PM me the contents of the "Process incoming links" plugin please :)

[Mecho]

It asks you to download the file O_O. That's baffling. Seems more like a server issue than an issue with my code, but I'll look into it.

i think it s timeout error from server . but i think the reason is the approving the huge list .

[Dean C]

Hmm to those getting the bug with blank listings on showthread, it seems that fix didn't make it into the zip. Will issue an update later :)

[PeteBlume]

Thanks for the info Dean, I didn't realize I could just use google without the .com, it appears to be working now.

On the the next issue (I am happy to help test this out though) it appears that some of the google's got through even though I thought I said no to all of them, no big deal though. The thing is my display has empty cells in the thread. Here's a screenshot.

I've even installed this plugin and have the same problems. Is there any fix?

Greetings

[Dean C]

Yep, the latest code didn't make it into the zip file for displaying linkbacks on the showthread page. I'm not very well this weekend, so please be patient with me :)

[Dean C]

v1.2 uploaded :)

[ericgtr]

v1.2 uploaded :)
I just updated, removed and reinstalled all of it. I will report my findings. Thanks for the update.

One thing I did notice about the prior version is that if I had several and selected Yes to only one and No to all the others, it would process them all at one time. Just though I would point that out. :)

[Dean C]

I just updated, removed and reinstalled all of it. I will report my findings. Thanks for the update.

One thing I did notice about the prior version is that if I had several and selected Yes to only one and No to all the others, it would process them all at one time. Just though I would point that out. :)

Ah of course. Will see if I can fix that tonight. I'm trying to implement pingbacks in the commercial product at the moment :)

[DanaRVT]

Hmmm, installed new product and within minutes had tons of linkbacks to moderate, however all coming from my own domain.. where can I set the blacklist? Also even though I had all set to No, it made me process each one separately.

[Dean C]

Hmmm, installed new product and within minutes had tons of linkbacks to moderate, however all coming from my own domain.. where can I set the blacklist? Also even though I had all set to No, it made me process each one separately.

The blacklist is set in the options section of the admincp. Is your domain URL different from your forums?

[Dean C]

I've updated the zip again with a new admincp file. I've removed the All Yes and All No options for now, and added a new option called "Leave", which won't approve/not approve the linkbacks. Just upload the latest version of dcseo.php tp the admincp folder, if you installed the initial version of 1.2 :)

[Mecho]

and what happen if we select Leave ?

[ericgtr]

Dean, just a thought here but since you already have the cpnav_dcseolinkbacks.xml in the left menu in the admin cp, why not add the DCSEO Linkback Settings to that? It would be easier to have all the settings in that location. :)

[Dean C]

and what happen if we select Leave ?

It leaves it in the moderation queue.

Dean, just a thought here but since you already have the cpnav_dcseolinkbacks.xml in the left menu in the admin cp, why not add the DCSEO Linkback Settings to that? It would be easier to have all the settings in that location. :)

Could do, I'll see if I can whip something up. XMLRPC is driving me nuts at the moment :)

[nnjj.net]

does this working for 3.6.8?

[Masiello]

Hey Dean, I'll waiting for your DC SEO release, I'm so excited =)

[Alibass]

See msg #114

[Alibass]

I got it installed and working fine, voted and thanks for sharing. :)

[rayw]

Installed and appears to be working fine. Thanks! :)

[Dean C]

does this working for 3.6.8?

Yes it does.

[Dean C]

Does anyone have a sample thread with quite a few refbacks, that I can link to in my first post to show folk what it looks like in action :)?

[nnjj.net]

I have install it but nothing happen!

[Dean C]

I have install it but nothing happen!

Maybe no-one is linking to your content :)

[Alibass]

@Dean

Your hack is working great, but have a question. I was approving and disapproving refbacks this morning and one of the search engine got approved. How do you delete those from being displayed at bottom of forum?

[Alibass]

Can someone tell me where the linkback file is located so I can edit and delete what links I need to? Any help or info would greatly be appreciated. :)

[Wachtmeister]

Nice add-on :) Installed and working (http://www.webgurus.de/forum/showthread.php?t=885)...

[Wachtmeister]

Here you go ..

After having a look in the db I can see why there is more than one entry coming into the mod queue .. however that isn't explaining the extra empty rows in the linkback table at the bottom of the page ..

Perhaps it's getting confused due to the similarity of the URL?

Nice add-on :) Installed and working (http://www.webgurus.de/forum/showthread.php?t=885)...

Hmm, not working ;) I cannot see a moderation queue in my admin-cp.

What can i do to view the refback list? Test2 (http://www.webgurus.de/forum/showpost.php?p=433477&postcount=5)

EDIT: Ok, now i have a "Moderate Linkbacks" :) But no Refback from this thread.... Test3 ... ok, got it :) Great work! Really
(http://www.webgurus.de/forum/showthread.php?t=2397)

[ForosAbiertos]

At install i have this 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;

MySQL Error : Table 'linkback' already exists
Error Number : 1050
Date : Tuesday, October 2nd 2007 @ 01:05:09 PM
Script : http://forosabiertos.com/admin/plugin.php?do=productimport
Referrer : http://forosabiertos.com/admin/plugin.php?do=productadd
IP Address : *****
Username : ***
Classname : vB_Database

some help please

[Dave-M]

I have a question.

I have installed as per the instructions, and I can see it in my admincp, but I dont see anything on the forums.

I know that there are quite a lot of links to my forums, so I was wondering if this is because I'm using a custom skin (http://www.extremepixels.com/forum/index.php?styleid=64)?

My forum can be found here (http://www.clunk.org.uk/forums/index.php).

Thanks :)

[tanand79]

I had installed this in my board but i dont see what u had shown in the screenshots..

www.desibbrg.com is my board.
Pls advise what i should do... I also did the template edits in the showthread....

[Alibass]

Apparently there is a bug with 1.2 version. Say you get 4-5 linkbacks and you only want to approve one. You tick yes to the one and the others are left ticked to leave, it doesn't matter it still approves all links and post them in the threads including search engine links. Are you aware of this and are you working on a fix?

I ask several days ago where you can edit and delete the links and still no reply. This hack is supported isn't it?

[Dean C]

@Dean

Your hack is working great, but have a question. I was approving and disapproving refbacks this morning and one of the search engine got approved. How do you delete those from being displayed at bottom of forum?

I'll be adding that feature for admins soon :p

[Dean C]

At install i have this error


some help please

Have you installed Zoints SEO before?

[Dean C]

I have a question.

I have installed as per the instructions, and I can see it in my admincp, but I dont see anything on the forums.

I know that there are quite a lot of links to my forums, so I was wondering if this is because I'm using a custom skin (http://www.extremepixels.com/forum/index.php?styleid=64)?

My forum can be found here (http://www.clunk.org.uk/forums/index.php).

Thanks :)

It shouldn't be. Have you approved any links thus far?

[Dean C]

I had installed this in my board but i dont see what u had shown in the screenshots..

www.desibbrg.com is my board.
Pls advise what i should do... I also did the template edits in the showthread....

Until someone links to one of your threads, and you approve their refback in your admincp, nothing will show :)

[Dean C]

Apparently there is a bug with 1.2 version. Say you get 4-5 linkbacks and you only want to approve one. You tick yes to the one and the others are left ticked to leave, it doesn't matter it still approves all links and post them in the threads including search engine links. Are you aware of this and are you working on a fix?

I ask several days ago where you can edit and delete the links and still no reply. This hack is supported isn't it?

Are you using the latest version? You should not get any search engine links at all. Have you edited the blacklist in your admincp? I will be adding the ability to delete refbacks, but not edit them.

[dj_f16]

links very long is becoming.. pages are spoiling... how do we shorten not can the them...

exp:
http://www.google.it/search?q=$INFO%5B%27premium_act%27%5D+%3D+%271%27; +//You+should+change+this+number+according+to+the+acc ount&ie=UTF-8&oe=UTF-8
http://www.google.it/search?q=$INFO%5B%27premium_a...........

.etc

[Dean C]

links very long is becoming.. pages are spoiling... how do we shorten not can the them...

exp:
http://www.google.it/search?q=$INFO%5B%27premium_act%27%5D+%3D+%271%27; +//You+should+change+this+number+according+to+the+acc ount&ie=UTF-8&oe=UTF-8
http://www.google.it/search?q=$INFO%5B%27premium_a...........

.etc

Add google.it to your blacklist in the vBulletin options section of the admincp :)

[Alibass]

Are you using the latest version? You should not get any search engine links at all. Have you edited the blacklist in your admincp? I will be adding the ability to delete refbacks, but not edit them.

Apparently there is a bug with 1.2 version. Say you get 4-5 linkbacks and you only want to approve one. You tick yes to the one and the others are left ticked to leave, it doesn't matter it still approves all links and post them in the threads including search engine links. Are you aware of this and are you working on a fix?

Dean unless you have another version other than 1.2, I am running the latest. Are you suppose to goto the blacklist and add the search engine each time before you approve your legit forum links? I wouldn't think you should half to do that if hack is working properly. You should be able to approve the links you want and then remove the ones you don't want afterwards, but if I approve one they all get approved.

So now if I have search engines in the mix with forum links I deny them all or I will end up with refback links to the search engine on my forums. :mad:

[Dave-M]

It shouldn't be. Have you approved any links thus far?

No mate, I have no activity whatsoever. I can see the plugin is installed, I have been back over everything several times, reinstalled, re-uploaded etc, still not had anything to approve.

If you need any more details, just say the word :)

[Dean C]

Dean unless you have another version other than 1.2, I am running the latest. Are you suppose to goto the blacklist and add the search engine each time before you approve your legit forum links? I wouldn't think you should half to do that if hack is working properly. You should be able to approve the links you want and then remove the ones you don't want afterwards, but if I approve one they all get approved.

So now if I have search engines in the mix with forum links I deny them all or I will end up with refback links to the search engine on my forums. :mad:

No, you add anything to the blacklist once, and all future refbacks that match will not be approved.

[Dean C]

No mate, I have no activity whatsoever. I can see the plugin is installed, I have been back over everything several times, reinstalled, re-uploaded etc, still not had anything to approve.

If you need any more details, just say the word :)

Link to one of your threads here, then click on it. You should get a refback in your admincp :)

[Alibass]

No, you add anything to the blacklist once, and all future refbacks that match will not be approved.

Does your program work with wild cards? If not you know google has a wad of serach engine like google.it, google.uk, google.nl etc. Adding just google.com doesn't stop them all, you half to add each individual one.

Another for instance, yesterday I had four refbacks to approve for the same website and thread. I tick yes to one and left the other three to leave and all four where approved and added to the bottom of my forum. :confused: What's up with that? Seems to me only the one should have been approved and the the other three left.

[dj_f16]

know....blacklist long reaches if I affect linkler other..
You shorten does it not have a road?

[Dean C]

Does your program work with wild cards? If not you know google has a wad of serach engine like google.it, google.uk, google.nl etc. Adding just google.com doesn't stop them all, you half to add each individual one.

Another for instance, yesterday I had four refbacks to approve for the same website and thread. I tick yes to one and left the other three to leave and all four where approved and added to the bottom of my forum. :confused: What's up with that? Seems to me only the one should have been approved and the the other three left.

I'm going to look into that bug this weekend if I get a chance. Regarding wildcards, it would be very easy to add. At the moment, it just searches for the URL for that string, so if you want to filter out all google domains, use "google." in the blacklist. Unfortunately if you have a url that also happens to contain the string google. it'll block that too. I'll consider possibly blocking search engine refbacks in a different way i.e. regex's hardcoded somewhere: google\.(it|com) etc...

[Dean C]

know....blacklist long reaches if I affect linkler other..
You shorten does it not have a road?

Sorry I don't understand

[Dave-M]

Link to one of your threads here, then click on it. You should get a refback in your admincp :)

Here (http://www.clunk.org.uk/forums/showthread.php?t=68) is a thread from the forums.

Aha, the moderate linkbacks has appeared, and that wasnt there before, now I have a bazillion to moderate :)

Thanks for the help!

[Dave-M]

Ok, I went through the linkbacks that needed moderating, and chose the ones I wanted, but they all showed up on the page.

Is there any way to prune them once they are approved?

Thanks :)

[dj_f16]

i understand ı know it
there is a long links except black list
there isnt a way to solve thıs problem

[Dean C]

Ok, I went through the linkbacks that needed moderating, and chose the ones I wanted, but they all showed up on the page.

Is there any way to prune them once they are approved?

Thanks :)

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

[Dean C]

i understand ı know it
there is a long links except black list
there isnt a way to solve thıs problem

Sorry, I still don't understand what you are saying.

[dj_f16]

u do not understand the nay....

me say ;

which blacklist does not become URLs long.........

solve the long URLs problem do you not know?
-------------------------------------------------------------------------------------
Beyler Biri Çevirsin Şuna... Karalistede Olmayan Linklerde Uzun.. Çıkan Tüm Linklerimi Kara Listeye Ekleyelim.. Mantıksız... Yokmu Bu Uzun Linkleri Kısaltmanın Yolu????? Bunu Derseniz Sevinirim...

[Dean C]

If someone who speaks Turkish could better translate dj_f16's post for me, I'd appreciate it :)

[Alibass]

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


vB 3.6.8

PHP 4.4.4

[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... :) :D

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

[Dave-M]

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]

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

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... :) :D

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

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

[Dean C]

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. (http://www.clunk.org.uk/forums/index.php)

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]

Thanks for this mate :)

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

Forums. (http://www.clunk.org.uk/forums/index.php)

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]

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

No problem Dave :)

[ChaosProgrammer]

Help! :D

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/forum/admincp/plugin.php?do=productimport
Referrer : http://www.chaosprogramming.com/forum/admincp/plugin.php?do=productadd
IP Address : XXXXX
Username : XXXXX
Classname : vb_database




I have zoints SEO if that helps

[dj_f16]

OOooO man :)
thack u very much :D :D :D

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

[ChaosProgrammer]

Help! :D

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/forum/admincp/plugin.php?do=productimport
Referrer : http://www.chaosprogramming.com/forum/admincp/plugin.php?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]

Anyone has an idea?

Not sure. It works for everyone else.

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]

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?

[buurman]

Installed and works fine!!
Thanks for the nice Mod....

Dont really get why google will love them so much.. but will give it a try... :D

[Deadly Assassin]

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?

Well, i just put a link on another site, i used my wifes site.

Then clicked the link.

Went to main forum page and string was showing at the top of the page.

I refreshed and it had gone.

Went to ACP, and the linkback was in there for me to moderate a it should be

Thats it mate :confused:

Thanks:up:

[Dean C]

I'll look into it :)

[Alibass]

Sorry **uninstalled** today.

I installed vBSEO 3.0 today and there is a conflict with the program and this hack. Causes showthreads to crash.

[Barakat]

some hacks have the same table of this hack ....

i wish that u can rename the table so as to have no conflict with other hacks ... thanks and install

[fredang85]

The thing i face is this:

I choose "No" for everything that i don't want, yes for everything i want.

but those i didin't want came up.

So I cleared my database for refback(Because delete button doesn't work!)
and redo my moderation

this time i put "leave" for stuff i didin't want, and same thing, it too appeared.

So whats the problem?

Yea, my delete button doesn't work. It goes to my not found page, which i have set in the htaccess.

How? :D

Thanks.

[cedars]

I have version 1.3 installed and I am still getting linkbacks to my own forum and the links are without the www prefix .

[Dean C]

The thing i face is this:

I choose "No" for everything that i don't want, yes for everything i want.

but those i didin't want came up.

So I cleared my database for refback(Because delete button doesn't work!)
and redo my moderation

this time i put "leave" for stuff i didin't want, and same thing, it too appeared.

So whats the problem?

Yea, my delete button doesn't work. It goes to my not found page, which i have set in the htaccess.

How? :D

Thanks.

Upload the files the installation instructions tell you to.

[Dean C]

I have version 1.3 installed and I am still getting linkbacks to my own forum and the links are without the www prefix .

Can I have a link to your forum, and a link to an example thread where you're getting the refback problem please :)

[bada_bing]

Can someone tell me if this will work with vb 3.5.3 ?

[Dean C]

Can someone tell me if this will work with vb 3.5.3 ?

I can't confirm it, but you should upgrade to the latest version anwyay. It contains bugfixes and security fixes.

[GNeRaL]

Thank you, great..

[Wachtmeister]

I think i have a problem with this.

I can only disapprove one link at a time. When i check all linkbacks and tell to delete them all, just one is deleted. Just the first one.

When approving more links it works fine. Just disapproving does not work.

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

Has this been fixed yet?

[Dean C]

I think i have a problem with this.

I can only disapprove one link at a time. When i check all linkbacks and tell to delete them all, just one is deleted. Just the first one.

When approving more links it works fine. Just disapproving does not work.

Are you running the latest version? This issue was fixed a long time ago.

[joiner42]

works ok for me

[joiner42]

<a href="http://www.steamengines.org.uk/steam" target="_blank">www.steamengines.org.uk/steam</a>

[Wachtmeister]

Are you running the latest version? This issue was fixed a long time ago.

Hello Dean, yes i run 1.3. Sorry...

[Beermonster]

I can only seem to moderate 1 link at a time, if I choose more than 1 they don't get removed, also would it possible to add a "select all" option?

cool hack btw :)

[Rob1986]

installed,thanks.

[Dean C]

Updated to 1.4

This is a bug fix release which fixed the bug in the admincp where you can only moderate one linkback at a time.

Regards,
- Dean (DCSEO Developer (http://www.teckreviews.com/forum/forumdisplay.php?f=24))

[DanaRVT]

Woo hoooooo Dean you got it! It lets me moderate them all at once now YAY! Great work!

[Dean C]

Hehe no problem Dana ;) Should have got around to it sooner, but I've been so busy lately!

[dartho]

Help! :D

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/forum/admincp/plugin.php?do=productimport
Referrer : http://www.chaosprogramming.com/forum/admincp/plugin.php?do=productadd
IP Address : XXXXX
Username : XXXXX
Classname : vb_database




I have zoints SEO if that helps

It's to do with the "collate latin1_general_ci " part in the
`pageurl` varchar(250) collate latin1_general_ci NOT NULL,
and
`pagetitle` varchar(250) collate latin1_general_ci NOT NULL,
lines.

I had the same error on one site which is hosted on a box with an old version of MySQL. Removing the collate latin1_general_ci in teh product XML and then install allows the process to go through, but I am unsure of any side effects.

[dartho]

I've created a small add-on to this which will display if and how many linkbacks need to be moderated in your AdminCP main page HERE

[BlizzardHQ]

Has anyone tried this with 3.7b?

[dartho]

Yep - seems to work OK, although not heavily tested

[BlizzardHQ]

k, thanks

/clicks install

[Dean C]

Thanks for the feedback guys. Let me know if you have any problems with 3.7 as I haven't tested it on that yet.

[Dean C]

v1.5 released

Added the ability for admins to moderate all backlinks at once again. So now you can select All yes, or all no. Use sparingly and wisely ;)

[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/forum/showthread.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/plugin.php?do=productimport
Referrer : http://www.magicinvasion.de/admincp/plugin.php?do=productadd
IP-Adresse : 87.171.215.96
Benutzername : TheMagicWizard
Klassenname : vb_database
MySQL-Version : 4.0.27-max-log

[FD1Stu]

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]

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/forum/showthread.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:

[SAT2M]

Hello
I want to remove this hack but I cant & shown this database error why?

.................
Database error in vBulletin 3.7.2:

Invalid SQL:
DROP table linkback;

MySQL Error : Unknown table 'linkback'
Error Number : 1051
Request Date : Wednesday, August 20th 2008 @ 04:36:10 PM
Error Date : Wednesday, August 20th 2008 @ 04:36:10 PM
Script : http://www.***.com/admincp/plugin.php?do=productkill
Referrer : http://www.***.com/admincp/plugin.php?do=productdelete&productid=dcseolinkbacks&s=
IP Address : 206.222.**.**
Username : MEHDI
Classname : vB_Database
MySQL Version : 5.0.51a-community
.................................

[LuBi]

Hello
I want to remove this hack but I cant & shown this database error why?

Do you have any other SEO products installed? I saw someone who had a similar issue and they had vBSEO installed as well.

[SAT2M]

Do you have any other SEO products installed? I saw someone who had a similar issue and they had vBSEO installed as well.


Yes I have vbseo installed but it is diffrence with DCSEO linkback & I want to unistall it

How can I do this?

[puertoblack2003]

works great on 3.7.3

[TFEX]

Marked as installed. Still testing.

Test link: http://www.thefreebieexchange.com/forums/showthread.php?t=41

:)

[Mesohu]

It doesn't work on vB 3.7.4.

Can you update it for vB 3.7 ?
And why google , yahoo & msn are in the Linkbacks blacklist.

Thank you.

[Mesohu]

The coder is alive or not ?!

[LuBi]

Yes I have vbseo installed but it is diffrence with DCSEO linkback & I want to unistall it

How can I do this?

No idea sorry.. I disabled it but get the same error as you when I try to uninstall. I'll try and look into this weekend as I'd like to clean up my ACP.

[Mesohu]

The coder is alive or not ?!
I'm waiting :confused: :o

[yjmalmsteen]

test1..is it ok? (http://www.kuzeykalesi.com/forum/showthread.php?t=2304)
http://www.kuzeykalesi.com/forum/showthread.php?t=2304

[yjmalmsteen]

If someone who speaks Turkish could better translate dj_f16's post for me, I'd appreciate it :)
He said ; Are there any way to make shorter these refback links?

:)

[Dean C]

It doesn't work on vB 3.7.4.

Can you update it for vB 3.7 ?
And why google , yahoo & msn are in the Linkbacks blacklist.

Thank you.

Because they are not true linkbacks. Search engine results are a different category of link, that hold no PR.

[turbosatan]

Because they are not true linkbacks. Search engine results are a different category of link, that hold no PR.

can i add google.* as a wildcard or do i ave to add each individual google site one at a time?

[Dean C]

can i add google.* as a wildcard or do i ave to add each individual google site one at a time?

No, you can't use wildcards in there. It's just a substring check.

[Sym0n]

Working perfectly for me on 3.7.4PL1 :D

My only gripe would be that I'd like to have the option to either auto approval linkbacks or setup a whitelist for sites that I know often link to our content.

If that could be implemented it would be uber.

Thanks

Sy

[Sym0n]

In case anyone is after the full official list of google.tld then you can get them all here (http://www.google.com/supported_domains).

You'll need to strip the full stops and change the spaces to a line break, but you can do that easily in Word.

Hope it helps.

Sy

[turbosatan]

all google domains formatted ready to use.

google.com
google.ad
google.ae
google.com.af
google.com.ag
google.com.ai
google.am
google.it.ao
google.com.ar
google.as
google.at
google.com.au
google.az
google.ba
google.com.bd
google.be
google.bg
google.com.bh
google.bi
google.com.bn
google.com.bo
google.com.br
google.bs
google.co.bw
google.com.by
google.com.bz
google.ca
google.cd
google.cg
google.ch
google.ci
google.co.ck
google.cl
google.cn
google.com.co
google.co.cr
google.com.cu
google.cz
google.de
google.dj
google.dk
google.dm
google.com.do
google.dz
google.com.ec
google.ee
google.com.eg
google.es
google.com.et
google.fi
google.com.fj
google.fm
google.fr
google.ge
google.gg
google.com.gh
google.com.gi
google.gl
google.gm
google.gp
google.gr
google.com.gt
google.gy
google.com.hk
google.hn
google.hr
google.ht
google.hu
google.co.id
google.ie
google.co.il
google.im
google.co.in
google.is
google.it
google.je
google.com.jm
google.jo
google.co.jp
google.co.ke
google.com.kh
google.ki
google.kg
google.co.kr
google.com.kw
google.kz
google.la
google.li
google.lk
google.co.ls
google.lt
google.lu
google.lv
google.com.ly
google.co.ma
google.md
google.me
google.mn
google.ms
google.com.mt
google.mu
google.mv
google.mw
google.com.mx
google.com.my
google.co.mz
google.com.na
google.com.nf
google.com.ng
google.com.ni
google.nl
google.no
google.com.np
google.nr
google.nu
google.co.nz
google.com.om
google.com.pa
google.com.pe
google.com.ph
google.com.pk
google.pl
google.pn
google.com.pr
google.pt
google.com.py
google.com.qa
google.ro
google.ru
google.rw
google.com.sa
google.com.sb
google.sc
google.se
google.com.sg
google.sh
google.si
google.sk
google.com.sl
google.sn
google.sm
google.st
google.com.sv
google.co.th
google.com.tj
google.tk
google.tl
google.tm
google.to
google.com.tr
google.tt
google.com.tw
google.co.tz
google.com.ua
google.co.ug
google.co.uk
google.com.uy
google.co.uz
google.com.vc
google.co.ve
google.vg
google.co.vi
google.com.vn
google.vu
google.ws
google.rs
google.co.za
google.co.zm
google.co.zw
google.cat

[cjwinternet]

Thanks for the edited list turbosatan.

I have approved linkbacks to a site I no longer want to link to. I don't know what threads were linked to this domain.

Is there anyway I can search and delete the linkbacks?

[cjwinternet]

I just approved a whole load of linkbacks by accident, most of them are junk, and I normally only approve good ones. Is there a logfile anywhere, I want to delete them.

Regards

Chris

[Reef Man]

Can anybody tell me if this works with vbulletin 3.8.X ??

Thanks

[Reef Man]

Well,
It works with 3.8.X.

just one question, how can I skip to have a lot of linkbacks from google with the list above?

Thanks.

[Reef Man]

Found it !!

Thanks anyway.

Great Mod !!

[zombietom]

Seems to work good,would like to see trackbacks and pingbacks added ..would like to see a number of linkback count in the threadtools like Vseo as well...thanks for this

[Tanapangarap]

Dear sir,

I tried visiting the link you gave for your "DCSEO modification," but I am lead to an error page. Is that modification still available, or have you decided to discontinue?

Regards,

Kevin

[Reef Man]

Hi,
Does this will be updated to the 4.0.1 version?

Thanks.

[turbosatan]

im getting

Invalid SQL:

INSERT INTO linkback
(pageurl, approved, type, dateline, threadid)
VALUES
('http://www.google.co.il/search?hl=iw&q=%D7%A4%D7%95%D7%A8%D7%95%D7%9D+%D7%9C%D7%9E%D7%9 1%D7%95%D7%92%D7% A8%D7%99%D7%9D+%D7%A1%D7%A8%D7%98%D7%99%D7%9D&start=20&sa=N', 0, 1, '1265583981', '7339');

MySQL Error : Duplicate entry '65535' for key 1

i tried changing the linkbackid to an int value instead of smallint

that didnt do it.

[SAT2M]

Hello
I want to remove this hack but I cant & shown this database error why?

.................
Database error in vBulletin 3.7.2:

Invalid SQL:
DROP table linkback;

MySQL Error : Unknown table 'linkback'
Error Number : 1051
Request Date : Wednesday, August 20th 2008 @ 04:36:10 PM
Error Date : Wednesday, August 20th 2008 @ 04:36:10 PM
Script : http://www.***.com/admincp/plugin.php?do=productkill
Referrer : http://www.***.com/admincp/plugin.php?do=productdelete&productid=dcseolinkbacks&s=
IP Address : 206.222.**.**
Username : MEHDI
Classname : vB_Database
MySQL Version : 5.0.51a-community
.................................


Hello
Why don't answer any person to me for uninstalling this hook ??????

[karnevil]

testing http://www.legalbeagles.info/forums/showthread.php?p=153361#post153361

[AfterWorldForum]

Maybe I'm missing something, but where would one put entries into the blacklist exactly?

I'd also like to enquire whether this modification still works with VB4? And lastly, I noticed that in some of my linkbacks, I have a lot of repetitive links showing up. Would it be possible to somehow have numerous links from the same site (for instance from another forum, it's possible to receive dozens of links from a single thread) consolidated into a single entry without requiring manual interaction?

Thanks :)

Edit: Just bought vbSEO, and discovered everything I asked is available in there :)

[River_rush]

MySQL Error : Duplicate entry '65535' for key 1
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.
Also have this problem too.

[Reef Man]

Any other mod like this for 4.2.2 ???
Will this be updated?

[ozzy47]

I don't remember seeing one like this for vB4, and I doubt the developer will be updating this, they have not been on here in almost two years.

[viper357]

I've been running this mod for a few years now, but in this day and age and with google changing so much, is there any benefit to having this mod installed? On some threads I have lists of about 35 link backs. Does having these linkbacks have any effect or benefit for SEO purposes?