Regular expression to ignore escaped quotes within quotes

Params:
Language: PHP

Problem:
I have string:
$text = '[[["my tree \",and to and \"\" something \'\"else","moe derevo \" , a takzhe i\" \"nechto \" drugoe",""]],,"en",,[["en"]],2]';
I need only quoted part of it:  my tree \",and to and \"\" something \'\"else


Solution:

$pattern = '/"([^"\\\\]*(?:\\\\.[^"\\\\]*)*)"/imsu'; // Use this regular expression
$match = '';
preg_match($pattern, $text, $match);
var_dump($match[1]);

And you will see: my tree \",and to and \"\" something \'\"else

Magento database add table prefix

Problem:
Store setup was without database table prefix.
Now I need to move magento database to existing db with tables from another application.

Parameters:
Magento version 1.6.0

Solution:
Create script "add_db_prefix.php" in your store public catalog. Listing:


<?php
$database_host = "localhost"; // Here database server, ip or domain name
$database_user = "<your_db_user>";
$database_password = "<your_db_user_password>";
$magento_database = "<your_db_name>";
$table_prefix = "mage_"; // Table prefix wich you want!!!

$db = mysql_connect($database_host, $database_user, $database_password);
mysql_select_db($magento_database);
$result = mysql_query("SHOW TABLES") or die('Err');
while (($row = mysql_fetch_array($result)) != false) {
    $old_table = $row[0];
    if (preg_match('/'.$table_prefix.'/', $old_table)) {
        echo "Table $old_table already done<br/>\n";
        continue;
    }

    $new_table = $table_prefix.$old_table;
    echo "Renaming $old_table to $new_table<br/>\n";
    $query = "RENAME TABLE `$old_table`  TO `$new_table`";
    mysql_query($query);
}
?>

Do not forget change db conection data in script!
Follow to the url: http://<your_store_domain_name>/add_db_prefix.php
Now all tables in db with new prefix.
And of course you need setup table prefix in your store config file.
Edit config: "app/etc/local.xml"
Find string: "<table_prefix><![CDATA[]]></table_prefix>"
Put there your new table prefix: "<table_prefix><![CDATA[mage_]]></table_prefix>"

Magento Admin Notification bugfix

Magento v.1.6
Trouble:
Every time when I am login to the admin panel see this message:"Reminder: Change Magento`s default phone numbers and callouts before site launch"
It's really damn annoying.


Sollution:
Copy the file app/code/core/Mage/AdminNotification/Model/Resource/Inbox.php
to app/code/local/Mage/AdminNotification/Model/Resource 
Create these folders if they does not exists.
And edit this php script.
Line 102. Find:
$select = $adapter->select()
                ->from($this->getMainTable())
                ->where('url=?', $item['url']);
Replace it by:$select = $adapter->select()
                ->from($this->getMainTable())
                ->where('url=? OR url IS NULL', $item['url'])
                ->where('title=?', $item['title']);
Delete all your notifications.


Thanks to Payserv http://www.magentocommerce.com/boards/viewthread/246247/

Move Magento store to another server

Actions

• Create DB backup (phpmyadmin or etc.)
• Import backup to server DB.
• Copy all magento files to the server.
• Edit config for DB connection. (app/etc/local.xml)
• Clear Magento cache folder (var/cache/)

In phpmyadmin.

1. open table core_config_data
2. Find rows where column "path" equal "web/unsecure/base_url" and "web/secure/base_url".
3. Edit these rows. Set appropriate site domain name.

Magento Connect Manager problems

Errors on page Magento Connect Manager(MCM):
1) "Warning: Your Magento folder does not have sufficient write permissions."
2) "Config file does not exists" or something like that
3) MCM tab "Settings" Deployment Type "Local Filesystem" is inactive

Solution (Your magento installation folder here /var/www/<domain_name>/public/):
Change folders permission
> chmod -v 777 /var/www/<domain_name>/public/
> chmod -v 777 /var/www/<domain_name>/public/downloader/

Gentoo installation (x86)

> passwd (new password for root)
> /etc/init.d/sshd start
> ifconfig eth0 192.168.0.4 broadcast 192.168.0.255 netmask 255.255.255.0 up
> route add default gw 192.168.0.1
> nano -w /etc/resolv.conf
            nameserver 109.86.2.2
            nameserver 109.86.2.21
> ping google.com (check net)

> ssh root@192.168.0.4 (On another host)
> fdisk /dev/hda (check file system)
> mke2fs -j /dev/hda1
> mkreiserfs /dev/hda5
> mkswap /dev/hda2
> swapon /dev/hda2
> mount /dev/hda5 /mnt/gentoo

> mkdir /mnt/gentoo/boot
> mount /dev/hda1 /mnt/gentoo/boot
> date (check current date)
> date --set "28 Aug 2011 12:03"
> cd /mnt/gentoo
> wget http://gentoo.inode.at/releases/x86/current-stage3/stage3-i686-20110809.tar.bz2

> tar xvjpf stage3-i686-20110809.tar.bz2

> wget http://gentoo.inode.at/snapshots/portage-latest.tar.bz2

> tar xvjf /mnt/gentoo/portage-latest.tar.bz2 -C /mnt/gentoo/usr

> nano -w /mnt/gentoo/etc/make.conf (Configure compilation parameters and set gentoo mirrors)

> cp -L /etc/resolv.conf /mnt/gentoo/etc/resolv.conf

> mount -t proc none /mnt/gentoo/proc

> mount -o bind /dev /mnt/gentoo/dev

> chroot /mnt/gentoo /bin/bash

> env-update

> source /etc/profile

> export PS1="(chroot) $PS1"

> emerge --sync

> ls -FGg /etc/make.profile

> ls /usr/portage/profiles/default/linux/x86/10.0/

> less /usr/portage/profiles/use.desc

> nano -w /etc/make.conf (set USE flags)

> nano -w /etc/locale.gen (set localization parameters)

           ru_UA.UTF-8 UTF-8                                                                                       

           en_US.UTF-8 UTF-8

> locale-gen

> ls /usr/share/zoneinfo/ (find your time zone)

> cp /usr/share/zoneinfo/Europe/Kiev  /etc/localtime

> USE="-doc symlink" emerge gentoo-sources

> ls -l /usr/src/linux (check kernel symlink)

> emerge pciutils -av

> cd /usr/src/linux

> make menuconfig (configure kernel)

> make && make modules_install

> cp arch/i386/boot/bzImage /boot/linux-2.6.39-gentoo-r3_1

> nano -w /etc/fstab (configure partitions)

> nano -w /etc/conf.d/hostname

> nano -w /etc/conf.d/net

> cd /etc/init.d

> ln -s net.lo net.eth1

> rc-update add net.eth1 default

> nano -w /etc/hosts

> passwd

> nano -w /etc/rc.conf

> nano -w /etc/conf.d/keymaps

> nano -w /etc/conf.d/clock

> emerge syslog-ng

> rc-update add syslog-ng default

> emerge vixie-cron

> rc-update add vixie-cron default

> emerge sys-apps/mlocate

> emerge reiserfsprogs (you must setup programms to maintenance)

> emerge dhcpcd

> emerge grub

> grub

      grub> root (hd0,0)

      grub> setup (hd0)

      grub> quit

> exit

> cd

> umount /mnt/gentoo/boot /mnt/gentoo/dev /mnt/gentoo/proc /mnt/gentoo

> reboot

Midnight Commander file association and execution

Set KDE file association in mc for all users.
Edit config file "/etc/mc/mc.ext"

For example we set association for video files:
**************************************************
### Video ###
........

include/video                                                                                                      
<------>Open=(kfmclient exec %f >/dev/null 2>&1 &)
**************************************************
Use this string for other application if need.

Examples for other ENV:
# for XFCE
Open=(exo-open %f >/dev/null 2>&1 &)
#for Gnome
Open=(gnome-open %f >/dev/null 2>&1 &)