Users Developers
Home / Forums / In-Portal Modules / In-Link – Directory Management / Dmitry, need some help on very old version / Topic Posts

In-Portal Forum

This is a place for users of In-Portal to ask questions, discuss various topics, and interact with other members of the In-Portal Community. Please report bugs through the Bugs Team (not the Forum). If you are interested in contributing or joining one of the many Teams for In-Portal, please check out the Contribute section of the website.

In-Portal Forum

Dmitry, need some help on very old version (2)

Posted: 08/11/2010 7:33:47 AM

Reply Quoted  

v2.3.4 (lol!)

Some smart alic had found a way to submit without using the form....... I patched it so it checks the referrer so it now only works via submitting via the form (I also added a capcha for extra measures).

Now, on to my question,... I have over 80k spam sites due to this........ What would be the raw DELETE FROM syntax for deleting between two dates?

Any assistance will be appreciated.

Posted: 08/13/2010 7:34:25 AM

Reply Quoted  

If you are familiar with database structure (I think you are, since you told, that you have modded In-Link), then writing an SQL doesn't seem to be a hard task.

Final SQL maybe will look like this:
FROM <links_table>
WHERE <data_created_field> BETWEEN <from_timestamp> AND <to_timestamp>.

I doesn't know how columns were named in that In-Link version.