[Release] Fraction System

~~yannickFlyff~~ · 02/02/2012, 18:13

CREDITS 100% BY ME (YANNICKMAMA)!!!!!!!!!!!!!!

DatabaseServer.cpp: Add below

Code:

 #if __VER >= 12 // __TAX #include "Tax.h" #endif // __TAX

Code:

 #if defined __SYS_FRACTION #include "fraction.h" #endif

below

Code:

 #if __VER >= 15 // __CAMPUS CCampusHelper::GetInstance()->PostRequest( CAMPUS_LOAD ); #endif // __CAMPUS

Code:

 #ifdef __SYS_FRACTION CFractionManager::GetInstance()->Load("fraction.inc"); #endif

Save & Close. Open DPLoginClient.h // Neuz Replace:

Code:

 #if __VER >= 15 // __2ND_PASSWORD_SYSTEM void SendCreatePlayer( BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh, int nBankPW = 0 ); #else // __2ND_PASSWORD_SYSTEM #ifdef __SYS_FRACTION void SendCreatePlayer( BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh, int nFraction ); #else void SendCreatePlayer( BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh ); #endif

Find the place by yourself, isn't as difficult. Open DPLoginClient.cpp Same here

Code:

 #if __VER >= 15 // __2ND_PASSWORD_SYSTEM void CDPLoginClient::SendCreatePlayer(BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh, int nBankPW ) #else // __2ND_PASSWORD_SYSTEM #ifdef __SYS_FRACTION void CDPLoginClient::SendCreatePlayer(BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh, int nFraction ) #else void CDPLoginClient::SendCreatePlayer(BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh ) #endif #endif // __2ND_PASSWORD_SYSTEM

and below

Code:

 ar << g_Neuz.m_dwAuthKey;

Code:

 #ifdef __SYS_FRACTION ar << nFraction; #endif

Open DPSrvr.cpp Find

Code:

CDPSrvr::OnTrade( CAr & ar, DPID dpidCache, DPID dpidUser, LPBYTE lpBuf, u_long uBufSize )

And add below

Code:

 if( pTrader->IsPlayer() ) // pc {

Code:

 #ifdef __SYS_FRACTION if( pTrader->m_nFraction != pUser->m_nFraction ) { pUser->AddText( "You cannot trade with user of other fractions." ); return; } #endif

Find

Code:

 CDPSrvr::InviteParty( u_long uLeaderid, u_long uMemberid, BOOL bTroup )

and add below

