Einbruch Nachricht kommt nicht

AmaZiinG

Okay Nachricht kommt jetzt. Nur das Problem ist nach einem Server Restart, wenn man bei seinem Haus spwant kann man alle Türen öffnen und muss das Haus neu kaufen.

In den ExtDB 3 Logs stand wieder folgendes:

Code

[13:14:43:364216 +02:00] [Thread 2828] extDB3: SQL: Error MariaDBQueryException: Unknown column 'security' in 'field list'
[13:14:43:364424 +02:00] [Thread 2828] extDB3: SQL: Error MariaDBQueryException: Input: SELECT pid, pos, classname, inventory, gear, dir, id, security FROM containers WHERE pid='76561198111029548' AND owned='1'

moeck

hast du eine tabelle containers?

AmaZiinG

Ja habe ich

moeck

hier mal noch ein update

C: fn_fetchPlayerHouses.sqf

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

 Description:
 1. Fetches all the players houses and sets them up.
 2. Fetches all the players containers and sets them up.
*/
private ["_query","_containers","_containerss","_houses","_furnituress"];
params [
 ["_uid","",[""]]
];
if (_uid isEqualTo "") exitWith {};

_query = format ["SELECT pid, pos, classname, inventory, gear, dir, id, security FROM houses WHERE pid='%1' AND owned='1'",_uid];
_containers = [_query,2,true] call DB_fnc_asyncCall;

_containerss = [];
_furnituress = [];
{
 _position = call compile format ["%1",_x select 1];
 _house = nearestObject [_position, "House"];
 _direction = call compile format ["%1",_x select 5];
 _trunk = [_x select 3] call DB_fnc_mresToArray;
 if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
 _gear = [_x select 4] call DB_fnc_mresToArray;
 if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
 //furniture and container split
 _className = _x select 2;
 _type = getText(missionConfigFile >> "CfgDonkeyPunchCustoms" >> _className);
 _isFurniture = getNumber(missionConfigFile >> "VirtualItems" >> _type >> "furniture") isEqualTo 1;
 _container = createVehicle[_x select 2,[0,0,999],[],0,"NONE"];
 waitUntil {!isNil "_container" && {!isNull _container}};
 if!(_isFurniture)then{
 _containerss pushBack _container;
 }else{
 _furnituress pushBack _container;
 _container enableSimulationGlobal false;
 };
 _container allowDamage false;
 _container setPosATL _position;
 _container setVectorDirAndUp _direction;
 //Fix position for more accurate positioning
 _posX = _position select 0;
 _posY = _position select 1;
 _posZ = _position select 2;
 _currentPos = getPosATL _container;
 _fixX = (_currentPos select 0) - _posX;
 _fixY = (_currentPos select 1) - _posY;
 _fixZ = (_currentPos select 2) - _posZ;
 _container setPosATL [(_posX - _fixX), (_posY - _fixY), (_posZ - _fixZ)];
 _container setVectorDirAndUp _direction;
 _container setVariable ["Trunk",_trunk,true];
 _container setVariable ["container_owner",[_x select 0],true];
 _container setVariable ["container_id",_x select 6,true];
 clearWeaponCargoGlobal _container;
 clearItemCargoGlobal _container;
 clearMagazineCargoGlobal _container;
 clearBackpackCargoGlobal _container;
 if (count _gear > 0) then {
 _items = _gear select 0;
 _mags = _gear select 1;
 _weapons = _gear select 2;
 _backpacks = _gear select 3;
 for "_i" from 0 to ((count (_items select 0)) - 1) do {
 _container addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
 };
 for "_i" from 0 to ((count (_mags select 0)) - 1) do{
 _container addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
 };
 for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
 _container addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
 };
 for "_i" from 0 to ((count (_backpacks select 0)) - 1) do{
 _container addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
 };
 };
 _house setVariable ["containers",_containerss,true];
 _house setVariable["Secured",_x select 4,true];
} forEach _containers;

_query = format ["SELECT pid, pos FROM houses WHERE pid='%1' AND owned='1'",_uid];
_houses = [_query,2,true] call DB_fnc_asyncCall;

_return = [];
{
 _pos = call compile format ["%1",_x select 1];
 _house = nearestObject [_pos, "House"];
 _house allowDamage false;
 _return pushBack [_x select 1,_containerss];
} forEach _houses;

