ioShareDB

[darkone]

It isn't certain how functional api i've created is.. (it should cover everything, but since I've never tested it - it's possible that i've missed something)

[rozwellite]

Groups slots are also being messed up. Doesn't seem to keep the leech slots. Once a user gives the leech spot then its turns the slots for leech to 0.

[Mouton]

That's the expected behaviour of ioFTPD.
Leech and group slots and decremented when used.
Group slots are refunded (incremented) on deluser, but leech slots are not refunded, to prevent leech slots rotation.

[rozwellite]

Okay thanks, I just didn't notice with the regular io db. I guess I just wasn't paying as close attention.

[rozwellite]

ZodMan is been awhile since we have heard anything from u. Just wondering if u had any news for us. Thanks

[ZodMan]

There have been some delays on v1.0.0 due to limited time.
The code for v1.0.0 has been ready for some time now,
but I haven't done all the testing yet.

New in v1.0.0
- Local cache
- Sync cache
- Improved error and debug logging
- Username & password support for odbc connection
- Bug fixes

I will probably have some time later on today to do some testing.

[rozwellite]

Well dont work too hard its xmas and all. Merry Xmas to u!!!

[Lathieza]

got a problem with the shareddb / iobanana

226-CRC Checked: File is OK!
226-resolvePath 1: Error opening file 'c:\ioFTPD\users\445'
226-resolvePath 1: Error opening file 'c:\ioFTPD\users\445'

i get this after transferring a file
seems iobanana checks on hd for userfile instead of in
the shared db

how can i fix this ?



using:

ioftpd 5.3.9r / ioBanana 18free / ioA

[neoxed]

Originally posted by Lathieza
got a problem with the shareddb / iobanana

226-CRC Checked: File is OK!
226-resolvePath 1: Error opening file 'c:\ioFTPD\users\445'
226-resolvePath 1: Error opening file 'c:\ioFTPD\users\445'

i get this after transferring a file
seems iobanana checks on hd for userfile instead of in
the shared db

how can i fix this ?

using:

ioftpd 5.3.9r / ioBanana 18free / ioA

ioBanana doesn't work with a shared DB as it relys on user files for changing/editing credits/stats etc.

[Mouton]

Indeed.
I gave Harm new code for all the functions that required to read userfiles and groupfiles. He said he would probably use those in next version.
ioB (my branch) works fine with ioSharedDb.

[Harm]

Most of them are already implemented in my "beta" version. But I am adding networked drives support too (+ some other nice features) and I need some more time.

[Poema]

Could someone give me example line to read out the values dircectly in the sql database?

I dont understand the TINYBLOB type fields.

Why?

Because /msg sitebot !invite user pass is not working.
So i need a new invite script.

I use fbsql(.dll) for windrop to connect a database within TCL.

#### example test
sql connect 1.2.3.4 sqluser sqlpassword
sql selectdb ioftpd
sql startquery "SELECT * FROM users LIMIT 0,5" -array results
while {[sql fetchrow] != ""} {
set user $results(name)
set flags $results(flags)
set ratio $results(ratio)
set credits $results(credits)
set daydn $results(daydn)


if {$user != ""} {
putquick "PRIVMSG $chan :\002DBTEST\002 ( User: $user has flags: $flags ratio: $ratio credits: $credits daydn: $daydn)"
}
}
sql endquery
sql disconnect
######

Respond:
DBTEST ( User: Poema has flags: 1 ratio: credits: ~4< daydn: )


So i need to know how i get readable text out of the TINYBLOB fields and need to know how the password of the user is stored.
Still SHA1 or MD5 or whatever...

Thanx for reading.

[ADDiCT]

blob = binary large object
i guess all u need to do is convert the (combined) binary characters to a long integer

in your example:
the blob contains '~4<'
'~' = (dec) 126 = (hex) 7E
'4' = (dec) 52 = (hex) 34
'<' = (dec) 60 = (hex) 3C
value = 126 * 256^2 + 52 * 256 + 60 = 8270908 bytes
or
value = 60 * 256^2 + 52 * 256 + 126 = 3945598 bytes
not sure which one is the right one

[Poema]

Bah Why he did not use normal table fields :S
Too complex to build TCL code i think.

I think its a nice start for userdb sharing but a lot of work must be done before it works 100% (And compatible with other site bot scripts.. maybe a new version ioBanana needed, version for shared db and a version for non shared db)

So get rid of TINYBLOB fields and use normal VARCHAR fields i can read :P l. Only important thing is to store user passwords as MD5.

[Mouton]

blob ares more efficient that varchars, thus his choice.
and u're not suspposed to read the db directly. ask io to give u the user's pwd, and it will work (through shared mem).