Squire-DB :: ArcEmu Based Database

[bubbavicious]

Hi James13

Trying out the db now, first thing I noticed, the mobs and npcs seem to be doubled? There are 2 enemies standing in the same spot and there seems to be more of them. Is there something I did wrong in the importing process?

Thanks.

[pedroz77]

bubbavicious: nah, you didnt any wrong.
this is what happens when ppl try merge ncdb and whydb as they did.
the spawn tables does not limit on any id, so when 2 spawn tables
merges. you get double spawn everywhere.

in other words: this database is complete useless as a blizzlike atm.

[Zombienation]

Well, I'm just curious but..... Why? Why are people still creating DBs and such for ArcEmu? Everytime I check their SVN for updates, there is usually only 3-4 updates in the past week. They are so far behind that it's actaully quite hilarious. That's just my opinion I guess.

[Biden]

Well, I'm just curious but..... Why? Why are people still creating DBs and such for ArcEmu? Everytime I check their SVN for updates, there is usually only 3-4 updates in the past week. They are so far behind that it's actaully quite hilarious. That's just my opinion I guess.

lol what kind of core/database do you use then?

[Joriee]

probally Vlacks K6 or K5

[Abdullaah]

bubbavicious: nah, you didnt any wrong.
this is what happens when ppl try merge ncdb and whydb as they did.
the spawn tables does not limit on any id, so when 2 spawn tables
merges. you get double spawn everywhere.

in other words: this database is complete useless as a blizzlike atm.

Excuse Me??

Who told you we merged the 2 tables?? 1st of all, we did not! Nor are there any Double Spawns!
What i think is that the person who got double spawns has its own error somewhere, either he merged it or is using some repack!

Dont comment on the DB before knowing the whole thing!
Thank you!

[keazain]

Bump +Rep x 3 from me nice work xD if help is needed, pm me...

[pedroz77]

abdullaah: dont try that bullshit on me

have you read the info in this release thread?

Squire-DB
Hey All!
Squire-DB has been released recently, and We are based on ArcEmu. We have started our Project based on NCDB's Latest Rev for ArcEmu Support and some of WhyDB.

even Knaur from norwegian elite team confirmed same thing,
most blizzlike areas+instances in your db has double spawns.
2 npc,s on the same point. but i guess Knaur that has made databases
since 2006 doesnt know what he talks bout

we was gonna use this db as blizz-ground for our next funserver project at norwegian elite team,
but since its doublespawn in alot of the blizz areas, we skipped it. also im tired of database teams
that never wanna take critic, just denies all even if its a fact. keep doing that and you will be unpop in wow community


start read squire db,s own announces before accusing ppl for lying...

and as far as i know, no repacks has been released with squire db as i have seen,
and btw we used clean from svn, as we always do

[Confucius]

+Rep 2x! ty

[Abdullaah]

dude?? My THATAnnouncement doesnt say that we ripped 2 same tables from 2 different database and merged them and called it Squire-DB!!

If thats what i wanted to do, i wouldnt have taken it underground for 2 weeks before releasing it!!

Also, our creature_spawns table was taken from WhyDB not NCDB and we made a lot of fixes on it, and if those double spawns our in our DB and if you are running a project you should have enough sense and worked out that little bug by running a simple Sql Query:

delete from creature_spawns using creature_spawns, creature_spawns as creature_spawns_2 where (creature_spawns_2.id>creature_spawns.id) 
and (creature_spawns.entry=creature_spawns_2.entry)
and (creature_spawns.map=creature_spawns_2.map)
and (creature_spawns.position_x=creature_spawns_2.position_x)
and (creature_spawns.position_y=creature_spawns_2.position_y)
and (creature_spawns.position_z=creature_spawns_2.position_z);


/*

Please run it in parts like this:
delete from creature_spawns using creature_spawns, creature_spawns as creature_spawns_2 where (creature_spawns_2.id>creature_spawns.id) 
and (creature_spawns.entry=creature_spawns_2.entry)
and (creature_spawns.map=creature_spawns_2.map)
and (creature_spawns.position_x=creature_spawns_2.position_x)
and (creature_spawns.position_y=creature_spawns_2.position_y)
and (creature_spawns.position_z=creature_spawns_2.position_z)
and id>0 and id<10000; -- <== That part!
*/


DELETE FROM loot_skinning USING loot_skinning, loot_skinning AS loot_skinning_2 WHERE
(loot_skinning_2.index != loot_skinning.index) 
AND (loot_skinning.entryid = loot_skinning_2.entryid)
AND (loot_skinning.itemid = loot_skinning_2.itemid);

And if you couldnt do that simple thing, then it means ur new project would be nothing but useless


@Keazin and Hap-Ki-Do Master:
Thanks!!!

[Found]

nice release, but no rep too many DB's like this

[Abdullaah]

nice release, but no rep too many DB's like this

hehehe, thanks! And NP!

[Cripto]

Squire -Db now supports Linux

[server1]

Nicee Database, I see it becoming a really good one!

[Abdullaah]

Nicee Database, I see it becoming a really good one!

heyy, thanks! Atm we are working on Ulduar(60% Done) and 3.2 Stuff, as Northrend is completly spawned. Also added 3.1.3 Items, Creatures and Gameobjects...

Squire-DB is Also looking for some SERIOUS and SKILLED Devs, and if you are interested in being one, please post an Application Here after reading our Application format.