Mostrando postagens classificadas por relevância para a consulta Rust Experimental. Ordenar por data Mostrar todas as postagens
Mostrando postagens classificadas por relevância para a consulta Rust Experimental. Ordenar por data Mostrar todas as postagens

domingo, 20 de dezembro de 2015

Rust Experimental - Start Protection

What is Start Protection?
Start Protection is a simple plugin that gives new users a certain amount of time to play without stressing about being killed by other players, it also prevents them from attacking other players. Players can still be killed by the environment, animals and self-inflicted injuries. Only PVP is disabled.

Why is this useful?
Rust is full of griefers, I often read server logs and see several players rage-quit after only playing a few minutes after being gunned down by other players. This gives them a chance to move around a little and set up shop.

Default Configuration:
Code (Text):

{
  "bHelicopterProtection": true,
  "bProtectionEnabled": true,
  "bSleeperProtection": true,
  "iAuthLevel": 2,
  "iInactiveDays": 0.25,
  "iPunishment": 300,
  "iTime": 1800,
  "iUpdateTimerInterval": 10
}
 
The default time is "1800", which equates to 30 minutes. I found this was a fair time.

Punishment time is "300" by default, which equates to 5 minutes. This is the time that will be revoked if the player tries to PVP while in SP mode.

Ingame commands:
/sp (Will display all the sub-commands)

Bugs:
None yet, but I'm sure we'll find some.
Download 
Download 


 

Rust Experimental - Fishing

Version 1.0.6 now uploaded. All current overview items are included.

This plugin allows all players to use Spear, Bow or Crossbow to fish the waters of Rust. You can catch fish in Rivers or Open waters. Each has its own fish type.



How to Fish:
First, Head off and find some water. You need to be within a few meters or even standing in it. Take your Spear and jab the water floor and then you have a chance to haul in a fish. (aka...raw chicken). You can also use your Bow or Crossbow to get near the water and shoot at it.

Hapis Island RazorJaw - found in rivers.
Savis Island Swordfish - found in open water, lakes and oceans.
Craggy Island Dorkfish - may or may not exist...no one knows.

actual raw catch will change to something else. chicken is just easy for now.

Modifers to Chance to Catch fish:
Using Wood Spear or Bow give player default chance to catch fish.
+ Bonus if using a Stone Spear or Crossbow
+ Bonus if wearing Boonie cap

Coming Soon or Ideas :
- Permissions to allow who can fish.
- Config file values for many things.
- Find fishing Hotspots via onscreen notification.
- chances to pull up snake or gator.. can hurt player or get poisoned.
- using mining quarry placed in rivers as a "fish wheel"...maybe?
- Time of day will effect chance of fish.
- Having someone play guitar by a fire will increase area fish rates.
Download

Download

Download

segunda-feira, 21 de dezembro de 2015

Rust Eperimental - ZLevels Remastered

This plugin, is remastered version of ZLevels plugin. It was long time since it was updated, and I had many crazy ideas about it, so I decided, that i should develop it on my own, taking ZLevels as base, because I really loved the work plugin developer did there.

My plugin includes 4 skills:
  • Mining
  • Woodcutting
  • Skinning
  • Crafting

    Any of them can be disabled via configuration file.
All of those skills works kinda the same like in ZLevels, I've just introduced new skill called Crafting, which boosts your crafting speed depending on your Crafting skill level, to increase it, you must craft things obviously. The more time you spend on crafting, the more XP you get. Also when player reaches a point, where he has 100% faster crafting, all his items are instant crafted, if you craft more than 10 items at once, then items are MagicCrafted, I've loved how this plugin solved that huge queue of "instantly crafted" items, by simple creating them from plugin.

I rewritten XP loss formula, so now you loose percentage of your current level XP instead of some fixed amount if you are level 10 and have 80% exp, and you should loose 60% exp on death, that means you'll be level 10 and 20% experience.
Every hour spent alive, you'll loss less experience when killed. For example if you set XPPercentToLoose to 100%, after 5 hours you'll only loose 50% instead of 100%, hours counts even when you are offline. There is also 10 mins grace period, that when you die within first 10 mins you don't loose any experience. You can check how much XP you'll loose by typing /stats.

The biggest thing I'm proud of that I've implemented user interface, which looks like this:
qAqgzWh.png
This makes you to avoid typing /stats every second and check how much XP is left till you level up and etc.