missionNamespace setVariable [format ["houses_%1",_uid],_return];

Alles anzeigen

AmaZiinG

Jetzt ist es classname

Code

[13:33:20:576879 +02:00] [Thread 2504] extDB3: SQL: Error MariaDBQueryException: Unknown column 'classname' in 'field list'
[13:33:20:577098 +02:00] [Thread 2504] extDB3: SQL: Error MariaDBQueryException: Input: SELECT pid, pos, classname, inventory, gear, dir, id, security FROM houses WHERE pid='76561198111029548' AND owned='1'

moeck

achso moment habe da gerade noch was gesehen gibt gleich noch ein update

moeck

so hier nochmal ein Update

C: fn_fetchPlayerHouses.sqf

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

 Description:
 1. Fetches all the players houses and sets them up.
 2. Fetches all the players containers and sets them up.
*/
private ["_query","_containers","_containerss","_houses","_furnituress"];
params [
 ["_uid","",[""]]
];
if (_uid isEqualTo "") exitWith {};

_query = format ["SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses WHERE pid='%1' AND owned='1' and houses.pid = containers.pid",_uid];
_containers = [_query,2,true] call DB_fnc_asyncCall;

_containerss = [];
_furnituress = [];
{
 _position = call compile format ["%1",_x select 1];
 _house = nearestObject [_position, "House"];
 _direction = call compile format ["%1",_x select 5];
 _trunk = [_x select 3] call DB_fnc_mresToArray;
 if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
 _gear = [_x select 4] call DB_fnc_mresToArray;
 if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
 //furniture and container split
 _className = _x select 2;
 _type = getText(missionConfigFile >> "CfgDonkeyPunchCustoms" >> _className);
 _isFurniture = getNumber(missionConfigFile >> "VirtualItems" >> _type >> "furniture") isEqualTo 1;
 _container = createVehicle[_x select 2,[0,0,999],[],0,"NONE"];
 waitUntil {!isNil "_container" && {!isNull _container}};
 if!(_isFurniture)then{
 _containerss pushBack _container;
 }else{
 _furnituress pushBack _container;
 _container enableSimulationGlobal false;
 };
 _container allowDamage false;
 _container setPosATL _position;
 _container setVectorDirAndUp _direction;
 //Fix position for more accurate positioning
 _posX = _position select 0;
 _posY = _position select 1;
 _posZ = _position select 2;
 _currentPos = getPosATL _container;
 _fixX = (_currentPos select 0) - _posX;
 _fixY = (_currentPos select 1) - _posY;
 _fixZ = (_currentPos select 2) - _posZ;
 _container setPosATL [(_posX - _fixX), (_posY - _fixY), (_posZ - _fixZ)];
 _container setVectorDirAndUp _direction;
 _container setVariable ["Trunk",_trunk,true];
 _container setVariable ["container_owner",[_x select 0],true];
 _container setVariable ["container_id",_x select 6,true];
 clearWeaponCargoGlobal _container;
 clearItemCargoGlobal _container;
 clearMagazineCargoGlobal _container;
 clearBackpackCargoGlobal _container;
 if (count _gear > 0) then {
 _items = _gear select 0;
 _mags = _gear select 1;
 _weapons = _gear select 2;
 _backpacks = _gear select 3;
 for "_i" from 0 to ((count (_items select 0)) - 1) do {
 _container addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
 };
 for "_i" from 0 to ((count (_mags select 0)) - 1) do{
 _container addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
 };
 for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
 _container addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
 };
 for "_i" from 0 to ((count (_backpacks select 0)) - 1) do{
 _container addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
 };
 };
 _house setVariable ["containers",_containerss,true];
 _house setVariable["Secured",_x select 4,true];
} forEach _containers;

_query = format ["SELECT pid, pos FROM houses WHERE pid='%1' AND owned='1'",_uid];
_houses = [_query,2,true] call DB_fnc_asyncCall;

_return = [];
{
 _pos = call compile format ["%1",_x select 1];
 _house = nearestObject [_pos, "House"];
 _house allowDamage false;
 _return pushBack [_x select 1,_containerss];
} forEach _houses;

missionNamespace setVariable [format ["houses_%1",_uid],_return];

Alles anzeigen

AmaZiinG

Code

