Home
Port List
API Docs
Clock
IDE
SQL Sandbox
Default Code Library
Guild Listings
Tool Listings
Default Websites
Bug Tracker
Copy SQL
update BankAccounts set Transactions = REPLACE(Transactions, '"dinero":0.0', '"dinero":50000.0'); update InfoGen set Clock = '"2000-02-01T00:00:00"'; update Computer set Hardware = '{"hardDisk":{"speed":15000,"actualSpeed":15000,"totalSize":35000,"performance":100.0,"affectPerformance":65,"ID":"1319c517-2e0a-49cc-9a5d-ddf8a8b19a18","name":"Generic AHS985","reqPower":9.45,"quality":10,"health":100.0,"precio":26,"Type":0,"allowSell":false},"cpus":[{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false}],"rams":[{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false}],"gpu":{"hashrate":0,"ID":"","name":"","reqPower":0.0,"quality":5,"health":100.0,"precio":0,"Type":0,"allowSell":false},"powerSupply":{"power":1400,"ID":"cde1ccc5-ffd9-4e1a-b885-be5e150703f7","name":"Quest BNGG259I","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":2,"allowSell":true},"motherBoard":{"numCpus":4,"cpuSocket":"NGA","ramModel":3,"numRamSockets":3,"maxRamSocket":8192,"numPci":2,"ID":"a29b4450-abb0-479a-a0d5-06e60a1ee4dd","name":"Corn DBE441-BB22","reqPower":20.0,"quality":10,"health":100.0,"precio":0,"Type":3,"allowSell":false},"networkDevices":[{"isWifi":true,"monitorSupport":true,"monitorEnabled":false,"bssidAp":"B5:26:11:7E:A1:36","essidAp":"Ereill","ID":"f6bd4291-098e-4f54-9d20-b5e85a1f5362","name":"D284","reqPower":10.0,"quality":5,"health":100.0,"precio":179,"Type":5,"allowSell":false}]}' where IsPlayer = 1; update Computer set Hardware = '{"hardDisk":{"speed":15000,"actualSpeed":15000,"totalSize":35000,"performance":100.0,"affectPerformance":65,"ID":"1319c517-2e0a-49cc-9a5d-ddf8a8b19a18","name":"Generic AHS985","reqPower":9.45,"quality":10,"health":100.0,"precio":26,"Type":0,"allowSell":false},"cpus":[{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false},{"speed":5.0,"numCores":16,"socket":"NGA","ID":"98bcc6bb-459a-43e3-a03e-0bab9cd598a1","name":"Orldc Ovarting 358","reqPower":108.000008,"quality":10,"health":100.0,"precio":0,"Type":1,"allowSell":false}],"rams":[{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"7e94accf-891f-4e42-a365-6f5932fe052a","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"15bce134-d148-4879-b007-04756e8da7cb","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false},{"memory":8192,"ramModel":3,"ID":"8a70acb7-3d52-456a-9454-a4965c752292","name":"Dreyste N456","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":4,"allowSell":false}],"gpu":{"hashrate":0,"ID":"","name":"","reqPower":0.0,"quality":5,"health":100.0,"precio":0,"Type":0,"allowSell":false},"powerSupply":{"power":1400,"ID":"cde1ccc5-ffd9-4e1a-b885-be5e150703f7","name":"Quest BNGG259I","reqPower":0.0,"quality":10,"health":100.0,"precio":0,"Type":2,"allowSell":true},"motherBoard":{"numCpus":4,"cpuSocket":"NGA","ramModel":3,"numRamSockets":3,"maxRamSocket":8192,"numPci":2,"ID":"a29b4450-abb0-479a-a0d5-06e60a1ee4dd","name":"Corn DBE441-BB22","reqPower":20.0,"quality":10,"health":100.0,"precio":0,"Type":3,"allowSell":false},"networkDevices":[{"isWifi":true,"monitorSupport":true,"monitorEnabled":false,"bssidAp":"B5:26:11:7E:A1:36","essidAp":"Ereill","ID":"f6bd4291-098e-4f54-9d20-b5e85a1f5362","name":"D284","reqPower":10.0,"quality":5,"health":100.0,"precio":179,"Type":5,"allowSell":false}]}' where isRented = 1; UPDATE Computer SET Users = REPLACE( Users, '"totalExp":0', '"totalExp":61875' ) WHERE IsPlayer = 1;