Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static bool inserePagina(string titulo, string seo_title, string seo_description, string texto, string slug, int idPaginaPai, int ultimoId)
- {
- bool retorno = false;
- StringBuilder qp = new StringBuilder();
- qp.Append(" INSERT INTO wp_posts ( ");
- qp.Append(" ID, ");
- qp.Append(" post_author, ");
- qp.Append(" post_date, ");
- qp.Append(" post_date_gmt, ");
- qp.Append(" post_content, ");
- qp.Append(" post_title, ");
- qp.Append(" post_status, ");
- qp.Append(" comment_status, ");
- qp.Append(" ping_status, ");
- qp.Append(" post_name, ");
- qp.Append(" post_modified, ");
- qp.Append(" post_modified_gmt, ");
- qp.Append(" post_parent, ");
- qp.Append(" guid, ");
- qp.Append(" menu_order, ");
- qp.Append(" post_type, ");
- qp.Append(" comment_count ");
- qp.Append(" ) VALUES ( ");
- qp.AppendFormat(" {0}, ", ultimoId + 1);
- qp.Append(" 1, ");
- qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
- qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
- qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(texto));
- qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(titulo));
- qp.Append(" 'publish', ");
- qp.Append(" 'closed', ");
- qp.Append(" 'closed', ");
- qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(slug));
- qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
- qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
- qp.AppendFormat(" {0}, ", idPaginaPai);
- qp.AppendFormat(" 'https://opiniaobomvaleapena.com.br/?p={0}', ", ultimoId + 1);
- qp.Append(" 0, ");
- qp.Append(" 'page', ");
- qp.Append(" 0 ");
- qp.Append(" ); ");
- /*
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- HttpContext.Current.Response.Write(qp.ToString());
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- */
- //Grava
- int insercao = Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- if (insercao > 0)
- {
- qp.Clear();
- //Título
- qp.Append(" INSERT INTO wp_postmeta ( ");
- qp.Append(" post_id, ");
- qp.Append(" meta_key, ");
- qp.Append(" meta_value ");
- qp.Append(" ) VALUES ( ");
- qp.AppendFormat(" {0}, ", ultimoId + 1);
- qp.Append(" '_yoast_wpseo_title', ");
- qp.AppendFormat(" '{0}' ", Extrator.Util.aspasSQL(seo_title));
- qp.Append(" ); ");
- Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- //Meta
- qp.Append(" INSERT INTO wp_postmeta ( ");
- qp.Append(" post_id, ");
- qp.Append(" meta_key, ");
- qp.Append(" meta_value ");
- qp.Append(" ) VALUES ( ");
- qp.AppendFormat(" {0}, ", ultimoId + 1);
- qp.Append(" '_yoast_wpseo_metadesc', ");
- qp.AppendFormat(" '{0}' ", Extrator.Util.aspasSQL(seo_description));
- qp.Append(" ); ");
- Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- retorno = true;
- }
- return retorno;
- }
- private static void atualizaPagina(string titulo, string seo_title, string seo_description, string texto, string slug, string idPagina, int idPaginaPai, bool exportaMetaDados)
- {
- StringBuilder qp = new StringBuilder();
- qp.Append(" UPDATE wp_posts SET ");
- qp.AppendFormat(" post_title = '{0}', ", Extrator.Util.aspasSQL(titulo));
- qp.AppendFormat(" post_content = '{0}', ", Extrator.Util.aspasSQL(texto));
- qp.AppendFormat(" post_name = '{0}', ", Extrator.Util.aspasSQL(slug));
- qp.AppendFormat(" post_modified = '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
- qp.AppendFormat(" post_parent = '{0}' ", idPaginaPai);
- qp.AppendFormat(" WHERE ID = {0} ", idPagina);
- //Grava
- Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- /*
- HttpContext.Current.Response.Write(qp.ToString());
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- */
- qp.Clear();
- if (exportaMetaDados)
- {
- //Título
- qp.AppendFormat(" UPDATE wp_postmeta SET meta_value = '{0}' WHERE meta_key = '_yoast_wpseo_title' AND post_id = {1};", Extrator.Util.aspasSQL(seo_title), idPagina);
- Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- /*
- HttpContext.Current.Response.Write(qp.ToString());
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- */
- //Meta
- qp.AppendFormat(" UPDATE wp_postmeta SET meta_value = '{0}' WHERE meta_key = '_yoast_wpseo_metadesc' AND post_id = {1};", Extrator.Util.aspasSQL(seo_description), idPagina);
- Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
- /*
- HttpContext.Current.Response.Write(qp.ToString());
- HttpContext.Current.Response.Write(System.Environment.NewLine);
- */
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement