xlulu's blog

This hack is to add a reminder message at the heading area when members have not yet got their Email validation done.

1. includes/lib_main.php

Find the following codes:

<blockquote>$sql = 'SELECT u.user_id, u.email, u.user_name, u.user_money, u.pay_points'.

' FROM ' .$GLOBALS['ecs']->table('users'). ' AS u ' .

" WHERE u.user_id = '$id'";</blockquote>

add “u.is_validated” into the select strings.

2. themes/theme name/library/member_info.lbi

Add following code at where you want to show the message.

<!--{if $user_info.is_validated eq 0} -->
<font>You have not yet completed Email validation, please validate your Email in member center.</font>
 <!--{/if} -->

1. Close Outlook Express. RUN command “msimn /reg” from the Start Menu > Run to register msimn.
2. Open Outlook Express and to the Tools Menu. Select Options. On the General tab, look down to the Default Messaging Programs. More than likely, to top option will say that “This application is NOT the default Mail handler” Click the button next to it that says “Make Default”. This should trigger an available option in Firefox below if it was not already available.
3. In Firefox, go to the Tools menu. Select Options. Click on Applications. Under the column, “Content Type” look for the mailto function. In the column Action, select “Use Outlook Express (default)” if it is not already selected. “(default)” must be part of the phrase. Somehow there is code behind this option that will bring up a new e-mail in Outlook that otherwise does not work if Outlook is selected manually.

mysql –user=YOUR_USERNAME –password=YOUR_PASSWORD -BNe “show tables” YOUR_DBSCHEMA_NAME | tr ‘\n’ ‘,’ | sed -e ‘s/,$//’ | awk ‘{print “SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS ” $1 “;SET FOREIGN_KEY_CHECKS = 1;”}’ | mysql –user=YOUR_USERNAME –password=YOUR_PASSWORD YOUR_DBSCHEMA_NAME

Add follow code to index.php

if ($_SERVER['REMOTE_ADDR'] != '192.168.1.100')
{
 require 'down.htm';
 die();
 }

The code will redirect visitors from all IPs except for 192.168.1.100 to down.htm page.

flush cache

rm -rf var/cache/ var/session/ var/report/

Backup files from public_html/magento directory

tar -zcf filename.tar.gz

Read more…



符號表引用自頂客論壇：http://www.dk101.com/Discuz/viewthread.php?tid=116102

The following steps are how to dump the whole database of a MySql server and then restore them:

1. Dump all databases by calling:
   

   mysqldump -uroot -p –extended-insert –all-databases –add-drop-database –disable-keys –flush-privileges –quick –routines –triggers > all-databases.sql

2. Stop the MySQL server;
3. Rename or remove (in case you’ve already backed it up) the MySQL data directory;
4. Make the appropriate changes in my.cnf;
5. Re-initialize the database with the following command:
   

   mysql_install_db

6. Start the MySQL server;
7. Get into the ‘mysql‘ console and type:
   

   SET FOREIGN_KEY_CHECKS=0;
   SOURCE all-databases.sql;
   SET FOREIGN_KEY_CHECKS=1;

8. Restart the MySQL server.

MySQL: How to Force MySql Drop Tables with Foreign Key

mysql> SET foreign_key_checks = 0;
mysql> drop table …
mysql> SET foreign_key_checks = 1;