Latest Activities not updating on web interface

[loljoho]

The "Latest Activities" table on the home page only reflects approvals/rejections made via the IRC bot interface, and not the web interface. The corresponding SQLite table triviaactivity is only updated through the bot plugin Python code; no such methods exist in the PHP portion.

[loljoho]

.

[loljoho]

CREATE TABLE triviaactivity (
                            id INTEGER PRIMARY KEY AUTOINCREMENT,
                            type TEXT,
                            activity TEXT,
                            channel TEXT,
                            channel_canonical TEXT,
                            network TEXT,
                            timestamp INTEGER);

CREATE TABLE triviaedit (
                            id INTEGER PRIMARY KEY AUTOINCREMENT,
                            question_id INTEGER,
                            question TEXT,
                            status TEXT,
                            username TEXT,
                            channel TEXT,
                            created_at TEXT,
                            username_canonical TEXT,
                            channel_canonical TEXT);

CREATE TABLE triviaquestion (
                            id INTEGER PRIMARY KEY AUTOINCREMENT,
                            question_canonical TEXT,
                            question TEXT,
                            deleted INTEGER NOT NULL DEFAULT 0,
                            num_answered INTEGER,
                            num_missed INTEGER);

CREATE TABLE triviatemporaryquestion (
                            id INTEGER PRIMARY KEY AUTOINCREMENT,
                            username TEXT,
                            channel TEXT,
                            question TEXT,
                            username_canonical TEXT,
                            channel_canonical TEXT);

CREATE TABLE triviadelete (
                            id INTEGER PRIMARY KEY AUTOINCREMENT,
                            username TEXT,
                            username_canonical TEXT,
                            line_num INTEGER,
                            channel TEXT,
                            channel_canonical TEXT,
                            reason TEXT);