[ASCENT][CUSTOM] GM Vendors

Printable View

Show 100 post(s) from this thread on one page

19-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

UPDATE creature_proto SET displayid = '18106' WHERE entry between '50000' and '50080';
UPDATE creature_spawns SET displayid = '18106' WHERE entry between '50000' and '50080';
19-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Now recruiting people who can make blizzlike fixes as well as custom content for TerraNet public, PM me if you wanna join the team.
19-08-07
Dayclone

Re: [ASCENT][CUSTOM] GM Vendors

I have an error

Code:

Error Code : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, e' at line 1 (0 ms taken)
19-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Run the query in the first post.
19-08-07
SERVER-X

Re: [ASCENT][CUSTOM] GM Vendors

Spawn Fix:

Quote:

DELETE FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';

INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50000, 1, 16256.1, 16298.3, 13.1752, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50001, 1, 16255.4, 16293.6, 13.1752, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50002, 1, 16255.3, 16296, 13.1745, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50003, 1, 16254.4, 16306.8, 20.8443, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50004, 1, 16254, 16302.4, 20.8443, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50005, 1, 16254, 16304.5, 20.8443, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50006, 1, 16256.4, 16306.6, 20.8439, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50007, 1, 16256, 16302.1, 20.8433, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50008, 1, 16256.1, 16304.3, 20.8433, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50009, 1, 16249.7, 16314.5, 20.8435, 4.58868, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50010, 1, 16251.7, 16314.1, 20.8434, 4.58868, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50011, 1, 16253.8, 16313.7, 20.8432, 4.58868, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50012, 1, 16231.1, 16292, 31.4275, 2.96285, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50015, 1, 16225.7, 16309.9, 29.2601, 6.07953, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50016, 1, 16225.4, 16307.9, 29.2611, 6.07953, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50017, 1, 16225.3, 16305.7, 29.2601, 6.07953, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50018, 1, 16225, 16303.3, 29.2611, 6.07953, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50019, 1, 16227.5, 16290, 31.6797, 1.47146, 0, 20023, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50020, 1, 16241.4, 16292.7, 13.1752, 1.45732, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50021, 1, 16239.3, 16292.9, 13.1752, 1.45732, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50022, 1, 16235, 16300.9, 13.1748, 6.17454, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50023, 1, 16255.1, 16310.1, 20.8435, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50024, 1, 16254.1, 16299.2, 20.8443, 3.08688, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50025, 1, 16243.1, 16302.5, 13.174, 4.59759, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50026, 1, 16230.9, 16295, 20.8444, 3.10912, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50028, 1, 16233.1, 16304.8, 29.2611, 2.9315, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50029, 1, 16233.3, 16306.6, 29.2617, 2.9315, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50030, 1, 16243, 16295.3, 21.5678, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50031, 1, 16238.5, 16295.9, 21.5019, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50032, 1, 16240.8, 16295.8, 21.4214, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50033, 1, 16243.1, 16293.9, 22.278, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50034, 1, 16238.1, 16294.4, 22.2475, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50035, 1, 16240.6, 16294.2, 22.2379, 1.54742, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50040, 1, 16228.7, 16303.2, 20.8617, 6.14614, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50041, 1, 16228.9, 16305.1, 20.8581, 6.14614, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50042, 1, 16229.1, 16307, 20.8552, 6.14614, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50043, 1, 16229.2, 16309, 20.8501, 6.14614, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50044, 1, 16227.9, 16316.1, 29.2606, 4.31697, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50045, 1, 16241.5, 16311.5, 20.8437, 4.66726, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50047, 1, 16233.5, 16298.8, 20.8448, 1.20837, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50048, 1, 16231.5, 16292.6, 20.8459, 2.88455, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50049, 1, 16249.8, 16296, 20.8433, 1.63247, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50050, 1, 16228.9, 16303.7, 13.1802, 4.7554, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50051, 1, 16229.2, 16285.6, 13.174, 3.05395, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50052, 1, 16228.8, 16283.6, 13.174, 3.05395, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50053, 1, 16228.6, 16281.7, 13.174, 3.05395, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50054, 1, 16220.2, 16296.8, 13.1737, 6.10608, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50055, 1, 16220.5, 16298.4, 13.1743, 6.23784, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50056, 1, 16223.6, 16295, 20.8517, 6.14898, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50057, 1, 16227.8, 16317.2, 20.8455, 4.69757, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50058, 1, 16229.5, 16316.9, 20.8455, 4.69757, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50059, 1, 16231.4, 16316.9, 20.8455, 4.69757, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50060, 1, 16238.8, 16301.9, 13.174, 4.4716, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50061, 1, 16231.1, 16296.9, 20.8484, 2.98251, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50062, 1, 16245.6, 16299.5, 13.1733, 4.51227, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50063, 1, 16247.3, 16299.2, 13.1733, 4.51227, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50064, 1, 16246.9, 16294.4, 13.1747, 1.47434, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50065, 1, 16245, 16294.6, 13.1747, 1.47434, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50066, 1, 16218.6, 16282.7, 13.174, 6.03672, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50067, 1, 16218.9, 16284.8, 13.174, 6.03672, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50068, 1, 16220.7, 16300.2, 13.178, 0.0159378, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50069, 1, 16220.9, 16301.9, 13.1747, 6.23784, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50070, 1, 16224, 16296.9, 20.8531, 6.14898, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50071, 1, 16224.1, 16298.9, 20.8516, 6.14898, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50072, 1, 16233.3, 16316.6, 20.8455, 4.69757, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50073, 1, 16235.2, 16316.4, 20.8458, 4.69757, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50074, 1, 16240.9, 16301.5, 13.174, 4.4716, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50075, 1, 16230.6, 16295.1, 20.8446, 2.98251, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50076, 1, 16249.8, 16300, 13.175, 4.56881, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50077, 1, 16249.2, 16292.7, 13.175, 1.69974, 0, 18106, 1741, 0, 0, 0, 0, 0);
INSERT INTO creature_spawns (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50078, 1, 16231.2, 16292.5, 20.8451, 2.98799, 0, 18106, 1741, 0, 0, 0, 0, 0);
19-08-07
firezip

Re: [ASCENT][CUSTOM] GM Vendors

Thanks Server-X :)
19-08-07
Dayclone

Re: [ASCENT][CUSTOM] GM Vendors

Wow quick reply! thanks guys
19-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

What's the spawn "fix" for, its basically reverting my old spawns. New tables dont affect spawns.
19-08-07
SERVER-X

Re: [ASCENT][CUSTOM] GM Vendors

i have the spawn table fix in the new tabel with new and old code
(sorry for the bad english, i'am come from germany)
19-08-07
firezip

Re: [ASCENT][CUSTOM] GM Vendors

Well in 3.0, when I executed "custom_shop_spawn.sql" I got the error. When I executed the old vendor spawn from 2.9a, everything worked fine. Just fyi.

I'm assuming this fix is for the 3.0 spawns.
19-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Version 3.0a:
Always forget that damn table name in spawn query, added.
Added in custom_shop_display.sql, change your own displayids.
19-08-07
firezip

Re: [ASCENT][CUSTOM] GM Vendors

Thanks for the update :)
20-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Your welcome.
20-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

Ok, i'm encountering some large issues. For starters i followed your directions, i got ascent 1141, and i updated my DB with the queries on the first page. I start up Logonserver.exe, it works just fine, but ascent.exe will pop up for a sec and then dissapear and create a crash dumps file. So that's not working. Then i tried my older version, ascent 1036. Everything started fine, but when I logged in and created a new char, there are humongous npcs everywhere and when i modify scale 1.0 they dont shrink. Then i went back and looked at Ascent.exe and saw written in yellow "Invalid format in creature_proto <36/40> loading anyway because we have enough data:ImageShack - Hosting :: untitled3sr2.png. So then i start over. I don't update my DB this time. Then when I try and add custom shop it doesnt work, i get an error file. Then I figure out that the custom vendors will only work when I update my DB, but that makes all the NPCs huge so i'm stuck.

Also, in the Display ID query, you have Creature_proto and there is no column for display ID in proto so i think you meant names. If anyone knows how to fix this their help is appreciated.
20-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Yes, update your tables with the things I put in the first post, then it will work.
20-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

As i said, when i do that it makes all npcs huge and their scale can not be modified down, one of those queries screws up proto.
20-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

No, use ascent 1132+ and the problems will be gone.
20-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Hi Evansg

Just to expand on what Channel is saying
I
20-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Large npcs are caused by having extra columns while the core doesn't support them, so updating the core after updating the tables should work.
20-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

...oh forgot to also say, cheers for all the hard work Channel ^_^
20-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

:) cool
20-08-07
shtzngiggles

Re: [ASCENT][CUSTOM] GM Vendors

FYI, the display ID has nothing to do with the faction, as long as you just change the display ID, both races will be able to use them. I got sick of the lame ass ones that come with it so I changed mine to horde, alliance and neutral npc's as well as bosses. works fine.
21-08-07
2EZ

