SQL phone Error

Brandy1118

Error:

Code

12:06:41 Error in expression <format [ "Query:% 1" _ query];
WAITUNTIL DB_Async_Active {!};
[_query, 1] call DB_fn>
 12:06:41 Error position: <} DB_Async_Active;
[_query, 1] call DB_fn>
 12:06:41 Error Missing {
 12:06:41 File life_server \ Functions \ Smartphone \ fn_handleMessages.sqf, line 19
 12:06:41 Error in expression <format [ "Query:% 1" _ query];
WAITUNTIL DB_Async_Active {!};
[_query, 1] call DB_fn>
 12:06:41 Error position: <} DB_Async_Active;
[_query, 1] call DB_fn>
 12:06:41 Error Missing {
 12:06:41 File life_server \ Functions \ Smartphone \ fn_handleMessages.sqf, line 19

Alles anzeigen

handleMessage

Code: fn_handleMessages.sqf

/ * File: fn_handleMessages.sqf Author: Silex * /




private [ "_ msg", "_ to", "_ target", "_ player", "_ type"];
_target = [_this, 0, ObjNull, [ObjNull]] call BIS_fnc_param;
_msg = [_this, 1, "" [ ""]] call BIS_fnc_param;
_player = [_this, 2, ObjNull, [ObjNull]] call BIS_fnc_param;
_type = [_this, 3, -1] call BIS_fnc_param;




switch (_type) do {// normal message 
case 0: {if (IsNull _target) exit with {};
 _to = call compile format [ "% 1", _target];
[_msg, Name _player, 0] RemoteExec [ "TON_fnc_clientMessage" _ to];
 private [ "_ query", "_ pid", "_ toID"];
_pid = getPlayerUID _player;
 _toID = getPlayerUID _target;
 _msg = [_msg] call DB_fnc_mresString;
 _fromName = name _player;
 _toName = name _target;
 _query = format [ "INSERT INTO messages (fromID, toID, message, fromName, toName) VALUES ( '% 1', '% 2', '" "% 3" "', '% 4', '% 5') "_pid, _toID _msg, _fromName, _toName];
 diag_log format [ "Query:% 1" _ query];
 WAITUNTIL DB_Async_Active {!};
 [_query, 1] call DB_fnc_asyncCall;
 };
 // Message to cops 
 case 1: { 
[_msg, Name _player, 1] RemoteExec [ "TON_fnc_clientMessage" west];
 };
 // To admins 
 case 2: { 
[_msg, Name _player, 2] RemoteExec [ "TON_fnc_clientMessage", 0];
 };
 // Ems request 
 case 3: { 
[_msg, Name _player, 5] RemoteExec [ "TON_fnc_clientMessage" independent];
 };
 // adminToPerson 
 case 4: {_to = call compile format [ "% 1", _target];
 if (isNull _to) exit with {};
[_msg, Name _player, 3] RemoteExec [ "TON_fnc_clientMessage" _ to];
 };
 / / AdminMsgAll
 case 5: {[_msg, name _player, 4] RemoteExec [ "TON_fnc_clientMessage", 0];
 };
};

Alles anzeigen

blackfisch

Zitat von Brandy1118

WAITUNTIL DB_Async_Active {!};

-> waotUntil {!DB_Async_Active];

Brandy1118

Zitat von blackfisch

-> [Tt] {waotUntil DB_Async_Active]; [/ Tt]!

waotUntil {DB_Async_Active];

or

waitUntil{DB_Async_Active];

Brandy1118

Now getting this

Smartphone.hpp

Code

class Life_my_smartphone {
Idd =  88888 ;
 name = "life_my_telephone_menu";
 movingEnable = false;
 enableSimulation = true;
 onLoad = "[] spawn life_fnc_smartphone;";
 class controlsBackground {
 class Life_RscTitleBackground:Life_RscText {
 colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", "(profilenamespace getvariable ['GUI_BCG_RGB_A',0.7])"};
 idc = -1;
 x = 0.1;
and = 0.2;
 w = 0.95;
 h = (1 / 25);
 };
 class MainBackground:Life_RscText {
 colorBackground[] = {0, 0, 0, 0.7};
 idc = -1;
 x = 0.1;
and = 0.2 + ( November  /  250 );
 w = 0.95;
 h = 0.7 - (22 / 250);
 };
 class PlayerListTitleBackground:Life_RscText {
 colorBackground[] = {0.588, 0.424, 0.145, 1.0};
 idc = -1;
 x = 0.11;
and = 0.25;
 w = 0.2;
 h = (1 / 25);
 };
 class MessageTitleBackground:Life_RscText {
 colorBackground[] = {0.588, 0.424, 0.145, 1.0};
 idc = -1;
 x = 0.325;
and = 0.25;
 w = 0.7;
 h = (1 / 25);
 };
 class RandomTitleBackground:Life_RscText {
 colorBackground[] = {0.588, 0.424, 0.145, 1.0};
 idc = -1;
 x = 0.325;
and = 0.25 + 0.3 + ( 1  /  25 );
 w = 0.7;
 h = (1 / 25);
 };
 };
 class controls {
 class MessageTitle : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = 88886;
 text = "";
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.9)";
 x = 0.325;
and = 0.25;
 w = 0.7;
 h = (1 / 25);
 };
 class RandomTitle : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = 88890;
 text = "$STR_SMARTPHONE_RANDOMTITLE";
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.9)";
 x = 0.325;
