Page MenuHomeContribution Center

Add SQL to server-side functions
Closed, ResolvedPublic

Event Timeline

queryPlayerArsenal
Get a list with ACE Arsenal items allowed by player.

Arguments:

  • playerUID
  • operationID (optional?)

Result:
["item1", "item2", "item3"]

MajJames claimed this task.Sep 1 2020, 12:44 AM
MajJames added a project: Website (J10).
MajJames moved this task from Backlog to Next on the Website (J10) board.
PvtGrezvany13 added a comment.EditedSep 1 2020, 7:28 AM

queryPlayerData
Get all ORBAT data for specific player.

Arguments:

  • playerUID
  • operationID

Result:

  • player rank (eg. Rec, Pvt, PFC, etc.)
  • arma rank (insignia ID)
  • group callsign (<any string>)
  • role (eg. Squad Medic)
  • group leader (eg. FTL, SL, PltL)
  • buddy colour (white, red, blue, green, yellow)
  • group frequency (float)
  • parent group frequency (float)
  • medic level (ACE Medic: 0,1,2)
  • engineer level (ACE Engineer: 0,1,2)
  • EOD level (ACE EOD: 0,1)
  • is zeus (0,1)
  • is admin (0,1)
  • is logistics (0,1)
  • is reporter (0,1)

Current SQL:
format["0:FETCHDATA:SELECT playerRank,playerAdmin,playerPos,playerDir,is_medic_level,is_engineer_level,callsign,freq,buddy,lr_freq,armarank FROM operation_players WHERE armauid = '%1' AND operation = '%2' GROUP BY armauid", _playerUID, _operationID]

queryFullORBAT
Get the full ORBAT information.

Arguments:

  • operationID

Result:
list of players with rank, role, callsign, buddy colour and group frequency (as on website)

MajJames moved this task from Next to Backlog on the Website (J10) board.Sep 5 2020, 1:42 AM
PvtGrezvany13 moved this task from Restricted Project Column to Restricted Project Column on the Restricted Project board.Dec 18 2020, 2:49 AM
MajJames closed this task as Resolved.Dec 21 2020, 1:42 AM
MajJames moved this task from Backlog to Released on the Website (J10) board.