I also made this plugin to save stats into MySQL database, but it can also be saved into game files, just like the old plugin, since I always used MySQL, i did some quick rewriting to make usable for guys, who doesn't have MySQL server.

I'll write more information later, when i'll get some feedback and questions.

Thanks to people who helped me testing:
  • leeter (Owner of Rusty Dallas server)
  • meatcircus (Owner of 100PlaneAirdrops server)
  • killsontact
Incompatible plugins:

Current commands are:
  • /stats - displays stats.
  • /statsui - toggle's stats interface.
  • /topskills - display's top player skills (only working if you are using MySQL)
  • /statinfo [Woodcutting/Crafting/Mining/ Skinning] - Displays information about certain skill, including server configuration.
You can disable certain skills, by setting LevelCaps value for that skill to -1.

Example of configuration file:

Code (Text):
{
  "CraftingDetails": {
    "PercentFasterPerLevel": 5,
    "TimeSpent": 1,
    "XPPerTimeSpent": 3
  },
  "dbConnection": {
    "Database": "db",
    "GameProtocol": 1336,
    "Host": "127.0.0.1",
    "Password": "password",
    "Port": 3306,
    "UseMySQL": false,
    "Username": "user"
  },
  "LevelCaps": {
    "C": 20,
    "M": 0,
    "S": 0,
    "WC": 0
  },
  "Messages": {
    "CSkill": "Crafting",
    "LevelUpText": "{0} Level up\nLevel: {1} (+{4}% bonus) \nXP: {2}/{3}",
    "MSkill": "Mining",
    "SSkill": "Skinning",
    "StatsHeadline": "Level stats (/statinfo [statname] - To get more information about skill)",
    "StatsText": "-{0}\nLevel: {1} (+{4}% bonus) \nXP: {2}/{3} [{5}].\n<color=red>-{6} XP loose on death.</color>",
    "WCSkill": "Woodcutting"
  },
  "PercentLostOnDeath": {
    "C": 50,
    "M": 100,
    "S": 50,
    "WC": 100
  },
  "PointsPerHit": {
    "M": 30,
    "S": 30,
    "WC": 30
  },
  "ResourcePerLevelMultiplier": {
    "M": 20.0,
    "S": 20.0,
    "WC": 20.0
  }
}
If you are going to use MySQL here's a table this plugin use:
Code (Text):

CREATE TABLE `RPG_User` (
  `UserID` bigint(20) NOT NULL,
  `Name` varchar(50) DEFAULT NULL,
  `WCLevel` int(11) DEFAULT NULL,
  `WCPoints` bigint(20) DEFAULT NULL,
  `MLevel` int(11) DEFAULT NULL,
  `MPoints` bigint(20) DEFAULT NULL,
  `SLevel` int(11) DEFAULT NULL,
  `SPoints` bigint(20) DEFAULT NULL,
  `CLevel` int(11) DEFAULT NULL,
  `CPoints` bigint(20) DEFAULT NULL,
  `LastDeath` int(11) DEFAULT NULL,
  `LastLoginDate` int(11) DEFAULT NULL,
  `XPMultiplier` int(11) NOT NULL DEFAULT '100',
  PRIMARY KEY (`UserID`),
  UNIQUE KEY `UserID_UNIQUE` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


 


domingo, 20 de dezembro de 2015

Rust Experimental - Player Database

Este plugin é inútil sozinho
Eu vou estar portando plugins para usar este banco de dados leve após algumas provações

LER PARA INSTALAR:
in: server/serveridentity/oxide/data
crie uma pasta chamada: playerdatabase

Como redefinir os dados:
1) Desligue o servidor
2) apagar: o oxide/data/PlayerDatabase.json
3) esvaziar a pasta: playerdatabase
4) reiniciar o servidor
Download



Rust Experimental - Event Battlefield

Required Dependencies:
http://oxidemod.org/plugins/event-manager.740/
http://oxidemod.org/plugins/zones-manager.739/
http://oxidemod.org/plugins/kits.668/

Battlefield FREE FOR ALL!
This plugin can be used alone with Event Manager, or with any other plugins.
With Event Manager you can set auto events and make it that the battlefield lasts for 30mins, then goes to another event type (before coming back again to this event at some point)

Special Player Commands:
- /ground XX => vote for a new battlefield ground
- /weapon XX => vote for a new weapon kit

