How do i find itemids?

[ihamjang]

i don't know how do i find te itemtype

can you show me?
or give me a list of items
thanks a lot for help

 

[terrorofdeath]

http://forum.ragezone.com/f514/v1-2-complete-pangya-setup-719617/

You can find a list of character equipment itemid in your own database:

7c. Give an Account a Single Item

• Open the PyServer Repack.v2.rar and open the folder Admin Procedures in it.
• Double click the Add Item Procedure.sql file. This opens a query in SMS.
• Execute the querry.
• Databases → Pangya_S4_TH → INI3Bill_DB → Stored Procedures
• Right Click on "dbo.TSU_AddItemToUser" and choose "Execute Stored Procedure..."
  • @user_id: The user ID used to log into the game of the account you wish to add the item to.
  • @item_id: The item ID of the item you wish to add.
    • You can find a list of most items in your database.
    • Pangya_S4_TH → Tables
    • Right Click on "dbo.PANGYA_ITEM_TYPELIST" and choose "Select Top 100 Rows".
    • A query will appear and execute. Change it to say "SELECT TOP 5000 [TYPEID]".
    • Execute the procedure. A table will appear with item IDs and item descriptions you can use for reference.
  • Hit OK to execute the procedure.

 

[ihamjang]

http://forum.ragezone.com/f514/v1-2-complete-pangya-setup-719617/

You can find a list of character equipment itemid in your own database:

thanks you man!

 

[X_Sarah_X]

I have attached a textfile with all the items that are in the database delivered with the server files.

This list contains all the item names and IDs.
For some reason the names have a limit on the amount of characters, but it's easy to figure it out

 

[ihamjang]

I have attached a textfile with all the items that are in the database delivered with the server files.

This list contains all the item names and IDs.
For some reason the names have a limit on the amount of characters, but it's easy to figure it out

thanks you very much

excuse me,

do you have ids item of club sets? balls? and cardpack?
thanks you

 

[burningchr0me]

do you have ids item of club sets? balls? and cardpack?
thanks you

There are some with messed up looking names, but they are different languages, and I didn't track down how to convert them from hex yet. These are pulled from the .iff files:

Cards.iff:

Spoiler

