Se cierra el samp server al guardar mysql
#4

No la metas en el bucle, ponla despuйs de cada, pon este:
pawn Код:
GuardarCuenta( playerid )
{
    if( GetPVarInt( playerid, #Login ) == 1 )
    {
        new 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, # , # ) ;
        print("one");
        // ------------------------------------- //
        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, # , # ) ;
        }
        print("two");
        // ------------------------------------- //
        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, # , # ) ;
        print("three");

        // ------------------------------------- //
        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, # , # ) ;
        print("four");

        // ------------------------------------- //
        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, # , # ) ;
        print("five");
    }
    return 1;
}
Compila, y dime que imprime.
Reply


Messages In This Thread

Forum Jump:


Users browsing this thread: 2 Guest(s)