1
I'm having som e problems. I keep getting this:
SELECT xoops__tplls_events.EventID, xoops__tplls_events.LeagueMatchID, xoops__tplls_events.PlayerID, xoops__tplls_events.EventType, xoops__tplls_events.EventHomeAway, xoops__tplls_events.EventTime, xoops__tplls_players.PlayerName FROM xoops__tplls_events, xoops__tplls_players WHERE ((xoops__tplls_events.PlayerID=xoops__tplls_players.PlayerID)AND( xoops__tplls_events.LeagueMatchID='26' ))
Error number: 0
Error message: Action not allowed
in MySQL debug after using this :
$umid = $_GET[themid];
$eventdata = $xoopsDB->query("
SELECT
".$xoopsDB->prefix("tplls_events").".EventID,
".$xoopsDB->prefix("tplls_events").".LeagueMatchID,
".$xoopsDB->prefix("tplls_events").".PlayerID,
".$xoopsDB->prefix("tplls_events").".EventType,
".$xoopsDB->prefix("tplls_events").".EventHomeAway,
".$xoopsDB->prefix("tplls_events").".EventTime,
".$xoopsDB->prefix("tplls_players").".PlayerName
FROM
".$xoopsDB->prefix("tplls_events").",
".$xoopsDB->prefix("tplls_players")."
WHERE ((".$xoopsDB->prefix("tplls_events").".PlayerID=".$xoopsDB->prefix("tplls_players").".PlayerID)AND(
".$xoopsDB->prefix("tplls_events").".LeagueMatchID='".$_GET[themid]."'
))
");
while($edata = $xoopsDB->fetchArray($eventdata)){
bla bla bla
}
Anyone got an idea?