[Release] Arena Score 1.2

Pumaaa

Einige Sachen sind nicht optimal , wenn nicht sogar grottenschlecht gelöst, aber es erfüllt seinen Zweck besser als die andern Scripts da draußen.

Ihr dürft gerne über die miserable Qualität lästern , jedoch wüsste ich nicht warum ich ein vollkommenes Produkt releasen sollte wenn ich eine Version davon hab mit der man Spaß am basteln haben kann :)

DATABASE:

dpTrans.cpp:

PHP

#ifdef __ARENA_SCORE
    ON_MSG( PACKETTYPE_ARENA_UPDATE, OnSendArenaScore ); 
    ON_MSG( PACKETTYPE_ARENA_GET, OnGetArenaScore );
#endif

PHP

#ifdef __ARENA_SCORE
void CDPTrans::OnGetArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize )
{
    LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus        = g_DbManager.AllocRequest();
    g_DbManager.MakeRequest( lpDbOverlappedPlus, lpBuf, uBufSize );
    lpDbOverlappedPlus->dpid    = dpid;
    lpDbOverlappedPlus->nQueryMode    = LOAD_ARENASCORE;
    PostQueuedCompletionStatus( g_DbManager.m_hIOCPPut, 1, NULL, &lpDbOverlappedPlus->Overlapped );
}


void CDPTrans::OnSendArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize )
{
    LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus        = g_DbManager.AllocRequest();
    g_DbManager.MakeRequest( lpDbOverlappedPlus, lpBuf, uBufSize );
    lpDbOverlappedPlus->dpid    = dpid;
    lpDbOverlappedPlus->nQueryMode = SAVE_ARENASCORE;
    PostQueuedCompletionStatus( g_DbManager.m_hIOCPPut, 1, NULL, &lpDbOverlappedPlus->Overlapped );
}


void CDPTrans::SendArenaScore( u_long idPlayer, int nAkill, int nAdeath )
{


    BEFORESENDDUAL( ar, PACKETTYPE_ARENA_GET, DPID_UNKNOWN, DPID_UNKNOWN );
    ar << idPlayer << nAkill << nAdeath;


    SEND( ar, this, DPID_ALLPLAYERS );
}
#endif

Alles anzeigen

dpTrans.h

PHP

#ifdef __ARENA_SCORE
void OnGetArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize );
void OnSendArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize );
void SendArenaScore( u_long idPlayer, int nAkill, int nAdeath );
#endif

DbManager.cpp

PHP

#ifdef __ARENA_SCORE
            case LOAD_ARENASCORE:
                LoadArenaScore( pQueryChar, lpDbOverlappedPlus );
                break;
            case SAVE_ARENASCORE:
                SaveArenaScore( pQueryChar, lpDbOverlappedPlus );
                break;
#endif

PHP

#ifdef __ARENA_SCORE
void CDbManager::LoadArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus )
{
    CAr arRead( lpDbOverlappedPlus->lpBuf, lpDbOverlappedPlus->uBufSize );
    
    u_long nidPlayer;
    int    nArenaKills; 
    int    nArenaDeaths;
    arRead >> nidPlayer;
    char szQuery[QUERY_SIZE] = {0,};
    sprintf( szQuery, "uspLoadArena @serverindex='%02d', @idPlayer='%07d' ",g_appInfo.dwSys, nidPlayer );    //can add arguments directly %s %d..
    //RUN QUERY


    




    //RUN QUERY
    if( FALSE == qry->Exec( szQuery ) )
    {
        WriteLog( "%s, %d\t%s", __FILE__, __LINE__, szQuery );


    }






            while( qry->Fetch() )
            {    
                    nArenaKills    =    qry->GetInt("nArenaKills");
                    nArenaDeaths    =    qry->GetInt("nArenaDeaths");
            }


    
    CDPTrans::GetInstance()->SendArenaScore( nidPlayer, nArenaKills, nArenaDeaths );


    FreeRequest( lpDbOverlappedPlus );
}


