Rebellion

Noticed this in my extDb logs: [12:21:51:920039 +01:00] [Thread 4516] extDB2: Database Type: MySQL [12:21:51:921538 +01:00] [Thread 4516] extDB2: Database Session Pool Started [12:21:51:923996 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Loading Template Filename: D:\Servers\ArmaExile2\@exileserver\extDB\sql_custom_v2\exile.ini [12:21:51:924179 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Version 12 Detected, Latest Version 12 Available [12:21:52:011797 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: UPDATE vehicle SET deleted_at = NOW() WHERE last_updated_at < DATE_SUB(NOW(), INTERVAL ? DAY) AND territory_id IS NULL [12:21:52:011841 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [12:21:52:011855 +01:00] [Thread 496] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: markDeleteOldVehicles:3 [12:21:52:017689 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: DELETE FROM vehicle WHERE territory_id IS NULL AND deleted_at < DATE_SUB(NOW(), INTERVAL ? DAY) [12:21:52:017725 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [12:21:52:017739 +01:00] [Thread 7896] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: deleteOldVehicles:3 [12:21:52:433635 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Error StatementException: MySQL: [MySQL]: [Comment]: mysql_stmt_prepare error [mysql_stmt_error]: Unknown column 'territory_id' in 'where clause' [mysql_stmt_errno]: 1054 [mysql_stmt_sqlstate]: 42S22 [statemnt]: SELECT id FROM vehicle WHERE deleted_at IS NULL AND territory_id IS NULL LIMIT ?,? [12:21:52:433672 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Wiping Statements + Session [12:21:52:433687 +01:00] [Thread 4516] extDB2: SQL_CUSTOM_V2: Error: UniqueID: 1 Input String: loadVehicleIdPage:0:100

Since the last Arma 3 update (Update to Game Version:1.76.142872), I've been getting the following error on my server: 12:03:27 "ExileServer - Database Error: Error Statement Exception" 12:03:27 Error in expression <umberOfVehicles - 1 do { ((_vehicleIDs select _i)select 0) call ExileServer_obj> 12:03:27 Error position: <select _i)select 0) call ExileServer_obj> 12:03:27 Error Generic error in expression 12:03:27 File exile_server\code\ExileServer_world_loadAllDatabaseVehicles.sqf, line 25 Would anyone know the reason for this, or maybe able to point me to the solution. This error was not occuring before this latest update. Cheers. *EDIT* Noticed the 1.0.3e update to include support for malden. Hopefully that will sort out the territory_id error I'm getting in my db.

Have been getting an error with the following tried numerous different ways to set this in my setVariable but still getting a BE kick #0 anyone got any ideas? This occurs when attempting to load crate into back of vehicle. 29.06.2017 09:06:37: Rebellion (xxxxxxxxxxx) 7xxxxxxxxxxx - Value Restriction #0 "r3f_log_est_deplace_par" = R Rebel Gamers:1 (Rebellion) REMOTE 2:2121 CargoNet_01_box_F Ive tried both !"r3f_log_est_deplace_par" and !="r3f_log_est_deplace_par" in setVariable.txt

Does anyone know the correct entry for the following restriction #0 in remotexec: - #0 "14.06.2017 07:45:13: Rebellion (192.168.0.2:2344) 74eb6cf5895f89932947ea8625cd5fa3 - #0 "admintoolkit_network_receiverequest [R Rebel Gamers:1 (Blah) REMOTE,"login",""]" Ive tried !="admintoolkit_network_receiverequest" and also tried !="login"

Im assuming the line "ExileServer_object_construction_database_load = "EBM\exileServer_object_construction_database_load.sqf"; //Original fix by Eichi" is no longer needed in the CfgExileCustomCode section of config.cpp anymore as it was to do with the door fix in 1.02? As im getting a warning in my rpt "Script EBM\exileServer_object_construction_database_load.sqf not found"

Just a quick thought. I may have to edit this post and expand upon it to convey what Im suggesting. Lets go to a random suggestion in the OP's list. Regarding vehicles, well more over the repair and maintenance of them. Yes we all agree it needs to be overhauled and a more comprehensive system of maintenance/repair put in place. I believe it was suggested different components needing to be obtained in order for a repair to be carried out (in conjunction with the trusty old foolbox plus a wrench/spanner/screwdriver etc depending on what is being repaired) and the bulk item ie engine block/brakelines/transmission etc need to be found by looting areas. What if the vehicle wrecks that we see strewn around the map were made to be "lootable" that could potentially harvest various items (a random list with a random percentage of success to give it a level of variance) but requiring tools in order to break down the components from the wreck. each attempt at breaking a vehicle down would have a percentage of success or failure with the resulting loot being random with varying percentages of damage (ie if an item that you harvest from a wrecked vehicle is quite damaged that said item would THEN need further repair made to it to get it working before it can be used to repair/maintainan existing vehicle) items such as the engine block/brakelines/transmission/metal scrap could be the resulting loot that is harvested from the wreck. Again you could make it so that only certain parts from certain wrecks are compatible with the vehicle you are repairing. Sobasically im suggesting we dont just make it a "one tier" system to repair a vehicle...lets make it so that there maybe another tier in the process in order to get a salvageable part for your vehicle ie harvested components may also need to be repaired prior to using them to repair your trusty old strider!

Yeah I think thats gonna have to be what Ill need to do. Though I believe it returns the time that is set on the server, particularly if the server is set to real time in config rather than static.

Just a quick query...does anyone know the format that the global command "serverTime" uses in Arma? Does it take a format of HH:MM:SS or 24 Hr style eg 1900 or 1236. I just need the format in order for something I'm trying to attempt on a server.

I believe where you say serverTime returns the time since the server was started is done by "Time" (https://community.bistudio.com/wiki/time). If you check BIS Wiki: Time since server started whereas serverTime returns the actual time of the server. I dont want to set any time or date or anything like that as i know i can do that from exile_server_config. Im creating a script that is dependant on having the actual server time returned as a value, which is why I want to know the format this particular command returns it in. I had already read the wiki which you quote the explanation in your reply. I dont need to format it or even display it in any particular way. What I actually want to do is use it as a means to sync an event to certain pre-defined times on my server hence why i need to know how the "output" it creates is returned so I know how to format the script to match it to the correct format.

Hey was wondering IF you still have this tool...would you mind if you could send me a copy of the entire webfiles as I wouldnt mind hosting this from my site...that way it stays online for the benefit of others to use.

Not sure if you have solved this issue or not yet...but i noticed what you have done if you look at the mod folders in your A3 directory it looks like you have @CUP Weapons @CUP Vehicles etc (ie a space between CUP and weapons/vehicles) whereas your mod line has an underscore rename the mod directories in your A3 directory to match the names on your command line and see if that does the trick.

Does it have the function to fetch the keys from each mod folder that is downloaded and drop them into the keys folder in A3. If not maybe adding this as a future possible addition would be great...that way i can run this from a batch tool once a week or whatever so that I dont have to keep downloading the updates and manually updating keys on a regular basis. Just a simple "click and go" all in one easy step or have it set to an auto start-up on a weekly basis.

Seems a bit strange to reply to a thread thats been dorment for some time but thought it necessary. For a good while I've been wondering WHY players were connecting then almost after connecting to my server why they were disconnecting. Think I finally worked out why now, now that i came across this post. In the last week even one of my friends has been getting kicks for what seemed to be "Wrong signature file" checks against PBO's in his A3\Addons folder and sometimes even against PBO's in some of the mods enabled on the server (note: current mod versions). I assisted in trying to find out what was causing this and went through numerous fault finding tests to see what the cause was such as verifying game files in steam...deleting the corresponding PBO and Bisign file in his a3\addons folder THEN verifying files so that those files were redownloaded with a definite valid file. Nothing worked. Until now, or at least what I am going to assume, I noticed the security setting regarding "OnDifferentData" >> mine was set to kick. I can only but assume that this was the reason why kicks were occurring even though there was no unvalid reason it was happening. Now ive set that line to "" instead "kick" hopefully all should be good. Glad I came across this post!

Ahhh ok thanks...I always like to question things such as this...not in an ignorant way...but more in a way to find out "why" different people do things in different ways. personally, if i knew enough about making addons etc like this I would have done this as a server side PBO and dropped it into the exile server/addons folder...but only because it would come across as being more efficient, maybe tidier, and less cpu hungry or at least how I would imagine it to be. *EDIT* But i will say this addon does looks clean and pleasing to the eye...think Ill give it a go on my server as i host a box from home

Im just wondering...why is this toolkit in mod form? Would it not have been easier (and perhaps more secure) to have done it with server side PBO's placed inside the exileserver/addons folder and client side files placed in mission file folder and have them detected automatically when the server starts up. having -mod and -servermod parameters seems a bit out of the way. This is the only admin toolkit ive seen done this way. Any particular reason why?

Sweet got it working. Just gotta sort a couple of SetVariable restrictions and I'm good to go!

Cheers!

If no init.sqf file is in the mission file....where would I place this file? Would it be good in the config.cpp file or shall I just create an empty init.sqf file and put the line in there?

And now it seems I've resolved my issue regarding my extDB issue with the call extension not loading. I just compared my arma server Altis and Tanoa root folders and it seemed I had overlooked a few files that I did not have in my Altis root folder. Copied from one to the other and now that issue seems to have disappeared. Fingers crossed my Altis server should now be working.

Not quite sure where to begin here. Having a few problems with an exile server that, at one point was working (Prior to update regarding x64 version of Arma 3). Updated server files today with updated versions of armaserver etc (32 bit and 64 bit) but have hit a few glitches getting it running again. A couple of problems seem to be occuring. Firstly the dreaded Call extension with extDB2 not loading - checked it over with a fine tooth pick - and this should not be happening as do have vcredist installed correctly (x86 and x64). Made sure I am running 32 bit armaserver (ie armaserver.exe instead of armaserver_x64.exe). Secondly I have noticed that when joining server the loading screen shows Tanoa as loading (as indicated by the Tanoa picture on top right and displaying "Tanoa" beneath it) when it should be Altis that should be loading. With this I checked that my config was showing as "Exile.Altis" (Check! It is!) and obviously the ONLY map template I have in my mpmissions folder is "Exile.Altis(.PBO)". Now usually I would supply all relevant information from logs etc if I have a problem, but this has got me so damn stumped im not sure where to start. What I will do though is anyone having a think over this - just request any relevant information/logs/etc and ill post as replies. Think that might be the best course to take as I dont want to overfill with anything irrelevant. If I cant find a solution before long I may have to start over from scratch and see if I can find a result doing things that way - though of course, I would very much rather not take that route.

OK, Z80, thats the pic issue pointed out to me...so that shouldnt be a problem. Cheers for letting me know that, was just wondering as I had seen other posts regarding that issue but looks like its not a game breaker issue.

Try reverting to the 32 Bit version of the arma server (ie ArmaServer NOT ArmaServer_x64) Im not sure if they have updated extDB2 to allow for the 64 bit version of the server yet.

Im getting this error, I did as you mention here but still get the error after adding the two files. Anyone know of any other solution to this? *EDIT* Hold that thought! I just added this post and looks like someone put a post regarding the error still occurring (check 2 or 3 posts before this) and mention deleting the additional line from $PREFIX$. Gonna try this and see if it works. *EDIT 2* yer it works now. Anyone getting the end of line error still after adding the $PBOPREFIX$ and PboPrefix.TXT files should check that there is only one line in all 3 files and overwrite if so.

Id have thought adding an additional row to the accounts table calling the new row "whitelisted" and setting a numerical value of either 0 or 1 ie non-whitelisted/whitelisted would have been a far earier method and slightly more efficient.

I was looking for something similar to this...BUT....Nah Im not gonna register details regarding database user/password. Im sorry but like has already been mentioned, you say "Why would I want to do that...accessing databases when they are encrypted"...well it wouldnt take much for you to decrypt them and have access to numerous databases elsewhere, and also having no rep and charging for it on a cloud based hosting solution. Nope! Not for me unless it was to be released where users such as myself and others could host it on a server ourselves, i dont think youll get much interest in this and even less interest if its gonna be a chargeable solution. There are many solutions out there that look really useful and aesthetically pleasing as yours. Albeit this post is mainly a criticism I will compliment on the design and lookout and the feature set of your script. It looks very tempting, but I wont give in to that temptation as the risk is not worth while. With the likes of others on this site who have built up a good rep over the years I know where I would prefer to put my money if i was to pay for something.