Перейти к содержанию
Авторизация  
Подписчики 0
Slavas

sql запрос

Автор Slavas, в Обсуждения

Рекомендуемые сообщения

Slavas    0

Slavas
Опубликовано

как правильно написать sql запрос  для   lucera  ??

 

 

UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753;    
-- kamael soe for simple soe (x10)
UPDATE char_creation_items SET itemId='219' WHERE itemId = 10;    
-- starting dagger for Sword Breaker
UPDATE char_creation_items SET itemId='311' WHERE itemId = 6;    
-- starting wand for Crucifix of Blessing
UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;    
-- starting sword for Falchion
UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;    
-- starting fists for Viper Fang
UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;    
-- starting fists for Flanged Mace
UPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;    
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;    
-- starting mystics armor for Devotion armor
UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;    
-- starting fifghers armor for Wooden armor
UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147;    
-- starting fifghers armor for Wooden armor
INSERT INTO char_creation_items VALUES (0,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (18,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (31,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (44,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (53,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (123,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (124,43,1,'true');    
-- Wooden set helm
INSERT INTO char_creation_items VALUES (10,44,1,'true');    
-- Devotion set helm
INSERT INTO char_creation_items VALUES (25,44,1,'true');    
-- Devotion set helm
INSERT INTO char_creation_items VALUES (38,44,1,'true');    
-- Devotion set helm
INSERT INTO char_creation_items VALUES (49,44,1,'true');    
-- Devotion set helm
INSERT INTO char_creation_items VALUES (0,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (18,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (31,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (44,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (53,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (123,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (124,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (10,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (25,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (38,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (49,5590,1,'true');    
-- Random Boots (id:5590 - Squeaking Shoes)
INSERT INTO char_creation_items VALUES (0,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (18,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (31,51,1,'true');    
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (44,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (53,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (123,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (124,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (10,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (25,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (38,51,1,'true');    
-- Random gloves id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (49,51,1,'true');    
-- Random gloves (id:51 - Bracer Gloves)
INSERT INTO char_creation_items VALUES (0,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (18,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (31,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (44,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (53,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (123,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (124,5250,2,'true');    
-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)
INSERT INTO char_creation_items VALUES (10,5262,1,'false');    
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (25,5262,1,'false');    
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (38,5262,1,'false');    
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)
INSERT INTO char_creation_items VALUES (49,5262,1,'false');    
-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

zGosu    396

zGosu
Опубликовано (изменено)

как правильно написать sql запрос  для   lucera  ??

 

 

UPDATE char_creation_items SET itemId='736' WHERE itemId = 12753;    

-- kamael soe for simple soe (x10)

UPDATE char_creation_items SET itemId='219' WHERE itemId = 10;    

-- starting dagger for Sword Breaker

UPDATE char_creation_items SET itemId='311' WHERE itemId = 6;    

-- starting wand for Crucifix of Blessing

UPDATE char_creation_items SET itemId='68' WHERE itemId = 2369;    

-- starting sword for Falchion

UPDATE char_creation_items SET itemId='257' WHERE itemId = 2368;    

-- starting fists for Viper Fang

UPDATE char_creation_items SET itemId='155' WHERE itemId = 2370;    

-- starting fists for Flanged Mace

UPDATE char_creation_items SET itemId='1101' WHERE itemId = 425;    

-- starting mystics armor for Devotion armor

UPDATE char_creation_items SET itemId='1104' WHERE itemId = 461;    

-- starting mystics armor for Devotion armor

UPDATE char_creation_items SET itemId='23' WHERE itemId = 1146;    

-- starting fifghers armor for Wooden armor

UPDATE char_creation_items SET itemId='2386' WHERE itemId = 1147;    

-- starting fifghers armor for Wooden armor

INSERT INTO char_creation_items VALUES (0,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (18,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (31,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (44,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (53,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (123,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (124,43,1,'true');    

-- Wooden set helm

INSERT INTO char_creation_items VALUES (10,44,1,'true');    

-- Devotion set helm

INSERT INTO char_creation_items VALUES (25,44,1,'true');    

-- Devotion set helm

INSERT INTO char_creation_items VALUES (38,44,1,'true');    

-- Devotion set helm

INSERT INTO char_creation_items VALUES (49,44,1,'true');    

-- Devotion set helm

INSERT INTO char_creation_items VALUES (0,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (18,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (31,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (44,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (53,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (123,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (124,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (10,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (25,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (38,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (49,5590,1,'true');    

-- Random Boots (id:5590 - Squeaking Shoes)

INSERT INTO char_creation_items VALUES (0,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (18,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (31,51,1,'true');    

-- Random gloves id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (44,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (53,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (123,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (124,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (10,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (25,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (38,51,1,'true');    

-- Random gloves id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (49,51,1,'true');    

-- Random gloves (id:51 - Bracer Gloves)

INSERT INTO char_creation_items VALUES (0,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (18,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (31,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (44,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (53,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (123,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (124,5250,2,'true');    

-- shoots x2 (id:5250 - Greater Compressed Package of Soulshots: No-grade)

INSERT INTO char_creation_items VALUES (10,5262,1,'false');    

-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

INSERT INTO char_creation_items VALUES (25,5262,1,'false');    

-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

INSERT INTO char_creation_items VALUES (38,5262,1,'false');    

-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

INSERT INTO char_creation_items VALUES (49,5262,1,'false');    

-- shoots (id:5262 - Greater Compressed Package of Blessed Spiritshots: No-grade)

 

А чем Вас эти запросы не устраивают? Подправить под свои таблицы эти запросы и Готово! 

Изменено пользователем zGosu
  • Upvote 1

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти
Авторизация  
Подписчики 0
Перейти к списку тем

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×
×
  • Создать...