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)

dj_f16 10-08-2007 05:48 PM

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

Robert7 10-09-2007 12:43 PM

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

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

ChaosProgrammer 10-09-2007 06:50 PM

Quote:

Originally Posted by ChaosProgrammer (Post 1355507)
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 : XXXXXX
Username : XXXXX
Classname : vb_database




I have zoints SEO if that helps

Anyone has an idea?

ragtek 10-09-2007 08:39 PM

why have you commented
Code:

                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 10-10-2007 08:35 AM

Quote:

Originally Posted by ChaosProgrammer (Post 1356404)
Anyone has an idea?

Not sure. It works for everyone else.

Quote:

Originally Posted by ragtek (Post 1356461)
why have you commented
Code:

                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 10-10-2007 08:57 AM

hm strange
for me its working fine

Dean C 10-10-2007 01:42 PM

Quote:

Originally Posted by ragtek (Post 1356754)
hm strange
for me its working fine

I'll look into uncommenting it next time around ;)

Deadly Assassin 10-12-2007 03:50 AM

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:

Dean C 10-12-2007 12:34 PM

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 10-12-2007 01:49 PM

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 10-12-2007 02:56 PM

Quote:

Originally Posted by Dean C (Post 1358232)
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 10-13-2007 01:54 PM

I'll look into it :)

Alibass 10-15-2007 06:11 PM

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 10-16-2007 04:54 AM

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 10-17-2007 12:37 PM

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 10-17-2007 12:46 PM

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 10-18-2007 02:42 PM

Quote:

Originally Posted by fredang85 (Post 1362291)
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 10-18-2007 02:43 PM

Quote:

Originally Posted by cedars (Post 1362297)
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 10-20-2007 02:16 AM

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

Dean C 10-21-2007 08:50 AM

Quote:

Originally Posted by bada_bing (Post 1364075)
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 10-24-2007 10:24 AM

Thank you, great..

Wachtmeister 10-25-2007 12:43 PM

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

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:

Has this been fixed yet?

Dean C 10-26-2007 07:33 AM

Quote:

Originally Posted by Wachtmeister (Post 1368282)
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 10-26-2007 02:41 PM

works ok for me

joiner42 10-26-2007 02:42 PM

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

Wachtmeister 10-28-2007 10:18 AM

Quote:

Originally Posted by Dean C (Post 1368943)
Are you running the latest version? This issue was fixed a long time ago.

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

Beermonster 11-05-2007 07:55 PM

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 01-13-2008 12:10 PM

installed,thanks.

Dean C 01-21-2008 07:17 PM

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)

DanaRVT 01-21-2008 07:30 PM

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

Dean C 01-21-2008 07:32 PM

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

dartho 01-22-2008 02:27 AM

Quote:

Originally Posted by ChaosProgrammer (Post 1355507)
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

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 01-22-2008 02:43 AM

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 01-22-2008 04:26 AM

Has anyone tried this with 3.7b?

dartho 01-22-2008 04:41 AM

Yep - seems to work OK, although not heavily tested

BlizzardHQ 01-22-2008 04:47 AM

k, thanks

/clicks install

Dean C 01-22-2008 07:48 AM

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 01-24-2008 07:24 PM

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


All times are GMT. The time now is 06:03 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.01510 seconds
  • Memory Usage 1,828KB
  • 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
  • (4)bbcode_code_printable
  • (12)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