PHP Code:
INSERT INTO shops ( shopid, npcid ) VALUES ( 73201, 2002001 ); -- Rudi Shop (Happyville)
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990000, 500, 1 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990001, 500, 2 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990002, 500, 3 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990003, 500, 4 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990004, 500, 5 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990005, 500, 6 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990006, 500, 7 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990007, 500, 8 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990008, 500, 9 );
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990009, 500, 10);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990010, 500, 11);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990011, 500, 12);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990012, 500, 13);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990013, 500, 14);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990014, 500, 15);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990015, 500, 16);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990016, 500, 17);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990017, 500, 18);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990018, 500, 19);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990019, 500, 20);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990020, 500, 21);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990021, 500, 22);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990022, 500, 23);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3990023, 500, 24);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991000, 500, 25);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991001, 500, 26);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991002, 500, 27);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991003, 500, 28);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991004, 500, 29);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991005, 500, 30);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991006, 500, 31);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991007, 500, 32);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991008, 500, 33);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991009, 500, 34);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991010, 500, 35);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991011, 500, 36);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991012, 500, 37);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991013, 500, 38);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991014, 500, 39);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991015, 500, 40);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991016, 500, 41);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991017, 500, 42);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991018, 500, 43);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991019, 500, 44);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991020, 500, 45);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991021, 500, 46);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991022, 500, 47);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991023, 500, 48);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991024, 500, 49);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991025, 500, 50);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991026, 500, 51);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991027, 500, 52);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991028, 500, 53);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991029, 500, 54);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991030, 500, 55);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991031, 500, 56);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991032, 500, 57);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991033, 500, 58);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991034, 500, 59);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991035, 500, 60);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991036, 500, 61);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991037, 500, 62);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991038, 500, 63);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991039, 500, 64);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991040, 500, 65);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991041, 500, 66);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991042, 500, 67);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991043, 500, 68);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991044, 500, 69);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991045, 500, 70);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991046, 500, 71);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991047, 500, 72);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991048, 500, 73);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991049, 500, 74);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991050, 500, 75);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3991051, 500, 76);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992000, 500, 77);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992001, 500, 78);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992002, 500, 79);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992003, 500, 80);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992004, 500, 81);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992005, 500, 82);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992006, 500, 83);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992007, 500, 84);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992008, 500, 85);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992009, 500, 86);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992010, 500, 87);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992011, 500, 88);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992012, 500, 89);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992013, 500, 90);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992014, 500, 91);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992015, 500, 92);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992016, 500, 93);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992017, 500, 94);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992018, 500, 95);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992019, 500, 96);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992020, 500, 97);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992021, 500, 98);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992022, 500, 99);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992023, 500, 100);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992024, 500, 101);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992025, 500, 102);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992026, 500, 103);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992027, 500, 104);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992028, 500, 105);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992029, 500, 106);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992030, 500, 107);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992031, 500, 108);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992032, 500, 109);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992033, 500, 110);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992034, 500, 111);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992035, 500, 112);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992036, 500, 113);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992037, 500, 114);
INSERT INTO shopitems ( shopid, itemid, price, position ) VALUES ( 57, 3992038, 500, 115);
I added all decoration I found, do I miss something? post it here