Julianx's Shopping Mall V2.5[Ascent][Last Release]

[Julian_X]

Ok to get to the Mall manually to check it out b4 you wanna try this out use this command.

Code:
.worldport 530 -3572.760254 -95.951981 303.653137
Ok I changed the overall set-up of the Vendors, and removed a few items, added portals to and from each city. There is also a portal to go under to the "arena" underneath and also back up if people are lazy. I will make a List with all the Vendors added, they are already spawned for you so just review and add some of your own!

-Vendors-
50000 Armor Dungeon I
50001 Armor Dungeon II
50002 Armor Dungeon III
50003 Armor Raid Tier I
50004 Armor Raid Tier II
50005 Armor Raid Tier III
50006 Armor Raid Tier IV
50007 Armor Raid Tier V
50008 Armor Raid Tier VI
50009 Armor Wrist
50010 Armor Waist
50011 Armor Feet
50012 Armor Shield
50015 Weapon Level 50+
50016 Weapon Level 60+
50017 Weapon Level 65+
50018 Weapon Level 75+
50019 Weapon Level 100+
50020 Armor Necklace
50021 Armor Rings
50022 Armor Trinket
50023 Armor Cloak
50024 Armor Shirt
50025 Armor Tabard
50026 Armor Miscellaneous
50028 Armor Off-Hands
50029 Armor Libram/Idol/Totem
50030 Arena Season I
50031 Arena Season I
50032 Arena Season I
50033 Arena Season II
50034 Arena Season II
50035 Arena Season II
50040 Misc Gemstone I
50041 Misc Gemstone II
50042 Misc Mount I
50043 Misc Mount II
50044 Misc Projectile
50045 Misc Container
50047 Misc Enchantment
50048 Misc Key
50049 Misc Currency
50050 Recipe Book A-Z
50051 Recipe Leather A-F
50052 Recipe Leather G-R
50053 Recipe Leather S-Z
50054 Recipe Tailor A-G
50055 Recipe Tailor H-Z
50056 Recipe Engineer A-Z
50057 Recipe Blacksmith A-F
50058 Recipe Blacksmith G-R
50059 Recipe Blacksmith S-Z
50060 Recipe Cooking A-Z
50061 Recipe Alchemy A-Z
50062 Recipe Enchant A-G
50063 Recipe Enchant H-Z
50064 Recipe Jeweler A-K
50065 Recipe Jeweler L-Z
50066 Reagent Leather I
50067 Reagent Leather II
50068 Reagent Tailor I
50069 Reagent Tailor II
50070 Reagent Engineer I
50071 Reagent Engineer II
50072 Reagent Blacksmith I
50073 Reagent Blacksmith II
50074 Reagent Cooking
50075 Reagent Alchemy
50076 Reagent Enchant
50077 Reagent Jeweler
50078 Reagent Miscellaneous
-----------------------------

The "arena" does not seem to want to toggle the "PvP" when you enter, it like it does Gurubashi Arena, but you can still use it for that.

It looks like this with Vendors and etc.

-Download-
Julianx's Mall 2.5

Inside includes Changelog, Credits and instructions

[MentaL]

[KingXCrosses]

is this for mangos or ascent
(i'm guessing ascent)

[DrCuddles]

They are all placed in these ares already? is there any way i could move them? i have only just started this and would like the vendors, but not make them shall we say... easy to get to, for me and GM purposes only.

[maztheplaya]

Verry nice, but its seems i cant find any weapon vendor. :(

[Airforce999]

I went to one of these on another server and it toggled pvp and was ganked as soon as I spawned in ><;

[zlaya07]

omg julian you have nervs of steel :) , i could never make mall like this in 5 years :)

ty :P

[Monguse88]

All fixed. Thanks.

[Lexil123]

how do you release only The Mall? I want to release my Hall but then I have to give all my objects and npc's...
can someone tell me,.

[zipper20032]

Weapons must be spawn with ( ASCENT ) .npc spawn vendorID 1
1 is to remain permanent

[makka]

they wernt there for me the ports were but not the venders

[n00blet88]

When i click Extecute batch on navicat it dosenot work

