expected token: "-string end-", but found "-identifier-"

Funkis · Gruodžio 9, 2014

stock LoadVehicle(playerid)
{
    new carData [ 6 ] , Float:posi [ 4 ] , Float:hp , Engine , Lights , Alarm, Doors, Bonnet, Boot, Objective;
    new tr = playerCar1 [ playerid ];
    new const Result:r = sql_query(sql, //310

        f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), //312
        QUERY_CACHED // cached naudoti kai imi duomenis iš mysql
    );

    sql_get_field_assoc(r, "savininkas", masina[ tr ][vSavininkas], MAX_PLAYER_NAME);
    masina[ tr ][ vehModel ] = sql_get_field_assoc_int(r, "modelis");
    masina[ tr ][ lock ] = (sql_get_field_assoc_int(r, "uzraktas"))?(true):(false);
    masina[ tr ][ Gas ] = sql_get_field_assoc_float(r, "degalai");
    masina[ tr ][ vehColor ][0] = sql_get_field_assoc_int(r, "spalva1");
    masina[ tr ][ vehColor ][1] = sql_get_field_assoc_int(r, "spalva2");
    masina[ tr ][ vehLastPos ][ 0 ] = sql_get_field_assoc_float(r, "posX");
    masina[ tr ][ vehLastPos ][ 1 ] = sql_get_field_assoc_float(r, "posY");
    masina[ tr ][ vehLastPos ][ 2 ] = sql_get_field_assoc_float(r, "posZ");
    masina[ tr ][ vehLastPos ][ 3 ] = sql_get_field_assoc_float(r, "posA");
    masina[ tr ][ vehKaina ] = sql_get_field_assoc_int(r, "kaina");
    masina[ tr ][ status ] = (sql_get_field_assoc_int(r, "statusas"))?(true):(false);
    masina[ tr ][ vehVariklis ] = sql_get_field_assoc_int(r, "variklis");
    masina[ tr ][ vehHealth ] = sql_get_field_assoc_float(r, "bukle");
    sql_get_field_assoc(r, "numeriai", masina[ tr ][vehNumber], 21);
    masina[ tr ][ vehRida ] = sql_get_field_assoc_float(r, "rida");
    masina[ tr ] ][ vehPaintjob ] = sql_get_field_assoc_int(r, "paintjob");
    masina[ tr ][ vehTech ] = sql_get_field_assoc_int(r, "technikine");
    masina[ tr ][ vehTechtime ] = sql_get_field_assoc_int(r, "techlaikas");

    playerCar1 [ playerid ] = CreateVehicle ( masina[ tr ][ vehModel ] ,  masina[ tr ][ vehLastPos ][ 0 ] ,  masina[ tr ][ vehLastPos ][ 1 ] ,  masina[ tr ][ vehLastPos ][ 2 ] ,  masina[ tr ][ vehLastPos ][ 3 ] , masina[ tr ][ vehColor ][0] , masina[ tr ][ vehColor ][1] , -1 ) ;
    return 1;
}

eilutės 310-312

dzeronimo · Gruodžio 9, 2014

new const Result:r = sql_query(sql, //310

f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), //312

Maybe here mistake ?

Papildau , bet tai skliaustu nera sql_query(sql, //310 ir kiek suprantu ten turi if("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), //312 buti ?

Redaguota Gruodžio 9, 2014, nario dzeronimo

Funkis · Gruodžio 10, 2014

ne, nes čia kuris yra, jis veikia:

	new const Result:r = sql_query(sql, 

		f("SELECT * FROM "MySQL_BUSINESS_TABLE" WHERE id = '%i'", id), 
		QUERY_CACHED // cached naudoti kai imi duomenis iš mysql
	);

new const Result:r = sql_query(sql, //310

f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), //312

Maybe here mistake ?

Papildau , bet tai skliaustu nera sql_query(sql, //310 ir kiek suprantu ten turi if("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), //312 buti ?

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), QUERY_CACHED);

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid)), QUERY_CACHED);

esmės nekeičia.

bebras · Gruodžio 10, 2014

Man atrodo radau...

Bandyk taip:

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED);

Mano teorijos paaiškinimas.

// Tavo "f" macro
#define f(%0) (format(g_szBuffer, sizeof g_szBuffer, %0), g_szBuffer) 


// Tavo kodas
new const Result:r = sql_query(sql, 
	f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid)), QUERY_CACHED);

