Hi

Original link: https://5ime.cn/excel2sql.html I recently encountered a need to import an Excel类型question bank into the database (the specific format is shown in the figure below), and Baidu found a suitable library PhpSpreadsheet PhpSpreadsheet is a library written in pure PHP that provides a set of classes that allow you to read and write various spreadsheet […]

Original link: https://5ime.cn/shortcuts.html Recently, the main machine has been replaced by an iPhone . During use, I suddenly realized that Safari cannot download direct-link videos… After a brief study of the shortcut commands, the whole automation came out, and I felt very confused when adjusting the shortcut commands, and获取URL的内容often not displayed (I am a good

Original link: https://5ime.cn/ws-notify.html WebSocket is a protocol for full-duplex communication over a single TCP connection, allowing the server to actively push data to the client. Recently, I was developing the公告实时推送in MoeCTF . I originally wanted to implement it through轮询, but after thinking about轮询, the client actively sends requests to the server. If a single user

Original link: https://5ime.cn/moectf.html The most familiar language PHP was used for platform development, and finally ThinkPHP was used for development. The back-end all returned JSON data, and the front-end rendered pages in real time through ajax , which took nearly a week of development. Since MoeCTF is positioned as a (small) team ‘s internal training

Original link: https://5ime.cn/qwbqsn-2022.html This time I lost a big strategy, and the web pulled my crotch Crypto crypto1 Without rules, how to analyze it? Downloaded a bunch of AB strings, tried bacon, didn’t work, then tried Morse code, got a bunch of English Let’s run quipqiup directly to get the flag Misc misc1 Do you

Original link: https://5ime.cn/2022-sd.html Web Open the environment comment prompts to access robots.txt After accessing robots.txt , you will get two files source.php and flag.php . Accessing source.php prompts post to pass admin Just tried the commit and got only 127.0.0.1 can get the flag!! 1 admin = 1 Simply fuzz it, add the X-Client-ip header

Original link: https://5ime.cn/isg-2022.html There are many things to do at the beginning of the school, and the time of Guan’an and Wangding perfectly coincides, and it is simple to paddle. Misc DISG Hacker Li Ming edited an important file on his disk and deleted it immediately. We got his disk image file. Can you help

Original link: https://5ime.cn/wangdingcup-2022.html There are many things to do at the beginning of school, and the time of Wangding and Guan’an coincide perfectly, and it is simple to paddle. Crypto crypto091 Xiao A mustered up the courage to ask the goddess for a phone number, but the goddess must test him. The goddess said she

Original link: https://5ime.cn/qwb-2022.html write in front The Qiangwang Cup is not badly called the Strong Pwn Cup, with 17 Pwn questions. I don’t know what happened in previous years. There are many recurring CVE questions this year. I don’t know whether other questions have CVE. 1 2 3 myJWT CVE- 2022 – 21449 WP -UM

Original link: https://5ime.cn/cloudflare-block-ip.html Due to the recent increase in malicious attacks, it is very annoying to block a large number of IPs in batches, so I simply wrote a script to automatically block them. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 twenty

Original link: https://5ime.cn/qgb-2022.html write in front I feel that the competition experience is average. It is understandable that after all, this competition is the first time. The sign-in question was squatted on time at 8:59 , and the sign-in question was only at 9:01 ? ! At first I thought there was no sign in

Original link: https://5ime.cn/doyoulikeme.html Someone should have noticed that the blogger added a Do You Like Me widget to the sidebar. In fact, I think the easier way is to use PHP+SQL+AJAX , but in the idea of ​​tossing + reducing costs (white prostitution) , using Vercel , LeandCloud and Node.JS to roll one out. Node

Original link: https://5ime.cn/sinaurl.html In fact, as early as 2018年I wrote that PHP calls Sina API to generate short URLs , but 2020年Weibo released an announcement on the implementation of the external chain whitelist mechanism on the Weibo platform , restricting that only白名单内域名can be generated normally. , the非白名单域名jump will show a prompt message, and you can