新冠疫情Covid-19公开的数据源 Novel Coronavirus (COVID-19) Cases Data https://data.humdata.org/dataset/novel-coronavirus-2019-ncov-cases COVID-19 开放研究数据集地址： https://pages.semanticscholar.org/coronavirus-research COVID-19 开放研究数据集挑战赛地址： https://www.kaggle.com/allen-institute-for-ai/CORD-19-research-challenge 北美新型冠状肺炎COVID-19疫情实时动态| 一亩三分地 https://coronavirus.1point3acres.com/?from=groupmessage  893 total views

How featured image stored in MySQL database? Featured image in wp_posts table: post_author = '77777' post_parent = [post_id] guid = [image url] post_type = 'attachement' post_mime_type = 'image/jpeg' Featured image in wp_postmeta table: There are 3 meta_keys hold the image information. post_id, meta_key, meta_value = [post id], '_thumbnail_id', [featured image post id] post_id, meta_key, meta_value = [featured image post id], '_wp_attached_file', [image url] post_id, meta_key, meta_value = [featured image post id], '_wp_attachment_image_alt', [image alt] Optimize data structure Move the featured image record right next to the post. set @id = 2334; -- post id set @id1 = 2335; -- new image post id set @id2= 2339; -- old image post id update wp_posts set id=@id1 where id=@id2; update wp_postmeta set post_id=@id1 where post_id=@id2 and meta_key like '_wp_attach%'; update wp_postmeta set meta_value=@id1 where post_id=@id and meta_key='_thumbnail_id';  984 total views

Further reading content should be based on the post category in order to get the title and permalinks of the related posts. First approach We could use filter to change the post contents. But it does not work as expected. The result is the new contents are added on each paginated page, and break the pagination link block. function my_content_filter($content) { $content .= further_reading(); return $content; } function stringInsert($str,$insertstr,$pos) { $str = substr($str, 0, $pos) . $insertstr . substr($str, $pos); return $str; } add_filter( 'the_content', 'my_content_filter', 1 ); //set priority to 1 in order to add the new content right after post content from database. Second approach The alternative way is to modify paging plugin directly. Plugin: automatically-paginate-posts File to change: /wp-content/plugins/automatically-paginate-posts/automatically-paginate-posts.php Inside paging plugin, it uses 'the_post' filter to make pagination. What we need to do is to change the post content directly in the $post object in filter_the_posts function. $the_post->post_content .= further_reading(); $content = $the_post->post_content; Avoid plugin auto-update In order to keep the custom changes we need to avoid the plugin update. Change the plugin version number to a big number. Add 9 prefix in this case. Version: 90.2 further_reading function function further_reading(){ ob_start(); ?> <style> .further-reading{margin-top:50px;} .further-articles{background:#407a9e;width:100%;padding:8px 20px;color:white;font-size:18px;font-weight:bold;} </style> <div class="further-reading"> <div class="further-articles">相关文章</div> <div style="margin:20px;"> <?php //note that the_id() is not work in this context, so we have to identify the post from url. $us = explode('/',$_SERVER['REQUEST_URI']); $count= count($us); $post_name = $us[$count-2]; if(is_numeric($post_name)) //paging number $post_name = $us[$count-3]; $post = get_page_by_path( $post_name, OBJECT, 'post' ); $post_id = $post->ID; $cats = get_the_category($post_id); foreach($cats as $cat){ $related_posts = get_posts(…

With web page history we can see how the page involved over time. If we found issues on current version web page, we still can compare to the previous version of the page and fix it easily. On google search we can get google cached pages. Just click on the little green down arrow, then cached. Tool: https://cachedview.com/ We can get google cached pages, or archive.org cached pages. Tool: http://www.cachedpages.com/ Google cached only get the latest version page before current one. Archive.org provides more versions of pages. Note that it is not cached very day! For example, articles that reference wechat images may encountered this situation all the sudden: Search the archieved page would give you idea how to fix it. Google the article title and look at the images. You could download the old images and upload it again to fix the issue.  720 total views

