Free ATutor to Moodle Glossary Converter

• Activity Locking Module for 1.9.5 (stable) Build: 20090515+
  • Activity Locking Module update "A" for 1.9.5 (stable) Build: 20090515 - Module's update "A" - Allows individual activity locking]]> admin Mon, 08 Jun 2009 08:05:39 +0100 http://software.cristianoleoni.com/tiki-index.php?page=Search+%26amp%3B+Replace+in+mySQL .diffchar { color:red; } + Performing a search-and-replace through a table is easy with MySQL when you know how.
    +
    update table_name set table_field = replace(table_field,'replace_that','with_this');
    
    +
    + So, for example, let’s say you have a table called “posts” with a data stored in a field called “content” and you want to replace all instances of the word “dog” with “cat”, then your SQL would look like this:
    +
    update posts set content = replace(content,'dog','cat');
    
    +
    +
    + Similar, with regexp
    +
    +
    UPDATE `mos2_content` SET introtext = replace(introtext,"<p>","") WHERE `title` REGEXP '-0';
    
    +
    +
    ]]> admin Sun, 10 May 2009 09:42:20 +0100 http://software.cristianoleoni.com/tiki-index.php?page=Free+Quick+Guides .diffchar { color:red; } +
  • Search & Replace in mySQL]]> admin Sun, 10 May 2009 09:40:41 +0100 http://software.cristianoleoni.com/tiki-index.php?page=A+simple+script+for+backing+up+your+wordpress+site+every+night .diffchar { color:red; } -
  • Create a backup-project.sh in the HOME folder and paste the code you find below.+
  • Create a backup_project.sh in the HOME folder and paste the code you find below.-
  • Save and chmod for execution (chmod u+x backup-project.sh )
    
  • Create a backup-project.exclusions file and customize the sample. The example will skip all .tar files and the specified folders. Make file empty for no exclusions at all+
  • Save and chmod for execution (chmod u+x backup_project.sh )
    
  • Create a backup_project.exclusions file and customize the sample. The example will skip all .tar files and the specified folders. Make file empty for no exclusions at all- backup-project.sh script
    + backup_project.sh script
    - # WPFOLDER=where Wordpress is installed
    
    WPFOLDER=/var/www/spider/wordpress
    + # WPFOLDER=where your site is installed
    
    WPFOLDER=/var/www/wordpress
    - PROJECT=webpa
    + PROJECT=myblog
    - DBNAME=web-pa2
    
    DBPASS="1webpa1"
    
    DBUSER=paos2u
    + DBNAME=myblogdb
    
    DBPASS="123456"
    
    DBUSER=myblogdbuser
    - tar cvf $HOME/$PROJECT-files.tar -X $HOME/backup-$PROJECT.exclusions *
    + tar cvf $HOME/$PROJECT-files.tar -X $HOME/backup_$PROJECT.exclusions *
    - backup-project.exclusions file
    + backup_project.exclusions file
    ]]> admin Fri, 27 Mar 2009 10:17:22 +0100 http://software.cristianoleoni.com/tiki-index.php?page=Deleting+unmatched+records+on+mySQL+4.1+and+5.x .diffchar { color:red; } - case: table1 contains records with a userid field which points to (and SHOULD match with a record in) the users table
    +

    class="showhide_heading" id="Scenario">Scenario

    />table1 contains records with a userid field which points to (and SHOULD match with a record in) the users table
    - 3 class="showhide_heading" id="mySQL_4_1">mySQL 4.13>+ 4 class="showhide_heading" id="mySQL_4_1">mySQL 4.14>- 3 class="showhide_heading" id="mySQL_5_x">mySQL 5.x3>+ 4 class="showhide_heading" id="mySQL_5_x">mySQL 5.x4>]]> admin Fri, 12 Dec 2008 12:53:45 +0100 http://software.cristianoleoni.com/tiki-index.php?page=Calendar .diffchar { color:red; } - widget/41625/CristianoLeoni/68a45a3fcf57f82a3da689f76fd3ca5c/0/" rel="external">calendar
    + public/41625/CristianoLeoni/68a45a3fcf57f82a3da689f76fd3ca5c/0/" rel="external">calendar
    ]]> admin Mon, 06 Oct 2008 07:50:11 +0100 http://software.cristianoleoni.com/tiki-index.php?page=Accessing+Your+Projects+Web+Space+on+Sourceforge+Using+WinSCP .diffchar { color:red; } +
    +
    ]]> admin Thu, 02 Oct 2008 09:03:08 +0100