$mid = $db->loadResult(); } //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')); } ?>