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 :
le="color: #000000"><?php $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?
