blob: 7633c3f8678e2b9fc135ebdf242adfcaa29fef99 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
|
#!/usr/bin/python
import db
#TEMPLATE_PATH = "/var/www/scannerjammer.com/diornights/httpdocs/"
#f = file (TEMPLATE_PATH+"template.html", "r")
#template = f.read()
#f.close()
DB = db.db ()
sql = "SELECT * FROM dior_fb WHERE date > %s ORDER BY likes DESC"
DB.execute(sql, (db.now() - 86400*3))
rows = DB.cursor.fetchall ()
def is_image (url):
return url[-3:].lower() in ["gif","jpg","png"] or url[-4:].lower == "jpeg"
boxes = []
count = 0
for row in rows:
# 0 id 1 fbid 2 date 3 likes 4 comments 5 authorfbid 6 author 7 link 8 description
if row[3] < 1:
continue
if is_image (row[7]):
boxes.append("<div class='box'><img src='%s' /><br/>%s - %d likes</div>" % (row[7], row[6], row[3]))
count += 1
if count == 2:
boxes.append("""
<div id="feed" class="box">
<ul>
<li>Follow us @</li>
<li><a href="http://www.facebook.com/diornights"><img src="/img/icons/facebook_32.png" class="icon"></a></li>
<li><a href="http://twitter.com/diornights/"><img src="/img/icons/twitter_32.png" class="icon"></a></li>
<li><a href="http://vimeo.com/diornights"><img src="/img/icons/vimeo_32.png" class="icon"></a></li>
<!-- <li><a href="http://diornights.tumblr.com/"><img src="/img/icons/tumblr_32.png" class="icon"></a></li>
<li><a href="http://diornights.bandcamp.com/"><img src="/img/icons/bandcamp_32.png" class="icon"></a></li> -->
<li><a href="http://www.youtube.com/user/diornights"><img src="/img/icons/youtube_32.png" class="icon"></a></li>
</ul>
</div>
""")
#out = file(TEMPLATE_PATH+"index.html", "w")
#out.write( template.replace("%%REPORT%%", "".join(boxes)) )
#out.close ()
|
