member_scores.php
1.65 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?php
/**
* 会员积分
*
* @version $Id: member_scores.php 1 11:24 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once(dirname(__FILE__)."/config.php");
CheckPurview('member_Scores');
if(!isset($action)) $action = '';
if($action=='save')
{
if(!empty($add_integral)&&!empty($add_icon)&&!empty($add_titles))
{
$integral = preg_replace("#[^0-9]#", "", $add_integral);
$add_icon = preg_replace("#[^0-9]#", "", $add_icon);
$add_titles = cn_substr($add_titles, 15);
$dsql->ExecuteNoneQuery("INSERT INTO `#@__scores`(integral,icon,titles,isdefault) VALUES('$integral','$add_icon','$add_titles','$add_isdefault')");
}
foreach($_POST as $rk=>$rv)
{
if(preg_match("#-#", $rk))
{
$ID = preg_replace("#[^0-9]#", "", $rk);
$fildes = preg_replace("#[^a-z]#", "", $rk);
$k = $$rk;
if(empty($k))
{
$k = 0;
}
$sql = $fildes."='".$k."'";
$dsql->ExecuteNoneQuery("UPDATE `#@__scores` SET ".$sql." WHERE id='{$ID}'");
if(preg_match("#Ids-#", $rk))
{
if($k) $dsql->ExecuteNoneQuery("DELETE FROM `#@__scores` WHERE id='$ID'");
}
}
}
}
$Scores = array();
$dsql->SetQuery("SELECT * FROM `#@__scores` ORDER BY id ASC");
$dsql->Execute();
while($rs = $dsql->GetArray())
{
array_push($Scores,$rs);
}
include DedeInclude('templets/member_scores.htm');