} //obtin data curenta $query = "SELECT `id` FROM #__sa_accesorii WHERE `accesorii` = '" . $acc . "'"; $db->setQuery($query); $acc_id = $db->loadResult(); $curentDate = date('Y-m-d H:i:s', $time); $expiryDate = date('Y-m-d H:i:s', $time + 2592000); //echo '<br />caroserie>>>>'.$caroserie.'<br />'; //adaug in baza de date $query = "INSERT INTO #__sa_anunturi \n\t(`titlu_anunt`, `anunt`, `tip_anunt`, `accesorii_auto`, `subaccesorii_auto`, `proprietar`, \n\t`data_adaugarii`, `status_anunt`, `raportat`, `marca_auto`, `model_auto`) \n\tVALUES \n\t('" . $titlu_anunt . "', '" . $anunt . "', '7', '" . $acc_id . "', '" . $subacc . "', '" . $uid . "', '" . $curentDate . "', '1', '0', '" . $mid . "', '" . $model_auto . "')"; $db->setQuery($query); $db->query(); $anunt_id = $db->insertid(); ###########################prelucrare imagine############# SautoViewAdding::uploadImg($time, $uid, $anunt_id); SautoViewAdding::sendMail($anunt_id); ###########################end prelucrare imagine################## //echo $query; $app->setUserState('titlu_anunt', ''); $app->setUserState('accesorii', ''); $app->setUserState('marca', ''); $app->setUserState('model_auto', ''); $app->setUserState('subaccesorii', ''); $app->setUserState('anunt7', ''); $app->setUserState('request', ''); $app->setUserState('anunt', ''); $link_redirect = JRoute::_('index.php?option=com_sauto'); $app->redirect($link_redirect, JText::_('SAUTO_SUCCESS_ADDED')); } ?>
} } } //sfarsit verificare if ($register_anunt == 1) { //obtin data curenta $curentDate = date('Y-m-d H:i:s', $time); $expiryDate = date('Y-m-d H:i:s', $time + 2592000); //echo '<br />caroserie>>>>'.$caroserie.'<br />'; //adaug in baza de date $query = "INSERT INTO #__sa_anunturi \n\t(`titlu_anunt`, `anunt`, `tip_anunt`, `marca_auto`, `model_auto`, `an_fabricatie`, `cilindree`, `carburant`, `caroserie`, `serie_caroserie`, `proprietar`, `data_adaugarii`, `status_anunt`, `raportat`, `pret`, `data_expirarii`) \n\tVALUES \n\t('" . $titlu_anunt . "', '" . $anunt . "', '6', '" . $marca_auto_id . "', '" . $model_auto_id . "', '" . $an_fabricatie . "', '" . $cilindree . "', '" . $carburant . "', '" . $caroserie . "', '" . $serie_caroserie . "', '" . $uid . "', '" . $curentDate . "', '1', '0', '" . $price . "', '" . $expiryDate . "')"; $db->setQuery($query); $db->query(); $anunt_id = $db->insertid(); ###########################prelucrare imagine############# SautoViewAdding::uploadImg($time, $uid, $anunt_id); ###########################end prelucrare imagine################## $app->setUserState('titlu_anunt', ''); $app->setUserState('an_fabricatie', ''); $app->setUserState('cilindree', ''); $app->setUserState('carburant', ''); $app->setUserState('marca', ''); $app->setUserState('caroserie', ''); $app->setUserState('serie_caroserie', ''); $app->setUserState('anunt6', ''); $app->setUserState('model_auto', ''); $app->setUserState('titlu_anunt', ''); $app->setUserState('request', ''); $link_redirect_fr = JRoute::_('index.php?option=com_sauto'); $app->redirect($link_redirect_fr, JText::_('SAUTO_SUCCESS_ADDED')); } ?>