Windows 10系统想要下载应用和游戏都需要在应用商店Microsoft Store中下载，但是很多用户反馈应用商店打不开，无法加载页面，请稍后重试的错误，下面通常还有一些代码什么的，不过参考意义不大，下面就教大家如何解决这个问题。
分类： Windows
Office 2007 VBA上传文件
Public Function UploadFileTo(sFileName As String, uURL As String, nameFieldID As String, dataFieldID As String, formID As String) As Boolean
Const STR_BOUNDARY As String = "a832972453175"
Dim nFile As Integer
Dim baBuffer() As Byte
Dim sPostData As String
Dim WinHttpReq As Object
Set WinHttpReq = CreateObject("Microsoft.XMLHTTP")
UploadFileTo = False
'--- read file
nFile = FreeFile
Open sFileName For Binary Access Read As nFile
If LOF(nFile) > 0 Then
ReDim baBuffer(0 To LOF(nFile) - 1) As Byte
Get nFile, , baBuffer
sPostData = StrConv(baBuffer, vbUnicode)
End If
Close nFile
sPostData = "--" & STR_BOUNDARY & vbCrLf & _
"Content-Disposition: form-data; name=""file""; filename=""" & Mid$(sFileName, InStrRev(sFileName, "\") + 1) & """" & vbCrLf & _
"Content-Type: text/plain" & vbCrLf & vbCrLf & _
sPostData & vbCrLf & vbCrLf & _
STR_BOUNDARY & vbCrLf & _
"Content-Disposition: form-data; name=""Action""" & vbCrLf & _
vbCrLf & "Send File" & vbCrLf & _
"--" & STR_BOUNDARY & "--"
With WinHttpReq
'UPLOAD REQUEST
.Open "POST", uURL, False
.setRequestHeader "Content-Type", "multipart/form-data; boundary=" & STR_BOUNDARY
.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
.send (sPostData)
End With
''---------------------------
UploadFileTo = True
End Function
Private Sub SelFileButton_Click()
'新建一个对话框对象
Set oFD = Application.FileDialog(msoFileDialogFilePicker)
'配置对话框
With oFD
.Title = "请选择要查找的文件夹"
.InitialFileName = "C:\"
.Filters.Clear
.Filters.Add "All Files", "*.*", 1
End With
'显示对话框
oFD.Show
'获取选择对话框选择的文件夹
Set fs = oFD.SelectedItems
For Each f In fs
SelFileTextBox.Value = f
Next
End Sub
Private Sub UploadButton_Click()
If Trim$(SelFileTextBox.Value) = vbNullString Then
MsgBox "没有选择需要上传的文件"
Else
If UploadFileTo(SelFileTextBox.Value, "http://127.0.0.1:8000/", "myFileNameField", "myFileData", "myDistantForm") Then
MsgBox "文件上传成功"
Else
MsgBox "文件上传失败"
End If
End If
End Sub
# -*- coding: utf-8 -*-
#!/usr/bin/env python3
"""Simple HTTP Server With Upload.
This module builds on BaseHTTPServer by implementing the standard GET
and HEAD requests in a fairly straightforward manner.
see: https://gist.github.com/UniIsland/3346170
"""
__version__ = "0.1"
__all__ = ["SimpleHTTPRequestHandler"]
import os
import posixpath
import http.server
import urllib.request, urllib.parse, urllib.error
import cgi
import html
import shutil
import mimetypes
import re
from io import BytesIO
class SimpleHTTPRequestHandler(http.server.BaseHTTPRequestHandler):
"""Simple HTTP request handler with GET/HEAD/POST commands.
This serves files from the current directory and any of its
subdirectories. The MIME type for files is determined by
calling the .guess_type() method. And can reveive file uploaded
by client.
The GET/HEAD/POST requests are identical except that the HEAD
request omits the actual contents of the file.
"""
server_version = "SimpleHTTPWithUpload/" + __version__
def do_GET(self):
"""Serve a GET request."""
f = self.send_head()
if f:
self.copyfile(f, self.wfile)
f.close()
def do_HEAD(self):
"""Serve a HEAD request."""
f = self.send_head()
if f:
f.close()
def do_POST(self):
"""Serve a POST request."""
r, info = self.deal_post_data()
print((r, info, "by: ", self.client_address))
f = BytesIO()
f.write(b'<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">')
f.write(b"<html>\n<title>Upload Result Page</title>\n")
f.write(b"<body>\n<h2>Upload Result Page</h2>\n")
f.write(b"<hr>\n")
if r:
f.write(b"<strong>Success:</strong>")
else:
f.write(b"<strong>Failed:</strong>")
f.write(info.encode())
f.write(("<br><a href=\"%s\">back</a>" % self.headers['referer']).encode())
f.write(b"<hr><small>Powerd By: bones7456, check new version at ")
f.write(b"<a href=\"http://li2z.cn/?s=SimpleHTTPServerWithUpload\">")
f.write(b"here</a>.</small></body>\n</html>\n")
length = f.tell()
f.seek(0)
self.send_response(200)
self.send_header("Content-type", "text/html")
self.send_header("Content-Length", str(length))
self.end_headers()
if f:
self.copyfile(f, self.wfile)
f.close()
def deal_post_data(self):
content_type = self.headers['content-type']
if not content_type:
return (False, "Content-Type header doesn't contain boundary")
boundary = content_type.split("=")[1].encode()
remainbytes = int(self.headers['content-length'])
line = self.rfile.readline()
remainbytes -= len(line)
if not boundary in line:
return (False, "Content NOT begin with boundary")
line = self.rfile.readline()
remainbytes -= len(line)
fn = re.findall(r'Content-Disposition.*name="file"; filename="(.*)"', line.decode())
if not fn:
return (False, "Can't find out file name...")
path = self.translate_path(self.path)
fn = os.path.join(path, fn[0])
line = self.rfile.readline()
remainbytes -= len(line)
line = self.rfile.readline()
remainbytes -= len(line)
try:
out = open(fn, 'wb')
except IOError:
return (False, "Can't create file to write, do you have permission to write?")
preline = self.rfile.readline()
remainbytes -= len(preline)
while remainbytes > 0:
line = self.rfile.readline()
remainbytes -= len(line)
if boundary in line:
preline = preline[0:-1]
if preline.endswith(b'\r'):
preline = preline[0:-1]
out.write(preline)
out.close()
return (True, "File '%s' upload success!" % fn)
else:
out.write(preline)
preline = line
return (False, "Unexpect Ends of data.")
def send_head(self):
"""Common code for GET and HEAD commands.
This sends the response code and MIME headers.
Return value is either a file object (which has to be copied
to the outputfile by the caller unless the command was HEAD,
and must be closed by the caller under all circumstances), or
None, in which case the caller has nothing further to do.
"""
path = self.translate_path(self.path)
f = None
if os.path.isdir(path):
if not self.path.endswith('/'):
# redirect browser - doing basically what apache does
self.send_response(301)
self.send_header("Location", self.path + "/")
self.end_headers()
return None
for index in "index.html", "index.htm":
index = os.path.join(path, index)
if os.path.exists(index):
path = index
break
else:
return self.list_directory(path)
ctype = self.guess_type(path)
try:
# Always read in binary mode. Opening files in text mode may cause
# newline translations, making the actual size of the content
# transmitted *less* than the content-length!
f = open(path, 'rb')
except IOError:
self.send_error(404, "File not found")
return None
self.send_response(200)
self.send_header("Content-type", ctype)
fs = os.fstat(f.fileno())
self.send_header("Content-Length", str(fs[6]))
self.send_header("Last-Modified", self.date_time_string(fs.st_mtime))
self.end_headers()
return f
def list_directory(self, path):
"""Helper to produce a directory listing (absent index.html).
Return value is either a file object, or None (indicating an
error). In either case, the headers are sent, making the
interface the same as for send_head().
"""
try:
list = os.listdir(path)
except os.error:
self.send_error(404, "No permission to list directory")
return None
list.sort(key=lambda a: a.lower())
f = BytesIO()
displaypath = html.escape(urllib.parse.unquote(self.path))
f.write(b'<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 3.2 Final//EN">')
f.write(("<html>\n<title>Directory listing for %s</title>\n" % displaypath).encode())
f.write(("<body>\n<h2>Directory listing for %s</h2>\n" % displaypath).encode())
f.write(b"<hr>\n")
f.write(b"<form ENCTYPE=\"multipart/form-data\" method=\"post\">")
f.write(b"<input name=\"file\" type=\"file\"/>")
f.write(b"<input type=\"submit\" value=\"upload\"/></form>\n")
f.write(b"<hr>\n<ul>\n")
for name in list:
fullname = os.path.join(path, name)
displayname = linkname = name
# Append / for directories or @ for symbolic links
if os.path.isdir(fullname):
displayname = name + "/"
linkname = name + "/"
if os.path.islink(fullname):
displayname = name + "@"
# Note: a link to a directory displays with @ and links with /
f.write(('<li><a href="%s">%s</a>\n'
% (urllib.parse.quote(linkname), html.escape(displayname))).encode())
f.write(b"</ul>\n<hr>\n</body>\n</html>\n")
length = f.tell()
f.seek(0)
self.send_response(200)
self.send_header("Content-type", "text/html")
self.send_header("Content-Length", str(length))
self.end_headers()
return f
def translate_path(self, path):
"""Translate a /-separated PATH to the local filename syntax.
Components that mean special things to the local file system
(e.g. drive or directory names) are ignored. (XXX They should
probably be diagnosed.)
"""
# abandon query parameters
path = path.split('?',1)[0]
path = path.split('#',1)[0]
path = posixpath.normpath(urllib.parse.unquote(path))
words = path.split('/')
words = [_f for _f in words if _f]
path = os.getcwd()
for word in words:
drive, word = os.path.splitdrive(word)
head, word = os.path.split(word)
if word in (os.curdir, os.pardir): continue
path = os.path.join(path, word)
return path
def copyfile(self, source, outputfile):
"""Copy all data between two file objects.
The SOURCE argument is a file object open for reading
(or anything with a read() method) and the DESTINATION
argument is a file object open for writing (or
anything with a write() method).
The only reason for overriding this would be to change
the block size or perhaps to replace newlines by CRLF
-- note however that this the default server uses this
to copy binary data as well.
"""
shutil.copyfileobj(source, outputfile)
def guess_type(self, path):
"""Guess the type of a file.
Argument is a PATH (a filename).
Return value is a string of the form type/subtype,
usable for a MIME Content-type header.
The default implementation looks the file's extension
up in the table self.extensions_map, using application/octet-stream
as a default; however it would be permissible (if
slow) to look inside the data to make a better guess.
"""
base, ext = posixpath.splitext(path)
if ext in self.extensions_map:
return self.extensions_map[ext]
ext = ext.lower()
if ext in self.extensions_map:
return self.extensions_map[ext]
else:
return self.extensions_map['']
if not mimetypes.inited:
mimetypes.init() # try to read system mime.types
extensions_map = mimetypes.types_map.copy()
extensions_map.update({
'': 'application/octet-stream', # Default
'.py': 'text/plain',
'.c': 'text/plain',
'.h': 'text/plain',
})
def test(HandlerClass = SimpleHTTPRequestHandler,
ServerClass = http.server.HTTPServer):
http.server.test(HandlerClass, ServerClass, "HTTP/1.0", 8000, '127.0.0.1')
if __name__ == '__main__':
test()
参考链接
WOL网络唤醒在微星主板上开启(ubuntu 20.04/Windows 10双系统)
网络唤醒
微星H97I-AC的板子开启WOL网络唤醒
主板：微星 H97I-AC，集成 Realtek 千兆网卡,这个网卡自带网络唤醒功能，但是需要在操作系统中通过驱动开启这个功能，BIOS中无法直接开启。
操作系统：Windows 10/ubuntu 20.04双系统，双系统都需要进行配置，才能实现全部系统关机之后都能正常唤醒。
BIOS 设置
- 高级–整合周边设备–网卡ROM启动，设置为允许
- 高级–电源管理设置–Eup 2013，设置为禁止
- 高级–唤醒事件设置–PCIE设备唤醒，设置为允许
Windows 10 设置
- 控制面板–所有控制面板项–网络连接
- 在网卡适配器点击鼠标右键–属性，弹出的属性对话框中
- 选择网络选项卡–配置
- 选择高级选项卡，将
关机 网络唤醒设置为开启，将魔术封包唤醒设置为开启 - 电源管理选项卡，勾选下面三个选项，允许此设备唤醒计算机。
ubuntu 20.04设置
$ sudo apt-get install ethtool $ sudo apt-get install vim $ sudo vim /etc/systemd/system/wol.service
里面的内容如下：
[Unit] Description=Configure Wake On LAN [Service] Type=oneshot ExecStart=/sbin/ethtool -s eth0 wol g # 如果有多张网卡 # ExecStart=/bin/bash -c '/sbin/ethtool -s enp5s0 wol g && /sbin/ethtool -s eth0 wol g' [Install] WantedBy=basic.target
上述配置是向驱动发送控制命令，启用网络唤醒功能。
启用服务
$ sudo systemctl daemon-reload $ sudo systemctl enable wol.service $ sudo systemctl start wol.service
远程唤醒
$ sudo apt-get install wakeonlan -y $ wakeonlan MAC
也可尝试 etherwake
$ sudo apt-get install etherwake -y $ etherwake MAC # OpenWrt # opkg install etherwake # /usr/bin/etherwake -i br-lan MAC
参考链接
ThinkPad-T440安装Windows 7(USB 3.0)
ThinkPad-T440安装Windows 7的时候，使用USB外置光驱安装系统，由于系统光盘没有集成USB 3.0的驱动，导致在安装过程中，出现错误，错误信息如下图所示：
如何激活机器自带正版Windows10或Office/查询Windows内置序列号
不时看到新机友因为各种原因，无法正确激活机器自带的正版Windows10或Office，解决方法如下：
1、全新机器，第一次启动，连接上网。通常自动激活Windows10，Win10激活后，马上运行Office，据说因服务器原因很多机油无法立即激活，过一小会（几分钟）后就可以了。
1、全新机器，第一次启动，连接上网。通常自动激活Windows10，Win10激活后，马上运行Office，据说因服务器原因很多机油无法立即激活，过一小会（几分钟）后就可以了。
2、 通用手工激活方法，正确输入正版软件的系列号。 该系列号位于机器Bios内，且不会因官方Bios升级取消。
不会查Bios的童鞋，请下载Produkey（绿色软件）自行查询（目前测试ThinkPad T440是可以的）
Windows泄露文件目录分析
1）种子链接：https://itorrents.org/torrent/3D8B16242B56A3AAFB8DA7B5FC83EF993EBCF35B.torrent?title=[limetorrents.info]Microsoft.leaked.source.code.archive_2020-09-24（你不会想用手敲吧？）也可 本地下载
看了下大小是42.93GB（应该是对的~）
Android默认调试签名证书
今天遇到了需要手工用调试签名重新签名APK文件的一个需求。
Android默认调试签名证书位置
Windows：
C:\Users\<用户名>\.android\debug.keystore
macOS Catalina:
~/.android/debug.keystore
证书密码 ：android
签名脚本：
$ bash ~/Android/sdk/build-tools/29.0.2/apksigner sign --ks debug.keystore xxx.apk
参考链接
解决SourceTree 3.3.8访问Git库提示“access denied”
使用`SourceTree 3.3.8`，在检出版本库的时候，选择记住密码。过一段时间之后，版本库的密码修改之后，提示`access denied`。
解决方法为删除已经记住的用户名密码，如下：
del "C:\Users\%username%\AppData\Local\Atlassian\SourceTree\passwd"
具体文件位置如下图：
Download KMSpico 11 Final Windows 10 Activator [2020]
KMSpico激活工具是激活Office 2016/2013/2010等常用的工具，一段时期之内发生被植入挖矿病毒的情况。
目前比较安全的下载地址是 Download KMSpico 11 Final Windows 10 Activator [2020]，压缩包有密码，密码 123456。
也可本站下载 kmspico
参考链接
Windows系统盘符错乱导致桌面无法加载
系统：Windows 7
问题：
在`ubuntu 18.04` 系统上，使用 `gparted` 调整 `Windows 7` 系统分区大小之后，开机登陆用户，桌面无法显示，屏幕黑屏或者蓝色空白。
屏幕右下角显示:
Windows 7 内部版本7601 此Windows副本不是正版
按下 `Ctrl+Shift+DEL` 能打开任务管理器，但右击相关进程属性发现所有的系统应用显示为 `E:` 盘，可以确定是盘符错乱导致无法正常加载系统文件及和户配置。
解决方法：
用U盘PE启动,命令行中执行 `regist32.exe`，定位到 `HKEY_LOCAL_MACHINE\SYSTEM\MountedDevices`，复制 `\DosDevices\C:` 的值，这个值有长有短，但只要硬盘不变，分区不变，PE下得到的值和硬盘系统的值是一样的，可以直接复制过来用。
将光标定位在 `HKEY_LOCAL_MACHINE` 上，文件菜单或右键菜单上就可以有 `加载配置单元` ，到硬盘系统中注册表保存位置，`C:\Windows\System32\config\` 中，选择注册表文件 `SYSTEM` ，在弹出的框中输入一个 `项名字`(名字可以随意取)，如 `TEST`，然后 `HKEY_LOCAL_MACHINE` 下就会新增一个 `TEST` 节点，加载刚才选择的 `SYSTEM` 的配置。定位到 `MountedDevices`，找到对应的 `\DosDevices\C:`，把刚才复制的值粘贴过去。
重新启动系统。