Auto Link Checker

[NHWD]

i keep getting
The package you tried to upload either is not a valid package or has become corrupted.

im running 1.1.9

[infyquest]

is it possible to increase the link limit from 100 to 1000?

[Sabre™]

Maaan this is a cool mod!!
Good work M-DVD
I'll give it a few days before I install though, give you time to update
Cheers

[esttecb]

@ esttecb
Ok, i've deleted it and when trying to run that lines as you said got again error:

#1064 - 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 'blah_log_link_checker_status ( `ID_MSG` INT( 10 ) UNSIGNED NOT NULL, `url` VAR' at line 1

Why this is not ruuned automaticaly when i've installed it, couse i install this by admin panel.. :/

mmm... ok... delete that table again (blah_log_link_checker_status).

Import the following code:

Remember to replace the PREFIX prefix  ... with ur real db prefix.

Code Select Expand

ALTER TABLE PREFIX_messages ADD checker_time INT(10) DEFAULT '0' NOT NULL;

CREATE TABLE PREFIX_log_link_checker_status (
ID_MSG int(10) UNSIGNED NOT NULL,
url varchar(255) NOT NULL,
life tinyint(1) DEFAULT '1' NOT NULL,
INDEX (ID_MSG)
);

INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_enabled', '1');
INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_time', '2');
INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_rapi', '1');
INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_mega', '1');
INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_file', '1');
INSERT IGNORE INTO PREFIX_settings (variable, value) VALUE ('auto_link_checker_sendpm', '2');

It should work.

EDIT: okay, all people with SMF 1.1.X have to import the above SQL code manually, from the phpmyadmin.

[Dzonny]

I have this error now:

SQL query:

INSERT INTO blah_settings( variable, value ) VALUE(
'auto_link_checker_enabled',
'1'
);

MySQL said: Documentation
#1062 - Duplicate entry 'auto_link_checker_enabled' for key 1

Edit:
I've install this successfully on my forum, but on test forum (free host) it wont work....

M-DVD: If you plan to develop this pod in fututre, can we give you some future ideas and requests here?
Anyway, thanks for great mod! 

is it possible to increase the link limit from 100 to 1000?

I'm also interested in this...

[ɔɔɔɔɔɔuɥoɾ]

Thanks for filling my mod request M-DVD, I will try this, I have SMF 2 RC1, will I need to upgrade to 2 RC1-1?

EDIT

works perfect for me (no manual coding required) on my custom theme with SMF 2 RC1.

Thanks again for such a great mod.

I have another useful idea, how about adding an option where we can choose which board(s) the link checker will scan for dead links, options could include, ALL boards, which categories, which boards.

I think that would make this already great mod that much greater, of course we can wait for future updates

[Sudhakar Arjunan]

Good Mod.

Do you think, is smf themed sites gives downloads .

[edi67]

is it possible to increase the link limit from 100 to 1000?

change in AutoLinkChecker-Subs.php this :

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 100)

to:

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 1000)


PS. is possible send pm for dead links  to moderator global too ?

[Nibogo]

Another great mod, really nice buddy

[Dzonny]

edi67, thanks for tip...

[Dzonny]

Sorry for bumping again but i have this error when i enable this mod and when go to topic that have some links in it:

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 '' at line 2
File: /home/samoo/public_html/forum/Sources/AutoLinkChecker-x1.php
Line: 127

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

My Database version is at version 1.1.9 for shore. (I've runned connect.php and check it)
So, anyone has idea what can be problem?

[Sabre™]

Database 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 '' at line 2
File: /home/vol1/phpnet.us/c/crazy/htdocs/blah/Sources/AutoLinkChecker-x1.php
Line: 127

Can you say me the MOD's setting, and the message did you post?

[Dzonny]

Sabre™, thanks for your quick answer...

In post settings i have:
Check Links again if has been over: 2 days
All filehosts servers are enabled, and pm reporting to post author + local mod.

I've posted for example topic with some application for download before enableing this mod. When i enable it, and browse that topic i've got error posted before.

[franklinrony]

marvelous mod, good job

[esttecb]

Sabre™, thanks for your quick answer...

In post settings i have:
Check Links again if has been over: 2 days
All filehosts servers are enabled, and pm reporting to post author + local mod.

I've posted for example topic with some application for download before enableing this mod. When i enable it, and browse that topic i've got error posted before.

It's looks like a mysql error to me... but u say it was working in ur local host, isn't it?

now, where are you testing it from? a local machine or from the web?

[Dzonny]

esttecb, i've tested in on free host earlier.
Now i wonna use it on my forum, on web....

I don't really know what to do, couse i havent change anything in AutoLinkChecker-x1.php, and i still have database error :/

[esttecb]

esttecb, i've tested in on free host earlier.
Now i wonna use it on my forum, on web....

I don't really know what to do, couse i havent change anything in AutoLinkChecker-x1.php, and i still have database error :/

yep, i know. I think it's a data base issue...

did you imported all the db tables? (u've to import 3 tables)

http://www.simplemachines.org/community/index.php?topic=321151.msg2139362#msg2139362

I told u that before, so I guess u already did that... but just to make sure...

[Dzonny]

esttecb thanks one again for your help...
I've delete that table now again, and when type code that you give me i got this error:

SQL query:

ALTER TABLE pn_1462104_messages ADD checker_time INT( 10 ) DEFAULT '0' NOT NULL ;

MySQL said: Documentation
#1060 - Duplicate column name 'checker_time'

Database prefix is pn_1462104_
So the code that i have inserted is:

Code Select Expand


ALTER TABLE pn_1462104_messages ADD checker_time INT(10) DEFAULT '0' NOT NULL;

CREATE TABLE pn_1462104_log_link_checker_status (
ID_MSG int(10) UNSIGNED NOT NULL,
url varchar(255) NOT NULL,
life tinyint(1) DEFAULT '1' NOT NULL,
INDEX (ID_MSG)
);

INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_enabled', '1');
INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_time', '2');
INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_rapi', '1');
INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_mega', '1');
INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_file', '1');
INSERT INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_sendpm', '2');


[ceewee]

is it possible to increase the link limit from 100 to 1000?

change in AutoLinkChecker-Subs.php this :

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 100)

to:

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 1000)


