Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import getpass, MySQLdb, re
- conn = MySQLdb.connect(host = raw_input("Hostname: "), port = int(raw_input("Port number: ")), user = raw_input("Username: "), passwd = getpass.getpass(), db = raw_input("DB name: "))
- db = conn.cursor()
- db.execute("SELECT * FROM zerotolerance")
- rowsToInsert = []
- steamIdRegex = re.compile("^STEAM_[0-7]:[01]:\\d+$")
- for row in db.fetchall():
- id, type, punished_id, punished_name, punisher_id, punisher_name, remover_id, remover_name, start_time, end_time, removal_time, reason, removal_reason = row
- if type == 'Unknown':
- continue
- if end_time == 0 or end_time == start_time:
- length = 0
- else:
- length = end_time - start_time
- if punisher_id == 'Server':
- punisher_id = 'Console'
- rowsToInsert.append((type.lower(), punished_name, punished_id, "", punisher_name, punisher_id, remover_id, remover_name, start_time, length, removal_time, reason, removal_reason, -1))
- insertQuery = "INSERT INTO sourcepunish_punishments (Punish_Type, Punish_Player_Name, Punish_Player_ID, Punish_Player_IP, Punish_Admin_Name, Punish_Admin_ID, UnPunish_Admin_ID, UnPunish_Admin_Name, Punish_Time, Punish_Length, UnPunish_Time, Punish_Reason, UnPunish_Reason, Punish_Server_ID) VALUES "
- for row in rowsToInsert:
- insertQuery += '('
- for i in range(0, len(row)):
- element = row[i]
- if isinstance(element, str):
- insertQuery += '\'' + conn.escape_string(element) + '\''
- elif isinstance(element, int) or isinstance(element, long):
- insertQuery += str(element)
- if i + 1 != len(row):
- insertQuery += ', '
- insertQuery += '),\n'
- insertQuery = insertQuery[:-2] + ';'
- print insertQuery
- if raw_input("Are you sure? [y/N] ") == 'y':
- db.execute(insertQuery)
- print 'Done!'
- else:
- print 'Okay, exiting.'
Advertisement
Add Comment
Please, Sign In to add comment