member_model_edit.php

/php/xuzhou58/xuzhou58.com/dede/member_model_edit.php

http://jqbird.googlecode.com/
PHP | 227 lines | 193 code | 8 blank | 26 comment | 27 complexity | 0551bd356e6e6ded30bc6699e495ba64 MD5 | raw file
Possible License(s): GPL-3.0, LGPL-3.0, LGPL-2.1, GPL-2.0

<?php

require_once(dirname(__FILE__)."/config.php");

CheckPurview('c_Edit');

require_once(DEDEINC."/dedetag.class.php");

require_once(DEDEINC."/oxwindow.class.php");

if(empty($dopost))

{

	$dopost="";

}

$id = (empty($id) ? 0 : intval($id));



/*----------------

function __SaveEdit()

-----------------*/

if($dopost=="save")

{

	$state = isset($state) && is_numeric($state) ? $state : 1;

  $description = htmlspecialchars($description);

	$name = htmlspecialchars($name);

	$query = "update `#@__member_model` set name = '$name', description = '$description', state='$state' where id='$id' ";

	$dsql->ExecuteNoneQuery($query);

	//????????

	UpDateMemberModCache();

	ShowMsg("???????????","member_model_main.php");

	exit();

}

/*----------------

function __Disabled()

-----------------*/

else if($dopost=="disabled")

{

	@set_time_limit(0);

	CheckPurview('c_Del');

	$row = $dsql->GetOne("Select * From #@__member_model where id='$id'");

	$statenum = ($row['state']==0)? 1 : 0;

	$statestr = ($row['state']==0)? '??' : '??';

	//????

	$dsql->ExecuteNoneQuery("Update #@__member_model set state={$statenum} where id='$id' ");

	//????????

	UpDateMemberModCache();

	ShowMsg("??{$statestr}???????","member_model_main.php");

	exit();

	

}

/*----------------

function __Copy()

-----------------*/

else if($dopost=="copy")

