$sql_add `head`='$head', `priv`='$priv' "; $smarty->clearAllCache(); mysql_query($sql) or die(mysql_error()); if($id=='') $id = mysql_insert_id(); /*SLUG*/ foreach ($languages as $chave => $lingua) { $sql = "DELETE FROM `slugs` WHERE id='$username' AND lg='$lingua' AND module='blogs'"; /*delete actual slugs*/ mysql_query($sql) or die(mysql_error()); if ($username == "") $username = '******'; $slug = $slug_init = slug_gen($username); while (slug_exists2($slug,'',$lingua)) { $e++;$slug = $slug_init."-".$e; } $sql = " INSERT INTO `slugs` (`id`,`lg` ,`slug`,`module`) VALUES ('$username', '$lingua', '$slug','blogs') ON DUPLICATE KEY UPDATE `slug`='$slug';\n "; $slug = $slug_init = ''; //echo $sql; mysql_query($sql) or die(mysql_error()); } header("Location: users.php");
ON DUPLICATE KEY UPDATE `title`='$title_bd', `text`='$text_bd', `date_change` = NOW(), `seo_desc` = '$seo_desc_bd' "; mysql_query($sql) or die(mysql_error()); if($id=='') $id = mysql_insert_id(); /*SLUG*/ foreach ($languages as $chave => $lingua) { $sql = "DELETE FROM `slugs` WHERE id='$id' AND lg='$lingua' AND module='post'"; /*delete actual slugs*/ $user_slug = user_slug($user,$lingua); mysql_query($sql) or die(mysql_error()); if ($title[$lingua] == "") $title[$lingua] = 'no-name'; $slug = $slug_init = slug_gen($title[$lingua]); while (slug_exists2($user_slug,$slug,$lingua)) { $e++;$slug = $slug_init."-".$e; } $sql = " INSERT INTO `slugs` (`id`,`lg` ,`slug`,`sub_slug`,`module`) VALUES ('$id', '$lingua','$user_slug', '$slug','post') ON DUPLICATE KEY UPDATE `slug`='$user_slug', `sub_slug`='$slug' ;\n "; $slug = $slug_init = ''; //echo $sql; mysql_query($sql) or die(mysql_error()); }