Steps to Install Lineage OS 17.1 ROM on Galaxy Note 4
摘录
计算机
  • Make sure that you have downloaded all the required files on your device.
  • Now, copy the TWRP image file, GApps file, and ROM zip file to your device internal storage.
  • Next, reboot your Galaxy Note 4 into recovery mode.
  • You will boot into TWRP Recovery mode.
  • In recovery menu, tap on Install button > Install Image > Select the TWRP Image file from the location where you have moved earlier.
  • Swipe to confirm flash.
  • Now, reboot to recovery mode again.
  • In the TWRP menu, go to Wipe section.
  • Select Advanced Wipe > Select the data, system, vendor, cache. Then swipe to wipe it.
  • Flash the ROM zip file from the Install option.
  • The system will be mounted already Uncheck it & Remount system and vendor manually. Then flash Gapps zip file as well.
  • Finally, reboot your phone into a new system. Wait for it, as the boot process will take a few minutes.
  • That’s it. Enjoy!
搭建aria2离线下载服务器 ariaNG
摘录
计算机

一、搭建aria2离线下载服务器

1、安装aria2

sudo apt-get install aria2

2、aria2基本配置

sudo mkdir /etc/aria2    #新建文件夹 
sudo touch /etc/aria2/aria2.session    #新建session文件
sudo chmod 777 /etc/aria2/aria2.session    #设置aria2.session可写 
sudo vim /etc/aria2/aria2.conf    #创建配置文件

3、 aria2.conf文件配置，注意此文件任意用户可读

dir=/home/aria2Down
disable-ipv6=true
#打开rpc的目的是为了给web管理端用
enable-rpc=true
rpc-allow-origin-all=true
rpc-listen-all=true
#rpc-listen-port=6800
#断点续传
continue=true
input-file=/etc/aria2/aria2.session
save-session=/etc/aria2/aria2.session
#最大同时下载任务数
max-concurrent-downloads=20
save-session-interval=120
# Http/FTP 相关
connect-timeout=120
#lowest-speed-limit=10K
#同服务器连接数
max-connection-per-server=10
#max-file-not-found=2
#最小文件分片大小, 下载线程数上限取决于能分出多少片, 对于小文件重要
min-split-size=10M
#单文件最大线程数, 路由建议值: 5
split=10
check-certificate=false
#http-no-cache=true

4、 增加开机启动脚本

sudo nano /etc/init.d/aria2c

内容如下

#!/bin/sh
### BEGIN INIT INFO
# Provides: aria2
# Required-Start: $remote_fs $network
# Required-Stop: $remote_fs $network
# Default-Start: 2 3 4 5
# Default-Stop: 0 1 6
# Short-Description: Aria2 Downloader
### END INIT INFO
 
case "$1" in
start)
 
 echo -n "已开启Aria2c"
 sudo aria2c --conf-path=/etc/aria2/aria2.conf -D
;;
stop)
 
 echo -n "已关闭Aria2c"
 killall aria2c
;;
restart)
 
 killall aria2c
 sudo aria2c --conf-path=/etc/aria2/aria2.conf -D
;;
esac
exit

5、修改权限

sudo chmod 755 /etc/init.d/aria2c

6、 添加aria2c服务到开机启动

cd /etc/init.d
sudo update-rc.d aria2c defaults

7、 启动并查看服务

sudo service aria2c start

sudo systemctl status aria2c

https://github.com/mayswind/AriaNg

How To Install and Use Composer on Ubuntu 20.04
摘录
计算机

https://www.digitalocean.com/community/tutorials/how-to-install-and-use-composer-on-ubuntu-20-04

• sudo apt update

• sudo apt install php-cli unzip

• cd ~

• curl -sS https://getcomposer.org/installer -o composer-setup.php

• HASH=`curl -sS https://composer.github.io/installer.sig`

• echo $HASH

Output

e0012edf3e80b6978849f5eff0d4b4e4c79ff1609dd1e613307e16318854d24ae64f26d17af3ef0bf7cfb710ca74755a

• php -r "if (hash_file('SHA384', 'composer-setup.php') === '$HASH') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"

Installer verified

• sudo php composer-setup.php --install-dir=/usr/local/bin --filename=composer

Output

All settings correct for using Composer Downloading...

Composer (version 1.10.5) successfully installed to:

/usr/local/bin/composer

Use it: php /usr/local/bin/composer To test your installation, run:

