Old 12-17-2003, 08:33 PM   #31
darkone
Disabled
FlashFXP Registered User
ioFTPD Administrator
 
darkone's Avatar
 
Join Date: Dec 2001
Posts: 2,230
Default

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)
darkone is offline   Reply With Quote
Old 12-21-2003, 02:29 PM   #32
rozwellite
Member
ioFTPD Registered User
 
Join Date: May 2003
Posts: 37
Default

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.
rozwellite is offline   Reply With Quote
Old 12-21-2003, 10:04 PM   #33
Mouton
Posse Member
Ultimate Scripter
ioFTPD Administrator
 
Join Date: Dec 2002
Posts: 1,956
Default

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.
Mouton is offline   Reply With Quote
Old 12-21-2003, 10:07 PM   #34
rozwellite
Member
ioFTPD Registered User
 
Join Date: May 2003
Posts: 37
Default

Okay thanks, I just didn't notice with the regular io db. I guess I just wasn't paying as close attention.
rozwellite is offline   Reply With Quote
Old 12-24-2003, 01:08 PM   #35
rozwellite
Member
ioFTPD Registered User
 
Join Date: May 2003
Posts: 37
Default

ZodMan is been awhile since we have heard anything from u. Just wondering if u had any news for us. Thanks
rozwellite is offline   Reply With Quote
Old 12-25-2003, 05:15 AM   #36
ZodMan
Junior Member
ioFTPD Registered User
 
Join Date: Oct 2003
Posts: 6
Default

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.
ZodMan is offline   Reply With Quote
Old 12-25-2003, 01:02 PM   #37
rozwellite
Member
ioFTPD Registered User
 
Join Date: May 2003
Posts: 37
Default

Well dont work too hard its xmas and all. Merry Xmas to u!!!
rozwellite is offline   Reply With Quote
Old 12-27-2003, 08:26 PM   #38
Lathieza
Junior Member
 
Join Date: Jan 2003
Posts: 13
Default

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
Lathieza is offline   Reply With Quote
Old 12-27-2003, 10:04 PM   #39
neoxed
Too much time...
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: May 2003
Posts: 1,326
Default

Quote:
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.
neoxed is offline   Reply With Quote
Old 12-28-2003, 05:47 AM   #40
Mouton
Posse Member
Ultimate Scripter
ioFTPD Administrator
 
Join Date: Dec 2002
Posts: 1,956
Default

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.
Mouton is offline   Reply With Quote
Old 12-28-2003, 07:05 AM   #41
Harm
Too much time...
Ultimate Scripter
 
Join Date: Jul 2003
Posts: 1,430
Default

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.
Harm is offline   Reply With Quote
Old 12-28-2003, 09:44 AM   #42
Poema
Junior Member
 
Join Date: Dec 2003
Posts: 4
Default

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.
Poema is offline   Reply With Quote
Old 12-28-2003, 09:49 AM   #43
ADDiCT
Senior Member
FlashFXP Beta Tester
ioFTPD Scripter
 
Join Date: Aug 2003
Posts: 517
Default

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
ADDiCT is offline   Reply With Quote
Old 12-28-2003, 10:09 AM   #44
Poema
Junior Member
 
Join Date: Dec 2003
Posts: 4
Default

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.
Poema is offline   Reply With Quote
Old 12-28-2003, 10:14 AM   #45
Mouton
Posse Member
Ultimate Scripter
ioFTPD Administrator
 
Join Date: Dec 2002
Posts: 1,956
Default

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).
Mouton is offline   Reply With Quote
Reply

Tags
gorups, iosharedb, module, user, users

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 09:18 AM.

Parts of this site powered by vBulletin Mods & Addons from DragonByte Technologies Ltd. (Details)