Survival Essentials

How to use protection zone for admins? What commands are for it?
______________________________________________
EDIT: 15.00, 31.08.2015

OK. NVM... I probably found line in "cs" file where it is.

Code:

 void LoadProtectionZones()
  {
  ProtectedZones.Clear();  // ProtectedZones.Add(new Vector2(x, z), distance);
  }

But my question is:

Is it possible to make this kind of funcion without whole this mod and without SQL base ?

 

database download error

 

Can we get an update link to the clean DB and marketplace.sql

The Mega link no longer works

 

can someone please upload the mssql database as the link is no longer working thanks

 

please share mssql database guys

 

Ok Guys here is what Jonty originally uploaded , I have posted them on the bottom of the page at this link 4kgamers

There was 2 files Marketplace.sql and ROK.sql

 

thank you so much

 

I would be curious to know this too. War Tracker has /warnokos - Toggles whether players can KoS if not in a war which is not working. GrandExchange has /safetrade which works but affects the store trade area. SafeZones or No Attack Zones - unmaintained. Is Survival Essentials the answer?
[DOUBLEPOST=1443726682,1443616396][/DOUBLEPOST]

If you figure out how to get this to work let me know.....I am a noob when it comes to databases and have yet to get it to work.

 

i dont know how to use mssql that well i installed mssql 2008 r2 got it to connect to the database but dont seem to be updating the tables atm

 

I cant get it to connect....I also have 2008 r2 installed (tried several machines,VPS's and now have it on local machine ROK server is running on trying to use localhost or 127.0.0.1 to simplify everything), I have all my tables ready but clearly not communicating.Can anyone take a look at this

Code:

[Oxide] 8:14 PM [Info] Loaded plugin SurvivalEssenstials v2.0.1 by Jonty
[Oxide] 8:14 PM [Warning] [SurvivalEssenstials] System.Data.SqlClient.SqlExcepti
on: Server does not exist or connection refused. ---> Mono.Data.Tds.Protocol.Tds
InternalException: Server does not exist or connection refused. ---> System.Net.
Sockets.SocketException: No connection could be made because the target machine
actively refused it.
  at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remoteEP, Boolean re
quireSocketPolicy) [0x00000] in <filename unknown>:0
  at System.Net.Sockets.Socket+Worker.Connect () [0x00000] in <filename unknown>
:0
  --- End of inner exception stack trace ---
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port,
Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] in <filename
unknown>:0
  at Mono.Data.Tds.Protocol.Tds..ctor (System.String dataSource, Int32 port, Int
32 packetSize, Int32 timeout, TdsVersion tdsVersion) [0x00000] in <filename unkn
own>:0
  at Mono.Data.Tds.Protocol.Tds70..ctor (System.String server, Int32 port, Int32
packetSize, Int32 timeout, TdsVersion version) [0x00000] in <filename unknown>:
0
  at Mono.Data.Tds.Protocol.Tds80..ctor (System.String server, Int32 port, Int32
packetSize, Int32 timeout) [0x00000] in <filename unknown>:0
  at Mono.Data.Tds.Protocol.TdsConnectionPoolManager.CreateConnection (Mono.Data
.Tds.Protocol.TdsConnectionInfo info) [0x00000] in <filename unknown>:0
  at Mono.Data.Tds.Protocol.TdsConnectionPool.GetConnection () [0x00000] in <fil
ename unknown>:0
  at System.Data.SqlClient.SqlConnection.Open () [0x00000] in <filename unknown>
:0
  --- End of inner exception stack trace ---
  at System.Data.SqlClient.SqlConnection.Open () [0x00000] in <filename unknown>
:0
  at Oxide.Plugins.SurvivalEssenstials.Loaded () [0x00000] in <filename unknown>
:0
[Oxide] 8:14 PM [Error] Failed to call hook 'OnServerInitialized' on plugin 'Sur
vivalEssenstials v2.0.1' (InvalidOperationException: ExecuteReader requires an o
pen connection to continue. This connection is closed.)
[Oxide] 8:14 PM [Debug]   at System.Data.SqlClient.SqlCommand.ValidateCommand (S
ystem.String method, Boolean async) [0x00000] in <filename unknown>:0
  at System.Data.SqlClient.SqlCommand.ExecuteReader (CommandBehavior behavior) [
0x00000] in <filename unknown>:0
  at System.Data.SqlClient.SqlCommand.ExecuteReader () [0x00000] in <filename un
known>:0
  at (wrapper remoting-invoke-with-check) System.Data.SqlClient.SqlCommand:Execu
teReader ()
  at Oxide.Plugins.SurvivalEssenstials.LoadAnnouncements () [0x00000] in <filena
me unknown>:0
  at Oxide.Plugins.SurvivalEssenstials.OnServerInitialized () [0x00000] in <file
name unknown>:0
  at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (ob
ject,object[],System.Exception&)
  at System.Reflection.MonoMethod.Invoke (System.Object obj, BindingFlags invoke
Attr, System.Reflection.Binder binder, System.Object[] parameters, System.Global

4KGamers Reign Of Kings Test Server 63fps, 4m14s
0/5 players, 0 sleepers, 79 entities 0b/s in, 0b/s out
1:17 pm, Weather: Clear Oxide 2.0.1414 for Alpha 21
Oxide 2.0.1414 for Alpha 21

 

I have no idea how to load rules.. ive read everything,, please help

 

OK So I have gotten this to work and connect to a DB but how do you edit the tables? I am a total Database noob

 

Hello has all, I am actuelement has the search(research) for a devellopeur capable of supplying me a compatible version stable MySQL and with some added fonctionnalitée has this plugin if possible translated into French, naturally we let us can dédomager financially the person who will realize us this plugin, contact I for more information beforehand thank you

 

Hi guys,

I've been working on other games lately and havent really had time to support RoK. I've been kind of interested to rewrite this plugin but with MySQL support - if this is something that sounds good to you then add a post to this thread and if theres enough demand, I'll go ahead and do it.]
[DOUBLEPOST=1447730813,1447719995][/DOUBLEPOST]

I use a program called Navicat to modify the db.
[DOUBLEPOST=1447737337][/DOUBLEPOST]

If you still haven't managed to get it working, flick me an email at [email protected] with your Skype and I can assist you.

 

There are parts of this plugin that I would like to use on our servers. However it conflicts with some of the existing plugins. For example is there a way to run the protectionzones without running anything else?

 

hope to see it at MySQL or even better file based

 

Flatfail? Never! And after looking at the MySQL wrapper included in Oxide I don't think I'll be doing that either.
[DOUBLEPOST=1450887846][/DOUBLEPOST]

No, the plugin comes all-in-1. However I could always write you a simple plugin for your server to do exactly that.

 

Well Im using dedicated server with windows server 2016 and I dont have license for MSSQL

 

Where's the DB? I cant find it.

 

Okay, using Windows Server 2012 and MSSQL 2008 and I cannot establish a connection to 127.0.0.1. I have configured the MSSQL server to accept local and remote connections, but it does not work with the plugin, navicat or HeidiSQL. Therefore, if you converted this to Oracle MySQL, that would be GREAT, as I am more familiar with MySQL than MSSQL. Microsoft seems to like to make things far more complicated than they need to be, it seems.