[DiscordArchive] can you describe "then i put them (...)" with more details?
[DiscordArchive] can you describe "then i put them (...)" with more details?
Original source
can you describe "then i put them (...)" with more details?
rektbyfaith
05-12-2022, 09:01 PM #1Archived author: Jinnai • Posted: 2022-05-12T21:01:36.623000+00:00
Original source
can you describe "then i put them (...)" with more details?
Original source
DROP TABLE IF EXISTS `aa_item_dbc`;
CREATE TABLE `aa_item_dbc` (
`id` INT(11) NOT NULL DEFAULT '0',
`class` INT(11) NOT NULL DEFAULT '0',
`subclass` INT(11) NOT NULL DEFAULT '0',
`unk0` INT(11) NOT NULL DEFAULT '0',
`material` INT(11) NOT NULL DEFAULT '0',
`displayid` INT(11) NOT NULL DEFAULT '0',
`inventorytype` INT(11) NOT NULL DEFAULT '0',
`sheath` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
ALTER TABLE `world`.`aa_item_dbc`
CHANGE `id` `id` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `class` `class` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `subclass` `subclass` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `unk0` `unk0` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `material` `material` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `displayid` `displayid` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `inventorytype` `inventorytype` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `sheath` `sheath` VARCHAR(255) DEFAULT '0' NOT NULL,
DROP PRIMARY KEY;
INSERT INTO `aa_item_dbc` VALUES ('int','int','int','int','int','int','int','int');
INSERT INTO `aa_item_dbc`
SELECT
`item_template`.entry,
`item_template`.class,
`item_template`.subclass,
`item_template`.SoundOverrideSubclass,
`item_template`.Material,
`item_template`.displayid,
`item_template`.InventoryType,
`item_template`.sheath
FROM `item_template` WHERE `item_template`.entry = `item_template`.entry;
rektbyfaith
05-12-2022, 09:04 PM #2Archived author: Fake´z • Posted: 2022-05-12T21:04:25.094000+00:00
Original source
DROP TABLE IF EXISTS `aa_item_dbc`;
CREATE TABLE `aa_item_dbc` (
`id` INT(11) NOT NULL DEFAULT '0',
`class` INT(11) NOT NULL DEFAULT '0',
`subclass` INT(11) NOT NULL DEFAULT '0',
`unk0` INT(11) NOT NULL DEFAULT '0',
`material` INT(11) NOT NULL DEFAULT '0',
`displayid` INT(11) NOT NULL DEFAULT '0',
`inventorytype` INT(11) NOT NULL DEFAULT '0',
`sheath` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
);
ALTER TABLE `world`.`aa_item_dbc`
CHANGE `id` `id` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `class` `class` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `subclass` `subclass` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `unk0` `unk0` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `material` `material` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `displayid` `displayid` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `inventorytype` `inventorytype` VARCHAR(255) DEFAULT '0' NOT NULL,
CHANGE `sheath` `sheath` VARCHAR(255) DEFAULT '0' NOT NULL,
DROP PRIMARY KEY;
INSERT INTO `aa_item_dbc` VALUES ('int','int','int','int','int','int','int','int');
INSERT INTO `aa_item_dbc`
SELECT
`item_template`.entry,
`item_template`.class,
`item_template`.subclass,
`item_template`.SoundOverrideSubclass,
`item_template`.Material,
`item_template`.displayid,
`item_template`.InventoryType,
`item_template`.sheath
FROM `item_template` WHERE `item_template`.entry = `item_template`.entry;
Original source
damn sry . thougt it could pop in like a small window -.- i run that query in heidi and i get the dbc "aa_item_dbc" and inside that dbc my ring item is . i copy all files inside and over to mpqediter and create the Item_dbc for mpq - calling it patch-4.mpq and i put the patch in my client folder where it says Data and not Data / us
rektbyfaith
05-12-2022, 09:07 PM #3Archived author: Fake´z • Posted: 2022-05-12T21:07:08.552000+00:00
Original source
damn sry . thougt it could pop in like a small window -.- i run that query in heidi and i get the dbc "aa_item_dbc" and inside that dbc my ring item is . i copy all files inside and over to mpqediter and create the Item_dbc for mpq - calling it patch-4.mpq and i put the patch in my client folder where it says Data and not Data / us
Original source
im not a custom editing expert but i highly doubt that whatever exactly you are doing here will work
rektbyfaith
05-12-2022, 09:08 PM #4Archived author: Jinnai • Posted: 2022-05-12T21:08:26.668000+00:00
Original source
im not a custom editing expert but i highly doubt that whatever exactly you are doing here will work
Original source
not sure why you work in sql here
rektbyfaith
05-12-2022, 09:08 PM #5Archived author: Jinnai • Posted: 2022-05-12T21:08:50.004000+00:00
Original source
not sure why you work in sql here
Original source
and your colum names do not match the real dbc column names
rektbyfaith
05-12-2022, 09:08 PM #6Archived author: Jinnai • Posted: 2022-05-12T21:08:59.182000+00:00
Original source
and your colum names do not match the real dbc column names
Original source
![[Image: unknown.png?ex=690c65b4&is=690b1434&hm=c...85870313f&]](https://cdn.discordapp.com/attachments/870722120458600528/974417973068574830/unknown.png?ex=690c65b4&is=690b1434&hm=c59de06e9488ae740fbc1267f01d5fd80b7dd82546824eb0d3c481885870313f&)
rektbyfaith
05-12-2022, 09:09 PM #7Archived author: Jinnai • Posted: 2022-05-12T21:09:08.746000+00:00
Original source
Original source
and you also need aaaaallll of the old data from the item.dbc and ADD your new stuff to it and pack it into a NEW mpq because otherwise you will KILL all old stuff
rektbyfaith
05-12-2022, 09:10 PM #8Archived author: Jinnai • Posted: 2022-05-12T21:10:57.341000+00:00
Original source
and you also need aaaaallll of the old data from the item.dbc and ADD your new stuff to it and pack it into a NEW mpq because otherwise you will KILL all old stuff
Original source
last time i did it same way and it worked fine
i follow jada¨s guide for mpq patch , i ran the code in heidi and got the dbc file . then my item should pop up in that + in item_template .
rektbyfaith
05-12-2022, 09:12 PM #9Archived author: Fake´z • Posted: 2022-05-12T21:12:09.642000+00:00
Original source
last time i did it same way and it worked fine
i follow jada¨s guide for mpq patch , i ran the code in heidi and got the dbc file . then my item should pop up in that + in item_template .
Original source
well, cant help you if you follow a 9 year old video from a random dude recording in his bathroom and something doesnt work
rektbyfaith
05-12-2022, 09:18 PM #10Archived author: Jinnai • Posted: 2022-05-12T21:18:34.896000+00:00
Original source
well, cant help you if you follow a 9 year old video from a random dude recording in his bathroom and something doesnt work
1 Guest(s)
1 Guest(s)