• composer

• Output

Tuesday, August 25, 2020 - 17:58
原创
计算机

卡死了，卡死了，6年前的桌面台式机ubuntu下跑不太动去年11月的Formtools了－－还依旧用十几、几十年前的观念来看待今天的世界吗？，－－淘汰、淘汰、淘汰……

mysql 8.0
摘录
计算机

use mysql;

CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';

GRANT ALL ON *.* TO 'username'@'localhost'; flush privileges;

excel 常用公式收集
原创
计算机

1、对2003版，最大行数是65536行  2、对2007以上版本，最大行数是1048576行

身份证 换算年龄

---按年计算（虚岁）

=YEAR(NOW())-MID(A2,7,4)   

----算周岁 y 为年数 m 为月数 d 为天数

=DATEDIF(TEXT(MID(D3,7,8),"0000-00-00"),TODAY(),"y")

--- 算到2018-12-31 的周岁 

=DATEDIF(TEXT(MID(D5,7,8),"0000-00-00"),"2018-12-31","y")

 

比对数据 

=TRIM(VLOOKUP(G4,Sheet!A:C,3,0))

--- G4 查找的内容，Sheet 供对照的工作本  A:C 查找的范围 ， 查找的第3列，0 精准匹配 TRIM去格

检验数位数     =IF(LEN(D2)=11,0,1)

Sunday, October 27, 2019 - 19:35
原创
计算机

波士顿动力公司的机器人。
这是要参加奥运体操比赛吗？

Video file
用过的 一个 access VBA
摘录
计算机

Option Compare Database

Private Sub Form_Current()
    DoCmd.Maximize
End Sub
Private Sub Command11_Click()
Dim strWhere As String
    strWhere = "拼音 Like '*" & Me.Text6 & "*'"
    Me.S窗体.Form.Filter = strWhere
    Me.S窗体.Form.FilterOn = True
End Sub

Private Sub Command130_Click()
Dim strWhere As String
    strWhere = "五笔 Like '*" & Me.Text162 & "*'"
    Me.S窗体.Form.Filter = strWhere
    Me.S窗体.Form.FilterOn = True
End Sub

Private Sub Fdelall_Click()
     SQLSTR = "delete * from grade"
     DoCmd.SetWarnings False              ' 取消系统提示
    DoCmd.RunSQL SQLSTR            ' 运行查询
    DoCmd.SetWarnings True                ' 恢复系统提示
    Me.F窗体.Form.Requery
End Sub

 

 

Option Compare Database

Private Sub S序号_DblClick(Cancel As Integer)
  Call llx
End Sub


Private Sub S项目编码_DblClick(Cancel As Integer)
  Call llx
End Sub

Private Sub S项目名称_DblClick(Cancel As Integer)
  Call llx
End Sub

Private Sub S剂型_DblClick(Cancel As Integer)
  Call llx
End Sub
Private Sub S规格_DblClick(Cancel As Integer)
  Call llx
End Sub

Private Sub S厂家_DblClick(Cancel As Integer)
  Call llx
End Sub

Sub llx()
    SQLSTR = "insert into grade(项目编号, 项目名称,剂型, 厂家, 规格) SELECT  项目编号, 项目名称,剂型, 厂家, 规格 FROM ypk WHERE 序号 = " & Me.序号 & ""


    DoCmd.SetWarnings False              ' 取消系统提示
    DoCmd.RunSQL SQLSTR            ' 运行查询
    DoCmd.SetWarnings True                ' 恢复系统提示

    Me.Parent.F窗体.Form.Requery
End Sub


 

 

Option Compare Database

Private Sub F项目编号_DblClick(Cancel As Integer)
 Call Fdelone
End Sub

Private Sub F项目名称_DblClick(Cancel As Integer)
 Call Fdelone
End Sub

Private Sub F厂家_DblClick(Cancel As Integer)
   Call Fdelone
End Sub

Private Sub F规格_DblClick(Cancel As Integer)
 Call Fdelone
End Sub
Private Sub F剂型_DblClick(Cancel As Integer)
 Call Fdelone
End Sub

Sub Fdelone()
     SQLSTR = "delete * from grade WHERE  序号  = " & Me.序号 & ""
     DoCmd.SetWarnings False              ' 取消系统提示
    DoCmd.RunSQL SQLSTR            ' 运行查询
    DoCmd.SetWarnings True                ' 恢复系统提示
    Me.Form.Requery
