convert unixtime into human readable time[SOLVED]

[speechles]

Code: Select all

if {[string match $chan "#blah"]}{set limit 5} 

!=

Code: Select all

if {[string match $chan "#somechannel"]} {set limit 5}

Notice the spacing in mine.. this is there for a reason.

[ztian299]

Really, didn't know that space was that important! thanks again speechles

[ztian299]

is it possible to have a select query like this:

set count [mysql $dbconnect "SELECT COUNT(*) FROM table WHERE user LIKE 'blah%' ORDER BY time DESC LIMIT 5" -flatlist]
if {$count == 0} {set user "No user found"}
putserv "PRIVMSG $chan :User:$count"

How would this if-loop look like? i know that one wont work, thats why im asking here

[nml375]

Using the same "rules" as mentioned before, this should work as long as your query is proper.

Code: Select all

set count [mysqlsel $dbconnect "SELECT COUNT(*) FROM table WHERE user LIKE 'blah%' ORDER BY time DESC LIMIT 5" -flatlist]
if {[lindex $count 0] == 0} {set user "No user found"}
putserv "PRIVMSG $chan :User:$count"

[ztian299]

Again some problems..
I've tried 2-3 blowcrypt scripts from tcl-archive and google. And all return

Tcl error [encryptedincominghandler]: can't read "display": no such variable

the if-loop is like this:

Code: Select all

if {[lindex $count 0] == 0} {set display "0"}

Why? tried to change the stuff inside "" but doesnt help much
Got told that it's not blowcrypt script. It's the if-loop. How?