Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Can someone teach me how to modify this database? Thank you!

Newbie Spellweaver
Joined
May 12, 2022
Messages
85
Reaction score
2
When I added the appearance change and the old and new glow changes to the source,

[DbManagerSave.cpp]:
#ifdef __LOOKCHANGE
",%d"
#endif
#ifdef __SWITCH_GLOW_OLDNEW
",%d"
#endif // __SWITCH_GLOW_OLDNEW
#ifdef __LOOKCHANGE
, pItemElem->GetLook()
#endif
#ifdef __SWITCH_GLOW_OLDNEW
, pItemElem->m_bGlowOld
#endif // __SWITCH_GLOW_OLDNEW

But how should I modify the database, or what values should I add to the database? Can someone teach me, I haven't found a way to modify it for a long time! Thank you so much.



How do I add this ",%d" to the database?
 
Inactive
Joined
Jan 20, 2009
Messages
1,015
Reaction score
1,830
You would need to update m_Inventory in BASE_VALUE_TBL.

This would also only work for old chars not new ones.
 
Upvote 0
Newbie Spellweaver
Joined
May 12, 2022
Messages
85
Reaction score
2
USE CHARACTER_01_DBFGOUPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-322033766,0,0,0,0,0,0,0,1,0/1,2801,0,0,,1,0,-1,0,0,0,-1981991882,0,0,0,0,0,0,0,1,0/2,4805,0,0,,5,0,-1,0,0,0,1215878883,0,0,0,0,0,0,0,1,0/6,502,0,0,,1,0,9000000,0,0,0,-818549536,0,0,0,0,0,-1,0,1,0/169,510,0,0,,1,0,4500000,0,0,0,505042330,0,0,0,0,0,-1,0,1,0/172,21,0,0,,1,0,7200000,0,0,0,-1944939863,0,0,0,0,0,-1,0,0,0/173,506,0,0,,1,0,5850000,0,0,0,-1119756572,0,0,0,0,0,-1,0,1,0/$' 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_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'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'GOUPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0,0,0,1,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0,0,0,1,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0,0,0,1,0/3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1,0,0,0/170,508,0,0,,1,0,5850000,0,0,0,-385612173,0,0,0,0,0,-1,0,1,0/171,504,0,0,,1,0,9000000,0,0,0,903262398,0,0,0,0,0,-1,0,1,0/173,512,0,0,,1,0,4500000,0,0,0,955505939,0,0,0,0,0,-1,0,1,0/$' WHERE g_nSex = '1'UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/169/172/6/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/171/-1/170/173/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/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/4/172/170/5/173/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 = '1'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 = '1'GO


I have added a weapon level system and a new and old radiance change system, how do I update this database script?
 
Upvote 0
Experienced Elementalist
Joined
Jan 7, 2020
Messages
257
Reaction score
97
use character_01_dbfgoupdate base_value_tbl set m_inventory = '0,2800,0,0,,3,0,-1,0,0,0,-322033766,0,0,0,0,0,0,0,1,0/1,2801,0,0,,1,0,-1,0,0,0,-1981991882,0,0,0,0,0,0,0,1,0/2,4805,0,0,,5,0,-1,0,0,0,1215878883,0,0,0,0,0,0,0,1,0/6,502,0,0,,1,0,9000000,0,0,0,-818549536,0,0,0,0,0,-1,0,1,0/169,510,0,0,,1,0,4500000,0,0,0,505042330,0,0,0,0,0,-1,0,1,0/172,21,0,0,,1,0,7200000,0,0,0,-1944939863,0,0,0,0,0,-1,0,0,0/173,506,0,0,,1,0,5850000,0,0,0,-1119756572,0,0,0,0,0,-1,0,1,0/$' 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_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'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'goupdate base_value_tbl set m_inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0,0,0,1,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0,0,0,1,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0,0,0,1,0/3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1,0,0,0/170,508,0,0,,1,0,5850000,0,0,0,-385612173,0,0,0,0,0,-1,0,1,0/171,504,0,0,,1,0,9000000,0,0,0,903262398,0,0,0,0,0,-1,0,1,0/173,512,0,0,,1,0,4500000,0,0,0,955505939,0,0,0,0,0,-1,0,1,0/$' where g_nsex = '1'update base_value_tbl set m_apindex = '0/1/2/174/169/172/6/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/171/-1/170/173/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' where g_nsex = '1'update base_value_tbl set m_dwobjindex = '0/1/2/178/173/178/6/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/4/172/170/5/173/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 = '1'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 = '1'go


i have added a weapon level system and a new and old radiance change system, how do i update this database script?

Don't copy paste, use your own values. But the script should work.
Code:
USE CHARACTER_01_DBF
GO
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_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'
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'
GO
UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/170,508,0,0,,1,0,5850000,0,0,0,-385612173,0,0,0,0,0,-1/171,504,0,0,,1,0,9000000,0,0,0,903262398,0,0,0,0,0,-1/173,512,0,0,,1,0,4500000,0,0,0,955505939,0,0,0,0,0,-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/169/172/6/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/171/-1/170/173/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/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/4/172/170/5/173/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 = '1'
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 = '1'
GO
 
Upvote 0
Newbie Spellweaver
Joined
May 12, 2022
Messages
85
Reaction score
2
This script you sent is K18, the same one I use now, I need to update it to match the weapon level system and the glow replacement system, but thank you for the answer



Don't copy paste, use your own values. But the script should work.
Code:
USE CHARACTER_01_DBF
GO
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_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'
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'
GO
UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/170,508,0,0,,1,0,5850000,0,0,0,-385612173,0,0,0,0,0,-1/171,504,0,0,,1,0,9000000,0,0,0,903262398,0,0,0,0,0,-1/173,512,0,0,,1,0,4500000,0,0,0,955505939,0,0,0,0,0,-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/169/172/6/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/171/-1/170/173/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'
UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/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/4/172/170/5/173/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 = '1'
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 = '1'
GO
This script you sent is K18, the same one I use now, I need to update it to match the weapon level system and the glow replacement system, but thank you for the answer
 
Upvote 0
Newbie Spellweaver
Joined
Feb 28, 2022
Messages
39
Reaction score
10
In your original database file you will find the area of code that CREATES the base value table. You will want to add a new variable in the same order that the cpp code is calling for. Read through it well.
 
Upvote 0
Junior Spellweaver
Joined
May 13, 2020
Messages
106
Reaction score
3
In your original database file you will find the area of code that CREATES the base value table. You will want to add a new variable in the same order that the cpp code is calling for. Read through it well.

Code:
UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,-1665507005,0,0,0,0,0,-1/170,508,0,0,,1,0,5850000,0,0,0,-385612173,0,0,0,0,0,-1/171,504,0,0,,1,0,9000000,0,0,0,903262398,0,0,0,0,0,-1/173,512,0,0,,1,0,4500000,0,0,0,955505939,0,0,0,0,0,-1/$' WHERE g_nSex = '1'UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/169/172/6/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/171/-1/170/173/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1'UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/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/4/172/170/5/173/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 = '1'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 = '1'
Is this the basic value you mentioned? Or you can tell us exactly. No, and how to delete the basic value
 