Re: [ASCENT][CUSTOM] GM Vendors

You tried emptying your cache folder?
21-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

can someone tell me the query for updating all items buyprice in a shop to 100g ... as the tier vendors don't have any prices.
21-08-07
seg

Re: [ASCENT][CUSTOM] GM Vendors

I'm geting an error while importing any sql file from custon_shop... here it is :

Code:

Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 18:43:16 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 18:44:09 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 18:44:58 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 18:45:01 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 19:00:54 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `npc_monstersay` ( `entry` int(11) NOT NULL, `event` int(11) NOT NULL, `chance` float NOT NULL, `language` int(11) NOT NULL, `type` int(11) NOT NULL, `monstername` longtext, `text0` longtext, `text1` longtext, `text2` longtext, `text3` longtext, `text4` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-18 19:01:56 Line no.:13 Error Code: 1050 - Table 'npc_monstersay' already exists Query: CREATE TABLE `worldmap_info` ( `mapid` int(10) NOT NULL default '0', `screenid` int(10) default '0', `type` int(10) default '0', `maxplayers` int(10) default '0', `minlevel` int(11) unsigned zerofill default '00000000001', `repopx` float default '0', `repopy` float default '0', `repopz` float default '0', `repopmapid` int(5) unsigned zerofill default '00000', `area_name` varchar(100) default '0', `flags` int(11) unsigned NOT NULL default '0', `cooldown` int(15) NOT NULL default '0', `lvl_mod_a` int(11) NOT NULL default '0', PRIMARY KEY (`mapid`) ) TYPE=MyISAM Error occured at:2007-08-18 19:02:21 Line no.:17 Error Code: 1050 - Table 'worldmap_info' already exists Query: CREATE TABLE `worldmap_info` ( `mapid` int(10) NOT NULL default '0', `screenid` int(10) default '0', `type` int(10) default '0', `maxplayers` int(10) default '0', `minlevel` int(11) unsigned zerofill default '00000000001', `repopx` float default '0', `repopy` float default '0', `repopz` float default '0', `repopmapid` int(5) unsigned zerofill default '00000', `area_name` varchar(100) default '0', `flags` int(11) unsigned NOT NULL default '0', `cooldown` int(15) NOT NULL default '0', `lvl_mod_a` int(11) NOT NULL default '0', PRIMARY KEY (`mapid`) ) TYPE=MyISAM Error occured at:2007-08-18 19:03:12 Line no.:17 Error Code: 1050 - Table 'worldmap_info' already exists Query: CREATE TABLE `worldmap_info` ( `mapid` int(10) NOT NULL default '0', `screenid` int(10) default '0', `type` int(10) default '0', `maxplayers` int(10) default '0', `minlevel` int(11) unsigned zerofill default '00000000001', `repopx` float default '0', `repopy` float default '0', `repopz` float default '0', `repopmapid` int(5) unsigned zerofill default '00000', `area_name` varchar(100) default '0', `flags` int(11) unsigned NOT NULL default '0', `cooldown` int(15) NOT NULL default '0', `lvl_mod_a` int(11) NOT NULL default '0', PRIMARY KEY (`mapid`) ) TYPE=MyISAM Error occured at:2007-08-18 19:03:37 Line no.:17 Error Code: 1050 - Table 'worldmap_info' already exists Query: DROP TABLE LL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 ,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve oat NOT NULL default '0', `text0_0` longtext NOT NULL, `text0_1` longtext NOT NULL, ,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20 `playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25 0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2 0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14 477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216 36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180), fault '0', `itemtext` int(10) unsigned NOT NULL default '0', ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin 0', `RequiredRaces` int(11) unsigned NOT NULL nkill` ENABLE KEYS */ Error occured at:2007-08-18 19:03:51 Line no.:149206 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scar' at line 3 Query: able structure for table `creature_names` DROP TABLE IF EXISTS `creature_names` Error occured at:2007-08-18 19:05:57 Line no.:382 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'able structure for table `creature_names` DROP TABLE IF EXISTS `creature_names`' at line 1 Query: DROP TABLE LL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 ,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve oat NOT NULL default '0', `text0_0` longtext NOT NULL, `text0_1` longtext NOT NULL, ,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20 `playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25 0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2 0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14 477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216 36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180), fault '0', `itemtext` int(10) unsigned NOT NULL default '0', ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin 0', `RequiredRaces` int(11) unsigned NOT NULL nkill` ENABLE KEYS */ Error occured at:2007-08-18 19:06:30 Line no.:149206 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scar' at line 3 Query: uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */; /*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `creature_spawns` -- DROP TABLE -- Table structure for table `gameobject_spawns` -- DROP TABLE IF EXISTS `gameobject_spawns`; CREATE TABLE `gameobject_spawns` ( `ID` int(30) unsigned NOT NULL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 255) NOT NULL default '', `displayid` int(70) unsigned NOT NULL default '0', `quality` int(30) NOT NULL default '0', `flags` int(30) NOT NULL default '0', `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve ble structure for table `npc_text` DROP TABLE IF EXISTS `npc_text` Error occured at:2007-08-18 19:11:22 Line no.:51145 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1 Query: uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */; /*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `creature_spawns` -- DROP TABLE -- Table structure for table `gameobject_spawns` -- DROP TABLE IF EXISTS `gameobject_spawns`; CREATE TABLE `gameobject_spawns` ( `ID` int(30) unsigned NOT NULL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 255) NOT NULL default '', `displayid` int(70) unsigned NOT NULL default '0', `quality` int(30) NOT NULL default '0', `flags` int(30) NOT NULL default '0', `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve ble structure for table `npc_text` DROP TABLE IF EXISTS `npc_text` Error occured at:2007-08-18 19:11:32 Line no.:51145 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1 Query: LOCK TABLES `characters` WRITE Error occured at:2007-08-19 12:08:20 Line no.:175 Error Code: 1146 - Table 'ascent.characters' doesn't exist Query: CREATE TABLE `command_overrides` ( `command_name` varchar(100) NOT NULL, `access_level` varchar(10) NOT NULL, PRIMARY KEY (`command_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:27:46 Line no.:5 Error Code: 1050 - Table 'command_overrides' already exists Query: uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS */; /*!40000 ALTER TABLE `creature_quest_starter` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `creature_spawns` -- DROP TABLE -- Table structure for table `gameobject_spawns` -- DROP TABLE IF EXISTS `gameobject_spawns`; CREATE TABLE `gameobject_spawns` ( `ID` int(30) unsigned NOT NULL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int ion Hold'),(91,-10606.8,294.048,31.8466,4.0817,10,0,0,3,'Raven Hill'),(92,10458.5,-6364.61,39.7907,4.0817,3430,3487,530,3,'Sunstrider Isle'),(93,-7991.57,1557.8,5.01986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 2,874.911,7284.72,23.0023,4.0817,3521,0,530,3,'Zangarmarsh'),(213,337.125,8616.87,24.1361,4.0817,3521,0,530,3,'Zangarmarsh'),(214,4363.88,3093.74,132.969,4.0817,3523,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 097.21,111.865,4.0817,3523,0,530,3,'Eco-Dome Midrealm'),(331,3476.45,3293.56,95.2325,4.0817,3523,0,530,3,'The Crumbling Waste'),(332,3348.41,3172.06,90.9979,4.0817,3523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 255) NOT NULL default '', `displayid` int(70) unsigned NOT NULL default '0', `quality` int(30) NOT NULL default '0', `flags` int(30) NOT NULL default '0', `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve ble structure for table `npc_text` DROP TABLE IF EXISTS `npc_text` Error occured at:2007-08-19 12:28:11 Line no.:51145 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'uest_starter` WRITE; /*!40000 ALTER TABLE `creature_quest_starter` DISABLE KEYS ' at line 1 Query: LOCK TABLES `characters` WRITE Error occured at:2007-08-19 12:28:48 Line no.:175 Error Code: 1146 - Table 'tester.characters' doesn't exist Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:29:18 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `command_overrides` ( `command_name` varchar(100) NOT NULL, `access_level` varchar(10) NOT NULL, PRIMARY KEY (`command_name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:29:56 Line no.:5 Error Code: 1050 - Table 'command_overrides' already exists Query: CREATE TABLE `npc_monstersay` ( `entry` int(11) NOT NULL, `event` int(11) NOT NULL, `chance` float NOT NULL, `language` int(11) NOT NULL, `type` int(11) NOT NULL, `monstername` longtext, `text0` longtext, `text1` longtext, `text2` longtext, `text3` longtext, `text4` longtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:30:02 Line no.:13 Error Code: 1050 - Table 'npc_monstersay' already exists Query: CREATE TABLE `worldmap_info` ( `mapid` int(10) NOT NULL default '0', `screenid` int(10) default '0', `type` int(10) default '0', `maxplayers` int(10) default '0', `minlevel` int(11) unsigned zerofill default '00000000001', `repopx` float default '0', `repopy` float default '0', `repopz` float default '0', `repopmapid` int(5) unsigned zerofill default '00000', `area_name` varchar(100) default '0', `flags` int(11) unsigned NOT NULL default '0', `cooldown` int(15) NOT NULL default '0', `lvl_mod_a` int(11) NOT NULL default '0', PRIMARY KEY (`mapid`) ) TYPE=MyISAM Error occured at:2007-08-19 12:30:24 Line no.:17 Error Code: 1050 - Table 'worldmap_info' already exists Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:50:05 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0', `acct` int(20) unsigned NOT NULL default '0', `name` varchar(21) NOT NULL default '', `race` smallint(3) unsigned NOT NULL, `class` smallint(3) unsigned NOT NULL, `gender` tinyint(1) unsigned NOT NULL, `level` int(3) unsigned NOT NULL, `xp` int(30) unsigned NOT NULL, `exploration_data` longtext NOT NULL, `skills` longtext NOT NULL, `watched_faction_index` bigint(40) unsigned NOT NULL, `selected_pvp_title` int(30) unsigned NOT NULL, `available_pvp_titles` int(30) unsigned NOT NULL, `gold` int(30) unsigned NOT NULL, `ammo_id` int(30) unsigned NOT NULL, `available_prof_points` int(30) unsigned NOT NULL, `available_talent_points` int(30) unsigned NOT NULL, `current_hp` int(30) unsigned NOT NULL, `current_power` int(30) unsigned NOT NULL, `pvprank` int(30) unsigned NOT NULL, `bytes` int(30) unsigned NOT NULL, `bytes2` int(30) unsigned NOT NULL, `player_flags` int(30) unsigned NOT NULL, `player_bytes` int(30) unsigned NOT NULL, `positionX` float NOT NULL default '0', `positionY` float NOT NULL default '0', `positionZ` float NOT NULL default '0', `orientation` float NOT NULL default '0', `mapId` int(8) unsigned NOT NULL default '0', `zoneId` int(8) unsigned NOT NULL default '0', `taximask` longtext NOT NULL, `banned` int(6) unsigned NOT NULL default '0', `banReason` varchar(50) NOT NULL, `timestamp` text NOT NULL, `online` int(11) default NULL, `bindpositionX` float NOT NULL default '0', `bindpositionY` float NOT NULL default '0', `bindpositionZ` float NOT NULL default '0', `bindmapId` int(8) unsigned NOT NULL default '0', `bindzoneId` int(8) unsigned NOT NULL default '0', `isResting` int(1) NOT NULL default '0', `restState` int(5) NOT NULL default '0', `restTime` int(5) NOT NULL default '0', `playedtime` longtext NOT NULL, `deathstate` int(2) NOT NULL default '0', `TalentResetTimes` int(3) NOT NULL default '0', `first_login` tinyint(1) NOT NULL default '0', `forced_rename_pending` tinyint(1) unsigned NOT NULL default '0', `publicNote` varchar(32) NOT NULL default '', `officerNote` varchar(32) NOT NULL default '', `guildid` int(10) unsigned NOT NULL default '0', `guildRank` int(10) unsigned NOT NULL default '0', `charterId` int(10) NOT NULL, `totalstableslots` int(10) unsigned NOT NULL default '0', `instance_id` int(10) NOT NULL default '0', `entrypointmap` int(4) NOT NULL default '0', `entrypointx` float NOT NULL default '0', `entrypointy` float NOT NULL default '0', `entrypointz` float NOT NULL default '0', `entrypointo` float NOT NULL default '0', `entrypointinstance` int(10) NOT NULL default '0', `taxi_path` int(10) NOT NULL default '0', `taxi_lastnode` int(10) NOT NULL default '0', `taxi_mountid` int(10) NOT NULL default '0', `transporter` int(10) NOT NULL default '0', `transporter_xdiff` float NOT NULL default '0', `transporter_ydiff` flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` longtext NOT NULL, `deleted_spells` longtext NOT NULL, `reputation` longtext NOT NULL, `actions` longtext NOT NULL, `auras` longtext NOT NULL, `finished_quests` longtext NOT NULL, `lastDailyReset` int(30) NOT NULL, `killsToday` int(10) NOT NULL default '0', `killsYesterday` int(10) NOT NULL default '0', `killsLifeTime` int(10) NOT NULL default '0', `honorToday` int(10) NOT NULL default '0', `honorYesterday` int(10) NOT NULL default '0', `honorPoints` int(10) NOT NULL default '0', `difficulty` int(4) NOT NULL default '0', UNIQUE KEY `guid` (`guid`), KEY `acct` (`acct`), KEY `guildid` (`guildid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:50:25 Line no.:269 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'flo ULL default '0', `transporter_zdiff` float NOT NULL default '0', `spells` lo' at line 68 Query: DROP TABLE LL, `Entry` int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scarab Wall'),(94,8936.56,-7439.9,8 ,0,530,3,'The Stormspire'),(215,3032.44,3594.28,145.806,4. 523,0,530,3,'The Crumbling Waste'),(333,3216.28,2992.5 `buyprice` int(30) NOT NULL default '0', `sellprice` int(30) NOT NULL default '0', `inve oat NOT NULL default '0', `text0_0` longtext NOT NULL, `text0_1` longtext NOT NULL, ,25,19,19,90,0,1000,0,0,33,5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20 `playercreateinfo_items` VALUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25 0,95,1,5),(20,176,1,5),(20,38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2 0,0),(50,184,0,5),(50,183,5,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14 477),(39,6478),(39,6603),(39,7266),(39,7267),(39,7355),(39,8386),(39,216 36,20593),(36,20592),(36,168),(36,227),(36,7340),(36,203),(41,1180), fault '0', `itemtext` int(10) unsigned NOT NULL default '0', ield',2),(241,'The Rotting Orchard',3),(242,'Brightwood Grove Gate Outpost',1),(807,'North Gate Pass',1),(808,'North Ga e',3),(2245,'Mazthoril',3),(2246,'Frostfire Hot Sprin 0', `RequiredRaces` int(11) unsigned NOT NULL nkill` ENABLE KEYS */ Error occured at:2007-08-19 12:51:17 Line no.:149206 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int(10) unsigned NOT NULL default '0', `Map` int 986,4.0817,1377,0,1,3,'The Scar' at line 3 Query: r table `creature_spawns` DROP TABLE gned NOT NULL default '0', `Map` int Scarab Wall'),(94,8936.56,-7439.9,8 (215,3032.44,3594.28,145.806,4. Waste'),(333,3216.28,2992.5 LL default '0', `sellprice` int(30) NOT NULL default '0', `inve `text0_0` longtext NOT NULL, `text0_1` longtext NOT NULL, 5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20 LUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25 38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2 ,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14 9,7266),(39,7267),(39,7355),(39,8386),(39,216 8),(36,227),(36,7340),(36,203),(41,1180), t(10) unsigned NOT NULL default '0', Orchard',3),(242,'Brightwood Grove h Gate Pass',1),(808,'North Ga (2246,'Frostfire Hot Sprin 11) unsigned NOT NULL OCK TABLES; -- LL,1),(30213,NU ),(10947,NU 22,NULL ULL 4,NULL,NULL,1),(20355,NULL,NULL,1),(20411,NULL,NULL,1),(20412,NULL,NULL,1),(20413,NULL,NULL,1),(20414,NULL,NULL,1),(20425,NULL,NULL,1),(20467,NULL,NULL,1),(20961,NULL,NULL,1),(20962,NULL,NULL,1),(20963,NULL,NULL,1),(20964,NULL,NULL,1),(20965,NULL,NULL,1),(20966,NULL,NULL,1),(20967,NULL,NULL,1),(20968,NULL,NULL,1),(21183,NULL,NULL,1),(21889,NULL,NULL,1),(23590,NULL,NULL,1),(24234,NULL,NULL,1),(25061,NULL,NULL,1),(25745,NULL,NULL,1),(25751,NULL,NULL,1),(25752,NULL,NULL,1),(25753,NULL,NULL,1),(25757,NULL,NULL,1),(25758,NULL,NULL,1),(25759,NULL,NULL,1),(25760,NULL,NULL,1),(25761,NULL,NULL,1),(25762,NULL,NULL,1),(25942,NULL,NULL,1),(25943,NULL,NULL,1),(25944,NULL,NULL,1),(25945,NULL,NULL,1),(27731,NULL,NULL,1),(133,NULL,NULL,1),(143,NULL,NULL,1),(145,NULL,NULL,1),(3140,NULL,NULL,1),(8400,NULL,NULL,1),(8401,NULL,NULL,1),(8402,NULL,NULL,1),(9053,NULL,NULL,1),(9487,NULL,NULL,1),(9488,NULL,NULL,1),(10148,NULL,NULL,1),(10149,NULL,NULL,1),(10150,NULL,NULL,1),(10151,NULL,NULL,1),(10578,NULL,NULL,1),(11839,NULL,NULL,1),(11921,NULL,NULL,1),(11985,NULL,NULL,1),(11988,NULL,NULL,1),(11989,NULL,NULL,1),(12466,NULL,NULL,1),(13140,NULL,NULL,1),(13375,NULL,NULL,1),(13438,NULL,NULL,1),(14034,NULL,NULL,1),(15228,NULL,NULL,1),(15242,NULL,NULL,1),(15243,NULL,NULL,1),(15285,NULL,NULL,1),(15536,NULL,NULL,1),(15662,NULL,NULL,1),(15665,NULL,NULL,1),(16101,NULL,NULL,1),(16250,NULL,NULL,1),(16412,NULL,NULL,1),(16413,NULL,NULL,1),(16415,NULL,NULL,1),(16788,NULL,NULL,1),(17203,NULL,NULL,1),(17290,NULL,NULL,1),(18082,NULL,NULL,1),(18105,NULL,NULL,1),(18108,NULL,NULL,1),(18199,NULL,NULL,1),(18392,NULL,NULL,1),(18796,NULL,NULL,1),(19391,NULL,NULL,1),(19816,NULL,NULL,1),(20420,NULL,NULL,1),(20678,NULL,NULL,1),(20692,NULL,NULL,1),(20714,NULL,NULL,1),(20793,NULL,NULL,1),(20797,NULL,NULL,1),(20808,NULL,NULL,1),(20811,NULL,NULL,1),(20815,NULL,NULL,1),(20823,NULL,NULL,1),(21072,NULL,NULL,1),(21159,NULL,NULL,1),(21162,NULL,NULL,1),(21230,NULL,NULL,1),(21402,NULL,NULL,1),(21549,NULL,NULL,1),(22088,NULL,NULL,1),(22425,NULL,NULL,1),(23024,NULL,NULL,1),(23411,NULL,NULL,1),(23512,NULL,NULL,1),(24374,NULL,NULL,1),(24611,NULL,NULL,1),(25306,NULL,NULL,1),(39416,NULL,NULL,1),(53,NULL,NULL,2),(703,NULL,NULL,2),(1329,NULL,NULL,2),(2589,NULL,NULL,2),(2590,NULL,NULL,2),(2591,NULL,NULL,2),(5221,NULL,NULL,2),(6785,NULL,NULL,2),(6787,NULL,NULL,2),(6800,NULL,NULL,2),(8627,NULL,NULL,2),(8631,NULL,NULL,2),(8632,NULL,NULL,2),(8633,NULL,NULL,2),(8676,NULL,NULL,2),(8721,NULL,NULL,2),(8724,NULL,NULL,2),(8725,NULL,NULL,2),(8992,NULL,NULL,2),(9829,NULL,NULL,2),(9830,NULL,NULL,2),(9866,NULL,NULL,2),(9867,NULL,NULL,2),(11267,NULL,NULL,2),(11268,NULL,NULL,2),(11269,NULL,NULL,2),(11279,NULL,NULL,2),(11280,NULL,NULL,2),(11281,NULL,NULL,2),(11289,NULL,NULL,2),(11290,NULL,NULL,2),(21987,NULL,NULL,2),(23959,NULL,NULL,2),(24825,NULL,NULL,2),(25300,NULL,NULL,2),(26839,NULL,NULL,2),(26863,NULL,NULL,2),(26884,NULL,NULL,2),(27001,NULL,NULL,2),(27002,NULL,NULL,2),(27005,NULL,NULL,2),(27441,NULL,NULL,2),(34411,NULL,NULL,2),(34412,NULL,NULL,2),(34413,NULL,NULL,2); /*!40000 ALTER TABLE `spellextra` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spelloverride` -- DROP TABLE IF EXISTS `spelloverride`; CREATE TABLE `spelloverride` ( `overrideId` int(30) NOT NULL default '0', `spellId` int(30) NOT NULL default '0', UNIQUE KEY `overrideId` (`overrideId`,`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `spelloverride` -- LOCK TABLES `spelloverride` WRITE; /*!40000 ALTER TABLE `spelloverride` DISABLE KEYS */; INSERT INTO `spelloverride` VALUES (836,10),(836,6141),(836,8427),(836,10185),(836,10186),(836,10187),(836,27085),(836,27618),(850,5246),(850,12730),(850,19134),(850,20511),(850,29544),(850,33789),(850,38945),(850,38946),(968,5246),(968,12730),(968,19134),(968,20511),(968,29544),(968,33789),(968,38945),(968,38946),(969,5246),(969,12730),(969,19134),(969,20511),(969,29544),(969,33789),(969,38945),(969,38946),(988,10),(988,6141),(988,8427),(988,10185),(988,10186),(988,10187),(988,27085),(988,27618),(989,10),(989,6141),(989,8427 7),(5063,17),(5063,592),(5063,600),(5063,3747),(5063,6065),(5063,6066),(5063,10898),(5063,10899),(5063,10900),(5063,10901),(5063,25217),(5063,25218),(5063,27607),(5064,17),(5064,592),(5064,600),(5064,3747),(5064,6065),(5064,6066),(5064,10898),(5064,10899),(5064,10900),(5064,10901),(5064,25217),(5064,25218),(5064,27607),(5065,17),(5065,592),(5065,600),(5065,3747),(5065,6065),(5065,6066),(5065,10898),(5065,10899),(5065,10900),(5065,10901),(5065,25217),(5065,25218),(5065,27607),(5066,589),(5066,594),(5066,970),(5066,992),(5066,2767),(5066,10892),(5066,10893),(5066,10894),(5066,15407),(5066,16568),(5066,17165),(5066,17311),(5066,17312),(5066,17313),(5066,17314),(5066,18807),(5066,22919),(5066,23953),(5066,25367),(5066,25368),(5066,25387),(5066,26044),(5066,26143),(5066,27605),(5066,28310),(5066,29407),(5066,29570),(5066,32417),(5066,34914),(5066,34916),(5066,34917),(5066,35507),(5066,37276),(5066,37330),(5066,37621),(5066,38243),(5142,403),(5142,421),(5142,529),(5142,548),(5142,915),(5142,930),(5142,943),(5142,2860),(5142,6041),(5142,10391),(5142,10392),(5142,10605),(5142,15207),(5142,15208),(5142,25439),(5142,25442),(5142,25448),(5142,25449),(5142,37661),(5147,20116),(5147,20922),(5147,20923),(5147,20924),(5147,26573),(5147,27173),(5147,32773),(5147,33559),(5147,36946),(5147,37553),(5147,38385),(5148,2912),(5148,8949),(5148,8950),(5148,8951),(5148,9875),(5148,9876),(5148,21668),(5148,25298),(5148,26986),(5148,35243),(5148,38935),(5236,1130),(5236,14323),(5236,14324),(5236,14325),(5236,31615),(5237,1130),(5237,14323),(5237,14324),(5237,14325),(5237,31615),(5238,1130),(5238,14323),(5238,14324),(5238,14325),(5238,31615),(5239,1130),(5239,14323),(5239,14324),(5239,14325),(5239,31615),(5240,1130),(5240,14323),(5240,14324),(5240,14325),(5240,31615),(5494,1463),(5494,8494),(5494,8495),(5494,10191),(5494,10192),(5494,10193),(5494,17740),(5494,17741),(5494,27131),(5494,29880),(5494,30973),(5494,31635),(5494,35064),(5494,38151),(5634,17364),(5634,32175),(5634,32176); /*!40000 ALTER TABLE `spelloverride` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spells112` -- DROP TABLE IF EXISTS `spells112`; CREATE TABLE `spells112` ( `Id` int(100) default '0', `School` int(100) default '0', `Category` int(100) default '0', `field4` int(100) default '0', `DispelType` int(100) default '0', `MechanicsType` int(100) default '0', `Attributes` int(100) default '0', `AttributesEx` int(100) default '0', `Flags3` int(100) default '0', `field10` int(100) default '0', `field11` int(100) default '0', `UNK12` int(100) default '0', `UNK13` int(100) default '0', `Targets` int(100) default '0', `TargetCreatureType` int(100) default '0', `RequiresSpellFocus` int(100) default '0', `CasterAuraState` int(100) default '0', `TargetAuraState` int(100) default '0', `CastingTimeIndex` int(100) default '0', `RecoveryTime` int(100) default '0', `CategoryRecoveryTime` int(100) default '0', `InterruptFlags` int(100) default '0', `AuraInterruptFlags` int(100) default '0', `ChannelInterruptFlags` int(100) default '0', `procFlags` int(100) default '0', `procChance` int(100) default '0', `procCharges` int(100) default '0', `maxLevel` int(100) default '0', `baseLevel` int(100) default '0', `spellLevel` int(100) default '0', `DurationIndex` int(100) default '0', `powerType` int(100) default '0', `manaCost` int(100) default '0', `manaCostPerlevel` int(100) default '0', `manaPerSecond` int(100) default '0', `manaPerSecondPerLevel` int(100) default '0', `rangeIndex` int(100) default '0', `speed` float default '0', `modalNextSpell` int(100) default '0', `maxstack` int(100) default '0', `Totem1` int(100) default '0', `Totem2` int(100) default '0', `Reagent1` int(100) default '0', `Reagent2` int(100) default '0', `Reagent3` int(100) default '0', `Reagent4` int(100) default '0', `Reagent5` int(100) default '0', `Reagent6` int(100) default '0', `Reagent7` int(100) default '0', `Reagent8` int(100) default lags` int(100) default '0', `ManaCostPercentage` int(100) default '0', `unkflags` int(100) default '0', `StartRecoveryTime` int(100) default '0', `StartRecoveryCategory` int(100) default '0', `SpellFamilyName` int(100) default '0', `SpellGroupType` int(100) default '0', `unkne` int(100) default '0', `MaxTargets` int(100) default '0', `Spell_Dmg_Type` int(100) default '0', `FG` int(100) default '0', `FH` int(100) default '0', `dmg_multiplier_1` float default '0', `dmg_multiplier_2` float default '0', `dmg_multiplier_3` float default '0', `FL` int(100) default '0', `FM` int(100) default '0', `FN` int(100) default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:52:19 Line no.:198722 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r table `creature_spawns` DROP TABLE gned NOT NULL default '0', `Map` int Scarab' at line 1 Query: r table `creature_spawns` DROP TABLE gned NOT NULL default '0', `Map` int Scarab Wall'),(94,8936.56,-7439.9,8 (215,3032.44,3594.28,145.806,4. Waste'),(333,3216.28,2992.5 LL default '0', `sellprice` int(30) NOT NULL default '0', `inve `text0_0` longtext NOT NULL, `text0_1` longtext NOT NULL, 5,6),(4,4,4,1,1,141,10311.3,832.463,1326.41,55,20,25,21,20,20 LUES (1,38,3,1),(1,39,6,1),(1,40,7,1),(1,2362,16,1),(1,25 38,5,5),(20,101,5,5),(20,111,300,300),(20,253,5,5),(2 ,5),(50,172,0,5),(50,164,0,0),(50,142,0,1),(50,14 9,7266),(39,7267),(39,7355),(39,8386),(39,216 8),(36,227),(36,7340),(36,203),(41,1180), t(10) unsigned NOT NULL default '0', Orchard',3),(242,'Brightwood Grove h Gate Pass',1),(808,'North Ga (2246,'Frostfire Hot Sprin 11) unsigned NOT NULL OCK TABLES; -- LL,1),(30213,NU ),(10947,NU 22,NULL ULL 4,NULL,NULL,1),(20355,NULL,NULL,1),(20411,NULL,NULL,1),(20412,NULL,NULL,1),(20413,NULL,NULL,1),(20414,NULL,NULL,1),(20425,NULL,NULL,1),(20467,NULL,NULL,1),(20961,NULL,NULL,1),(20962,NULL,NULL,1),(20963,NULL,NULL,1),(20964,NULL,NULL,1),(20965,NULL,NULL,1),(20966,NULL,NULL,1),(20967,NULL,NULL,1),(20968,NULL,NULL,1),(21183,NULL,NULL,1),(21889,NULL,NULL,1),(23590,NULL,NULL,1),(24234,NULL,NULL,1),(25061,NULL,NULL,1),(25745,NULL,NULL,1),(25751,NULL,NULL,1),(25752,NULL,NULL,1),(25753,NULL,NULL,1),(25757,NULL,NULL,1),(25758,NULL,NULL,1),(25759,NULL,NULL,1),(25760,NULL,NULL,1),(25761,NULL,NULL,1),(25762,NULL,NULL,1),(25942,NULL,NULL,1),(25943,NULL,NULL,1),(25944,NULL,NULL,1),(25945,NULL,NULL,1),(27731,NULL,NULL,1),(133,NULL,NULL,1),(143,NULL,NULL,1),(145,NULL,NULL,1),(3140,NULL,NULL,1),(8400,NULL,NULL,1),(8401,NULL,NULL,1),(8402,NULL,NULL,1),(9053,NULL,NULL,1),(9487,NULL,NULL,1),(9488,NULL,NULL,1),(10148,NULL,NULL,1),(10149,NULL,NULL,1),(10150,NULL,NULL,1),(10151,NULL,NULL,1),(10578,NULL,NULL,1),(11839,NULL,NULL,1),(11921,NULL,NULL,1),(11985,NULL,NULL,1),(11988,NULL,NULL,1),(11989,NULL,NULL,1),(12466,NULL,NULL,1),(13140,NULL,NULL,1),(13375,NULL,NULL,1),(13438,NULL,NULL,1),(14034,NULL,NULL,1),(15228,NULL,NULL,1),(15242,NULL,NULL,1),(15243,NULL,NULL,1),(15285,NULL,NULL,1),(15536,NULL,NULL,1),(15662,NULL,NULL,1),(15665,NULL,NULL,1),(16101,NULL,NULL,1),(16250,NULL,NULL,1),(16412,NULL,NULL,1),(16413,NULL,NULL,1),(16415,NULL,NULL,1),(16788,NULL,NULL,1),(17203,NULL,NULL,1),(17290,NULL,NULL,1),(18082,NULL,NULL,1),(18105,NULL,NULL,1),(18108,NULL,NULL,1),(18199,NULL,NULL,1),(18392,NULL,NULL,1),(18796,NULL,NULL,1),(19391,NULL,NULL,1),(19816,NULL,NULL,1),(20420,NULL,NULL,1),(20678,NULL,NULL,1),(20692,NULL,NULL,1),(20714,NULL,NULL,1),(20793,NULL,NULL,1),(20797,NULL,NULL,1),(20808,NULL,NULL,1),(20811,NULL,NULL,1),(20815,NULL,NULL,1),(20823,NULL,NULL,1),(21072,NULL,NULL,1),(21159,NULL,NULL,1),(21162,NULL,NULL,1),(21230,NULL,NULL,1),(21402,NULL,NULL,1),(21549,NULL,NULL,1),(22088,NULL,NULL,1),(22425,NULL,NULL,1),(23024,NULL,NULL,1),(23411,NULL,NULL,1),(23512,NULL,NULL,1),(24374,NULL,NULL,1),(24611,NULL,NULL,1),(25306,NULL,NULL,1),(39416,NULL,NULL,1),(53,NULL,NULL,2),(703,NULL,NULL,2),(1329,NULL,NULL,2),(2589,NULL,NULL,2),(2590,NULL,NULL,2),(2591,NULL,NULL,2),(5221,NULL,NULL,2),(6785,NULL,NULL,2),(6787,NULL,NULL,2),(6800,NULL,NULL,2),(8627,NULL,NULL,2),(8631,NULL,NULL,2),(8632,NULL,NULL,2),(8633,NULL,NULL,2),(8676,NULL,NULL,2),(8721,NULL,NULL,2),(8724,NULL,NULL,2),(8725,NULL,NULL,2),(8992,NULL,NULL,2),(9829,NULL,NULL,2),(9830,NULL,NULL,2),(9866,NULL,NULL,2),(9867,NULL,NULL,2),(11267,NULL,NULL,2),(11268,NULL,NULL,2),(11269,NULL,NULL,2),(11279,NULL,NULL,2),(11280,NULL,NULL,2),(11281,NULL,NULL,2),(11289,NULL,NULL,2),(11290,NULL,NULL,2),(21987,NULL,NULL,2),(23959,NULL,NULL,2),(24825,NULL,NULL,2),(25300,NULL,NULL,2),(26839,NULL,NULL,2),(26863,NULL,NULL,2),(26884,NULL,NULL,2),(27001,NULL,NULL,2),(27002,NULL,NULL,2),(27005,NULL,NULL,2),(27441,NULL,NULL,2),(34411,NULL,NULL,2),(34412,NULL,NULL,2),(34413,NULL,NULL,2); /*!40000 ALTER TABLE `spellextra` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spelloverride` -- DROP TABLE IF EXISTS `spelloverride`; CREATE TABLE `spelloverride` ( `overrideId` int(30) NOT NULL default '0', `spellId` int(30) NOT NULL default '0', UNIQUE KEY `overrideId` (`overrideId`,`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `spelloverride` -- LOCK TABLES `spelloverride` WRITE; /*!40000 ALTER TABLE `spelloverride` DISABLE KEYS */; INSERT INTO `spelloverride` VALUES (836,10),(836,6141),(836,8427),(836,10185),(836,10186),(836,10187),(836,27085),(836,27618),(850,5246),(850,12730),(850,19134),(850,20511),(850,29544),(850,33789),(850,38945),(850,38946),(968,5246),(968,12730),(968,19134),(968,20511),(968,29544),(968,33789),(968,38945),(968,38946),(969,5246),(969,12730),(969,19134),(969,20511),(969,29544),(969,33789),(969,38945),(969,38946),(988,10),(988,6141),(988,8427),(988,10185),(988,10186),(988,10187),(988,27085),(988,27618),(989,10),(989,6141),(989,8427 7),(5063,17),(5063,592),(5063,600),(5063,3747),(5063,6065),(5063,6066),(5063,10898),(5063,10899),(5063,10900),(5063,10901),(5063,25217),(5063,25218),(5063,27607),(5064,17),(5064,592),(5064,600),(5064,3747),(5064,6065),(5064,6066),(5064,10898),(5064,10899),(5064,10900),(5064,10901),(5064,25217),(5064,25218),(5064,27607),(5065,17),(5065,592),(5065,600),(5065,3747),(5065,6065),(5065,6066),(5065,10898),(5065,10899),(5065,10900),(5065,10901),(5065,25217),(5065,25218),(5065,27607),(5066,589),(5066,594),(5066,970),(5066,992),(5066,2767),(5066,10892),(5066,10893),(5066,10894),(5066,15407),(5066,16568),(5066,17165),(5066,17311),(5066,17312),(5066,17313),(5066,17314),(5066,18807),(5066,22919),(5066,23953),(5066,25367),(5066,25368),(5066,25387),(5066,26044),(5066,26143),(5066,27605),(5066,28310),(5066,29407),(5066,29570),(5066,32417),(5066,34914),(5066,34916),(5066,34917),(5066,35507),(5066,37276),(5066,37330),(5066,37621),(5066,38243),(5142,403),(5142,421),(5142,529),(5142,548),(5142,915),(5142,930),(5142,943),(5142,2860),(5142,6041),(5142,10391),(5142,10392),(5142,10605),(5142,15207),(5142,15208),(5142,25439),(5142,25442),(5142,25448),(5142,25449),(5142,37661),(5147,20116),(5147,20922),(5147,20923),(5147,20924),(5147,26573),(5147,27173),(5147,32773),(5147,33559),(5147,36946),(5147,37553),(5147,38385),(5148,2912),(5148,8949),(5148,8950),(5148,8951),(5148,9875),(5148,9876),(5148,21668),(5148,25298),(5148,26986),(5148,35243),(5148,38935),(5236,1130),(5236,14323),(5236,14324),(5236,14325),(5236,31615),(5237,1130),(5237,14323),(5237,14324),(5237,14325),(5237,31615),(5238,1130),(5238,14323),(5238,14324),(5238,14325),(5238,31615),(5239,1130),(5239,14323),(5239,14324),(5239,14325),(5239,31615),(5240,1130),(5240,14323),(5240,14324),(5240,14325),(5240,31615),(5494,1463),(5494,8494),(5494,8495),(5494,10191),(5494,10192),(5494,10193),(5494,17740),(5494,17741),(5494,27131),(5494,29880),(5494,30973),(5494,31635),(5494,35064),(5494,38151),(5634,17364),(5634,32175),(5634,32176); /*!40000 ALTER TABLE `spelloverride` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `spells112` -- DROP TABLE IF EXISTS `spells112`; CREATE TABLE `spells112` ( `Id` int(100) default '0', `School` int(100) default '0', `Category` int(100) default '0', `field4` int(100) default '0', `DispelType` int(100) default '0', `MechanicsType` int(100) default '0', `Attributes` int(100) default '0', `AttributesEx` int(100) default '0', `Flags3` int(100) default '0', `field10` int(100) default '0', `field11` int(100) default '0', `UNK12` int(100) default '0', `UNK13` int(100) default '0', `Targets` int(100) default '0', `TargetCreatureType` int(100) default '0', `RequiresSpellFocus` int(100) default '0', `CasterAuraState` int(100) default '0', `TargetAuraState` int(100) default '0', `CastingTimeIndex` int(100) default '0', `RecoveryTime` int(100) default '0', `CategoryRecoveryTime` int(100) default '0', `InterruptFlags` int(100) default '0', `AuraInterruptFlags` int(100) default '0', `ChannelInterruptFlags` int(100) default '0', `procFlags` int(100) default '0', `procChance` int(100) default '0', `procCharges` int(100) default '0', `maxLevel` int(100) default '0', `baseLevel` int(100) default '0', `spellLevel` int(100) default '0', `DurationIndex` int(100) default '0', `powerType` int(100) default '0', `manaCost` int(100) default '0', `manaCostPerlevel` int(100) default '0', `manaPerSecond` int(100) default '0', `manaPerSecondPerLevel` int(100) default '0', `rangeIndex` int(100) default '0', `speed` float default '0', `modalNextSpell` int(100) default '0', `maxstack` int(100) default '0', `Totem1` int(100) default '0', `Totem2` int(100) default '0', `Reagent1` int(100) default '0', `Reagent2` int(100) default '0', `Reagent3` int(100) default '0', `Reagent4` int(100) default '0', `Reagent5` int(100) default '0', `Reagent6` int(100) default '0', `Reagent7` int(100) default '0', `Reagent8` int(100) default lags` int(100) default '0', `ManaCostPercentage` int(100) default '0', `unkflags` int(100) default '0', `StartRecoveryTime` int(100) default '0', `StartRecoveryCategory` int(100) default '0', `SpellFamilyName` int(100) default '0', `SpellGroupType` int(100) default '0', `unkne` int(100) default '0', `MaxTargets` int(100) default '0', `Spell_Dmg_Type` int(100) default '0', `FG` int(100) default '0', `FH` int(100) default '0', `dmg_multiplier_1` float default '0', `dmg_multiplier_2` float default '0', `dmg_multiplier_3` float default '0', `FL` int(100) default '0', `FM` int(100) default '0', `FN` int(100) default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Error occured at:2007-08-19 12:52:34 Line no.:198722 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'r table `creature_spawns` DROP TABLE gned NOT NULL default '0', `Map` int Scarab' at line 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 16:26:50 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 16:27:11 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO (entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, emote_state, respawnNpcLink) VALUES (50000, 1, 16256.1, 16298.3, 13.1752, 3.0377, 0, 18106, 1741, 0, 0, 0, 0, 0) Error occured at:2007-08-19 16:27:34 Line no.:3 Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, e' at line 1 Query: CREATE TABLE `accounts` ( `acct` bigint(20) NOT NULL auto_increment, `login` varchar(255) NOT NULL default '', `password` varchar(28) NOT NULL default '', `gm` varchar(27) NOT NULL default '', `banned` int(30) NOT NULL default '0', `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, `lastip` varchar(15) NOT NULL default '', `email` varchar(50) NOT NULL default '', `flags` int(11) NOT NULL default '0', PRIMARY KEY (`acct`,`login`), UNIQUE KEY `acct` (`acct`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 Error occured at:2007-08-19 16:35:12 Line no.:26 Error Code: 1050 - Table 'accounts' already exists Query: CREATE TABLE `accounts` ( `acct` bigint(20) NOT NULL auto_increment, `login` varchar(255) NOT NULL default '', `password` varchar(28) NOT NULL default '', `gm` varchar(27) NOT NULL default '', `banned` int(30) NOT NULL default '0', `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP, `lastip` varchar(15) NOT NULL default '', `email` varchar(50) NOT NULL default '', `flags` int(11) NOT NULL default '0', PRIMARY KEY (`acct`,`login`), UNIQUE KEY `acct` (`acct`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 Error occured at:2007-08-19 16:35:26 Line no.:26 Error Code: 1050 - Table 'accounts' already exists Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:17:12 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:26:53 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:28:39 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:29:56 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:30:02 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:32:17 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-19 18:35:17 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1 Query: INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state) VALUES (50000, 100, 100, 1741, 1000000, 1000000, 1000000, 1, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-21 10:48:54 Line no.:86 Error Code: 1054 - Unknown column 'minlevel' in 'field list' Query: INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, item1slotdisplay, item1info1, item1info2, item2slotdisplay, item2info1, item2info2, item3slotdisplay, item3info1, item3info2, respawntime, resistance0_armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state) VALUES (50000, 100, 100, 1741, 1000000, 1000000, 1000000, 1, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0) Error occured at:2007-08-21 10:51:06 Line no.:86 Error Code: 1054 - Unknown column 'minlevel' in 'field list'
21-08-07
SERVER-X

Re: [ASCENT][CUSTOM] GM Vendors

The vendors are spawns from 0-49 what is with the other vendors?
21-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by matei2me

can someone tell me the query for updating all items buyprice in a shop to 100g ... as the tier vendors don't have any prices.

hihi You'll need to do a bit of work here as you need to specify all the Item ID values in this...

Code:

UPDATE items SET itemextendedcost = '1000000' WHERE entry IN (ItemID, ItemID, ETC);

Or I'd try rerunning Channels script custom_shop_buyprice.sql again
21-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Seg....

The error would seem to indicate that your table structure maybe wrong to import the dump file.

Have you run the query at the very start of this topic (page1) before attempting to run the custom shop stuff?
21-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by SERVER-X

The vendors are spawns from 0-49 what is with the other vendors?

I'm not following what you mean? Are the vendors 50 and upwards not spawning for you or is there some confusion that these vendors will be selling Recipes/Reagents
21-08-07
liquifigh

Re: [ASCENT][CUSTOM] GM Vendors

Only problem I have is when the NPC spawn they run around and try to kill stuff, but at least it works I guess.
21-08-07
Bloodshed2007

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by Raptaur

hihi You'll need to do a bit of work here as you need to specify all the Item ID values in this...

Code:

UPDATE items SET itemextendedcost = '100' WHERE entry IN (ItemID, ItemID, ETC);

Or I'd try rerunning Channels script custom_shop_buyprice.sql again

for the UPDATE items SET itemextendedcost = '100' shouldnt it be 1000000....cause the 100 is the gold...you need to put in the silver and copper values in too. 100 would be 1s

100g 00s 00c
21-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by Bloodshed2007

for the UPDATE items SET itemextendedcost = '100' shouldnt it be 1000000....cause the 100 is the gold...you need to put in the silver and copper values in too. 100 would be 1s

100g 00s 00c

Thanks for the spot Blood, updated the code
21-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Itemextendedcost refers to itemextendedcost.dbc, setting it 100 would correspond to... 100,0,0,24245,0,0x0,,,1,0,0,0,0, requirement of item 24245 to buy the item. Please don't try to be smart and set them like that... read itemextendedcost.dbc before making suggestions to people using my vendors, so that your info can atleast be accurate.

He wants everything to cost 100 gold or something, similar to a query like this:

Code:

UPDATE items SET buyprice = '1000000' WHERE entry IN (SELECT itemguid FROM vendors);
21-08-07
seg

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by Raptaur

Seg....

The error would seem to indicate that your table structure maybe wrong to import the dump file.

Have you run the query at the very start of this topic (page1) before attempting to run the custom shop stuff?

yeap ... i did ... the thing is i use ascent 989 because any higher core will make at the start of ascent.exe to say that creature_loot is using old don't know ... and there are no npc on the server ... so i'm using this core with Rev 8 ... but that character erorr always appear

sorry for my bad english
21-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

Itemextendedcost refers to itemextendedcost.dbc, setting it 100 would correspond to... 100,0,0,24245,0,0x0,,,1,0,0,0,0, requirement of item 24245 to buy the item. Please don't try to be smart and set them like that... read itemextendedcost.dbc before making suggestions to people using my vendors, so that your info can atleast be accurate.

He wants everything to cost 100 gold or something, similar to a query like this:

Code:

UPDATE items SET buyprice = '1000000' WHERE entry IN (SELECT itemguid FROM vendors);

thanks a lot i kinda knew this was it i just wanted to be sure.. anyone that can tell me all tier guids ?
the thing is i wanna make
1. all tier 3 pieces cost 40g
2. all tier 4 pieces cost 60g
3. all tier 5 pieces cost 80g
4. all tier 6 pieces cost 100g

i have to write 4 queries and put all guid items from that shop. does anyone did this before? si i don't have to work that much ? :-s :D
21-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Here you go:

Code:

UPDATE items SET buyprice = '400000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50005'); UPDATE items SET buyprice = '600000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50006'); UPDATE items SET buyprice = '800000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50007'); UPDATE items SET buyprice = '1000000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50008');
21-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

thanks a lot.. this is very helpfull... i thought i had to update all items id to to buyprice which will have resulted in a lot of work.very good solution, change all items in a vendor :D.. thanks a lot

NEW ISSUE
how can i save a sql with the vendors that i spawn in-game as i delete the database very often to upgrade it..... i mean how can i make a sql batch file with my spawns form in-game... assuming i spawn them in game cause i don't know coordonates to use in vendor_custom_spawn.sql.... get it ?
21-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Here:

Code:

SELECT * FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';

Then export, only problem is that when you spawn my vendors, theres a delete query, so just dont use my spawn query anymore if you have your own.
21-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

i'm just gonna delete

Code:

DELETE FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';

form u;r spawns as i would like them in gm island too .... thanks a lot
22-08-07
jaggu

Re: [ASCENT][CUSTOM] GM Vendors

Channel_49
there is a bug in your change display query that comes with 3.0a.

You included creature_proto instead of creature_names.

It should look like this...

Code:

UPDATE creature_names SET displayid = '21178' WHERE entry between '50000' and '50080'; UPDATE creature_spawns SET displayid = '21178' WHERE entry between '50000' and '50080';
22-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

Here you go:

Code:

UPDATE items SET buyprice = '400000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50005'); UPDATE items SET buyprice = '600000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50006'); UPDATE items SET buyprice = '800000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50007'); UPDATE items SET buyprice = '1000000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors AND vendorguid = '50008');

