ROK.SQL

_____________________________________________________________________________________________________________________________________________________

/*
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] (
[id] bigint NOT NULL ,
[currency] int NULL DEFAULT ((100)) ,
[originalname] varchar(60) NULL ,
[currentname] varchar(60) NULL ,
[has_protection] varchar(1) NULL DEFAULT ('0') ,
[protection_left] int NULL DEFAULT ('0') ,
[played_rp] varchar(1) NULL DEFAULT ('0') ,
[rp_builder] varchar(1) NULL DEFAULT ('0') ,
[rp_newspawn] varchar(1) NULL DEFAULT ('1') ,
[warnings] int NULL ,
[kills] int NULL 
)


GO


/*
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-14 04:35:09
*/


-- ----------------------------
-- Table structure for announcements
-- ----------------------------
DROP TABLE [dbo].[announcements]
GO
CREATE TABLE [dbo].[announcements] (
[message] varchar(200) NULL ,
[colour] varchar(10) NULL 
)


GO

-- ----------------------------
-- Records of announcements
-- ----------------------------
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'You can view your account balance by typing /balance', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'You can place bounties on other players by typing /setbounty <amount> <playername>', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'We have an in-game shop! Type /listitems to view what''s for sale, and /buy <amount> <itemname> to purchase!', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'Your account is automatically given 150 Denars for each half an hour you spend online!', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'Have you spotted a cheater? Let one of our staff know!', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'If you would like to see a plugin on our server, simply ask us and we will do our best to oblige you!', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'Join us on TS3 at ts.amprok.com!', N'Yellow')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'If you need help with our plugins, type /modhelp', N'Yellow')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'Check the rules by typing /rules to avoid your account being admin jailed', N'Red')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'You can challenge players to a duel by using /duel', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'You are given 1 Gold Denar for every 5 blocks you place', N'White')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'You can now sell items to the Store for profit with /sell', N'Yellow')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'Check out our creative server at creative.amprok.com', N'Yellow')
GO
GO
INSERT INTO [dbo].[announcements] ([message], [colour]) VALUES (N'We now have leaderboards which you can access with /leaderboards', N'Yellow')
GO
GO

-- ----------------------------
-- Table structure for plugin_settings
-- ----------------------------
DROP TABLE [dbo].[plugin_settings]
GO
CREATE TABLE [dbo].[plugin_settings] (
[disable_decresting] int NULL ,
[announce_interval] int NULL ,
[currency_interval] int NULL ,
[currency_interval_amount] int NULL 
)


GO

-- ----------------------------
-- Records of plugin_settings
-- ----------------------------
INSERT INTO [dbo].[plugin_settings] ([disable_decresting], [announce_interval], [currency_interval], [currency_interval_amount]) VALUES (N'1', N'300', N'1800', N'150')
GO
GO

-- ----------------------------
-- Table structure for rules
-- ----------------------------
DROP TABLE [dbo].[rules]
GO
CREATE TABLE [dbo].[rules] (
[rule] varchar(100) NULL 
)


GO

-- ----------------------------
-- Records of rules
-- ----------------------------
INSERT INTO [dbo].[rules] ([rule]) VALUES (N'Do not rebuild blocks while being seiged. Please use the repair hammer instead.')
GO
GO
INSERT INTO [dbo].[rules] ([rule]) VALUES (N'Do not siege offline players')
GO
GO
INSERT INTO [dbo].[rules] ([rule]) VALUES (N'Do not mass KOS/Kill on Sight')
GO
GO
INSERT INTO [dbo].[rules] ([rule]) VALUES (N'Do not create sleeper prisons')
GO
GO
INSERT INTO [dbo].[rules] ([rule]) VALUES (N'Do not destroy beds in other players bases. Stray beds are fine.')
GO
GO

 

 

_____________________________________________________________________________________________________________________________________________________

Marketplace.SQL

_____________________________________________________________________________________________________________________________________________________

/*
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:19
*/


-- ----------------------------
-- 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

-- ----------------------------
-- Records of marketplace
-- ----------------------------
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Iron', N'3', N'2', N'4429', N'1')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Wood', N'1', N'1', N'9000', N'2')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Stone', N'2', N'1', N'0', N'3')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Oil', N'8', N'4', N'11765', N'4')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Flax', N'3', N'1', N'5712', N'5')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Flowers', N'3', N'1', N'900', N'6')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Bones', N'2', N'1', N'1000', N'7')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Blood', N'5', N'2', N'0', N'8')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Potion of Antidote', N'250', N'75', N'999', N'16')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Potion of Appearance', N'500', N'150', N'1001', N'17')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Stone Hatchet', N'50', N'25', N'1000', N'18')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Stone Pickaxe', N'50', N'25', N'1000', N'19')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Feather', N'2', N'1', N'1000', N'10')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Clay', N'1', N'1', N'4000', N'9')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Leather Crest', N'750', N'300', N'10', N'11')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Iron Crest', N'1500', N'600', N'10', N'12')
GO
GO
INSERT INTO [dbo].[marketplace] ([name], [price_buy], [price_sell], [amount], [id]) VALUES (N'Steel Crest', N'4000', N'1200', N'5', N'13')
GO
GO