MySQL Probleem

Nillas

PHP

-- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: May 12, 2005 at 10:05 AM
-- Server version: 3.23.49
-- PHP Version: 4.3.9
-- 
-- Database: `fb`
-- 


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


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


CREATE TABLE `admin` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(50) default NULL,
  `avatar` varchar(50) default NULL,
  `col_back` varchar(7) NOT NULL default 'ffffff',
  `col_link` varchar(7) NOT NULL default 'ff9900',
  `col_text` varchar(7) NOT NULL default 'ffffff',
  `col_table_border` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_border_2` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_row` varchar(7) NOT NULL default '000000',
  `col_table_row2` varchar(7) NOT NULL default '000000',
  `col_table_header` varchar(7) NOT NULL default 'EB9518',
  `col_table_header_2` varchar(7) NOT NULL default '000000',
  `col_table_header_text` varchar(7) NOT NULL default 'FFFFFF',
  `col_table_row_text` varchar(7) NOT NULL default 'FFFFFF',
  `currency` char(3) NOT NULL default '£',
  `logo_pos` varchar(10) NOT NULL default 'center',
  `texture` varchar(30) NOT NULL default '',
  `admin_message` text NOT NULL,
  `title_message` text NOT NULL,
  `theme_col` varchar(12) NOT NULL default 'grey',
  `site_url` varchar(100) NOT NULL default 'Enter your site url here !!!!',
  `admin_email` varchar(100) NOT NULL default '',
  `pom_vote` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;


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


INSERT INTO `admin` VALUES (1, 'admin', 'homer.gif', '000033', 'FFFF33', 'FFFFFF', 'CCCCCC', '888888', '330000', '660000', '000066', '000033', 'FFFF00', 'FFFFFF', '', 'Center', '0', 'This welcome message can be changed from the admin control panel.\r\n\r\nPut whatever message you like !\r\nit will always be displayed at the top of this page\r\n\r\nIMPORTANT: Create a new users straight away, giving yourself admin rights, then login with your new user and delete the admin user !!!', 'Welcome to PHP FC Homepage', 'Grey', '', '', 2);


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


-- 
-- Table structure for table `fixtures`
-- 


CREATE TABLE `fixtures` (
  `fix_id` int(10) NOT NULL auto_increment,
  `opp_team` varchar(50) NOT NULL default '',
  `ground` varchar(50) NOT NULL default '',
  `fix_date` date NOT NULL default '0000-00-00',
  `fix_time` varchar(8) NOT NULL default '',
  `home_away` varchar(10) NOT NULL default '',
  `match_type` varchar(40) NOT NULL default '',
  `notes` text NOT NULL,
  `closed` char(3) NOT NULL default 'no',
  `fix_oldname` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`fix_id`)
) TYPE=MyISAM AUTO_INCREMENT=73 ;


-- 
-- Dumping data for table `fixtures`
-- 




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


-- 
-- Table structure for table `league_table`
-- 


CREATE TABLE `league_table` (
  `table_id` int(10) NOT NULL auto_increment,
  `match_id` int(11) NOT NULL default '0',
  `team_name` varchar(50) NOT NULL default '',
  `opp_team` varchar(50) NOT NULL default '',
  `w_d_l` varchar(5) NOT NULL default '',
  `points` int(10) NOT NULL default '0',
  `home_away` varchar(8) NOT NULL default '',
  `match_type` varchar(40) NOT NULL default '',
  `goals_for` int(11) NOT NULL default '0',
  `goals_against` int(11) NOT NULL default '0',
  `oldname` varchar(50) NOT NULL default '',
  `match_report` text NOT NULL,
  `match_tag` char(3) NOT NULL default '',
  `match_date` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`table_id`)
) TYPE=MyISAM AUTO_INCREMENT=153 ;


-- 
-- Dumping data for table `league_table`
-- 




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


-- 
-- Table structure for table `match_comment`
-- 


