Beiträge von GaNja

GaNja

In welcher Datei kann man die Attribute der jeweiligen Schwierigkeitsstufen einstellen. Da wenn man die Schwierigkeit Veteran nimmt, trotzdem 3rd person View hat?

GaNja

wie kann man dies beheben?

Hab alles so gemacht wie im tutorial

GaNja · 21-59-18.log

Bei mir wird die Message Box gar nicht angezeigt

Ich schicke mal alle Logs:

GaNja

na ich probiere es mal aus, sollte es sich zu einem riesen performance fresser entwickeln, kann ich es ja wieder rückgängig machen.

Gab es nicht mal die möglichkeit sich bestimmte actionen von spielern in den Server logs farbig zu markieren, also z.B. wenn eine Waffe dubliziert wird, das dies in den Logs Rot angezeigt wird?

GaNja

Gibt es eine andere Möglichkeit?

Ich habe nämlich bei LiveYourLife gesehen das die das so gelöst haben.

GaNja

Die Endmission Konsole wurde ja von Bohemia selbst gefixt und bei uns hab ich die Tastenkombination Alt + F4 wie auch Esc + Alt + F4 gesperrt.

Mir fällt da noch der Dupe mit Lagswitch ein, sowohl mit dem T- Inventar wie auch mit dem I - Inventar.

Meine Idee wäre, das während die Invetare offen sind man irgendwie eine Abfrage macht ob der Packet Fluss unterbrochen wird.

Meine Frage jetzt wie stelle ich das an?

GaNja

Danke ich werde es später mal ausprobieren

GaNja

Ich habe für das Navy HQ und ein Rebellen HQ, einen Flugzeugträger auf der Map plaziert und auch shops und einen spawnpunkt definiert und auch ins Variablen Fenster eingetragen. Soweit so gut, man kann dort auch spawnen, jedoch nicht auf dem Deck, sondern man spawnt im Wasser

Gibt es eine möglichkeit die spawnhöhe mit Koordinaten anzupassen?

GaNja

es gab ein Array doppelt und dadurch konnte die Pid nicht abgerufen werden

GaNja

Hab es selbst gefixt trotzdem Danke

GaNja

Ich schwöre auf meinen PC, dass ich nichts dran geändert habe. Was muss ich den da rauslöschen oder ändern, das es funktioniert?

GaNja

Bitte schön

GaNja · 13-7-57.log

Bitte schön

GaNja

So habe die Datenbank ausgetauscht steht dort immernoch, dass der Server versucht die Pid aufzurufen.

Das ist der Error in der RPT

SQL

13:08:06 BEServer: registering a new player #100459200
13:08:53 Server: Object 0:0 not found (message Type_181)
13:08:55 Unaccessible
13:09:01 Error in expression <a = _old select _i;

