SELECT sikepuri_downlog.sikepuri_id AS sikepuri_id, COUNT(*) AS down_count, sikepuri.title AS sikepuri_title, sikepuri.creater AS sikepuri_creater FROM sikepuri_downlog, sikepuri WHERE 1310266968 <= sikepuri_downlog.time AND sikepuri_downlog.time <= 1310276968 AND sikepuri_downlog.sikepuri_id = sikepuri.id GROUP BY sikepuri_downlog.sikepuri_id ORDER BY down_count DESC
SELECT sikepuri_downlog.sikepuri_id AS sikepuri_id, COUNT(*) AS down_count, sikepuri.title AS sikepuri_title, sikepuri.creater AS sikepuri_creater, classdata.name1, COUNT(DISTINCT classdata.id) AS classdata_count FROM sikepuri_downlog, sikepuri LEFT JOIN sikepuri_link ON sikepuri.id = sikepuri_link.sikepuri_id LEFT JOIN classdata ON sikepuri_link.classdata_id = classdata.id WHERE 1310266968 <= sikepuri_downlog.time AND sikepuri_downlog.time <= 1310276968 AND sikepuri_downlog.sikepuri_id = sikepuri.id GROUP BY sikepuri_downlog.sikepuri_id ORDER BY down_count DESC, sikepuri_id ASC
6.3 Timers — HTML5 http://www.w3.org/TR/html5/timers.html#dom-windowtimers-settimeout
---
If the currently running task is a task that was created by the setTimeout() method, and timeout is less than 4, then increase timeout to 4.
-----
4ms以下の場合は4msになるらしい。これはいい情報だ。
SMTPの仕様に従っていない、SMTPもどきサーバー。 by Ruby
-----
require 'socket'
require 'kconv'
def log(*str)
str.each{|s|
print s.to_s.tosjis
}
end
class String
def startwith(str)
self.slice(0, str.length) === str
end
end
gs = TCPServer.open(25)
addr = gs.addr
addr.shift
printf("server is on %s\n", addr.join(':'))
while true
Thread.start(gs.accept) do |s|
log s, " is accepted.\n"
s.write "220 OK\r\n"
line = s.gets
if line.startwith('EHLO')
s.write "502 ERR\r\n"
line = s.gets
end
if !line.startwith('HELO')
s.write "500 ERR\r\n"
s.close
return
end
s.write "250 OK\r\n"
while !(line = s.gets).startwith('DATA')
s.write "250 OK\r\n"
log line
end
s.write "354 ENTER\r\n"
log line
while !((line = s.gets) === ".\r\n")
log line
end
s.write "250 OK\r\n"
if !(line = s.gets).startwith('QUIT')
s.write "500 ERR\r\n"
s.close
return
end
s.write "221 CLOSE\r\n"
