Advertisement
Guest User

Untitled

a guest
Sep 17th, 2017
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.92 KB | None | 0 0
  1. # Запись в таблицу avto
  2. $db_q=" SET date=NOW(), marka='{$to_db[$n]['marka']}',
  3. model='{$to_db[$n]['model']}', price='{$to_db[$n]['price']}',
  4. currency='1', dvig_type='{$to_db[$n]['dvig_type']}',
  5. ob_dvig='{$to_db[$n]['ob_dvig']}', vis='0',
  6. mosch_dvig='{$to_db[$n]['mosch_dvig']}',
  7. transmission='{$to_db[$n]['transmission']}',
  8. privod='{$to_db[$n]['privod']}',
  9. tip_kuz='{$to_db[$n]['tip_kuz']}', probeg='{$to_db[$n]['probeg']}', class='{$to_db[$n]['class']}', steer='{$to_db[$n]['steer']}', city='{$to_db[$n]['city']}', saler='{$to_db[$n]['saler']}', phone='{$to_db[$n]['phone']}',
  10. period='{$to_db[$n]['period']}',
  11. comments='{$to_db[$n]['comments']}',
  12. photo='nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;nofoto.jpg;', status='{$to_db[$n]['status']}', color='{$to_db[$n]['color']}', optcolor='0', salon='{$to_db[$n]['salon']}', year='{$to_db[$n]['year']}', istorg='{$to_db[$n]['istorg']}', password='', email='{$to_db[$n]['email']}', state='{$to_db[$n]['state']}', pruser='{$to_db[$n]['pruser']}', view='{$to_db[$n]['veiw']}', canlong='{$to_db[$n]['canlong']}' ";
  13. if(db_nr(db_q("SELECT salonxmltires.id FROM salonxmltires INNER JOIN avto ON (salonxmltires.aid=avto.id) WHERE salonxmltires.uid='{$to_db[$n]['pruser']}' and salonxmltires.sid='{$to_db[$n]['sid']}'"))>0){
  14. $cur=db_fa(db_q("SELECT aid FROM salonxmltires WHERE uid='{$to_db[$n]['pruser']}' and sid='{$to_db[$n]['sid']}'"));
  15. $anum=db_fa(db_q("SELECT number FROM avto WHERE id='{$cur['aid']}'"));
  16. $to_db[$n]['number']=$anum['number'];
  17. db_q("UPDATE avto ".$db_q." WHERE id='{$cur['aid']}'");
  18. }else{
  19. db_q("INSERT INTO avto ".$db_q." , number='{$to_db[$n]['number']}' ");
  20. $cur['aid']=mysql_insert_id();
  21. db_q("DELETE FROM salonxmltires WHERE uid='{$to_db[$n]['pruser']}' and sid='{$to_db[$n]['sid']}'");
  22. db_q("INSERT INTO salonxmltires SET uid='{$to_db[$n]['pruser']}', aid='{$cur['aid']}', sid='{$to_db[$n]['sid']}'");
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement