Survival Essentials

Ah oh should have read it first properly lol, Thanks

 

spending quite a bit of time getting the errors sorted. One thing to note, you do need to list in your Prerequisits, that you need MSSQL 2008 R2 for this to work first time around without mucking with it. I had 2014 and ran into several issues. tried it with 2008 R2 and it works better. Not all of the commands work, so still trying to resolve that issue. The leaderboard works. Balance does not work for both admins on the server, only one. The spawn protection works here and there, not consistently. I can do damage but not take damage. Duel is not working and does not come up in the commands. Still testing, more to come.

 

Jonty updated Survival Essentials with a new update entry:

Namespace issue fixed

[DOUBLEPOST=1437046272][/DOUBLEPOST]

You sure the database connection is configured correctly? Because I am using the exact same .cs and it is working for me.

 

I tried to load your plugin, using SQL Server 2014 Express. Database excist and I was able to test my connection with a test.udl. However when I try to load the plugin it gives a connection error;

Code:

12:46 PM [Info] Loaded plugin SurvivalEssenstials v2.0.1 by Jonty
12:46 PM [Warning] [SurvivalEssenstials] System.Data.SqlClient.SqlException: Server does not exist or connection refused. ---> Mono.Data.Tds.Protocol.TdsInternalException: Server does not exist or connection refused. ---> System.Net.Sockets.SocketException: Kan geen verbinding maken omdat de doelcomputer de verbinding actief heeft geweigerd.
  at System.Net.Sockets.Socket.Connect (System.Net.EndPoint remoteEP, Boolean requireSocketPolicy) [0x00000] in <filename unknown>:0
  at System.Net.Sockets.Socket+Worker.Connect () [0x00000] in <filename unknown>:0
  --- End of inner exception stack trace ---

 

It tells you.. YOU NEED 2008

 

I know it's probably painfully annoying to hear this but if I am running on my local host, is this not possible to use? I've set up local mysql server, never an mssql server which I figured would have been nearly the same but I can't seem to even accidently get one thing correct about it.
Would love to use the full features of this plugin and willing to pay for help setting up if it's possible.

 

Actually they are alot different haha.. you will need to go and get a MSSQL 2008 server setup (its not hard) and you may need to edit a few things in the script to get it to work properly, this isn't a plug and play thing thats for sure

 

Oh okay, interesting. I'll keep trying but I must have the wrong mssql 2008. At first I downloaded the express version, then I downloaded and installed the regular version but it didn't change that I noticed.
I'm just a bit sad this game is dying at the speed of light. Our awesome server admins just quit and said they aren't supporting this game due to lack of interest and babysitting everything from crest breakers to day kosers, and so on. Same reasons I wouldn't want to admin but this plugin seems to solve.

I'll keep trying and appreciate your response.

 

stopping decresting is easy

Code:

using System;
using System.Collections.Generic;using CodeHatch.Build;
using CodeHatch.Engine.Networking;using CodeHatch.Engine.Core.Networking;
using CodeHatch.Blocks;
using CodeHatch.Blocks.Networking.Events;
using CodeHatch.Networking.Events.Entities;
using CodeHatch.Networking.Events.Entities.Players;
using CodeHatch.Networking.Events.Players;
using CodeHatch.Networking.Events.Social;
using CodeHatch.Engine.Core.Cache;
using UnityEngine;namespace Oxide.Plugins
{
    [Info("No Crest Attacks", "Vilemouse", "0.2.0")]
    public class CrestAttacking : ReignOfKingsPlugin {
   
        #region Configuration Data
       
        string chatPrefix = "Crest";
        string message;
        #endregion
       
       
       
   
        private void OnEntityHealthChange(EntityDamageEvent damageEvent) {
                if (damageEvent.Damage.Amount > 0) {
                    bool crestattack = damageEvent.Entity.name.ToString().Contains("Crest");
                        if (crestattack){
//                            string attacker = "[00FF00]" + damageEvent.Damage.DamageSource.Owner.DisplayName;
//                            string message = chatPrefix + ": " + attacker + " has attacked " + damageEvent.Entity.Player.DisplayName + " crest.";
//                            PrintToChat(message);
                            damageEvent.Cancel("No damage to crest");
                            damageEvent.Damage.Amount = 0f;                       
                            PrintToChat(damageEvent.Damage.DamageSource.Owner, "[FF0000]You can't damage another players crest.  If this crest needs removed due to a rule violation please request assistance from an admin.");
                            }
                }
            }
        }       
}

 

any plans on making it mysql compatible ?

 

I don't think he/she will as there really isn't a point.. MSSQL 2008 isn't hard to setup or use..

 

its hard to setup on a windows 2012 server

 

How is it hard i have it on windows 2012.. http://www.microsoft.com/en-au/download/details.aspx?id=1695 that and set it up and then https://www.microsoft.com/en-au/download/details.aspx?id=7593 and set it up, make the database and then import everything from the SQL file.. done :3

 

Can anyone help me out here? I have been trying to get this plug in to work with no luck.....Here is what I am getting now . Is an older version of plugin getting loaded without my database settings or do i just have have all this screwed up like a soup sandwich?
****UPDATE: My VPS was closing my ports either due to VPS template or rule/role issues. **

