Пример #1
0
 public function do_clear()
 {
     mysqld_delete('bigwheel_award', array());
     mysqld_delete('bigwheel_fans', array());
     mysqld_delete('bigwheel_reply', array());
     message('活动重置成功!', "refresh", 'success');
 }
Пример #2
0
<?php

if ($_CMS['addons_bj_hx']) {
    if (!empty($_GP['isverify'])) {
        mysqld_delete('bj_hx_verify_goods', array('goodsid' => $id));
        if (!empty($_GP['verifyshop_cb'])) {
            foreach ($_GP['verifyshop_cb'] as $verifyshop_cb) {
                mysqld_insert('bj_hx_verify_goods', array('goodsid' => $id, 'verifyid' => $verifyshop_cb, 'createtime' => time()));
            }
        }
    } else {
        mysqld_delete('bj_hx_verify_goods', array('goodsid' => $id));
    }
}
Пример #3
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
    mysqld_delete('addon10_scene_subscribe', array("id" => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
}
$subscribe_list = mysqld_selectall("SELECT subscribe.*,sl.title FROM " . table('addon10_scene_subscribe') . " subscribe left join " . table('addon10_scene_list') . "  sl on sl.id=subscribe.list_id ");
include addons_page('subscribe');
Пример #4
0
<?php

defined('SYSTEM_IN') or exit('Access Denied');
hasrule('weixin', 'weixin');
$settings = globaSetting();
$payment = mysqld_select("SELECT * FROM " . table('payment') . " WHERE code = :code", array(':code' => 'weixin'));
if (!empty($payment['configs'])) {
    $paymentconfig = unserialize($payment['configs']);
}
$thirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE code = :code", array(':code' => 'weixin'));
if (checksubmit()) {
    $cfg = array('weixinname' => $_GP['weixinname'], 'weixintoken' => $_GP['weixintoken'], 'EncodingAESKey' => $_GP['EncodingAESKey'], 'weixin_appId' => $_GP['weixin_appId'], 'weixin_appSecret' => $_GP['weixin_appSecret'], 'weixin_autoreg' => $_GP['weixin_autoreg']);
    refreshSetting($cfg);
    mysqld_delete('config', array('name' => 'weixin_access_token'));
    $settings = globaSetting();
    $thirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE code = :code", array(':code' => 'weixin'));
    require WEB_ROOT . '/system/modules/plugin/thirdlogin/weixin/lang.php';
    if (empty($thirdlogin['id'])) {
        $data = array('code' => 'weixin', 'enabled' => intval($_GP['thirdlogin_weixin']), 'name' => $_LANG['thirdlogin_weixin_name']);
        mysqld_insert('thirdlogin', $data);
    } else {
        $data = array('enabled' => intval($_GP['thirdlogin_weixin']), 'name' => $_LANG['thirdlogin_weixin_name']);
        mysqld_update('thirdlogin', $data, array('code' => 'weixin'));
    }
    if (empty($settings['weixintoken']) && !empty($_GP['weixintoken'])) {
        header("location:" . create_url('site', array('name' => 'weixin', 'do' => 'setting')));
    } else {
        message('保存成功', 'refresh', 'success');
    }
}
if (empty($settings['weixintoken'])) {
Пример #5
0
         if (empty($row)) {
             continue;
         }
         $hsdata[$index] = array('attachment' => $_GP['attachment-new'][$index]);
     }
     $cur_index = $index + 1;
 }
 if (!empty($_GP['attachment'])) {
     foreach ($_GP['attachment'] as $index => $row) {
         if (empty($row)) {
             continue;
         }
         $hsdata[$cur_index + $index] = array('attachment' => $_GP['attachment'][$index]);
     }
 }
 mysqld_delete('shop_goods_piclist', array('goodid' => $id));
 foreach ($hsdata as $row) {
     $data = array('goodid' => $id, 'picurl' => $row['attachment']);
     mysqld_insert('shop_goods_piclist', $data);
 }
 //处理商品规格
 $files = $_FILES;
 $spec_ids = $_POST['spec_id'];
 $spec_titles = $_POST['spec_title'];
 $specids = array();
 $len = count($spec_ids);
 $specids = array();
 $spec_items = array();
 for ($k = 0; $k < $len; $k++) {
     $spec_id = "";
     $get_spec_id = $spec_ids[$k];
Пример #6
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
    mysqld_delete('addon8_article', array("id" => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
}
if ($operation == 'post') {
    $category = mysqld_selectall("SELECT * FROM " . table('addon8_article_category') . "  where deleted=0  ORDER BY parentid ASC, displayorder DESC", array(), 'id');
    if (!empty($category)) {
        $children = '';
        foreach ($category as $cid => $cate) {
            if (!empty($cate['parentid'])) {
                $children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
            }
        }
    }
    $article = mysqld_select("SELECT * FROM " . table('addon8_article') . " where id='" . intval($_GP['id']) . "' ");
    if (checksubmit('submit')) {
        if (empty($article['id'])) {
            $data = array('createtime' => time(), 'pcate' => intval($_GP['pcate']), 'ccate' => intval($_GP['ccate']), 'iscommend' => intval($_GP['iscommend']), 'ishot' => intval($_GP['ishot']), 'mobileTheme' => intval($_GP['mobileTheme']), 'title' => $_GP['title'], 'readcount' => intval($_GP['readcount']), 'description' => $_GP['description'], 'content' => htmlspecialchars_decode($_GP['content']), 'displayorder' => intval($_GP['displayorder']));
            if (!empty($_GP['thumb_del'])) {
                $data['thumb'] = '';
            }
            if (!empty($_FILES['thumb']['tmp_name'])) {
                file_delete($_GP['thumb_old']);
                $upload = file_upload($_FILES['thumb']);
                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $data['thumb'] = $upload['path'];
Пример #7
0
 public function do_user()
 {
     global $_GP;
     $operation = !empty($_GP['op']) ? $_GP['op'] : 'listuser';
     if ($operation == 'listuser') {
         $list = mysqld_selectall("select * from " . table('user'));
         include page('listuser');
     }
     if ($operation == 'rule') {
         $allrule = mysqld_selectall('SELECT * FROM ' . table('rule'));
         $id = $_GP['id'];
         $account = mysqld_select('SELECT * FROM ' . table('user') . " WHERE  id=:id", array(':id' => $id));
         $username = $account['username'];
         $userRule = mysqld_selectall('SELECT * FROM ' . table('user_rule') . " WHERE  uid=:uid", array(':uid' => $id));
         foreach ($allrule as $key => $item) {
             foreach ($userRule as $rule) {
                 if ($item['modname'] == $rule['modname'] && $item['moddo'] == $rule['moddo']) {
                     $allrule[$key]['check'] = true;
                 }
             }
         }
         if (checksubmit('submit')) {
             if (empty($id)) {
                 message('操作异常', refresh(), 'error');
             }
             if (!empty($account['id'])) {
                 mysqld_delete('user_rule', array('uid' => $account['id']));
                 foreach ($allrule as $item) {
                     if (!empty($_GP[$item['modname'] . '-' . $item['moddo']])) {
                         $data = array('uid' => $account['id'], 'modname' => $item['modname'], 'moddo' => $item['moddo']);
                         mysqld_insert('user_rule', $data);
                     }
                 }
             }
             message('权限修改成功!', refresh(), 'succes');
         }
         include page('rule');
     }
     if ($operation == 'deleteuser') {
         mysqld_delete('user', array('id' => $_GP['id']));
         mysqld_delete('user_rule', array('uid' => $_GP['id']));
         message('删除成功', refresh(), 'success');
     }
     if ($operation == 'changepwduser') {
         $account = mysqld_select('SELECT * FROM ' . table('user') . " WHERE  id=:id", array(':id' => $_GP['id']));
         $username = $account['username'];
         $id = $account['id'];
         if (checksubmit('submit')) {
             if (empty($_GP['newpassword'])) {
                 message('密码不能为空', refresh(), 'error');
             }
             if (!empty($account['id'])) {
                 if ($_GP['newpassword'] != $_GP['confirmpassword']) {
                     message('两次密码不一致!', refresh(), 'error');
                 }
                 $data = array('password' => md5($_GP['newpassword']));
                 mysqld_update('user', $data, array('id' => $account['id']));
                 message('密码修改成功!', create_url('site', array('name' => 'user', 'do' => 'listuser')), 'succes');
             } else {
                 message($_GP['username'] . '用户名已存在', refresh(), 'error');
             }
         }
         include page('changepwd');
     }
     if ($operation == 'adduser') {
         $allrule = mysqld_selectall('SELECT * FROM ' . table('rule'));
         if (checksubmit('submit')) {
             if (empty($_GP['username']) || empty($_GP['newpassword'])) {
                 message('用户名或密码不能为空', refresh(), 'success');
             }
             $account = mysqld_select('SELECT * FROM ' . table('user') . " WHERE  username=:username", array(':username' => $_GP['username']));
             if (empty($account['id'])) {
                 if ($_GP['newpassword'] != $_GP['confirmpassword']) {
                     message('两次密码不一致!', refresh(), 'error');
                 }
                 $data = array('username' => $_GP['username'], 'password' => md5($_GP['newpassword']));
                 mysqld_insert('user', $data);
                 $account = mysqld_select('SELECT * FROM ' . table('user') . " WHERE  username=:username", array(':username' => $_GP['username']));
                 if (!empty($account['id'])) {
                     mysqld_delete('user_rule', array('uid' => $account['id']));
                     foreach ($allrule as $item) {
                         if (!empty($_GP[$item['modname'] . '-' . $item['moddo']])) {
                             $data = array('uid' => $account['id'], 'modname' => $item['modname'], 'moddo' => $item['moddo']);
                             mysqld_insert('user_rule', $data);
                         }
                     }
                 }
                 message('新增用户成功!', web_url('user'), 'succes');
             } else {
                 message($_GP['username'] . '用户名已存在', refresh(), 'error');
             }
         }
         include page('adduser');
     }
 }
Пример #8
0
<?php

$setting = mysqld_select("SELECT * FROM " . table('addon7_config'));
if (checksubmit("submit")) {
    $cfg = array('title' => $_GP['title']);
    mysqld_delete('addon7_config', array());
    mysqld_insert('addon7_config', $cfg);
    message('保存成功', 'refresh', 'success');
}
include addons_page('setting');
Пример #9
0
} elseif ($operation == 'post') {
    $id = intval($_GP['id']);
    if (checksubmit('submit')) {
        $data = array('link' => $_GP['link'], 'enabled' => intval($_GP['enabled']), 'displayorder' => intval($_GP['displayorder']));
        if (!empty($_FILES['thumb']['tmp_name'])) {
            $upload = file_upload($_FILES['thumb']);
            if (is_error($upload)) {
                message($upload['message'], '', 'error');
            }
            $data['thumb'] = $upload['path'];
        }
        if (!empty($id)) {
            mysqld_update('shop_adv', $data, array('id' => $id));
        } else {
            mysqld_insert('shop_adv', $data);
        }
        message('更新幻灯片成功!', web_url('adv', array('op' => 'display')), 'success');
    }
    $adv = mysqld_select("select * from " . table('shop_adv') . " where id=:id  limit 1", array(":id" => $id));
    include page('adv');
} elseif ($operation == 'delete') {
    $id = intval($_GP['id']);
    $adv = mysqld_select("SELECT id  FROM " . table('shop_adv') . " WHERE id = '{$id}' ");
    if (empty($adv)) {
        message('抱歉,幻灯片不存在或是已经被删除!', web_url('adv', array('op' => 'display')), 'error');
    }
    mysqld_delete('shop_adv', array('id' => $id));
    message('幻灯片删除成功!', web_url('adv', array('op' => 'display')), 'success');
} else {
    message('请求方式不存在');
}
Пример #10
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
$list = mysqld_selectall("SELECT * FROM " . table('xc_zjp_winner') . " where award <> '' ORDER BY createtime DESC");
foreach ($list as $id => $item) {
    $list[$id]['mobile'] = mysqld_selectcolumn("select mobile\tfrom" . table('member') . "  where istemplate=0 and openid=:openid ", array(':openid' => $item['open_id']));
}
if ($operation == 'post') {
    $id = intval($_GP['id']);
    mysqld_update('xc_zjp_winner', array('status' => 2), array('id' => $id));
    message('兑现成功!', web_url('awardlist'), 'success');
}
if ($operation == 'delete') {
    $id = intval($_GP['id']);
    mysqld_delete('xc_zjp_winner', array('id' => $id));
    message('删除成功!', web_url('awardlist'), 'success');
}
include addons_page('awardlist');
Пример #11
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'display') {
    $pindex = max(1, intval($_GP['page']));
    $psize = 20;
    $condition = '';
    $id = intval($_GP['id']);
    $list = mysqld_selectall("SELECT comment.*,member.realname,member.mobile,shop_goods.title FROM " . table('shop_goods_comment') . " comment  left join " . table('member') . " member on comment.openid=member.openid   left join " . table('shop_goods') . " shop_goods on shop_goods.id=comment.goodsid  ORDER BY comment.createtime DESC LIMIT " . ($pindex - 1) * $psize . ',' . $psize);
    $total = mysqld_selectcolumn('SELECT COUNT(*) FROM ' . table('shop_goods_comment'));
    $pager = pagination($total, $pindex, $psize);
    include page('goods_comment');
} elseif ($operation == 'delete') {
    $id = intval($_GP['id']);
    $row = mysqld_select("SELECT * FROM " . table('shop_goods_comment') . " WHERE id = :id", array(':id' => $id));
    if (empty($row)) {
        message('抱歉,评论不存在或是已经被删除!');
    }
    //修改成不直接删除,而设置deleted=1
    mysqld_delete("shop_goods_comment", array('id' => $id));
    message('删除成功!', 'refresh', 'success');
}
Пример #12
0
    $payment = mysqld_select("select * from " . table("payment") . " where enabled=1 and code=:payment", array(':payment' => $_GP['payment']));
    if (empty($payment['id'])) {
        message("没有获取到付款方式");
    }
    $paytype = $this->getPaytypebycode($payment['code']);
    $data = array('openid' => $openid, 'ordersn' => $ordersns, 'price' => $goodsprice + $dispatchprice, 'dispatchprice' => $dispatchprice, 'goodsprice' => $goodsprice, 'credit' => $goodscredit, 'status' => 0, 'paytype' => $paytype, 'sendtype' => intval($dispatchitem['sendtype']), 'dispatchexpress' => $dispatchitem['express'], 'dispatch' => $dispatchid, 'paytypecode' => $payment['code'], 'paytypename' => $payment['name'], 'remark' => $_GP['remark'], 'address_mobile' => $address['mobile'], 'address_realname' => $address['realname'], 'address_province' => $address['province'], 'address_city' => $address['city'], 'address_area' => $address['area'], 'address_address' => $address['address'], 'createtime' => time());
    mysqld_insert('shop_order', $data);
    $orderid = mysqld_insertid();
    //插入订单商品
    foreach ($allgoods as $row) {
        if (empty($row)) {
            continue;
        }
        $d = array('goodsid' => $row['id'], 'orderid' => $orderid, 'total' => $row['total'], 'price' => $row['marketprice'], 'createtime' => time(), 'optionid' => $row['optionid']);
        $o = mysqld_select("select title from " . table('shop_goods_option') . " where id=:id limit 1", array(":id" => $row['optionid']));
        if (!empty($o)) {
            $d['optionname'] = $o['title'];
        }
        //获取商品id
        $ccate = $row['ccate'];
        mysqld_insert('shop_order_goods', $d);
    }
    //清空购物车
    if (!$direct) {
        mysqld_delete("shop_cart", array("session_id" => $openid));
    }
    $this->setOrderStock($orderid);
    clearloginfrom();
    header("Location:" . mobile_url('pay', array('orderid' => $orderid, 'topay' => '1')));
}
include themePage('confirm');
Пример #13
0
<?php

$requestcount = mysqld_selectcolumn("select count(id) FROM " . table('addon7_request') . " where award_id=:id", array(":id" => intval($_GP['id'])));
if (empty($requestcount)) {
    mysqld_delete('addon7_award', array("id" => intval($_GP['id'])));
} else {
    mysqld_update('addon7_award', array("deleted" => 1), array("id" => intval($_GP['id'])));
}
message('删除成功!', 'refresh', 'success');
Пример #14
0
                 $children[$cate['parentid']][$cate['id']] = array($cate['id'], $cate['name']);
             }
         }
     }
     $condition = '';
     if (!empty($_GP['cate_2'])) {
         $cid = intval($_GP['cate_2']);
         $condition .= " AND ccate = '{$cid}'";
     } elseif (!empty($_GP['cate_1'])) {
         $cid = intval($_GP['cate_1']);
         $condition .= " AND pcate = '{$cid}'";
     }
     $bonus_good_list = mysqld_selectall("SELECT bonus_good.*,shop_goods.title FROM " . table('bonus_good') . " bonus_good left join " . table('shop_goods') . " shop_goods on shop_goods.id=bonus_good.good_id WHERE  bonus_good.bonus_type_id=:bonus_type_id", array(":bonus_type_id" => intval($_GP['id'])));
     $goodslist = mysqld_selectall("SELECT * FROM " . table('shop_goods') . " WHERE  deleted=0 {$condition} and status=1 and id not in (SELECT good_id FROM " . table('bonus_good') . " WHERE  bonus_type_id=:bonus_type_id)", array(":bonus_type_id" => intval($_GP['id'])));
     if (checksubmit('send_goods')) {
         mysqld_delete('bonus_good', array('bonus_type_id' => intval($_GP['id'])));
         foreach ($_GP['good_add'] as &$goodid) {
             $bonus_good = mysqld_select("SELECT * FROM " . table('bonus_good') . " WHERE  bonus_type_id=:bonus_type_id and good_id=:good_id", array(":bonus_type_id" => intval($_GP['id']), ":good_id" => intval($goodid)));
             $goods = mysqld_select("SELECT * FROM " . table('shop_goods') . " WHERE  deleted=0 and id=:goodid and status=1", array(":goodid" => $goodid));
             if (empty($bonus_good['id']) && !empty($goods['id'])) {
                 mysqld_insert('bonus_good', array('bonus_type_id' => intval($_GP['id']), 'good_id' => $goodid));
             }
         }
         message("设置成功!", "refresh", "success");
     }
     include page('sendgoodbonus');
 }
 if ($bonus['send_type'] == 3) {
     if (empty($_GP['id'])) {
         message("无法获取到优惠券信息");
     }
Пример #15
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'display') {
    $pormotions = mysqld_selectall("SELECT  * FROM " . table('shop_pormotions'));
    include page('promotion_list');
    exit;
}
if ($operation == 'delete') {
    mysqld_delete('shop_pormotions', array('id' => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
    exit;
}
if ($operation == 'post') {
    $id = intval($_GP['id']);
    $pro = mysqld_select("select * from " . table('shop_pormotions') . "where id=:id  limit 1", array(':id' => $id));
    if (checksubmit('submit')) {
        $data = array('promoteType' => $_GP['radioPromotionType'], 'condition' => (int) intval($_GP['promotionmoney']), 'pname' => $_GP['promotionname'], 'starttime' => strtotime($_GP['start_time']), 'endtime' => strtotime($_GP['end_time']), 'description' => $_GP['description']);
        if ($data['starttime'] > $data['endtime']) {
            message('设置错误,开始时间不能大于结束时间', 'refresh', 'error');
            return;
        }
        if (empty($data['pname'])) {
            message('请输入活动名称', 'refresh', 'error');
            return;
        }
        if (empty($data['condition'])) {
            message('请输入满额(件)数量', 'refresh', 'error');
            return;
        }
        if (!empty($id)) {
Пример #16
0
<?php

$delurl = $_GP['pic'];
if (file_delete($delurl)) {
    $filename = basename(SYSTEM_WEBROOT . '/attachment/' . $delurl);
    mysqld_delete('attachment', array('uid' => $_CMS['account']['id'], 'filename' => $filename));
    echo 1;
} else {
    echo 0;
}
Пример #17
0
                $data['cover2'] = $upload['path'];
            }
            if (!empty($_GP['bg_music_url_del'])) {
                $data['bg_music_url'] = '';
            }
            if (!empty($_FILES['bg_music_url']['tmp_name'])) {
                $upload = file_upload($_FILES['bg_music_url'], 'music');
                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $data['bg_music_url'] = $upload['path'];
            }
            mysqld_update('addon10_scene_list', $data, array('id' => $_GP['id']));
            message("修改成功", "refresh", "success");
        }
    }
    include addons_page('themes/' . $theme . '/scene_post');
    exit;
}
if ($operation == 'delete') {
    mysqld_delete('addon10_scene_page', array("list_id" => intval($_GP['id'])));
    mysqld_delete('addon10_scene_subscribe', array("list_id" => intval($_GP['id'])));
    mysqld_delete('addon10_scene_list', array("id" => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
}
if ($operation == 'post') {
    include addons_page('scene');
    exit;
}
$scene_list = mysqld_selectall("SELECT * FROM " . table('addon10_scene_list'));
include addons_page('scene_list');
Пример #18
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
    mysqld_delete('shop_diymenu', array("id" => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
}
if ($operation == 'post') {
    $fansindex_menu = mysqld_select("SELECT * FROM " . table('shop_diymenu') . " where id='" . intval($_GP['id']) . "' and menu_type='fansindex'");
    if (checksubmit('submit')) {
        if (empty($_GP['id'])) {
            $data = array('tname' => $_GP['tname'], 'url' => $_GP['url'], 'icon' => $_GP['icon'], 'menu_type' => 'fansindex', 'torder' => intval($_GP['torder']));
            mysqld_insert('shop_diymenu', $data);
            message("添加成功", create_url('site', array('name' => 'shopwap', 'do' => 'fansindex_menu', 'op' => 'display')), "success");
        } else {
            $data = array('tname' => $_GP['tname'], 'url' => $_GP['url'], 'icon' => $_GP['icon'], 'menu_type' => 'fansindex', 'torder' => intval($_GP['torder']));
            mysqld_update('shop_diymenu', $data, array('id' => $_GP['id']));
            message("修改成功", "refresh", "success");
        }
    }
    include page('fansindex_menu');
    exit;
}
$fansindex_menu_list = mysqld_selectall("SELECT * FROM " . table('shop_diymenu') . " where menu_type='fansindex' order by torder desc");
include page('fansindex_menu_list');
Пример #19
0
        //存在
        $data = array('marketprice' => $marketprice, 'total' => $t, 'optionid' => $optionid);
        mysqld_update('shop_cart', $data, array('id' => $row['id']));
    }
    //返回数据
    $carttotal = $this->getCartTotal();
    $result = array('result' => 1, 'total' => $carttotal);
    die(json_encode($result));
} else {
    if ($op == 'clear') {
        mysqld_delete('shop_cart', array('session_id' => $openid));
        die(json_encode(array("result" => 1)));
    } else {
        if ($op == 'remove') {
            $id = intval($_GP['id']);
            mysqld_delete('shop_cart', array('session_id' => $openid, 'id' => $id));
            die(json_encode(array("result" => 1, "cartid" => $id)));
        } else {
            if ($op == 'update') {
                $id = intval($_GP['id']);
                $num = intval($_GP['num']);
                mysqld_query("update " . table('shop_cart') . " set total={$num} where id=:id", array(":id" => $id));
                die(json_encode(array("result" => 1)));
            } else {
                $list = mysqld_selectall("SELECT * FROM " . table('shop_cart') . " WHERE   session_id = '" . $openid . "'");
                $totalprice = 0;
                if (!empty($list)) {
                    foreach ($list as &$item) {
                        $goods = mysqld_select("SELECT  title, thumb, marketprice, total FROM " . table('shop_goods') . " WHERE id=:id limit 1", array(":id" => $item['goodsid']));
                        //属性
                        $option = mysqld_select("select title,marketprice,stock from " . table("shop_goods_option") . " where id=:id limit 1", array(":id" => $item['optionid']));
Пример #20
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'del') {
    mysqld_delete('rank_model', array("rank_level" => intval($_GP['rank_level'])));
    message("删除成功!", "refresh", "success");
}
if ($operation == 'detail') {
    $condition = ' and 1=2 ';
    if ($_GP['rank_level'] != '') {
        $condition = ' and rank_level=' . intval($_GP['rank_level']);
    }
    $rank = mysqld_select("SELECT * FROM " . table('rank_model') . " where 1=1 {$condition} ");
    $rank_level_all = mysqld_selectall("SELECT * FROM " . table('rank_model'), array(), 'rank_level');
    if (checksubmit('submit')) {
        if (empty($_GP['rank_name'])) {
            message("等级名称不能空");
        }
        if (empty($rank)) {
            $data = array('rank_level' => intval($_GP['rank_level']), 'rank_name' => $_GP['rank_name'], 'experience' => intval($_GP['experience']));
            mysqld_insert('rank_model', $data);
        } else {
            $data = array('rank_name' => $_GP['rank_name'], 'experience' => intval($_GP['experience']));
            mysqld_update('rank_model', $data, array('rank_level' => $rank['rank_level']));
        }
        message('操作成功!', web_url('rank'), 'success');
    }
    include page('rank');
    exit;
}
$list = mysqld_selectall('SELECT * FROM ' . table('rank_model') . " order by rank_level");
Пример #21
0
            if ($rule['keywords'] != $_GP['keywords']) {
                $count = mysqld_selectcolumn('SELECT count(id) FROM ' . table('alipay_rule') . " WHERE  keywords = :keywords", array(':keywords' => $_GP['keywords']));
                if ($count > 0) {
                    message('触发关键字' . $_GP['keywords'] . "已存在!");
                }
            }
            if (!empty($_FILES['thumb']['tmp_name'])) {
                file_delete($_GP['thumb_old']);
                $upload = file_upload($_FILES['thumb']);
                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $thumb = $upload['path'];
            }
            $data = array('title' => $_GP['title'], 'ruletype' => $_GP['ruletype'], 'keywords' => $_GP['keywords'], 'description' => $_GP['description'], 'url' => $_GP['url']);
            if (!empty($thumb)) {
                $data['thumb'] = $thumb;
            }
            mysqld_update('alipay_rule', $data, array('id' => $_GP['id']));
            message('修改成功!', 'refresh', 'success');
        }
    }
    include page('rule_detail');
    exit;
}
if ($operation == 'delete' && !empty($_GP['id'])) {
    mysqld_delete('alipay_rule', array('id' => $_GP['id']));
    message('删除成功!', 'refresh', 'success');
}
$list = mysqld_selectall('SELECT * FROM ' . table('alipay_rule'));
include page('rule');
Пример #22
0
<?php

$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
if ($operation == 'delete') {
    mysqld_delete('addon9_singlepage', array("id" => intval($_GP['id'])));
    message("删除成功!", "refresh", "success");
}
if ($operation == 'post') {
    $singlepage = mysqld_select("SELECT * FROM " . table('addon9_singlepage') . " where id='" . intval($_GP['id']) . "' ");
    if (checksubmit('submit')) {
        if (empty($_GP['id'])) {
            $data = array('createtime' => time(), 'title' => $_GP['title'], 'open_footer' => intval($_GP['open_footer']), 'content' => htmlspecialchars_decode($_GP['content']));
            mysqld_insert('addon9_singlepage', $data);
            message("添加成功", create_url('site', array('name' => 'addon9', 'do' => 'singlepage', 'op' => 'post', 'id' => mysqld_insertid())), "success");
        } else {
            $data = array('title' => $_GP['title'], 'open_footer' => intval($_GP['open_footer']), 'content' => htmlspecialchars_decode($_GP['content']));
            mysqld_update('addon9_singlepage', $data, array('id' => $_GP['id']));
            message("修改成功", "refresh", "success");
        }
    }
    include addons_page('singlepage');
    exit;
}
$singlepage_list = mysqld_selectall("SELECT * FROM " . table('addon9_singlepage'));
include addons_page('singlepage_list');
Пример #23
0
function integration_session_account($loginid, $oldsessionid)
{
    $member = mysqld_select("SELECT * FROM " . table('member') . " WHERE openid = :openid ", array(':openid' => $loginid));
    $sessionmember = mysqld_select("SELECT * FROM " . table('member') . " WHERE openid = :openid", array(':openid' => $oldsessionid));
    if (empty($member['openid']) || $sessionmember['istemplate'] != 1) {
        return;
    }
    $cartall = mysqld_selectall("SELECT * FROM " . table('shop_cart') . " WHERE session_id = :session_id ", array(':session_id' => $oldsessionid));
    foreach ($cartall as $cartitem) {
        $row = mysqld_select("SELECT * FROM " . table('shop_cart') . " WHERE session_id = :loginid  AND goodsid = :goodsid  and optionid=:optionid limit 1", array(':loginid' => $loginid, ':goodsid' => $cartitem['goodsid'], ':optionid' => $cartitem['optionid']));
        if (empty($row['id'])) {
            mysqld_update('shop_cart', array('session_id' => $loginid), array('id' => $cartitem['id']));
        } else {
            $t = $cartitem['total'] + $row['total'];
            $data = array('marketprice' => $cartitem['marketprice'], 'total' => $t, 'optionid' => $optionid);
            mysqld_update('shop_cart', $data, array('id' => $row['id']));
            mysqld_delete('shop_cart', array('id' => $cartitem['id']));
        }
    }
    mysqld_update('shop_address', array('openid' => $loginid), array('openid' => $oldsessionid));
    mysqld_update('shop_order', array('openid' => $loginid), array('openid' => $oldsessionid));
    mysqld_update('shop_address', array('openid' => $loginid), array('openid' => $oldsessionid));
    mysqld_update('shop_order_paylog', array('openid' => $loginid), array('openid' => $oldsessionid));
    mysqld_update('member_paylog', array('openid' => $loginid), array('openid' => $oldsessionid));
    /*可能出现刷分情况,屏蔽
    	 if($sessionmember['credit']>0)
    	 {
    	 	member_credit($loginid,intval($sessionmember['credit']),'addcredit','登陆后账户合并所得积分');
        }
      */
    if ($sessionmember['gold'] > 0) {
        member_gold($loginid, intval($sessionmember['gold']), 'addgold', '登录后与临时账户合并所得余额');
    }
    mysqld_delete('member', array('openid' => $oldsessionid));
    $alipaythirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE enabled=1 and `code`='alipay'");
    if (!empty($alipaythirdlogin) && !empty($alipaythirdlogin['id'])) {
        $alipayfans = mysqld_select("SELECT * FROM " . table('alipay_alifans') . " WHERE alipay_openid=:alipay_openid ", array(':alipay_openid' => $oldsessionid));
        if (!empty($alipayfans['alipay_openid'])) {
            mysqld_update('alipay_alifans', array('openid' => $loginid), array('alipay_openid' => $oldsessionid));
        }
    }
    if (strpos($_SERVER['HTTP_USER_AGENT'], 'MicroMessenger') !== false) {
        $weixinthirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE enabled=1 and `code`='weixin'");
        if (!empty($weixinthirdlogin) && !empty($weixinthirdlogin['id'])) {
            $weixinfans = mysqld_select("SELECT * FROM " . table('weixin_wxfans') . " WHERE weixin_openid=:weixin_openid ", array(':weixin_openid' => $oldsessionid));
            if (!empty($weixinfans['weixin_openid']) && empty($weixinfans['openid'])) {
                mysqld_update('weixin_wxfans', array('openid' => $loginid), array('weixin_openid' => $oldsessionid));
            }
        }
    }
    if (!empty($_SESSION[MOBILE_QQ_OPENID])) {
        $qqlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE enabled=1 and `code`='qq'");
        if (!empty($qqlogin) && !empty($qqlogin['id'])) {
            $qqfans = mysqld_select("SELECT * FROM " . table('qq_qqfans') . " WHERE qq_openid=:qq_openid", array(':qq_openid' => $_SESSION[MOBILE_QQ_OPENID]));
            if (!empty($qqfans['qq_openid']) && empty($qqfans['openid'])) {
                mysqld_update('qq_qqfans', array('openid' => $loginid), array('qq_openid' => $_SESSION[MOBILE_QQ_OPENID]));
            }
        }
    }
    //unset($_SESSION[MOBILE_SESSION_ACCOUNT]);
}
Пример #24
0
        $query = mysql_query("SHOW DATABASES LIKE  '" . $_GP['dbname'] . "';", $con);
        if (!mysql_fetch_assoc($query)) {
            message("数据库不存在且创建数据库失败");
        }
        file_put_contents(WEB_ROOT . '/config/config.php', $config);
        file_put_contents(WEB_ROOT . '/config/version.php', "<?php define('SYSTEM_VERSION', " . CORE_VERSION . ");");
        header("Location:" . web_url("install", array("name" => "public", "op" => "setp3", "doact" => "installsql", "adminname" => urlencode(base64_encode($_GP['adminname'])), "adminpwd" => urlencode(base64_encode(md5($_GP['adminpwd']))))));
    }
    if ($_GP['doact'] == "installsql") {
        define('SYSTEM_INSTALL_IN', true);
        require "installsql.php";
        $data = array('username' => base64_decode(urldecode($_GP['adminname'])), 'password' => base64_decode(urldecode($_GP['adminpwd'])), 'createtime' => time());
        mysqld_insert('user', $data);
        $account = mysqld_select('SELECT * FROM ' . table('user') . " WHERE  username=:username", array(':username' => base64_decode(urldecode($_GP['adminname']))));
        if (!empty($account['id'])) {
            mysqld_delete('user_rule', array('uid' => $account['id']));
            $allrule = mysqld_selectall('SELECT * FROM ' . table('rule'));
            foreach ($allrule as $item) {
                $data = array('uid' => $account['id'], 'modname' => $item['modname'], 'moddo' => $item['moddo']);
                mysqld_insert('user_rule', $data);
            }
        }
        $cfg = array('shop_openreg' => 1);
        refreshSetting($cfg);
        file_put_contents(WEB_ROOT . '/config/install.link', intval($_GP['openbridge']));
        unset($_SESSION["account"]);
        http_get("http://m.baijiacms.com/install_log.php?hostname=" . urlencode(WEBSITE_ROOT));
        message("安装成功", web_url("index", array("name" => "public")), "success");
    }
}
include page('install');
Пример #25
0
<?php

$op = $_GP['op'];
$id = intval($_GP['id']);
if ($id > 0) {
    $item = mysqld_select('select * from ' . table('addon10_scene_page') . ' where id=:id AND list_id=:list_id ', array(':list_id' => $list_id, ':id' => $id));
}
if ($_GP['op'] == 'del') {
    if ($item != false) {
        $temp = mysqld_delete('addon10_scene_page', array('id' => $item['id']));
    }
    if ($temp == false) {
        $this->ajaxmessage('数据提交失败');
    } else {
        $this->ajaxmessage('数据提交成功', web_url('scene_page', array('listid' => $list_id, 'op' => 'display')), 'success');
    }
}
//保存数据
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    $insert = array('list_id' => $list_id, 'listorder' => intval($_GP['listorder']), 'm_type' => intval($_GP['m_type']), 'thumb' => $_GP['thumb']);
    if ($insert['m_type'] == 1) {
        $data = $_GP['first'];
    } elseif ($insert['m_type'] == 2) {
        $data = $_GP['second'];
    } elseif ($insert['m_type'] == 3) {
        $data = $_GP['third'];
    } elseif ($insert['m_type'] == 4) {
        $data = $_GP['fourth'];
    } elseif ($insert['m_type'] == 5) {
        $data = $_GP['fifth'];
    } elseif ($insert['m_type'] == 6) {
Пример #26
0
            $area = $regions[3];
            $shop_dispatch_areas = mysqld_selectall("SELECT shop_dispatch_area.* FROM " . table('shop_dispatch_area') . " shop_dispatch_area left join " . table('shop_dispatch') . " shop_dispatch on shop_dispatch.id=shop_dispatch_area.dispatchid WHERE shop_dispatch.deleted=0 and shop_dispatch.express=:code and shop_dispatch_area.country = :country and shop_dispatch_area.provance = '" . $provance . "' and shop_dispatch_area.city = '" . $city . "' and shop_dispatch_area.area = '" . $area . "'", array(':code' => $code, ':country' => $country));
            foreach ($shop_dispatch_areas as $shop_dispatch_area) {
                if ($shop_dispatch_area['dispatchid'] != $id) {
                    message("'" . $region . "'该区域已在此配送方式中存在。");
                }
            }
        }
        $data = array('displayorder' => intval($_GP['displayorder']), 'dispatchname' => $_GP['dispatchname'], 'firstprice' => $_GP['firstprice'], 'secondprice' => $_GP['secondprice'], 'provance' => '', 'city' => '', 'area' => '', 'firstweight' => intval($_GP['firstweight']), 'secondweight' => intval($_GP['secondweight']), 'express' => $_GP['express'], 'deleted' => 0, 'sendtype' => intval($_GP['sendtype']));
        if (empty($id)) {
            mysqld_insert("shop_dispatch", $data);
            $id = mysqld_insertid();
        } else {
            mysqld_update("shop_dispatch", $data, array('id' => $id));
        }
        mysqld_delete("shop_dispatch_area", array("dispatchid" => $id));
        foreach ($_GP['regions'] as $region) {
            $regions = explode("-", $region);
            $country = $regions[0];
            $provance = $regions[1];
            $city = $regions[2];
            $area = $regions[3];
            mysqld_insert("shop_dispatch_area", array('dispatchid' => $id, 'country' => $country, 'provance' => $provance, 'city' => $city, 'area' => $area));
        }
        message('配送方式操作成功!', create_url('site', array('name' => 'shop', 'do' => 'dispatch', 'op' => 'display', 'code' => $code)), 'success');
    }
    include page('dispatch');
} elseif ($operation == 'delete') {
    $id = intval($_GP['id']);
    $row = mysqld_select("SELECT id FROM " . table('shop_dispatch') . " WHERE id = :id", array(':id' => $id));
    if (empty($row)) {
Пример #27
0
}
$alipay_rule = mysqld_select("SELECT * FROM " . table('rule') . " WHERE `modname`='alipay' and `moddo`='alipay' ");
if (empty($alipay_rule['modname'])) {
    $sql = $sql . "\r\n\tdelete from `baijiacms_rule` where `modname`='alipay' and `moddo`='alipay';\r\n\tinsert into `baijiacms_rule` (`moddescription`,`modname`,`moddo`)value('支付宝服务窗设置', 'alipay', 'alipay');\r\n\t";
    $user_list = mysqld_selectall("SELECT * FROM " . table('user'));
    foreach ($user_list as &$_tuser) {
        mysqld_delete('user_rule', array('uid' => $_tuser['id'], 'modname' => 'alipay', 'moddo' => 'alipay'));
        mysqld_insert('user_rule', array('uid' => $_tuser['id'], 'modname' => 'alipay', 'moddo' => 'alipay'));
    }
}
$bonus_rule = mysqld_select("SELECT * FROM " . table('rule') . " WHERE `modname`='bonus' and `moddo`='bonus' ");
if (empty($bonus_rule['modname'])) {
    $sql = $sql . "\r\n\tdelete from `baijiacms_rule` where `modname`='bonus' and `moddo`='bonus';\r\ninsert into `baijiacms_rule` (`moddescription`,`modname`,`moddo`)value('促销管理','bonus','bonus');\r\n\t";
    $user_list = mysqld_selectall("SELECT * FROM " . table('user'));
    foreach ($user_list as &$_tuser) {
        mysqld_delete('user_rule', array('uid' => $_tuser['id'], 'modname' => 'bonus', 'moddo' => 'bonus'));
        mysqld_insert('user_rule', array('uid' => $_tuser['id'], 'modname' => 'bonus', 'moddo' => 'bonus'));
    }
}
$sql = $sql . "\r\nupdate `baijiacms_shop_order` set paytype=1 where paytypecode='gold';\r\nupdate `baijiacms_shop_order` set paytype=3 where paytypecode='delivery';\r\nupdate `baijiacms_shop_order` set paytype=2 where paytypecode='weixin';\r\nupdate `baijiacms_shop_order` set paytype=2 where paytypecode='alipay';\r\nupdate `baijiacms_shop_order` set paytype=2 where paytypecode='bank';\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_gold_order` (\r\n  `createtime` int(10) NOT NULL,\r\n  `status` int(1) NOT NULL DEFAULT '0',\r\n  `price` decimal(10,2) NOT NULL,\r\n  `openid` varchar(40) NOT NULL,\r\n \t`ordersn` varchar(20) NOT NULL,\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_shop_diymenu` (\r\n  `menu_type` varchar(10) NOT NULL,\r\n  `torder` int(2) NOT NULL,\r\n  `icon` varchar(30) NOT NULL,\r\n  `url` varchar(350) NOT NULL,\r\n  `tname` varchar(100) NOT NULL,\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_rank_model` (\r\n  `experience` int(11) DEFAULT '0',\r\n  `rank_level` int(3) DEFAULT  '0' COMMENT '等级',\r\n  `rank_name` varchar(50) DEFAULT NULL  COMMENT '等级名称',\r\n  PRIMARY KEY (`rank_level`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_rank_phb` (\r\n\t`rank_level` int(11) DEFAULT '0',\r\n  `rank_name` varchar(50) DEFAULT '',\r\n  `realname` varchar(50) DEFAULT '' NOT NULL,\r\n  `openid` varchar(50) DEFAULT '' NOT NULL,\r\n  `rank_top` int(2) DEFAULT '0' COMMENT '名次',\r\n  PRIMARY KEY (`rank_top`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_bonus_type` (\r\n  `type_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `type_name` varchar(60) NOT NULL DEFAULT '',\r\n  `type_money` decimal(10,2) NOT NULL DEFAULT '0.00',\r\n  `send_type` tinyint(3) unsigned NOT NULL DEFAULT '0',\r\n  `deleted` int(1)  NOT NULL DEFAULT '0',\r\n  `min_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',\r\n  `max_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',\r\n  `send_start_date` int(11) NOT NULL DEFAULT '0',\r\n  `send_end_date` int(11) NOT NULL DEFAULT '0',\r\n  `use_start_date` int(11) NOT NULL DEFAULT '0',\r\n  `use_end_date` int(11) NOT NULL DEFAULT '0',\r\n  `min_goods_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',\r\n  PRIMARY KEY (`type_id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_bonus_user` (\r\n  `bonus_id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `bonus_type_id` int(10) unsigned NOT NULL DEFAULT '0',\r\n  `bonus_sn` varchar(20) DEFAULT '' NOT NULL,\r\n  `openid` varchar(50) DEFAULT '' NOT NULL,\r\n  `deleted` int(1)  NOT NULL DEFAULT '0',\r\n  `isuse` int(1)  NOT NULL DEFAULT '0',\r\n  `used_time` int(10) unsigned NOT NULL DEFAULT '0',\r\n  `order_id` mediumint(8) unsigned NOT NULL DEFAULT '0',\r\n  `collect_time` int(10) unsigned NOT NULL DEFAULT '0',\r\n  `createtime` int(10) NOT NULL,\r\n  PRIMARY KEY (`bonus_id`),\r\n  KEY `openid` (`openid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_bonus_good` (\r\n  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,\r\n  `bonus_type_id` mediumint(8) NOT NULL ,\r\n  `good_id` int(10) NOT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_alipay_rule` (\r\n  `url` varchar(500) NOT NULL,\r\n  `thumb` varchar(60) NOT NULL,\r\n  `keywords` varchar(50) NOT NULL,\r\n  `title` varchar(50) NOT NULL,\r\n  `description` varchar(255) DEFAULT NULL,\r\n  `ruletype` int(11) NOT NULL COMMENT '1文本回复 2图文回复',\r\n  `content` text,\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_alipay_alifans` (\r\n  `createtime` int(10) NOT NULL DEFAULT '0',\r\n  `openid` varchar(50) DEFAULT NULL,\r\n  `alipay_openid` varchar(50) NOT NULL,\r\n  `follow` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否订阅',\r\n  `nickname` varchar(100) NOT NULL DEFAULT '' COMMENT '昵称',\r\n  `avatar` varchar(200) NOT NULL DEFAULT '',\r\n  `gender` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别(0:保密 1:男 2:女)',\r\n  PRIMARY KEY (`alipay_openid`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_shop_dispatch_area` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `dispatchid` int(11) NOT NULL,\r\n  `country` varchar(30) NOT NULL,\r\n  `provance` varchar(30) DEFAULT '',\r\n  `city` varchar(30) DEFAULT '',\r\n  `area` varchar(30) DEFAULT '',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\nCREATE TABLE IF NOT EXISTS `baijiacms_dispatch` (\r\n  `id` int(7) unsigned NOT NULL AUTO_INCREMENT,\r\n  `code` varchar(20) NOT NULL DEFAULT '',\r\n  `name` varchar(120) NOT NULL DEFAULT '',\r\n  `sendtype` int(5) NOT NULL DEFAULT '1' COMMENT '0为快递,1为自提',\r\n  `desc` text NOT NULL,\r\n  `configs` text NOT NULL,\r\n  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n";
if (!mysqld_fieldexists('modules', 'isdisable')) {
    $sql = $sql . "ALTER TABLE " . table('modules') . " ADD COLUMN `isdisable` int(1) DEFAULT '0' COMMENT '模块是否禁用';";
}
if (!mysqld_fieldexists('member', 'avatar')) {
    $sql = $sql . "ALTER TABLE " . table('member') . " ADD COLUMN `avatar` varchar(200) DEFAULT '' COMMENT '用户头像';";
}
if (!mysqld_fieldexists('member', 'experience')) {
    $sql = $sql . "ALTER TABLE " . table('member') . " ADD COLUMN `experience` int(11) DEFAULT '0' COMMENT '账户经验值';";
    $sql = $sql . "update " . table('member') . " set experience=credit;";
}
if (!mysqld_fieldexists('shop_goods', 'isfirst')) {
Пример #28
0
$operation = !empty($_GP['op']) ? $_GP['op'] : 'display';
$list = mysqld_selectall("SELECT * FROM " . table('xc_zjp_award'));
if ($operation == 'post') {
    $id = intval($_GP['id']);
    if (checksubmit('submit')) {
        $data = array('title' => $_GP['title'], 'probalilty' => intval($_GP['probalilty']), 'total' => intval($_GP['total']));
        if (!empty($_FILES['description']['tmp_name'])) {
            $upload = file_upload($_FILES['description']);
            if (is_error($upload)) {
                message($upload['message'], '', 'error');
            }
            $data['description'] = $upload['path'];
        }
        if (!empty($id)) {
            mysqld_update('xc_zjp_award', $data, array('id' => $id));
        } else {
            mysqld_insert('xc_zjp_award', $data);
        }
        message('操作成功!', web_url('prizelist'), 'success');
    }
    $item = mysqld_select("select * from " . table('xc_zjp_award') . " where id=:id  limit 1", array(":id" => $id));
    include addons_page('prize');
    exit;
}
if ($operation == 'delete') {
    $id = intval($_GP['id']);
    mysqld_delete('xc_zjp_award', array('id' => $id));
    message('奖品删除成功!', web_url('prizelist'), 'success');
}
include addons_page('prizelist');
Пример #29
0
            if ($rule['keywords'] != $_GP['keywords']) {
                $count = mysqld_selectcolumn('SELECT count(id) FROM ' . table('weixin_rule') . " WHERE  keywords = :keywords", array(':keywords' => $_GP['keywords']));
                if ($count > 0) {
                    message('触发关键字' . $_GP['keywords'] . "已存在!");
                }
            }
            if (!empty($_FILES['thumb']['tmp_name'])) {
                file_delete($_GP['thumb_old']);
                $upload = file_upload($_FILES['thumb']);
                if (is_error($upload)) {
                    message($upload['message'], '', 'error');
                }
                $thumb = $upload['path'];
            }
            $data = array('title' => $_GP['title'], 'ruletype' => $_GP['ruletype'], 'keywords' => $_GP['keywords'], 'description' => $_GP['description'], 'url' => $_GP['url']);
            if (!empty($thumb)) {
                $data['thumb'] = $thumb;
            }
            mysqld_update('weixin_rule', $data, array('id' => $_GP['id']));
            message('修改成功!', 'refresh', 'success');
        }
    }
    include page('rule_detail');
    exit;
}
if ($operation == 'delete' && !empty($_GP['id'])) {
    mysqld_delete('weixin_rule', array('id' => $_GP['id']));
    message('删除成功!', 'refresh', 'success');
}
$list = mysqld_selectall('SELECT * FROM ' . table('weixin_rule'));
include page('rule');
Пример #30
0
<?php

