AsmBB

Power
Login Register

Latest update

#15480 (ツ) johnfound
Created 04.08.2018, read: 836 times

It is not released as a binary package, but the latest update of the AsmBB engine is running now here and contains one important update.

The server-site-events, used for the real-time chat, was separated as a service. This change allows much faster and resource friendly handling of very big amount of SSE connections and this way opens an options to be used in all pages of the forum, not only in the chat.

If someone wants to update to the latest version of the engine, without creating new database, two more tables must to be created in the database. Execute the following SQL in the SQLite console:

create table EventSessions (
  session     text unique not null,
  time        integer,
  username    text,
  original    text,
  status      integer
);

create index idxEventSessionsTime on EventSessions(time);
create index idxEventSessionsOrig on EventSessions(original);

create table EventQueue (
  id         integer primary key autoincrement,
  type       integer,
  event      text,
  receiver   text    -- the sessionID of the receiver. If NULL then broadcast to all subscribed.
);

After the update, the table ChatUsers becomes obsolete and can be dropped:

  drop table ChatUsers;
AsmBB v2.9 (check-in: 6d407831308ba556); SQLite v3.31.1 (check-in: 3bfa9cc97da10598);
©2016..2020 John Found; Licensed under EUPL. Powered by Assembly language Created with Fresh IDE