Code:

eac_server.dll [x64] :: hModule: 000007FEDEA00000 dwReason: 1 lpvReserved: 0
[Oxide] 4:44 PM [Info] Loading Oxide core v2.0.1248...
[Oxide] 4:44 PM [Info] Loading extensions...
[Oxide] 4:44 PM [Info] Loaded extension CSharp v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension JavaScript v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension Lua v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension MySql v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension Python v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension SQLite v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension Unity v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded extension ReignOfKings v1.0.1248 by Oxide Team
[Oxide] 4:44 PM [Info] Using Covalence provider for game 'ReignOfKings'
[Oxide] 4:44 PM [Info] Loading plugins...
[Oxide] 4:44 PM [Info] Loaded plugin Unity Core v1.0.0 by Oxide Team
[Oxide] 4:44 PM [Info] Loaded plugin Reign of Kings Core v1.0.0 by Oxide Team
[Oxide] 4:44 PM [Info] SurvivalEssenstials was compiled successfully in 3125ms
[Oxide] 4:44 PM [Warning] A plugin has polluted the global namespace by defining
ChatColours: SurvivalEssenstials
[Oxide] 4:44 PM [Warning] A plugin has polluted the global namespace by defining
AmpCache: SurvivalEssenstials
[Oxide] 4:44 PM [Warning] A plugin has polluted the global namespace by defining
AmpMarketplace: SurvivalEssenstials
[Oxide] 4:44 PM [Info] Loaded plugin SurvivalEssenstials v2.0.1 by Jonty
[Oxide] 4:44 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 such host is known.: 0.0 b/s Total Receive: 0.0 b/s  at System.Net.Dns.GetHostByName (System.String hostName) [0x00000] in <filenam
e unknown>:0
  at System.Net.Dns.GetHostEntry (System.String hostNameOrAddress) [0x00000] in
<filename unknown>:0
  at Mono.Data.Tds.Protocol.TdsComm..ctor (System.String dataSource, Int32 port,
Int32 packetSize, Int32 timeout, TdsVersion tdsVersion) [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
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
NullReferenceException: Object reference not set to an instance of an object
[Oxide] 4:45 PM [Error] Failed to call hook 'OnPlayerConnected' on plugin 'Survi
valEssenstials' (InvalidOperationException: ExecuteScalar requires an open conne
ction to continue. This connection is closed.)
[Oxide] 4:45 PM [Debug]   at System.Data.SqlClient.SqlCommand.ValidateCommand (S
ystem.String method, Boolean async) [0x00000] in <filename unknown>:0
  at System.Data.SqlClient.SqlCommand.ExecuteScalar () [0x00000] in <filename un
known>:0 0.1.21(100021) - Alpha 18   Total Sent: 0.0 b/s Total Receive: 0.0 b/s
  at Oxide.Plugins.SurvivalEssenstials.OnPlayerConnected (CodeHatch.Engine.Netwo
rking.Player player) [0x00000] in <filename 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
ization.CultureInfo culture) [0x00000] in <filename unknown>:0
[Oxide] 4:45 PM [Error] Failed to call hook 'OnServerInitialized' on plugin 'Sur
vivalEssenstials' (InvalidOperationException: ExecuteReader requires an open con
nection to continue. This connection is closed.)
[Oxide] 4:45 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 8   Total Sent: 0.0 b/s Total Receive: 0.0 b/s
  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
ization.CultureInfo culture) [0x00000] in <filename unknown>:0
[Oxide] 4:45 PM [Error] Failed to call hook 'CheckCurrencyBalance' on plugin 'Su
rvivalEssenstials' (NullReferenceException: Object reference not set to an insta
nce of an object)
[Oxide] 4:45 PM [Debug]   at Oxide.Plugins.SurvivalEssenstials.CheckCurrencyBala
nce (CodeHatch.Engine.Networking.Player Player, System.String Command, System.St
ring[] Arguments) [0x00000] in <filename 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
ization.CultureInfo culture) [0x00000] in <filename unknown>:0

 

This is by far, the most amazing sounding plugin out there, I have been browsing plugin sites for hours and this features everything I am looking for, for my very busy RP server. However, I'm a super noob when it comes to server configuring. I know how to access FTP etc. However, my oxide does not have a folder under my "Saves" folder....though I downloaded it straight from this site? I am using a Hosted Server at that. So I guess my only question is, since you all made this sound like it requires A LOT more than simply drag and drop and a restart. Could someone be as so kind as to maybe write or even make a small youtube video of a step by step on how to install this? I would happily donate to the cause.

 

Hi Jonty, will we see a MySQL version ?

 

MySQL will be supported soon, I am busy on work I'm being paid for but will continue updating this when I have the time to work for free.

 

Ok nice, thanks for the answer !

 

Love the idea of this plugin! I can't wait to use it but coming from a hosted environment MSSQL is the hang up. Anyone know of a provider that can offer you this type of DB?

They all carry MySQL due to Altis Life and just about any other game that needs a DB...

 

I used a $20 VPS from XZNetworks.com for my MSSQL, however that company has recently changed ownership, not sure how good/reliable it is now.