and = 0.25 + 0.3 + ( 1  /  25 );
 w = 0.7;
 h = (1 / 25);
 };
 class PlayerList : Life_RscListBox {
 idc = 88881;
 onLBSelChanged = "[2] spawn life_fnc_smartphone;";
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
 x = 0.11;
and = 0.25 + ( 1  /  25 );
 w = 0.2;
 h = 0.5;
 };
 class MessageList : Life_RscListNBox {
 idc = 88882;
 onLBSelChanged = "[(lbCurSel 88882)] call life_fnc_showMsg;";
 //sizeEx = 0.04;
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
 colorBackground[] = {0, 0, 0, 0.0};
 columns[] = {0,0.3};
 x = 0.325;
and = 0.25 + ( 1  /  25 );
 w = 0.7;
 h = 0.3;
 };
 class TextShow : Life_RscControlsGroup {
 x = 0.325;
and = 0.25 + 0.3 + ( 1  /  25 ) + ( 1  /  25 );
 w = 0.7;
 h = 0.15;
 class HScrollbar : HScrollbar {
 height = 0;
 };
 class controls {
 class showText : Life_RscStructuredText {
 idc = 88887;
 text = "";
 colorBackground[] = {0.28,0.28,0.28,0.28};
 size = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
 shadow = 0;
 x = 0;
and =  0 ;
a = 0.69; / / a = 0.7;
h =  1 ; / / hr = 2:15;
 };
 };
 };
 class letter: Life_RscButtonMenu {
 idc = 887892;
 text  =  "$ STR_SMARTPHONE_SCHREIBEN" ;
 onButtonClick = "[4] call life_fnc_smartphone;";
 colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", 1.0};
 x = 0.11;
and = 0.25 + ( 1  /  25 ) + 0.51;
 w = 0.2;
 h = (1 / 25);
 };
 class Title : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = -1;
 text = "$STR_SMARTPHONE_TITLE";
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 1)";
 x = 0.1;
and = 0.2;
 w = 0.95;
 h = (1 / 25);
 };
 class PlayerListTitle : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = -1;
 text = "$STR_SMARTPHONE_PLAYERLISTTITLE";
 sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.9)";
 x = 0.11;
