Differences

This shows you the differences between two versions of the page.

--- serveurs:mrscandi-ovh [2021/04/08 18:07] – [mysql] quentin
+++ serveurs:mrscandi-ovh [2026/01/08 12:50] (current) – [CPanel] 78.192.146.214
@@ Line 1: / Line 1: @@
+🚨 ATTENTION NOUVEL HEBERGEMENT 2026 APRES MIGRATION
+==== CPanel ====
+> Adresse de connexion :	[[https://abyssin.o2switch.net:2083]]
+> Nom d'utilisateur :	chqu2445
+> Mot de passe :	3yz5-aaGa-HkG{
+==== FTP ====
+> Adresse FTP :	abyssin.o2switch.net
+> Port FTP :	Port 21
+> Nom d'utilisateur :	chqu2445
+> Mot de passe :	3yz5-aaGa-HkG{
+---
 ==== ftp ====
 [[http://vacwdjk.cluster028.hosting.ovh.net]]
@@ Line 26: / Line 46: @@
 > QTrFPrXJ5YCgQgxB
+===== SQL AIDE =====
+** Afficher tous les produits shopping en brouillon avant le 15-09**
+<code `sql`>
+SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-09-15 15:09:01' AND `post_type` LIKE 'shopping' ORDER BY `wp_posts`.`post_modified` ASC
+</code>
+** Passer en archive tous les produits shopping en brouillon avant le 15-09**
+<code `sql`>UPDATE `wp_posts` SET `post_status` = 'archive' WHERE `post_status` LIKE 'draft' AND `post_modified` < '2021-09-15 15:09:01' AND `post_type` LIKE 'shopping'</code>
+** Afficher tous les produits shopping en brouillon**
+<code `sql`>SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping'</code>
+** Afficher tous les produits shopping en brouillon contenant le mot matelas**
+<code `sql`>SELECT * FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';</code>
+** Supprimer tous les produits shopping en brouillon contenant le mot matelas**
+<code `sql`>DELETE FROM `wp_posts` WHERE `post_status` LIKE 'draft' AND `post_type` LIKE 'shopping' AND `post_title` LIKE '%matelas%';</code>
+** Afficher les produits les + cliqués **
+<code `sql`>SELECT p.ID, p.guid, p.post_title, meta_value as nb_clics
+FROM `wp_postmeta` pm, wp_posts p
+WHERE meta_key = 'nb_clics'
+AND pm.post_id = p.ID
+ORDER BY CAST(meta_value AS DECIMAL) DESC
+LIMIT 200;</code>