root/dev/common/autoupgrade.php @ 44

Revision 44, 0.9 KB (checked in by exi, 14 years ago)

Changed Synchronization to use http-request class
Changed portrait generation to use http class and fixed some issues there aswell
Ordered Killist on alliance losses / explicit cast to int from URI
Added date support to comments (autoupgrading, just save your settings once again)
Added a combined view to campaigns so you can filter kills and losses for each shipclass on one page
Cast corpid to int from URI
Changed DB, define DB_HALTONERROR in your config to stop page generation on error.
Set minor version to svn revision
Adding base alliance logos as stated on  http://www.eve-dev.net/forums/viewtopic.php?t=35 Thanks to DarkXeRoX for those.

Line 
1<?php
2require_once("db.php");
3function check_commenttable()
4{
5    $qry = new DBQuery();
6    $query = 'select count(*) from kb3_comments';
7    $result = mysql_query($query);
8    if ($result)
9    {
10        check_commenttablerow();
11        return;
12    }
13    $query = 'CREATE TABLE `kb3_comments` (
14`ID` INT NOT NULL AUTO_INCREMENT ,
15`kll_id` INT NOT NULL ,
16`comment` TEXT NOT NULL ,
17`name` TINYTEXT NOT NULL ,
18`posttime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL,
19PRIMARY KEY ( `ID` )
20) TYPE = MYISAM';
21    $qry->execute($query);
22}
23
24function check_commenttablerow()
25{
26    $qry = new DBQuery();
27    $query = 'select count(posttime) from kb3_comments';
28    $result = mysql_query($query);
29    if ($result)
30    {
31        check_commenttablerow();
32        return;
33    }
34    $query = 'ALTER TABLE `kb3_comments` ADD `posttime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP NOT NULL';
35    $qry->execute($query);
36}
37?>
Note: See TracBrowser for help on using the browser.