Lucera Sql Запрос

[sharp1k 321]

нужно сделать запрос под люцеру чтобы новые персы появлялись в ТОП НГ шмоте, и с нублом при старте)

 

пожалуйста

[King 15]

Нубл настраивается в конфигах.

С запросом сложнее, запрос надо весь переписывать.

Есть мной написанный запрос на добавление С шмота.

Для примера могу выложить, объяснить что куда.

Остальное сам.

Могу за "Пиво" переписать самому)

Изменено 17 января, 2013 пользователем King

[Abnormal 254]

таблица char_creation_items

смотришь её структуру и пишешь запрос

[39rus 8]

Нубл настраивается в конфигах.

С запросом сложнее, запрос надо весь переписывать.

Есть мной написанный запрос на добавление С шмота.

Для примера могу выложить, объяснить что куда.

Остальное сам.

Могу за "Пиво" переписать самому)

А можешь дать готовый с грейд:?запрос под люцеру:?

[King 15]

Могу =)

[WTF 113]

D грейд + соски и тд при старте

 

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('0', '1463', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('0', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('10', '3948', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('10', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('18', '1463', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('18', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('25', '3948', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('25', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('31', '1463', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('31', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('38', '3948', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('38', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('44', '1463', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('44', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('49', '3948', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('49', '3031', '1000', 'true');

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `char_creation_items` VALUES ('53', '1463', '1000', 'true');

INSERT INTO `char_creation_items` VALUES ('53', '3031', '1000', 'true');

UPDATE `char_creation_items` SET `amount`='2' WHERE `itemId`='850';

UPDATE `char_creation_items` SET `amount`='2' WHERE `itemId`='881';

[unsual 530]

UPDATE `characters` SET `subpledge`='1'

UPDATE `characters` SET `nobless`='1'

 

 

REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);

 

[39rus 8]

аесть у кого не на нублис при старте а на скилл при старте :?)

[unsual 530]

аесть у кого не на нублис при старте а на скилл при старте :?)

UPDATE `characters` SET `название скила`='лвл скила' Изменено 17 января, 2013 пользователем unsual

[39rus 8]

UPDATE `characters` SET `subpledge`='1'

UPDATE `characters` SET `nobless`='1'

 

 

REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);

 

[Err] 1136 - Column count doesn't match value count at row 1

[Err] REPLACE INTO char_templates VALUES (0, "Human Fighter", 0, 40, 43, 30, 21, 11, 25, 4, 72, 3, 47, 330, 213, 33, 44, 33, 115, 81900, -71338, 258271, -3104, 0, "1.1", "1.188", 9, 23, "1.1", "1.188", 8, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (18, "Elf Fighter", 1, 36, 36, 35, 23, 14, 26, 4, 72, 3, 47, 345, 249, 36, 46, 36, 125, 73000, 45978, 41196, -3440, 0, "1.15", "1.242", "7.5", 24, "1.15", "1.242", "7.5", 23, 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (31, "DE Fighter", 2, 41, 32, 34, 25, 12, 26, 4, 72, 3, 47, 342, 226, 35, 45, 35, 122, 69000, 28377, 10916, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.14", "1.2312", 7, "23.5", 401, 2437, 2461, 499,6358);

REPLACE INTO char_templates VALUES (44,'Orc Fighter', 3, 40, 47, 26, 18, 12, 27, 4, 72, 2, 48, 318, 226, 31, 42, 31, 117, 87000, -58192, -113408, -650, 0, "1.06", "1.144800", 11.0, 28.0,1.06, "1.144800", 7.0, 27.0, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (53, "Dwarf Fighter", 4, 39, 45, 29, 20, 10, 27, 4, 72, 3, 48, 327, 203, 33, 43, 33, 115, 83000, 108471, -174026, -400, 1, "1.09", "1.487196", 9, 18, "1.09", "1.487196", 5, 19, 401, 2437, 2461, 499, 4710);

REPLACE INTO char_templates VALUES (10, "Human Mage", 0, 22, 27, 21, 41, 20, 39, 2, 48, 7, 54, 303, 333, 28, 40, 28, 120, 62500, -90890, 248027, -3570, 0, "1.01", "0.87264", "7.5", "22.8", "1.01", "0.87264", "6.5", "22.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (25, "Elf Mage", 1, 21, 25, 24, 37, 23, 40, 2, 48, 6, 54, 312, 386, 30, 41, 30, 122, 62400, 46182, 41198, -3440, 0, "1.04", "0.89856", "7.5", 24, "1.04", "0.89856", "7.5", 23, 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (38, "DE Mage", 2, 23, 24, 23, 44, 19, 37, 2, 48, 7, 53, 309, 316, 29, 41, 29, 122, 61000, 28295, 11063, -4224, 0, "1.14", "1.2312", "7.5", 24, "1.03", "0.88992", 7, "23.5", 2430, 2454, 439, 471, 6313);

REPLACE INTO char_templates VALUES (49, "Orc Mage", 3, 27, 31, 24, 31, 15, 42, 2, 48, 4, 56, 312, 265, 30, 41, 30, 121, 68000, -56682, -113730, -690, 0, "1.04", "0.89856", 7, "27.5", "1.04", "0.89856", 8, "25.5", 2430, 2454, 439, 471, 6313);

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[King 15]

_http://rghost.ru/43103764

Вот 100% рабочий SQL запрос на фул "С" грейд при старте.

Лично писал

Изменено 17 января, 2013 пользователем King

[39rus 8]

а скилл на нублес при старте нету не у кого случайно:?

[King 15]

Ковыряй конфиги.

Там есть графа добавления № скила всем.

[39rus 8]

Спасибо помог