Si, ws justo el mio, el problema es que si el processo es crear una tabla, esa se crea, pero al llegar al proceso trigger dice que no tengo acceso:
Cita: CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
Birth_Date date)
Esto si funciona, pero el codigo antenrior:
Cita: $query ="CREATE TRIGGER 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;
END";
Esto me denega el acceso