From 51ea9c0580a19f185660dce3dcb6325e87d8ce15 Mon Sep 17 00:00:00 2001 From: yvesf Date: Sat, 13 Jun 2009 08:43:43 +0000 Subject: asd git-svn-id: http://xapek.org/svn/common/omegle@1131 d0e8fea9-7529-0410-93fb-d39fd5b9c1dd --- megahal_bot.py | 20 +++++++++++++++----- 1 file changed, 15 insertions(+), 5 deletions(-) (limited to 'megahal_bot.py') diff --git a/megahal_bot.py b/megahal_bot.py index 9e70505..c5a0f64 100644 --- a/megahal_bot.py +++ b/megahal_bot.py @@ -108,7 +108,6 @@ Argumente: AND NOT ( message ILIKE '%www.%' OR message ILIKE '%http%' OR message ILIKE '%@%.%') - ORDER BY from_ident||to_ident, send_time; ;""", "offensive": """SELECT message FROM omegle_messages @@ -125,8 +124,7 @@ Argumente: AND LENGTH(message) < 35 AND NOT ( message ILIKE '%www.%' OR message ILIKE '%http%' - OR message ILIKE '%@%.%') - ORDER BY from_ident||to_ident, send_time;""", + OR message ILIKE '%@%.%');""", "offensive-large": """SELECT message FROM omegle_messages WHERE from_ident in ( SELECT from_ident FROM omegle_messages @@ -144,7 +142,19 @@ Argumente: AND NOT ( message ILIKE '%www.%' OR message ILIKE '%http%' OR message ILIKE '%@%.%') );""", - + "serious": + """SELECT message + FROM omegle_messages om1 + WHERE ( SELECT COUNT(*) + FROM omegle_messages om2 + WHERE ( om1.from_ident = om2.from_ident + OR om1.to_ident = om2.from_ident) + AND (om1.send_time - om2.send_time > interval '-2 hours' + AND om1.send_time - om2.send_time < interval '2 hours')) > 25 + AND LENGTH(message) < 30 + AND NOT ( message ILIKE '%www.%' + OR message ILIKE '%http%' + OR message ILIKE '%@%.%');""", } sqlKey = "standard" dbname = "omegle" @@ -205,7 +215,7 @@ Argumente: while True: event.wait(0.5) if event.isSet(): - print "partner" + print "disconnect_event set" break except KeyboardInterrupt: print "CTRL-C pressed, exiting" -- cgit v1.2.1