· 9 years ago · Jan 11, 2017, 09:32 PM
1CREATE TABLE IF NOT EXISTS `custom_pvp_db` (
2 `cid` int(11) NOT NULL,
3 `kills` int(11) NOT NULL DEFAULT '1',
4 `deaths` int(11) NOT NULL DEFAULT '1',
5 `points` int(11) NOT NULL DEFAULT '1',
6 `take_prize` int(11) NOT NULL DEFAULT '0',
7 PRIMARY KEY (`cid`)
8) ENGINE=InnoDB DEFAULT CHARSET=latin1;
9
10
11delimiter //
12
13CREATE TRIGGER RECALC_POINTS AFTER UPDATE ON custom_pvp_db
14FOR EACH ROW
15BEGIN
16 DECLARE v_kills int(11);
17 DECLARE v_deaths int(11);
18 DECLARE v_max_kills int(11);
19
20 SELECT kills into v_kills FROM custom_pvp_db;
21END;//
22
23delimiter ;