# constraint failure (no sys_name most likely) - skip the item
continue
for num in range(1, 10):
for i in range(1, 4):
typeid = v['basetype' + str(num) + '_' + str(i)]
typeval = v['basetypevalue' + str(num) + '_' + str(i)]
if typeid != 0 and typeid != 214 and typeid != 216 and typeid != 215: # XXXRS itemset 610312 has this
cur.execute('INSERT INTO suit_bonus (guid, itemcount, ordernum, typeid, value) VALUES (%s,%s,%s,%s,%s)', (k, num + 1, i, typeid, typeval))
try:
for i in range(1, 11):
suitlist = v['suitlist' + str(i)]
if suitlist != 0:
# check for weapon or armor
cur.execute("SELECT NULL FROM weapon WHERE guid=%s", (suitlist, ))
if cur.fetchone():
cur.execute('INSERT INTO suit_itemlist (suitid, ordernum, weaponid) VALUES (%s,%s,%s)', (k, i, suitlist))
else:
cur.execute('INSERT INTO suit_itemlist (suitid, ordernum, armorid) VALUES (%s,%s,%s)', (k, i, suitlist))
except DBConnection.IntegrityError:
# constraint failure (no armor/weapon) - skip the item
conn.rollback()
continue
conn.commit()
conn.close()
# vim:set ts=2 sw=2:
