IPB 3.x.x text replace in all posts
Jan 26
![]()
Run this queries in phpmyadmin to replace text1 to text2 read all »
Jan 26
![]()
Run this queries in phpmyadmin to replace text1 to text2 read all »
Jan 12
Secure server backup logic
1) find all buckup files *.gz
2) encode them to *.gz.out
3) remove gz file
4) upload to ftp
5) remove encoded file
Secure server backup script
1 2 3 4 5 6 7 8 9 10 11 | #!/bin/sh
BACKUPDATE=`date +%Y-%m-%d`;
find . -type f -name "*.gz" -print|while read myfile
do
openssl enc -aes-256-cbc -salt -in "$myfile" -out "$myfile".out -pass pass:PaSSwordThere;
rm "$myfile" ;
curl -v -T "$myfile".out ftp://login:"FTppassThere"@ftpserveraddres.com/${BACKUPDATE}/"$myfile" -Q "MKD ${BACKUPDATE}";
curl -v -T "$myfile".out ftp://login:"FTppassThere"@ftpserveraddres.com/${BACKUPDATE}/"$myfile" ;
rm "$myfile".out ;
echo "$myfile" "\n" ;
done |
This is my first backup script!
Also decode example
openssl enc -d -aes-256-cbc -in zzzz.gz.out -out zzzz.gz -pass pass:PaSSwordThere;
Dec 03
Will redirect all request from _ld/ folder to another website
(.htaccess!!)
1 2 | RewriteRule ^_ld/(.*)$ http://fantasy-worlds.ru/_ld/$1 [L] RewriteRule ^_nw/(.*)$ http://fantasy-worlds.ru/_nw/$1 [L] |
Nov 06
How to repair in MYSQL all tables ?
Just run in console
1 | mysqlcheck -u root -p --auto-repair --check --optimize --all-databases -p[password] |
Where password – this is admin password!
Oct 28
This simple script makes good things!
1) leave first img tag
2) remove all another img tags
3) cut text by length
So you get simple text short text with one image on it.
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 | function cut_text($x) { $alli = catch_that_image($x); if ($alli) { $x= substr($x, 0, $alli[2]+$alli[3]). substr(strip_only($x, '<img>'), $alli[2]); } if(strlen($x) > 700) { $x = substr($x, 0, 700); $y = strrpos($x, '>'); $x = substr($x, 0, $y). '>...'; } return $x; } function catch_that_image($x) { $first_img = ''; $output = preg_match_all('/<img.+src=[\'"]([^\'"]+)[\'"].*>/i', $x, $matches); @$first_img = $matches [1][0]; $imglen = strlen($matches [0][0]); if (strlen($matches [1][0]) AND $imglen){ $imgpos = stripos($x, $matches [0][0]); $tx = substr($x, 0, $imgpos).substr($x, $imgpos+$imglen); //Vsio krome<img> }else{ $tx = false; } return array($tx,$matches [0][0], $imgpos, $imglen ); } function strip_only($str, $tags) { if(!is_array($tags)) { $tags = (strpos($str, '>') !== false ? explode('>', str_replace('<', '', $tags)) : array($tags)); if(end($tags) == '') array_pop($tags); } foreach($tags as $tag) $str = preg_replace('#</?'.$tag.'[^>]*>#is', '', $str); return $str; } echo cut_text('<div class="content" style="min-height: 202px;"> <img width="200" height="200" alt="Post Pic" src="http://www.wprecipes.com/wp-content/uploads/2009/02/php2.jpg"/> <div class="pic fl"> <img width="200" height="200" alt="Post Pic" src="http://www.wprecipes.com/wp-content/uploads/2009/02/php2.jpg"/> </div> <div class="post-title"> </div> <img width="200" height="200" alt="Post Pic" src="http://www.wprecipes.com/wp-content/uploads/2009/02/php2.jpg"/> <div class="post-excerpt">'); |
Oct 27
To block backups for admin in IPB,
You need to open FTP read all »
Sep 25
Run this code from phpmyadmin
1 2 3 | SELECT * FROM `wp_comments` WHERE `comment_approved` LIKE 'spam' |
Sep 24
Results of compiling this scripts was recommendations how to change mysql params.
note. For best result please run MYSQL before testing – 48 hours!
1 2 3 | wget http://mysqltuner.com/mysqltuner.pl chmod +x mysqltuner.pl ./mysqltuner.pl |
OR (also) try this script
1 2 | wget http://www.day32.com/MySQL/tuning-primer.sh sh tuning-primer.sh |
Sep 21
So how to allow ftp clients to list .htaccess in proftpd?
We need to open
/etc/proftpd/proftpd.conf
1 | ListOptions <--->"-l" |
to
1 | ListOptions <--->"-a" |
and then restart proftpd!