and = 0.25;
 w = 0.2;
 h = (1 / 25);
 };
 class CloseLoadMenu : Life_RscButtonMenu {
 idc = -1;
 text = "$STR_Global_Close";
 onButtonClick = "closeDialog 0;";
 x = -0.06 + (6.25 / 40) + (1 / 250 / (safezoneW / safezoneH));
and = 0.9 - ( 1  /  25 );
 w = (6.25 / 40);
 h = (1 / 25);
 };
 class emergency: Life_RscButtonMenu {
 idc = -1;
 text  =  "$ STR_SMARTPHONE_NOTRUF" ;
 onButtonClick = "createDialog ""Life_smartphone_notruf"";";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 x = 0.325 + 0.7 - (6.25 / 40);
and = 0.25 + ( 1  /  25 ) + 0.51;
 w = (6.25 / 40);
 h = (1 / 25);
 };
 };
};
class Life_smartphone_schreiben {
Idd =  88883 ;
 name = "life_my_smartphone_schreiben";
 movingEnable = false;
 enableSimulation = true;
 onLoad = "";
 class controlsBackground {
 class Life_RscTitleBackground:Life_RscText {
 colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", "(profilenamespace getvariable ['GUI_BCG_RGB_A',0.7])"};
 idc = -1;
 x = 0.1;
and = 0.2;
 w = 0.6;
 h = (1 / 25);
 };
 class MainBackground:Life_RscText {
 colorBackground[] = {0, 0, 0, 0.7};
 idc = -1;
 x = 0.1;
and = 0.2 + ( November  /  250 );
 w = 0.6;
 h = 0.1;
 };
 };
 class controls {
 class Title : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = 88886;
 text  =  "$ STR_SMARTPHONE_NACHRICHTTITLE" ;
 x = 0.1;
and = 0.2;
 w = 0.95;
 h = (1 / 25);
 };
 class sending: Life_RscButtonMenu {
 idc = 88885;
 text  =  "$ STR_SMARTPHONE_ABSENDEN" ;
 onButtonClick = "[1,-1,(ctrlText 88884)] call life_fnc_newMsg;";
 colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", 1.0};
 x = 0.6 - (6.25 / 40) + 0.088;
and = 0.3 + ( 1  /  25 ) - 0.048;
 w = (6.25 / 40);
 h = (1 / 25);
 };
 class AdminMsg : life_RscButtonMenu 
 {
 idc = 888897;
 text = "$STR_CELL_AdminMsg";
 colorBackground[] = {"(profilenamespace getvariable ['GUI_BCG_RGB_R',0.3843])", "(profilenamespace getvariable ['GUI_BCG_RGB_G',0.7019])", "(profilenamespace getvariable ['GUI_BCG_RGB_B',0.8862])", 1.0};
 onButtonClick = "[5,-1,(ctrlText 88884)] call life_fnc_newMsg;";
 x = 0.6 - (6.25 / 40) - 0.121;
and = 0.3 + ( 1  /  25 ) - 0.048;
 w = 0.2;
 h = (1 / 25);
 };
 class Close : Life_RscButtonMenu {
 idc = -1;
 text = "$STR_Global_Close";
 onButtonClick = "closeDialog 0;";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 x = 0.11;
and = 0.3 + ( 1  /  25 ) - 0.048;
 w = (6.25 / 40);
 h = (1 / 25);
 };
 class textEdit : Life_RscEdit {
 idc = 88884;
 text = "";
 sizeEx = 0.030;
x = 0.11; and = 0.3 - .048;
 w = 0.58; h = 0.03;
 };
 };
};
class Life_smartphone_notruf {
Idd =  887 890 ;
 name= "life_my_smartphone_notruf";
 movingEnable = false;
 enableSimulation = true;
 onLoad = "[6] spawn life_fnc_newMsg;";
 class controlsBackground {
 class Life_RscTitleBackground:Life_RscText {
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 idc = -1;
 x = 0.1;
and = 0.2;
 w = 0.64;
 h = (1 / 25);
 };
 class MainBackground:Life_RscText {
 colorBackground[] = {0, 0, 0, 0.7};
 idc = -1;
 x = 0.1;
and = 0.2 + ( November  /  250 );
 w = 0.64;
 h = 0.15 - (5 / 250);
 };
 };
 class controls {
 class Title : Life_RscTitle {
 colorBackground[] = {0, 0, 0, 0};
 idc = 888892;
 text  =  "$ STR_SMARTPHONE_Notruftitle" ;
 x = 0.1;
and = 0.2;
 w = 0.6;
 h = (1 / 25);
 };
 class textEdit : Life_RscEdit {
 idc = 888894;
 text = "";
 sizeEx = 0.030;
x = 0.11; and = 0.25;
 w = 0.62; h = 0.03;
 };
 class TxtCopButton : life_RscButtonMenu 
 {
 idc = 888895;
 text = "$STR_CELL_TextPolice";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 onButtonClick = "[2,-1,(ctrlText 888894)] call life_fnc_newMsg;";
 x = 0.32;
and = 0.30;
 w = 0.2;
 h = (1 / 25);
 };
 class TxtAdminButton : life_RscButtonMenu 
 {
 idc = 888896;
 text = "$STR_CELL_TextAdmins";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 onButtonClick = "[3,-1,(ctrlText 888894)] call life_fnc_newMsg;";
 x = 0.53;
and = 0.30;
 w = 0.2;
 h = (1 / 25);
 };
 class AdminMsgAll : life_RscButtonMenu 
 {
 idc = 888898;
 text = "$STR_CELL_AdminMSGAll";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 onButtonClick = "[7,-1,(ctrlText 888894)] call life_fnc_newMsg;";
 x = 0.53;
and = 0.30;
 w = 0.2;
 h = (1 / 25);
 };
 class EMSReq : life_RscButtonMenu
 {
 idc = 888899;
 text = "$STR_CELL_EMSRequest";
 colorBackground[] = {0.584, 0.086, 0.086,1.0};
 onButtonClick = "[4,-1,(ctrlText 888894)] call life_fnc_newMsg;";
 x = 0.11;
and = 0.30;
 w = 0.2;
 h = (1 / 25);
 };
 class CloseButton : Life_RscButtonMenu {
 idc = -1;
 text = "$STR_Global_Close";
 onButtonClick = "closeDialog 0;";
 x = -0.06 + (6.25 / 40) + (1 / 250 / (safezoneW / safezoneH));
and = 0.36 + ( 1  /  50 );
 w = (6.25 / 40);
 h = (1 / 25);
 };
 };
};