void CDbManager::SaveArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus )
{
    CAr arRead( lpDbOverlappedPlus->lpBuf, lpDbOverlappedPlus->uBufSize );
    
    u_long idPlayer;
    int    nArenaKills;
    int    nArenaDeaths;
    BOOL bCreate;
    arRead >> idPlayer >> nArenaKills >> nArenaDeaths >> bCreate;


    char szQuery[250] = {0,};
if( !bCreate )
    sprintf( szQuery, "uspSaveArena @serverindex='%02d', @idPlayer='%07d', @nArenaKills='%d', @nArenaDeaths='%d'", g_appInfo.dwSys, idPlayer, nArenaKills, nArenaDeaths );
else
    sprintf( szQuery, "TRUNCATE TABLE dbo.ArenaScore");




        if( FALSE == qry->Exec( szQuery ) )
        {
            WriteLog( "%s, %d\t%s", __FILE__, __LINE__, szQuery );
            FreeRequest( lpDbOverlappedPlus );
            return;
        }
    


    FreeRequest( lpDbOverlappedPlus );
}
#endif

Alles anzeigen

DbManager.h

PHP

#ifdef __ARENA_SCORE
    ,LOAD_ARENASCORE
    ,SAVE_ARENASCORE
#endif

PHP

#ifdef __ARENA_SCORE
void    LoadArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus );
void    SaveArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus );
#endif

CLIENT:

DpClient.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreClient.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
            case SNAPSHOTTYPE_ARENA_UPDATE: OnArenaUpdate( ar ); break;
#endif

PHP

#ifdef __ARENA_SCORE
void CDPClient::OnArenaUpdate( CAr & ar )
{
    int nCount;
    
    ar >> nCount;
    
    g_ArenaScore.m_vecUserInfo.clear();


    for( int i=0; i<nCount; i++)
    {
        ARENA_INFO tmpInfo;
        ar.ReadString( tmpInfo.szName );
        ar >> tmpInfo.nKills;        
        ar >> tmpInfo.nDeaths;
        ar >> tmpInfo.nPoints;
        ar >> tmpInfo.nKills2;
        ar >> tmpInfo.nDeaths2;
        ar >> tmpInfo.nLevel;


        g_ArenaScore.m_vecUserInfo.push_back( tmpInfo );
    }
    


}


#endif

Alles anzeigen

DPClient.h

PHP

#ifdef __ARENA_SCORE
    void    OnArenaUpdate( CAr & ar );
#endif

Neuz.cpp

PHP

#ifdef __ARENA_SCORE
    m_pHeroIconArena = NULL;
#endif

PHP

#ifdef __ARENA_SCORE
    m_pHeroIconArena = CWndBase::m_textureMng.AddTexture( g_Neuz.m_pd3dDevice, MakePath( DIR_ICON, "icon_ArenaMvp.png"), 0xffff00ff );
#endif

Neuz.h

PHP

#ifdef __ARENA_SCORE
    CTexture*                m_pHeroIconArena;
#endif

FuncTextCmd.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif
#endif    // __WORLDSERVER

PHP

BOOL TextCmd_ArenaAllout( CScanner& scanner )  
{ 
#ifdef __WORLDSERVER
#ifdef __ARENA_SCORE
            g_ArenaScore.m_nRemainTime = ::timeGetTime();
            g_ArenaScore.KickOut();
#endif
#endif
            return TRUE;
}

PHP

#ifdef __ARENA_SCORE
    ON_TEXTCMDFUNC( TextCmd_ArenaAllout,           "AlloutArena",              "aoa",             "½Ã°£",           "½Ã",      TCM_SERVER, AUTH_GAMEMASTER      , "½Ã°£ º¸±â [/½Ã°£]" )
#endif

WndWorld.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreClient.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
    g_ArenaScore.WorldDrawer(p2DRender);
#endif

PHP

#ifdef __ARENA_SCORE
        if( nChar == VK_TAB )
            g_ArenaScore.m_bDraw = !g_ArenaScore.m_bDraw;
#endif

Mover.cpp

PHP

#ifdef __ARENA_SCORE
#include "..\WORLDSERVER\ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __WORLDSERVER
#ifdef __ARENA_SCORE
            if( GetWorld()->IsArena() && IsPlayer() )
                g_ArenaScore.ArenaOnKillHook((CUser*)pAttacker,(CUser*)this);
#endif    // __ARENA_SCORE
#endif

