if ($ClassID == 6) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n " . DeathKnightTransfer($GUID);
}
foreach ($json['glyphs'] as $key => $value) {
$GlyphID1 = _GetGlyphID($value[0][0]);
$GlyphID2 = _GetGlyphID($value[0][1]);
$GlyphID3 = _GetGlyphID($value[0][2]);
$GlyphID4 = _GetGlyphID($value[1][0]);
$GlyphID5 = _GetGlyphID($value[1][1]);
$GlyphID6 = _GetGlyphID($value[1][2]);
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* GLYPHS */ INTO `character_glyphs` VALUES (" . $GUID . "," . (int) $key . ",\n " . (int) $GlyphID1 . "," . (int) $GlyphID4 . "," . (int) $GlyphID5 . "," . (int) $GlyphID2 . "," . (int) $GlyphID6 . "," . (int) $GlyphID3 . ");";
}
foreach ($json['achiev'] as $key => $value) {
$achievement = $value['I'];
$date = $value['D'];
if (_CheckWrongOrNoAchievement($achievement)) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* ACHIEVEMENT */ INTO `character_achievement` VALUES (" . $GUID . ", " . (int) $achievement . ", " . (int) $date . ");";
}
}
$locale = trim(strtoupper($json['ginf']['locale']));
foreach ($json['rep'] as $key => $value) {
$reputation = $value['V'];
$faction = GetFactionID(mb_strtoupper($value['N'], 'UTF-8'), $locale);
if ($faction < 1 || $reputation < 1) {
continue;
}
$flag = $value['F'] + 1;
if ($faction == 1119 && $reputation > 1) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n " . SonsOfHordirTransfer($GUID);
}
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* REPUTATION */ INTO `character_reputation` VALUES (" . $GUID . ", " . $faction . ", " . (int) $reputation . "," . (int) $flag . ");";
if ($ClassID == 6) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n " . _DKMigration($GUID);
}
foreach ($json['glyphs'] as $key => $value) {
$GlyphID1 = _GetGlyphID($value[0][0]);
$GlyphID2 = _GetGlyphID($value[0][1]);
$GlyphID3 = _GetGlyphID($value[0][2]);
$GlyphID4 = _GetGlyphID($value[1][0]);
$GlyphID5 = _GetGlyphID($value[1][1]);
$GlyphID6 = _GetGlyphID($value[1][2]);
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* GLYPHS */ INTO `character_glyphs` VALUES (" . $GUID . "," . (int) $key . ",\n " . (int) $GlyphID1 . "," . (int) $GlyphID4 . "," . (int) $GlyphID5 . "," . (int) $GlyphID2 . "," . (int) $GlyphID6 . "," . (int) $GlyphID3 . ");";
}
foreach ($json['achiev'] as $key => $value) {
$AchievementID = $value['I'];
$date = $value['D'];
if (_CheckWrongOrNoAchievement($AchievementID)) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* ACHIEVEMENT */ INTO `character_achievement` VALUES (" . $GUID . ", " . (int) $AchievementID . ", " . (int) $date . ");";
}
}
$locale = trim(strtoupper($json['ginf']['locale']));
foreach ($json['rep'] as $key => $value) {
$reputation = $value['V'];
$faction = GetFactionID(mb_strtoupper($value['N'], 'UTF-8'), $locale);
if ($faction < 1 || $reputation < 1) {
continue;
}
$flag = $value['F'] + 1;
if ($faction == 1119 && $reputation > 1) {
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n " . _SOHMigration($GUID);
}
$QUERYFOREXECUTE = $QUERYFOREXECUTE . "\n INSERT IGNORE /* REPUTATION */ INTO `character_reputation` VALUES (" . $GUID . ", " . $faction . ", " . (int) $reputation . "," . (int) $flag . ");";
