[Tutorial] Permanenter Personalausweis/Dienstausweis - (V1+V2)

ZanchezDE

Ich habe die Altis Life 4.4 Vanilla hier aus dem Downloadbereich.

fn_persoRequest.sqf

Spoiler anzeigen

/*
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)];

Den perso-Ordner habe ich bereits mit allen Versionen ausprobiert. Keine von denen hat funktioniert.

Und so sieht das ganze aus, wenn ich mir ein DB Backup erstelle:

Spoiler anzeigen

-- ----------------------------
-- 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');

Rom

Nicht der Datensatz als INSERT sondern so, wie man in bspw. mit Navicat oder in phpmyadmin drin sieht. Der Rest scheint eig ok zu sein wobei mich aber wundert, warum beim INSERT die Spalten fehlen

Andre-2

Seid dem Ich es Rauf gespielt habe Funktoniert der Kleidungs Händler etc. Kann mir wer Helfen?=

ZanchezDE

Ich schick jetzt einfach mal einen Screenshot von dem Table `perso`.

Draxprod

How to see even be the identity card? When I go to Menu Y and ID CARD F10 then I done nothing that happens.

Rom

Any issues in your clientside rpt-file?
@Draxprod

Rom

Zitat von ZanchezDE

Ich schick jetzt einfach mal einen Screenshot von dem Table `perso`.

Wie ich gerade gesehen habe, nutzt du vordefinierte SQL-Statements und die life_server Variante für extDB3. Soll das so? Wie siehen die vordefinierten SQL-Statements in der ".ini" aus?

ZanchezDE

Also wenn du damit die SQL_Custom meinst, dann sieht die so aus bei mir:

Spoiler anzeigen

;; 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

Rom

Zitat von ZanchezDE

Also wenn du damit die SQL_Custom meinst, dann sieht die so aus bei mir:

Oder nutzt du keine vordefinierten SQL-Befehle? So wie du die persoRequest eingebaut hast schon :o

Draxprod

@Rom

Code

19:01:35 "----------------------------------------------------------------------------------------------------"
19:01:35 "               End of Altis Life Client Init :: Total 
19:05:07 Error in expression < contenir au moins 4 caractères!"};
if(fvs_bargeld < 50) exitWith {hint parseTe>
19:05:07   Error position: <fvs_bargeld < 50) exitWith {hint parseTe>
19:05:07   Error Variable indéfinie dans une expression: fvs_bargeld
19:05:07 File mpmissions\__CUR_MP.Jackson_County\core\pmenu\perso\fn_persoBeantragenAenderung.sqf, line 32
19:05:07 Error in expression <;
fvs_checking_a = false;
fvs_bargeld = fvs_bargeld - 100;
[] call SOCK_fnc_upda>
19:05:07   Error position: <fvs_bargeld - 100;
[] call SOCK_fnc_upda>
19:05:07   Error Variable indéfinie dans une expression: fvs_bargeld
19:05:07 File mpmissions\__CUR_MP.Jackson_County\core\pmenu\perso\fn_persoBeantragenAenderung.sqf, line 99
19:35:24 "0h 41min | Aaron SHEPPARD(76561198170351694) | Teleport to [6250.36,1440.56,0](GPS: 062963)"
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:38:05 Item STR_Item_Citron listed twice

Alles anzeigen

ZanchezDE

Also ich habe jeden Befehl in einer Datei stehen.

@extDB2\[lexicon]extdb[/lexicon]\SQL_CUSTOM_V2\altis-life-rpg-4.ini

Da in den anderen life_server Varianten die Befehle selber drin stehen, habe ich diese genommen, da dort ja die Befehle aus der .ini angesprochen werden.
Sorry, wenn ich mich da jetzt total verrenne. Mit Datenbanksachen habe ich es noch nicht so ganz.

Rom

Zitat von Draxprod

@Rom

Found a issue in perso\fn_persoBeantragenAenderung.sqf. Could you describe your problem a bit more? (my English "meh")

Zitat von ZanchezDE

Also ich habe jeden Befehl in einer Datei stehen.

@extDB2\[lexicon]extdb[/lexicon]\SQL_CUSTOM_V2\altis-life-rpg-4.ini

Da in den anderen life_server Varianten die Befehle selber drin stehen, habe ich diese genommen, da dort ja die Befehle aus der .ini angesprochen werden.
Sorry, wenn ich mich da jetzt total verrenne. Mit Datenbanksachen habe ich es noch nicht so ganz.

Sie werden zwar angesprochen, müssen aber selber hinzugefügt werden.

ZanchezDE

Das sieht in etwa so aus bei mir:

Spoiler anzeigen

[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

;;______________________________________________________________

Jeweils dann nochmal für die entsprechenden playersides natürlich.

Rom

Japs,

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

ZanchezDE

Und das Eintragen funktioniert ja wie man sieht in der DB.
Nur er bleibt dann bei dem Text "Ueberpruefe Daten des Personalausweises" hängen.
Und das verstehe ich nicht so ganz.

ZanchezDE

East habe ich raus genommen, da ich ja keine East Side habe auf dem Server.

Draxprod

@Rom

When I click on "ID CARD" in the menu Y that does not matter at all, he asks me to F10 but nothing is happening as a result I can not see my ID

My perso\fn_persoBeantragenAenderung.sqf

Code

/*
	Autor: Felix von Studsinske
	Dateiname: fn_persoBeantragenAenderung.sqf
	Beschreibung:
		Überprüft nochmal die Eingaben/Auswahlen des Personalausweises und schickt die dann zum Server.

	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
*/
if(playerside != civilian) exitWith {}; 
disableSerialization;
if((lbCurSel 70003) == -1) exitWith {};
if((lbCurSel 70004) == -1) exitWith {};
if((lbCurSel 70006) == -1) exitWith {};
if((lbCurSel 70007) == -1) exitWith {};
if((lbCurSel 70008) == -1) exitWith {};
if((lbCurSel 70009) == -1) exitWith {};
if((lbCurSel 70010) == -1) exitWith {};
if((lbCurSel 70013) == -1) exitWith {};
if((lbCurSel 70018) == -1) exitWith {};
if((lbCurSel 70011) == -1) exitWith {};
if((lbCurSel 70012) == -1) exitWith {};
if(ctrlText 70002 == "" && fvs_namenInfo) exitWith {hint "Vous voulez que le nom Bien Modifier, mais il est pas un nouvel ensemble. Le nom ne peut être vide et contenir au moins 4 caractères!"};
if(fvs_bargeld < 50) exitWith {hint parseText format ["Vous n'avez pas assez d'argent à portée de main.<br/>Actuel: $%2<br/>Banque: $%1",(500 - fvs_bargeld), fvs_bargeld];};
_sex = call compile format ["%1",lbData[70003,(lbCurSel 70003)]];
_cm = call compile format ["%1",lbValue[70004,(lbCurSel 70004)]];
_kg = call compile format ["%1",lbValue[70006,(lbCurSel 70006)]];
_blg = call compile format ["%1",lbData[70007,(lbCurSel 70007)]];
_bT = call compile format ["%1",lbValue[70008,(lbCurSel 70008)]];
_bM = call compile format ["%1",lbValue[70009,(lbCurSel 70009)]];
_bJ = call compile format ["%1",lbValue[70010,(lbCurSel 70010)]];
_plzst = call compile format ["%1",lbValue[70013,(lbCurSel 70013)]];
_str = call compile format ["%1",lbData[70011,(lbCurSel 70011)]]; 
_hausnr = call compile format ["%1",lbValue[70012,(lbCurSel 70012)]]; 
_bildID = call compile format ["%1",lbValue[70018,(lbCurSel 70018)]]; 
_insert = [];
if(fvs_namen_a) then {
	_insert pushBack (ctrlText 70002);
} else {
	_insert pushBack profileName;
};
_insert pushBack str((date select 0) - _bJ);
_insert pushBack _sex;
_insert pushBack _blg;
_insert pushBack _str;
_insert pushBack fvs_handynr;
_insert pushBack fvs_email;
_insert pushBack str(_cm);
_insert pushBack str(_kg);
_insert pushBack str(_bT);
_insert pushBack str(_bM);
_insert pushBack str(_bJ);
_insert pushBack str(_plzst);
_insert pushBack str(_hausnr);
_insert pushBack str(_bildID);
_uid = (getplayerUID player);
_side = side player;
[_insert,_uid,_side,player] remoteExec ["DB_fnc_persoUpdate",2];




