Miscreated

Miscreated

Phoenix Rebirth Community Mod
 此主题已被置顶,因此可能具有重要性
Black Phoenix  [开发者] 2019 年 5 月 30 日 下午 1:12
Database Usage
Database Usage
Hey All, As promised here's a guide to using the database

SQLite DB Broswer[sqlitebrowser.org]

Now before we begin you will need something to browse your database, I would recommend

Its the software i use and what this guide will be based on using, so if you need to install it now .. ill wait. If you already have it installed then take a seat at he head of the class.

Ok now that's sorted lets start.Navigate to your servers root directory, Depending on your install location it should look like

D:\Steam\steamapps\common\MiscreatedServer

Scroll down till you see miscreated.db ( if you cant see the extension its listed as DB File under Type)

Open this file..a double click will do it.

A window should open with a browser window listing 11 Tables and 15 Indices. Above this you will see Create Table and Create index With four Tabs above them, Select the Browse Data Tab.

The browser window will change and should now show columns, First column will be CharacterID, Above this you will see Table with a drop down menu next to it (currently on Characters)

Now you need to locate yourself or the desired player in the database, there is a couple of ways to do this but easiest and quickest is make sure the character in question is in a clan, If the Character is the clan leader simply choose clans and look for the clan they own, now select the OwnerAccountID, Congrats here take this pipe and magnifying glass... Weve more detective work to do yet.
If the Character Is a clan member select clans and ake the clanID now go to ClanMembers and paste or type the clanID into the top of the ClanID column, Now look for the player and copy their Account ID. And Done

Another method to find unclanned players on whitelisted servers is to reference your whitelist to the CharacterID (0 = First on Whitelist). If you remove Players From The whitelist this wont work unless you also deleted them from the database. but if your reading this its unlikely.
The final method take alot more work and needs a guide in itself lol.

From Here ill Break The Guide Into Sections That Will Follow This
最后由 Black Phoenix 编辑于; 2019 年 5 月 30 日 下午 1:20
< >
正在显示第 1 - 4 条,共 4 条留言
Black Phoenix  [开发者] 2019 年 5 月 30 日 下午 1:36 
Base Bugs And Deletion

If a player cannot remove their Plot sign due to sinking parts or they are breaching server rules and the base is to be deleted the databse can be used for this.

Firstly Take the AccountID gained from the steps above.

Now To Delete Individual Parts Select Structures and Paste the AccountID into AccountID to filter the Correct plot sign, Scroll to the last column StructureGUID and copy this.

Now go to the StructureParts table and Paste the StructureGUID into the column filter.

On a big base you will be faced with a list of items, The PartTypeID is the Item ID not sure about online sources but all can be found in the Scripts file inside mods or the game SDK folder.

Scripts\Entities\Items\XML\

This is the location of items in any mod or the game files

you may get lucky however by checking the PosZ for - Values ... sunken parts should have the lowest value.

Remove the part by deleting the record (right click on it )

To Delete the whole base just locate the Plot sing and delete that record.
Black Phoenix  [开发者] 2019 年 5 月 30 日 下午 1:58 
Move Vehicles/Players

We Shall Start With Players, Since we have a AccountID to hand.

In The Character table paste the AccountID into the column filter to get the player.
Then edit the PosX,Y and Z

I would suggest first moving your player In-game to a safe spot and using this method to note the position.
it can now be used as a Safezone

To Move a Vehicle select the Vehicle table and locate the vehicle you can do this by filtering the Category column.
The data column shows the health fuel and oil of the car if you still cant locate which one it is
If you still cant locate it but know the contents copy the VehicleGUID and then go to the Items table and Paste the VehicleGUID into the OwnerID column tho show the cars contents.If the contents match then the VehicleGUID Belongs to the car.

Head back to the Vehicles table and change the PosX,Y and Z to match your safezone Co-ords

Black Phoenix  [开发者] 2019 年 5 月 30 日 下午 2:18 
Change Items

This should only be used to help with bugs or setup events

To change stored items on a player locate the player with the AccountID then copy the CharacterGUID ( Last column )

Head to the Items table and paste the CharacterID into OwnerID this will list all a player is carrying.
Be Cautious of how you change things here as there is different slot types same with the Vehicle table
Any slots are things being carried in storage belt, face, eyes etc are all things equipped.
Change the ClassName of the item you want to swap for example Rags becomes Nails.
Data contains info on Stacksize if items Stackable or health if the item has durability, these can be changed to suit

To Change the items in anything else such as Tents, Vehicles, Wood Crates you just need to get the related GUID
Tents can be found in Structures table
Vehicles in Vehicle table
Woodcrates - follow steps to locate base part in Base Bugs / Deletion and copy the parts GUID instead of deleting the record.

List of Added items can be found in discussions for Items Added by the mod everything else can be found in the Scripts.pak file in the game/server root folder in GameSDK
Black Phoenix  [开发者] 2019 年 5 月 30 日 下午 2:32 
Policing Servers

The Database can be a powerful tool to aid you in policing your server and enforcing rules. Somethings are easily taken care off

Tent Limits can be enforced tents bare the AccountID of the player who placed it so players cant hide tents in woods or inside base.

Items located close together, checking the X,Y,Z of Tents/Vehicles to Plot sign locations can help build a picture of what is stored inside a base and can indicate how many Vehicles or Tents are held inside

There is alot more the database can help with but i hope ive gave you the help or info needed to better understand and use the database, not abuse

BE SURE THAT ANY CHANGES MADE AND SAVED BY SELECTING WRITE CHANGES

Changes to players Items and Position Require the player to be logged of during changes

Changes to Bases and Vehicles Require a server Restart to take effect (if server is live)
< >
正在显示第 1 - 4 条,共 4 条留言
每页显示数: 1530 50