{

	@set_time_limit(0);

	CheckPurview('c_Del');

	$row = $dsql->GetOne("Select * From #@__member_model where id='$id'");

	$thisname = $row['name'];

	$thistable = $row['table'];

	$thisinfo = $row['info'];

	$row = $dsql->GetOne("Select id From #@__member_model order by id desc limit 0,1 ");

	if(is_array($row))

	{

		$newid = $row['id']+1;

	}

	else

	{

		$newid = 1;

	}

	if(empty($job))

	{

		$job="";

	}

	//????

	if($job=="")

	{

		$wintitle = "??????-??????";

		$wecome_info = "<a href='member_model_main.php'>??????</a>::??????";

		$win = new OxWindow();

		$win->Init("member_model_edit.php","js/blank.js","POST");

		$win->AddHidden("job","yes");

		$win->AddHidden("dopost",$dopost);

		$win->AddHidden("id",$id);

		$win->AddTitle("?????? \"".$thisname."\" ???????");

		$msg ="";

		$msg.="<table width='460' border='0' cellspacing='0' cellpadding='0'>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td width='170' height='24' align='center'>???ID?</td>\r\n";

    $msg.=" <td width='230'><input name='newid' type='text' id='newid' size='6' value='{$newid}'/></td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td height='24' align='center'>??????</td>\r\n";

    $msg.=" <td><input name='newname' type='text' id='newname' value='{$thisname}{$newid}' style='width:250px'/></td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td height='24' align='center'>??????</td>\r\n";

    $msg.=" <td><input name='newtable' type='text' id='newtable' value='{$thistable}{$newid}' style='width:250px'/></td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td height='24' align='center'>?????</td>\r\n";

    $msg.=" <td><font color='red'>??????????,???????????</font></td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td height='24' align='center'>??????</td>\r\n";

    $msg.=" <td><label>\r\n";

    $msg.=" <textarea name=\"description\" id=\"description\" cols=\"45\" rows=\"5\" onClick=\"this.value=''\">?????</textarea>\r\n";

    $msg.=" </label></td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="<tr>\r\n";

    $msg.=" <td height='24' align='center'>?????</td>\r\n";

    $msg.=" <td><input name='state' type='radio' id='copytemplet' value='1' class='np' checked='checked'/>\r\n";

    $msg.=" ??\r\n";

    $msg.=" &nbsp;\r\n";

    $msg.=" <input name='state' type='radio' id='copytemplet' class='np' value='0'/>\r\n";

    $msg.=" ??</td>\r\n";

    $msg.="</tr>\r\n";

    $msg.="</table>";

    $win->AddMsgItem("<div style='padding:20px;line-height:300%'>$msg</div>");

		$winform = $win->GetWindow("ok");

		$win->Display();

		exit();

	}

	//??

	else if($job=="yes")

	{

  	if(ereg("[^0-9-]",$newid)||empty($newid))

  	{

  		ShowMsg("<font color=red>'????ID'</font>??????","-1");

  		exit();

  	}

		if($newtable=="")

		{

			ShowMsg("???????","-1");

			exit();

		}

		$state = isset($state) && is_numeric($state) ? $state : 0;

		$newname = htmlspecialchars($newname);

		$row = $dsql->GetOne("Select * from #@__member_model where id='$newid' Or `table` like '$newtable' Or name like '$newname' ");

		if(is_array($row))

		{

			ShowMsg("???????ID???????????????????","-1");

			exit();

		}

		//?????

		if(!$dsql->IsTable($newtable))

		{

			$dsql->Execute('me',"SHOW CREATE TABLE {$dsql->dbName}.{$thistable}");

			$row = $dsql->GetArray('me', MYSQL_BOTH);

			$tableStruct = $row[1];

			$tb = str_replace('#@__',$cfg_dbprefix,$thistable);

			$tableStruct = preg_replace("/CREATE TABLE `$thistable`/iU","CREATE TABLE `$newtable`",$tableStruct);

			$dsql->ExecuteNoneQuery($tableStruct);

		}

		$query = "insert into #@__member_model (`id`, `name`, `table`, `description`, `issystem`, `state`, `info`) values ('$newid', '$newname', '$newtable', '$description', 0, '$state','$thisinfo')";

		$rs = $dsql->ExecuteNoneQuery($query);

		if($rs)

		{

			UpDateMemberModCache();

			ShowMsg("?????????????????... ","member_model_edit.php?id={$newid}&dopost=edit");

			exit();

		}

		else

		{

			$errv = $dsql->GetError();

			ShowMsg("?????????????????????????<br /> ?????member_model_edit.php?dopost=copy $errv","javascript:;");

			exit();

		}

  	//echo "Do it!";exit();

	}

}

/*----------------

function __Delete()

-----------------*/

else if($dopost=="delete")

{

	@set_time_limit(0);

	CheckPurview('c_Del');

	$row = $dsql->GetOne("Select * From #@__member_model where id='$id'");

  if($row['issystem'] == 1)

  {

		ShowMsg("????,????!","-1");

		exit();

  }

	if(empty($job))

	{

		$job="";

	}



	//????

	if($job=="")

	{

		$wintitle = "??????-??????";

		$wecome_info = "<a href='member_model_main.php'>??????</a>::??????";

		$win = new OxWindow();

		$win->Init("member_model_edit.php","js/blank.js","POST");

		$win->AddHidden("job","yes");

		$win->AddHidden("dopost",$dopost);

		$win->AddHidden("id",$id);

		$win->AddTitle("????????????????????<br />?????? \"".$row['name']."\" ???????");

		$winform = $win->GetWindow("ok");

		$win->Display();

		exit();

	}



	//??

	else if($job=="yes")

	{

		$row = $dsql->GetOne("Select `table` From `#@__member_model` where id='$id'",MYSQL_ASSOC);

		if(!is_array($row))

		{

			ShowMsg("??????????????!","-1");

			exit();

		}



		//???

		$dsql->ExecuteNoneQuery("DROP TABLE IF EXISTS `{$row['table']}`;");



		//????????

		$dsql->ExecuteNoneQuery("Delete From `#@__member_model` where id='$id'");

		UpDateMemberModCache();

		ShowMsg("???????????","member_model_main.php");

		exit();

	}

}



/*----------------

function edit()

-----------------*/

$row = $dsql->GetOne("Select * From #@__member_model where id='$id'");

include DEDEADMIN."/templets/member_model_edit.htm";



?>