ecshop抽奖插件

1、执行SQL，注意前缀，这里是默认的cj_ CREATE TABLE `cj_lottery` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `goods_id` mediumint(8) unsigned NOT NULL, `shop_price` decimal(10,2) unsigned NOT NULL default '0.00', `point` mediumint(8) unsigned NOT NULL, `pro` mediumint(8) unsigned NOT NULL, `lg` mediumint(8) unsigned NOT NULL, `status` tinyint(3) unsigned NOT NULL, `remark` text NOT NULL, `winnum` mediumint(8) unsigned NOT NULL, `total` mediumint(8) unsigned NOT NULL, `outnum` mediumint(8) unsigned NOT NULL, `click` mediumint(8) unsigned NOT NULL, `taobaourl` varchar(255) NOT NULL, PRIMARY KEY (`id`), KEY `NewIndex1` (`goods_id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; CREATE TABLE `cj_lottery_group` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `lg_name` varchar(255) NOT NULL, `lg_pro` mediumint(8) NOT NULL, `lg_remark` text NOT NULL, `taobao` tinyint(3) unsigned NOT NULL, `type` int(11) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; CREATE TABLE `cj_lottery_user` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `lid` mediumint(8) unsigned NOT NULL, `user_id` mediumint(8) unsigned NOT NULL, `status` tinyint(3) unsigned NOT NULL, `remark` text NOT NULL, `speech` varchar(255) NOT NULL, `wintime` int(10) unsigned NOT NULL, `address` varchar(500) NOT NULL, `applystatus` tinyint(3) unsigned NOT NULL, `tel` varchar(255) NOT NULL default '', `gettime` int(10) unsigned NOT NULL, `order_id` mediumint(8) unsigned NOT NULL, `ip` varchar(15) NOT NULL default '', `address1` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; CREATE TABLE `cj_wj_award` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `user_id` mediumint(8) unsigned NOT NULL, `type` tinyint(3) unsigned NOT NULL, `last_time` int(11) unsigned NOT NULL default '0', `value` varchar(255) default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; CREATE TABLE `cj_wj_award_type` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `type` tinyint(3) unsigned NOT NULL, `value` mediumint(8) unsigned NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=gbk; 2、上传附件里的文件,如果有做过二次开发，请不要直接覆盖，以免把做过二次开发的文件覆盖掉（下面说明是修改做过二次开发的文件）。 3、修改admin/includes/inc_menu.php，查找： $modules['03_promotion']['15_exchange_goods'] = 'exchange_goods.php?act=list'; 换行添加： $modules['03_promotion']['17_wj_lottery'] = 'wj_lottery.php?act=list'; //抽奖列表 $modules['03_promotion']['18_wj_lottery_group'] = 'wj_lottery_group.php?act=list'; //抽奖级别 $modules['03_promotion']['19_wj_lottery_user'] = 'wj_lottery_user.php?act=list'; //获奖列表 $modules['11_system']['wj_award_type'] = 'wj_award_type.php?act=edit'; //赠送积分设置 4、修改languages/zh_cn/admin/common.php,查找： $_LANG['package_add'] = '添加超值礼包'; 换行添加： $_LANG['17_wj_lottery'] = '抽奖列表'; $_LANG['18_wj_lottery_group'] = '抽奖级别'; $_LANG['19_wj_lottery_user'] = '获奖列表'; $_LANG['wj_award_type'] = '积分设置'; 5、9、修改includes/lib_common.php ?>前添加： /* 获得区域名称 */ function get_region_name($region_id = 0) { if(empty($region_id)) { $region_id = 0; } $sql = "SELECT region_name from " . $GLOBALS['ecs']->table('region') . " where region_id = " . $region_id; $region_name = $GLOBALS['db']->getOne($sql); return $region_name; }