5 Aug
真不想过LvQuan.com可以卖钱,从注册(2005年10月26日)到转让,差不多10年了。
LvQuan.com最初是在新网注册的,因解析受限且备案麻烦。一气之下,转到了name.com,当时还费了些周折(新网不肯转出)。
一直以来,欲收购LvQuan.com域名的人比较多,但一直没想过真卖。
今天,几点几不点,居然真的出手了,可惜啊,亏了500(比最低价)!

通过ADMIN5.net完成交易。
5 Jul
忘记对EXCEL加密的密码怎么办?可以用以下宏代码解决。
注意:破解后的文件需另存为——
Public Sub 工作表保护密码破解()
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
"作者:McCormick   JE McGimpsey "
Const HEADER As String = "工作表保护密码破解"
Const VERSION As String = DBLSPACE & "版本 Version 1.1.1"
Const REPBACK As String = DBLSPACE & ""
Const ZHENGLI As String = DBLSPACE & "JOBSH整理"
Const ALLCLEAR As String = DBLSPACE & "该工作簿中的工作表密码保护已全部解除!!" & DBLSPACE & "请记得另保存" _
& DBLSPACE & "注意:不要用在不当地方!"
Const MSGNOPWORDS1 As String = "该文件工作表中没有加密"
Const MSGNOPWORDS2 As String = "该文件工作表中没有加密2"
Const MSGTAKETIME As String = "解密需花费一定时间,请耐心等候!" & DBLSPACE & "按确定开始破解!"
Const MSGPWORDFOUND1 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _
"如果该文件工作表有不同密码,将搜索下一组密码并修改清除"
Const MSGPWORDFOUND2 As String = "密码重新组合为:" & DBLSPACE & "$$" & DBLSPACE & _
"如果该文件工作表有不同密码,将搜索下一组密码并解除"
Const MSGONLYONE As String = "确保为唯一的?"
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
Else
On Error Resume Next
Do 'dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
"$$", PWord1), vbInformation, HEADER
Exit Do 'Bypass all for...nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
'Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
'Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do 'Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
"$$", PWord1), vbInformation, HEADER
'leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do 'Bypass all for...nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK & ZHENGLI, vbInformation, HEADER
End Sub
8 Jun
Tags: , ,
数据表结构:

--
-- 表的结构 `ceshi`
--

CREATE TABLE IF NOT EXISTS `ceshi` (
  `id` int(5) NOT NULL auto_increment,
  `income` decimal(9,2) NOT NULL,
  `spending` decimal(9,2) NOT NULL,
  `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

如图:
点击在新窗口中浏览此图片点击在新窗口中浏览此图片

假设要对income(收入字段)和spending(支出字段)汇总,语句如下:
select id,income,spending,date from ceshi
union all
select "Total",sum(income),sum(spending),"" from (
select id,income,spending,date from ceshi) a

语句中最后的“a”相对于严重符号,但必须有,否则无效。
10 Apr
  近日,有媒体披露了一段《贫困县官员追求奢靡 主持怒斥直播现场被换》的视频。从视频6分40秒开始,主持人对湖北房县官员修建豪华办公楼发表了评论:
  “房县是国家级贫困县,是一个中小学教学楼还有一大部分处于危房的地方,县老爷的办公室却盖得这么豪华,国家级贫困县的办公室盖出了经济发展先进县的感觉。刚刚的节目当中,有位领导说政府是全县人民的面子,这个面子不能丢。看来,他们比的不是人民生活水平的改善,比的不是政府服务水平的提高,比的是奢华,比的是出入的排场。这样的领导、这样的干部,不腐败可能吗?这样的领导、这样的干部,不腐败你信不信?”
20 Mar
Tags: ,
两段代码:
一、
<?php
$filename = $_GET['filename'];  
header("Content-type: application/octet-stream");  
header("Content-Length: ".filesize($filename));  
header("Content-Disposition: attachment; filename=$filename");  
$fp = fopen($filename, 'rb');  
fpassthru($fp);  
fclose($fp);
?>

二、
<?php
$url = '路径+实际文件名';
$ljarr = explode( "/", $url);
$num = sizeof( $ljarr ) - 1;
$docname = $ljarr[$num];//取路径中的文件名,一般针对保存在数据库中的文件路径进行截取

header("Content-Type: application/force-download");//一定不要少了这个步骤,这个就是本文的关键步骤之一,提示下载
header("Content-Disposition: attachment; filename=".$docname);//实际的文件名
readfile($url);//从路径中读取文件的内容,这步是关键,如果没有这步,下载保存下来的文件就是空的,0字节。
?>
分页: 9/136 第一页 上页 4 5 6 7 8 9 10 11 12 13 下页 最后页 [ 显示模式: 摘要 | 列表 ]