summaryrefslogtreecommitdiffstats
path: root/abs/core/supplemental-web/contents/calllog.py
diff options
context:
space:
mode:
Diffstat (limited to 'abs/core/supplemental-web/contents/calllog.py')
-rw-r--r--abs/core/supplemental-web/contents/calllog.py16
1 files changed, 8 insertions, 8 deletions
diff --git a/abs/core/supplemental-web/contents/calllog.py b/abs/core/supplemental-web/contents/calllog.py
index 908a9c6..9a13e14 100644
--- a/abs/core/supplemental-web/contents/calllog.py
+++ b/abs/core/supplemental-web/contents/calllog.py
@@ -17,29 +17,29 @@ def main(argv):
cursor.execute("select name,number,count(number) as '# calls' from cid group by number,name order by '# calls' DESC limit 20;")
result = cursor.fetchall()
-
-#Top shows
+
+#Top shows
#print '<div id="content"> <p></p>'
print '<div> <p></p>'
print '<table class="calllog">'
print "Top 20 callers"
searchstring='''<td> <a href="http://www.google.com/search?q=%s" > %s </a> </td> '''
- cursor.execute("select name,number,count(number) as '# calls' from cid group by number,name order by '# calls' DESC limit 20;")
+ cursor.execute("select name,number,count(number) from cid group by number,name order by count(number) DESC limit 20;")
result = cursor.fetchall()
for row in result:
print " <tr>"
#print " <td>",row[0],"</td>"
- print searchstring % (row[0], row [0])
+ print searchstring % (row[0], row [0])
print " <td>",row[2],"</td>"
#print " <td>",row[1],"</td>"
- print searchstring % (row[1], row [1])
+ print searchstring % (row[1], row [1])
print " </tr>"
#print "%40s %26s %10s" %(row[0],row[2],row[1])
print "</table>"
print "</div>"
#Top categorys
-
+
print '<br>'
print '<br>'
#print '<div id="content"> <p></p>'
@@ -54,9 +54,9 @@ def main(argv):
print " <td> %s </td>" %(row[0])
print " <td>",row[1],"</td>"
#print " <td>",row[2],"</td>"
- print searchstring % (row[2], row [2])
+ print searchstring % (row[2], row [2])
#print " <td>",row[3],"</td>"
- print searchstring % (row[3], row [3])
+ print searchstring % (row[3], row [3])
print " </tr>"
# print "%26s %26s %26s %26s " %(row[0],row[1],row[2],row[3])
print "</table>"