Diskusi masalah TRINITY, Scripting/Macro, & DB

oke deh jadi mercu ya...

versinya yang mana nih?
1.1.1?

Quote:

---

Originally Posted by -OceaN-LorD

versinya yang mana nih?
1.1.1?

---

yang mana aja terserah, paling baru juga gpp, btw anda make platform windoze apa linux?

windoze
tpi kyknya saya baru bisa mulai belajar hal2 tersebut setelah bulan april deh T T
maaf ya bang

eh mau nanya om gaptekbet..
kalo trinity core uda bisa dipake buat patch 3.0.8 blum??
kalo uda kasi link nya buat download..
thanks

Quote:

---

Originally Posted by heaven1st

eh mau nanya om gaptekbet..
kalo trinity core uda bisa dipake buat patch 3.0.8 blum??
kalo uda kasi link nya buat download..
thanks

---

Trinity blom support 3.0.8, berhubung dev nya masih kangen maen BC.
yang udah support 3.0.8 MaNGOS tuh

buka aja forum trinity
disitu support 2.4.3 paling akhir

jadi...kita nunggu devnya bosen tbc dan maw wotlk...

bukan bosen , tapi trinity dia mau release barengan core dan dbna

daripada ntar starting zone dk (chain quest dk) ancur2an pas release lebih baik ngurusin tbc dolo dan sambil benarin WOLTK na

Quote:

---

FROM BRIAN DEV TDB

Please take the time to read the beginning of this post... 2.4.3 data is NOT available anymore and I am NOT going to use 3.0.3 data to fix 2.4.3 problems -- THAT is a waste of time.

As for no one talking about the 3.x core -- yea, I will admit that there is not much info. Part of the problem is that some of the Trinity team wanted to just merge in the MaNGOS 3.x patch and part wanted to write it all by themselves. That held development up for a while, but in the end the decision was made to do a "write from scratch".

Now I bet some people are going to go: "DEAR GOD -- WHY?!?" ... well I can tell you that MaNGOS got some things WAY wrong, and doing it from scratch and not just following someone else, yielded some nice results.


In closing, these forums aren't going anywhere, Trinity isn't going anywhere, and there WILL be a 3.0.x core with FULL DB support -- eventually.

There are some DAMN dedicated people working on this -- and they are doing it because they have FUN doing it. Yea, we get some things wrong -- but that is part of the learning process. But the bottom line is, most of us are doing this for our own personal gratification ... it is just a bonus that we get to share that gratification with you...

-- Brian

---

JUST BE PATIENT

yoa
hidup trinity,pelan tapi pasti!

mau nanya nih, gw coba database dr tdb (Trinity Database checkout dr svn assembla) dan udah patch hingga update pack 6 (29 jan 2009). tapi pas mau tes loot table seperti yg mas gaptekbet lakukan disini kok hasilnya 0 result. dan dicek memang ga ada di creature_loot_table. namun di cek di reference_loot_table menghasilkan dengan ChanceOrQuestChance 0, sedangkan kalau reference_loot_table.entry direferensikan menjadi creature_loot_table.item, ChanceOrQuestChance jadi 100.

nah, datanya kok gak sama ya? apa gw salah pake database atau kurang patch/update tertentu? :(

Thanks :)

-- lampiran --

Code:

---

mysql> select creature_template.name, creature_loot_template.* from creature_template, creature_loot_template where creature_template.entry = 22887 and creature_loot_template.item = 32245;
Empty set (0.04 sec)

---

Code:

---

mysql> select creature_loot_template.* from creature_loot_template where creature_loot_template.item = 32245;
Empty set (0.04 sec)

---

Code:

---

mysql> select reference_loot_template.entry, reference_loot_template.item, refer ence_loot_template.ChanceOrQuestChance from reference_loot_template where reference_loot_template.item = 32245;
+-------+-------+---------------------+
| entry | item  | ChanceOrQuestChance |
+-------+-------+---------------------+
| 34070 | 32245 |                  0 |
+-------+-------+---------------------+
1 row in set (0.00 sec)

---

*coba mengira2 creature_loot_template.item = reference_loot_template.entry

Code:

---

mysql> select creature_template.name, creature_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;
+------------------------+---------------------+
| name                  | ChanceOrQuestChance |
+------------------------+---------------------+
| High Warlord Naj'entus |                100 |
+------------------------+---------------------+
1 row in set (1.11 sec)

---

Quote:

---

Originally Posted by flamea

mau nanya nih, gw coba database dr tdb (Trinity Database checkout dr svn assembla) dan udah patch hingga update pack 6 (29 jan 2009). tapi pas mau tes loot table seperti yg mas gaptekbet lakukan disini kok hasilnya 0 result. dan dicek memang ga ada di creature_loot_table. namun di cek di reference_loot_table menghasilkan dengan ChanceOrQuestChance 0, sedangkan kalau reference_loot_table.entry direferensikan menjadi creature_loot_table.item, ChanceOrQuestChance jadi 100.

nah, datanya kok gak sama ya? apa gw salah pake database atau kurang patch/update tertentu? :(

Thanks :)

-- lampiran --

Code:

---

mysql> select creature_template.name, creature_loot_template.* from creature_template, creature_loot_template where creature_template.entry = 22887 and creature_loot_template.item = 32245;
Empty set (0.04 sec)

---

Code:

---

mysql> select creature_loot_template.* from creature_loot_template where creature_loot_template.item = 32245;
Empty set (0.04 sec)

---

Code:

---

