Life is Feudal Official Forum

[Midaxos]

NICE !!

[KhaimovMR]

Version 0.9.13 released.
Features implemented:

• Specific MySQL port support added (previously panel didn't function if you were specifying mysql port in the "server" parameter of config_local.cs)

[DrunkMunki]

Hello, guys.
Tested 0.9.12 version on a Windows machine today.
Working fine with a clean setup (wiped database).

SnowSharky, you can try two ways to fix this issue:
First way - wiping character online history:
1. Shutdown the server.
2. Turn off the lifds-cp.
3. Drop all tables that starts with "lifdcp_".
4. Start lifds-cp again.

Second way - easiest by may not help if "lifdscp_*" tables are messed up:
Check that the parameter "online-statistics" in lifds-cp.ini is set to "on".

I am having the same issue, but none of the lifdcp_ tables are being created .. online statistics is set to ON and the CP can list users ID's ... just not showing online status

any chance i can get a SQL import file for these tables?

[KhaimovMR]

Hello, guys.
Tested 0.9.12 version on a Windows machine today.
Working fine with a clean setup (wiped database).

SnowSharky, you can try two ways to fix this issue:
First way - wiping character online history:
1. Shutdown the server.
2. Turn off the lifds-cp.
3. Drop all tables that starts with "lifdcp_".
4. Start lifds-cp again.

Second way - easiest by may not help if "lifdscp_*" tables are messed up:
Check that the parameter "online-statistics" in lifds-cp.ini is set to "on".

I am having the same issue, but none of the lifdcp_ tables are being created .. online statistics is set to ON and the CP can list users ID's ... just not showing online status

any chance i can get a SQL import file for these tables?

First one:

Code: Select all

CREATE TABLE `lifdscp_online_character` (
   `CharacterID` INT(10) UNSIGNED NOT NULL,
   `LoggedInAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`CharacterID`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

Second one:

Code: Select all

CREATE TABLE `lifdscp_online_history` (
   `ID` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
   `CharacterID` INT(10) UNSIGNED NOT NULL,
   `LoggedInAt` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `LoggedOutAt` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
   `IsLoggedOut` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '0 - still logged in, 1 - logged out',
   PRIMARY KEY (`ID`),
   INDEX `idx_CharacterID` (`CharacterID`),
   INDEX `idx_LoggedInAt` (`LoggedInAt`),
   INDEX `idx_LoggedOutAt` (`LoggedOutAt`),
   INDEX `idx_IsLoggedOut` (`IsLoggedOut`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=184;