5210fc3733d43e0887b16c06dc1f2d6595df86ad
3 require_once 'connect.db.inc.php';
5 $globals->debug
= 0; //do not store backtraces
7 $terms = XDB
::iterator('SELECT `jtid`, `name` FROM `profile_job_term_enum`');
8 while ($term = $terms->next()) {
9 $tokens = array_unique(JobTerms
::tokenize($term['name']));
10 if (!count($tokens)) {
14 foreach ($tokens as $t) {
15 $values[] = '('.XDB
::escape($t).','.XDB
::escape($term['jtid']).')';
17 XDB
::execute('INSERT IGNORE INTO `profile_job_term_search` (`search`,`jtid`) VALUES '.implode(',',$values));
20 /* vim:set et sw=4 sts=4 ts=4: */