Nuri (Normal) 2080374784
Nuri (Rare) 2080374785
Nuri (S.Rare) 2080374786
Nuri (S.Rare) 2080374787
Hana (Normal) 2080374788
Hana (Rare) 2080374789
Hana (S.Rare) 2080374790
Hana (Secret) 2080374791
Arthur (Normal) 2080374792
Arthur (Rare) 2080374793
Arthur (S.Rare) 2080374794
Arthur (Secret) 2080374795
Kooh (Normal) 2080374796
Kooh (Rare) 2080374797
Kooh (S.Rare) 2080374798
Kooh (Secret) 2080374799
Cesillia (Normal) 2080374800
Cesillia (Rare) 2080374801
Cesillia (S.Rare) 2080374802
Cesillia (Secret) 2080374803
Max (Normal) 2080374804
Max (Rare) 2080374805
Max (S.Rare) 2080374806
Max (Secret) 2080374807
Arin (Normal) 2080374808
Arin (Rare) 2080374809
Arin (S.Rare) 2080374810
Arin (Secret) 2080374811
Kaz (Normal) 2080374812
Kaz (Rare) 2080374813
Kaz (S.Rare) 2080374814
Kaz (Secret) 2080374815
Lucia (Normal) 2080374816
Lucia (Rare) 2080374817
Nuri (Normal) 2080374818
Max (Rare) 2080374819
Cesillia (Normal) 2080374820
Kooh (Normal) 2080374821
Arin (Normal) 2080374822
Kaz (Normal) 2080374823
Bongdari (Normal) 2084569088
Bongdari (Rare) 2084569089
Bongdari (S.Rare) 2084569090
Bongdari (Secret) 2084569091
Pippin (Normal) 2084569092
Pippin (Normal) 2084569093
Pippin (S.Rare) 2084569094
Pippin (Secret) 2084569095
Titan Boo (Rare) 2084569096
Titan Boo (S.Rare) 2084569097
Titan Boo (Secret) 2084569098
Titan Boo (Normal) 2084569099
Dolphini (Normal) 2084569100
Dolphini (Rare) 2084569101
Dolphini (S.Rare) 2084569102
Dolphini (Secret) 2084569103
Lolo (Normal) 2084569104
Lolo (Rare) 2084569105
Lolo (S.Rare) 2084569106
Lolo (Secret) 2084569107
Kuma (Normal) 2084569108
Kuma (Rare) 2084569109
Kuma (S.Rare) 2084569110
Kuma (Secret) 2084569111
Cadie (S.Rare) 2084569112
Cadie (Secret) 2084569113
Cadie (Secret) 2084569114
Bongdari (Normal) 2084569115
Pippin (Normal) 2084569116
Tiki (Normal) 2084569117
Tiki (Rare) 2084569118
Winkle Pippin (Normal) 2084569119
Winkle Pippin (Rare) 2084569120
Cadie (Rare) 2084569121
Basic Training 2088763392
Swing Training 2088763393
Training 2088763394
Black Jerry Mind 2088763395
Black Jerry Heart 2088763396
Black Jerry Soul 2088763397
White Jerry Mind 2088763398
White Jerry Heart 2088763399
White Jerry Soul 2088763400
ｶﾘｧ・ｧﾔｹｻﾑｧ (・ﾅ・｡) 2088763401
ｶﾘｧ・ｧﾔｹｻﾑｧ (｡ﾅﾒｧ) 2088763402
ｶﾘｧ・ｧﾔｹｻﾑｧ (・ﾋｭ・) 2088763403
Pippin`s Time 2088763404
Pippin`s Time 2 2088763405
Cadie`s Magic 2088763406
Cadie`s Magic 2 2088763407
Tiki`s Blessing 2088763408
Tiki`s Blessing 2 2088763409
Dolphini`s Trick 2088763410
Dolphini`s Trick 2 2088763411
Kuma`s Support 2088763412
Kuma`s Support 2 2088763413
Assistance Caddie 2088763414
Stamina Pack 2088763415
Billy`s Bag 2088763416
Billy`s Bag 2 2088763417
Rainbow Feather 2088763418
Sepia Wind 2088763419
Wind Hill 2088763420
Pink Wind 2088763421
Blue Moon 2088763422
Pang bag(small) 2088763423
Elf Ear 2088763424
Treasure Hunter 2088763425
Intermediate Training 2088763426
Black Jerry Mind 2088763427
White Jerry Mind 2088763428
Dolphini's Umbrella 2088763429
Orihakon 2088763430
Pangya Card Pack No.1 2092957696
Golden Card Ticket 2092957697
Silver Card Ticket 2092957698
Bronze card ticket 2092957699
Pangya Card Pack No.2 2092957700
Pangya Card Box No.2 2097152001

Club.iff

Spoiler

