Firefox PHP

Event logging and IPV6

Posted by Scott Finegan 
Event logging and IPV6
June 18, 2012 01:40PM
Looking at the event logging table, it appears to me that the "ip" field should be larger by default going forward for IPV6.
While I am at it, an index on "ip" would be helpful. The reason is to sort by ip on the View Logged Events page, to determine easily if one user is especially problematic. This is without expanding every detail.

Language: SQL
CREATE TABLE {$PHORUM["event_logging_table"]} (   log_id INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,   SOURCE VARCHAR(32) NOT NULL DEFAULT ';unknown';, category TINYINT(4) NOT NULL DEFAULT 0, loglevel TINYINT(4) NOT NULL DEFAULT 0, message VARCHAR(255) NOT NULL DEFAULT ';<no error message specified>';, details TEXT NULL,   ip VARCHAR(15) NULL, hostname VARCHAR(255) NULL, user_id INT UNSIGNED NULL, datestamp INT UNSIGNED NOT NULL DEFAULT 0,   vroot INT UNSIGNED NULL, forum_id INT UNSIGNED NULL, thread_id INT UNSIGNED NULL, message_id INT UNSIGNED NULL,   KEY SOURCE (SOURCE), KEY category (category), KEY loglevel (loglevel), KEY datestamp (datestamp), KEY user_id (user_id), KEY forum (vroot, forum_id, thread_id, message_id) )
Sorry, only registered users may post in this forum.

Click here to login