<?php include './../../include/session.php'; include './../../include/conn.php'; include './../../include/myfunction.php'; include './../../include/adfunction.php'; include './../../include/page.class.php'; $currentPage = 'PaiMaiList'; $manageGroup = 'hezuoGroup'; if (isset($_GET['html'])) { //$html=1&week=1 $gethtml = $_GET['html']; if ($gethtml == 1) { $getweek = $_GET['week']; if (htmlAD('userpp', $getweek, 1)) { $fphtml = "生成成功"; } } } if (isset($_GET['delete'])) { if ($_GET['delete'] == 1) { $deleteid = $_GET['id']; if (!empty($deleteid)) { $sql = "delete from ad_paimai where id={$deleteid}"; mysql_query($sql); $result = mysql_affected_rows(); if ($result > 0) { $msn = "删除成功"; } } }
function autoad($endtime, $getweek) { if (time() > $endtime) { $sql = "select b.name as adpsname,c.name as ppusname,c.jifen as usjifen,a.* from ad_paimai as a left join ad_type as b on a.week=b.week left join user as c on a.userid=c.id where a.status=1 and a.week={$getweek}"; $result = mysql_query($sql); $ppcount = mysql_num_rows($result); if ($ppcount > 0) { while ($row = mysql_fetch_assoc($result)) { $adid['id'][] = $row['id']; $adid['title'][] = $row['title']; $adid['link'][] = $row['link']; $adid['pic_url'][] = $row['pic_url']; $adid['week'][] = $row['week']; $adid['ad_start_time'][] = $row['ad_start_time']; $adid['ad_end_time'][] = $row['ad_end_time']; $adid['userid'][] = $row['userid']; $adid['adpsname'][] = $row['adpsname']; $adid['jifen'][] = $row['jifen']; $adid['ppusname'][] = $row['ppusname']; $adid['usjifen'][] = $row['usjifen']; } foreach ($adid['id'] as $key => $idvalue) { if (Zbkupdate('ad_paimai', array('status' => 2), "status=1 and id={$idvalue} and week={$getweek}")) { $sql = "select week from ad where week=" . $adid['week'][$key]; $result = mysql_query($sql); $row = mysql_fetch_assoc($result); Zbkinsert('jifen_log', array('name' => $adid['ppusname'][$key], 'jifen' => -$adid['jifen'][$key], 'XiaoJi' => $adid['usjifen'][$key], 'create_time' => time(), 'jf_mingxi' => '竞拍广告位中标扣除积分')); if ($row['week']) { Zbkupdate('ad', array('status' => 2, 'name' => $adid['adpsname'][$key], 'pp_id' => $adid['id'][$key], 'userid' => $adid['userid'][$key], 'title' => $adid['title'][$key], 'link' => $adid['link'][$key], 'pic_url' => $adid['pic_url'][$key], 'week' => $adid['week'][$key], 'ad_start_time' => $adid['ad_start_time'][$key], 'ad_end_time' => $adid['ad_end_time'][$key]), 'week=' . $adid['week'][$key]); htmlAD('userpp', $getweek, 1); } else { Zbkinsert('ad', array('status' => 2, 'name' => $adid['adpsname'][$key], 'pp_id' => $adid['id'][$key], 'userid' => $adid['userid'][$key], 'title' => $adid['title'][$key], 'link' => $adid['link'][$key], 'pic_url' => $adid['pic_url'][$key], 'week' => $adid['week'][$key], 'ad_start_time' => $adid['ad_start_time'][$key], 'ad_end_time' => $adid['ad_end_time'][$key])); htmlAD('userpp', 'getweek', 1); } } } } } }