1. Dashboard
  2. Forum
    1. Unerledigte Themen
  3. Downloads
  4. Galerie
    1. Alben
  5. Toolbox
    1. Passwort Generator
    2. Portchecker
  6. Mitglieder
    1. Mitgliedersuche
    2. Benutzer online
    3. Trophäen
    4. Team
Sa: 17 Mai 2025
  • Anmelden oder registrieren
  • Suche
Dieses Thema
  • Alles
  • Dieses Thema
  • Dieses Forum
  • Artikel
  • Forum
  • Dateien
  • Seiten
  • Bilder
  • Erweiterte Suche

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.

Anmelden oder registrieren
    1. Nodezone.net Community
    2. Forum
    3. Gameserver & Hosting
    4. ArmA Series - ArmA 3 / Reforger
    5. Hilfeforum
    6. Archiv

    ADAC System

    • PrideGame
    • 19. Juni 2016 um 22:05
    • Geschlossen
    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 22:05
      • #1

      Hallo,

      ich habe die letzten Stunden damit verbracht ein ADAC System zum laufen zubekommen...
      Wenn ich jetzt auf den Server joine kommt buggt das mega rum und dort steht irgendwas von "Wird abgerufen[...]" und "Konnte nicht gefunden werden trage ein[...]" irgendwie sowas in der Art.
      Mein RPT Log ballert mir auch die Ohren voll kann mir das wer erklären was das bedeutet?

      Code
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      "extDB2: uisleep [4]: 168.008"
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      "extDB2: uisleep [4]: 168.404"
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      "extDB2: uisleep [4]: 168.814"
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      Error in expression <],	
      [], 
      [], 
      [], 
      [], 
      [], 
      [],  
      [], 
      ];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error position: <];
      
      
      
      
      
      
      
      
      
      
      
      
      
      [_query,1] call DB_fnc_asyncCall;>
        Error Missing [
      File life_server\Functions\MySQL\fn_insertRequest.sqf, line 61
      "extDB2: uisleep [4]: 169.219"
      "extDB2: uisleep [4]: 169.563"
      Warning: Cleanup player - person 2:1810 not found
      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)
      Alles anzeigen
      Code: fn_insertRequest.sqf
      #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

      Lern gern dazu, also nur raus damit. :)

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • xDreamzZ
      Anfänger
      Reaktionen
      21
      Trophäen
      11
      Beiträge
      81
      • 19. Juni 2016 um 22:53
      • #2

      Abend,

      der Fehler wird nicht in der insertRequest.sqf liegen. Oder hast du Dort was verändert?
      Wen der Fehler erscheint hat es eigentlich immer etwas mit der Datenbank zutun, bzw hast dort etwas falsch gemacht.

      Gib mal deine [lexicon]extDB[/lexicon] Logs

      //Edit:

      Dummer Spruch haha von mir. Natürlich hast du was verändert. Hast ja ADAC eingefügt. Fail :D Trotzdem Die [lexicon]extDb[/lexicon] Logs bitte

      Gruß

    • xDreamzZ
      Anfänger
      Reaktionen
      21
      Trophäen
      11
      Beiträge
      81
      • 19. Juni 2016 um 23:09
      • #3

      Hab mir mal deine insertRequest genau durchgesehen. Bin mit der 4.0 nicht ganz vertraut aber naja ich hau ma meine Vermutungen raus:

      Wahrscheinlich hast du dich ja an ein TUT gehalten.

      In Zeile 62-64 hast du folgendes

      Code
      _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];

      auskommentiert. Warum?

      Was is dat den?

      Zeile 47-61

      Code
      _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
      ];
      Alles anzeigen

      Würde vorschlagen das du es rückgängig machst und das alte was du auskommentiert hast in Gang setzt. Denke mal dein neues Zeug is bissl Falsch und verursacht Errors.

      Gruß

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:12
      • #4

      So jetzt,

      Logs kommen gleich nach editiert.
      Ich hab das auskommentiert weil das vom Tut gekommen ist.
      Das hat irgendwie alles nicht funktioniert deswegen hab ich das alte genommen und die Adac Dinger hinten dran gemacht..

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • xDreamzZ
      Anfänger
      Reaktionen
      21
      Trophäen
      11
      Beiträge
      81
      • 19. Juni 2016 um 23:13
      • #5

      Dann Link vom TUT noch bitte

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:15
      • #6

      [Tutorial] ADAC (Opfor) einfügen extDB

      [How To] Add ADAC (Opfor) in Altis Life 4.0 - 4.0 - Altis Life RPG

      Hauptsächlich hab ich den ersten benutzt.. leider war der nur für Version 3.x und ich hab ja v4.0 ..
      Der zweite wäre zwar für die v4.0 aber der Typ bekommt noch ne Backpfeife von mir der sollte mal
      formatieren lernen. :D

      EDIT:

      Hoppla, nochmal klares Deutsch:

      Hauptsächlich habe ich das Tutorial von diesem Forum hier verwendet jedoch bei manchen Dingen musst ich mich dann durch das unformatierte Tutorial lesen von altisliferpg.com

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • xDreamzZ
      Anfänger
      Reaktionen
      21
      Trophäen
      11
      Beiträge
      81
      • 19. Juni 2016 um 23:28
      • #7
      Zitat von PrideGame

      [Tutorial] ADAC (Opfor) einfügen extDB

      [How To] Add ADAC (Opfor) in Altis Life 4.0 - 4.0 - Altis Life RPG

      Hauptsächlich hab ich den ersten benutzt.. leider war der nur für Version 3.x und ich hab ja v4.0 ..
      Der zweite wäre zwar für die v4.0 aber der Typ bekommt noch ne Backpfeife von mir der sollte mal
      formatieren lernen. :D

      EDIT:

      Hoppla, nochmal klares Deutsch:

      Hauptsächlich habe ich das Tutorial von diesem Forum hier verwendet jedoch bei manchen Dingen musst ich mich dann durch das unformatierte Tutorial lesen von altisliferpg.com

      Alles anzeigen

      Really?

      Du weist das es viele unterschiede zwischen 3.1.4 und 4.0 gibt? Würde sagen du machst alles von neu von dem 4.0 TUT.. Dannach kannst dich nomma melden :D
      Es können soviele Sachen dazu Führen das du ein Fehler in der asyncCall bekommst...

    • br1zey
      Meister
      Reaktionen
      881
      Trophäen
      11
      Beiträge
      2.458
      Dateien
      2
      Bilder
      58
      • 19. Juni 2016 um 23:29
      • #8

      Ich bin mir nicht Sicher aber

      • _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
      • ];

      muss das Komma Rot nicht weg ?

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:30
      • #9

      Das dachte ich mir auch mit dem Komma ich hab es entfernt.. jetzt komm ich nicht mehr auf den Server.

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:30
      • #10
      Zitat von Max Smith

      Really?

      Schau dir das andere Tutorial mal an, ich bin Neuling in SQF ich verstehe kein Wort von diesem unformatierten Kauderwelsch.

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • br1zey
      Meister
      Reaktionen
      881
      Trophäen
      11
      Beiträge
      2.458
      Dateien
      2
      Bilder
      58
      • 19. Juni 2016 um 23:33
      • #11

      habe grade mal in so ne Alte Version Geguckt und Ja das Komma mus weg :D

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:34
      • #12

      Wie gesagt, ich habs entfernt nun komme ich nach dem ich das Serverpasswort eingegeben habe nicht mehr aus dem Ladebildschirm.
      EDIT:
      Wäre sehr erfreut darüber wenn mir einer ein vernünfiges Tutorial für die 4.0 empfehlen/schicken könnte.. will das ja lernen aber ohne gute Tutorials geht das nicht.

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • xDreamzZ
      Anfänger
      Reaktionen
      21
      Trophäen
      11
      Beiträge
      81
      • 19. Juni 2016 um 23:34
      • #13
      Zitat von PrideGame

      Schau dir das andere Tutorial mal an, ich bin Neuling in SQF ich verstehe kein Wort von diesem unformatierten Kauderwelsch.

      Ja das unformatierte is echt bitter. Aber ich wette das halt iwas nicht passt weil es für die 3.1.4 war.. Gibts kein anderes deutsches?

    • br1zey
      Meister
      Reaktionen
      881
      Trophäen
      11
      Beiträge
      2.458
      Dateien
      2
      Bilder
      58
      • 19. Juni 2016 um 23:41
      • #14

      Sicher ist das , zu viel machs weg dan neunen RPT log und [lexicon]extDB[/lexicon] log

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 19. Juni 2016 um 23:56
      • #15
      Code
      [...]
      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.

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • br1zey
      Meister
      Reaktionen
      881
      Trophäen
      11
      Beiträge
      2.458
      Dateien
      2
      Bilder
      58
      • 20. Juni 2016 um 00:00
      • #16

      Ist das alles im RPT ????

      wenn ich mich recht erriiner gibs in der 4.0 nooch ne altis-life-rpg-4.ini

      hast du auch eigentlich auch angepasst ?

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 20. Juni 2016 um 00:01
      • #17

      Musst ein wenig rausschneiten.. sonst wäre es über die maximale Zeilenlänge gegangen.. hab aber nur oben was raus genommen.

      Code: altis-life-rpg-4.ini
      [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. :/

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • br1zey
      Meister
      Reaktionen
      881
      Trophäen
      11
      Beiträge
      2.458
      Dateien
      2
      Bilder
      58
      • 20. Juni 2016 um 00:07
      • #18

      Fangen wir an aber kenne mich mit der ini auch nicht so aus aber

      Code
      ;;______________________________________________________________
      [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
      ;;______________________________________________________________


      muss angepasst werden denke ich wenn ich Falsch Liege kann mich bestimmt jemand berichtigen

      und weiter untern noch für die Jeweilige Seite aber keine für ADAC


      Code
      [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
      ;;______________________________________________________________
      Alles anzeigen

      ReallifeRPG Admin, Scripter, Technischer Helfer, und Manchmal auch Spieler

      realliferpg128x128.png?resize=128%2C128&ssl=1

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 20. Juni 2016 um 00:38
      • #19

      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. :)

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    • PrideGame
      Schüler
      Reaktionen
      21
      Trophäen
      9
      Beiträge
      111
      Bilder
      3
      • 20. Juni 2016 um 15:09
      • #20

      Meine altis-life.rpg-4.ini hab ich jetzt ein wenig angepasst.

      Code
      [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. :/

      Jeffry ist das lebende PAWN-Lexikon.
      Quini  :love:
      Server Teamspeak 5.189.163.112

    Registrieren oder Einloggen

    Du bist noch kein Mitglied von Native-Servers.com? Registriere dich kostenlos und werde Teil einer großartigen Community!

    Benutzerkonto erstellen

    Ähnliche Themen

    • [Tutorial] Altis Life 4.4r4 ADAC (OPFOR) einfügen

      • amdgeode
      • 17. Januar 2017 um 01:47
      • Tutorials & Releases
    • [TUTORIAL] SQL basiertes Smartphone

      • Exodoos
      • 1. August 2016 um 18:57
      • Tutorials & Releases
    • Position Speicherung RPG Log wird gesprengt

      • JohnnyWalker
      • 12. August 2017 um 18:33
      • Hilfeforum
    • FSM einstellungen

      • KlitschKO
      • 16. Januar 2017 um 16:19
      • Hilfeforum

    Wichtige Links & Informationen

    Server & Hosting-Ressourcen

      Server Administration & Hosting Basics

      Windows Server Support & Guides

      Linux Server Configuration & Help

      Setting up TeamSpeak 3 & VoIP Servers

      Domains & Web Hosting for Beginners & Professionals

      Cloud Hosting, Docker & Kubernetes Tutorials

    Gameserver & Modding-Ressourcen

      ArmA 3 Tutorials & Script Collection

      Renting & Operating Gameservers

      DayZ Server Management & Help

      FiveM (GTA V) Server & Script Development

      Rust Server Modding & Administration

      Setting up & Optimizing ARK Survival Servers

    NodeZone.net – Deine Community für Gameserver, Server-Hosting & Modding

      NodeZone.net ist dein Forum für Gameserver-Hosting, Rootserver, vServer, Webhosting und Modding. Seit 2015 bietet unsere Community eine zentrale Anlaufstelle für Server-Admins, Gamer und Technikbegeisterte, die sich über Server-Management, Hosting-Lösungen und Spielemodding austauschen möchten.


      Ob Anleitungen für eigene Gameserver, Hilfe bei Root- und vServer-Konfigurationen oder Tipps zu Modding & Scripting – bei uns findest du fundiertes Wissen und praxisnahe Tutorials. Mit einer stetig wachsenden Community findest du hier Antworten auf deine Fragen, Projektpartner und Gleichgesinnte für deine Gaming- und Serverprojekte. Schließe dich NodeZone.net an und werde Teil einer aktiven Community rund um Server-Hosting, Gameserver-Management und Modding-Ressourcen.

    Wer jetzt nicht teilt ist selber Schuld:
    1. Nutzungsbestimmungen
    2. Datenschutzerklärung
    3. Impressum
    4. Urheberrechts- oder Lizenzverstoß melden
  • Trimax Design coded & layout by Gino Zantarelli 2023-2025©
    Community-Software: WoltLab Suite™