Auto Link Checker

Started by M-DVD, June 30, 2009, 12:52:38 AM

Previous topic - Next topic

Dzonny

I have uninstall mod, delete and empty table log_link_checker and install mod again, and i've noticed that in some topic i have dead links showen although they are alive. :/

ceewee

Quote from: ceewee on July 05, 2009, 04:46:00 AM
[quot
Quote from: M-DVD on July 04, 2009, 09:50:35 PM

IMPORTANT:

All persons who have made the increase in the number of links, should do:

1.- Uninstalls the MOD.
2.- Via phpmyadmin. Delete the changes made by the MOD in the tables. (delete the table and the column)
3.- Reinstalls the MOD.

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


I have 3000 rapidshares in 8 msgs, below 154 it worked fine, I have changed 100>1000>999 then 600 then 100, ten uninstalled, so applies to me.

Will make 30 msgs from those 8 and then reinstall after deleteling table/colum.

But which table/colum I have to delete (after backup Mysql) ?





Deleted table/colum, modified msgs (only 100 links (except megaupload) max. per total msg/topic, so splitting topic with replies or just copy and paste in new topics.
Works !!

BTW Can you add rapidshare.de to the list?

ɔɔɔɔɔɔuɥoɾ

I noticed something strange, Posts with over 100 links showing as dead links, well, I edit the post (add a space to the end) and the links now have correcrt status, I dont know if this is relevant but it seems to be helping something ???


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

M-DVD

Quote from: ceewee on July 05, 2009, 04:46:00 AM
Quote from: M-DVD on July 04, 2009, 09:50:35 PM

IMPORTANT:

All persons who have made the increase in the number of links, should do:

1.- Uninstalls the MOD.
2.- Via phpmyadmin. Delete the changes made by the MOD in the tables. (delete the table and the column)
3.- Reinstalls the MOD.

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


I have 3000 rapidshares in 8 msgs, below 154 it worked fine, I have changed 100>1000>999 then 600 then 100, ten uninstalled, so applies to me.

Will make 30 msgs from those 8 and then reinstall after deleteling table/colum.

But which table/colum I have to delete (after backup Mysql) ?

Quote from: Dzonny on July 05, 2009, 04:52:14 AM
I have uninstall mod, delete and empty table log_link_checker and install mod again, and i've noticed that in some topic i have dead links showen although they are alive. :/

Quote from: johncccccc on July 05, 2009, 12:14:02 PM
I noticed something strange, Posts with over 100 links showing as dead links, well, I edit the post (add a space to the end) and the links now have correcrt status, I dont know if this is relevant but it seems to be helping something ???

Delete the table {db_prefix}log_link_checker_status

And Delete the column checker_time in {db_prefix}messages

And then re-install the MOD.

It is the only way to clean the false data by changing the maximum number of links

--

Quote from: Groundhog on July 05, 2009, 02:54:20 AM

Quote

To add a site, you must study this site and make some adjustments in the code, ie, there is no magic formula for adding other filehosts.

Thanks for feedback M-DVD  :)

Your welcome :)

Quote from: Sabre™ on July 05, 2009, 04:17:29 AM
Very good support mate :)
+k

Thanks for your comment :P

--

