Watchlist pluggin done !

[Resta]

This plugin works with the current version of osclass without any changes but there are 2 issues -

1) it paginates for just 2 items on each page - 10 item pagination would be better - does anyone know how to change that?

2) once an item is added to the watchlist, there seems to be no way for the user to delete the one or all items from the watchlist (or I haven't figured out a way yet)

I was wondering if anyone else have the same issues and if there are any fixes?

Thanks!

[san4747]

function for count favorite
в functions.php theme add function

Code: [Select]

       
function countFavorite() {
        $count = 0;
        $conn = getConnection();
                $count =  $conn->osc_dbFetchValue("SELECT COUNT(fk_i_item_id) FROM %st_item_watchlist WHERE fk_i_user_id = '%d'" , DB_TABLE_PREFIX, osc_logged_user_id());
        return $count;
        }

Show count in header

Code: [Select]

<span class="count"><?= countFavorite(); ?></span> </a>


[WEBmods]

function for count favorite
в functions.php theme add function

Code: [Select]

       
function countFavorite() {
        $count = 0;
        $conn = getConnection();
                $count =  $conn->osc_dbFetchValue("SELECT COUNT(fk_i_item_id) FROM %st_item_watchlist WHERE fk_i_user_id = '%d'" , DB_TABLE_PREFIX, osc_logged_user_id());
        return $count;
        }

Show count in header

Code: [Select]

<span class="count"><?= countFavorite(); ?></span> </a>


Didn't want to reply, but this bugs me...

Just two recommendations:

use DAO instead of 'getConnection' function.
don't use php short tags '<?=' as they might be disabled on some servers.

Regards.