Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $query ="CREATE TRIGGER ".$dbprefix."players_ai AFTER INSERT ON $playertable
- FOR EACH ROW BEGIN
- INSERT INTO $playerhistory SET
- year = DATE_FORMAT(NOW(),'%Y'),
- month = DATE_FORMAT(NOW(),'%m'),
- day = DATE_FORMAT(NOW(),'%e'),
- player_id = NEW.id,
- alliance_id = NEW.alliance_id,
- rank = NEW.rank,
- points = NEW.points,
- frank = NEW.frank,
- fpoints = NEW.fpoints,
- rrank = NEW.rrank,
- rpoints = NEW.rpoints,
- erank = NEW.erank,
- epoints = NEW.epoints;
- END";
- if (!mysql_query($query)) {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $playertable (Trigger 1)</td><td class=\"failure\">failure</td></tr>\n";
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n";
- $error_occured = true;
- } else {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $playertable (Trigger 1)</td><td class=\"success\">success</td></tr>\n";
- }
- $query ="CREATE TRIGGER ".$dbprefix."players_au AFTER UPDATE ON $playertable
- FOR EACH ROW BEGIN
- INSERT INTO $playerhistory SET
- year = DATE_FORMAT(NOW(),'%Y'),
- month = DATE_FORMAT(NOW(),'%m'),
- day = DATE_FORMAT(NOW(),'%e'),
- player_id = NEW.id,
- alliance_id = NEW.alliance_id,
- rank = NEW.rank,
- points = NEW.points,
- frank = NEW.frank,
- fpoints = NEW.fpoints,
- rrank = NEW.rrank,
- rpoints = NEW.rpoints,
- erank = NEW.erank,
- epoints = NEW.epoints
- ON DUPLICATE KEY UPDATE
- rank=valueS(rank), points=VALUES(points),
- frank=valueS(frank), fpoints=VALUES(fpoints),
- rrank=valueS(rrank), rpoints=VALUES(rpoints),
- erank=valueS(erank), epoints=VALUES(epoints);
- END";
- if (!mysql_query($query)) {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $playertable (Trigger 2)</td><td class=\"failure\">failure</td></tr>\n";
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n";
- $error_occured = true;
- } else {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $playertable (Trigger 2)</td><td class=\"success\">success</td></tr>\n";
- }
- // Ally history - insert
- $query ="CREATE TRIGGER ".$dbprefix."alliances_ai AFTER INSERT ON $allytable
- FOR EACH ROW BEGIN
- INSERT INTO $allyhistory SET
- year = DATE_FORMAT(NOW(),'%Y'),
- month = DATE_FORMAT(NOW(),'%m'),
- day = DATE_FORMAT(NOW(),'%e'),
- alliance_id = NEW.id,
- members = NEW.members,
- rank = NEW.rank,
- points = NEW.points,
- frank = NEW.frank,
- fpoints = NEW.fpoints,
- rrank = NEW.rrank,
- rpoints = NEW.rpoints,
- erank = NEW.erank,
- epoints = NEW.epoints;
- END";
- if (!mysql_query($query)) {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 1)</td><td class=\"failure\">failure</td></tr>\n";
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n";
- $error_occured = true;
- } else {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 1)</td><td class=\"success\">success</td></tr>\n";
- }
- // Ally history - update
- $query ="CREATE TRIGGER ".$dbprefix."alliances_au AFTER UPDATE ON $allytable
- FOR EACH ROW BEGIN
- INSERT INTO $allyhistory SET
- year = DATE_FORMAT(NOW(),'%Y'),
- month = DATE_FORMAT(NOW(),'%m'),
- day = DATE_FORMAT(NOW(),'%e'),
- alliance_id = NEW.id,
- members = NEW.members,
- rank = NEW.rank,
- points = NEW.points,
- frank = NEW.frank,
- fpoints = NEW.fpoints,
- rrank = NEW.rrank,
- rpoints = NEW.rpoints,
- erank = NEW.erank,
- epoints = NEW.epoints
- ON DUPLICATE KEY UPDATE
- rank=values(rank), points=values(points),
- frank=values(frank), fpoints=values(fpoints),
- rrank=values(rrank), rpoints=values(rpoints),
- erank=values(erank), epoints=values(epoints);
- END";
- if (!mysql_query($query)) {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 2)</td><td class=\"failure\">failure</td></tr>\n";
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n";
- $error_occured = true;
- } else {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $allytable (Trigger 2)</td><td class=\"success\">success</td></tr>\n";
- }
- $query ="CREATE TRIGGER ".$dbprefix."reports_ai AFTER INSERT ON $reporttable
- FOR EACH ROW BEGIN
- IF NEW.scanned = 'research' OR NEW.computech > 0 OR NEW.energytech > 0 THEN
- UPDATE $playertable SET
- spiolvl = NEW.spiolvl,
- computech = NEW.computech,
- waffentech = NEW.waffentech,
- schildtech = NEW.schildtech,
- rpz = NEW.rpz,
- energytech = NEW.energytech,
- hypertech = NEW.hypertech,
- vbt=NEW.vbt,
- impulse = NEW.impulse,
- hra=NEW.hra,
- lasertech = NEW.lasertech,
- iontech = NEW.iontech,
- plasmatech = NEW.plasmatech,
- forschungsnetz = NEW.forschungsnetz,
- expedition = NEW.expedition,
- gravi = NEW.gravi,
- last_tech_update = NOW()
- WHERE id = (SELECT g.player_id FROM $reporttable r, $dbtablename g WHERE r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.planetname = g.planetname AND r.galaxy=NEW.galaxy AND r.system=NEW.system and r.planet=NEW.planet AND r.planetname=NEW.planetname LIMIT 1);
- END IF;
- IF NEW.msg_id > 0 THEN
- INSERT IGNORE INTO $reportarchive SET
- galaxy = NEW.galaxy,
- system = NEW.system,
- planet = NEW.planet,
- moon = NEW.moon,
- msg_id = NEW.msg_id,
- metal = NEW.metal,
- crystal = NEW.crystal,
- deuterium = NEW.deuterium,
- energy = NEW.energy,
- scantime = NEW.scantime,
- scanned = NEW.scanned,
- kt = NEW.kt,
- gt = NEW.gt,
- lj = NEW.lj,
- sj = NEW.sj,
- krz = NEW.krz,
- ss = NEW.ss,
- kolo = NEW.kolo,
- rec = NEW.rec,
- spio = NEW.spio,
- bomb = NEW.bomb,
- zerri = NEW.zerri,
- ds = NEW.ds,
- skrz = NEW.skrz,
- sat = NEW.sat,
- rak = NEW.rak,
- ll = NEW.ll,
- sl = NEW.sl,
- ion = NEW.ion,
- gauss = NEW.gauss,
- plasma = NEW.plasma,
- ksk = NEW.ksk,
- gsk = NEW.gsk,
- arak = NEW.arak,
- irak = NEW.irak,
- memi = NEW.memi,
- krimi = NEW.krimi,
- deutsyn = NEW.deutsyn,
- solar = NEW.solar,
- fusion = NEW.fusion,
- robo = NEW.robo,
- nani = NEW.nani,
- rawe = NEW.rawe,
- mesp = NEW.mesp,
- krissp = NEW.krissp,
- deutsp = NEW.deutsp,
- folab = NEW.folab,
- terra = NEW.terra,
- allydep = NEW.allydep,
- raksilo = NEW.raksilo,
- mbase = NEW.mbase,
- sensor = NEW.sensor,
- sprungtor = NEW.sprungtor,
- spiolvl = NEW.spiolvl,
- computech = NEW.computech,
- waffentech = NEW.waffentech,
- schildtech = NEW.schildtech,
- rpz = NEW.rpz,
- energytech = NEW.energytech,
- hypertech = NEW.hypertech,
- vbt = NEW.vbt,
- impulse = NEW.impulse,
- hra = NEW.hra,
- lasertech = NEW.lasertech,
- iontech = NEW.iontech,
- plasmatech = NEW.plasmatech,
- forschungsnetz = NEW.forschungsnetz,
- expedition = NEW.expedition,
- gravi = NEW.gravi;
- END IF;
- END";
- if (!mysql_query($query)) {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 1)</td><td class=\"failure\">failure</td></tr>\n";
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\" class=\"failure\" colspan=\"2\">".mysql_error()."</td></tr>\n";
- $error_occured = true;
- } else {
- echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (Trigger 1)</td><td class=\"success\">success</td></tr>\n";
- }
- $query ="CREATE TRIGGER ".$dbprefix."reports_au AFTER UPDATE ON $reporttable
- FOR EACH ROW BEGIN
- IF NEW.scanned = 'research' OR NEW.computech > 0 OR NEW.energytech > 0 THEN
- UPDATE $playertable SET
- spiolvl = NEW.spiolvl,
- computech = NEW.computech,
- waffentech = NEW.waffentech,
- schildtech = NEW.schildtech,
- rpz = NEW.rpz,
- energytech = NEW.energytech,
- hypertech = NEW.hypertech,
- vbt=NEW.vbt,
- impulse = NEW.impulse,
- hra=NEW.hra,
- lasertech = NEW.lasertech,
- iontech = NEW.iontech,
- plasmatech = NEW.plasmatech,
- forschungsnetz = NEW.forschungsnetz,
- expedition = NEW.expedition,
- gravi = NEW.gravi,
- last_tech_update = NOW()
- WHERE id = (SELECT g.player_id FROM $reporttable r, $dbtablename g WHERE r.galaxy = g.galaxy AND r.system = g.system AND r.planet = g.planet AND r.planetname = g.planetname AND r.galaxy=NEW.galaxy AND r.system=NEW.system and r.planet=NEW.planet AND r.planetname=NEW.planetname LIMIT 1);
- END IF;
- IF NEW.msg_id > 0 THEN
- INSERT IGNORE INTO $reportarchive SET
- galaxy = NEW.galaxy,
- system = NEW.system,
- planet = NEW.planet,
- moon = NEW.moon,
- msg_id = NEW.msg_id,
- metal = NEW.metal,
- crystal = NEW.crystal,
- deuterium = NEW.deuterium,
- energy = NEW.energy,
- scantime = NEW.scantime,
- scanned = NEW.scanned,
- kt = NEW.kt,
- gt = NEW.gt,
- lj = NEW.lj,
- sj = NEW.sj,
- krz = NEW.krz,
- ss = NEW.ss,
- kolo = NEW.kolo,
- rec = NEW.rec,
- spio = NEW.spio,
- bomb = NEW.bomb,
- zerri = NEW.zerri,
- ds = NEW.ds,
- skrz = NEW.skrz,
- sat = NEW.sat,
- rak = NEW.rak,
- ll = NEW.ll,
- sl = NEW.sl,
- ion = NEW.ion,
- gauss = NEW.gauss,
- plasma = NEW.plasma,
- ksk = NEW.ksk,
- gsk = NEW.gsk,
- arak = NEW.arak,
- irak = NEW.irak,
- memi = NEW.memi,
- krimi = NEW.krimi,
- deutsyn = NEW.deutsyn,
- solar = NEW.solar,
- fusion = NEW.fusion,
- robo = NEW.robo,
- nani = NEW.nani,
- rawe = NEW.rawe,
- mesp = NEW.mesp,
- krissp = NEW.krissp,
- deutsp = NEW.deutsp,
- folab = NEW.folab,
- terra = NEW.terra,
- allydep = NEW.allydep,
- raksilo = NEW.raksilo,
- mbase = NEW.mbase,
- sensor = NEW.sensor,
- sprungtor = NEW.sprungtor,
- spiolvl = NEW.spiolvl,
- computech = NEW.computech,
- waffentech = NEW.waffentech,
- schildtech = NEW.schildtech,
- rpz = NEW.rpz,
- energytech = NEW.energytech,
- hypertech = NEW.hypertech,
- vbt = NEW.vbt,
- impulse = NEW.impulse,
- hra = NEW.hra,
- lasertech = NEW.lasertech,
- iontech = NEW.iontech,
- plasmatech = NEW.plasmatech,
- forschungsnetz = NEW.forschungsnetz,
- expedition = NEW.expedition,
- gravi = NEW.gravi;
- END IF;
- END";
Add Comment
Please, Sign In to add comment