Advertisement
Guest User

Untitled

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