_old set[_i,[_data select 0, ([_data select 1,1] call DB_fn>
13:09:01   Error position: <select 0, ([_data select 1,1] call DB_fn>
13:09:01   Error select: Type Number, expected Array,String,Config entry
13:09:01 File \life_server\Functions\MySQL\fn_queryRequest.sqf [DB_fnc_queryRequest], line 210
13:09:35 Unknown attribute shadown

Dies hier ist die fn_queryRequest.sqf von Zeile 182-210

SQL

//Playtime

_new = [(_queryResult select 11)] call DB_fnc_mresToArray;

if (_new isEqualType "") then {_new = call compile format["%1", _new];};

_index = TON_fnc_playtime_values_request find [_uid, _new];

if (_index != -1) then {

TON_fnc_playtime_values_request set[_index,-1];

TON_fnc_playtime_values_request = TON_fnc_playtime_values_request - [-1];

TON_fnc_playtime_values_request pushBack [_uid, _new];

} else {

TON_fnc_playtime_values_request pushBack [_uid, _new];

};

[_uid,_new select 0] call TON_fnc_setPlayTime;

};

case civilian: {

_queryResult set[7,([_queryResult select 7,1] call DB_fnc_bool)];

Alles anzeigen

Ich habe an dieser Datei null geändert, kann mir jemand sagen wo der Fehler liegt und wie man ihn behebt?

GaNja

hätte jemand für mich die standart altislife.sql für 5.0?

GaNja

Woran könnte es den liegen?

Brauche nen Ansatzpunkt wo ich suchen muss

GaNja

Es geht immernoch nicht....

Code

extDB3: https://bitbucket.org/torndeco/extdb3/wiki/Home
extDB3: Version: 1.031
extDB3: Windows Version
Message: All development for extDB3 is done on a Linux Dedicated Server
Message: If you would like to Donate to extDB3 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: 18/05/15


extDB3: Found extdb3-conf.ini
extDB3: Detected 8 Cores, Setting up 6 Worker Threads
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...
extDB3: ...


[19:16:52:230692 +02:00] [Thread 1860] extDB3: SQL: Initialized: Add Quotes around TEXT Datatypes mode: 2
[19:16:52:230878 +02:00] [Thread 1860] extDB3: SQL: Initialized: NULL = ""
[19:16:52:230899 +02:00] [Thread 1860] extDB3: Locked
[19:18:22:982194 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:22:982417 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:23:214762 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:23:214790 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:23:460086 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:23:460167 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:23:674046 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:23:674072 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:24:006589 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:24:006669 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:24:370608 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:24:370688 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:24:999564 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:24:999647 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:25:381640 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:25:381670 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:25:582462 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:25:582547 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:25:818546 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:25:818572 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:26:603896 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:26:603977 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:26:836095 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:26:836126 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:27:076858 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:27:076938 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:27:291532 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:27:291560 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:27:510646 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:27:510728 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:27:749344 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:27:749369 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'
[19:18:27:987436 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Unknown column 'playerid' in 'field list'
[19:18:27:987467 +02:00] [Thread 7000] extDB3: SQL: Error MariaDBQueryException: Input: SELECT playerid, name, cash, bankacc, adminlevel, donorlevel, civ_licenses, arrested, civ_gear, civ_prof, civ_stats, civ_alive, civ_position, playtime FROM players WHERE playerid='76561198262726614'

Alles anzeigen

GaNja

Dann wird mir das hier angezeigt

Code

[Err] 1072 - Key column 'pid' doesn't exist in table
[Err] -- --------------------------------------------------------

--
-- Table structure for table `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `uid` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `aliases` text NOT NULL,
  `playerid` varchar(17) NOT NULL,
  `cash` int(100) NOT NULL DEFAULT '0',
  `bankacc` int(100) NOT NULL DEFAULT '0',
  `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NOT NULL DEFAULT '0',
  `mediclevel` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
  `civ_licenses` text NOT NULL,
  `cop_licenses` text NOT NULL,
  `med_licenses` text NOT NULL,
  `civ_gear` text NOT NULL,
  `cop_gear` text NOT NULL,
  `med_gear` text NOT NULL,
  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `arrested` tinyint(1) NOT NULL DEFAULT '0',
  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
  `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
  `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
  `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
  `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `pid` (`pid`),
  KEY `name` (`name`),
  KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Alles anzeigen

GaNja

Woran könnte es noch liegen?

GaNja

nope hab in der nichts geändert

ich schicke es mal rein

SQL

CREATE TABLE IF NOT EXISTS `players` (
  `uid` int(6) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `aliases` text NOT NULL,
  `pid` varchar(17) NOT NULL,
  `cash` int(100) NOT NULL DEFAULT '0',
  `bankacc` int(100) NOT NULL DEFAULT '0',
  `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NOT NULL DEFAULT '0',
  `mediclevel` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
  `civ_licenses` text NOT NULL,
  `cop_licenses` text NOT NULL,
  `med_licenses` text NOT NULL,
  `civ_gear` text NOT NULL,
  `cop_gear` text NOT NULL,
  `med_gear` text NOT NULL,
  `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
  `arrested` tinyint(1) NOT NULL DEFAULT '0',
  `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `donorlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
  `blacklist` tinyint(1) NOT NULL DEFAULT '0',
  `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
  `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
  `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
  `insert_time` timestamp DEFAULT CURRENT_TIMESTAMP,
  `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `pid` (`pid`),
  KEY `name` (`name`),
  KEY `blacklist` (`blacklist`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 AUTO_INCREMENT=12 ;

Alles anzeigen

Beiträge von GaNja

Schwierigkeits Attribute anpassen

Erneutes neues Nachrichtensystem mit Emojis

Erneutes neues Nachrichtensystem mit Emojis

Duper stoppen nur wie?

Duper stoppen nur wie?

Duper stoppen nur wie?

Spawnpunkt höhe anpassen

Spawnpunkt höhe anpassen

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3

Datenbank Fehler ExtDB3