-
Posts
208 -
Joined
-
Last visited
Content Type
Profiles
Forums
Articles
Posts posted by JohnyMST
-
-
Hey Guys!
It wasn't the code which got my server down. It was my SQL port being set to a completely different value then it should be!
I'm not sure how this happened as I am aware of what SQL port I should be using (probably a typo)...
In my case, my SQL port was set to 3303 instead of 2303... I know, stupid :)To check/change your SQL port (in Vilayer anyway)
Go to section: Change Database Passwords
In there you will see all your connection properties that server uses
Thanks: LimpNoodle & Revoplay :)
-
Just for anyone who will find this topic with similar problems:
In order for the announces to work spot on time, I had to change the hours even though my Time zone was set correctly etc.
My current Scheduler code looks like this:
01:00:00~ 02:00:00~ 03:00:00~ 03:30:00~ Server Restart in 30 minutes 03:45:00~ Server Restart in 15 minutes 03:55:00~ Server Restart in 5 minutes 03:59:00~ Server Restart in 1 minute. RUN!!! 04:00:00~ 05:00:00~ 06:00:00~ 06:30:00~ Server Restart in 30 minutes 06:45:00~ Server Restart in 15 minutes 06:55:00~ Server Restart in 5 minutes 06:59:00~ Server Restart in 1 minute. RUN!!! 07:00:00~ 08:00:00~ 09:00:00~ 09:30:00~ Server Restart in 30 minutes 09:45:00~ Server Restart in 15 minutes 09:55:00~ Server Restart in 5 minutes 09:59:00~ Server Restart in 1 minute. RUN!!! 10:00:00~ 10:30:00~ 11:00:00~ 12:00:00~ 12:30:00~ Server Restart in 30 minutes 12:45:00~ Server Restart in 15 minutes 12:55:00~ Server Restart in 5 minutes 12:59:00~ Server Restart in 1 minute. RUN!!! 13:00:00~ 14:00:00~ 15:00:00~ 15:30:00~ Server Restart in 30 minutes 15:45:00~ Server Restart in 15 minutes 15:55:00~ Server Restart in 5 minutes 15:59:00~ Server Restart in 1 minute. RUN!!! 16:00:00~ 17:00:00~ 18:00:00~ 18:30:00~ Server Restart in 30 minutes 18:45:00~ Server Restart in 15 minutes 18:55:00~ Server Restart in 5 minutes 18:59:00~ Server Restart in 1 minute. RUN!!! 19:00:00~ 20:00:00~ 21:00:00~ 21:30:00~ Server Restart in 30 minutes 21:45:00~ Server Restart in 15 minutes 21:55:00~ Server Restart in 5 minutes 21:59:00~ Server Restart in 1 minute. RUN!!! 22:00:00~ 23:00:00~ 00:30:00~ Server Restart in 30 minutes 00:45:00~ Server Restart in 15 minutes 00:55:00~ Server Restart in 5 minutes 00:59:00~ Server Restart in 1 minute. RUN!!!
Server restarts every 3 hours as you can see.
Thank you: LimpNoodle, fr1nk, -CJ-, JuiceRIfle :)
-
It's sad but I think I entered my lines into Traders_Items instead of the Tables "folder"...
I ran the traders_data from your link but it didn't fix it... I'm sure that I entered wrong code into wrong table...
Have you also got the default Trader_Items code?
-
I have not edited anything except this for 2 days... This is very weird.
Revoplay
Also I found that:
When I restart the server, I can join the lobby and then it takes me to the briefing (where u see list of players and the map etc) but it never goes further then the briefing screen...
I need to exit the game then and when I refresh my server in the list I see time icon beside it, from that point I can no longer join even the lobby until I restart the whole server.
We will need the rpt log
I have no idea how to provide you with the log.
There has to be someone with a solution to this...
Can you please tell me how to restore SQL to standard and remove my previous entries? Just in case it did cause the problem...
-
It broke after I executed the above SQL query... Was working fine 5 minutes before this...
Anyone knows how to restore this stuff?
-
any ideas on this?
-
The annnonces started working suddenly o0
The hours are off anyway. I will need to modify them 1 hour ahead to see if its spot on...
-
I updated my traders with Cinder Blocks, Mortar and Sledgehammer via SQL program and after that was done I can no longer join my server :/
It's online however in dayz commaner I have the "time" icon showing beside it...
How can I restore it so the server is back working again? I'm not sure what I did wrong as I used the below SQL query to update the traders:
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["CinderBlocks",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 680, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["MortarBucket",1]', 50, '[5,"ItemSilverBar",1]', '[2,"ItemSilverBar",1]', 680, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgeHandle",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 508, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 530, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 662, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 678, 'trade_items');
INSERT INTO traders_data (`item`, `qty`, `buy`, `sell`, `tid`, `afile`) VALUES ('["ItemSledgehead",1]', 50, '[1,"ItemGoldBar10oz",1]', '[3,"ItemGoldBar",1]', 680, 'trade_items'); -
Hey! :D
I was thinking about adding new models such as Lambo, Ferrari and all those awesome cars...
Do u know if it's possible or are there any scripts for this?
Any help appriciated ;) -
Yeah my one is enabled too... No idea why its not working :/
-
Configuration Files --> DayZ Epoch --> [account]_MasterConfiguration\[server ID]_config.cfg --> [configuration editor]
Yeah i'm in that file. Cant see how to enable this tho...
-
I've had this same issue. Oddly enough, Battleye was turned off :lol:
Battleye was turned off?
How do I check if it's on or not? :D
-
is there anything else that I might have skipped?
-
yeah it's pointing to my server IP, Port and Rcon
-
Hi guys,
I need help with my Vilayer server. My announces are not working on my server at all...
I have made the steps to get them to work but still no luck, maybe someone will be able to help out with this...
I have installed "Battleye Extended Controls" in the Add Ons menu
Then I moved on to the file : "servermessages\messages.cfg" and wrote the following inside
00:30:00~ 01:00:00~ 01:30:00~ 02:00:00~ 02:30:00~ Server Restart in 30 minutes 02:45:00~ Server Restart in 15 minutes 02:55:00~ Server Restart in 5 minutes 02:59:00~ Server Restart in 1 minute. RUN!!! 03:00:00~ 03:30:00~ 04:00:00~ 04:30:00~ 05:00:00~ 05:30:00~ Server Restart in 30 minutes 05:45:00~ Server Restart in 15 minutes 05:55:00~ Server Restart in 5 minutes 05:59:00~ Server Restart in 1 minute. RUN!!! 06:00:00~ 06:30:00~ 07:00:00~ 07:30:00~ 08:00:00~ 08:30:00~ Server Restart in 30 minutes 08:45:00~ Server Restart in 15 minutes 08:55:00~ Server Restart in 5 minutes 08:59:00~ Server Restart in 1 minute. RUN!!! 09:00:00~ 09:30:00~ 10:00:00~ 10:30:00~ 11:00:00~ 11:30:00~ Server Restart in 30 minutes 11:45:00~ Server Restart in 15 minutes 11:55:00~ Server Restart in 5 minutes 11:59:00~ Server Restart in 1 minute. RUN!!! 12:00:00~ 12:30:00~ 13:00:00~ 13:30:00~ 14:00:00~ 14:30:00~ Server Restart in 30 minutes 14:45:00~ Server Restart in 15 minutes 14:55:00~ Server Restart in 5 minutes 14:59:00~ Server Restart in 1 minute. RUN!!! 15:00:00~ 15:30:00~ 16:00:00~ 16:30:00~ 17:00:00~ 17:30:00~ Server Restart in 30 minutes 17:45:00~ Server Restart in 15 minutes 17:55:00~ Server Restart in 5 minutes 17:59:00~ Server Restart in 1 minute. RUN!!! 18:00:00~ 18:30:00~ 19:00:00~ 19:30:00~ 20:00:00~ 20:30:00~ Server Restart in 30 minutes 20:45:00~ Server Restart in 15 minutes 20:55:00~ Server Restart in 5 minutes 20:59:00~ Server Restart in 1 minute. RUN!!! 21:00:00~ 21:30:00~ 22:00:00~ 22:30:00~ 23:00:00~ 23:30:00~ Server Restart in 30 minutes 23:45:00~ Server Restart in 15 minutes 23:55:00~ Server Restart in 5 minutes 23:59:00~ Server Restart in 1 minute. RUN!!!
So this should be warning players every 3 hours (I want restarts every 3h)
Are there any problems here?
I have also changed the settings in my Scheduled Tasks:
My Time zone is also set to UTC 0
Can you let me know if there is anything wrong with this?
Thanks
-
This is my "Keys" folder. bikeys files are in here..
-
Restarted just now... no luck
Should I downgrade the server to old version? Anyone?
-
I keep running into a lot of problems with the new patch...
Now when I try to join my server I get that error:
Any Ideas?
-
Hi guys,
I ran into a big problem with my server.
I am stuck on this screen "waiting on server to start authentication" and epoch logo... After 30sec it disconnects me and I am returned to the lobby...I am able to login into any server but my one.
What could be causing this issue?
-
OMG it suddenly came to me... I downloaded HeidiSQL and connected to MySQL...
I can see the file you were talking about "Trader_Items"
Now if I dont succeed with this on my own, I will give u the details to login ( I want to learn how to do this :D )
Just tell me... How do I edit this Trader Items so I can input the lines that I want to stock into the traders
Can u send a screenshot on where I should enter the lines u gave me yesterday?
-
Hi again guys,
I asked a question about the Trader Stock as I want to add Cinder Blocks and Mortar to them.I have received a response that I should look for file called "traders_data" file but I cannot find it anywhere.
Today I was told that I should add the stock in MySQL... I have no idea on who to do this and I have searched the forum for help but didnt find anything good.
Can you please let me know if you know, where and how to add these two Items. Screenshots, anything is helpful.
This is all I need to get my server completed and I would love to have it done soon. Anyone with this knowledge or Vilayer server willing to help out?Thanks!!
-
OK I see the "Traders_Data" file but the format of the file is: "FRM"
How do I open FRM files? I tried with notepad ++ but it doesnt look good.
þ 0 ÂQ @ Â ]Å ! // € ( € @ÿ € @ ÿPRIMARYÿitemÿ trade_items InnoDB ç m W Q' P « m ) id item qty buy sell order tid afile Jÿ @ 8 @ Kÿ @ Jÿ @ @ @@ ÿidÿitemÿqtyÿbuyÿsellÿorderÿtidÿafileÿ [Class Name,1 = CfgMagazines | 2 = Vehicle | 3 = Weapon]amount in stock available to buy[[Qty,Class,Type],][[Qty,Class,Type],]# sort order for addAction menuTrader Menu ID
............. ?
-
I am using Vilayer host and I dont have an sql Tab.
I can see mysql folder in the file manager but nothing specific in there...
-
Sorry but I'm a noob at this.
Execute this sql.
What does that mean? Or how do I execute this sql? :P
HiveExt.ini location? (vilayer.com)
in Scripting
Posted
Services > Configuration Files > ServerName_MasterConfiguration\HiveExt.ini > *Text Editor*
Code:
Change 365 to whatever you like. If you don't have CleanupPlacedAfterDays line then add the whole part under Objects ;ResetOOBObjects = false so It looks like mine above.