MySQL Forums
Forum List  »  Partitioning

Here are some of the crons that run.
Posted by: john hango
Date: September 06, 2010 11:38PM

This cleans up the auction feilds data

<? if (!$manualCron) {
include_once("../config/config.php");
$dir_parent = "../";
} else {
$dir_parent = "";
}
if (!$s_sess_lang||$s_sess_lang=="n/a"||$s_sess_lang=="") {
include_once("../config/lang/".$setts['default_lang']."/site.lang");
$s_sess_lang = $setts['default_lang'];
//start of updating sessions
$_SESSION[$setts['pk']."_sessioner"] = base64_encode(nash_cc_encrypt($s_membersarea."[XAX]".$s_memberlastaccess."[XAX]".$s_memberid."[XAX]".$s_membername."[XAX]".$s_memberusern."[XAX]".$s_password."[XAX]".$s_sms_phone_number."[XAX]".$s_sms_message."[XAX]".$s_syidescription."[XAX]".$s_nb_items_per_page."[XAX]".$s_is_myfolders."[XAX]".$s_option."[XAX]".$s_charity_id."[XAX]".$s_scatid."[XAX]".$s_sstep."[XAX]".$s_llistin."[XAX]".$s_ageOkToBid."[XAX]".$s_memberzip."[XAX]".$s_memberland."[XAX]".$s_accsusp."[XAX]".$s_is_guest."[XAX]".$s_is_seller."[XAX]".$s_auctionid_refresh."[XAX]".$s_buynow_refresh."[XAX]".$s_buynow_timeout."[XAX]".$s_sess_lang."[XAX]".$s_table_to_modify."[XAX]".$s_slandid."[XAX]".$s_landname."[XAX]".$s_landflag."[XAX]".$s_mygateza_merch_id."[XAX]".$s_mygateza_app_id."[XAX]".$s_mygateza_currency."[XAX]".$s_setcom_email."[XAX]".$s_setcom_username."[XAX]".$s_setcom_pw."[XAX]".$s_setcom_currency."[XAX]".$s_label_comment1."[XAX]".$s_label_comment2."[XAX]".$s_label_comment3."[XAX]".$s_label_comment4."[XAX]".$s_label_comment5."[XAX]".$s_comment1."[XAX]".$s_comment2."[XAX]".$s_comment3."[XAX]".$s_comment4."[XAX]".$s_comment5."[XAX]".$s_quantity."[XAX]".$s_pagseguro_token."[XAX]".$s_show_msg."[XAX]".$s_showcountry."[XAX]".$s_nrs2,$setts['myprivatekey']));
//end of updating sessions
} else {
include_once("../config/lang/".$s_sess_lang."/site.lang");
}
// routine: clean yspnash_fields_data table off the outdated rows
$fields = mysql_query("SELECT SQL_CACHE id,auctionid FROM yspnash_fields_data WHERE 1");
$nb_fields = mysql_num_rows($fields);
if ($nb_fields>0) {
while ($field = mysql_fetch_array($fields)) {
$isItem = getSqlNumber("SELECT id FROM yspnash_auctions WHERE id='".$field['auctionid']."'");
if ($isItem==0) $delFields = mysql_query("DELETE FROM yspnash_fields_data WHERE id='".$field['id']."'");
}
echo "".$lang[nash5365]."";
} else {
echo "".$lang[nash5366]."";
}?>

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.