CREATE TABLE `match_comment` (
  `comment_id` int(10) NOT NULL auto_increment,
  `match_id` int(11) NOT NULL default '0',
  `name` varchar(40) NOT NULL default '',
  `comment` text NOT NULL,
  PRIMARY KEY  (`comment_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;


-- 
-- Dumping data for table `match_comment`
-- 




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


-- 
-- Table structure for table `match_signup`
-- 


CREATE TABLE `match_signup` (
  `signup_id` int(10) NOT NULL auto_increment,
  `match_id` int(10) NOT NULL default '0',
  `name` varchar(40) NOT NULL default '',
  `playing` varchar(5) NOT NULL default '',
  `comment` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`signup_id`)
) TYPE=MyISAM AUTO_INCREMENT=21 ;


-- 
-- Dumping data for table `match_signup`
-- 




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


-- 
-- Table structure for table `match_squad`
-- 


CREATE TABLE `match_squad` (
  `squad_id` int(10) NOT NULL auto_increment,
  `match_id` int(10) NOT NULL default '0',
  `position` varchar(20) NOT NULL default '',
  `playername` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`squad_id`)
) TYPE=MyISAM AUTO_INCREMENT=219 ;


-- 
-- Dumping data for table `match_squad`
-- 




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


-- 
-- Table structure for table `matchtypes`
-- 


CREATE TABLE `matchtypes` (
  `matchtype_id` int(10) NOT NULL auto_increment,
  `matchtype` varchar(40) NOT NULL default '',
  `match_cat` varchar(40) NOT NULL default '',
  `division` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`matchtype_id`),
  UNIQUE KEY `matchtype` (`matchtype`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;


-- 
-- Dumping data for table `matchtypes`
-- 


INSERT INTO `matchtypes` VALUES (1, 'Enter league name here', 'league', '');


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


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


CREATE TABLE `news` (
  `news_id` int(10) NOT NULL auto_increment,
  `news_username` varchar(40) default NULL,
  `news` text,
  `news_title` varchar(50) NOT NULL default '',
  `news_date` date NOT NULL default '0000-00-00',
  `topic_image` varchar(20) NOT NULL default 'topic_news.gif',
  `hyperlink_text1` varchar(255) default NULL,
  `hyperlink_url1` varchar(255) default NULL,
  `hyperlink_text2` varchar(255) default NULL,
  `hyperlink_url2` varchar(255) default NULL,
  `news_image` varchar(20) NOT NULL default 'none',
  PRIMARY KEY  (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=160 ;


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


INSERT INTO `news` VALUES (158, 'admin', 'This is an example news post, please delete this post using the ''Delete'' option in the top right corner.\r\n\r\nAdd your own news posts via the administration screen.', 'Example News', '2005-05-12', 'club news2.gif', '', '', '', '', 'none');


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


-- 
-- Table structure for table `player_of_match`
-- 


CREATE TABLE `player_of_match` (
  `pom_id` int(10) NOT NULL auto_increment,
  `username` varchar(50) NOT NULL default '',
  `playername` varchar(50) NOT NULL default '',
  `match_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pom_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;


-- 
-- Dumping data for table `player_of_match`
-- 




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


-- 
-- Table structure for table `results`
-- 


CREATE TABLE `results` (
  `results_id` int(10) NOT NULL auto_increment,
  `match_id` int(10) NOT NULL default '0',
  `playername` varchar(40) NOT NULL default '',
  `goals` tinyint(4) NOT NULL default '0',
  `position` varchar(20) NOT NULL default '',
  `pom` int(11) NOT NULL default '0',
  PRIMARY KEY  (`results_id`)
) TYPE=MyISAM AUTO_INCREMENT=97 ;


-- 
-- Dumping data for table `results`
-- 




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


-- 
-- Table structure for table `roles`
-- 


CREATE TABLE `roles` (
  `role_id` tinyint(10) NOT NULL auto_increment,
  `role_title` varchar(20) NOT NULL default '',
  `role_order` int(10) NOT NULL default '0',
  PRIMARY KEY  (`role_id`)
) TYPE=MyISAM AUTO_INCREMENT=19 ;


-- 
-- Dumping data for table `roles`
-- 


INSERT INTO `roles` VALUES (1, 'Manager', 2);
INSERT INTO `roles` VALUES (3, 'Player', 6);


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


-- 
-- Table structure for table `seasons`
-- 


CREATE TABLE `seasons` (
  `season_id` int(10) NOT NULL auto_increment,
  `season_name` varchar(20) NOT NULL default '',
  `season_start` date NOT NULL default '0000-00-00',
  `season_end` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`season_id`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;


-- 
-- Dumping data for table `seasons`
-- 


INSERT INTO `seasons` VALUES (2, '2004-2005', '2004-08-01', '2005-05-29');


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


-- 
-- Table structure for table `teams`
-- 


CREATE TABLE `teams` (
  `team_id` int(10) NOT NULL auto_increment,
  `team_name` varchar(80) NOT NULL default '',
  `division` varchar(80) NOT NULL default '',
  `own_team` varchar(5) NOT NULL default 'no',
  `league_name` varchar(80) NOT NULL default '',
  `contact_name` varchar(40) NOT NULL default '',
  `contact_role` varchar(30) NOT NULL default '',
  `contact_name_2` varchar(30) NOT NULL default '',
  `contact_role_2` varchar(30) NOT NULL default '',
  `contact_name_3` varchar(30) NOT NULL default '',
  `contact_role_3` varchar(30) NOT NULL default '',
  `contact_email` varchar(50) NOT NULL default '',
  `contact_email_2` varchar(50) NOT NULL default '',
  `contact_email_3` varchar(50) NOT NULL default '',
  `contact_tel` varchar(20) NOT NULL default '',
  `contact_tel_2` varchar(20) NOT NULL default '',
  `contact_tel_3` varchar(20) NOT NULL default '',
  `contact_address` varchar(255) NOT NULL default '',
  `ground_name` varchar(50) NOT NULL default '',
  `home_strip` varchar(50) NOT NULL default '',
  `away_strip` varchar(50) NOT NULL default '',
  `points_total` int(11) NOT NULL default '0',
  `goaldiff` int(11) NOT NULL default '0',
  PRIMARY KEY  (`team_id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;


-- 
-- Dumping data for table `teams`
-- 


INSERT INTO `teams` VALUES (1, 'Your Team Name', '', 'yes', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0, 0);


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


-- 
-- Table structure for table `topic`
-- 


CREATE TABLE `topic` (
  `topic_id` int(10) NOT NULL auto_increment,
  `topic_image` varchar(20) NOT NULL default '',
  `topic_image_name` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`topic_id`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;


-- 
-- Dumping data for table `topic`
-- phpMyAdmin SQL Dump
-- version 3.1.3.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 28 Mei 2009 om 21:28
-- Serverversie: 5.1.33
-- PHP-Versie: 5.2.9-2
-- 


INSERT INTO `topic` VALUES (27, 'cup news.gif', 'Cup News');
INSERT INTO `topic` VALUES (26, 'player match 2.gif', 'Player Of The Match');
INSERT INTO `topic` VALUES (21, 'match_news.gif', 'Match News');
INSERT INTO `topic` VALUES (24, 'club news2.gif', 'Club News');


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


-- 
-- Table structure for table `users`
-- 


CREATE TABLE `users` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(40) default NULL,
  `displayname` varchar(40) NOT NULL default '',
  `nickname` varchar(20) NOT NULL default '',
  `interests` text NOT NULL,
  `yim` varchar(50) NOT NULL default '',
  `joindate` varchar(20) NOT NULL default 'n/a',
  `clubs` text NOT NULL,
  `profile` text NOT NULL,
  `password` varchar(50) default NULL,
  `rights` int(10) NOT NULL default '0',
  `regdate` varchar(20) default NULL,
  `email` varchar(100) default NULL,
  `msn` varchar(40) NOT NULL default '',
  `icq` varchar(10) NOT NULL default '',
  `aim` varchar(40) NOT NULL default '',
  `tel` varchar(20) NOT NULL default '',
  `position` varchar(20) NOT NULL default '',
  `role` varchar(20) NOT NULL default '',
  `age` int(3) default NULL,
  `website` varchar(150) default NULL,
  `location` varchar(150) default NULL,
  `show_email` int(2) default '0',
  `last_login` varchar(20) default NULL,
  `avatar` varchar(30) NOT NULL default 'no_pic.gif',
  `player` char(3) NOT NULL default '',
  `selected` char(3) NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`),
  UNIQUE KEY `displayname` (`displayname`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=124 ;


-- 
-- Dumping data for table `users`
-- 


INSERT INTO `users` VALUES (121, 'admin', 'admin', '', '', '', 'n/a', '', '', '21232f297a57a5a743894a0e4a801fc3', 5, '2005-05-12', '', '', '', '', '', '', 'Player', NULL, NULL, NULL, 0, 'Never', 'no_pic.gif', 'yes', 'no');

Toon Meer

Wat is er fout aan deze Dump? Hij geeft aan dat het geen goede currency is in the Admin table. Ik kan nu even niet op php-my-admin maar zodra ik dat wel kan zal ik de volledige fout plaatsen. Ik dacht ik post hem alvast. Ziet iemand dit probleem?

Darsstar

`currency` char(3) NOT NULL default '£',

char(3) betekend dat waardes uit drie teken moeten bestaan.
varchar(3) betekend dat het uit maximaal drie tekens mag bestaan.

Hoeveel tekens heeft je default waarde?
Ik denk dat daar het probleem ligt...

Jannick

Met het uitvoeren heb ik geen problemen ondervonden. Misschien even de de waarde bij 'currency' veranderen? Dus niet het pond-teken, maar bijv. niks. Wellicht dat dat helpt?

Darsstar hoe wil je dan verklaren dat ik geen foutmelding krijg? Het enige aparte is dat ie het hele veld van currency truncate, is dat de reden?

Nillas

Ok thanx, ik kan nog steeds niet op Php-Myadmin hebben jullie dit ook?

Darsstar

Citaat van Jannick

Met het uitvoeren heb ik geen problemen ondervonden. Misschien even de de waarde bij 'currency' veranderen? Dus niet het pond-teken, maar bijv. niks. Wellicht dat dat helpt?
Darsstar hoe wil je dan verklaren dat ik geen foutmelding krijg? Het enige aparte is dat ie het hele veld van currency truncate, is dat de reden?

*haat MySQL nog meer dan 5 minuten geleden*
MySQL geeft te weinig errors, probeert zelf te veel dingen te corrigeren en nog wat andere dingen...
Volgens mij plaatst MySQL allemaal spaties aan het einde van de string zodat het genoeg tekens bevat, bij het uitlezen laat MySQL al die spaties weg.
Dat laatste weet ik behoorlijk zeker (net nog getest).
Met een slecht ontworpen login systeem kan je zo dus op een admin account inloggen met je zelf gekozen wachtwoord.

Nillas
Ik kan gewoon op een willekeurige phpmyadmin komen hoor, maar dat wilt niet zeggen.
Een foutmelding zou toch wel erg fijn zijn...

ICTscripters

Dé plek voor IT

Dé plek voor IT

Na 15 jaar terug van weggeweest: iCriminals.nl is terug (BETA)!

Developer Gezocht

Op zoek naar de legends

[FREE] WeFact Hosting module

Help testers nodig voor android app Urgent

Versio vervanger

Afspraken systeem met planbeperking

Partner Gezocht om meerdere NFT Collecties op Open Sea te Plaatsen

Verschillende domeinen

350 Nieuwe Domeinnamen Januari 2026

321 Nieuwe Domeinnamen December 2025

MySQL Probleem

Participate now!

Fijne feestdagen

Kritieke update voor Really Simple Security-plug-in

ING Nederland streeft naar ondersteuning van Google Pay tegen eind februari

Functioneel ontwerp

Access Control List implementatie in PHP/MySQL - deel 1/2

Access Control List implementatie in PHP/MySQL - deel 2/2

Gebruikers die dit topic bekijken