doxt3r

SET @oldsite='http://oldsite.com'; 
SET @newsite='http://newsite.com';
UPDATE wp_options SET option_value = replace(option_value, @oldsite, @newsite) WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE wp_posts SET post_content = replace(post_content, @oldsite, @newsite);
UPDATE wp_links SET link_url = replace(link_url, @oldsite, @newsite);
UPDATE wp_postmeta SET meta_value = replace(meta_value, @oldsite, @newsite);

/* only uncomment next line if you want all your current posts to post to RSS again as new */
#UPDATE wp_posts SET guid = replace(guid, @oldsite, @newsite);

doxt3r

//Césure propre
function Cesure(){
    $content = strip_tags($mon_contenu); // cleaning input string
    if (strlen($content) > 300) {
      $contentCut = substr($content,0,300);
      $content = substr($contentCut,0,strrpos($contentCut," "))." ...";
    }
    return $content;
   }

doxt3r

#!/bin/bash
#
# m4a to ogg
# faad tool needs to be installed in your machine inorder to retrive metadata infos.

for i in *.m4a; do
   tmp=$(mktemp)
   y=`echo "$i"|sed -e 's/.m4a/.ogg/'`
   faad -i "$i" 1>/dev/null 2>"$tmp"
   if [ $? -ne 0 ] ; then

doxt3r

# delete node
find . -name modules.xml | xargs xmlstarlet ed -L -d '//node'

# update attribute
find . -name modules.xml | xargs xmlstarlet ed -L -u '//node/@attr' -v 'value'

# indent with 4 spaces
for i in $(find . -name 'modules.xml'); do xmlstarlet fo -s 4 "$i" > "$i.tmp"; mv "$i.tmp" "$i"; done

doxt3r

#!/bin/bash -e
clear
echo "============================================"
echo "WordPress Install Script"
echo "============================================"
echo "Do you need to setup new MySQL database? (y/n)"
read -e setupmysql
if [ "$setupmysql" == y ] ; then
	echo "MySQL Admin User: "
	read -e mysqluser