[Pawn] Help with mysql and data retrieving.

[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;

}