[Realese]Chrispeee NEW updated Ascent Repack

[polledkdk]

Hey.. I need help.. When i try Execute the file it says something about Accounts is allerady existing.. and if i delete the account thinks it says Something is allerady existing.. and when i delete that,.. the accounts get back.. and if i try make a new query it says the Navicat is full.. what shall i do ? please send a mail to [email protected]

[crwilborn]

Hi chrispee...i got your pack up and running its very nice i might add ..but im seem to be having a problem with aggro range regardless of level mobs will attack from the longest range posible..they also attack through walls as well...i have been searching for a fix for this problem and i can not seem to find anything on it anywhere..is there a fix for this because would like to get a few friends on my server to play with and maybe go live with it as well...but with an aggro range like that i dont want to get anyone on till i can get it fixed..any help would be appreciated

[T3h Sorrow]

Hey, i downloaded your Repack, works great, but i noticed you cant fish anywhere, i tried SW, Orgrimmar, Undercity, barrens, etc. Is there a way to make it so me and others can fish, i know i can use GM power to make my fishing maxed and ETC, but what about people without GM powers that want to actually fish.

[godofwar]

when i try to execute the Antrix file and loginserver file it give me errors like:


any ideas?
.also says that im missing worlddatabase something...
<WorldDatabase
Hostname = localhost
Username = root
Password = ascent
Name = ascent
Port = 3306
Type = 1>
<CharacterDatabase
Hostname = localhost
Username = root
Password = ascent
Name = ascent
Port = 3306
Type = 1>

[Bloodless]

Another masterpice by Chrispee +rep

[torhokon12]

hello chrispeee nice work !!! but can u help me with 1 thing??
when i am logging in all the ppl,mobs,vendors is super big !!!! like somewone did .modify scale 99999!!! can u help me?

[Entr0py]

argggg i get some gay error when i try to execute the db

Error occured at:2007-09-04 19:31:31
Line no.:227
Error Code: 2006 - MySQL server has gone away

Query:
create table `recall` (
 `id` double ,
 `locname` varchar (300),
 `mapid` int ,
 `positionX` float ,
 `positionY` float ,
 `positionZ` float 
 )

Error occured at:2007-09-13 14:50:31
Line no.:16
Error Code: 1050 - Table 'recall' already exists

