Rebirt system

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:

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;
}

---

add this under CString strSQL;:

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;
        }
        }

---

now under :

Code:

---

TCHAR g_szDB_UPDATE_CHAR_LEVEL[] = _T("{CALL spUpdateCharLevel (%d, %d)}");

---

add:

Code:

---

TCHAR g_szDB_UPDATE_CHAR_REBIRTH[] = _T("{CALL spRebirthCharLevel (%d, %d)}");

---

now in sql add this:

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. ?

Quote:

---

Originally Posted by secondary

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. ?