End Sub

 

excel中把汉字转换成拼音(只取首字母)
摘录
计算机

  1. 1.启动Excel 2003（其它版本请仿照操作），打开相应的工作表；

  2. 2.执行“工具→宏→Visual Basic编辑器”命令（或者直接按“Alt+F11”组合键），进入Visual Basic编辑状态；

  3. 3.执行“插入→模块”命令，插入一个新模块。再双击插入的模块，进入模块代码编辑状态；

  4. 4.将代码输入其中；

    Function pinyin(p As String) As String

    i = Asc(p)

    Select Case i

    Case -20319 To -20284: pinyin = "A"

    Case -20283 To -19776: pinyin = "B"

    Case -19775 To -19219: pinyin = "C"

    Case -19218 To -18711: pinyin = "D"

    Case -18710 To -18527: pinyin = "E"

    Case -18526 To -18240: pinyin = "F"

    Case -18239 To -17923: pinyin = "G"

    Case -17922 To -17418: pinyin = "H"

    Case -17417 To -16475: pinyin = "J"

    Case -16474 To -16213: pinyin = "K"

    Case -16212 To -15641: pinyin = "L"

    Case -15640 To -15166: pinyin = "M"

    Case -15165 To -14923: pinyin = "N"

    Case -14922 To -14915: pinyin = "O"

    Case -14914 To -14631: pinyin = "P"

    Case -14630 To -14150: pinyin = "Q"

    Case -14149 To -14091: pinyin = "R"

    Case -14090 To -13319: pinyin = "S"

    Case -13318 To -12839: pinyin = "T"

    Case -12838 To -12557: pinyin = "W"

    Case -12556 To -11848: pinyin = "X"

    Case -11847 To -11056: pinyin = "Y"

    Case -11055 To -2050: pinyin = "Z"

    Case Else: pinyin = p

    End Select

    End Function

    Function getpy(str)

    For i = 1 To Len(str)

    getpy = getpy & pinyin(Mid(str, i, 1))

    Next i

    End Function

  5. 5

    5.代码输入完成后，关闭Visual Basic编辑窗口，返回Excel编辑状态；

  6. 6

    6.自定义函数就可以用了，如：选中A2单元格，输入公式：=getpy(A2)。

关于双网卡电脑，特定网页走特定网卡的设置
摘录
计算机

route add 172.160.1.0  mask  255.255.255.0  192.168.1.1 -p  

----IP 、mask、 网关换成相应的  -p 表示永久

route delete 172.160.1.0  mask  255.255.255.0  192.168.1.1 -p    

-- 删掉

 

首先要知道换网卡顺序是否可以进
打开网络共享中心，在左侧中间，点入后，按一下alt建，按高级，再按高级设置，在第一个页面调整顺序
若是换网卡顺序都不能进去，请百度或必应错误寻找解决办法

下面主要介绍换网卡就可以进去的方法


1、  可用网卡进去后

打开CMD，输入“ping+空格+域名”（域名为中间那个，如www.baidu.com,域名为baidu）

Ping完后会出现IP地址，以及TTL（跃点），记下来

2、   查看添加路由

在CMD中，输入“route print”可显示本机路由表，查看永久路由中是否两张网卡的网关都存在。（以内网和外网为例：两个都存在可能会存在冲突，这时候我们就要删除内网网关）

删除流程：先在注册表中将对应的的永久路由条目删掉
永久路由条目位置：
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\PersistentRoutes
删除后，重起电脑，完毕后来，再使用route delete 0.0.0.0 mask 0.0.0.0 192.XXX.XX.XX（永久路由的网关）

添加永久路由：知道ip和跃点后，我们可以添加永久路由来解决域名没有解析的问题。输入： route add -p x.x.x.x mask x.x.x.x  z.z.z.z metric 1

                                                                                                                                                                                  (外网IP)（子网掩码如255.255）（网卡网关永久路由表看到那个如10.0）

（metric 1 数字代表跃点数，上面有说如何查）

特别说明：添加路由后，登录此网站可能需要直接输入其ip地址，不能用域名登录
--------------------- 
作者：skHougeng 
来源：CSDN 
原文：https://blog.csdn.net/a2009a11a29/article/details/77880549 
版权声明：本文为博主原创文章，转载请附上博文链接！

Subscribe to 计算机