Jump to content

Search the Community

Showing results for tags 'mysql'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • General
    • Announcements
  • DayZ
    • Discussion
    • Public Servers
    • DayZ SA Resources
    • Q&A Section
  • ArmA 3
    • Epoch Survival
    • Community Projects
    • Q&A Section
    • Terrain Discussion
    • Resources
  • Arma 3 Resources
  • ArmA 2
    • General Discussion.
    • Q&A Section
    • Resources
    • Legacy Resources
    • A2: Community Projects
    • A2 Community Servers
  • Space Engineers
    • General Discussion.
    • Public Servers
  • Other Games
    • Discussion
  • Off Topic
    • Off Topic

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 21 results

  1. I have been finding that some people on my server has been losing base walls and floors even though DZE_godmodebase = true; , it has no effect on anything built inside the plot radius. So i have come to the conclusion that base items might receive damage on age and this ultimately being removed by server cleanup script. So my question is if I drop this event below will that stop me and others from losing base walls and floor? Or at the minimum update it without any cinder wall items? like this and set damage to 0.001:
  2. ***PLEASE HELP*** 2017-12-13 16:25:01 HiveExt: [Information] HiveExt 2017-12-13 16:25:01 HiveExt: [Critical] Cannot create database: Error loading database module: DatabaseMySql Ive tried changing the password to the database and user in the Hiveext.cfg For some reason whenever i join the server its all fine, but as soon as i log in as it says 'game started', it proceeds with the error 2017-12-13 16:25:01 HiveExt: [Information] HiveExt 2017-12-13 16:25:01 HiveExt: [Critical] Cannot create database: Error loading database module: DatabaseMySql then the server closes itself. I have no idea now how to fix this issue as no one else has posted about it from what ive seen and i could really do with any help if anyone knows how to fix this error, im probably just being stupid. Thanks
  3. I have setup many Epoch servers over the past 4 years. All of which were built on old PC's I have. Players have no problem getting into game. In the past month I built a Dedicated Server Xeon, Server board, Server memory, etc Installed Windows 2016 essentials on it. Set up a game server, one that has dinosaurs in it. It works! Have the same Taviana Epoch server working on a nomal PC, Players can join! Now on with my problem Installed MySQL for Windows Installed all files for the Taviana Epoch Server Created a data base called tavi_2365 Have port forwarded the port of 2365 Setup new rules for inbound and outbound 2365 in the firewall When I start the server all goes as planned Server starts up Can see the server from my computer When I try to join, I get the lobby and click ok The loading screen comes up and the first white bar runs as normal The second white bar starts and says waiting for server to start authentication Then times out at 120 seconds On my second monitor I am watching the server load It gets to game started and it just sets there Database never starts, get the following error in server RPT 2:09:23 "HIVE: Starting" 2:09:24 Error in expression <erver_hiveReadWrite; _outcome = _result select 0; if (_outcome == "PASS") then {> 2:09:24 Error position: <select 0; if (_outcome == "PASS") then {> 2:09:24 Error select: Type String, expected Array,Config entry 2:09:24 File z\addons\dayz_server\system\server_monitor.sqf, line 23 Below are my Server RPT, Client RPT, HiveExt.ini, and server_monitor.sqf server RPT https://pastebin.com/6M9sG9RB client RPT https://pastebin.com/9ayVMXjF hiveext.ini https://pastebin.com/3wx9VDM9 server_monitor.sqf https://pastebin.com/fUnU09Gp UPDATE PROBLEM SOLVED Had to install all of the Visual C++ from 08 to 17 they were a little hard to find, but I did it. Thanks to all that helped me. @juandayz @icomrade and more below is a pic of what I had to install to get it to work https://dl.dropboxusercontent.com/u/487376647/MS Visual C.PNG Here is a link to my drop box for a .rar and a .zip for all the MS Visual C++ that I used to get my dedicated server working. https://dl.dropboxusercontent.com/u/487376647/All Microsoft Visual C%2B%2B Redistributables.rar https://dl.dropboxusercontent.com/u/487376647/All Microsoft Visual C%2B%2B Redistributables.zip
  4. I've noticed dayz epoch arma 2 mod uses hives to connect to mysql databases I want to create a custom table in the MySQL database, will i be able to use the custom table if i create a new hive.. or is there another way? or is it even possible to create a custom hive?
  5. Notsapl

    Get data from DB

    Hi, can u help me ? I have some problem with get any data from db , this is my example code : _key = format["CHILD:999:select `value` from `notsa_addon_data` where `addon` = 'communication' and `key`='last_id' LIMIT 1:[]:"]; //_data = "HiveEXT" callExtension _key; //_result = call compile _data; _result = _key call server_hiveReadWrite; _status = _result select 0; // get the status of the result if (_status == "CustomStreamStart") then { //check if the stream coming from the hive was opened _val = _result select 1; // get the number of entries that will be coming in the stream if(_val > 0) then { _result = _key call server_hiveReadWrite; _bankingstart = _result select 0; }; }; _notsacommunication_last_id = _bankingstart; diag_log("[NotsaAddon Communication] Load last key : "+str(_notsacommunication_last_id) ); _key = format["CHILD:999:select `message`,`author`,`id` from `notsa_communication_msg` where `id` > %1 LIMIT 1:[]:",_notsacommunication_last_id]; _result = _key call server_hiveReadWrite; Why second query is : " select `message`,`author`,`id` from `notsa_communication_msg` where `id` > " when in log i can read: [Information] Result : ["CustomStreamStart",1] [Information] Result : [5] <-- Here is true data from db : last_id = 5 Why in second query variable _notsacommunication_last_id is empty ? Thanks for any help ! :)
  6. MySQL DB backup v1.1. Note: This script is included in the DayZEpoch 1.0.6 distribution (when released). What is it. This is a Windows batch file (.bat) which will backup your MYSql database(s) for you. If you add it to Windows scheduler it can also run automatically at a frequency you define (every 15 minutes for example). Features. - Backup tables, triggers and events. - Housekeeps old backups after user defined number of days. - Resulting .sql files can be loaded in to a SQL client and run against a MYSQL database to recreate the structure and data from the backed up database. - Server DateTime format independant (works for MM/DD/YYYY or DD/MM/YYYY date formats). - Can be scheduled with Windows scheduler. How to use it. Create a .bat file (call it something like DB_Backup.bat) and paste the following in to it. @REM *** PARAMETERS/VARIABLES *** SET BackupDir="[Where you want to save the backups]" SET mysqldir="C:\Program Files\MySQL\MySQL Server 5.6\bin" SET mysqlschema=[Your DB schema name] SET mysqlpassword=[your DB password] SET mysqluser=[your DB user login] SET housekeepafter=5 for /F "usebackq tokens=1,2 delims==" %%i in (`wmic os get LocalDateTime /VALUE 2^>NUL`) do if '.%%i.'=='.LocalDateTime.' SET ldt=%%j set datestamp=%ldt:~0,4%-%ldt:~4,2%-%ldt:~6,2%.%ldt:~8,2%-%ldt:~10,2%-%ldt:~12,2% @REM *** EXECUTION ***@REM Change to mysqldir c: cd %mysqldir% @REM dump/backup ALL database, this is all in one line mysqldump -u %mysqluser% -p%mysqlpassword% --databases %mysqlschema% --routines --events --triggers --quick >%BackupDir%\%mysqlschema%_backup.%datestamp%.sql @REM - Housekeeping forfiles -p %BackupDir% -s -m *.sql -d -%housekeepafter% -c "cmd /c del @path" Configuration Input your DB connection details and desired backup save location. All details that need changing are in []. Make the changes without the []. e.g. SET mysqlschema=[Your DB schema name] may change to SET mysqlschema=EpochDB SET BackupDir="[Where you want to save the backups]" May change to SET BackupDir="c:\DB-Backups" Housekeeping will clear any .sql files that are over housekeepafter number of days old. You may need to confirm the MySQL path for the mysqldump exe as it may depend on your provider. Add "read" (without "") at the end of the file to require an input for debugging. This allows you to check the test backup is ok and troubleshoot any issues. Remove it when automating or the .bat file will never close. Automation can be done via Windows task scheduler. Create a basic task and then edit the tasks parameters after creating if you want to backup more than once a day. The option is only available after the task is created. Revision History. Current version: v1.1 Changes: - Amended code to cope with US & UK date formats when calculating the resulting .sql files datetimestamp included in the filename. Previous versions: v1.0: Initial version. Possible future improvements. I may add an option to compress (zip) the files if there is enough interest.
  7. Config: GitHub: Database Entries ;) I've made some entries for my custom traders for the new overpoch weapons/ammo. Your trader TID will be different than mine so you will have to change that. I've separated them into each class. *note some may be in the wrong section, forgive me, i'm not a gun nut... :rolleyes: Feel free to adjust the prices etc. I'm using navicat so It may be different using other methods. But to add, create a new query and simply paste the below entries. *note your "traders_data" may be different, change to suit your database. *If you find any mistakes or feel that something needs to be more balanced price wise please comment and ill update, Thanks ;) AK Variants: G3 Variants: Sidearms: Masada ACR SCAR Rifles: HK416's HK417's LMG's Snipers: ACR snow camo: ACR black camo:
  8. If I were to set up multiple dedicated servers what would I set the hivext.ini port to if I am only using one mysql service? Would I leave it the same as my other server (3306) or would I need to run another mysql service with a different port? I have read to just create another database for the second/third/fourth server and edit the hivext and config... I am confused as to how this would work only running one mysql service. Any help is appreciated!
  9. Anyone have something for this? Trying to get 15-30 minutes backups My Backup.bat - http://pastebin.com/KWCn4aPH
  10. I'm suffering from database rollbacks with 20-25+ players. Is there any obvious reason why its doing this from looking at my sql settings? With a dedicated server are you renting a mysql server or are you hosting it yourself alongside an epoch server? Here is my, my.ini: Any feedback would be amazing!
  11. Hi I am not sure this is the right forum, but I give it a go :) I been googling to try and find an SQL to delete cars what has not key in the game anymore, but I am coming up a bit short. I found this: https://github.com/vbawol/DayZ-Epoch/issues/1007 Tried to do this: SELECT object_data.ObjectID, object_data.ObjectUID, object_data.Worldspace, object_data.Classname, object_data.CharacterID, object_data.LastUpdated, (CASE WHEN object_data.CharacterID < 2501 THEN CONCAT('ItemKeyGreen', object_data.CharacterID) WHEN object_data.CharacterID < 5001 THEN CONCAT('ItemKeyRed', object_data.CharacterID - 2500) WHEN object_data.CharacterID < 7501 THEN CONCAT('ItemKeyBlue', object_data.CharacterID - 5000) WHEN object_data.CharacterID < 10001 THEN CONCAT('ItemKeyYellow', object_data.CharacterID - 7500) WHEN object_data.CharacterID < 12501 THEN CONCAT('ItemKeyBlack', object_data.CharacterID - 10000) ELSE 'ERROR' END) AS `KeyColour`, (SELECT COUNT(*) FROM `character_data` WHERE `Alive` = '1' AND (`Inventory` LIKE CONCAT('%', KeyColour, '%') OR `Backpack` LIKE CONCAT('%', KeyColour, '%'))) AS InChar, (SELECT COUNT(*) FROM `object_data` WHERE `Inventory` LIKE CONCAT('%', KeyColour, '%')) AS InVeh FROM `object_data` WHERE `CharacterID` <> '0' AND `CharacterID` <= 12500 AND `Classname` NOT LIKE 'Land%' AND `Classname` NOT LIKE 'Cinder%' AND `Classname` NOT LIKE 'Wood%' AND `Classname` NOT LIKE 'Metal%' AND `Classname` NOT LIKE '%Storage%' AND `Classname` NOT IN ('OutHouse_DZ', 'GunRack_DZ', 'WorkBench_DZ', 'Sandbag1_DZ', 'FireBarrel_DZ','DesertCamoNet_DZ','StickFence_DZ','LightPole_DZ','DeerStand_DZ','ForestLargeCamoNet_DZ','Plastic_Pole_EP1_DZ','Hedgehog_DZ','FuelPump_DZ', 'Fort_RazorWire', 'SandNest_DZ', 'ForestCamoNet_DZ', 'Fence_corrugated_DZ', 'CanvasHut_DZ', 'Generator_DZ') But I am not 100% friends with MySql yet, so does this tject in players safes too, to see if there is a key ? or only on players and in backpacks? And the results are that the cars with out key’s ? even the once that says 1 in ‘InChar’ or ‘InVeh’ ? Anyone knows? Or know a better way to remove cars where the key is lost ?
  12. Hey :) ok, at first i want to do a Mysql cleanup which delete old objects in the object_data table. i use this script now on my server that tie the playeruid on buildables instead of the characterID. now i want to cleanup objects where the lastLogin is older than 7 days in the character_data table. so the script should look in the character_data table , find the Characters who are older than 7 days, copy the PlayerUID from theese characters go into the object_data table and search for the PlayerUID in the characterID column and delete the complete row. i hope you could understand what i want to do :) would be awesome if someone could help me out :D
  13. Greetings all, I purchased a DayZPackage 40 slot from Vilayer the other day - We had an Epoch server up and running for my clan and whoever wanted to join, but after I tried updating the traders with the Epoch.sql script, my game started giving anyone who tried to join an error of "incorrect server version". A SQL rollback didn't fix the issue either - so at this time I may be having them wipe my server completely and start from scratch. From the server files for 1.0.1.1 - How do I install these right off the bat from a newly setup server? I have access via HeidiSQL and FTP to the server itself and can make changes on the fly to the traders, but I'm not sure how to go about getting all the files in Vilayer's Epoch update to the correct version that's downloaded from this site: http://dayzepoch.com/wiki/index.php/Server_Installation_Instructions Basically, Vilayer's update disabled building and didn't give the traders the ability to sell plot poles or any of the new items - however, new items and backpacks and weapons were spawning from the newest patch. Pretty weird stuff. Can anyone provide me with a bit clearer instructions on what files I need to move to where within the database? If need be, I can PM you my connection details for the server. Sincerely, Javier Santana
  14. Basically I am helping a friend with scripting on his server and that and I am struggling to edit and add extra weapons into the database could someone help me and give me some advice.
  15. I apologize up front if I'm not posting in the right place or if there are already a thread on this issue. I am having an issue where when I or others try to join my current DayZ Epoch server they are able to get into the game lobby but once they try to join they get a black screen where it states they are waiting for server authentication. I personally will eventually get an error: "You cannot play/edit this mission; it is dependent on downloadable content that has been deleted. vilas_pl_cars". Afterwards I click ok and I get just a black screen. If I hit escape it will bring up the game menu and then I am allowed to walk around an empty field. Server side steps taken: -Used Steam to install Arma2 & Arma2OA (Launched both games via steam to get needed .net and ++ installed) -Installed DayZ commander and used to update Arma2 to beta patch 103718 and install Dayz Epoch 1.0.1.5. -Downloaded and installed MYSQL Server 5.5 -Went to Dayz Epoch website and downloaded server files and extracted to the Arma2 OA directory -Created a new DB in MYSQL and used MYSQL Administrator to "restore" the DayZ Epoch SQL file to the dayz_epoch database that was created previously. -Updated Hiveext.ini file to point to new MYSQL DB and update password information -Copied Addon folder from Arma2 directory to Arma2 OA -Created batch script based off of examples -Able to launch dedicated server without errors Thank you in advance for anyone that is able to point me in the right direction.
  16. Host: Vilayer Wanting to clear up unused vehicles (Untouched within 14 days) Tested some queries such as refuel all vehicles and fix all vehicles but nothing worked, even after restart. Please help :/ Used Navicat Lite and HeidiSQL MySQL > Epoch > Queries
  17. Host: Vilayer Wanting to clear up unused vehicles (Untouched within 14 days) Tested some queries such as refuel all vehicles and fix all vehicles but nothing worked, even after restart. Please help :/ Used Navicat Lite and HeidiSQL MySQL > Epoch > Queries
  18. Hi. I am creating php tool for administrate dayz epoch database. I need help with transports. Questions: I need add locked transport to server via database, and put key from that transport to character toolbelt. So: 1) How i can generate key? 2) How i can put generated key to toolbelt? 3) How i can add transport to object_data locked by that key? I am really need answers. Better if it will be with examples. Thank you P.S. Sorry for my bad english.
  19. Hello, so i get an error evrey time i try to start up my DayZ Epoch server wich is : Database(0): [Error] Error 1044 (Access denied for user 'dayz'@'localhost' to database 'dayz_epoch') in connect And i cant seem to find what is coursing this error, please help thanks :) Ps sorry for my bad english.
  20. So I'm in the process of trying to create an event that deletes items built by users that have not logged on in over 30 days. This should be fairly easy if not for two things, MySql has problems doing a table update from a sub query select from statement, and 2nd, the 1st would not be a problem if placed items were tied to the CharacterUID and not the CharacterID (which changes on character death). I understand the reasoning back when everyone was running vanilla DayZ, when you die, in theory, you're a new person and can't pack up your previous life's tent, got it. However this no longer really applies to Epoch. If Epoch followed that same logic, upon death a players combo locks and safe combos should change so that a "new" character would have no prior knowledge of what those combos were. Obviously this defeats the purpose of having combo locks and safes, if they were one life use, no one would use them. So with that logic in mind, what would it take to change the database tables to base the items built keyed to the CharacterUID instead of the CharacterID? I'll go ahead and post the script I was working on, maybe someone smarter than me with MySQL and can make it work without altering the DB tables, if so I'd love to see it. This script does take into account the fact that the CharacterID of a user changes upon death. What it does not take into account, and cannot take into account is that if a user builds a base with another user. If user 1 does not login for X number of days, the items would be deleted, leaving user 2 with a funky looking base. In this case it would be user 2's responsibility to notify an admin that user 1 hasn't been on in a while and would like to take ownership of built items (not vehicle/safe items) before the X DELETE day mark. There's no way around that with a script currently. Anyway: DELETE FROM object_data WHERE CharacterID in ( SELECT CharacterID FROM object_data WHERE CharacterID IN ( SELECT CharacterID FROM character_data WHERE LastLogin < DATE_SUB(NOW(), INTERVAL 30 DAY) AND PlayerUID NOT IN ( SELECT PlayerUID FROM character_data WHERE LastLogin > DATE_SUB(NOW(), INTERVAL 30 DAY))))
  21. Hi, my goal is to take some of my existing scripts and have them return data collected in game to some of my custom tables in MySQL. I am well versed with MySQL and PHP but have never tried interfacing directly from the ARMA 2 scripting language. Is there a resource available where I can learn more about how to execute the queries and pass the information?
×
×
  • Create New...