Sign in to follow this  
Followers 0
<Z>SneakyDude

Mysql not saving. -Why does this happen

4 posts in this topic

Do explain why items would not be backing up to the MySQL. Its frustrating as hell, and i am eager to figure this out.

When you import fields at the start are they coded so we only have those fields being entered and anything we custom add will not be added to the sql database?

We basically must create the fields in MySQL, and Exile does that in the beginning when we import the fields to be written in tables etc...

 

so explain why would we be restricted with MySQL not saving new items we add to exile.

We add new items like    

class 100Rnd_MAG                    { quality = 1; price = 200; };  This is an Example

then add

class Ammunition
    {
        name = "Ammunition";
        icon = "a3\ui_f\data\gui\Rsc\RscDisplayArsenal\itemacc_ca.paa";
        items[] =
        {

"100Rnd_MAG", This is an Example

};

-- Dumping structure for table exile.player
CREATE TABLE IF NOT EXISTS `player` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `account_uid` varchar(32) NOT NULL,
  `is_alive` tinyint(1) NOT NULL DEFAULT '1',
  `damage` double unsigned NOT NULL DEFAULT '0',
  `fatigue` double unsigned NOT NULL DEFAULT '0',
  `hunger` double unsigned NOT NULL DEFAULT '100',
  `thirst` double unsigned NOT NULL DEFAULT '100',
  `alcohol` double unsigned NOT NULL DEFAULT '0',
  `oxygen_remaining` double unsigned NOT NULL DEFAULT '1',
  `bleeding_remaining` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_head` double unsigned NOT NULL,
  `hitpoint_body` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_hands` double unsigned NOT NULL DEFAULT '0',
  `hitpoint_legs` double unsigned NOT NULL DEFAULT '0',
  `direction` double NOT NULL DEFAULT '0',
  `position_x` double NOT NULL DEFAULT '0',
  `position_y` double NOT NULL DEFAULT '0',
  `position_z` double NOT NULL DEFAULT '0',
  `spawned_at` datetime NOT NULL,
  `died_at` datetime DEFAULT NULL,
  `assigned_items` text NOT NULL,
  `backpack` varchar(64) NOT NULL,
  `backpack_items` text NOT NULL,
  `backpack_magazines` text NOT NULL,
  `backpack_weapons` text NOT NULL,
  `current_weapon` varchar(64) NOT NULL,
  `goggles` varchar(64) NOT NULL,
  `handgun_items` varchar(255) NOT NULL,
  `handgun_weapon` varchar(64) NOT NULL,
  `headgear` varchar(64) NOT NULL,
  `binocular` varchar(64) NOT NULL,
  `loaded_magazines` varchar(255) NOT NULL,
  `primary_weapon` varchar(64) NOT NULL,
  `primary_weapon_items` varchar(255) NOT NULL,
  `secondary_weapon` varchar(64) NOT NULL,
  `secondary_weapon_items` varchar(255) NOT NULL,
  `uniform` varchar(64) NOT NULL,
  `uniform_items` text NOT NULL,
  `uniform_magazines` text NOT NULL,
  `uniform_weapons` text NOT NULL,
  `vest` varchar(64) NOT NULL,
  `vest_items` text NOT NULL,
  `vest_magazines` text NOT NULL,
  `vest_weapons` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `player_uid` (`account_uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


****** Could it be here that is why its not written to the database? **********

It cant be that simple is it?


Sorry to have to bother you and the devs about this, but i seriously want to figure this out. I am used to reddis now, not so much Mysql

But i am learning.

Share this post


Link to post
Share on other sites

Do we need to use this or setup ( Implement extDB as an option for saving, directly to mysql.)

So i can proceed

Share this post


Link to post
Share on other sites
Advertisement
Advertisement

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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.