vb.org Archive

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)

Alibass 09-30-2007 01:58 AM

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 10-02-2007 07:50 AM

Nice add-on :) Installed and working...

Wachtmeister 10-02-2007 08:04 AM

Quote:

Originally Posted by Slave (Post 1332751)
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?

Quote:

Originally Posted by Wachtmeister (Post 1351269)
Nice add-on :) Installed and working...

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

What can i do to view the refback list? Test2

EDIT: Ok, now i have a "Moderate Linkbacks" :) But no Refback from this thread.... Test3 ... ok, got it :) Great work! Really

ForosAbiertos 10-02-2007 10:09 AM

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

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

Dave-M 10-02-2007 11:08 PM

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?

My forum can be found here.

Thanks :)

tanand79 10-03-2007 09:58 AM

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 10-04-2007 02:26 AM

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 10-04-2007 12:23 PM

Quote:

Originally Posted by Alibass (Post 1349672)
@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 10-04-2007 12:25 PM

Quote:

Originally Posted by ForosAbiertos (Post 1351318)
At install i have this error


some help please

Have you installed Zoints SEO before?

Dean C 10-04-2007 12:25 PM

Quote:

Originally Posted by Dave-M (Post 1351753)
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?

My forum can be found here.

Thanks :)

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

Dean C 10-04-2007 12:26 PM

Quote:

Originally Posted by tanand79 (Post 1352013)
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 10-04-2007 12:27 PM

Quote:

Originally Posted by Alibass (Post 1352538)
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 10-04-2007 12:49 PM

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 10-04-2007 01:21 PM

Quote:

Originally Posted by dj_f16 (Post 1352783)
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 10-04-2007 02:10 PM

Quote:

Originally Posted by Dean C (Post 1352770)
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.

Quote:

Originally Posted by 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?

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 10-04-2007 02:27 PM

Quote:

Originally Posted by Dean C (Post 1352768)
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 10-04-2007 03:08 PM

Quote:

Originally Posted by Alibass (Post 1352827)
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 10-04-2007 03:09 PM

Quote:

Originally Posted by Dave-M (Post 1352834)
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 10-04-2007 03:28 PM

Quote:

Originally Posted by Dean C (Post 1352851)
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 10-04-2007 04:08 PM

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

Dean C 10-04-2007 04:21 PM

Quote:

Originally Posted by Alibass (Post 1352868)
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 10-04-2007 04:22 PM

Quote:

Originally Posted by dj_f16 (Post 1352907)
know....blacklist long reaches if I affect linkler other..
You shorten does it not have a road?

Sorry I don't understand

Dave-M 10-04-2007 04:53 PM

Quote:

Originally Posted by Dean C (Post 1352852)
Link to one of your threads here, then click on it. You should get a refback in your admincp :)

Here 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 10-04-2007 05:25 PM

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 10-04-2007 05:35 PM

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

Dean C 10-05-2007 06:42 AM

Quote:

Originally Posted by Dave-M (Post 1352958)
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 10-05-2007 06:42 AM

Quote:

Originally Posted by dj_f16 (Post 1352964)
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 10-05-2007 08:22 AM

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 10-05-2007 09:31 AM

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

Alibass 10-05-2007 01:42 PM

Quote:

Originally Posted by Dean C (Post 1353307)
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 10-05-2007 04:18 PM

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

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 10-05-2007 06:06 PM

Quote:

Originally Posted by Dean C (Post 1353307)
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 10-05-2007 07:57 PM

Quote:

Originally Posted by dj_f16 (Post 1353547)
----------------------------------------------------------------------------------------------------

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 10-05-2007 07:59 PM

Quote:

Originally Posted by Dave-M (Post 1353582)
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 10-07-2007 01:49 PM

v1.3 released :)

Dave-M 10-07-2007 07:35 PM

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 10-07-2007 07:50 PM

Quote:

Originally Posted by Dave-M (Post 1354970)
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 10-07-2007 08:15 PM

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

Dean C 10-08-2007 01:15 PM

Quote:

Originally Posted by Dave-M (Post 1354996)
Yep, no rush, it was just my list of links frightened me - thanks again for this :)

No problem Dave :)

ChaosProgrammer 10-08-2007 02:31 PM

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


All times are GMT. The time now is 06:44 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.06502 seconds
  • Memory Usage 1,860KB
  • 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
  • (26)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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