}
//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'));
}
?>