MoverRender.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreClient.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
            //Arena Score
        if( GetWorld()->IsArena() && !strcmp( m_szName , g_ArenaScore.m_vecUserInfo[0].szName) )
        {
                    pTexture = g_Neuz.m_pHeroIconArena;
                    if( pTexture )
                    {
                        long oldpointx=point.x;
                        long oldpointy=point.y;
                        point.y -= pTexture->m_size.cy + 5;
                        point.y = point.y+1;
                        //point.x = point.x + 15;
                        if(pGuild==NULL)
                        {
                            point.x -= cs1.cx + 27;    
                        }
                        else
                        {
                            if( cs1.cx > cs2.cx )
                            {
                                if(this->GetGuild()->m_dwLogo!=NULL)
                                {
                                    point.x -= cs1.cx + 52;    
                                }
                                else
                                {
                                    point.x -= cs1.cx + 27;    
                                }
                            }
                            else
                            {
                                if(this->GetGuild()->m_dwLogo!=NULL)
                                {
                                    point.x -= cs2.cx + 52;    
                                }
                                else
                                {
                                    point.x -= cs2.cx + 27;    
                                }
                            }
                        }


                            pTexture->Render( &g_Neuz.m_2DRender, point );


                        point.x=oldpointx;
                        point.y=oldpointy;
                    }
            }
#endif

Alles anzeigen

Worldserver:

DPDatabaseClient.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
    ON_MSG( PACKETTYPE_ARENA_GET, OnGetArenaScore );
#endif

PHP

#ifdef __ARENA_SCORE // SendArenaUpdate
    if( pUser->m_nArenaKills || pUser->m_nArenaDeaths ) // Override fix.
        g_dpDBClient.SendArenaScore( pUser->m_idPlayer, pUser->m_nArenaKills, pUser->m_nArenaDeaths );
#endif

PHP

#ifdef __ARENA_SCORE




void CDPDatabaseClient::OnGetArenaScore(  CAr & ar, DPID, DPID )
{
    u_long idPlayer;
    int nKills,nDeaths;


    ar >> idPlayer >> nKills >> nDeaths;


    CUser* pUser    = g_UserMng.GetUserByPlayerID( idPlayer );


    if(IsValidObj(pUser))
    {    
        pUser->m_nArenaKills = nKills;
        pUser->m_nArenaDeaths = nDeaths;
        //g_UserMng.AddArenaUpdateSingleUser( pUser ); // Send User joined to other Clients.
    }




}




void CDPDatabaseClient::SendArenaScore( u_long idPlayer, int nAkill , int nAdeath, BOOL bCreate )
{


    BEFORESENDDUAL( ar, PACKETTYPE_ARENA_UPDATE, DPID_UNKNOWN, DPID_UNKNOWN );
    ar << idPlayer << nAkill << nAdeath << bCreate;
    SEND( ar, this, DPID_SERVERPLAYER );
}


void CDPDatabaseClient::GetArenaScore( u_long idPlayer )
{


    BEFORESENDDUAL( ar, PACKETTYPE_ARENA_GET, DPID_UNKNOWN, DPID_UNKNOWN );
    ar << idPlayer;
    SEND( ar, this, DPID_SERVERPLAYER );
}
#endif

Alles anzeigen

DPServer.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif

ThreadMng.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
                g_ArenaScore.Process();
#endif

User.cpp

PHP

#ifdef __ARENA_SCORE
#include "ArenaScoreWorld.h"
extern CArenaScore g_ArenaScore;
#endif

PHP

#ifdef __ARENA_SCORE
    m_nArenaKills = 0;
    m_nArenaKills2 = 0;
    m_nArenaPoints = 0;
    m_nArenaDeaths = 0;
    m_nArenaDeaths2 = 0;
    m_nArenaIndex = NULL_ID;
#endif

PHP

#ifdef __ARENA_SCORE
    if( GetWorld()->IsArena() ) // This hook fixes the Score and ID of the player no matter where they are
        if( !g_ArenaScore.IsArenaUser( this ) )
        {
                g_ArenaScore.ArenaOnJoin( this );                // or how they got into thr Arena.


        }
    if( !GetWorld()->IsArena() )
            if( g_ArenaScore.IsArenaUser( this ) )
            {
                    g_ArenaScore.ArenaOnExit( this );
            }
#endif

Alles anzeigen

PHP

#ifdef __ARENA_SCORE




