Copy all of this into a file called tributes.sql and source it into your database:
Quote:
CREATE TABLE tributes (
id INT UNSIGNED AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
descr MEDIUMTEXT NOT NULL,
PRIMARY KEY(id)
);
INSERT INTO tributes (id,name,descr) VALUES(1, 'Aura of Clarity', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(2, 'Vengeful Aura', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(3, 'Power of Will', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(4, 'Bulwark of Honor', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(5, 'Arm of Strength', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(6, 'Body of the Brute', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(7, 'Rabbit\'s Song', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(8, 'Juggler\'s Hands', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(9, 'Sage\'s Advice', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(10, 'Sage\'s Knowledge', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(11, 'Glowing Beauty', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(12, 'Strength of Body', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(13, 'Strength of Mind', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(14, 'Replenishing Body', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(15, 'Harmony of Drums', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(16, 'Harmony of Wind', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(17, 'Harmony of String', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(18, 'Harmony of Horns', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(19, 'Chorus', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(20, 'Concerto', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(21, 'Strength of Will', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(22, 'Visions of Suffering', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(23, 'Twinge of Pain', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(24, 'Expeditious Aid', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(25, 'Persistent Boon', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(26, 'Power of Sight', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(27, 'Power of Recovery', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(28, 'Power of Conservation', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(29, 'Power of Alacrity', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(30, 'Visions of Command', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(31, 'Commanding Presence', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(32, 'Swift Arms', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(33, 'Power of Suffering', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(34, 'Gills of the Bass', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(35, 'Candlelight Vigil', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(36, 'Sight of the Falcon', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(37, 'Gift of the Enchanter', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(38, 'Ethereal Protection', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(39, 'Blazing Shield', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(40, 'Insulation', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(41, 'Antibody', 'No Text Collected!');
INSERT INTO tributes (id,name,descr) VALUES(42, 'Antidote', 'No Text Collected!');
#Stupid mysql wont let you insert the value 0 into a INT UNSIGNED AUTO_INCREMENT field
UPDATE tributes SET id=id-1;
|
Copy this into tribute_levels.sql and source it in:
Quote:
CREATE TABLE tribute_levels (
tribute_id INT UNSIGNED NOT NULL,
level INT UNSIGNED NOT NULL,
cost INT UNSIGNED NOT NULL,
item_id INT UNSIGNED NOT NULL,
PRIMARY KEY(tribute_id,level)
);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,20,5,56300);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,30,5,56301);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,40,12,56302);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,50,20,56303);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(1,60,29,56304);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,45,5,56305);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,50,13,56306);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,55,20,56307);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,60,27,5630 ;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(2,65,33,56309);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,20,4,56310);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,40,5,56311);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,50,12,56312);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(3,60,20,56313);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,10,6,56484);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,20,1,56314);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,30,3,56315);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,40,7,56316);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,50,13,56317);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(4,60,27,5631;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,10,6,56319);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,20,1,56320);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,30,3,56321);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,40,7,56322);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,50,11,56323);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(5,60,15,56477);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,10,6,56324);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,20,1,56325);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,30,3,56326);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,40,7,56327);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,50,11,5632;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(6,60,15,5647;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,10,6,56329);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,20,1,56330);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,30,3,56331);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,40,7,56332);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,50,11,56333);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(7,60,15,56479);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,10,6,56334);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,20,1,56335);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,30,3,56336);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,40,7,56337);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,50,11,5633;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(8,60,15,56480);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,10,6,56339);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,20,1,56340);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,30,3,56341);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,40,7,56342);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,50,11,56343);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(9,60,15,56481);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,10,6,56344);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,20,1,56345);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,30,3,56346);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,40,7,56347);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,50,11,5634;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(10,60,15,56482);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,10,6,56349);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,20,1,56350);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,30,3,56351);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,40,7,56352);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,50,11,56353);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(11,60,15,56483);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,10,6,56476);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,20,1,56354);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,30,3,56355);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,40,7,56356);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,50,11,56357);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(12,60,15,5635;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,10,6,56475);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,20,1,56359);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,30,3,56360);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,40,7,56361);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,50,11,56362);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(13,60,15,56363);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,20,5,56369);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,30,5,56370);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,40,12,56371);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,50,20,56372);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(14,60,29,56373);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,30,3,56374);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,45,10,56375);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(15,60,13,56376);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,30,3,56377);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,45,10,5637;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(16,60,13,56379);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,30,3,56380);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,45,10,56381);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(17,60,13,56382);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,30,3,56383);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,45,10,56384);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(18,60,13,56385);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,30,3,56386);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,45,10,56387);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(19,60,13,5638;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,55,3,56389);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,60,30,56390);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(20,65,39,56391);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,10,6,56485);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,20,1,56392);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,30,3,56393);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,40,7,56394);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,50,11,56395);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(21,60,15,56396);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,20,4,56397);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,40,5,5639;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,50,12,56399);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(22,60,20,56400);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,20,4,56401);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,40,5,56402);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,50,12,56403);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(23,60,20,56404);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,20,4,56405);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,40,5,56406);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,50,12,56407);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(24,60,20,5640;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,20,4,56409);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,40,5,56410);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,50,12,56411);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(25,60,20,56412);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,20,4,56413);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,40,5,56414);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,50,12,56415);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(26,60,20,56416);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,20,4,56417);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,40,5,5641;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,50,12,56419);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(27,60,20,56420);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,20,4,56421);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,40,5,56422);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,50,12,56423);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(28,60,20,56424);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,20,4,56425);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,40,5,56426);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,50,12,56427);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(29,60,20,5642;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,20,4,56429);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,40,5,56430);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,50,12,56431);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(30,60,20,56432);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,20,4,56433);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,40,5,56434);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,50,12,56435);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(31,60,20,56436);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,20,5,56437);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,30,5,5643;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,40,12,56439);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,50,20,56440);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(32,60,29,56441);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,20,4,56442);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,30,5,56443);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,40,12,56444);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(33,50,20,56445);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(34,20,1,56446);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(35,20,1,56447);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(36,20,1,5644;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(37,50,1,56449);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,20,5,56450);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,30,7,56451);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,40,10,56452);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,50,14,56453);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(38,60,18,56454);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,20,5,56455);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,30,7,56456);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,40,10,56457);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,50,14,5645;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(39,60,18,56459);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,20,5,56460);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,30,7,56461);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,40,10,56462);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,50,14,56463);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(40,60,18,56464);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,20,5,56465);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,30,7,56466);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,40,10,56467);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,50,14,5646;
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(41,60,18,56469);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,20,5,56470);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,30,7,56471);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,40,10,56472);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,50,14,56473);
INSERT INTO tribute_levels (tribute_id,level,cost,item_id) VALUES(42,60,18,56474);
#Stupid mysql wont let you insert the value 0 into a INT UNSIGNED AUTO_INCREMENT field
UPDATE tribute_levels SET tribute_id=tribute_id-1;
|
And then copy this into a file called commands.pl and save it in the main emulator directory:
Hope that helps!
-Sarepean
|