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