Beiträge von ZanchezDE

[requestPersoCivilian]
;;

SQL1_1 = SELECT persoCiv FROM perso WHERE pid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-string

;;______________________________________________________________
[updatePersoCivilian]
;;

SQL1_1 = UPDATE perso SET persoCiv=? WHERE pid=?

Number of Inputs = 2
SQL1_INPUTS = 2,1

;;______________________________________________________________
[insertPerso]
SQL1_1 = INSERT INTO perso(pid, persoCop, persoMed, persoCiv) VALUES (?,'[]','[]','[]');

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________

;; Version 4.1
;;
;; Status: im Lifebetrieb
;;
;; Stand: 01.11.2015
;;
;; Beschreibung: Konfiguration @extDB2 (Altis Life 4.0 ;; tauglich
;;
;; Entwickler: Media (Xylometachlorid) von Berlin Life
;; Kontakt: [email protected]

[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 = \/\|;{}<>'`

;; INPUT / OUTPUT Options
;; String (Removes " from value, then wraps value with ")
;; BeGUID (Converts value into BEGUID)
;; Check (Sanitize value check)
;; NoCheck
;; Strip (Strips Chars)
;; NoStrip
;;______________________________________________________________
[resetLifeVehicles]
;;

SQL1_1 = CALL resetLifeVehicles;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteDeadVehicles]
;;

SQL1_1 = CALL deleteDeadVehicles;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteOldHouses]
;;

SQL1_1 = CALL deleteOldHouses;

Number of Inputs = 0
Prepared Statement Cache = false

;;______________________________________________________________
[deleteOldGangs]
;;

SQL1_1 = CALL deleteOldGangs;

Number of Inputs = 0
Prepared Statement Cache = false

;;**************************************************************
;;**************************************************************
;; GANGS
;;

;;______________________________________________________________
[gangIDPlayer]
;;

SQL1_1 = SELECT id FROM gangs WHERE members LIKE ? AND active='1';

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________
[gangNameSelectID]
;;

SQL1_1 = SELECT id FROM gangs WHERE name=? AND active=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[gangOwnerSelectID]
;;

SQL1_1 = SELECT id FROM gangs WHERE owner=? AND active=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[gangInsert]
;;

SQL1_1 = INSERT INTO gangs (owner, name, members) VALUES(?,?,?);
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[gangUpdate]
;;

SQL1_1 = UPDATE gangs SET active=1, owner=?,members=? WHERE id=?;

Number of Inputs = 3
SQL1_INPUTS = 1, 2, 3

;;______________________________________________________________
[gangRemove]
;;

SQL1_1 = UPDATE gangs SET active='0' WHERE id=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[gangInfo]
;; Get Gang Info
;;

SQL1_1 = SELECT id, owner, name, maxmembers, bank, members FROM gangs WHERE active='1' AND members LIKE ?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2-String, 3-String, 4, 5, 6

;;______________________________________________________________
[gangBankInfoUpdate]
;; Update Gang Bank
;;

SQL1_1 = UPDATE gangs SET bank=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangInfoUpdate]
;; Update Gang Info
;;

SQL1_1 = UPDATE gangs SET bank=?, maxmembers=?, owner=? WHERE id=?;
SQL1_INPUTS = 1, 2, 3-String, 4

Number of Inputs = 4

;;______________________________________________________________
[gangMaxMembersUpdate]
;; Update Gang Max Members
;;

SQL1_1 = UPDATE gangs SET maxmembers=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangMembersUpdate]
;; Update Gang Members
;;

SQL1_1 = UPDATE gangs SET members=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[gangOwnerUpdate]
;; Update Gang Owner
;;

SQL1_1 = UPDATE gangs SET owner=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;**************************************************************
;;**************************************************************
;; PLAYERS
;;

;;______________________________________________________________
[playerInfo]
;;

SQL1_1 = SELECT playerid, name FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2

;;______________________________________________________________
[requestPersoWest]
;;

SQL1_1 = SELECT persoCop FROM perso WHERE pid=?;
SQL1_INPUTS = 1

OUTPUT = 1-string

;;______________________________________________________________
[requestPersoCivilian]
;;

SQL1_1 = SELECT persoCiv FROM perso WHERE pid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-string

;;______________________________________________________________
[requestPersoIndependent]
;;

SQL1_1 = SELECT persoMed FROM perso WHERE pid=?;
SQL1_INPUTS = 1

OUTPUT = 1-string

;;______________________________________________________________
[updatePersoCivilian]
;;

SQL1_1 = UPDATE perso SET persoCiv=? WHERE pid=?

Number of Inputs = 2
SQL1_INPUTS = 2,1

;;______________________________________________________________
[updatePersoWest]
;;

SQL1_1 = UPDATE perso SET persoCop=? WHERE pid=?
SQL1_INPUTS = 2,1

;;______________________________________________________________
[updatePersoIndependent]
;;

SQL1_1 = UPDATE perso SET persoMed=? WHERE pid=?
SQL1_INPUTS = 2,1

;;______________________________________________________________
[playerInfoInsert]
;;

SQL1_1 = INSERT INTO players
;;1 2 3 4 5 6 7 8 9 10 11
SQL1_2 = (playerid, name, cash, bankacc, westcash, westbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);

SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

Number of Inputs = 13

;;______________________________________________________________
[insertPerso]
SQL1_1 = INSERT INTO perso(pid, persoCop, persoMed, persoCiv) VALUES (?,'[]','[]','[]');

Number of Inputs = 1
SQL1_INPUTS = 1

;;______________________________________________________________
[playerWestInfo]
;;

SQL1_1 = SELECT playerid, name, westcash, westbankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9, 10

;;______________________________________________________________
[playerCivInfo]
;;

SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, civ_licenses, arrested, civ_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9

;;______________________________________________________________
[playerIndependentInfo]
;;

SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, med_licenses, mediclevel, med_gear FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9

;;______________________________________________________________
[playerWestUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________
[playerCivilianUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6 7
SQL1_2 = SET name=?, cash=?, bankacc=?, civ_licenses=?, civ_gear=?, arrested=? WHERE playerid=?;

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6, 7

Number of Inputs = 7

;;______________________________________________________________
[playerIndependentUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, med_licenses=?, med_gear=? WHERE playerid=?;

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________
[playerUpdateCash]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cash=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerWestUpdateBank]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________
[playerUpdateBank]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET bankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateBank+Cash]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cash=?, bankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[playerWestUpdateBank+Cash]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westcash=?, westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________
[playerUpdateCopLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cop_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCivLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET civ_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateMedLicense]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET med_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCopGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET cop_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateCivGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET civ_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateMedGear]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET med_gear=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateAlive]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET alive=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;______________________________________________________________
[playerUpdateArrested]
;;

SQL1_1 = UPDATE players
SQL1_2 = SET arrested=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2

;;**************************************************************
;;**************************************************************
;; VEHICLES
;;

;;______________________________________________________________
[vehicleDead]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleInsert]
;;

SQL1_1 = INSERT INTO vehicles
;;1 2 3 4 5 6 7 8 9
SQL1_2 = (side, classname, type, pid, alive, active, inventory, color, plate)
SQL1_3 = VALUES (?,?,?,?,?,?,?,?,?);

SQL1_INPUTS = 1, 2, 3, 4, 5, 6, 7, 8, 9
Number of Inputs = 9

;;______________________________________________________________
[vehicleInfo]
;;

;;1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE id=? AND pid=?;
SQL1_INPUTS = 1, 2
Number of Inputs = 2

OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9

;;______________________________________________________________
[vehiclesInfo]
;;

;;1 2 3 4 5 6 7 8 9
SQL1_1 = SELECT id, side, classname, type, pid, alive, active, plate, color
SQL1_2 = FROM vehicles WHERE pid=? AND alive=1 AND active = 0 AND side=? AND type=?;
SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

OUTPUT = 1, 2-String, 3-String, 4-String, 5-String, 6, 7, 8, 9

;;______________________________________________________________
[vehicleUpdateActive]
;;

SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND id=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateActivePlate]
;;

SQL1_1 = UPDATE vehicles SET active=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateAlive]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND id=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;______________________________________________________________
[vehicleUpdateAlivePlate]
;;

SQL1_1 = UPDATE vehicles SET alive=? WHERE pid=? AND plate=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3

;;**************************************************************
;;**************************************************************
;; Wanted System
;;

;;______________________________________________________________
[housingCount]
;;

SQL1_1 = SELECT COUNT(*) FROM houses WHERE owned='1';

Number of Inputs = 0

;;______________________________________________________________
[housingInit]
;;

SQL1_1 = SELECT houses.id, houses.pid, houses.pos, players.name FROM houses INNER JOIN players ON houses.pid=players.playerid WHERE houses.owned='1' LIMIT ?,10;

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1, 2-String, 3-String, 4-String

;;______________________________________________________________
[housingFetchPlayerHouse]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1-String, 2-String, 3, 4

;;______________________________________________________________
[housingCheckHouse]
;;

SQL1_1 = SELECT CASE
SQL1_2 = WHEN EXISTS(SELECT id FROM houses WHERE pos=? AND owned='1')
SQL1_3 = THEN 'false' ELSE 'true'
SQL1_4 = END

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1

;;______________________________________________________________
[housingAddHouse]
;;
SQL1_1 = INSERT INTO houses (pid, pos, inventory, containers, owned)
SQL1_2 = VALUES(?,?,?,?,?);
SQL1_INPUTS = 1, 2, 3, 4, 5
SQL2_1 = SELECT id FROM houses WHERE pos=? AND pid=? AND owned='1';
SQL2_INPUTS = 2, 1

Number of Inputs = 5
OUTPUT = 1

;;______________________________________________________________
[housingSellHouse]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE pid=? AND pos=? AND owned='1';
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[housingSellHouse2]
;;
SQL1_1 = UPDATE houses SET owned='0', pos='[]', inventory='[[],0]', containers='[]' WHERE id=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[houseUpdateContainer]
;;
SQL1_1 = UPDATE houses SET containers=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[housingUpdateInventory]
;;
SQL1_1 = UPDATE houses SET inventory=? WHERE id=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[housingCleanup]
;;
SQL1_1 = SELECT pid, pos, inventory, containers FROM houses WHERE pid=? AND owned='1';
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4

