[ANY] NotD Store - Page 11

darkscissors00 · 02-09-2013 , 14:46 Re: [ANY] NotD Store

i get this in chat when mi type !shop

You cannot use !shop at this time

InB · 02-09-2013 , 18:30 Re: [ANY] NotD Store

Quote:

Originally Posted by darkscissors00

whats the database code?

Code:

-- MySQL dump 10.13  Distrib 5.1.41, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: store
-- ------------------------------------------------------
-- Server version    5.1.41-3ubuntu12.10

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `colors`
--

DROP TABLE IF EXISTS `colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `colors` (
  `index` tinyint(4) NOT NULL AUTO_INCREMENT,
  `color` varchar(10) NOT NULL,
  `red` smallint(6) NOT NULL DEFAULT '0',
  `blue` smallint(6) NOT NULL DEFAULT '0',
  `green` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `colors`
--

LOCK TABLES `colors` WRITE;
/*!40000 ALTER TABLE `colors` DISABLE KEYS */;
INSERT INTO `colors` VALUES (0,'Default',255,255,255),(1,'Red',255,0,0),(2,'Green',0,255,0),(3,'Blue',0,0,255),(4,'Yellow',255,255,0),(5,'Purple',255,0,255),(6,'Cyan',0,255,255),(7,'Orange',255,128,0),(8,'Pink',255,0,128),(9,'Olive',128,255,0),(10,'Lime',0,255,128),(11,'Violet',128,0,255),(12,'Lightblue',0,128,255),(13,'Gold',255,215,0),(15,'Tomato',255,99,71),(16,'DarkOrange',255,140,0),(17,'Brown',139,69,19),(14,'DeepPink',255,20,147);
/*!40000 ALTER TABLE `colors` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `items` (
  `steamid` varchar(25) CHARACTER SET utf8 NOT NULL,
  `item` varchar(25) CHARACTER SET utf8 NOT NULL,
  `number` tinyint(4) NOT NULL DEFAULT '0',
  KEY `steamid` (`steamid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `items`
