Domanda Database creator

[America]

Ciao,

ho trovato sul sito ufficiale lo script in php per creare il database bello e pulito, tuttavia quando provo ad avviare lo script via browser mi da un errore:

Connecting to database…Creating player table…You have an error in your  SQL syntax; check the manual that corresponds to your MySQL server  version for the right syntax to use near '     username VARCHAR,     password VARCHAR,     dob VARCHAR,     email VARCHAR,     lastL' at line 3

Lo script è il seguente:

<?php
/*
Sets up a pokenet game account database.
Requires MySQL 4 or 5.
/*

/*
EDIT THE FOLLOWING ACCORDINGLY
*/
$host= "messo";
$dbname = "messo";
$username = "messo";
$password = "messo";

/*
DO NOT EDIT BELOW UNLESS YOU ARE A DEVELOPER
*/
// Make the MySQL Connection
echo "Connecting to database…";
mysql_connect($host, $username, $password) or die(mysql_error());
mysql_select_db($dbname) or die(mysql_error());

//Create the player table
echo "Creating player table…";

mysql_query("CREATE TABLE pn_members(
    id INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY,
    username VARCHAR,
    password VARCHAR,
    dob VARCHAR,
    email VARCHAR,
    lastLoginTime VARCHAR,
    lastLoginServer VARCHAR,
    lastLoginIP VARCHAR,
    lastLanguageUsed INT,
    sprite INT,
    party INT,
    money INT,
    skHerb INT,
    skCraft INT,
    skFish INT,
    skTrain INT,
    skCoord INT,
    skBreed INT,
    x INT,
    y INT,
    mapX INT,
    mapY INT,
    badges VARCHAR,
    healX INT,
    healY INT,
    healMapX INT,
    healMapY INT,
    isSurfing VARCHAR,
    muted VARCHAR,
    adminLevel INT )")
or die(mysql_error());

/* Make usernames UNIQUE */
mysql_query("ALTER TABLE pn_members add UNIQUE")
or die(mysql_error());

/*
Create bag table
*/
echo "Creating the bag table…";

mysql_query("CREATE TABLE pn_bag(
    member INT NOT NULL,
    item INT NOT NULL,
    quantity INT NOT NULL )") 
or die(mysql_error());

/*
Create the party table.
A pokemon party stores 6 Pokemon (Id reference).
*/
echo "Creating the Pokemon party table…";

mysql_query("CREATE TABLE pn_party(
    id INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY,
    member INT,
    pokemon0 INT,
    pokemon1 INT,
    pokemon2 INT,
    pokemon3 INT,
    pokemon4 INT,
    pokemon5 INT )") 
or die(mysql_error());

/*
Create the Pokemon table
*/
echo "Creating the Pokemon table…";

mysql_query("CREATE TABLE pn_pokemon(
    id INT NOT NULL AUTO_INCREMENT,
    PRIMARY KEY,
    name VARCHAR,
    speciesName VARCHAR,
    exp VARCHAR,
    baseExp INT,
    expType VARCHAR,
    isFainted VARCHAR,
    level INT,
    happiness INT,
    gender INT,
    nature VARCHAR,
    abilityName VARCHAR,
    itemName VARCHAR,
    isShiny VARCHAR,
    originalTrainerName VARCHAR,
    currentTrainerName VARCHAR,
    contestStats VARCHAR,
    move0 VARCHAR,
    move1 VARCHAR,
    move2 VARCHAR,
    move3 VARCHAR,
    hp INT,
    atk INT,
    def INT,
    speed INT,
    spATK INT,
    spDEF INT,
    evHP INT,
    evATK INT,
    evDEF INT,
    evSPD INT,
    evSPATK INT,
    evSPDEF INT,
    ivHP INT,
    ivATK INT,
    ivDEF INT,
    ivSPD INT,
    ivSPATK INT,
    ivSPDEF INT,
    pp0 INT,
    pp1 INT,
    pp2 INT,
    pp3 INT,
    maxpp0 INT,
    maxpp1 INT,
    maxpp2 INT,
    maxpp3 INT,
    ppUp0 INT,
    ppUp1 INT,
    ppUp2 INT,
    ppUp3 INT,
    date VARCHAR )") 
or die(mysql_error());

/*
Create the ban table.
*/
echo "Creating the ban table…";

mysql_query("CREATE TABLE pn_bans(
ip VARCHAR )") 
or die(mysql_error());

/*
Create pn_history table
*/
echo "Creating pn_history table…";

mysql_query("CREATE TABLE pn_history(
    member INT,
    action INT,
    with INT,
    timestamp DATETIME,
    details VARCHAR )") 
or die(mysql_error());

echo "Setup complete";
?>

Come risolvo ?

 

[abalossa]

Anche io ho lo stesso problema con la query postata da murder ho fatto una piccola ricerca a quanto pare utilizzano una versione precedente dalla nostra

 

[America]

Se tolgo le variabili VARCHAR, mi da gli errori sulle INT asd, murdercode aiutaci tu!

---------- Post added 03-04-12 at 15:32 ---------- Previous post was 02-04-12 at 22:54 ----------

Risolto avviando la query che c'è nello zip (anche se volevo fare via php), però la registrazione non va lo stesso...