Original Zebuxoruk DB and server build

[Amra]

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

[Maze_EQ]

I attempted to bring this up to date once.

Someone more talented than me will have to try haha.

[Splose]

holy shit.. lots of memories on that server.

[Maze_EQ]

8/21/2007 binaries...

holy hell on a stick.

Maybe Akkadius could get this up to date for someone.

[vsab]

Linkage for the lazy to inspire:- http://www.eqemulator.org/forums/showthread.php?t=25950&highlight=Zebuxoruk

Sounded fun.

[boweq]

yeah this server was Amazing,

[Davood]

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

[Davood]

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

[Davood]

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)

[Davood]

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

[nenelan]

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.

[Davood]

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.

[ghanja]

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

[Maze_EQ]

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.

[Davood]

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

[Davood]

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

[Davood]

i mean global quests

[Davood]

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

[Davood]

ok global quests fixed . was only a few anyways.

[Davood]

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.

[rencro]

http://www.eqemulator.org/forums/showthread.php?t=25950&highlight=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.

[Davood]

Thanks - i will update the starting zone(s)

[Davood]

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

[Davood]

uhh

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

happy halloween

[Secrets]

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.

[Amra]

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

[Davood]

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

[Davood]

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


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

[Davood]

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.

[Davood]

npc_types is cleaned up.

now i await more feedback.

[Davood]

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

[J3wish]

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

[Davood]

Vanilla files.

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

[J3wish]

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.

[Davood]

ok ill add this to my analysis

time for some SQL magic

[Minluin]

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.

[Davood]

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


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:


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

[Davood]

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

[J3wish]

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

[Burningsoul]

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

[J3wish]

Last I played was a week ago aswell Burningsoul.

[Burningsoul]

Aye, same as me. Got it on my fourth or fifth trash mob, looking at the loottable\lootdrop Davood posted it seems inline with it. I echo your sentiments about sloooow ooc regen compared to modern servers as well, it was the norm in the S2K/Zeb era but for a low pop server it will definitely turn some people off nowadays.

[Davood]

ok i agree with your sentiments regarding ooc regen.

i'll change it in the db. will go live at 5 am

[Underscore]

What happened here? I was just about to go back to this server and it disappeared.

I miss my Jibbatwinkers yum yum rabbit fetus.