In WordPress all scheduled events are controled by wp-cron.php file. How cron job work in WordPress The file wp-cron.php is the part of WordPress that handles scheduled events within a WordPress site. Anything that has to do with scheduling posts or publications and really anything date/time oriented is governed by the wp-cron.php file. In order for wp-cron.php to work properly, it needs to be executed frequently, but no more than once per minute. However, the default behavior does not require you to set up a real system level cron job on your server. Instead, it uses a piggyback method on every incoming request. When a request comes into the site, WordPress will generate an additional request from itself to the wp-cron.php file over HTTP(S). It is invoked by http(s) each request. If no any request all events would never run. What if a large number of requests in a short period of time? It would become DDOS attack. Alternatives The best practice for scheduled jobs is to setup system cron job on server side that executes the wp-cron.php script directly through PHP in certain interval. This ensures that any scheduled tasks are indeed executed at their scheduled time. Cron functions Create cron hook add_action( 'hostlike_cron_hook', 'wp_cron_function' ); Schedule a task wp_schedule_event ( time(),  'hourly',  'hostlike_cron_hook' );  //may register duplicate event wp_next_scheduled ( 'hostlike_cron_hook' );   //return next execution timestamp, it check if a particular hook is already scheduled to ensure the event only be registerred once Recurring event if ( ! wp_next_scheduled( 'hostlike_cron_hook' ) ) { wp_schedule_event( time(), 'hourly', 'hostlike_cron_hook' );…

Symptom Event Calendar stop working. /events/, and event page shows 500 error. /contact/ page shows 500 error. Problem .htaccess file was changed. Working file: # HTTPS forced by SG-Optimizer <IfModule mod_rewrite.c> RewriteEngine On RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{SERVER_NAME}%{REQUEST_URI} [R=301,L] </IfModule> # END HTTPS # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase / RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> # END WordPress It was changed to # This file was updated by Duplicator on 2019-12-30 00:19:21. See .htaccess.orig for the original .htaccess file. # Please note that other plugins and resources write to this file. If the time-stamp above is different # than the current time-stamp on the file system then another resource has updated this file. # Duplicator only writes to this file once during the install process while running the installer.php file. # BEGIN WordPress <IfModule mod_rewrite.c> RewriteEngine On RewriteBase /s/ RewriteRule ^index\.php$ - [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /s/index.php [L] </IfModule> # END WordPress Related note Pages and posts are getting 404 Note This change is sespected as hacker action. It was imposible to use duplicator installer on the date.  485 total views

Download package file from DownloadFreeThemes and unzip the file. Installation guide video on youtube.  Install wordpress as normal, then activate BeautyPack theme, goto dashboard to import files. Install required plugins Clear existing posts and pages Files in theme package Import theme options Import sliders Import menu, posts, pages Page builder settings Change wp settings Final demos  512 total views

There are a few way to redirect a site. 1. using meta refresh. Meta refresh is a method of instructing a web browser to automatically refresh the current web page or frame after a given time interval, using an HTML meta element with the http-equiv parameter set to "refresh" and a content parameter giving the time interval in seconds. It is also possible to instruct the browser to fetch a different URL when the page is refreshed, by including the alternative URL in the content parameter. By setting the refresh time interval to zero (or a very low value), meta refresh can be used as a method of URL redirection. <meta http-equiv="refresh" content="0;url=http://www.mortgageedge.ca/Judy-Yin"/> 2. using .htaccess file. The .htaccess editor is a powerful tool with which advanced users can customize their website. When using this tool, your first step will always be to select the domain and directory where you are applying the changes. Add one of the following code snippets into your .htaccess file (based on what you want to do. Old to new domain - Update "OLDDOMAIN" to the old domain you want to redirect to and update the "NEWDOMAIN" to the new domain it is redirecting to. RewriteEngine on RewriteCond %{HTTP_HOST} ^OLDDOMAIN.com [NC,OR] RewriteCond %{HTTP_HOST} ^www.OLDDOMAIN.com [NC] RewriteRule ^(.*)$ http://NEWDOMAIN.net/$1 [L,R=301,NC] HTTPS - Redirect for SSL Certificate, update the "DOMAIN" to the domain that requires the redirect from HTTP to HTTPS Click Save. RewriteEngine On RewriteCond %{HTTP_HOST} ^DOMAIN.com [NC] RewriteCond %{SERVER_PORT} 80 RewriteRule ^(.*)$ https://www.DOMAIN.com/$1 [R=301,L] 3. using 301 redirect 301 is one of the HTTP response status code used for permanent URL redirection. This type of redirect is best for SEO purposes and also…

Notice the difference between the two checkbox. Change stylesheet "-webkit-appearance" value to checkbox would fix. Fixed:  480 total views

Installed SQL Server 2017, but New Diagram is not allowed. Resolution ref: SSMS Cannot execute as database principal (Microsoft SQL Server, Error: 15517) Result  400 total views