#include <iostream>
#include <fstream>
#include <string>
#include <stdio.h>
using namespace std;
#define EXTENSIO ".php"

int main () {
    ofstream php;
    string arxiu;
    string cat;
    cout << "Quina categoria tractarem?" << endl;
    while (cin >> cat) {
        cout << "Quina nova pagina toca crear?" << endl;
        char pag;
        cin >> pag;
        while (pag > '0') {
            if (pag > '9') {
                arxiu = cat + "-" + pag + EXTENSIO;
            }
            else {
                arxiu = cat + "-0" + pag + EXTENSIO;
            }
            php.open(&arxiu[0]);
            if (php.is_open()){
php << "<?php\n";
php << "    $host=\"localhost\";\n";
php << "$user=\"s05e8375_lector\";\n";
php << "$password=\"anonimo\";\n";
php << "$link = mysql_connect ($host, $user, $password) or die (\"<center>No se puede conectar";
php << " con la base de datos\\n</center>\\n\");\n";
php << "   $tablename=\"juegos\";\n";
php << " $query=\"SELECT * FROM $tablename WHERE ID=XX\";\n";
php << " include (\"cuerpoplantillacat1.php\");\n";
                php << "$query=\"SELECT * FROM $tablename WHERE ID LIKE '" << cat << "____' ORDER";
                php << "BY `ID` DESC LIMIT " << 10 * (pag - '1') <<" , " << 10*(pag - '0') - '1' << "\" ;\n";
                php.close();
                cout << "La pagina " << pag << " s'ha creat correctament." <<endl;
                --pag;
            }
            else {
                php.close();
                cout << "El joc " << pag << " ha fallat en l'execucio." << endl;
                cout << "No creus que hauries de preguntar-li a l'excel·lentissim Carles?" << endl;
                --pag;
            }
        }
        cout << "Quina nova pagina toca crear ara?" << endl;
    }
}