Es wird nix in der Tabelle eingetragen

Hallo,

undzwar wird in der MySQL Tabelle nix eingetragen die Tabellen werden jedoch erstelle. Hier mal beim Register so eigentlich was eingetragen werden sollte. MySQL r5

public OnPlayerRegister(playerid,password[])
{
new string[200];
format(string,sizeof(string),"INSERT INTO `users`(`pName`,`pPasswort`,`pEmail`,`pBanned`,`pSkin`) VALUE('%s','%s','%s','%d','%d')",
GetName(playerid),password,pInfo[playerid][pEmail],pInfo[playerid][pBanned],pInfo[playerid][pSkin]);
mysql_query(string);
StopAudioStreamForPlayer(playerid);
pInfo[playerid][pOnline] = 1;
SavePlayer(playerid);
SpawnPlayer(playerid);
pInfo[playerid][pBanned] = 0;
return 1;
}

Hier mal die mysql_log
[14:03:23]

[14:03:23] ---------------------------
[14:03:23] MySQL Debugging activated (01/09/14)
[14:03:23] ---------------------------
[14:03:23]
[14:03:23] >> mysql_query( Connection handle: 1 )
[14:03:23] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `users` (`id` int(11) AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.
[14:03:23] >> mysql_query( Connection handle: 1 )
[14:03:23] CMySQLHandler::Query(ALTER TABLE `users` ADD `pName` varchar(64)) - An error has occured. (Error ID: 1060, Duplicate column name 'pName')
[14:03:23] >> mysql_query( Connection handle: 1 )
[14:03:23] CMySQLHandler::Query(ALTER TABLE `users` ADD `pPasswort` varchar(64)) - An error has occured. (Error ID: 1060, Duplicate column name 'pPasswort')
[14:04:03] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[14:04:03] CMySQLHandler::FreeResult() - The result is already empty.
[14:04:03] CMySQLHandler::Disconnect() - Connection was closed.

so ich habe mich mal registriert aber in der mysql log kenn ich mich net aus

die tabellen wird ja erstellt. Nur wenn ich mich registrieren wird nix eingetragen.

stock TabellenErstellen()
{
print("test");
mysql_query("CREATE TABLE IF NOT EXISTS `users` (`id` int(11) AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
mysql_query("ALTER TABLE `users` ADD `pName` varchar(64)");
mysql_query("ALTER TABLE `users` ADD `pPasswort` varchar(64)");
print("<<<< Tabellen erfolgreich erstellt >>>>");
return 1;
}

So, ich habe mal den dialog geprintet und es wird in der server console angezeigt wenn ich mich registriere nur es passiert einfach garnix in der tabelle.

case DIALOG_REGISTER:
{
if(response)
{
if(strlen(inputtext) == 0)
{
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Kein Passwort eingabe Test","Register","Abbrechen");
return 1;
}
else
{
print("test");
OnPlayerRegister(playerid, inputtext);
return 1;
}
}
else
{
Kick(playerid);
}
return 1;
}
case DIALOG_LOGIN:

Beavis:

So. Wenn ich mich einloggen will schließt sich der server

hier mal dialog_login case DIALOG_LOGIN:
{
if(response)
{
if(strlen(inputtext) == 0)
{
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Falsches Passwort test","Login","Abbrechen");
return 1;
}
else
{
print("test");
OnPlayerLogin(playerid,inputtext);
return 1;
}
}
else
{
Kick(playerid);
}
return 1;
}

und onplayerlogin: public OnPlayerLogin(playerid,password[])
{
new string[256],result[256];
format(string, sizeof(string),"SELECT * FROM `users` WHERE `pName` = '%s' AND `pPasswort` = '%s'", GetName(playerid),password);
mysql_query(string);
mysql_store_result();
if(mysql_num_rows())
{
while(mysql_retrieve_row())
{
mysql_fetch_field_row(result, "pID");
pInfo[playerid][pID] = strval(result);

mysql_fetch_field_row(result, "pSkin");
pInfo[playerid][pSkin] = strval(result);

strdel(result,0,sizeof(result));
}
mysql_free_result();
format(string,256,"UPDATE `users` SET `pOnline`='1' WHERE pName= '%s'",GetName(playerid));
mysql_query(string);
pInfo[playerid][pOnline] = 1;
GivePlayerMoney(playerid,pInfo[playerid][pMoney]);
SetPlayerScore(playerid,pInfo[playerid][pLevel]);
SetPlayerSkin(playerid,pInfo[playerid][pSkin]);
SpawnPlayer(playerid);
}
else
{
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Du hast dein Passwort falsch ein gegeben.\nGebe es nun neu ein.","Login","Abbrechen");
}
return 1;
}

[20:16:39]

[20:16:39] ---------------------------

[20:16:39] MySQL Debugging activated (01/09/14)

[20:16:39] ---------------------------

[20:16:39]

[20:17:04] >> mysql_query( Connection handle: 1 )
[20:17:04] CMySQLHandler::Query(SELECT * FROM `users` WHERE `pName`='aicej') - Successfully executed.
[20:17:04] >> mysql_store_result( Connection handle: 1 )
[20:17:04] CMySQLHandler::StoreResult() - Result was stored.
[20:17:04] >> mysql_num_rows( Connection handle: 1 )
[20:17:04] CMySQLHandler::NumRows() - Returned 1 row(s)
[20:17:07] >> mysql_query( Connection handle: 1 )
[20:17:07] CMySQLHandler::Query(SELECT * FROM `users` WHERE `pName` = 'aicej' AND `pPasswort` = 'tes') - Successfully executed.
[20:17:07] >> mysql_store_result( Connection handle: 1 )
[20:17:07] CMySQLHandler::StoreResult() - Result was stored.
[20:17:07] >> mysql_num_rows( Connection handle: 1 )
[20:17:07] CMySQLHandler::NumRows() - Returned 0 row(s)
[20:17:09] >> mysql_query( Connection handle: 1 )
[20:17:09] CMySQLHandler::Query(SELECT * FROM `users` WHERE `pName` = 'aicej' AND `pPasswort` = 'test') - Successfully executed.
[20:17:09] >> mysql_store_result( Connection handle: 1 )
[20:17:09] CMySQLHandler::StoreResult() - Result was stored.
[20:17:09] >> mysql_num_rows( Connection handle: 1 )
[20:17:09] CMySQLHandler::NumRows() - Returned 1 row(s)
[20:17:09] >> mysql_retrieve_row( Connection handle: 1 )
[20:17:09] >> mysql_fetch_field_row( Connection handle: 1 )