defined('SYSTEM_IN') or exit('Access Denied');
hasrule('alipay', 'alipay');
$settings = globaSetting(array('alipay_name', 'alipay_appId', 'thirdlogin_alipay'));
$thirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE code = :code", array(':code' => 'alipay'));
if (checksubmit()) {
    $cfg = array('alipay_name' => $_GP['alipay_name'], 'alipay_appId' => $_GP['alipay_appId'], 'thirdlogin_alipay' => $_GP['thirdlogin_alipay']);
    refreshSetting($cfg);
    mysqld_delete('config', array('name' => 'alipay_access_token'));
    $settings = globaSetting(array('alipay_name', 'alipay_appId', 'thirdlogin_alipay'));
    $thirdlogin = mysqld_select("SELECT * FROM " . table('thirdlogin') . " WHERE code = :code", array(':code' => 'alipay'));
    require WEB_ROOT . '/system/modules/plugin/thirdlogin/alipay/lang.php';
    if (empty($thirdlogin['id'])) {
        $data = array('code' => 'alipay', 'enabled' => intval($_GP['thirdlogin_alipay']), 'name' => $_LANG['thirdlogin_alipay_name']);
        mysqld_insert('thirdlogin', $data);
    } else {
        $data = array('enabled' => intval($_GP['thirdlogin_alipay']), 'name' => $_LANG['thirdlogin_alipay_name']);
        mysqld_update('thirdlogin', $data, array('code' => 'alipay'));
    }
    message('保存成功', 'refresh', 'success');
}
include page('setting');