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

powerafro2

Dann schick jetzt nochmal die Logs, nachdem du es ausgeführt hast.

~removed~

Bitteschön..

Rom

Zum Punkt extDB3, kann wohl daran liegen, ~removed~ :

Zitat von Rom

@lemyjr kein Problem,
für alle anderen, woran es lag und was zusätzlich geändert musste:

fn_persoRequest.sqf, [_ergebnis] remoteExecCall ["fvs_fnc_persoErgebnis",(owner _player)]; gändert zu _ergebnis remoteExecCall ["fvs_fnc_persoErgebnis",(owner _player)];

da kein SQL_CUSTOM-Protokoll verwendet wird, sondern SQL_RAW/SQL, entstand der MySQL-Fehler im extDB3-Log, z.B.

SQL_RAW/SQL: SELECT persoCop FROM perso WHERE pid='%1'

SQL_CUSTOM: CUSTOMCALL:ARGUMENT:ARGUMENT:...

~removed~

Zitat von Rom

Zum Punkt extDB3, kann wohl daran liegen, ~removed~ :

Danke! Ich teste es mal

~removed~

Zitat von Rom

Zum Punkt extDB3, kann wohl daran liegen, ~removed~ :

Habe das jetzt in der Datei geändert jedoch öffnet sich das Fenster wieder sofort nachdem absenden.

Rom

Hast du auch die ausgeschriebenen SQL-Statements drinne? Sprich die life_server-Version für extDB2 für 4.5?

~removed~

Zitat von Rom

Hast du auch die ausgeschriebenen SQL-Statements drinne? Sprich die life_server-Version für extDB2 für 4.5?

Umm, für doofe? Sorry bin gerade komplett bescheuert..

~removed~

Gibt es evt. die möglichkeit kurz zu schnacken?

Rom

So in der Art sollte es aussehen.

Edit: Der Unterschied mag klein sein, aber wichtig.

~removed~

Zitat von Rom

So in der Art sollte es aussehen.

Edit: Der Unterschied mag klein sein, aber wichtig.

Jetzt Spamt er mir Frage Spieler Informationen ab..

oh man

Edit: Und füllt meine Perso Datenbank mit any

Derverdox · 144.76.31.37

Zitat von joelbhv

Jetzt Spamt er mir Frage Spieler Informationen ab..

oh man

Edit: Und füllt meine Perso Datenbank mit any

Versuche mal diese fn_insertRequest

Code

#include "\life_server\script_macros.hpp"
/*
    File: fn_insertRequest.sqf
    Author: Bryan "Tonic" Boardwine

    Description:
    Adds a player to the database upon first joining of the server.
    Recieves information from core\sesison\fn_insertPlayerInfo.sqf
*/
private ["_queryResult","_query","_alias"];
params [
    "_uid",
    "_name",
    ["_money",-1,[0]],
    ["_bank",-1,[0]],
    ["_returnToSender",objNull,[objNull]]
];

//Error checks
if ((_uid isEqualTo "") || (_name isEqualTo "")) 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 ["SELECT pid, name FROM players WHERE pid='%1'",_uid];


_tickTime = diag_tickTime;
_queryResult = [_query,2] call DB_fnc_asyncCall;

if (EXTDB_SETTING(getNumber,"DebugMode") isEqualTo 1) then {
    diag_log "------------- Insert Query Request -------------";
    diag_log format ["QUERY: %1",_query];
    diag_log format ["Time to complete: %1 (in seconds)",(diag_tickTime - _tickTime)];
    diag_log format ["Result: %1",_queryResult];
    diag_log "------------------------------------------------";
};

//Double check to make sure the client isn't in the database...
if (_queryResult isEqualType "") exitWith {[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];}; //There was an entry!
if !(count _queryResult isEqualTo 0) exitWith {[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];};

//Clense and prepare some information.
_name = [_name] call DB_fnc_mresString; //Clense the name of bad chars.
_alias = [[_name]] call DB_fnc_mresArray;
_money = [_money] call DB_fnc_numberSafe;
_bank = [_bank] call DB_fnc_numberSafe;

