Doofus Pet Shop And Food

[NMDanny]

This Is My First Release, Don't Flame Please
I Didn't Tested It Cause My Private Server Don't Work
==========================================
Credits: Me For Making This, MapleTip For The ID's
It Have: Pets(Price 9-15k and Dragons 25-50k) Foods(1000 Mesos) That
Add Closeness And Fullness
You Have To Make A Line At Table 'Shops' With Id 31337 and Npc Id that
you want(I did 1012004 its doofus)
SQL:

/*
MySQL Data Transfer
Source Host: localhost
Source Database: odinms
Target Host: localhost
Target Database: odinms
Date: 26/07/2008 18:19:56
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for shopitems
-- ----------------------------

-- ----------------------------
-- Records 
-- ----------------------------

INSERT INTO `shopitems` VALUES ('1952', '31337', '2120000', '30', '0');
INSERT INTO `shopitems` VALUES ('1953', '31337', '5240000', '1000', '1');
INSERT INTO `shopitems` VALUES ('1954', '31337', '5240001', '1000', '2');
INSERT INTO `shopitems` VALUES ('1955', '31337', '5240002', '1000', '3');
INSERT INTO `shopitems` VALUES ('1956', '31337', '5240003', '1000', '4');
INSERT INTO `shopitems` VALUES ('1957', '31337', '5240004', '1000', '5');
INSERT INTO `shopitems` VALUES ('1958', '31337', '5240005', '1000', '6');
INSERT INTO `shopitems` VALUES ('1959', '31337', '5240006', '1000', '7');
INSERT INTO `shopitems` VALUES ('1960', '31337', '5240007', '1000', '8');
INSERT INTO `shopitems` VALUES ('1961', '31337', '5240008', '1000', '9');
INSERT INTO `shopitems` VALUES ('1962', '31337', '5240009', '1000', '10');
INSERT INTO `shopitems` VALUES ('1963', '31337', '5240010', '1000', '11');
INSERT INTO `shopitems` VALUES ('1964', '31337', '5240011', '1000', '12');
INSERT INTO `shopitems` VALUES ('1965', '31337', '5240012', '1000', '13');
INSERT INTO `shopitems` VALUES ('1966', '31337', '5240013', '1000', '14');
INSERT INTO `shopitems` VALUES ('1967', '31337', '5240015', '1000', '15');
INSERT INTO `shopitems` VALUES ('1968', '31337', '5240017', '1000', '16');
INSERT INTO `shopitems` VALUES ('1969', '31337', '5240020', '1000', '17');
INSERT INTO `shopitems` VALUES ('1970', '31337', '5170000', '2000', '18');
INSERT INTO `shopitems` VALUES ('1971', '31337', '5180000', '5000', '19');
INSERT INTO `shopitems` VALUES ('1972', '31337', '5000029', '10000', '20');
INSERT INTO `shopitems` VALUES ('1973', '31337', '5000034', '10000', '21');
INSERT INTO `shopitems` VALUES ('1974', '31337', '5000033', '50000', '22');
INSERT INTO `shopitems` VALUES ('1975', '31337', '5000004', '9000', '23');
INSERT INTO `shopitems` VALUES ('1976', '31337', '5000007', '10000', '24');
INSERT INTO `shopitems` VALUES ('1977', '31337', '5000032', '25000', '25');
INSERT INTO `shopitems` VALUES ('1978', '31337', '5000000', '10000', '26');
INSERT INTO `shopitems` VALUES ('1979', '31337', '5000001', '10000', '27');
INSERT INTO `shopitems` VALUES ('1980', '31337', '5000015', '10000', '28');
INSERT INTO `shopitems` VALUES ('1981', '31337', '5000009', '10000', '29');
INSERT INTO `shopitems` VALUES ('1982', '31337', '5000010', '10000', '30');
INSERT INTO `shopitems` VALUES ('1983', '31337', '5000013', '10000', '31');
INSERT INTO `shopitems` VALUES ('1984', '31337', '5000025', '10000', '32');
INSERT INTO `shopitems` VALUES ('1985', '31337', '5000030', '25000', '33');
INSERT INTO `shopitems` VALUES ('1986', '31337', '5000006', '10000', '34');
INSERT INTO `shopitems` VALUES ('1987', '31337', '5000024', '12000', '35');
INSERT INTO `shopitems` VALUES ('1988', '31337', '5000036', '13000', '36');
INSERT INTO `shopitems` VALUES ('1989', '31337', '5000003', '11000', '37');
INSERT INTO `shopitems` VALUES ('1990', '31337', '5000020', '11000', '38');
INSERT INTO `shopitems` VALUES ('1991', '31337', '5000011', '8000', '39');
INSERT INTO `shopitems` VALUES ('1992', '31337', '5000044', '14000', '40');
INSERT INTO `shopitems` VALUES ('1993', '31337', '5000008', '10000', '41');
INSERT INTO `shopitems` VALUES ('1994', '31337', '5000002', '10000', '42');
INSERT INTO `shopitems` VALUES ('1995', '31337', '5000031', '25000', '43');
INSERT INTO `shopitems` VALUES ('1996', '31337', '5000017', '10000', '44');
INSERT INTO `shopitems` VALUES ('1997', '31337', '5000014', '10000', '44');
INSERT INTO `shopitems` VALUES ('1998', '31337', '5000045', '10000', '45');
INSERT INTO `shopitems` VALUES ('1999', '31337', '5000041', '9000', '46');
INSERT INTO `shopitems` VALUES ('2000', '31337', '5000022', '10000', '47');
INSERT INTO `shopitems` VALUES ('2001', '31337', '5000005', '10000', '48');
INSERT INTO `shopitems` VALUES ('2002', '31337', '5000012', '10000', '40');

It Add Only To ShopItems, that mean you have to make the Shop at 'Shops'
DOWNLOAD: (Mediafire)

To view the content, you need to sign in or register

****Don't Download Cause It Drop/Replace All The Items From All Shop, I Removed The Remove From The Post Not From the
DL
On Next Version I May Add Pet Command Books And Visual Equips

 

[Davidkun]

Re: [Release] Doofus Pet Shop And Food

There have been a few releases of this already. Thanks though. :]

 

[jimme12]

Re: [Release] Doofus Pet Shop And Food

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for shopitems
-- ----------------------------
DROP TABLE IF EXISTS `shopitems`;
CREATE TABLE `shopitems` (
  `shopitemid` int(10) unsigned NOT NULL auto_increment,
  `shopid` int(10) unsigned NOT NULL default '0',
  `itemid` int(11) NOT NULL default '0',
  `price` int(11) NOT NULL default '0',
  `position` int(11) NOT NULL default '0',
  PRIMARY KEY  (`shopitemid`),
  KEY `shopid` (`shopid`)
) ENGINE=InnoDB AUTO_INCREMENT=2003 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------

INSERT INTO `shopitems` VALUES ('1952', '31337', '2120000', '30', '0');
INSERT INTO `shopitems` VALUES ('1953', '31337', '5240000', '1000', '1');
INSERT INTO `shopitems` VALUES ('1954', '31337', '5240001', '1000', '2');
INSERT INTO `shopitems` VALUES ('1955', '31337', '5240002', '1000', '3');
INSERT INTO `shopitems` VALUES ('1956', '31337', '5240003', '1000', '4');
INSERT INTO `shopitems` VALUES ('1957', '31337', '5240004', '1000', '5');
INSERT INTO `shopitems` VALUES ('1958', '31337', '5240005', '1000', '6');
INSERT INTO `shopitems` VALUES ('1959', '31337', '5240006', '1000', '7');
INSERT INTO `shopitems` VALUES ('1960', '31337', '5240007', '1000', '8');
INSERT INTO `shopitems` VALUES ('1961', '31337', '5240008', '1000', '9');
INSERT INTO `shopitems` VALUES ('1962', '31337', '5240009', '1000', '10');
INSERT INTO `shopitems` VALUES ('1963', '31337', '5240010', '1000', '11');
INSERT INTO `shopitems` VALUES ('1964', '31337', '5240011', '1000', '12');
INSERT INTO `shopitems` VALUES ('1965', '31337', '5240012', '1000', '13');
INSERT INTO `shopitems` VALUES ('1966', '31337', '5240013', '1000', '14');
INSERT INTO `shopitems` VALUES ('1967', '31337', '5240015', '1000', '15');
INSERT INTO `shopitems` VALUES ('1968', '31337', '5240017', '1000', '16');
INSERT INTO `shopitems` VALUES ('1969', '31337', '5240020', '1000', '17');
INSERT INTO `shopitems` VALUES ('1970', '31337', '5170000', '2000', '18');
INSERT INTO `shopitems` VALUES ('1971', '31337', '5180000', '5000', '19');
INSERT INTO `shopitems` VALUES ('1972', '31337', '5000029', '10000', '20');
INSERT INTO `shopitems` VALUES ('1973', '31337', '5000034', '10000', '21');
INSERT INTO `shopitems` VALUES ('1974', '31337', '5000033', '50000', '22');
INSERT INTO `shopitems` VALUES ('1975', '31337', '5000004', '9000', '23');
INSERT INTO `shopitems` VALUES ('1976', '31337', '5000007', '10000', '24');
INSERT INTO `shopitems` VALUES ('1977', '31337', '5000032', '25000', '25');
INSERT INTO `shopitems` VALUES ('1978', '31337', '5000000', '10000', '26');
INSERT INTO `shopitems` VALUES ('1979', '31337', '5000001', '10000', '27');
INSERT INTO `shopitems` VALUES ('1980', '31337', '5000015', '10000', '28');
INSERT INTO `shopitems` VALUES ('1981', '31337', '5000009', '10000', '29');
INSERT INTO `shopitems` VALUES ('1982', '31337', '5000010', '10000', '30');
INSERT INTO `shopitems` VALUES ('1983', '31337', '5000013', '10000', '31');
INSERT INTO `shopitems` VALUES ('1984', '31337', '5000025', '10000', '32');
INSERT INTO `shopitems` VALUES ('1985', '31337', '5000030', '25000', '33');
INSERT INTO `shopitems` VALUES ('1986', '31337', '5000006', '10000', '34');
INSERT INTO `shopitems` VALUES ('1987', '31337', '5000024', '12000', '35');
INSERT INTO `shopitems` VALUES ('1988', '31337', '5000036', '13000', '36');
INSERT INTO `shopitems` VALUES ('1989', '31337', '5000003', '11000', '37');
INSERT INTO `shopitems` VALUES ('1990', '31337', '5000020', '11000', '38');
INSERT INTO `shopitems` VALUES ('1991', '31337', '5000011', '8000', '39');
INSERT INTO `shopitems` VALUES ('1992', '31337', '5000044', '14000', '40');
INSERT INTO `shopitems` VALUES ('1993', '31337', '5000008', '10000', '41');
INSERT INTO `shopitems` VALUES ('1994', '31337', '5000002', '10000', '42');
INSERT INTO `shopitems` VALUES ('1995', '31337', '5000031', '25000', '43');
INSERT INTO `shopitems` VALUES ('1996', '31337', '5000017', '10000', '44');
INSERT INTO `shopitems` VALUES ('1997', '31337', '5000014', '10000', '44');
INSERT INTO `shopitems` VALUES ('1998', '31337', '5000045', '10000', '45');
INSERT INTO `shopitems` VALUES ('1999', '31337', '5000041', '9000', '46');
INSERT INTO `shopitems` VALUES ('2000', '31337', '5000022', '10000', '47');
INSERT INTO `shopitems` VALUES ('2001', '31337', '5000005', '10000', '48');
INSERT INTO `shopitems` VALUES ('2002', '31337', '5000012', '10000', '40');

LOLOL, just to check.... i think this drops the shopitems table :O lose all data? Hah.... i think youd better check on that ( don't quote on me) just wondering...

 

[NMDanny]

Re: [Release] Doofus Pet Shop And Food

oh ok now it just do insert into but i didn't edited the dl

 

[NMDanny]

Re: [Release] Doofus Pet Shop And Food

what this error releated to?
This NX Is For Real CashShop, What I Did Is For Basic Shop NPC

 

[rookief]

Re: [Release] Doofus Pet Shop And Food

dam you.all the shops item are gone, thanks man, i love your scripting

 

[mariokiller64]

Re: [Release] Doofus Pet Shop And Food

dam you.all the shops item are gone, thanks man, i love your scripting

serious leecher right there lol.

1. You should have read the script.
2. You should take backups of your databases.
3. Actually look at the things you leech.

 

[Regurgitate]

Re: [Release] Doofus Pet Shop And Food

lol. Rofling at the leecher.

 

[mbaa24]

Re: [Release] Doofus Pet Shop And Food

lol. Rofling at the leecher.

haha.
People should start doing this to the SQLs they release huh?

 

[Namrfigk]

Re: [Release] Doofus Pet Shop And Food

files have been uploaded to

To view the content, you need to sign in or register

with instructions and everything :eek6:

website also includes all patches(updated daily) & top animes for anime fans

to view add hamachi network(same user & pass): 10gigforrent1