Hallo, ich habe folgendes Problem.
Mission id: c5eee29756a245b3306d2ef217fbc46fb47dbccd
20:18:00 Game started.
"extDB2: Connected to Database"
"extDB2: Protocol Error: [0,"Error Statement Exception"]"
Error in expression <rray = _queryResult select 0;
if (count _pricearray < 1) then {
diag_log "######>
Error position: <_pricearray < 1) then {
diag_log "######>
Error Undefined variable in expression: _pricearray
File life_server\Functions\DynMarket\fn_HandleDB.sqf, line 33
"### DYNMARKET >> SUCCESSFULLY BACKUP'D CURRENT PRICES TO DATABASE! ###"
"### DYNMARKET >> SUCCESSFULLY BACKUP'D CURRENT PRICES TO DATABASE! ###"
"### DYNMARKET >> SUCCESSFULLY BACKUP'D CURRENT PRICES TO DATABASE! ###"
Code: fn_HandleDB.sqf
/*
##################### DYNAMIC MARKET SCRIPT #####################
### AUTHOR: RYAN TT. ###
### STEAM: www.steamcommunity.com/id/ryanthett ###
### ###
### DISCLAIMER: THIS SCRIPT CAN BE USED ON EVERY SERVER ONLY ###
### WITH THIS HEADER / NOTIFICATION ###
#################################################################
*/
_switch = _this select 0;
_whatanumber = 1;
switch (_switch) do
{
case 0:
{
_query = format["DYNMARKET_Price_Set:%1",DYNMARKET_Items_CurrentPriceArr];
waitUntil {sleep (random 0.3); !DB_Async_Active};
_queryResult = [_query,1] call DB_fnc_asyncCall;
diag_log "### DYNMARKET >> SUCCESSFULLY BACKUP'D CURRENT PRICES TO DATABASE! ###";
};
case 1:
{
_query = format["DYNMARKET_Price_Get"];
waitUntil{sleep (random 0.3); !DB_Async_Active};
_tickTime = diag_tickTime;
_queryResult = [_query,2] call DB_fnc_asyncCall;
//DYNMARKET_Items_CurrentPriceArr = _queryResult select 0;
_pricearray = _queryResult select 0;
if (count _pricearray < 1) then {
diag_log "########################## DYNAMIC MARKET ##########################";
diag_log "### >> CAN'T LOAD PRICES FROM DATABASE: ERROR 01x ###";
diag_log "### THE REQUESTED PRICEARRAY WAS UNEXPECTEDLY EMPTY! ###";
diag_log "### IF YOU ARE RUNNING DYNMARKET FOR THE FIRST TIME, ###";
diag_log "### PLEASE IGNORE THIS ERROR! ###";
diag_log "####################################################################";
} else {
DYNMARKET_Items_CurrentPriceArr = _pricearray;
{
_itemName = _x select 0;
_itemNewPrice = _x select 1;
_index = -1;
{
_index = _index + 1;
_curItemName = _x select 0;
if (_curItemName==_itemName) then {
DYNMARKET_sellarraycopy set [_index,[_itemName,_itemNewPrice]];
};
} forEach DYNMARKET_sellarraycopy;
} forEach DYNMARKET_Items_CurrentPriceArr;
diag_log "########################## DYNAMIC MARKET ##########################";
diag_log "### >> SUCCESSFULLY LOADED PRICES FROM DATABASE! ###";
diag_log "####################################################################";
};
};
};Code
[20:18:00 +02:00] [Thread 7203] extDB2: Database Type: MySQL
[20:18:00 +02:00] [Thread 7203] extDB2: Database Session Pool Started
[20:18:00 +02:00] [Thread 7203] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[20:18:01 +02:00] [Thread 7425] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:18:01 +02:00] [Thread 7425] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Get
[20:21:21 +02:00] [Thread 7423] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:21:21 +02:00] [Thread 7423] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$
[20:24:36 +02:00] [Thread 7426] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:24:36 +02:00] [Thread 7426] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$
[20:27:51 +02:00] [Thread 7422] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:27:51 +02:00] [Thread 7422] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$
[20:31:06 +02:00] [Thread 7421] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:31:06 +02:00] [Thread 7421] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$
[20:34:21 +02:00] [Thread 7424] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:34:21 +02:00] [Thread 7424] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$
[20:37:36 +02:00] [Thread 7425] extDB2: SQL_RAW_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your $
[20:37:36 +02:00] [Thread 7425] extDB2: SQL_RAW_V2: Error StatementException: SQL: DYNMARKET_Price_Set:[["apple",25,0],["peach",50,0],["tbacon",125,0],["donut",130,0],["rabbit_raw",150,0],["rabbit_grilled",170,0],["ornate_raw",190,0],["$Code: @life_server\addons\life_server\Functions\DynMarket/fn_config.sqf
/*
##################### DYNAMIC MARKET SCRIPT #####################
### AUTHOR: RYAN TT. ###
### STEAM: www.steamcommunity.com/id/ryanthett ###
### ###
### DISCLAIMER: THIS SCRIPT CAN BE USED ON EVERY SERVER ONLY ###
### WITH THIS HEADER / NOTIFICATION ###
#################################################################
*/
// ███████████████████████████████████████████████████████████████████████
// █████████████████ DYNAMIC MARKET BASIC CONFIGURATION ██████████████████
// ███████████████████████████████████████████████████████████████████████
DYNMARKET_Serveruptime = 05; // Serveruptime after restart in hours
DYNMARKET_UseExternalDatabase = true; // Should the script use the External Database?
DYNMARKET_PriceUpdateInterval = 01; // After how many minutes should the price be updated?
DYNMARKET_CreateBackups = true; // Should the server save write the prices regulary into the Database? If false, it will save the prices before Server-restart?
DYNMARKET_CreateBackupInterval = 03; // After how many updates (PriceUpdateIntervals) should the prices be saved into the Database?
DYNMARKET_UserNotification = true; // Should the user be informed with a hint whenever the prices got updated?
// █████████████████ USER NOTIFICATION TEXTS █████████████████
DYNMARKET_UserNotification_Text =
[
"Your prices have been updated!",
"The new prices are being calculated by the server..."
];
// █████████████████ ITEM GROUP CONFIGURATION █████████████████
DYNMARKET_Items_Groups =
[
["Legal",
[
["apple",-1,10,50],
["peach",-1,30,100]
],
0.5
],
["Illegal",
[
/*["peach",1,30,100]*/
],
0.5
]
];
// █████████████████ ALL SELLABLE ITEMS █████████████████
DYNMARKET_Items_ToTrack =
[
["apple",25],
["peach",50],
["tbacon",125],
["donut",130],
["rabbit_raw",150],
["rabbit_grilled",170],
["ornate_raw",190],
["ornate_grilled",190],
["mackerel_raw",190],
["mackerel_grilled",190],
["tuna_raw",190],
["tuna_grilled",190],
["mullet_raw",190],
["mullet_fried",200],
["catshark_raw",200],
["catshark_Fried",200],
["turtle_soup",200],
["hen_raw",200],
["hen_fried",200],
["rooster_raw",210],
["sheep_raw",210],
["sheep_grilled",155],
["goat_raw",155],
["goat_grilled",300],
["redgull",1500],
["coffee",10],
["waterBottle",10],
["pickaxe",350],
["fuelFull",500],
["spikeStrip",1200],
["lockpick",75],
["goldbar",95000],
["blastingcharge",35000],
["boltcutter",7500],
["defusekit",2500],
["storagesmall",75000],
["storagebig",15000],
["oil_processed",1200],
["copper_refined",1700],
["iron_refined",1650],
["salt_refined",1850],
["glass",1450],
["diamond_cut",2530],
["cement",2350],
["heroin_processed",5000],
["marijuana",5250],
["cocaine_processed",5300]
];
//███████████████████████████████████████████████████████████████████████
//██████████████████ DO NOT MODIFY THE FOLLOWING CODE! ██████████████████
//███████████████████████████████████████████████████████████████████████
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 >> CURRENT PRICES ARE BEING WRITTEN TO THE DATABASE ###";
diag_log "### DYNMARKET >> AS PLANNED, AWAITING RESULT... ###";
[0] call TON_fnc_HandleDB;
};
};
sleep 5;
[] call TON_fnc_sleeper;Mfg