it doesn't work :|
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND vendorguid = '50005')' at line 1
(0 ms taken) any suggestions ? i think the code si bad the db has no problems
22-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Sorry... bad query :P

Code:

UPDATE items SET buyprice = '400000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid = '50005'); UPDATE items SET buyprice = '600000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid = '50006'); UPDATE items SET buyprice = '800000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid = '50007'); UPDATE items SET buyprice = '1000000', itemextendedcost = '0' WHERE entry IN (SELECT itemguid FROM vendors WHERE vendorguid = '50008');
22-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

when i run the querys it block my sqlyog when i try to close it it says
"query are executing. could not close connection" what should i do?
can someone test this for me please :-s
22-08-07
chris631992

Re: [ASCENT][CUSTOM] GM Vendors

use navicat it doesnt crash, i have had this problem and so have others
22-08-07
matei2me

Re: [ASCENT][CUSTOM] GM Vendors

thanks
22-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

Itemextendedcost refers to itemextendedcost.dbc, setting it 100 would correspond to... 100,0,0,24245,0,0x0,,,1,0,0,0,0, requirement of item 24245 to buy the item. Please don't try to be smart and set them like that... read itemextendedcost.dbc before making suggestions to people using my vendors, so that your info can atleast be accurate.

He wants everything to cost 100 gold or something, similar to a query like this:

