[QUESTION] Help me problem

Results 1 to 12 of 12
  1. 17-09-07 #1
    ShakatoNNN
    Sorcerer Supreme ShakatoNNN is offline
    Member +Rank
    Apr 2006 Join Date
    ArgentinaLocation
    295Posts

    [QUESTION] Help me problem

    1.jpg
    2.jpg
    3.jpg
    somebody has idea?
    Reply With Quote Reply With Quote
  2. Check out our sponsor
    [QUESTION] Help me problem
  3. 17-09-07 #2
    Paco44
    You don't know me. Paco44 is offline
    Grand MasterRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: [QUESTION] Help me problem

    For that creature_proto error, execute this:

    Code:
    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;
    Reply With Quote Reply With Quote
  4. 17-09-07 #3
    ShakatoNNN
    Sorcerer Supreme ShakatoNNN is offline
    Member +Rank
    Apr 2006 Join Date
    ArgentinaLocation
    295Posts

    Re: [QUESTION] Help me problem

    thanks nice query xd
    Reply With Quote Reply With Quote
  5. 17-09-07 #4
    Paco44
    You don't know me. Paco44 is offline
    Grand MasterRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: [QUESTION] Help me problem

    You're welcome.
    Reply With Quote Reply With Quote
  6. 17-09-07 #5
    DeBOuN
    Member DeBOuN is offline
    MemberRank
    Jul 2004 Join Date
    Barcelona (Spain)Location
    30Posts

    Re: [QUESTION] Help me problem

    This is one of my errors xD How I execute this in navicat?

    EDIT: Ok I found it, but have the problem of the loot tables.
    Reply With Quote Reply With Quote
  7. 17-09-07 #6
    gmaze
    Elite Member gmaze is offline
    Member +Rank
    May 2007 Join Date
    IndianaLocation
    238Posts

    Re: [QUESTION] Help me problem

    try this one:

    Code:
    ALTER TABLE creatureloot DROP heroicchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;

ALTER TABLE fishingloot DROP heroicchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;

ALTER TABLE itemloot DROP heroicchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;

ALTER TABLE objectloot DROP heroicchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;

ALTER TABLE pickpocketingloot DROP heroicchance;
ALTER TABLE pickpocketingloot DROP mincount;
ALTER TABLE pickpocketingloot DROP maxcount;

ALTER TABLE prospectingloot DROP heroicchance;
ALTER TABLE prospectingloot DROP mincount;
ALTER TABLE prospectingloot DROP maxcount;

ALTER TABLE skinningloot DROP heroicchance;
ALTER TABLE skinningloot DROP mincount;
ALTER TABLE skinningloot DROP maxcount;

ALTER TABLE creatureloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE creatureloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE creatureloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE creatureloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE fishingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE fishingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE fishingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE fishingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE itemloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE itemloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE itemloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE itemloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE objectloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE objectloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE objectloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE objectloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE pickpocketingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE pickpocketingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE pickpocketingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE pickpocketingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE prospectingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE prospectingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE prospectingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE prospectingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE skinningloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE skinningloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE skinningloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE skinningloot ADD column maxcount int(30) NOT NULL default 1;
    Reply With Quote Reply With Quote
  8. 17-09-07 #7
    Paco44
    You don't know me. Paco44 is offline
    Grand MasterRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: [QUESTION] Help me problem

    Nice, thank you gmaze.
    Reply With Quote Reply With Quote
  9. 18-09-07 #8
    ShakatoNNN
    Sorcerer Supreme ShakatoNNN is offline
    Member +Rank
    Apr 2006 Join Date
    ArgentinaLocation
    295Posts

    Re: [QUESTION] Help me problem

    Quote Originally Posted by Paco44 View Post
    You're welcome.
    AHAHAHAHA, you also :)

    Quote Originally Posted by gmaze View Post
    try this one:

    Code:
    ALTER TABLE creatureloot DROP heroicchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;

ALTER TABLE fishingloot DROP heroicchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;

ALTER TABLE itemloot DROP heroicchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;

ALTER TABLE objectloot DROP heroicchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;

ALTER TABLE pickpocketingloot DROP heroicchance;
ALTER TABLE pickpocketingloot DROP mincount;
ALTER TABLE pickpocketingloot DROP maxcount;

ALTER TABLE prospectingloot DROP heroicchance;
ALTER TABLE prospectingloot DROP mincount;
ALTER TABLE prospectingloot DROP maxcount;

ALTER TABLE skinningloot DROP heroicchance;
ALTER TABLE skinningloot DROP mincount;
ALTER TABLE skinningloot DROP maxcount;

ALTER TABLE creatureloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE creatureloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE creatureloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE creatureloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE fishingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE fishingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE fishingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE fishingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE itemloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE itemloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE itemloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE itemloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE objectloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE objectloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE objectloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE objectloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE pickpocketingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE pickpocketingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE pickpocketingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE pickpocketingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE prospectingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE prospectingloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE prospectingloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE prospectingloot ADD column maxcount int(30) NOT NULL default 1;

ALTER TABLE skinningloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE skinningloot ADD column heroicchance float(0) NOT NULL default 0 AFTER percentchance;
ALTER TABLE skinningloot ADD column mincount int(30) NOT NULL default 1;
ALTER TABLE skinningloot ADD column maxcount int(30) NOT NULL default 1;
    it is for fixing creature_proto error only?
    Reply With Quote Reply With Quote
  10. 18-09-07 #9
    Kiteal
    Elite Member Kiteal is offline
    Member +Rank
    Sep 2007 Join Date
    Uh...Places.Location
    112Posts

    Re: [QUESTION] Help me problem

    Quote Originally Posted by ShakatoNNN View Post
    AHAHAHAHA, you also :)



    it is for fixing creature_proto error only?
    Are you using Blazingwow DB or w/e it is? Because I had these same errors with it >_>. And it kept messing up so I just changed the DB to where I am using NCDB.

    -Kiteal
    Reply With Quote Reply With Quote
  11. 18-09-07 #10
    Paco44
    You don't know me. Paco44 is offline
    Grand MasterRank
    Apr 2006 Join Date
    IllinoisLocation
    1,777Posts

    Re: [QUESTION] Help me problem

    NCDB is by-far the best.
    Reply With Quote Reply With Quote
  12. 18-09-07 #11
    Kiteal
    Elite Member Kiteal is offline
    Member +Rank
    Sep 2007 Join Date
    Uh...Places.Location
    112Posts

    Re: [QUESTION] Help me problem

    Quote Originally Posted by Paco44 View Post
    NCDB is by-far the best.
    Agreed, I do not have many problems with it, and when I do theres usually others who use it that can help me :p. I tried some of the others and could never get them to turn out right.

    -Kiteal
    Reply With Quote Reply With Quote
  13. 19-09-07 #12
    ShakatoNNN
    Sorcerer Supreme ShakatoNNN is offline
    Member +Rank
    Apr 2006 Join Date
    ArgentinaLocation
    295Posts

    Re: [QUESTION] Help me problem

    use TNPS Rev 8, it will try with NCDB Milestone 0.1 :P
    Reply With Quote Reply With Quote


« Previous Thread | Next Thread »

Advertisement