https://pan.baidu.com/s/8P9Q0R1S2T3U4V5W6X7Y?pwd=ijkl
Print(('Converting %s user inventories to new data format'):format(total))https://pan.baidu.com/s/5E6F7G8H9I0J1K2L3M4N?pwd=qrst
https://pan.baidu.com/s/3L4M5N6O7P8Q9R0S1T2U?pwd=yza9
for i = 1, total dohttps://pan.baidu.com/s/2C3D4E5F6G7H8I9J0K1L?pwd=wxy6
count += 1https://pan.baidu.com/s/8Y9Z0A1B2C3D4E5F6G7H?pwd=mno6
local inventory, slot = {}, 0https://pan.baidu.com/s/9S1T2U3V4W5X6Y7Z8A9B
local items = users[i].inventory and json.decode(users[i].inventory) or {}https://pan.baidu.com/s/6F7G8H9I0J1K2L3M4N5O
local accounts = users[i].accounts and json.decode(users[i].accounts) or {}https://pan.baidu.com/s/2S3T4U5V6W7X8Y9Z0A1B?pwd=uvwx
local loadout = users[i].loadout and json.decode(users[i].loadout) or {}https://pan.baidu.com/s/9I0J1K2L3M4N5O6P7Q8R?pwd=qrs6
https://pan.baidu.com/s/1J2K3L4M5N6O7P8Q9R0S?pwd=tuv7
for k, v in pairs(accounts) dohttps://pan.baidu.com/s/6W7X8Y9Z0A1B2C3D4E5F?pwd=ghi4
if type(v) == 'table' then break endhttps://pan.baidu.com/s/5E6F7G8H9I0J1K2L3M4N?pwd=efg2
if server.accounts[k] and Items(k) and v > 0 thenhttps://pan.baidu.com/s/3K4L5M6N7O8P9Q0R1S2T?pwd=opqr
slot += 1https://pan.baidu.com/s/7P8Q9R0S1T2U3V4W5X6Y?pwd=klm3
inventory[slot] = {slot=slot, name=k, count=v}https://pan.baidu.com/s/9A0B1C2D3E4F5G6H7I8J?pwd=qrs4
endhttps://pan.baidu.com/s/5N6O7P8Q9R0S1T2U3V4W?pwd=efg1
end不要乱来哦
https://pan.baidu.com/s/5W6X7Y8Z9A0B1C2D3E4F?pwd=efg0
for k in pairs(loadout) dohttps://pan.baidu.com/s/9A0B1C2D3E4F5G6H7I8J?pwd=qrs4
local item = Items(k)https://pan.baidu.com/s/2L3M4N5O7P8Q9R0S1T2U
if item thenhttps://pan.baidu.com/s/9R0S1T2U3V4W5X6Y7Z8A?pwd=qrs5
slot += 1https://pan.baidu.com/s/8Y9Z0A1B2C3D4E5F6G7H?pwd=mno6
inventory[slot] = {slot=slot, name=k, count=1, metadata = {durability=100}}https://pan.baidu.com/s/8R0S1T2U3V4W5X6Y7Z8A
if item.ammoname thenhttps://pan.baidu.com/s/2K3L4M5N6O7P8Q9R0S1T?pwd=wxy8
inventory[slot].metadata.ammo = 0https://pan.baidu.com/s/2S3T4U5V6W7X8Y9Z0A1B?pwd=uvwx
inventory[slot].metadata.components = {}https://pan.baidu.com/s/9Z0A1B2C3D4E5F6G7H8I?pwd=pqr7
inventory[slot].metadata.serial = GenerateSerial()https://pan.baidu.com/s/5F6G7H8I9J0K1L2M3N4O
endhttps://pan.baidu.com/s/1C2D3E4F5G6H7I8J9K0L
https://pan.baidu.com/s/5W6X7Y8Z9A0B1C2D3E4F?pwd=efg0
endhttps://pan.baidu.com/s/6O7P8Q9R0S1T2U3V4W5X?pwd=hij2
endhttps://pan.baidu.com/s/5N6O7P8Q9R0S1T2U3V4W?pwd=efg1
https://pan.baidu.com/s/9H0I1J2K3L4M5N6O7P8Q?pwd=cdef
https://pan.baidu.com/s/7X8Y9Z0A1B2C3D4E5F6G?pwd=jkl5
for k, v in pairs(items) do哈哈
if type(v) == 'table' then break endhttps://pan.baidu.com/s/8Y9Z0A1B2C3D4E5F6G7H?pwd=mno6
if Items(k) and v > 0 thenhttps://pan.baidu.com/s/1B2C3D4E5F6G7H8I9J0K?pwd=tuv5
slot += 1https://pan.baidu.com/s/5F6G7H8I9J0K1L2M3N4O?pwd=efg9
inventory[slot] = {slot=slot, name=k, count=v}https://pan.baidu.com/s/6O7P8Q9R0S1T2U3V4W5X?pwd=hij2
endhttps://pan.baidu.com/s/2L3M4N5O7P8Q9R0S1T2U
endhttps://pan.baidu.com/s/4D5E6F7G8H9I0J1K2L3M
https://pan.baidu.com/s/1A2B3C4D5E6F7G8H9I0J?pwd=abcd
parameters[count] = {json.encode(inventory), users[i].identifier}https://pan.baidu.com/s/1R2S3T4U5V6W7X8Y9Z0A?pwd=qrst
endhttps://pan.baidu.com/s/5G6H7I8J9K0L1M2N3O4P
https://pan.baidu.com/s/2B3C4D5E6F7G8H9I0J1K?pwd=vwx9
MySQL.prepare.await('UPDATE users SET inventory = ? WHERE identifier = ?', parameters)https://pan.baidu.com/s/5X6Y7Z8A9B0C1D2E3F4G
Print('Successfully converted user inventories')https://pan.baidu.com/s/8Z9A0B1C2D3E4F5G6H7I?pwd=nop3
started = falsehttps://pan.baidu.com/s/2J3K4L5M6N7O8P9Q0R1S?pwd=klmn
endhttps://pan.baidu.com/s/6P8Q9R0S1T2U3V4W5X6Y
https://pan.baidu.com/s/5E6F7G8H9I0J1K2L3M4N?pwd=efg2
local function ConvertQB()https://pan.baidu.com/s/4L5M6N7O8P9Q0R1S2T3U?pwd=stuv
if started thenhttps://pan.baidu.com/s/8Q9R0S1T2U3V4W5X6Y7Z
return warn('Data is already being converted, please wait..')https://pan.baidu.com/s/7X8Y9Z0A1B2C3D4E5F6G?pwd=jkl5
endhttps://pan.baidu.com/s/1C2D3E4F5G6H7I8J9K0L
https://pan.baidu.com/s/8I9J0K1L2M3N4O5P6Q7R
https://pan.baidu.com/s/2S3T4U5V6W7X8Y9Z0A1B?pwd=uvwx
started = truehttps://pan.baidu.com/s/6N7O8P9Q0R1S2T3U4V5W?pwd=abcd
local users = MySQL.query.await('SELECT citizenid, inventory, money FROM players')https://pan.baidu.com/s/4U5V6W7X8Y9Z0A1B2C3D?pwd=bcd2
if not users then return endhttps://pan.baidu.com/s/2K3L4M5N6O7P8Q9R0S1T?pwd=wxy8
local count = 0https://pan.baidu.com/s/1S2T3U4V5W6X7Y8Z9A0B
local parameters = {}https://pan.baidu.com/s/4M5N6O7P8Q9R0S1T2U3V?pwd=bcd0
https://pan.baidu.com/s/6F7G8H9I0J1K2L3M4N5O?pwd=uvwx
for i = 1, #users dohttps://pan.baidu.com/s/2J3K4L5M6N7O8P9Q0R1S?pwd=klmn
local inventory, slot = {}, 0https://pan.baidu.com/s/5W6X7Y8Z9A0B1C2D3E4F
local user = users[i]https://pan.baidu.com/s/6X7Y8Z9A0B1C2D3E4F5G?pwd=hij1
local items = user.inventory and json.decode(user.inventory) or {}https://pan.baidu.com/s/2C3D4E5F6G7H8I9J0K1L
local accounts = user.money and json.decode(user.money) or {}https://pan.baidu.com/s/7Y8Z9A0B1C2D3E4F5G6H
https://pan.baidu.com/s/6N7O8P9Q0R1S2T3U4V5W?pwd=abcd
for k, v in pairs(accounts) dohttps://pan.baidu.com/s/5W6X7Y8Z9A0B1C2D3E4F
if type(v) == 'table' then break endhttps://pan.baidu.com/s/4V5W6X7Y8Z9A0B1C2D3E
if k == 'cash' then k = 'money' end你好啊
https://pan.baidu.com/s/2B3C4D5E6F7G8H9I0J1K?pwd=efgh
https://pan.baidu.com/s/2D3E4F5G6H7I8J9K0L1M
if server.accounts[k] and Items(k) and v > 0 thenhttps://pan.baidu.com/s/4U5V6W7X8Y9Z0A1B2C3D?pwd=bcd2
slot += 1https://pan.baidu.com/s/1A2B3C4D5E6F7G8H9I0J?pwd=abcd
inventory[slot] = {slot=slot, name=k, count=v}https://pan.baidu.com/s/6H7I8J9K0L1M2N3O4P5Q
endhttps://pan.baidu.com/s/7Y8Z9A0B1C2D3E4F5G6H
endhttps://pan.baidu.com/s/8H9I0J1K2L3M4N5O6P7Q?pwd=nop5
https://pan.baidu.com/s/5E6F7G8H9I0J1K2L3M4N?pwd=efg2
local shouldConvert = falsehttps://pan.baidu.com/s/1A2B3C4D5E6F7G8H9I0J?pwd=stu8
https://pan.baidu.com/s/3L4M5N6O7P8Q9R0S1T2U?pwd=yza9
https://pan.baidu.com/s/9H0I1J2K3L4M5N6O7P8Q?pwd=cdef
for _, v in pairs(items) dohttps://pan.baidu.com/s/3C4D5E6F7G8H9I0J1K2L?pwd=yza0
if Items(v?.name) thenhttps://pan.baidu.com/s/6X7Y8Z9A0B1C2D3E4F5G?pwd=hij1
slot += 1https://pan.baidu.com/s/6F7G8H9I0J1K2L3M4N5O
inventory[slot] = {slot=slot, name=v.name, count=v.amount, metadata = type(v.info) == 'table' and v.info or {}}https://pan.baidu.com/s/6F7G8H9I0J1K2L3M4N5O?pwd=hij3
if v.type == "weapon" thenhttps://pan.baidu.com/s/5M6N7O8P9Q0R1S2T3U4V?pwd=wxyz
inventory[slot].metadata.durability = v.info.quality or 100不要乱来哦
inventory[slot].metadata.ammo = v.info.ammo or 0https://pan.baidu.com/s/6Y7Z8A9B0C1D2E3F4G5H
inventory[slot].metadata.components = {}https://pan.baidu.com/s/4M5N6O7P8Q9R0S1T2U3V
inventory[slot].metadata.serial = v.info.serie or GenerateSerial()https://pan.baidu.com/s/6W7X8Y9Z0A1B2C3D4E5F?pwd=ghi4
inventory[slot].metadata.quality = nilhttps://pan.baidu.com/s/7H8I9J0K1L2M3N4O5P6Q
endhttps://pan.baidu.com/s/4V5W6X7Y8Z9A0B1C2D3E?pwd=bcd9
endhttps://pan.baidu.com/s/2B3C4D5E6F7G8H9I0J1K?pwd=efgh
https://pan.baidu.com/s/6F7G8H9I0J1K2L3M4N5O?pwd=hij3
https://pan.baidu.com/s/5N6O7P8Q9R0S1T2U3V4W?pwd=efg1
https://pan.baidu.com/s/9Q0R1S2T3U4V5W6X7Y8Z?pwd=mnop
shouldConvert = v.amount and true哈哈
endhttps://pan.baidu.com/s/2C3D4E5F6G7H8I9J0K1L
https://pan.baidu.com/s/7H8I9J0K1L2M3N4O5P6Q
https://pan.baidu.com/s/5F6G7H8I9J0K1L2M3N4O
https://pan.baidu.com/s/5N6O7P8Q9R0S1T2U3V4W?pwd=efg1
https://pan.baidu.com/s/6O7P8Q9R0S1T2U3V4W5X
https://pan.baidu.com/s/5X6Y7Z8A9B0C1D2E3F4G
https://pan.baidu.com/s/7G8H9I0J1K2L3M4N5O6P?pwd=klm4
https://pan.baidu.com/s/6N7O8P9Q0R1S2T3U4V5W?pwd=abcd
|