Author Topic: 2012-13 EPL Teams and Players  (Read 5420 times)

admin

  • Guest
2012-13 EPL Teams and Players
« on: August 12, 2012, 01:03:33 AM »
I have attached a dump of my 2012/13 EPL realteams and players sql files.

You will need to import both of these in to your MySQL database, overwriting the original tables.

Once imported you will then need to log in as admin and upload the shirt jpg for each team.
« Last Edit: August 29, 2013, 06:58:28 AM by David Allen »

Offline GaryL

  • New User
  • *
  • Posts: 2
    • View Profile
Re: 2012-13 EPL Teams and Players
« Reply #1 on: August 13, 2012, 07:36:57 AM »
Fantastic! Cheers for this David! Sorry I didn't get back to you regarding hosting. I eventually got my host to sort the issue. Thank you again!

Gary

Offline SᴩiDᴇЯ

  • New User
  • *
  • Posts: 5
    • View Profile
Re: 2012-13 EPL Teams and Players
« Reply #2 on: August 16, 2012, 09:08:38 AM »
" I download file and when I import Players SQL it giving this error :

SQL query:

 -- -- Dumping data for table `players` -- INSERT INTO `players` (`id`, `firstname`, `lastname`, `reallifeteam`, `cost`, `position`, `is_active`) VALUES (2893, 'Abou', 'Diaby', 135, 5.0, 'MD', 'Y'), (2894, 'Ashley', 'Cole', 139, 5.5, 'DF', 'Y'), (2898, 'Robin', 'Van Persie', 135, 10.0, 'AT', 'Y'), (2906, 'Philippe', 'Senderos', 141, 3.5, 'DF', 'Y'), (2908, 'Gael', 'Clichy', 143, 5.0, 'DF', 'Y'), (2911, 'Emmanuel', 'Adebayor', 143, 8.0, 'AT', 'Y'), (2913, 'Kolo', 'Toure', 143, 5.5, 'DF', 'Y'), (2916, 'Theo', 'Walcott', 135, 7.5, 'AT', 'Y'), (2917, 'Nicklas', 'Bendtner', 135, 7.0, 'AT', 'Y'), (2924, 'Tomas', 'Rosicky', 135, 5.5, 'MD', 'Y'), (2926, 'Thomas', 'Sorensen', 148, 4.0, 'GK', 'Y'), (2931, 'Gareth', 'Barry', 143, 6.0, 'MD', 'Y'), (2942, 'Aaron', 'Hughes', 141, 4.0, 'DF', 'Y'), (2945, 'Gary', 'Cahill', 139, 6.0, 'DF', 'Y'), (2949, 'Gabriel', 'Agbonlahor', 136, 7.5, 'AT', 'Y'), (2950, 'Brad', 'Friedel', 150, 5.0, 'GK', 'Y'), (2978, 'Ali', 'Al Habsi', 153, 4.0, 'GK', 'Y'), (3023, [...]

MySQL said: 
 #1062 - Duplicate entry '2893' for key 'PRIMARY'

Please can you help me?

Thank you David.

admin

  • Guest
Re: 2012-13 EPL Teams and Players
« Reply #3 on: August 18, 2012, 01:14:06 AM »
You will need to delete both real_team and players tables before importing both of these.

It is important to use my real_team list as well because the players list relates to it.