resources/sql/autopatches/20151106.phame.post.mailkey.2.php

   1 <?php
   2
   3 $table = new PhamePost();
   4 $conn_w = $table->establishConnection('w');
   5 $iterator = new LiskMigrationIterator($table);
   6 foreach ($iterator as $post) {
   7   $id = $post->getID();
   8
   9   echo pht('Adding mail key for Post %d...', $id);
  10   echo "\n";
  11
  12   queryfx(
  13     $conn_w,
  14     'UPDATE %T SET mailKey = %s WHERE id = %d',
  15     $table->getTableName(),
  16     Filesystem::readRandomCharacters(20),
  17     $id);
  18 }