Upvote 0
Newbie Spellweaver
Joined
May 12, 2022
Messages
85
Reaction score
2
INSERT [dbo].[BASE_VALUE_TBL] ([g_nSex], [m_vScale_x], [m_dwMotion], [m_fAngle], [m_nHitPoint], [m_nManaPoint], [m_nFatiguePoint], [m_dwRideItemIdx], [m_dwGold], [m_nJob], [m_pActMover], [m_nStr], [m_nSta], [m_nDex], [m_nInt], [m_nLevel], [m_nExp1], [m_nExp2], [m_aJobSkill], [m_aLicenseSkill], [m_aJobLv], [m_dwExpertLv], [m_idMarkingWorld], [m_vMarkingPos_x], [m_vMarkingPos_y], [m_vMarkingPos_z], [m_nRemainGP], [m_nRemainLP], [m_nFlightLv], [m_nFxp], [m_nTxp], [m_lpQuestCntArray], [m_chAuthority], [m_dwMode], [blockby], [TotalPlayTime], [isblock], [m_Inventory], [m_apIndex], [m_adwEquipment], [m_aSlotApplet], [m_aSlotItem], [m_aSlotQueue], [m_SkillBar], [m_dwObjIndex], [m_Card], [m_Cube], [m_apIndex_Card], [m_dwObjIndex_Card], [m_apIndex_Cube], [m_dwObjIndex_Cube], [m_idparty], [m_nNumKill], [m_idMuerderer], [m_nSlaughter], [m_nFame], [m_nDeathExp], [m_nDeathLevel], [m_dwFlyTime], [m_nMessengerState], [m_Bank], [m_apIndex_Bank], [m_dwObjIndex_Bank], [m_dwGoldBank]) VALUES (N'0', 1, 0, 0, 230, 63, 32, 0, 0, 0, N'0,0', 15, 15, 15, 15, 1, 0, 0, N'0,1,1,1/0,1,2,1/0,1,3,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/$', N'0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/$', N'1/1/1/1/1/1/1/1/1/1/1/1/1/1/1/1/$', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'$', N'F', 268566528, NULL, 0, N'F', N'0,502,0,0,,1,0,9000000,0,0,0,0,0/1,2801,0,0,,1,0,0,0,0,0,0,0/2,4805,0,0,,5,0,0,0,0,0,0,0/42,506,0,0,,1,0,5850000,0,0,0,0,0/43,510,0,0,,1,0,4500000,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,0,0/45,2800,0,0,,3,0,0,0,0,0,0,0/$', N'45/1/2/3/4/5/6/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/-1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$', N'-1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$', N'2,2,2010,0,2,0,0/3,2,581,0,3,0,0/4,3,25,0,4,0,0/$', N'0,0,5,45,0,0,0,1/0,1,5,1,0,1,0,1/0,2,3,3,0,2,0,1/0,8,3,2,0,8,0,1/$', N'$', 0, N'44/1/2/3/4/5/6/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/46/47/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$', N'$', N'$', N'5/36/37/38/39/40/41/$', N'0/1/2/3/4/5/6/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/$', N'0/1/2/3/4/5/6/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/$', N'0/1/2/3/4/5/6/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/$', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'$', N'$', N'$', 0)
INSERT [dbo].[BASE_VALUE_TBL] ([g_nSex], [m_vScale_x], [m_dwMotion], [m_fAngle], [m_nHitPoint], [m_nManaPoint], [m_nFatiguePoint], [m_dwRideItemIdx], [m_dwGold], [m_nJob], [m_pActMover], [m_nStr], [m_nSta], [m_nDex], [m_nInt], [m_nLevel], [m_nExp1], [m_nExp2], [m_aJobSkill], [m_aLicenseSkill], [m_aJobLv], [m_dwExpertLv], [m_idMarkingWorld], [m_vMarkingPos_x], [m_vMarkingPos_y], [m_vMarkingPos_z], [m_nRemainGP], [m_nRemainLP], [m_nFlightLv], [m_nFxp], [m_nTxp], [m_lpQuestCntArray], [m_chAuthority], [m_dwMode], [blockby], [TotalPlayTime], [isblock], [m_Inventory], [m_apIndex], [m_adwEquipment], [m_aSlotApplet], [m_aSlotItem], [m_aSlotQueue], [m_SkillBar], [m_dwObjIndex], [m_Card], [m_Cube], [m_apIndex_Card], [m_dwObjIndex_Card], [m_apIndex_Cube], [m_dwObjIndex_Cube], [m_idparty], [m_nNumKill], [m_idMuerderer], [m_nSlaughter], [m_nFame], [m_nDeathExp], [m_nDeathLevel], [m_dwFlyTime], [m_nMessengerState], [m_Bank], [m_apIndex_Bank], [m_dwObjIndex_Bank], [m_dwGoldBank]) VALUES (N'1', 1, 0, 0, 230, 63, 32, 0, 0, 0, N'0,0', 15, 15, 15, 15, 1, 0, 0, N'0,1,1,1/0,1,2,1/0,1,3,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/0,1,-1,1/$', N'0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/0,0,0,1/$', N'1/1/1/1/1/1/1/1/1/1/1/1/1/1/1/1/$', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'$', N'F', 268566528, NULL, 0, N'F', N'0,504,0,0,,1,0,9000000,0,0,0,0,0/1,2801,0,0,,1,0,0,0,0,0,0,0/2,4805,0,0,,5,0,0,0,0,0,0,0/42,508,0,0,,1,0,5850000,0,0,0,0,0/43,512,0,0,,1,0,4500000,0,0,0,0,0/44,21,0,0,,1,0,7200000,0,0,0,0,0/45,2800,0,0,,3,0,0,0,0,0,0,0/$', N'45/1/2/3/4/5/6/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/-1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/$', N'-1/-1/0/-1/42/43/-1/-1/-1/-1/44/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$', N'2,2,2010,0,2,0,0/3,2,581,0,3,0,0/4,3,25,0,4,0,0/$', N'0,0,5,45,0,0,0,1/0,1,5,1,0,1,0,1/0,2,3,3,0,2,0,1/0,8,3,2,0,8,0,1/$', N'$', 0, N'44/1/2/3/4/5/6/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/46/47/52/0/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$', N'$', N'$', N'5/36/37/38/39/40/41/$', N'0/1/2/3/4/5/6/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/$', N'0/1/2/3/4/5/6/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/$', N'0/1/2/3/4/5/6/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/$', 0, 0, 0, 0, 0, 0, 0, 0, 0, N'$', N'$', N'$', 0)


This is the base value of K18.3
 
Upvote 0
Back
Top