Code:

 if( ( pWorld && pWorld->GetID() == WI_WORLD_GUILDWAR ) || pLeaderUser->GetWorld() && pLeaderUser->GetWorld()->GetID() == WI_WORLD_GUILDWAR ) { pLeaderUser->AddText( prj.GetText(TID_GAME_GUILDCOMBAT_CANNOT_PARTY) );// "¼öÁ¤ÇØ¾ßÇÔ : ±æµå´ëÀüÀå¿¡´Â ÆÄÆ¼¸¦ ÇÒ¼ö ¾ø½À´Ï´Ù" ); return; }

Code:

 #ifdef __SYS_FRACTION if( pUser->m_nFraction != pLeaderUser->m_nFraction ) { pLeaderUser->AddText( "You cannot invite user of other fracrions" ); return; } #endif

Finally find

Code:

 CDPSrvr::InviteCompany( CUser* pUser, OBJID objid )

and add under

Code:

 CGuild* pGuild = g_GuildMng.GetGuild( pUser->m_idGuild ); if( pGuild ) {

Code:

 #ifdef __SYS_FRACTION if( pUsertmp->m_nFraction != pUser->m_nFraction ) { pUser->AddText( "You cannot invite user of other fractions." ); return; } #endif

Close & save. Open ThreadMng.cpp // WS Add below

Code:

 #if __VER >= 12 // __SECRET_ROOM #include "SecretRoom.h" #endif // __SECRET_ROOM

Code:

 #ifdef __SYS_FRACTION #include "fraction.h" #endif

Find

Code:

OutputDebugString( "CreateMonster.txt Not Found!" );

and add below

Code:

 #if __VER >= 12 // __ITEMCREATEMON_S0602 #if __VER < 12 // __NEW_ITEMCREATEMON_SERVER if( !g_CreateMonster.LoadScript( "CreateMonster.txt" ) ) { OutputDebugString( "CreateMonster.txt Not Found!" ); return FALSE; } #endif // __NEW_ITEMCREATEMON_SERVER #endif // __ITEMCREATEMON_S0602

Code:

 #ifdef __SYS_FRACTION CFractionManager::GetInstance()->Load( "fraction.inc" ); #endif

Save & close Open CCtrl.cpp and find

Code:

 CCtrl::ApplySkill( CCtrl *pSrc, ItemProp *pSkillProp, AddSkillProp *pAddSkillProp, bool bIgnoreProb, int nParam, BOOL bOnlyDmg, BOOL bTarget )

Below

Code:

 #ifdef __JEFF_11_4 || pAttacker->IsArenaTarget( pDefender ) #endif // __JEFF_11_4

you add

Code:

 #ifdef __SYS_FRACTION || pAttacker->IsFractionAttack( pDefender ) #endif

Open mover.cpp Add below

Code:

void CMover::PostAIMsg( DWORD dwMsg, DWORD dwParam1, DWORD dwParam2 ) { if( m_pAIInterface ) m_pAIInterface->PostAIMsg( dwMsg, dwParam1, dwParam2 ); }

Code:

#ifdef __SYS_FRACTION BOOL CMover::IsFractionAttack( CMover *pMover ) { if( pMover->GetLevel() > 60 && GetLevel() > 60 && m_nFraction != pMover->m_nFraction ) return TRUE; return FALSE; } #endif

Add below

Code:

void CMover::Init() {

Code:

 #ifdef __SYS_FRACTION m_nFraction = 0; m_nFractKill = 0; m_nFractDeath = 0; #endif

Find

Code:

 CMover::DoDie( CCtrl *pAttackCtrl, DWORD dwMsg )

Add below

Code:

 #if defined(__WORLDSERVER) if( GetType() == OT_MOVER ) { RemoveCommonBuffs(); g_UserMng.AddRemoveAllSkillInfluence( this ); } if( m_nGuildCombatState ) { if( pAttacker && pAttacker->IsPlayer() && GetWorld() ) GetWorld()->OnDie( this, pAttacker ); }

Code:

#ifdef __SYS_FRACTION if( pAttacker->IsPlayer() && IsFractionAttack( pAttacker ) ) { __int64 n64 = m_nFractDeath + 1; if( n64 <= INT_MAX ) m_nFractDeath++; n64 = pAttacker->m_nFractKill + 1; if( n64 <= INT_MAX ) pAttacker->m_nFractKill++; char szMsg[256]; sprintf( szMsg, " You killed %s. You got %d KillPoints (Total: %d)", GetName(), 1, pAttacker->m_nFractKill ); ((CUser*)pAttacker)->AddText( szMsg ); } #endif

Find

Code:

CMover::IsAttackAble( CObj *pObj )

Add under

Code:

#ifdef __JEFF_11_4 else if( IsArenaTarget( pMover ) ) bAble = TRUE; #endif // __JEFF_11_4

Code:

#ifdef __SYS_FRACTION else if( IsFractionAttack( pMover ) ) // fraction 1on1 bAble = TRUE; #endif

Close & open mover.h Add below

Code:

#define COLOR_GUILDCOMBAT 0xff00ff00

Code:

 #ifdef __SYS_FRACTION #define COLOR_FRACTION_OTHER 0xffff0000 #endif

Add below

Code:

class CMover : public CCtrl { public: CMover(); virtual ~CMover(); friend CActionMover; enum { PLAYER, NPC }; /// CMoverÀÇ Å¸ÀÔ public:

Code:

#ifdef __SYS_FRACTION int m_nFraction; int m_nFractKill; int m_nFractDeath; BOOL IsFractionAttack( CMover *pMover ); #endif

Open MoverAttack.cpp Find

Code:

HITTYPE CMover::GetHitType2( CMover* pMover, BOOL bTarget, BOOL bGood )

and add below

Code:

#ifdef __JEFF_11_4 if( IsArenaTarget( pMover ) ) return HITTYPE_ARENA; #endif // __JEFF_11_4

Code:

#ifdef __SYS_FRACTION if( IsFractionAttack( pMover ) ) return HITTYPE_PVP; #endif

Find

Code:

HITTYPE CMover::GetHitType( CMover* pMover, BOOL bTarget, int nReflect )

add below

Code:

#ifdef __JEFF_11_4 if( IsArenaTarget( pMover ) ) return HITTYPE_ARENA; #endif // __JEFF_11_4

Code:

#ifdef __SYS_FRACTION if( IsFractionAttack( pMover ) ) return HITTYPE_PVP; #endif

Open MoverRender.cpp Add below

Code:

extern CGuildCombat g_GuildCombatMng;

Code:

#ifdef __SYS_FRACTION #include "fraction.h" #endif

Find

Code:

void CMover::RenderName( LPDIRECT3DDEVICE9 pd3dDevice, CD3DFont* pFont, DWORD dwColor )

Add below

Code:

 else if( IsPKPink() ) dwColor = prj.m_PKSetting.dwReadyColor;

Code:

#ifdef __SYS_FRACTION else if( m_nFraction != g_pPlayer->m_nFraction ) dwColor = COLOR_FRACTION_OTHER; #endif

and below

Code:

#ifdef __CLIENT // ±æµåÀü½Ã¿¡ ¸Ó¸®À§¿¡ ¶ß´Â ÀüÅõ¸¶Å© if( g_eLocal.GetState( EVE_GUILDWAR ) == 1 ) // ±æµåÀü °¡´ÉÇÑ ¼¹öÀÎ°¡. { if( m_idWar && g_pPlayer->m_idWar == m_idWar ) // ³ª¶û °°Àº ÀüÀï¿¡ Âü°¡ÁßÀÎ ³ðÀÎ°¡. { if( m_idGuild != g_pPlayer->m_idGuild ) // ³ª¶û ´Ù¸¥±æµåÀÎ°¡(µ¿¸ÍÀÎ°æ¿ì´Â ÀÌ°É·Î ¾ÈµÈ´Ù.) { if( (m_dwFlag & MVRF_WARMARK) == 0 ) // ÀüÀï¸¶Å©°¡ ¾ÆÁ÷ ¾È¶°ÀÖ´Â »óÅÂ¸é { RenderFlag( ENEMY_WAR ); } } } } #endif // CLIENT }

Code:

 #ifdef __SYS_FRACTION if( IsPlayer() ) { if( !pGuild ) { point.x = (LONG)( vOut.x ); point.y = (LONG)( vOut.y ); MakeEven( point.x ); point.x -= pFont->GetTextExtent( (LPCTSTR)CFractionManager::GetInstance()->GetName( m_nFraction ) ).cx / 2; point.y -= 32; point.x -= 3; }else { point.x = (LONG)( vOut.x ); point.y = (LONG)( vOut.y ); MakeEven( point.x ); point.x -= pFont->GetTextExtent( (LPCTSTR)CFractionManager::GetInstance()->GetName( m_nFraction ) ).cx / 2; point.y -= 44; point.x -= 3; } dwColor = CFractionManager::GetInstance()->GetColor( m_nFraction ); pFont->DrawText( (FLOAT)point.x, (FLOAT)point.y, dwColor, CFractionManager::GetInstance()->GetName( m_nFraction ) ); } #endif

Find

Code:

CMover::RenderHP(LPDIRECT3DDEVICE9 pd3dDevice)

Add below

Code:

 D3DXVec3Project( &vOut, &vPosHeight, &vp, &GetWorld()->m_matProj, &GetWorld()->m_pCamera->m_matView, &matWorld);

Code:

#ifdef __SYS_FRACTION if( GetGuild() ) vOut.y -= 46; else #endif

Close & Open MoverSkill.cpp Find

Code:

BOOL CMover::DoUseSkill( DWORD dwSkill, int nLevel, OBJID idFocusObj, SKILLUSETYPE sutType, BOOL bControl, const int nCastingTime )

Add below

Code:

#ifdef __JEFF_11_4 || IsArenaTarget( pTarget ) #endif // __JEFF_11_4

Code:

#ifdef __SYS_FRACTION || IsFractionAttack( pTarget ) #endif

Close & open ObjSerializeOpt.cpp Find

Code:

CMover::Serialize( CAr & ar )

Add below

Code:

 for( int j = 0 ; j < SM_MAX ; ++j ) ar << m_dwSMTime[j];

Code:

#ifdef __SYS_FRACTION ar << m_nFraction; ar << m_nFractKill; ar << m_nFractDeath; #endif

and below

Code:

 for( int j = 0 ; j < SM_MAX ; ++j ) ar >> m_dwSMTime[j];

Code:

#ifdef __SYS_FRACTION ar >> m_nFraction; ar >> m_nFractKill; ar >> m_nFractDeath; #endif

Save & close Open Project.cpp Add below

Code:

#if __VER >= 13 // __COUPLE_1117 #include "couplehelper.h" #include "couple.h" #ifdef __WORLDSERVER #include "dpdatabaseclient.h" #include "dpsrvr.h" extern CDPDatabaseClient g_dpDBClient; extern CDPSrvr g_DPSrvr; #endif // __WORLDSERVER #endif // __COUPLE_1117

Code:

 #ifdef __CLIENT #ifdef __SYS_FRACTION #include "fraction.h" #endif #endif

and below

Code:

#ifdef __IMPROVE_MAP_SYSTEM #ifdef __CLIENT m_MapInformationManager.LoadMapInformationData(); #endif // __CLIENT #endif // __IMPROVE_MAP_SYSTEM

Code:

#ifdef __CLIENT #ifdef __SYS_FRACTION CFractionManager::GetInstance()->Load( "fraction.inc" ); #endif #endif

Save & close. Open DBManager.h Add below

Code:

#if __VER >= 15 // __IMPROVE_QUEST_INTERFACE , char* m_aCheckedQuest = '\0' #endif // __IMPROVE_QUEST_INTERFACE

Code:

#ifdef __SYS_FRACTION , int nFraction = 0 #endif

Open DBManager.cpp Under

Code:

#if __VER >= 15 // __CAMPUS #include "CampusDBCtrl.h" #endif // __CAMPUS

You add

Code:

#ifdef __SYS_FRACTION #include "fraction.h" #endif

Find

Code:

CDbManager::CreatePlayer( CQuery *qry, LPDB_OVERLAPPED_PLUS lpDbOverlappedPlus )

Below

Code:

 DWORD dwAuthKey; arRead >> dwAuthKey;

you add

Code:

#ifdef __SYS_FRACTION int nFraction = 0; arRead >> nFraction; #endif

Below

Code:

#if __VER >= 15 // __2ND_PASSWORD_SYSTEM if( nBankPW < 0 || nBankPW > 9999 ) { Error( "nBankPW is Invalid! szPlayer : %s, nBankPW : %d", lpDbOverlappedPlus->AccountInfo.szPlayer, nBankPW ); FreeRequest( lpDbOverlappedPlus ); return; } #endif // __2ND_PASSWORD_SYSTEM

Code:

 #ifdef __SYS_FRACTION CFractionManager *pMng = CFractionManager::GetInstance(); dwWorldID = pMng->GetWorld( nFraction ); vPos = pMng->GetStart(nFraction); #endif

And replace this shit

Code:

 DBQryCharacter( szQuery, "I1", 0, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPlayer, nSlot, dwWorldID, dwIndex, vPos.x, vPos.y, vPos.z, '\0', nSkinSet, nHairMesh, dwHairColor, nHeadMesh, nSex

with

Code:

 DBQryCharacter( szQuery, "I1", 0, g_appInfo.dwSys, lpDbOverlappedPlus->AccountInfo.szAccount, lpDbOverlappedPlus->AccountInfo.szPlayer, nSlot, dwWorldID, dwIndex, vPos.x, vPos.y, vPos.z, '\0', nSkinSet, nHairMesh, dwHairColor, nHeadMesh, nSex #ifdef __SYS_FRACTION ,0.0f, 0, 0.0f, 0, 0, 0, 0, 0, 0, '\0', 0, 0, 0, 0, 0, 0, 0, '\0', '\0', '\0', 0, 0, 0.0f, 0.0f, 0.0f, 0, 0, 0, 0, 0, '\0', 'F', 0, #if __VER >= 8 // __S8_PK 0, 0, 0, #else // __VER >= 8 // __S8_PK 0, 0, 0, 0, 0, #endif // __VER >= 8 // __S8_PK 0, 0, 0, 0, 0, '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', '\0', 0, '\0', '\0', '\0', 0, 0, 0, '\0', '\0', 0, '\0', '\0', '\0', '\0', '\0', 0, 0.0f, 0.0f, 0.0f #if __VER >= 8 // __S8_PK , 0, 0, 0 #endif // __VER >= 8 // __S8_PK #if __VER >= 8 //__CSC_VER8_5 , 0, 0 #endif // __CSC_VER8_5 , '\0', '\0', 0 #ifdef __EXP_ANGELEXP_LOG , 0, 0 #endif // __EXP_ANGELEXP_LOG #ifdef __EVENTLUA_COUPON , 0 #endif // __EVENTLUA_COUPON #if __VER >= 13 // __HONORABLE_TITLE // ´ÞÀÎ , -1 // ´ÞÀÎ¼±ÅÃ #endif // __HONORABLE_TITLE // ´ÞÀÎ #ifdef __LAYER_1015 , 0 #endif // __LAYER_1015 #if __VER >= 15 // __CAMPUS , 0, 0 #endif // __CAMPUS #if __VER >= 15 // __IMPROVE_QUEST_INTERFACE , '\0' #endif // __IMPROVE_QUEST_INTERFACE , nFraction #endif

Add below

Code:

#if __VER >= 15 // __IMPROVE_QUEST_INTERFACE , char* m_aCheckedQuest #endif // __IMPROVE_QUEST_INTERFACE

[/CODE]#ifdef __SYS_FRACTION , int nFraction #endif[/CODE] (Head of the DBQryCharacter method) Add below

Code:

#if __VER >= 15 // __IMPROVE_QUEST_INTERFACE sprintf( strCharacter, ",@im_aCheckedQuest='%s'", m_aCheckedQuest ); strncat( qryCharacter, strCharacter, sizeof(strCharacter) ); #endif // __IMPROVE_QUEST_INTERFACE

Code:

 #ifdef __SYS_FRACTION sprintf( strCharacter, ",@im_nFraction='%d'", nFraction ); strncat( qryCharacter, strCharacter, sizeof(strCharacter) ); #endif

Save & close Open DBManagerJoin.cpp Add below

Code:

#if __VER >= 15 // __GUILD_HOUSE mover.m_nRestPoint = qry->GetInt( "m_nRestPoint" ); mover.m_tLogOut = time_null() - qry->GetInt( "m_LogOutTime" ); #endif // __GUILD_HOUSE

Code:

#ifdef __SYS_FRACTION mover.m_nFraction = qry->GetInt( "m_nFraction" ); mover.m_nFractDeath = qry->GetInt( "m_nFractDeath" ); mover.m_nFractKill = qry->GetInt( "m_nFractKill" ); #endif

Open DBManagerSave.cpp Add below

Code:

#if __VER >= 15 // __CAMPUS ",?,?" #endif // __CAMPUS

Code:

#ifdef __SYS_FRACTION ",?,?,?" #endif

below

Code:

#if __VER >= 15 // __CAMPUS MAX_SAVEPARAM += 2; // m_nCampusPoint, m_idCampus #endif // __CAMPUS

Code:

#ifdef __SYS_FRACTION MAX_SAVEPARAM += 3; #endif

below

Code:

#if __VER >= 15 // __CAMPUS int nCampusPoint = pMover->GetCampusPoint(); bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &nCampusPoint, 0, 0 ); u_long idCampus = pMover->GetCampusId(); bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &idCampus, 0, 0 ); #endif // __CAMPUS

Code:

#ifdef __SYS_FRACTION bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &pMover->m_nFraction, 0, 0 ); bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &pMover->m_nFractDeath, 0, 0 ); bOK[++j] = qry->BindParameter( ++i, SQL_PARAM_INPUT, SQL_C_LONG, SQL_INTEGER, 0, 0, &pMover->m_nFractKill, 0, 0 ); #endif

Save & close Open WndTitle.cpp Find

Code:

#ifdef __CERTIFIER_COLLECTING_SYSTEM #include "DPCollectClient.h" #endif // __CERTIFIER_COLLECTING_SYSTEM

Add below

Code:

 #ifdef __SYS_FRACTION #include "Fraction.h" #endif

Add below

Code:

#if __VER >= 15 // __2ND_PASSWORD_SYSTEM CWndStatic* pWnd2ndPasswordText = ( CWndStatic* )GetDlgItem( WIDC_STATIC_2ND_PASSWORD_TEXT ); assert( pWnd2ndPasswordText ); pWnd2ndPasswordText->m_dwColor = D3DCOLOR_ARGB( 255, 255, 0, 0 ); CWndEdit* pWnd2ndPassword = ( CWndEdit* )GetDlgItem( WIDC_EDIT_2ND_PASSWORD ); assert( pWnd2ndPassword ); pWnd2ndPassword->AddWndStyle( EBS_PASSWORD | EBS_AUTOHSCROLL | EBS_NUMBER ); pWnd2ndPassword->SetMaxStringNumber( MAX_2ND_PASSWORD_NUMBER ); CWndEdit* pWnd2ndPasswordConfirm = ( CWndEdit* )GetDlgItem( WIDC_EDIT_2ND_PASSWORD_CONFIRM ); assert( pWnd2ndPasswordConfirm ); pWnd2ndPasswordConfirm->AddWndStyle( EBS_PASSWORD | EBS_AUTOHSCROLL | EBS_NUMBER ); pWnd2ndPasswordConfirm->SetMaxStringNumber( MAX_2ND_PASSWORD_NUMBER ); pWnd2ndPasswordText->EnableWindow( FALSE ); #endif // __2ND_PASSWORD_SYSTEM

Code:

#ifdef __SYS_FRACTION CWndComboBox* pFraction = (CWndComboBox*)GetDlgItem( WIDC_COMBOBOX1 ); vector<FRACTIONPROP>::iterator it; CFractionManager *pMng = CFractionManager::GetInstance(); for( it = pMng->v_Fractions.begin(); it != pMng->v_Fractions.end(); ++it ) { pFraction->AddString( it->szName ); } pFraction->SetCurSel(0); #endif

and below

Code:

 else { dwHairColor = D3DCOLOR_ARGB( 255, nFeMaleHairColor[m_Player.m_byHairMesh][0], nFeMaleHairColor[m_Player.m_byHairMesh][1], nFeMaleHairColor[m_Player.m_byHairMesh][2] ); }

replace the creation send shit with

Code:

#ifdef __SYS_FRACTION int nFraction = 0; CWndComboBox* pFrac = (CWndComboBox*)GetDlgItem(WIDC_COMBOBOX1); nFraction = CFractionManager::GetInstance()->GetFraction(((CWndComboBox*)GetDlgItem(WIDC_COMBOBOX1))->GetString() ); g_dpLoginClient.SendCreatePlayer( (BYTE)( m_Player.m_uSlot ), string, m_Player.m_byFace, m_Player.m_byCostume, m_Player.m_bySkinSet, m_Player.m_byHairMesh, dwHairColor, m_Player.m_bySex, m_Player.m_byJob, m_Player.m_byHeadMesh, nFraction ); #else #if __VER >= 15 // __2ND_PASSWORD_SYSTEM g_dpLoginClient.SendCreatePlayer( (BYTE)( m_Player.m_uSlot ), string, m_Player.m_byFace, m_Player.m_byCostume, m_Player.m_bySkinSet, m_Player.m_byHairMesh, dwHairColor, m_Player.m_bySex, m_Player.m_byJob, m_Player.m_byHeadMesh, atoi( pWnd2ndPassword->GetString() ) ); #else // __2ND_PASSWORD_SYSTEM g_dpLoginClient.SendCreatePlayer( (BYTE)( m_Player.m_uSlot ), string, m_Player.m_byFace, m_Player.m_byCostume, m_Player.m_bySkinSet, m_Player.m_byHairMesh, dwHairColor, m_Player.m_bySex, m_Player.m_byJob, m_Player.m_byHeadMesh ); #endif // __2ND_PASSWORD_SYSTEM #endif

Save & close Open Obj.cpp Find

Code:

#ifdef __JEFF_9_20 m_dwMute = 0; #else // __JEFF_9_20 m_dwFlyTime = 0; #endif // __JEFF_9_20

add below

Code:

#ifdef __SYS_FRACTION m_nFraction = 0; m_nFractKill = 0; m_nFractDeath = 0; #endif

Find

Code:

CMover::Copy( CMover * pMover, BOOL bAll )

And add below

Code:

#if __VER >= 15 // __GUILD_HOUSE m_nRestPoint = pMover->m_nRestPoint; m_tLogOut = pMover->m_tLogOut; #endif // __GUILD_HOUSE

Code:

#ifdef __SYS_FRACTION m_nFraction = pMover->m_nFraction; m_nFractDeath = pMover->m_nFractDeath; m_nFractKill = pMover->m_nFractKill; #endif

Open Obj.h Add below

Code:

class CMover: public CCtrl { private: DWORD m_dwGold; public: /// ¸ó½ºÅÍ¿¡ ÇØ´çµÇ´Â °Í

Code:

#ifdef __SYS_FRACTION int m_nFraction; int m_nFractKill; int m_nFractDeath; #endif

Finally, define __SYS_FRACTION in VersionCommon.h of Neuz, WorldServer and TransServer. You have to edit the CharCreate Window by yourself. Also you have to add 3 new Columns in your Database named m_nFraction, m_nFractDeath and m_nFractKill. Then batch this SQL

Code:

 USE [CHARACTER_01_DBF] GO /****** Object: StoredProcedure [dbo].[CHARACTER_STR] Script Date: 01/20/2012 19:44:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[CHARACTER_STR] @iGu CHAR(2) = 'S1', @im_idPlayer CHAR(7) = '0000001', @iserverindex CHAR(2) = '01', /********************************************** INSERT ? **********************************************/ -- CHARACTER_TBL @iaccount VARCHAR(32) = '', @im_szName VARCHAR(32) = '', @iplayerslot INT = 0, @idwWorldID INT = 0, @im_dwIndex INT = 0, @im_vPos_x REAL = 0, @im_vPos_y REAL = 0, @im_vPos_z REAL = 0, @im_szCharacterKey VARCHAR(32) = '', @im_dwSkinSet INT = 0, @im_dwHairMesh INT = 0, @im_dwHairColor INT = 0, @im_dwHeadMesh INT = 0, @im_dwSex INT = 0, /********************************************** UPDATE ? **********************************************/ -- CHARACTER_TBL @im_vScale_x REAL = 0, @im_dwMotion INT = 0, @im_fAngle REAL = 0, @im_nHitPoint INT = 0, @im_nManaPoint INT = 0, @im_nFatiguePoint INT = 0, @im_dwRideItemIdx INT = 0, @im_dwGold INT = 0, @im_nJob INT = 0, @im_pActMover VARCHAR(50) = '', @im_nStr INT = 0, @im_nSta INT = 0, @im_nDex INT = 0, @im_nInt INT = 0, @im_nLevel INT = 0, @im_nExp1 BIGINT = 0, @im_nExp2 BIGINT = 0, @im_aJobSkill VARCHAR(500) ='', @im_aLicenseSkill VARCHAR(500) ='', @im_aJobLv VARCHAR(500) ='', @im_dwExpertLv INT = 0, @im_idMarkingWorld INT = 0, @im_vMarkingPos_x REAL = 0, @im_vMarkingPos_y REAL = 0, @im_vMarkingPos_z REAL = 0, @im_nRemainGP INT = 0, @im_nRemainLP INT = 0, @im_nFlightLv INT = 0, @im_nFxp INT = 0, @im_nTxp INT = 0, @im_lpQuestCntArray VARCHAR(3072)= '', @im_chAuthority CHAR(1) = '', @im_dwMode INT = 0, @im_idparty INT = 0, @im_idMuerderer INT = 0, @im_nFame INT = 0, @im_nDeathExp BIGINT = 0, @im_nDeathLevel INT = 0, @im_dwFlyTime INT = 0, @im_nMessengerState INT = 0, @iTotalPlayTime INT = 0 -------------- (ADD : Version8-PK System) ,@im_nPKValue int=0 ,@im_dwPKPropensity int=0 ,@im_dwPKExp int=0 -- CARD_CUBE_TBL ,@im_Card VARCHAR(1980)= '', @im_Index_Card VARCHAR(215) = '', @im_ObjIndex_Card VARCHAR(215) = '', @im_Cube VARCHAR(1980)= '', @im_Index_Cube VARCHAR(215) = '', @im_ObjIndex_Cube VARCHAR(215) = '', -- INVENTORY_TBL @im_Inventory VARCHAR(6940)= '', @im_apIndex VARCHAR(345) = '', @im_adwEquipment VARCHAR(135) = '', @im_dwObjIndex VARCHAR(345) = '', -- TASKBAR_TBL @im_aSlotApplet VARCHAR(3100)= '', -- TASKBAR_ITEM_TBL @im_aSlotItem VARCHAR(6885)= '', -- TASKBAR_TBL @im_aSlotQueue VARCHAR(225)= '', @im_SkillBar SMALLINT = 0, -- BANK_TBL @im_Bank VARCHAR(4290)= '', @im_apIndex_Bank VARCHAR(215)= '', @im_dwObjIndex_Bank VARCHAR(215)= '', @im_dwGoldBank INT = 0, @im_nFuel INT = -1, @im_tmAccFuel INT = 0, @im_dwSMTime VARCHAR(2560)='', @iSkillInfluence varchar(2048) ='', @im_dwSkillPoint INT = 0, @im_aCompleteQuest varchar(1024) = '', @im_extInventory varchar(2000) = '', @im_extBank varchar(2000) = '', @im_InventoryPiercing varchar(8000) = '', @im_BankPiercing varchar(8000) = '', @im_dwReturnWorldID INT = 1, @im_vReturnPos_x REAL = 0, @im_vReturnPos_y REAL = 0, @im_vReturnPos_z REAL = 0, -------------- ( Version 7 : Skill Update) @im_SkillPoint int=0, @im_SkillLv int=0, @im_SkillExp bigint=0, -------------- (?? ?? : 2006 11 13 Attendant Class) @idwEventFlag bigint=0, @idwEventTime int=0, @idwEventElapsed int=0 -------------- (ADD : Version8-Angel System) ,@im_nAngelExp bigint=0 ,@im_nAngelLevel int=0 --------------- Version 9 ?? ?? Pet?? ,@iszInventoryPet varchar(4200) = '$' ,@iszBankPet varchar(4200) = '$' ,@im_dwPetId int = -1 ,@im_nExpLog int = 0 ,@im_nAngelExpLog int = 0 , @im_nCoupon int = 0 , @im_nLayer int = 0 , @im_nFraction int = 0 , @im_nFractDeath int = 0 , @im_nFractKill int = 0 ---------- Ver.13 , @im_nHonor int = -1 ---------- Ver 15 --, @im_BankPW char(4) = '0000' , @im_aCheckedQuest varchar(100) ='' , @im_nCampusPoint int = 0 , @im_idCampus int = 0 /******************************************************* Gu ?? S : SELECT I : INSERT U : UPDATE D : DELETE 2005.04.11 updated ALTER TABLE CHARACTER_TBL ADD m_aCompleteQuest varchar(1024) NULL ALTER TABLE CHARACTER_TBL ALTER COLUMN m_lpQuestCntArray VARCHAR(3072) NULL *******************************************************/ AS set nocount on declare @last_connect tinyint set @last_connect = 1 DECLARE @om_chLoginAuthority CHAR(1),@oaccount VARCHAR(32),@oplayerslot INT IF @iGu = 'S2' -- ??? ?? ??????? ?????? ???? BEGIN IF @iaccount = '' OR @im_szName = '' BEGIN SELECT m_chAuthority = '',fError = '1', fText = '????' RETURN END SELECT A.dwWorldID, A.m_szName, A.playerslot, A.End_Time, A.BlockTime, A.m_dwIndex, A.m_idPlayer, A.m_idparty, A.m_dwSkinSet, A.m_dwHairMesh, A.m_dwHeadMesh, A.m_dwHairColor, A.m_dwSex, A.m_nJob, A.m_nLevel, A.m_vPos_x, A.m_vPos_y, A.m_vPos_z, A.m_nStr, A.m_nSta, A.m_nDex, A.m_nInt, A.m_aJobLv, A.m_chAuthority, A.m_idCompany, A.m_nMessengerState, B.m_Inventory, B.m_apIndex, B.m_adwEquipment, B.m_dwObjIndex, m_idGuild = CASE WHEN C.m_idGuild IS NULL THEN '0' ELSE C.m_idGuild END , m_idWar = CASE WHEN C.m_idWar IS NULL THEN '0' ELSE C.m_idWar END, D.m_extInventory, D.m_InventoryPiercing, ------------- ver. 13 A.m_nHonor, last_connect = @last_connect FROM CHARACTER_TBL A, INVENTORY_TBL B,GUILD_MEMBER_TBL C, INVENTORY_EXT_TBL D WHERE A.m_idPlayer = B.m_idPlayer AND A.serverindex= B.serverindex AND B.m_idPlayer = D.m_idPlayer AND B.serverindex = D.serverindex AND D.m_idPlayer *= C.m_idPlayer AND D.serverindex *= C.serverindex AND A.isblock = 'F' AND A.account = @iaccount AND A.serverindex= @iserverindex ORDER BY A.playerslot insert into CHARACTER_TBL_penya_check (account, m_szName, m_dwGold, check_sec, serverindex) select @iaccount, m_szName, m_dwGold, 9, @iserverindex from CHARACTER_TBL (nolock) where account = @iaccount and serverindex = @iserverindex and TotalPlayTime < 1 and m_dwGold >= 1 RETURN END /* ??? ?? ??????? ?????? ???? ex ) CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword) CHARACTER_STR 'S2','0','02','seghope','1234' */ ELSE IF @iGu = 'S3' -- ??? ????? ?? ???? idPlayer? ? ???? BEGIN SELECT m_szName, m_idPlayer,m_idCompany FROM CHARACTER_TBL WHERE serverindex = @iserverindex -- AND isblock = 'F' ORDER BY m_idPlayer RETURN END /* ??? ????? ?? ???? idPlayer? ? ???? ex ) CHARACTER_STR 'S3','',@iserverindex CHARACTER_STR 'S3','','01' */ ELSE IF @iGu = 'S4' -- ??? ??? ?? BEGIN declare @q1 nvarchar(4000) set @q1 = ' SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId, isnull(adwItemId5, 0) as adwItemId5, isnull(adwItemId6, 0) as adwItemId6, isnull(adwItemId7, 0) as adwItemId7, isnull(adwItemId8, 0) as adwItemId8, isnull(adwItemId9, 0) as adwItemId9, isnull(nUMPiercedSize, 0) as nUMPiercedSize, isnull(adwUMItemId0, 0) as adwUMItemId0, isnull(adwUMItemId1, 0) as adwUMItemId1, isnull(adwUMItemId2, 0) as adwUMItemId2, isnull(adwUMItemId3, 0) as adwUMItemId3, isnull(adwUMItemId4, 0) as adwUMItemId4 FROM ITEM_SEND_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0' exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex /* SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption, m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime FROM ITEM_SEND_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0 */ RETURN END /* ??? ?? ex ) CHARACTER_STR 'S4',@im_idPlayer,@iserverindex CHARACTER_STR 'S4','000001','01' */ ELSE IF @iGu = 'S5' -- ??? ??? ????? ??? ?? BEGIN -- DELETE ITEM_SEND_TBL UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1 WHERE m_nNo = @iplayerslot IF @@ROWCOUNT = 0 SELECT fError = '0' ELSE SELECT fError = '1' RETURN END /* ??? ??? ????? ??? ?? ex ) CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount CHARACTER_STR 'S5','000001','01','???',1,1 */ ELSE IF @iGu = 'S6' -- ??? ??? ?? BEGIN SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, State, m_bItemResist, m_nResistAbilityOption FROM ITEM_REMOVE_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0 RETURN END /* ??? ?? ex ) CHARACTER_STR 'S6',@im_idPlayer,@iserverindex CHARACTER_STR 'S6','000001','01' */ ELSE IF @iGu = 'S7' -- ??? ??? ????? ??? ?? BEGIN -- DELETE ITEM_REMOVE_TBL UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1 WHERE m_nNo = @iplayerslot IF @@ROWCOUNT = 0 SELECT fError = '0' ELSE SELECT fError = '1' RETURN END /* ??? ??? ????? ??? ?? ex ) CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount CHARACTER_STR 'S7','000001','01','???',1,1 */ IF @iGu = 'S8' -- ??? ?? ???? BEGIN -- ?? ?? ???? character ? SELECT @om_chLoginAuthority = m_chLoginAuthority FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL WHERE account = @iaccount SELECT m_chLoginAuthority = @om_chLoginAuthority, A.account, A.m_idPlayer, A.playerslot, A.serverindex, A.dwWorldID, A.m_szName, A.m_dwIndex, A.m_vScale_x, A.m_dwMotion, A.m_vPos_x, A.m_vPos_y, A.m_vPos_z, A.m_fAngle, A.m_szCharacterKey, A.m_idPlayer, A.m_nHitPoint, A.m_nManaPoint, A.m_nFatiguePoint, A.m_nFuel, A.m_dwSkinSet, A.m_dwHairMesh, A.m_dwHairColor, A.m_dwHeadMesh, A.m_dwSex, A.m_dwRideItemIdx, A.m_dwGold, A.m_nJob, A.m_pActMover, A.m_nStr, A.m_nSta, A.m_nDex, A.m_nInt, A.m_nLevel, A.m_nMaximumLevel, A.m_nExp1, A.m_nExp2, A.m_aJobSkill, A.m_aLicenseSkill, A.m_aJobLv, A.m_dwExpertLv, A.m_idMarkingWorld, A.m_vMarkingPos_x, A.m_vMarkingPos_y, A.m_vMarkingPos_z, A.m_nRemainGP, A.m_nRemainLP, A.m_nFlightLv, A.m_nFxp, A.m_nTxp, A.m_lpQuestCntArray, m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'), A.m_chAuthority, A.m_dwMode, A.m_idparty, A.m_idCompany, A.m_idMuerderer, A.m_nFame, A.m_nDeathExp, A.m_nDeathLevel, A.m_dwFlyTime, A.m_nMessengerState, A.End_Time, A.BlockTime, A.blockby, A.isblock, A.TotalPlayTime, A.CreateTime, A.m_dwSkillPoint, B.m_aSlotApplet, B.m_aSlotQueue, B.m_SkillBar, C.m_aSlotItem, D.m_Inventory, D.m_apIndex, D.m_adwEquipment, D.m_dwObjIndex, m_idGuild = ISNULL(G.m_idGuild,'0'), m_idWar = ISNULL(G.m_idWar,'0'), A.m_tmAccFuel, A.m_tGuildMember, m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL') , SkillInfluence = ISNULL(E.SkillInfluence,'$'), F.m_extInventory, F.m_InventoryPiercing, A.m_dwReturnWorldID, A.m_vReturnPos_x, A.m_vReturnPos_y, A.m_vReturnPos_z, last_connect = @last_connect, A.m_SkillPoint, A.m_SkillLv, A.m_SkillExp, -------------- (2006 11 13 ?? ?? : Attedant Event) A.dwEventFlag, A.dwEventTime, A.dwEventElapsed -------------- (Version8 : PK System) ,A.PKValue as m_nPKValue ,A.PKPropensity as m_dwPKPropensity ,A.PKExp as m_dwPKExp -------------- (Version8 : Angel System) ,A.AngelExp as m_nAngelExp ,A.AngelLevel as m_nAngelLevel ------------------- Version9 Pet ,F.szInventoryPet as szInventoryPet ,A.m_dwPetId , A.m_nExpLog, A.m_nAngelExpLog , m_nCoupon ---------------- ver.13 , A.m_nLayer ---------- Ver 15 , A.m_aCheckedQuest , A.m_nCampusPoint , A.idCampus , isnull(R.m_nRestPoint, 0) m_nRestPoint , isnull(R.m_LogOutTime, 0) m_LogOutTime ---------- Fraction , A.m_nFraction , A.m_nFractKill , A.m_nFractDeath FROM CHARACTER_TBL A, TASKBAR_TBL B, TASKBAR_ITEM_TBL C, INVENTORY_TBL D, SKILLINFLUENCE_TBL E, INVENTORY_EXT_TBL F, GUILD_MEMBER_TBL G, BILING_ITEM_TBL H , tblRestPoint R WHERE A.m_idPlayer = @im_idPlayer AND A.serverindex = @iserverindex AND A.m_idPlayer = B.m_idPlayer AND A.serverindex = B.serverindex AND B.m_idPlayer = C.m_idPlayer AND B.serverindex = C.serverindex AND C.m_idPlayer = D.m_idPlayer AND C.serverindex = D.serverindex AND D.m_idPlayer = E.m_idPlayer AND D.serverindex = E.serverindex AND E.m_idPlayer = F.m_idPlayer AND E.serverindex = F.serverindex AND F.serverindex *= G.serverindex AND F.m_idPlayer *= G.m_idPlayer AND F.serverindex *= R.serverindex AND F.m_idPlayer *= R.m_idPlayer AND F.serverindex *= H.serverindex AND F.m_idPlayer *= H.m_idPlayer AND A.account = lower(@iaccount) insert into CHARACTER_TBL_validity_check (m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, sum_ability, CreateTime) select m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, (m_nStr + m_nSta + m_nDex + m_nInt), CreateTime from CHARACTER_TBL (nolock) where m_idPlayer = @im_idPlayer and TotalPlayTime <= 1 and (m_dwGold >= 1 or m_nLevel >= 2 or m_nJob >= 1 or (m_nStr + m_nSta + m_nDex + m_nInt) > 60) declare @m_dwGold_old bigint, @m_dwGold_now bigint select @m_dwGold_old = m_dwGold from tblLogout_Penya (nolock) where m_idPlayer = @im_idPlayer select @m_dwGold_now = m_dwGold from CHARACTER_TBL (nolock) where serverindex = @iserverindex and m_idPlayer = @im_idPlayer if (@m_dwGold_old <> @m_dwGold_now) begin insert into tblLogout_Penya_Diff_Log (serverindex, m_idPlayer, m_dwGold_old, regdate_old, m_dwGold_now) select serverindex, m_idPlayer, @m_dwGold_old, regdate, @m_dwGold_now from tblLogout_Penya (nolock) where m_idPlayer = @im_idPlayer and serverindex = @iserverindex end -- ?? ?? ???? account ? -- DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT) -- -- INSERT @bank -- (m_idPlayer,serverindex,playerslot) -- SELECT m_idPlayer,serverindex,playerslot -- FROM CHARACTER_TBL -- WHERE account = @iaccount -- AND isblock = 'F' -- ORDER BY playerslot SELECT a.m_idPlayer, c.playerslot, a.m_Bank, a.m_apIndex_Bank, a.m_dwObjIndex_Bank, a.m_dwGoldBank, a.m_BankPw, b.m_extBank, b.m_BankPiercing ,b.szBankPet FROM dbo.BANK_TBL a, dbo.BANK_EXT_TBL b, dbo.CHARACTER_TBL c WHERE a.m_idPlayer = b.m_idPlayer AND a.serverindex = b.serverindex AND b.m_idPlayer = c.m_idPlayer AND b.serverindex = c.serverindex AND c.account = @iaccount AND c.isblock = 'F' ORDER BY c.playerslot -- ?? ?? ???? SELECT a.nPocket, a.szItem, a.szIndex, a.szObjIndex, a.bExpired, a.tExpirationDate, b.szExt, b.szPiercing, b.szPet FROM tblPocket as a inner join tblPocketExt as b on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer ORDER BY a.nPocket RETURN END /* ??? ?? ???? New ex ) CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount CHARACTER_STR 'S8','425120','01','ata3k' */ ELSE IF @iGu = 'U1' -- ??? ?? BEGIN UPDATE CHARACTER_TBL SET dwWorldID = @idwWorldID, m_dwIndex = @im_dwIndex, m_dwSex = @im_dwSex, m_vScale_x = @im_vScale_x, m_dwMotion = @im_dwMotion, m_vPos_x = @im_vPos_x, m_vPos_y = @im_vPos_y, m_vPos_z = @im_vPos_z, m_dwHairMesh = @im_dwHairMesh, m_dwHairColor = @im_dwHairColor, m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 ?? m_fAngle = 0, --@im_fAngle, m_szCharacterKey = @im_szCharacterKey, m_nHitPoint = @im_nHitPoint, m_nManaPoint = @im_nManaPoint, m_nFatiguePoint = @im_nFatiguePoint, m_nFuel = @im_nFuel, m_dwRideItemIdx = @im_dwRideItemIdx, m_dwGold = @im_dwGold, m_nJob = @im_nJob, m_pActMover = @im_pActMover, m_nStr = @im_nStr, m_nSta = @im_nSta, m_nDex = @im_nDex, m_nInt = @im_nInt, m_nLevel = @im_nLevel, m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END, m_nExp1 = @im_nExp1, m_nExp2 = @im_nExp2, m_aJobSkill = @im_aJobSkill, m_aLicenseSkill = @im_aLicenseSkill, m_aJobLv = @im_aJobLv, m_dwExpertLv = @im_dwExpertLv, m_idMarkingWorld = @im_idMarkingWorld, m_vMarkingPos_x = @im_vMarkingPos_x, m_vMarkingPos_y = @im_vMarkingPos_y, m_vMarkingPos_z = @im_vMarkingPos_z, m_nRemainGP = @im_nRemainGP, m_nRemainLP = @im_nRemainLP, m_nFlightLv = @im_nFlightLv, m_nFxp = @im_nFxp, m_nTxp = @im_nTxp, m_lpQuestCntArray = @im_lpQuestCntArray, m_aCompleteQuest = @im_aCompleteQuest, m_dwMode = @im_dwMode, m_idparty = @im_idparty, m_idMuerderer = @im_idMuerderer, m_nFame = @im_nFame, m_nDeathExp = @im_nDeathExp, m_nDeathLevel = @im_nDeathLevel, m_nMessengerState = @im_nMessengerState, --m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime, m_dwFlyTime = @im_dwFlyTime, TotalPlayTime = TotalPlayTime + @iTotalPlayTime, m_tmAccFuel = @im_tmAccFuel, m_dwSkillPoint = @im_dwSkillPoint, m_dwReturnWorldID= @im_dwReturnWorldID, m_vReturnPos_x = @im_vReturnPos_x, m_vReturnPos_y = @im_vReturnPos_y, m_vReturnPos_z = @im_vReturnPos_z, m_SkillPoint =@im_SkillPoint, m_SkillLv =@im_SkillLv, m_SkillExp =@im_SkillExp -------------- (?? ?? : 2006 11 13 Attendant Event) , dwEventFlag =@idwEventFlag , dwEventTime =@idwEventTime , dwEventElapsed =@idwEventElapsed -------------- (ADD: Version8-PK System) , PKValue = @im_nPKValue , PKPropensity = @im_dwPKPropensity , PKExp = @im_dwPKExp -------------- (ADD: Version8-Angel System) , AngelExp = @im_nAngelExp , AngelLevel = @im_nAngelLevel --------------------- Version9 Pet , m_dwPetId = @im_dwPetId , m_nExpLog = @im_nExpLog , m_nAngelExpLog = @im_nAngelExpLog , m_nCoupon = @im_nCoupon ------------- ver. 13 , m_nHonor = @im_nHonor , m_nLayer = @im_nLayer ---------- Ver 15 , m_aCheckedQuest = @im_aCheckedQuest , m_nCampusPoint = @im_nCampusPoint , idCampus = @im_idCampus , m_nFraction = @im_nFraction , m_nFractDeath = @im_nFractDeath , m_nFractKill = @im_nFractKill WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex -- if object_id('QUEST_TBL') is not null -- EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray update tblLogout_Penya set m_dwGold = @im_dwGold, regdate = getdate() where m_idPlayer = @im_idPlayer and serverindex = @iserverindex IF @im_nLevel>=120 BEGIN UPDATE CHARACTER_TBL SET FinalLevelDt=getdate() WHERE serverindex=@iserverindex AND m_idPlayer=@im_idPlayer AND FinalLevelDt='2000-01-01' END --??? ???? ?? ?? IF @im_dwSMTime > '' BEGIN IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer AND serverindex = @iserverindex) UPDATE BILING_ITEM_TBL SET m_dwSMTime = @im_dwSMTime WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex ELSE INSERT BILING_ITEM_TBL (m_idPlayer,serverindex,m_dwSMTime) VALUES (@im_idPlayer,@iserverindex,@im_dwSMTime) END ELSE DELETE BILING_ITEM_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex -- UPDATE CARD_CUBE_TBL -- SET m_Card = @im_Card, -- m_apIndex_Card = @im_Index_Card, -- m_dwObjIndex_Card= @im_ObjIndex_Card, -- m_Cube = @im_Cube, -- m_apIndex_Cube = @im_Index_Cube, -- m_dwObjIndex_Cube=@im_ObjIndex_Cube -- WHERE m_idPlayer = @im_idPlayer -- AND serverindex = @iserverindex UPDATE INVENTORY_TBL SET m_Inventory = @im_Inventory, m_apIndex = @im_apIndex, m_adwEquipment = @im_adwEquipment, m_dwObjIndex = @im_dwObjIndex WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE TASKBAR_TBL SET m_aSlotApplet = @im_aSlotApplet, m_aSlotQueue = @im_aSlotQueue, m_SkillBar = @im_SkillBar WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE TASKBAR_ITEM_TBL SET m_aSlotItem = @im_aSlotItem WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE BANK_TBL SET m_Bank = @im_Bank, m_apIndex_Bank = @im_apIndex_Bank, m_dwObjIndex_Bank = @im_dwObjIndex_Bank, m_dwGoldBank = @im_dwGoldBank WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE SKILLINFLUENCE_TBL SET SkillInfluence = @iSkillInfluence WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE INVENTORY_EXT_TBL SET m_extInventory = @im_extInventory, m_InventoryPiercing= @im_InventoryPiercing ,szInventoryPet = @iszInventoryPet WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE BANK_EXT_TBL SET m_extBank = @im_extBank, m_BankPiercing = @im_BankPiercing , szBankPet = @iszBankPet WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex SELECT fError = '1', fText = 'OK' RETURN END /* ?????? ex ) CHARACTER_STR 'U1', ALL ... CHARACTER_STR 'U1','000001','01' ... */ ELSE IF @iGu = 'U2' --? ???? ?? BEGIN UPDATE CHARACTER_TBL SET TotalPlayTime = TotalPlayTime + @iplayerslot WHERE m_szName = @im_szName AND serverindex = @iserverindex RETURN END /* ? ???? ?? ex ) CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime) CHARACTER_STR 'U2','','01','','beat',10234 */ ELSE IF @iGu = 'U3' --? ???? ?? new BEGIN UPDATE CHARACTER_TBL SET TotalPlayTime = TotalPlayTime + @iplayerslot WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex RETURN END /* ? ???? ?? (new) ex ) CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime) CHARACTER_STR 'U3','000001','01','','',10234 */ ELSE IF @iGu = 'U4' --??? ? ?? BEGIN IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_szName = @im_szName AND serverindex = @iserverindex) BEGIN SELECT fError = '0' END ELSE BEGIN UPDATE CHARACTER_TBL SET m_szName = @im_szName WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex SELECT fError = '1' END RETURN END -- Ver 15 ELSE IF @iGu = 'U5' --?? ??? ???? ?? BEGIN IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex) BEGIN UPDATE CHARACTER_TBL SET m_nCampusPoint = m_nCampusPoint + @iplayerslot WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex declare @u5m_nCampusPoint int select @u5m_nCampusPoint = m_nCampusPoint from CHARACTER_TBL (nolock) WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex SELECT fError = '1', @u5m_nCampusPoint m_nCampusPoint END ELSE RETURN END ELSE IF @iGu = 'U6' -- ?? ID ???? ?? BEGIN IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex) BEGIN UPDATE CHARACTER_TBL SET idCampus = @iplayerslot WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex SELECT fError = '1' END ELSE BEGIN SELECT fError = '0' END RETURN END /* ??? ? ?? ex ) CHARACTER_STR 'U4',@im_idPlayer,@iserverindex,@iaccount,@im_szName CHARACTER_STR 'U4','000001','01','','????' */ ELSE IF @iGu = 'D1' -- ??? ?? BEGIN IF @im_szName = '' BEGIN SELECT fError = '1', fText = '??????' RETURN END if not exists (select * from CHARACTER_TBL where m_idPlayer = @im_idPlayer and account = @iaccount and serverindex = @iserverindex) begin select fError = '1' return end DECLARE @Exists int IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN') BEGIN IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (password = @im_szName OR member = 'B' )) SET @Exists = 1 ELSE SET @Exists = 0 END ELSE BEGIN IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' )) SET @Exists = 1 ELSE SET @Exists = 0 END IF @Exists > 0 BEGIN DECLARE @currDate char(12) SET @currDate = CONVERT(CHAR(8),GETDATE(),112) + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2) + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2) IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND m_idWar > 0) BEGIN SELECT fError = '3', fText = '????' RETURN END ELSE BEGIN UPDATE CHARACTER_TBL SET isblock = 'D', End_Time = @currDate , BlockTime = LEFT(@currDate,8) WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE MESSENGER_TBL SET State = 'D' WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex UPDATE MESSENGER_TBL SET State = 'D' WHERE f_idPlayer = @im_idPlayer AND serverindex = @iserverindex /****************************************************************************************/ /** 200506 event **/ /****************************************************************************************/ -- if (not exists(select account from RANKING.RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount) -- and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12') -- -- begin --: 1?? ?? ????? ?? ???? ?? -- declare @cash int,@get_cach int -- select @cash = case when m_nLevel between 10 and 19 then 500 -- when m_nLevel between 20 and 39 then 1000 -- when m_nLevel between 40 and 49 then 1500 -- when m_nLevel between 50 and 59 then 2000 -- when m_nLevel between 60 and 69 then 2500 -- when m_nLevel >= 70 then 3000 -- else 0 end -- from CHARACTER_TBL -- where m_idPlayer = @im_idPlayer and serverindex = @iserverindex -- -- select @get_cach = isnull(sum(amount),0) -- from RANKING.RANKING_DBF.dbo.event_member_tbl -- where account = @iaccount -- group by account -- -- if @cash + @get_cach > 5000 -- set @cash = 5000 - @get_cach -- -- if @cash > 0 -- -- begin -- declare @retcode int -- -- if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount) -- exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ','' -- -- exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'??? ?? ???',0,'' -- -- if @retcode <> 1 -- set @cash = 0 -- -- insert RANKING.RANKING_DBF.dbo.event_member_tbl -- (account,amount,m_idPlayer,serverindex,retcode,date) -- values -- (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate()) -- -- end -- end /****************************************************************************************/ /****************************************************************************************/ /****************************************************************************************/ IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex) BEGIN SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex RETURN END ELSE BEGIN SELECT fError = '0', fText = 'DELETE OK' RETURN END END END ELSE BEGIN SELECT fError = '1', fText = '??????' RETURN END END /* ??? ?? ex ) CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock) CHARACTER_STR 'D1','001068','01','ata3k','1019311' */ ELSE IF @iGu = 'I1' -- ?? ?? ?? BEGIN IF EXISTS(SELECT m_szName FROM CHARACTER_TBL WHERE m_szName = @im_szName AND serverindex = @iserverindex) BEGIN SELECT fError = '0', fText = '??? ??!' RETURN END ELSE BEGIN DECLARE @om_idPlayer CHAR (7) , @om_vScale_x REAL , @om_dwMotion INT , @om_fAngle REAL , @om_nHitPoint INT , @om_nManaPoint INT , @om_nFatiguePoint INT , @om_dwRideItemIdx INT , @om_dwGold INT , @om_nJob INT , @om_pActMover VARCHAR(50) , @om_nStr INT , @om_nSta INT , @om_nDex INT , @om_nInt INT , @om_nLevel INT , @om_nExp1 BIGINT , @om_nExp2 BIGINT , @om_aJobSkill VARCHAR (500), @om_aLicenseSkill VARCHAR (500), @om_aJobLv VARCHAR (500), @om_dwExpertLv INT , @om_idMarkingWorld INT , @om_vMarkingPos_x REAL , @om_vMarkingPos_y REAL , @om_vMarkingPos_z REAL , @om_nRemainGP INT , @om_nRemainLP INT , @om_nFlightLv INT , @om_nFxp INT , @om_nTxp INT , @om_lpQuestCntArray VARCHAR(1024), @om_chAuthority CHAR(1) , @om_dwMode INT , @oblockby VARCHAR(32) , @oTotalPlayTime INT , @oisblock CHAR(1) , @oEnd_Time CHAR(12) , @om_Inventory VARCHAR(6940), @om_apIndex VARCHAR(345) , @om_adwEquipment VARCHAR(135) , @om_aSlotApplet VARCHAR(3100), @om_aSlotItem VARCHAR(6885), @om_aSlotQueue VARCHAR(225), @om_SkillBar SMALLINT, @om_dwObjIndex VARCHAR(345) , @om_Card VARCHAR(1980), @om_Cube VARCHAR(1980), @om_apIndex_Card VARCHAR(215) , @om_dwObjIndex_Card VARCHAR(215) , @om_apIndex_Cube VARCHAR(215) , @om_dwObjIndex_Cube VARCHAR(215) , @om_idparty INT , @om_idMuerderer INT , @om_nFame INT , @om_nDeathExp BIGINT , @om_nDeathLevel INT , @om_dwFlyTime INT , @om_nMessengerState INT , @om_Bank VARCHAR(4290), @om_apIndex_Bank VARCHAR(215) , @om_dwObjIndex_Bank VARCHAR(215) , @om_dwGoldBank INT ---------- Ver 15 , @om_aCheckedQuest varchar(100) , @om_nCampusPoint int , @om_idCampus int IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE serverindex = @iserverindex) SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7) FROM CHARACTER_TBL WHERE serverindex = @iserverindex ELSE SELECT @om_idPlayer = '0000001' SELECT @om_vScale_x = m_vScale_x, @om_dwMotion = m_dwMotion, @om_fAngle = m_fAngle, @om_nHitPoint = m_nHitPoint, @om_nManaPoint = m_nManaPoint, @om_nFatiguePoint = m_nFatiguePoint, @om_dwRideItemIdx = m_dwRideItemIdx, @om_dwGold = m_dwGold, @om_nJob = m_nJob, @om_pActMover = m_pActMover, @om_nStr = m_nStr, @om_nSta = m_nSta, @om_nDex = m_nDex, @om_nInt = m_nInt, @om_nLevel = m_nLevel, @om_nExp1 = m_nExp1, @om_nExp2 = m_nExp2, @om_aJobSkill = m_aJobSkill, @om_aLicenseSkill = m_aLicenseSkill, @om_aJobLv = m_aJobLv, @om_dwExpertLv = m_dwExpertLv, @om_idMarkingWorld = m_idMarkingWorld, @om_vMarkingPos_x = m_vMarkingPos_x, @om_vMarkingPos_y = m_vMarkingPos_y, @om_vMarkingPos_z = m_vMarkingPos_z, @om_nRemainGP = m_nRemainGP, @om_nRemainLP = m_nRemainLP, @om_nFlightLv = m_nFlightLv, @om_nFxp = m_nFxp, @om_nTxp = m_nTxp, @om_lpQuestCntArray = m_lpQuestCntArray, @om_chAuthority = m_chAuthority, @om_dwMode = m_dwMode, @oblockby = blockby, @oTotalPlayTime = TotalPlayTime, @oisblock = isblock, @oEnd_Time = CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000', @om_Inventory = m_Inventory, @om_apIndex = m_apIndex, @om_adwEquipment = m_adwEquipment, @om_aSlotApplet = m_aSlotApplet, @om_aSlotItem = m_aSlotItem, @om_aSlotQueue = m_aSlotQueue, @om_SkillBar = m_SkillBar, @om_dwObjIndex = m_dwObjIndex, @om_Card = m_Card, @om_Cube = m_Cube, @om_apIndex_Card = m_apIndex_Card, @om_dwObjIndex_Card = m_dwObjIndex_Card, @om_apIndex_Cube = m_apIndex_Cube, @om_dwObjIndex_Cube = m_dwObjIndex_Cube, @om_idparty = m_idparty, @om_idMuerderer = m_idMuerderer, @om_nFame = m_nFame, @om_nDeathExp = m_nDeathExp, @om_nDeathLevel = m_nDeathLevel, @om_dwFlyTime = m_dwFlyTime, @om_nMessengerState = m_nMessengerState, @om_Bank = m_Bank, @om_apIndex_Bank = m_apIndex_Bank, @om_dwObjIndex_Bank = m_dwObjIndex_Bank, @om_dwGoldBank = m_dwGoldBank FROM BASE_VALUE_TBL WHERE g_nSex = @im_dwSex INSERT CHARACTER_TBL ( m_idPlayer, serverindex, account, m_szName, playerslot, dwWorldID, m_dwIndex, m_vScale_x, m_dwMotion, m_vPos_x, m_vPos_y, m_vPos_z, m_fAngle, m_szCharacterKey, m_nHitPoint, m_nManaPoint, m_nFatiguePoint, m_nFuel, m_dwSkinSet, m_dwHairMesh, m_dwHairColor, m_dwHeadMesh, m_dwSex, m_dwRideItemIdx, m_dwGold, m_nJob, m_pActMover, m_nStr, m_nSta, m_nDex, m_nInt, m_nLevel, m_nMaximumLevel, m_nExp1, m_nExp2, m_aJobSkill, m_aLicenseSkill, m_aJobLv, m_dwExpertLv, m_idMarkingWorld, m_vMarkingPos_x, m_vMarkingPos_y, m_vMarkingPos_z, m_nRemainGP, m_nRemainLP, m_nFlightLv, m_nFxp, m_nTxp, m_lpQuestCntArray, m_aCompleteQuest, m_chAuthority, m_dwMode, m_idparty, m_idCompany, m_idMuerderer, m_nFame, m_nDeathExp, m_nDeathLevel, m_dwFlyTime, m_nMessengerState, blockby, TotalPlayTime, isblock, End_Time, BlockTime, CreateTime, m_tmAccFuel, m_tGuildMember, m_dwSkillPoint, m_dwReturnWorldID, m_vReturnPos_x, m_vReturnPos_y, m_vReturnPos_z, m_SkillPoint, m_SkillLv, m_SkillExp ---------- Ver 15 , m_aCheckedQuest , m_nCampusPoint , idCampus ---------- Fraction , m_nFraction , m_nFractDeath , m_nFractKill ) VALUES ( @om_idPlayer, @iserverindex, @iaccount, @im_szName, @iplayerslot, @idwWorldID, @im_dwIndex, @om_vScale_x, @om_dwMotion, @im_vPos_x, @im_vPos_y, @im_vPos_z, @om_fAngle, @im_szCharacterKey, @om_nHitPoint, @om_nManaPoint, @om_nFatiguePoint, -1, --m_nFuel @im_dwSkinSet, @im_dwHairMesh, @im_dwHairColor, @im_dwHeadMesh, @im_dwSex, @om_dwRideItemIdx, @om_dwGold, @om_nJob, @om_pActMover, @om_nStr, @om_nSta, @om_nDex, @om_nInt, @om_nLevel, 1, --m_nMaximumLevel @om_nExp1, @om_nExp2, @om_aJobSkill, @om_aLicenseSkill, @om_aJobLv, @om_dwExpertLv, @om_idMarkingWorld, @om_vMarkingPos_x, @om_vMarkingPos_y, @om_vMarkingPos_z, @om_nRemainGP, @om_nRemainLP, @om_nFlightLv, @om_nFxp, @om_nTxp, @om_lpQuestCntArray, '$', -- m_aCompleteQuest @om_chAuthority, @om_dwMode, @om_idparty, '000000', -- m_idCompany @om_idMuerderer, @om_nFame, @om_nDeathExp, @om_nDeathLevel, @om_dwFlyTime , @om_nMessengerState, @oblockby, @oTotalPlayTime, @oisblock, @oEnd_Time, CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112), GETDATE(), 0, CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112) + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2) + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2) + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2), 0, --m_dwSkillPoint 1, 0, 0, 0, @im_SkillPoint, @im_SkillLv, @im_SkillExp -- Ver 15 , '$' , 0 , 0 , @im_nFraction , 0 , 0 ) INSERT INVENTORY_TBL ( m_idPlayer, serverindex, m_Inventory, m_apIndex, m_adwEquipment, m_dwObjIndex ) VALUES ( @om_idPlayer, @iserverindex, @om_Inventory, @om_apIndex, @om_adwEquipment, @om_dwObjIndex ) -- INSERT CARD_CUBE_TBL -- ( -- m_idPlayer, -- serverindex, -- m_Card, -- m_Cube, -- m_apIndex_Card, -- m_dwObjIndex_Card, -- m_apIndex_Cube, -- m_dwObjIndex_Cube -- ) -- VALUES -- ( -- @om_idPlayer, -- @iserverindex, -- @om_Card, -- @om_Cube, -- @om_apIndex_Card, -- @om_dwObjIndex_Card, -- @om_apIndex_Cube, -- @om_dwObjIndex_Cube -- ) IF @@SERVERNAME = 'WEB' OR @@SERVERNAME = 'SERVER4' SET @om_aSlotApplet = '0,2,400,0,0,0,0/1,2,398,0,1,0,0/2,2,2010,0,2,0,0/3,2,1005,0,3,0,0/4,3,25,0,4,0,0/$' INSERT TASKBAR_TBL ( m_idPlayer, serverindex, m_aSlotApplet, m_aSlotQueue, m_SkillBar ) VALUES ( @om_idPlayer, @iserverindex, @om_aSlotApplet, @om_aSlotQueue, @om_SkillBar ) INSERT TASKBAR_ITEM_TBL ( m_idPlayer, serverindex, m_aSlotItem ) VALUES ( @om_idPlayer, @iserverindex, @om_aSlotItem ) INSERT BANK_TBL ( m_idPlayer, serverindex, m_Bank, m_BankPw, m_apIndex_Bank, m_dwObjIndex_Bank , m_dwGoldBank ) VALUES ( @om_idPlayer, @iserverindex, @om_Bank, '0000', -- m_BankPw -- @im_BankPW, @om_apIndex_Bank, @om_dwObjIndex_Bank, @om_dwGoldBank ) INSERT SKILLINFLUENCE_TBL ( m_idPlayer, serverindex, SkillInfluence ) VALUES ( @om_idPlayer, @iserverindex, '$' ) INSERT INVENTORY_EXT_TBL ( m_idPlayer, serverindex, m_extInventory, m_InventoryPiercing ) VALUES ( @om_idPlayer, @iserverindex, '$','$' ) INSERT BANK_EXT_TBL ( m_idPlayer, serverindex, m_extBank, m_BankPiercing ) VALUES ( @om_idPlayer, @iserverindex, '$','$' ) -- Skill Information INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES (@iserverindex, @om_idPlayer, 1, 0, 0) INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES (@iserverindex, @om_idPlayer, 2, 0, 1) INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES (@iserverindex, @om_idPlayer, 3, 0, 2) -- Pocket INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' ) INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' ) INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' ) ------------------- ver. 13 insert into tblMaster_all (serverindex, m_idPlayer, sec) select @iserverindex, @om_idPlayer, 1 insert into tblMaster_all (serverindex, m_idPlayer, sec) select @iserverindex, @om_idPlayer, 2 insert into tblMaster_all (serverindex, m_idPlayer, sec) select @iserverindex, @om_idPlayer, 3 /* ?? ??? : ??? ???? ?? ??1 : ?? 1~20 ??? ?? ?? ???(????? ????? ?? ?? ??) ?? ??2 : ??? ??? ???? ??? ??? ?? ??? 23~27???(28 0?? ??) ?? ?? ??? 24~27???(28 0?? ??) */ ------------------- ver. 15 insert into tblRestPoint (serverindex, m_idPlayer) select @iserverindex, @om_idPlayer ------------ Penay check default setting insert into tblLogout_Penya (serverindex, m_idPlayer) select @iserverindex, @om_idPlayer /*"???????~!"*/ if (getdate() >= '2009-05-29 00:00:00' and getdate() < '2009-06-29 00:00:00') begin declare @i1_regdate datetime select @i1_regdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if (@i1_regdate >= '2009-05-29 00:00:00' and @i1_regdate < '2009-06-29 00:00:00') begin if not exists (select * from MANAGE_DBF.dbo.tblEvent_NewAcc_090529 where account = @iaccount) begin insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_bCharged, idSender) select @om_idPlayer, @iserverindex, '30191', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tblEvent_NewAcc_090529 (account, serverindex, m_idPlayer, m_szName) select @iaccount, @iserverindex, @om_idPlayer, @im_szName end end end --[Event.4] ???? ?? ???? if (getdate() >= '2009-12-29 10:00:00' and getdate() < '2010-03-02 10:00:00') begin declare @aregdate datetime select @aregdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount declare @id_no1 char(6), @id_no2 char(7), @itcount int if (@aregdate >= '2009-12-29 10:00:00' and @aregdate < '2010-03-02 10:00:00') begin select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount /* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/ select @itcount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__' and regdate <= '2009-12-29 10:00:00' --Event.1 ?? ?? ?? : ??? ???? (????) if (@itcount = 0) begin /* DECLARE @nMaxMailID int SELECT @nMaxMailID = MAX(nMail) + 1 from MAIL_TBL where serverindex = @iserverindex SET @nMaxMailID = ISNULL( @nMaxMailID, 0 ) EXEC dbo.MAIL_STR 'A1', @nMaxMailID, @iserverindex, @om_idPlayer, '0000000', 0, 0, 0, '?? ?? ???', '????? ??? ??????.', '26205', 3, 0, 0, 0, 0, 2 */ --ES ??? ????(20) (???: 26205) insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26314', 3, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_NewAccount_0912 (account, serverindex, m_idPlayer, m_Jumin) select @iaccount, @iserverindex, @om_idPlayer, @id_no1+@id_no2 end end -- Event.2 ????! ??? ????? ( ?? ??) if (getdate() >= '2010-02-22 10:00:00' and getdate() < '2010-02-23 10:00:00') begin --??? ????? ( ?? ??) -- @aregdate, @id_no1, @id_no2 ? ????? ???? ?? ?? if (@aregdate >= '2010-02-02 10:00:00' and @aregdate < '2010-02-23 10:00:00') begin /* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/ select @itcount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__' and regdate <= '2010-01-29 10:00:00' if (@itcount = 0 ) begin -- ?? 3? ?? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26919', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26920', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26921', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type) select @iaccount, @iserverindex, @om_idPlayer, 'N' insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001_account (account) select @iaccount end end --??? ????? (?? ??) if not exists (select top 1 * from MANAGE_DBF.dbo.tbl_Event_WSNB_1001_account (nolock) where account = @iaccount) begin -- ?? 3? ?? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26919', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26920', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26921', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type) select @iaccount, @iserverindex, @om_idPlayer, 'H' end end end /*[Event.1-2]?? ???? ???? ??~!! ? ???~ ???~ Start if (getdate() >= '2009-07-28 10:00:00' and getdate() < '2009-09-01') begin declare @aregdate datetime select @aregdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if (@aregdate >= '2009-07-28 10:00:00') begin declare @id_no1 char(6), @id_no2 char(7), @itcount int select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount -- select @itcount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(account, 4)), 2) <> '__' -- ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ?? select @itcount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__' and regdate <= @aregdate --Event.1 ?? ?? ?? : ?? ??? ???? (????) if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 where account = @iaccount) begin if (@itcount = 1) begin --??? ?? ??(???: 30191) insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000' --??? ?? ??(???: 26770) insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26770', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end --Event.2 ?? ?? ? ???? ??? ?? : ??? ??? ???? (????) if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2009-07-28') begin --?? ???? ?? (???? ???? ?? : 2082) declare @remem_id as varchar (32), @re_serverindex char(2), @re_m_idPlayer char(7) select @remem_id = remem_id from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount exec MANAGE_DBF.dbo.usp_Highest_Char @remem_id, @re_serverindex output, @re_m_idPlayer output -- select @remem_id, @re_serverindex, @re_m_idPlayer if @re_serverindex is not NULL and @re_m_idPlayer is not NULL begin if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 where account = @iaccount) begin if (@itcount = 1) begin insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 (account, serverindex, m_idPlayer, m_Item) select @iaccount, @iserverindex, @om_idPlayer, '30191' -- ???? ???? (??) declare @q001 nvarchar(4000) set @q001 = ' insert into CHARACTER_[&server&]_DBF.dbo.ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @re_serverindex, @re_m_idPlayer, ''2082'', 2, 1, ''0000000''' set @q001 = replace(@q001, '[&server&]', @re_serverindex) exec sp_executesql @q001, N'@re_serverindex char(2), @re_m_idPlayer char(7)', @re_serverindex, @re_m_idPlayer -- insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 (account, serverindex, m_idPlayer, m_Item) -- select @remem_id, @re_serverindex, @re_m_idPlayer, '2082' end end end end end end -- [Event.1-2]??? ???? ???? ??~!! ? ???~ ???~ End */ /* [Event.2]???~ ??? ????! Start if (getdate() >= '2009-02-24 10:00:00' and getdate() <= '2009-03-24 10:00:00') begin declare @aregdate datetime select @aregdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if (@aregdate >= '2009-02-24 10:00:00') begin declare @id_no1 char(6), @id_no2 char(7), @itcount int select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount select @itcount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL where id_no1 + id_no2 = @id_no1 + @id_no2 and left ((right(account, 4)), 2) <> '__' --?? ?? ?? : ?? ??? ???? (????) if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0902 where account = @iaccount) begin if (@itcount = 1) begin --FLY/FOR/FUN?? 30? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26666', 30, 1, '0000000' --FLY/FOR/FUN?? 30? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26667', 30, 1, '0000000' --FLY/FOR/FUN?? 30? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26668', 30, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0902 (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end --?? ?? ? ???? ??? ?? : ??? ??? ???? (????) if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2009-02-24') begin if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0902 where account = @iaccount) begin if (@itcount = 1) begin -- ??? ?? ????? ?? ???? ?? (2009-02-24 11:40) by ??? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0902 (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end end end end*/ /* [Event.2]???~ ??? ????! End */ /* [Event.5] ???? ???? ^^ Start if (getdate() >= '2009-03-03 09:00:00' and getdate() <= '2009-03-31 09:00:00') begin declare @a2regdate datetime declare @sex char(1) select @a2regdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount select @sex = [??] from WEB.ONLINE_DBF.dbo.USER_TBL where [??] = @iaccount if (@a2regdate >= '2009-03-03 09:00:00' and @sex = '2') begin --- ?? ??? ???? (????) if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_Women_0903 where account = @iaccount) begin --??? ?? ?? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '26770', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_Women_0903 (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end end*/ /* [Event.5] ???? ???? ^^ End */ /* ?? ??? : ??? ???? ?? ??1 : ?? 1~20 ??? ?? ?? ???(????? ????? ?? ?? ??) ?? ??2 : ??? ??? ???? ??? ??? ?? ??? 23~27???(28 0?? ??) ?? ?? ??? 24~27???(28 0?? ??) */ /* if (getdate() <= '2008-02-12 09:00:00') begin declare @regdate datetime, @check int select @check = count(*) from ACCOUNT_DBF.dbo.tblEvent_Board_Provide where account = @iaccount select @regdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if ((@check = 0) and (@regdate >= '2008-01-08 11:00:00')) begin declare @channel_check char(4) set @channel_check = right(@iaccount, 4) if (@channel_check = '__an') begin insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender) select @om_idPlayer, @iserverindex, '26533', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, @iserverindex, @om_idPlayer, @im_szName end else if (@channel_check = '__bu') begin if (getdate() <= '2008-02-08 23:59:59') begin insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender) select @om_idPlayer, @iserverindex, '26534', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, @iserverindex, @om_idPlayer, @im_szName end end else begin insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender) select @om_idPlayer, @iserverindex, '26532', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, @iserverindex, @om_idPlayer, @im_szName end end end */ /* if (getdate() >= '2008-07-30 00:00:00' and getdate() <= '2008-09-15 23:59:59') begin declare @aregdate datetime select @aregdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if (@aregdate >= '2008-07-30 00:00:00') begin declare @reaccount varchar(32) if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount) begin if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL where account = @iaccount) begin insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end end end */ /* if (getdate() >= '2008-12-17 10:00:00' and getdate() <= '2009-01-27 10:00:00') begin declare @aregdate datetime select @aregdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if (@aregdate >= '2008-12-17 10:00:00') begin declare @reaccount varchar(32) if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2008-12-16') begin if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0812 where account = @iaccount) begin insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0812 (account, serverindex, m_idPlayer) select @iaccount, @iserverindex, @om_idPlayer end end end end IF (GETDATE() BETWEEN '2004-06-23 18:00:00.000' AND '2004-06-27 23:59:59.999') INSERT ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, End_Time, m_bItemResist, m_nResistAbilityOption, m_bCharged) VALUES ('261007','01','?? ??? 12',2,0,NULL,0,0,1) */ SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer RETURN END END /* ?? ?? ?? ex ) CHARACTER_STR 'I1','',@iserverindex,@iaccount,@im_szName,@iplayerslot,@idwWorldID, @im_dwIndex,@im_vPos_x,@im_vPos_y,@im_vPos_z,@im_szCharacterKey, @im_dwSkinSet,@im_dwHairMesh,@im_dwHairColor,@im_dwHeadMesh,@im_dwSex CHARACTER_STR 'I1','','01','beat','????3',0,0, 0,0,0,0,'', 0,0,0,0,0 */ set nocount off RETURN

