Beiträge von PoweredByte

PoweredByte

Im Anhang befindet sich die Datei ;). Du musst natürlich noch die [lexicon]extdb[/lexicon]-conf.ini nach deinen Wünschen anpassen

EDIT:

Führe vorsichthalbar nochmal diesen Befehl als Root aus:

apt-get install libtbb2 lib32gcc1 lib32stdc++6 libtbb2:i386

Damit installierst du alle benötigten Programme für extDB2

PoweredByte

Das Problem ist das du offensichtlich versuchst dll's unter Linux zu lesen, dies ist nicht möglich ohne eine Windows VM (Korrigiert mich wenn ich falsch liege). Du brauchst eine extDB2 für Linux, schreib mich bitte mal Privat an, ich werde dir dann eine Linux Variante schicken.

Mfg Lukas

PoweredByte

Du kannst den Server über eine .bat bzw .sh starten lassen

das könnte dann z.B so aussehen:

Code: start.bat (Windows)

@echo off




start "arma3server.exe" -port=2302 -parameter

Solltest du Linux verwenden

Code: start.sh (Linux)

./arma3server.exe -port=2302 -parameter

PoweredByte

Funktioniert leider immernoch nicht, folgender Fehler:

Code

9:12:28 Game started.
"extDB2: Connected to Database"
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 34

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["UPDATE dynmarket SET prices='%1' WHERE id=1",DYNMARKET_Items_CurrentPriceArr];
/*		_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"];														*/
		_query = format["SELECT prices FROM dynmarket WHERE id=1"];
/*		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 "####################################################################";
		};
	};
};

Alles anzeigen

PoweredByte

Was soll ich jetzt genau ändern?, bzw. in welchen Dateien?

Und ja, ich benutze die Altis-Life-RPG-4.ini in @extDB2/db_custom/

PoweredByte

Vielen Dank für diese Antwort, leider funktioniert es immernoch nicht

Code

23:51:38 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

PoweredByte

Larry kannst du erklären was ich genau ersetzen muss?, bin in Sachen SQF leider sehr unerfahren.

PoweredByte

Weiß jemand ob es auch für die 4.0 funktioniert?

PoweredByte

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 "####################################################################";
		};
	};
};

Alles anzeigen

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],["$

Alles anzeigen

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;

Alles anzeigen

Mfg

PoweredByte

Danke

PoweredByte

Wie schon gesagt, kriege das mit dem Scheduler nicht hin, weiß auch garnicht ob das unter Linux überhaupt in irgendeiner weise noch möglich ist...

PoweredByte

Zitat: "Habe es per Scheduler probiert aber da ich Linux verwende ist das nicht so einfach den Scheduler zum laufen zu kriegen."

Meinst mit BEC Nachricht doch sicherlich die Scheduler Nachrichten oder?

PoweredByte

Okay vielen Dank :D, werde ich machen!

PoweredByte

Wenn ich nur Scripter wäre :/, wärst du vielleicht so nett?...

-

Bin nicht so der Fan von InfiStar, habe sehr viele Schlechte Sachen dadrüber gehört.

PoweredByte

InfiStar auf Linux?

Gibt es noch eine andere Möglichkeit? :?

PoweredByte

Hallo, ich suche nach einem Script der zu bestimmten Uhrzeiten wiederholt Nachrichten ausgibt.

Beispiel:

15:30 : Server Restart in 30minuten.
15:45 : Server Restart in 15minuten.
15:55 : Server Restart in 5minuten.
15:59 : RESTART

------

23:30 : Server Restart in 30minuten.
23:45 : Server Restart in 15minuten.
23:55 : Server Restart in 5minuten.
23:59 : RESTART

Habe es per Scheduler probiert aber da ich Linux verwende ist das nicht so einfach den Scheduler zum laufen zu kriegen.

Danke für's Lesen. gruß Lukas

PoweredByte

Gibt es eine Möglichkeit dadraus ein Counter zu machen?, also z.B das er von 6std runterzählt?.

Gruß Lukas

PoweredByte

Im Auto + Außerhalb des Auto's ist keine Option wenn ich an einer Tankstelle stehe

PoweredByte

Ja klar, nur wenn ich jetzt an die Tankstelle ranfahre, dann passiert halt nix.

PoweredByte

So, das Auto tankt schonmal nicht von alleine, wie Tanke ich denn nun?

Beiträge von PoweredByte

extDB2 Probleme

extDB2 Probleme

Starparmenter

DynMarket Script, Linux Server (4.4)

DynMarket Script, Linux Server (4.4)

DynMarket Script, Linux Server (4.4)

DynMarket Script, Linux Server (4.4)

[TUTORIAL] Vehicle Shop mit Vorschau | Altis Life 3.1.4.8

DynMarket Script, Linux Server (4.4)

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

Script der Nachrichten zu bestimmten Zeiten ausgibt.

[Tutorial] Statusbar / Infoleiste

Für's Tanken bezahlen + Dynamischer Spritverbrauch

Für's Tanken bezahlen + Dynamischer Spritverbrauch

Für's Tanken bezahlen + Dynamischer Spritverbrauch