1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
|
Add Table:
CREATE TABLE IF NOT EXISTS `chatUsers` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`userID` int(11) NOT NULL,
`channel` int(11) NOT NULL,
`client` varchar(16) NOT NULL,
`dateEntered` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`dateLastActive` timestamp NULL DEFAULT NULL,
`isHere` tinyint(1) NOT NULL,
`isAdmin` tinyint(1) NOT NULL,
`isMod` tinyint(1) NOT NULL,
PRIMARY KEY (`ID`),
KEY `userID` (`userID`,`channel`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- Did we do everything below? I think we did.. Jan 13 2014?
For next update:
- Move the new columns from BlueRaja's database over to your other databases (see also: db updates.sql. Most, but not all, are in there.
I don't think Snap added his stuff there). Make sure to get not only the type, but nullable/default as well.
(We need to do this in a more sensible way in the future... sorry)
- Drop the 'statistics' table. It's not needed anymore.
- Delete the lines relating to '$mysqlid' from db.inc.php (which I can't do, since that file is not versioned).
Those lines have been moved to sqlEmbedded.php. The only thing that should be left are the four lines defining the servername/username/etc.
- Open includes\playerStats.php, and set CP_EARLIEST_DATE to the date we want to start counting ties/wins/champion points from.
We could also pretty easily recalculate the other stats (mazes and total moves) from that date, if you want; then that date would be like the 'start' of pathery.
- Go to the admin page in the browser, and click on the button that says "recalculate player statistics." All the above steps must be done before this.
Notes from previous updates:
|