Special Admin Commands:
- /ground XX => Set a new battlefield ground
- /weapon XX => Set a new weapon kit

Creating Grounds:
1) Create 1 ground or more
2) You will need to create your zones on your own, as i can't handle multiple zones per plugin at the moment (wasn't made like that ...)
So i recommend knowing how to use Zone Manager!!
3) in Battlefield - Grounds, use the same way i used to create the longrange ground and shortrange ground. You will need "spawnfile" and "kits".
spawnfile is where all the spawns are stored for the battle ground
kits are all the kits that you will allow the players to use (/vote for). All players will have the SAME kits!
I recommend using: JSONLint - The JSON Validator. to make sure you didn't fuck up the configs

Zone Management:
In the grounds list you must have a "zone" set to the respective battlefield zone.
Exemple for the shortrange one:
- /zone_add BattlefieldGround1
- /zone_edit BattlefieldGround1
- /zone radius 100 undestr true nobuild true nodeploy true nocorpse true nowounded true autolights true
Of course the zone can be named as you wish as long as the names match in the config and zone.

Default Config:
Code (Text):

{
  "Battlefield - Default Ground": "shortrange",
  "Battlefield - Default Weapon Kit": "assault",
  "Battlefield - Event - Name": "Battlefield",
  "Battlefield - Grounds": {
    "longrange": {
      "kits": [
        "sniper",
        "pistols"
      ],
      "spawnfile": "longrangespawnfile",
      "zone": "BattlefieldGround2"
    },
    "shortrange": {
      "kits": [
        "pistols",
        "assault"
      ],
      "spawnfile": "shortrangespawnfile",
      "zone": "BattlefieldGround1"
    }
  },
  "Battlefield - Start - Health": 100.0,
  "Battlefield - Vote - % needed to win": 60,
  "Messages - Error - Not joined": "You must be in the battlefield to vote",
  "Messages - Error - Not Selected": "Battlefield isn't currently launched",
  "Messages - Error - Not Started": "You need to wait for the Battlefield to be started to use this command.",
  "Messages - Error - Vote - Ground Already This One": "The current ground is already {0}.",
  "Messages - Error - Vote - Ground Doesnt Exist": "This battlefield ground doesn't exist.",
  "Messages - Error - Vote - Weapon Already This One": "The current weapon is already {0}.",
  "Messages - Error - Vote - Weapon Doesnt Exist": "This weapon kits doesn't exist in this battleground.",
  "Messages - Kill": "{0} killed {2}. ({1} kills)",
  "Messages - Open Broadcast": "In Battlefield, it's a free for all, the goal is to kill as many players as possible!",
  "Messages - Vote - Grounds - New": "︻┳═一 New ground is now: {0}",
  "Messages - Vote - Grounds - Show Avaible List": "{0} - {1} votes",
  "Messages - Vote - Grounds - Show Avaible Title": "︻┳═一 Battlefield Grounds Avaible 一═┳︻ Votes required for an item: {0}",
  "Messages - Vote - Grounds - Show Votes": "┳═一 {0} has {1} votes",
  "Messages - Vote - Grounds - Voted": "You have voted for the ground: {0}.",
  "Messages - Vote - Weapons - New": "︻┳═一 New weapon kit is now: {0}",
  "Messages - Vote - Weapons - Show Avaible List": "{0} - {1} votes",
  "Messages - Vote - Weapons - Show Avaible Title": "︻┳═一 Avaible Weapon Kits For Current Ground 一═┳︻  Votes required for an item: {0}",
  "Messages - Vote - Weapons - Show Votes": "┳═一 {0} has {1} votes",
  "Messages - Vote - Weapons - Voted": "︻┳═一 You have voted for the weapon: {0}.",
  "Tokens - Per Kill": 1
}
This is the first version, i will add console commands later on.
And fixes also ^^

Download

Rust Experimental - FlameThrower

This plugin is mostly for fun. Use as you wish, change it, make it better, fix it.. whatever. its for fun :) at least until the official version is out.

Allows authorized players to use the Thompson as a makeshift flamethrower. Flames and Blast heat damage shoot out approx. to 12 meters, then flames fall to ground and does damage over time. Flames will start small secondary fires that will last longer.



Fuel:
uses 5 Low grade fuel and 5 crude oil every time you hit the use key.
This can be adjusted in Config file.

Permissions:
canuseflamethrower - grants access to use flamethrower