void CUserMng::AddArenaUpdate()
{


    CAr arBlock;


    arBlock << NULL_ID << SNAPSHOTTYPE_ARENA_UPDATE;
    arBlock << g_ArenaScore.m_vecUserInfo.size();


    for( DWORD i = 0; i < g_ArenaScore.m_vecUserInfo.size(); i++ )
    {    
        arBlock.WriteString( g_ArenaScore.m_vecUserInfo[i].szName );
        arBlock << g_ArenaScore.m_vecUserInfo[i].nKills;
        arBlock << g_ArenaScore.m_vecUserInfo[i].nDeaths;
        arBlock << g_ArenaScore.m_vecUserInfo[i].nPoints;
        arBlock << g_ArenaScore.m_vecUserInfo[i].nKills2;
        arBlock << g_ArenaScore.m_vecUserInfo[i].nDeaths2;
        arBlock << g_ArenaScore.m_vecUserInfo[i].nLevel;
    }


    GETBLOCK( arBlock, lpBlock, uBlockSize );


    for( DWORD i = 0; i < g_ArenaScore.m_vecUserInfo.size(); i++ )
    {
        CUser* pUserReceive = prj.GetUser(g_ArenaScore.m_vecUserInfo[i].dwID);
        if( !pUserReceive )
            continue;


        pUserReceive->AddBlock( lpBlock, uBlockSize );
    }




}




void CUserMng::GetArenaUsers()
{    


    if( ::timeGetTime() > g_ArenaScore.m_nRejoinTime + 2000 )
    {
        map<DWORD, CUser*>::iterator it;
        for( it = m_users.begin(); it != m_users.end(); ++it )
        {
            CUser* pUser = it->second;


            if( !pUser->IsValid() )
                continue;


            if( pUser->GetWorld()->IsArena() )
                g_ArenaScore.NewUser( pUser );
       }


    }


}


#endif

Alles anzeigen

PHP

#ifdef __ARENA_SCORE
    if( g_ArenaScore.IsArenaUser( pUser ) )
        {
            g_ArenaScore.ArenaOnExit( pUser );
            DestroyPlayer( pUser );
            return;
        }
    #endif

DatabaseClient.h

PHP

#ifdef __ARENA_SCORE
    // Arena
    void    SendArenaScore( u_long idPlayer, int nAkill , int nAdeath, BOOL bCreate = FALSE );
    void    GetArenaScore( u_long idPlayer );
    void    OnGetArenaScore(  CAr & ar, DPID, DPID );


#endif

User.h

PHP

#ifdef __ARENA_SCORE
public:
    //Arena Score
    int        m_nArenaKills;
    int        m_nArenaKills2;
    int        m_nArenaPoints;
    int        m_nArenaDeaths;
    int        m_nArenaDeaths2;
    int        m_nArenaIndex;


#endif

Alles anzeigen

PHP

#ifdef __ARENA_SCORE
    void            AddArenaUpdate();
    void            GetArenaUsers();
#endif

KernDateien:
File-Upload.net - ArenaCore.rar

Ich gebe keine Garantie auf die Richtigkeit der Codebausteine noch garantiere ich das davon alles in dem eigentlichen Script verwendet wird.

Dies ist eine ungecleante und veraltete Version des eigentlichen Codes und wurde nie über einen längeren Zeitraum verwendet.

Jeder der sich NICHT mit dem Source Code ansatzweise auskennt sollte die Finger hiervon lassen.

Credits :

99.9% Pumaaa ( Recode )
0.01% lol32/caja ( Arena ~ Original Code )

SCREEN

Son_Goku

Wäre es möglich einen Screen davon zu sehen?

Pumaaa

#Screen added.

Shuya

Könntest du in dein tut schreiben wo was an welcher stelle hin kommt?

Crasy

Zitat von Shuya;278863

Könntest du in dein tut schreiben wo was an welcher stelle hin kommt?

Wtf0x?

Wozu ein TuT, einfacher gehts net als es dort Steht, er schreibt die Daten + den Inhalt, es kommt fast überall ganz unten hin, lol.

sh4dovv

Könntest du viellecht noch die zugehörigen prozeduren und tables uploaden?

Crasy

Zitat von sh4dovv;278880

Könntest du viellecht noch die zugehörigen prozeduren und tables uploaden?

Du hast den Source, bau sie dir daraus, ist doch einfach o.O

deviant

need a sql query? or don't need

something like this

