Survival Essentials

Jonty submitted a new resource:

Survival Essentials - All-in-one survival server essentials

Read more about this resource...

 

Wow!

This is an awesome plugin. I can't wait to put it on my server and see what I can do.

Thanks!

 

Cheers. More features will show up, and once I'm done with the major features, I'll probably shift to mysql instead of mssql. The reason I haven't done this yet is I'm too lazy to convert my own DB

 

Nice job!
Will have a look at the plugin and see what you've come up with.
Small bug : You can still harvest resources off the indestructible blocks in protected zones.

 

Yeah I am aware of that bug but I am unsure how to fix it, though I haven't had much of a look in the direction of fixing it. Are you able to shed any light?

By the way, I would like to point out that it's possible to do some pretty cool things with this plugin, not just on your server but a full web-based user control panel or donation panel, anything really is possible. A basic example is shown here: http://amprok.com/

 

I've got something in the works which will fix it.
I'll keep you posted.
If I can get onto it at lunch today, I'm hoping will have it done by close of play!
[DOUBLEPOST=1436863981][/DOUBLEPOST]Loving the sound of the web-based stuff, too by the way.
It's definitely something I'll be having a dig around in your code for!

It's just a shame that RoK is hemmoraging (sp?) players at the moment... :-/

 

Ya it is a shame. Once we get more hooks though we'll be able to change up the game a lot and make it more attractive to return players as well as newbies.

There is no API needed in my plugin to pull data to a website, as everything is stored in a db. All you need is php_sqlsrv.dll installed on your PHP setup. Once I switch to MySQL, I'll most likely release a PHP Framework for working with this plugin - sqlsrv is dirty and procedural
[DOUBLEPOST=1436864394][/DOUBLEPOST]I just moved all the Announcements to DB, also supporting colours (struct= message(varchar 200), colour(varchar 10))

 

Jonty updated Survival Essentials with a new update entry:

2.0.1 - More database changes, code cleanup

 

Hay looks great, nice to see new plugins, really would like to have this on my seerver, hosted by blackbox, im looking into you set instructions and cant get it to work im on ROK permissions, and it does not recognise the command, you also mention set up data base connection unsure how i would do this, really sry to sound basic, but iv inly just started getting into the Oxide plugins last week or so, so if you could help, could you explain in simple terms maybe screen shot of what i need to alter, great work would love to see this running on my server. just a question could i just have the league tables activated top killer richest person sounds good. hoope you can help me. good stuff

 

You must have a MSSQL server set up on a VPS or Dedicated Server in order to use this, and then you need to modify this part of the plugin:



It was never intended to be used on servers hosted on pay-per-slot rentals, but it can be done as long as you have a VPS or Dedi available to use.

 

ok i just assumed thatwas able to use this as i have all other plugins, access to ftp, but thats any way for quick response shame, really liked it pfft,

 

I use a VPS from https://xznetworks.com/ with 2GB RAM to host the MSSQL server. It's pretty cheap and you can do a lot of cool things with a SQL backend.

 

I have a server and website hosted @gameserver.com. It does come with mssql database on the Cpanel of the website. I don't have much experience with MSSQL. Every time I try to import the .sql files that you posted it gives me error messages. Is there a way you could help me install it on what I have going on right now? or see if its even possible for me with what I have atm?

 

What errors are you getting?

Are you sure you're not mistaking MSSQL for MYSQL?

 

What version of MSSQL are you using, Jonty?

 

I would love you to death if you made some sort of duel plug-in separately because i run a pvp server that want's more to pvp for, but doesn't want an in-game store.

 

Cant wait for the MySQL version .... in regards to a hosted environment MYSQL will likely be compatible.. Especially if they already host ARMA 3 servers (Altis Life)

 

I use Microsoft SQL Server 2008 R2.

I could always make it a possibility to disable the in-game store, so you can make use of the other parts of the plugin? Much like I've done with DeCresting.

You could always just add PVP related items to your in-game store for relatively cheap prices.

In theory it would be possible (if you store your Altis Life users by their Steam Id) to keep a global currency across all of your gaming servers, not just reign of kings, and display all of that information on a website and within the servers you own all in 1 database.

At the moment I run 2 RoK servers, both of which run a variant of this plugin, communicate with the same db, and use the same currency system on both servers giving players the opportunity to earn on both servers and spend on whichever one they like. You could do this easily w/ Altis Life.

 

Hi, thanks for sharing this mod, Im having an issue with the sql import, this is the error for the ROK.sql

Error
SQL query:


/*
Navicat SQL Server Data Transfer

Source Server : asdasd
Source Server Version : 105000
Source Host : 127.0.0.1:1433
Source Database : rok
Source Schema : dbo

Target Server Type : SQL Server
Target Server Version : 105000
File Encoding : 65001

Date: 2015-07-13 05:52:03
*/


-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE [dbo].[admins]
GO
CREATE TABLE [dbo].[admins] (
[steamid] bigint NULL
)


GO

-- ----------------------------
-- Table structure for marketplace
-- ----------------------------
DROP TABLE [dbo].[marketplace]
GO
CREATE TABLE [dbo].[marketplace] (
[name] varchar(50) NOT NULL ,
[price_buy] int NULL ,
[price_sell] int NULL ,
[amount] int NULL ,
[id] int NULL
)


GO

-- ----------------------------
-- Table structure for players
-- ----------------------------
DROP TABLE [dbo].[players]
GO
CREATE TABLE [dbo].[players] ([...]

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[dbo].[admins]
GO
CREATE TABLE [dbo].[admins] (
[steamid] bigint NULL
)

' at line 21