help|ascent.exe cruseing

[alex5025]

its says -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Server has crashed. Reason was:
an Access Violation at 0x7C35528C
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
System Information:
Running as: α∞δ

[MentaL]

[alex5025]

please some one i need your help

[titus4k]

ensure your Db doesnt miss latest updates:

Revision: 1923
----
alter table playeritems add column randomsuffix int(30) default 0 after randomprop;


Revision: 1919
----
item_randomprop_groups.sql
item_randomsuffix_groups.sql


Revision: 1844
----
ALTER TABLE playerpets DROP COLUMN autocastspell;
UPDATE playerpets SET actionbar="";


Revision: 1837
----
trainer_defs.sql
trainer_spells.sql


Revision: 1786
----
alter table characters add column custom_faction int(30) default 0 not null after gender;


Revision: 1743
----
spell_proc_data.sql (world db)


Revision: 1730
----
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;


Revision: 1649
----
banned_phrases.sql


Revision: 1641
----
arenateams.sql


Revision: 1603
----
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;


Revision: 1602
----
alter table characters change lastDailyReset honorPointsToAdd INT(10) NOT NULL; 
update characters set honorPointsToAdd = 0;
alter table characters change charterId arenaPoints INT(10) NOT NULL;
update characters set arenaPoints = 0;


Revision: 1598
----
server_settings.sql (CHARACTER DATABASE)


Revision: 1566
----
Added : arenateams.sql
Added : charters.sql


Revision: 1561
----
Added : weather.sql


Revision: 1542
----
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;


Revision: 1425
----
if you wish to use this formula then execute this query
update ai_agents set spellCooldown=-1 where spellCooldown=0


Revision: 1393
----
CREATE TABLE `banned_names` (
`name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


Revision: 1387
----
alter table playeritems drop column guid;
alter table playeritems add column guid bigint(10) NOT NULL auto_increment primary key after ownerguid;


Revision: 1361 
----
Added : pets.sql


Revision: 1312 
---- 
Added : groups.sql


Revision: 1305 
---- 
Added : new_trainer_sruct.sql


Revision: 1143
----
CREATE TABLE `zoneguards` (
  `zoneId` int(10) unsigned NOT NULL,
  `hordeEntry` int(10) unsigned default NULL,
  `allianceEntry` int(10) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


Revision: 1132
----
alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;


Revision: 1071
----
alter table creatureloot add column heroicpercentchance float(0) default 0;
alter table creatureloot add column mincount int(30) default 1;
alter table creatureloot add column maxcount int(30) default 1;
alter table fishingloot add column heroicpercentchance float(0) default 0;
alter table fishingloot add column mincount int(30) default 1;
alter table fishingloot add column maxcount int(30) default 1;
alter table itemloot add column heroicpercentchance float(0) default 0;
alter table itemloot add column mincount int(30) default 1;
alter table itemloot add column maxcount int(30) default 1;
alter table objectloot add column heroicpercentchance float(0) default 0;
alter table objectloot add column mincount int(30) default 1;
alter table objectloot add column maxcount int(30) default 1;
alter table skinningloot add column heroicpercentchance float(0) default 0;
alter table skinningloot add column mincount int(30) default 1;
alter table skinningloot add column maxcount int(30) default 1;


Revision: 974
----
prospecting.sql


Revision: 896
----
alter table worldmap_info add column required_quest int(30) not null default 0 after lvl_mod_a;
alter table worldmap_info add column required_itemid int(30) not null default 0 after lvl_mod_a;


Revision 262:
----
UPDATE totemspells SET spellToCast1= 8349 WHERE spellId=1535
UPDATE totemspells SET spellToCast1= 8502 WHERE spellId=8498
UPDATE totemspells SET spellToCast1= 8503 WHERE spellId=8499
UPDATE totemspells SET spellToCast1= 11306 WHERE spellId=11314
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=11315
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=27623
UPDATE totemspells SET spellToCast1= 8187 WHERE spellId=8190
UPDATE totemspells SET spellToCast1= 10579 WHERE spellId=10585
UPDATE totemspells SET spellToCast1= 10580 WHERE spellId=10586
UPDATE totemspells SET spellToCast1= 10581 WHERE spellId=10587


Revision 231:
----
UPDATE totemspells SET spellToCast1= 5729 WHERE spellId=5730

t4k

[alex5025]

i have an Ascent Rev. 1939 + Scripts + Ad.exe + DLL Files

[titus4k]

as i said above. its for sure a DB issue. look into table "playeritems". is there a column called "randomsuffix" ? if not, use the sql query and update your table. same for all the other queries in the ocdebox above.
which DB are you using? which version?

t4k

[alex5025]

im useing NCDB Milestone 0.2 and i dident see an update for ascent rev 1939

[titus4k]

you also have to apply the older updates, if not allready done. and dont use milestone 0.2 its too old. use latest from their svn. or download this:
http://forum.ragezone.com/f114/lates...-daily-305070/
NCDB Rev 554 (Updated 15th October 2007)

t4k

[alex5025]

i cant use ncdb cuz it is gives me error. what the db name i need call the db name?

[alex5025]

here is an image http://84.95.212.66/asdasd.jpg

[titus4k]

hmm, bad dump of rev 554. do you have TortoiseSVN or RapidSVN ?
Download | TortoiseSVN

download and install this. create a new folder, within this folder, right mouse key, pops up a context menu, choose "SVN Checkout". now enter this adress: http://projects.emupedia.com/svn/ncdb
( username = anonymous / password: leave blank )

it will download latest revision of ncdb. takes a moment. then open Tool.bat with a texteditor: edit:
set user=CHANGEME
set pass=CHANGEME
set wdb=ascent
set cdb=character

save the file and start it (double click). press w and it will install latest world-db.

t4k

[kounelos]

alex you keep posting without reading any guides at all
go register here Next-Chapter Project and you will learn everything
about how to get the latest rev

[alex5025]

i need press c too?

[titus4k]

NO, option c will delete your current Character/Login Tables. and write new, empty tables. its only used ONCE. forget option c. just use w.

t4k