How to move a multisite wordpress to a single side wordpress ?

This blog needs to be moved. He is presently hosted in an american webhost Dreamhost. This host is nice. You can have lot of web space. But sometimes workpress needs more power or the delay between Europe and USA suck.

So I decided to move it to OVH.

The limit of my OVHh host is the database. I only have one database and it is limited to 200Mega. I can put many domains so if you use many wordpress on one database prefix is needed. As I installed wordress with default prefix how to process.

Before doing the move work. I should know how to do it.

 

1. rename the tables manualy.

 

Rename table wp_commentmeta to new_commentmeta;
Rename table wp_comments to new_comments;
Rename table wp_links to wplabo_links;
Rename table wp_options to new_options;
Rename table wp_postmeta to new_postmeta;
Rename table wp_posts to new_posts;
Rename table wp_termmeta to new_termmeta;
Rename table wp_terms to new_terms;
Rename table wp_term_relationships to new_term_relationships;
Rename table wp_term_taxonomy to new_term_taxonomy;
Rename table wp_usermeta to new_usermeta;
Rename table wp_users to new_users;

2. manual change in table wp_options and wp_usermata

search in wp_option the value user_roles in the field options_name

SELECT *  FROM `kris_options` WHERE `option_name` LIKE '%user_roles%'
and change the prefix like new_user_roles
SELECT * FROM `kris_usermeta` WHERE `meta_key` LIKE ‘%wp_%’
Change all wp_ by your new prefix new_

3. copy the sources localy

By ftp copy all sources in a local directory.

4. copy the sources to the new site

5. Change the wp_config

define('DB_NAME', '...');

/** MySQL database username */
define('DB_USER', '...');

/** MySQL database password */
define('DB_PASSWORD', '...');

/** MySQL hostname */
define('DB_HOST', '...');

...

$table_prefix = 'new_';

After transfering the new wp_config by ftp. Your new site should be working on your new host.

How to add youtube video in interpals

You can add embeded youtube video in interpals message or content. I will explain you step by step how to do it.

1. Select the url of the video. just copy past the address for example http://www.youtube.com/watch?v=WObWGpe1ff8&feature=related

2. Identify the youtube code. The youtube code is in red

http://www.youtube.com/watch?v=WObWGpe1ff8&feature=related

3. here select WObWGpe1ff8

4. Then put the code

You have an option : click the youtube button

Then past the code like this

click OK and it is done

How to integrate Recaptcha in Prestashop in 3 steps

Prestashop is one of the most used ecommerce on the internet BUT the contact form has no protection again the spam. Of course you can buy an additional plugin but I will explain how to integrate a spam protection without paying. You have to create and configure an account, change 2 sources. You can make it in 30 mn or less.

Here is a howto step by step for prestashop 1.6 (I don’t know about prestashop 1.7 but I imagine it should be similar).

1 Setup your Google reCAPTCHA if you don’t have it

https://www.google.com/recaptcha/intro/index.html

Note the key and the secret key

You have to configure it and put your domain name.

2  Change the contact-form.tpl

First you have to change the contact form (client side) contact-form.tpl should be in your theme. Open an editor and search the submit botton

For me it is like that

 <div class="submit">
 <button type="submit" name="submitMessage" id="submitMessage" class="button"><span>{l s='Send'}<i class="icon-chevron-right right"></i></span></button>
 </div>
 </form>

 

Just above add few lines of code. Replace key by your key

 <script src='https://www.google.com/recaptcha/api.js'></script>
<div class="g-recaptcha" data-sitekey="key"></div>

 

That should look like that

<div>
 <script src='https://www.google.com/recaptcha/api.js'></script>
 <div class="g-recaptcha" data-sitekey="key"></div>
</div>

 <div class="submit">
 <button type="submit" name="submitMessage" id="submitMessage" class="button"><span>
{l s='Send'}
<i class="icon-chevron-right right"></i></span>
</button>
 </div>
 </form>

3 Change ContactControler.php

If you don’t have this source in override\controllers\front copy it from controllers\front

Then you have to add few lines to check if the captcha is ok or not

search the postProcess() function it should be at the begining (2nd function) and add

  if (Tools::isSubmit('submitMessage')) {
 $extension = array('.txt', '.rtf', '.doc', '.docx', '.pdf', '.zip', '.png', '.jpeg', '.gif', '.jpg');
 $file_attachment = Tools::fileAttachment('fileUpload');
 $message = Tools::getValue('message'); // Html entities is not usefull, iscleanHtml check there is no bad html tags.
 $id_order = (int)$this->getOrder();
 if (!($from = trim(Tools::getValue('from'))) || !Validate::isEmail($from)) {
 $this->errors[] = Tools::displayError('Invalid email address.');
// add the 2 lines from here
 } elseif (!($gcaptcha = (int)(Tools::getValue('g-recaptcha-response')))) {
 $this->errors[] = Tools::displayError('Captcha error');
// to here

Tutorial How to make a voice record with protools first

Pro Tools is a digital audio workstation which can be used for a wide range of sound recording and sound production purposes. Like all digital audio workstation software, Pro Tools can perform the functions of a multitrack tape recorder and audio mixer, along with additional features that can only be performed in the digital domain, such as non-destructive editing, using the Undo feature, which allows an engineer to undo any changes he or she does not like.

If you start using ProTools, you can download a free version Protools first. This version is just limited but you can use it for training. If you are completely beginer and just want to have a basic audio recording this is a tutorial for you. You have plenty of tutorial but most of them are for musicians or for advanced level. In halt an hour you will be able to create your first record.