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