Buenas, estoy intentando poner el galaxytool de ogame en 000webhost, el problema es que me sale esto al intalar:
Código:
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtplayers'
Table: gtplayers (Trigger 2) failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtplayers'
Table: gtalliances (Trigger 1) failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtalliances'
Table: gtalliances (Trigger 2) failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtalliances'
Table: gtreports (Trigger 1) failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtreports'
Table: gtreports (Trigger 2) failure
TRIGGER command denied to user 'a6197009_gt'@'10.1.1.27' for table 'gtreports'
Installation failed
Pongo solo el trozo que falla...
Como que command denied? que passa aqui?
El instalador esasi, por si ayuda mas:
Código PHP:
$query ="CREATE TRIGGER 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
ON DUPLICATE KEY UPDATE
rank=values(rank), points=values(points),
frank=values(frank), fpoints=values(fpoints),
rrank=values(rrank), rpoints=values(rpoints);
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 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;
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 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";
if (!mysql_query($query)) {
echo "<tr class=\"firstcolor\"><td style=\"padding-left:10px;\">Table: $reporttable (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: $reporttable (Trigger 2)</td><td class=\"success\">success</td></tr>\n";
}