Julianx's Shopping Center!

[Mesmoras]

I'd say it's worth the wait. And Rej, I'd say your problem is that it didn't go into your creature_name/proto right.

News!!! For everybody that has been getting the failure error in your ascent.exe, I have the solution! It's the Remote Passwords. You did not set them the same on the logonserver.conf and ascent.conf

[REJ]

I'd say it's worth the wait. And Rej, I'd say your problem is that it didn't go into your creature_name/proto right.

News!!! For everybody that has been getting the failure error in your ascent.exe, I have the solution! It's the Remote Passwords. You did not set them the same on the logonserver.conf and ascent.conf

how do i fix it. please help me

[Mesmoras]

It's not something I can walk you through w/o being at your computer. Check the creature_name entry ID's and make sure those match the creature_proto ID's.

[REJ]

what range is the entry of the vendors in creature_proto? cause the last entry vendors i got are 23536, 23535, 23534, etc.... and in creature_names its 50078, 50077, 50076 from last to first. so in creature proto whats supposed to be their entry?

[REJ]

-Vendors-
50000 Armor Dungeon I
50001 Armor Dungeon II
50002 Armor Dungeon III
50003 Armor Raid Tier I
50004 Armor Raid Tier II
50005 Armor Raid Tier III
50006 Armor Raid Tier IV
50007 Armor Raid Tier V
50008 Armor Raid Tier VI
50009 Armor Wrist
50010 Armor Waist
50011 Armor Feet
50012 Armor Shield
50015 Weapon Level 50+
50016 Weapon Level 60+
50017 Weapon Level 65+
50018 Weapon Level 75+
50019 Weapon Level 100+
50020 Armor Necklace
50021 Armor Rings
50022 Armor Trinket
50023 Armor Cloak
50024 Armor Shirt
50025 Armor Tabard
50026 Armor Miscellaneous
50028 Armor Off-Hands
50029 Armor Libram/Idol/Totem
50030 Arena Season I
50031 Arena Season I
50032 Arena Season I
50033 Arena Season II
50034 Arena Season II
50035 Arena Season II
50040 Misc Gemstone I
50041 Misc Gemstone II
50042 Misc Mount I
50043 Misc Mount II
50044 Misc Projectile
50045 Misc Container
50047 Misc Enchantment
50048 Misc Key
50049 Misc Currency
50050 Recipe Book A-Z
50051 Recipe Leather A-F
50052 Recipe Leather G-R
50053 Recipe Leather S-Z
50054 Recipe Tailor A-G
50055 Recipe Tailor H-Z
50056 Recipe Engineer A-Z
50057 Recipe Blacksmith A-F
50058 Recipe Blacksmith G-R
50059 Recipe Blacksmith S-Z
50060 Recipe Cooking A-Z
50061 Recipe Alchemy A-Z
50062 Recipe Enchant A-G
50063 Recipe Enchant H-Z
50064 Recipe Jeweler A-K
50065 Recipe Jeweler L-Z
50066 Reagent Leather I
50067 Reagent Leather II
50068 Reagent Tailor I
50069 Reagent Tailor II
50070 Reagent Engineer I
50071 Reagent Engineer II
50072 Reagent Blacksmith I
50073 Reagent Blacksmith II
50074 Reagent Cooking
50075 Reagent Alchemy
50076 Reagent Enchant
50077 Reagent Jeweler
50078 Reagent Miscellaneous
-----------------------------

The "arena" does not seem to want to toggle the "PvP" when you enter, it like it does Gurubashi Arena, but you can still use it for that.

It looks like this with Vendors and etc. [/quote]

can you please remodify the batch file so that the creature protos match the creature name >.<

i got it to work, but i dont know in the sql which proto is which creature.
p.s. i looked at the file and in the creature proto has an extra two. the creature names go from 50k to 50078 and the creature proto goes from 50k to 50080 ???

[JulianX]

they do match lol, hey are all the same all the creature_proto is the same.

[REJ]

Upgarding will make you have less bugs since a newer DB.
Or you can just use these queries to update.

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;
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;
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;

WTF!! I used the update and it messed up my whole game. every npc is 1000000 times bigger. i lag sooo much. how do i fix this

[Mesmoras]

Try updating them one update at a time...

[REJ]

didnt work .....
im just gonna have to remake my sql database again...

[imwiee]

guy's i have the addon if wannit heres the link.....
http://logon.defrag-zero.be/addons.rar
maybe the link will work but thats the server goes on the same broband have dun xD

[Mesmoras]

Imwiee my eyes are bleeding. Please work on your spelling. Anyways, what exactly is the addon?

[REJ]

guy's i have the addon if wannit heres the link.....
http://logon.defrag-zero.be/addons.rar
maybe the link will work but thats the server goes on the same broband have dun xD

addon for what? whats it do

[REJ]

w00t!! i am soooo happy. i got the game to work and validate and the mall works as well. thanx julian. you get like 1k +rep

[Avatori]

Hmm, cant get it to work.

[nether drake]

im using antrix with SQL will it work ? i found some naruu vendors in my repack , im using WoW Forms and other Crap | its like yours 100% but antrix , it says

There was an error while executing a query.
The query and the error message has been logged at:
C:\Program Files\SQLyog Community\sqlyog.err.
Please click on "Open Error File..." to open the error file.

what to do ? PST