ProjectSkyfire / SkyFire.406a

SkyFireEMU is a full featured F/OSS World of Warcraft: Cataclysm emulator written in C++. || Compatible with World of Warcraft client 4.0.6a (Build:13623) || Public DB is located on forum
http://www.projectskyfire.org
GNU General Public License v3.0
344 stars 218 forks source link

[Quest] Liberate the Kaja'Mite #698

Open alexmocanu opened 12 years ago

alexmocanu commented 12 years ago

Quest ID:14124

Can't pick up the Kaja'mite chunks (48766)

LKArthas commented 12 years ago

confirm, it can´t pick up

Mopower commented 12 years ago

I went into my database and changed data0 to 5 and it worked you can pick it up. Also make sure chest loot is set to right entry number. Let me know if this worked.

Edit: Go into database under game_object template look up Kaja'mite chunks. Then look for Data0 change it there. Chestloot is actually data1. Sorry for any confusion i use truice as a database editor makes it simpler.

Nomadgraphics commented 12 years ago

If you found a fix for a db issue submit it in a sql

Loukie commented 12 years ago

what is the values for data0 and data1?

Walkum commented 12 years ago

@Loukie put in google "gameobject template tc2" and see the wiki.

Loukie commented 12 years ago

thx but im still a noob at this i have try changing the values like i think it should be but with no luck.

Mopower commented 12 years ago

Sorry about that like nomad said i will put try and put it in sql foramat for you. Give me a chance pretty busy in real life and other things. Will try and get it in sql this weekend.

Merlin2010 commented 12 years ago

update gameobject_template set data0 = 5 where entry = 195492;

Loukie commented 12 years ago

did not work for me :( but thax for the help ill wait for the core fix.

hydrocataclism commented 11 years ago

Hy it easy to fix just change data0 value to 1818 it works well, now we can pickup ,but my question is how to fix i the spell 67682 (Kablooey Bombs) ?

hydrocataclism commented 11 years ago

Oh, and the sql query to change is UPDATE world.gameobject_template SET data0 = '1818' WHERE gameobject_template.entry =195492;

crowel commented 11 years ago

Hey it works for me but my friends who went to try it does not work I do?

ImageDev commented 11 years ago

you guys make pull requests, if you have a fix... this is not the correct place for fix suggestions, for this use the forums.

crowel commented 11 years ago

okay sorry for the question

ImageDev commented 11 years ago

the question is fine, just redirect it to our forums, this tracker is just for reporting bugs ;) working together to figure out a solution for a problem, is encouraged... if its in the right place