[Share] Ackhole Malls. They Work For 2.4.3

[Chrisspitz]

I think your like is broke.
EDIT:
Well obviously I was to lazy to read the other posts

[Silentnvd]

I took the Time to upload the mall and put it on Filebeam since Ackhole is Dead

Filebeam - Free Fast File Hosting <--- Ackhole malls
Love,
Silent

[Ickybad]

Thanks man I will add them to the post if you don't mind.

[Silentnvd]

Thanks man I will add them to the post if you don't mind.

atleast give me some credit since i uploaded Pl0X :confused:

[wside420]

When I execute "Trainer_spells.sql" [Err] 1364 - Field 'learn_spell' doesn't have a default value
[Err] insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('100106','33694','20000','0','0','0','60','0','0');
[Msg] Finished - Unsuccessfully

This is because I Have "Learn_spell" Column for the Trainer_spells Table.
I am using an up to date WhyDB. Anyone have solutions?

[predadmi]

whats is de item id of the key portal?

[Juggalo90]

Its not dead, he just needs to either buy the domain again or more web hosting...

[ynospsp123]

any1 smart enough to look for there svn witch has the mall in it ACPDB http://mmoforge.org/svn/acpfdb your very very very very welcome have an nice day plus here are the individual svn's
Core Work:
http://mmoforge.org/svn/acpfcore
Database Work:
http://mmoforge.org/svn/acpfdb
Script work:
http://mmoforge.org/svn/acpfscripts

http://mmoforge.org/svn/acpfdb is the one with the mall

[welshy123]

any images of mall ?

[CircaSkaterr]

when i try to extract this into my mangos DB i get an error

Error occured at:2008-07-24 22:31:51
Line no.:1
Error Code: 1146 - Table 'mangos.creature_names' doesn't exist

[eric888]

Im having problems excrating the SQL files...
These are the errors im reciving

goobject_names.sql:

[Err] 1062 - Duplicate entry '1000006' for key 1
[Err] insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('1000006','14','2170','Bamboo Holding pen','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0' ,'0','0','0','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

mall_item.sql

[Err] 1054 - Unknown column 'ItemExtendedCost' in 'field list'
[Err] insert into `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ArenaRankRequirement`, `ReqDisenchantSkill`, `unk2`) values('100101','14','-1','-1','Mall Token of Entrance','Mall Token of Entrance','Mall Token of Entrance','Mall Token of Entrance','6418','6','0','0','0','0','-1','-1','0','0','0','0','0','0','0','0','0','1','1','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',' 0','0','0','0','0','0','0','0','1','','0','0','0','0','0','0','0','0','0','0','0 ','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

trainer_spells.sql

[Err] 1364 - Field 'learn_spell' doesn't have a default value
[Err] insert into `trainer_spells` (`entry`, `cast_spell`, `spellcost`, `reqspell`, `reqskill`, `reqskillvalue`, `reqlevel`, `deletespell`, `is_prof`) values('100106','33694','20000','0','0','0','60','0','0');
[Msg] Finished - Unsuccessfully
--------------------------------------------------

vendors.sql

[Err] 1146 - Table 'scyther.vendors' doesn't exist
[Err] Delete from `vendors` where `entry` between '100010' and '100250';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[eric888]

I posted them in my blizzlike repack V2 and V2.4.3 also .

Exactly what did you post in those repacks?

The malls or what, cause im dying trying to get the mall working
(To lazy to type .additem all the time and i would love the idea of a mall)

[ynospsp123]

[YNOSPSP123's GUIDE TO GET THESE DAMED THIGS WORKING] First try putting em all in if that dont work go to the file and delete the Delete from `vendors` where `entry` between so and so just edit with note pad do this for each file that you error NOT RECOMENDED IF YOUR USING A FUN REPACK ALREADY as these #s will most likely be already taken thats whey the delete's is there if that dont work msg me plz ill try to help plz include your sql error thx

eric888 im dying trying to get the mall working
(To lazy to type .additem all the time and i would love the idea of a mall)

try this if this dont work msg me


Example:Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` between '50000000' and '50000029';
Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` between '300003' and '300009';
Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` = '1000006';
delete these i would recomend makeing a backup of the files just for safety as i have learned the hard way with much bigger file's aka databases >.>

[eric888]

That doesnt work for me at all to be honest.

[CircaSkaterr]

[YNOSPSP123's GUIDE TO GET THESE DAMED THIGS WORKING] First try putting em all in if that dont work go to the file and delete the Delete from `vendors` where `entry` between so and so just edit with note pad do this for each file that you error NOT RECOMENDED IF YOUR USING A FUN REPACK ALREADY as these #s will most likely be already taken thats whey the delete's is there if that dont work msg me plz ill try to help plz include your sql error thx try this if this dont work msg me


Example:Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` between '50000000' and '50000029';
Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` between '300003' and '300009';
Delete from `<usally what ever the name of the file is here aka g.o or creature proto>_names` where `entry` = '1000006';
delete these i would recomend makeing a backup of the files just for safety as i have learned the hard way with much bigger file's aka databases >.>

k so i tried extracting all of them, none worked. Tried the deleting thing, didn't work either. so what else can i try to get this to work?