[HELP][ASCENT]City Guardian

[boyfashion]

When i ask to a city guardian where is a trainer, or the guild master or other option, in the map does not appear the flag! Why? I use the newest version of ascent and the newest of the databases! Why the guardian does not work?

EDIT: There arent the quester too...

[MentaL]

[fox333]

1) Delete the world Db u have now...create a new world Db...extract MileStone-0.3.x.rar(you can find thet in the "NCDB.rar\Releases\Milestones\MileStone-0.3.x") extract the Database.rar and execute Database.sql in the world Db.
2) Edit the Tool.bat :

@ECHO off
REM ############################################################################
REM #
REM #      B A S I C   U S E R   C O N F I G U R A T I O N   A R E A
REM #
REM ############################################################################
set user=root
set pass=pass
REM  wdb  -  is the World Database
REM  cdb -  is the Character Database
REM If you do not have them seperated then set them to the same values
set wdb=world
set cdb=character
REM ############################################################################
REM #
REM #    A D V A N C E D   U S E R   C O N F I G U R A T I O N   A R E A
REM #
REM ############################################################################
set port=3306
set server=localhost
set devpath=.\Development\Database
set pubpath=.\Releases
set mysqlpath=.\Development\Database\MYSQL
REM ############################################################################
REM #
REM #     D O   N O T   M O D I F Y   B E Y O N D   T H I S   P O I N T
REM #
REM ############################################################################
if %user% == CHANGEME GOTO id10t
if %pass% == CHANGEME GOTO id10t
:menu
cls
ECHO.
ECHO.
ECHO		####################################
ECHO		#######     Next Chapter     #######
ECHO		######        Database        ######
ECHO		#######     Import Tool      #######
ECHO		####################################
ECHO.
ECHO		Please type the letter for the option:
ECHO.
ECHO		 Q = Install NCDB World (Quests tables).
ECHO.
ECHO		 x - Exit
ECHO.
set /p l=            Enter Letter:
if %l%==* goto error
if %l%==q goto quest
if %l%==Q goto quest
goto error
:quest
CLS
ECHO.
ECHO.
ECHO [Importing] Started...
ECHO [Importing] Quests tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_finisher.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_starter.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_quest_finisher.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\creature_quest_starter.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\quests.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_item_binding.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\gameobject_quest_pickup_binding.sql
ECHO [Importing] Reputation On Kill Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_creature_onkill.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_faction_onkill.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\reputation_instance_onkill.sql
ECHO [Importing] PlayerCreateInfo Tables
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_bars.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_items.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_skills.sql
%mysqlpath%\mysql -h %server% --user=%user% --password=%pass% --port=%port% %wdb% < %devpath%\tables_world\playercreateinfo_spells.sql
ECHO.

just delete what you have in the tool.bat and past this cod.
edit the usre and pass!!!
3) Update the world Db whit the SQL files in you "WowServer/SQL/world/" folder

[boyfashion]

Does not work too... :'(

[fox333]

Update the world Db whit the SQL files in you "WowServer/SQL/world/" folder

[boyfashion]

i do this, but... nothing

EDIT: But i have to run tool.bat or not?

[waymirec]

tried deleting your client cache folder? invalid cache can cause a lot of strange issues.

[boyfashion]

ok, the quests are ok! Ty man! But the city guardian are bugged yet...

[fox333]

wen u create a new character ...the city guards at the new character start points dont work...the ones in main citys do

[boyfashion]

the guards in main city does not work!

[gregon13]

which main city guardians you talking about because this issue was in earlier ascent releases back in the 2.2.3 patch (at least for me)

[boyfashion]

i talk about all main city! O.O

[Bloodshed2007]

what patch are you using?

[boyfashion]

i'm using the 2.3.3 ... ascent 4293, NCDB 1210 ...

[boyfashion]

up!

[boyfashion]

i need this help! PLZ!

[Paco44]

boyfashion, I'm currently at school so I will assist you if no one else does, when I get home. I already know what the problem is, however I do not remember the name of the table.

[boyfashion]

o.o help me!say me what's the problem...

[boyfashion]

sry for the second message, but it's a problem of world db? If it is so, what's the solution? I have to download a new db?

[Paco44]

I'm terribly sorry boyfashion I suppose I read your question wrong in the first post. I thought you asked how to get the guards to talk to you. If it's an icon problem on the minimap, then I'm afraid I don't know much about it.

[boyfashion]

nuooooooooooooooooooooooooooooooooooo... and now?

[2m4Y]

...try updating your world DB with files included in Ascent!

Cheers...

[Paco44]

The only thing I could possibly come up with is that you don't have an updated NCDB.

[2m4Y]

...try updating with next

Char Updates:
4202_character_cooldowns.sql

Logon Updates:
4156_logon_accounts.sql
4156_logon_set_encrypted_passwords.sql

Althou this three updates are most likely already applyed,
& finaly

World Updates:
4042_world_quests.sql
4062_world_totemspells.sql
4069_world_disenchantingloot.sql
4069_world_prospectingloot.sql

But, none of them has something to do exactly with problem above, but man can never now!


BTW, ...download newest DB from Revision 2: /
Copy this link to your SVN client!

Try it out, cheers...