CREATE TABLE [dbo].[ArenaScore](
[idPlayer] [char](7) NOT NULL,
[nArenaKills] [int] NULL,
[nArenaDeaths] [int] NULL,
[serverindex] [int] NULL,

lol32

And the stored procedures too.

tester1337

Srsly, there are 2 usps, which simply read/update integers in a table...
Even some SQL newbie could write them.

Code

sprintf( szQuery, "[COLOR=#0000ff][B]uspLoadArena[/B] [/COLOR][COLOR=#008000]@serverindex[/COLOR][COLOR=#0000FF]='%02d', [/COLOR][COLOR=#008000]@idPlayer[/COLOR][COLOR=#0000FF]='%07d'[/COLOR] ",g_appInfo.dwSys, nidPlayer );    //can add arguments directl
.....
.....
            while( qry->Fetch() )
            {    
                    nArenaKills    =    qry->[COLOR=#ff0000]GetInt[/COLOR]("[COLOR=#008000]nArenaKills[/COLOR]");
                    nArenaDeaths    =    qry->[COLOR=#ff0000]GetInt[/COLOR]("[COLOR=#008000]nArenaDeaths[/COLOR]");
            }

GetInt -> Select XX values (type int) from a table.

-->

Code

CREATE proc [dbo].[uspLoadArena]
    @serverindex char(2),       
    @idPlayer char(7)
as
set nocount on   


Select serverindex, m_idPlayer, nArenaKills, nArenaDeaths
from [COLOR=#ff0000]tblArenaScore[/COLOR] with (nolock)
where serverindex = @serverindex and m_idPlayer = @m_idPlayer

Something like this.

Code

[B][COLOR=#0000ff]uspSaveArena[/COLOR][/B] [COLOR=#008000]@serverindex[/COLOR]='%02d', [COLOR=#008000]@idPlayer[/COLOR]='%07d', [COLOR=#008000]@nArenaKills[/COLOR]='%d', [COLOR=#008000]@nArenaDeaths[/COLOR]='%d'

-> Writes green values into a table...

Code

CREATE proc [dbo].[uspSaveArena]
    @serverindex char(2),       
    @idPlayer char(7), 
    @nArenaKills int,
    @nArenaDeaths int
as
set nocount on
set xact_abort on


update [COLOR=#ff0000]tblArenaScore[/COLOR]
set nArenaKills = @nArenaKills, nArenaDeaths = @nArenaDeaths
where serverindex = @serverindex and m_idPlayer = @m_idPlayer

Alles anzeigen

I just wrote them without testing, I don't know if they work as they should. But its your job to do this right when working with source code...

And for those who need the table..

Code

CREATE TABLE [dbo].[tblArenaScore](
    [serverindex] [char](2) NULL,
    [m_idPlayer] [char](7) NULL,
    [nArenaKills] [int] NULL,
    [nArenaDeaths] [int] NULL
)

jcdace123

Adding This Below "ArenaOnKillHook()" Should prevent anyone dual clienting on the same connection for looting rewards/kills

Code

if( pAttacker->m_playAccount.lpAddr == pDefender->m_playAccount.lpAddr )
return;

Let me know if it works for you as i haven't had chance to 100% test it in a live server yet :)
and if it's also not needed let me know too plz xD

.:Flyff:.

In welcher DBF muss ich die Tabellen denn erstellen?
Einfach auf master?

Danke

Crasy

Zitat von .:Flyff:.;282443

In welcher DBF muss ich die Tabellen denn erstellen?
Einfach auf master?
Danke

Naja, frag dich mal wo alllllllllllllles was mit CHARACTER zutun hat gespeichert wird? in der ACCOUNT_DBF natürlich.

.:Flyff:.

HAHA, CHARACTER_01_DBF XD Aber man kann ja mal fragen :D

Habe es in der CHARACTER_01_DBF. Tabele heißt ja dbo.ArenaScore

Aber iwie speichter der da nichts rein.

Chibox

Wo ist denn die eigeninitiative heutzutage geblieben?

Crasy

Zitat von Chibox;282506

Wo ist denn die eigeninitiative heutzutage geblieben?

Die, ja.. die... gute Frage eigentlich :<

Wenn nichts gespeichert wird hast du iwo etwas Vergessen oder so..

Pumaaa: warum Sendest du vom Database Server den Score? du übergibst alle daten an den WorldServer, bei einem Update ( Kill / Death ) updated man diesen ja, und sendet ihn an DB und Client ( alle die in der Arena sind ), fertig, da braucht man eigentlich nichts über den Trans Server iwie Senden, meine meinung.

Pumaaa

Das sind überbliebene Bits von einer Version inder der Score nicht nach einer Runde, sondern nach einer Woche zurückgesetzt wurde.

Deswegen musste das ganze auch rückwertig funktionieren :)

marcogwapo

do i need to define it on version common?

Pumaaa

Yep you have to.

marcogwapo

i defined it to version common but i got errors :/ can someone translate this to english ?

[Release] Arena Score 1.2

Jetzt mitmachen!

SCHNELLZUGRIFF

HILFE & COMMUNITY

RECHTLICHES