esmNewdir

[esmandil]

http://www.ioftpd.com/scripts/script.php?id=166
Excerpts for ReadMe.txt:

##################################################
This is a newdir/dupe script for ioFTPD, created by Esmandil
version 0.35 (11.12.2004)

It uses sqlite database, so it is pretty fast: I have tested with
database of over 1.000.000 directories and it still took less than 0.5
seconds to MKD. On the other hand, the dupe db takes a bit more (about
50% more, probably) space than flat text file would. It is well worth
it, though

This script was heavily influenced by NEWDIR V3.5.2 by B0unTy
-- big thanks, B0unty!

##################################################

Usage:

site new [<section>] [<count>] [<pattern>]
site dupe <pattern> [<section>] [<count>]
site undupe <dirname>

Deleting a directory removes it from the dupe database.
Wipe-ing a directory keeps it in dupe database.

##################################################

Example of use:

PHP Code:

MKD test1
257 "test1" created.

MKD test1
550 This dir looks like a dupe!

site undupe test1
200-Successfully unduped test1

site new D*V 3 tes
200-##  Age       Owner       Section     Name         
200---  --------  ----------  ----------  -------------
200-01  01d 04h   ioFTPD      DVDR        test1        
200-02  03d 00h   ioFTPD      DiVX        test2        
200-03  03d 00h   ioFTPD      DiVX        test3        
200-Usage: site new [<section>] [<count>] [<pattern>]

site dupe test gam 3
200-## Age       Owner       Section     Name                
200--- --------  ----------  ----------  ------------------- 
200-01 00m 02s   ioFTPD      game        test7               
200-02 02m 15s   ioFTPD      game        test8               
200-          Notes: Wiped by ioFTPD on 2004-12-10 20:30:07,
200-03 01d 04h   ioFTPD      games_old   test9               
200-          Notes: Unduped by ioFTPD on 2004-12-10 20:38:04 
200-Usage: site dupe <pattern> [<section>] [<count>] 


##################################################

!!! ATTENTION: batch script(s) I use -- namely run.bat -- have only
!!! been tested on WinXP. I am pretty sure they will work on 2000 as
!!! well, but most probably won't in 9x. If somebody manages to write
!!! it in a portable way, I would love to get my hands on it

##################################################

Have fun

[ChipMunk666]

Ok i looked into your script and i find it rather fascinating but i have a question.
I see db_schema.sql to put in a sql database.
But i don't see anything where i put this and how esmnewdir connects to it doesn't it need the required database in the sql server etc?And where to connect etc?
I want to use this with iosharedb.So a global dupe system.
But can't find any information about connecting it to the sql database.

[JoeBAR]

It uses sqllite, no connection, just a dll which store data in 'sql' fashion

[ChipMunk666]

ow ok thx why the sql table than?

[esmandil]

EsmNewdir uses SQL database to manage the data, but it is a lightweight one called sqlite. It does not connect to any SQL server, it stores all its data in a single file.

The esmnewdir.db file already has the correct schema loaded, the file is just for reference if somebody is interested

That said, it wouldn't be difficult to use some SQL server to keep the database in -- provided you have a way of accessing such server from tcl. I will not be doing anything like this, at least not in near future, but if you know some tcl you should be able to modify esmNewdir without much problem.