Esempio n. 1
0
 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;
 }
Esempio n. 2
0
 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;
 }
Esempio n. 3
0
 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;
 }