goolive Forum » Fachforum » Hardware & Software
Alle entfernten Beiträge einblenden
5 Beiträge • unten

Suche Leute die sich mit MySQL-Scripts Aus kenne!

kaugummi
Direkt-Link

Am 23.11.2010 um 17:18:

Hi. Leute & Forum Besucher,

Also mein Anliegen ist dies, ich suche ein Pa Programmierer. Die mir Vielleicht weiter helfen könnten

mit eine PHP, und MYSQL-Scrpit. Das Problem ist die Trotz aller Einstellungen, sag mein Server-System Index Error 512.. etc. Nun..ja.. ich kann mal den Script hier öffentlich darstellen.. vielleicht findet jemanden den Fehler, wäre echt klasse das diese seit für den Windows MediaCenter gedacht wa oder auch ist, und wir auch gerne diese seite endlich mal Online haben wolllen

Hier der Script:

-- phpMyAdmin SQL Dump
-- version 2.11.0
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 26, 2007 at 02:01 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";

--
-- Database: `livetv_livetv`
--

-- -------------------------------------- ------------------

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11)  \'0\',
  `uid` varchar(15)  \'\',
  `pwd` varchar(15) L,
  `email` varchar(100) ,
  `admin_email` varchar(100) ,
  `report_email` varchar(100) ,
  `feedback_email` varchar(100) ,
  `support_email` varchar(100) ,
  `info_email` varchar(100) ,
  `legal_email` varchar(100) ,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` VALUES(1, \'admin\', \'admin\', \'you@YourTVChannel.com\', \'you@YourTVChannel.com\', \'you@YourTVChannel.com\', \'you@YourTVChannel.com\', \'you@YourTVChannel.com\', \'you@YourTVChannel.com\', \'12\');

-- -------------------------------------- ------------------

--
-- Table structure for table `advertise`
--

CREATE TABLE `advertise` (
  `ad_id` int(22) NOT NULL auto_increment,
  `comp_name` varchar(200)  \'lokalhost\',
  `fname` varchar(200)  \'mcsoft\',
  `lname` varchar(200) \'mcsoft\',
  `email` varchar(130)  \'not default\',
  `message` text collate latin1_general_ci NOT NULL,
  `pdate` int(11) \'0\',
  PRIMARY KEY  (`ad_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Dumping data for table `advertise`
--


