migrater.sql

INSERT INTO theta.users (uid, name, nicks, lastip, status, status_ip, status_port, lastses, authuuid, coins, hash, oldhash, pwprefix, pwlen, registration, laston, ontime, config, lid, skin1, skin2, lastgrind, rank, warnpts, lastwarn, tid, teamrank, teamjoin, teampts, ignorelist, email, emailkey, emailauth, purchase_code, spleef_init, spleef_wins, spleef_winlosers, spleef_losses, spleef_losetotal, spleef_loseleft, spleef_draws, spleef_drawtotal, spleef_drawleft, pvp_init, pvp_kills, pvp_deaths, pvp_maxstreak, pvp_curstreak, pvp_kit)
SELECT
	uid, primaryname, CONCAT('|', names),
	lastip, 0, '', 0, 1, '',
	IF(coins < 100, 0, (coins - 100) * 10)
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND helmet >= 4) * 7500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND helmet >= 3) * 6000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND helmet >= 2) * 1250
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND helmet >= 1) * 250
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND chestplate >= 4) * 7500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND chestplate >= 3) * 5000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND chestplate >= 2) * 2000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND chestplate >= 1) * 400
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND leggings >= 4) * 35000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND leggings >= 3) * 8750
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND leggings >= 2) * 1750
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND leggings >= 1) * 350
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND boots >= 4) * 7500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND boots >= 3) * 5000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND boots >= 2) * 1000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND boots >= 1) * 200
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND weapon >= 2) * 7500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND weapon >= 1) * 2500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND food >= 5) * 25000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND food >= 4) * 15000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND food >= 3) * 8500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND food >= 2) * 2500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND food >= 1) * 750
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 8) * 100000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 7) * 50000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 6) * 30000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 5) * 20000
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 4) * 2500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 3) * 1500
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 2) * 750
	+ 5 * (SELECT COUNT(*) FROM kitpvp_kits WHERE uid=players.uid AND arrows >= 1) * 500
	,
	'', hash, '~', 0,
	registry,	lastonline,ontime,
	0x80 | 0x40 | 0x20 | IF(players.notag = 1, 0, 0x10) | IF(ipconfig = 1, 4, 5),
	-1,
	NULL, NULL ,
	lastgrind,
	rank,
	0,
	0,
	tid, teamrank, teamjointime, 0,
	ignoring,
	'NOTSET', NULL, 0, (SELECT purchase_code FROM account_settings WHERE uid=old.players.uid),
	registry, (SELECT wins FROM spleef WHERE uid=players.uid), 2, (SELECT losses FROM spleef WHERE uid=players.uid), 8, 2, (SELECT draws FROM spleef WHERE uid=players.uid), 8, 2,
	registry, (SELECT kills FROM kitpvp WHERE uid=players.uid), (SELECT deaths FROM kitpvp WHERE uid=players.uid), 0, 0, NULL
FROM old.players;