Example #1
0
function get_dyn_content($id)
{
    $SQL = new FC_SQL();
    $qs = "SELECT content FROM anima09_page p\n\t\t\t\tLEFT JOIN anima09_page_content c \n\t\t\t\t\tON p.anima09_page_id = c.anima09_page_id\n\t \t\t\tWHERE p.anima09_page_id = {$id}";
    $SQL->query($qs);
    $SQL->next_record();
    return $SQL->f(0);
}
Example #2
0
$gBitSystem->verifyPermission('bit_p_bitcart_admin');
header("Expires: 0");
require_once '../../bit_setup_inc.php';
$gBitSystem->verifyPermission('bit_p_bitcart_admin');
require_once BITCART_PKG_PATH . 'functions.php';
// ========== start of variable loading ==========
// load passed variables and cookie variables
// int or double cast the numbers, no exceptions
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
$vendid = (int) getparam('vendid');
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
// includes flags.php
$fcv = new FC_SQL();
?>

<h2 align=center>Modify A Vendor Profile</h2>
<hr>
<p>

<center>
<table border="0" cellpadding="3" cellspacing="1" bgcolor="#666666" width="650" class="text">
<tr><td align=center colspan=2 bgcolor="#FFFFFF">

<a href="index.php?zoneid=<?php 
echo $zoneid;
?>
&langid=<?php 
echo $langid;
Example #3
0
function parse_sql_file($filename)
{
    // do not escape the file while reading it
    set_magic_quotes_runtime(0);
    $fcz = new FC_SQL();
    $fcz->connect();
    if (file_exists($filename)) {
        $fp = fopen($filename, "r");
        while ($buffer = fgets($fp, 4096)) {
            $dres = null;
            $res = null;
            if (strchr($buffer, '#') && eregi("\"#[0-9a-z]{6}\"", $buffer)) {
                // html color code, typically in inserted html
                $sql .= $buffer;
            } else {
                if (ereg("(^[ \t]*[#;/-]+)", $buffer, $res) || ereg("^\n", $buffer)) {
                    // comment line, skip it
                    // oracle has lines with a single leading /, skip them
                    continue;
                } elseif (ereg("([^#]+);[\t ]*[-]{0,2}.*", $buffer, $res)) {
                    // ; terminated sql line
                    // chop off double dash comments
                    $sql .= $res[1];
                    // echo "second: $sql<br>br>\n";
                    if (ereg(" end[ \t]*\$", $res[1])) {
                        // wierd hack for oracle triggers/procedures
                        $sql .= ';';
                    }
                    $fcz->query($sql);
                    unset($sql);
                } elseif (ereg("(^[^#;]+)[\t ]*[-]{0,2}[^;]*", $buffer, $res)) {
                    // unterminated sql line
                    // chop off double dash comments
                    $sql .= $res[1];
                    // echo "first: $sql<br><br>\n";
                } else {
                    // echo "third: $buffer<br><br>\n";
                }
            }
        }
        fclose($fp);
    }
}
Example #4
0
            // get subcat level under $cat and spit them out in a table
            // how many cats across the page?
            $subcats1 = new FC_SQL();
            $subcats1->query('select count(*) as cnt from cat ' . "where catzid={$zid} and catlid={$lid} and catunder={$cat}");
            // are there any subcats to display? If not, don't do anything more.
            $subcats1->next_record();
            $subcattot = (int) $subcats1->f("cnt");
            $subcats1->free_result();
        } else {
            $subcattot = 0;
        }
        if ($subcattot) {
            // change this to increase or descrease the number of cats
            // displayed across the page
            $cats_across = "1";
            $subcats = new FC_SQL();
            $subcats->query("select catval,catdescr,catmast,catlogo from cat " . "where catact=1 and catzid={$zid} and catlid={$lid} and catunder={$cat} order by catdescr");
            $across = 0;
            ?>
<br /><br />
<table border="0" width="500" cellpadding="5">
<tr><td valign="top" colspan="<?php 
            echo $cats_across;
            ?>
">
<b><?php 
            echo fc_text("subcats");
            ?>
</b>
</td></tr>
<?php 
Example #5
0
$show = (int) getparam('show');
$srch = (int) getparam('srch');
$act = getparam('act');
$oldzid = (int) getparam('oldzid');
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
$droot = "BITCART_PKG_PATH";
if ($zoneid == 0) {
    ?>
	Please click the &quot;Back&quot; button on your browser
	and select a default zone.  Thank you.
    <?php 
    exit;
}
$fcm = new FC_SQL();
$fcm->Auto_commit = 0;
$fcm->query("select count(*) as cnt from master");
$fcm->next_record();
if ($fcm->f("cnt") > 0) {
    $fcm->free_result();
    $res = $fcm->query("update master set zoneid={$zoneid}");
} else {
    $res = $fcm->query("insert into master (zoneid) values ({$zoneid})");
}
if (!$res) {
    $fcm->rollback();
    echo "<b>Failure updating master: {$res}</b><br>\n";
} else {
    $fcm->commit();
    echo "Work Committed.<br>\n";
Example #6
0
</td><td align=center bgcolor=#ffffff>

<b>Delete An Existing Language Profile</b>

</td></tr>
<tr><td align=center bgcolor=#ffffff>

<form name=langmod method="post" action="langmod.php">

To modify an existing language profile,<br>
select its name from the list and<br>
click <i>Modify Selected Profile</i>.
<br>

<?php 
$fcl = new FC_SQL();
$fcl->query("select count(*) as cnt from lang " . "where langzid={$zoneid} and langid={$langid}");
$fcl->next_record();
$len = $fcl->f("cnt");
$fcl->free_result();
?>

<select name=lngid size="<?php 
echo $len + 1;
?>
"
 onChange="document.langmod.action='langmod.php';submit();">
<option value="" selected>[no change]

<?php 
$fcl->query("select * from lang " . "where langzid={$zoneid} and langid={$langid} order by langid");
Example #7
0
<a href="index.php?zoneid=<?php 
echo $zoneid;
?>
&langid=<?php 
echo $langid;
?>
">
Return To Central Maintenance Page</a><br>

</td></tr>
<tr><td valign=top align=center bgcolor=#ffffff>

<?php 
$fcl = new FC_SQL();
$fcm = new FC_SQL();
$fcz = new FC_SQL();
$fcm->query("select zoneid from master");
$fcm->next_record();
?>

<form method="post" action="masterupd.php">

<input type=hidden name=act value=update>
<input type=hidden name=srch value=<?php 
echo $srch;
?>
>
<input type=hidden name=show value="<?php 
echo $show;
?>
">
Example #8
0
header("Expires: " . GMDate("D, d M Y H:i:s") . " GMT");
require './admin.php';
require 'header.php';
require_once BITCART_PKG_PATH . 'functions.php';
// ========== start of variable loading ==========
// load passed variables and cookie variables
// int or double cast the numbers, no exceptions
// if $zid or $lid are found, they should be changed
// to $zoneid or $langid, respectively. Once all
// maint files are done, $zid and $lid can probably
// be eliminated.
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
// ==========  end of variable loading  ==========
$fcl = new FC_SQL();
$fcp = new FC_SQL();
if (!$zoneid || !$langid) {
    echo 'Please click Back and select a zone and/or language.  Thank you.';
    exit;
}
?>

<h2 align="center">Related Product Maintenance</h2>
<hr />

<?php 
$fcp->query("select count(*) as cnt from prodrel where relzone={$zoneid}");
$fcp->next_record();
$pt = $fcp->f('cnt');
$fcp->free_result();
?>
Example #9
0
" onClick="closehelp()">Return To Order Detail Query Page</a>
<br>
<a href="index.php?zoneid=<?php 
echo $zoneid;
?>
&langid=<?php 
echo $langid;
?>
" onClick="closehelp()">Return To Central Maintenance Page</a><br>

</td></tr>

<?php 
$fcohead = new FC_SQL();
$fcoline = new FC_SQL();
$fccust = new FC_SQL();
$ototal = (int) $ototal;
$notfound = 0;
if ($ototal) {
    $fcohead->query("select * from ohead where orderid='{$orderid}'");
    if (!$fcohead->next_record()) {
        $notfound = 1;
    }
} else {
    $notfound = 1;
}
if ($notfound) {
    echo '<tr><td align=center valign=middle colspan=4 bgcolor="#FFFFFF">' . 'Order record ' . $orderid . ' not found<br>' . '</td></tr>';
} else {
    // notfound
    $purchid = $fcohead->f("purchid");
Example #10
0
//getparam('zcnt'); // :VESTIGIAL?: mag 030703 Passed from productaddm.php, but not used herein
// Note. $zid and $lid are used in this script to hold optional values
// of $zoneid and $langid used in <select> elements.
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
$fcl = new FC_SQL();
// language
$fcp = new FC_SQL();
// check if product exists
$fcu = new FC_SQL();
// update product
$fcw = new FC_SQL();
// web
//$fcc = new FC_SQL; // :VESTIGIAL?: mag 030704 I don't see this used anywhere.
$fcz = new FC_SQL();
// zone
$now = time();
$droot = 'BITCART_PKG_PATH';
// figure out from the addzone* fields which zones must be processed
// accumulate a numeric indexed array $zins
$fcz->query("select zoneid from zone order by zoneid");
while ($fcz->next_record()) {
    $zid = (int) $fcz->f('zoneid');
    $tzid = (int) getparam('addzone' . $zid);
    //$tzid : this zone id, get the value of this zone flag
    if ($tzid) {
        // if this box was checked
        $zins[] = $zid;
        // process this zone (add this zone to array of zones to process)
    }
Example #11
0
First the options after updating all tables are fetched again
if there is an option in the current language defined it is
inserted into prodlflag1
(bvo)
*/
$fcco = new FC_SQL();
$fcco->query("select * from prodopt where poptzid={$zoneid} and poptlid={$langid}" . " and poptsku='{$ssku}'");
if ($fcco->next_record()) {
    $poptf = 1;
}
$fcco->free_result();
$plflag1 = 0;
if ($poptf) {
    $plflag1 |= (int) $flag_hasoption;
}
$fccr = new FC_SQL();
$fccr->query("update prodlang set prodlflag1={$plflag1} where prodlsku='{$ssku}'" . " and prodlzid={$zoneid} and prodlid={$langid}");
$fccr->commit();
//set the prodlflag correctly   bvo
?>

<p>

<?php 
if ($act == 'update' || $act == 'delete') {
    ?>
<form method=post action="prodoptndx.php">
<?php 
} else {
    ?>
<form method=post action="productmod.php">
Example #12
0
<?php

require_once '../bit_setup_inc.php';
require './functions.php';
require './public.php';
require './languages.php';
$esdid = (int) getparam('esdid');
if ($esdid == 0) {
    echo fc_text('esdnotrans');
    echo fc_text('esdcustsvc');
    exit;
}
require './pwesd.php';
$now = time();
// increment the download count
$fcesd = new FC_SQL();
$fcesd->query("select esddlcnt,esddlmax,esddlexp,esddlfile from esd " . "where esdid={$esdid} and esdoid='{$pwuid}'");
if (!$fcesd->next_record()) {
    echo fc_text('esdnodl');
    echo fc_text('esdcustsvc');
    exit;
}
$esddlcnt = (int) $fcesd->f('esddlcnt') + 1;
$esddlmax = (int) $fcesd->f('esddlmax');
$esddlexp = (int) $fcesd->f('esddlexp');
$esddlfile = $fcesd->f('esddlfile');
$fcesd->free_result();
if ($esddlcnt > $esddlmax || $now > $esddlexp) {
    echo fc_text('esddlmax');
    echo fc_text('esdcustsvc');
    exit;
Example #13
0
// maint files are done, $zid and $lid can probably
// be eliminated.
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
if (!$zoneid || !$langid) {
    ?>
  A zone or language ID was not selected.
        <p>Please click the <a href='self.history.back()'>Back</a> button on your browser
        and select a zone.  Thank you.
    <?php 
    exit;
}
$fcp = new FC_SQL();
$fcp->query("select zonedescr from zone where zoneid='{$zoneid}' and zonedeflid='{$langid}'");
if ($fcp->next_record()) {
    $zone_name = $fcp->f("zonedescr") . "<br>";
    $fcp->free_result();
}
?>

<table align=center cellspacing=0 cellpadding=4 bgcolor=#666666 width=650 class="text">
  <tr valign="middle" align="center">
    <td bgcolor=#ffffff>
      <h2>FishCart Reporting Module</h2>
    </td>
  </tr>
</table>
<hr>
Example #14
0
$pwzone = (int) getparam('pwzone');
$pwjan = (int) getparam('pwjan');
$pwfeb = (int) getparam('pwfeb');
$pwmar = (int) getparam('pwmar');
$pwapr = (int) getparam('pwapr');
$pwmay = (int) getparam('pwmay');
$pwjun = (int) getparam('pwjun');
$pwjul = (int) getparam('pwjul');
$pwaug = (int) getparam('pwaug');
$pwsep = (int) getparam('pwsep');
$pwoct = (int) getparam('pwoct');
$pwnov = (int) getparam('pwnov');
$pwdec = (int) getparam('pwdec');
// ==========  end of variable loading  ==========
require './admin.php';
$fcpw = new FC_SQL();
if ($action == 'A' || $action == 'M') {
    if ($pwdescr == '' || $pwuid == '' || $pwpw == '' || $pwemail == '') {
        ?>
<p>A field has been left blank; please return to the password
maintenance page and enter valid values in the Description, E-Mail, User ID
and Password fields.
<p>
<a href="pwndx.php?zoneid=<?php 
        echo $zoneid;
        ?>
&langid=<?php 
        echo $langid;
        ?>
"
 onClick="closehelp();">Return to Password Maintenance Page</a><br>
Example #15
0
//array lseq and link are handled below
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
$fcc = new FC_SQL();
if ($act == "add") {
    if (strlen($title) == 0 || strlen($text) == 0) {
        ?>
	<p>One of the fields was left blank. Both fields must be filled
	in to have a functioning link.<p>Please click the
	&quot;Back&quot; button on your browser	and correct the
	errors.  Thank you.</p>
<?php 
        exit;
    }
    $max_seq = new FC_SQL();
    if ($databaseeng == 'odbc' && $dialect == 'solid') {
        $max_seq->query("select seq from auxtext where rownum < 2 order by seq desc");
    } elseif ($databaseeng == 'postgres') {
        $max_seq->query("select seq from auxtext order by seq desc limit 1,0");
    } elseif ($databaseeng == 'mssql') {
        $max_seq->query("select top 1 seq from auxtext order by seq desc");
    } elseif ($databaseeng == 'oracle') {
        $max_seq->query("select seq from auxtext where rownum < 2 order by seq desc");
    } elseif ($databaseeng == 'mysql') {
        $max_seq->query("select seq from auxtext order by seq desc limit 0,1");
    }
    $max_seq->next_record();
    $seq = $max_seq->f("seq") + 1;
    $max_seq->free_result();
    $res = $fcc->query("insert into auxtext (" . "seq,loc,title,text) values ({$seq},{$loc},'{$title}','{$text}')");
Example #16
0
}
?>
>&nbsp;Yes<br>
<input type=radio name=pwactive value="0"<?php 
if (!$pwactive) {
    ?>
 checked<?php 
}
?>
>&nbsp;No<br>

<b>Permitted zone for this user:</b><br>
<select name="pwzone" size="1">
<option value="0">[-- All Zones --]
<?php 
$fcz = new FC_SQL();
$fcz->query("select zoneid,zonedescr from zone");
while ($fcz->next_record()) {
    $zid = $fcz->f('zoneid');
    $zdesc = stripslashes($fcz->f('zonedescr'));
    if ($zid == $pwzone) {
        echo "<option value=\"{$zid}\" selected>{$zdesc}\n";
    } else {
        echo "<option value=\"{$zid}\">{$zdesc}\n";
    }
}
?>
</select><br>

<input type="hidden" name="action" value="M">
<input type="hidden" name="oldpwuid" value="<?php 
Example #17
0
// custid cookie is mime encoded, don't escape
$CookieCustID = getcookie("Cookie{$instid}CustID");
$CookieCart = getcookie("Cookie{$instid}Cart");
$cartid = getparam('cartid');
$zid = (int) getparam('zid');
$lid = (int) getparam('lid');
$subz = (int) getparam('subz');
$ccexp_years = (int) getparam('ccexp_years');
$mode = getparam('mode');
// ==========  end of variable loading  ==========
require_once BITCART_PKG_PATH . 'public.php';
require_once BITCART_PKG_PATH . 'cartid.php';
require_once BITCART_PKG_PATH . 'languages.php';
require_once BITCART_PKG_PATH . 'flags.php';
$fcl = new FC_SQL();
$fcz = new FC_SQL();
$fcz->query("select zonecurrsym,zflag1 from zone where zoneid={$zid}");
if ($fcz->next_record()) {
    $csym = stripslashes($fcz->f("zonecurrsym"));
    $csym = trim($csym);
    $zflag1 = (int) $fcz->f('zflag1');
} else {
    $csym = '';
    $zflag1 = 0;
}
// get the language templates
$fcl->query("select langterms,langcopy,langordr from lang where langid={$lid}");
$fcl->next_record('langterms');
if (!empty($showscat)) {
    $tmpl = stripslashes($fcl->f('langstmpl'));
} else {
Example #18
0
// int or double cast the numbers, no exceptions
// custid cookie is mime encoded, don't escape
$pwlostmail = getparam('pwlostmail');
// ==========  end of variable loading  ==========
require './public.php';
if (eregi("^[a-z0-9_\\'\\.-]+@[a-z0-9_\\.-]+\\.[a-z]{2,4}\$", $pwlostmail)) {
    $pwlostmail = $pwlostmail;
} else {
    $pwlostmail = "";
}
if ($pwlostmail == "") {
    echo 'no email address found or no valid email address in your request';
    exit;
}
// retrieve the record for the email address
$wwkwijt = new FC_SQL();
$wwkwijt->query("SELECT pwactive,pwemail,pwuid,pwpw from pw " . "where pwemail='{$pwlostmail}' limit 1");
$wwkwijt->next_record();
if ($wwkwijt->f("pwuid") == "") {
    //no record for this address so we're supposed to build an errormessage here
    //let's keep it simple for now
    //this will be fixed in the next release
    echo "sorry, we don't know the address entered";
    exit;
}
if ($wwkwijt->f("pwactive") == "0") {
    //login is not active so we're supposed to build an errormessage here
    //let's keep it simple for now
    //this will be fixed in the next release
    echo 'account is currently not active';
    exit;
Example #19
0
<tr><td class="showcartcell" colspan="1" bgcolor="#FFFFFF"></td>
<td class="showcartcell" colspan="2" align="left" valign="top" bgcolor="#FFFFFF">

<b><?php 
        echo fc_text('shipfee');
        ?>
</b><br />

<?php 
        if ($allowupdate) {
            if ($scnt > 1) {
                ?>
<select name="shipid" size="1" onChange="submit(); return false;">
<?php 
                $fcmt = new FC_SQL();
                $fcmt->query("select ship.shipid,shipdef,shipdescr " . "from ship,subzship " . "where shipzid={$zid} " . "and shipszid={$subz} " . "and ship.shiplid={$lid} " . "and subzship.shiplid={$lid} " . "and subzship.shipid=ship.shipid " . "and subzship.shiplid=ship.shiplid " . "order by ship.shipid");
                while ($fcmt->next_record()) {
                    if ($curshipid == (int) $fcmt->f("shipid")) {
                        ?>
<option value="<?php 
                        echo $fcmt->f("shipid");
                        ?>
" selected><?php 
                        echo stripslashes($fcmt->f("shipdescr"));
                        ?>
</option>
<?php 
                    } else {
                        ?>
<option value="<?php 
Example #20
0
<form method="post" action="ascupd.php">

<input type="hidden" name="act" value="new" />

<input type="hidden" name="zoneid" value="<?php 
echo $zoneid;
?>
" />
<input type="hidden" name="langid" value="<?php 
echo $langid;
?>
" />

Select Web Profile for this Associate
<?php 
$fcw = new FC_SQL();
$fcw->query("select count(*) as cnt from web " . "where webzid={$zoneid} and weblid={$langid}");
$wt = (int) $fcw->f("cnt");
$fcw->free_result();
$fcw->query("select * from web " . "where webzid={$zoneid} and weblid={$langid} order by webid");
?>

<select name="ascwebid" size="<?php 
echo $wt + 1;
?>
">
<option value="0" selected>[no web profile]</option>
<?php 
while ($fcw->next_record()) {
    ?>
   <option value="<?php 
Example #21
0
$ordr = $fcl->f("langordr");
$copy = $fcl->f("langcopy");
$lterms = $fcl->f("langterms");
$fcl->free_result();
if (!empty($doit)) {
    if ($zflag1 & $flag_zonetcpage) {
        // set for inline terms and conditions
        $ordr = 'terms.php';
    }
    $contrib = str_replace("\$", "", $contrib);
    $contrib = str_replace(",", "", $contrib);
    $c = (double) $contrib;
    if ($c < 0) {
        $c = (double) 0;
    }
    $fch = new FC_SQL();
    $fch->query("update ohead set contrib={$c} where orderid='{$cartid}'");
    $fch->commit();
    header("Location: {$securl}{$secdir}/{$ordr}?" . "cartid={$cartid}&zid={$zid}&lid={$lid}&subz={$subz}");
    exit;
} else {
    $contamt = (double) $fco->f("contrib");
}
// END OF ESSENTIAL CART DISPLAY CODE FROM LINE 1 TO HERE
?>
<html>
<head>
<link rel="stylesheet" ID href="style.css" type="text/css" />
<title></title></head>
<body bgcolor="#FFFFFF" marginheight="0" marginwidth="0" topmargin="0" leftmargin="0">
Example #22
0
if ($prodflag1 & $flag_useesd) {
    $flag1 |= (int) $flag_useesd;
}
if ($prodflag1 & $flag_genesd) {
    $flag1 |= (int) $flag_genesd;
}
if ($prodflag1 & $flag_persvc) {
    $flag1 |= (int) $flag_persvc;
}
if ($prodflag1 & $flag_package) {
    $flag1 |= (int) $flag_package;
}
if ($prelf) {
    $flag1 |= (int) $flag_hasrel;
}
$fccr = new FC_SQL();
$fccr->query("update prod set prodflag1={$flag1} where prodsku='{$relsku}'" . " and prodzid={$zoneid}");
$fccr->commit();
if ($act == 'insert') {
    ?>
    <form method="post" action="prodreladd.php">
<?php 
} else {
    ?>
    <form method="post" action="prodrelndx.php">
<?php 
}
?>
<input type="hidden" name="zoneid" value="<?php 
echo $zoneid;
?>
Example #23
0
	<p>Please click the &quot;Back&quot; button on your browser
	and correct the errors.  Thank you.
    <?php 
    exit;
}
if ($act == "insert" || $act == "update") {
    if ($nsm != "" && $nsd != "" && $nsy != "" && $nem != "" && $ned != "" && $ney != "") {
        $sdate = mktime(0, 0, 0, $nsm, $nsd, $nsy);
        $ndate = mktime(0, 0, 0, $nem, $ned, $ney);
    } else {
        $sdate = 0;
        $ndate = 0;
    }
}
$fco = new FC_SQL();
$fcu = new FC_SQL();
if ($act == "insert") {
    $fcu->query("select count(*) as cnt from oprod where oprodsku='{$sku}'");
    $fcu->next_record();
    if ($fcu->f('cnt') == 0) {
        $fco->query("insert into oprod (oprodsku,ostart,oend,ozid) " . "values ('{$sku}',{$sdate},{$ndate},{$zoneid})");
    }
    $fcu->free_result();
} elseif ($act == "update") {
    $fco->query("update oprod " . "set oprodsku='{$sku}',ostart={$sdate},oend={$ndate} where oprodsku='{$sku}'");
} elseif ($act == "delete") {
    $fco->query("delete from oprod where oprodsku='{$sku}'");
}
$fco->commit();
?>
Example #24
0
        echo '<option value="' . $key . '" selected>' . $val . "\n";
    } else {
        echo '<option value="' . $key . '">' . $val . "\n";
    }
}
?>
</select>

<p>
Front page promotions category for this language:<br />
<select name="langfppromo" size="1">
<option value="">[select a category]</option>
<?php 
$fp_cat = (int) $fcl->f("langfppromo");
$get_cats = new FC_SQL();
$get_scats = new FC_SQL();
$get_cats->query("select catval,catpath from cat " . "where catzid={$zoneid} and catlid={$lngid} order by catpath");
while ($get_cats->next_record()) {
    $patharray = explode(":", $get_cats->f("catpath"));
    $catlst = $get_cats->f("catval");
    $selected = '';
    if ($catlst == $fp_cat) {
        $selected = ' selected';
    }
    print "<option value=\"{$catlst}\"{$selected}>";
    while (list($key, $val) = each($patharray)) {
        if ($val != "") {
            $get_scats->query("select catdescr from cat " . "where catzid={$zoneid} and catlid={$lngid} and catval={$val}");
            if ($get_scats->next_record()) {
                print '/' . $get_scats->f("catdescr");
                $get_scats->free_result();
Example #25
0
$cybercash->ccname = "{$cc_name}";
$cybercash->address1 = "{$billing_address1}";
$cybercash->address2 = "{$billing_address2}";
$cybercash->cccity = "{$billing_city}";
$cybercash->ccstate = "{$billing_state}";
$cybercash->cczip = "{$billing_zip}";
$cybercash->cccountry = "USA";
// submit the charge to CyberCash and parse out the return data
if (!$cybercash->send()) {
    $cybercash->errorHandler("Error: no data received back from CyberCash");
}
$POP = $cybercash->POP;
parse_str(ereg_replace("pop.", "", $POP));
if ($status != 'success') {
    // get the Web table
    $fcw = new FC_SQL();
    $fcw->query("select webback,webtext,weblink,webvlink,webalink,webbg,webfree,websort " . "from fishcart where webzid={$zid} and weblid={$lid}");
    $fcw->next_record();
    $srt = $fcw->f("websort");
    $fcw->free_result();
    // END OF ESSENTIAL CART DISPLAY CODE FROM LINE 1 TO HERE
    ?>

<html>
<head>
<link rel="stylesheet" ID href="style.css" type="text/css" />
<title>
</title>
</head>

<body<?php 
Example #26
0
    $langterms = nl2br($langterms);
}
if ($langzid == "") {
    ?>
  A Zone ID was not selected.
	<p>Please click the &quot;Back&quot; button on your browser
	and correct the errors.  Thank you.
    <?php 
    exit;
}
$fcl = new FC_SQL();
$fcm = new FC_SQL();
$fct = new FC_SQL();
$fcta = new FC_SQL();
$fctb = new FC_SQL();
$fctc = new FC_SQL();
if ($act == "update") {
    //get the old langfppromo
    $fcta->query("select langfppromo from lang where langid={$lngid} and " . "langzid={$zoneid}");
    if ($fcta->next_record()) {
        $oldfppromo = (int) $fcta->f('langfppromo');
    }
    $fcta->free_result();
    // oracle clob
    if ($databaseeng == "oracle") {
        $res = $fcl->query("update lang set " . "langzid={$langzid},     langdescr='{$langdescr}',langtmpl='{$langtmpl}', " . "langtdsp='{$langtdsp}', langterr='{$langterr}',  langshow='{$langshow}', " . "langgeo='{$langgeo}',   langordr='{$langordr}',  langfinl='{$langfinl}', " . "langproc='{$langproc}', langstmpl='{$langstmpl}',langiso ='{$langiso}', " . "langwelcome='{$langwelcome}',langcopy='{$langcopy}',langterms=empty_clob()," . "langfppromo={$langfppromo} " . "where langid={$lngid}", langterms, $langterms);
    } else {
        $res = $fcl->query("update lang set " . "langzid={$langzid},     langdescr='{$langdescr}',langtmpl='{$langtmpl}', " . "langtdsp='{$langtdsp}', langterr='{$langterr}',  langshow='{$langshow}', " . "langgeo='{$langgeo}',   langordr='{$langordr}',  langfinl='{$langfinl}', " . "langproc='{$langproc}', langstmpl='{$langstmpl}',langiso ='{$langiso}', " . "langwelcome='{$langwelcome}',langcopy='{$langcopy}',langterms='{$langterms}'," . "langfppromo={$langfppromo} " . "where langid={$lngid}");
    }
} elseif ($act == "new") {
    $fcm->query('select numlang from master');
Example #27
0
*/
header("Expires: " . GMDate("D, d M Y H:i:s") . " GMT");
require_once '../../bit_setup_inc.php';
$gBitSystem->verifyPermission('bit_p_bitcart_admin');
require_once BITCART_PKG_PATH . 'functions.php';
// ========== start of variable loading ==========
// load passed variables and cookie variables
// int or double cast the numbers, no exceptions
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
$catcount = (int) getparam('catcount');
// values of catseq is an array handled below
// ==========  end of variable loading  ==========
require './admin.php';
require './header.php';
$fcc = new FC_SQL();
if (!$zoneid || !$langid) {
    ?>
  A zone or language ID was not selected.
	<p>Please click the &quot;Back&quot; button on your browser
	and select a zone.  Thank you.
    <?php 
    exit;
}
$i = 0;
while ($i < $catcount) {
    $seq = (int) getparam('catseq' . $i);
    $cid = (int) getparam('catval' . $i);
    $fcc->query("update cat set catseq={$seq} " . "where catzid={$zoneid} and catval={$cid}");
    $i++;
}
Example #28
0
require_once '../../bit_setup_inc.php';
require './admin.php';
require './header.php';
require_once BITCART_PKG_PATH . 'functions.php';
// ========== start of variable loading ==========
// load passed variables and cookie variables
// int or double cast the numbers, no exceptions
// if $zid or $lid are found, they should be changed
// to $zoneid or $langid, respectively. Once all
// maint files are done, $zid and $lid can probably
// be eliminated.
$zoneid = (int) getparam('zoneid');
$langid = (int) getparam('langid');
// ==========  end of variable loading  ==========
$fcs = new FC_SQL();
$fcz = new FC_SQL();
?>

<h2 align="center">SubZone Maintenance</h2>
<hr />

<center>
<table border="0" cellpadding="4" cellspacing="1" bgcolor="#666666" width="650" class="text">
<tr><td colspan="2" align="center" bgcolor="#ffffff">

<a href="index.php?zoneid=<?php 
echo $zoneid;
?>
&amp;langid=<?php 
echo $langid;
?>
Example #29
0
<center>
<table border=0 cellpadding=4 cellspacing=1 bgcolor=#666666 width=650 class="text">
<tr><td align=center valign=middle colspan=1 bgcolor=#FFFFFF>

<a href="index.php?zoneid=<?php 
echo $zoneid;
?>
&langid=<?php 
echo $langid;
?>
" onClick="closehelp()">Return To Central Maintenance Page</a><br>

</td></tr>

<?php 
$fckey = new FC_SQL();
$fckey->query("select count(*) as cnt from keyword");
$fckey->next_record();
$ktotal = $fckey->f("cnt");
$fckey->free_result();
?>

<tr><td align=left valign=top colspan=1 bgcolor=#ffffff>
<i>Total keywords logged: <?php 
echo $ktotal;
?>
</i>
<p>

Number of Keywords to View:<br>
<i>0 for all keywords</i><br>
Example #30
0
</td><td align="center" bgcolor="#FFFFFF">

<b>Delete An Existing Coupon Profile</b>

</td></tr>
<tr><td align="center" bgcolor="#FFFFFF">

<form name="couponmod" method="post" action="couponmod.php">

To modify an existing coupon profile,<br />
select its name from the list and<br />
click <i>Modify Selected Profile</i>.
<br />

<?php 
$coupon = new FC_SQL();
$coupon->query("select count(*) as cnt from coupon");
$coupon->next_record();
$len = (int) $coupon->f("cnt");
$coupon->free_result();
?>

<select name="cpnid" size="<?php 
echo $len + 1;
?>
"
 onChange="document.couponmod.action='couponmod.php';submit();">
<option name=cpnid value="" selected>[no change]</option>
<?php 
// query the coupon
$coupon->query("select cpnid,cpnredeem from coupon order by cpnid");