Code:

UPDATE items SET buyprice = '1000000' WHERE entry IN (SELECT itemguid FROM vendors);

Sheesh, calm... I wasn't trying to be smart, unsure how you came to that conclusion unless you think that trying to help out is being some sort of smart ass?
I like your work, so thought to repay by helping out. I use SQL everyday among other things (unfortunate carer choice) I didn't have the TDDB setup here at work but I'll look to install it locally on my laptop (SQL2000) to keep me right for referencing any help I give

Apologies bad query, I did looked at the wrong DBC...
22-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by seg

yeap ... i did ... the thing is i use ascent 989 because any higher core will make at the start of ascent.exe to say that creature_loot is using old don't know ... and there are no npc on the server ... so i'm using this core with Rev 8 ... but that character erorr always appear

sorry for my bad english

Ahh okay then you also want to run this piece as well. http://forum.ragezone.com/f114/ascen...update-290271/ I'm using Ascent core 1141, holding up really well so far
22-08-07
haragon

Re: [ASCENT][CUSTOM] GM Vendors

abc
23-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Use the new cores with all the patches, 1071, 1132, etc.
23-08-07
Raptaur

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

Use the new cores with all the patches, 1071, 1132, etc.

From what version and above are the new cores channel?
23-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

1132 has all the new table updates
24-08-07
chris631992