;;**************************************************************
;;**************************************************************
;; Wanted System
;;

;;______________________________________________________________
[wantedGetCrimes]
;;

SQL1_1 = SELECT wantedID, wantedCrimes FROM wanted WHERE wantedID=?;

SQL1_INPUTS = 1
Number of Inputs = 1

OUTPUT = 1-String, 2

;;______________________________________________________________
[wantedUpdateCrimes]
;;

SQL1_1 = UPDATE wanted SET wantedCrimes = ?, wantedBounty = wantedBounty + ?, active = '1' WHERE wantedID=?;
SQL1_INPUTS = 1, 2, 3

Number of Inputs = 3

;;______________________________________________________________
[wantedInsertCrimes]
;;

SQL1_1 = INSERT INTO wanted (wantedID, wantedName, wantedCrimes, wantedBounty, active)
SQL1_2 = VALUES(?,?,?,?,?);

SQL1_INPUTS = 1, 2, 3, 4, 5

Number of Inputs = 5

;;______________________________________________________________
[wantedFetchBounty]
;;

SQL1_1 = SELECT wantedID, wantedName, wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1

OUTPUT = 1-String, 2-String, 3, 4

;;______________________________________________________________
[wantedFetchCrimes]
;;

SQL1_1 = SELECT wantedCrimes, wantedBounty FROM wanted WHERE active='1' AND wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1, 2

;;______________________________________________________________
[wantedFetchID]
;;

SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1' AND wantedID in (?);
SQL1_INPUTS = 1-STRIP

Number of Inputs = 1
OUTPUT = 1-String, 2-String

;;______________________________________________________________
[wantedFetchPerson]
;;

SQL1_1 = SELECT wantedID, wantedName, wantedBounty FROM wanted WHERE wantedID=? AND active='1';
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3

;;______________________________________________________________
[wantedFetchName]
;;

SQL1_1 = SELECT wantedName FROM wanted WHERE wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String

;;______________________________________________________________
[wantedFetchIDAll]
;;

SQL1_1 = SELECT wantedID, wantedName FROM wanted WHERE active='1';

OUTPUT = 1-String, 2-String
;;______________________________________________________________
[wantedUpdateName]
;;

SQL1_1 = UPDATE wanted
SQL1_2 =SET wantedName=? WHERE wantedID=?;
SQL1_INPUTS = 1, 2

Number of Inputs = 2

;;______________________________________________________________
[wantedRemoveCrimes]
;;

SQL1_1 = UPDATE wanted
SQL1_2 =SET active = 0, wantedCrimes = '[]', wantedBounty = 0 WHERE wantedID=?;
SQL1_INPUTS = 1

Number of Inputs = 1

;;______________________________________________________________
[DYNMARKET_Price_Set]
;;
SQL1_1 = UPDATE dynmarket SET prices = ? WHERE id=1;
SQL1_INPUTS = 1
Number of Inputs = 1
;;______________________________________________________________
[DYNMARKET_Price_Get]
;;
SQL1_1 = SELECT prices FROM dynmarket WHERE id=1;
OUTPUT = 1

/*
Autor: Felix von Studsinske
Dateiname: fn_persoRequest.sqf
Beschreibung:
Sucht in der DB nach Einträgen für den Personalausweis je nach Fraktion.

Sie dürfen meine Funktionen/Scripte nur mit der "License-FvS.txt" nutzen sowie der Einhaltung der Regeln.
Im Missionshauptverzeichnis oder in einem leicht zu findenen Ordner muss die "License-FvS.txt" vorhanden sein!
Beispiel-Pfad:
Altis_Life.Altis\License-FvS.txt
MyExampleMission.Altis\License-FvS.txt
You are only allowed to use my scripts/functions with my littly "License-FvS.txt" and the agreements to the rules.
The "License-FvS.txt" has to be in your mission root folder or in an easy to finding folder
Destination example:
Altis_Life.Altis\License-FvS.txt
MyExampleMission.Altis\License-FvS.txt
*/
params [
["_uid","",[""]],
["_side",sideUnknown,[sideUnknown]],
["_player",objNull,[objNull]]
];

if(isNull _player) exitWith {}; // Gibt's nicht

_query = switch(_side) do
{
case west:
{
format["requestPersoWest:%1",_uid];
};
case independent:
{
format["requestPersoIndependent:%1",_uid];
};
case civilian:
{
format["requestPersoCivilian:%1",_uid];
};
//case east:
//{
// format["requestPersoEast:%1",_uid];
//};
};

_queryResult = [_query,2] call DB_fnc_asyncCall;

if(count _queryResult == 0 _queryResult isEqualTo []) exitWith {
_query_2 = format["insertPerso:%1",_uid];
[_query_2,1] call DB_fnc_asyncCall;
[] remoteExecCall ["fvs_fnc_persoNeu",(owner _player)];
};
_result = ((_queryResult select 0)select 0);
_ergebnis = [_result] call DB_fnc_mresToArray;
[_ergebnis] remoteExecCall ["fvs_fnc_persoErgebnis",(owner _player)];