// Tavo kodas pakeitus pagal define:
new const Result:r = sql_query(sql, (format(g_szBuffer, sizeof g_szBuffer, "SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'"), g_szBuffer), getPlayerName(playerid)), QUERY_CACHED);

Kai taip viską susidedi matosi, kad po "getPlayerName" yra du skliaustai "))", o tai yra vienu per daug.

Funkis · Gruodžio 10, 2014

vis tiek

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED);

ir pagal tavo tas pats:

GM\vehicle.gm(312) : error 001: expected token: "-string end-", but found "-identifier-"
GM\vehicle.gm(312) : warning 215: expression has no effect

xxxyiin · Gruodžio 10, 2014

parodyk MySQL_VEHICLES_TABLE define

Funkis · Gruodžio 10, 2014

parodyk MySQL_VEHICLES_TABLE define

#define MySQL_VEHICLE_TABLE "vehicles"

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLE_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED);

blogai define buvau pasirašęs... Bet dabar kiti išlindo:

    new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLE_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED); // 312

    sql_get_field_assoc(r, "savininkas", masina[ tr ][vSavininkas], MAX_PLAYER_NAME); // 314

GM\vehicle.gm(312) : error 035: argument type mismatch (argument 3)
GM\vehicle.gm(314) : warning 213: tag mismatch
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase


6 Errors.
GM\vehicle.gm(314) : error 032: array index out of bounds (variable "masina")
GM\vehicle.gm(330) : warning 215: expression has no effect
GM\vehicle.gm(330) : error 001: expected token: ";", but found "]"
GM\vehicle.gm(330) : error 029: invalid expression, assumed zero
GM\vehicle.gm(330) : error 029: invalid expression, assumed zero
GM\vehicle.gm(330) : fatal error 107: too many error messages on one line

Compilation aborted.[Finished in 4.3s with exit code 1]

Redaguota Gruodžio 10, 2014, nario Funkis

xxxyiin · Gruodžio 10, 2014

parodyk kaip sukuri 'masina' array ir visus jo enumus.

Funkis · Gruodžio 10, 2014

enum eVehicle

{

SQLID,

vehOwner[ MAX_PLAYER_NAME ],

vehModel,

Float:vehLastPos[4],

vehTune[13],

vehColor[2],

vehPaintjob,

vehKaina,

vehNumber[21],

Float:vehRida,

Float:Gas,

vehSign,

vehTech,

vehTechtime,

vehVariklis,

vehID,

bool:vehOwned,

bool:lock,

bool:status,

Float:vehHealth

}; new masina[MAX_VEHICLES][eVehicle];

xxxyiin · Gruodžio 10, 2014

nematau enume vSavininkas[MAX_PLAYER_NAME] kintamojo

Funkis · Gruodžio 10, 2014

Vis tiek tas 312

GM\vehicle.gm(312) : error 035: argument type mismatch (argument 3)


viskas tvarka.

Redaguota Gruodžio 10, 2014, nario Funkis

Kesa · Gruodžio 10, 2014

Vis tiek tas 312

GM\vehicle.gm(312) : error 035: argument type mismatch (argument 3)

Dabar Justas tau suvėlė, turi būt taip:

new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), QUERY_CACHED);

Funkis · Gruodžio 10, 2014

Jap, viskas tvarka, dėkui Yiin, Justai, kRego.

xxxyiin · Gruodžio 10, 2014

duokit man -rep ant šito pranešimo kas mano jog justas nemoka skript.

Redaguota Gruodžio 10, 2014, nario Yiin

Funkis · Gruodžio 10, 2014

e dok rep ...

lol. minus gavai. ir epic. such epic. kitos klaidos.

[07:06:45] [debug] Run time error 4: "Array index out of bounds"
[07:06:45] [debug]  Accessing element at negative index -1
[07:06:45] [debug] AMX backtrace:
[07:06:45] [debug] #0 0002e6e0 in ?? () from GM.amx
[07:06:45] [debug] #1 0003bdb0 in ?? () from GM.amx
[07:06:45] [debug] #2 0003bd40 in public @yC_krautiv () from GM.amx
[07:06:45] [debug] #3 native CallRemoteFunction () [00472b40] from samp-server.exe
[07:06:45] [debug] #4 000134b8 in ?? () from GM.amx
[07:06:45] [debug] #5 00012dec in ?? () from GM.amx
[07:06:45] [debug] #6 00006500 in public OnPlayerCommandText () from GM.amx

