Jump to content
  • 0

MySQL Data-Base Error

M.G_Master

Asked by M.G_Master,

 Share

Question

M.G_Master Apprentice

M.G_Master

Posted
Posted (edited)

Problema ( Descriere ) : Ma tot bantuie o eroare in MySQL Logs ( mysql_log.html ) de la ,, Personal Vehicles Sistem " .
Eroarea ( Error ) : ("LoadPersonalVehicleInfo");

                    Log("12:12:24","cache_get_field_content_int",1,"invalid datatype",0);
Liniile de cod sursa al script-ului :

Citat

SQL_Function LoadPersonalVehicleInfo( playerid )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 0 );

    new Field[ 25 ], Rows, Fields;
    cache_get_data( Rows, Fields, g_Handle );

    if( Rows )
    {
        PlayerInfo[ playerid ][ CarID ]      = cache_get_field_content_int( 0,"ID", g_Handle );
        PlayerInfo[ playerid ][ car_X ]      = cache_get_field_content_float( 0, "Veh_LocX", g_Handle );
        PlayerInfo[ playerid ][ car_Y ]      = cache_get_field_content_float( 0, "Veh_LocY", g_Handle );
        PlayerInfo[ playerid ][ car_Z ]      = cache_get_field_content_float( 0, "Veh_LocZ", g_Handle );
        PlayerInfo[ playerid ][ car_A ]      = cache_get_field_content_float( 0,"Veh_LocA", g_Handle );
        PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked", g_Handle );
        PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1", g_Handle );
        PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2", g_Handle );
        PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler", g_Handle );
        PlayerInfo[ playerid ][ neonid ]     = cache_get_field_content_int( 0, "Plate", g_Handle );

        cache_get_field_content( 0, "Plate", Field, g_Handle );
        format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

        PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
                                                                PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
                                                                PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
        SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

        if ( PlayerInfo[ playerid ][ neonid ] != 0 )
            OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

        if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
        Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
    }
    return ( 1 );
}


 

Imagini / Video : -
 

Ati incercat sa rezolvati singur ? : Yes , Sir .

P.S : Tiin sa va anunt ca Server-ul ruleaza in perfecta stare ( in conditii normale ) , fara nici o problema / bug ...

      Server Log-ul ( server_log.txt ) Server-ului este 100% curat , fara nici un Warnning / Error !

 

Citat

----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, (C)2005-2015 SA-MP Team

