X-Affiliate getting on nerves, thats all

[bholabhala]

I just installed X-cart affiliate and this is what i am getting:

INVALID SQL: 1064 : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY plan_id' at line 1

SQL QUERY FAILURE: SELECT * FROM ORDER BY plan_id

Any kind of help in this matter will be highly appretiated.

Regards
Arslan

[bholabhala]

<?

#

$Id: partner_commissions.php,v 1.1.2.1 2003/06/09 07:29:22 svowl Exp $

#

require "./auth.php";
require $xcart_dir."/include/security.php";

if ($mode == "apply") {
if (is_array($plans)) {
foreach ($plans as $k=>$v) {
db_query ("UPDATE $sql_tbl[partner_commissions] SET plan_id='$v' WHERE login='$k'");
}
}

    func_header_location("partner_commissions.php?mode=go&page=$page&partner=$partner&applied");

}
elseif ($mode == "apply_all") {
db_query ("UPDATE $sql_tbl[partner_commissions] SET plan_id='$pc'");

    func_header_location("partner_commissions.php?mode=go&page=$page&partner=$partner&applied_all");

}
elseif ($mode == "go") {
$partner_info_query = "SELECT $sql_tbl[partner_commissions]., $sql_tbl[customers]. FROM $sql_tbl[partner_commissions], $sql_tbl[customers] WHERE $sql_tbl[partner_commissions].login like '".(empty($partner) ? "%" : "$partner")."' AND $sql_tbl[partner_commissions].login=$sql_tbl[customers].login ORDER BY $sql_tbl[partner_commissions].login";
$total_numba = count (func_query ($partner_info_query));

    $objects_per_page = 10;

    $total_nav_pages = ceil ($total_numba/$objects_per_page)+1;
    require $xcart_dir."/include/navigation.php";
    $smarty->assign ("partner_info", func_query ("$partner_info_query LIMIT $first_page, $objects_per_page"));
    $smarty->assign ("navigation_script", "partner_commissions.php?mode=go&partner=".urlencode($partner));

}

$partners = func_query ("SELECT FROM $sql_tbl[customers] WHERE usertype='B' ORDER BY lastname, firstname");
$partner_plans = func_query ("SELECT FROM $sql_tbl[partner_plans] ORDER BY plan_title,plan_id");

$smarty->assign ("partner_plans", $partner_plans);
$smarty->assign ("partners", $partners);
$smarty->assign ("partner", $partner);
$smarty->assign ("mode", $mode);

$smarty->assign ("main", "commissions");
@include $xcart_dir."/modules/gold_display.php";
$smarty->display("admin/home.tpl");
?>

[drew010]

you should really contact the people who made this plugin, since it could be a problem with what they are distributing. also make sure this code isnt copyrighted and if you paid for it it really shouldnt be posted.

[tekky]

well the obvious problem is $sql_tbl[partner_plans] isnt getting assigned.... looking at the rest of the code whoever wrote this does sloppy work IMO... should include 'single quotes' around associate names and not use "double quotes" when its static text....

just my 2cents