nxTools v1.0.4

[neoxed]

Changes:

• NEW: Check if the request was already filled before adding it.
• NEW: Extensions are now loaded using Tcl's package system.
• FIX: Properly quote string values in SQL statements.
• FIX: The "SITE PRE STATS" command was broken in v1.0.3.
• FIX: The maximum request age should be logged in seconds.
• FIX: The release check for "SITE REQUEST" did not allow some valid names.

Notes:

• Update ASAP, this fixes a possible SQL injection exploit.
• The procedure I used for escaping strings in SQL statements was left over from the MySQL days of nxTools. When I migrated to SQLite I never modified the procedure, so strings were not properly escaped.

Download:

http://www.inicom.net/pages/en.ioftpd-scripts.php?id=78

[Freestyler]

I upgraded from 1.0.3 to 1.0.4 and did what it says in upgrading.txt. Uploading is broke now.
It can be fixed to change 'result' to '$result' in nxDupe.tcl.

--------------------------- ErrorInfo ----------------------------
syntax error in expression "!result && [IsTrue $dupe(CheckFiles)]": variable references require preceding $
    ("if" test expression)
    while compiling
"if {!result && [IsTrue $dupe(CheckFiles)]} {
                set result [CheckFiles $virtualPath]
            }"
    ("PRESTOR" arm line 6)
    invoked from within
"switch -- $event {
        DUPELOG {
            set virtu

[neoxed]

Damnit, can't believe I missed that.

Thanks for pointing out that typo, it's been fixed in v1.0.4a (I reposted the file).

[zOrP]

one small question..

the site rebuild part..

i get

(14:08:38) [1] site rebuild
(14:08:38) [1] 200-.-[DupeUpdate]-----------------------------------------------------------.

then it makes 2 files
DupeDirs.db-journal
DupeFiles.db-journal

thats all.. it doesnt update the dupedb's..

sometimes i also get this

(14:15:20) [1] site rebuild
(14:15:20) [1] 200-.-[DupeUpdate]-----------------------------------------------------------.
(14:15:20) [1] 200-| Updating dupe database from: J:/APPS |
(14:15:20) [1] 200 Command successful.

only the first section..
but its not updated.. :x
takes 2 mins.. then site chrash.

worked yesterday, but i decided to remove requests from rebuild.
so i deleted the db's, created new and voila.. :x

solution?
:>

this is from systemerror.log

05-28-2006 14:52:34 "..\scripts\nxTools\nxDupe.tcl" terminated abnormally
--------------------------- ErrorInfo ----------------------------
database is locked
while executing
"DirDb eval {BEGIN; DELETE FROM DupeDirs;}"
(procedure "RebuildDb" line 16)
invoked from within
"RebuildDb"
("REBUILD" arm line 2)
invoked from within
"switch -- $event {
DUPELOG {
set virtualPath [GetPath $pwd [join [lrange $argList 2 end]]]
if {[IsTrue $dupe(CheckDirs..."
(procedure

EDIT:
i forgot a close bracket in nxtools.cfg..

and patience is a virtue.. :>

[zOrP]

would be nice with a site msg function in next version..

for filled and wiped reqs.. :>

[neoxed]

No, I won't add a message-board function to my script, it's completely unnecessary. If you really need one, there are plenty of existing message-board scripts.

[zOrP]

true.. its not really needed.

Only for filled reqs..

thnx anyway