//In der gelieferten Version nimmt er eine playerid! Die ist aber in der 5.0 (wahrscheinlich auch in der 4.0) die "pid"
_query = format ["INSERT INTO players (pid, name, cash, bankacc, aliases, cop_licenses, med_licenses, civ_licenses, civ_gear, cop_gear, med_gear) VALUES('%1', '%2', '%3', '%4', '%5','""[]""','""[]""','""[]""','""[]""','""[]""','""[]""')",
    _uid,
    _name,
    _money,
    _bank,
    _alias
];
_query_2 = format["INSERT INTO perso(pid, persoCop, persoMed, persoCiv, persoEast) VALUES ('%1','""[]""','""[]""','""[]""','""[]""')",_uid];
[_query,1] call DB_fnc_asyncCall;
[_query_2,1] call DB_fnc_asyncCall;
[] remoteExecCall ["SOCK_fnc_dataQuery",(owner _returnToSender)];

Alles anzeigen

Evtl hast du nur copy pasted und so hast du eine unvollständige gehabt

x33Pingu

Rom Keine ahnung wo der Fehler ist vielleicht siehst du ihn ja. steht halt immer nur Überprüfe Daten des Personalausweises

Client RPT Fehlermeldung

Code

19:49:13 Wrong init state
19:49:13 Attempt to override final function - bis_fnc_endmission
19:49:14 "------------------------------------------------------------------------------------------------------"
19:49:14 "--------------------------------- Starting Altis Life Client Init ----------------------------------"
19:49:14 "------------------------------------------------------------------------------------------------------"
19:49:14 "::Life Client:: Initialization Variables"
19:49:14 "::Client:: Pruefe Personalausweisdaten."
19:49:14 Error in expression <alausweises...","BLACK FADED"];
[] call fvs_fnc_perso_laden;
0 cutFadeOut 999999>
19:49:14   Error position: <fvs_fnc_perso_laden;
0 cutFadeOut 999999>
19:49:14   Error Undefined variable in expression: fvs_fnc_perso_laden
19:49:14 File mpmissions\__CUR_MP.Altis\core\init.sqf, line 25

Alles anzeigen

Fehlereintrag aus der Init.sqf

Code

[] call compile PreprocessFileLineNumbers "core\clientValidator.sqf";
enableSentences false;

//Setup initial client core functions
diag_log "::Life Client:: Initialization Variables";
[] call compile PreprocessFileLineNumbers "core\configuration.sqf";

//Personalausweis
diag_log "::Client:: Pruefe Personalausweisdaten.";
0 cutText ["Ueberpruefe Daten des Personalausweises...","BLACK FADED"];
[] call fvs_fnc_perso_laden;
0 cutFadeOut 99999999;
waitUntil{fvs_persoReady};

//Set bank amount for new players
switch (playerSide) do {
    case west: {
        BANK = LIFE_SETTINGS(getNumber,"bank_cop");
        life_paycheck = LIFE_SETTINGS(getNumber,"paycheck_cop");
    };
    case civilian: {
        BANK = LIFE_SETTINGS(getNumber,"bank_civ");
        life_paycheck = LIFE_SETTINGS(getNumber,"paycheck_civ");
    };
    case independent: {
        BANK = LIFE_SETTINGS(getNumber,"bank_med");
        life_paycheck = LIFE_SETTINGS(getNumber,"paycheck_med");
    };
};

diag_log "::Life Client:: Variables initialized";
diag_log "::Life Client:: Setting up Eventhandlers";
[] call life_fnc_setupEVH;

diag_log "::Life Client:: Eventhandlers completed";
diag_log "::Life Client:: Setting up user actions";

Alles anzeigen

Rom

Ich verweise dich mal auf zig andere Probleme mit der Functions.h/hpp. Dort ist vielen ein Fehler unterlaufen. Poste mal deine bitte

x33Pingu

Ja gut okay jetzt öffnet es sich alles aber jetzt trage ich alles ein makiere die hacken und dann auf bestätigen aber dann lande ich wieder im gleichen bildschirm

PoweredByte

Wo kann man einstellen wie lang der Name sein darf & wo kann man case-sensitive deaktivieren?.

x33Pingu

