Achmed Posted February 5, 2014 Report Share Posted February 5, 2014 Does anyone know what file sets the humanity to 2500 for new players? Link to comment Share on other sites More sharing options...
0 Joeyy Posted February 5, 2014 Report Share Posted February 5, 2014 `Humanity` int(11) NOT NULL DEFAULT '2500', It's in the SQL. salival 1 Link to comment Share on other sites More sharing options...
0 Achmed Posted February 5, 2014 Author Report Share Posted February 5, 2014 Where in the database would i find it? Link to comment Share on other sites More sharing options...
0 Judge Bread Posted February 6, 2014 Report Share Posted February 6, 2014 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 More sharing options...
0 Joeyy Posted February 6, 2014 Report Share Posted February 6, 2014 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 More sharing options...
0 Achmed Posted February 6, 2014 Author Report Share Posted February 6, 2014 Thanks. Will give it a try :) Link to comment Share on other sites More sharing options...
0 Jun_msk Posted November 21, 2016 Report Share Posted November 21, 2016 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'; Link to comment Share on other sites More sharing options...
0 Jun_msk Posted November 23, 2016 Report Share Posted November 23, 2016 works for anyone? Link to comment Share on other sites More sharing options...
Question
Achmed
Does anyone know what file sets the humanity to 2500 for new players?
Link to comment
Share on other sites
7 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now