Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- echo "<hr><h2>REPLACING TRYK GEAR IN DATABASE:</h2><hr>";
- // Database Connection Setup
- // -------------------------------------------------------
- $dbhost = '127.0.0.1';
- $dbname = 'exile';
- $dbuser = 'dbuser';
- $dbpass = 'dbpass';
- // -------------------------------------------------------
- $db_local = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
- $replacement_uniform = "Exile_Uniform_Woodland";
- $replacement_vest = "V_PlateCarrierGL_blk";
- $replacement_headgear = "H_HelmetLeaderO_ocamo";
- $replacement_backpack = "B_Carryall_oli";
- $tryk_uniforms = [
- "TRYK_HRP_UCP",
- "TRYK_HRP_USMC",
- "TRYK_HRP_khk",
- "TRYK_U_B_OD_OD_CombatUniform",
- "TRYK_U_B_OD_OD_R_CombatUniform",
- "TRYK_U_B_TANTAN_CombatUniform",
- "TRYK_U_B_TANTAN_R_CombatUniform",
- "TRYK_U_B_BLKBLK_CombatUniform",
- "TRYK_U_B_BLKBLK_R_CombatUniform",
- "TRYK_U_B_GRYOCP_CombatUniform",
- "TRYK_U_B_GRYOCP_R_CombatUniformTshirt",
- "TRYK_U_B_TANOCP_CombatUniform",
- "TRYK_U_B_TANOCP_R_CombatUniformTshirt",
- "TRYK_U_B_BLKOCP_CombatUniform",
- "TRYK_U_B_BLKOCP_R_CombatUniformTshirt",
- "TRYK_U_B_BLKTAN_CombatUniform",
- "TRYK_U_B_BLKTANR_CombatUniformTshirt",
- "TRYK_U_B_ODTAN_CombatUniform",
- "TRYK_U_B_ODTANR_CombatUniformTshirt",
- "TRYK_U_B_GRTAN_CombatUniform",
- "TRYK_U_B_GRTANR_CombatUniformTshirt",
- "TRYK_U_B_wood_CombatUniform",
- "TRYK_U_B_woodR_CombatUniformTshirt",
- "TRYK_U_B_wood3c_CombatUniform",
- "TRYK_U_B_wood3c_CombatUniformTshirt",
- "TRYK_U_B_MARPAT_WOOD_CombatUniform",
- "TRYK_U_B_MARPAT_WOOD_CombatUniformTshirt",
- "TRYK_U_B_WOOD_MARPAT_CombatUniform",
- "TRYK_U_B_WOOD_MARPAT_CombatUniformTshirt",
- "TRYK_U_B_woodtan_CombatUniform",
- "TRYK_U_B_woodtanR_CombatUniformTshirt",
- "TRYK_U_B_JSDF_CombatUniform",
- "TRYK_U_B_JSDF_CombatUniformTshirt",
- "TRYK_U_B_3CD_Delta_BDU",
- "TRYK_U_B_3CD_Delta_BDUTshirt",
- "TRYK_U_B_3CD_Ranger_BDU",
- "TRYK_U_B_3CD_Ranger_BDUTshirt",
- "TRYK_U_B_3CD_BLK_BDUTshirt",
- "TRYK_U_B_3CD_BLK_BDUTshirt2",
- "TRYK_U_B_ACU",
- "TRYK_U_B_ACUTshirt",
- "TRYK_U_B_MARPAT_Wood",
- "TRYK_U_B_MARPAT_Wood_Tshirt",
- "TRYK_U_B_MARPAT_Desert",
- "TRYK_U_B_MARPAT_Desert_Tshirt",
- "TRYK_U_B_MARPAT_Desert2",
- "TRYK_U_B_MARPAT_Desert2_Tshirt",
- "TRYK_U_B_3c",
- "TRYK_U_B_3cr",
- "TRYK_U_B_Sage_Tshirt",
- "TRYK_U_B_BLK3CD",
- "TRYK_U_B_BLK3CD_Tshirt",
- "TRYK_U_B_BLK",
- "TRYK_U_B_BLK_Tshirt",
- "TRYK_U_B_BLKTAN",
- "TRYK_U_B_BLKTAN_Tshirt",
- "TRYK_U_B_ODTAN",
- "TRYK_U_B_ODTAN_Tshirt",
- "TRYK_U_B_BLK_OD",
- "TRYK_U_B_BLK_OD_Tshirt",
- "TRYK_U_B_C01_Tsirt",
- "TRYK_U_B_C02_Tsirt",
- "TRYK_U_B_OD_BLK",
- "TRYK_U_B_OD_BLK_2",
- "TRYK_U_B_BLK_TAN_1",
- "TRYK_U_B_BLK_TAN_2",
- "TRYK_U_B_wh_tan_Rollup_CombatUniform",
- "TRYK_U_B_wh_OD_Rollup_CombatUniform",
- "TRYK_U_B_wh_blk_Rollup_CombatUniform",
- "TRYK_U_B_BLK_tan_Rollup_CombatUniform",
- "TRYK_U_B_BLK_OD_Rollup_CombatUniform",
- "TRYK_U_B_NATO_UCP_GRY_CombatUniform",
- "TRYK_U_B_NATO_UCP_GRY_R_CombatUniform",
- "TRYK_U_B_NATO_UCP_CombatUniform",
- "TRYK_U_B_NATO_UCP_R_CombatUniform",
- "TRYK_U_B_NATO_OCP_c_BLK_CombatUniform",
- "TRYK_U_B_NATO_OCP_BLK_c_R_CombatUniform",
- "TRYK_U_B_NATO_OCP_BLK_CombatUniform",
- "TRYK_U_B_NATO_OCP_BLK_R_CombatUniform",
- "TRYK_U_B_NATO_OCPD_CombatUniform",
- "TRYK_U_B_NATO_OCPD_R_CombatUniform",
- "TRYK_U_B_NATO_OCP_CombatUniform",
- "TRYK_U_B_NATO_OCP_R_CombatUniform",
- "TRYK_U_B_AOR1_Rollup_CombatUniform",
- "TRYK_U_B_AOR2_Rollup_CombatUniform",
- "TRYK_U_B_MTP_CombatUniform",
- "TRYK_U_B_MTP_R_CombatUniform",
- "TRYK_U_B_MTP_BLK_CombatUniform",
- "TRYK_U_B_MTP_BLK_R_CombatUniform",
- "TRYK_U_B_Woodland",
- "TRYK_U_B_Woodland_Tshirt",
- "TRYK_U_B_WDL_GRY_CombatUniform",
- "TRYK_U_B_WDL_GRY_R_CombatUniform",
- "TRYK_U_B_ARO1_GR_CombatUniform",
- "TRYK_U_B_ARO1_GR_R_CombatUniform",
- "TRYK_U_B_ARO1_GRY_CombatUniform",
- "TRYK_U_B_ARO1_GRY_R_CombatUniform",
- "TRYK_U_B_ARO1_CombatUniform",
- "TRYK_U_B_ARO1R_CombatUniform",
- "TRYK_U_B_ARO1_BLK_CombatUniform",
- "TRYK_U_B_ARO1_BLK_R_CombatUniform",
- "TRYK_U_B_ARO1_CBR_CombatUniform",
- "TRYK_U_B_ARO1_CBR_R_CombatUniform",
- "TRYK_U_B_ARO2_CombatUniform",
- "TRYK_U_B_ARO2R_CombatUniform",
- "TRYK_U_B_AOR2_BLK_CombatUniform",
- "TRYK_U_B_AOR2_BLK_R_CombatUniform",
- "TRYK_U_B_AOR2_OD_CombatUniform",
- "TRYK_U_B_AOR2_OD_R_CombatUniform",
- "TRYK_U_B_AOR2_GRY_CombatUniform",
- "TRYK_U_B_AOR2_GRY_R_CombatUniform",
- "TRYK_U_B_Snow_CombatUniform",
- "TRYK_U_B_Snowt",
- "TRYK_U_B_Denim_T_WH",
- "TRYK_U_B_Denim_T_BK",
- "TRYK_U_B_BLK_T_WH",
- "TRYK_U_B_BLK_T_BK",
- "TRYK_U_B_RED_T_BR",
- "TRYK_U_B_Denim_T_BG_WH",
- "TRYK_U_B_Denim_T_BG_BK",
- "TRYK_U_B_BLK_T_BG_WH",
- "TRYK_U_B_BLK_T_BG_BK",
- "TRYK_U_B_RED_T_BG_BR",
- "TRYK_U_B_fleece",
- "TRYK_U_B_fleece_UCP",
- "TRYK_U_B_UCP_PCUs",
- "TRYK_U_B_GRY_PCUs",
- "TRYK_U_B_Wood_PCUs",
- "TRYK_U_B_PCUs",
- "TRYK_U_B_UCP_PCUs_R",
- "TRYK_U_B_GRY_PCUs_R",
- "TRYK_U_B_Wood_PCUs_R",
- "TRYK_U_B_PCUs_R",
- "TRYK_U_B_PCUGs",
- "TRYK_U_B_PCUODs",
- "TRYK_U_B_PCUGs_gry",
- "TRYK_U_B_PCUGs_BLK",
- "TRYK_U_B_PCUGs_OD",
- "TRYK_U_B_PCUGs_gry_R",
- "TRYK_U_B_PCUGs_BLK_R",
- "TRYK_U_B_PCUGs_OD_R",
- "TRYK_U_Bts_GRYGRY_PCUs",
- "TRYK_U_Bts_UCP_PCUs",
- "TRYK_U_Bts_Wood_PCUs",
- "TRYK_U_Bts_PCUs",
- "TRYK_U_pad_j",
- "TRYK_U_pad_j_blk",
- "TRYK_U_pad_hood_Cl",
- "TRYK_U_pad_hood_Cl_blk",
- "TRYK_U_pad_hood_tan",
- "TRYK_U_pad_hood_Blk",
- "TRYK_U_pad_hood_CSATBlk",
- "TRYK_U_pad_hood_Blod",
- "TRYK_U_pad_hood_odBK",
- "TRYK_U_pad_hood_BKT2",
- "TRYK_hoodie_Blk",
- "TRYK_hoodie_FR",
- "TRYK_hoodie_Wood",
- "TRYK_hoodie_3c",
- "TRYK_T_camo_tan",
- "TRYK_T_camo_3c",
- "TRYK_T_camo_Wood",
- "TRYK_T_camo_wood_marpat",
- "TRYK_T_camo_Desert_marpat",
- "TRYK_T_camo_3c_BG",
- "TRYK_T_camo_Wood_BG",
- "TRYK_T_camo_wood_marpat_BG",
- "TRYK_T_camo_desert_marpat_BG",
- "TRYK_T_PAD",
- "TRYK_T_OD_PAD",
- "TRYK_T_TAN_PAD",
- "TRYK_T_BLK_PAD",
- "TRYK_T_T2_PAD",
- "TRYK_T_CSAT_PAD",
- "TRYK_U_nohoodPcu_gry",
- "TRYK_U_hood_nc",
- "TRYK_U_hood_mc",
- "TRYK_U_denim_hood_blk",
- "TRYK_U_denim_hood_mc",
- "TRYK_U_denim_hood_3c",
- "TRYK_U_denim_hood_nc",
- "TRYK_U_denim_jersey_blu",
- "TRYK_U_denim_jersey_blk",
- "TRYK_shirts_PAD",
- "TRYK_shirts_OD_PAD",
- "TRYK_shirts_TAN_PAD",
- "TRYK_shirts_BLK_PAD",
- "TRYK_shirts_PAD_BK",
- "TRYK_shirts_OD_PAD_BK",
- "TRYK_shirts_TAN_PAD_BK",
- "TRYK_shirts_BLK_PAD_BK",
- "TRYK_shirts_PAD_BLW",
- "TRYK_shirts_OD_PAD_BLW",
- "TRYK_shirts_TAN_PAD_BLW",
- "TRYK_shirts_BLK_PAD_BLW",
- "TRYK_shirts_PAD_YEL",
- "TRYK_shirts_OD_PAD_YEL",
- "TRYK_shirts_TAN_PAD_YEL",
- "TRYK_shirts_BLK_PAD_YEL",
- "TRYK_shirts_PAD_RED2",
- "TRYK_shirts_OD_PAD_RED2",
- "TRYK_shirts_TAN_PAD_RED2",
- "TRYK_shirts_BLK_PAD_RED2",
- "TRYK_shirts_PAD_BLU3",
- "TRYK_shirts_OD_PAD_BLU3",
- "TRYK_shirts_TAN_PAD_BLU3",
- "TRYK_shirts_BLK_PAD_BLU3",
- "TRYK_shirts_DENIM_R",
- "TRYK_shirts_DENIM_BL",
- "TRYK_shirts_DENIM_BK",
- "TRYK_shirts_DENIM_WH",
- "TRYK_shirts_DENIM_BWH",
- "TRYK_shirts_DENIM_RED2",
- "TRYK_shirts_DENIM_WHB",
- "TRYK_shirts_DENIM_ylb",
- "TRYK_shirts_DENIM_od",
- "TRYK_shirts_DENIM_R_Sleeve",
- "TRYK_shirts_DENIM_BL_Sleeve",
- "TRYK_shirts_DENIM_BK_Sleeve",
- "TRYK_shirts_DENIM_WH_Sleeve",
- "TRYK_shirts_DENIM_BWH_Sleeve",
- "TRYK_shirts_DENIM_RED2_Sleeve",
- "TRYK_shirts_DENIM_WHB_Sleeve",
- "TRYK_shirts_DENIM_ylb_Sleeve",
- "TRYK_shirts_DENIM_od_Sleeve",
- "TRYK_shirts_PAD_BL",
- "TRYK_shirts_OD_PAD_BL",
- "TRYK_shirts_TAN_PAD_BL",
- "TRYK_shirts_BLK_PAD_BL",
- "TRYK_U_taki_wh",
- "TRYK_U_taki_COY",
- "TRYK_U_taki_BL",
- "TRYK_U_taki_BLK",
- "TRYK_U_Bts_PCUGs",
- "TRYK_U_Bts_PCUODs",
- "TRYK_U_taki_G_WH",
- "TRYK_U_taki_G_COY",
- "TRYK_U_taki_G_BL",
- "TRYK_U_taki_G_BLK",
- "TRYK_U_B_PCUHs",
- "TRYK_U_B_PCUGHs",
- "TRYK_U_B_PCUODHs",
- "TRYK_B_USMC_R",
- "TRYK_B_USMC_R_ROLL",
- "TRYK_ZARATAKI",
- "TRYK_ZARATAKI2",
- "TRYK_ZARATAKI3",
- "TRYK_B_TRYK_UCP_T",
- "TRYK_B_TRYK_3C_T",
- "TRYK_B_TRYK_MTP_T",
- "TRYK_B_TRYK_OCP_T",
- "TRYK_B_TRYK_OCP_D_T",
- "TRYK_DMARPAT_T",
- "TRYK_C_AOR2_T",
- "TRYK_U_B_Sage_T",
- "TRYK_U_B_Wood_T",
- "TRYK_U_B_BLTAN_T",
- "TRYK_U_B_BLOD_T",
- "TRYK_OVERALL_flesh",
- "TRYK_OVERALL_nok_flesh",
- "TRYK_OVERALL_SAGE_BLKboots",
- "TRYK_OVERALL_SAGE_BLKboots_nk_blk",
- "TRYK_OVERALL_SAGE_BLKboots_nk",
- "TRYK_OVERALL_SAGE_BLKboots_nk_blk2",
- "TRYK_OVERALL_SAGE",
- "TRYK_SUITS_BLK_F",
- "TRYK_SUITS_BR_F",
- "TRYK_H_ghillie_top_headless3glass",
- "TRYK_shoulder_armor_BK",
- "TRYK_shoulder_armor_OD",
- "TRYK_shoulder_armor_CY",
- "TRYK_H_ghillie_top_headless3",
- "TRYK_U_B_PCUHsW",
- "TRYK_U_B_PCUHsW2",
- "TRYK_U_B_PCUHsW3",
- "TRYK_U_B_PCUHsW3nh",
- "TRYK_U_B_PCUHsW4",
- "TRYK_U_B_PCUHsW5",
- "TRYK_U_B_PCUHsW6"
- ];
- $tryk_vests = [
- "TRYK_Hrp_vest_ucp",
- "TRYK_V_PlateCarrier_JSDF",
- "TRYK_V_ArmorVest_AOR1",
- "TRYK_V_ArmorVest_AOR2",
- "TRYK_V_ArmorVest_coyo",
- "TRYK_V_ArmorVest_Brown",
- "TRYK_V_ArmorVest_CBR",
- "TRYK_V_ArmorVest_khk",
- "TRYK_V_ArmorVest_rgr",
- "TRYK_V_ArmorVest_green",
- "TRYK_V_ArmorVest_tan",
- "TRYK_V_ArmorVest_Delta",
- "TRYK_V_ArmorVest_Ranger",
- "TRYK_V_ArmorVest_AOR1_2",
- "TRYK_V_ArmorVest_AOR2_2",
- "TRYK_V_ArmorVest_coyo2",
- "TRYK_V_ArmorVest_Brown2",
- "TRYK_V_ArmorVest_cbr2",
- "TRYK_V_ArmorVest_khk2",
- "TRYK_V_ArmorVest_rgr2",
- "TRYK_V_ArmorVest_green2",
- "TRYK_V_ArmorVest_tan2",
- "TRYK_V_ArmorVest_Delta2",
- "TRYK_V_ArmorVest_Ranger2",
- "TRYK_V_PlateCarrier_blk",
- "TRYK_V_PlateCarrier_coyo",
- "TRYK_V_PlateCarrier_wood",
- "TRYK_V_PlateCarrier_ACU",
- "TRYK_V_TacVest_coyo",
- "TRYK_V_harnes_blk_L",
- "TRYK_V_harnes_od_L",
- "TRYK_V_harnes_TAN_L",
- "TRYK_V_PlateCarrier_blk_L",
- "TRYK_V_PlateCarrier_wood_L",
- "TRYK_V_PlateCarrier_ACU_L",
- "TRYK_V_PlateCarrier_coyo_L",
- "TRYK_V_ChestRig_L",
- "TRYK_V_ChestRig",
- "TRYK_V_Bulletproof",
- "TRYK_V_Bulletproof_BLK",
- "TRYK_V_Bulletproof_BL",
- "TRYK_V_IOTV_BLK",
- "TRYK_V_tacv1M_BK",
- "TRYK_V_tacv1MLC_BK",
- "TRYK_V_tacv1",
- "TRYK_V_tacv1_CY",
- "TRYK_V_tacv1_BK",
- "TRYK_V_tacv1_P_BK",
- "TRYK_V_tacv1_SHERIFF_BK",
- "TRYK_V_tacv1_FBI_BK",
- "TRYK_V_tacv1LP_BK",
- "TRYK_V_tacv1LSRF_BK",
- "TRYK_V_tacv1LC_BK",
- "TRYK_V_tacv1LC_CY",
- "TRYK_V_tacv1LC_OD",
- "TRYK_V_tacv1LC_FBI_BK",
- "TRYK_V_tacv1LC_SRF_BK",
- "TRYK_V_tacv1LC_SRF_OD",
- "TRYK_V_tacv1LC_P_BK",
- "TRYK_V_PlateCarrier_POLICE",
- "TRYK_V_ArmorVest_HRT_B",
- "TRYK_V_ArmorVest_HRT_OD",
- "TRYK_V_ArmorVest_HRT2_B",
- "TRYK_V_ArmorVest_HRT2_OD",
- "TRYK_V_ArmorVest_Winter",
- "TRYK_V_Sheriff_BA_OD",
- "TRYK_V_tacv10_BK",
- "TRYK_V_tacv10_OD",
- "TRYK_V_tacv10_TN",
- "TRYK_V_tacv10LC_BK",
- "TRYK_V_tacv10LC_OD",
- "TRYK_V_tacv10LC_TN",
- "TRYK_V_tacv1L_BK",
- "TRYK_V_tacv1L_OD",
- "TRYK_V_tacv1L_CY",
- "TRYK_V_tacv1LC_FBI2_BK",
- "TRYK_V_tacv1LC_SRF2_BK",
- "TRYK_V_tacv1LC_SRF2_OD",
- "TRYK_V_tacv1LC_P2_BK",
- "TRYK_V_tacv1_MSL_BK",
- "TRYK_V_tacv1_MSL_NV",
- "TRYK_V_tacv1LMSL_BK",
- "TRYK_V_tacv1LMSL_NV",
- "TRYK_V_tacv1LC_MSL_BK",
- "TRYK_V_tacv1LC_MSL_NV",
- "TRYK_V_tacSVD_BK",
- "TRYK_V_tacSVD_OD",
- "TRYK_V_Sheriff_BA_TL",
- "TRYK_V_Sheriff_BA_TBL",
- "TRYK_V_Sheriff_BA_TCL",
- "TRYK_V_Sheriff_BA_TL2",
- "TRYK_V_Sheriff_BA_TBL2",
- "TRYK_V_Sheriff_BA_TCL2",
- "TRYK_V_Sheriff_BA_T",
- "TRYK_V_Sheriff_BA_TB",
- "TRYK_V_Sheriff_BA_T2",
- "TRYK_V_Sheriff_BA_TB2",
- "TRYK_V_Sheriff_BA_T3",
- "TRYK_V_Sheriff_BA_TB3",
- "TRYK_V_Sheriff_BA_T4",
- "TRYK_V_Sheriff_BA_TB4",
- "TRYK_V_Sheriff_BA_T5",
- "TRYK_V_Sheriff_BA_TB5",
- "TRYK_V_Sheriff_BA_TBL3_BK",
- "TRYK_V_Sheriff_BA_TBL3_OD",
- "TRYK_V_Sheriff_BA_TBL3_TN",
- "TRYK_LOC_AK_chestrig_OD",
- "TRYK_LOC_AK_chestrig_TAN"
- ];
- $tryk_headgears = [
- "TRYK_Beard_Gr4",
- "TRYK_US_ESS_Glasses",
- "TRYK_US_ESS_Glasses_WH",
- "TRYK_US_ESS_Glasses_BLK",
- "TRYK_US_ESS_Glasses_TAN",
- "TRYK_US_ESS_Glasses_TAN_BLK",
- "TRYK_SPGEAR_Glasses",
- "TRYK_headset_Glasses",
- "TRYK_SpsetG_Glasses",
- "TRYK_Spset_PHC1_Glasses",
- "TRYK_Spset_PHC2_Glasses",
- "TRYK_US_ESS_Glasses_H",
- "TRYK_US_ESS_Glasses_Cover",
- "TRYK_headset2_glasses",
- "TRYK_US_ESS_Glasses_NV",
- "TRYK_US_ESS_Glasses_TAN_NV",
- "TRYK_ESS_BLKTAN_NV",
- "TRYK_ESS_BLKBLK_NV",
- "TRYK_G_Shades_Black_NV",
- "TRYK_G_Shades_Blue_NV",
- "TRYK_G_bala_ess_NV",
- "TRYK_bandana_NV",
- "TRYK_SPgearG_NV",
- "TRYK_SPgear_PHC1_NV",
- "TRYK_SPgear_PHC2_NV",
- "TRYK_G_bala_wh_NV",
- "TRYK_ESS_wh_NV",
- "TRYK_ESS_CAP_OD",
- "TRYK_ESS_CAP_tan",
- "TRYK_R_CAP_BLK",
- "TRYK_R_CAP_TAN",
- "TRYK_R_CAP_OD_US",
- "TRYK_r_cap_tan_Glasses",
- "TRYK_r_cap_blk_Glasses",
- "TRYK_r_cap_od_Glasses",
- "TRYK_H_headsetcap_Glasses",
- "TRYK_H_headsetcap_blk_Glasses",
- "TRYK_H_headsetcap_od_Glasses",
- "TRYK_TAC_EARMUFF_SHADE",
- "TRYK_TAC_EARMUFF",
- "TRYK_NOMIC_TAC_EARMUFF",
- "TRYK_headset2",
- "TRYK_TAC_EARMUFF_Gs",
- "TRYK_TAC_SET_bn",
- "TRYK_NOMIC_TAC_EARMUFF_Gs",
- "TRYK_TAC_EARMUFF_SHADE_Gs",
- "TRYK_TAC_SET_TAN",
- "TRYK_TAC_SET_OD",
- "TRYK_TAC_SET_WH",
- "TRYK_TAC_SET_MESH",
- "TRYK_TAC_SET_TAN_2",
- "TRYK_TAC_SET_OD_2",
- "TRYK_TAC_SET_WH_2",
- "TRYK_TAC_SET_MESH_2",
- "TRYK_bandana_g",
- "TRYK_H_PASGT_BLK",
- "TRYK_H_PASGT_OD",
- "TRYK_H_PASGT_COYO",
- "TRYK_H_PASGT_TAN",
- "TRYK_H_Helmet_Snow",
- "TRYK_H_WH",
- "TRYK_H_GR",
- "TRYK_H_AOR1",
- "TRYK_H_AOR2",
- "TRYK_H_EARMUFF",
- "TRYK_H_TACEARMUFF_H",
- "TRYK_H_Bandana_H",
- "TRYK_H_Bandana_wig",
- "TRYK_H_Bandana_wig_g",
- "TRYK_H_wig",
- "TRYK_H_headset2",
- "TRYK_H_ghillie_over",
- "TRYK_H_ghillie_top",
- "TRYK_H_ghillie_top_headless",
- "TRYK_H_ghillie_over_green",
- "TRYK_H_ghillie_top_green",
- "TRYK_H_ghillie_top_headless_green",
- "TRYK_H_woolhat",
- "TRYK_H_woolhat_CW",
- "TRYK_H_woolhat_WH",
- "TRYK_H_woolhat_br",
- "TRYK_H_woolhat_cu",
- "TRYK_H_woolhat_tan",
- "TRYK_H_headsetcap",
- "TRYK_H_headsetcap_blk",
- "TRYK_H_headsetcap_od",
- "TRYK_H_pakol",
- "TRYK_H_pakol2",
- "TRYK_H_LHS_HEL_G",
- "TRYK_H_Helmet_Winter",
- "TRYK_H_Helmet_Winter_2",
- "TRYK_Headphone_NV",
- "TRYK_HRPIGEAR_NV",
- "TRYK_Headset_NV",
- "TRYK_TAC_boonie_SET_NV",
- "TRYK_TAC_SET_NV_TAN",
- "TRYK_TAC_SET_NV_OD",
- "TRYK_TAC_SET_NV_WH",
- "TRYK_TAC_SET_NV_MESH",
- "TRYK_TAC_SET_NV_TAN_2",
- "TRYK_TAC_SET_NV_OD_2",
- "TRYK_TAC_SET_NV_WH_2",
- "TRYK_TAC_SET_NV_MESH_2",
- "TRYK_H_DELTAHELM_NV",
- "TRYK_Shemagh_shade_MESH",
- "TRYK_Shemagh_shade_N",
- "TRYK_Shemagh_shade_G_N",
- "TRYK_Shemagh_shade_WH_N",
- "TRYK_kio_balaclava_WH",
- "TRYK_kio_balaclava_BLK",
- "TRYK_kio_balaclavas",
- "TRYK_kio_balaclava_BLK_ear",
- "TRYK_kio_balaclava_ear",
- "TRYK_kio_balaclava_ESS",
- "TRYK_Shemagh",
- "TRYK_Shemagh_mesh",
- "TRYK_Shemagh_G",
- "TRYK_Shemagh_WH",
- "TRYK_Shemagh_shade",
- "TRYK_Shemagh_shade_G",
- "TRYK_Shemagh_shade_WH",
- "TRYK_Shemagh_shade_MH",
- "TRYK_Shemagh_ESS",
- "TRYK_Shemagh_ESS_G",
- "TRYK_Shemagh_ESS_WH",
- "TRYK_Shemagh_EAR_TAN",
- "TRYK_Shemagh_EAR_WH",
- "TRYK_balaclava_BLACK_NV",
- "TRYK_balaclava_NV",
- "TRYK_balaclava_BLACK_EAR_NV",
- "TRYK_balaclava_EAR_NV",
- "TRYK_Shemagh_TAN_NV",
- "TRYK_Shemagh_MESH_NV",
- "TRYK_Shemagh_G_NV",
- "TRYK_Shemagh_WH_NV",
- "TRYK_Shemagh_EAR_NV",
- "TRYK_Shemagh_EAR_G_NV",
- "TRYK_Shemagh_EAR_WH_NV",
- "TRYK_ShemaghESSTAN_NV",
- "TRYK_ShemaghESSOD_NV",
- "TRYK_ShemaghESSWH_NV"
- ];
- $tryk_backpacks = [
- "TRYK_B_AssaultPack_UCP",
- "TRYK_B_AssaultPack_Type2camo",
- "TRYK_B_AssaultPack_MARPAT_Desert",
- "TRYK_B_AssaultPack_MARPAT_Wood",
- "TRYK_B_Kitbag_Base",
- "TRYK_B_Kitbag_blk",
- "TRYK_B_Kitbag_aaf",
- "TRYK_B_Carryall_blk",
- "TRYK_B_Carryall_wh",
- "TRYK_B_Carryall_wood",
- "TRYK_B_Carryall_JSDF",
- "TRYK_B_Kitbag_Base_JSDF",
- "TRYK_B_Coyotebackpack",
- "TRYK_B_Coyotebackpack_OD",
- "TRYK_B_Coyotebackpack_BLK",
- "TRYK_B_Coyotebackpack_WH",
- "TRYK_B_Alicepack",
- "TRYK_B_Medbag",
- "TRYK_B_Medbag_OD",
- "TRYK_B_Medbag_BK",
- "TRYK_B_Medbag_ucp",
- "TRYK_B_Belt",
- "TRYK_B_Belt_BLK",
- "TRYK_B_Belt_CYT",
- "TRYK_B_Belt_tan",
- "TRYK_B_Belt_br",
- "TRYK_B_Belt_GR",
- "TRYK_B_Belt_AOR1",
- "TRYK_B_Belt_AOR2",
- "TRYK_B_BAF_BAG_BLK",
- "TRYK_B_BAF_BAG_CYT",
- "TRYK_B_BAF_BAG_OD",
- "TRYK_B_BAF_BAG_rgr",
- "TRYK_B_BAF_BAG_mcamo",
- "TRYK_B_tube_cyt",
- "TRYK_B_tube_od",
- "TRYK_B_tube_blk",
- "TRYK_B_FieldPack_Wood",
- "TRYK_Winter_pack"
- ];
- $replacement_uniform = "Exile_Uniform_Woodland";
- $replacement_vest = "V_PlateCarrierGL_blk";
- $replacement_headgear = "H_HelmetLeaderO_ocamo";
- $replacement_backpack = "B_Carryall_oli";
- // Swap TRYK Uniforms equipped on players
- $sql = "SELECT COUNT(*) as count FROM player WHERE uniform like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- $row = mysqli_fetch_object($result);
- $count = $row->count;
- echo "Replaced $count uniforms that players had equipped<br>";
- $sql = "UPDATE player SET uniform = '$replacement_uniform' WHERE uniform like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- // Swap TRYK Vests equipped on players
- $sql = "SELECT COUNT(*) as count FROM player WHERE vest like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- $row = mysqli_fetch_object($result);
- $count = $row->count;
- echo "Replaced $count vests that players had equipped<br>";
- $sql = "UPDATE player SET vest = '$replacement_vest' WHERE vest like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- // Swap TRYK headgear equipped on players
- $sql = "SELECT COUNT(*) as count FROM player WHERE headgear like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- $row = mysqli_fetch_object($result);
- $count = $row->count;
- echo "Replaced $count headgear that players had equipped<br>";
- $sql = "UPDATE player SET headgear = '$replacement_headgear' WHERE headgear like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- // Swap TRYK backpacks equipped on players
- $sql = "SELECT COUNT(*) as count FROM player WHERE backpack like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- $row = mysqli_fetch_object($result);
- $count = $row->count;
- echo "Replaced $count backpack that players had equipped<br>";
- $sql = "UPDATE player SET backpack = '$replacement_backpack' WHERE backpack like 'TRYK%'";
- $result = mysqli_query($db_local, $sql);
- foreach ($tryk_uniforms as $tryk_uniform)
- {
- $sql = "UPDATE container SET cargo_container = REPLACE(cargo_container, '$tryk_uniform', '$replacement_uniform') WHERE cargo_container like '%$tryk_uniform%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE vehicle SET cargo_container = REPLACE(cargo_container, '$tryk_uniform', '$replacement_uniform') WHERE cargo_container like '%$tryk_uniform%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE player SET backpack_items = REPLACE(backpack_items, '$tryk_uniform', '$replacement_uniform') WHERE backpack_items like '%$tryk_uniform%'";
- $result = mysqli_query($db_local, $sql);
- echo "Replaced all instances of $tryk_uniform in the database<br>";
- };
- foreach ($tryk_vests as $tryk_vest)
- {
- $sql = "UPDATE container SET cargo_container = REPLACE(cargo_container, '$tryk_vest', '$replacement_vest') WHERE cargo_container like '%$tryk_vest%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE vehicle SET cargo_container = REPLACE(cargo_container, '$tryk_vest', '$replacement_vest') WHERE cargo_container like '%$tryk_vest%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE player SET backpack_items = REPLACE(backpack_items, '$tryk_vest', '$replacement_vest') WHERE backpack_items like '%$tryk_vest%'";
- $result = mysqli_query($db_local, $sql);
- echo "Replaced all instances of $tryk_vest in the database<br>";
- };
- foreach ($tryk_headgears as $tryk_headgear)
- {
- $sql = "UPDATE container SET cargo_items = REPLACE(cargo_items, '$tryk_headgear', '$replacement_headgear') WHERE cargo_items like '%$tryk_headgear%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE vehicle SET cargo_items = REPLACE(cargo_items, '$tryk_headgear', '$replacement_headgear') WHERE cargo_items like '%$tryk_headgear%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE player SET backpack_items = REPLACE(backpack_items, '$tryk_headgear', '$replacement_headgear') WHERE backpack_items like '%$tryk_headgear%'";
- $result = mysqli_query($db_local, $sql);
- echo "Replaced all instances of $tryk_headgear in the database<br>";
- };
- foreach ($tryk_backpacks as $tryk_backpack)
- {
- $sql = "UPDATE container SET cargo_container = REPLACE(cargo_container, '$tryk_backpack', '$replacement_backpack') WHERE cargo_container like '%$tryk_backpack%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE vehicle SET cargo_container = REPLACE(cargo_container, '$tryk_backpack', '$replacement_backpack') WHERE cargo_container like '%$tryk_backpack%'";
- $result = mysqli_query($db_local, $sql);
- $sql = "UPDATE player SET backpack_items = REPLACE(backpack_items, '$tryk_backpack', '$replacement_backpack') WHERE backpack_items like '%$tryk_backpack%'";
- $result = mysqli_query($db_local, $sql);
- echo "Replaced all instances of $tryk_backpack in the database<br>";
- };
- echo "<hr><h2>FINISHED REPLACING TRYK GEAR IN YOUR DATABASE</h2><hr>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement