• Getrennte Konten

      Hallo liebe Community!

      Ich suche nach einem Weg um die Konten der Spieler zu trennen.
      Also Medic / Cop / Zivi haben alle ein getrenntes Konto

      Nochmal in einfach:

      Max ist ein Zivilist.
      Max hat 200€ auf seinem Konto.

      Max ist jetzt ein Polizist oder Medic
      Max hat jetzt 200000€ auf seinem Konto als Beamter.

      Als Max wieder zum Zivilist wird hat er wieder 200€ auf seinem Konto.

      Vielen dank für eine Antwort :)

      Ich verweise nur mal hier rauf: [Tutorial] How to separate Civilian and Police cash/atm AL 4.0 - 4.0 - Altis Life RPG

      Was verstehst du daran denn nicht? ^^

      EDIT Oh... Ja... Jede dieser zeilen musst du dir immer über die Zitate denken, da ist wohl was durcheinander gekommen ^^

      Go into @[lexicon]extDB[/lexicon]\[lexicon]extDB[/lexicon]\db_custom\altis-life-rpg-4.ini

      Spoiler anzeigen


      change:
      [playerInfoInsert];;SQL1_1 = INSERT INTO players ;;1 2 3 4 5 6 7 8 9 10 11SQL1_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, 3, 4, 5, 6, 7, 8, 9, 10, 11
      With:
      [playerInfoInsert];;SQL1_1 = INSERT INTO players ;;1 2 3 4 5 6 7 8 9 10 111213SQL1_2 = (playerid, name, cash, bankacc, westcash, westbankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) SQL1_3 = VALUES(?,?,?,?,?,?,?,?,?,?,?)SQL1_INPUTS = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13Number of Inputs = 13
      CHANGE:
      [playerWestInfo];;12 3 45678 910SQL1_1 = SELECT playerid, name, cash, bankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;SQL1_INPUTS = 1
      WITH:
      [playerWestInfo];;12 3 45678 910SQL1_1 = SELECT playerid, name, westcash, westbankacc, adminlevel, donatorlvl, cop_licenses, coplevel, cop_gear, blacklist FROM players WHERE playerid=?;SQL1_INPUTS = 1

      CHANGE:
      [playerWestUpdate];;SQL1_1 = UPDATE players;;1 2 3 4 5 6SQL1_2 = SET name=?, cash=?, bankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?
      WITH:
      [playerWestUpdate];;SQL1_1 = UPDATE players;;1 2 3 4 5 6SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?
      Then now ADD:
      [playerWestUpdateBank];;SQL1_1 = UPDATE playersSQL1_2 = SET westbankacc=? WHERE playerid=?;SQL1_INPUTS = 1, 2Number of Inputs = 2;;______________________________________________________________
      After:
      [playerUpdateBank]
      And Finally ADD:
      [playerWestUpdateBank+Cash];;SQL1_1 = UPDATE playersSQL1_2 = SET westcash=?, westbankacc=? WHERE playerid=?;SQL1_INPUTS = 1, 2, 3Number of Inputs = 3;;______________________________________________________________
      AFTER:
      [playerUpdateBank+Cash]

      Auf den kleinen teil hab ich kein bock, scheint aber dort paar fehler sind also am besten durchn Thread lesen.

      Zitat von Scrpt

      RPT und [lexicon]ExtDB[/lexicon] Logs sind hilfreich, erstrecht wenn du einen Error bekommst. Ausserdem: Welche altis version benutzt du und welche [lexicon]extDB[/lexicon]?

      Habe es inzwischen soweit hinbekommen, dass es funktioniert. Habe jedoch immer noch zwei Errors in der db log.

      Altis 4.4
      extDB2

      Hier meine extDB2 log

      Spoiler anzeigen

      extDB2: Found [lexicon]extdb[/lexicon]-conf.ini
      extDB2: Detected 6 Cores, Setting up 6 Worker Threads


      [01:55:44:068 --7:00] [Thread 4060] extDB2: Database Type: MySQL
      [01:55:44:101 --7:00] [Thread 4060] extDB2: Database Session Pool Started
      [01:55:44:103 --7:00] [Thread 4060] extDB2: SQL_CUSTOM_V2: Loading Template Filename: C:\server\A3Master\@extDB2\[lexicon]extDB[/lexicon]\sql_custom_v2\altis-life-rpg-4.ini
      [01:55:44:103 --7:00] [Thread 4060] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available
      [01:56:53:883 --7:00] [Thread 3976] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';;1 2 3 4 5 6SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_lic' at line 1 [mysql_stmt_errno]: 1064 [mysql_stmt_sqlstate]: 42000 [statemnt]: UPDATE players;;1 2 3 4 5 6SQL1_2 = SET name=?, westcash=?, westbankacc=?, cop_gear=?, cop_licenses=? WHERE playerid=?;
      [01:56:53:883 --7:00] [Thread 3976] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session
      [01:56:53:883 --7:00] [Thread 3976] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: playerWestUpdate:Günther Gundula:100:2500:["U_Rangemaster","V_Rangemaster_belt","","","",["ItemMap","ItemCompass","Itemwatch","ItemGPS"],"","hgun_P07_snds_F",[],["16Rnd_9x21_Mag","16Rnd_9x21_Mag","16Rnd_9x21_Mag"],[],[],[],["16Rnd_9x21_Mag","16Rnd_9x21_Mag","16Rnd_9x21_Mag"],["","","",""],["muzzle_snds_L","","",""],[]]:[["license_cop_cAir",0],["license_cop_cg",0]]:76561198042173943
      [02:07:36:640 --7:00] [Thread 4060] extDB2: Stopping ...