[SourceCode] AO 4.6 Full source code VS2019

[inetpub]

Hello,
after long time when only a few people had this, now you can get this too.
1. Base source code is 4.6 from St34lth4ng3l package.
2. I have updated it to vc142 and reworked directory structure.
3. I have translated contents.h to humanish (not using google translate but checking src and commenting what is it)
4. No other mods or bugs or backdoors has been added instead of these which was there originally.
5. Password is "long,fame and others who always had all and never shared poop - lick my ballz fuckers" without quotes
6. As password says - it is extremaly fucked in this community that there are haves and have-nots so now you can start flame that you have opportunity to work on something other than currently released stuff.

LINK (vs2019 pw above):

You must be registered to see links

LINK (vs6 - no password) :

You must be registered to see links

Please don't spam my pm,
Cheers

 

[xxradicaldxx]

I hope that seeing this important contribution is good for everyone and they are not asking how it is compiled.
Enjoy it guys and take a little time so you can update certain things and don't create random servers

 

[St34lth4ng3l]

I like that password

Edit: As this one is a really important release in this section, maybe someone of the moderation team could pin this thread?

 

[Emirr]

Ty for share. Can you share a 4.6 DB?

 

[St34lth4ng3l]

Ty for share. Can you share a 4.6 DB?

I don't have a clean 4.6 DB and i don't know how far he is with updating exisiting ones to EP 4.6 so you probably have to wait or do it on your own... sorry

 

[xxradicaldxx]

It is necessary to wait for the last contribution

Who will it be?

 

[Emirr]

I don't have a clean 4.6 DB and i don't know how far he is with updating exisiting ones to EP 4.6 so you probably have to wait or do it on your own... sorry

Oh okey. Then is there any alternative database you can suggest ?

 

[Davidc96]

In the Database > MSSQL folder, there are SQL text files which creates databases, I don't know if those SQL files contains all the database but most of the tables, are in those files.

 

[xxradicaldxx]

First of all thanks to inetpub

For the Database you can use any, but you will have to add several missing procedures and maybe some tables

MSSQL creates the Database but not the entire database (Something will always be missing)

 

[vinleprince]

Oh okey. Then is there any alternative database you can suggest ?

maybe you can waiting for relase db, or upgrade from ep4.3there not much thing different.

============================
- Item Event Check
[Edit Account DB]
ti_ItemEvent (+2 Fields for GiveItemAtTime as datetime, ChannelingType as int)
 
[Edit Produce]
atum_GetEventItemList (+1 Select for CheckWithCharacterUID)
atum_insert_Log_ItemEvent (+1 Fields for CheckWithCharacterUID)
atum_update_Log_ItemEvent_fixed_period (+1 Fields for CheckWithCharacterUID)
atum_Load_ItemEvent (+2 GiveItemAtTime, ChannelingType)
=====================
- Combat Power
[Create DB]
atum_log_combatpower ([Time] as datetime ,[TotalANI] as int ,[TotalBCU] as int)
 
[Create Produce]
atum_Insert_CombatPowerLog (@time as vachar 30,@ani as int,@bcu as int) insert to atum_log_combatpower
==================
- Change Inf Count *Produce that might be already have, but require
 
[Create DB]
atum_NumberOfChangeInfl (AccountUniqueNumber as int ,NumberOfChangeInfl as tinyint)
 
[Create Produce]
atum_GetNumberOfChangeInfl (Select  [USER=420555]Aid[/USER] as int, select NumberOfChangeInfl where  [USER=420555]Aid[/USER], if empty return 0)
atum_SetNumberOfChangeInfl (2 param  [USER=420555]Aid[/USER] int  [USER=138004]count[/USER] as tinyint. if exist use update instend of insert, )
=========================
- Happy Hour extend
[Edit Account DB]
ti_HappyHourEvent (+8 field as float HPRecoveryRate, SHDRecoveryRate, SPRecoveryRate, WeaponEnchantRate, ArmorEnchantRate, ETCItemEnchantRate, SPIDiscountRate, WPDiscountRate)

* dont forget edit produce select for +8 fields
=========================
SP Level Log
[Edit 1 DB]
atum_log_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel)
 
