[RELEASE] Lakelog's Custom Zul'Aman

[Mesmoras]

Very nice bro I love the entire layout. +2 rep

Edit: Ahhh, one thing is needed, update all creatureloot table queries. Column "heroicchance" to "heroicpercentchance"

[bowser]

Very nice! +Rep

[Lakelog]

Very nice bro I love the entire layout. +2 rep

Edit: Ahhh, one thing is needed, update all creatureloot table queries. Column "heroicchance" to "heroicpercentchance"

Must be that I'm running an older version, or something. I'll do that for you and others who request it

[Mesmoras]

Thanks bro, let me know when that's done.

[Lakelog]

Thanks bro, let me know when that's done.

It's done, check the new download link to use it, just erase the Creatureloot inside the Zul'Aman.SQL and replace it with the new SQL

[Mesmoras]

Thanks again bro, I'll +rep you again when I can.

[Mesmoras]

Well I'm guessing the problem now is that 'index' seems to be an sql coding command (such as INSERT INTO). Or atleast that's what my friend said over the phone as I discussed the situation w/ him. So when I try to execute the new file now, it doesn't execute a thing. So I deleted to whole (index, entryid, itemid, etc.) row on each creatureloot and it seemed to work. As long as the amount of values matches the amount of rows you have, the naming of the rows in the SQL coding is not necessary.

Edit: What level is this instance supposed to be for? 225? 70? 80?

[thpthpthp]

this work on mangos?

[Lakelog]

Well I'm guessing the problem now is that 'index' seems to be an sql coding command (such as INSERT INTO). Or atleast that's what my friend said over the phone as I discussed the situation w/ him. So when I try to execute the new file now, it doesn't execute a thing. So I deleted to whole (index, entryid, itemid, etc.) row on each creatureloot and it seemed to work. As long as the amount of values matches the amount of rows you have, the naming of the rows in the SQL coding is not necessary.

Edit: What level is this instance supposed to be for? 225? 70? 80?

Answer: It works for my server, I'm currently using Chrispeee's repack & database. The instance is tuned for better geared level 80 players (bosses' normal hits are supposed to be 20000+ on cloth and around 5000+/- on plate)

this work on mangos?

It's for Ascent.

[Illidan1]

plz help can u put a link for it on a better site couse it wont let em download it on dat 1 i click download and it just says Your Download has started and nothing

[Lakelog]

plz help can u put a link for it on a better site couse it wont let em download it on dat 1 i click download and it just says Your Download has started and nothing

Mediafire is considered one of the best uploading site, as there is no waiting time. Also, don't use any programs that accelerate your downloading speed when trying to download it, as those programs mostly don't work on File Uploading sites. If you want, I can send you the SQL by email, just PM me your email adress.

[deathomen]

Not working for me either. Filebeam is a good one as well, i strongly reccommend adding a mirror there.

You gotta work with the people if you want them to use your content. I saw someone asking for an SQLyog version in a previous post, and you told them to use Navicat because you couldn't get SQLyog to work on your machine. Gotta be a little flexable.

~death~

EDIT: O.o all my posts are gone

[Illidan1]

yes and Lakelog i didnt us anythign to increase my speed i just have no windoes open on inter witht hsi Thred and meidefile with that luink and i click download and it just sat there saying Yoyur Download has started for about 3 Hours lol help

[Lakelog]

Not working for me either. Filebeam is a good one as well, i strongly reccommend adding a mirror there.

You gotta work with the people if you want them to use your content. I saw someone asking for an SQLyog version in a previous post, and you told them to use Navicat because you couldn't get SQLyog to work on your machine. Gotta be a little flexable.

~death~

EDIT: O.o all my posts are gone

Added Filebeam download links. Also, how can I add this for SQLyog when I don't know anything about the program itself, and I can't get it to work?

[deathomen]

perhaps someone else can get u an SQLyog version....ill do that when i get a chance...for now im gonna test this out.

~death~

EDIT: something that would be great is adding an sql called Delete.sql or something like that has delete queries for all the stuff you added. That way if people want to take it out, they can. Also, this needs to be updated for the latest cores. Took the liberty of getting the SQL queries for the tables you used. should be plenty enough.

SQL Update for Ascent1542 and newer:

ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;

SQL Update for Ascent1603 and newer:

alter table creature_names change displayid male_displayid int(30) not null;
alter table creature_names add column female_displayid int(30) not null after male_displayid;
alter table creature_names add column unknown_int1 int(30) not null default 0 after female_displayid;
alter table creature_names add column unknown_int2 int(30) not null default 0 after unknown_int1;
alter table creature_names change unk2 unknown_float1 float(0) not null;
alter table creature_names change unk3 unknown_float2 float(0) not null;
alter table creature_proto add column fly_speed float(0) default "14.0" not null;
alter table creature_proto add column extra_a9_flags int(30) default 0 not null;

SQL Update for Ascent1730 and newer:

alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;