Err] 1136 - Column count doesn't match value count at row 1
[Err] /* Creature_Proto */
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);
[Msg] Finished - Unsuccessfully

[miceiken]

n00blet88:
That error causes because of the different database. Same thing happens to me.
Im using TerraNet DB. Ask Julian_X to fix it.

[Julian_X]

TerraNet is out of date so I don't have to fix it.

[Carcenagin]

I installed this on my server with no problems, and all the NPCs were spawned. I use JulianX's repack 4. I went to Undercity and used the portal to the mall, and it worked flawlessly.

[zakman]

julianx i have the same problem as nooblet88 how do we fix this?? please tell us asap thanks

[RaF71]

Oki this is repack

[Kira90]

ok ... I know this has no relivency 2 the post ... but where can I get that GM addon u have on the Screen Shot (JulianX)

Thanx :D

[zakman]

RaF71 that dint help its still says that error?? how can i fixes this??

lol i was gona ask the same question kira lol i have been looking for one for ascent

[ilia2006]

Why when i extecute to SQL is show me a 1064 error ? can u help me please?

[Kiteal]

ok ... I know this has no relivency 2 the post ... but where can I get that GM addon u have on the Screen Shot (JulianX)

Thanx :D

Uh I have that addon if you want it, I'll upload in a sec.

MEGAUPLOAD - The leading online storage and file delivery service

Ya, thats right, I uploaded at megaupload D:< I am that lazy.

Also, I am pretty sure they are the same thing but that is the minimized version. If not they are really similar.

-Kiteal


Oh ya Btw, whenever I try to put this in my DB I always get this error "Query:
/* Creature_Proto */
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, 2.5, 8)

Error occured at:2006-09-20 16:34:00
Line no.:125
Error Code: 1136 - Column count doesn't match value count at row 1"

And I tried it on Life DB and NCDB - Milestone 0.1 (Current one I am using.) Any suggestions would be helpful. Thanks.

[CrimsonRO]

Uh I have that addon if you want it, I'll upload in a sec.

MEGAUPLOAD - The leading online storage and file delivery service

Ya, thats right, I uploaded at megaupload D:< I am that lazy.

Also, I am pretty sure they are the same thing but that is the minimized version. If not they are really similar.

-Kiteal


Oh ya Btw, whenever I try to put this in my DB I always get this error "Query:
/* Creature_Proto */
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, 2.5, 8)

Error occured at:2006-09-20 16:34:00
Line no.:125
Error Code: 1136 - Column count doesn't match value count at row 1"

And I tried it on Life DB and NCDB - Milestone 0.1 (Current one I am using.) Any suggestions would be helpful. Thanks.

its because RaF71 Fixed Shopping Malls to work with new
Ascent core 1588+ and NCDB 419+

NCDB Next Chapter MileStone 0.1 is current got new table structures which Creature_names and so forth effected Custome items, and Vendors.

Thank you RaF71 and Also to you JulianX for this Mall, players love it, Also would love see prices fixed on some of the shops, because players on my server camp on vendors getting tons gold still from buying free and selling for golds, also 2 items in Regant Vendor you can buy for 1 copper and sell for 2 silver and other is 5 copper for 2 silver or something like that.

[Kiteal]

its because RaF71 Fixed Shopping Malls to work with new
Ascent core 1588+ and NCDB 419+

NCDB Next Chapter MileStone 0.1 is current got new table structures which Creature_names and so forth effected Custome items, and Vendors.

Thank you RaF71 and Also to you JulianX for this Mall, players love it, Also would love see prices fixed on some of the shops, because players on my server camp on vendors getting tons gold still from buying free and selling for golds, also 2 items in Regant Vendor you can buy for 1 copper and sell for 2 silver and other is 5 copper for 2 silver or something like that.

Ah, thanks for the info. Really helpful :p.

-Kiteal

[Paco44]

I use this mall too, it's fantastic!!

[beaker]

I did some fixes for latest core 1607

RapidShare: 1-Click Webhosting



* male/creature displayid support (thank you blizz for patch 2.2!)
* fixed "player not creatable" bug
* added extra a9 flags and flyspeed to creatureproto

------------------------------
sql queries:
------------------------------

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;

[RaF71]

I fixing to new rev server.