mysql> select reference_loot_template.entry, reference_loot_template.item, refer ence_loot_template.ChanceOrQuestChance from reference_loot_template where reference_loot_template.item = 32245;
+-------+-------+---------------------+
| entry | item  | ChanceOrQuestChance |
+-------+-------+---------------------+
| 34070 | 32245 |                  0 |
+-------+-------+---------------------+
1 row in set (0.00 sec)

---

*coba mengira2 creature_loot_template.item = reference_loot_template.entry

Code:

---

mysql> select creature_template.name, creature_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;
+------------------------+---------------------+
| name                  | ChanceOrQuestChance |
+------------------------+---------------------+
| High Warlord Naj'entus |                100 |
+------------------------+---------------------+
1 row in set (1.11 sec)

---

---

reference_loot_template adalah table global yang mendefinisikan semua loot_template.

creature_loot_template.item != reference_loot_template.entry karena berbeda referensi table nya, reference_loot_template digunakan untuk mereferensikan world loot yang tidak ada table spesifiknya (seperti untuk event AI). Wah kalau hasil Query nya 0 tapi barangnya drop gak tuh? lagipula Query yang terakhir agak ngacok, coba ditampilkan field creature_loot_template.entry, creature_loot_template.item, reference_loot_template.entry dan reference_loot_template.itemnya. contoh :

Code:

---

select creature_template.name, creature_loot_template.entry, creature_loot_template.item, creature_loot_template.ChanceOrQuestChance, reference_loot_template.entry, reference_loot_template.item, reference_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;

---

Quote:

---

Originally Posted by gaptekbet

reference_loot_template adalah table global yang mendefinisikan semua loot_template.

creature_loot_template.item != reference_loot_template.entry karena berbeda referensi table nya, reference_loot_template digunakan untuk mereferensikan world loot yang tidak ada table spesifiknya (seperti untuk event AI). Wah kalau hasil Query nya 0 tapi barangnya drop gak tuh? lagipula Query yang terakhir agak ngacok, coba ditampilkan field creature_loot_template.entry, creature_loot_template.item, reference_loot_template.entry dan reference_loot_template.itemnya. contoh :

Code:

---

select creature_template.name, creature_loot_template.entry, creature_loot_template.item, creature_loot_template.ChanceOrQuestChance, reference_loot_template.entry, reference_loot_template.item, reference_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;

---

---

thanks koreksinya, yg query terakhir emang ngira2 sih.. kalo ingame belum di coba sih drop apa ngga, mungkin besok baru bisa dites. takutnya sih ada patch/update database yg kurang di apply.

world database yg gw masukin:
1. TDB_0.0.1.sql
2. 5_corepatch_world_51_to_250.sql
3. 5_updatepack_world.sql
4. 6_corepatch_world_251_to_678.sql
5. 6_updatepack_world.sql
6. sql updates (679 - 973)

mungkin kah ada yg terlupa?

Terima kasih :)

-- edit: lupa hasil querynya: --

Code:

---

mysql> select creature_template.name, creature_loot_template.entry, creature_loot_template.item, creature_loot_template.ChanceOrQuestChance, reference_loot_template.entry, reference_loot_template.item, reference_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
| name                  | entry | item  | ChanceOrQuestChance | entry | item  | ChanceOrQuestChance |
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
| High Warlord Naj'entus | 22887 | 34070 |                100 | 34070 | 32245 |                  0 |
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
1 row in set (1.19 sec)

---

Quote:

---

Originally Posted by flamea

thanks koreksinya, yg query terakhir emang ngira2 sih.. kalo ingame belum di coba sih drop apa ngga, mungkin besok baru bisa dites. takutnya sih ada patch/update database yg kurang di apply.

world database yg gw masukin:
1. TDB_0.0.1.sql
2. 5_corepatch_world_51_to_250.sql
3. 5_updatepack_world.sql
4. 6_corepatch_world_251_to_678.sql
5. 6_updatepack_world.sql
6. sql updates (679 - 973)

mungkin kah ada yg terlupa?

Terima kasih :)

-- edit: lupa hasil querynya: --

Code:

---

mysql> select creature_template.name, creature_loot_template.entry, creature_loot_template.item, creature_loot_template.ChanceOrQuestChance, reference_loot_template.entry, reference_loot_template.item, reference_loot_template.ChanceOrQuestChance from creature_template, creature_loot_template, reference_loot_template where creature_template.entry = creature_loot_template.entry and creature_loot_template.item = reference_loot_template.entry and reference_loot_template.item = 32245;
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
| name                  | entry | item  | ChanceOrQuestChance | entry | item  | ChanceOrQuestChance |
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
| High Warlord Naj'entus | 22887 | 34070 |                100 | 34070 | 32245 |                  0 |
+------------------------+-------+-------+---------------------+-------+-------+---------------------+
1 row in set (1.19 sec)

---

---

kalo gak salah tiap kali anda update rev core nya dan melakukan kompilasi ada sql file di folder bin nya, apakah anda melakukan update dari clean DB? maksudnya database anda benar2 kosong alias buat baru.
Nah dari hasil Query tsb kan terlihat kejanggalan. Karena dari hasil tsb ada perbedaan referensi. Isi dari field creature_loot_template.entry adalah creature_template.entry, sedangkan field creature_loot_template.item didapat dari item_template.entry.
Table creature_loot_template bisa di referensikan dengan table reference_loot_template dengan syarat field creature_loot_template.MinCountOrRef nilainya < 0

kbtulan ni bahas offline,bntuin gw dunk,gw dah make ac web ultimate repack 7.5,trz pas bz login,milih realm,maw bkin char tlsannya conected mulu,trz ujung2nya disconect dah..
pdhl ga ada warning apa2 klo ad yg error2..
help me plizz...it pke core trinity jg,di readmenya gpg nyetingnya,trz tinggal maen...tapi..........
thx be4...