Air Knight Wood 201326592
Air Knight Iron 201326593
Air Knight Wedge 201326594
Air Knight Putter 201326595
Air Knight2 Wood 201326596
Air Knight2 Iron 201326597
Air Knight2 Wedge 201326598
Air Knight2 Putter 201326599
Baseball bat Wood 201326600
Baseball bat Iron 201326601
Baseball bat Wedge 201326602
Bessball bat Putter 201326603
Challenge Set Wood 201326604
Challenge Set Iron 201326605
Challenge Set Wedge 201326606
Challenge Set Putter 201326607
Family Wood 201326608
Family Iron 201326609
Family Wedge 201326610
Family Putter 201326611
After Burner Wood 201326612
After Burner Iron 201326613
After Burner Wedge 201326614
After Burner Putter 201326615
SE-93 After Burner Wood 201326616
SE-93 After Burner Iron 201326617
SE-93 After Burner Wedge 201326618
SE-93 After Burner Putter 201326619
Spike Hammer Wood 201326620
Spike Hammer Iron 201326621
Spike Hammer Wedge 201326622
Spike Hammer Putter 201326623
Dual Feather Wood 201326624
Dual Feather Iron 201326625
Dual Feather Wedge 201326626
Dual Feather Putter 201326627
Pico Hammer Wood 201326628
Pico Hammer Iron 201326629
Pico Hammer Wedge 201326630
Pico Hammer Putt 201326631
Umbrella Wood 201326632
Umbrella Iron 201326633
Umberlla Wedge 201326634
Umberlla Putt 201326635
Air Knight 3 Wood 201326636
Air Knight 3 Iron 201326637
Air Knight 3 Wedge 201326638
Air Knight 3 Putter 201326639
G. Dual Feather Wood 201326640
G. Dual Feather Iron 201326641
G. Dual Feather Wedge 201326642
G. Dual Feather Putter 201326643
Magic Club Wood 201326644
Magic Club Iron 201326645
Magic Club Wedge 201326646
Magic Club Putter 201326647
Wooden Sword Wood 201326648
Wooden Sword Iron 201326649
Wooden Sword Wedge 201326650
Wooden Sword Putter 201326651
Mythril Sword Wood 201326652
Mythril Sword Iron 201326653
Mythril Sword Wedge 201326654
Mythril Sword Putter 201326655
Black Sword Wood 201326656
Black Sword Iron 201326657
Black Sword Wedge 201326658
Black Sword Putter 201326659
Microphone Wood 201326660
Microphone Iron 201326661
Microphone Wedge 201326662
Microphone Putter 201326663
Xmas Set Wood 201326664
Xmas Set Iron 201326665
Xmas Set Wedge 201326666
Xmas Set Putter 201326667
Air Knight Lucky Wood 201326668
Air Knight Lucky Iron 201326669
Air Knight Lucky Wedge 201326670
Air Knight Lucky Putter 201326671
Halloween Wood 201326672
Halloween Iron 201326673
Halloween Wedge 201326674
Halloween Putter 201326675
Chocolet Wood 201326676
Chocolet Iron 201326677
Chocolet Wedge 201326678
Chocolet Putter 201326679
Golden Air Knight Wood 201326680
Golden Air Knight Iron 201326681
Golden Air Knight Wedge 201326682
Golden Air Knight Putter 201326683
??????? ?? 201326688
??????? ??? 201326689
??????? ?? 201326690
??????? ?? 201326691
Merry Xmas Set Wood 201326692
Merry Xmas Set Iron 201326693
Merry Xmas Set Wedge 201326694
Merry Xmas Set Putter 201326695
Cat Hand Wood 201326696
Cat Hand Iron 201326697
Cat Hand Wedge 201326698
Cat Hand Putter 201326699
Golden Spike Hammer Wood 201326720
Golden Spike Hammer Iron 201326721
Golden Spike Hammer Wedge 201326722
Golden Spike Hammer Putter 201326723
????? ?? 201326724
????? ??? 201326725
????? ?? 201326726
????? ?? 201326727
Dark Platinum Wood 201326728
Dark Platinum Iron 201326729
Dark Platinum Wedge 201326730
Dark Platinum Putter 201326731
?? ????? ?? 201326762
?? ??? 201326763
?? ????? ?? 201326764
?? ????? ?? 201326765
Soul Reaper Woods 201326766
Soul Reaper Irons 201326767
Soul Reaper Wedges 201326768
Soul Reaper Putters 201326769
Soul Master Woods 201326774
Soul Master Irons 201326775
Soul Master Wedges 201326776
Soul Master Putters 201326777
Golden Air Knight Wood 2 201326778
Golden Air Knight Iron 2 201326779
Golden Air Knight Wedge 2 201326780
Golden Air Knight Putter 2 201326781
Candy Club Wood 201326782
Candy Club Iron 201326783
Candy Club Wedge 201326784
Candy Club Putter 201326785
Siam Golden Club Wood 201326798
Siam Golden Club Iron 201326799
Siam Golden Club Wedge 201326800
Siam Golden Club Putter 201326801
Crystal Air Night Wood 201326810
Crystal Air Knight Irons 201326811
Cristal Air Night Wedge 201326812
Cristal Air Night Putters 201326813
Leek Club Wood 201326700
Leek Club Irons 201326701
Leek Club Wedges 201326702
Leek Club Putters 201326703

Clubset.iff

Spoiler

