diff options
| author | yvesf <yvesf@d0e8fea9-7529-0410-93fb-d39fd5b9c1dd> | 2009-06-13 08:43:43 +0000 |
|---|---|---|
| committer | yvesf <yvesf@d0e8fea9-7529-0410-93fb-d39fd5b9c1dd> | 2009-06-13 08:43:43 +0000 |
| commit | 51ea9c0580a19f185660dce3dcb6325e87d8ce15 (patch) | |
| tree | 9f37da9a4338bc0bb48149d235c44fcf75849dbf /megahal_bot.py | |
| parent | 92745d835fcf2139556fda9c8aa252471e4cb4de (diff) | |
| download | omegle-51ea9c0580a19f185660dce3dcb6325e87d8ce15.tar.gz omegle-51ea9c0580a19f185660dce3dcb6325e87d8ce15.zip | |
asd
git-svn-id: http://xapek.org/svn/common/omegle@1131 d0e8fea9-7529-0410-93fb-d39fd5b9c1dd
Diffstat (limited to 'megahal_bot.py')
| -rw-r--r-- | megahal_bot.py | 20 |
1 files changed, 15 insertions, 5 deletions
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" |