maap2 my bad, salah ketik itu yg saya liat item 50172 <== ini bukan S3 tapi Sanguine Silk Robes (ini yg ada di Hiver tapi tetep yg ngasih itu si CG)
Code:
mysql> select itementry, owner_guid, giftcreatorguid from item_instance where giftcreatorguid = 73477 and itementry = 50172; +-----------+------------+-----------------+
| itementry | owner_guid | giftcreatorguid |
+-----------+------------+-----------------+
| 50172 | 372159 | 73477 |
+-----------+------------+-----------------+
1 row in set (2.23 sec)
Ket :
- itementry = 50172 (Sanguine Silk Robes)
- owner_guid = 372159 (Hiver)
- giftcreatorguid = 73477 (CG)
Nah untuk si albarn :
Code:
mysql> select guid, name, class from characters where name like 'albarn';
+------+--------+-------+
| guid | name | class |
+------+--------+-------+
| 933 | Albarn | 5 |
+------+--------+-------+
1 row in set (0.00 sec)
mysql> select itementry, owner_guid, giftcreatorguid from item_instance where giftcreatorguid = 73477 and itementry = 50173; +-----------+------------+-----------------+
| itementry | owner_guid | giftcreatorguid |
+-----------+------------+-----------------+
| 50173 | 933 | 73477 |
+-----------+------------+-----------------+
1 row in set (2.22 sec)
ket :
- sama dengan diatas, kecuali itementry 50173 (ini baru S3)
sekali lagi saya mohon maaf sebesar2nya untuk pemilik char Hiver
