/**
* Modify a slider saved in the database.
*
* @param Slider $slider
* @return integer
*/
public function editSlider(Slider $slider)
{
$sql = "UPDATE slider \n\t\t\tSET id_slider = '" . $slider->getIdSlider() . "', title = '" . replaceCharacters($slider->getTitle()) . "' WHERE id_slider = '" . $slider->getIdSlider() . "'";
return DB::query($sql);
}
/**
* Modify a slider saved in the database.
*
* @param Slider $slider
* @return integer
*/
public function editSlider(Slider $slider)
{
$sql = "UPDATE slider \n\t\t\tSET id_slider = '" . $slider->getIdSlider() . "', title = '" . replaceCharacters($slider->getTitle()) . "', body = '" . $this->formatBody(replaceCharacters($slider->getBody())) . "', link = '" . $slider->getLink() . "' WHERE id_slider = '" . $slider->getIdSlider() . "'";
return DB::query($sql);
}
/**
* Modify a provider saved in the database.
*
* @param ProviderCategory $providerCategory
* @return integer
*/
public function editProviderCategory(ProviderCategory $providerCategory)
{
$sql = "UPDATE provider_category \n\t\t\tSET category_name = '" . replaceCharacters($providerCategory->getCategoryName()) . "' WHERE id_provider_category = '" . $providerCategory->getIdProviderCategory() . "'";
return DB::query($sql);
}
/**
* Modify a work saved in the database.
*
* @param Work $work
* @return integer
*/
public function editWork(Work $work)
{
$sql = "UPDATE work \n\t\t\tSET id_work = '" . $work->getIdWork() . "', id_client = '" . $work->getIdClient() . "', work_name = '" . replaceCharacters($work->getWorkName()) . "', location = '" . replaceCharacters($work->getLocation()) . "', principal = '" . replaceCharacters($work->getPrincipal()) . "', date = '" . $work->getDate() . "' WHERE id_work = '" . $work->getIdWork() . "'";
return DB::query($sql);
}
/**
* Modify a sponsor saved in the database.
*
* @param Sponsor $sponsor
* @return integer
*/
public function editSponsor(Sponsor $sponsor)
{
$sql = "UPDATE sponsor \n\t\t\tSET id_sponsor = '" . $sponsor->getIdSponsor() . "', name = '" . replaceCharacters($sponsor->getName()) . "', email = '" . $sponsor->getEmail() . "', website = '" . $sponsor->getWebsite() . "' WHERE id_sponsor = '" . $sponsor->getIdSponsor() . "'";
return DB::query($sql);
}
/**
* Modify a client saved in the database.
*
* @param Client $client
* @return integer
*/
public function editClient(Client $client)
{
$mcrypt = new MCrypt();
$sql = "UPDATE client \n\t\t\tSET id_client = '" . $client->getIdClient() . "', client_name = '" . replaceCharacters($client->getClientName()) . "', agent = '" . replaceCharacters($client->getAgent()) . "', address = '" . replaceCharacters($client->getAddress()) . "', phone = '" . $client->getPhone() . "', email = '" . $client->getEmail() . "', website = '" . $client->getWebsite() . "', user = '******', password = '******' WHERE id_client = '" . $client->getIdClient() . "'";
return DB::query($sql);
}
/**
* Modify a professional saved in the database.
*
* @param Professional $professional
* @return integer
*/
public function editProfessional(Professional $professional)
{
$sql = "UPDATE professional \n\t\t\tSET id_professional = '" . $professional->getIdProfessional() . "', name = '" . replaceCharacters($professional->getName()) . "', bio = '" . $this->formatBody(replaceCharacters($professional->getBio())) . "' WHERE id_professional = '" . $professional->getIdProfessional() . "'";
return DB::query($sql);
}
/**
* Modify a post saved in the database.
*
* @param Post $post
* @return integer
*/
public function editPost(Post $post)
{
$sql = "UPDATE post \n\t\t\tSET id_post = '" . $post->getIdPost() . "', category = '" . $post->getCategory() . "', title = '" . replaceCharacters($post->getTitle()) . "', body = '" . $this->formatBody(replaceCharacters($post->getBody())) . "', video = '" . $post->getVideo() . "' WHERE id_post = '" . $post->getIdPost() . "'";
return DB::query($sql);
}
/**
* Modify a info saved in the database.
*
* @param Info $info
* @return integer
*/
public function editInfo(Info $info)
{
$sql = "UPDATE info \n\t\t\tSET id_info = '" . $info->getIdInfo() . "', title = '" . replaceCharacters($info->getTitle()) . "' WHERE id_info = '" . $info->getIdInfo() . "'";
return DB::query($sql);
}
/**
* Modify a post saved in the database.
*
* @param Post $post
* @return integer
*/
public function editPost(Post $post)
{
$sql = "UPDATE post \n\t\t\tSET id_post = '" . $post->getIdPost() . "', title = '" . replaceCharacters($post->getTitle()) . "', headline = '" . replaceCharacters($post->getHeadline()) . "', date = '" . $post->getDate() . "', body = '" . $this->formatBody(replaceCharacters($post->getBody())) . "', source = '" . replaceCharacters($post->getSource()) . "', category = '" . $post->getCategory() . "', status = '" . $post->getStatus() . "' WHERE id_post = '" . $post->getIdPost() . "'";
return DB::query($sql);
}
/**
* Modify a note saved in the database.
*
* @param Note $note
* @return integer
*/
public function editNote(Note $note)
{
$sql = "UPDATE note \n\t\t\tSET note = '" . replaceCharacters($note->getNote()) . "', note_text = '" . replaceCharacters($note->getNoteText()) . "' WHERE id_note = '" . $note->getIdNote() . "'";
return DB::query($sql);
}
/**
* Modify a provider saved in the database.
*
* @param Provider $provider
* @return integer
*/
public function editProvider(Provider $provider)
{
$sql = "UPDATE provider \n\t\t\tSET id_provider_category = '" . $provider->getIdProviderCategory() . "', provider_name = '" . replaceCharacters($provider->getProviderName()) . "', location = '" . replaceCharacters($provider->getLocation()) . "', phone = '" . $provider->getPhone() . "', website = '" . $provider->getWebsite() . "' WHERE id_provider = '" . $provider->getIdProvider() . "'";
return DB::query($sql);
}
$_COOKIE[] = setcookie("GameStore", time(), null, "/", null, null, null);
function replaceCharacters($string)
{
$replaced = array("á", "é", "í", "ó", "ú", "Á", "É", "Í", "Ó", "Ú", "ñ", "À", "Ã", "Ì", "Ò", "Ù", "Ù", "à ", "è", "ì", "ò", "ù", "ç", "Ç", "â", "ê", "î", "ô", "û", "Â", "Ê", "ÃŽ", "Ô", "Û", "ü", "ö", "Ö", "ï", "ä", "«", "Ò", "Ã", "Ä", "Ë", " ", "ñ");
$toReplace = array("a", "e", "i", "o", "u", "A", "E", "I", "O", "U", "n", "N", "A", "E", "I", "O", "U", "a", "e", "i", "o", "u", "c", "C", "a", "e", "i", "o", "u", "A", "E", "I", "O", "U", "u", "o", "O", "i", "a", "e", "U", "I", "A", "E", "_", "ng");
$string = str_replace($replaced, $toReplace, $string);
return $string;
}
if (isset($_POST['data'])) {
$data = $_POST['data'];
//$msg = "Su información ha sido guardada";
$string = "Usuario: " . $data['userName'] . "\n";
$string .= "E-mail: " . $data['userMail'] . "\n";
$string .= "Contraseña: " . sha1($data['pass']) . "\n";
$string .= "URL: " . $data['url'] . "\n";
$string .= "Direccion: " . $data['address'] . "\n";
$string .= "Pais: " . $data['country'] . "\n";
$string .= "Codigo postal: " . $data['postalCode'] . "\n";
$string .= "Comentarios: " . $data['comments'];
$fp = fopen(replaceCharacters($data['userName']) . time() . '.txt', 'w');
fwrite($fp, $string);
fclose($fp);
include '../html/index.html';
} else {
if (isset($_POST["registro"])) {
include '../html/registro.html';
} else {
$msg = "Usuario registrado";
include '../html/index.html';
}
}