stock LoadVehicle(playerid)
{
    //new carData [ 6 ] , Float:posi [ 4 ] , Float:hp;
    new tr = playerCar1 [ playerid ];
    //new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), QUERY_CACHED);

    //new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLE_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED); // 312
    new const Result:r = sql_query(sql, 

        f("SELECT * FROM "MySQL_VEHICLE_TABLE"WHERE savininkas = '%s'", getPlayerName(playerid)), 
        QUERY_CACHED // cached naudoti kai imi duomenis iš mysql
    );

    sql_get_field_assoc(r, "savininkas", masina[ tr ][vehOwner], MAX_PLAYER_NAME); // 314
    masina[ tr ][ vehModel ] = sql_get_field_assoc_int(r, "modelis");
    masina[ tr ][ lock ] = (sql_get_field_assoc_int(r, "uzraktas"))?(true):(false);
    masina[ tr ][ Gas ] = sql_get_field_assoc_float(r, "degalai");
    masina[ tr ][ vehColor ][0] = sql_get_field_assoc_int(r, "spalva1");
    masina[ tr ][ vehColor ][1] = sql_get_field_assoc_int(r, "spalva2");
    masina[ tr ][ vehLastPos ][ 0 ] = sql_get_field_assoc_float(r, "posX");
    masina[ tr ][ vehLastPos ][ 1 ] = sql_get_field_assoc_float(r, "posY");
    masina[ tr ][ vehLastPos ][ 2 ] = sql_get_field_assoc_float(r, "posZ");
    masina[ tr ][ vehLastPos ][ 3 ] = sql_get_field_assoc_float(r, "posA");
    masina[ tr ][ vehKaina ] = sql_get_field_assoc_int(r, "kaina");
    masina[ tr ][ status ] = (sql_get_field_assoc_int(r, "statusas"))?(true):(false);
    masina[ tr ][ vehVariklis ] = sql_get_field_assoc_int(r, "variklis");
    masina[ tr ][ vehHealth ] = sql_get_field_assoc_float(r, "bukle");
    sql_get_field_assoc(r, "numeriai", masina[ tr ][vehNumber], 21);
    masina[ tr ][ vehRida ] = sql_get_field_assoc_float(r, "rida");
    masina[ tr ][ vehPaintjob ] = sql_get_field_assoc_int(r, "paintjob");
    masina[ tr ][ vehTech ] = sql_get_field_assoc_int(r, "technikine");
    masina[ tr ][ vehTechtime ] = sql_get_field_assoc_int(r, "techlaikas");

    playerCar1 [ playerid ] = CreateVehicle ( masina[ tr ][ vehModel ] ,  masina[ tr ][ vehLastPos ][ 0 ] ,  masina[ tr ][ vehLastPos ][ 1 ] ,  masina[ tr ][ vehLastPos ][ 2 ] ,  masina[ tr ][ vehLastPos ][ 3 ] , masina[ tr ][ vehColor ][0] , masina[ tr ][ vehColor ][1] , -1 ) ;
    SetVehicleParamsEx ( playerCar1 [ playerid ], masina[ tr ][ vehVariklis ], false, false, false, false, false, false ) ;
    SetVehicleHealth(playerCar1 [ playerid ], masina[ tr ][ vehHealth ]);
    return 1;
}

mysql log

[07:06:44][debug] Natives::sql_query: Executing statement (stmt->id = 42, stmt->query = SELECT * FROM vehiclesWHERE savininkas = 'Iam_Satan')...
[07:06:45][debug] Natives::sql_query: Executing statement callback (stmt->id = 42, stmt->error = 1064, stmt->callback = )...
[07:06:45][debug] ProccessTick: Erasing query (stmt->id = 42)...

Redaguota Gruodžio 10, 2014, nario Funkis

bebras · Gruodžio 10, 2014

new tr = playerCar1 [ playerid ];

Ar jis yra -1?

Funkis · Gruodžio 10, 2014

new tr = playerCar1 [ playerid ];

Ar jis yra -1?

jap, onplayerc ir onplayerd nustatau reikšmę į -1

Kesa · Gruodžio 10, 2014

Tai gal pirmiau sukurk mašiną, poto jos kintamuosiusi nustatinėk..

Funkis · Gruodžio 10, 2014

Tai gal pirmiau sukurk mašiną, poto jos kintamuosiusi nustatinėk..