Query:
INSERT INTO `creature_proto` VALUES ('50000', '100', '100', '1741', '1000000', '1000000', '1000000', '0.7', '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-09-14 17:37:18
Line no.:106
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', '1000000', '0.7', '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-09-14 17:37:42
Line no.:106
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', '1000000', '0.7', '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-09-14 17:47:47
Line no.:106
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', '1000000', '0.7', '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-09-14 17:48:26
Line no.:106
Error Code: 1136 - Column count doesn't match value count at row 1

Query:
INSERT INTO items (entry, class, subclass, field4, name, 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, ReqDisenchantSkill, unk2) 
 VALUES (95056,2,10,-1,"Bloodhorn War Staff","Bloodhorn War Staff","Bloodhorn War Staff","Bloodhorn War Staff",42091,4,0,10000000,5000000,17,-1,-1,145,75,0,0,0,0,0,0,0,0,1,0,7,54,5,55,6,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,278,411,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3600,0,0,35797,1,0,0,0,0,38347,2,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,1,2,0,0,0,0,75,0,0,0,0,4,0,8,0,8,0,426,0,0,0,0)

Error occured at:2007-09-14 19:04:26
Line no.:4
Error Code: 1062 - Duplicate entry '95056' for key 1

Query:
INSERT INTO items (entry, class, subclass, field4, name, 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, ReqDisenchantSkill, unk2) 
 VALUES (95056,2,10,-1,"Bloodhorn War Staff","Bloodhorn War Staff","Bloodhorn War Staff","Bloodhorn War Staff",42091,4,0,10000000,5000000,17,-1,-1,145,75,0,0,0,0,0,0,0,0,1,0,7,54,5,55,6,53,0,0,0,0,0,0,0,0,0,0,0,0,0,0,278,411,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3600,0,0,35797,1,0,0,0,0,38347,2,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,1,2,0,0,0,0,75,0,0,0,0,4,0,8,0,8,0,426,0,0,0,0)

Error occured at:2007-09-14 20:00:48
Line no.:4
Error Code: 1062 - Duplicate entry '95056' for key 1

Query:
INSERT INTO `creature_spawns` VALUES ('1000001066', '6295', '530', '-1814.81', '5445.47', '-12.428', '3.2052', '0', '4994', '1741', '0', '0', '0', '0', '0')

Error occured at:2007-09-14 20:02:48
Line no.:302
Error Code: 1062 - Duplicate entry '1000001066' for key 1

Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, ̉ہÂÂÂ**.')

Error occured at:2007-09-22 22:21:18
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 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=4 DEFAULT CHARSET=latin1

Error occured at:2007-09-23 10:31:57
Line no.:26
Error Code: 1050 - Table 'accounts' already exists

Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, ̉ہÂÂÂ**.')

Error occured at:2007-09-23 10:41:34
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1

Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, ̉ہÂÂÂ**.')

Error occured at:2007-09-23 12:39:39
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1

[RaIdA101]

AUSOME i love this repack

[wowowner]

when i try to finish the msql instalation i always get an error says retry or skip i cant figure out why it says accesses denied for localhost@<something> using password<YES>

[waffles2k7]

how do you get a free full version of navicat?

[Gameshark]

Hello Chrispeee,

Just wanted to say that this repack is awesome, but I need help with something, I cannot train for expert riding or artisan riding Is this intentional? Since there is all these teleports? Is there anyway I the GM can .learnsk or am I just lost? Thanks in advance for any help... My Aim Handle Is Timmysugar78, Peace, Love, And Chicken Grease!

[drtrdr23]

the logon works fine but when i open ascent it just closed rite away i dont know but if you could help me out let me know and the last repacks u had were great keep up the good work

westly

[megalord20]

i cnt exucute the db

Query:
create table `creature_proto` (
`entry` double ,
`level` double ,
`faction` double ,
`health` double ,
`mana` double ,
`scale` float ,
`npcflags` double ,
`attacktime` double ,
`mindamage` float ,
`maxdamage` float ,
`rangedattacktime` double ,
`rangedmindamage` float ,
`rangedmaxdamage` float ,
`mountdisplayid` double ,
`item1slotdisplay` double ,
`item1info1` double ,
`item1info2` double ,
`item2slotdisplay` double ,
`item2info1` double ,
`item2info2` double ,
`item3slotdisplay` double ,
`item3info1` double ,
`item3info2` double ,
`respawntime` double ,
`resistance0_armor` double ,
`resistance1` double ,
`resistance2` double ,
`resistance3` double ,
`resistance4` double ,
`resistance5` double ,
`resistance6` double ,
`combat_reach` float ,
`bounding_radius` float ,
`auras` blob ,
`boss` double ,
`money` double
)
Error occured at:2007-09-21 17:24:28
Line no.:46
Error Code: 1050 - Table 'creature_proto' already exists
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(30001, "WarpNpc", "Teleporter Npc", 0, 4, 0, 3, 0, 0, 21576, 1, 1, 1, 0)
Error occured at:2007-09-22 18:12:04
Line no.:4
Error Code: 1062 - Duplicate entry '30002' for key 1
Query:
INSERT INTO `creature_proto` VALUES (30003,70,70,14,30000,30000,100,1,0,1000,400,650,1292,62.016,85.272,0,0,0,0,0,0, 0,0,0,0,5000,0,0,0,0,0,0,0,1,1,'0',0,0,0,0)
Error occured at:2007-09-22 18:12:14
Line no.:128
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(30001, "WarpNpc", "Teleporter Npc", 0, 4, 0, 3, 0, 0, 21576, 1, 1, 1, 0)
Error occured at:2007-09-22 18:19:14
Line no.:4
Error Code: 1062 - Duplicate entry '30001' for key 1
Query:
INSERT INTO `creature_proto` VALUES (30003,70,70,14,30000,30000,100,1,0,1000,400,650,1292,62.016,85.272,0,0,0,0,0,0, 0,0,0,0,5000,0,0,0,0,0,0,0,1,1,'0',0,0,0,0)
Error occured at:2007-09-22 18:19:21
Line no.:128
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
insert into `recall` (`id`, `locname`, `mapid`, `positionX`, `positionY`, `positionZ`) values('1290','VAULTS','0','-8633.3','595.988','95.6903')
Error occured at:2007-09-22 18:19:43
Line no.:2
Error Code: 1062 - Duplicate entry '1290' for key 1
Query:
INSERT INTO `creature_proto` VALUES (30003,70,70,14,30000,30000,100,1,0,1000,400,650,1292,62.016,85.272,0,0,0,0,0,0, 0,0,0,0,5000,0,0,0,0,0,0,0,1,1,'0',0,0,0,0)
Error occured at:2007-09-22 18:20:28
Line no.:128
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO `creature_proto` VALUES (30003,70,70,14,30000,30000,100,1,0,1000,400,650,1292,62.016,85.272,0,0,0,0,0,0, 0,0,0,0,5000,0,0,0,0,0,0,0,1,1,'0',0,0,0,0)
Error occured at:2007-09-22 18:27:13
Line no.:128
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_names
(entry, creature_name, Subname, Flags1, type, Family, Rank, unk4, SpellDataID, displayid, unk2, unk3, Civilian, Leader)
VALUES
(30001, "WarpNpc", "Teleporter Npc", 0, 4, 0, 3, 0, 0, 21576, 1, 1, 1, 0)
Error occured at:2007-09-22 18:58:57
Line no.:4
Error Code: 1062 - Duplicate entry '30001' for key 1
Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, Ãâââà ¢â€šÂ¬Ã…¡Ã‚¬Ã…ÂÂÂ**.')
Error occured at:2007-09-23 12:19:12
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1
Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, Ãâââà ¢â€šÂ¬Ã…¡Ã‚¬Ã…ÂÂÂ**.')
Error occured at:2007-09-23 13:11:31
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1
Query:
CREATE TABLE `accounts` (
`acct` bigint(20) NOT NULL auto_increment,
`login` varchar(255) NOT NULL default '',
`password` varchar(2 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=4 DEFAULT CHARSET=latin1
Error occured at:2007-09-23 14:05:33
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
INSERT INTO `trainers` VALUES ('372', '186', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '60', '0', 'Hello, Ãâââà ¢â€šÂ¬Ã…¡Ã‚¬Ã…ÂÂÂ**.')
Error occured at:2007-09-23 21:54:53
Line no.:964350
Error Code: 1406 - Data too long for column 'TalkText' at row 1

[Kirbyfan]

For Everyone Having Trouble adding the empty accounts - Delete the accounts, characters, and charters tables from the DB then execute the batch, it should work.

[waffles2k7]

yo dude for some reason the creatures are huge when i log in