sugestion

Post by **caesar** » Thu Dec 25, 2003 5:52 pm

I have an database (actualy an .txt file with some links in it) and I vote them once per 24 hours. It's from an online game to help my alliance. I need an sugestion on how should I mark them when I vote one link and then to get from there only the ones that have passed the 24 hours limit. Also, how should I save the votes, in an array and then after 15 minutes or something in the file or directly to it? Any recomandations?

I've stucked at the hours part, since there is no 24:00 hour only an 00:00 one, so an 01:00 will screw my thing down. I was thinging in calculating the difference betwen this two like 23:00 - the time it got voted and add 1 hour to the result. I'm kinda clue less, no ideeas from where to start..

GodOfSuicide · Post by **GodOfSuicide** » Thu Dec 25, 2003 6:04 pm

what do you mean by vote ? you rate them or something like that ?

btw, for the time : add [unixtime] output infront of the URL when you save it for a textfile, when you check you watch if it's older than 24h -> delete

Post by **caesar** » Thu Dec 25, 2003 6:08 pm

Vote as in click the link

duration [unixtime] = 34 years 1 day 22 hours 6 minutes 59 seconds

How the bloddy hell will that help me? Also, this 24 hours limit must be done automaticly by the eggdrop, not by me

GodOfSuicide · Post by **GodOfSuicide** » Thu Dec 25, 2003 6:21 pm

when you add the url to the database add the current [unixtime] (NOT duration) in front / after it
then you generate a timer that checks how much time passed between the current [unixtime] and the var you have in front / after your url.
so you can check when it's been added and take the consequences

Post by **caesar** » Thu Dec 25, 2003 6:25 pm

Umm.. like comparing if the unixtime from the link is let's say 34 years 1 day 22 hours 6 minutes 59 seconds and my current unixtime is 34 years 2 days 22 hours 6 minutes 59 then it should be working fine, I guess. Neat. Thanks for the lil tip. Also, no need for timers. Just an 15 minutes check or even an check on the spot when I do clicks and want to see thouse that have passed the 24 hours limit. Thank you.

Post by **caesar** » Thu Dec 25, 2003 7:31 pm

Code: Select all

proc bla {} {
set list [split [read [set f [open "koc.db" r]]][close $f] \n]
foreach bla $list {
putlog [duration [expr [unixtime] - [lindex $bla 1]]]
}
}

What the bloddy hell should I do now to get ridd of the annoyng "Tcl error: syntax error in expression "1072394717 - ": premature end of expression" msg?

Papillon · Post by **Papillon** » Fri Dec 26, 2003 7:33 am

that error means that there is no 2nd element in your list
are you sure $bla is a list?
do a check on what the $list/$bla contains

GodOfSuicide · Post by **GodOfSuicide** » Fri Dec 26, 2003 7:58 am

caesar wrote:Umm.. like comparing if the unixtime from the link is let's say 34 years 1 day 22 hours 6 minutes 59 seconds and my current unixtime is 34 years 2 days 22 hours 6 minutes 59 then it should be working fine, I guess.

did you listen ? I said NOT to use duration...
take the current [unixtime] (NOT DURATION), substract the old one from it

that looks some kinda like this:
current time - old time = x
1072443286 - 1072443256 = 30

if x >= 86400 -> older than 24h
(correct me if the value is wrong, thats 60 * 60 * 24)

Post by **caesar** » Fri Dec 26, 2003 11:18 am

GodOfSuicide : Well.. calculating the duration betwen them or doing what you've said seems to me to be the same thing, at least for me dose, and mine looks a lot easier.

Damn.. /me slaps itself.. I wonder how the heck did I forgot to add the [unixtime] thing there.. umm.. *problem* fixed.

GodOfSuicide · Post by **GodOfSuicide** » Fri Dec 26, 2003 2:14 pm

hehe

let's have a look at it when it's finished, ok ?

stdragon · Post by **stdragon** » Fri Dec 26, 2003 3:29 pm

"sugestion"? I think this post might have to be deleted ;)

arcane · Post by **arcane** » Fri Dec 26, 2003 4:10 pm

stdragon wrote:"sugestion"? I think this post might have to be deleted

yeah, it has to be "suggestion"

Post by **caesar** » Fri Dec 26, 2003 4:24 pm

Heh.. I was hungry and I've eat an letter..

Edit: Now an "open" problem. Seems that it adds an blank line after adding the link in the file, and again cos of that the "premature end of expression" pops-out his ugly face

.. so, any suggestions on how should I get ridd of the blank line?

Code: Select all

proc my:click {nick uhost hand chan text} {
  set list [split [read [set f [open "koc.db" r]]][close $f] \n] 
  foreach bla $list { 
    if {[expr [unixtime] - [lindex $bla 1]] >= 86400} {
      putserv "PRIVMSG $chan :[lindex $bla 0]"
    } 
  }
}

As you can see I've folowed your advice GodOfSuicide, cos yours at another close look seems a lot easier that what I had in mind.

GodOfSuicide · Post by **GodOfSuicide** » Fri Dec 26, 2003 5:32 pm

caesar wrote:Heh.. I was hungry and I've eat an letter..

i'd rather delete it for poor subject line but ok...

Edit: Now an "open" problem. Seems that it adds an blank line after adding the link in the file

that proc doesnt add anything to the file, it's just reading from it.
if you have got blank lines just check for them..like "are there 2 words ?" "is the line != \n ?" etc (i'm sorry i cannot provide more help cos i dont see the real problem)

As you can see I've folowed your advice GodOfSuicide, cos yours at another close look seems a lot easier that what I had in mind.

you're welcome

Post by **caesar** » Sat Dec 27, 2003 4:18 am

The link is added "normaly" in the file like:

Code: Select all

set f [open "koc.db" a]
puts $f "[lindex [split $text] 0] [unixtime]" 
close $f

Yes I know, that proc just reads from that file and it's suposed to not read the blank ones but it dose..