Rom ich lande nun immer im gleichen Bildschirm beim bestätigen des Fensters habe mal C und S Rpt dran gehangen und ja die Fehler die drinnen stehen kenne ich also in der "CleanUp" und in der "greenhammer". Diese sind aber eigentlich nicht relevant. Das Problem ist zurzeit nur das wenn man alle Haken bestätigt und dann den Ausweis beantragen will man wieder im gleichen Fenster landet.

Rom

x33Pingu noch zusätzlich denen extDB-Log bitte, danke schon

x33Pingu

Ahh jetzt ich sehe schon. Daran hatte ich nicht gedacht nur die Frage was muss ich machen xD

Code

extDB2: Version: 70
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 8 Cores, Setting up 6 Worker Threads


[19:29:51:421239 +02:00] [Thread 14700] extDB2: Database Type: MySQL
[19:29:51:425432 +02:00] [Thread 14700] extDB2: Database Session Pool Started
[19:29:51:425837 +02:00] [Thread 14700] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True
[19:32:34:707505 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'requestPersoCivilian:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: requestPersoCivilian:76561198082987757
[19:32:34:707791 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: requestPersoCivilian:76561198082987757
[19:32:34:725668 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'insertPerso:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: insertPerso:76561198082987757
[19:32:34:725709 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: insertPerso:76561198082987757
[19:32:45:045509 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","77982987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","77982987757","[email protected]","170","55","1","1","1950","39071","0","1"]':76561198082987757
[19:32:45:045558 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","77982987757","[email protected]","170","55","1","1","1950","39071","0","1"]':76561198082987757
[19:32:45:193086 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'requestPersoCivilian:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: requestPersoCivilian:76561198082987757
[19:32:45:193126 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: requestPersoCivilian:76561198082987757
[19:32:45:216734 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'insertPerso:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: insertPerso:76561198082987757
[19:32:45:216782 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: insertPerso:76561198082987757
[19:32:53:832293 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","78982987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","78982987757","[email protected]","170","55","1","1","1950","39071","0","1"]':76561198082987757
[19:32:53:832469 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: updatePersoCivilian:'["Rudi Leutner","66","M","A","Kleine Felswand","78982987757","[email protected]","170","55","1","1","1950","39071","0","1"]':76561198082987757
[19:32:53:997194 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'requestPersoCivilian:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: requestPersoCivilian:76561198082987757
[19:32:53:997235 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: requestPersoCivilian:76561198082987757
[19:32:54:016069 +02:00] [Thread 13216] extDB2: SQL_RAW_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 'insertPerso:76561198082987757' at line 1    [mysql_stmt_errno]: 1064    [mysql_stmt_sqlstate]: 42000    [statemnt]: insertPerso:76561198082987757
[19:32:54:016112 +02:00] [Thread 13216] extDB2: SQL_RAW_V2: Error StatementException: SQL: insertPerso:76561198082987757

Alles anzeigen

Rom

Also,

entweder hast du die life_server-Version für extDB3 genommen oder die extDB2-Version mit ini/SQL_CUSTOM für die Version 4.0, welche ich denke mal du nicht nutzt, sonst würde der Fehler nicht kommen.

Probiere mal bitte diese Variante (unterscheiden sich alle im Grunde entweder im Protokoll oder mit einer zusätzlichen Klammer oder einer weniger): life_server Versionen\extDB2\life_server 4.5

x33Pingu

Okay das hat funktioniert nun hab ich wieder nen Fehler Fehler im Personalausweis steht da und dann beendet sich die Mission

extDB2 Log

Code

extDB2: Version: 70
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 8 Cores, Setting up 6 Worker Threads


[20:27:41:460271 +02:00] [Thread 5324] extDB2: Database Type: MySQL
[20:27:41:463305 +02:00] [Thread 5324] extDB2: Database Session Pool Started
[20:27:41:463579 +02:00] [Thread 5324] extDB2: SQL_RAW_V2: Initialized: ADD_QUOTES True

Alles anzeigen

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

Ähnliche Themen

Neue Lizenzen hinzufügen auf der 4.4r4

Ich suche ein Ausweis Script

Ausweis Script für die 5.0.0

Spielernamen

Personalausweis für 4.4.r4

Name über dem Kopf