Code (Text):
oxide.grant <group|user> <name|id> canuseflamethrower

Example: To allow the group player to use it. (all players)
oxide.grant group player canuseflamethrower

Example 2 : To just allow a person to use it:
oxide.grant user "colon blow" canuseflamethrower
Config: (Default numbers below)

Code (Text):
{
  "AmountRequired-CrudeOil": 5,
  "AmountRequired-LowGradeFuel": 5,
  "BlastDamageEffectedByProtectionValue": true,
  "BlastDamageRadius": 1.0,
  "BlastDamagetoBuilding": 10.0,
  "BlastDamagetoNPC": 10.0,
  "BlastDamagetoPlayer": 10.0,
  "EnableChanceOfWeaponFailure": false,
  "FlamethrowerReloadTime": 4.0,
  "GroundFlameDamagePerSecond": 2.0,
  "GroundFlameDamageRadius": 1.0,
  "GroundFlameMaximumDuration": 10.0,
  "GroundFlameMinimumDuration": 10.0,
  "GroundFlameTimetoSpread": 8.0
}
Configuration Files Explained
"AmountRequired-CrudeOil": 5, - Amount of Crude Oil needed per shot.
"AmountRequired-LowGradeFuel": 5, - Amount of Low Grade Fuel needed per shot.
"BlastDamageEffectedByProtectionValue": true, - All items have resistance against damage types, setting to false allow Initial Flame Blast damage to deal 100% of value no matter what.
"BlastDamageRadius": 1.0, - Initial Flame Blast has a quick damage cone. this is the radius from the flame shot it effects as it goes out to approx. 12 meters.
"BlastDamagetoBuilding": 10.0, - Intital Flame Blast effects Buildings this amount per hit.
"BlastDamagetoNPC": 10.0, - Intital Flame Blast effects NPC's this amount per hit.
"BlastDamagetoPlayer": 10.0, - Intital Flame Blast effects Players this amount per hit.
"EnableChanceOfWeaponFailure": false, - Setting to True, will give your weapon a slight chance to explode on use.
"FlamethrowerReloadTime": 4.0, - Amount of time need to pull trigger again after using.
"GroundFlameDamagePerSecond": 2.0, - Flames that drop on ground, this is how much DPS it does to things.
"GroundFlameDamageRadius": 1.0, - Flames that drop on ground, this is the radius amount the DPS effects.
"GroundFlameMaximumDuration": 10.0, - Once Flames are out and on ground, this is the minimum time they will stay in world. Setting to lower than max, flames will randomly despawn starting at this time.
"GroundFlameMinimumDuration": 10.0, - Once Flames are out and on ground, this is the maximum time they will stay in world.
"GroundFlameTimetoSpread": 8.0 - Once Flames are on ground, they have chance to 'spread' themselves starting after this many seconds. setting to higher than time max will prevent this.

Use:
Equip a Thompson gun, have the required fuel in inventory, make sure the Thompson is highlighted in belt, then press the use key (the E key).

Note: testing with 20 plus players at a time do not seem to have a big performance hit. But of course if everyone is spamming the use key it will cause framerate degradation.

thanks to the other plugin developers for there great coding inspiration 
Download
Download
Download
Download

Rust Experimental - Enhanced Hammer

Descrição: Você também odeio esse botão direito do mouse e clicar coisa à esquerda, quando a base de atualização de galhos para STONE? Bem, não mais.

Este plugin se livrar do que, por isso, você só precisa de clique direito e atualizar uma parede, e ele alterna para o modo de atualização, então você pode simplesmente manter o botão esquerdo em todas as paredes, e atualiza-los automaticamente para a fase que você escolheu manualmente . Se você quiser mudar para o modo martelo padrão, você deve apenas à esquerda, clique mesma camada (ou superior) parede novamente.
Ele ainda requer materiais embora, por isso não pode ser abusado.

Comandos para jogadores (sublinhadas são padrões):

/eh [mostrar / ocultar] - Oculta ou mostra atual estado martelo como ícone.
/eh [ativar / desativar] - Ativa ou desativa a funcionalidade do plugin para o usuário que tenha digitado este comando.
/eh ajuda - Apresenta a lista de todos os comandos possíveis.
/eh temporizador [0 / segundo] - Tempo em que o martelo vai voltar para o modo padrão.
/eh msgs [mostrar / ocultar] - Exibir mensagens em bate-papo sobre o estado martelo.