_name = _insert select 0;
_alter = _insert select 1;
_sex = _insert select 2;
_bltg = _insert select 3;
_stra = _insert select 4;
_email = _insert select 6;
_cm = _insert select 7;
_kg = _insert select 8;
_t = _insert select 9;
_m = _insert select 10;
_j = _insert select 11;
_plz = _insert select 12;
_hsnr = _insert select 13;
_wohnort = getText(missionConfigFile >> "Personalausweis" >> "persoOrt" >> (_insert select 12) >> "name");
_bildID = _insert select 14;
_bildName = getText(missionConfigFile >> "Personalausweis" >> "persoBild" >> _bildID >> "name");
closeDialog 0;
if(fvs_namen_a) then {
	hint parseText format ["100$ on ete preleve, retour au lobby dans quelques minutes.<br/><br/>Modifications apoorte:<br/><br/>Nom: %1<br/>Adresse: %2 %3<br/>Adresse 2: %4 %5<br/><br/>Email: %6<br/>Telephone: 0%7<br/>Taille: %8cm<br/>Gewicht: %9kg<br/>Age: %10 ans<br/>Date de naissance: %11 %12 %13<br/>Groupe sainguin: %14<br/><br/>Photo: %15 %16",_name,_stra,_hsnr,_plz,_wohnort,_email,fvs_handynr,_cm,_kg,_alter,_t,_m,_j,_bltg,_bildID,_bildName];
	player setVariable ["personaltext",_insert,true];
	fvs_namen_a = false;
	fvs_checking_a = false;
	fvs_bargeld = fvs_bargeld - 100;
	[] call SOCK_fnc_updateRequest;
	sleep (60 * 5);
	endMission "persoA";
} else {
	hint parseText format ["Une somme de 100$ a ete preleve, retour en lobby dans quelques minutes. <br/><br/>Changements:<br/><br/>Nom: %1<br/>Adresse: %2 %3<br/>Adresse 2: %4 %5<br/><br/>Email: %6<br/>Telephone: 0%7<br/>Taille: %8cm<br/>Poids: %9kg<br/>Age: %10 ans<br/>Date de naissance: %11 %12 %13<br/>Groupe Sanguin: %14<br/><br/>Photo: %15 %16",_name,_stra,_hsnr,_plz,_wohnort,_email,fvs_handynr,_cm,_kg,_alter,_t,_m,_j,_bltg,_bildID,_bildName];
	player setVariable ["personaltext",_insert,true];
	fvs_namen_a = false;
	fvs_checking_a = false;
	fvs_bargeld = fvs_bargeld - 100;
	[] call SOCK_fnc_updateRequest;
};

