+ XDB::execute('DELETE FROM search_name
+ WHERE pid = {?}',
+ $pid);
+ $keys = XDB::iterator("SELECT CONCAT(n.particle, n.name) AS name, e.score,
+ FIND_IN_SET('public', e.flags) AS public
+ FROM profile_name AS n
+ INNER JOIN profile_name_enum AS e ON (n.typeid = e.id)
+ WHERE n.pid = {?}",
+ $pid);
+
+ foreach ($keys as $i => $key) {
+ if ($key['name'] == '') {
+ continue;
+ }
+ $toks = preg_split('/[ \'\-]+/', $key['name']);
+ $token = '';
+ $first = 5;
+ while ($toks) {
+ $token = strtolower(replace_accent(array_pop($toks) . $token));
+ $score = ($toks ? 0 : 10 + $first) * ($key['score'] / 10);
+ XDB::execute('REPLACE INTO search_name (token, pid, soundex, score, flags)
+ VALUES ({?}, {?}, {?}, {?}, {?})',
+ $token, $pid, soundex_fr($token), $score, $key['public']);
+ $first = 0;
+ }
+ }
+ }
+
+ /** The school identifier consists of 6 digits. The first 3 represent the
+ * promotion entry year. The last 3 indicate the student's rank.
+ *
+ * Our identifier consists of 8 digits and both half have the same role.
+ * This enables us to deal with bigger promotions and with a wider range
+ * of promotions.
+ *
+ * getSchoolId returns a school identifier given one of ours.
+ * getXorgId returns a X.org identifier given a school identifier.
+ */
+ public static function getSchoolId($xorgId)
+ {
+ if (!preg_match('/^[0-9]{8}$/', $xorgId)) {
+ return null;
+ }
+
+ $year = intval(substr($xorgId, 0, 4));
+ $rank = intval(substr($xorgId, 5, 3));
+ if ($year < 1996) {
+ return null;
+ } elseif ($year < 2000) {
+ $year = intval(substr(1900 - $year, 1, 3));
+ return sprintf('%02u0%03u', $year, $rank);