Advertisement
Guest User

Untitled

a guest
Sep 17th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. # -*- coding: utf-8 -*-
  2.  
  3. prefix = "icq"
  4. dbHost = "127.0.0.1"
  5. dbUser = "root"
  6. dbPass = "password"
  7. dbName = "transport"
  8.  
  9. from xml.dom import minidom
  10. import MySQLdb
  11. import sys, os
  12.  
  13. if len(sys.argv) != 2:
  14. print "Zła liczba argumentów."
  15. sys.exit(0)
  16.  
  17. connection = MySQLdb.connect(dbHost, dbUser, dbPass, dbName)
  18.  
  19. for x in os.listdir(sys.argv[1]):
  20. dom = minidom.parse(x)
  21.  
  22. uin = dom.getElementsByTagName('uin')[0].childNodes[0].data
  23. password = dom.getElementsByTagName('password')[0].childNodes[0].data
  24. jid = dom.getElementsByTagName('password')[0].childNodes[0].data
  25.  
  26. c = connection.cursor()
  27.  
  28. c.execute("""INSERT INTO %s_users (jid, uin, password, language, encoding, last_login, vip, online)
  29. VALUES ('%s', '%s', '%s', '%s', '%s', '%s', '%s')""" % (prefix, jid, uin, password, 'pl', 'utf8', '2011-06-16 21:02:38', '0', '1') )
  30.  
  31. c.execute("SELECT id FROM %_users WHERE jid = '%s';" % (prefix, jid) )
  32. user_id = c.fetchone()[0]
  33.  
  34. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_avatars', '4', '1');""" % (user_id, prefix) )
  35. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_chatstate', '4', '1');""" % (user_id, prefix) )
  36. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_notify_email', '4', '0');""" % (user_id, prefix) )
  37. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'enable_transport', '4', '1');""" % (user_id, prefix) )
  38. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'first_synchronization_done', '4', '1');""" % (user_id, prefix) )
  39. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'reject_authorizations', '4', '0');""" % (user_id, prefix) )
  40. c.execute("""INSERT INTO %s_users_settings (user_id, var, type, value) VALUES ('%s', 'save_files_on_server', '4', '0');""" % (user_id, prefix) )
  41.  
  42. for node in dom.getElementsByTagName('contact'):
  43. c.execute("""INSERT INTO %s_buddies (user_id, uin, subscription, nickname, groups, flags) VALUES ('%s', '%s', '%s', '%s', 'Buddies', '0');""" %
  44. (prefix, user_id, node.attributes["uin"].value, node.attributes["subscribe"].value, node.attributes["uin"].value) )
  45. c.close()
  46.  
  47. connection.commit()
  48. connection.close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement