Help with query database

SlimRF

this my code.

Code

private ["_time1","_time2","_query"];







_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;







if(_time1 > 0) then
{
 _time2 = _time1 - 1;
};




_query = format["UPDATE players SET p_time='%1'",_time2];
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

I'm trying to make query.

Example : 1. script read p_time column from all players.
2. script subtract "1"
3. script write in p_time new value
(300-1=299)
p_time FOR all players.

But my code write "0" to all players

What i do wrong? Help me please.

altis life 3.1.4.8 extdb2

Rom

You have to use the WHERE Statement in Update:
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1];

And you have to define _time1 first and select _time2 from your _queryresult

#mobile

SlimRF

Zitat von Rom

You have to use the WHERE Statement in Update:
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1];

And you have to define _time1 first and select _time2 from your _queryresult

#mobile

Code

private ["_time1","_time2","_query","_queryResult"];




_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult;




if(_time1 > 0) then
{
 _time2 = _time1 - 1;
};




_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1];
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

like this?
Sorry please! I'm not good at this yet. Help me to fix everything

Rom

How do you call your function/script?

[arguments] call/spawn/remoteExec/remoteExecCall tag_fnc_functionname

Code

/*
	Passed argement is _time1
	You can call this serverside script with:
		[300] remoteExec ["tag_fnc_functionname",2];
		Change your tag_fnc_functionname
*/
private ["_time2","_query","_queryResult"];
params [["_time1",-1,[0]]]; // passed argement, default is -1, expect 0=number
if (_time1 isEqualTo -1) exitWith {diag_log "No argument found";};
_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult select 0;
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
_time2 = _time1 - 1;
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1]; // Replace existing data with current _time1 with the new one (_time2), not all
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

this is one possibility

SlimRF

Zitat von Rom

How do you call your function/script?

[arguments] call/spawn/remoteExec/remoteExecCall tag_fnc_functionname

Code

/*
	Passed argement is _time1
	You can call this serverside script with:
		[300] remoteExec ["tag_fnc_functionname",2];
		Change your tag_fnc_functionname
*/
private ["_time2","_query","_queryResult"];
params [["_time1",-1,[0]]]; // passed argement, default is -1, expect 0=number
if (_time1 isEqualTo -1) exitWith {diag_log "No argument found";};
_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult select 0;
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
_time2 = _time1 - 1;
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1]; // Replace existing data with current _time1 with the new one (_time2), not all
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

this is one possibility

call my function in int.sqf

Code

[] spawn{
	while {true} do {
		sleep (1 * 60);
		[] call TON_fnc_updatedtime;
	};
};

SlimRF

All players are different values. I need to subtract "1 " each player in p_time column. Even if the player is not on the server. Every 15 minutes.

SlimRF

Code

/*
 Passed argement is _time1
 You can call this serverside script with:
 [300] remoteExec ["tag_fnc_functionname",2];
 Change your tag_fnc_functionname
*/
private ["_time2","_query","_queryResult"];
params [["_time1",-1,[0]]]; // passed argement, default is -1, expect 0=number
if (_time1 isEqualTo -1) exitWith {diag_log "No argument found";};
_query = format["SELECT p_time FROM players WHERE p_time='%1'",_time1];
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall;
_time1 = _queryResult select 0;
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
_time2 = _time1 - 1;
_query = format["UPDATE players SET p_time='%1' WHERE p_time='%2'",_time2, _time1]; // Replace existing data with current _time1 with the new one (_time2), not all
waitUntil {sleep (random 0.3); !DB_Async_Active};
[_query,2] call DB_fnc_asyncCall;

Alles anzeigen

does not work(((

Rom

do you call the function serverside? life_server\init.sqf or clientside mission.map\init.sqf?

SlimRF

Zitat von Rom

do you call the function serverside? life_server\init.sqf or clientside mission.map\init.sqf?

serverside ( life_server/init.sqf)

Rom

Zitat von SlimRF

serverside ( life_server/init.sqf)

Not tested yet/can not test it

Code

[] spawn{
     while {true} do {
     sleep (1 * 60);
     [] spawn TON_fnc_updatedtime; // call -> spawn
     };
    };

Code

/*
	Passed argement is _time1
	You can call this serverside script with:
		0 spawn TON_fnc_updatedtime;
*/
private ["_time1","_time2","_query","_queryResult"];
if !canSuspend exitWith {diag_log "TON_fnc_updatedtime has to be called (spawn) in sheduled environment, see description";};
_uids = "";
{
	if(_uids isEqualTo "") then {
		_uids = (getPlayerUID _x);
	} else { 
		_uids = format["%1,%2",_uids,getPlayerUID _x];
	};
} forEach allPlayers;
_query = format["SELECT pid,p_time FROM players WHERE pid not IN (%1)",_uids]; // only select entries without players are not online
waitUntil{!DB_Async_Active};
_queryResult = [_query,2] call DB_fnc_asyncCall; // 2=excepting
diag_log format["p_time query return: %1",_queryResult];
_time1 = _queryResult select 0;
if (count _queryResult < 1) exitWith {diag_log "No p_time changed";};
if ((_time1 - 1) < 0) exitWith {}; // cancel script execution, because negative number
{
	_x params [["_uid","",[""]],["_time1",-1,[0]]];
	_time2 = (_time1 -1);
	if (!(_uid isEqualTo "") && (_time2 > 0)) then {
		_query = format["UPDATE players SET p_time='%1' WHERE pid='%2'",_time2, _uid]; // Replace existing data with current _time1 with the new one (_time2), not all
		diag_log format ["%1: new time %2", _uid, _time2];
		waitUntil {sleep (random 0.3); !DB_Async_Active};
		[_query,1] call DB_fnc_asyncCall; // 1=only insert/update data in database without return
	};
} forEach _queryResult;

Alles anzeigen