Download


segunda-feira, 21 de dezembro de 2015

Rust Experimental - Hunt RPG

This is a RPG system in development, I'm releasing it now to get feedback.

Currently the RPG is composed of:
  • Levels
  • Stats Points:
    • Agility : Increases your change to dodge attacks
    • Strength : Increases you Health
    • Intelligence : Decreases the crafting time
  • Skill Points
  • Skills
    • Lumberjack : Increases the gather rate for wood
    • Miner : Increases the gather rate for ores and stones
    • Hunter : Increases the gather rate from animals resources
    • Researcher: Allow you to research items you have to generate the Blueprint, each skill point unlocks new types of items you can research and decreases the cooldown.
    • Blacksmith - Increases the melting rate, every time a furnace fuel is consumed your furnace got a chance to produce X more result (Ex: metal frag). The x depends on skill level as well as the chance %.
    • BlinkToArrow - You can blink to where your arrow fell. Each skillpoint decreases the cooldown.
    • Gatherer - You can gather more resources from pickup.
    • Taming - You can tame animals, thanks to @Bombardir. Level 1 allows wolf, Level 2 allows bear.
      • If the NpcController plugin isnt available the skill will be disabled.
You get exp when you gather stuff or build/upgrade buildings.
You get 1 stat point automatically assigned to each attribute when you level up, and 3 to distribute.
You get 1 skill point when you level up to distribute.

There is a in game help but is not 100% done yet, but the basics are.

To see the list of commands type /hunt or /h


Each skill requires a level to get, some specific stats amounts, and a number of skillpoints to upgrade. (Still to be balanced)
Ex: Skill Researcher: Requiers level 30, 45 int, and consumes 7 skillpoints to levelup.
Also there is a max level for the skills.
Default max profile level for is 200.

[CUSTOMIZATION]
It's available for a lot of stuff, soon I'll explain how to customize everything that's is possible to do so.

[ADMIN (CHAT) COMMANDS]
hunt.lvlup <playername> <desired_level> or
/hunt lvlup <playername(opitional)> <desired_level> :
will level the admin character level or the specified player character, will give stats points and skill points too.
hunt.saverpg : save data
hunt.resetrpg : reset data
hunt.statreset <playername>
hunt.skillreset <playername>
hunt.genxptable <BaseXP(383)> <LevelMultiplier(1.105)> <LevelModule(10)> <ModuleReducer(0.005)>

Note: If you dont have permissions nothing will be shown for now.

[INSTALLATION]
Just copy the .cs file to the plugins folder of the server.

There is a config file and a data file, for now I recommend not changing then.

[COMPATIBILITY]
I suggest that you dont use plugins that:
  • change the gather rate
  • change crafting rate
  • allows you to buy blueprints
It will probably work, but the RPG itself will make almost no sense.

[IMPORTANT]
Since I'm going to add plenty more features there may be needed to reset the RPG, so dont get to attached.

Right now it will save profiles when server saves or player levels up(not via admin chat command(/h lvlup <level>)).
You can manually save it via console command: hunt.saverpg

[FORKING]
Please
, if you want to help with the plugin, make a push request at:
-- currently not available --
I'll check your code and probably accept the request, if that happens I can give you my contact information so we can work together.

You are welcome to fork my code, but I would really like if you keep me in the credits. I spent a lot of time researching the assembly, not for what there is in the extension now, but for features that I wanted to do, so if you could do that, you are more than welcome to fork it.

Download

Download

Download



domingo, 20 de dezembro de 2015

Rust Experimental - Enhanced Ban System

Descrição: Este plugin ajuda a lidar com as suas proibições. Ele lhe dá a possebility para proibir por nome, SteamID ou por IP e considera todos os três quando alguém proibiu tentando se juntar ao servidor. Assim, mesmo se alguém usa outra conta de vapor seu IP ainda será bloqueado.

Uso

Bate-papo Comandos:

/ban <nome / Steamid / IP> <razão opcional> <tempo em segundos opcional>
Se é dado nenhum momento a proibição é permanente.
Exemplos:
/ban Domestos de noob - irá banir permanentemente Domestos
/ban Domestos Noob 1200 - vai proibir Domestos por 20 minutos
/ban Domestos Noob 10800 - vai proibir Domestos por 3 horas
/ban Domestos Noob 864000 - vai proibir Domestos por 10 dias

