Jump to content
  • 0

starting humanity


Achmed

Question

7 answers to this question

Recommended Posts

  • 0

Its in the actual query that defines the Character_DATA table.

CREATE TABLE Character_DATA (
  CharacterID INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  PlayerUID VARCHAR(20) NOT NULL DEFAULT '0',
  InstanceID INT(11) NOT NULL DEFAULT 0,
  Datestamp DATETIME DEFAULT NULL,
  LastLogin DATETIME NOT NULL,
  Inventory LONGTEXT DEFAULT NULL,
  Backpack LONGTEXT DEFAULT NULL,
  Worldspace VARCHAR(128) NOT NULL DEFAULT '[]',
  Medical VARCHAR(300) NOT NULL DEFAULT '[]',
  Alive TINYINT(3) UNSIGNED NOT NULL DEFAULT 1,
  Generation INT(11) UNSIGNED NOT NULL DEFAULT 1,
  LastAte DATETIME NOT NULL,
  LastDrank DATETIME NOT NULL,
  KillsZ INT(11) UNSIGNED NOT NULL DEFAULT 0,
  HeadshotsZ INT(11) UNSIGNED NOT NULL DEFAULT 0,
  DistanceFoot INT(11) NOT NULL DEFAULT 0,
  Duration INT(11) NOT NULL DEFAULT 0,
  CurrentState VARCHAR(200) NOT NULL DEFAULT '[]',
  KillsH INT(11) UNSIGNED NOT NULL DEFAULT 0,
  Model VARCHAR(50) NOT NULL DEFAULT '"Survivor2_DZ"',
  KillsB INT(11) UNSIGNED NOT NULL DEFAULT 0,
  Humanity INT(11) NOT NULL DEFAULT 2500,
  Infected TINYINT(3) DEFAULT 0,
  PRIMARY KEY (CharacterID),
  INDEX Alive (Alive),
  INDEX PlayerUID (PlayerUID)
)

This might help you to get the query you need. It goes without saying that you run tests on a seperate/test table before you get the query correct.

http://www.tutorialspoint.com/mysql/mysql-alter-command.htm (Look for Changing a Column's Default Value).

Link to comment
Share on other sites

  • 0

To change it go to your MySQL database for Epoch.

 

Navigate to character_data and edit it via structure or execute this query:

ALTER Table `character_data` CHANGE `Humanity` `Humanity` INT( 11 ) NOT NULL DEFAULT `2500`; 

Change 2500 to your default value!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Advertisement
  • Discord

×
×
  • Create New...