[Информация] простенькие SQL запросы

[levoe123]

Перед использованием SQL запросов не забывайте делать бэкапы

Устанавливаем вес всех вещей 0
Код:

Цитата: UPDATE `etcitem` SET `weight`=0 WHERE `weight`>0; UPDATE `armor` SET `weight`=0 WHERE `weight`>0; UPDATE `weapon` SET `weight`=0 WHERE `weight`>0;

Изменяем имя персонажу
Код:

Цитата: UPDATE characters SET char_name='новое_имя' WHERE char_name='старое_имя'

Полное удаление Нпса из БД
Код:

Цитата: DELETE FROM spawnlist WHERE npc_templateid = 50000; DELETE FROM npc WHERE id = 50000;

Удаление всех вещей с определённым ID у определнного персонажа.
Код:

Цитата: DELETE * FROM items WHERE item_id=(ид того что удалить) AND owner_id=(ИД перса, у которого удалить)

Снижение цен продажи вещей в магазины до 1 адены:
Код:

Цитата: update etcitem set price=1 where price > 1; update weapon set price=1 where price > 1; update armor set price=1 where price > 1;

Убираем весь дроп кроме адены
Код:

Цитата: DELETE FROM `droplist` WHERE (`itemId`!='57') AND (`category`='-1')

Устанавливаем шанс дропа аден 100% вместо 70%
Код:

Цитата: UPDATE `droplist` SET `droplist`.`chance`=1000000 WHERE `droplist`.`itemId`=57;

Удаляем из дропа всё, кроме вещей с ID 57, 77, 107

Код:

Цитата: DELETE FROM droplist WHERE itemId NOT IN (57,77,107);

Удаление дропа:

Ресурсы
Код:

Цитата: DELETE FROM droplist WHERE itemId='1864'; DELETE FROM droplist WHERE itemId='1865'; DELETE FROM droplist WHERE itemId='1866'; DELETE FROM droplist WHERE itemId='1868'; DELETE FROM droplist WHERE itemId='1869'; DELETE FROM droplist WHERE itemId='1870'; DELETE FROM droplist WHERE itemId='1871'; DELETE FROM droplist WHERE itemId='1872'; DELETE FROM droplist WHERE itemId='1873'; DELETE FROM droplist WHERE itemId='1874'; DELETE FROM droplist WHERE itemId='1875'; DELETE FROM droplist WHERE itemId='1876'; DELETE FROM droplist WHERE itemId='1877'; DELETE FROM droplist WHERE itemId='1878'; DELETE FROM droplist WHERE itemId='1879'; DELETE FROM droplist WHERE itemId='1880'; DELETE FROM droplist WHERE itemId='1881'; DELETE FROM droplist WHERE itemId='1882'; DELETE FROM droplist WHERE itemId='1884'; DELETE FROM droplist WHERE itemId='1885'; DELETE FROM droplist WHERE itemId='1895'; DELETE FROM droplist WHERE itemId='5549'; DELETE FROM droplist WHERE itemId='1886'; DELETE FROM droplist WHERE itemId='1887'; DELETE FROM droplist WHERE itemId='1888'; DELETE FROM droplist WHERE itemId='1890'; DELETE FROM droplist WHERE itemId='1891'; DELETE FROM droplist WHERE itemId='1892'; DELETE FROM droplist WHERE itemId='1893'; DELETE FROM droplist WHERE itemId='1889'; DELETE FROM droplist WHERE itemId='1894'; DELETE FROM droplist WHERE itemId='4039'; DELETE FROM droplist WHERE itemId='4040'; DELETE FROM droplist WHERE itemId='4041'; DELETE FROM droplist WHERE itemId='4042'; DELETE FROM droplist WHERE itemId='4043'; DELETE FROM droplist WHERE itemId='4044'; DELETE FROM droplist WHERE itemId='4046'; DELETE FROM droplist WHERE itemId='4047'; DELETE FROM droplist WHERE itemId='4045'; DELETE FROM droplist WHERE itemId='5550'; DELETE FROM droplist WHERE itemId='4048';

