1. _AvatarStart PROCEDURE

ÇALIŞMA MANTIĞI

ITEM OLUŞTURMA AKIŞI

• Slot kontrol edilir
• Item ID generate edilir
• _Items tablosuna yazılır
• _InventoryForAvatar içine eklenir

2. AUTO AVATAR SYSTEM (_AddNewChar)

MALE CHARACTER

FEMALE CHARACTER

SİSTEM ÖZETİ

ÖNEMLİ NOT

• RefCharID aralıkları server'a göre değişebilir
• Item ID'ler custom serverlara göre uyarlanmalıdır
• Procedure yanlış eklenirse character create hatası oluşabilir
• Backup almadan production server'a 적용 etmeyin

SONUÇ

admin' Alıntı:

Hello dear vSRO developers,


In this post, I'm sharing the vSRO AvatarStart stored procedure and the logic behind the automatic avatar dress-up (Auto Dress System) .


Thanks to this system:


Automatic avatar customization during character creation.
Providing different sets based on Male/Female distinction.
Slot-based item equip system
Full control via database.


can be provided.

---

1. _AvatarStart PROCEDURE

The following procedure is used to add an avatar item to a character:



CREATE PROCEDURE [dbo].[_AvatarStart]
@CharID int,
@Slot int,
@RefItemID int,
@Data int
AS

---

WORKING PRINCIPLES

✔ Checks if the slots are full.
✔ Generates a new item ID
✔ Performs inventory/chest duplicate checks.
✔ Writes the Item to the _Items table.
✔ Adds to avatar slot

---

ITEM CREATION FLOW

• Slot is checked
• Item ID is generated.
• It is written to the _Items table.
• It is added to _InventoryForAvatar

---

2. AUTO AVATAR SYSTEM (_AddNewChar)

This section is the automatic avatar assignment system when a character is created.

---

MALE CHARACTER

if @RefCharID <=14887 AND @RefCharID >=14875
OR @RefCharID<=1919 AND @RefCharID>=1907
BEGIN
exec _AvatarStart @NewCharID,0,22918,0 -- DRESS
exec _AvatarStart @NewCharID,1.22914,0 -- LINE
exec _AvatarStart @NewCharID,2.23962,0 -- ATTACH
END

---

FEMALE CHARACTER

if @RefCharID <=14900 AND @RefCharID >=14888
OR @RefCharID<=1932 AND @RefCharID>=1920
BEGIN
exec _AvatarStart @NewCharID,0,22919,0 -- DRESS
exec _AvatarStart @NewCharID,1.22915,0 -- LINE
exec _AvatarStart @NewCharID,2.23962,0 -- ATTACH
END

---

SYSTEM SUMMARY

✔ Character create → automatic avatar equip
✔ Separate item sets for Male and Female
✔ Slot-based equipment system
✔ Database controlled system

---

IMPORTANT NOTE

• RefCharID ranges may vary depending on the server.
• Item IDs must be adapted to custom servers.
• If the procedure is added incorrectly, a character creation error may occur.
• Don't try to deploy to the production server without creating a backup.

---

CONCLUSION

With this system:


✔ Automatic starting costume for players
✔ Premium starter experience
✔ Server branding (custom appearance)

You can provide it.
Hidden text: Cannot be quoted.

Genişletmek için tıkla ...