[Question] DB Editor

[Tropem]

Ok when i use the latest version of DB editor.. well i just tell the problem.

When i make an NPC i generate the SQL. I copy the text from the 1th Window ( Insert blablabla )

and when i gonna inport them to DB i get this error


BTW iam useing SectorSevens Blizz Repack, well hope someone figure it out
I dunno why it dosent work with DB editor. :confused:

[b!atch]

The query ur trying to run has too many or too few columns to match up with ur db. add or remove some to fix it

[Tropem]

thanks! I edit this post if it works!

EDIT 1 :
Right im a noob at this.. how do i do it?? xDDDD

[Power of Illuminati]

Update your DB to a newer structur, else the SQL you have downloaded has an older structure

[Tropem]

as i said im realy noobish at this.. realy.. now i mean realy..

"Update your DB to a newer structur, else the SQL you have downloaded has an older structure"

How do i update?? -..0

[Tropem]

hmm what problems will this cause?

I use the Apples DB Instead of SectorServens DB? I quess it isent so much problems??

[b!atch]

like

INSERT INTO `creature_proto` (`entry`,`minlevel`,`maxlevel`,`faction`,`minhealth`,`maxhealth`,`mana`,`scale`,`npcflags`,`attacktime`,`mindamage`,`maxdamage`,`rangedattacktime`,`rangedmindamage`,`rangedmaxdamage`,`mountdisplayid`,`equipmodel1`,`equipinfo1`,`equipslot1`,`equipmodel2`,`equipinfo2`,`equipslot2`,`equipmodel3`,`equipinfo3`,`equipslot3`,`respawntime`,`armor`,`resistance4`,`combat_reach`,`bounding_radius`,`auras`,`boss`,`money`,`invisibility_type`,`death_state`,`walk_speed`,`run_speed`,`extra_a9_flags`) VALUES ('1000012','72','72','1626','1200000','1200000','34000900','1','0','1500','6700','9700','0','0','0','0','0','0','0','0','0','0','0','0','0','36000','14000','200','1','0','0','1','0','0','0','4','12','0')

just add some more '0's at the end. Or remove some depends if you got new columns in the table ur inserting into

[Tropem]

ok tyvm, i try this. But .. umm If i add to many it dosent work? right? and if i add to less it still dosent work? So i got to add exactly so many as it need?

[b!atch]

Thats right But you can count them u know..

Say we're modding creature_proto, now count the columns in creature_proto

ok. There is 44

Now count the columns in your query, (the numbers) these have to be 44 aswell

[latruwski]

Creature names - Wiki
Creature proto - Wiki

wiki = always handy shows structure + info... and if you need to download updates or latest structure:
Revision 185: /trunk/sql

grtz

[Tropem]

Tyvm, but.. umm how do i update? i got them.. now what?

EDIT
I think i got it, i make an new quiery thing, copy and paste the text from that links you gave me and hit run?
if this is right, then all creatures will disapear? cause if i run this then they will say there is already an table existing, do i need t overwrite or something then? Cause im pretty sure all creatures will disapear or what??

EDIT2
Sorry if you dont understand how i try to explain, and sorry for bad english. ( I dunno how to explain .. well i tried )

[latruwski]

for updates you need to run the 'updates' you find on the link...
The things you are running are probably the full structures and that will clear your current DB...
this is an example of an update:
http://arcemu.svn.sourceforge.net/sv...ture_proto.sql

[Tropem]

for updates you need to run the 'updates' you find on the link...
The things you are running are probably the full structures and that will clear your current DB...
this is an example of an update:
http://arcemu.svn.sourceforge.net/sv...ture_proto.sql

Clear my DB? I mean, will it delete the normal NPCS and vendors and such? will it delete all creatures, vendors, mobs?? questes??

NVM i dont get this with updates.. so well i just try something and hopefully figure it out..

EDIT :
Lol i updated Creatures name.. everything disapeared, is there a way to get the Normal NPCS, Vendors, MOBS back?

[Tropem]

\\\BUMP///

Answer my question anyone?? I realy wanna do this

"Lol i updated Creatures name.. everything disapeared, is there a way to get the Normal NPCS, Vendors, MOBS back?"