its `creature_names` table, column name `rank`
Type: Posts; User: gmaze
its `creature_names` table, column name `rank`
Its in creature_names, under the rank column
0 Normal
1 Elite
2 Rare Elite (?)
3 World Boss
4 Rare
that is an incomplete table, but will stop the error messages.
an official table has never been released, but from the source code, it should be something like
CREATE TABLE `transport_creatures`...
try as execute batch file
1. I don't know how to accomplish that...if u are neutral with a faction, it just gives you the option of attacking them. you could just disable pvp in that area so no one can do it, or make pvping...
Make sure you check "Continue on errors"
caused by the nether drake, and has been reported to developers
install your sql as a service, that way it auto-starts when you start your computer
I would go ahead and replace script_bin and all .exe files, rest should be ok to leave
some stuff doesn't change very frequently, but I recommend just replacing it all
the script_bin files don't change very often, and neither does logonserver.....also you can usually keep your .conf...
need to update this was fixed in revision 2421
that would work, but here is your problem....you don't have BC enabled.
I bet you have no BE's or Dranaei either, what you do is change the 'flag' column in accounts table to 8 for BC, and 0 is...
make sure the "change_me_logon" is the same in both your ascent.conf and logonserver.conf
have you customized your server?
says here cooldowntimes are whats erroring there, and I don't have this error, nor have I tried to get rid of my cooldowntimes, either.
here is how I did it, without the realmserver.
1. You need 2 copies of ascent.
2. Open your copied ascent and delete the logonserver and logonserver.conf
3. Create your new characters and world...
.modify skill 'inputskillid' 'input levelwanted'
skillid must be its number id
so, would look like this
.modify skill 26 375<-------------26 is just a made up # on my part
you can also use the execute batch file feature
means you need a certain reputation with the given faction to be able to use it.
there isn't one.....you have to .learn each individually
you changed nothing, and they just quit working???
sounds like a hacker....check to make sure you still have status in your db
If you think its so easy to fix, why don't you do it?
moaning and complaining won't accomplish anything
I don't think pets work very well in ascent, just yet
port to gm island same as porting anywhere else.
type: .recall port *location*( in your case gmisland)
as to sign-up forms, there are lots posted here....spora is prob the simplest.
I'm on ascent rev 2379, i think.
NCDB rev 66 something, lol, don't remember.
Running wow 2.3
Hmm, no sense....I did this, tele'd to anvilmar, and works for me
also used these 2 codes to fix trainers and weps master, but the above works for me....don't believe this is a 100% fix, more like a...
this sql will update vendors so they work.....just execute it on your database
lol, I use trunk all the time, so that is not necessarily the issue.
I've found that 80% of the time it crashes like this, you've missed a sql update for database structure.
UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags =...
open the main.tpl file in tpl folder
find the table listing online players (around line 150)
delete the entire table(or, if you want to save, cut and paste somewhere else)
yes, but need to make sure it matches an actual index or it will error
create a new folder in your ascent one and name it scripts.
place all your scripts in this folder
when you start ascent.exe, it will automatically load them.
uhmm, there is no easy way to convert the scripts
game monkey(.gm) was replaced with lua, so all need to be re-written in lua(similar to C#)
they come with the core....look in script_bin
.gm is no longer supported, so they won't work
INSERT INTO playercreateinfo_items
(indexid, protoid, slotid, amount)
VALUES
(5, 16866, 0, 1);
the first is the player indexid (to get proper info, you must cross ref with playercreateinfo...
well, i use sqlyog or phpmyadmin for database editing/updating.
so open sqlyog, find your db and select it, then find execute batch file and click it, browse to the sql file to use, select it,...
if you have a router, you have to forward ports through it AND your firewall.
Really, its the only thing it could be.....also, only 4 ports required to run ascent....more ports you forward, more...
its not so much your configs...read the error
connecting toMySQL on localhost with(root, ******)
sql result: connection failed. Reason was access denied for user root@localhost(using password:NO)...
well, without knowing the item, makes it harder to help, but I'll give it a shot
item needs to be in items and playercreateinfo_items tables.
item needs to have no level limit and be usable by...
yes, battlegrounds require someone to battle
looks to me like its not even connecting to your sql host
when you installed your sql, you specified a user and pass, those must be the same as in your ascent config files
oh, ok, you didn't specify which one the dl was for, :P
well, based off what quickmasta just posted, there is your problem.
You say your db is called world in your config files, but name it ncdb in the tool.bat
set user= namtlade
set pass= CENSORED...
using w/e tool u use for sql queries, execute that query on your database....it will change the flags of vendors to match 2.3......for your info, 2.3 cores and 2.2 rest of stuff has MAJOR issues, you...
my community edition doesn't have a trial, I've been using for over a year now :S
MySQL GUI Tools, MySQL Monitor, MySQL Manager, MySQL Performance Tuning and Optimization
make sure its...
here is a sql i used....fixed most of my vendors
UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE...
i use the community edition of sqlyog, its free
so the name of your datatbase is ncdb???? and character database is characters????