[14:09:35:478690 +02:00] [Thread 3884] extDB3: SQL: Error MariaDBQueryException: Column 'pid' in where clause is ambiguous
[14:09:35:478915 +02:00] [Thread 3884] extDB3: SQL: Error MariaDBQueryException: Input: SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses WHERE pid='76561198111029548' AND owned='1' and houses.pid = containers.pid

moeck

so einen habe ich noch

Code: fn_fetchplayerhouses.sqf

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

 Description:
 1. Fetches all the players houses and sets them up.
 2. Fetches all the players containers and sets them up.
*/
private ["_query","_containers","_containerss","_houses","_furnituress"];
params [
 ["_uid","",[""]]
];
if (_uid isEqualTo "") exitWith {};

_query = format ["SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses on houses.pid = containers.pid WHERE pid='%1' AND owned='1'",_uid];
_containers = [_query,2,true] call DB_fnc_asyncCall;

_containerss = [];
_furnituress = [];
{
 _position = call compile format ["%1",_x select 1];
 _house = nearestObject [_position, "House"];
 _direction = call compile format ["%1",_x select 5];
 _trunk = [_x select 3] call DB_fnc_mresToArray;
 if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
 _gear = [_x select 4] call DB_fnc_mresToArray;
 if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
 //furniture and container split
 _className = _x select 2;
 _type = getText(missionConfigFile >> "CfgDonkeyPunchCustoms" >> _className);
 _isFurniture = getNumber(missionConfigFile >> "VirtualItems" >> _type >> "furniture") isEqualTo 1;
 _container = createVehicle[_x select 2,[0,0,999],[],0,"NONE"];
 waitUntil {!isNil "_container" && {!isNull _container}};
 if!(_isFurniture)then{
 _containerss pushBack _container;
 }else{
 _furnituress pushBack _container;
 _container enableSimulationGlobal false;
 };
 _container allowDamage false;
 _container setPosATL _position;
 _container setVectorDirAndUp _direction;
 //Fix position for more accurate positioning
 _posX = _position select 0;
 _posY = _position select 1;
 _posZ = _position select 2;
 _currentPos = getPosATL _container;
 _fixX = (_currentPos select 0) - _posX;
 _fixY = (_currentPos select 1) - _posY;
 _fixZ = (_currentPos select 2) - _posZ;
 _container setPosATL [(_posX - _fixX), (_posY - _fixY), (_posZ - _fixZ)];
 _container setVectorDirAndUp _direction;
 _container setVariable ["Trunk",_trunk,true];
 _container setVariable ["container_owner",[_x select 0],true];
 _container setVariable ["container_id",_x select 6,true];
 clearWeaponCargoGlobal _container;
 clearItemCargoGlobal _container;
 clearMagazineCargoGlobal _container;
 clearBackpackCargoGlobal _container;
 if (count _gear > 0) then {
 _items = _gear select 0;
 _mags = _gear select 1;
 _weapons = _gear select 2;
 _backpacks = _gear select 3;
 for "_i" from 0 to ((count (_items select 0)) - 1) do {
 _container addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
 };
 for "_i" from 0 to ((count (_mags select 0)) - 1) do{
 _container addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
 };
 for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
 _container addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
 };
 for "_i" from 0 to ((count (_backpacks select 0)) - 1) do{
 _container addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
 };
 };
 _house setVariable ["containers",_containerss,true];
 _house setVariable["Secured",_x select 4,true];
} forEach _containers;

_query = format ["SELECT pid, pos FROM houses WHERE pid='%1' AND owned='1'",_uid];
_houses = [_query,2,true] call DB_fnc_asyncCall;

_return = [];
{
 _pos = call compile format ["%1",_x select 1];
 _house = nearestObject [_pos, "House"];
 _house allowDamage false;
 _return pushBack [_x select 1,_containerss];
} forEach _houses;

missionNamespace setVariable [format ["houses_%1",_uid],_return];

Alles anzeigen

AmaZiinG

Code

[16:15:43:140576 +02:00] [Thread 6916] extDB3: SQL: Error MariaDBQueryException: Column 'pid' in where clause is ambiguous
[16:15:43:140777 +02:00] [Thread 6916] extDB3: SQL: Error MariaDBQueryException: Input: SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses on houses.pid = containers.pid WHERE pid='76561198111029548' AND owned='1'

moeck

