site pretime

[Mouton]

[12:21:01] site pretime
[12:21:03] 200-*--[PRETiME]-----------------------------------------------------*
[12:21:03] 200-| SYNTAX: SITE PRETiME <lookup> [number]                         |
[12:21:03] 200-|       <lookup>: Either the complete release name, a type of    |
[12:21:03] 200-|                 release, a group name or a keyword to search   |
[12:21:03] 200-|                 the db for.                                    |
[12:21:03] 200-|       <number>: Number of results to show (default is used if  |
[12:21:03] 200-|                 none specified).                               |
[12:21:03] 200-|                 Default:                                       |
[12:21:03] 200-|                   Exact match returns 0-1 result               |
[12:21:03] 200-|                   Release type returns 0-10 result(s)          |
[12:21:03] 200-|                   Group name returns 0-10 result(s)            |
[12:21:03] 200-|                   Keyword match returns 0-25 result(s)         |
[12:21:03] 200-|       Valid types: 0-DAY DiVX DVD-R GAME-iSO GBA MP3 MUSiC-ViD PS SVCD TV VCD XBOX XViD XXX *
[12:21:03] 200---[/PRETiME]----------------------------------------------------*
[12:21:03] 200 Command Successful.

U need a mysql table that contains type, name and timestamp of all rls. And don't ask where to get such a thing.
timestamp field needs to be a unix timestamp (as int), NOT a mysql timestamp field.

Source included, just in case ur table doesn't use the default field names, etc.

Enjoy.

*file has been removed*
Please ppl, mirror it. It won't be avail. there for much more than a week.

[phoenixfr]

wahoo mouton
this sounds nice to me
thx for sharing
i think you've worked a lot to make it work

[Mouton]

not that much...
once u get mysql++ working, it's an hour or two.

[dasOp]

in that case most of the work was probably getting mysql++ working at all.

[Mouton]

had to google a couple of minutes before I could find how to compile that thing on vs.net... had to comment gay functions and stuff...

[Flare2]

nice shit man, nice shit


any way to make a non-SQL version of this?

[Mouton]

Where would u like it to fetch the info from ?

[ProlyX]

txt?

save it like
type name time
then you grep the the search string and output the results..

[cez]

not really on topic, but anyone know of a tcl-sqldriver to be used with windrop and dzsbot??

[iXi]

moin,

realy nice script but thats only one part
is a secound part planed ?

that means a script for writing release name + pre time into a sql-db on pre ?

*g


cya

[Flare2]

make it able to use a .mdb instead of SQL

would be good for us without SQL

[Mouton]

I really don't think you can use ".mdb" and "good" in the same sentence and still make sense!

I won't support that, cause I don't intend to learn how to access an Access DB from a C++ program...
Just the tought of that gives me shivers!

Quick Q: Why don't u use MySQL or Postgres, or any other free sql-(almost-)compliant db ?

[Mouton]

pRoLuCkY:

.tcl:

bind msgm - [PRE]* procpre

proc procpre {nick uhost handle text} {
  set query [http::formatQuery "rls" $text]
  set url "http://your_ip/pretime.php?$query"
  putlog "url: $url"
  set result [http::data [http::geturl $url -timeout 5000]]
  putlog "$result"
}

pretime.php:

<?
mysql_connect("localhost", "user", "password");
mysql_select_db("pretimes_db");

ereg("\[PRE\] - ([a-zA-Z0-9\._-]*). in .([a-zA-Z0-9\._-]*)",$rls,$regs);
$release = $regs[1];
$type = $regs[2];

$time = time();

if ($type!="" && $release!="") {
  $sql = "INSERT INTO pretimes (timestamp, type, name) VALUES ('$time', '$type', '$release')"; 
  mysql_query($sql)
    or die($sql."<br>\n".mysql_error());
	
  echo "Release '$release' succesfully added as $type";
}

[iXi]

thx man

but thats a write in via msg not via io*gg

i meaned a tcl or programm what is writing into the sql db .. when
a rls grp on the site makes a pre...

cya

*edit*

btw other question how can i make a idler kick job for ioFTPD with
sitekill.exe ?

[Slayer]

mouton nice tcl's
is there anyway to make the bot report pretime via a trigger to the channel?