Thread: [Epic] Easiest way for creating ur own patch for "Melee Weapons" item bug!

I exceeded number of letters so I had to rip this much as I was able to..

So lets start immediately:

CREATING DB IN MYSQL AND GETTING REQUIRED COLUMNS

Using PHP Script on your database.
--> Connecting and creating new DB.
So simply, create new database in MySQL which will be called DBC. When you created it, select it and type this code as QUERY.

PHP Code:

CREATE TABLE `items` (
    `entry` INT(8) UNSIGNED NOT NULL DEFAULT '0',
    `class` INT(30) NOT NULL DEFAULT '0',
    `subclass` INT(30) NOT NULL DEFAULT '0',
    `field4` INT(30) NOT NULL DEFAULT '0',
    `lock_material` INT(30) NOT NULL DEFAULT '0',
    `displayid` INT(30) NOT NULL DEFAULT '0',
    `inventorytype` INT(30) NOT NULL DEFAULT '0',
    `quality` INT(30) NOT NULL DEFAULT '0',
    PRIMARY KEY (`entry`)
)
COMMENT='ThePingue.com'
ENGINE=MyISAM
ROW_FORMAT=DEFAULT 


--> Using script to transfer required fields from world.items to DBC.items
Use it as you use others.

PHP Code:

<?php 
set_time_limit(0); 
#CONNECTION SETTINGS 
$host = '127.0.0.1'; 
$user = 'root'; 
$password = 'ascent'; 

#Dont edit below here.. 
mysql_connect($host, $user, $password) or die('Could not connect to server!'); 

$items = mysql_query("SELECT entry,class,subclass,field4,lock_material,displayid,inventorytype,sheathID FROM world.items"); 
while($row = mysql_fetch_array($items)) { 
  mysql_query("INSERT INTO dbc.items (entry, class, subclass, field4, lock_material, displayid, inventorytype, sheathID) VALUES ('{$row['entry']}', '{$row['class']}', '{$row['subclass']}', '{$row['field4']}', '{$row['lock_material']}', '{$row['displayid']}', '{$row['inventorytype']}', '{$row['sheathID']}')"); 
} 
?>

--> Exporting items as .csv file.
So, when you are in dbc.items, select all of the rows you see (CTRL + A) and export them as grid.
See image 1.0

--> Next step, editing items.csv file.
Good, open items.csv file with NotePad++. Google for it if u dont have it. Then go to 'Search' -> Drop down menu and select REPLACE.
Stuff that needs to be replaced.
; with ,
" with nothing, just leave replace with empty.

--> NEXT: EDITING item.csv FILE & Converting it back into DBC --> .MPQ

Downloading required programs & Using them
DBCUtil can be downloaded [Only registered and activated users can see links. ]
& CSVed can be downloaded [Only registered and activated users can see links. ]
& Ladix MPQ editor can be downloaded [Only registered and activated users can see links. ]
You might need WinRAR for this. Google for it

--> Installing the programs
CSVed has installation of it self.
DBCutill must be placed into its own folder with items.dbc.
Ladik's MPQ Editor can be placed on desktop and just to run.

--> Using the programs & Exporting & Editing item.csv
Ok next thing we wanna do is to EXPORT item.dbc from your .MPQ file.
1. Navigate to your WoW Folder/Data/enUS/
2. Open patch-enUS-3.mpq with ladik's editor.
3. Proceed to DBFilesClient folder.
4. When you are in DBFilesClient folder, right click on item.dbc and EXTRACT it to your DBCUtil folder.
5. Close it, do NOT save anything.
6. Now navigate into your DBCutil folder, and make sure that inside you only have item.dbc, DBCutil.exe and MSVCR71.dll file.
7. Run DBCUtil.exe it should do some percentage, process, and then it will close it self.
8. Take a look into DBCUtil folder, you will see item.dbc.csv file.
9. Now open the file with CSVed, and look for Text Editor, see image 1.1
10. When you opened file in Text Editor, then go to FILE, open current.
11. Select all and delete them. Now thing we want to do is to copy text from NotePad++ where we had exported items from DB INTO item.csv file.
12. When you are done, save it, refresh file and close.

--> Converting item.csv INTO item.dbc AND putting it into PATCH.mpq
1. Go to your DBCUtil folder and delete item.dbc file in it. Now remember the edited item.dbc.csv file?.. drag it over DBCutil.exe and it will convert it into item.dbc
Save it.
2. Now go to your World of Warcraft folder, Data, enUS, and there put [Only registered and activated users can see links. ] file. Now edit that empty patch file which you downloaded and import item.dbc file in to patch.mpq/DBClientFiles/--
So it will look like image 1.2.
3. Save the file and close it, now rename file to patch-YourLanguage-7.mpq


With that, you're done. Login and try casting some spell which requires melee weapon, remember to have custom weapon equiped, rofl.


Thats all.




IMAGES

1.0

1.1

1.2



Credits: Maverfax & Intr3 from thepingue.com

This is my start only..

edit: I'm uploading files up again.

Good share mate

Nice Share

what am i doing wrong...
i enter this into the world database

Code:

select entry, class, subclass, field4, quality, displayid, inventorytype, sheathid
from items

then i export it as a cvs from hedisql
then i open it with notepad++ and replace ; with , and " with nothing.
then i convert item.dbc to item.dbc.csv
then i open item.dbc.csv with CSVed and go to text editor
i copy the stuff from the exported csv into item.dbc.csv. i save it and refresh it ect
then i convert it back to dbc, place it in my custom patch and put the converted dbc in ArcEmu/DBC