[12:10:42] 
[12:10:42] Server Plugins
[12:10:42] --------------
[12:10:42]  Loading plugin: [MGS]_Server-CrashDetect-Plugin.so
[12:10:42]   CrashDetect v4.15.1 is OK.
[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-xFile-Plugin.so
[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-Gvar-Plugin.so
[12:10:42] 

*** GVar Plugin v1.3 by Incognito loaded ***

[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-MySQLx-Plugin.so
[12:10:42]  >> plugin.mysql: R39-4 successfully loaded.
[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-SScanf-Plugin.so
[12:10:42] 

[12:10:42]  ===============================

[12:10:42]       sscanf plugin loaded.     

[12:10:42]          Version:  2.8.1        

[12:10:42]    (c) 2012 Alex "Y_Less" Cole  

[12:10:42]  ===============================

[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-Streamer-Plugin.so
[12:10:42] 

*** Streamer Plugin v2.7.9 by Incognito loaded ***

[12:10:42]   Loaded.
[12:10:42]  Loading plugin: [MGS]_Server-WhirlPool-Plugin.so
[12:10:42]  
[12:10:42]  ==================
[12:10:42]  
[12:10:42]   Whirlpool loaded
[12:10:42]  
[12:10:42]  ==================
[12:10:42]  
[12:10:42]   Loaded.
[12:10:42]  Loaded 7 plugins.

[12:10:42] 
[12:10:42] Filterscripts
[12:10:42] ---------------
[12:10:42]   Loading filterscript '[MGS]_Server-ClanBase-Object.amx'...
[12:10:42]   Loading filterscript '[MGS]_Server-GanGBase-Object.amx'...
[12:10:42]   Loading filterscript '[MGS]_Server-Maps-Objects_v01.amx'...
[12:10:43]   Loading filterscript '[MGS]_Server-PersonalsIslands-Objects.amx'...
[12:10:43]   Loaded 4 filterscripts.

[12:10:43]  
[12:10:43]  
[12:10:43]  
[12:10:43]  ======================================= 
[12:10:43]  |                                     | 
[12:10:43]  |        YSI version 3.09.0684        | 
[12:10:43]  |        By Alex "Y_Less" Cole        | 
[12:10:43]  |                                     | 
[12:10:43]  ======================================= 
[12:10:43]  
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ Master GaminG Stunt Server | phpMyAdmin : MySQL Data-Bases Connecting    ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Host ( 213.136.80.44 ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server User ( samp_servers ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server DBs  ( server01 )   ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Pass ( ************* ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Stat : ( +++++++++++ ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Maps : ( +++++++++++ ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server CMDs : ( +++++++++++ ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Logs : ( +++++++++++ ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Server Bans : ( +++++++++++ ) ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Loading ] ... ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Succes ] ...  ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Ready ] ...   ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ Done ] ...    ]=-::.
[12:10:43] .::-=[ phpMyAdmin : MySQL Data-Bases Connecting | Please Wait , [ OK ] ...      ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ Master GaminG Stunt Server | phpMyAdmin : MySQL Data-Bases Connecting    ]=-::.
[12:10:43] .::-=[--------------------------------------------------------------------------]=-::.
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Forbidden Names • ( 0 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Forbidden Tags • ( 0 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Forbidden Words • ( 0 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Forbidden CMDs • ( 0 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Hot Air Ballons • ( 4 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Started UP • ( 12:10:43 ) ON ( 13/03/2016 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Started UP • ( 1457871043 ) ON ( Epoch Timer ) « •
[12:10:43] Number of vehicle models: 39
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Houses • ( "1188" ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Properties • ( "107" ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Vehicles • ( "793" ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : Duels • ( "7" ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanGs • ( 7 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 1 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 2 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 3 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 4 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 5 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( 0 ) • ID • ( 6 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Name • ( Master GaminG GanG ) • ID • ( 7 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Teritories • ( 7 ) « •
[12:10:43] .::-=[ - Successfully -> Loaded => ]=-::. • » Master GaminG Stunt | Server : GanG Check-Point • ( 7 ) « •

 

Edited by M.G_Master
  • Upvote 1
Link to comment
Share on other sites

11 answers to this question

Recommended Posts

  • 0
kwnx Veteran

kwnx

Posted
Posted 
SQL_Function LoadPersonalVehicleInfo( playerid )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 0 );

    new Field[ 25 ], Rows, Fields;
    cache_get_data( Rows, Fields, g_Handle );

    if( Rows )
    {
        PlayerInfo[ playerid ][ CarID ]      = cache_get_field_content_int( 0,"ID" );
        PlayerInfo[ playerid ][ car_X ]      = cache_get_field_content_float( 0, "Veh_LocX" );
        PlayerInfo[ playerid ][ car_Y ]      = cache_get_field_content_float( 0, "Veh_LocY" );
        PlayerInfo[ playerid ][ car_Z ]      = cache_get_field_content_float( 0, "Veh_LocZ" );
        PlayerInfo[ playerid ][ car_A ]      = cache_get_field_content_float( 0,"Veh_LocA" );
        PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked" );
        PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1" );
        PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2" );
        PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler" );
        PlayerInfo[ playerid ][ neonid ]     = cache_get_field_content_int( 0, "Plate" );

        cache_get_field_content( 0, "Plate", Field, g_Handle );
        format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

        PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
                                                                PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
                                                                PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
        SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

        if ( PlayerInfo[ playerid ][ neonid ] != 0 )
            OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

        if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
        Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
    }
    return ( 1 );
}

 

  • Upvote 2

242086.png

Link to comment
Share on other sites
  • 0
M.G_Master Apprentice

M.G_Master

Posted
  • Author
Posted (edited)
1 oră în urmă, KnowN a spus: 

SQL_Function LoadPersonalVehicleInfo( playerid )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 0 );

    new Field[ 25 ], Rows, Fields;
    cache_get_data( Rows, Fields, g_Handle );

    if( Rows )
    {
        PlayerInfo[ playerid ][ CarID ]      = cache_get_field_content_int( 0,"ID" );
        PlayerInfo[ playerid ][ car_X ]      = cache_get_field_content_float( 0, "Veh_LocX" );
        PlayerInfo[ playerid ][ car_Y ]      = cache_get_field_content_float( 0, "Veh_LocY" );
        PlayerInfo[ playerid ][ car_Z ]      = cache_get_field_content_float( 0, "Veh_LocZ" );
        PlayerInfo[ playerid ][ car_A ]      = cache_get_field_content_float( 0,"Veh_LocA" );
        PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked" );
        PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1" );
        PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2" );
        PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler" );
        PlayerInfo[ playerid ][ neonid ]     = cache_get_field_content_int( 0, "Plate" );

        cache_get_field_content( 0, "Plate", Field, g_Handle );
        format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

        PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
                                                                PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
                                                                PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
        SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

        if ( PlayerInfo[ playerid ][ neonid ] != 0 )
            OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

        if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
        Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
    }
    return ( 1 );
}

 

Mdeah .

Eroarea de la ,, Personal Vehicles System " s-a rezolvat ...

Dar acum mi-au aparut niste erori de la functia ,, CheckAccountPassword " :))

Citat

StartCB("CheckAccountPassword");Log("16:39:10","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);
EndCB();StartCB("CheckAccountPassword");Log("16:39:19","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);
EndCB();StartCB("CheckAccountPassword");Log("16:39:39","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);
EndCB()

Nici nu ma mai lasa sa ma loghez pe server ...

Idei ?

Edited by M.G_Master
  • Upvote 2
Link to comment
Share on other sites
  • 0
kwnx Veteran

kwnx

Posted
Posted
1 hour ago, M.G_Master said:

Mdeah .

Eroarea de la ,, Personal Vehicles System " s-a rezolvat ...

Dar acum mi-au aparut niste erori de la functia ,, CheckAccountPassword " :))

Nici nu ma mai lasa sa ma loghez pe server ...

Idei ?

Da-mi funcția CheckAccountPassword.

242086.png

Link to comment
Share on other sites
  • 0
M.G_Master Apprentice

M.G_Master

Posted
  • Author
Posted (edited)
Spoiler

SQL_Function CheckAccountPassword( playerid, password[ ] )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 1 );

    new Login_Field[ 256 ], xxstring[512];

    cache_get_field_content( 0, "Password", Login_Field, g_Handle );

    if ( strmatch( password, Login_Field ) )
    {
        new LastOnline[ 256 ], RegisterDate[ 256 ];

        PlayerPlaySound(playerid,1057,0.0,0.0,0.0);

        format( gsQuery, 128, "UPDATE `MGS_Server_Accounts` SET `LoggedIn` = 1,`IP` = '%s',`Lang` = %d WHERE `Name` = '%s'", GetPlayerIPEx( playerid ), Lang[ playerid ], PlayerName( playerid ) );
        mysql_function_query( g_Handle, gsQuery, false, "", "" );
        //----------------------------- Loggin' Into Account -----------------//
        PlayerInfo[ playerid ][ LoggedIn ]             = 1;
        PlayerInfo[ playerid ][ AccID ]             = cache_get_field_content_int( 0, "Key", g_Handle );
        PlayerInfo[ playerid ][ pVip ]                 = cache_get_field_content_int( 0, "Vip", g_Handle );
        PlayerInfo[ playerid ][ Level ]             = cache_get_field_content_int( 0, "Level", g_Handle );
        PlayerInfo[ playerid ][ rVip ]                 = cache_get_field_content_int( 0, "rVip", g_Handle );
        PlayerInfo[ playerid ][ bKillingSpree ]     = cache_get_field_content_int( 0, "BestKillings", g_Handle );
        PlayerInfo[ playerid ][ KillingSpree ]         = cache_get_field_content_int( 0, "KillingSpree", g_Handle );
        PlayerInfo[ playerid ][ Drugs ]             = cache_get_field_content_int( 0, "Drugs", g_Handle );
        PlayerInfo[ playerid ][ Coins ]             = cache_get_field_content_int( 0, "Coins", g_Handle );
        PlayerInfo[ playerid ][ PosRespect ]         = cache_get_field_content_int( 0, "Positive", g_Handle );
         PlayerInfo[ playerid ][ NegRespect ]         = cache_get_field_content_int( 0, "Negative", g_Handle );
        PlayerInfo[ playerid ][ SAdmin ]             = cache_get_field_content_int( 0, "SAdmin", g_Handle );
        PlayerInfo[ playerid ][ FavSkin ]             = cache_get_field_content_int( 0, "FavSkin", g_Handle );
        PlayerInfo[ playerid ][ rank ]                 = cache_get_field_content_int( 0, "ClanRank", g_Handle );
        PlayerInfo[ playerid ][ c_points ]             = cache_get_field_content_int( 0, "ClanPoints", g_Handle );
        PlayerInfo[ playerid ][ c_deaths ]             = cache_get_field_content_int( 0, "ClanDeaths", g_Handle );
        PlayerInfo[ playerid ][ PKicks ]             = cache_get_field_content_int( 0, "Kicks", g_Handle );
        PlayerInfo[ playerid ][ PBans ]             = cache_get_field_content_int( 0, "Bans", g_Handle );
        PlayerInfo[ playerid ][ PJails ]             = cache_get_field_content_int( 0, "Jails", g_Handle );
        PlayerInfo[ playerid ][ PWarns ]             = cache_get_field_content_int( 0, "Warns", g_Handle );
        PlayerInfo[ playerid ][ PClearCH ]             = cache_get_field_content_int( 0, "ClearChats", g_Handle );
        PlayerInfo[ playerid ][ PReactions ]         = cache_get_field_content_int( 0, "ReactionTest", g_Handle );
        PlayerInfo[ playerid ][ PMaths ]             = cache_get_field_content_int( 0, "MathTest", g_Handle );
        PlayerInfo[ playerid ][ PMutes ]             = cache_get_field_content_int( 0, "Mutes", g_Handle );
        PlayerInfo[ playerid ][ Property ]             = cache_get_field_content_int( 0, "Property", g_Handle );
        PlayerInfo[ playerid ][ Jailed ]             = cache_get_field_content_int( 0, "Jailed", g_Handle );
        PlayerInfo[ playerid ][ Frozen ]             = cache_get_field_content_int( 0, "Frozen", g_Handle );
        PlayerInfo[ playerid ][ Kills ]             = cache_get_field_content_int( 0, "Kills", g_Handle );
        PlayerInfo[ playerid ][ Deaths ]             = cache_get_field_content_int( 0, "Deaths", g_Handle );
        PlayerInfo[ playerid ][ rAdmin ]             = cache_get_field_content_int( 0, "RAdmin", g_Handle );
        PlayerInfo[ playerid ][ D_Score ]             = cache_get_field_content_int( 0, "DuelScore", g_Handle );
        PlayerInfo[ playerid ][ Race_Score ]         = cache_get_field_content_int( 0, "RaceScore", g_Handle );
        PlayerInfo[ playerid ][ Stunt_Score ]         = cache_get_field_content_int( 0, "StuntScore", g_Handle );
        PlayerInfo[ playerid ][ Drift_Score ]         = cache_get_field_content_int( 0, "DriftScore", g_Handle );
        PlayerInfo[ playerid ][ CarID ]             = cache_get_field_content_int( 0, "OwnedCarID", g_Handle );
        PlayerInfo[ playerid ][ szOwnedHouseID ]     = cache_get_field_content_int( 0, "HouseID", g_Handle );
        PlayerInfo[ playerid ][ P_BANK_MONEY ]         = cache_get_field_content_int( 0, "BankMoney", g_Handle );
        Lang[ playerid ]                            = cache_get_field_content_int( 0, "Lang", g_Handle );
        Users[ playerid ][ gang ]                     = cache_get_field_content_int( 0, "GangID", g_Handle );
        Users[ playerid ][ g_Kills ]                 = cache_get_field_content_int( 0, "GangKills", g_Handle );
        Users[ playerid ][ g_Deaths ]                 = cache_get_field_content_int( 0, "GangDeaths", g_Handle );
        Users[ playerid ][ isLeader ]                 = cache_get_field_content_int( 0, "GangRank", g_Handle );
        Users[ playerid ][ g_Warns ]                 = cache_get_field_content_int( 0, "GangWarns", g_Handle );
        Users[ playerid ][ g_Captures ]             = cache_get_field_content_int( 0, "GangCaptures", g_Handle );
        Users[ playerid ][ g_Points ]                 = cache_get_field_content_int( 0, "GangPoints", g_Handle );
        PlayerInfo[ playerid ][ NoPM ]                 = cache_get_field_content_int( 0, "NoPM", g_Handle );
        PlayerInfo[ playerid ][ GotoIgnored ]         = cache_get_field_content_int( 0, "NoGoto", g_Handle );
        PlayerInfo[ playerid ][ Ignore_Spec ]         = cache_get_field_content_int( 0, "NoSpec", g_Handle );

        cache_get_field_content( 0, "E-Mail", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ EMail ], 128, "%s", Login_Field );

        SetPVarFloat( playerid, "vSpawn_X", cache_get_field_content_float( 0, "vSpawn_X", g_Handle ) );
        SetPVarFloat( playerid, "vSpawn_Y", cache_get_field_content_float( 0, "vSpawn_Y", g_Handle ) );
        SetPVarFloat( playerid, "vSpawn_Z", cache_get_field_content_float( 0, "vSpawn_Z", g_Handle ) );
        SetPVarFloat( playerid, "vSpawn_A", cache_get_field_content_float( 0, "vSpawn_A", g_Handle ) );

        ResetPlayerMoney( playerid );
        GivePlayerMoney( playerid, cache_get_field_content_int( 0, "Cash", g_Handle ) );
        SetPVarInt( playerid, "sMoney", cache_get_field_content_int( 0, "Cash", g_Handle ) );

        SetPlayerScore( playerid, cache_get_field_content_int( 0, "Score", g_Handle ) );

        cache_get_field_content( 0, "Online", Login_Field, g_Handle );
        sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ hours ],
                                        PlayerInfo[ playerid ][ mins ],
                                        PlayerInfo[ playerid ][ secs ] );

        cache_get_field_content( 0, "LastOn", LastOnline, g_Handle );
        cache_get_field_content( 0, "RegisterDate", RegisterDate, g_Handle );
        cache_get_field_content( 0, "Rank", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ RankName ], 25, Login_Field );

        cache_get_field_content( 0, "Description1", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ Description1 ], 128, "%s", Login_Field );

        cache_get_field_content( 0, "Description2", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ Description2 ], 128, "%s", Login_Field );

        cache_get_field_content( 0, "Description3", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ Description3 ], 128, "%s", Login_Field );

        cache_get_field_content( 0, "ClanJoined", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ JoinedInClan ], 50, Login_Field );

        cache_get_field_content( 0, "Clan", Login_Field, g_Handle );
        format( PlayerInfo[ playerid ][ Clan ], 25, "%s", Login_Field );

        cache_get_field_content( 0, "ClanOnline", Login_Field );
        sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ clan_H ], PlayerInfo[ playerid ][ clan_M ], PlayerInfo[ playerid ][ clan_S ] );

        cache_get_field_content( 0, "SavingSts", Login_Field, g_Handle );
        sscanf( Login_Field, "p<,>ii", PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ] );

        if ( PlayerInfo[ playerid ][ Jailed ] >= 1 )
        {
            cache_get_field_content( 0, "JailTime", Login_Field, g_Handle );
            sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] );
        }

        if ( PlayerInfo[ playerid ][ Frozen ] == 1 )
        {
            cache_get_field_content( 0, "FreezeTime", Login_Field, g_Handle );
            sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] );
        }
        if ( PlayerInfo[ playerid ][ CarID ] != 0 )
        {
            format( gsQuery, 128, "SELECT * FROM `MGS_Server_PersonalsVehicles` WHERE `Owner` = '%s'", PlayerName( playerid ) );
            mysql_function_query( g_Handle, gsQuery, true, "LoadPersonalVehicleInfo", "i", playerid );
        }

        if ( !strmatch( PlayerInfo[ playerid ][ Clan ], "None" ) )
        {
            format( gsQuery, 256, "SELECT * FROM `MGS_Server_Clans` WHERE `name` = '%s'", PlayerInfo[ playerid ][ Clan ] );
            mysql_function_query( g_Handle, gsQuery, true, "LoadClanDetails", "i", playerid );
        }

 

Edited by M.G_Master
Link to comment
Share on other sites
  • 0
M.G_Master Apprentice

M.G_Master

Posted
  • Author
Posted
Acum 19 ore, KnowN a spus:

Sterge acel g_Handle de la functia cache_get_field_content_int.

Done . 

Nu mai apare eroarea :

Citat

StartCB

("CheckAccountPassword");Log("16:39:10","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);
EndCB();StartCB("CheckAccountPassword");Log("16:39:19","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);
EndCB();StartCB("CheckAccountPassword");Log("16:39:39","CMySQLResult::GetRowDataByName()",1,"invalid row index ('0')",0);


EndCB()

Dar acum a revenit prima eroare :

Citat

StartCB

("LoadPersonalVehicleInfo");Log("17:17:12","cache_get_field_content_int",1,"invalid datatype",0);


EndCB()

Pareri / Idei ?

P.S: Functia ( SQL ) ,,LoadPersonalVehicleInfo" : [ Actuala ]

Spoiler

SQL_Function LoadPersonalVehicleInfo( playerid )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 0 );

    new Field[ 25 ], Rows, Fields;
    cache_get_data( Rows, Fields, g_Handle );

    if( Rows )
    {
        PlayerInfo[ playerid ][ CarID ]      = cache_get_field_content_int( 0,"ID" );
        PlayerInfo[ playerid ][ car_X ]      = cache_get_field_content_float( 0, "Veh_LocX", g_Handle );
        PlayerInfo[ playerid ][ car_Y ]      = cache_get_field_content_float( 0, "Veh_LocY", g_Handle );
        PlayerInfo[ playerid ][ car_Z ]      = cache_get_field_content_float( 0, "Veh_LocZ", g_Handle );
        PlayerInfo[ playerid ][ car_A ]      = cache_get_field_content_float( 0,"Veh_LocA", g_Handle );
        PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked" );
        PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1" );
        PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2" );
        PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler" );
        PlayerInfo[ playerid ][ neonid ]     = cache_get_field_content_int( 0, "Plate" );

        cache_get_field_content( 0, "Plate", Field, g_Handle );
        format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

        PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
                                                                PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
                                                                PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
        SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

        if ( PlayerInfo[ playerid ][ neonid ] != 0 )
            OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

        if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
        Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
    }
    return ( 1 );
}

 

Link to comment
Share on other sites
  • 0
kwnx Veteran

kwnx

Posted
Posted
On 14.03.2016 at 18:29, M.G_Master said:

Done . 

Nu mai apare eroarea :

Dar acum a revenit prima eroare :

Pareri / Idei ?

P.S: Functia ( SQL ) ,,LoadPersonalVehicleInfo" : [ Actuala ]

  Hide contents

SQL_Function LoadPersonalVehicleInfo( playerid )
{
    if ( !IsPlayerConnected( playerid ) )
        return ( 0 );

    new Field[ 25 ], Rows, Fields;
    cache_get_data( Rows, Fields, g_Handle );

    if( Rows )
    {
        PlayerInfo[ playerid ][ CarID ]      = cache_get_field_content_int( 0,"ID" );
        PlayerInfo[ playerid ][ car_X ]      = cache_get_field_content_float( 0, "Veh_LocX", g_Handle );
        PlayerInfo[ playerid ][ car_Y ]      = cache_get_field_content_float( 0, "Veh_LocY", g_Handle );
        PlayerInfo[ playerid ][ car_Z ]      = cache_get_field_content_float( 0, "Veh_LocZ", g_Handle );
        PlayerInfo[ playerid ][ car_A ]      = cache_get_field_content_float( 0,"Veh_LocA", g_Handle );
        PlayerInfo[ playerid ][ car_Locked ] = cache_get_field_content_int( 0, "car_Locked" );
        PlayerInfo[ playerid ][ car_color1 ] = cache_get_field_content_int( 0, "Veh_Color1" );
        PlayerInfo[ playerid ][ car_color2 ] = cache_get_field_content_int( 0, "Veh_Color2" );
        PlayerInfo[ playerid ][ spoilerid ]  = cache_get_field_content_int( 0, "Spoiler" );
        PlayerInfo[ playerid ][ neonid ]     = cache_get_field_content_int( 0, "Plate" );

        cache_get_field_content( 0, "Plate", Field, g_Handle );
        format( PlayerInfo[ playerid ][ car_plate ], 20, "%s", Field );

        PlayerInfo[ playerid ][ p_VehID ] = AddStaticVehicleEx( PlayerInfo[ playerid ][ CarID ],
                                                                PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], PlayerInfo[ playerid ][ car_A ],
                                                                PlayerInfo[ playerid ][ car_color1 ], PlayerInfo[ playerid ][ car_color2 ], 60 );

        format( VehicleOwner[ PlayerInfo[ playerid ][ p_VehID ] ], 25, "%s", PlayerName( playerid ) );
        SetVehicleNumberPlate( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ car_plate ] );

        if ( PlayerInfo[ playerid ][ neonid ] != 0 )
            OnDialogResponse( playerid, DIALOG_CAR_NEON, 1, PlayerInfo[ playerid ][ neonid ], "lol" );

        if ( PlayerInfo[ playerid ][ spoilerid ] != 0 )
            AddVehicleComponent( PlayerInfo[ playerid ][ p_VehID ], PlayerInfo[ playerid ][ spoilerid ] );

        format( gsString, 128, "%s{2AB22A}'s personal vehicle.", PlayerName( playerid ) );
        Player3DVehicleLabel[ playerid ] = CreateDynamic3DTextLabel( gsString, 0x33CCFFFF, PlayerInfo[ playerid ][ car_X ], PlayerInfo[ playerid ][ car_Y ], PlayerInfo[ playerid ][ car_Z ], 20 );
    }
    return ( 1 );
}

 

Sterge acel g_Handle din funcția cache_get_field_content_float

  • Upvote 1

242086.png

Link to comment
Share on other sites
  • 0
M.G_Master Apprentice

M.G_Master

Posted
  • Author
Posted
Acum 13 minute, KnowN a spus:

Sterge acel g_Handle din funcția cache_get_field_content_float

Am sters ...

Tot asa :

Citat

StartCB

("LoadPersonalVehicleInfo");Log("17:17:12","cache_get_field_content_int",1,"invalid datatype",0);


EndCB()

Alte pareri / idei ?

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.