vbawol Posted July 3, 2013 Report Share Posted July 3, 2013 In the 1.0.1.4 release the trader config had some missing items like: fishing poles, crowbars, machete, tents, lightbulbs, generators, safes. Update your SQL using this one or wait for the next release 1.0.1.5. https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql ^ Right click save as Link to comment Share on other sites More sharing options...
0 legato Posted July 3, 2013 Report Share Posted July 3, 2013 I'm still a little green as far as SQL. I can just go into phpmyadmin, and "Import" this file and it will make the necessary changes? Link to comment Share on other sites More sharing options...
0 TayTayTheKiller Posted July 3, 2013 Report Share Posted July 3, 2013 just get errors with navicat Commits to DayZ-Epoch:master" type="application/atom+xml" /> </head> <body class="logged_out page-blob windows vis-public env-production "> <div class="wrapper"> <div [Msg] Finished - Unsuccessfully Link to comment Share on other sites More sharing options...
0 vbawol Posted July 3, 2013 Author Report Share Posted July 3, 2013 Sorry wrong link try it now. Link to comment Share on other sites More sharing options...
0 TayTayTheKiller Posted July 3, 2013 Report Share Posted July 3, 2013 working Perfect thanks! Link to comment Share on other sites More sharing options...
0 rac Posted July 6, 2013 Report Share Posted July 6, 2013 Ok...like TayTay, do i paste this to my sql and punch "go" or do I have to replace a file or just import it and let it do its thing? sorry...kinda a noob question, but i havent done much work with phpmyadmin (ST server) Thanx rac Link to comment Share on other sites More sharing options...
0 rac Posted July 6, 2013 Report Share Posted July 6, 2013 Tried importing it, nothing Link to comment Share on other sites More sharing options...
0 blindfisk Posted July 6, 2013 Report Share Posted July 6, 2013 I pasted it in the SQL-tab in phpmyadmin and hit "ok". That worked for me. Before that I had to rename all the tables in the epoch.sql file like this: "character_data" to "Character_DATA" and "object_data" to "Object_DATA" and so on. I did it with Notepad++ (search then change all). Link to comment Share on other sites More sharing options...
0 rac Posted July 6, 2013 Report Share Posted July 6, 2013 SUCCESS!! Thanx blindfisk, only one more question, when i open bliss thru php my admin, its showing that i have Traders_DATA AND traders_data, same for player, object , ect, is this somethin redundant that i can remove?....otherwise....my traders seem to be fixed. Link to comment Share on other sites More sharing options...
0 rac Posted July 6, 2013 Report Share Posted July 6, 2013 BTW..I really like ST servers, but they really dropped the ball on this one and seemed to not really care if it worked or not. Link to comment Share on other sites More sharing options...
0 blindfisk Posted July 6, 2013 Report Share Posted July 6, 2013 Yes, thats exactly why I had to rename them. To prevent the duplicate tables. Link to comment Share on other sites More sharing options...
0 rac Posted July 6, 2013 Report Share Posted July 6, 2013 OK, selected the redundant files and selected "drop" from the actions menu, cleaned up nicely. hope everything works after restart. Thanks again for your help blindfisk. Link to comment Share on other sites More sharing options...
0 blindfisk Posted July 6, 2013 Report Share Posted July 6, 2013 No problem :) Link to comment Share on other sites More sharing options...
0 PetuniaEpoch Posted July 7, 2013 Report Share Posted July 7, 2013 Hi, Can I check, what's with the renaming? Doesn't this mess with the files, as I though SQL was case sensitive? - Meaning, don't the SQL queries the game makes use character_data, rather than character_DATA ? Not saying this is wrong (not at all!) just wondering if I need to do this, and why? If it's to create new tables instead of overwritie old ones or something, then do I need to copy over all my player data into character_data? I pasted it in the SQL-tab in phpmyadmin and hit "ok". That worked for me. Before that I had to rename all the tables in the epoch.sql file like this: "character_data" to "Character_DATA" and "object_data" to "Object_DATA" and so on. I did it with Notepad++ (search then change all). Link to comment Share on other sites More sharing options...
0 blindfisk Posted July 7, 2013 Report Share Posted July 7, 2013 I am not an SQL-expert. I just wanted to keep the buildings and vehicles that were there before I updated. I thought I'd change the table-names in the epoch.sql file to match the existing ones in my database to prevent duplicates and patch the existing data. Now Im actually not sure if that is working that way at all. My tables looked like this: Character_DATA Object_DATA Player_DATA Player_LOGIN Server_TRADERS Trader_ITEMS Trader_TIDS Traders_DATA Can some sql-pro enlighten me/us? Link to comment Share on other sites More sharing options...
0 vbawol Posted July 7, 2013 Author Report Share Posted July 7, 2013 Sorry about that guys, I did forget to take linux servers into account and fix the case. It has been fixed and will remain fixed from now on. https://raw.github.com/vbawol/DayZ-Epoch/3a15a66200bde54c99855c42e8a95164ac06d333/Server%20Files/mysql/epoch.sql Link to comment Share on other sites More sharing options...
0 blindfisk Posted July 7, 2013 Report Share Posted July 7, 2013 Awesome, thanks! I love the mod btw. The best. :) Link to comment Share on other sites More sharing options...
0 Sirocco Posted July 8, 2013 Report Share Posted July 8, 2013 Thanks vbawol for the fix. I've had the same problem as everyone else on my Dayz.ST server. I stopped my server and used your sql file to update the tables. Pasted it in phpMyAdminand ran it. But had the case sensitive problem where the new files were without the Capitals. So it was still using the old tables. I made a copy of the old Traders_DATA as Traders_DATAold then deleted the old file. I copied the new traders_data file with the old files capitalization as so Traders_DATA . When I restarted the server, all the Traders now work. Woo Hoo Thanks again Sirocco Link to comment Share on other sites More sharing options...
Question
vbawol
In the 1.0.1.4 release the trader config had some missing items like: fishing poles, crowbars, machete, tents, lightbulbs, generators, safes. Update your SQL using this one or wait for the next release 1.0.1.5.
https://raw.github.com/vbawol/DayZ-Epoch/master/Server%20Files/mysql/epoch.sql
^ Right click save as
Link to comment
Share on other sites
17 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now