blob: 1ff219c03ed60b277d2a43132a059ffedacc4a20 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
|
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:
|