Стрелы
Код:

Цитата: DELETE FROM droplist WHERE itemId='17'; DELETE FROM droplist WHERE itemId='1341'; DELETE FROM droplist WHERE itemId='1342'; DELETE FROM droplist WHERE itemId='1343'; DELETE FROM droplist WHERE itemId='1344'; DELETE FROM droplist WHERE itemId='1345'; DELETE FROM droplist WHERE itemId='4048';

Potions
Код:

Цитата: DELETE FROM droplist WHERE itemId='1539'; DELETE FROM droplist WHERE itemId='5591'; DELETE FROM droplist WHERE itemId='5592';

Cursed Bone
Код:

Цитата: DELETE FROM droplist WHERE itemId='2508';

SoE
Код:

Цитата: DELETE FROM droplist WHERE itemId='736'; DELETE FROM droplist WHERE itemId='1829'; DELETE FROM droplist WHERE itemId='1830'; DELETE FROM droplist WHERE itemId='737'; DELETE FROM droplist WHERE itemId='1538';

Возвращаем РБ бижу Боссам
Код:

Цитата: INSERT INTO droplist VALUES ('29001', '6660', '1', '1', '12', '300000'); INSERT INTO droplist VALUES ('29006', '6662', '1', '1', '8', '300000'); INSERT INTO droplist VALUES ('29014', '6661', '1', '1', '9', '300000'); INSERT INTO droplist VALUES ('29022', '6659', '1', '1', '13', '1000000'); INSERT INTO droplist VALUES ('29020', '6658', '1', '1', '2', '1000000'); INSERT INTO droplist VALUES ('29019', '6656', '1', '1', '31', '1000000'); INSERT INTO droplist VALUES ('29028', '6657', '1', '1', '34', '1000000');

Добавляем скил Weight Limit всем персонажам.
Код:

Цитата: INSERT INTO skill_trees VALUES (0,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (10,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (18,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (25,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (31,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (38,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (44,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (49,150,2,'Weight Limit',0,1); INSERT INTO skill_trees VALUES (53,150,2,'Weight Limit',0,1);

Добавляем скил Noblesse Blessingt всем персонажам
Код:

Цитата: INSERT INTO skill_trees VALUES (0,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (10,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (18,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (25,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (31,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (38,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (44,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (49,1323,2,'Noblesse Blessing',0,1); INSERT INTO skill_trees VALUES (53,1323,2,'Noblesse Blessing',0,1);

[Fix]

Это чтоб вопросов не было
SELECT
Функция: ввод данных из таблицы.
Синтаксис: SELECT FROM WHERE =;
Параметр WHERE не обязателен, а команда SELECT * FROM users;
покажет все данные таблицы "users"
--------------------------------------------------------------------------------
INSERT
Функция: ввод данных в таблицу.
Синтаксис: INSERT INTO () VALUES ();
К примеру,
INSERT INTO users (login, password) VALUES ('hawker', 'qwerty');
вставит в таблицу "users" новую строку, причем в столбике "login" будет значится "hawker", а в столбике "password" - "qwerty".
--------------------------------------------------------------------------------
UPDATE
Функция: модификация данных в базе. Синтаксис: UPDATE SET =,..,= WHERE =;
К примеру,
UPDATE users SET password='asdfg' WHERE login='hawker';
поменяет поле "password" в строке, добавленной выше.
--------------------------------------------------------------------------------
DELETE
Функция: удаление данных из базы.
Синтаксис: DELETE FROM WHERE =;
К примеру,
DELETE FROM users WHERE login='hawker';
удалит строку, добавленную выше.
-------------------------------------------------------------------------------
DROP
Функция: удаление таблицы. Синтаксис: DROP TABLE :
К примеру,
DROP TABLE users;
сотрет всю таблицу "users".