Re: [ASCENT][CUSTOM] GM Vendors

Channel,
have you ever thought of adding a totem vendor?
and in the next version add the blacksmith hammer to the reagent vendor as i manually dun it on the 3.0a version when some1 on my server was asking were it was
24-08-07
sysaddmin

Re: [ASCENT][CUSTOM] GM Vendors

Hi Is there a vendor that sells enchants (that everyone can use without being a enchanter ) ... like in the afgan warriors repack for 1.12 casue that would be sweet ;) It came in a package that tad the required rod needed, the mats and a stone that you clicked on to enchant the particular enchant.
24-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Use permenant enchants.
24-08-07
Zweck

Re: [ASCENT][CUSTOM] GM Vendors

How come whenever I put your custom items in my DB whenever i log on all the monsters are x1000 bigger?!?!?

I tried it with every single DB I knew of and all the versions of antrix... STILL it doesn't work!
25-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Cuz you didnt update your tables like I said in the first post.
25-08-07
seg

Re: [ASCENT][CUSTOM] GM Vendors

Finaly i make it WORK !!! YOU ROCK channel_49
25-08-07
ctrmu

Re: [ASCENT][CUSTOM] GM Vendors

where are they ?? i added but i dont know where are the shop s^^
26-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

GM island....

.recall port gm isl
26-08-07
Triscuit

