Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Мульти апдейт
- $updSQL_query = array();
- $updend_SQL = array();
- $updSQL = "UPDATE $allskins SET csmoney = CASE ";
- foreach ( $upd_items as $item){
- $updSQL_query[] = "WHEN skinname = '". $item['skinName'] ."' THEN '". $item['skinCost'] ."'";
- $updend_SQL[]="'".$item['skinName']."'";
- }
- $updSQL .= implode(' ',$updSQL_query)." END WHERE skinname in (" . implode(',',$updend_SQL) . ")";
- R::exec($updSQL);
- // Мульти инсерт.
- $insSQL_query = array();
- $insSQL = "INSERT INTO $allskins ( skinname,csmoney,csmupd ) VALUES";
- foreach ($insert_items as $item){
- $insSQL_query[] = "('".$item['skinName']."', '" . $item['skinCost'] . "', '$date')";
- }
- $insSQL .= implode(',',$insSQL_query);
- R::exec($insSQL);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement