Windows 10系统想要下载应用和游戏都需要在应用商店Microsoft Store中下载,但是很多用户反馈应用商店打不开,无法加载页面,请稍后重试的错误,下面通常还有一些代码什么的,不过参考意义不大,下面就教大家如何解决这个问题。
分类: Windows
Office 2007 VBA上传文件
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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 |
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 |
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 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 |
# -*- 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设置
1 2 3 4 5 |
$ sudo apt-get install ethtool $ sudo apt-get install vim $ sudo vim /etc/systemd/system/wol.service |
里面的内容如下:
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[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 |
上述配置是向驱动发送控制命令,启用网络唤醒功能。
启用服务
1 2 3 4 5 |
$ sudo systemctl daemon-reload $ sudo systemctl enable wol.service $ sudo systemctl start wol.service |
远程唤醒
1 2 3 |
$ sudo apt-get install wakeonlan -y $ wakeonlan MAC |
也可尝试 etherwake
1 2 3 4 5 6 7 |
$ 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内置序列号
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:
1 |
C:\Users\<用户名>\.android\debug.keystore |
macOS Catalina:
1 |
~/.android/debug.keystore |
证书密码 :android
签名脚本:
1 |
$ 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
。
解决方法为删除已经记住的用户名密码,如下:
1 |
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
系统分区大小之后,开机登陆用户,桌面无法显示,屏幕黑屏或者蓝色空白。
屏幕右下角显示:
1 2 3 |
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:
,把刚才复制的值粘贴过去。
重新启动系统。