Fixed bug + added insert
diff --git a/admin/inscrits.csv b/admin/inscrits.csv
new file mode 100644
index 0000000..a72196d
--- /dev/null
+++ b/admin/inscrits.csv
@@ -0,0 +1,101 @@
+nom,curs,grau
+Leyla Rosenbarg,4,0
+Conny Swinford,2,0
+Nadya Gillio,4,1
+Tillie Care,4,0
+Lynnett Perceval,3,1
+Hunter Kneeland,4,0
+Eileen Fells,3,1
+Jessamine Gowler,2,0
+Cleve Ebbers,4,0
+Josee Harrap,3,1
+Frederik Merchant,3,1
+Leo Mattedi,4,0
+Cynde Bickell,3,1
+Peyton Fenne,4,1
+Noella Turneux,4,1
+Lib Langeley,3,1
+Benjie Hopewell,2,0
+Valerie Sherlaw,4,0
+Mira Willgoose,3,1
+Cory Gullam,4,0
+Amalita Melmoth,4,1
+Laverne Paxforde,4,0
+Caroline Burfitt,4,0
+Moses Glawsop,3,0
+Cristionna Hallede,4,1
+Vinnie De Brett,1,0
+Tripp Jeannin,4,1
+Netta Lejeune,3,1
+Hyacinth Grigorio,1,1
+Germain Groucock,4,1
+Merle Demanche,2,1
+Donica Chalmers,1,1
+Shel Lassen,2,1
+Quint Enocksson,3,1
+Codie Tomik,3,1
+Jessalin Land,2,1
+Woodman Pattinson,1,0
+Matias Arnull,1,1
+Rafael Coburn,3,0
+Maiga Nurden,3,1
+Latrena McDowell,4,1
+Dael Sammes,3,0
+Maribeth Oldnall,3,1
+Duncan Beacham,4,0
+Adelaide Knewstub,2,1
+Prince Gotter,3,0
+Mignonne Reiglar,4,1
+Doll Esland,3,0
+Penelope Capner,3,0
+Mina Abelovitz,2,1
+Damaris Gerrelt,3,0
+Waverly Pockey,1,1
+Portie Crewther,4,0
+Esmaria Girodin,1,1
+Homerus Keeton,1,0
+Georgiana Rallin,4,0
+Ammamaria Churn,3,0
+Kirby Grunwald,1,1
+Kenna Meadway,4,1
+Evania Dri,4,0
+Colas Pettiford,4,0
+Raven Gorrick,1,1
+Sunny Renouf,3,0
+Darice MacCarter,3,1
+Evyn Bloxsum,4,0
+Willette Lantoph,4,1
+Wells Murtell,3,1
+Paxon Poley,4,1
+Jamaal Barenskie,4,0
+Damon Driffe,4,1
+Danya Holborn,2,0
+Emmi Fairney,1,1
+Kare Ottley,3,0
+Marysa Carbine,4,1
+Ginni Hilhouse,4,1
+Lisa Lunt,4,0
+Vivyan Goldstein,2,1
+Dalt Goaley,4,1
+Antony Poulgreen,4,1
+Courtney Jodkowski,1,0
+Joela Yerrill,4,1
+Armstrong Shillito,4,0
+Garry Vaudin,3,0
+Margaretha Cartmell,1,1
+Wendall Clorley,2,0
+Pablo Janusz,3,1
+Neddy Pirouet,4,0
+Ardene Rhydderch,2,0
+Cassey Pech,3,0
+Dody Happert,2,0
+Lilas Sach,3,0
+Winthrop Sidon,4,0
+Wainwright Ginley,3,0
+Colas Ardern,4,1
+Grace Monni,1,1
+Husain Buglar,4,1
+Andres Gay,2,0
+Krissie Ledwith,4,1
+Lloyd Laval,4,0
+Sharyl Wooffitt,4,0
diff --git a/admin/insert.php b/admin/insert.php
index 8cb6f2a..77df79b 100644
--- a/admin/insert.php
+++ b/admin/insert.php
@@ -1,24 +1,18 @@
<?php
require '../credentials.php';
require '../php/utils.php';
+
+ // Read from CSV
+ $inscrits = array_map('str_getcsv', file('inscrits.csv'));
+ array_shift($inscrits); // remove header
- $inscrits = [
- ['Joan Hernanz Segarra', 3, 1],
- ['Olga Almudena Martínez', 1, 1],
- ['Jordi Ganso Rodríguez', 2, 0],
- ['Júlia Montserrat Puig', 3, 0],
- ['Berta Galofré Mestres', 4, 0],
- ['Laia Pomar Raventós', 3, 1],
- ['Irene Cusiné Baltà', 1, 0]
- ];
-
- $start = 6;
+ $start = 1;
$i = $start;
foreach ($inscrits as $user) {
$i = ($i + 1) % ($start + count($inscrits));
if ($i == 0) $i = $i + 1;
- $template = "INSERT INTO `users` (`id`, `nom`, `curs`, `grau`, `quimata`, `requested`, `mort`, `password`)" .
+ $template = "INSERT INTO `newusers` (`id`, `nom`, `curs`, `grau`, `quimata`, `requested`, `mort`, `password`)" .
" VALUES (NULL, '".$user[0]."', '".$user[1]."', '".$user[2]."', ".$i.", '0', '0', '')";
- if (query($template)) echo $template . "\n";
+ if (query($template)) echo $template . "<br />";
}
?>