Air Knight Set 268435456
Air Knight II Set 268435457
Baseball bat Set 268435458
Family Set 268435459
Spike Hammer Set 268435460
SY Afterburner Set 268435461
SE Afterburner Set 268435462
Dual Feather Set 268435463
Pico Hammer Set 268435464
Umbrella Set 268435465
Air Knight III 268435466
G.Dual Feather Set 268435467
Magical Stick Set 268435468
Wooden Sword Set 268435469
Mythril Sword Set 268435470
Black Sword Set 268435471
Microphone Set 268435472
Xmas Club Set 268435473
Air Knight Lucky Set 268435474
Halloween Set 268435475
Chocolate Club Set 268435476
Golden Air Knight Set 268435477
?????????? 268435479
2007 Xmas Club set 268435480
Cat Hand Club set 268435481
????? ?? 268435483
Dark Platinum Set 268435484
Ruby Air Knight Set 268435494
Soul Reaper Set 268435495
Soul Master Set 268435497
Golden Air Knight Mk.II 268435498
Candy Club Set 268435499
Siam Golden Club Set 268435505
Crystal Air Night Club Set 268435508
Golden Air Knight Mk. III 268435510
Golden S.Hammer 268435584
Leek Club Set 268435482

Ball.iff

Spoiler

Aztec 335544320
Bomber 335544321
Blue Star 335544322
Love Love 335544323
Afro Aztec 335544324
Water Aztec 335544325
Firework Aztec 335544326
G-Star Aztec 335544327
Fortune Aztec 335544328
Fortune Aztec (Gift) 335544329
Christmas 335544330
HG Aztec (JP) 335544331
Clover Aztec 335544332
Blue Star Aztec (Gift) 335544333
2nd Anniversary Aztec 335544334
Blue Aztec(PH) 335544335
Clover Aztec 335544336
Aztec Winning Ball 335544337
Aztec Soccer Ball 335544338
Blue Star (Gift)(PH) 335544339
?????????? ???(BRS) 335544340
?????(USA) 335544341
Watermelon Aztec 335544342
??????? ??? (JP) 335544343
FFL Love Aztec (PH) 335544344
WCG2006 Aztec 335544345
Halloween Aztec 335544346
Pumpkin Aztec (Gift) 335544347
???????(JP) 335544348
?????(JP) 335544349
Sakura Aztec 335544350
3rd Anniversary Aztec 335544351
Rainbow Aztec 335544352
??????(CN) 335544353
Chocolate Aztec 335544354
??????_??(JPN) 335544355
??????_??(JPN) 335544356
??????_???(JPN) 335544358
??????_???(JPN) 335544359
??????_??(JPN) 335544360
??????_??(JPN) 335544361
??????_?(JPN) 335544362
??????_??(JPN) 335544363
??????(TW) 335544364
Halloween Skull Aztec 335544369
Halloween Skull Aztec 335544370
4th Anniversary Aztec 335544371
Canna Aztec 335544372
Talk Play Love ??? 335544374
??? ??? 335544375
??? ??? 335544376
????? ??? 335544377
?????? ??? 335544378
Chihuahua Aztec 335544379
Light Aztec 335544380
Shadow Aztec 335544381
Tiger Aztec 335544384
Kooh Aztec 335544385
Hana Aztec 335544387
Cesillia Aztec 335544391
Lucia Birthday Aztec 335544392
Nuri Aztec 335544397
Arin Aztec 335544398
Arthur Birthday Aztec 335544399
Together Love Dad Aztec 335544401
Kaz Birthday Aztec 335544402
Water Aztec 335544448
Bomber 335544449
Bomber 335544450
Love Love 335544451
Love Love 335544452
2???????(ID) 335544453
LoveMom Aztec 335544454
Wooo Hooo Aztec 335544455
Smiling Goblin Aztec 335544465
TGS Aztec 335544489
Red Cross Aztec 335544490
We love Thai Aztec 335544491
5th Anniversary Aztec 335544493
2010 WC Aztec 335544495

 

[ihamjang]

burningchr0me

oH thanks you but
i forget
about

etc items, such as boost time, mascot and silent wind
thanks you:O:!