Warning: Second password system should be deactivated! Then add a new file, fraction.inc, in your client and server resource folder. The fraction.inc file is build like this:

Code:

 AddFraction "Inzest TV" //Name { nFractionID 1 // Fraction ID vPos 1 6973 100 3328 //Start Position dwColor 0xff00ff00 // Fraction Color } AddFraction "Anal mit dem Wal" { nFractionID 2 vPos 1 3237 11 3400 dwColor 0xff0000ff }

Finally add these files to your neuz, database and worldserver project:

dennisdra · 02/02/2012, 19:43

Also irgendwie glaube ich yannick und Pumbaa nicht, denn komischer Weise (und yannick machts normaler Weise nicht)
wurden die Kommentare in Englisch geschrieben:

Code:

BOOL CFractionManager::Load( LPCSTR lpszFile ) // loads the fraction data. default: fraction.inc
{
	v_Fractions.clear();
	CScript s;
	if( s.Load(lpszFile) == FALSE )
		return FALSE;

	while( s.tok != FINISHED )
	{
		s.GetToken();
		if( s.Token == "AddFraction" )  // parameter for adding a new fraction
		{
			FRACTIONPROP prop;
			s.GetToken();
			prop.szName = new char[strlen(s.token)+1];
			strcpy( prop.szName, s.token );
			s.GetToken(); // {
			while( s.Token != "}" )     // loop fraction data block

Aber dann kam es dazu, das Pumbaa in dem französischen Forum am Anfang ausversehen die Auktionshaus-Dateien hochgeladen hatte, später dies aber wieder entfernt hat.

So sehr ich yannick nicht mag... glauben tue ich ihm schon auf ne Weise, aber Pumbaa ebenfalls :x

Vielleicht ist es auch von keinem der beiden, sondern von Etioom (so wie damals das Colosseum-System...)

Pumbaaa · 02/02/2012, 19:47

Quote:
Originally Posted by dennisdra
Also irgendwie glaube ich yannick und Pumbaa nicht, denn komischer Weise (und yannick machts normaler Weise nicht)
wurden die Kommentare in Englisch geschrieben:
Code:
BOOL CFractionManager::Load( LPCSTR lpszFile ) // loads the fraction data. default: fraction.inc
{
	v_Fractions.clear();
	CScript s;
	if( s.Load(lpszFile) == FALSE )
		return FALSE;

	while( s.tok != FINISHED )
	{
		s.GetToken();
		if( s.Token == "AddFraction" )  // parameter for adding a new fraction
		{
			FRACTIONPROP prop;
			s.GetToken();
			prop.szName = new char[strlen(s.token)+1];
			strcpy( prop.szName, s.token );
			s.GetToken(); // {
			while( s.Token != "}" )     // loop fraction data block
Aber dann kam es dazu, das Pumbaa in dem französischen Forum am Anfang ausversehen die Auktionshaus-Dateien hochgeladen hatte, später dies aber wieder entfernt hat.

So sehr ich yannick auch hasse... glauben tue ich ihm schon auf ne Weise, aber Pumbaa ebenfalls :x

Vielleicht ist es auch von keinem der beiden, sondern von Etioom (so wie damals das Colosseum-System...)

Ich schreibe meine Kommentare, wenn ich welche schreibe, immer in Englisch...
Weil ich ein paar Leute aus England kenne, die sich ziemlich gut mit Coding etc auskennen und ich gerne Meinungen anderer, kompetenter Leute, einfahre...

Aber ist mir auch Latte, wer wem glaubt, ich gebs auf, hier kann man echt mit niemandem vernünftig kommunizieren, vllt sieht man sich ja iwann anders wieder, bin raus aus dieser Foren Szene.

Sedrika · 02/02/2012, 19:47

3 Seiten und davon 3 Seiten Spam, ausgenommen von eins oder zwei.

Habt ihr sie nicht alle ?

@Yannik: Du hast keinen Beweis, dass es von dir ist (allerdings muss ich dennisdra mit dem Post über mir zustimmen)

@Pumbaaa: Beweise ? Und löschen tue ich es wohlkaum. Einmal released ist es da, zudem wenn ich es lösche, ein anderer Packt es eh wieder hier hin.

Kassiert hat jetzt keiner aber weiteres wird bestraft.

Synxx© · 02/02/2012, 20:01

Die Resdata einträge fehlen^^

Mr.Greenthumb · 02/02/2012, 20:35

sagt mal sorry wenn ich nu dumm frage aber was is das für ein system was macht es und wofür ist es gut ? ^^

420twisted1 · 02/02/2012, 20:36

can you please re upload to another site this one doesn't work in my country

Mr.Greenthumb · 02/02/2012, 20:41

der download wurde entfernt ^^ hat jemand einen reup?

@ Twisted
this download is permanent deleted

archerbow120 · 02/02/2012, 20:45

What is Fraction System?

Shiaru · 02/02/2012, 20:47

Fraction System like in World of Warcraft or other online-games.

dennisdra · 02/02/2012, 20:49

Und jetzt braucht mir hier niemand ankommmen vonwegen warum uppst du das...
Die sind im Französichen Forum auch hochgeladen worden via Multiupload...

~~.Crasy^~~ · 02/02/2012, 20:50

Quote:

Originally Posted by archerbow120

What is Fraction System?

User can select @ create char an fraction, like "A" and "B".

Fraction leaked by 4Story, "Derion" & "Valorian", nice one.

Und was bringt es am Ende? Yannick, sag mir den Sinn hinter Fraction? Ich bin in Fraction A, kann mit dir in B 0 machen, sinn?

~~yannickFlyff~~ · 02/02/2012, 21:02

Ich find das Fractionssystem eh scheise.

Wenn dann würde ich machen das Magier und Psy in Fraktion A ist und Acrobat und Mercenary in Fraktion B.

Das sie utnerschiedlich spawnen auf versch. maps etc ^^

Lumi · 02/02/2012, 21:27

Was bringt der Fraction System genau ? o_O
Wozu ist er Nützlich ? o:

~~Flash!~~ · 02/02/2012, 21:31

Jo Lumi wozu ist er nützlich, der Fraktions-System ..

Meine Güte liest doch einfach die letzten Post dann wisst ihr was Sache ist.
Es sind zwei verschiedene Nationen sozusagen die sich gegenseitig verfeinden und somit
auch jederzeit bekämpfen können.

Für Leute die wirklich kreativ sind &' ein wenig Hirn haben, die können das gebrauchen.
Das kann man ausbauen, beispielsweise das was Yannick sagte.

Wirklich aktiv nutzen wird das kein erfolgreicher Server.