upgrade/1.0.1/tokenize_job_terms.php

   1 #!/usr/bin/php5
   2 <?php
   3 require_once 'connect.db.inc.php';
   4 require_once 'profil.func.inc.php';
   5
   6 $globals->debug = 0; //do not store backtraces
   7
   8 $terms = XDB::iterator('SELECT `jtid`, `name` FROM `profile_job_term_enum`');
   9 while ($term = $terms->next()) {
  10     $tokens = array_unique(tokenize_job_term($term['name']));
  11     if (!count($tokens)) {
  12         continue;
  13     }
  14     $values = array();
  15     foreach ($tokens as $t) {
  16         $values[] = '('.XDB::escape($t).','.XDB::escape($term['jtid']).')';
  17     }
  18     XDB::execute('INSERT IGNORE INTO `profile_job_term_search` (`search`,`jtid`) VALUES '.implode(',',$values));
  19 }
  20
  21 /* vim:set et sw=4 sts=4 ts=4: */
  22 ?>