Jump to content

Search the Community

Showing results for tags 'sql'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • 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


Last Updated

  • Start


Filter by number of...


  • Start





Website URL







Found 26 results

  1. Hello everyone. I would like to ask for help regarding a problem I have been having on my server. Items stored in the vault are not being stored in the SQL database. I have tested with the safe and the lockbox and both are not working but with the tent it works and saves the items in the database after the server restart. ArmA2OA.RPT: https://pastebin.com/X2cT7BBU arma2oaserve.RPT: https://pastebin.com/rqFNGbDy server_log.txt: https://pastebin.com/ZVWAzgNP Please help me. My players do not want to stay on the server because of this and if I remove the safe and leave only the tent (which is what saves the items) they will cry hahaha
  2. Sorry for another question! So Ive ordered a dedi box from OVH, the MC-32 one just to see if I could get it working as I have no experience with this at all! Ive installed Win 2012R2 trial, xampp, got all the server stuff done and its all good.. Except! When I start the console, and the game loads, it stops as it should until a player joins. The player joins and on thier screen they see the waiting to authenticate screen and its starts to count up. The issue is, the console sits there saying game started for a while before the hive starts loading, all the while the authenticate screen is still counting up. It gets ato about 80-90 before you actually load into the game, which isnt normal! The database has about 5500k objects, but even so, shouldnt take that long. Ive got the same database on my test server and it loads far faster, and also on my home pc server. Ive messed around with my.ini, but no real difference has been made and Im not really sure what Im doing, Ive just copied other examples off the web. The database is in c:/xammp on a 240gb ssd in raid0 The server files are in c:/epochserver....on the same disk. Im aware databases run better on a seperate disk, But I dont have that option right now. Im guessing its either an issue with speed connecting to the database or something is stalling it from starting quick enough. I read about clean up scripts being run before start up could cause this, and that would make sense, as when loaded into the game, loads of stuff is missing, specifically stuff thats not been mantained or interacted with in the last few days. However I cant find these scripts anywhere, Ive looked using navicat in events, Ive looked using phpadmin and also heidy sql. I can find no reference to any events, querys, functions or anything. In Hiveext.ini, cleanup is set to -1 Any help would be greatly appreciated, Im amazed I got this far on my own, but this one little issue I just cant figure out.
  3. Hi folks, Im getting myself in a mess trying to trim my database down from abandoned bases. What Ive done so far: All bases are indestructable. I want to keep this the case. On the 18th, I ran a script to update all objects 'last updated' time to be the 18th. I edited my init.sqf to have maintain when damage is 0 I editied fn_selfactions to make maintenance free Ive pre warned all players that they must maintain thier bases every 7 days starting from the 21st. What I want to acheive.. I thought I had saved an sql event in my bookmarks that would delete all objects that havent been updated in the previous 7 days, however I cant find it. I found this one But I tried it on my test server and it didnt delete anything. I changed the interval 24 day and interval 42 day to 1 day to try and it still didnt delete anything. SQL isnt my forte and I dont know what Im doing wrong. I just want a scipt I can run that deletes anything that hasnt been updated in the previous 7 days, be it automatic or one I have to run manually.. I have navicat or phpmyadmin acsess to the database and seemingly can create events without any issues, as I have run a charcter data one without issues, I just dont know what the correct event is for this purpose!
  4. Trader Prices differ between SQL files and Server FilesToday, 10:46 AM Hi Guys Heed some help, im trying to change the trader prices on my server and i've hit a problem. Here is a small example on whats going on; Aircraft trader NE airfield...Trader is Worker2 his Helicopter item TID is 519. "Merlin" price on the trader is 6 briefs and sell for 3 briefs but in phpmyadmin its 2 briefs buy and 1 brief sell??? No matter what I do it never changes any prices on the server and the two just don't merry up together? This also causes me a problem trying to add more traders and even new items. I have added PRACS and want to make a trader for it, so I created a TID, a Server trader and put the first jet in the Trader items. The trader on the server is showing the trader and his menu but no item? Does anyone know what's going wrong here. Regards ROG Server is overpoch Chernarus 11
  5. I need someone who (for the LOWEST price) can add vehicles and guns to traders AND can adjust prices of the vehicles. Thanks!
  6. deltagi

    SQL events

    I was wondering how I would make this mod Is there any tutorials for SQL evnets out there? Where do I put this bit of code? DROP EVENT IF EXISTS resetVaults; CREATE EVENT resetVaults ON SCHEDULE EVERY 1 DAY COMMENT 'Sets safe codes to 0000 if not accessed for 14 days' DO UPDATE `object_data` SET `CharacterID` = 0 WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `CharacterID` > 0 AND `Classname` IN ('VaultStorageLocked') AND `Inventory` <> '[]' AND `Inventory` IS NOT NULL Thanks Aurora!
  7. does anyone happen to have a list of the trader IDs for the map Sauerland? It would be really appreciated. TIA
  8. Hello, I've been trying to setup a server for a very long time. Could not get enough information from google/epoch forums or any other source on how i may fix this problem. I'd appreciate if one could help me out here. i have pretty much the default template for everything. config.cfg HiveExt.ini arma2oaserver.rpt init.sqf Database is pretty much default. https://photos-1.dropbox.com/t/0/AADPkBCoa5FpYYuvRxrpy5dJ0IgYDz7ceSCXRDfdZZ8lCw/12/123774030/png/1024x768/3/1411473600/0/2/sqlscrn.png/eYsQj5LnONotLmB97QFnAq-TFNUCMTQLY1bC5ZqRKbQ [sorry i didn't upload it to tinyurl etc. it's 4 in the morning and i would like atleast 2 hours of sleep before i have to get up again.] Any idea?
  9. Hi Guys! I forgot to backup my cleanup.sql when transferring to a new server. Soo, i was hoping someone would do me a solid and share some good cleanup to be ran each time the server reboots. Kimz!
  10. Okay guys, I have seen a lot of people having trouble adding weapons and items to their traders. I will admit that I was having the same problem as well. So I decided to make a program for myself to help out with the problem. Today I finally decided to release the program to the community to help others out. :) So first things first, You can download the program from Here Check out all of the spoilers for help. When you open it up it will look something like this, depending on your version of windows. And just so everyone feels a little safer. http://virusscan.jotti.org/en/scanresult/4bfc071e4742ab59a219a0d2e6b4eab6b138023f https://www.virustotal.com/en/file/338be750f28a82f855525615e8ff1f851dd555947e3d4fbee782097068ef5685/analysis/1400816403/
  11. Hi folks! New to the forum, yet running an Napf Overpoch server with survival servers as my host. I was just wonder wondering if anyone could give me a brief explanation of how to enter queries to activate buy/sell price changes for traders in the database. I already know how to find tid's and such to locate items and traders properly. I also know that all the changes are made in traders_data. I just have the understanding that in order to activate the changes made, there has to be an UPDATE query. There was another forum post that I had seen, :( ), that explained what needed to be put in the query but I'm dumb and need an explanation that shows what I need to do to change the prices of sandbags, specifically from 4 gold bars to buy, to 4 silver bars to buy. Any help would be greatly appreciated! Thanks for having patience! I'm new to scripting and SQL databases!
  12. I'm wanting to add some additional items to my traders. I have a good knowledge of SQL and how to add them via a query. The one thing that's holding me up is that I don't know what TID (Trader ID) to use when adding items. Most traders have multiple TIDs (i.e., Weapons Friendly - 485, 486, 489, 574, 487, 488) . How do I know which one to use when entering a new item?? Does it even matter?
  13. Hey all, Just a question, how can I remove an item from my Vilayer database? Is there a command I can use for a SQL Query? Thanks!!
  14. Hey guys, I created this excel spreadsheet a few weeks back to speed along the process of inserting all the Overwatch weapons into my database. Allows you to create mass SQL statements easily. Here is a screenshot: Once you're done, add this to the begginning of the statement: INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES YOU MUST REMOVE THE LAST COMMA FROM YOUR STATMENTS or you'll get an error. Very Easy! You can get it here: http://ge.tt/2UmgLQp1/v/0
  15. This SQL change the old id with the new id and the new id with the old id, so you have your old character back. set @oldID = '82888333'; set @newID = '76561197993172434'; update character_data set PlayerUID = concat(@oldID,'_CHANGE') where PlayerUID = @oldID and Alive = 1; update character_data set PlayerUID = @oldID where PlayerUID = @newID and Alive = 1; update character_data set PlayerUID = @newID where PlayerUID = concat(@oldID,'_CHANGE') and Alive = 1;82888333 is the old id76561197993172434 is the new id Note the 'Alive=1' condition. If the player was in dead state before the version change, there is nothing to do. If you want to do it in only one server instance, you need to add the Instance=11 (11, or wathever instance you want to change) condition on the 3 update lines. To find old id and new id you can use this SQL: select * from player_data where PlayerName like '%Jones%';Where Jones is the hint for the nick. To avoid character steal, you can ask for key itens that was on the old character. To see the itens on the old character, you can use this SQL: set @oldID = '82888333'; select Inventory, Backpack from character_data where PlayerUID = @oldID and Alive = 1;82888333 is the old id. You also can ask for the old player id as a way to avoid steal, but in my few experiences on this most players don't had it.
  16. Hey guys, I created this excel spreadsheet a few weeks back to speed along the process of inserting all the Overwatch weapons into my database. Allows you to create mass SQL statements easily. Here is a screenshot: Once you're done, add this to the begginning of the statement: INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES YOU MUST REMOVE THE LAST COMMA FROM YOUR STATMENTS or you'll get an error. Very Easy! You can get it here: http://ge.tt/2UmgLQp1/v/0
  17. I realize that there are a good many videos out there on how to setup a DayZ Epoch server, but this one in particular uses MySQL Workbench (Which I have found is not used in ANY video). I recommend using MySQL Workbench because it is free and you don't have to go through some back alley to get it like Navicat Lite. The tool is much better than Navicat Lite and gives you all the power you need over your server SQL for editing traders, players, vehicles, and whatever else you need to. I have gotten a good amount of positive feedback from this video and this gave me the idea to post it here. I figured it has helped a good deal of people on youtube and that it may help a good deal of you here. If you have any issues setting up a server this video should get you up and running in no time. Install Video
  18. Hey guys, I would like to improve my current base maintenance set up. First, copied below is what I have at the moment. My current setDamageOnAge.sql which is executed every 3 hours after server is automatically shutdown via script and just before it is automatically restarted. -- EXECUTION FREQUENCY: To be executed before each server restart. -- SUMMARY: Sets minor damage to walls so the game can identify when a maintain option should be available. -- It it recommended to have this set to half of your CleanupPlacedAfterDays value. -- The default is 6 days so "INTERVAL 3 DAY" should be used as shown below. UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') ) AND ( (`Classname` NOT LIKE '%Vault%') AND (`Classname` NOT LIKE '%Lockbox%') ) From what I understand the above code checks the Datestamp of any buildables and then sets Damage to "0.1" if it is older than 24 hours. (I added the last line it might be unnecessary - I'm not sure). Goal: The above being the current setup, what I would like to do next is, update my SQL query so that setDamage adds 10% every day, so that, if a user does not maintain for: 1 day, the damage will be 10% 2 days, the damage will be 20% 3 days, the damage will be 30% ... ... 9 days, the damage will be 90% 10 days, the damage will be 100% << from what I read in the forums here, then it will be automatically removed because the damage will be '1'. (Furthermore, my "CleanupPlacedAfterDays" is set to 10 days so it will definitely go - exactly what I want). Question #1: (SQL) So how can I accomplish this goal? Is there a simple SQL trigger such as "Damage = +0.1"? Question #2: (Epoch) Once the SQL side is sorted, how can I setup an Epoch system to charge players skipping maintenance accordingly AND reward (not punish) diligent players paying daily? Just to clarify with an example ( a ) Let's imagine a diligent player who logs in every day & maintains his base so he will be paying the maintenance fee for his items every day.In a 10 day period, he obviously will pay 10 times daily maintenance. ( b ) Let's also imagine a lazy-slash-busy player who (as you can guess) doesn't even log in to do any maintenance but logs in just before 10th day, so maintains every 9 days, thus pays 1 time daily maintenance every 10 days. This guy will be getting unfair discount which also means diligent dude will be getting punished for his diligence! If anything, I would like to give the diligent players a discount (nothing much -business slow already!-, let's say 5% discount for first day maintenance, 4% for second day, 3% for third day, 2% for fourth day, and only 1% for fifth day)... Let me add: I acknowledge the tiny (5% to 1%) discounts won't matter with gold bar payment system but I am still hoping we will reach our day, so it will make a difference when the day comes. Today, while we're at it I'd like to update maintenance related SQL queries in a way that the bonus code is active even though it won't matter for the next few week/months. Thanks in advance for any input...
  19. Hey all, I used this SQL query to add radios to my traders, but when I buy one (trader takes gold), it doesn't appear in my inventory. What have I done wrong? INSERT INTO `traders_data` (`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES ('["ItemRadio",1]',50,'[1,"ItemGoldBar10oz",1]','[1,"ItemGoldBar10oz",1]',0,663,'trade_items') Also there is no picture included, it just says : (ItemRadio) How can I add a picture? Thanks!
  20. Hi Everyone, I did try to search this but I only found a couple threads here and there relating to adding more items to the trader. Does anyone have a server that has ALL the Arma guns and ALL the Arma vehicles in the trader for buy/sell? If not, is this something anyone would be interested in working on with me? I hate taking an Mi17 there and find it's some stupid variant that doesn't sell. Thanks!!!
  21. Updated: hi folks,I originally stared this topic looking for advice on problems I was experiencing with lag/latency and general server administration practices. The issues were ultimately caused by high object numbers and poor practices/house keeping on my part. So for those new to Dayz server administration, or for those who are just not as technical as others (such as myself!), I have put together some of the information I have gathered to help others to avoid the struggle and hours of web-surfing and forum trawling. I hope you find this useful and helps your server by improving your "house-keeping". Experienced and more technical admins are more than welcome to add their feedback, correct any mistakes I've made or add further advice on this thread too. General config Build limit (INIT.sqf) This applies to objects that are allowed to be placed around each plot pole - it is NOT a limit of objects to be built on the server it's self. It's probably best to leave this at the default number, or even reduce it slightly. Dynamic vehicles & vehicle limits: I find that having traders with relatively cheap vehicles has kind of superseded the need for having dynamic vehicles spawning all over the map. They mostly spawn in places you don't really need or want them anyway and in most cases vehicles tend to sit for days unused or being salvaged for parts in far out reaches of the map. First it's important to realise that vehicle limits only govern dynamically spawned vehicles but it is affected by the total number of vehicles on the map. So if you have a vehicle limit of 200 that means once you server regulars have bought around 150 vehicles between them, your dynamic vehicle limit will be reduced to 50. Now this is entirely dependant on your server regular population and activity, but Personally I reduce my dynamic vehicle limit (vehicle limit in the INIT file) do about 350 as we have a steady server population and usually have around 330+ vehicles owned by players at anyone time. So I have removed the low value vehicles on the dynamic vehicles list and replaced them with some medium/high value vehicles so that they are more likely to be used/sold. This also gives players interesting little side missions to do around restarts. If they know there is a chance a decent chopper or armoured vehicle wills spawn they will go out patrolling. We manually add in vehicles for new spawns on the coast every other day too. Base decay This is the set period that is an object/base will need maintenance for. Some hosts automatically set this, others allow you to set it. Some have it disabled by default (such as dayz.st). I personally recommend enabling it and extending it to around 20 days. This generally prevents players from over building as they naturally limited to what they can afford or have time to maintain. From my experience, players who enjoy the modular building aspect of the game tend to build large, elaborate camps then once complete they start another project if base decay is not a factor. This is particularly bad if indestructible bases are enabled on a server as it pretty much makes that base a permanent fixture and resource hog. Vehicles: Vehicles known to cause lag/latency issues on servers are; pook_H13_amphib GNT_C185F GNT_C185E I recommend removing them from your database/traders. Maintenance/Clean ups: The more objects in your database, the more likely you are to experience latency issues and problems. By default not all objects created or even destroyed are removed from the database with most service providers, this is your job to do. The following SQL scripts will help you maintain your database. I cannot take credit for producing these scripts, these are just what I've found (BASED ON DAYZ.ST SERVERS - May vary slightly for other hosts). Update time stamp on objects based on player logins: This stops objects that are built by players that are active being cleaned up during automated clean ups by associating a time/date stamp to their objects. DROP EVENT IF EXISTS preventCleanup CREATE EVENT preventCleanup ON SCHEDULE EVERY 1 DAY COMMENT 'prevents cleanup of objects build by active player by setting the timestamp to currect' DO UPDATE Object_DATA SET Datestamp = CURRENT_TIMESTAMP WHERE ObjectUID <> 0 AND CharacterID <> 0 AND ((Inventory IS NULL) OR (Inventory = '[]')) AND EXISTS (SELECT 1 FROM Character_DATA c WHERE c.PlayerUID = (SELECT p.PlayerUID FROM Player_DATA p, Character_DATA c2 WHERE p.PlayerUID = c2.PlayerUID AND c2.CharacterID = Object_DATA.CharacterID) AND c.Alive = 1 AND c.LastLogin > NOW() - INTERVAL 1 WEEK) Remove destroyed vehicles: This sets a daily schedule to remove any destroyed vehicles from the database DROP EVENT IF EXISTS removeDamagedVehicles; CREATE EVENT removeDamagedVehicles ON SCHEDULE EVERY 1 DAY COMMENT 'Removes damaged vehicles' DO DELETE FROM `Object_DATA` WHERE Damage = 1; ; Remove abandoned objects: This removes any object that is "empty" and has not been modified for 2 weeks DROP EVENT IF EXISTS removeObjectEmpty; CREATE EVENT removeObjectEmpty ON SCHEDULE EVERY 1 DAY COMMENT 'Removes abandoned storage objects and vehicles' DO DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') OR (`Inventory` = '[[[],[]],[[],[]],[[],[]]]') ) ; Remove objects and vehicles after 7 days: This removes all objects owned by a player that has not been active within 7 days. DROP EVENT IF EXISTS removeObjectOld; CREATE EVENT removeObjectOld ON SCHEDULE EVERY 1 DAY COMMENT 'Removes old objects and vehicles' DO DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY) ;
  22. https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql This link is corrupt This is the link from server installation.
  23. I was about to add some events for cleaning up old vehicles in my Database ( when I noticed something really strange. It seems a lot of my vehicles automaticly get a new timestamp in the LastUpdated column every time the server comes up. This means removing these vehicles from database by using this value becomes quite problematic since I have no idea when they were last used. I did some troubleshooting and it seems it only happens with vehicles that are not fully repaired. If I repair them it keeps the timestamp and does not change at server restart. If not repairing the vehicles updated the column, a workaround could be creating an event that repairs everything every day, but alas it does (Maybe there's a way around this in SQL?). There's also a couple of vehicles that are not fully repaired that this does not happen to. It occurs both on ordinary spawned and locked vehicles. My buildings are indestructible so I am unaware if they would have the problem as well if they were damaged. I created a new server with a unchanged dayz_server.pbo and Mission folder and created a new empty database. The problem still occurs. Attached is an excerpt from HivExt.log when the problem is occuring on the new server (17:29:48). Is this a known issue or am I doing something wrong? LastUpdated_Troubleshooting_HiveExt.txt
  24. So silly question probably but, how do I go about updating the server files? I did search, found someone ask the same basic question and they got a one line response of updating sql... Surely there is more to it than executing the new sql file no? Can someone elaborate? Especially if the current server install is modded with scripts etc. won't the new files overwrite the existing? Anyone want to put up some simple instructions on how to update an epoch server? I guess, a proper question would be this: When updating to a new server version, must server admins update all files, including all instance_X_mapname, and MPMission folders etc.that are included in the download to get benefits of the update? Or is the server update merely the new HiveExt.dll and the new server pbo? Can I just update the pbo to get all new version updates?
  • Create New...