Survival Essentials

They are at this link scroll down. 4kgamers

 

Anyone can help me i put the command looc in the console it gives me the coordinates of x and z, next i put this coord in the command above protectedzones in .cs and it doesnt work, please i need help i need a way to protect blocks and stop building in determinated area

 

Jonty updated Survival Essentials with a new update entry:

2.2.0

 

Jonty updated Survival Essentials with a new update entry:

2.2.0b

 

Jonty updated Survival Essentials with a new update entry:

2.2.1

 

Just so you know @Jonty you misspelled the file name you up loaded:

Previous version:
SurvivalEssentials.cs

Current Version:
SurvivalEssenstials.cs (Added an extra S after the N)

 

Jonty updated Survival Essentials with a new update entry:

2.2.1

 

Download link is broken for the sql import

 

Please reup or post structure of last mysql please anyone.

Edit:
Here is the MySQL Structure. It's works for me but don't know is all correctly type set. ;-)

Code:

CREATE TABLE `admins` (
  `steamid` varchar(64) NOT NULL,
  PRIMARY KEY (`steamid`)
);CREATE TABLE `announcements` (
  `message` varchar(255) NOT NULL,
  `colour` varchar(12) NOT NULL DEFAULT '-',
  PRIMARY KEY (`message`)
);CREATE TABLE `marketplace` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `price_buy` int(11) NOT NULL DEFAULT '2',
  `price_sell` int(11) NOT NULL DEFAULT '1',
  `amount` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
);CREATE TABLE `players` (
  `id` bigint(13) NOT NULL,
  `originalname` varchar(32) DEFAULT NULL,
  `currentname` varchar(32) DEFAULT NULL,
  `currency` bigint(13) NOT NULL DEFAULT '0',
  `has_protection` int(2) NOT NULL DEFAULT '1',
  `protection_left` bigint(13) NOT NULL DEFAULT '3600',
  `warnings` int(11) NOT NULL DEFAULT '0',
  `kills` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
);CREATE TABLE `plugin_settings` (
  `disable_decresting` int(11) NOT NULL DEFAULT '0',
  `announce_interval` int(11) NOT NULL DEFAULT '600',
  `currency_interval` int(11) NOT NULL DEFAULT '3600',
  `currency_interval_amount` int(11) NOT NULL DEFAULT '10'
);CREATE TABLE `rules` (
  `rule` varchar(255) NOT NULL
);

 

Question on adding records to the 'marketplace' table...

What exactly do you put in the [name] field? The friendly name 'Iron Crest' or the blueprint name 'IronCrest' (no spaces) or an underscored name 'Iron_Crest'? I assume that the [ID] field DOES NOT have to match the in-game IDs.

Problem: I've imported 129 items into the marketplace table ... all fields are populated ... I've restarted the serve and I've reloaded the marketplace with the /modreload marketplace command but /listitems buy nor /listitems sell list any items nor do the /buy 1 item or /sell 1 item commands work. All other commands & lists (i.e. /rules, /ip, etc.) are working correctly.

 

On me works the friendly name with space. The Id field in the Table is only for order.

 

How can I disable crest protect and give command protection? And how can I reduce time of spawn protection? Thank you.

 

jonty how do i use the protected area command need it for an arena

 

Get your current coordinates and add them to the dictionary like the example that (pretty sure) is provided in the source code.
[DOUBLEPOST=1503624372][/DOUBLEPOST]

By modifying the source, I believe. It's been a long time since I made this and no longer really remember where thing are, or have any interest in updating it to make it easier on people who can't edit a .cs file. It should be relatively easy to change with a little reading of the source