@D3D
well its hard for me to put a demo together, because I don't know HOW to do it
you can't test something if you just don't know how
but here are some more information:
this is the GSTsqlite version of the code:
Code:
str_cpy(temp_string3,"Select * from Charaktere where Account = ");
str_cat(temp_string3,str_bearb); // str_bearb contains the account-ID
query_handle = GSTsqlite_ExecuteQuery(data_handle,temp_string3);
while(!GSTsqlite_EOF(query_handle))
{
str_cat(str_info,"&");
GSTsqlite_GetString(query_handle,"CharName", str_bearb);
str_cat(str_info,str_bearb);
str_cat(str_info,"&");
GSTsqlite_GetInteger(query_handle,"Charakter", temp);
str_for_num(str_bearb,temp);
str_cat(str_info,str_bearb);
str_cat(str_info,"&");
GSTsqlite_GetInteger(query_handle,"Groesse", GSTsqlite_VarResult);
str_for_num(str_bearb,GSTsqlite_VarResult);
str_cat(str_info,str_bearb);
str_cat(str_info,"&");
GSTsqlite_GetInteger(query_handle,"Red", GSTsqlite_VarResult);
str_for_num(str_bearb,GSTsqlite_VarResult);
str_cat(str_info,str_bearb);
str_cat(str_info,"&");
GSTsqlite_GetInteger(query_handle,"Green", GSTsqlite_VarResult);
str_for_num(str_bearb,GSTsqlite_VarResult);
str_cat(str_info,str_bearb);
str_cat(str_info,"&");
GSTsqlite_GetInteger(query_handle,"Blue", GSTsqlite_VarResult);
str_for_num(str_bearb,GSTsqlite_VarResult);
str_cat(str_info,str_bearb);
GSTsqlite_NextRow(query_handle);
}
GSTNet_ServerSend(vSender, 12, str_info);
how it works: the server wants to send the character infos to the client. it opens the database and select the characters with the same account-ID.
now, the server is on the first row. it's reading all character infos and put them into a string, that will be send to the client.
that will look like that (the first number is the account ID) "1&Franz&2&1&100&200&100"
then, the server goes to the next row, reading the next character of the account. the string will look like that:
1&Franz&2&1&100&200&100&Hans&1&3&50&255&100"
and it goes on and on and on.
TILL it comes to the last row. if the server got to the last row, it will stop the while and send the information to the client.
ok, how to do that with mysql?
I heard that the query commands also returns information, like the "count(*)" command. but the plugin only returns "1" or "0".
also, the problem is easy to describe:
I want to read out of the database information that is more than in one row and I don't know how much rows it will have.
hope that explains it a little more
P.s.: I'm Using A6, so no lite-c
