Dmitry, need some help on very old version - In-Portal Web 2.0 Content Management System (CMS)

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.

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

webmaster
Member

Joined: 20-Feb-2004
Location: United Kingdom
Posts: 3

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.

alex
Member

Joined: 24-Jun-2009
Location: Latvia
Posts: 231

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:
DELETE
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.