--

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `settings` (
  `steamid` varchar(25) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `credits` int(11) NOT NULL DEFAULT '0',
  `badge` tinyint(4) NOT NULL DEFAULT '0',
  `tracer` tinyint(4) NOT NULL DEFAULT '0',
  `tracertype` tinyint(4) NOT NULL DEFAULT '0',
  `glow` tinyint(4) NOT NULL DEFAULT '0',
  `weapon` tinyint(4) NOT NULL DEFAULT '0',
  `width` tinyint(4) NOT NULL DEFAULT '10',
  `render` tinyint(4) NOT NULL DEFAULT '4',
  `online` tinyint(4) NOT NULL DEFAULT '0',
  `queue` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `tracers`
--

DROP TABLE IF EXISTS `tracers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tracers` (
  `index` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) CHARACTER SET utf8 NOT NULL,
  `texture` varchar(20) CHARACTER SET utf8 NOT NULL,
  `vip` tinyint(1) NOT NULL DEFAULT '0',
  `event` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`index`),
  KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tracers`
--

LOCK TABLES `tracers` WRITE;
/*!40000 ALTER TABLE `tracers` DISABLE KEYS */;
INSERT INTO `tracers` VALUES (0,'Default','Default',0,0),(1,'Hydragut Beam (Not all colors)','hydragutbeam',0,0),(2,'Phys Beam','physbeam',0,0),(3,'Rainbow','trails/rainbow',1,0),(4,'Fire','trails/fire1',1,0),(5,'Ice','trails/ice1',1,0),(6,'Leaves','trails/leaves1',1,0),(7,'leaves2','trails/leaves21',1,0),(8,'metallic','trails/metallic1',1,0),(9,'Awesome','trails/awesome',1,0),(10,'Wheel','trails/wheel',0,0),(11,'Earth','trails/earth',1,0),(12,'Peace','trails/peace',0,0),(13,'Strider Ball','strider_blackball',0,0),(14,'Crystal Beam','crystal_beam1',0,0),(15,'Mushroom','trails/mushroom',1,0),(16,'Star','trails/star',1,0),(17,'Cracked Beam','trails/crackedbeam',1,0),(18,'Pumpkin','trails/pumpkin',0,1),(19,'Ying Yang','trails/yingyang',0,0),(20,'Snowman','trails/snowman',0,0),(21,'Christmas Light','trails/chrislight',0,0),(22,'DNA','trails/dna2',0,0),(23,'Crown','trails/crown',0,0),(24,'Skull N Bones','trails/skullnbones',0,0),(25,'Biohazard','trails/biohazard',0,0),(26,'Pot Leaf','trails/potleaf',0,0),(27,'Bank Note','trails/banknote',0,0),(28,'Money Bag','trails/moneybag',0,0),(29,'Poker','trails/poker',0,0),(30,'Medic','trails/medic',0,0),(31,'Taco','trails/taco',0,0),(32,'Hello Kitty','trails/hellokitty',0,0),(33,'US Flag','trails/usflag',0,0),(34,'Warrior','trails/warrior',0,0),(35,'Hypnotic','trails/hypnotic',0,0),(36,'Double Rainbow','trails/doublerainbow',1,0),(37,'Seperated Rainbow','trails/seprainbow',1,0),(38,'Paint Splatter','trails/paintsplatter',1,0),(39,'Psychedelic Ball','trails/psychball',1,0),(40,'Psychedelic Triangle','trails/psychtriangle',1,0),(41,'Swirly','trails/swirly',1,0),(42,'Trippy','trails/trippy',1,0),(43,'Pretzel','trails/pretzel',1,0),(44,'Heart','trails/heart',1,0),(45,'Mushroom 2','trails/mushroom2',1,0),(46,'Mario','trails/mario',1,0),(47,'Bombomb','trails/bombomb',1,0),(48,'Boo','trails/boo',1,0),(49,'Apple','trails/apple',0,0),(50,'Arrow Rainbow','trails/arrowrainbow',1,0),(51,'Beer Mug','trails/beermug',0,0),(52,'Blade','trails/blade',0,0),(53,'Blue Lightning','trails/bluelightning',1,0),(54,'Bullet Bill','trails/bulletbill',1,0),(55,'Canada Flag','trails/canadaflag',0,0),(56,'Candies','trails/candies',0,0),(57,'Coca Cola','trails/cocacola',0,0),(58,'Color Bolt','trails/colorbolt',0,0),(59,'Cookies','trails/cookies',0,0),(60,'Donuts','trails/donuts',0,0),(61,'Energy','trails/energy',1,0),(62,'Energy Ball','trails/energyball',1,0),(63,'Footprint','trails/footprint',0,0),(64,'German Flag','trails/germanflag',0,0),(65,'Goomba','trails/goomba',1,0),(66,'Grenade','trails/grenade',0,0),(67,'Gummy Bears','trails/gummybears',0,0),(68,'Handgun','trails/handgun',0,0),(69,'Lightspeed','trails/lightspeed',1,0),(70,'LOL','trails/lol',1,0),(71,'PacMan','trails/pacman',1,0),(72,'Pawprint','trails/pawprint',0,0),(73,'Skull','trails/skull',0,0),(74,'UK Flag','trails/ukflag',0,0),(75,'Words','trails/words',0,0);
/*!40000 ALTER TABLE `tracers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vip`
--

DROP TABLE IF EXISTS `vip`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vip` (
  `steamid` varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `weapons`
--

DROP TABLE IF EXISTS `weapons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `weapons` (
  `index` tinyint(4) NOT NULL AUTO_INCREMENT,
  `weapon` varchar(20) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `weapons`
--

LOCK TABLES `weapons` WRITE;
/*!40000 ALTER TABLE `weapons` DISABLE KEYS */;
INSERT INTO `weapons` VALUES (1,'Paintball'),(2,'Default');
/*!40000 ALTER TABLE `weapons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'store'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2011-09-05 20:15:23

Quote:

Originally Posted by darkscissors00

i get this in chat when mi type !shop

You cannot use !shop at this time

You aren't connected to the Database.

If you find this store Buggy/Glitchy/Not Working try this store that was just released, here.

Clyde · 05-27-2013 , 12:05 Re: [ANY] NotD Store

I have taken over this mod and am providing full support for the plugin. https://forums.alliedmods.net/showthread.php?t=216895 It is now called Public Store.