argh, ok wer lesen kann ist klar im vorteil. man sollte auch in der where bedingung spezifizieren aus welcher tabelle die pid kommt

Code

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

 Description:
 1. Fetches all the players houses and sets them up.
 2. Fetches all the players containers and sets them up.
*/
private ["_query","_containers","_containerss","_houses","_furnituress"];
params [
 ["_uid","",[""]]
];
if (_uid isEqualTo "") exitWith {};

_query = format ["SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses on houses.pid = containers.pid WHERE containers.pid='%1' AND owned='1'",_uid];
_containers = [_query,2,true] call DB_fnc_asyncCall;

_containerss = [];
_furnituress = [];
{
 _position = call compile format ["%1",_x select 1];
 _house = nearestObject [_position, "House"];
 _direction = call compile format ["%1",_x select 5];
 _trunk = [_x select 3] call DB_fnc_mresToArray;
 if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
 _gear = [_x select 4] call DB_fnc_mresToArray;
 if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
 //furniture and container split
 _className = _x select 2;
 _type = getText(missionConfigFile >> "CfgDonkeyPunchCustoms" >> _className);
 _isFurniture = getNumber(missionConfigFile >> "VirtualItems" >> _type >> "furniture") isEqualTo 1;
 _container = createVehicle[_x select 2,[0,0,999],[],0,"NONE"];
 waitUntil {!isNil "_container" && {!isNull _container}};
 if!(_isFurniture)then{
 _containerss pushBack _container;
 }else{
 _furnituress pushBack _container;
 _container enableSimulationGlobal false;
 };
 _container allowDamage false;
 _container setPosATL _position;
 _container setVectorDirAndUp _direction;
 //Fix position for more accurate positioning
 _posX = _position select 0;
 _posY = _position select 1;
 _posZ = _position select 2;
 _currentPos = getPosATL _container;
 _fixX = (_currentPos select 0) - _posX;
 _fixY = (_currentPos select 1) - _posY;
 _fixZ = (_currentPos select 2) - _posZ;
 _container setPosATL [(_posX - _fixX), (_posY - _fixY), (_posZ - _fixZ)];
 _container setVectorDirAndUp _direction;
 _container setVariable ["Trunk",_trunk,true];
 _container setVariable ["container_owner",[_x select 0],true];
 _container setVariable ["container_id",_x select 6,true];
 clearWeaponCargoGlobal _container;
 clearItemCargoGlobal _container;
 clearMagazineCargoGlobal _container;
 clearBackpackCargoGlobal _container;
 if (count _gear > 0) then {
 _items = _gear select 0;
 _mags = _gear select 1;
 _weapons = _gear select 2;
 _backpacks = _gear select 3;
 for "_i" from 0 to ((count (_items select 0)) - 1) do {
 _container addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
 };
 for "_i" from 0 to ((count (_mags select 0)) - 1) do{
 _container addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
 };
 for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
 _container addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
 };
 for "_i" from 0 to ((count (_backpacks select 0)) - 1) do{
 _container addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
 };
 };
 _house setVariable ["containers",_containerss,true];
 _house setVariable["Secured",_x select 4,true];
} forEach _containers;

_query = format ["SELECT pid, pos FROM houses WHERE pid='%1' AND owned='1'",_uid];
_houses = [_query,2,true] call DB_fnc_asyncCall;

_return = [];
{
 _pos = call compile format ["%1",_x select 1];
 _house = nearestObject [_pos, "House"];
 _house allowDamage false;
 _return pushBack [_x select 1,_containerss];
} forEach _houses;

missionNamespace setVariable [format ["houses_%1",_uid],_return];

Alles anzeigen

AmaZiinG

Code

[16:51:53:524156 +02:00] [Thread 2364] extDB3: SQL: Error MariaDBQueryException: Column 'owned' in where clause is ambiguous
[16:51:53:524364 +02:00] [Thread 2364] extDB3: SQL: Error MariaDBQueryException: Input: SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses on houses.pid = containers.pid WHERE containers.pid='76561198111029548' AND owned='1'

moeck

Code

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

 Description:
 1. Fetches all the players houses and sets them up.
 2. Fetches all the players containers and sets them up.
*/
private ["_query","_containers","_containerss","_houses","_furnituress"];
params [
 ["_uid","",[""]]
];
if (_uid isEqualTo "") exitWith {};

