Saludos gente de TSM

Voy hacer breve ya es muy tarde y quiero dormir.

Versión original:

https://github.com/nicomuratona/MuEmu-0.97k-kayito/tree/master-mysql

POST:
Files MuEmu 0.97k ORIGINAL + FULL SOURCE - kayito

Mi Versión Basada en MySQL (la que prefiero):

Update 1:

- Add InfinityArrow.
- Add command READD.
- Add System Credit.
- Add CustomMonsterReward.
- CustomAttack.
- CustomPick.

Ya pasa a segundo plano la versión SQL Server, igual si desean que les trabaje esa versión le llegan el privado.

VIDEO:

LINK:



Salu2

Buen aporte. Si a más gente le interesa, puedo llegar a hacer un video explicando cómo integrar el sistema de MySQL a los files basados en MuEmu

void CQueryManager::BindParameterAsString(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
   this->m_SQLBindValue[(ParamNumber-1)] = SQL_NTS;

   SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_VARCHAR,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);


}

void CQueryManager::BindParameterAsBinary(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
this->m_SQLBindValue[(ParamNumber-1)] = ColumnSize;

SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_BINARY,SQL_VARBINARY,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);
}


how to convert it to mysql ?

convert ms sql to mysql database

Code: [Select]

void CQueryManager::BindParameterAsString(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
	this->m_SQLBindValue[(ParamNumber-1)] = SQL_NTS;

	SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_VARCHAR,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);
}

void CQueryManager::BindParameterAsBinary(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
	this->m_SQLBindValue[(ParamNumber-1)] = ColumnSize;

	SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_BINARY,SQL_VARBINARY,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);
}

how to convert it to mysql ?

You can view my QueryManager in the source code of the Github repository. Just switch to "master-mysql" branch and download everything or just enter in the JoinServer or DataServer QueryManager.cpp and QueryManager.h to see how i did it. (i used an external library to work with MySQL).

convert ms sql to mysql database

This only works with DataBase Schema but doesn't give you the Stored Procedures. I recommend you to use this to define the DataBase Schema and using some AI like ChatGPT to adapt each Stored Procedure one by one.

void CQueryManager::BindParameterAsString(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
   this->m_SQLBindValue[(ParamNumber-1)] = SQL_NTS;

   SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_CHAR,SQL_VARCHAR,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);


}

void CQueryManager::BindParameterAsBinary(int ParamNumber,void* InBuffer,int ColumnSize) // OK
{
this->m_SQLBindValue[(ParamNumber-1)] = ColumnSize;

SQLBindParameter(this->m_STMT,ParamNumber,SQL_PARAM_INPUT,SQL_C_BINARY,SQL_VARBINARY,ColumnSize,0,InBuffer,0,&this->m_SQLBindValue[(ParamNumber-1)]);
}


how to convert it to mysql ?

This is the code in muemu s6, how to convert it to mysql like you did

how to transfer databse of ss6 muemu to mysql