Quote from: ceewee on July 05, 2009, 09:36:05 AM
Deleted table/colum, modified msgs (only 100 links (except megaupload) max. per total msg/topic, so splitting topic with replies or just copy and paste in new topics.
Works !!

Excelent.

Quote from: ceewee on July 05, 2009, 09:36:05 AM
BTW Can you add rapidshare.de to the list?

Afaik rapidshare.de don't have tool or API for check many links. Then I will not add this filehost.

Why? Because... and Because...


mforum

Quote from: mforum on July 01, 2009, 05:40:11 AM
i don`t know if you changed something since yesterday but i have unintsalled and installed again anyway

same error

2: preg_match_all() [<a href='function.preg-match-all'>function.preg-match-all</a>]: Compilation failed: unrecognized character after (?< at offset 51
File: /home/******/public_html/forum/Sources/AutoLinkChecker-Subs.php
Line: 113

the link i post is: http://rapidshare.com/files/91721165/djchris_livemix.part1.rar.html
which is definitely dead
i get no pm and have the above error in log as soon as i post it

AutoLinkChecker-Subs.php around line 113
// Msg with Filehost's Links
if (preg_match_all($linkCheker['Regexs']['reg0'], $msg, $recipiens))
$linkCheker['msg_with_links'][] = $id_msg;


settings i use shows on attached screenshot

any ideas?
can i do something ?

lucas-ruroken

very good...
Great mod ^^
Adk Portal 3.1 is coming....

Design your universe!

ceewee

>And Delete the column checker_time in {db_prefix}messages

Oops forgot that, but after modyfing the 8 into 25 and setting timecheck 4 to 0, I assume that's ok. Now reset to 4.


Great mod..too bad for rapidshare.de but if they don't have the facility's..

Will check if I can add more filehosts...


ɔɔɔɔɔɔuɥoɾ

Okay I have removed all the database entries made by this mod and re installed.

I would like the limit to be 1000 too

but if this edit causes the inaccuracy of the link status
http://www.simplemachines.org/community/index.php?topic=321151.msg2140473#msg2140473

how can we make the limit 1000 without messing up the mod?


SMF 2.0 RC5

   
Webhost to New Webhost file transfer service, PM me - Fast transfers

4Kstore

Buenas, pensaba modificar un poco el mod para que solo le mande los MP a un grupo "checkeadores de link", solo a ese grupo.
Queria hacer la consulta algo asi, pero hasta ahi llego y me trabo.:
$sql = db_query("
SELECT realName
FROM {db_prefix}members
      WHERE ID_GROUP = 9",_FILE_,_LINE_);
$bccb = array();
mysql_free_result($sql);


donde 9 seria el id del grupo nuevo que cree...

y despues remplazar lo que hay en bccb en
sendpm(array('to' => $bcc, 'bcc' => array()),

NO funciona, pero queria saber si estoy muy desviado y si me podian dar una mano.

Saludos!

¡¡NEW MOD: Sparkles User Names!!!

Mraza

thanks for this great MOD...i got a problem now..in many posts i am getting this error
"There are over 100 links to a FileHost in this message page.
Please, delete some links, use other filehost or open other topic. "

any solution...thanks
Signature:
Old Software Engineers Never Dies, They Just Log Out...
! ! ! ! ! 5 Best Movies Thread ! ! ! ! !

Dzonny

Ok, i've delete those tables as M-DVD said, and reinstall mod, now works fine. Thanks for tips M-DVD.

Quote from: mraza on July 06, 2009, 05:28:57 AM
thanks for this great MOD...i got a problem now..in many posts i am getting this error
"There are over 100 links to a FileHost in this message page.
Please, delete some links, use other filehost or open other topic. "

any solution...thanks

As M-DVD said we can not done that for now.
http://www.simplemachines.org/community/index.php?topic=321151.msg2144104#msg2144104

I'm wondering can we set topic to load normaly without link check if topic has more than 100 links? That would be cool.
Regards,

M-DVD

Quote from: mforum on July 05, 2009, 02:49:53 PM
any ideas?
can i do something ?

Your host has enabled the function fsockopen?

--

Quote from: johncccccc on July 05, 2009, 06:05:18 PM
Okay I have removed all the database entries made by this mod and re installed.

I would like the limit to be 1000 too

but if this edit causes the inaccuracy of the link status
http://www.simplemachines.org/community/index.php?topic=321151.msg2140473#msg2140473

how can we make the limit 1000 without messing up the mod?

To allow this, currently would require a couple of changes.

I didn't possible for the reasons I mentioned earlier. It would be inconvenient.

Perhaps in the future I do the change, for if somebody want to do so at your own risk.

--

Quote from: 4kstore on July 05, 2009, 08:07:28 PM
Buenas, pensaba modificar un poco el mod para que solo le mande los MP a un grupo "checkeadores de link", solo a ese grupo.
Queria hacer la consulta algo asi, pero hasta ahi llego y me trabo.:
$sql = db_query("
SELECT realName
FROM {db_prefix}members
      WHERE ID_GROUP = 9",_FILE_,_LINE_);
$bccb = array();
mysql_free_result($sql);


donde 9 seria el id del grupo nuevo que cree...

y despues remplazar lo que hay en bccb en
sendpm(array('to' => $bcc, 'bcc' => array()),

NO funciona, pero queria saber si estoy muy desviado y si me podian dar una mano.

Saludos!

Lo primero, es que debes leer los ID, no los nombres.

Luego parece que vas a usar la variable $bccb y más abajo se llama $bcc.

Y también falta el mysql_fetch_assoc

Trata con esto:


$sql = db_query("
SELECT ID_MEMBER
FROM {db_prefix}members
WHERE ID_GROUP = 9"
,_FILE_,_LINE_);
$bcc = array();
while ($row = mysql_fetch_assoc($sql))
$bcc[] = $row['ID_MEMBER'];

mysql_free_result($sql);


Eso debe servir. Pero sólo devuelve a los usuarios que tengan a ese grupo como grupo primario, si alguno lo tiene como grupo secundario no aparecerá.

--

Quote from: mraza on July 06, 2009, 05:28:57 AM
thanks for this great MOD...i got a problem now..in many posts i am getting this error
"There are over 100 links to a FileHost in this message page.
Please, delete some links, use other filehost or open other topic. "

any solution...thanks

Disable the MOD and split (if is possible) the topic/post, then enable the MOD.

There are reasons why the maximum is 100 links. (For all) Do not try increase it because the consequences will be worse.

--

Quote from: Dzonny on July 06, 2009, 11:22:37 AM
I'm wondering can we set topic to load normaly without link check if topic has more than 100 links? That would be cool.
Regards,

I not did it, because the people will think that the MOD doesn't work (and will not aware that there is an impediment to check more than 100 links).

But in a new version I will do something better, just I need think how best to implement.

--

Quote from: lucas-ruroken on July 05, 2009, 03:13:02 PM
very good...
Great mod ^^

Thanks for your comment :D

--

Quote from: Dzonny on July 06, 2009, 11:22:37 AM
Ok, i've delete those tables as M-DVD said, and reinstall mod, now works fine. Thanks for tips M-DVD.

Your welcome :D

Dzonny

QuoteI not did it, because the people will think that the MOD doesn't work (and will not aware that there is an impediment to check more than 100 links).
Okay, then, maybe some notice to member first and then normal load of topic without link check.
Just an idea for future version of mods...

Mraza

Quote from: Dzonny on July 06, 2009, 11:22:37 AM
I'm wondering can we set topic to load normaly without link check if topic has more than 100 links? That would be cool.
Regards,
+1

yes is it possible if the post have more then 100 filehost link it will just leave the post alone :) ..this would be great....thanks
Signature:
Old Software Engineers Never Dies, They Just Log Out...
! ! ! ! ! 5 Best Movies Thread ! ! ! ! !

asifnur

how do i chnge so it doesnt give me error like i have a thread which has like 1000s of links .. but when i enter it is says summin like remove sum links ... and i cant enter tht thread any help?

Dzonny

asifnur, turn off mod first, in admin panel > Post and Topics and then modify/delete links

4Kstore

#96
Quote from: M-DVD on July 06, 2009, 11:47:09 AM

Quote from: 4kstore on July 05, 2009, 08:07:28 PM
Buenas, pensaba modificar un poco el mod para que solo le mande los MP a un grupo "checkeadores de link", solo a ese grupo.
Queria hacer la consulta algo asi, pero hasta ahi llego y me trabo.:
$sql = db_query("
SELECT realName
FROM {db_prefix}members
      WHERE ID_GROUP = 9",_FILE_,_LINE_);
$bccb = array();
mysql_free_result($sql);


donde 9 seria el id del grupo nuevo que cree...

y despues remplazar lo que hay en bccb en
sendpm(array('to' => $bcc, 'bcc' => array()),

NO funciona, pero queria saber si estoy muy desviado y si me podian dar una mano.

Saludos!

Lo primero, es que debes leer los ID, no los nombres.

Luego parece que vas a usar la variable $bccb y más abajo se llama $bcc.

Y también falta el mysql_fetch_assoc

Trata con esto:


$sql = db_query("
SELECT ID_MEMBER
FROM {db_prefix}members
WHERE ID_GROUP = 9"
,_FILE_,_LINE_);
$bcc = array();
while ($row = mysql_fetch_assoc($sql))
$bcc[] = $row['ID_MEMBER'];

mysql_free_result($sql);


Eso debe servir. Pero sólo devuelve a los usuarios que tengan a ese grupo como grupo primario, si alguno lo tiene como grupo secundario no aparecerá.



Gracias por la respuesta, antes y ahora siempre tira el mismo 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 '}members
WHERE ID_GROUP = 9' at line 2
Archivo: _FILE_
Línea: _LINE_


Lo que faltaba era "$" en db_prefix, despues tiraba otro error de que no encontraba la tabla y es porque faltaba el "$db_prefix" en las variables globales.
Y por ultimo para que busque en los grupos secundarios me fije en el post de ejemplo que dejaste para otra cosa y lo resolvi de la siguiente manera por si alguien necesita:

Buscar:
global $linkCheker, $modSettings, $context, $txt, $sourcedir, $scripturl, $topic;

Remplazar:
global $linkCheker, $modSettings, $context, $txt, $sourcedir, $scripturl, $db_prefix, $topic;

Buscar:
require_once($sourcedir . '/Subs-Post.php');

Agregar despues:  // Donde "9" es el id del grupo al cual se enviaran los mp
   $sql = db_query("
   SELECT ID_MEMBER
      FROM {$db_prefix}members
      WHERE ID_GROUP = 9 OR FIND_IN_SET(9, additionalGroups)"
   ,_FILE_,_LINE_);
   $bcc = array();
   while ($row = mysql_fetch_assoc($sql))
      $bcc[] = $row['ID_MEMBER'];

   mysql_free_result($sql);


Y despues remplazar
sendpm(array('to' => $bcc, 'bcc' => array()),

Me funciona perfecto parece.

Gracias de nuevo por la ayuda..
Saludos!

¡¡NEW MOD: Sparkles User Names!!!

asifnur

Quote from: Dzonny on July 06, 2009, 06:16:09 PM
asifnur, turn off mod first, in admin panel > Post and Topics and then modify/delete links
no i dont want to delet any links though :(
i just want to edit the mod so it can chk like 1000 or more links too

Dzonny

Quote from: asifnur on July 06, 2009, 06:44:48 PM
Quote from: Dzonny on July 06, 2009, 06:16:09 PM
asifnur, turn off mod first, in admin panel > Post and Topics and then modify/delete links
no i dont want to delet any links though :(
i just want to edit the mod so it can chk like 1000 or more links too
It's not possible for now....
Maybe in next version this will be fixed in some way...

[̲̅J̲̅][̲̅U̲̅][̲̅R̲̅][̲̅E̲̅][̲̅K̲̅] ٩(×̯×)۶

Croatian translation based on Dzonny's Serbian translation:
- Note: only few words changed, because of other language code


$txt['auto_link_checker_enabled'] = 'Uključi automatsku provjeru linkova';
$txt['auto_link_checker_enabled_sub'] = 'Ostavite prazno polje ako želite isključiti mod';

$txt['auto_link_checker_time'] = 'Provjeriti linkove ako su postavljeni prije ';
$txt['auto_link_checker_time_sub'] = '0 za stalnu provjeru';

$txt['auto_link_checker_error'] = 'Ima preko 100 linkova za FileHost u ovoj poruci.
<br />Molimo obrišite neke linkove, koristite drugi filehost ili otvorite novu temu.';

$txt['auto_link_checker_rapi'] = 'Rapidshare.com';
$txt['auto_link_checker_mega'] = 'Megaupload, Megarotic, Megaporn, Sexuploader';
$txt['auto_link_checker_file'] = 'Filefactory';

$txt['auto_link_checker_subject'] = 'Upozorenje: Pronađeni mrtvi linkovi!';
$txt['auto_link_checker_message'] = "U ovoj poruci [url=http://%1]%1[/url] pronađeni su mrtvi linkovi.\n\n
Možete obnoviti linkove, zaključati temu ili izbrisati linkove.\n\nHvala.\n\nAutomatska Provjera Linkova";

$txt['auto_link_checker_sendpm'] = 'Pošalji privatnu poruku';
$txt['auto_link_checker_pm_op'][0] = 'Isključeno';
$txt['auto_link_checker_pm_op'][1] = 'Pošalji autoru posta';
$txt['auto_link_checker_pm_op'][2] = 'Pošalji autoru posta + Lokalnom moderatoru';

Advertisement: