Ep3 serveur : some random questions to finish it

[desp08500]

Hi guys, it's me again, i open a new thread to not charge the other one and post my others questions again. I know i ask a lot of questions i'm a boring guy lol.

So my first question is :

I got some problem to get a working 3021,3024, 3041 and 3044.sma. Anyone can send me a working ones or explain me what informations i have to modify in it ?

And the second one is :

I try an advanced base today (akron to be precise),the start is ok the kill is ok and system know what guild take it but alt+clik on base don't work,no error message and no more error message on log,anyone has an idea of why?

Alt click zone not working or something wrong in database? don't know.

PS=> I know this thread looks like the "must read thread" and i hope it's look like it, anyway the goal of it is to make another thread like it and sur for help me too (:p), i hope make an organise thread when all is ok on my serv.

[MentaL]

[desp08500]

Hum no one got an idea?

[PanKJ]

Hhm. What do you mean your smas work? Maps dont load or creatures dont spawn? Did you create them or just used an sma and editted the spawns? As for your adv base problem, i heard something similar before, but i have only tested adv wars once and i dont remember details.

[desp08500]

Woups i forget to say it, it'sok for my sma, i find my error alone, and for adv base i always search what the problem atm. And now that i test mothership, i see that when i spawn it my fieldserver crash, i don't know what"s the problem with that too,maybe win7 problem? :s

And i see that on my field server log :

06-03 17:25:11|[Notify] ..\config/./../map/Res-EXE/ACEONLINE.ATM is loaded for CheckSum
06-03 17:25:11|[Notify] CFieldIOCP::LoadResObjCheckList_ success !! CheckSum File Count: 3828
06-03 17:25:12| [Notify] CFieldIOCP::IOCPInit# success to DBLoadDBServerGroup, LimitUserCnt(100) IsLockCreateNewAccount(0)
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Hate: 2097200] MPOption[0x23] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Santa Cat: 2101000] MPOption[0x30] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ \wChoco Boy\w: 2093000] MPOption[0x30] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Minor Kreacia: 2091300] MPOption[0x30] MPParam1[0] MPParam2[0]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Bishop: 2001800] TotalUsingPercent[30]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Hell Lion: 2015600] TotalUsingPercent[50]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Munitions Warehouse: 2016600] TotalUsingPercent[30]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[\eAnubis\e \yLV[5]\y: 2027200] TotalUsingPercent[130]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ \cHoros\c \yLV[5]\y: 2027300] TotalUsingPercent[130]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Lilith: 2039400] TotalUsingPercent[70]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Lilith: 2040800] TotalUsingPercent[70]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Lilith: 2040900] TotalUsingPercent[70]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Griph: 2041100] TotalUsingPercent[50]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ \eHellion Snoto\e: 2048800] TotalUsingPercent[50]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Sekhmete Guard: 2049000] TotalUsingPercent[50]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ \eGriph Typhon\e: 2054300] TotalUsingPercent[50]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Not decieded: 2056500] TotalUsingPercent[30]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ \wCrazy Snowman\w: 2060600] TotalUsingPercent[105]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Ksar: 2061700] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Queen Purion: 2062500] TotalUsingPercent[50]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_3 MoveTypeCheck error, MonsterName[Missile Cannon Tower: 2062900] MonsterForm[0x 9] MovePattern[0x4]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Naros: 2064300] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Ellos: 2064400] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ Tart: 2066100] TotalUsingPercent[70]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Ksar: 2069000] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Ksar: 2069600] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Naros: 2069900] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Ellos: 2070000] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Naros: 2070200] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[Error] CMonsterDBAccess::GetAllMonsters_4 MPOption error, Monster[ Mega Ellos: 2070300] MPOption[0x22] MPParam1[0] MPParam2[0]
06-03 17:25:12|[ERROR] CMonsterDBAccess::GetAllMonsters_2 Monster Item percent error !!, MonsterName[ \eTess Tart\e: 2080300] TotalUsingPercent[70]

i see on the must read forum someone who was speaking about it then say it's ok i find what the problem,but don't say anymore about it

[PanKJ]

Apparently some data in these rows isnt correct. Simply try to fix it. Im using data from omi so i dont know what you gotta do to fix it without it.

[desp08500]

Humm ok I will take a look on that sooner or later,but tell me i try to make a GM account and so use the type at 125 but the gear come in green name and seems to be a leader not a gm,i know that 128 is GA but for gm now i'm not sure

[l34V3]

Humm ok I will take a look on that sooner or later,but tell me i try to make a GM account and so use the type at 125 but the gear come in green name and seems to be a leader not a gm,i know that 128 is GA but for gm now i'm not sure

0 - Normal user
128 - Admin user
256 - GameMaster user

...

[desp08500]

Ok thx for this info. But no one got an idea about the field server crash when activate a ms or about advanced base (no alt+clik)?

Hummm i try 256 for GM ut aparently that not work,i try 64 but nothing

---------- Post added at 10:00 AM ---------- Previous post was at 09:25 AM ----------

ok found it, it's 255 ....

[l34V3]

Ok thx for this info. But no one got an idea about the field server crash when activate a ms or about advanced base (no alt+clik)?

Hummm i try 256 for GM ut aparently that not work,i try 64 but nothing

---------- Post added at 10:00 AM ---------- Previous post was at 09:25 AM ----------

ok found it, it's 255 ....

0 - Normal
128 - Administrator
256 - Gamemaster
512 - Monitor
1024 - Guest
2048 - For demo

and that isn't 255 ...

On top of that imho, you should get a bit more knowledge about differences between GM account and Admin account in AceOnline.

[desp08500]

Man i have no reason to lie,when i use 256 that was not working,when i put 255 i log the account then see logging as game master,it's maybe an error on my db but i don't lie ok. Don"t feel that like an attaque, i just say what i see keep cool with that it's not a big problem... and i understand what the diference betwwen GA and GM thx ....and anyway 255 or 256 that stay a ^2 or 256-1 not so bad anyway.

[l34V3]

Man i have no reason to lie,when i use 256 that was not working,when i put 255 i log the account then see logging as game master,it's maybe an error on my db but i don't lie ok. Don"t feel that like an attaque, i just say what i see keep cool with that it's not a big problem... and i understand what the diference betwwen GA and GM thx ....and anyway 255 or 256 that stay a ^2 or 256-1 not so bad anyway.

Mate , at the end im telling you a proper way how to do things. And you keep doing shit in wrong way. Your call but if you would at least try to understand how those servers work ... You would see to what -numbers- account type is changing at MSSQL when you use gmtools.

And yeah, strange enough that masangsoft made it that way (256) and you are using 255, that means 2 things A) You fucked something up B) You are running flyff server maybe? Not AO.

[desp08500]

Cause i want a proper way i continu to search why this things happened,i see a searchoptioninfo on character i put it to 8196 like my GA account,don't know why,i put it back to 0 then put 256 value,now 256 is GM account, i don't really know what this is for but now i got the good way. And for information, i modify ga/gm tools with ace online patcher but return all time wrong ip value or "preserver not execute". And for moment,i think that i'm not so bad to understand this server, i'm in a far way to conclude i know it,but for moment,i modify stuff,make acocunt,weapon,modify drop list set up ms time sp and avanced base,it's not a bad start i think. Ok i got some bug in alt-clik on base and a fieldserver crash on ms active or after kill. But i think you don't tell me that i don't really try to understand how to do.

---------- Post added at 07:06 PM ---------- Previous post was at 06:50 PM ----------

Oh and cause i promise to give some informations to all like i can,i will give some sql things to all that is really interesting for beginner:

Look inventory :

SELECT a.accountname, c.charactername, i.Itemname, s.*
FROM td_Store s, atum2_db_account.dbo.td_account a, td_Character c, atum2_db_account.dbo.ti_Item i
WITH (NOLOCK)
WHERE c.accountname LIKE '%name of acc%' AND c.charactername LIKE '%name of character%' AND a.AccountUniqueNumber = s.accountuniquenumber AND s.possess = c.uniquenumber AND s.Itemnum = i.Itemnum
ORDER BY c.charactername, s.Itemnum

enchant weapon :

USE [atum2_db_1]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[atum_InsertEnchant]
@i_TargetItemUniqueNumber = num,
@i_TargetItemNum = num,
@i_EnchantItemNum = num

SELECT 'Return Value' = @return_value

GO

Make weapon prefix/suffix :

UPDATE td_Store
SET PrefixCodeNum = @i_PrefixCodeNum, SuffixCodeNum = @i_SuffixCodeNum
WHERE UniqueNumber = @i_ItemUID

Delete an item from an inventory:

USE [atum2_db_1]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[atum_DeleteStoreItem]
@accNum = 1,
@uniqueNum = 252085

SELECT 'Return Value' = @return_value

GO

Some info about a gear :

SELECT *, dbo.atum_GetGearString(UnitKind) AS Gear
FROM td_character
WHERE race <or>or= 128

Most of them are in stored procedure but maybe some people don't see them.


My new sql command personnal that some people need i think :

select MI.MonsterUniqueNumber, m.MonsterName, Mi.ItemNum,i.ItemName, Mi.Probability
from dbo.ti_MonsterItem MI left join dbo.ti_Monster m on M.uniquenumber=MI.monsteruniquenumber inner join dbo.ti_item i on i.itemnum=Mi.itemnum
WHERE MonsterName LIKE '%""%'
ORDER BY M.MonsterName

This one will help you to see what drop and other informations can be set about drop list on a mob.

Hope that will help some peoples.

---------- Post added at 07:21 PM ---------- Previous post was at 07:06 PM ----------

Exemple of what the last command can give you :
Here is some lines for Echelon :
2063700 \rEchelon\r 7000022 SPI 1000000
2063700 \rEchelon\r 7000630 Standard Attack Card 100000
2063700 \rEchelon\r 7000640 Advanced Attack Card 100000
2063700 \rEchelon\r 7000650 Standard Quick Fire Card 100000
2063700 \rEchelon\r 7000660 Advanced Quick Fire Card 100000
2063700 \rEchelon\r 7000670 Standard Weight Card 100000
2063700 \rEchelon\r 7002500 Devilhunter VII 32258
2063700 \rEchelon\r 7002530 Advanced Weight Card 100000
2063700 \rEchelon\r 7002540 Standard Time Card 100000

SELECT MI.MonsterUniqueNumber, m.MonsterName, MI.ItemNum, i.ItemName, MI.Probability
FROM ti_MonsterItem AS MI LEFT OUTER JOIN
ti_Monster AS m ON m.UniqueNumber = MI.MonsterUniqueNumber INNER JOIN
ti_Item AS i ON i.ItemNum = MI.ItemNum
WHERE (m.MonsterName LIKE '%Echelon%')
ORDER BY m.MonsterName

[desp08500]

Is the pad(supply shop) info is in dat or something? cause i have all pandea pad not working (some mission pandea pad working)

[PanKJ]

Pad info is stored both in dat and sma. But, the special thing about sma is that the building id of the shop that should be opened when you land is also stored. This means it wont work without correct sma. So, since you have the official dats i suppose dat is ok. As for sma, i wont tell you how to edit it. But since you have a sma with which the pad works you can simply use it and, optionally, edit the spawns. If you really want to edit sma, i suggest you start by reading an old post of mine briefly explaining the sma format. Editing sma or dat manually or even finding the format and what each value means without using a custom program will be hard for noobs tho and therefore not recommended (unless you know coding).

Now use your brains. I hope this was some food for thought and a good point towards the right direction, but I wont give you everything on a silver plate.

[DragonLord]

Well put and nicely summed, PanKJ.
We (The people who have made progress) refuse to spoonfeed you lot, we expect you to use whatever limited tools and intelligence you have to make progressions and new developments.