EQEmulator Forums - Original Zebuxoruk DB and server build

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- General::Server Discussion (https://www.eqemulator.org/forums/forumdisplay.php?f=601)

- - Original Zebuxoruk DB and server build (https://www.eqemulator.org/forums/showthread.php?t=38944)

Original Zebuxoruk DB and server build

Yello all,

I finally came across my Zebuxoruk CD while going through a bunch of crap. This is an unmodified version just as Jib released it way back when. There are no Abyss related changes and all characters from the original zeb server are intact. It would be nice to see Zeb live once again.

https://www.mediafire.com/?j8vgna5w76b47w1

I attempted to bring this up to date once.

Someone more talented than me will have to try haha.

holy shit.. lots of memories on that server.

8/21/2007 binaries...

holy hell on a stick.

Maybe Akkadius could get this up to date for someone.

Linkage for the lazy to inspire:- http://www.eqemulator.org/forums/sho...ight=Zebuxoruk

Sounded fun.

yeah this server was Amazing,

holy crap 2007 binaries.. i started tickling eqemu in 2008... and that was primitive to what we have now. geez.

I still have all of my compiles from 2008 onwards so i don't imagine it would be IMPOSSIBLE to bring zeb online but it would need some serious database massaging.

damn i wish i had free time to do eqemu stuff again, maybe instead of sleeping one week ill check it out :P

this is going to require older version of perl and mysql i think?

i brought it to life for 5 minutes, tested some stuff it worked 100%

then i realized its missing about 99.9999% of the awesomeness that is 7 more years of eqemu development.

now i'm converting it through 7 years of changes to the db quests etc. may have to analyze the quests and possibly update them too (can i do it automagically well see, hopefully they are more or less fine.).

im updating the server to about may of this year before all of the ridiculous changes started occurring (which i still haven't synced my own server up to yet)

ok finished teh update

hailed some npcs and quests seem to work

will tinker with it some more but for now its up and its updated from 2007 to 2014

I fondly remember this server. Wasn't heavily in to it, as other pursuits occupied me that era, but Davood, you're a saint for working on this. I'd love to see this place again, if only for the nostalgia blast.

It's up. Give it a go

I am collecting information on what is broken right now.

Default zones are needing a fix
Bind points
Some issues with making chars.

Tried, encountered an unknown error while trying to join the server. Will look into that from my end in the meantime.

wonder if my old rapesauce monk is here.

Oh damn hes there but lvl 44.

*edit* Clickies are broken as well.

And quests are giving error (0) (aug1) is not an actual augment.

A lot of spells are (out of spell range) as well.

Ok i know how to fix that Aug error problem. And the spell problem.

In fact I had those issues recently. Gonna search my own threads tonight when I get home.

Thanks for testing guys

aug error and spell error should be fixed.

also start zone should be fixed too

it is my understanding they were supposed to start in guild hall?

few other things im sure ill find.

ill give you a hint. the DB went from x tables to 3x tables, there is alot of structure that was hardcoded or quested before

2007 -> 2014 is a long jump. hopefully we can land there together. if i get it up and running I'll be interested in discussing acquiring volunteer GMs because I have no intention of logging in except to fix technical issues. I don't have any time to GM anything.

development - I can bring some things in if you want. we can do somethign where you mail soe.eq.zeboxuruk.davood and tell him/me which features from alakamin you liked and would want to see as part of zeb

some of them might be

item courier
god system (probably overkill for small scope non dungeon crawl design)
monster system
expanded skillsets
graphics hacks (server side)
variable # command menu based on quests etc
etc

all of those things i have built as drop and play systems so if there is alot of interest i can easily port them over .

oh taht reminds me. i need to convert the old global system to the new one blah

i mean global quests

i've left the old GMS and guides in place for now

i'm going to also be using all of the QS tables. and possibly, if i dont get complaints, implementing my shouters with top ten lists etc.

Should I do a full char wipe? or leave it as is? I'm not the original author of this content so i dunno if deleting 8,000 characters is a good idea

ok global quests fixed . was only a few anyways.

ok seems stuff is working but start zones seem to be all over

i can fix it but im curious were the players all supposed to start in one place on teh zeb server? if m analysis is correct, they should all be starting in the guild hall.

http://www.eqemulator.org/forums/sho...ight=Zebuxoruk

from this thread:

Layout:
The server is centered on the City of Cabilis. This is where players will start, prepare, and gather for their adventures into the world. Three "open world" zones attach to Cabilis: Warsliks Woods, Field of Bone, and Western Wastes. Each of these zones contain quests, dungeons, and the not-so-rare dragon. Cabilis is also home to a slew of merchants that will sell you all sorts of things. I have spent a lot of time developing a balanced economy through merchants and item drops so money is worth something. All NPCs, Items, and Quests are completely custom, (everything except the zones they are in). To help you get around the custom world I have compiled some Custom Maps on the Zeb Downloads Page.

Also, the combat mechanics code changed quite a bit from back then so using newer mechanics with older db may result in dps not being what is was.

Thanks - i will update the starting zone(s)

Does anyone have the custom maps or the excel progression spreadsheet that is referred to in that thread?

uhh

i think factions are broken. everythign is indifferent? or is it. im going to bed willi test more tommorrow

happy halloween

Depending on when the server database was released, there's a cabilis-era and a nexus-era Zeb server. Personally if I remember correctly the Nexus-era one was older and better content-wise.

That being said the jump from 2007 -> 2014 is probably too much. NPC damage, health, AC, pathing, attack speed, avoidance - these are all variables that are screwed to hell and back. You're better off using Akkadius' zone importing tools to transfer the NPCs and re-tune them.

This is nexus version. The thread that is referred to was a relaunch of zeb which was after this release.

anyways i managed to convert everything. the factions seem to be ok please tell me if im wrong - i can easily redo that part

and yeah i figured out last night that this was the "nexus" version.

i am going to do some testing with melee and spell casters and see how broken npcs are. seems the special attacks etc were all converted properly databasewise

OK fixed the following things today:

respawn and variance fixed
factions fixed - just need some more testing. database-wise it looks good now
issues from emails - all dealt with. Will reward you with stuff later once i put in item couriers
check skill limits - fixed was only 15 entries in class_skill now has all entries.
fix zone points - fixed
analyze other potential static tables - lots of static data was simply lacking. that is now resolved.

regarding factions

Code:

SELECT

nt.id, nt.name, nt.class



FROM

npc_types as nt



WHERE

nt.npc_faction_id = 0 AND

nt.class < 17 AND

nt.id NOT IN

(

        SELECT np.npcID

        FROM

        pets as np

) AND

nt.race <> 127 AND 

nt.size > 0 AND

nt.level > 1 AND

nt.bodytype <> 66



ORDER BY

nt.name,nt.class,nt.id;

still gives me 702 matches but i think those don't matter as they look like quest-ish npcs. I will investigate some more. the original missing faction assignment list was ~5000 npcs

next up is fixing the npc_types table with min max damage attack counts etc

oh i've updated the spell master (had a nice script i wrote for alakamin) - you can pick and choose what levels etc of spell you want. later when I have time ill generate a script that will let you menu-ally (pun on manually) pick and choose specific discs and spells from the spell dude and maybe even associate a price too.

npc_types is cleaned up.

now i await more feedback.

something is still up with zone lines.. sigh will have to do more testing.

Is there custom files needed for this server? Or just vanilla files?

Vanilla files.

I might do some stuff with skills but nothing is required.

Seems as though the skeletons in the newbie adventure aren't dropping the tickets for getting sent above-ground. Dropping "Torch of the Elements" instead. Out of Combat regen rates are abysmally low aswell. Also appears to be a few mobs in CB that have a very high in combat HP regen rate.

ok ill add this to my analysis

time for some SQL magic

The GMs in the nexus don't show all the skills that you need to train for every class. On all the toons i have logged into, they only have the languages. I also tried going to starting cities and got the same result.

ok fixed npc regen. shouldn't be any weird regenning anymore.

regarding skills - they are appearing properly now

still debating out of combat regen rates - illl leave this decision to whoever takes over active development.

factions seem to be broken in some places. still not 100% sure..

some zone lines are weird still looking into it

also I have worked on teh loot issue
I wrote this query

Code:

select

NT.name,NT.hp,S2.zone,items.Name,items.hp,items.ac,items.damage,items.delay,LDE.lootdrop_id,items.id item_id,S2.respawntime,LDE.chance LDE_CHANCE, LTE.probability LTE_PROBABILITY



from

items

JOIN lootdrop_entries as LDE on items.id = LDE.item_id

JOIN loottable_entries as LTE on LDE.lootdrop_id = LTE.lootdrop_id

JOIN npc_types as NT on LTE.loottable_id = NT.loottable_id

JOIN spawnentry as SE on NT.id = SE.npcID

JOIN spawn2 as S2 on SE.spawngroupID = S2.spawngroupID



where

NT.class < 20 and

S2.zone = "FieldofBone" and

NT.name like '%ythrax%'



group by items.Name,NT.name;

this has netted me a list of various item drops

for simplicity ill list the output here:

Code:

Sythrax_The_Undead_Lord        90        fieldofbone        Bone Fingered Gloves        0        3        0        0        80060        1318        120        20        100

a_servant_of_Sythrax        11        fieldofbone        Busted Bottle        0        0        7        30        82113        93148        60        12        35

servant_of_Sythrax        25        fieldofbone        Busted Bottle        0        0        7        30        82113        93148        60        12        35

Sythrax_guardian        46        fieldofbone        Busted Bottle        0        0        7        30        82113        93148        100        12        35

Sythrax_The_Undead_Lord        90        fieldofbone        Clattering Bone Necklace        30        8        0        0        80060        6418        120        20        100

a_servant_of_Sythrax        11        fieldofbone        Dungeon Ticket        0        0        0        0        80052        65335        60        15        25

servant_of_Sythrax        25        fieldofbone        Dungeon Ticket        0        0        0        0        80052        65335        60        15        25

Sythrax_guardian        46        fieldofbone        Dungeon Ticket        0        0        0        0        80052        65335        100        15        25

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Armband        0        1        0        0        82113        91706        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Armband        0        1        0        0        82113        91706        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Armband        0        1        0        0        82113        91706        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Boots        0        1        0        0        82113        91354        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Boots        0        1        0        0        82113        91354        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Boots        0        1        0        0        82113        91354        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Cuirass        2        1        0        0        82113        91002        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Cuirass        2        1        0        0        82113        91002        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Cuirass        2        1        0        0        82113        91002        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Greaves        1        1        0        0        82113        91178        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Greaves        1        1        0        0        82113        91178        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Greaves        1        1        0        0        82113        91178        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Helm        1        1        0        0        82113        92058        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Helm        1        1        0        0        82113        92058        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Helm        1        1        0        0        82113        92058        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Dusty Crypt Sleeves        0        1        0        0        82113        91530        60        11        35

servant_of_Sythrax        25        fieldofbone        Dusty Crypt Sleeves        0        1        0        0        82113        91530        60        11        35

Sythrax_guardian        46        fieldofbone        Dusty Crypt Sleeves        0        1        0        0        82113        91530        100        11        35

Sythrax_The_Undead_Lord        90        fieldofbone        Fabled Dagger of Marnek        0        0        8        20        80060        68231        120        20        100

Sythrax_The_Undead_Lord        90        fieldofbone        Fingerbone Hoop        0        2        0        0        80060        14751        120        20        100

a_servant_of_Sythrax        11        fieldofbone        Key of the Dead        0        0        0        0        80052        20886        60        14        25

servant_of_Sythrax        25        fieldofbone        Key of the Dead        0        0        0        0        80052        20886        60        14        25

Sythrax_guardian        46        fieldofbone        Key of the Dead        0        0        0        0        80052        20886        100        14        25

a_servant_of_Sythrax        11        fieldofbone        Mask of Swirling Water        25        4        0        0        80052        24740        60        14        25

servant_of_Sythrax        25        fieldofbone        Mask of Swirling Water        25        4        0        0        80052        24740        60        14        25

Sythrax_guardian        46        fieldofbone        Mask of Swirling Water        25        4        0        0        80052        24740        100        14        25

a_servant_of_Sythrax        11        fieldofbone        Meat Hook        0        0        7        29        82113        93147        60        11        35

servant_of_Sythrax        25        fieldofbone        Meat Hook        0        0        7        29        82113        93147        60        11        35

Sythrax_guardian        46        fieldofbone        Meat Hook        0        0        7        29        82113        93147        100        11        35

Sythrax_The_Undead_Lord        90        fieldofbone        Polished Femur Club        15        2        10        30        80060        68265        120        20        100

a_servant_of_Sythrax        11        fieldofbone        Scrap Shiv        0        0        5        24        82113        93146        60        11        35

servant_of_Sythrax        25        fieldofbone        Scrap Shiv        0        0        5        24        82113        93146        60        11        35

Sythrax_guardian        46        fieldofbone        Scrap Shiv        0        0        5        24        82113        93146        100        11        35

a_servant_of_Sythrax        11        fieldofbone        Shield of Flesh        0        13        0        0        80051        62303        60        33        15

servant_of_Sythrax        25        fieldofbone        Shield of Flesh        0        13        0        0        80051        62303        60        33        15

Sythrax_guardian        46        fieldofbone        Shield of Flesh        0        13        0        0        80051        62303        100        33        15

a_servant_of_Sythrax        11        fieldofbone        Shimmering Opal Ring        15        3        0        0        80052        21911        60        14        25

servant_of_Sythrax        25        fieldofbone        Shimmering Opal Ring        15        3        0        0        80052        21911        60        14        25

Sythrax_guardian        46        fieldofbone        Shimmering Opal Ring        15        3        0        0        80052        21911        100        14        25

a_servant_of_Sythrax        11        fieldofbone        Spine Bracelet        0        8        0        0        80052        24739        60        14        25

servant_of_Sythrax        25        fieldofbone        Spine Bracelet        0        8        0        0        80052        24739        60        14        25

Sythrax_guardian        46        fieldofbone        Spine Bracelet        0        8        0        0        80052        24739        100        14        25

a_servant_of_Sythrax        11        fieldofbone        Staff of Sunken Corpses        10        5        0        0        80052        66617        60        15        25

servant_of_Sythrax        25        fieldofbone        Staff of Sunken Corpses        10        5        0        0        80052        66617        60        15        25

Sythrax_guardian        46        fieldofbone        Staff of Sunken Corpses        10        5        0        0        80052        66617        100        15        25

Sythrax_The_Undead_Lord        90        fieldofbone        Sythrax Building Plans        0        0        0        0        23104        14772        120        100        45

a_servant_of_Sythrax        11        fieldofbone        Torch of the Elements        0        0        0        0        80051        28007        60        33        15

servant_of_Sythrax        25        fieldofbone        Torch of the Elements        0        0        0        0        80051        28007        60        33        15

Sythrax_guardian        46        fieldofbone        Torch of the Elements        0        0        0        0        80051        28007        100        33        15

a_servant_of_Sythrax        11        fieldofbone        Twisted Tendon Bracelet        3        7        0        0        80052        10148        60        14        25

servant_of_Sythrax        25        fieldofbone        Twisted Tendon Bracelet        3        7        0        0        80052        10148        60        14        25

Sythrax_guardian        46        fieldofbone        Twisted Tendon Bracelet        3        7        0        0        80052        10148        100        14        25

a_servant_of_Sythrax        11        fieldofbone        Woodsman's Staff        0        0        31        35        80051        6635        60        34        15

servant_of_Sythrax        25        fieldofbone        Woodsman's Staff        0        0        31        35        80051        6635        60        34        15

Sythrax_guardian        46        fieldofbone        Woodsman's Staff        0        0        31        35        80051        6635        100        34        15

i did try throwing in an items.clickeffect on the select portion. all of it is -1

my question is. what is the item i'm supposed to be looking for anyways? the "key of hte dead" drops quite a bit from the two skels near sythrax

I think it was the Dungeon Ticket that never dropped when I was playing around.

I got it off the skelly just fine, I'd imagine the RNG just felt like screwing with you