Last active
December 20, 2016 15:12
-
-
Save games647/a3ab32af897320a905e60bb9e5a1b0e0 to your computer and use it in GitHub Desktop.
Import the auto in plugin database to the fastlogin database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
INSERT INTO premium (Name, Premium, LastIp, UUID) SELECT | |
name AS Name, | |
/* Enable premium authentication only for those who want to be auto logged in, so | |
they have their cracked protection disabled */ | |
!protection AND premium AS Premium, | |
/* Not used at the moment */ | |
'' AS LastIp, | |
/* Remove the dashes - returns null if puuid is null too */ | |
REPLACE(puuid, '-', '') AS UUID | |
FROM gt_nicknames | |
/* Get the premium uuid */ | |
LEFT JOIN ( | |
/* Prevent duplicates */ | |
SELECT * FROM gt_uuids GROUP BY nickname_id | |
) uuids | |
ON gt_nicknames.id = uuids.nickname_id; | |
/* FastLogin will also make lookups on the uuid column for name changes | |
the old 1.6.2 version won't check if those user have premium enabled | |
so it could happen that a premium could steal the account if we don't do this | |
It seems the uuid is saved on autoin too if the player is cracked */ | |
UPDATE `premium` SET `UUID`=NULL WHERE PREMIUM=0; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
You save my life. Thank you so much 👍