Hi is there any way to executed nested queries using $smcFunc['db_query'](..)
I have a special case where i want to build a ranking system.
I have kind of the following structure:
+------------------------------------------------------+
| smf_challenge_completions |
+--------------+-----------+--------+------------------+
| id_challenge | id_member | points | submit_timestamp |
+--------------+-----------+--------+------------------+
| ....
SELECT id_member, SUM(points) AS total_points, MAX(submit_timestamp), @rownum := @rownum + 1 AS rank
FROM smf_challenge_completions, (SELECT @rownum := 0) r
ORDER BY total_points DESC, submit_timestamp DESC
GROUP BY id_member, rank
and
SELECT rank FROM
(
SELECT id_member, SUM(points) AS total_points, MAX(submit_timestamp), @rownum := @rownum + 1 AS rank
FROM smf_challenge_completions, (SELECT @rownum := 0) r
ORDER BY total_points DESC, submit_timestamp DESC
GROUP BY id_member, rank
) AS t
WHERE id_member = ?
Always getting Hacking attempt... because of db_query security..
Set before you run the query
$modSettings['securityDisable'] = 1;
And after your run it set it to
$modSettings['securityDisable'] = 0;
It seems like
$modSettings['disableQueryCheck'] = 1;
does the trick
Oops yeah meant that one.
You could also probably use a JOIN...