Beispiel #1
0
		`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");
Beispiel #2
0
		`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());
	}