/** * Returns an array with the most recent votes in the database. * @return array * @private */ function getSenatVotes($order, $count, $from, $uid = 0, $q = '') { if ($q != '') { $sql = mysql_query("\n SELECT v.id, v.link, v.type, v.description, v.time,\n v.vda, v.vnu, v.vab, v.vmi,\n l.link as law_link, l.number as law_number\n FROM senat_2008_votes_details AS v\n LEFT JOIN senat_2008_laws AS l ON l.id = v.idlaw\n WHERE v.link LIKE '%{$q}%'\n ORDER BY time {$order}\n LIMIT {$from}, {$count}\n "); } else { $sql = mysql_query("\n SELECT v.id, v.link, v.type, v.description, v.time,\n v.vda, v.vnu, v.vab, v.vmi,\n l.link as law_link, l.number as law_number\n FROM senat_2008_votes_details AS v\n LEFT JOIN senat_2008_laws AS l ON l.id = v.idlaw\n ORDER BY time {$order}\n LIMIT {$from}, {$count}\n "); } $votes = array(); while ($r = mysql_fetch_array($sql)) { $vote = $r; $vote['subject'] = str_replace("/pls/proiecte", "http://www.cdep.ro/pls/proiecte", $r['description']); $vote['time'] = $r['time'] / 1000; if ($uid != 0) { $vote['tags'] = getVoteTags('senat_2008_votes_details', $r['id'], $uid); } $votes[] = $vote; } return $votes; }
/** * Returns an array with the most recent votes in the database. * @return array * @private */ function getCdepVotes($order, $count, $from, $uid = 0, $q = '') { if ($q == '') { $sql = mysql_query("\n SELECT link, type, description, time, vda, vnu, vab, vmi, id\n FROM cdep_2008_votes_details\n ORDER BY time {$order}\n LIMIT {$from}, {$count}\n "); } else { $sql = mysql_query("\n SELECT link, type, description, time, vda, vnu, vab, vmi, id\n FROM cdep_2008_votes_details\n WHERE link LIKE '%{$q}%'\n ORDER BY time {$order}\n LIMIT {$from}, {$count}\n "); } $votes = array(); while ($r = mysql_fetch_array($sql)) { $vote = $r; $vote['subject'] = str_replace("/pls/proiecte", "http://www.cdep.ro/pls/proiecte", $r['description']); $vote['time'] = $r['time'] / 1000; if ($uid != 0) { $vote['tags'] = getVoteTags('cdep_2008_votes_details', $r['id'], $uid); } $votes[] = $vote; } return $votes; }