function ass_idLookup($link, $list, $names) { // f**k you, ccp. $len = count($list); // get the ids... $names = fuck_ccp($list, $names); $sql = ""; foreach ($list as $id) { $sql .= "(" . $id . ",'" . addslashes($names[$id]) . "'),"; } mysql_query("INSERT INTO " . DB_PREFIX . ID_CACHE_TABLE . " (id, name) VALUES " . rtrim($sql, ","), $link); return $names; }
function char_idLookup($Db, $list, $names) { $len = count($list); // get the ids... $names = fuck_ccp($list, $names); $sql = ""; $insertStatement = $Db->prepare()->insert(ID_CACHE_TABLE, ['id' => "?", "name" => "?"]); foreach ($list as $id) { $insertStatement->execute(['id' => $id, 'name' => $names[$id]]); } return $names; }