CodeExtinguisher's Website Code

[eluser]Isern Palaus[/eluser]
Ouch... first problem understanding one of the models:

I'm in http://jtaby.com:82/svn/codex_site/syste...gins_m.php:

Code:

function  getPlugins ($num=-1,$offset=-1){
    $sql = "SELECT * from plugins order by created_at desc";
    if($num != -1)
        $sql .= " limit ";
    if($num != -1 AND $offset != -1)
        $sql .= "$offset,";
    if($num != -1)
        $sql .= "$num";
    
    $query = $this->db->query($sql);
    return $query->result_array();
}

I don't understand why you set -1 value. I suppose this value is set if no value is passed when you call the function on a controller.

It's called on controller plugins.php

Code:

if($num === "all"){
    $data['plugins'] = $this->plugins_m->getPlugins($config['per_page']);
}
else{
    if(!isset($num) OR !is_numeric($num)) $num = 0;
    $data['plugins'] = $this->plugins_m->getPlugins($config['per_page'],$num);
    $data['replies'] = $this->plugins_m->getThreads($num);
}

When you the $num (segment 3 on the URI) is equal at all you call $this->plugins_m->getPlugins($config['per_page']); the getPlugins() will create a SQL like this:

Code:

SELECT * from plugins order by created_at desc limit 10

(Supposing that $config['per_page] = 10)

What more, if you call $this->plugins_m->getPlugins($config['per_page'],$num) will create a SQL like this:

Code:

SELECT * from plugins order by created_at desc limit 10,10

It is?

Thanks in advance and thanks for sharing!

See you,
-- Isern Palaus