Mod:MojMod od 0
Problem:Kako citati iz Querrya
Skripta-//-
Slika/Video
[Pomoc]Citanje iz Querrya
783
pregleda
9
postova
3. Jul 2011.
evo ti primjer
i onda moras ovako raditi:
format(Query, sizeof(Query), "SELECT * FROM `Igraci` WHERE `Korisnik` = '%s' AND `Password` = '%s'", Ime(playerid), password);
mysql_query(Query);i onda moras ovako raditi:
new string;
if(mysql_fetch_row(string))
{
new info;
sscanf(line, "p<|>sdf", ime, broj, float);
//postavljas varijablu... npr:
SetPVarInt(playerid, "Level", broj);
}3. Jul 2011.
mozes, ali moras ovo koristiti:
i onda evo primjer:
public split(const strsrc[], strdest[][], delimiter)
{
new i, li;
new aNum;
new len;
while(i <= strlen(strsrc)){
if(strsrc==delimiter || i==strlen(strsrc)){
len = strmid(strdest, strsrc, li, i, 128);
strdest = 0;
li = i+1;
aNum++;
}
i++;
}
return 1;
}i onda evo primjer:
new Delimit;
new stringFile;
split(stringFile, Delimit, '|');
strmid(nekoime, Delimit, 0, strlen(Delimit), 255);3. Jul 2011.
Evo ovako:
public split(const strsrc[], strdest[][], delimiter)
{
new i, li;
new aNum;
new len;
while(i <= strlen(strsrc)){
if(strsrc==delimiter || i==strlen(strsrc)){
len = strmid(strdest, strsrc, li, i, 12😎;
strdest = 0;
li = i+1;
aNum++;
}
i++;
}
return 1;
}
//==================Na login callbacku kako se vec zove "OnPlayerLogin..."=================
format(Query, sizeof(Query), "SELECT * FROM `Igraci` WHERE `Korisnik` = '%s' AND `Password` = '%s'", Ime(playerid), password);
mysql_query(Query);
new string;
if(mysql_fetch_row(string))
{
new Delimit;
new stringFile;
split(stringFile, Delimit, '|');/* --------------------SVE MORA BITI PO REDU, BROJAC UVIJEK POCINJE OD NULE ( 0 ) */
SetPVarInt(playerid, "Novac", Delimit);
SetPVarInt(playerid, "Level", Delimit);
SetPVarString(playerid, "Password", Delimit, sizeof(Delimit));
SetPVarInt(playerid, "Banka", Delimit);
//---------------samo nastavis na ovaj fazon je sve....------------------
}
public split(const strsrc[], strdest[][], delimiter)
{
new i, li;
new aNum;
new len;
while(i <= strlen(strsrc)){
if(strsrc==delimiter || i==strlen(strsrc)){
len = strmid(strdest, strsrc, li, i, 12😎;
strdest = 0;
li = i+1;
aNum++;
}
i++;
}
return 1;
}
//==================Na login callbacku kako se vec zove "OnPlayerLogin..."=================
format(Query, sizeof(Query), "SELECT * FROM `Igraci` WHERE `Korisnik` = '%s' AND `Password` = '%s'", Ime(playerid), password);
mysql_query(Query);
new string;
if(mysql_fetch_row(string))
{
new Delimit;
new stringFile;
split(stringFile, Delimit, '|');/* --------------------SVE MORA BITI PO REDU, BROJAC UVIJEK POCINJE OD NULE ( 0 ) */
SetPVarInt(playerid, "Novac", Delimit);
SetPVarInt(playerid, "Level", Delimit);
SetPVarString(playerid, "Password", Delimit, sizeof(Delimit));
SetPVarInt(playerid, "Banka", Delimit);
//---------------samo nastavis na ovaj fazon je sve....------------------
}
Morate biti prijavljeni da biste odgovorili na ovu temu.
Prijava