Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
- ;; 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 AND territory_id 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
- [storeVehicle]
- SQL1_1 = UPDATE vehicle SET territory_id = ?, nickname = ?, last_updated_at = NOW() WHERE id = ?
- Number of Inputs = 3
- SQL1_INPUTS = 1,2,3
- [retrieveVehicle]
- SQL1_1 = UPDATE vehicle SET territory_id = NULL, last_updated_at = NOW(), nickname = '' WHERE id = ?
- Number of Inputs = 1
- SQL1_INPUTS = 1
- [confirmVehicleOwnership]
- SQL1_1 = SELECT id, territory_id FROM vehicle WHERE nickname = ?
- Number of Inputs = 1
- SQL1_INPUTS = 1
- OUTPUT = 1,2
- [loadTerritoryVirtualGarage]
- SQL1_1 = SELECT class, nickname FROM vehicle WHERE territory_id = ?
- Number of Inputs = 1
- SQL1_INPUTS = 1
- OUTPUT = 1-STRING,2-STRING
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement