Changeset 374
- Timestamp:
- 06/14/09 14:06:02 (14 years ago)
- Location:
- dev
- Files:
-
- 3 modified
Legend:
- Unmodified
- Added
- Removed
-
dev/common/includes/class.kill.php
r370 r374 851 851 if ( $this->timestamp_ == "" || !$this->victimid_ || !$this->victimship_->getID() || !$this->solarsystem_->getID() || 852 852 !$this->victimallianceid_ || !$this->victimcorpid_ || !$this->getFBAllianceID() || !$this->getFBCorpID() || 853 !$this->getFBPilotID() ) 854 return 0; 853 !$this->getFBPilotID() ) return 0; 855 854 if ($id == null) 856 855 { … … 868 867 $qry = new DBQuery(); 869 868 $sql = "INSERT INTO kb3_kills 870 (kll_id , kll_timestamp , kll_victim_id , kll_all_id , kll_crp_id , kll_ship_id , kll_system_id , kll_fb_plt_id , kll_points , kll_dmgtaken, kll_ isk_loss)869 (kll_id , kll_timestamp , kll_victim_id , kll_all_id , kll_crp_id , kll_ship_id , kll_system_id , kll_fb_plt_id , kll_points , kll_dmgtaken, kll_external_id, kll_isk_loss) 871 870 VALUES (".$qid.", 872 871 date_format('".$this->timestamp_."', '%Y.%m.%d %H:%i:%s'), … … 879 878 ".$this->calculateKillPoints().", 880 879 ".$this->dmgtaken.", 880 NULL, 881 881 ".$this->calculateISKLoss()." )"; 882 882 $qry->autocommit(false); -
dev/packages/database/kb3_kills/table.xml
r371 r374 11 11 `kll_ship_id` int(3) NOT NULL default 0, 12 12 `kll_system_id` int(4) NOT NULL default 0, 13 `kll_fb_ all_id` int(3) default NULL,13 `kll_fb_plt_id` int(3) default NULL, 14 14 `kll_points` int(11) NOT NULL default 0, 15 `kll_dmgtaken` int(11) NOT NULL default 0, 15 16 `kll_external_id` int(3) default NULL, 16 17 `kll_isk_loss` float NOT NULL default 0, 17 `kll_dmgtaken` int(11) NOT NULL default 0,18 18 PRIMARY KEY (`kll_timestamp`,`kll_id`), 19 19 UNIQUE KEY `kll_id` (`kll_id`), … … 23 23 KEY `kll_crp_id` (`kll_crp_id`), 24 24 KEY `kll_system_id` (`kll_system_id`), 25 KEY `kll_fb_ all_id` (`kll_fb_all_id`),25 KEY `kll_fb_plt_id` (`kll_fb_plt_id`), 26 26 UNIQUE KEY `kll_external_id` (`kll_external_id`) 27 27 ) Type=InnoDB DEFAULT CHARSET=utf8;</structure> -
dev/packages/database/kb3_pilots/table.xml
r371 r374 11 11 PRIMARY KEY (`plt_id`), 12 12 UNIQUE KEY `plt_name` (`plt_name`), 13 UNIQUEKEY `plt_externalid` (`plt_externalid`)13 KEY `plt_externalid` (`plt_externalid`) 14 14 ) Type=InnoDB DEFAULT CHARSET=utf8;</structure> 15 15 </kb3>