Re: [ASCENT][CUSTOM] GM Vendors

Thanks a lot for this pack. I will be using it for my server when it goes live for my gm's. I was wondering if you could e-mail me on any advice on making vendors. I know of a site i can go to but IDK if it works yet. my e-mail is Triscuit_Wells@hotmail.com. I also have a thread looking for some help on custom areas. this post was to thank you and let you know i will be using your vendors when my server goes live. again thanks for the great vendors :)

Triscuit
26-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

What patch does ascent 1141 run on? I have 2.1.3 and when I play it says unable to validate game version. Also could someone tell me how to downgrade to a lower patch, because the only way I know how is to uninstall WoW and then reinstall it but don't let it download the next patch. Thanks in advance
26-08-07
Rago

Re: [ASCENT][CUSTOM] GM Vendors

hmm... im using 3.0a and repack 1235 and i cant talk to any vendor in the game

does anyone know how to fix this? ... sorry if this is a repost
26-08-07
AidanZon

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

What patch does ascent 1141 run on? I have 2.1.3 and when I play it says unable to validate game version. Also could someone tell me how to downgrade to a lower patch, because the only way I know how is to uninstall WoW and then reinstall it but don't let it download the next patch. Thanks in advance
_________________

just go into your logonserver.conf and edit verison on the bottom; 2.1.3 i think is 6830 or something; just find your 4 digit version when you load it and make sure its your max on allow .
26-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

