• KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Topic: Opinion On Adding Bad URLs To A Caspio Database Then Querying

I've been thinking it would probably be better to get off my .csv list asap (see extension URL Checker). Therefor I've been looking at the caspio services.

Now I wonder whether that is the best solution for quickly creating a db that any forum owners can access.

Here's some docs on the subject of WS API access

http://www.caspio.com/support/resources … ce-API.pdf

Interested to hear peoples views on the matter....

Background: it needs to be realtime data to be most effective against spammers, a list published every 12 or 24 hours won't do....

2 Reply by Grez

  • Grez
  • PunBB senior member
  • Offline
  • From: Czech Republic
  • Registered: 2008-12-03
  • Posts: 248

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

48 pages... really?  big_smile neutral

Eraversum - scifi browser-based online webgame

Grez's Website

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

Yeah, the salesperson I've been in contact with, is absolutely useless. I told him I'm no coder big_smile
If you know a way to get our own queryable db going I'll scrap them in a nanosecond....
I've got all the data in sql - all I need is way to query now....

4 Reply by Grez

  • Grez
  • PunBB senior member
  • Offline
  • From: Czech Republic
  • Registered: 2008-12-03
  • Posts: 248

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

KeyDog wrote:

If you know a way to get our own queryable

Well, it's not problem smile

With the SQL table structure you used in this post. (BTW, not really sure - what's in table "type"?)

This will do smile
http://keydog.info/index.php?url_spam=http://example.com/example
[code=php]<?php
if(isset($_GET['url_spam']) && !empty($_GET['url_spam'])) {
    $url = mysql_real_escape_string(urldecode($_GET['url_spam'])); //protection against SQL injection + encoding for national domains
    $q = mysql_query("SELECT keyword, position, type FROM spamurls WHERE url = '$url'");
    while($z = mysql_fetch_array($q)) {
        echo json_encode($z);
    }
}
[/code]

Which will output something you can easily decode with [code=php]json_decode()[/code] smile

Eraversum - scifi browser-based online webgame

Grez's Website

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

Very interesting...

RE the BTW; Type and position and meant more for any disputes I have. If there's an X it means I manually changed/added a URL that was http://spamsitedotcom/folder/somepage to http://spamsitedotcom - so I don't need to worry about the paths being changed. S stands for signature and is most common. Position is to remember if there were several links in one signature. Both aren't relevant for queries, but important for me.

Grez wrote:

This will do smile
http://keydog.info/index.php?url_spam=http://example.com/example
[code=php]<?php
if(isset($_GET['url_spam']) && !empty($_GET['url_spam'])) {
    $url = mysql_real_escape_string(urldecode($_GET['url_spam'])); //protection against SQL injection + encoding for national domains
    $q = mysql_query("SELECT keyword, position, type FROM spamurls WHERE url = '$url'");
    while($z = mysql_fetch_array($q)) {
        echo json_encode($z);
    }
}
[/code]

Which will output something you can easily decode with [code=php]json_decode()[/code] smile

Will modification/use of this code permit me to query my db from other forums aswell? Or will this be for local integration ?

6 Reply by Grez

  • Grez
  • PunBB senior member
  • Offline
  • From: Czech Republic
  • Registered: 2008-12-03
  • Posts: 248

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

KeyDog wrote:

Will modification/use of this code permit me to query my db from other forums aswell? Or will this be for local integration ?

Well, if someone (which seems to be me, at the weekend big_smile), will write code for it then yes smile

Eraversum - scifi browser-based online webgame

Grez's Website

  • KeyDog
  • KeyDog
  • Global Moderator
  • Offline
  • Registered: 2008-12-12
  • Posts: 1,693

Re: Opinion On Adding Bad URLs To A Caspio Database Then Querying

Grez wrote:

Well, if someone (which seems to be me, at the weekend big_smile), will write code for it then yes smile

Sounds too good to be true ! Look forward to your ideas, code big_smile