$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADAcategory = 25;
$pageNum_WADAcategory = 0;
if (isset($_GET['pageNum_WADAcategory'])) {
$pageNum_WADAcategory = $_GET['pageNum_WADAcategory'];
}
$startRow_WADAcategory = $pageNum_WADAcategory * $maxRows_WADAcategory;
mysql_select_db($database_bikes_db, $bikes_db);
$query_WADAcategory = "SELECT * FROM mailist ORDER BY mail_signup_date DESC";
setQueryBuilderSource($query_WADAcategory, $WADbSearch1, false);
$query_limit_WADAcategory = sprintf("%s LIMIT %d, %d", $query_WADAcategory, $startRow_WADAcategory, $maxRows_WADAcategory);
$WADAcategory = mysql_query($query_limit_WADAcategory, $bikes_db) or die(mysql_error());
$row_WADAcategory = mysql_fetch_assoc($WADAcategory);
if (isset($_GET['totalRows_WADAcategory'])) {
$totalRows_WADAcategory = $_GET['totalRows_WADAcategory'];
} else {
$all_WADAcategory = mysql_query($query_WADAcategory, $bikes_db);
$totalRows_WADAcategory = mysql_num_rows($all_WADAcategory);
}
$totalPages_WADAcategory = ceil($totalRows_WADAcategory / $maxRows_WADAcategory) - 1;
mysql_select_db($database_bikes_db, $bikes_db);
$query_father = "SELECT* FROM category WHERE hide = 0 AND cat_isparent=1 OR cat_isparent=2 OR cat_isparent=3 ORDER BY cat_isparent ASC";
$father = mysql_query($query_father, $bikes_db) or die(mysql_error());
$row_father = mysql_fetch_assoc($father);
$totalRows_father = mysql_num_rows($father);
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_disputes = 10;
$pageNum_WADApaypal_disputes = 0;
if (isset($_GET['pageNum_WADApaypal_disputes'])) {
$pageNum_WADApaypal_disputes = $_GET['pageNum_WADApaypal_disputes'];
}
$startRow_WADApaypal_disputes = $pageNum_WADApaypal_disputes * $maxRows_WADApaypal_disputes;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_disputes = "SELECT id, txn_id, case_id, case_type, case_creation_date, payment_date, receipt_id, verify_sign, payer_email, payer_id, invoice, reason_code, custom, notify_version, creation_timestamp, ipn_status, txn_type, test_ipn FROM " . $db_table_prefix . "disputes ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_disputes, $WADbSearch1, false);
$query_limit_WADApaypal_disputes = sprintf("%s LIMIT %d, %d", $query_WADApaypal_disputes, $startRow_WADApaypal_disputes, $maxRows_WADApaypal_disputes);
$WADApaypal_disputes = mysql_query($query_limit_WADApaypal_disputes, $connDB) or die(mysql_error());
$row_WADApaypal_disputes = mysql_fetch_assoc($WADApaypal_disputes);
if (isset($_GET['totalRows_WADApaypal_disputes'])) {
$totalRows_WADApaypal_disputes = $_GET['totalRows_WADApaypal_disputes'];
} else {
$all_WADApaypal_disputes = mysql_query($query_WADApaypal_disputes);
$totalRows_WADApaypal_disputes = mysql_num_rows($all_WADApaypal_disputes);
}
$totalPages_WADApaypal_disputes = ceil($totalRows_WADApaypal_disputes / $maxRows_WADApaypal_disputes) - 1;
$queryString_WADApaypal_disputes = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_recurring_payment_profiles = 10;
$pageNum_WADApaypal_recurring_payment_profiles = 0;
if (isset($_GET['pageNum_WADApaypal_recurring_payment_profiles'])) {
$pageNum_WADApaypal_recurring_payment_profiles = $_GET['pageNum_WADApaypal_recurring_payment_profiles'];
}
$startRow_WADApaypal_recurring_payment_profiles = $pageNum_WADApaypal_recurring_payment_profiles * $maxRows_WADApaypal_recurring_payment_profiles;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_recurring_payment_profiles = "SELECT id, payment_cycle, txn_type, last_name, first_name, next_payment_date, residence_country, initial_payment_amount, rp_invoice_id, currency_code, time_created, verify_sign, period_type, payer_status, payer_email, receiver_email, payer_id, product_type, payer_business_name, shipping, amount_per_cycle, profile_status, notify_version, amount, outstanding_balance, recurring_payment_id, product_name, ipn_status, creation_timestamp, test_ipn FROM " . $db_table_prefix . "recurring_payment_profiles ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_recurring_payment_profiles, $WADbSearch1, false);
$query_limit_WADApaypal_recurring_payment_profiles = sprintf("%s LIMIT %d, %d", $query_WADApaypal_recurring_payment_profiles, $startRow_WADApaypal_recurring_payment_profiles, $maxRows_WADApaypal_recurring_payment_profiles);
$WADApaypal_recurring_payment_profiles = mysql_query($query_limit_WADApaypal_recurring_payment_profiles, $connDB) or die(mysql_error());
$row_WADApaypal_recurring_payment_profiles = mysql_fetch_assoc($WADApaypal_recurring_payment_profiles);
if (isset($_GET['totalRows_WADApaypal_recurring_payment_profiles'])) {
$totalRows_WADApaypal_recurring_payment_profiles = $_GET['totalRows_WADApaypal_recurring_payment_profiles'];
} else {
$all_WADApaypal_recurring_payment_profiles = mysql_query($query_WADApaypal_recurring_payment_profiles);
$totalRows_WADApaypal_recurring_payment_profiles = mysql_num_rows($all_WADApaypal_recurring_payment_profiles);
}
$totalPages_WADApaypal_recurring_payment_profiles = ceil($totalRows_WADApaypal_recurring_payment_profiles / $maxRows_WADApaypal_recurring_payment_profiles) - 1;
$queryString_WADApaypal_recurring_payment_profiles = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_order_items = 10;
$pageNum_WADApaypal_order_items = 0;
if (isset($_GET['pageNum_WADApaypal_order_items'])) {
$pageNum_WADApaypal_order_items = $_GET['pageNum_WADApaypal_order_items'];
}
$startRow_WADApaypal_order_items = $pageNum_WADApaypal_order_items * $maxRows_WADApaypal_order_items;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_order_items = "SELECT id, order_id, refund_id, item_name, item_number, os0, on0, os1, on1, quantity, custom, mc_gross, mc_handling, mc_shipping, creation_timestamp, raw_log_id FROM " . $db_table_prefix . "order_items ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_order_items, $WADbSearch1, false);
$query_limit_WADApaypal_order_items = sprintf("%s LIMIT %d, %d", $query_WADApaypal_order_items, $startRow_WADApaypal_order_items, $maxRows_WADApaypal_order_items);
$WADApaypal_order_items = mysql_query($query_limit_WADApaypal_order_items, $connDB) or die(mysql_error());
$row_WADApaypal_order_items = mysql_fetch_assoc($WADApaypal_order_items);
if (isset($_GET['totalRows_WADApaypal_order_items'])) {
$totalRows_WADApaypal_order_items = $_GET['totalRows_WADApaypal_order_items'];
} else {
$all_WADApaypal_order_items = mysql_query($query_WADApaypal_order_items);
$totalRows_WADApaypal_order_items = mysql_num_rows($all_WADApaypal_order_items);
}
$totalPages_WADApaypal_order_items = ceil($totalRows_WADApaypal_order_items / $maxRows_WADApaypal_order_items) - 1;
$queryString_WADApaypal_order_items = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_mass_payments = 10;
$pageNum_WADApaypal_mass_payments = 0;
if (isset($_GET['pageNum_WADApaypal_mass_payments'])) {
$pageNum_WADApaypal_mass_payments = $_GET['pageNum_WADApaypal_mass_payments'];
}
$startRow_WADApaypal_mass_payments = $pageNum_WADApaypal_mass_payments * $maxRows_WADApaypal_mass_payments;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_mass_payments = "SELECT id, masspay_txn_id, mc_currency, mc_fee, mc_gross, receiver_email, status, unique_id, creation_timestamp, ipn_status, txn_type, test_ipn FROM " . $db_table_prefix . "mass_payments ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_mass_payments, $WADbSearch1, false);
$query_limit_WADApaypal_mass_payments = sprintf("%s LIMIT %d, %d", $query_WADApaypal_mass_payments, $startRow_WADApaypal_mass_payments, $maxRows_WADApaypal_mass_payments);
$WADApaypal_mass_payments = mysql_query($query_limit_WADApaypal_mass_payments, $connDB) or die(mysql_error());
$row_WADApaypal_mass_payments = mysql_fetch_assoc($WADApaypal_mass_payments);
if (isset($_GET['totalRows_WADApaypal_mass_payments'])) {
$totalRows_WADApaypal_mass_payments = $_GET['totalRows_WADApaypal_mass_payments'];
} else {
$all_WADApaypal_mass_payments = mysql_query($query_WADApaypal_mass_payments);
$totalRows_WADApaypal_mass_payments = mysql_num_rows($all_WADApaypal_mass_payments);
}
$totalPages_WADApaypal_mass_payments = ceil($totalRows_WADApaypal_mass_payments / $maxRows_WADApaypal_mass_payments) - 1;
$queryString_WADApaypal_mass_payments = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADAarticles = 50;
$pageNum_WADAarticles = 0;
if (isset($_GET['pageNum_WADAarticles'])) {
$pageNum_WADAarticles = $_GET['pageNum_WADAarticles'];
}
$startRow_WADAarticles = $pageNum_WADAarticles * $maxRows_WADAarticles;
mysql_select_db($database_bikes_db, $bikes_db);
//$query_WADAarticles = "SELECT articlesID, articlesName, articlesType, articlesUpdate, artlicesLive, articlesPDF FROM articles ORDER BY articlesID DESC";
$query_WADAarticles = "SELECT articles.articlesID, articles.articlesName, articles.articlesType, articles.artlicesLive,\narticles.articlesIntro, articles.articlesBody, articles.articlesAuthor, articles.articlesPublishDate, articles.articlesPublication,\narticles.articlesUpdate, articles.articlesPDF, articles.articlesThumb, category.cat_id, category.cat_name\nFROM articles \nINNER JOIN category\nON articles.articlesType = category.cat_id\nORDER BY articles.articlesType, articles.articlesUpdate ASC ";
setQueryBuilderSource($query_WADAarticles, $WADbSearch1, false);
$query_limit_WADAarticles = sprintf("%s LIMIT %d, %d", $query_WADAarticles, $startRow_WADAarticles, $maxRows_WADAarticles);
$WADAarticles = mysql_query($query_limit_WADAarticles, $bikes_db) or die(mysql_error());
$row_WADAarticles = mysql_fetch_assoc($WADAarticles);
if (isset($_GET['totalRows_WADAarticles'])) {
$totalRows_WADAarticles = $_GET['totalRows_WADAarticles'];
} else {
$all_WADAarticles = mysql_query($query_WADAarticles, $bikes_db);
$totalRows_WADAarticles = mysql_num_rows($all_WADAarticles);
}
$totalPages_WADAarticles = ceil($totalRows_WADAarticles / $maxRows_WADAarticles) - 1;
$queryString_WADAarticles = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_raw_log = 10;
$pageNum_WADApaypal_raw_log = 0;
if (isset($_GET['pageNum_WADApaypal_raw_log'])) {
$pageNum_WADApaypal_raw_log = $_GET['pageNum_WADApaypal_raw_log'];
}
$startRow_WADApaypal_raw_log = $pageNum_WADApaypal_raw_log * $maxRows_WADApaypal_raw_log;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_raw_log = "SELECT id, created_timestamp, ipn_data_serialized FROM " . $db_table_prefix . "raw_log ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_raw_log, $WADbSearch1, false);
$query_limit_WADApaypal_raw_log = sprintf("%s LIMIT %d, %d", $query_WADApaypal_raw_log, $startRow_WADApaypal_raw_log, $maxRows_WADApaypal_raw_log);
$WADApaypal_raw_log = mysql_query($query_limit_WADApaypal_raw_log, $connDB) or die(mysql_error());
$row_WADApaypal_raw_log = mysql_fetch_assoc($WADApaypal_raw_log);
if (isset($_GET['totalRows_WADApaypal_raw_log'])) {
$totalRows_WADApaypal_raw_log = $_GET['totalRows_WADApaypal_raw_log'];
} else {
$all_WADApaypal_raw_log = mysql_query($query_WADApaypal_raw_log);
$totalRows_WADApaypal_raw_log = mysql_num_rows($all_WADApaypal_raw_log);
}
$totalPages_WADApaypal_raw_log = ceil($totalRows_WADApaypal_raw_log / $maxRows_WADApaypal_raw_log) - 1;
$queryString_WADApaypal_raw_log = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_subscription_payments = 10;
$pageNum_WADApaypal_subscription_payments = 0;
if (isset($_GET['pageNum_WADApaypal_subscription_payments'])) {
$pageNum_WADApaypal_subscription_payments = $_GET['pageNum_WADApaypal_subscription_payments'];
}
$startRow_WADApaypal_subscription_payments = $pageNum_WADApaypal_subscription_payments * $maxRows_WADApaypal_subscription_payments;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_subscription_payments = "SELECT id, first_name, last_name, payer_email, memo, item_name, item_number, os0, on0, os1, on1, quantity, payment_date, payment_type, txn_id, mc_gross, mc_fee, payment_status, pending_reason, txn_type, tax, mc_currency, reason_code, custom, address_country, subscr_id, payer_status, ipn_status, creation_timestamp, test_ipn FROM " . $db_table_prefix . "subscription_payments ORDER BY id DESC";
setQueryBuilderSource($query_WADApaypal_subscription_payments, $WADbSearch1, false);
$query_limit_WADApaypal_subscription_payments = sprintf("%s LIMIT %d, %d", $query_WADApaypal_subscription_payments, $startRow_WADApaypal_subscription_payments, $maxRows_WADApaypal_subscription_payments);
$WADApaypal_subscription_payments = mysql_query($query_limit_WADApaypal_subscription_payments, $connDB) or die(mysql_error());
$row_WADApaypal_subscription_payments = mysql_fetch_assoc($WADApaypal_subscription_payments);
if (isset($_GET['totalRows_WADApaypal_subscription_payments'])) {
$totalRows_WADApaypal_subscription_payments = $_GET['totalRows_WADApaypal_subscription_payments'];
} else {
$all_WADApaypal_subscription_payments = mysql_query($query_WADApaypal_subscription_payments);
$totalRows_WADApaypal_subscription_payments = mysql_num_rows($all_WADApaypal_subscription_payments);
}
$totalPages_WADApaypal_subscription_payments = ceil($totalRows_WADApaypal_subscription_payments / $maxRows_WADApaypal_subscription_payments) - 1;
$queryString_WADApaypal_subscription_payments = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
$theValue = $theValue != "" ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
$currentPage = $_SERVER["PHP_SELF"];
$maxRows_WADApaypal_refunds = 10;
$pageNum_WADApaypal_refunds = 0;
if (isset($_GET['pageNum_WADApaypal_refunds'])) {
$pageNum_WADApaypal_refunds = $_GET['pageNum_WADApaypal_refunds'];
}
$startRow_WADApaypal_refunds = $pageNum_WADApaypal_refunds * $maxRows_WADApaypal_refunds;
mysql_select_db($database_connDB, $connDB);
$query_WADApaypal_refunds = "SELECT id, ipn_status, mc_gross, invoice, protection_eligibility, payer_id, address_street, payment_date, payment_status, charset, address_zip, mc_shipping, mc_handling, first_name, memo, last_name, product_name, mc_fee, address_country_code, address_name, notify_version, reason_code, custom, address_country, address_city, verify_sign, payer_email, parent_txn_id, contact_phone, time_created, txn_id, payment_type, payer_business_name, address_state, receiver_email, receiver_id, mc_currency, residence_country, test_ipn, transaction_subject, rp_invoice_id, recurring_payment_id, creation_timestamp FROM " . $db_table_prefix . "refunds";
setQueryBuilderSource($query_WADApaypal_refunds, $WADbSearch1, false);
$query_limit_WADApaypal_refunds = sprintf("%s LIMIT %d, %d", $query_WADApaypal_refunds, $startRow_WADApaypal_refunds, $maxRows_WADApaypal_refunds);
$WADApaypal_refunds = mysql_query($query_limit_WADApaypal_refunds, $connDB) or die(mysql_error());
$row_WADApaypal_refunds = mysql_fetch_assoc($WADApaypal_refunds);
if (isset($_GET['totalRows_WADApaypal_refunds'])) {
$totalRows_WADApaypal_refunds = $_GET['totalRows_WADApaypal_refunds'];
} else {
$all_WADApaypal_refunds = mysql_query($query_WADApaypal_refunds);
$totalRows_WADApaypal_refunds = mysql_num_rows($all_WADApaypal_refunds);
}
$totalPages_WADApaypal_refunds = ceil($totalRows_WADApaypal_refunds / $maxRows_WADApaypal_refunds) - 1;
$queryString_WADApaypal_refunds = "";
if (!empty($_SERVER['QUERY_STRING'])) {
$params = explode("&", $_SERVER['QUERY_STRING']);
$newParams = array();
foreach ($params as $param) {
