Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # -*- coding: utf-8 -*-
- prefix = "icq"
- dbHost = "127.0.0.1"
- dbUser = "root"
- dbPass = "password"
- dbName = "transport"
- from xml.dom import minidom
- import MySQLdb
- import sys, os
- if len(sys.argv) != 2:
- print "Zła liczba argumentów."
- sys.exit(0)
- connection = MySQLdb.connect(dbHost, dbUser, dbPass, dbName)
- for x in os.listdir(sys.argv[1]):
- dom = minidom.parse(x)
- uin = dom.getElementsByTagName('uin')[0].childNodes[0].data
- password = dom.getElementsByTagName('password')[0].childNodes[0].data
- jid = dom.getElementsByTagName('password')[0].childNodes[0].data
- c = connection.cursor()
- c.execute("""INSERT INTO %s_users (jid, uin, password, language, encoding, last_login, vip, online)
- VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')""" % (prefix, jid, uin, password, 'pl', 'utf8', '2011-06-16 21:02:38', '0', '1') )
- c.execute("SELECT id FROM %_users WHERE jid = '%s';" % (prefix, jid) )
- user_id = c.fetchone()[0]
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_avatars', '4', '1');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_chatstate', '4', '1');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_notify_email', '4', '0');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_transport', '4', '1');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'first_synchronization_done', '4', '1');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'reject_authorizations', '4', '0');""" % (user_id, prefix) )
- c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'save_files_on_server', '4', '0');""" % (user_id, prefix) )
- for node in dom.getElementsByTagName('contact'):
- c.execute("""INSERT INTO %s_buddies (user_id, uin, subscription, nickname, groups, flags) VALUES ('%s', '%s', '%s', '%s', 'Buddies', '0');""" %
- (prefix, user_id, node.attributes["uin"].value, node.attributes["subscribe"].value, node.attributes["uin"].value) )
- c.close()
- connection.commit()
- connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement