Skip to content

Instantly share code, notes, and snippets.

@PEMapModder

PEMapModder/migrater.sql Secret

Created Sep 9, 2015
Embed
What would you like to do?
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.