Advertisement
Guest User

Untitled

a guest
Sep 16th, 2019
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.46 KB | None | 0 0
  1. private static bool inserePagina(string titulo, string seo_title, string seo_description, string texto, string slug, int idPaginaPai, int ultimoId)
  2. {
  3. bool retorno = false;
  4.  
  5. StringBuilder qp = new StringBuilder();
  6. qp.Append(" INSERT INTO wp_posts ( ");
  7. qp.Append(" ID, ");
  8. qp.Append(" post_author, ");
  9. qp.Append(" post_date, ");
  10. qp.Append(" post_date_gmt, ");
  11. qp.Append(" post_content, ");
  12. qp.Append(" post_title, ");
  13. qp.Append(" post_status, ");
  14. qp.Append(" comment_status, ");
  15. qp.Append(" ping_status, ");
  16. qp.Append(" post_name, ");
  17. qp.Append(" post_modified, ");
  18. qp.Append(" post_modified_gmt, ");
  19. qp.Append(" post_parent, ");
  20. qp.Append(" guid, ");
  21. qp.Append(" menu_order, ");
  22. qp.Append(" post_type, ");
  23. qp.Append(" comment_count ");
  24. qp.Append(" ) VALUES ( ");
  25. qp.AppendFormat(" {0}, ", ultimoId + 1);
  26. qp.Append(" 1, ");
  27. qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
  28. qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
  29. qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(texto));
  30. qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(titulo));
  31. qp.Append(" 'publish', ");
  32. qp.Append(" 'closed', ");
  33. qp.Append(" 'closed', ");
  34. qp.AppendFormat(" '{0}', ", Extrator.Util.aspasSQL(slug));
  35. qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
  36. qp.AppendFormat(" '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
  37. qp.AppendFormat(" {0}, ", idPaginaPai);
  38. qp.AppendFormat(" 'https://opiniaobomvaleapena.com.br/?p={0}', ", ultimoId + 1);
  39. qp.Append(" 0, ");
  40. qp.Append(" 'page', ");
  41. qp.Append(" 0 ");
  42. qp.Append(" ); ");
  43.  
  44. /*
  45. HttpContext.Current.Response.Write(System.Environment.NewLine);
  46. HttpContext.Current.Response.Write(System.Environment.NewLine);
  47. HttpContext.Current.Response.Write(qp.ToString());
  48. HttpContext.Current.Response.Write(System.Environment.NewLine);
  49. HttpContext.Current.Response.Write(System.Environment.NewLine);
  50. */
  51.  
  52. //Grava
  53. int insercao = Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  54.  
  55. if (insercao > 0)
  56. {
  57.  
  58. qp.Clear();
  59.  
  60. //Título
  61. qp.Append(" INSERT INTO wp_postmeta ( ");
  62. qp.Append(" post_id, ");
  63. qp.Append(" meta_key, ");
  64. qp.Append(" meta_value ");
  65. qp.Append(" ) VALUES ( ");
  66. qp.AppendFormat(" {0}, ", ultimoId + 1);
  67. qp.Append(" '_yoast_wpseo_title', ");
  68. qp.AppendFormat(" '{0}' ", Extrator.Util.aspasSQL(seo_title));
  69. qp.Append(" ); ");
  70. Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  71.  
  72. //Meta
  73. qp.Append(" INSERT INTO wp_postmeta ( ");
  74. qp.Append(" post_id, ");
  75. qp.Append(" meta_key, ");
  76. qp.Append(" meta_value ");
  77. qp.Append(" ) VALUES ( ");
  78. qp.AppendFormat(" {0}, ", ultimoId + 1);
  79. qp.Append(" '_yoast_wpseo_metadesc', ");
  80. qp.AppendFormat(" '{0}' ", Extrator.Util.aspasSQL(seo_description));
  81. qp.Append(" ); ");
  82. Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  83.  
  84. retorno = true;
  85.  
  86. }
  87.  
  88. return retorno;
  89. }
  90.  
  91.  
  92.  
  93. private static void atualizaPagina(string titulo, string seo_title, string seo_description, string texto, string slug, string idPagina, int idPaginaPai, bool exportaMetaDados)
  94. {
  95. StringBuilder qp = new StringBuilder();
  96. qp.Append(" UPDATE wp_posts SET ");
  97. qp.AppendFormat(" post_title = '{0}', ", Extrator.Util.aspasSQL(titulo));
  98. qp.AppendFormat(" post_content = '{0}', ", Extrator.Util.aspasSQL(texto));
  99. qp.AppendFormat(" post_name = '{0}', ", Extrator.Util.aspasSQL(slug));
  100. qp.AppendFormat(" post_modified = '{0:yyyy-MM-dd HH:mm:ss}', ", DateTime.Now);
  101. qp.AppendFormat(" post_parent = '{0}' ", idPaginaPai);
  102. qp.AppendFormat(" WHERE ID = {0} ", idPagina);
  103.  
  104. //Grava
  105. Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  106.  
  107.  
  108. /*
  109. HttpContext.Current.Response.Write(qp.ToString());
  110. HttpContext.Current.Response.Write(System.Environment.NewLine);
  111. HttpContext.Current.Response.Write(System.Environment.NewLine);
  112. */
  113.  
  114. qp.Clear();
  115.  
  116. if (exportaMetaDados)
  117. {
  118. //Título
  119. 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);
  120. Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  121. /*
  122. HttpContext.Current.Response.Write(qp.ToString());
  123. HttpContext.Current.Response.Write(System.Environment.NewLine);
  124. */
  125.  
  126. //Meta
  127. 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);
  128. Extrator.DB_MySql.ExecutaConsulta(qp.ToString());
  129. /*
  130. HttpContext.Current.Response.Write(qp.ToString());
  131. HttpContext.Current.Response.Write(System.Environment.NewLine);
  132. */
  133. }
  134.  
  135. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement