Hey,
ich will das die gefesselten Spieler nicht aus einem Wagen aussteigen können, wer ne flotte Idee?
Schön, dass du den Weg zu NodeZone.net gefunden hast! Aktuell bist du nicht angemeldet und kannst deshalb nur eingeschränkt auf unsere Community zugreifen. Um alle Funktionen freizuschalten, spannende Inhalte zu entdecken und dich aktiv einzubringen, registriere dich jetzt kostenlos oder melde dich mit deinem Account an.
Hey,
ich will das die gefesselten Spieler nicht aus einem Wagen aussteigen können, wer ne flotte Idee?
Jo, klar ist es etwas übertrieben zusagen das es ist einfach ist, ich nimms zurück! Mainz!
Ohm... ach ja: Ich finde auch vor allem als ich meinen Pannendienst eingefügt bekommen hatte habe ich mich richtig gefreut.
Hallo du da!
Mein Name ist Tim ich bin 17 Jahre alt habe recht gutes Equipment sei es der Rechner oder das Mikrofon.
Ich habe eigentlich keine Genre die ich besonders gerne Spiele sonder ich schmeiße alles an was in meiner Bibliothek
sich so anhäuft. Ich liebe es Leute zu unterhalten und deswegen dachte ich mir yay Youtube!
» Youtube Kanal «
Würde mich über Feedback freuen, natürlich nur welches was man auch umsetzten kann
Abendunterhaltung :3
Bin selbst Anfänger und finde es einfach wenn man sich mal richtig reinfummelt.
Und Hilfe bekommt von Shinji, xD
Was ich für unendliche (schlechte) Geschichten über Zero One gehört habe bekommen mich da eh keine 10 Pferde mehr rauf...
Ich bin ehrlich ich finde viele große Server (auch in anderen Szenen, komme ja ursprünglich aus der GTA:SAMP Szene) einfach nur Peinlich sie haben so viele Leute und
könnten so tolle Dinge auf die Beine stellen aber nein lass uns doch lieber Anwälte & Detektive aufeinander hetzten...
Wenn ich das jetzt alles richtig verstanden habe.. ich habe die Nacht nicht geschlafen xD
Ich danke dir @Shinji du bist so eine große Hilfe gewesen!!
Hab da zwar jetzt noch ein oder zwei Aufgaben zulösen bzg. Shop und Garage der ADAC'lers.. Tuts dafür gibts nicht oder?
Ach, ja jetzt ist es logisch.. danke dir!
Ich werds mal testen.
#include <macro.h>
#define SPY "spy_log"
/*
File: fn_requestReceived.sqf
Author: Bryan "Tonic" Boardwine
Description:
Called by the server saying that we have a response so let's
sort through the information, validate it and if all valid
set the client up.
*/
life_session_tries = life_session_tries + 1;
if(life_session_completed) exitWith {}; //Why did this get executed when the client already initialized? arma...
if(life_session_tries > 3) exitWith {cutText[localize "STR_Session_Error","BLACK FADED"]; 0 cutFadeOut 999999999;};
0 cutText [localize "STR_Session_Received","BLACK FADED"];
0 cutFadeOut 9999999;
//Error handling and junk..
if(isNil "_this") exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(typeName _this,"STRING")) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(count _this,0)) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(SEL(_this,0),"Error")) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(!(EQUAL(steamid,SEL(_this,0)))) exitWith {[] call SOCK_fnc_dataQuery;};
//Lets make sure some vars are not set before hand.. If they are get rid of them, hopefully the engine purges past variables but meh who cares.
if(!isServer && (!isNil "life_adminlevel" OR !isNil "life_coplevel" OR !isNil "life_donator")) exitWith {
[[profileName,getPlayerUID player,"VariablesAlreadySet"],"SPY_fnc_cookieJar",false,false] call life_fnc_MP;
[[SPY,["VariablesAlreadySet"],profileName,steamid],"TON_fnc_logIt",false,false] call life_fnc_MP;
[[profileName,format["Variables set before client initialization...\nlife_adminlevel: %1\nlife_coplevel: %2\nlife_donator: %3",life_adminlevel,life_coplevel,life_donator]],"SPY_fnc_notifyAdmins",true,false] call life_fnc_MP;
sleep 0.9;
failMission "SpyGlass";
};
//Parse basic player information.
CASH = parseNumber (SEL(_this,2));
BANK = parseNumber (SEL(_this,3));
CONST(life_adminlevel,parseNumber (SEL(_this,4)));
CONST(life_donator,0);
//Loop through licenses
if(count (SEL(_this,6)) > 0) then {
{SVAR_MNS [SEL(_x,0),SEL(_x,1)];} foreach (SEL(_this,6));
};
life_gear = SEL(_this,8);
[true] call life_fnc_loadGear;
//Parse side specific information.
switch(playerSide) do {
case west: {
CONST(life_coplevel, parseNumber(SEL(_this,7)));
CONST(life_medicLevel,0);
life_blacklisted = SEL(_this,9);
CONST (life_adaclevel,0);
};
case civilian: {
life_is_arrested = SEL(_this,7);
CONST(life_coplevel, 0);
CONST(life_medicLevel, 0);
life_houses = SEL(_this,9);
{
_house = nearestBuilding (call compile format["%1", SEL(_x,0)]);
life_vehicles pushBack _house;
} foreach life_houses;
life_gangData = SEL(_this,10);
if(!(EQUAL(count life_gangData,0))) then {
[] spawn life_fnc_initGang;
};
[] spawn life_fnc_initHouses;
CONST (life_adaclevel,0);
};
case independent: {
CONST(life_medicLevel, parseNumber(SEL(_this,7)));
CONST(life_coplevel,0);
CONST (life_adaclevel,0);
};
case east: {
CONST (life_adaclevel, parseNumber(_this select 7));
CONST (life_coplevel,0);
CONST (life_medicLevel,0);
};
};
if(count (SEL(_this,12)) > 0) then {
{life_vehicles pushBack _x;} foreach (SEL(_this,12));
};
life_session_completed = true;
Alles anzeigen
So ist also nicht richtig.. sollte ich lieber CONST (life_adaclevel,0); zu life_adaclevel = 0; abändern?
15:49:17 name | modDir | default | origin | hash | hashShort | fullPath
15:49:17 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
15:49:17 @extDB2 | @extDB2 | false | GAME DIR | | | C:\server\A3Master\@extDB2
15:49:17 @life_server | @life_server | false | GAME DIR | 18abca9cadf23a47e9105afd42237968d120cf7f | d5ebc5 | C:\server\A3Master\@life_server
15:49:17 Arma 3 Marksmen | mark | true | GAME DIR | 712a72078c4f2cff7e6634753c58f30b3b0212a6 | c621374f | C:\server\A3Master\mark
15:49:17 Arma 3 Karts | kart | true | GAME DIR | d1cdcaa8f0600b304d1226f144660c820e23933f | 83125d6e | C:\server\A3Master\kart
15:49:17 Arma 3 Helicopters | heli | true | GAME DIR | 9ce621e55aa13e7e925533f53a4fe69f033b389b | f53557cc | C:\server\A3Master\heli
15:49:17 BEC | BEC | false | GAME DIR | | | C:\server\A3Master\BEC
15:49:17 Arma 3 DLC Bundle | dlcbundle | true | NOT FOUND | | |
15:49:17 Arma 3 Apex | expansion | true | GAME DIR | 65e3a6699175cc5284e3fd1e0f6a5386f4f53e29 | 2b5580af | C:\server\A3Master\expansion
15:49:17 Arma 3 Zeus | curator | true | GAME DIR | b976dd8c453d12252be8035eaa9058d46aa73312 | 9ada6e39 | C:\server\A3Master\curator
15:49:17 Arma 3 | A3 | true | NOT FOUND | | |
15:49:17 ==========================================================================================================================================================================================================
15:49:17 InitSound ...
15:49:17 InitSound - complete
15:49:17 PhysX3 SDK Init started ...
15:49:17 PhysX3 SDK Init ended.
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_calculatePrices.sqf not found
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_config.sqf not found
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_getUpdate.sqf not found
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_HandleDB.sqf not found
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_playerLogged.sqf not found
15:49:20 Warning Message: Script \life_server\Functions\DynMarket\fn_sleeper.sqf not found
15:49:20 Attempt to override final function - rscminimap_script
15:49:20 Attempt to override final function - rscdisplayloading_script
15:49:20 Attempt to override final function - rscdisplayloading_script
15:49:20 Attempt to override final function - rscdisplayloading_script
15:49:20 Attempt to override final function - rscdiary_script
15:49:20 Attempt to override final function - rscdisplaysinglemission_script
15:49:20 Attempt to override final function - rscdiary_script
15:49:20 Attempt to override final function - rscdisplayremotemissions_script
15:49:20 Attempt to override final function - rscdisplayloading_script
15:49:20 Attempt to override final function - rscdiary_script
15:49:20 Attempt to override final function - rscdiary_script
15:49:20 Attempt to override final function - rscdisplaystrategicmap_script
15:49:20 Attempt to override final function - rscdisplaycommon_script
15:49:20 Attempt to override final function - rscdisplaygarage_script
15:49:21 Attempt to override final function - rscdisplayhostsettings_script
15:49:21 Attempt to override final function - rscdisplayloading_script
15:49:21 Attempt to override final function - rscdisplaycurator_script
15:49:21 Attempt to override final function - display3deneditcomposition_script
15:49:21 Attempt to override final function - display3deneditattributes_script
15:49:21 Attempt to override final function - display3deneditattributes_script
15:49:21 Attempt to override final function - rscdisplayhostsettings_script
15:49:21 Attempt to override final function - rscdisplaycommon_script
15:49:21 Attempt to override final function - rscdisplaydebriefing_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:21 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
15:49:22 Attempt to override final function - rscunitinfo_script
Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
Steam AppId from steam_appid.txt: 107410
Connected to Steam servers
Unsupported language English in stringtable
Unsupported language English in stringtable
Mission Tanoa_Lifev0%2e2.Tanoa: Number of roles (111) is different from 'description.ext::Header::maxPlayer' (75)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Server error: Player without identity PrideGame (id 1761393266)
Starting mission:
Mission file: Tanoa_Lifev0%2e2 (__cur_mp)
Mission world: Tanoa
Mission directory: mpmissions\__cur_mp.Tanoa\
No more slot to add connection at 015030 (1523.6,3012.8)
Unknown hit sound type in A3\data_f\Penetration\tyre.bisurf.soundHit
Warning: Unaccessible ladder point for AI (already used for actionbegin2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionbegin2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionend2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionend2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Error in expression <ted = (_this select 9);
(life_adaclevel,0);
};
case civilian: {
life_is_arrest>
Error position: <,0);
};
case civilian: {
life_is_arrest>
Error Missing )
File mpmissions\__cur_mp.Tanoa\core\session\fn_requestReceived.sqf, line 55
Error in expression <ted = (_this select 9);
(life_adaclevel,0);
};
case civilian: {
life_is_arrest>
Error position: <,0);
};
case civilian: {
life_is_arrest>
Error Missing )
File mpmissions\__cur_mp.Tanoa\core\session\fn_requestReceived.sqf, line 55
Attempt to override final function - bis_functions_list
Attempt to override final function - bis_functions_listpreinit
Attempt to override final function - bis_functions_listpostinit
Attempt to override final function - bis_functions_listrecompile
Attempt to override final function - bis_fnc_missiontaskslocal
Attempt to override final function - bis_fnc_missionconversationslocal
Attempt to override final function - bis_fnc_missionflow
found in (40,17).
found in (380,209).
found in (449,319).
[...]
Loading movesType CfgGesturesMale
Animation a3\anims_f_exp\data\anim\sdr\gst\gesturereloadctarprone.rtm not found or empty
MovesType CfgGesturesMale load time 384 ms
Loading movesType CfgMovesMaleSdr
bin\config.bin/CfgMovesMaleSdr/States/UnconsciousReviveMedic.InterpolateTo: item count not multiple of 2 (is 11)
Animation a3\cargoposes_f\anim\passenger_flatground_leanleft_kia.rtm not found or empty
Animation a3\cargoposes_f\anim\passenger_flatground_leanright_kia.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimtopistol_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimunarmed_tobinoc_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimunarmed_frombinoc_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimlauncher1.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2idlelauncher1.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimlauncher_reload.rtm not found or empty
MovesType CfgMovesMaleSdr load time 13229 ms
found in (39,17).
found in (189,330).
No speaker given for Maalik Tinibu
found in (184,137).
found in (182,126).
found in (39,17).
found in (439,467).
found in (278,398).
found in (183,136).
found in (413,152).
found in (283,415).
found in (184,137).
found in (346,284).
found in (173,122).
found in (313,350).
found in (383,268).
found in (430,157).
found in (311,132).
found in (51,229).
found in (195,353).
found in (291,124).
found in (351,352).
No speaker given for Kirabo Achebe
found in (194,352).
found in (399,323).
found in (186,138).
found in (388,437).
found in (231,239).
found in (84,252).
found in (346,90).
found in (192,140).
found in (390,78).
found in (414,131).
found in (386,143).
found in (329,450).
found in (228,242).
found in (378,411).
found in (414,64).
found in (315,135).
found in (168,288).
found in (171,288).
found in (167,286).
No speaker given for Mobutu Odili
found in (388,84).
found in (407,272).
found in (172,294).
found in (187,345).
found in (189,352).
No speaker given for Thomas Snowe
found in (186,341).
found in (189,330).
found in (200,338).
No speaker given for Zaim Hoxha
found in (190,331).
No speaker given for Bao Ong
found in (189,330).
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
found in (187,342).
No speaker given for Benjamin Faulkner
found in (189,354).
No speaker given for Ryan Wright
found in (41,17).
No speaker given for Chad Wilson
found in (189,354).
No speaker given for Thomas Davis
found in (189,354).
found in (322,449).
No speaker given for Idi Azikiwe
found in (317,452).
found in (310,456).
No speaker given for Jack Martinez
found in (394,435).
No speaker given for Lewis Collins
found in (188,134).
No speaker given for Harvey Collins
found in (390,85).
found in (227,240).
found in (73,286).
found in (316,452).
No speaker given for Bao Chang
found in (329,450).
found in (391,88).
found in (390,100).
No speaker given for Wang Ryu
found in (386,87).
found in (445,413).
found in (167,86).
found in (177,335).
found in (456,408).
found in (392,76).
found in (464,415).
found in (463,395).
found in (283,458).
No speaker given for Samuel Davies
found in (390,85).
No speaker given for Douglas Clark
found in (188,134).
found in (176,334).
found in (180,135).
No speaker given for Callum Bennett
found in (168,286).
found in (470,306).
found in (152,71).
No speaker given for Deng Lin
found in (184,137).
found in (120,72).
found in (331,448).
found in (193,140).
found in (193,361).
found in (227,244).
No speaker given for Montgomery Jackson
found in (379,175).
No speaker given for Jamie Leahy
found in (379,175).
found in (413,473).
No speaker given for Chad Abbey
found in (393,84).
found in (396,91).
found in (300,459).
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
found in (318,453).
No speaker given for Paul Wood
found in (392,92).
found in (298,158).
No speaker given for Hamidi Awolowo
found in (388,75).
found in (207,412).
found in (238,140).
found in (474,383).
found in (93,189).
No speaker given for Max Wilson
found in (189,352).
No speaker given for David Stewart
found in (388,101).
No speaker given for Adam Lewis
found in (390,436).
found in (439,467).
found in (470,306).
No speaker given for Kyle Faulkner
found in (439,467).
found in (191,331).
found in (450,99).
No speaker given for Danny Patel
found in (192,135).
found in (188,164).
found in (341,168).
found in (385,86).
found in (37,18).
Error: Object(2 : 589) not found
c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
"extDB: Version: 63"
"extDB: Connected to the Database"
"extDB2: uisleep [4]: 205.342"
"extDB2: uisleep [4]: 205.449"
"extDB2: uisleep [4]: 238.602"
Mission id: 0f488a8f36aa7247f10081b0a4df1bd499a841ad
Alles anzeigen
"Empfange Dateien vom Server, überprüfe." Die [lexicon]ExtDB[/lexicon] Log ist immer noch clean.
Was heißt dieses "found in .." eigentlich, oder diese ganzen Namen?
Ich teste mal.
Wieso und was bedeutet das?
Hoppla
#include <macro.h>
#define SPY "spy_log"
/*
File: fn_requestReceived.sqf
Author: Bryan "Tonic" Boardwine
Description:
Called by the server saying that we have a response so let's
sort through the information, validate it and if all valid
set the client up.
*/
life_session_tries = life_session_tries + 1;
if(life_session_completed) exitWith {}; //Why did this get executed when the client already initialized? arma...
if(life_session_tries > 3) exitWith {cutText[localize "STR_Session_Error","BLACK FADED"]; 0 cutFadeOut 999999999;};
0 cutText [localize "STR_Session_Received","BLACK FADED"];
0 cutFadeOut 9999999;
//Error handling and junk..
if(isNil "_this") exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(typeName _this,"STRING")) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(count _this,0)) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(EQUAL(SEL(_this,0),"Error")) exitWith {[] call SOCK_fnc_insertPlayerInfo;};
if(!(EQUAL(steamid,SEL(_this,0)))) exitWith {[] call SOCK_fnc_dataQuery;};
//Lets make sure some vars are not set before hand.. If they are get rid of them, hopefully the engine purges past variables but meh who cares.
if(!isServer && (!isNil "life_adminlevel" OR !isNil "life_coplevel" OR !isNil "life_donator")) exitWith {
[[profileName,getPlayerUID player,"VariablesAlreadySet"],"SPY_fnc_cookieJar",false,false] call life_fnc_MP;
[[SPY,["VariablesAlreadySet"],profileName,steamid],"TON_fnc_logIt",false,false] call life_fnc_MP;
[[profileName,format["Variables set before client initialization...\nlife_adminlevel: %1\nlife_coplevel: %2\nlife_donator: %3",life_adminlevel,life_coplevel,life_donator]],"SPY_fnc_notifyAdmins",true,false] call life_fnc_MP;
sleep 0.9;
failMission "SpyGlass";
};
//Parse basic player information.
CASH = parseNumber (SEL(_this,2));
BANK = parseNumber (SEL(_this,3));
CONST(life_adminlevel,parseNumber (SEL(_this,4)));
CONST(life_donator,0);
//Loop through licenses
if(count (SEL(_this,6)) > 0) then {
{SVAR_MNS [SEL(_x,0),SEL(_x,1)];} foreach (SEL(_this,6));
};
life_gear = SEL(_this,8);
[true] call life_fnc_loadGear;
//Parse side specific information.
switch(playerSide) do {
case west: {
CONST(life_coplevel, parseNumber(SEL(_this,7)));
CONST(life_medicLevel,0);
life_blacklisted = SEL(_this,9);
__CONST__(life_adaclevel,0);
};
case civilian: {
life_is_arrested = SEL(_this,7);
CONST(life_coplevel, 0);
CONST(life_medicLevel, 0);
life_houses = SEL(_this,9);
{
_house = nearestBuilding (call compile format["%1", SEL(_x,0)]);
life_vehicles pushBack _house;
} foreach life_houses;
life_gangData = SEL(_this,10);
if(!(EQUAL(count life_gangData,0))) then {
[] spawn life_fnc_initGang;
};
[] spawn life_fnc_initHouses;
__CONST__(life_adaclevel,0);
};
case independent: {
CONST(life_medicLevel, parseNumber(SEL(_this,7)));
CONST(life_coplevel,0);
__CONST__(life_adaclevel,0);
};
case east: {
__CONST__(life_adaclevel, parseNumber(_this select 7));
__CONST__(life_coplevel,0);
__CONST__(life_medicLevel,0);
};
};
if(count (SEL(_this,12)) > 0) then {
{life_vehicles pushBack _x;} foreach (SEL(_this,12));
};
life_session_completed = true;
Alles anzeigen
Du brauchst dich bei mir nicht immer zu entschuldigen, ich will das doch lernen!
#include "\life_server\script_macros.hpp"
/*
File: fn_insertRequest.sqf
Author: Bryan "Tonic" Boardwine
Description:
Does something with inserting... Don't have time for
descriptions... Need to write it...
*/
private["_uid","_name","_side","_money","_bank","_licenses","_handler","_thread","_queryResult","_query","_alias"];
_uid = [_this,0,"",[""]] call BIS_fnc_param;
_name = [_this,1,"",[""]] call BIS_fnc_param;
_money = [_this,2,0,[""]] call BIS_fnc_param;
_bank = [_this,3,2500,[""]] call BIS_fnc_param;
_returnToSender = [_this,4,ObjNull,[ObjNull]] call BIS_fnc_param;
//Error checks
if((_uid == "") OR (_name == "")) exitWith {systemChat "Bad UID or name";}; //Let the client be 'lost' in 'transaction'
if(isNull _returnToSender) exitWith {systemChat "ReturnToSender is Null!";}; //No one to send this to!
_query = format["playerInfo:%1",_uid];
_tickTime = diag_tickTime;
_queryResult = [_query,2,true] call DB_fnc_asyncCall;
if((EQUAL(EXTDB_SETTINGS("MySQL_Query"),1))) then {
["diag_log",[
"------------- Insert Query Request -------------",
format["QUERY: %1",_query],
format["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)],
format["Result: %1",_queryResult],
"------------------------------------------------"
]] call TON_fnc_logIt;
};
//Double check to make sure the client isn't in the database...
if(typeName _queryResult == "STRING") exitWith {[[],"SOCK_fnc_dataQuery",(owner _returnToSender),false] call life_fnc_MP;}; //There was an entry!
if(count _queryResult != 0) exitWith {[[],"SOCK_fnc_dataQuery",(owner _returnToSender),false] call life_fnc_MP;};
//Clense and prepare some information.
_alias = [[_name]];
_money = [_money] call DB_fnc_numberSafe;
_bank = [_bank] call DB_fnc_numberSafe;
//Prepare the query statement..
_query = format["playerInfoInsert:%1:%2:%3:%4:%5:%6:%7:%8:%9:%10:%11:%12:%13",
_uid,
_name,
_money,
_bank,
_alias,
[], // Cop Licenses
[], // Med Licenses
[], // Civ Licenses
[], // Adac Licenses
[], // Civ Gear
[], // Cop Gear
[], // Med Gear
[] // Adac Gear
];
/*
_query = format["INSERT INTO players (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear, adac_gear, adac_licenses)
VALUES('%1', '%2', '%3', '%4', '%5','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')", _uid, _name, _money, _bank, _alias]; */
[_query,1] call DB_fnc_asyncCall;
[[],"SOCK_fnc_dataQuery",(owner _returnToSender),false] call life_fnc_MP;
Alles anzeigen
Du meinst das hier richtig?
[Musste was weg nehmen -> zulang] name | modDir | default | origin | hash | hashShort | fullPath
15:04:15 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
15:04:15 @extDB2 | @extDB2 | false | GAME DIR | | | C:\server\A3Master\@extDB2
15:04:15 @life_server | @life_server | false | GAME DIR | 18abca9cadf23a47e9105afd42237968d120cf7f | d5ebc5 | C:\server\A3Master\@life_server
15:04:15 Arma 3 Marksmen | mark | true | GAME DIR | 712a72078c4f2cff7e6634753c58f30b3b0212a6 | c621374f | C:\server\A3Master\mark
15:04:15 Arma 3 Karts | kart | true | GAME DIR | d1cdcaa8f0600b304d1226f144660c820e23933f | 83125d6e | C:\server\A3Master\kart
15:04:15 Arma 3 Helicopters | heli | true | GAME DIR | 9ce621e55aa13e7e925533f53a4fe69f033b389b | f53557cc | C:\server\A3Master\heli
15:04:15 BEC | BEC | false | GAME DIR | | | C:\server\A3Master\BEC
15:04:15 Arma 3 DLC Bundle | dlcbundle | true | NOT FOUND | | |
15:04:15 Arma 3 Apex | expansion | true | GAME DIR | 65e3a6699175cc5284e3fd1e0f6a5386f4f53e29 | 2b5580af | C:\server\A3Master\expansion
15:04:15 Arma 3 Zeus | curator | true | GAME DIR | b976dd8c453d12252be8035eaa9058d46aa73312 | 9ada6e39 | C:\server\A3Master\curator
15:04:15 Arma 3 | A3 | true | NOT FOUND | | |
15:04:15 ==========================================================================================================================================================================================================
15:04:15 InitSound ...
15:04:15 InitSound - complete
15:04:15 PhysX3 SDK Init started ...
15:04:15 PhysX3 SDK Init ended.
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_calculatePrices.sqf not found
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_config.sqf not found
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_getUpdate.sqf not found
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_HandleDB.sqf not found
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_playerLogged.sqf not found
15:04:17 Warning Message: Script \life_server\Functions\DynMarket\fn_sleeper.sqf not found
15:04:18 Attempt to override final function - rscminimap_script
15:04:18 Attempt to override final function - rscdisplayloading_script
15:04:18 Attempt to override final function - rscdisplayloading_script
15:04:18 Attempt to override final function - rscdisplayloading_script
15:04:18 Attempt to override final function - rscdiary_script
15:04:18 Attempt to override final function - rscdisplaysinglemission_script
15:04:18 Attempt to override final function - rscdiary_script
15:04:18 Attempt to override final function - rscdisplayremotemissions_script
15:04:18 Attempt to override final function - rscdisplayloading_script
15:04:18 Attempt to override final function - rscdiary_script
15:04:18 Attempt to override final function - rscdiary_script
15:04:18 Attempt to override final function - rscdisplaystrategicmap_script
15:04:18 Attempt to override final function - rscdisplaycommon_script
15:04:18 Attempt to override final function - rscdisplaygarage_script
15:04:18 Attempt to override final function - rscdisplayhostsettings_script
15:04:18 Attempt to override final function - rscdisplayloading_script
15:04:19 Attempt to override final function - rscdisplaycurator_script
15:04:19 Attempt to override final function - display3deneditcomposition_script
15:04:19 Attempt to override final function - display3deneditattributes_script
15:04:19 Attempt to override final function - display3deneditattributes_script
15:04:19 Attempt to override final function - rscdisplayhostsettings_script
15:04:19 Attempt to override final function - rscdisplaycommon_script
15:04:19 Attempt to override final function - rscdisplaydebriefing_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
15:04:19 Attempt to override final function - rscunitinfo_script
Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
Steam AppId from steam_appid.txt: 107410
Connected to Steam servers
Unsupported language English in stringtable
Unsupported language English in stringtable
Mission Tanoa_Lifev0%2e2.Tanoa: Number of roles (111) is different from 'description.ext::Header::maxPlayer' (75)
Server error: Player without identity PrideGame (id 1257775928)
Server error: Player without identity PrideGame (id 1257775928)
Starting mission:
Mission file: Tanoa_Lifev0%2e2 (__cur_mp)
Mission world: Tanoa
Mission directory: mpmissions\__cur_mp.Tanoa\
No more slot to add connection at 015030 (1523.6,3012.8)
Unknown hit sound type in A3\data_f\Penetration\tyre.bisurf.soundHit
Warning: Unaccessible ladder point for AI (already used for actionbegin2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionbegin2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionend2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Warning: Unaccessible ladder point for AI (already used for actionend2) in a3\structures_f_exp\commercial\shop_city_01\shop_city_01_f.p3d
Error in expression <lacklisted = (_this select 9);
__CONST__(life_adaclevel,0);
};
case civilian: {>
Error position: <(life_adaclevel,0);
};
case civilian: {>
Error Missing ;
File mpmissions\__cur_mp.Tanoa\core\session\fn_requestReceived.sqf, line 55
Error in expression <lacklisted = (_this select 9);
__CONST__(life_adaclevel,0);
};
case civilian: {>
Error position: <(life_adaclevel,0);
};
case civilian: {>
Error Missing ;
File mpmissions\__cur_mp.Tanoa\core\session\fn_requestReceived.sqf, line 55
Attempt to override final function - bis_functions_list
Attempt to override final function - bis_functions_listpreinit
Attempt to override final function - bis_functions_listpostinit
Attempt to override final function - bis_functions_listrecompile
Attempt to override final function - bis_fnc_missiontaskslocal
Attempt to override final function - bis_fnc_missionconversationslocal
Attempt to override final function - bis_fnc_missionflow
found in (40,17).
[...]
found in (407,431).
found in (406,431).
Loading movesType CfgGesturesMale
Animation a3\anims_f_exp\data\anim\sdr\gst\gesturereloadctarprone.rtm not found or empty
MovesType CfgGesturesMale load time 102 ms
Loading movesType CfgMovesMaleSdr
bin\config.bin/CfgMovesMaleSdr/States/UnconsciousReviveMedic.InterpolateTo: item count not multiple of 2 (is 11)
Animation a3\cargoposes_f\anim\passenger_flatground_leanleft_kia.rtm not found or empty
Animation a3\cargoposes_f\anim\passenger_flatground_leanright_kia.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimtopistol_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimunarmed_tobinoc_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimunarmed_frombinoc_end.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimlauncher1.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2idlelauncher1.rtm not found or empty
Animation a3\cargoposes_f_heli\anim\vehicle_passenger_stand_2aimlauncher_reload.rtm not found or empty
MovesType CfgMovesMaleSdr load time 6963 ms
found in (39,17).
found in (37,19).
found in (189,330).
No speaker given for Maalik Tinibu
found in (184,137).
found in (182,126).
found in (39,17).
found in (439,467).
found in (278,398).
found in (183,136).
found in (413,152).
found in (283,415).
found in (184,137).
found in (346,284).
found in (173,122).
found in (313,350).
found in (383,268).
found in (430,157).
found in (311,132).
found in (51,229).
found in (195,353).
found in (291,124).
found in (351,352).
No speaker given for Kirabo Achebe
found in (194,352).
found in (399,323).
found in (186,138).
found in (388,437).
found in (231,239).
found in (84,252).
found in (346,90).
found in (192,140).
found in (390,78).
found in (414,131).
found in (386,143).
found in (329,450).
found in (228,242).
found in (378,411).
found in (414,64).
found in (315,135).
found in (168,288).
found in (171,288).
found in (167,286).
No speaker given for Mobutu Odili
found in (388,84).
found in (407,272).
found in (172,294).
found in (187,345).
found in (189,352).
No speaker given for Thomas Snowe
found in (186,341).
found in (189,330).
found in (200,338).
No speaker given for Zaim Hoxha
found in (190,331).
No speaker given for Bao Ong
found in (189,330).
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
found in (187,342).
No speaker given for Benjamin Faulkner
found in (189,354).
No speaker given for Ryan Wright
found in (41,17).
No speaker given for Chad Wilson
found in (189,354).
No speaker given for Thomas Davis
found in (189,354).
found in (322,449).
No speaker given for Idi Azikiwe
found in (317,452).
found in (310,456).
No speaker given for Jack Martinez
found in (394,435).
No speaker given for Lewis Collins
found in (188,134).
No speaker given for Harvey Collins
found in (390,85).
found in (227,240).
found in (73,286).
found in (316,452).
No speaker given for Bao Chang
found in (329,450).
found in (391,88).
found in (390,100).
No speaker given for Wang Ryu
found in (386,87).
found in (445,413).
found in (167,86).
found in (177,335).
found in (456,408).
found in (392,76).
found in (464,415).
found in (463,395).
found in (283,458).
No speaker given for Samuel Davies
found in (390,85).
No speaker given for Douglas Clark
found in (188,134).
found in (176,334).
found in (180,135).
No speaker given for Callum Bennett
found in (168,286).
found in (470,306).
found in (152,71).
No speaker given for Deng Lin
found in (184,137).
found in (120,72).
found in (331,448).
found in (193,140).
found in (193,361).
found in (227,244).
No speaker given for Montgomery Jackson
found in (379,175).
No speaker given for Jamie Leahy
found in (379,175).
found in (413,473).
No speaker given for Chad Abbey
found in (393,84).
found in (396,91).
found in (300,459).
soldier[B_diver_F]:Some of magazines weren't stored in soldier Vest or Uniform?
found in (318,453).
No speaker given for Paul Wood
found in (392,92).
found in (298,158).
No speaker given for Hamidi Awolowo
found in (388,75).
found in (207,412).
found in (238,140).
found in (474,383).
found in (93,189).
No speaker given for Max Wilson
found in (189,352).
No speaker given for David Stewart
found in (388,101).
No speaker given for Adam Lewis
found in (390,436).
found in (439,467).
found in (470,306).
No speaker given for Kyle Faulkner
found in (439,467).
found in (191,331).
found in (450,99).
No speaker given for Danny Patel
found in (192,135).
found in (188,164).
found in (341,168).
found in (385,86).
Error: Object(2 : 589) not found
c:\w\stable\futura\lib\network\networkserver.cpp NetworkServer::OnClientStateChanged:NOT IMPLEMENTED - briefing!
"extDB: Version: 63"
"extDB: Connected to the Database"
"extDB2: uisleep [4]: 158.399"
"extDB2: uisleep [4]: 158.52"
"extDB2: uisleep [4]: 165.875"
"extDB2: uisleep [4]: 166.112"
"extDB2: uisleep [4]: 166.264"
Mission id: 0959991b3e0e144bc74b76f65ce94c6cbeaab103
Alles anzeigen
extDB2: Version: 63
extDB2: https://github.com/Torndeco/extDB2
extDB2: Windows Version
Message: All development for extDB2 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB2 Development
Message: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=2SUEFTGABTAM2
Message: Also leave a message if there is any particular feature you would like to see added.
Message: Thanks for all the people that have donated.
Message: Torndeco: 20/02/15
extDB2: Found extdb-conf.ini
extDB2: Detected 4 Cores, Setting up 4 Worker Threads
[15:05:59:070 +02:00] [Thread 2828] extDB2: Database Type: MySQL
[15:05:59:088 +02:00] [Thread 2828] extDB2: Database Session Pool Started
[15:05:59:091 +02:00] [Thread 2828] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\A3Master\@extDB2\extDB\sql_custom_v2\altis-life-rpg-4.ini
[15:05:59:091 +02:00] [Thread 2828] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
Alles anzeigen
Meine altis-life.rpg-4.ini hab ich jetzt ein wenig angepasst.
[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
;;______________________________________________________________
[playerInfoInsert]
;;
SQL1_1 = INSERT INTO players
;; 1 2 3 4 5 6 7 8 9 10 11 12 13
SQL1_2 = (playerid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, adac_licenses , civ_gear, cop_gear, med_gear, adac_gear)
SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?);
SQL1_INPUTS = 1, 2-String, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13
Number of Inputs = 13
;;______________________________________________________________
[playerWestInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, 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
;;______________________________________________________________
[playerEastInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, adac_licenses, adaclevel, adac_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=?, cash=?, bankacc=?, 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
;;______________________________________________________________
[playerEastUpdate]
;;
SQL1_1 = UPDATE players
;; 1 2 3 4 5 6
SQL1_2 = SET name=?, cash=?, bankacc=?, adac_licenses=?, adac_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
;;______________________________________________________________
[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
;;______________________________________________________________
[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
;;______________________________________________________________
[playerUpdateAdacLicense]
;;
SQL1_1 = UPDATE players
SQL1_2 = SET adac_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
;;______________________________________________________________
[playerUpdateAdacGear]
;;
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
Alles anzeigen
Meine fn_insertRequest.sqf, fn_queryRequest.sqf & fn_updateRequest.sqf Datein hab ich auch alle angepasst und "east" bzw. Adac hinzugefügt..
Eventuell ein wenig Code aber ich will das einfach alles mal überprüfen lassen... momentan ist es so das man mit keiner Fraktion mehr spawnen kann.
"Empfange Datein vom Server, überprüfe." In meiner Datenbank habe ich die extra Zeilen für den Adac auch eingefügt..
Bitte um Hilfe.. ich will das echt verstehen.
Achte auch darauf einen User zu erstellen und nicht root zu verwenden. Papa nox meint das wäre unsicher!
(Ist es auch davon mal abgesehen)
Jedoch solltest du deinen Datenbank User genauso nennen wie es dort steht: arma3
//EDIT: Grammatik Fehler behoben.
Danke für eure Hilfe.
Ich melde mich nochmal wenn ich Hilfe brauche
Edit:
Eventuell ein wenig unfreundlich, sorry :x
Ich hau mich erstmal ins Bett schreibe dann morgen mal wenn ich nicht weiter komme.
Musst ein wenig rausschneiten.. sonst wäre es über die maximale Zeilenlänge gegangen.. hab aber nur oben was raus genommen.
[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
;;______________________________________________________________
[playerInfoInsert]
;;
SQL1_1 = INSERT INTO players
;; 1 2 3 4 5 6 7 8 9 10 11
SQL1_2 = (playerid, name, cash, bankacc, 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
Number of Inputs = 11
;;______________________________________________________________
[playerWestInfo]
;;
SQL1_1 = SELECT playerid, name, cash, bankacc, 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=?, cash=?, bankacc=?, 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
;;______________________________________________________________
[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
;;______________________________________________________________
[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
Alles anzeigen
Hier meine: altis-life-rpg-4.ini send grad einfach mal jeden Code.
@Max Smith anderes deutsches Tutorial hab ich leider nicht finden können.
[...]
23:47:57 ============================================================================================= List of mods ===============================================================================================
23:47:57 modsReadOnly = true
23:47:57 safeModsActivated = false
23:47:57 customMods = true
23:47:57 hash = '9F9394563910C66AACAE10D457EB536014C1C28E'
23:47:57 hashShort = 'f2e6ecc7'
23:47:57 name | modDir | default | origin | hash | hashShort | fullPath
23:47:57 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
23:47:57 @extDB2 | @extDB2 | false | GAME DIR | | | C:\server\A3Master\@extDB2
23:47:57 @life_server | @life_server | false | GAME DIR | 7551e28dd5bc7d925c05db21232d664bce540624 | f84ea48d | C:\server\A3Master\@life_server
23:47:57 Arma 3 Marksmen | mark | true | GAME DIR | 712a72078c4f2cff7e6634753c58f30b3b0212a6 | c621374f | C:\server\A3Master\mark
23:47:57 Arma 3 Karts | kart | true | GAME DIR | d1cdcaa8f0600b304d1226f144660c820e23933f | 83125d6e | C:\server\A3Master\kart
23:47:57 Arma 3 Helicopters | heli | true | GAME DIR | 9ce621e55aa13e7e925533f53a4fe69f033b389b | f53557cc | C:\server\A3Master\heli
23:47:57 BEC | BEC | false | GAME DIR | | | C:\server\A3Master\BEC
23:47:57 Arma 3 DLC Bundle | dlcbundle | true | NOT FOUND | | |
23:47:57 Arma 3 Apex | expansion | true | GAME DIR | 65e3a6699175cc5284e3fd1e0f6a5386f4f53e29 | 2b5580af | C:\server\A3Master\expansion
23:47:57 Arma 3 Zeus | curator | true | GAME DIR | b976dd8c453d12252be8035eaa9058d46aa73312 | 9ada6e39 | C:\server\A3Master\curator
23:47:57 Arma 3 | A3 | true | NOT FOUND | | |
23:47:57 ==========================================================================================================================================================================================================
23:47:57 InitSound ...
23:47:57 InitSound - complete
23:47:57 PhysX3 SDK Init started ...
23:47:57 PhysX3 SDK Init ended.
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_calculatePrices.sqf not found
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_config.sqf not found
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_getUpdate.sqf not found
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_HandleDB.sqf not found
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_playerLogged.sqf not found
23:48:00 Warning Message: Script \life_server\Functions\DynMarket\fn_sleeper.sqf not found
23:48:00 Attempt to override final function - rscminimap_script
23:48:00 Attempt to override final function - rscdisplayloading_script
23:48:00 Attempt to override final function - rscdisplayloading_script
23:48:00 Attempt to override final function - rscdisplayloading_script
23:48:00 Attempt to override final function - rscdiary_script
23:48:00 Attempt to override final function - rscdisplaysinglemission_script
23:48:00 Attempt to override final function - rscdiary_script
23:48:00 Attempt to override final function - rscdisplayremotemissions_script
23:48:00 Attempt to override final function - rscdisplayloading_script
23:48:00 Attempt to override final function - rscdiary_script
23:48:00 Attempt to override final function - rscdiary_script
23:48:00 Attempt to override final function - rscdisplaystrategicmap_script
23:48:00 Attempt to override final function - rscdisplaycommon_script
23:48:01 Attempt to override final function - rscdisplaygarage_script
23:48:01 Attempt to override final function - rscdisplayhostsettings_script
23:48:01 Attempt to override final function - rscdisplayloading_script
23:48:01 Attempt to override final function - rscdisplaycurator_script
23:48:01 Attempt to override final function - display3deneditcomposition_script
23:48:01 Attempt to override final function - display3deneditattributes_script
23:48:01 Attempt to override final function - display3deneditattributes_script
23:48:01 Attempt to override final function - rscdisplayhostsettings_script
23:48:01 Attempt to override final function - rscdisplaycommon_script
23:48:01 Attempt to override final function - rscdisplaydebriefing_script
23:48:01 Attempt to override final function - rscunitinfo_script
Initializing Steam server - Game Port: 2302, Steam Query Port: 2303
Steam AppId from steam_appid.txt: 107410
Connected to Steam servers
Alles anzeigen
[lexicon]extDB[/lexicon] Log.. kommt irgendwie grad nichts..
Versuch es nachzuliefern.