Skip to main content

​
Overview

The sdev-db library is the database agent service component for Shaiya Episode 6. It adds support for the character list packet (equipment) and the name availability packet.

​
Environment

​
Features

​
Character List Packet Support

The library enhances the character list functionality by including equipment data in the character selection screen packets. This allows the client to display character equipment during character selection.

​
Name Availability Packet

Implements name availability checking to validate character names before creation, preventing duplicate names and ensuring compliance with naming rules.

​
Stored Procedures

Database stored procedures are available at: sdev-db/bin/sql These procedures include:
  • Character list data retrieval with equipment
  • Name availability checking
  • Item Mall integration procedures
These stored procedures are original code. If you receive an error during installation, change ALTER to CREATE and try again.

​
Binary

The binary has been patched to fix a critical bug that causes item mall purchase duplicates.

​
Bug Fix: Item Mall Purchase Duplicates

The original code contained an error that would set a value to 1 instead of 0, causing duplicate purchases: 
00407942  mov dword ptr [ebx+8],1
Using the original unpatched binary may result in duplicate item purchases in the Item Mall. Always use the patched version from the repository.

​
Integration

The sdev-db library works in conjunction with the sdev game service library. Ensure that:
  1. The patched binary is deployed to your dbAgent service directory
  2. All stored procedures are installed in the appropriate databases
  3. The dbAgent service has proper database connectivity configured

sdev

Game service library with Item Mall, Battlefield Move, and more

sdev-login

Login service library with vulnerability patches

Build docs developers (and LLMs) love

Get started for freeTalk to us