/unban <nome / Steamid / IP> - obviamente,
/kick <nome / Steamid / IP> <reason> - faz o que diz
/checkban <nome / SteamID / ip>
Comandos do console:
A sintaxe é exatamente o mesmo como os comandos de bate-papo!
player.ban <nome / Steamid / IP> <razão> <tempo [m | h | d] opcional>
player.unban <nome / Steamid / IP>
player.kick <nome / Steamid / IP>
player.banlist
player.checkban <nome / SteamID / ip>

Permissões:
A configuração oferece opções para definir permissões diferentes para cada comando que você possa controlar qual o usuário pode usar que comanda.
As permissões padrão são:
proibir e desbanir - "enhancedbansystem.ban"
chutar - "enhancedbansystem.kick"
bancheck - "enhancedbansystem.bancheck"

Download

Rust Experimental - Structure Whitelist

This is a simple plugin to block specific building grades, simply change true to false and the grade will be disabled.

Default Configuration:
Code (Text):

{
  "Grade": {
    "Metal": true,
    "Stone": true,
    "TopTier": true,
    "Wood": true
  }
}
 

Rust Experimental - SQLStats


This plugin collects various data from in game, and saves it to MySQL database. This allows server owners to have nice statistics of whats happening in their server, and also allows them to display those statistics on their website.

Donations would motivate me to do few more plugins: SQLRanks and SQLAchiements. Which would allow you to display such details in game using GUI. So even beginner server owners could make use of SQLStats plugin.

Plugin logs these events (so far):
  • Player login [Table: stats_player]

  • Player animal kills [Table: stats_player_animal_kill]

  • Player crafted items list and count for each day for each player. [Table: stats_player_craft_item]

  • Player death information for each day. Statistics such as how many times player died from cold/bullet/fall/etc on 2015-12-10 for example. [Table: stats_player_death]

  • Statistics about player destroyed buildings. [Table: stats_player_destroy_building]

  • Statistics about player bullet shots for each day. [Table: stats_player_fire_bullet]

  • Statistic about resources player gathered certain day. [Table: stats_player_gather_resource]

  • Statistics about player kills in PvP. [Table: stats_player_kill]

  • Statistic about player placed building objects. [Table: stats_player_place_building]

  • Statistic about player placed deployable objects(such as Campfires, Auto Turrets, etc). [Table:stats_player_place_deployable]

Here is config file for the plugin:
Code (Text):
{
  "dbConnection": {
    "Database": "RustDB",
    "Host": "127.0.0.1",
    "Password": "RustPW",
    "Port": 3306,
    "Username": "RustUSR"
  }
Here is SQL structure which is used in my plugin:
Code (Text):
CREATE TABLE `stats_player` (
  `id` bigint(20) NOT NULL,
  `name` varchar(256) CHARACTER SET utf8 NOT NULL,
  `online_seconds` bigint(20) NOT NULL DEFAULT '0',
  `ip` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `online` bit(1) NOT NULL DEFAULT b'0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `stats_player_animal_kill` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `animal` varchar(32) NOT NULL,
  `date` datetime NOT NULL,
  `distance` int(11) DEFAULT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_craft_item` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `item` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerItemDate` (`player`,`item`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_death` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `cause` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerCauseDate` (`player`,`cause`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_destroy_building` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `building` varchar(128) NOT NULL,
  `date` datetime NOT NULL,
  `tier` varchar(20) DEFAULT NULL,
  `weapon` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_fire_bullet` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `bullet` varchar(32) NOT NULL,
  `weapon` varchar(32) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerBulletWeaponDate` (`player`,`bullet`,`weapon`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_gather_resource` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `resource` varchar(32) NOT NULL,
  `count` bigint(20) NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerResourceCountDate` (`player`,`resource`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_kill` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `killer` bigint(20) NOT NULL,
  `victim` bigint(20) NOT NULL,
  `weapon` varchar(32) NOT NULL,
  `bodypart` varchar(2000) NOT NULL DEFAULT '',
  `date` datetime NOT NULL,
  `distance` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_place_building` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `building` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerBuildingDate` (`player`,`building`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

CREATE TABLE `stats_player_place_deployable` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `player` bigint(20) NOT NULL,
  `deployable` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `PlayerDeployableDate` (`player`,`deployable`,`date`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
Download



Próximas postagens → Página inicial