Julianx's Shopping Center!

[Mesmoras]

Is there a link you can give me to it? I'll +rep you asap if i can get my ascent up to date to the correct rev.

[Mesmoras]

Nvm i just saw your repack, +rep for that after i get it lol

[Myth.]

JulianX, are you going to help us solve this problem with creature proto values? Because this same problem is happening with a few other things i'm trieing to get. Or is our only option to upgrade to a newer repack?

[JulianX]

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;

[megalord20]

im using your v4 repack and how do i noe if its up to datye?

[megalord20]

im using your v4 repack and how do i noe if its up to datye?

[Halochecker]

Double-Posts ftl. btw, thanks JulianX, works for me. eh, yeh, +rep

[---free_kill---]

thanks julinax you god!!!! ++++rep dude!!!! finally a mall i was going to make but its a pin in the asz ajustiing the buy price and stuff thanks!!!!!!!

[---free_kill---]

lol ill rep when i can *need to spread the rep*
in the mean while ill 5 star you post =DD


EDIT: IM HAVING A PROBLEM ANY HELP:

Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-08-17 21:58:35
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593412,22917,32837,5),(593413,22917,32838,5),(593414,22917,31091,100),(593415,22917,31090,100),(593416,22917,31089,100),(593417,22917,32375,10),(593418,22917,32374,10),(593419,22917,32497,10),(593420,22917,32496,10),(593421,22917,32500,10),(593422,22917,32525,10),(593423,22917,32471,10),(593424,22917,32336,10),(593425,22917,32524,10),(593426,22917,32483,10),(593427,22917,32235,10),(593431,22917,32521,10)
Error occured at:2007-08-17 21:58:50
Line no.:1
Error Code: 1062 - Duplicate entry '593412' for key 1
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-08-17 21:58:55
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
Unable to issue `use` statement
Error occured at:2007-08-17 22:40:53
Line no.:0
Error Code: 1049 - Unknown database 'antrix'
Query:
INSERT INTO items VALUES (31978, 4, 0, -1, "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", "Merciless Gladiator's Endgame", 39505, 4, 0, 0, 0, 23, -1, -1, 136, 70, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 7, 27, 5, 19, 35, 27, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 18050, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, "", 0, 0, 0, 0, 0, 7, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1663, -1, 0)
Error occured at:2007-08-26 14:09:05
Line no.:271
Error Code: 1062 - Duplicate entry '31978' for key 1
Query:
INSERT INTO `creatureloot` VALUES (593432,23420,32362,10),(593433,23420,32345,10),(593434,23420,32354,10),(593435,23420,32352,10)
Error occured at:2007-08-26 14:09:31
Line no.:1
Error Code: 1062 - Duplicate entry '593432' for key 1
Query:
[creature 2]
 name=Undead Killer
 elite=0
 attack=1000 1000
 bounding_radius=0
 combat_reach=2
 damage=270 300
 equipmodel=0 8011 2 4 2 13 3 0 0 0
 faction=168
 flags1=0
 level=75
 loottemplate=0
 maxhealth=4000
 maxmana=4000
 model=1487
 npcflags=0
 speed=1
 type=0
 spell=0

Error occured at:2007-08-26 22:18:10
Line no.:20
Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[creature 2]
 name=Undead Killer
 elite=0
 attack=1000 1000
 bounding_radius=0
 ' at line 1
Query:
CREATE TABLE `accounts` (
 `acct` bigint(20) NOT NULL auto_increment,
 `login` varchar(255) NOT NULL default '',
 `password` varchar(28) NOT NULL default '',
 `gm` varchar(27) NOT NULL default '',
 `banned` int(30) NOT NULL default '0',
 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
 `lastip` varchar(15) NOT NULL default '',
 `email` varchar(50) NOT NULL default '',
 `flags` int(11) NOT NULL default '0',
 PRIMARY KEY  (`acct`,`login`),
 UNIQUE KEY `acct` (`acct`)
 ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1
Error occured at:2007-08-27 19:08:24
Line no.:26
Error Code: 1050 - Table 'accounts' already exists
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:44:26
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:45:26
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:45:35
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:46:18
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:49:00
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1
Query:
INSERT INTO creature_proto VALUES (50000, 100, 100, 1741, 1000000, 1000000, 100000, 1, 4, 100, 10000, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0, 0, 0)
Error occured at:2007-08-27 21:50:29
Line no.:132
Error Code: 1136 - Column count doesn't match value count at row 1

[---free_kill---]

o well nvm im going to use ur new repack =DD

[JulianX]

My repacks are always up to date ALWAYS! lol

[rfvtgbyhn]

Hey i'm using Chrispeees Ascent Repack. I was wondering that if i used this will it delete the original vendor on gm island?? and as an exemple the weapon 120+ vendor??

[rfvtgbyhn]

i was also wondering if you could change the ids of the vendors to something higher so it wouldent delete the old ones

[dinmammarules]

Is this command only working on private servers?

[---free_kill---]

when do i know when buyprice is finished lol i left my pc on for a day trying to insirt the buyprice.sql but still no progress?????? any help????

(and oh ya what happened with my rep power and rank wtf????)