[
2014/01/24 01:12 | by 孤城浪子 ]
2014/01/24 01:12 | by 孤城浪子 ]
declare @a int;
declare @iddd int;
declare @itemp varchar(8000);
set @a=11;
while @a<=8503
begin
SELECT @itemp =CONTENT FROM ARTICLE where idid=@a;
SELECT @itemp = CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:variable("@itemp"))', 'VARBINARY(MAX)') AS VARCHAR(MAX) );
update ARTICLE set [CONTENT]=@itemp where idid=@a;
set @a=@a+1;
end
declare @iddd int;
declare @itemp varchar(8000);
set @a=11;
while @a<=8503
begin
SELECT @itemp =CONTENT FROM ARTICLE where idid=@a;
SELECT @itemp = CAST(CAST(N'' AS XML).value('xs:base64Binary(sql:variable("@itemp"))', 'VARBINARY(MAX)') AS VARCHAR(MAX) );
update ARTICLE set [CONTENT]=@itemp where idid=@a;
set @a=@a+1;
end
[ 2013/05/26 18:58 | by 孤城浪子 ]
2013/05/26 18:58 | by 孤城浪子 ]
WINDOWS 服务器 IP安全策略手工命令行添加的命令
netsh ipsec static add filter filterlist=筛选器名 dstaddr=目标IP protocol=TCP srcmask=255.255.255.255 dstmask=255.255.255.255 srcaddr=源IP
如果是我的IP地址就用 0.0.0.0
netsh ipsec static add filter filterlist=筛选器名 dstaddr=目标IP protocol=TCP srcmask=255.255.255.255 dstmask=255.255.255.255 srcaddr=源IP
如果是我的IP地址就用 0.0.0.0
[ 2012/10/19 21:53 | by 孤城浪子 ]
2012/10/19 21:53 | by 孤城浪子 ]
在ajax调试，flash与服务器端通信，flex调试时候通常要监视客户端与服务端通信的数据以监视数据的正常与否。
一般情况下可以使用Iris这类专业及工具进行数据包监听，不过格式比较复杂。
我为了监听flash向服务器端提交的请求，特地写了这个文件。
保存到监听文件即可。
PHP代码
- <?
- //以下是数据记录
- $filename = 'plugins.txt';
- $get_content = $_GET;
- $post_content = $_POST;
- // 首先要确定文件存在并且可写。
- if (is_writable($filename)) {
- if (!$handle = fopen($filename, 'a')) {
- echo "不能打开文件 $filename";
- exit;
- }
- if ($get_content!="")
- {
- $time=date("Y-m-d H;i:s",time());
- file_put_contents($filename, "\n\n".$time."GET\n",FILE_APPEND);
- foreach ($get_content as $m_key => $m_value)
- {
- $key =$m_key ;
- $value =$m_value;
- file_put_contents($filename, $key.'=>'.$value."\n",FILE_APPEND);
- }
- }
- if ($post_content!="")
- {
- $time=date("Y-m-d H;i:s",time());
- file_put_contents($filename, "\n\n".$time."POST\n",FILE_APPEND);
- foreach ($post_content as $m_key => $m_value)
- {
- $key =$m_key;
- $value =$m_value;
- file_put_contents($filename, $key.'=>'.$value."\n",FILE_APPEND);
- }
- }
- } else {
- echo "文件 $filename 不可写";
- }
- ?>
即可在plugins.txt文件中记录参数。格式如下：
[ 2012/10/19 18:09 | by 孤城浪子 ]
2012/10/19 18:09 | by 孤城浪子 ]
$file="log.txt";
$userip = ($_SERVER['X_FORWARDED_FOR']) ? $_SERVER['X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
$hanlder=fopen($file,"ab+");
fwrite($hanlder,$userip.date("Y-m-d H:i:s").$POST."\r\n");
fclose($hanlder);
这样输出格式为 IP+时间+POST内容
$userip = ($_SERVER['X_FORWARDED_FOR']) ? $_SERVER['X_FORWARDED_FOR'] : $_SERVER['REMOTE_ADDR'];
$hanlder=fopen($file,"ab+");
fwrite($hanlder,$userip.date("Y-m-d H:i:s").$POST."\r\n");
fclose($hanlder);
这样输出格式为 IP+时间+POST内容
[ 2011/12/02 02:22 | by 孤城浪子 ]
2011/12/02 02:22 | by 孤城浪子 ]