-- ----------------------------
-- Table structure for `perso`
-- ----------------------------
DROP TABLE IF EXISTS `perso`;
CREATE TABLE `perso` (
`id` int(12) NOT NULL AUTO_INCREMENT,
`pid` varchar(50) NOT NULL DEFAULT '',
`persoCop` text NOT NULL,
`persoMed` text NOT NULL,
`persoCiv` text NOT NULL,
`Erstellungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`Aenderungsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`,`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of perso
-- ----------------------------
INSERT INTO `perso` VALUES ('4', '76561198042173943', '[]', '[]', '\"[`Günther Gundula`,`64`,`M`,`A`,`Kleine Felswand`,`76942173943`,`Gü[email protected]`,`170`,`55`,`1`,`1`,`1950`,`39071`,`0`,`1`]\"', '2016-10-21 16:14:34', '2016-10-21 16:14:41');

[19:50:41:491 +02:00] [Thread 5240] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Input String UPDATE dynmarket SET prices = '[["peach",150,0],["salema_raw",800,0],["salema",80,0],["ornate_raw",800,0],["ornate",80,0],["mackerel_raw",1000,0],["mackerel",100,0],["tuna_raw",2000,0],["tuna",190,0],["mullet_raw",900,0],["mullet",90,0],["catshark_raw",1700,0],["catshark",170,0],["rabbit_raw",1250,0],["rabbit",125,0],["hen_raw",1000,0],["hen",100,0],["rooster_raw",1200,0],["rooster",120,0],["sheep_raw",2100,0],["sheep",210,0],["goat_raw",3000,0],["goat",300,0],["oil_unprocessed",800,0],["oil_processed",2600,0],["copper_unrefined",250,0],["copper_refined",2250,0],["iron_unrefined",325,0],["iron_refined",1800,0],["salt_unrefined",175,0],["salt_refined",1750,0],["sand",200,0],["glass",2000,0],["diamond_uncut",500,0],["diamond_cut",3500,0],["goldbar",95000,0],["rock",300,0],["cement",1000,0],["heroin_unprocessed",750,0],["heroin_processed",4800,0],["cannabis",400,0],["marijuana",4200,0],["cocaine_unprocessed",700,0],["cocaine_processed",5300,0]]' WHERE id=1;
[19:50:41:491 +02:00] [Thread 5240] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Callname UPDATE dynmarket SET prices = '[["peach",150,0],["salema_raw",800,0],["salema",80,0],["ornate_raw",800,0],["ornate",80,0],["mackerel_raw",1000,0],["mackerel",100,0],["tuna_raw",2000,0],["tuna",190,0],["mullet_raw",900,0],["mullet",90,0],["catshark_raw",1700,0],["catshark",170,0],["rabbit_raw",1250,0],["rabbit",125,0],["hen_raw",1000,0],["hen",100,0],["rooster_raw",1200,0],["rooster",120,0],["sheep_raw",2100,0],["sheep",210,0],["goat_raw",3000,0],["goat",300,0],["oil_unprocessed",800,0],["oil_processed",2600,0],["copper_unrefined",250,0],["copper_refined",2250,0],["iron_unrefined",325,0],["iron_refined",1800,0],["salt_unrefined",175,0],["salt_refined",1750,0],["sand",200,0],["glass",2000,0],["diamond_uncut",500,0],["diamond_cut",3500,0],["goldbar",95000,0],["rock",300,0],["cement",1000,0],["heroin_unprocessed",750,0],["heroin_processed",4800,0],["cannabis",400,0],["marijuana",4200,0],["cocaine_unprocessed",700,0],["cocaine_processed",5300,0]]' WHERE id=1;

8:36:57 "------------------------------------------------------------------------------------------------------"
8:36:57 "--------------------------------- Starting Altis Life Client Init ----------------------------------"
8:36:57 "------------------------------------------------------------------------------------------------------"
8:36:57 "::Life Client:: Initialization Variables"
8:36:57 "::Life Client:: Variables initialized"
8:36:57 "::Life Client:: Setting up Eventhandlers"
8:36:57 "::Life Client:: Eventhandlers completed"
8:36:57 "::Life Client:: Setting up user actions"
8:36:57 "::Life Client:: User actions completed"
8:36:57 "::Life Client:: Waiting for server functions to transfer.."
8:36:57 "::Life Client:: Received server functions."
8:36:57 "::Life Client:: Waiting for the server to be ready.."
8:36:57 [ACE] (common) INFO: Settings received from server.
8:36:57 [ACE] (interaction) INFO: Interaction Module Initialized.
8:36:57 [ACE] (common) INFO: Settings initialized.
8:36:58 [ACE] (common) INFO: 57 delayed functions running.
8:36:58 [ACE] (common) INFO: JIP event synchronization initialized
8:36:58 [ACE] (medical) INFO: JIP Medical init for player.
8:37:01 [672169,15.7947,36395.9,159.729,[33c58100# 2342202: rabbit_f.p3d],"Rabbit_F",[947.277,1602.25,-0.0418254]]
8:37:01 [672170,14.9254,36396,159.782,[Agent 0x67280b40],"Rabbit_F",[947.277,1602.25,-0.0418254]]
8:37:03 Error in expression <angData = (_this select 11);
if(!(count life_gangData isEqualTo 0)) then {
[] sp>
8:37:03 Error position: <life_gangData isEqualTo 0)) then {
[] sp>
8:37:03 Error Nicht definierte Variable in Ausdruck: life_gangdata
8:37:03 File mpmissions\__CUR_MP.australia\core\session\fn_requestReceived.sqf, line 75
8:37:04 Warning Message: No entry 'mpmissions\__CUR_MP.australia\http://description.ext/life_spawn_sel…View.LineMarker'.
8:37:04 Warning Message: No entry '.lineWidthThin'.
8:37:04 Warning Message: '/' is not a value
8:37:04 Warning Message: No entry '.lineWidthThick'.
8:37:04 Warning Message: '/' is not a value
8:37:04 Warning Message: No entry '.lineDistanceMin'.
8:37:04 Warning Message: '/' is not a value
8:37:04 Warning Message: No entry '.lineLengthMin'.
8:37:04 Warning Message: '/' is not a value
8:37:20 "Past Settings Init"
8:37:20 "Executing client.fsm"
8:37:20 "Display 46 Found"
8:37:20 "------------------------------------------------------------------------------------------------------"
8:37:20 " End of Altis Life Client Init :: Total Execution Time 23.2695 seconds "
8:37:20 "------------------------------------------------------------------------------------------------------"
8:37:35 [672305,0.713999,36429.5,167.295,[4c228100# 2342218: snake_f.p3d],"Snake_random_F",[31176.4,10731.9,1.99803]]
8:37:36 [672306,0.685753,36430.5,167.395,[Agent 0x7045a3c0],"Snake_random_F",[31176.4,10731.9,1.99803]]
8:37:38 [672320,3.80862,36433,168.795,[6f81d600# 2342230: snake_f.p3d],"Snake_random_F",[31178.1,10710.6,2.08205]]
8:37:38 [672321,3.70885,36433.1,168.895,[Agent 0x6ae3c740],"Snake_random_F",[31178.1,10710.6,2.08205]]
8:37:39 [672324,6.46204,36433.5,169.195,[3468eb00# 2342232: rabbit_f.p3d],"Rabbit_F",[30946.6,11117.6,3.84158]]
8:37:39 [672325,6.77966,36433.6,169.295,[Agent 0x67280b40],"Rabbit_F",[30946.6,11117.6,3.84158]]
8:37:45 [672375,8.65801,36439.3,173.914,[8ff74100# 2342236: rabbit_f.p3d],"Rabbit_F",[31144.5,11160.7,3.91583]]
8:37:45 [672376,8.35073,36439.4,174.014,[Agent 0x5826e880],"Rabbit_F",[31144.5,11160.7,3.91583]]
8:37:55 [672447,19.802,36450,178.628,[335ac100# 2342241: rabbit_f.p3d],"Rabbit_F",[31524.4,10928.1,3.92665]]
8:37:55 [672448,16.8776,36450.1,178.728,[Agent 0x582829c0],"Rabbit_F",[31524.4,10928.1,3.92665]]
8:38:00 [672539,19.5122,36454.8,183.345,[3ad18100# 2342246: rabbit_f.p3d],"Rabbit_F",[31400.1,11073.1,3.91583]]
8:38:00 [672540,17.0032,36454.9,183.445,[Agent 0x58264a80],"Rabbit_F",[31400.1,11073.1,3.91583]]
8:38:05 [672631,20.0753,36459.5,188.062,[34681600# 2342251: rabbit_f.p3d],"Rabbit_F",[30892.2,11086.6,3.91583]]
8:38:05 [672632,19.536,36459.5,188.112,[Agent 0x58278ac0],"Rabbit_F",[30892.2,11086.6,3.91583]]
8:38:09 [672725,19.8511,36464.2,192.803,[49462b00# 2342254: rabbit_f.p3d],"Rabbit_F",[31110.3,11159.9,3.91583]]
8:38:10 [672726,18.6916,36464.3,192.872,[Agent 0x705fa140],"Rabbit_F",[31110.3,11159.9,3.91583]]
8:38:14 [672818,19.9253,36468.9,197.535,[49460100# 2342256: rabbit_f.p3d],"Rabbit_F",[31574.4,10759.4,2.82078]]
8:38:14 [672819,19.6319,36469,197.585,[Agent 0x70604180],"Rabbit_F",[31574.4,10759.4,2.82078]]
8:38:19 [672911,19.8758,36473.8,202.277,[513d6b00# 2342259: rabbit_f.p3d],"Rabbit_F",[31465.1,11013.5,3.91583]]
8:38:19 [672912,17.9977,36473.8,202.377,[Agent 0x66696180],"Rabbit_F",[31465.1,11013.5,3.91583]]

[playerInfoInsert]
;;

SQL1_1 = INSERT INTO players
;;1 2 3 4 5 6 7 8 9 10 11
SQL1_2 = (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?);

SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11

Number of Inputs = 11

;;______________________________________________________________

[playerInfoInsert]
;;

SQL1_1 = INSERT INTO players
;;1 2 3 4 5 6 7 8 9 10 11 12 13
SQL1_2 = (playerid, name, cash, bankacc, westcash, westbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);

SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

Number of Inputs = 13

;;______________________________________________________________

[playerWestInfo]
;;

SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9, 10

;;______________________________________________________________

[playerWestInfo]
;;

SQL1_1 = SELECT playerid, name, westcash, westbankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;
SQL1_INPUTS = 1

Number of Inputs = 1
OUTPUT = 1-String, 2-String, 3, 4, 5-String, 6-String, 7, 8-String, 9, 10

;;______________________________________________________________

[playerWestUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________

[playerWestUpdate]
;;

SQL1_1 = UPDATE players
;;1 2 3 4 5 6
SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?;

SQL1_INPUTS = 1-String, 2, 3, 4, 5, 6

Number of Inputs = 6

;;______________________________________________________________

[playerWestUpdateBank]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2
Number of Inputs = 2
;;______________________________________________________________

[playerWestUpdateBank+Cash]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET westcash=?, westbankacc=? WHERE playerid=?;

SQL1_INPUTS = 1, 2, 3
Number of Inputs = 3
;;______________________________________________________________

case 1: {
_value = [_this,2,0,[0]] call BIS_fnc_param;
_value = [_value] call DB_fnc_numberSafe;
_query = format["UPDATE players SET bankacc='%1' WHERE playerid='%2'",_value,_uid];
};

case 1: {
_value = [_this,2,0,[0]] call BIS_fnc_param;
_value = [_value] call DB_fnc_numberSafe;
switch(_side)do {
case civilian: {_query = format["playerUpdateBank:%1:%2",_value,_uid];};
case west: {_query = format["playerWestUpdateBank:%1:%2",_value,_uid];};
case independent: {_query = format["playerUpdateBank:%1:%2",_value,_uid];};
};
};

case 6: {
_value1 = [_this,2,0,[0]] call BIS_fnc_param;
_value2 = [_this,4,0,[0]] call BIS_fnc_param;
_value1 = [_value1] call DB_fnc_numberSafe;
_value2 = [_value2] call DB_fnc_numberSafe;
_query = format["UPDATE players SET cash='%1', bankacc='%2' WHERE playerid='%3'",_value1,_value2,_uid];
};

case 6: {
_value1 = [_this,2,0,[0]] call BIS_fnc_param;
_value2 = [_this,4,0,[0]] call BIS_fnc_param;
_value1 = [_value1] call DB_fnc_numberSafe;
_value2 = [_value2] call DB_fnc_numberSafe;
switch(_side)do {
case civilian: {_query = format["playerUpdateBank+Cash:%1:%2:%3",_value1,_value2,_uid];};
case west: {_query = format["playerWestUpdateBank+Cash:%1:%2:%3",_value1,_value2,_uid];};
case independent: {_query = format["playerUpdateBank+Cash:%1:%2:%3",_value1,_value2,_uid];};
};
};

//Prepare the query statement..
_query = format["playerInfoInsert:%1:%2:%3:%4:%5:%6:%7:%8:%9:%10:%11",
_uid,
_name,
_money,
_bank,
_alias,
[], // Cop Licenses
[], // Med Licenses
[], // Civ Licenses
[], // Civ Gear
[], // Cop Gear
[] // Med Gear
];

//Prepare the query statement..
_query = format["playerInfoInsert:%1:%2:%3:%4:%5:%6:%7:%8:%9:%10:%11:%12:%13",
_uid,
_name,
_money,
_bank,
_money,
_bank,
_alias,
[], // Cop Licenses
[], // Med Licenses
[], // Civ Licenses
[], // Civ Gear
[], // Cop Gear
[] // Med Gear
];

/*
##################### DYNAMIC MARKET SCRIPT #####################
### AUTHOR: RYAN TT. ###
### STEAM: https://nodezone.net/www.steamcommunity.com/id/ryanthett ###
### ###
### DISCLAIMER: THIS SCRIPT CAN BE USED ON EVERY SERVER ONLY ###
### WITH THIS HEADER / NOTIFICATION ###
#################################################################
*/

// ███████████████████████████████████████████████████████████████████████
// █████████████████ CONFIGURATION DE BASE DE LA BOURSE ██████████████████
// ███████████████████████████████████████████████████████████████████████

DYNMARKET_Serveruptime = 06; // La durée de fonctionnement jusqu'au prochain redémarrage du serveur en heures.
DYNMARKET_UseExternalDatabase = false; // Si le script utilise une base de données externe ?
DYNMARKET_PriceUpdateInterval = 01; // Après combien de minutes devrait être mis à jour le prix ?
DYNMARKET_CreateBackups = true; // Si le serveur ne sauvegarde pas les prix régulièrement dans la base de données, il le fera lorsque le serveur de redémarre ?
DYNMARKET_CreateBackupInterval = 03; // Après combien de mises à jour de la bourse le serveur devrait-il sauvegarder les prix dans la base de données ?
DYNMARKET_UserNotification = false; // Est-ce que les joueurs devraient être informé par un message (hint) à chaque fois que la bourse est mise à jour ?

// █████████████████ TEXTES DE NOTIFICATION █████████████████

DYNMARKET_UserNotification_Text =
[
"Die Preise wurden aktualisiert!",
"Die neuen Preise werden auf dem Server aktualisiert ..."
];

// █████████████████ CONFIGURATION DU GROUPE D'ARTICLES █████████████████

DYNMARKET_Items_Groups =
[
["Autres",
[
["blastingcharge",-1,17500,17500],
["boltcutter",-1,3750,3750],
["excavator",-1,2500,2500],
["defusekit",-1,1250,1250],
["gpstracker",-1,500,500],
["fuelEmpty",-1,212,212],
["fuelFull",-1,425,425],
["lockpick",-1,500,500],
["pickaxe",-1,325,325],
["waterBottle",-1,5,5],
["coffee",-1,5,5],
["donuts",-1,60,60],
["redgull",-1,750,750],
["tbacon",-1,37,37],
["spikeStrip",-1,1250,1250],
["storagebig",-1,75000,75000],
["storagesmall",-1,37500,37500]
],
0
],
["Fruits & Legumes",
[
["apple",-1,100,200],
["peach",-1,100,200]
],
0.5
],
["Poissonerie",
[
["salema_raw",-1,100,1500],
["salema",-1,10,150],

["ornate_raw",-1,100,1500],
["ornate",-1,10,150],

["mackerel_raw",-1,300,1700],
["mackerel",-1,30,170],

["tuna_raw",-1,1300,2700],
["tuna",-1,130,270],

["mullet_raw",-1,200,1600],
["mullet",-1,20,160],

["catshark_raw",-1,1000,2400],
["catshark",-1,100,240]
],
0.5
],
["Boucherie",
[
["rabbit_raw",-1,550,1950],
["rabbit",-1,55,195],

["hen_raw",-1,300,1700],
["hen",-1,30,170],

["rooster_raw",-1,500,1900],
["rooster",-1,50,190],

["sheep_raw",-1,1400,2800],
["sheep",-1,140,280],

["goat_raw",-1,2300,3700],
["goat",-1,230,370]
],
0.5
],
["Ressources",
[
["oil_unprocessed",-1,700,900],
["oil_processed",-1,7000,9000],

["copper_unrefined",-1,150,350],
["copper_refined",-1,1500,3500],

["iron_unrefined",-1,225,425],
["iron_refined",-1,2250,4250],

["salt_unrefined",-1,75,275],
["salt_refined",-1,750,2750],

["sand",-1,100,300],
["glass",-1,1000,3000],

["diamond_uncut",-1,400,600],
["diamond_cut",-1,4000,6000],

["rock",-1,200,400],
["cement",-1,2000,4000],

["medmarijuana",-1,1000,3000]
],
0.5
],
["Illegaux",
[
["cocaine_unprocessed",1,700,900],
["cocaine_processed",1,7000,9000],

["heroin_unprocessed",1,550,950],
["heroin_processed",1,6500,8500],

["cannabis",1,400,600],
["marijuana",1,4000,6000],
["goldbar",1,85000,105000]
],
0.5
]
];

// █████████████████ TOUS LES ARTICLES VENDABLE █████████████████

DYNMARKET_Items_ToTrack =
[
["waterBottle",5],
["coffee",5],
["donuts",60],
["redgull",750],
["apple",150],
["peach",150],
["salema_raw",800],
["salema",80],
["ornate_raw",800],
["ornate",80],
["mackerel_raw",1000],
["mackerel",100],
["tuna_raw",2000],
["tuna",190],
["mullet_raw",900],
["mullet",90],
["catshark_raw",1700],
["catshark",170],
["rabbit_raw",1250],
["rabbit",125],
["hen_raw",1000],
["hen",100],
["rooster_raw",1200],
["rooster",120],
["sheep_raw",2100],
["sheep",210],
["goat_raw",3000],
["goat",300],
["oil_unprocessed",800],
["oil_processed",8000],
["copper_unrefined",250],
["copper_refined",2500],
["iron_unrefined",325],
["iron_refined",3250],
["salt_unrefined",175],
["salt_refined",1750],
["sand",200],
["glass",2000],
["diamond_uncut",500],
["diamond_cut",5000],
["goldbar",95000],
["rock",300],
["cement",3000],
["heroin_unprocessed",750],
["heroin_processed",7500],
["cannabis",500],
["marijuana",5000],
["cocaine_unprocessed",800],
["cocaine_processed",8000],
["blastingcharge",17500],
["boltcutter",3750],
["defusekit",1250],
["lockpick",500],
["pickaxe",325],
["fuelEmpty",212],
["fuelFull",425],
["spikeStrip",1250],
["storagebig",75000],
["storagesmall",37500]
];

//███████████████████████████████████████████████████████████████████████
//██████████████████ NE PAS MODIFIER LE CODE SUIVANT! ██████████████████
//███████████████████████████████████████████████████████████████████████

DYNMARKET_Items_CurrentPriceArr = [];
DYNMARKET_sellarraycopy = DYNMARKET_Items_ToTrack;
DYNMARKET_Serveruptime = (DYNMARKET_Serveruptime * 3600) - 300;
{
_currentArray = _x;
DYNMARKET_Items_CurrentPriceArr pushBack [_currentArray select 0,_currentArray select 1,0];
} forEach DYNMARKET_Items_ToTrack;
publicVariable "DYNMARKET_UserNotification";
publicVariable "DYNMARKET_UserNotification_Text";
if (DYNMARKET_UseExternalDatabase) then {[1] call TON_fnc_HandleDB;};
DYNMARKET_UpdateCount = 0;
if (DYNMARKET_UseExternalDatabase) then {
[] spawn {
sleep DYNMARKET_Serveruptime;
diag_log "### DYNMARKET >> LES PRIX ACTUELS SONT EN COURS D'ÉCRITURE DANS LA BASE DE DONNÉES ###";
diag_log "### DYNMARKET >> COMME PRÉVU, RÉSULTAT EN ATTENTE ... ###";
[0] call TON_fnc_HandleDB;
};
};
sleep 5;
[] call TON_fnc_sleeper;

extDB2: Version: 63
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15

extDB2: Found [lexicon]extdb[/lexicon]-conf.ini
extDB2: Detected 6 Cores, Setting up 6 Worker Threads

[23:58:20:418 +02:00] [Thread 2516] extDB2: Database Type: MySQL
[23:58:20:432 +02:00] [Thread 2516] extDB2: Database Session Pool Started
[23:58:20:432 +02:00] [Thread 2516] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\A3Master\@extDB2\[lexicon]extDB[/lexicon]\sql_custom_v2\altis-life-rpg-4.ini
[23:58:20:432 +02:00] [Thread 2516] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
[00:01:41:176 +02:00] [Thread 7600] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Input String UPDATE dynmarket SET prices = '[["waterBottle",5,0],["coffee",5,0],["donuts",60,0],["redgull",750,0],["apple",150,0],["peach",150,0],["salema_raw",800,0],["salema",80,0],["ornate_raw",800,0],["ornate",80,0],["mackerel_raw",1000,0],["mackerel",100,0],["tuna_raw",2000,0],["tuna",190,0],["mullet_raw",900,0],["mullet",90,0],["catshark_raw",1700,0],["catshark",170,0],["rabbit_raw",1250,0],["rabbit",125,0],["hen_raw",1000,0],["hen",100,0],["rooster_raw",1200,0],["rooster",120,0],["sheep_raw",2100,0],["sheep",210,0],["goat_raw",3000,0],["goat",300,0],["oil_unprocessed",800,0],["oil_processed",8000,0],["copper_unrefined",250,0],["copper_refined",2500,0],["iron_unrefined",325,0],["iron_refined",3250,0],["salt_unrefined",175,0],["salt_refined",1750,0],["sand",200,0],["glass",2000,0],["diamond_uncut",500,0],["diamond_cut",5000,0],["goldbar",95000,0],["rock",300,0],["cement",3000,0],["heroin_unprocessed",750,0],["heroin_processed",7500,0],["cannabis",500,0],["marijuana",5000,0],["cocaine_unprocessed",800,0],["cocaine_processed",8000,0],["blastingcharge",17500,0],["boltcutter",3750,0],["defusekit",1250,0],["lockpick",500,0],["pickaxe",325,0],["fuelEmpty",212,0],["fuelFull",425,0],["spikeStrip",1250,0],["storagebig",75000,0],["storagesmall",37500,0]]' WHERE id=1;
[00:01:41:176 +02:00] [Thread 7600] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Callname UPDATE dynmarket SET prices = '[["waterBottle",5,0],["coffee",5,0],["donuts",60,0],["redgull",750,0],["apple",150,0],["peach",150,0],["salema_raw",800,0],["salema",80,0],["ornate_raw",800,0],["ornate",80,0],["mackerel_raw",1000,0],["mackerel",100,0],["tuna_raw",2000,0],["tuna",190,0],["mullet_raw",900,0],["mullet",90,0],["catshark_raw",1700,0],["catshark",170,0],["rabbit_raw",1250,0],["rabbit",125,0],["hen_raw",1000,0],["hen",100,0],["rooster_raw",1200,0],["rooster",120,0],["sheep_raw",2100,0],["sheep",210,0],["goat_raw",3000,0],["goat",300,0],["oil_unprocessed",800,0],["oil_processed",8000,0],["copper_unrefined",250,0],["copper_refined",2500,0],["iron_unrefined",325,0],["iron_refined",3250,0],["salt_unrefined",175,0],["salt_refined",1750,0],["sand",200,0],["glass",2000,0],["diamond_uncut",500,0],["diamond_cut",5000,0],["goldbar",95000,0],["rock",300,0],["cement",3000,0],["heroin_unprocessed",750,0],["heroin_processed",7500,0],["cannabis",500,0],["marijuana",5000,0],["cocaine_unprocessed",800,0],["cocaine_processed",8000,0],["blastingcharge",17500,0],["boltcutter",3750,0],["defusekit",1250,0],["lockpick",500,0],["pickaxe",325,0],["fuelEmpty",212,0],["fuelFull",425,0],["spikeStrip",1250,0],["storagebig",75000,0],["storagesmall",37500,0]]' WHERE id=1;