Not signed in (Sign In)

Vanilla 1.1.4 is a product of Lussumo. More Information: Documentation, Community Support.


Archive: How do I ban ip addresses using MSSQL script?

Bottom of Page

1 to 3 of 3

  1.  
    • CommentAuthorpeyton
    • CommentTimeNov 6th 2006
     
    Hi, this is my first post. I have a website www.psychopanic.com and there’s an IP address that I want banned from accessing my site (203.213.0.10). Does anyone here know how to make a MsSQL script that can ban ip addresses? my webhosting Plesk control panel only lets me use MsSQL.
    Thank you
    • CommentAuthorgregory
    • CommentTimeNov 6th 2006
     
    I'm not aware of any SQL functionality that you can implement to block an IP address, nor do I have any experience in web programming.
    With sql you can limit the privileges of any user assigning that user to a given roll or just to delete him from your db users.
    I have no idea how you can do that in the web environment, but I suppose that if you can get the user's ip you also can redirect him out of your site.
    I think you should (or any mod) move this thread to another forum, since your question is more related with web programming than with SQL.
    Good luck
    • CommentAuthorpeyton
    • CommentTimeNov 6th 2006
     
    Sorry about this post. since I posted that, I learnt that my webhoster supports php, plus a whole bunch of other codes like asp etc. I got a bit of help from my irc friends, and now I have 2 scripts for my website. one is to ban single ip addresses, and the other is to ban ranges of ip addresses.. I didn’t know I could just change my WebPages to .php instead of .htm to do this.

1 to 3 of 3

  1.