Who have for me Rebirth system for me ?
lvl : 99 rebirth lvl: 0
you have 50 Donator Coins
Printable View
Who have for me Rebirth system for me ?
lvl : 99 rebirth lvl: 0
you have 50 Donator Coins
I DID NOT TEST THIS becaus im having problems with my matchserver :glare:
search in MmatchDBMGR:
add this under CString strSQL;:Code:bool MMatchDBMgr::UpdateCharLevel(const int nCID, const int nLevel)
{
_STATUS_DB_START;
if (!CheckOpen()) return false;
CString strSQL;
try {
strSQL.Format(g_szDB_UPDATE_CHAR_LEVEL, nLevel, nCID);
m_DB.ExecuteSQL( strSQL );
}
catch(CDBException* e) {
ExceptionHandler(strSQL, e);
return false;
}
_STATUS_DB_END(14);
return true;
}
now under :Code:if(nLevel >= 99)
{
try {
strSQL.Format(g_szDB_UPDATE_CHAR_REBIRTH, nLevel, nCID);
m_DB.ExecuteSQL( strSQL );
}
catch(CDBException* e) {
ExceptionHandler(strSQL, e);
return false;
}
}
add:Code:TCHAR g_szDB_UPDATE_CHAR_LEVEL[] = _T("{CALL spUpdateCharLevel (%d, %d)}");
now in sql add this:Code:TCHAR g_szDB_UPDATE_CHAR_REBIRTH[] = _T("{CALL spRebirthCharLevel (%d, %d)}");
Code:USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spRebirthCharLevel] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* ·¹º§ ¾÷µ¥ÀÌÆ® */
ALTER PROC [dbo].[spRebirthCharLevel]
@Level smallint,
@CID int
AS
SET NOCOUNT ON
UPDATE Character
Set Level=0,DonatorPoints=50
WHERE CID=@CID
btw i dont know what your donator tables name is so i just did DonatorPoints=50
remember i didnt test this so im not sure if its gonna work 100%.
i will test after i fix my matchserver
Ok and where is php. ?
lol i tought you needed in c++ anyhow here it is for php :
http://forum.ragezone.com/f245/rebirth-system-814281/
next time use the search button
Morco Thanks :)
You have Vote sytem ? php. ?