-- -------------------------------------- ------------------

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `cat_id` int(22) NOT NULL auto_increment,
  `cat_name` varchar(255) collate latin1_general_ci NOT NULL default \'\',
  `top_flag` tinyint(2) NOT NULL default \'0\',
  `mid` int(22) NOT NULL default \'0\',
  PRIMARY KEY  (`cat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=10 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` VALUES(9, \'cartoons\', 0, 11);
INSERT INTO `category` VALUES(4, \'Live Press Conferences\', 1, 1);
INSERT INTO `category` VALUES(8, \'Live Games\', 0, 1);

-- -------------------------------------- ------------------

--
-- Table structure for table `channel`
--

CREATE TABLE `channel` (
  `ch_id` int(22) NOT NULL auto_increment,
  `cat_id` int(22) NOT NULL default \'0\',
  `channel_name` varchar(200) collate latin1_general_ci NOT NULL default \'\',
  `channel_description` text collate latin1_general_ci NOT NULL,
  `channel_video` varchar(230) collate latin1_general_ci NOT NULL default \'\',
  `top_flag` tinyint(2) NOT NULL default \'0\',
  `channel_url` text collate latin1_general_ci,
  `mid` int(22) NOT NULL default \'0\',
  `channel_type` char(1) collate latin1_general_ci default NULL,
  PRIMARY KEY  (`ch_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `channel`
--

INSERT INTO `channel` VALUES(1, 4, \'ABCNews\', \'newschannel\', \'11788825452.Dat\', 1, \'mms://a1873.l2639649579.c26396.g.lm. akamaistream.net/D/1873/26396/v0001/re flector:49579\', 0, NULL);
INSERT INTO `channel` VALUES(2, 4, \'DEFNews\', \'DEF new is the best news channel.\', \'1178888464.mp3\', 1, \'mms://a1873.l2639649579.c26396.g.lm. akamaistream.net/D/1873/26396/v0001/re flector:49579\', 0, NULL);
INSERT INTO `channel` VALUES(3, 8, \'ABC Sports\', \'This is a sports channel.This is very popular.\', \'1178888464.mp3\', 1, \'mms://a1873.l2639649579.c26396.g.lm. akamaistream.net/D/1873/26396/v0001/re flector:49579\', 0, \'T\');
INSERT INTO `channel` VALUES(4, 4, \'Food\', \'Food Demonstration\', \'\', 0, \'mms://twc.wmod.llnwd.net/a189/e1/mul timedia/video/limelight/topstory_bb.as f\', 0, NULL);
INSERT INTO `channel` VALUES(9, 9, \'fgsdfg\', \'\', \'\', 0, \'fghjdghj\', 11, NULL);
INSERT INTO `channel` VALUES(6, 4, \'bb\', \'\', \'\', 0, \'http://208.53.137.180:30000\', 1, NULL);
INSERT INTO `channel` VALUES(8, 4, \'GEO TV\', \'PAKISTANI TV CHANNEL\', \'\', 0, \'http://geo.tv\', 1, NULL);
INSERT INTO `channel` VALUES(11, 8, \'Test video\', \'Youtube video - Upps\', \'\', 0, \'<object width=\\\"425\\\" height=\\\"355\\\"><param name=\\\"movie\\\" value=\\\"http://www.youtube.com/v/Gm3 cYz4oQYA&rel=1\\\"></param&g t;<param name=\\\"wmode\\\" value=\\\"transparent\\\"></para m><embed src=\\\"http://www.youtube.com/v/Gm3cY z4oQYA&rel=1\\\" type=\\\"application/x-shockwave-flash \\\" wmode=\\\"transparent\\\" width=\\\"425\\\" height=\\\"355\\\"></embed>&l t;/object>\', 1, \'V\');
INSERT INTO `channel` VALUES(12, 4, \'Youtube Favorites\', \'Youtube Favorites\', \'\', 0, \'http://youtube.com/rss/global/top_fa vorites.rss\', 1, \'R\');
INSERT INTO `channel` VALUES(13, 4, \'Youtube Recently\', \'Youtube Recently\', \'\', 0, \'http://youtube.com/rss/global/recent ly_added.rss\', 1, \'R\');
INSERT INTO `channel` VALUES(14, 9, \'test3\', \'testa\', \'\', 0, \'mms://a1873.l2639649579.c26396.g.lm. akamaistream.net/D/1873/26396/v0001/re flector:49579\', 11, \'T\');
INSERT INTO `channel` VALUES(15, 8, \'Google Videos\', \'Google Videos\', \'\', 0, \'http://video.google.com/videofeed?ty pe=search&q=baseball&num=20&am p;output=rss\', 1, \'R\');

-- -------------------------------------- ------------------

--
-- Table structure for table `mcategory`
--

CREATE TABLE `mcategory` (
  `mid` int(22) NOT NULL auto_increment,
  `mcat_name` varchar(200) character set latin1 collate latin1_general_ci NOT NULL default \'\',
  PRIMARY KEY  (`mid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `mcategory`
--

INSERT INTO `mcategory` VALUES(1, \'American Football\');
INSERT INTO `mcategory` VALUES(11, \'Cartoons\');

-- -------------------------------------- ------------------

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `med_id` int(11) NOT NULL auto_increment,
  `description` varchar(200) default NULL,
  `url` varchar(200) default NULL,
  `html_code` text,
  `top_flag` smallint(6) default NULL,
  PRIMARY KEY  (`med_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `media`
--

INSERT INTO `media` VALUES(1, \'upps funny clip #28\', \'http://www.youtube.com/watch?v=Gm3cY z4oQYA\', \'<object width=\\\"425\\\" height=\\\"355\\\"><param name=\\\"movie\\\" value=\\\"http://www.youtube.com/v/Gm3 cYz4oQYA&rel=1\\\"></param&g t;<param name=\\\"wmode\\\" value=\\\"transparent\\\"></para m><embed src=\\\"http://www.youtube.com/v/Gm3cY z4oQYA&rel=1\\\" type=\\\"application/x-shockwave-flash \\\" wmode=\\\"transparent\\\" width=\\\"425\\\" height=\\\"355\\\"></embed>&l t;/object>\', 0);
INSERT INTO `media` VALUES(7, \'upps funny clip #17\', \'http://www.youtube.com/watch?v=52qU9 RAn1Dw\', \'<object width=\\\"425\\\" height=\\\"355\\\"><param name=\\\"movie\\\" value=\\\"http://www.youtube.com/v/52q U9RAn1Dw&rel=1\\\"></param&g t;<param name=\\\"wmode\\\" value=\\\"transparent\\\"></para m><embed src=\\\"http://www.youtube.com/v/52qU9 RAn1Dw&rel=1\\\" type=\\\"application/x-shockwave-flash \\\" wmode=\\\"transparent\\\" width=\\\"425\\\" height=\\\"355\\\"></embed>&l t;/object>\', NULL);
INSERT INTO `media` VALUES(8, \'great goals\', \'http://www.youtube.com/watch?v=HD8f_ Qgwc50\', \'<object width=\\\"425\\\" height=\\\"355\\\"><param name=\\\"movie\\\" value=\\\"http://www.youtube.com/v/HD8 f_Qgwc50&rel=1\\\"></param&g t;<param name=\\\"wmode\\\" value=\\\"transparent\\\"></para m><embed src=\\\"http://www.youtube.com/v/HD8f_ Qgwc50&rel=1\\\" type=\\\"application/x-shockwave-flash \\\" wmode=\\\"transparent\\\" width=\\\"425\\\" height=\\\"355\\\"></embed>&l t;/object>\', NULL);
INSERT INTO `media` VALUES(9, \'queen + pavarotti - too much love will kill you\', \'http://www.youtube.com/watch?v=C7FGP IRJx6I\', \'<object width=\\\"425\\\" height=\\\"355\\\"><param name=\\\"movie\\\" value=\\\"http://www.youtube.com/v/C7F GPIRJx6I&rel=1\\\"></param&g t;<param name=\\\"wmode\\\" value=\\\"transparent\\\"></para m><embed src=\\\"http://www.youtube.com/v/C7FGP IRJx6I&rel=1\\\" type=\\\"application/x-shockwave-flash \\\" wmode=\\\"transparent\\\" width=\\\"425\\\" height=\\\"355\\\"></embed>&l t;/object>\', NULL);

-- -------------------------------------- ------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `nid` int(22) NOT NULL auto_increment,
  `newsdetails` text character set latin1 collate latin1_general_ci NOT NULL,
  `pdate` int(11) NOT NULL default \'0\',
  PRIMARY KEY  (`nid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `news`
--

INSERT INTO `news` VALUES(1, \'THIS IS THE NEWS SECTION , IT CAN BE UPDATED VIA ADMIN PANEL.\', 1192725335);

-- -------------------------------------- ------------------

--
-- Table structure for table `poll_db`
--

CREATE TABLE `poll_db` (
  `pl_id` int(22) NOT NULL auto_increment,
  `num_option` varchar(220) collate latin1_general_ci NOT NULL default \'\',
  `option_name` text collate latin1_general_ci NOT NULL,
  `pl_name` varchar(200) collate latin1_general_ci NOT NULL default \'\',
  PRIMARY KEY  (`pl_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `poll_db`
--

INSERT INTO `poll_db` VALUES(1, \'3\', \'20 to 35 years old:36 to 55 years old:56 + years old:\', \'What is your age range\');

-- -------------------------------------- ------------------

--
-- Table structure for table `problems`
--

CREATE TABLE `problems` (
  `pb_id` int(22) NOT NULL auto_increment,
  `prob_desc` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`pb_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `problems`
--

INSERT INTO `problems` VALUES(1, \'You can edit this via admin panelrn<br />\');

-- -------------------------------------- ------------------

--
-- Table structure for table `requirment`
--

CREATE TABLE `requirment` (
  `req_id` int(22) NOT NULL auto_increment,
  `prob_desc` text NOT NULL,
  PRIMARY KEY  (`req_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `requirment`
--

INSERT INTO `requirment` VALUES(1, \'You can edit this via admin panelrn<br />\');

-- -------------------------------------- ------------------

--
-- Table structure for table `rss_feeds`
--

CREATE TABLE `rss_feeds` (
  `rss_id` int(11) NOT NULL auto_increment,
  `description` varchar(200) default NULL,
  `url` varchar(200) default NULL,
  `top_flag` smallint(6) default NULL,
  PRIMARY KEY  (`rss_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `rss_feeds`
--

INSERT INTO `rss_feeds` VALUES(3, \'YouTube :: Recently Added Videos\', \'http://youtube.com/rss/global/recent ly_added.rss\', NULL);
INSERT INTO `rss_feeds` VALUES(5, \'YouTube :: Recently Featured\', \'http://youtube.com/rss/global/recent ly_featured.rss\', NULL);
INSERT INTO `rss_feeds` VALUES(6, \'YouTube :: Top Favorites\', \'http://youtube.com/rss/global/top_fa vorites.rss\', NULL);

-- -------------------------------------- ------------------

--
-- Table structure for table `suggest_stream`
--

CREATE TABLE `suggest_stream` (
  `sg_id` int(22) NOT NULL auto_increment,
  `Name_of_stream` varchar(222) collate latin1_general_ci NOT NULL default \'\',
  `url` varchar(200) collate latin1_general_ci NOT NULL default \'\',
  `fname` varchar(120) collate latin1_general_ci NOT NULL default \'\',
  `lname` varchar(120) collate latin1_general_ci NOT NULL default \'\',
  `email` varchar(130) collate latin1_general_ci NOT NULL default \'\',
  `pdate` int(11) NOT NULL default \'0\',
  PRIMARY KEY  (`sg_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `suggest_stream`
--

INSERT INTO `suggest_stream` VALUES(1, \'sdfsdf\', \'sdfdsf\', \'sdfsdf\', \'sdfsdf\', \'sdfsdf@sdfsdf.com\', 1179007518);
INSERT INTO `suggest_stream` VALUES(2, \'zee sports\', \'\', \'\', \'\', \'\', 1192323551);
INSERT INTO `suggest_stream` VALUES(3, \'aass\', \'http://spreelance.com\', \'aa\', \'aa\', \'aass@aass.com\', 1193105552);

-- -------------------------------------- ------------------

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `tr_id` int(22) NOT NULL auto_increment,
  `prob_desc` text collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`tr_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` VALUES(1, \'\');

Danke schon mal im vorraus... Für Privi fragen oder Hilfestellungen bin ich immer da
Maximal (28)


Themen: 331
Beiträge: 4665
Nachricht
Direkt-Link

Am 28.11.2011 um 22:00:

Leute er/sie/es braucht Hilfe ... dringend

 

Toll , Du kannst lesen ....

datenmine (32)


Themen: 1
Beiträge: 44
Nachricht
Direkt-Link

Am 02.12.2011 um 02:06:

... male ehrlich ... das ist NICHT euer ernst, oder?!

Maximal (28)


Themen: 331
Beiträge: 4665
Nachricht
Direkt-Link

Am 02.12.2011 um 09:04:

Zitat (datenmine):

... male ehrlich ... das ist NICHT euer ernst, oder?!

öhm ne oder doch .....

Toll , Du kannst lesen ....

SeymourEvil (26)


Themen: 311
Beiträge: 10760
Nachricht
Direkt-Link

Am 02.12.2011 um 10:01:

User nicht mehr angemeldet

GESCHLOSSEN!

Die goolive Forenregeln: http://www.goolive.de/forumregeln

F iction is the truth inside the lie - Stephen King

5 Beiträge • oben


goolive Forum » Fachforum » Hardware & Software