$ find ./sites/default/files -type f -name "*.php"
- Create sdm_temp from main sdm backup.
- List all tables with their rows:
SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'sdm_temp' order by table_rows;
- Truncate all non-core tables with huge data.
Download: https://github.com/shadowsocks/shadowsocks-windows/releases
Install latest version of shadowsocks using pip3
$ sudo apt-get install python3-pip
- Install in the way described here: https://ipfs.io/docs/install/
- Set
IPFS_PATH
variable to host files somewhere you have enough space.
$ echo 'export IPFS_PATH=/media/mohamadaliakbari/Storage/.ipfs' >> $HOME/.bashrc
- Initiate IPFS and run deamon: https://ipfs.io/docs/getting-started/
$ ipfs init
There are a few ways to accomplish posting a photo from an iPhone or iPad to a REST API but the method I’ve found to be the most useful is to create a multi-part form request for the task.
It would be nice to just send the byte stream up on its own, but typically you need to attach some other models or data to the request so that you know what context to place the image into on the server. Borrowing from good old HTML Forms, this method will allow you to submit a whole bunch of data in a variety of formats in a single shot.
As well as this works, there is something unpleasant about generating a multi-part form request for iOS. It’s a specific structure like any other data format, but it’s got some peculiarities that make it feel...hackish. Here is an example of a multi-part form request so you can see what will ultimately be generated:
POST /path/to/script.php HTTP/1.0
Host: example.com
Content-type: multipart/form-data, boundary=AaB03x
To run MariaDB SQL from /home
, in the file /usr/lib/systemd/system/mariadb.service
, just change :
ProtectHome=true
to :
ProtectHome=false
$entities = Entity::searchByQuery($query, $aggregation_criteria, NULL, 36, ($request->get('page', 1) - 1) * 36);
$aggregations = $entities->getAggregations();
$entities = new LengthAwarePaginator($entities, $entities->totalHits(), 36, LengthAwarePaginator::resolveCurrentPage(), array('path' => LengthAwarePaginator::resolveCurrentPath()));
Upgrade Bootstrap
npm uninstall --save-dev bootstrap
npm install --save-dev bootstrap@next
Upgrade Popper
npm uninstall --save-dev popper.js
npm install @popper.js/core --save-dev
Find spammer IPs (IP with more than 1 unapproved comment)
select comment_author_IP from wp_comments where comment_approved = '0' group by comment_author_IP, comment_approved having count(*) > 1;
Convert to simple ip list using text-editor and REGX
Bulk check ip locations using https://app.ipapi.co/bulk/
Convert to propper format and insert into /etc/nginx/conf.d/blacklist.conf