stock LoadVehicle(playerid)
{
    //new carData [ 6 ] , Float:posi [ 4 ] , Float:hp;
    new tr = playerCar1 [ playerid ];
    //new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLES_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), QUERY_CACHED);

    //new const Result:r = sql_query(sql, f("SELECT * FROM "MySQL_VEHICLE_TABLE" WHERE savininkas = '%s'"), getPlayerName(playerid), QUERY_CACHED); // 312
    new const Result:r = sql_query(sql, 

        f("SELECT * FROM "MySQL_VEHICLE_TABLE" WHERE savininkas = '%s'", getPlayerName(playerid)), 
        QUERY_CACHED // cached naudoti kai imi duomenis iš mysql
    );

    sql_get_field_assoc(r, "savininkas", masina[ tr ][vehOwner], MAX_PLAYER_NAME); // 314
    masina[ tr ][ vehModel ] = sql_get_field_assoc_int(r, "modelis");
    masina[ tr ][ lock ] = (sql_get_field_assoc_int(r, "uzraktas"))?(true):(false);
    masina[ tr ][ Gas ] = sql_get_field_assoc_float(r, "degalai");
    masina[ tr ][ vehColor ][0] = sql_get_field_assoc_int(r, "spalva1");
    masina[ tr ][ vehColor ][1] = sql_get_field_assoc_int(r, "spalva2");
    masina[ tr ][ vehLastPos ][ 0 ] = sql_get_field_assoc_float(r, "posX");
    masina[ tr ][ vehLastPos ][ 1 ] = sql_get_field_assoc_float(r, "posY");
    masina[ tr ][ vehLastPos ][ 2 ] = sql_get_field_assoc_float(r, "posZ");
    masina[ tr ][ vehLastPos ][ 3 ] = sql_get_field_assoc_float(r, "posA");
    
    playerCar1 [ playerid ] = CreateVehicle ( masina[ tr ][ vehModel ] ,  masina[ tr ][ vehLastPos ][ 0 ] ,  masina[ tr ][ vehLastPos ][ 1 ] ,  masina[ tr ][ vehLastPos ][ 2 ] ,  masina[ tr ][ vehLastPos ][ 3 ] , masina[ tr ][ vehColor ][0] , masina[ tr ][ vehColor ][1] , -1 ) ;
    
    masina[ tr ][ vehKaina ] = sql_get_field_assoc_int(r, "kaina");
    masina[ tr ][ status ] = (sql_get_field_assoc_int(r, "statusas"))?(true):(false);
    masina[ tr ][ vehVariklis ] = sql_get_field_assoc_int(r, "variklis");
    masina[ tr ][ vehHealth ] = sql_get_field_assoc_float(r, "bukle");
    sql_get_field_assoc(r, "numeriai", masina[ tr ][vehNumber], 21);
    masina[ tr ][ vehRida ] = sql_get_field_assoc_float(r, "rida");
    masina[ tr ][ vehPaintjob ] = sql_get_field_assoc_int(r, "paintjob");
    masina[ tr ][ vehTech ] = sql_get_field_assoc_int(r, "technikine");
    masina[ tr ][ vehTechtime ] = sql_get_field_assoc_int(r, "techlaikas");

    SetVehicleParamsEx ( playerCar1 [ playerid ], masina[ tr ][ vehVariklis ], false, false, false, false, false, false ) ;
    SetVehicleHealth(playerCar1 [ playerid ], masina[ tr ][ vehHealth ]);
    return 1;
}

Redaguota Gruodžio 10, 2014, nario Funkis

Kesa · Gruodžio 10, 2014

Dar sykį perskaityk ką parašiau, nes dabar tu puse kintamūjų nustatai prieš sukūrimą, o kitą pusę po sukūrimo.

Prisijungti

expected token: "-string end-", but found "-identifier-"

Recommended Posts

Funkis

dzeronimo

Funkis

bebras

Funkis

xxxyiin

Funkis

xxxyiin

Funkis

xxxyiin

Funkis

Kesa

Funkis

xxxyiin

Funkis

bebras

Funkis

Kesa

Funkis

Kesa

Prisijungti prie diskusijos

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member

Nustatymai

Populiariausi nariai

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

📝 Referatai, konspektai, kursiniai ir kt. rašto darbai ✏️

Naujienos

Bendruomenė

Prisijungti

expected token: "-string end-", but found "-identifier-"

Recommended Posts

Prisijungti prie diskusijos

Šiame puslapyje naršo: 0 nariai

Skelbimai

Naujausios temos

Naujausi būsenos atnaujinimai Nustatymai Teksto formatavimas Nario nuotrauka Member Išsaugoti

Nustatymai

Populiariausi nariai

Naujausi būsenos atnaujinimai

Nustatymai

Teksto formatavimas

Nario nuotrauka

Member