Alles anzeigen

0xBADC0DED

Zitat von Draxprod

@Rom

When I click on "ID CARD" in the menu Y that does not matter at all, he asks me to F10 but nothing is happening as a result I can not see my ID

My perso\fn_persoBeantragenAenderung.sqf

Code

/*
	Autor: Felix von Studsinske
	Dateiname: fn_persoBeantragenAenderung.sqf
	Beschreibung:
		Überprüft nochmal die Eingaben/Auswahlen des Personalausweises und schickt die dann zum Server.

	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
*/
if(playerside != civilian) exitWith {}; 
disableSerialization;
if((lbCurSel 70003) == -1) exitWith {};
if((lbCurSel 70004) == -1) exitWith {};
if((lbCurSel 70006) == -1) exitWith {};
if((lbCurSel 70007) == -1) exitWith {};
if((lbCurSel 70008) == -1) exitWith {};
if((lbCurSel 70009) == -1) exitWith {};
if((lbCurSel 70010) == -1) exitWith {};
if((lbCurSel 70013) == -1) exitWith {};
if((lbCurSel 70018) == -1) exitWith {};
if((lbCurSel 70011) == -1) exitWith {};
if((lbCurSel 70012) == -1) exitWith {};
if(ctrlText 70002 == "" && fvs_namenInfo) exitWith {hint "Vous voulez que le nom Bien Modifier, mais il est pas un nouvel ensemble. Le nom ne peut être vide et contenir au moins 4 caractères!"};
if(fvs_bargeld < 50) exitWith {hint parseText format ["Vous n'avez pas assez d'argent à portée de main.<br/>Actuel: $%2<br/>Banque: $%1",(500 - fvs_bargeld), fvs_bargeld];};
_sex = call compile format ["%1",lbData[70003,(lbCurSel 70003)]];
_cm = call compile format ["%1",lbValue[70004,(lbCurSel 70004)]];
_kg = call compile format ["%1",lbValue[70006,(lbCurSel 70006)]];
_blg = call compile format ["%1",lbData[70007,(lbCurSel 70007)]];
_bT = call compile format ["%1",lbValue[70008,(lbCurSel 70008)]];
_bM = call compile format ["%1",lbValue[70009,(lbCurSel 70009)]];
_bJ = call compile format ["%1",lbValue[70010,(lbCurSel 70010)]];
_plzst = call compile format ["%1",lbValue[70013,(lbCurSel 70013)]];
_str = call compile format ["%1",lbData[70011,(lbCurSel 70011)]]; 
_hausnr = call compile format ["%1",lbValue[70012,(lbCurSel 70012)]]; 
_bildID = call compile format ["%1",lbValue[70018,(lbCurSel 70018)]]; 
_insert = [];
if(fvs_namen_a) then {
	_insert pushBack (ctrlText 70002);
} else {
	_insert pushBack profileName;
};
_insert pushBack str((date select 0) - _bJ);
_insert pushBack _sex;
_insert pushBack _blg;
_insert pushBack _str;
_insert pushBack fvs_handynr;
_insert pushBack fvs_email;
_insert pushBack str(_cm);
_insert pushBack str(_kg);
_insert pushBack str(_bT);
_insert pushBack str(_bM);
_insert pushBack str(_bJ);
_insert pushBack str(_plzst);
_insert pushBack str(_hausnr);
_insert pushBack str(_bildID);
_uid = (getplayerUID player);
_side = side player;
[_insert,_uid,_side,player] remoteExec ["DB_fnc_persoUpdate",2];




