10.06.2013, 12:24
Hola a toda la comunidad,bueno aca andamos con el mysql con algunos problemas xD
Al guardar las cuentas se me cae el servidor D: (se cierra el samp server)Observe el log pero no me da ninguna pista sobre que podia estar causandolo.
Si alguien me dice cual es mi error le estare agradecido (aunque yo pensaba que era el Consulta[256] que el valor era pequeсo aun asi agregando mas no funciono)
Bueno aqui el codigo.
Gracias desde ya.
Al guardar las cuentas se me cae el servidor D: (se cierra el samp server)Observe el log pero no me da ninguna pista sobre que podia estar causandolo.
Si alguien me dice cual es mi error le estare agradecido (aunque yo pensaba que era el Consulta[256] que el valor era pequeсo aun asi agregando mas no funciono)
Bueno aqui el codigo.
pawn Код:
GuardarCuenta( playerid )
{
if( GetPVarInt( playerid, #Login ) == 1 )
{
static
Consulta [ 256 ];
GetPlayerPos( playerid, PlayerInfo[ playerid ][ Pos ][ 0 ], PlayerInfo[ playerid ][ Pos ][ 1 ], PlayerInfo[ playerid ][ Pos ][ 2 ] ) ,
GetPlayerFacingAngle( playerid, PlayerInfo[ playerid ][ Pos ][ 3 ] ) ,
GetPlayerHealth( playerid, PlayerInfo[ playerid ][ Vida ] ) ,
GetPlayerArmour( playerid, PlayerInfo[ playerid ][ Chaleco ] ) ,
PlayerInfo[ playerid ][ Dinero ] = GetPlayerMoney ( playerid ) ,
PlayerInfo[ playerid ][ Interior ] = GetPlayerInterior ( playerid ) ,
PlayerInfo[ playerid ][ VirWorld ] = GetPlayerVirtualWorld ( playerid ) ;
// ------------------------------------- //
mysql_format( ConnectionHandle, Consulta, "UPDATE `users` SET Password='%s', PosX=%.4f, PosY=%.4f, PosZ=%.4f, Ang=%.4f, Vida=%.2f, Chaleco=%.2f WHERE `Nombre` = '%s' AND `ID_User` = '%i';", PlayerInfo[ playerid ][ Password ], PlayerInfo[ playerid ][ Pos ][ 0 ],
PlayerInfo[ playerid ][ Pos ][ 1 ], PlayerInfo[ playerid ][ Pos ][ 2 ], PlayerInfo[ playerid ][ Pos ][ 3 ], PlayerInfo[ playerid ][ Vida ], PlayerInfo[ playerid ][ Chaleco ], GetPName( playerid ), PlayerInfo[ playerid ][ pID ] );
mysql_function_query( ConnectionHandle , Consulta , false, # , # ) ;
// ------------------------------------- //
for( new i; i<13; i++ ) {
GetPlayerWeaponData( playerid, i, PlayerInfo[ playerid ][ Armas ][ i ], PlayerInfo[ playerid ][ Municiones ][ i ] );
mysql_format( ConnectionHandle, Consulta, "UPDATE `users` SET Arma_%i=%i, Municion_%i=%i WHERE `Nombre` = '%s' AND `ID_User` = '%i';", i, PlayerInfo[ playerid ][ Armas ][ i ], PlayerInfo[ playerid ][ Municiones ][ i ], GetPName( playerid ), PlayerInfo[ playerid ][ pID ] );
mysql_function_query( ConnectionHandle , Consulta , false, # , # ) ;
}
// ------------------------------------- //
mysql_format( ConnectionHandle, Consulta, "UPDATE `users` SET Skin=%i, Dinero=%i, Interior=%i, VirWorld=%i ,NivelAdmin=%i ,Tutorial=%i ,Sexo=%i ,Edad=%i WHERE `Nombre` = '%s' AND `ID_User` = '%i';", PlayerInfo[ playerid ][ Skin ], PlayerInfo[ playerid ][ Dinero ], PlayerInfo[ playerid ][ Interior ], PlayerInfo[ playerid ][ VirWorld ],PlayerInfo[ playerid ][ Admin] ,PlayerInfo[ playerid ][ HizoTuto],PlayerInfo[ playerid ][Sexo],PlayerInfo[ playerid ][Edad],GetPName( playerid ),
PlayerInfo[ playerid ][ pID ]);
mysql_function_query( ConnectionHandle , Consulta , false, # , # ) ;
// ------------------------------------- //
mysql_format( ConnectionHandle, Consulta, "UPDATE `users` SET Faccion=%i ,Trabajo=%i ,Encendedor=%i ,Cigarros=%i , Banco=%i ,Nivel=%i ,Experiencia=%i WHERE `Nombre` = '%s' AND `ID_User` = '%i';",PlayerInfo[ playerid ][Faccion],PlayerInfo[ playerid ][Trabajo],PlayerInfo[ playerid ][Encendedor],PlayerInfo[ playerid ][Cigarros],PlayerInfo[ playerid ][Banco],PlayerInfo[ playerid ][Nivel],PlayerInfo[ playerid ][Experiencia], GetPName( playerid ),
PlayerInfo[ playerid ][ pID ]);
mysql_function_query( ConnectionHandle , Consulta , false, # , # ) ;
// ------------------------------------- //
mysql_format( ConnectionHandle, Consulta, "UPDATE `users` SET Payday=%i ,TiempoConeccion=%i,Jaileado=%i,TiempoJail=%i,Estrellas=%i WHERE `Nombre` = '%s' AND `ID_User` = '%i';",PlayerInfo[ playerid ][Payday] ,PlayerInfo[ playerid ][TiempoConectado],PlayerInfo[ playerid ][Jaileado],PlayerInfo[ playerid ][TiempoJail],PlayerInfo[ playerid ][Estrellas], GetPName( playerid ),
PlayerInfo[ playerid ][ pID ]);
mysql_function_query( ConnectionHandle , Consulta , false, # , # ) ;
}
return 1;
}
) dentro del bucle.
