3.12 Delta#2

[neotokyo]

(this is in no way an official delta, but i like the name ;-)

Win32 Binaries (http://denial.dyndns.org/eqemu/neotokyo/bin.w32/)

i would like some people to download the exes (i cant guarantee they are virus free, i just swear i didnt put any malignant code there intentionally)

only a few changes in it, but they spread through half of the code and so i need someone to test them some more. i did some initial tests and i think it works fine.

now its up to you to prove me wrong.

whats to test:
mobs now will assist each other if the faction is the same, mobs have an aggroradius that can be set in the database for each type of mob (or let the program set it for you, if you're lazy). in addition to that, caster will heal nearby mobs that are hurt, and they will buff nearby mobs. and mobs will go into a frenzy if you are hurt enough (< 20%)

now i need you to run around and see if mobs cast the correct spells, if they assist correctly, and nothing crashes.

esp. i need some multimob, multitank situations, which i cant do on my own. let one tank get down to <20% and see if the mobs frenzy on him, then heal him back to full and see if the mobs return to their former state (i.e. fighting the other guy). mobs that werent engaged in combat before frenzy will stay on the player until one of them is dead.

known issues:
if you dont set the mana regen in the DB, dont expect mobs to cast for all eternity. mobs have as much mana as normal PCs and they WILL run out of mana if you dont give 'em some mana regen.

[neotokyo]

silly me,

you need one more file:

Database update script (http://denial.dyndns.org/eqemu/neotokyo/bodytype_diffs/bodytype_upd.sql)

add this like all the other .sql files

if you set AILevel to 0 or 1, almost all the new features will be disabled.

and one more: rename the ZoneGF.exe and WorldGF.exe to Zone.exe and World.exe or rewrite your batch files ...

[tamarae]

If you'd toss up the source code, I'd compile it for linux and put it up on the Dominare server to play with for a few days. :)

[neotokyo]

Diff Reports to 3.12 (http://denial.dyndns.org/eqemu/neotokyo/bodytype_diff/)
Holy Sources, Batman .... (http://denial.dyndns.org/eqemu/neotokyo/bodytype/)

there ya go

[tamarae]

I'll see about getting it compiled and up this afternoon before/during/after class and let ya know what I make of it.

Just outta curiosity (without looking at the source) does it have all of the rolled in changes that Trumpcard started with a few days ago?

Also - Anyone know real quick and easy how I can back up my database (I wanna make an exact copy of the one I have working right now, but call it eqbak) I'm not so mysql smart yet.

[neotokyo]

Tamarae
FIX: Avatar Proc bug and neutralize magic weapon add

check if your own changes are in the files, if yes then i merged all changes. if no, hm ...

[tamarae]

duh me. :P And the answer is no :) its stock 3.12 code

[Trumpcard]

http://denial.dyndns.org/eqemu/neotokyo/bodytype_diffs/


The URL to the diffs was wrong.

Alot of changes in there! I was hoping I'd see diffs for 2 or 3 files.

[neotokyo]

i hope you are not too disappointed trump ;-)

[neotokyo]

merged trumps changes and uploaded the sources and a new ZoneGF.exe (NOT the diffs !)

the avatar fix, the hand2hand fix and the loot fix should be in ...

[Bardboy]

If you need a body to log on and help test, just let me know when and where.

[Trumpcard]

I was going to do the same thing when I got home neo, thanks for doing it !

Edit: Neo, made one change to your source to get it to compile on linux, added #include <stdlib.h> to NpcAI.cpp

[tamarae]

Alrighty, its in on my server and the server is being booted now. Anyone who wants to play and do some testing is welcome.

[Trumpcard]

Works good.. 70 is the default in database.cpp, i'd put that in a variable like you did with AIlevel rather than hardcoding it (just as easy to do 'update npc_types set aggroradious='somenumber' ' , but easier on the sql unaware).

One thing that should be implemented is a max attackers, as it stands now, you'll pull the entire mass of clustered mobs, i know in eq you pull a maximum of what, like 4 or 5 at a time? I didnt look, but is your code taking into account z axis for calculating agro?

We should try and figure out how to get taunt working again, the code is there in client_process but the way hate_list is handled is changed so it will probably have to be modified . Also, anyone have any idea what it will take to get ranged weapons implemented? I was going to look into it, but couldnt find in attack.cpp where range was taken into account.

[BootyBill]

Been testing the new binaries the past hour or so. Some things I've found:

Casting any necro pet crashes zone.exe. Lifetaps and lifetap dots don't do any damage to mob nor do they appear to give any life to PC.

Mob agro radius does not appear to have worked when pulling agroed mobs past other mobs on the same faction.

Disconnection happens after killing an npc with no apparant warning. The packet loss indicator stays even and does not show you going LD.

All commands apear to stop working once in a while when attacking an npc. I thought this might be due to packet latency but I was wrong after testing it across my 100Mbit LAN.

Even though I am fairly adept at Mysql now I still cannot seem to make a certain faction KOS (-1000) to all through database field modification so I thus cannot test other NPC agro radius issues.

Any way I can help with anything? I am adept at programming Pic microcontrollers in ASM, but have not done any C programming in years = ( Sounds like a good time to relearn I guess..... Any other way I can help with database cleanup/modification?

Bill

[BootyBill]

P.S. I could not do much testing on Tamarae's server considering I had no commands avail. Thus all the testing was done on 3.13-DR1 and my own 3.12 with new binaries posted by Questor. Appear to both act similarly.

Bill

[Trumpcard]

Did you set the AILevel to 5 via the dbupdate,sql script?

If you dont, AI functions will not be used. I made that mistake at first.

[tamarae]

Bleh sorry about that with the commands, I was playing with it the other day and forgot to put it all back.. lol

[neotokyo]

first off all: a big thank you to all the people that offered to test my changes, and to tamarae for hosting the server.

as for the seemingly unrelated not working features:
thats what you get if you try to optimize functions you dont really understand ... let that be a lesson to you all ;-))

-- lifetaps (and all other damaging spells) should work again.
(was a problem in the damage calculation i tried to make work properly)

-- casting pets should no longer crash the zone.
(just silly programming error on my side)

concerning latency times and disconnects: the code for "NPC-AI" is kinda long, as far as runtime is concerned. on slower machines it could be possible that the server misses some packages or something. i hope with a little outside help we can get the "AI" to work a bit faster. (if thats the problem at all, i got random PL even before the AI was coded - time will tell ...)

the new files are available on the ftp-server. these files are new:
attack.cpp (http://denial.dyndns.org/eqemu/neotokyo/bodytype/attack.cpp)
MiscFunctions.cpp (http://denial.dyndns.org/eqemu/neotokyo/bodytype/MiscFunctions.cpp)
NpcAI.cpp (http://denial.dyndns.org/eqemu/neotokyo/bodytype/NpcAI.cpp)
spells.cpp (http://denial.dyndns.org/eqemu/neotokyo/bodytype/spells.cpp)

[tamarae]

Going to shower to get ready for class, and then I'll roll the new changes in to play with. It'll be up on my server within the hour. I did set the other gm commnds back down to level 0 in addon.ini, sorry about those who tried to help test and couldnt. I forgot I was fiddling the other day, and never put it back. :D

I swear I'm not always this scatterbrained.. only always at the end of the semester near final exams..hehe

[BootyBill]

Working well now. NPC agro is correct, Weap Proc works, Pet casting works, npc casting works. Will test more in a bit.

Issue with being unable to use any command might be related to Mysql. It seems when this happens that the database is not able to be queried by other players on the server. Doing a /q and coming back in solves this for the person locked up and seems to allow the other processes access to the database once more. No packet latency is apparent on the meter during this time.

All this testing was done on Tamarae's server.

Bill

[neotokyo]

bill, can you try and explain the problem with the commands again. i am not clear what you are trying to say.

the commands were disabled on Tam's server and enabled this morning. could that explain some of the difficulties?

[BootyBill]

Yes. During and sometimes directly after attacking an NPC all functions stop working as though you are going LD. No commands work at all even though the network meter does not show any latency. Everything appears normal except you cannot do anything but /q out and come back. Once you come back in from the character select screen then everything is back to normal.

It's as though a database query gets into a loop and uses all the servers processor on the query until the client disconnects. This was happening once in a while before the recent changes to attack.cpp and others, but now appears to happen much more often after the recent changes.

Bill

[BootyBill]

Tamarae,

Here are some mysql commands for database backup/ restoration:

To dump entire database into a backup file:
mysqldump --opt database > backup-file.sql;

To Restore database back:
mysql database < backup-file.sql;

To dump a single table:
mysql> SELECT * FROM account INTO OUTFILE 'account.txt'
-> FIELDS TERMINATED BY ','

To restore table data dumped in previous command:
mysql> LOAD DATA LOCAL INFILE "account.txt" INTO TABLE event
mysql> ->FIELDS TERMINATED BY ',';

BTW: I noticed some of your mobs are now KOS even though they don't attack when in agro range. They do assist correctly now though.

Bill

[neotokyo]

Tam did set the aggro range for mobs to an extreme low level, due to some issues in blackburrow, where many mobs stand close together (seperated by walls, but eqemu doesnt yet know walls)

probably thats why they didnt aggro, i could be wrong though.

for that other problem: i need the server logs to see if the client got disconnected or not. did you wait some time to see if the client just disconnected (even without typical PL getting higher)?

in some zones there (like nektulos) there are way to many caster for the zone-server to cope. i need definitly some performance improvements for the AI.

one problem with the current AI is, that if a caster tries to cast a spell of one type, but doesnt find one (due to level, range, mana, or whatever) he keeps looking and looking and looking. this uses much cpu time. i hope i can fix this tomorrow, after work.

[BootyBill]

Yes, I waited for about 3-5 minutes before using /q. I guess we could get Tam to post her server logs. What you described with the endless query sounds like what my be occuring.

Bill

[tamarae]

Okay, the aggroradius is back to 70, I was testing the differences in what aggroed and what didnt at different levels of aggroradius value. Sorry for not putting it back.

Attached is the zonelog that I think Bill is talking about.

And thanks for the db backup commands, shortly after posting it I found some info and was told some more info... and got it all backed up. :)

[morpheus014]

I have been playing on the freedom alliance server, and I have been experiencing the same issue with the "stealth" LD, functions stop working after, in this case, another person attacked a mob. I dont know if they are running your new code or not but all mobs were healing themselves obsessively for 500 hp =/ Anyway just thougth id put that out there, but i would assume that they are running the new exes since the mobs were all casting heals ..

[blackhawk]

After install the source updates summoning pets dont work. It crashes zone know

!! any ideas?

This was right after you made this change ehhe!

Aalron - Freedom Alliance

[tamarae]

About 10 posts up was another set of changes, 4 files that neo posted today.. fixed up the crashing pets part.

[blackhawk]

For some reason the code I downloaded from that page lol never made to me I guess I forgot to get that haah thanks it works know