_name = _insert select 0;
_alter = _insert select 1;
_sex = _insert select 2;
_bltg = _insert select 3;
_stra = _insert select 4;
_email = _insert select 6;
_cm = _insert select 7;
_kg = _insert select 8;
_t = _insert select 9;
_m = _insert select 10;
_j = _insert select 11;
_plz = _insert select 12;
_hsnr = _insert select 13;
_wohnort = getText(missionConfigFile >> "Personalausweis" >> "persoOrt" >> (_insert select 12) >> "name");
_bildID = _insert select 14;
_bildName = getText(missionConfigFile >> "Personalausweis" >> "persoBild" >> _bildID >> "name");
closeDialog 0;
if(fvs_namen_a) then {
	hint parseText format ["100$ on ete preleve, retour au lobby dans quelques minutes.<br/><br/>Modifications apoorte:<br/><br/>Nom: %1<br/>Adresse: %2 %3<br/>Adresse 2: %4 %5<br/><br/>Email: %6<br/>Telephone: 0%7<br/>Taille: %8cm<br/>Gewicht: %9kg<br/>Age: %10 ans<br/>Date de naissance: %11 %12 %13<br/>Groupe sainguin: %14<br/><br/>Photo: %15 %16",_name,_stra,_hsnr,_plz,_wohnort,_email,fvs_handynr,_cm,_kg,_alter,_t,_m,_j,_bltg,_bildID,_bildName];
	player setVariable ["personaltext",_insert,true];
	fvs_namen_a = false;
	fvs_checking_a = false;
	fvs_bargeld = fvs_bargeld - 100;
	[] call SOCK_fnc_updateRequest;
	sleep (60 * 5);
	endMission "persoA";
} else {
	hint parseText format ["Une somme de 100$ a ete preleve, retour en lobby dans quelques minutes. <br/><br/>Changements:<br/><br/>Nom: %1<br/>Adresse: %2 %3<br/>Adresse 2: %4 %5<br/><br/>Email: %6<br/>Telephone: 0%7<br/>Taille: %8cm<br/>Poids: %9kg<br/>Age: %10 ans<br/>Date de naissance: %11 %12 %13<br/>Groupe Sanguin: %14<br/><br/>Photo: %15 %16",_name,_stra,_hsnr,_plz,_wohnort,_email,fvs_handynr,_cm,_kg,_alter,_t,_m,_j,_bltg,_bildID,_bildName];
	player setVariable ["personaltext",_insert,true];
	fvs_namen_a = false;
	fvs_checking_a = false;
	fvs_bargeld = fvs_bargeld - 100;
	[] call SOCK_fnc_updateRequest;
};

