Openfire 3.4.0 has been released

Hey Stefan, the 1.0.2 is working great. Thanks a lot. Success and health for you.

PS: A saw at the user-status home page that you put an observation saying that the plugin only works with MySql. I’d like to say that i’m using PostGreSQL 8.1.x and its working fine. I just did minor changes to the Database Schema that you published at the same home page.

Regards,

Kleber (spockpb).

Would you mind to share the schema changes so I can include them in the next version?

Surely Stefan. Here they are.

CREATE TABLE userStatus (

username VARCHAR(64) NOT NULL,

resource VARCHAR(64) NOT NULL,

online INTEGER NOT NULL,

presence CHAR(15),

lastIpAddress CHAR(15) NOT NULL,

lastLoginDate CHAR(15) NOT NULL,

lastLogoffDate CHAR(15),

constraint pk_userStatus PRIMARY KEY (username, resource)

);

CREATE TABLE userStatusHistory (

historyID BIGINT NOT NULL,

username VARCHAR(64) NOT NULL,

resource VARCHAR(64) NOT NULL,

lastIpAddress CHAR(15) NOT NULL,

lastLoginDate CHAR(15) NOT NULL,

lastLogoffDate CHAR(15) NOT NULL,

constraint pk_userStatusHistory PRIMARY KEY (historyID)

);

Kleber (spockpb)

Thanks, I’ve added it to subversion so it will be part of the next version.

=Stefan