Alles anzeigen

Server Log:

Code

Error context / a = 0.7;
Warning Message: File mpmissions\__cur_mp.Altis\dialog\smartphone.hpp, line 107: '/Life_my_smartphone/controls/TextShow/controls/showText.': '/' encountered instead of '='
Warning Message: Config : some input after EndOfFile.
Class Life_RscControlsGroup destroyed with lock count 1
Class HScrollBar destroyed with lock count 1
Class Life_RscListNBox destroyed with lock count 1
Class Life_RscText destroyed with lock count 5
Class Life_RscTitle destroyed with lock count 2
Class Life_RscStructuredText destroyed with lock count 1
Class Life_RscListBox destroyed with lock count 1

blackfisch

Zitat von Brandy1118

class showText : Life_RscStructuredText {
idc = 88887;
text = "";
colorBackground[] = {0.28,0.28,0.28,0.28};
size = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
shadow = 0;
x = 0;
and = 0 ;
a = 0.69; / / a = 0.7;
h = 1 ; / / hr = 2:15;
};

Alles anzeigen

->

C

class showText : Life_RscStructuredText {
 idc = 88887;
 text = "";
 colorBackground[] = {0.28,0.28,0.28,0.28};
 size = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
 shadow = 0;
 x = 0;
 y = 0;
 w = 0.69; / / w = 0.7;
 h = 1 ; / / h = 2/15;
};

Alles anzeigen

(not quite sure, but should be)

Brandy1118

still the same error.

Code

Error context / w = 0.7;
Warning Message: File mpmissions\__cur_mp.Altis\dialog\smartphone.hpp, line 107: '/Life_my_smartphone/controls/TextShow/controls/showText.': '/' encountered instead of '='
Warning Message: Config : some input after EndOfFile.
Class Life_RscControlsGroup destroyed with lock count 1
Class HScrollBar destroyed with lock count 1
Class Life_RscListNBox destroyed with lock count 1
Class Life_RscText destroyed with lock count 5
Class Life_RscTitle destroyed with lock count 2
Class Life_RscStructuredText destroyed with lock count 1
Class Life_RscListBox destroyed with lock count 1

blackfisch

C

class showText : Life_RscStructuredText {
 idc = 88887;
 text = "";
 colorBackground[] = {0.28,0.28,0.28,0.28};
 size = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * 0.8)";
 shadow = 0;
 x = 0;
 y = 0;
 w = 0.69; // w = 0.7;
 h = 1 ; // h = 2/15;
};

Alles anzeigen

sorry, it added some spaces

SQL phone Error

Ähnliche Themen

Probleme mit der Datenbank (Gang)

Nachrichtensystem - Hilfe

Benutzer online in diesem Thema