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 |
---|
2 | require_once("db.php"); |
---|
3 | function 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, |
---|
19 | PRIMARY KEY ( `ID` ) |
---|
20 | ) TYPE = MYISAM'; |
---|
21 | $qry->execute($query); |
---|
22 | } |
---|
23 | |
---|
24 | function 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 | ?> |
---|