Jump to content
  • 0
Sign in to follow this  
Achmed

starting humanity

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

Share this post


Link to post
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!

Share this post


Link to post
Share on other sites
  • 0

Hi!

I change humanity value to 0 in phpmyadmin in characterdata table structure. But new players have 2500 humanity. Sorry for my english.

 

ALTER TABLE `character_data` CHANGE `Humanity` `Humanity` INT(11) NOT NULL DEFAULT '10';

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

  • Advertisement
  • Supporters
  • Discord

×
×
  • Create New...