[Release] Arena Score 1.2

    • [Release] Arena Score 1.2

      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-Quellcode

      1. #ifdef __ARENA_SCORE
      2. ON_MSG( PACKETTYPE_ARENA_UPDATE, OnSendArenaScore );
      3. ON_MSG( PACKETTYPE_ARENA_GET, OnGetArenaScore );
      4. #endif



      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void CDPTrans::OnGetArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize )
      3. {
      4. LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus = g_DbManager.AllocRequest();
      5. g_DbManager.MakeRequest( lpDbOverlappedPlus, lpBuf, uBufSize );
      6. lpDbOverlappedPlus->dpid = dpid;
      7. lpDbOverlappedPlus->nQueryMode = LOAD_ARENASCORE;
      8. PostQueuedCompletionStatus( g_DbManager.m_hIOCPPut, 1, NULL, &lpDbOverlappedPlus->Overlapped );
      9. }
      11. void CDPTrans::OnSendArenaScore( CAr & ar, DPID dpid, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize )
      12. {
      13. LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus = g_DbManager.AllocRequest();
      14. g_DbManager.MakeRequest( lpDbOverlappedPlus, lpBuf, uBufSize );
      15. lpDbOverlappedPlus->dpid = dpid;
      16. lpDbOverlappedPlus->nQueryMode = SAVE_ARENASCORE;
      17. PostQueuedCompletionStatus( g_DbManager.m_hIOCPPut, 1, NULL, &lpDbOverlappedPlus->Overlapped );
      18. }
      20. void CDPTrans::SendArenaScore( u_long idPlayer, int nAkill, int nAdeath )
      21. {
      23. BEFORESENDDUAL( ar, PACKETTYPE_ARENA_GET, DPID_UNKNOWN, DPID_UNKNOWN );
      24. ar << idPlayer << nAkill << nAdeath;
      26. SEND( ar, this, DPID_ALLPLAYERS );
      27. }
      28. #endif
      Alles anzeigen


      dpTrans.h

      PHP-Quellcode

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


      DbManager.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. case LOAD_ARENASCORE:
      3. LoadArenaScore( pQueryChar, lpDbOverlappedPlus );
      4. break;
      5. case SAVE_ARENASCORE:
      6. SaveArenaScore( pQueryChar, lpDbOverlappedPlus );
      7. break;
      8. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void CDbManager::LoadArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus )
      3. {
      4. CAr arRead( lpDbOverlappedPlus->lpBuf, lpDbOverlappedPlus->uBufSize );
      6. u_long nidPlayer;
      7. int nArenaKills;
      8. int nArenaDeaths;
      9. arRead >> nidPlayer;
      10. char szQuery[QUERY_SIZE] = {0,};
      11. sprintf( szQuery, "uspLoadArena @serverindex='%02d', @idPlayer='%07d' ",g_appInfo.dwSys, nidPlayer ); //can add arguments directly %s %d..
      12. //RUN QUERY
      17. //RUN QUERY
      18. if( FALSE == qry->Exec( szQuery ) )
      19. {
      20. WriteLog( "%s, %d\t%s", __FILE__, __LINE__, szQuery );
      22. }
      26. while( qry->Fetch() )
      27. {
      28. nArenaKills = qry->GetInt("nArenaKills");
      29. nArenaDeaths = qry->GetInt("nArenaDeaths");
      30. }
      33. CDPTrans::GetInstance()->SendArenaScore( nidPlayer, nArenaKills, nArenaDeaths );
      35. FreeRequest( lpDbOverlappedPlus );
      36. }
      38. void CDbManager::SaveArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus )
      39. {
      40. CAr arRead( lpDbOverlappedPlus->lpBuf, lpDbOverlappedPlus->uBufSize );
      42. u_long idPlayer;
      43. int nArenaKills;
      44. int nArenaDeaths;
      45. BOOL bCreate;
      46. arRead >> idPlayer >> nArenaKills >> nArenaDeaths >> bCreate;
      48. char szQuery[250] = {0,};
      49. if( !bCreate )
      50. sprintf( szQuery, "uspSaveArena @serverindex='%02d', @idPlayer='%07d', @nArenaKills='%d', @nArenaDeaths='%d'", g_appInfo.dwSys, idPlayer, nArenaKills, nArenaDeaths );
      51. else
      52. sprintf( szQuery, "TRUNCATE TABLE dbo.ArenaScore");
      55. if( FALSE == qry->Exec( szQuery ) )
      56. {
      57. WriteLog( "%s, %d\t%s", __FILE__, __LINE__, szQuery );
      58. FreeRequest( lpDbOverlappedPlus );
      59. return;
      60. }
      63. FreeRequest( lpDbOverlappedPlus );
      64. }
      65. #endif
      Alles anzeigen


      DbManager.h

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. ,LOAD_ARENASCORE
      3. ,SAVE_ARENASCORE
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void LoadArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus );
      3. void SaveArenaScore( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus );
      4. #endif



      CLIENT:

      DpClient.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreClient.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. case SNAPSHOTTYPE_ARENA_UPDATE: OnArenaUpdate( ar ); break;
      3. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void CDPClient::OnArenaUpdate( CAr & ar )
      3. {
      4. int nCount;
      6. ar >> nCount;
      8. g_ArenaScore.m_vecUserInfo.clear();
      10. for( int i=0; i<nCount; i++)
      11. {
      12. ARENA_INFO tmpInfo;
      13. ar.ReadString( tmpInfo.szName );
      14. ar >> tmpInfo.nKills;
      15. ar >> tmpInfo.nDeaths;
      16. ar >> tmpInfo.nPoints;
      17. ar >> tmpInfo.nKills2;
      18. ar >> tmpInfo.nDeaths2;
      19. ar >> tmpInfo.nLevel;
      21. g_ArenaScore.m_vecUserInfo.push_back( tmpInfo );
      22. }
      25. }
      27. #endif
      Alles anzeigen


      DPClient.h

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void OnArenaUpdate( CAr & ar );
      3. #endif


      Neuz.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. m_pHeroIconArena = NULL;
      3. #endif


      PHP-Quellcode

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


      Neuz.h

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. CTexture* m_pHeroIconArena;
      3. #endif


      FuncTextCmd.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif
      5. #endif // __WORLDSERVER


      PHP-Quellcode

      1. BOOL TextCmd_ArenaAllout( CScanner& scanner )
      2. {
      3. #ifdef __WORLDSERVER
      4. #ifdef __ARENA_SCORE
      5. g_ArenaScore.m_nRemainTime = ::timeGetTime();
      6. g_ArenaScore.KickOut();
      7. #endif
      8. #endif
      9. return TRUE;
      10. }


      PHP-Quellcode

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


      WndWorld.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreClient.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. g_ArenaScore.WorldDrawer(p2DRender);
      3. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. if( nChar == VK_TAB )
      3. g_ArenaScore.m_bDraw = !g_ArenaScore.m_bDraw;
      4. #endif


      Mover.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "..\WORLDSERVER\ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

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


      MoverRender.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreClient.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. //Arena Score
      3. if( GetWorld()->IsArena() && !strcmp( m_szName , g_ArenaScore.m_vecUserInfo[0].szName) )
      4. {
      5. pTexture = g_Neuz.m_pHeroIconArena;
      6. if( pTexture )
      7. {
      8. long oldpointx=point.x;
      9. long oldpointy=point.y;
      10. point.y -= pTexture->m_size.cy + 5;
      11. point.y = point.y+1;
      12. //point.x = point.x + 15;
      13. if(pGuild==NULL)
      14. {
      15. point.x -= cs1.cx + 27;
      16. }
      17. else
      18. {
      19. if( cs1.cx > cs2.cx )
      20. {
      21. if(this->GetGuild()->m_dwLogo!=NULL)
      22. {
      23. point.x -= cs1.cx + 52;
      24. }
      25. else
      26. {
      27. point.x -= cs1.cx + 27;
      28. }
      29. }
      30. else
      31. {
      32. if(this->GetGuild()->m_dwLogo!=NULL)
      33. {
      34. point.x -= cs2.cx + 52;
      35. }
      36. else
      37. {
      38. point.x -= cs2.cx + 27;
      39. }
      40. }
      41. }
      43. pTexture->Render( &g_Neuz.m_2DRender, point );
      45. point.x=oldpointx;
      46. point.y=oldpointy;
      47. }
      48. }
      49. #endif
      Alles anzeigen



      Worldserver:

      DPDatabaseClient.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. ON_MSG( PACKETTYPE_ARENA_GET, OnGetArenaScore );
      3. #endif


      PHP-Quellcode

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


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      4. void CDPDatabaseClient::OnGetArenaScore( CAr & ar, DPID, DPID )
      5. {
      6. u_long idPlayer;
      7. int nKills,nDeaths;
      9. ar >> idPlayer >> nKills >> nDeaths;
      11. CUser* pUser = g_UserMng.GetUserByPlayerID( idPlayer );
      13. if(IsValidObj(pUser))
      14. {
      15. pUser->m_nArenaKills = nKills;
      16. pUser->m_nArenaDeaths = nDeaths;
      17. //g_UserMng.AddArenaUpdateSingleUser( pUser ); // Send User joined to other Clients.
      18. }
      21. }
      24. void CDPDatabaseClient::SendArenaScore( u_long idPlayer, int nAkill , int nAdeath, BOOL bCreate )
      25. {
      27. BEFORESENDDUAL( ar, PACKETTYPE_ARENA_UPDATE, DPID_UNKNOWN, DPID_UNKNOWN );
      28. ar << idPlayer << nAkill << nAdeath << bCreate;
      29. SEND( ar, this, DPID_SERVERPLAYER );
      30. }
      32. void CDPDatabaseClient::GetArenaScore( u_long idPlayer )
      33. {
      35. BEFORESENDDUAL( ar, PACKETTYPE_ARENA_GET, DPID_UNKNOWN, DPID_UNKNOWN );
      36. ar << idPlayer;
      37. SEND( ar, this, DPID_SERVERPLAYER );
      38. }
      39. #endif
      Alles anzeigen


      DPServer.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      ThreadMng.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. g_ArenaScore.Process();
      3. #endif


      User.cpp

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. #include "ArenaScoreWorld.h"
      3. extern CArenaScore g_ArenaScore;
      4. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. m_nArenaKills = 0;
      3. m_nArenaKills2 = 0;
      4. m_nArenaPoints = 0;
      5. m_nArenaDeaths = 0;
      6. m_nArenaDeaths2 = 0;
      7. m_nArenaIndex = NULL_ID;
      8. #endif


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. if( GetWorld()->IsArena() ) // This hook fixes the Score and ID of the player no matter where they are
      3. if( !g_ArenaScore.IsArenaUser( this ) )
      4. {
      5. g_ArenaScore.ArenaOnJoin( this ); // or how they got into thr Arena.
      7. }
      8. if( !GetWorld()->IsArena() )
      9. if( g_ArenaScore.IsArenaUser( this ) )
      10. {
      11. g_ArenaScore.ArenaOnExit( this );
      12. }
      13. #endif
      Alles anzeigen


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      4. void CUserMng::AddArenaUpdate()
      5. {
      7. CAr arBlock;
      9. arBlock << NULL_ID << SNAPSHOTTYPE_ARENA_UPDATE;
      10. arBlock << g_ArenaScore.m_vecUserInfo.size();
      12. for( DWORD i = 0; i < g_ArenaScore.m_vecUserInfo.size(); i++ )
      13. {
      14. arBlock.WriteString( g_ArenaScore.m_vecUserInfo[i].szName );
      15. arBlock << g_ArenaScore.m_vecUserInfo[i].nKills;
      16. arBlock << g_ArenaScore.m_vecUserInfo[i].nDeaths;
      17. arBlock << g_ArenaScore.m_vecUserInfo[i].nPoints;
      18. arBlock << g_ArenaScore.m_vecUserInfo[i].nKills2;
      19. arBlock << g_ArenaScore.m_vecUserInfo[i].nDeaths2;
      20. arBlock << g_ArenaScore.m_vecUserInfo[i].nLevel;
      21. }
      23. GETBLOCK( arBlock, lpBlock, uBlockSize );
      25. for( DWORD i = 0; i < g_ArenaScore.m_vecUserInfo.size(); i++ )
      26. {
      27. CUser* pUserReceive = prj.GetUser(g_ArenaScore.m_vecUserInfo[i].dwID);
      28. if( !pUserReceive )
      29. continue;
      31. pUserReceive->AddBlock( lpBlock, uBlockSize );
      32. }
      35. }
      38. void CUserMng::GetArenaUsers()
      39. {
      41. if( ::timeGetTime() > g_ArenaScore.m_nRejoinTime + 2000 )
      42. {
      43. map<DWORD, CUser*>::iterator it;
      44. for( it = m_users.begin(); it != m_users.end(); ++it )
      45. {
      46. CUser* pUser = it->second;
      48. if( !pUser->IsValid() )
      49. continue;
      51. if( pUser->GetWorld()->IsArena() )
      52. g_ArenaScore.NewUser( pUser );
      53. }
      55. }
      57. }
      59. #endif
      Alles anzeigen


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. if( g_ArenaScore.IsArenaUser( pUser ) )
      3. {
      4. g_ArenaScore.ArenaOnExit( pUser );
      5. DestroyPlayer( pUser );
      6. return;
      7. }
      8. #endif


      DatabaseClient.h

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. // Arena
      3. void SendArenaScore( u_long idPlayer, int nAkill , int nAdeath, BOOL bCreate = FALSE );
      4. void GetArenaScore( u_long idPlayer );
      5. void OnGetArenaScore( CAr & ar, DPID, DPID );
      7. #endif


      User.h

      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. public:
      3. //Arena Score
      4. int m_nArenaKills;
      5. int m_nArenaKills2;
      6. int m_nArenaPoints;
      7. int m_nArenaDeaths;
      8. int m_nArenaDeaths2;
      9. int m_nArenaIndex;
      11. #endif
      Alles anzeigen


      PHP-Quellcode

      1. #ifdef __ARENA_SCORE
      2. void AddArenaUpdate();
      3. void GetArenaUsers();
      4. #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

    • Werbung zur Unterstützung des Forums ( Bitte AddBlocker deaktivieren )

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

      Quellcode

      1. 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
      2. .....
      3. .....
      4. while( qry->Fetch() )
      5. {
      6. nArenaKills = qry->[COLOR=#ff0000]GetInt[/COLOR]("[COLOR=#008000]nArenaKills[/COLOR]");
      7. nArenaDeaths = qry->[COLOR=#ff0000]GetInt[/COLOR]("[COLOR=#008000]nArenaDeaths[/COLOR]");
      8. }

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

      -->

      Quellcode

      1. CREATE proc [dbo].[uspLoadArena]
      2. @serverindex char(2),
      3. @idPlayer char(7)
      4. as
      5. set nocount on
      7. Select serverindex, m_idPlayer, nArenaKills, nArenaDeaths
      8. from [COLOR=#ff0000]tblArenaScore[/COLOR] with (nolock)
      9. where serverindex = @serverindex and m_idPlayer = @m_idPlayer

      Something like this.

      Quellcode

      1. [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...

      Quellcode

      1. CREATE proc [dbo].[uspSaveArena]
      2. @serverindex char(2),
      3. @idPlayer char(7),
      4. @nArenaKills int,
      5. @nArenaDeaths int
      6. as
      7. set nocount on
      8. set xact_abort on
      10. update [COLOR=#ff0000]tblArenaScore[/COLOR]
      11. set nArenaKills = @nArenaKills, nArenaDeaths = @nArenaDeaths
      12. 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..

      Quellcode

      1. CREATE TABLE [dbo].[tblArenaScore](
      2. [serverindex] [char](2) NULL,
      3. [m_idPlayer] [char](7) NULL,
      4. [nArenaKills] [int] NULL,
      5. [nArenaDeaths] [int] NULL
      6. )

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

      Quellcode

      1. if( pAttacker->m_playAccount.lpAddr == pDefender->m_playAccount.lpAddr )
      2. 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

    • Chibox;282506 schrieb:

      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.