PS. is possible send pm for dead links  to moderator global too ?

I'm on 1.1.9. (upgraded from 1.1.8 ) and get when I change 100 in 1000
next msg:

Database 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 '' at line 2
File: /mou...................-x1.php
Line: 127

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version 1.1.8. The above error might possibly go away if you execute the latest version of upgrade.php.


update: changed 1000 to 600 and they show not the msg but big lists all as not available although most are when checked!?
Up to 154 checker seems to work.

Have almost 3000 rapidshare links in 8 msg's.

BTW how do poster and admin instead of local moderator get message, we have 1800 members and just 2 admins, no moderators. (this is solved received first msg, but posisble that's not correct)

[esttecb]

esttecb thanks one again for your help...
I've delete that table now again, and when type code that you give me i got this error:

SQL query:

ALTER TABLE pn_1462104_messages ADD checker_time INT( 10 ) DEFAULT '0' NOT NULL ;

MySQL said: Documentation
#1060 - Duplicate column name 'checker_time'

Database prefix is pn_1462104_
So the code that i have inserted is:

Code Select Expand


ALTER TABLE pn_1462104_messages ADD checker_time INT(10) DEFAULT '0' NOT NULL;

CREATE TABLE pn_1462104_log_link_checker_status (
ID_MSG int(10) UNSIGNED NOT NULL,
url varchar(255) NOT NULL,
life tinyint(1) DEFAULT '1' NOT NULL,
INDEX (ID_MSG)
);

INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_enabled', '1');
INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_time', '2');
INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_rapi', '1');
INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_mega', '1');
INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_file', '1');
INSERT IGNORE INTO pn_1462104_settings (variable, value) VALUE ('auto_link_checker_sendpm', '2');


mmmh... import the next code to remove the "junk". (actually, it's an uninstaller)

Code Select Expand

ALTER TABLE pn_1462104_messages DROP COLUMN checker_time;

DROP TABLE IF EXISTS pn_1462104_log_link_checker_status;

ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_enabled;
ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_time;
ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_rapi;
ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_mega;
ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_file;
ALTER TABLE pn_1462104_settings DROP COLUMN auto_link_checker_sendpm;

now, try to import the tables again and see if u get some error (I don't think so).

However, u imported the right code before (in ur last msg) but u get errors coz u didn't delete the columns, just the table.

is it possible to increase the link limit from 100 to 1000?

change in AutoLinkChecker-Subs.php this :

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 100)

to:

Code Select Expand

if (count($linkCheker['recipiensA'][$f_host]) > 1000)


PS. is possible send pm for dead links  to moderator global too ?

I'm on 1.1.9. (upgraded from 1.1.8 ) and get when I change 100 in 1000
next msg:

Database 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 '' at line 2
File: /mounted-storage/home22b/sub003/sc20581-HXVG/pubnud.com/Sources/AutoLinkChecker-x1.php
Line: 127

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version 1.1.8. The above error might possibly go away if you execute the latest version of upgrade.php.


update: changed 1000 to 600 and they show not the msg but big lists all as not available although most are when checked!?
Up to 154 checker seems to work.

Have almost 3000 rapidshare links in 8 msg's.

BTW how do poster and admin instead of local moderator get message, we have 1800 members and just 2 admins, no moderators. (this is solved received first msg, but posisble that's not correct)

Sorry for bumping again but i have this error when i enable this mod and when go to topic that have some links in it:

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 '' at line 2
File: /home/samoo/public_html/forum/Sources/AutoLinkChecker-x1.php
Line: 127

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.9, while your database is at version 1.1.4. The above error might possibly go away if you execute the latest version of upgrade.php.

So both of u guys have the same error... Dzonny, is this a coincidence or u tried to increase the link limit from 100 to 1000 too?