[Pawn] Help with mysql and data retrieving.

[cronoxliker]

Hey guys, Im building a gamemode mostly for learning, but i got stuck in faction systems y was following a tutorial but was on an old version and im having struggle getting it done, if someone can explainme what im doing wrong here...

Code:

stock LoadFactions(/* arguments */)

{

new query[400];

for(new i = 0; i < MAX_FACTIONS; i)

{

mysql_tquery(query, "SELECT * FROM Factions WHERE ID = %d", i);

new rows, fields;

cache_get_data(rows, fields);

if(rows)

{

Total_Factions_Created;

cache_get_value_int(0,"id",Factions[i][ID]);

cache_get_value_name(0,"name",Factions[i][Name]);

cache_get_value_name(0,"type",Factions[i][Type]);

cache_get_value_name(0,"Rank1",Factions[i][Rank1]);

cache_get_value_name(0,"Rank2",Factions[i][Rank2]);

cache_get_value_name(0,"Rank3",Factions[i][Rank3]);

cache_get_value_name(0,"Rank1",Factions[i][Rank4]);

}

printf("se cargaron: %d facciones\n", Total_Factions_Created);

}

return 1;

}

[Josh]

If you're getting ALL of the factions just do a SELECT * FROM, there's no need to specify ID.

tquery will call a callback (which you specify) where you do cache_ function calls there, the plugin won't know what to do there because you have no cache active.

[cronoxliker]

Any quick mysql data retrieving guide? im struggling with this, :/

[DeploYeR]

// under OnGameModeInit

mysql_tquery(mysql_connection// change this to yours, "SELECT * FROM `Factions`", "LoadFactions");





forward LoadFactions();

public LoadFactions()

{

new rows, fields;

cache_get_data( rows, fields, your conn handle );



if( rows )

{

for( new i = 0; i < rows; i )

{

cache_get_value_int(i,"id",Factions[i][ID]);

cache_get_value_name(i,"name",Factions[i][Name]);

cache_get_value_name(i,"type",Factions[i][Type]);

cache_get_value_name(i,"Rank1",Factions[i][Rank1]);

cache_get_value_name(i,"Rank2",Factions[i][Rank2]);

cache_get_value_name(i,"Rank3",Factions[i][Rank3]);

cache_get_value_name(i,"Rank1",Factions[i][Rank4]);

}

}

return (true);

}

[cronoxliker]

Cache_get_data looks like deprecated i swaped it with cache_get_value_index_int, now, how do i now if it works, i tried with printf but it returns nothing, any idea? thanks for the time guys!



my try to print the factions name=



CMD:printtest(playerid,params[])

{

new query[140];

for(new i = 0; i < MAX_FACTIONS; i)

{

format(query, sizeof(query),"SELECT * FROM Factions WHERE ID = %d",i);

mysql_tquery(g_SQL,query);

printf("%s\n", Factions[i][Name]);

}

return 1;

}

prints 30 empty rows (yes i know there are rows in the db)



thanks!

[Pinch]

Use cache_get_value_name

[cronoxliker]

If you're getting ALL of the factions just do a SELECT * FROM, there's no need to specify ID.

tquery will call a callback (which you specify) where you do cache_ function calls there, the plugin won't know what to do there because you have no cache active.

Use cache_get_value_name

I get -error 035: argument type mismatch (argument 2)- if i just leave the rows as parameter then it will compile but still print 30 blank lines on /printtest, i can upload and edit but i cant retrieve the data...



if needed i can pass all the related code.

[Pinch]

Because cache_get_value_index_int uses column's idx while cache_get_value_name uses literal string.

cache_get_value_name(row, "collumn_name", out);

Edit:
mysql_tquery(g_SQL,query);

I don't see a callback there....? Where were you using cache functions at all...?

[cronoxliker]

Because cache_get_value_index_int uses column's idx while cache_get_value_name uses literal string.



cache_get_value_name(row, "collumn_name", out);



Edit:

mysql_tquery(g_SQL,query);



I don't see a callback there....? Where were you using cache functions at all...?

this is my factions code, if u want i can provide the entire code, and the tutorial i read,?

Code:

enum faction

{

ID, //Facc ID

Name[32],

Type, //Type, criminal, law, legal no weapon, legal weapons.

Rank1[32], //Rank name

Rank2[32], //Rank name

Rank3[32], //Rank name

Rank4[32] //Rank name

};





//enum initializing

new Factions[MAX_FACTIONS][faction], Total_Factions_Created, facid[MAX_PLAYERS];



forward LoadFactions();

public LoadFactions()

{

new rows, fields;

cache_get_value_index_int(rows,fields,g_SQL);



if( rows )

{

for( new i = 0; i < rows; i  )

{

cache_get_value_int(i,"id",Factions[i][ID]);

cache_get_value_name(i,"name",Factions[i][Name]);

cache_get_value_name(i,"type",Factions[i][Type]);

cache_get_value_name(i,"Rank1",Factions[i][Rank1]);

cache_get_value_name(i,"Rank2",Factions[i][Rank2]);

cache_get_value_name(i,"Rank3",Factions[i][Rank3]);

cache_get_value_name(i,"Rank1",Factions[i][Rank4]);

}

}

return 1;

}



public OnGameModeInit()

{

new MySQLOpt: option_id = mysql_init_options();



mysql_set_option(option_id, AUTO_RECONNECT, true); // it automatically reconnects when loosing connection to mysql server

g_SQL = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, option_id); // AUTO_RECONNECT is enabled for this connection handle only

if (g_SQL == MYSQL_INVALID_HANDLE || mysql_errno(g_SQL) != 0)

{

print("MySQL connection failed. Server is shutting down.");

SendRconCommand("exit"); // close the server if there is no connection

return 1;

}



new query[103];

mysql_format(g_SQL, query, sizeof query,"SELECT * FROM Factions");

mysql_tquery(g_SQL, query, "LoadFactions");

print("MySQL connection is successful.");



SetTimer("MoneyTimer", 1000, 1);





return 1;

}