Ok now I can log in but it gets stuck at logging into game server and I can't create characters or anything.
27-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

2.1.3 and cant create characters? That only happens with old clients + non tbc.
27-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

Nevermind about the characters, but my main point is that after logging it it just gets stuck at "logging into game server" and won't go any further.
27-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

If its a server related bug, you should ask in another thread.
27-08-07
evansg4

Re: [ASCENT][CUSTOM] GM Vendors

ok, the only reason I didn't was because you said that for it to work I needed 1132+ and after I started using 1132+ that's when it starting getting stuck at logging into game server
28-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Try to get some new configs for your core.
29-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

New cores also have this weird pet create crashing bug
30-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Another idea for a new vendor: ore vendor. Still looking for more ideas before update.
31-08-07
savell2

Re: [ASCENT][CUSTOM] GM Vendors

i no these are GM vendors but maybe player vendors E.g 1-10? :P
31-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Those would contain... what?
31-08-07
savell2

Re: [ASCENT][CUSTOM] GM Vendors

hmmm Weapons? dont think you need armour either way ur the boss
31-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Theres a lot more items as you go lower in quality, so there will be a lot more vendors needed to cover the small items and as well as matching items for accessories and such...
31-08-07
papawonka

Re: [ASCENT][CUSTOM] GM Vendors