[Edit Produce]
atum_log_Insert_SPWar (+3 Fields tinyint for  SPLevel, BCUNextSPLevel, ANINextSPLevel)
 
 
[Add Produce]
atum_Get_Summon_SPLevel (1 param for @LogType as tinyint / select top one from 2 fields for BCUNextSPLevel, ANINextSPLevel where param->logtype order by SPWarEndTime desc)
 
===========================
Armor Event
[Edit Account DB]
td_MonthlyArmorEvent (+1 Field int for Duration)
 
[Edit 1 DB]
td_Collection (+2 Fields for MAEOptionItemNum as int , MAEDurationTime as datetime)
 
atum_GetCollectionList (+2 select MAEOptionItemNum, MAEDurationTime)
atum_UpdateCollectionInfo (+2 update MAEOptionItemNum as int, MAEDurationTime as datetime *also add update line)
atum_GetMonthlyArmorEventByServer (+1 Select for Duration)
 
=========================
Tradecenter & Destroy Auction
 
[Require Produce]
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetItemList
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetAuctionItem
atum_DestroyAuction_UpdateBiddingInfo
atum_DestroyAuction_GetBiddingInfo
atum_DestroyAuction_SetClearDestroyAuction
atum_DestroyAuction_InsertDestroyAuctionListup
atum_DestroyAuction_Get_LogData_byItem
atum_DestroyAuction_Get_LogData_byCondition
atum_Market_Insert_ItemRegist
atum_Market_Get_Enchant_Info
atum_Market_Get_td_Enchant
atum_Market_BuyTradeItem
atum_Market_GetTradeItem
atum_Market_Get_SaleList
atum_Market_Get_MarketList
atum_Market_RemoveInfo
atum_Market_Get_LogData
=========================
Additional Produce that not much important (check source if want to upgrade, it have some sql line there)
atum_GetCashBuyDateByAccountExtUID
atum_InsertCashBuyDate
atum_InsertFirstPurchaseFromXMLRPC
atum_GetFirstPurchaseFromXMLRPC
atum_GetCombatPowerFromTOOL

 

[Emirr]

maybe you can waiting for relase db, or upgrade from ep4.3there not much thing different.

============================
- Item Event Check
[Edit Account DB]
ti_ItemEvent (+2 Fields for GiveItemAtTime as datetime, ChannelingType as int)
 
[Edit Produce]
atum_GetEventItemList (+1 Select for CheckWithCharacterUID)
atum_insert_Log_ItemEvent (+1 Fields for CheckWithCharacterUID)
atum_update_Log_ItemEvent_fixed_period (+1 Fields for CheckWithCharacterUID)
atum_Load_ItemEvent (+2 GiveItemAtTime, ChannelingType)
=====================
- Combat Power
[Create DB]
atum_log_combatpower ([Time] as datetime ,[TotalANI] as int ,[TotalBCU] as int)
 
[Create Produce]
atum_Insert_CombatPowerLog (@time as vachar 30,@ani as int,@bcu as int) insert to atum_log_combatpower
==================
- Change Inf Count *Produce that might be already have, but require
 
[Create DB]
atum_NumberOfChangeInfl (AccountUniqueNumber as int ,NumberOfChangeInfl as tinyint)
 
[Create Produce]
atum_GetNumberOfChangeInfl (Select  [USER=420555]Aid[/USER] as int, select NumberOfChangeInfl where  [USER=420555]Aid[/USER], if empty return 0)
atum_SetNumberOfChangeInfl (2 param  [USER=420555]Aid[/USER] int  [USER=138004]count[/USER] as tinyint. if exist use update instend of insert, )
=========================
- Happy Hour extend
[Edit Account DB]
ti_HappyHourEvent (+8 field as float HPRecoveryRate, SHDRecoveryRate, SPRecoveryRate, WeaponEnchantRate, ArmorEnchantRate, ETCItemEnchantRate, SPIDiscountRate, WPDiscountRate)

* dont forget edit produce select for +8 fields
=========================
SP Level Log
[Edit 1 DB]
atum_log_SPWar (+3 Fields tinyint for SPLevel, BCUNextSPLevel, ANINextSPLevel)
 
[Edit Produce]
atum_log_Insert_SPWar (+3 Fields tinyint for  SPLevel, BCUNextSPLevel, ANINextSPLevel)
 
 
[Add Produce]
atum_Get_Summon_SPLevel (1 param for @LogType as tinyint / select top one from 2 fields for BCUNextSPLevel, ANINextSPLevel where param->logtype order by SPWarEndTime desc)
 