Alles anzeigen

Please sent logs

Draxprod

@majoess

Code

19:01:35 "----------------------------------------------------------------------------------------------------"
19:01:35 " End of Altis Life Client Init :: Total 
19:05:07 Error in expression < contenir au moins 4 caractères!"};
if(fvs_bargeld < 50) exitWith {hint parseTe>
19:05:07   Error position: <fvs_bargeld < 50) exitWith {hint parseTe>
19:05:07   Error Variable indéfinie dans une expression: fvs_bargeld
19:05:07 File mpmissions\__CUR_MP.Jackson_County\core\pmenu\perso\fn_persoBeantragenAenderung.sqf, line 32
19:05:07 Error in expression <;
fvs_checking_a = false;
fvs_bargeld = fvs_bargeld - 100;
[] call SOCK_fnc_upda>
19:05:07   Error position: <fvs_bargeld - 100;
[] call SOCK_fnc_upda>
19:05:07   Error Variable indéfinie dans une expression: fvs_bargeld
19:05:07 File mpmissions\__CUR_MP.Jackson_County\core\pmenu\perso\fn_persoBeantragenAenderung.sqf, line 99
19:35:24 "0h 41min | Aaron SHEPPARD(76561198170351694) | Teleport to [6250.36,1440.56,0](GPS: 062963)"
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:37:29 Error in expression <false;
if((["hatch", (ABM_tempSelection select 1), true] call BIS_fnc_inString))>
19:37:29   Error position: <select 1), true] call BIS_fnc_inString))>
19:37:29   Error Diviseur nul
19:37:29 File Action_Button_Mod\ABM_doSelectionHeld.sqf, line 617
19:38:05 Item STR_Item_Citron listed twice

Alles anzeigen

Rom

Zitat von Draxprod

19:05:07 Error Variable indéfinie dans une expression: fvs_bargeld
19:05:07 File mpmissions\__CUR_MP.Jackson_County\core\pmenu\perso\fn_persoBeantragenAenderung.sqf, line 32

This issue comes, because you are using an older version of fn_persoBeantragenAenderung.sqf.
But you said, you can't see the id card as well? Mhmm. Did you created your id card?

[Tutorial] Permanenter Personalausweis/Dienstausweis - (V1+V2)

Ähnliche Themen

Neue Lizenzen hinzufügen auf der 4.4r4

Ich suche ein Ausweis Script

Ausweis Script für die 5.0.0

Spielernamen

Personalausweis für 4.4.r4

Name über dem Kopf