CREATE ALGORITHM = UNDEFINED DEFINER = `root`@`localhost` SQL SECURITY DEFINER VIEW `readable_cheatlog` AS SELECT `a`.`name` AS `accountname` , `a`.`id` AS `accountid` , `c`.`name` AS `name` , `c`.`id` AS `characterid` , `cl`.`offense` AS `offense` , `cl`.`count` AS `count` , `cl`.`lastoffensetime` AS `lastoffensetime` , `cl`.`param` AS `param`
FROM (( `cheatlog` `cl`
JOIN `characters` `c`
)
JOIN `accounts` `a`
)
WHERE (( `cl`.`cid` = `c`.`id`
)
AND ( `a`.`id` = `c`.`accountid`
)
AND ( `a`.`banned` =0
)
);
MySQL said:
#1227 - Access denied; you need the SUPER privilege for this operation
how Can I Fix This TY
FROM (( `cheatlog` `cl`
JOIN `characters` `c`
)
JOIN `accounts` `a`
)
WHERE (( `cl`.`cid` = `c`.`id`
)
AND ( `a`.`id` = `c`.`accountid`
)
AND ( `a`.`banned` =0
)
);
MySQL said:
#1227 - Access denied; you need the SUPER privilege for this operation
how Can I Fix This TY
