Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
[Default] Version = 12 Number of Inputs = 0 Sanitize Input Value Check = false Sanitize Output Value Check = false Prepared Statement Cache = true Return InsertID = false Strip = true Strip Chars Action = STRIP Strip Chars = \/\|;{}<>\' Strip Custom Chars = \/\|;{}<>\' ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Account related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [isKnownAccount] SQL1_1 = SELECT CASE WHEN EXISTS(SELECT uid FROM account WHERE uid = ?) THEN 'true' ELSE 'false' END Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createAccount] SQL1_1 = INSERT INTO account SET uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [startAccountSession] SQL1_1 = UPDATE account SET name = ?, last_connect_at = NOW(), total_connections = total_connections + 1 WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 2,1 [endAccountSession] SQL1_1 = UPDATE account SET last_disconnect_at = NOW() WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountStats] SQL1_1 = SELECT score, kills, deaths, clan_id, locker FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2,3,4,5 [addAccountKill] SQL1_1 = UPDATE account SET kills = kills + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [addAccountDeath] SQL1_1 = UPDATE account SET deaths = deaths + 1 WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [getAccountScore] SQL1_1 = SELECT score FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setAccountScore] SQL1_1 = UPDATE account SET score = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [modifyAccountScore] SQL1_1 = UPDATE account SET score = score + ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLocker] SQL1_1 = UPDATE account SET locker = ? WHERE uid = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getLocker] SQL1_1 = SELECT locker FROM account WHERE uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Player related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [hasAlivePlayer] SQL1_1 = SELECT CASE WHEN EXISTS(SELECT account_uid FROM player WHERE account_uid = ? AND damage < 1) THEN 'true' ELSE 'false' END Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [createPlayer] SQL1_1 = INSERT INTO player SET account_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [insertPlayerHistory] SQL1_1 = INSERT INTO player_history SET account_uid = ?, name = ?, position_x = ?, position_y = ?, position_z = ? Number Of Inputs = 5 SQL1_INPUTS = 1,2,3,4,5 [deletePlayer] SQL1_1 = DELETE FROM player WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadPlayer] SQL1_1 = SELECT p.id, SQL1_2 = p.name, SQL1_3 = p.account_uid, SQL1_4 = p.damage, SQL1_5 = p.hunger, SQL1_6 = p.thirst, SQL1_7 = p.alcohol, SQL1_8 = p.oxygen_remaining, SQL1_9 = p.bleeding_remaining, SQL1_10 = p.hitpoints, SQL1_11 = p.direction, SQL1_12 = p.position_x, SQL1_13 = p.position_y, SQL1_14 = p.position_z, SQL1_15 = p.assigned_items, SQL1_16 = p.backpack, SQL1_17 = p.backpack_items, SQL1_18 = p.backpack_magazines, SQL1_19 = p.backpack_weapons, SQL1_20 = p.current_weapon, SQL1_21 = p.goggles, SQL1_22 = p.handgun_items, SQL1_23 = p.handgun_weapon, SQL1_24 = p.headgear, SQL1_25 = p.binocular, SQL1_26 = p.loaded_magazines, SQL1_27 = p.primary_weapon, SQL1_28 = p.primary_weapon_items, SQL1_29 = p.secondary_weapon, SQL1_30 = p.secondary_weapon_items, SQL1_31 = p.uniform, SQL1_32 = p.uniform_items, SQL1_33 = p.uniform_magazines, SQL1_34 = p.uniform_weapons, SQL1_35 = p.vest, SQL1_36 = p.vest_items, SQL1_37 = p.vest_magazines, SQL1_38 = p.vest_weapons, SQL1_39 = p.money, SQL1_40 = a.score, SQL1_41 = a.kills, SQL1_42 = a.deaths, SQL1_43 = c.id, SQL1_44 = c.name, SQL1_45 = p.temperature, SQL1_46 = p.wetness, SQL1_47 = a.locker SQL1_48 = FROM player p SQL1_49 = INNER JOIN account a SQL1_50 = ON a.uid = p.account_uid SQL1_51 = LEFT JOIN clan c SQL1_52 = ON c.id = a.clan_id SQL1_53 = WHERE p.account_uid = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16-STRING,17,18,19,20-STRING,21-STRING,22,23-STRING,24-STRING,25-STRING,26,27-STRING,28,29-STRING,30,31-STRING,32,33,34,35-STRING,36,37,38,39,40,41,42,43,44-STRING,45,46,47 [updatePlayer] SQL1_1 = UPDATE player SET SQL1_2 = name = ?, SQL1_3 = damage = ?, SQL1_4 = hunger = ?, SQL1_5 = thirst = ?, SQL1_6 = alcohol = ?, SQL1_7 = oxygen_remaining = ?, SQL1_8 = bleeding_remaining = ?, SQL1_9 = hitpoints = ?, SQL1_10 = direction = ?, SQL1_11 = position_x = ?, SQL1_12 = position_y = ?, SQL1_13 = position_z = ?, SQL1_14 = assigned_items = ?, SQL1_15 = backpack = ?, SQL1_16 = backpack_items = ?, SQL1_17 = backpack_magazines = ?, SQL1_18 = backpack_weapons = ?, SQL1_19 = current_weapon = ?, SQL1_20 = goggles = ?, SQL1_21 = handgun_items = ?, SQL1_22 = handgun_weapon = ?, SQL1_23 = headgear = ?, SQL1_24 = binocular = ?, SQL1_25 = loaded_magazines = ?, SQL1_26 = primary_weapon = ?, SQL1_27 = primary_weapon_items = ?, SQL1_28 = secondary_weapon = ?, SQL1_29 = secondary_weapon_items = ?, SQL1_30 = uniform = ?, SQL1_31 = uniform_items = ?, SQL1_32 = uniform_magazines = ?, SQL1_33 = uniform_weapons = ?, SQL1_34 = vest = ?, SQL1_35 = vest_items = ?, SQL1_36 = vest_magazines = ?, SQL1_37 = vest_weapons = ?, SQL1_38 = temperature = ?, SQL1_39 = wetness = ? SQL1_40 = WHERE id = ? Number Of Inputs = 39 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Vehicle related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertVehicle] SQL1_1 = INSERT INTO vehicle SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = is_locked = ?, SQL1_5 = position_x = ?, SQL1_6 = position_y = ?, SQL1_7 = position_z = ?, SQL1_8 = direction_x = ?, SQL1_9 = direction_y = ?, SQL1_10 = direction_z = ?, SQL1_11 = up_x = ?, SQL1_12 = up_y = ?, SQL1_13 = up_z = ?, SQL1_14 = pin_code = ? Number of Inputs = 13 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13 Return InsertID = true [deleteVehicle] SQL1_1 = DELETE FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadVehicleIdPage] SQL1_1 = SELECT id FROM vehicle WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadVehicle] SQL1_1 = SELECT id,class,spawned_at,account_uid,is_locked,fuel,damage,hitpoints,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,vehicle_texture,deleted_at,money FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21-STRING,22,23,24 [loadVehicleContainer] SQL1_1 = SELECT cargo_container FROM vehicle WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [updateVehicle] SQL1_1 = UPDATE vehicle SET SQL1_2 = is_locked = ?, SQL1_3 = fuel = ?, SQL1_4 = damage = ?, SQL1_5 = hitpoints = ?, SQL1_6 = position_x = ?, SQL1_7 = position_y = ?, SQL1_8 = position_z = ?, SQL1_9 = direction_x = ?, SQL1_10 = direction_y = ?, SQL1_11 = direction_z = ?, SQL1_12 = up_x = ?, SQL1_13 = up_y = ?, SQL1_14 = up_z = ?, SQL1_15 = cargo_items = ?, SQL1_16 = cargo_magazines = ?, SQL1_17 = cargo_weapons = ?, SQL1_18 = cargo_container = ?, SQL1_19 = money = ?, SQL1_20 = last_updated_at = NOW() SQL1_21 = WHERE id = ? Number of Inputs = 19 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19 [updateVehicleSkin] SQL1_1 = UPDATE vehicle SET vehicle_texture = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [vehicleSetPinCode] SQL1_1 = UPDATE vehicle SET pin_code = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Construction related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertConstruction] SQL1_1 = INSERT INTO construction SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = position_x = ?, SQL1_5 = position_y = ?, SQL1_6 = position_z = ?, SQL1_7 = direction_x = ?, SQL1_8 = direction_y = ?, SQL1_9 = direction_z = ?, SQL1_10 = up_x = ?, SQL1_11 = up_y = ?, SQL1_12 = up_z = ?, SQL1_13 = territory_id = $CUSTOM_1$ Number of Inputs = 11 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11 Return InsertID = true [deleteConstruction] SQL1_1 = DELETE FROM construction WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadConstructionIdPage] SQL1_1 = SELECT id FROM construction WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadConstruction] SQL1_1 = SELECT id,class,account_uid,spawned_at,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,is_locked,pin_code,territory_id,deleted_at,damage FROM construction WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4-STRING,5,6,7,8,9,10,11,12,13,14,15-STRING,16,17,18 [countConstruction] SQL1_1 = SELECT COUNT(*) FROM construction Number Of Inputs = 0 OUTPUT = 1 [constructionSetPinCode] SQL1_1 = UPDATE construction SET pin_code= ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [upgradeObject] SQL1_1 = UPDATE construction SET class = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [addDoorLock] SQL1_1 = UPDATE construction SET pin_code = ?, is_locked = -1, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateLock] SQL1_1 = UPDATE construction SET is_locked = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateConstructionTerritoryIDs] SQL1_1 = UPDATE construction SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateDamage] SQL1_1 = UPDATE construction SET damage = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Containers related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [insertContainer] SQL1_1 = INSERT INTO container SET SQL1_2 = class = ?, SQL1_3 = account_uid = ?, SQL1_4 = position_x = ?, SQL1_5 = position_y = ?, SQL1_6 = position_z = ?, SQL1_7 = direction_x = ?, SQL1_8 = direction_y = ?, SQL1_9 = direction_z = ?, SQL1_10 = up_x = ?, SQL1_11 = up_y = ?, SQL1_12 = up_z = ?, SQL1_13 = cargo_items = ?, SQL1_14 = cargo_magazines = ?, SQL1_15 = cargo_weapons = ?, SQL1_16 = cargo_container = ?, SQL1_17 = money = ?, SQL1_18 = pin_code = ?, SQL1_19 = territory_id = $CUSTOM_1$ Number of Inputs = 17 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 Return InsertID = true [deleteContainer] SQL1_1 = DELETE FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadContainerIdPage] SQL1_1 = SELECT id FROM container WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadContainer] SQL1_1 = SELECT id,class,account_uid,is_locked,position_x,position_y,position_z,direction_x,direction_y,direction_z,up_x,up_y,up_z,cargo_items,cargo_magazines,cargo_weapons,pin_code,territory_id,abandoned,deleted_at,money FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9,10,11,12,13,14,15,16,17-STRING,18,19-STRING,20,21 [loadContainerCargo] SQL1_1 = SELECT cargo_container FROM container WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [updateContainer] SQL1_1 = UPDATE container SET SQL1_2 = is_locked = ?, SQL1_3 = position_x = ?, SQL1_4 = position_y = ?, SQL1_5 = position_z = ?, SQL1_6 = direction_x = ?, SQL1_7 = direction_y = ?, SQL1_8 = direction_z = ?, SQL1_9 = up_x = ?, SQL1_10 = up_y = ?, SQL1_11 = up_z = ?, SQL1_12 = cargo_items = ?, SQL1_13 = cargo_magazines = ?, SQL1_14 = cargo_weapons = ?, SQL1_15 = cargo_container = ?, SQL1_16 = territory_id = $CUSTOM_1$, SQL1_17 = money = ?, SQL1_18 = last_updated_at = NOW() SQL1_19 = WHERE id = ? Number of Inputs = 16 Number of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16 [containerSetPinCode] SQL1_1 = UPDATE container SET pin_code= ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [updateContainerTerritoryIDs] SQL1_1 = UPDATE container SET territory_id = ? WHERE id IN(?) Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Clan related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createClan] SQL1_1 = INSERT INTO clan SET leader_uid = ?, name = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 Return InsertID = true [setAccountClanLink] SQL1_1 = UPDATE account SET clan_id = ? WHERE uid = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [unLinkClanLink] SQL1_1 = UPDATE account SET clan_id = NULL WHERE uid = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [updateClanLeader] SQL1_1 = UPDATE clan SET leader_uid = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [deleteClan] SQL1_1 = DELETE FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [loadClansIdPage] SQL1_1 = SELECT id FROM clan LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [getClanInfo] SQL1_1 = SELECT name,leader_uid FROM clan WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1-STRING,2-STRING [getClanMembers] SQL1_1 = SELECT uid,name FROM account WHERE clan_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1-STRING,2-STRING [getClanMarkers] SQL1_1 = SELECT id,markerType,positionArr,color,icon,iconSize,label,labelSize FROM clan_map_marker WHERE clan_id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2,3,4,5-STRING,6,7-STRING,8 [addMarker] SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 0, positionArr = ?, color = ?, icon = ?, iconSize = ?, label = ?, labelSize = ? Number Of Inputs = 7 SQL1_INPUTS = 1,2,3,4,5,6,7 Return InsertID = true [addPoly] SQL1_1 = INSERT INTO clan_map_marker SET clan_id = ?, markerType = 1, positionArr = ?, color = ? Number Of Inputs = 3 SQL1_INPUTS = 1,2,3 Return InsertID = true [deleteMarker] SQL1_1 = DELETE FROM clan_map_marker WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Territory related queries ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [createTerritory] SQL1_1 = INSERT INTO territory SET owner_uid = ?, name = ?, position_x = ? , position_y = ? , position_z = ?, radius = ? , level = ? , flag_texture = ? , flag_stolen = ? , flag_stolen_by_uid =$CUSTOM_1$ , build_rights = ? , moderators = ? Number Of Inputs = 11 Number Of Custom Inputs = 1 SQL1_INPUTS = 1,2,3,4,5,6,7,8,9,10,11 Return InsertID = true [loadTerriotryIdPage] SQL1_1 = SELECT id FROM territory WHERE deleted_at IS NULL LIMIT ?,? Number Of Inputs = 2 SQL1_INPUTS = 1,2 OUTPUT = 1 [loadTerritory] SQL1_1 = SET @connector = ?; SQL2_1 = SELECT id,owner_uid,name,position_x,position_y,position_z,radius, level,flag_texture,flag_stolen,flag_stolen_by_uid,last_paid_at,build_rights,moderators,deleted_at,(SELECT COUNT(*)FROM construction c WHERE c.territory_id = @connector) FROM territory WHERE id = @connector Number Of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1,2-STRING,3-STRING,4,5,6,7,8,9-STRING,10,11-STRING,12-DateTime_ISO8601,13,14,15,16 [setTerritoryLevel] SQL1_1 = UPDATE territory SET level = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [setTerritorySize] SQL1_1 = UPDATE territory SET radius = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryBuildRights] SQL1_1 = UPDATE territory SET build_rights = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [updateTerritoryModerators] SQL1_1 = UPDATE territory SET moderators = ? WHERE id = ? Number Of Inputs = 2 SQL1_INPUTS = 1,2 [maintainTerritory] SQL1_1 = UPDATE territory SET last_paid_at = NOW(),xm8_protectionmoney_notified = 0 WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteTerritory] SQL1_1 = DELETE FROM territory WHERE id = ? Number Of Inputs = 1 SQL1_INPUTS = 1 [flagStolen] SQL1_1 = UPDATE territory SET flag_stolen = 1, flag_stolen_by_uid = ?, flag_stolen_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [flagRestore] SQL1_1 = UPDATE territory SET flag_stolen = 0, flag_stolen_by_uid = NULL, flag_stolen_at = NULL WHERE id = ? Number of Inputs = 1 SQL1_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Garbage Collector ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ; Marks for deletion containers outside territories that were not accessed within ? days [markDeleteOldContainers] SQL1_1 = UPDATE container SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes containers outside territories that were not accessed within ? days [deleteOldContainers] SQL1_1 = DELETE FROM container WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks contructions outside territories deleted after ? days [markDeleteOldConstructions] SQL1_1 = UPDATE construction SET deleted_at = NOW() WHERE spawned_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes contructions outside territories after ? days [deleteOldConstructions] SQL1_1 = DELETE FROM construction WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks for deletion vehicles that were not used within ? days [markDeleteOldVehicles] SQL1_1 = UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes vehicles that were not used within ? days [deleteOldVehicles] SQL1_1 = DELETE FROM vehicle WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 ; Marks territories (and all containers/constructions) that were not paid within ? days as deleted [markDeleteUnpaidTerritories] SQL1_1 = UPDATE territory SET deleted_at = NOW() WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND deleted_at IS NULL SQl2_1 = UPDATE construction SET deleted_at = (SELECT deleted_at FROM territory WHERE territory.id = construction.territory_id AND territory.deleted_at IS NOT NULL) WHERE construction.territory_id IS NOT NULL SQL3_1 = UPDATE container SET deleted_at = (SELECT deleted_at FROM territory WHERE territory.id = container.territory_id AND territory.deleted_at IS NOT NULL) WHERE container.territory_id IS NOT NULL Number Of Inputs = 1 SQL1_INPUTS = 1 ; Removes territories (and all containers/constructions) that were not paid within ? days [deleteUnpaidTerritories] SQL1_1 = DELETE FROM territory WHERE deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 [addAbandonedSafes] SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND class = "Exile_Container_Safe" AND territory_id IS NULL Number Of Inputs = 1 SQL1_INPUTS = 1 [deleteBaseFlagStolen] SQL1_1 = DELETE FROM territory WHERE flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY) Number Of Inputs = 1 SQL1_INPUTS = 1 ; Unlock doors and mark safes as abandoned if flag stolen for X days [setAbandonedUnlocked] SQL1_1 = UPDATE container SET abandoned = NOW(), pin_code = '0000' WHERE (SELECT flag_stolen_at FROM territory WHERE territory.id = container.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)); SQL2_1 = UPDATE construction SET pin_code = '0000' WHERE (SELECT flag_stolen_at FROM territory WHERE territory.id = construction.territory_id AND territory.flag_stolen_at < DATE_SUB(NOW(), INTERVAL ? DAY)) AND pin_code != '000000' Number Of Inputs = 1 SQL1_INPUTS = 1 SQL2_INPUTS = 1 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; Moneh moneh moneh ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [setPlayerMoney] SQL1_1 = UPDATE player SET money = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [getPlayerMoney] SQL1_1 = SELECT money FROM player WHERE id = ? Number of Inputs = 1 SQL1_INPUTS = 1 OUTPUT = 1 [setContainerMoney] SQL1_1 = UPDATE container SET money = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 [setVehicleMoney] SQL1_1 = UPDATE vehicle SET money = ?, last_updated_at = NOW() WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; ;; XM8 ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;; [getAllNotifTerritory] SQL1_1 = SELECT id FROM territory WHERE last_paid_at < DATE_SUB(NOW(), INTERVAL ? - 1 DAY) and xm8_protectionmoney_notified = 0 Number of Inputs = 1 SQL1_INPUTS = 1 [setTerritoryNotified] SQL1_1 = UPDATE territory SET xm8_protectionmoney_notified = ? WHERE id = ? Number of Inputs = 2 SQL1_INPUTS = 1,2
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
Untitled
15 sec ago | 0.37 KB
Untitled
1 min ago | 0.98 KB
Untitled
2 min ago | 0.20 KB
Untitled
3 min ago | 0.31 KB
Untitled
5 min ago | 0.31 KB
Untitled
8 min ago | 0.92 KB
Untitled
10 min ago | 0.67 KB
Untitled
10 min ago | 0.46 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
