[Appliqué]Correction requêtes SQL ZoneEmuWotlk
Bonjour,
Je sais, ce n'est pas la bonne section, mais je n'ai pas encore accès à la section dédiée au repo.
Dans les fichiers SQLs, les requêtes ont été oubliées :
[code=diff]

diff --git a/sql/zone-emu/2011_11_24_00_trinity_string.sql b/sql/zone-emu/2011_11_24_00_trinity_string.sql
index 7d8d57b..35adc96 100644
--- a/sql/zone-emu/2011_11_24_00_trinity_string.sql
+++ b/sql/zone-emu/2011_11_24_00_trinity_string.sql
@@ -1,5 +1,5 @@
DELETE FROM `trinity_string` WHERE `entry` BETWEEN 11010 AND 11019;
-
+INSERT INTO `trinity_string` (`entry`,`content_loc2`) VALUES
(11010,"Joueur"),
(11011,"Modérateur"),
(11012,"Mj"),
diff --git a/sql/zone-emu/2011_11_24_01_trinity_string.sql b/sql/zone-emu/2011_11_24_01_trinity_string.sql
index 189b781..18e87ee 100644
--- a/sql/zone-emu/2011_11_24_01_trinity_string.sql
+++ b/sql/zone-emu/2011_11_24_01_trinity_string.sql
@@ -1,5 +1,5 @@
DELETE FROM `trinity_string` WHERE `entry` BETWEEN 11010 AND 11025;
-
+INSERT INTO `trinity_string` (`entry`,`content_loc2`) VALUES
(11010,"Joueur"),
(11011,"Modérateur"),
(11012,"Mj"),
diff --git a/sql/zone-emu/2011_11_24_02_trinity_string.sql b/sql/zone-emu/2011_11_24_02_trinity_string.sql
index a4dbfc1..0cb06b0 100644
--- a/sql/zone-emu/2011_11_24_02_trinity_string.sql
+++ b/sql/zone-emu/2011_11_24_02_trinity_string.sql
@@ -1,5 +1,5 @@
DELETE FROM `trinity_string` WHERE `entry` BETWEEN 11010 AND 11027;
-
+INSERT INTO `trinity_string` (`entry`,`content_loc2`) VALUES
(11010,"Joueur"),
(11011,"Modérateur"),
(11012,"Mj"),
diff --git a/sql/zone-emu/2011_11_24_03_trinity_string.sql b/sql/zone-emu/2011_11_24_03_trinity_string.sql
index 444bfaf..561d2ca 100644
--- a/sql/zone-emu/2011_11_24_03_trinity_string.sql
+++ b/sql/zone-emu/2011_11_24_03_trinity_string.sql
@@ -1,5 +1,5 @@
DELETE FROM `trinity_string` WHERE `entry` BETWEEN 11010 AND 11029;
-
+INSERT INTO `trinity_string` (`entry`,`content_loc2`) VALUES
(11010,"Joueur"),
(11011,"Modérateur"),
(11012,"Mj"),
diff --git a/sql/zone-emu/2011_12_03_00_trinity_string.sql b/sql/zone-emu/2011_12_03_00_trinity_string.sql
index c046349..4f48a91 100644
--- a/sql/zone-emu/2011_12_03_00_trinity_string.sql
+++ b/sql/zone-emu/2011_12_03_00_trinity_string.sql
@@ -1,5 +1,5 @@
DELETE FROM `trinity_string` WHERE `entry` BETWEEN 11010 AND 11029;
-
+INSERT INTO `trinity_string` (`entry`,`content_loc2`) VALUES
(11010,"Joueur"),
(11011,"Modérateur"),
(11012,"Mj"),
[/code]

Voilà Clin
Encore une fois merci pour ces erreurs toutes connes Clin
C'est commit sur le repo.

Cordialement,
MacWarrior.

Retourner en haut Accueil