[Release] Event - Crystal Labyrinth

[pepsi1x1]

There were a few errors in the sql file, i took the time to fix them and have uploaded it to filebeam, heres the fixed sql

DOWNLOAD

Fyi when you write out the sql anywhere there is a column called Unique (ususally found in the items table) you need to wrap it with `` because its recognised as a sql function otherwise, also same goes for range wrap it with ``

e.g INSERT into items (`unique`, `range`) VALUES ('1', '1000');

its best practice to do this anyway so its a good habit to get into

I also removed the id's from the creature spawns section so it doesnt give duplicate key error's

EDIT: Ill +rep you when ive spread some more around!

[TheZaronz]

Coockiez Are you Llama6?

[y2kss66]

Why do i still receive this error:
Query:
INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(300000, 8, 7210, "Crystal", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2008-03-18 17:30:16
Line no.:4
Error Code: 1062 - Duplicate entry '300000' for key 1

Query:
INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(300000, 8, 7210, "Crystal", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2008-03-18 17:30:21
Line no.:4
Error Code: 1062 - Duplicate entry '300000' for key 1

Query:
INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(300000, 8, 7210, "Crystal", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2008-03-18 17:48:19
Line no.:4
Error Code: 1062 - Duplicate entry '300000' for key 1

Query:
INSERT INTO gameobject_names
(entry, Type, DisplayID, Name, spellfocus, sound1, sound2, sound3, sound4, sound5, sound6, sound7, sound8, sound9, unknown1, unknown2, unknown3, unknown4, unknown5, unknown6, unknown7, unknown8, unknown9, unknown10, unknown11, unknown12, unknown13, unknown14)
VALUES
(300000, 8, 7210, "Crystal", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

Error occured at:2008-03-18 17:48:34
Line no.:4
Error Code: 1062 - Duplicate entry '300000' for key 1

Query:
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, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state, walk_speed, run_speed, fly_speed, extra_a9_flags)
VALUES
(40001, 70, 70, 35, 12000, 12000, 0, 1, 3, 2800, 100, 200, 2800, 100, 200, 0, 31543, 0, 0, 0, 0, 0, 10178, 0, 0, 360000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "0", 0, 0, 0, 0, "2,5", 8, 14, 0)

Error occured at:2008-03-18 18:10:22
Line no.:11958
Error Code: 1265 - Data truncated for column 'walk_speed' at row 1

[*Alexz*]

because its old

[y2kss66]

how do i update it then?

[wurstbr0t]

Stop bumping this old thread.. zomg.. -_-'

/close please

[Succy]

Was really nice! To bad that you didn't update it

[TheSpidey]

Why do i still receive this error:

Error Code: 1062 - Duplicate entry '300000' for key 1

Umm, duplicate entry perhaps?

This is old. If you want you can salvage it manually though.

[y2kss66]

I cannot really update the sql code but I really liked this and was wondering if someone else could? Thank you and sorry if I am a noob and sorry for bumping.

[TheSpidey]

Perhaps the OP will

[y2kss66]

Ok thanks for the help!