===========================
Armor Event
[Edit Account DB]
td_MonthlyArmorEvent (+1 Field int for Duration)
 
[Edit 1 DB]
td_Collection (+2 Fields for MAEOptionItemNum as int , MAEDurationTime as datetime)
 
atum_GetCollectionList (+2 select MAEOptionItemNum, MAEDurationTime)
atum_UpdateCollectionInfo (+2 update MAEOptionItemNum as int, MAEDurationTime as datetime *also add update line)
atum_GetMonthlyArmorEventByServer (+1 Select for Duration)
 
=========================
Tradecenter & Destroy Auction
 
[Require Produce]
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetItemList
atum_DestroyAuction_AddItem
atum_DestroyAuction_GetAuctionItem
atum_DestroyAuction_UpdateBiddingInfo
atum_DestroyAuction_GetBiddingInfo
atum_DestroyAuction_SetClearDestroyAuction
atum_DestroyAuction_InsertDestroyAuctionListup
atum_DestroyAuction_Get_LogData_byItem
atum_DestroyAuction_Get_LogData_byCondition
atum_Market_Insert_ItemRegist
atum_Market_Get_Enchant_Info
atum_Market_Get_td_Enchant
atum_Market_BuyTradeItem
atum_Market_GetTradeItem
atum_Market_Get_SaleList
atum_Market_Get_MarketList
atum_Market_RemoveInfo
atum_Market_Get_LogData
=========================
Additional Produce that not much important (check source if want to upgrade, it have some sql line there)
atum_GetCashBuyDateByAccountExtUID
atum_InsertCashBuyDate
atum_InsertFirstPurchaseFromXMLRPC
atum_GetFirstPurchaseFromXMLRPC
atum_GetCombatPowerFromTOOL

Where should i apply this code ?

 

[xxradicaldxx]

Where should i apply this code ?

the code is not done.It is only giving you the clues where you have to add or edit and what procedures are missing so that everything can work.

 

[PhatLA]

EP406 BossReward Table from VTC-Game server

 

[fyrjzy]

which client can use?

 

[xxradicaldxx]

which client can use?

You can use any

 

[fyrjzy]

You can use any

but,server side crash ,like :
08-01 01:01:27.286|Socket Closed SocketIndex[ 3] SocketType[7] PeerIP[ 192.168.1.200] Port[26634] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
08-01 01:01:48.382|[ERROR] CIOCP::Worker() IOCPSocket End 3 error[64] Overlapped[45687668] Overlapped Type[2], ThreadID[17940]
08-01 01:01:48.382|Socket Closed SocketIndex[ 1] SocketType[5] PeerIP[ 192.168.1.200] Port[26495] MaxWriteBufCounts[ 1] ==> reason 5[0X000005]
08-01 01:01:48.383| Closed FieldServer( 192.168.1.200:26495), ServerGroupName( Test46)

 

[inetpub]

Now i definitely understand why noone was shared this before. Dude- use newest masang client with your engine , launcher and omi. If youre still stuck at the beginning of the road means you should learn more or give up

 

[xxradicaldxx]

but,server side crash ,like :
08-01 01:01:27.286|Socket Closed SocketIndex[ 3] SocketType[7] PeerIP[ 192.168.1.200] Port[26634] MaxWriteBufCounts[ 1] ==> reason 6[0X000006]
08-01 01:01:48.382|[ERROR] CIOCP::Worker() IOCPSocket End 3 error[64] Overlapped[45687668] Overlapped Type[2], ThreadID[17940]
08-01 01:01:48.382|Socket Closed SocketIndex[ 1] SocketType[5] PeerIP[ 192.168.1.200] Port[26495] MaxWriteBufCounts[ 1] ==> reason 5[0X000005]
08-01 01:01:48.383| Closed FieldServer( 192.168.1.200:26495), ServerGroupName( Test46)

You can't fix a simple mistake xDD



I ask myself the following question.
Could you add everything missing in the DB?
So you try to enter it will give you errors for not having everything you need in the DB

 

[fyrjzy]

You can't fix a simple mistake xDD



I ask myself the following question.
Could you add everything missing in the DB?
So you try to enter it will give you errors for not having everything you need in the DB

thanks ,i will try

 

[PhatLA]

after trying to clone the code 4.6 into my source, and add new Tables + Stores, it worked 70%.

Thank you for sharing.