You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
24 lines
563 B
Python
24 lines
563 B
Python
#!/usr/bin/python
|
|
|
|
import oursql
|
|
|
|
db = oursql.connect(host="localhost", user="root", passwd="", db="transfer")
|
|
c = db.cursor()
|
|
|
|
c.execute("SELECT * FROM servers")
|
|
servers = c.fetchall()
|
|
|
|
for server in servers:
|
|
if server[2] == 2 or server[2] == 4:
|
|
c.execute("SELECT * FROM entries WHERE `TargetNode` = ? AND `Position` = ?", (server[1], server[3]))
|
|
results = c.fetchall()
|
|
|
|
try:
|
|
vps = results[0]
|
|
except IndexError, e:
|
|
continue
|
|
|
|
if vps[6] == 3:
|
|
print "%s\t%s\t%s\t%s" % (server[1].ljust(26), str(vps[1]).ljust(6), vps[2].ljust(18), vps[3])
|
|
|