skigoggles

Members
  • Content count

    32
  • Joined

  • Last visited

About skigoggles

  • Rank
    Woodland Warrior
  1. that error doesn't mean anything, so you have something else wrong. Here's a guide - https://helpthedeadreturn.wordpress.com/2015/12/01/how-to-create-your-own-dayzmod-vanilla-server/ PM me if you are still having issues.
  2. errors. Check the server and player RPT.
  3. survival servers too. there are not many pre-made servers. Stay away from vilayer, if they still do it (IMO). Be careful with the hosts that say they can do vanilla, but really give you an epoch Db. I've helped a few admins try and figure out wtf was wrong and it was the difference in Db. Easier to install the Db yourself. If you are looking for a vanilla based server (not epoch), I have an guide todo the install on windows. go here: https://helpthedeadreturn.wordpress.com/2015/12/01/how-to-create-your-own-dayzmod-vanilla-server/
  4. All of the SQL files just need to be run. Is there anything in the RPT file or console that shows the ID? In my case the ID was NULL or ERROR or a number that I knew was not a STEADMID(I think they start with 76....). It started after the recent arma2oa.exe patch release. The solution was to run arma2 and possibly steam on the client as ADMIN. There was a recent post on reddit which discussed this too.
  5. AND for those out there who want to hear more of my woes AND who are database people.... At one point I thought this was an issue with the character_data, player_data, player_login tables. so for each of the 3 I did a "create table <table_name>_bak as select * from <table_name>" to back them up then deleted everything from them. When that didn't work I restored them by deleting the <table_name> and renaming the _bak. Can anyone guess what I did wrong? The game runs, but there is some weirdness - you spawn with no inventory. You spawn randomly, no select. When you die, you spawn new. I looked in the database and saw that the character_id of the character_data table was 0 (zero) for both people playing. The lasst_udpated clumn was null. Ugh, it took me a few minutes to figure it out. The create table as select only pulls the data (of course), so I lost all of the auto-update, auto-increment columns and the constraints, etc. I rebuilt them from the original SQL and it was all good.
  6. drum roll please..... After all of that BS, the solution was to find arma2oa.exe, goto the properties, compatability and check "run as administrator". All fixed.
  7. i'm still messing around with this. I was using a .BAT file to connect to the local test server [arma2oa.exe...-mod -port ...blah blah ] - it WAS working fine until the update. Things I tried - removing/reinstalling battleye on client + server. verifying/resintalling on client/server. Removing all data from character_data, player_data, player_login tables. I also removed a bunch of customizations. Also tried launching dayzmod and/or arma2oa then going multiplayer/LAN then trying to get in. Always "session lost". I also turned off battleye. What I saw by various trial and error methods is that the STEAM_ID was not getting set for whatever reason. If I tried to connect, then got the error, then canceled I could get to the profile menu and they did not have an ID. My local server files were out of date. The newer server files take a single port parameter for queryport and then steamqueryport is +1. The one I had took it from the server.cfg. Still thinking it was my server, I tried a .BAT I had for my public server - "The Dead Walk". Same "session lost" error. I finally got connected to my server, but it's still not ideal. instead of calling arma2oa.exe in the .BAT , I switched it to steam://rungameid/33930 . Not ideal since it takes you to the menu and you have to pick multiplayer/LAN and then my server, but it worked! So its the eternal launching problem - arma2oa.exe for whatever reason is not connecting to STEAM and passing the STEAM_ID but the rest of the parms seem to pass. I'm getting close. Honestly, I'm more worried about having to updated the public server with vilayer...
  8. Here's the link https://forums.bistudio.com/topic/186695-a2a2oa-patch-18122015/page-10 which is the update on the original patch thread. Here's the link on steam : http://steamcommunity.com/games/arma2oa/announcements/detail/45398879829365939 Some datapoints: Changelog: - AS50 sound reverted to original - DMR zeroing removed due to community requests - Burst lengths decreased for aircraft cannons - Lee Enfield zeroing reverted to original state - NVG is now usable with western scopes again - Helicopter side gunners firing angles reverted to original - All An-2 variants are now retexturable through hidden selections - GMG and AGS-30 zeroings fixed, no longer include unusable values - "No Owner" RPT messages should no longer appear - All patches are merged into single addon I've heard that the heli guns are fixed and the DMR is back to normal. lol my test server is broken, I think due to this update, but who can tell. Glad the public one is still running ok.
  9. You are right - https://github.com/DayZMod/DayZ/issues/601 - pCleanupOOB() not parsing worldspace correctly #601 I'll find you on the discord when I get a chance. thanks.
  10. Has anyone else really stepped through this code? A while ago I did and made a note that it always got an error and wasn't working. I know on the server I run there were items in the debug that were not getting deleted. I went back to it recently and started debugging/logging what it was doing. The splitting of the worldspace column is one of those crazy lines of code, IMO: SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), ',', '') INTO @West;SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 3), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3 -1)) + 1), ',', '') INTO @North; but when I researched it, it's basically the same as found here: http://stackoverflow.com/questions/11835155/mysql-split-comma-separated-string-into-temp-tableWhen I run through each step on paper it seems to be correct. Finally, after debugging for a while I'm seeing that the @West value is generally not being set correctly so I created a log file and added this to pCleanupOOB() - just decomposed pieces of the code above. The bold/italic/underline text are the values from my log file: insert into aalog values (@rsObjectUID, 130279766221295@rsWorldspace, 60,13027.9,7662.17,-0.01SUBSTRING_INDEX(@rsWorldspace, ',', 2), 60,13027.9SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1), 60LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1, 3SUBSTRING_INDEX(@rsWorldspace, ',', 2), 60,13027.9SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), ,13027.9@West, 13027@North, 7662.17@Height); -0.01 Like I said it looked good on paper, but when its decomposing the worlspace, the @West variable string thats extracted includes the leading comma, so the number doesn't always get converted properly. The solution seems to be : from this>> LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1to this:>> LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 2 now, I was a software developer for years, so I like it when a good "+1" just fixes it, but I'd like to hear from someone else that's noticed this. Has anyone else seen this code cleanup OOB items? If you'd like to see for yourself, here's some the code. You'll see I added @Height to pickup the Z value since I wanted to look for helis left on buildings. Also, I have 2 inserts into the log file - the first with the original values and the second with the +1.CREATE TABLE `aalog` ( `id` BIGINT(20) NOT NULL, `ws` VARCHAR(50) NULL DEFAULT NULL, `str1` VARCHAR(50) NULL DEFAULT NULL, `str2` VARCHAR(50) NULL DEFAULT NULL, `int1` INT(11) NULL DEFAULT NULL, `str3` VARCHAR(50) NULL DEFAULT NULL, `str4` VARCHAR(50) NULL DEFAULT NULL, `x` FLOAT NULL DEFAULT NULL, `y` FLOAT NULL DEFAULT NULL, `z` FLOAT NULL DEFAULT NULL)COLLATE='latin1_swedish_ci'ENGINE=InnoDB; CREATE DEFINER=`dayz`@`%` PROCEDURE `pCleanupOOB`() LANGUAGE SQL NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT ''BEGIN DECLARE intLineCount INT DEFAULT 0; DECLARE intDummyCount INT DEFAULT 0; DECLARE intDoLine INT DEFAULT 0; DECLARE intWest INT DEFAULT 0; DECLARE intNorth INT DEFAULT 0; DECLARE dblWest FLOAT DEFAULT 0; DECLARE dblNorth FLOAT DEFAULT 0; DECLARE dblHeight FLOAT DEFAULT 0; SELECT COUNT(*) INTO intLineCount FROM Object_DATA; SELECT COUNT(*) INTO intDummyCount FROM Object_DATA WHERE Classname = 'dummy'; WHILE (intLineCount > intDummyCount) DO SET intDoLine = intLineCount - 1; SELECT ObjectUID, Worldspace INTO @rsObjectUID, @rsWorldspace FROM Object_DATA LIMIT intDoLine, 1; SELECT REPLACE(@rsWorldspace, '[', '') INTO @rsWorldspace; SELECT REPLACE(@rsWorldspace, ']', '') INTO @rsWorldspace; SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), ',', '') INTO @West; SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 3), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3 -1)) + 1), ',', '') INTO @North; SELECT REPLACE(SUBSTRING(@rsWorldspace, LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3))+1 ) , ',', '') INTO @Height; SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 2), ',', '') INTO dblWest; SELECT REPLACE(SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 3), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3 -1)) + 2), ',', '') INTO dblNorth; SELECT REPLACE(SUBSTRING(@rsWorldspace, LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 3))+1 ) , ',', '') INTO dblHeight; SELECT INSTR(@West, '-') INTO intWest; SELECT INSTR(@North, '-') INTO intNorth; insert into aalog values (@rsObjectUID, @rsWorldspace, SUBSTRING_INDEX(@rsWorldspace, ',', 2), SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1, SUBSTRING_INDEX(@rsWorldspace, ',', 2), SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 1), @West, @North, @Height); insert into aalog values (@rsObjectUID, @rsWorldspace, SUBSTRING_INDEX(@rsWorldspace, ',', 2), SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 2, SUBSTRING_INDEX(@rsWorldspace, ',', 2), SUBSTRING(SUBSTRING_INDEX(@rsWorldspace, ',', 2), LENGTH(SUBSTRING_INDEX(@rsWorldspace, ',', 2 -1)) + 2), dblWest, dblNorth, dblHeight); IF (intNorth = 0) THEN SELECT CONVERT(@North, DECIMAL(16,8)) INTO intNorth; END IF; IF (intWest > 0 OR intNorth > 15360) THEN DELETE FROM Object_DATA WHERE ObjectUID = @rsObjectUID; END IF; SET intLineCount = intLineCount - 1; END WHILE;END
  11. Do you mean the classname? It's "MH6J_DZ"
  12. No, still busted. BTW, vinyl, I'm helpthedead walk on reddit - I was going to ping you over there about this.... Anyway, I assume you meant "C:\Program Files (x86)\Steam\steamapps\common\Arma 2" and not "C:\Program Files (x86)\Steam\steamapps\common\Arma 2 Operation Arrowhead", right?? AND you meant running the client or server? (I tried it on both). I did figure out that if I use "-port=8766" then the gameport does change and the steamqueryport is +1. Strange thing is that the 2 ports were defined in the server.cfg previously and those were the ones I opened in the router and it was all good until this week after the OA patch. This is how I was launching the server for the last 6 months: start arma2oaserver.exe -mod=Expansion;ca;@hive;@dayz -name=cfgdayz -config=cfgdayz\server.cfg -cfg=cfgdayz\basic.cfg -profiles=cfgdayz At one point I think I had originally used : start arma2oaserver.exe -mod=Expansion\beta;Expansion\beta\expansion;ca;@hive;@dayz -name=cfgdayz -config=cfgdayz\server.cfg -cfg=cfgdayz\basic.cfg -profiles=cfgdayz but then I played around with it to see what would work. This test server goes back to a pwnzer-based server that I created when I took over The Dead Walk. I could rebuild it from scratch I suppose, but I'm not sure where to begin to make it the "right/clean/better way"? I thought I saw a post by razor someplace. I'm open to suggestions since I see 1.8.7 coming after the holidays....
  13. lol. I know - I was a software developer for a long time. fyi: so far we're seeing weapons scopes/zeroing issues, heli gun movement limitations and medbox0 cannot hold any items. sigh.
  14. I guess everyone has seen that arma2OA patched the other day : https://forums.bistudio.com/topic/186695-a2a2oa-patch-18122015/ My test server is no longer working, but my hosted one is ok - go figure. I updated Arma2 and Arma2OA and recopied all of those files to the server directory. I suspect something with STEAM. In the logs below, I don't ever recall it listing the "Game Port" and "Steam Query Port" before. Also, my server.cfg has them set to 8766 & 27016. So it seems like the config isn't being respected. Also, that ID in the RPT file is usually a GUID and that number is not one. I've had other people try and connect and they get similar bad numbers too. the net of it all is that I try ad connect and get "Session Lost" and disconnect. CONSOLE12:01:06 Dedicated host created.12:01:07 BattlEye Server: Initialized (v1.207)12:01:07 Host identity created.12:01:08 Game Port: 2302, Steam Query Port: 230312:02:23 BattlEye Server: Player #0 Ski Goggles (xxx.xxx.x.xx:2304) connected12:02:23 Player Ski Goggles connecting.12:02:23 Mission DayZMod read from directory.12:02:25 Player Ski Goggles connected (id=ERROR).12:02:25 Player Ski Goggles disconnected.12:02:25 BattlEye Server: Player #0 Ski Goggles disconnected12:02:25 All users disconnected, waiting for users. arma2oaserver.RPT12:01:08 Initializing Steam server - Game Port: 2302, Steam Query Port: 230312:01:10 Connected to Steam servers12:02:25 Server error: Player without identity Ski Goggles (id 814250231)
  15. Recently had some players say that MedBoxes are disappearing when they get near to them. Has anyone heard about this? Could this be related to the Bohemai A2/A2:OA Patch 18.12.2015?? : https://forums.bistudio.com/topic/186695-a2a2oa-patch-18122015/ I've certainly noticed the issue with weapons and scoping/zeroing....