Would anyone have an example on how this would work with a custom
query? Like the one below maybe? I've been trying to hack around the
pagination to no avail.
$ret = $this->Result->query("SELECT
`res`.`id`,
`res`.`clan_id`,
`res`.`match_time`,
`res`.`deleted`,
`c`.`id`,
`c`.`tag`,
`c`.`name`,
`c`.`active`,
`mrxref`.`id`,
`mrxref`.`map_id`,
`mrxref`.`result_id`,
`mrxref`.`team_score`,
`mrxref`.`opp_score`,
`mrxref`.`competition`,
`mrxref`.`deleted`,
`rfxref`.`id`,
`rfxref`.`file_id`,
`rfxref`.`result_id`,
`rfxref`.`deleted`,
`rfxref`.`created`,
`rfxref`.`modified`,
`m`.`id`,
`m`.`game_id`,
`m`.`name`,
`g`.`id`,
`g`.`name_short`,
`g`.`icon`
FROM
`results` AS `res`
LEFT JOIN `clans` AS `c` ON (`res`.`clan_id` = `c`.`id`)
INNER JOIN `maps_results_xrefs` AS `mrxref` ON `mrxref`.`result_id` =
`res`.`id`
LEFT JOIN `results_files_xrefs` AS `rfxref` ON (`rfxref`.`result_id` =
`res`.`id`)
INNER JOIN `maps` AS `m` ON `m`.`id` = `mrxref`.`map_id`
INNER JOIN `games` AS `g` ON `g`.`id` = `m`.`game_id`
");
On Jun 6, 2:33 am, "jitka (poLK)" <[EMAIL PROTECTED]> wrote:
> I think thathttps://trac.cakephp.org/changeset/5248
> could be answer for your question.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