//working command



CMD:fcreate(playerid,params[])

{

new string[128], query[400], fname[32];

if(sscanf(params, "s[32]", fname)) return SendClientMessage(playerid,RED_COLOR,"USAGE: /fcreate factionname");

Total_Factions_Created;

//-----------------------------------

format(Factions[Total_Factions_Created][Name], 64,"%s", fname);

Factions[Total_Factions_Created][ID] = Total_Factions_Created;

//-----------------------------------



format(string, sizeof(string),"Creaste la faccion %s(ID:%d).",Factions[Total_Factions_Created][Name],Factions[Total_Factions_Created][ID]);

SendClientMessage(playerid, SYSTEM_COLOR, string);

//-----------------------------------



format(Factions[Total_Factions_Created][Rank1], 32, "Rank 1 - Lowest");

format(Factions[Total_Factions_Created][Rank2], 32, "Rank 2");

format(Factions[Total_Factions_Created][Rank3], 32, "Rank 3");

format(Factions[Total_Factions_Created][Rank4], 32, "Rank 4 - leader");





format(query, sizeof(query), "INSERT INTO `factions` (id, name, Rank1, Rank2, Rank3, Rank4) VALUES(%d,'%s','%s','%s','%s','%s')",

Factions[Total_Factions_Created][ID], Factions[Total_Factions_Created][Name], Factions[Total_Factions_Created][Rank1],

Factions[Total_Factions_Created][Rank2], Factions[Total_Factions_Created][Rank3], Factions[Total_Factions_Created][Rank4]);

mysql_tquery(g_SQL,query);

return 1;

}



//this one prints 30 empty lines

CMD:printtest(playerid,params[])

{

new query[140];

for(new i = 0; i < MAX_FACTIONS; i)

{

format(query, sizeof(query),"SELECT * FROM Factions WHERE ID = %d",i);

mysql_tquery(g_SQL,query);

printf("%s\n", Factions[i][Name]);

}

return 1;

}

[Pinch]

I don't wanna do everything from you because I see you understood nothing, I mean you literally have example scripts in the plugin's github.com repository...

[Expert*]

U replaced cache_get_data with cache_get_value_index_int.

What you want is:

new rows;
cache_get_row_count( rows );

field count is irelevent to you in this case, so we don't have to know how many we have...

Also use this:
cache_get_value_name_int(i,"id",Factions[i][ID]);

Instead of:
cache_get_value_int(i,"id",Factions[i][ID]);