BASE_VALUE MODIFICATION

12/07/2020 11:55 Tamus#1

Anyone have database script og base_value ? i want to create a base value., example when i create new character they have complete set and weapon with upgraded armor and weapon.,

anyone can give me a script?

thanks in advance

12/07/2020 18:39 aqwp#2

1. Create 1 male and 1 female character, check characters m_idPlayer in Db.

2. Set the characters how you want the characters to be (Inventory, Equipment).

2. Use this to check their current base value:

Code:

SELECT g_nSex, m_Inventory, m_apIndex, m_adwEquipment, m_dwObjIndex from BASE_VALUE_TBL

3. Update the values on the code below with current base value for Male.

Code:

UPDATE BASE_VALUE_TBL SET m_Inventory = '' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_apIndex = '' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_adwEquipment = '' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '' WHERE g_nSex = 0

4. Update the values on the code below with current base value for Female.

Code:

UPDATE BASE_VALUE_TBL SET m_Inventory = '' WHERE g_nSex = 1
UPDATE BASE_VALUE_TBL SET m_apIndex = '' WHERE g_nSex = 1
UPDATE BASE_VALUE_TBL SET m_adwEquipment = '' WHERE g_nSex = 1
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '' WHERE g_nSex = 1

Well done, every new male & female character will be the same as the characters you filled above.

-- Edit

Ofcourse: USE CHARACTER_01_DBF

12/08/2020 15:36 Tamus#3

UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-322033766,0,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,-1981991882,0,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,1215878883,0,0,0,0,0,0/6,502,0,0,,1,0,9000000,0,0,0,-818549536,0,0,0,0,0,-1/169,510,0,0,,1,0,4500000,0,0,0,505042330,0,0,0,0,0 ,-1/172,21,0,0,,1,0,7200000,0,0,0,-1944939863,0,0,0,0,0,-1/173,506,0,0,,1,0,5850000,0,0,0,-1119756572,0,0,0,0,0,-1/$' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/170/171/3/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/-1/-1/6/-1/173/169/-1/-1/-1/-1/172/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_adwEquipment = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$' WHERE g_nSex = 0
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/6/173/178/170/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/170/173/4/5/178/172/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = 0

something like this right?