<?php
include "includes/configuration.php";
include "includes/paging.class_sub.php";
$title_text = "Caricature Styles and Samples:";
include DIR_INCLUDES . 'header.php';
$pagination_object = new paging();
$pagenum = $pagination_object->setPageNumber($_GET['page']);
$maxrows = $pagination_object->setDisplayRows(15);
$pagination_object->setURL($_SERVER['PHP_SELF'], base64_encode(serialize($_GET)));
$appquery .= "SELECT U . *,PT.user_id,SUM(product_price) as totalprice,SUM(product_turnaroundtime) as totalturntime FROM `toon_users` U, `toon_user_types` UT ,`toon_products` PT WHERE U.`utype_id` = UT.`utype_id` AND U.`user_id` = PT.`user_id` AND U.`user_status` = 'Active' AND U.`user_delete` = '0' AND UT.`utype_name` = 'Artist' AND PT.`product_delete`=0 GROUP BY PT.user_id";
if ($_REQUEST['srtby']) {
$sort = $_REQUEST['srtby'];
if ($sort == 1) {
$appquery .= " ORDER BY totalprice DESC";
} elseif ($sort == 2) {
$appquery .= " ORDER BY totalprice ASC";
} elseif ($sort == 3) {
$appquery .= " ORDER BY totalturntime ASC";
}
}
if (!$_REQUEST['srtby']) {
$appquery .= " ORDER BY U.`user_artist_priority` ASC";
}
$rs_artists = mysql_query($appquery);
$num = mysql_num_rows($rs_artists);
$sku_count = $pagination_object->setTotalPages($num);
if ($sku_count <= $pagenum) {
$pagenum = $pagination_object->setPageNumber($totalpages - 1);
}
$startrow = $pagination_object->setStartRow();