SQL based allow/deny rules

I'm in the process of developing a (private) plugin for the antidos side to APF, basically allowing the users to throw the data into a (centralized) sql database on my server. That part I've managed to figure out, it really wasn't that hard.

From there, the question is how to use it. Granted, I can use wget and php to replace ad.rules every night, but I'm sure there's a better way to handle this data.

Has anyone run across (or developed) a rules based system that would allow (or deny) access to a server based on this type of data? Allowing remote connections to my server isn't a problem, so they could easily do something like this:

connect
select * from level1 where ip='$ip'

handle data from there

Simplistic? Maybe. Complicated? Naaah, it's just a matter of getting the data out right. Just wondering has anyone developed something like this?

Also, on a side note (no, I'm not selling this right now), how much interest would there be in this type of thing?

Thoughts/Ideas?

 

 

 

 

Top