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)

Wachtmeister 02-25-2008 09:27 PM

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/fo...ad.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 02-27-2008 06:14 PM

the linkbacks are not showing. either is the dropdown box

vinboy 05-15-2008 11:17 AM

hi
how do I disable the moderation?
I would like the linkback to appear as soon as possible without moderation.

thanks

Mesohu 05-20-2008 06:50 PM

This Mod work in vB 3.7 Gold or not ?

P@trick 05-31-2008 01:17 PM

I tryed it on vB 3.7.1 and i gain an SQL error when i want to import the product:

Quote:

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

FD1Stu 05-31-2008 04:52 PM

Quote:

Originally Posted by Deadly Assassin (Post 1357986)
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.

Code:

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 06-09-2008 09:55 PM

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 06-18-2008 12:26 PM

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 08-01-2008 04:39 PM

Quote:

Originally Posted by Wachtmeister (Post 1451005)
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/fo...ad.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 08-10-2008 08:08 PM

Waiting patiently for DCSEO and more on DCSEO Linkbacks working with 3.7.# :up:

SAT2M 08-20-2008 11:09 AM

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.ph...eolinkbacks&s=
IP Address : 206.222.**.**
Username : MEHDI
Classname : vB_Database
MySQL Version : 5.0.51a-community
.................................

LuBi 08-20-2008 09:11 PM

Quote:

Originally Posted by SAT2M (Post 1602993)
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 08-21-2008 07:13 AM

Quote:

Originally Posted by LuBi (Post 1603299)
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 10-04-2008 12:39 AM

works great on 3.7.3

TFEX 11-02-2008 09:16 PM

Marked as installed. Still testing.

Test link: http://www.thefreebieexchange.com/fo...hread.php?t=41

:)

Mesohu 11-15-2008 09:55 AM

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 11-18-2008 12:57 PM

The coder is alive or not ?!

LuBi 11-28-2008 02:59 AM

Quote:

Originally Posted by SAT2M (Post 1603603)
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 11-30-2008 03:11 PM

Quote:

Originally Posted by Mesohu (Post 1668049)
The coder is alive or not ?!

I'm waiting :confused: :o

yjmalmsteen 12-01-2008 08:56 PM

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

yjmalmsteen 12-01-2008 09:02 PM

Quote:

Originally Posted by Dean C (Post 1353355)
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 12-07-2008 11:08 AM

Quote:

Originally Posted by Mesohu (Post 1666027)
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 12-07-2008 12:38 PM

Quote:

Originally Posted by Dean C (Post 1680172)
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 12-09-2008 05:21 PM

Quote:

Originally Posted by turbosatan (Post 1680206)
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 12-27-2008 10:39 AM

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 12-27-2008 04:03 PM

In case anyone is after the full official list of google.tld then you can get them all here.

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 03-07-2009 01:09 PM

all google domains formatted ready to use.

Code:

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 03-16-2009 09:51 PM

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 07-22-2009 04:07 PM

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 09-08-2009 11:02 PM

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

Thanks

Reef Man 09-11-2009 08:19 PM

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 09-11-2009 08:22 PM

Found it !!

Thanks anyway.

Great Mod !!

zombietom 09-25-2009 06:02 PM

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 11-15-2009 04:36 AM

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 01-19-2010 09:55 PM

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

Thanks.

turbosatan 02-07-2010 09:13 PM

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%91%D7%95%D7%92%D7% A8%D7%99%D7%9D+%D7%A1%D7%A8%D7%98%D7%99%D7%9D&star t=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 02-26-2010 06:50 PM

Quote:

Originally Posted by SAT2M (Post 1602993)
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.ph...eolinkbacks&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 03-15-2010 11:27 AM

testing http://www.legalbeagles.info/forums/...361#post153361

AfterWorldForum 05-09-2010 06:12 AM

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 09-05-2012 05:11 AM

MySQL Error : Duplicate entry '65535' for key 1
Quote:

Originally Posted by crashys (Post 1589310)
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.


All times are GMT. The time now is 12:55 PM.

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.01602 seconds
  • Memory Usage 1,839KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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