public static function insert($inputData = array()) { // End addons // $totalArgs=count($inputData); $addMultiAgrs = ''; if (isset($inputData[0]['userid'])) { foreach ($inputData as $theRow) { $keyNames = array_keys($theRow); $insertKeys = implode(',', $keyNames); $keyValues = array_values($theRow); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs .= "({$insertValues}), "; } $addMultiAgrs = substr($addMultiAgrs, 0, strlen($addMultiAgrs) - 2); } else { $keyNames = array_keys($inputData); $insertKeys = implode(',', $keyNames); $keyValues = array_values($inputData); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs = "({$insertValues})"; } Database::query("insert into " . Database::getPrefix() . "address({$insertKeys}) values" . $addMultiAgrs); DBCache::removeDir('system/address'); if (!($error = Database::hasError())) { $id = Database::insert_id(); return $id; } return false; }
public static function insert($inputData = array()) { // End addons // $totalArgs=count($inputData); $addMultiAgrs = ''; if (isset($inputData[0]['postid'])) { foreach ($inputData as $theRow) { $theRow['date_added'] = date('Y-m-d H:i:s'); if (isset($theRow['fullname'])) { $theRow['fullname'] = String::encode(strip_tags($theRow['fullname'])); } if (isset($theRow['content'])) { // $theRow['content']=Shortcode::toBBCode($theRow['content']); $theRow['content'] = String::encode($theRow['content']); } $keyNames = array_keys($theRow); $insertKeys = implode(',', $keyNames); $keyValues = array_values($theRow); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs .= "({$insertValues}), "; } $addMultiAgrs = substr($addMultiAgrs, 0, strlen($addMultiAgrs) - 2); } else { $inputData['date_added'] = date('Y-m-d H:i:s'); if (isset($inputData['fullname'])) { $inputData['fullname'] = String::encode(strip_tags($inputData['fullname'])); } if (isset($inputData['content'])) { // $inputData['content']=Shortcode::toBBCode($inputData['content']); $inputData['content'] = String::encode($inputData['content']); } $keyNames = array_keys($inputData); $insertKeys = implode(',', $keyNames); $keyValues = array_values($inputData); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs = "({$insertValues})"; } Database::query("insert into " . Database::getPrefix() . "comments({$insertKeys}) values" . $addMultiAgrs); DBCache::removeDir('system/comment'); if (!($error = Database::hasError())) { $id = Database::insert_id(); return $id; } return false; }
public static function insert($inputData = array()) { // End addons // $totalArgs=count($inputData); $addMultiAgrs = ''; if (isset($inputData[0]['content'])) { foreach ($inputData as $theRow) { $theRow['date_added'] = date('Y-m-d H:i:s'); if (isset($theRow['title'])) { $theRow['title'] = String::encode($theRow['title']); } if (isset($theRow['url'])) { if (!preg_match('/^\\/.*?/i', $theRow['url'])) { $theRow['url'] = '/' . $theRow['url']; } $theRow['url'] = String::encode($theRow['url']); } $keyNames = array_keys($theRow); $insertKeys = implode(',', $keyNames); $keyValues = array_values($theRow); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs .= "({$insertValues}), "; } $addMultiAgrs = substr($addMultiAgrs, 0, strlen($addMultiAgrs) - 2); } else { $inputData['date_added'] = date('Y-m-d H:i:s'); if (isset($inputData['title'])) { $inputData['title'] = String::encode($inputData['title']); } if (isset($inputData['url'])) { if (!preg_match('/^\\/.*?/i', $inputData['url'])) { $inputData['url'] = '/' . $inputData['url']; } $inputData['url'] = String::encode($inputData['url']); } $keyNames = array_keys($inputData); $insertKeys = implode(',', $keyNames); $keyValues = array_values($inputData); $insertValues = "'" . implode("','", $keyValues) . "'"; $addMultiAgrs = "({$insertValues})"; } Database::query("insert into " . Database::getPrefix() . "links({$insertKeys}) values" . $addMultiAgrs); DBCache::removeDir('system/link'); if (!($error = Database::hasError())) { $id = Database::insert_id(); return $id; } return false; }