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. :p

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
:)