_query = format ["SELECT containers.pid, containers.pos, containers.classname, containers.inventory, containers.gear, containers.dir, containers.id, houses.security FROM containers join houses on houses.pid = containers.pid WHERE containers.pid='%1' AND containers.owned='1'",_uid];
_containers = [_query,2,true] call DB_fnc_asyncCall;

_containerss = [];
_furnituress = [];
{
 _position = call compile format ["%1",_x select 1];
 _house = nearestObject [_position, "House"];
 _direction = call compile format ["%1",_x select 5];
 _trunk = [_x select 3] call DB_fnc_mresToArray;
 if (_trunk isEqualType "") then {_trunk = call compile format ["%1", _trunk];};
 _gear = [_x select 4] call DB_fnc_mresToArray;
 if (_gear isEqualType "") then {_gear = call compile format ["%1", _gear];};
 //furniture and container split
 _className = _x select 2;
 _type = getText(missionConfigFile >> "CfgDonkeyPunchCustoms" >> _className);
 _isFurniture = getNumber(missionConfigFile >> "VirtualItems" >> _type >> "furniture") isEqualTo 1;
 _container = createVehicle[_x select 2,[0,0,999],[],0,"NONE"];
 waitUntil {!isNil "_container" && {!isNull _container}};
 if!(_isFurniture)then{
 _containerss pushBack _container;
 }else{
 _furnituress pushBack _container;
 _container enableSimulationGlobal false;
 };
 _container allowDamage false;
 _container setPosATL _position;
 _container setVectorDirAndUp _direction;
 //Fix position for more accurate positioning
 _posX = _position select 0;
 _posY = _position select 1;
 _posZ = _position select 2;
 _currentPos = getPosATL _container;
 _fixX = (_currentPos select 0) - _posX;
 _fixY = (_currentPos select 1) - _posY;
 _fixZ = (_currentPos select 2) - _posZ;
 _container setPosATL [(_posX - _fixX), (_posY - _fixY), (_posZ - _fixZ)];
 _container setVectorDirAndUp _direction;
 _container setVariable ["Trunk",_trunk,true];
 _container setVariable ["container_owner",[_x select 0],true];
 _container setVariable ["container_id",_x select 6,true];
 clearWeaponCargoGlobal _container;
 clearItemCargoGlobal _container;
 clearMagazineCargoGlobal _container;
 clearBackpackCargoGlobal _container;
 if (count _gear > 0) then {
 _items = _gear select 0;
 _mags = _gear select 1;
 _weapons = _gear select 2;
 _backpacks = _gear select 3;
 for "_i" from 0 to ((count (_items select 0)) - 1) do {
 _container addItemCargoGlobal [((_items select 0) select _i), ((_items select 1) select _i)];
 };
 for "_i" from 0 to ((count (_mags select 0)) - 1) do{
 _container addMagazineCargoGlobal [((_mags select 0) select _i), ((_mags select 1) select _i)];
 };
 for "_i" from 0 to ((count (_weapons select 0)) - 1) do{
 _container addWeaponCargoGlobal [((_weapons select 0) select _i), ((_weapons select 1) select _i)];
 };
 for "_i" from 0 to ((count (_backpacks select 0)) - 1) do{
 _container addBackpackCargoGlobal [((_backpacks select 0) select _i), ((_backpacks select 1) select _i)];
 };
 };
 _house setVariable ["containers",_containerss,true];
 _house setVariable["Secured",false,true];
 if ((_x select 1) isEqualTo 1) then {_house setVariable["Secured",true,true];};

} forEach _containers;

_query = format ["SELECT pid, pos FROM houses WHERE pid='%1' AND owned='1'",_uid];
_houses = [_query,2,true] call DB_fnc_asyncCall;

_return = [];
{
 _pos = call compile format ["%1",_x select 1];
 _house = nearestObject [_pos, "House"];
 _house allowDamage false;
 _return pushBack [_x select 1,_containerss];
} forEach _houses;

missionNamespace setVariable [format ["houses_%1",_uid],_return];

Alles anzeigen

AmaZiinG

Bekomme jetzt kein Fehler Meldung aber man muss das Haus immer noch neu Kaufen

moeck

ja vielleicht schaffe ich das heute noch, problem ist nur dass ich nicht testen kann.

Benutzer online in diesem Thema