I think, some cool additions would be: To add Master trainers on the balcony up top.
Maybe some main professions (same spot)
31-08-07
savell2

Re: [ASCENT][CUSTOM] GM Vendors

maybe it doesnt have to be every item maybe just the best ones for that level i dunno
31-08-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

That'd be hard to filter.
31-08-07
savell2

Re: [ASCENT][CUSTOM] GM Vendors

ok i dunno then its up to u its an idea xD
01-09-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

tindin once made a set of those vendors back on terranet forums, its gone now.
01-09-07
savell2

Re: [ASCENT][CUSTOM] GM Vendors

o :(
02-09-07
GeNyaa

Re: [ASCENT][CUSTOM] GM Vendors

Is there an weapon master were you can train everything??
for warrior plate skill... that sort of things...
if that not in there can somebody give me that??
03-09-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

A weapons trainer? I dont make custom trainers
03-09-07
DavidTirno

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

New cores also have this weird pet create crashing bug

I hope they fix this soon.

I'd like to add: Great work Channel_49, 10/10 for putting these together for the communities of WoW. We value your contributions. Thank you.

It was beyond easy to install, but I had a question about the prices and what you're planning on doing with items that don't have prices yet?
03-09-07
miquelx

Re: [ASCENT][CUSTOM] GM Vendors

i love your Vendors!!
You arer my hero :D
03-09-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Items that dont have prices = item.buyprice.sql

Other than that, the items that have no sellprice either would be hard to set a price.
05-09-07
DavidTirno

Re: [ASCENT][CUSTOM] GM Vendors

Got all that. Thanks a lot channel_49

It would seem the latest Ascent cores are starting to fail us. There's a lot of repeating issues. Hopefully there's a new stable release soon, gotta keep up to date.
05-09-07
channel_49

Re: [ASCENT][CUSTOM] GM Vendors

Yeah, a lot of new content in ascent core, means a lot of bugs.
05-09-07
miquelx

Re: [ASCENT][CUSTOM] GM Vendors

can you make this vendors for antrix and for terrantet database please
PS: i know that antrix and ascent are the same thing
05-09-07
KingXCrosses

Re: [ASCENT][CUSTOM] GM Vendors

i think it works for terranet db
just update your thing on the first post *i think*
06-09-07
maztheplaya

Re: [ASCENT][CUSTOM] GM Vendors

When i try to import the latest version i get this error:

Code:

Error occured at:2007-09-06 23:51:56 Line no.:84 Error Code: 1136 - Column count doesn't match value count at row 1

Im using latest TeraNetDB , i tried to import costum vendors just after imported TeraNetDB8.

What should i do so can import properly Costum Vendors?

Tried importing with navicat and im getting this errors:

Code:

[Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50001, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50002, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50003, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50004, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50005, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50006, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50007, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50008, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50009, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50010, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50011, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50012, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50013, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50014, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50015, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50016, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50017, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50018, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50019, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50020, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50021, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50022, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50023, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50024, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50025, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50026, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50027, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50028, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50029, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50030, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50031, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50032, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50033, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50034, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50035, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50036, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50037, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50038, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50039, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50040, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50041, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50042, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50043, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50044, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50045, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50046, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50047, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50048, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50049, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50050, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50051, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50052, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50053, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50054, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50055, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50056, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50057, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50058, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50059, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50060, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50061, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50062, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50063, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50064, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50065, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50066, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50067, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50068, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50069, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50070, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50071, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50072, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50073, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50074, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50075, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50076, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50077, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50078, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50079, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO creature_proto VALUES (50080, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0);
07-09-07
Ragefire89

Re: [ASCENT][CUSTOM] GM Vendors

i'm using TeraNetDB rev8 & i DLed the 2.7 version of the vendors n it applyed just fine, just about to boot server to see if the scales didnt F-up

OK i only know that the 2.7 version works on **TeraNetDB Rev8** i have not tried 2.8 or 2.9a nor will I, u can do that if you want, 2.7 seems to work fine except the fact that the vendors are 1.5 or 2.0 scale but i can work with that =P, hope that helps maz cuz i got the same error as u when i tried 3.0
07-09-07
KingXCrosses

Re: [ASCENT][CUSTOM] GM Vendors

Maz: update ur database from the first post
Rage: Clear ur DB or re-execute the db OR try another DB
10-09-07
sagefather

Re: [ASCENT][CUSTOM] GM Vendors

love the vendor but is anyone have any problem with them, when i upload them to my server and it runs for a while it just randomly crashes im thinking its the vendors but not sure any help? THanks for the vendors tho
13-09-07
NinjaBabe

Re: [ASCENT][CUSTOM] GM Vendors

Code:

Error Code : 1054 Unknown column 'health' in 'creature_proto' (0 ms taken) Error Code : 1060 Duplicate column name 'maxhealth' (0 ms taken) (0 row(s)affected) (0 ms taken) Error Code : 1054 Unknown column 'level' in 'creature_proto' (0 ms taken) Error Code : 1060 Duplicate column name 'maxlevel' (0 ms taken) (0 row(s)affected) (0 ms taken) Error Code : 1060 Duplicate column name 'invisibility_type' (0 ms taken) Error Code : 1060 Duplicate column name 'death_state' (0 ms taken)

Some errors when I tried to run the sql......
13-09-07
Chris-h11

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by NinjaBabe

Code:

Error Code : 1054 Unknown column 'health' in 'creature_proto' (0 ms taken) Error Code : 1060 Duplicate column name 'maxhealth' (0 ms taken) (0 row(s)affected) (0 ms taken) Error Code : 1054 Unknown column 'level' in 'creature_proto' (0 ms taken) Error Code : 1060 Duplicate column name 'maxlevel' (0 ms taken) (0 row(s)affected) (0 ms taken) Error Code : 1060 Duplicate column name 'invisibility_type' (0 ms taken) Error Code : 1060 Duplicate column name 'death_state' (0 ms taken)

Some errors when I tried to run the sql......

That means you don't need to use the SQL, you already have it.
13-09-07
Kungz

Re: [ASCENT][CUSTOM] GM Vendors

How do I update my Database?
13-09-07
Lordik333

Re: [ASCENT][CUSTOM] GM Vendors

Update sql. I have the latest core. And I get error while executing files with SQLyog....
Fix bugs!!!!!!
13-09-07
Niikkoo

Re: [ASCENT][CUSTOM] GM Vendors

Quote:

Originally Posted by channel_49

Gimme another "neutral" npc that isnt involved in either side and i'll change it to that displayid. I put it as naaru cuz of that.

goblins?etheral?
14-09-07
KingXCrosses

Re: [ASCENT][CUSTOM] GM Vendors

or you could just change the faction in the database

Show 100 post(s) from this thread on one page