diff options
| -rw-r--r-- | abfragen.sql | 20 | ||||
| -rw-r--r-- | megahal_bot.py | 3 | ||||
| -rw-r--r-- | proxy.py | 3 |
3 files changed, 24 insertions, 2 deletions
diff --git a/abfragen.sql b/abfragen.sql new file mode 100644 index 0000000..53ba62d --- /dev/null +++ b/abfragen.sql @@ -0,0 +1,20 @@ + +-- Ausdauernde + SELECT a.send_time - b.send_time AS "Dauer", date_trunc('day',a.send_time) + FROM ( SELECT MAX(send_time) AS send_time, from_ident + FROM omegle_messages + GROUP BY from_ident ) a + JOIN ( SELECT MIN(send_time) AS send_time, from_ident + FROM omegle_messages + GROUP BY from_ident ) b + ON a.from_ident = b.from_ident + WHERE a.send_time - b.send_time > interval '1 hour' +ORDER BY 1 DESC; + +-- Fleissigste + SELECT COUNT(*), from_ident, date_trunc('hour',MIN(send_time)) + FROM omegle_messages +GROUP BY from_ident + HAVING COUNT(*) > 10 +ORDER BY 1 DESC; + diff --git a/megahal_bot.py b/megahal_bot.py index c5a0f64..f1f3864 100644 --- a/megahal_bot.py +++ b/megahal_bot.py @@ -41,6 +41,7 @@ class MegahalBot(OmegleChat): if self.idlecount > 8: self.logger.info("Idle > 8. disconnect()") self.disconnect() + self.disconnect_event.set() else: self.logger.info("Idle count %s/8" % self.idlecount) self.respond("hey?") #restart the conv. @@ -61,7 +62,7 @@ class MegahalBot(OmegleChat): except: self.disconnect_event.set() return - time.sleep(random.randint(1,3)) + time.sleep(random.randint(2,5)) self.respond(message,prepend="\033[1A\033[2K\033[%sD"%(len(typestr))) #move up 1; delete line; move left %s def on_connect(self): @@ -34,7 +34,8 @@ class OmegleProxyChat(OmegleChat): try: self.disconnect() except: - self.disconnect_event.set() + pass + self.disconnect_event.set() else: self.logger.info("Idle count %s/8" % self.idlecount) |