13.08.2009, 14:48
I have done the check for owner of the house and it suppoust to return me the owners name of the house, but it only returns me the first letter of the name, some random symbol and than the last letter of the name.
There is a code:
But i done another check for a car using the same code ant it works:
Where is the problem? What did i missed out?
There is a code:
Код:
new uhousesquery[128];
new userhouse[13][10];
new uhousesn;
format(uhousesquery, sizeof(uhousesquery), "SELECT id,owner,buyprice,sellprice,interior,virtualworld,locked,icon_x,icon_y,icon_z,spawn_x,spawn_y,spawn_z FROM `uhouses`");
samp_mysql_query(uhousesquery);
samp_mysql_store_result();
while(samp_mysql_fetch_row(uhousesquery)) {
split(uhousesquery, userhouse, '|');
//format(playerhouse[uhousesn][house_uniqueid],256,"%s",userhouse[0]);
playerhouse[uhousesn][house_uniqueid] = strval(userhouse[0]);
format(playerhouse[uhousesn][house_owner],256,"%s",userhouse[1]);
playerhouse[uhousesn][house_buy] = strval(userhouse[2]);
playerhouse[uhousesn][house_sell] = strval(userhouse[3]);
playerhouse[uhousesn][house_interior] = strval(userhouse[4]);
playerhouse[uhousesn][house_virtualworld] = strval(userhouse[5]);
playerhouse[uhousesn][house_locked] = strval(userhouse[6]);
playerhouse[uhousesn][house_iconX] = floatstr(userhouse[7]);
playerhouse[uhousesn][house_iconY] = floatstr(userhouse[8]);
playerhouse[uhousesn][house_iconZ] = floatstr(userhouse[9]);
playerhouse[uhousesn][house_spawnX] = floatstr(userhouse[10]);
playerhouse[uhousesn][house_spawnY] = floatstr(userhouse[11]);
playerhouse[uhousesn][house_spawnZ] = floatstr(userhouse[12]);
//if(!strcmp(playerhouse[uhousesn][house_owner],"niekas",true)) {
// playerhousepickup[uhousesn] = CreatePickup(1273,2,playerhouse[uhousesn][house_iconX],playerhouse[uhousesn][house_iconY],playerhouse[uhousesn][house_iconZ]);
//} else {
playerhousepickup[uhousesn] = CreatePickup(1272,2,playerhouse[uhousesn][house_iconX],playerhouse[uhousesn][house_iconY],playerhouse[uhousesn][house_iconZ]);
//}
uhousesn++;
}
public OnPlayerPickUpPickup(playerid, pickupid) {
for (uhousesn=0;uhousesn<MAX_HOUSES; uhousesn++) {
if (pickupid == playerhousepickup[uhousesn]) {
new ownermessage[70];
format(ownermessage,sizeof(ownermessage), "|SERVERIS|: Namai priklauso pilieиiui vardu %s.", playerhouse[uhousesn][house_owner]);
SendClientMessage(playerid,COLOR_SERVER,ownermessage);
}
}
return 1;
}
Код:
new ucarsquery[128];
new usercar[12][10];
new ucarsn;
format(ucarsquery, sizeof(ucarsquery), "SELECT id,owner,modelid,spawn_x,spawn_y,spawn_z,angle,color1,color2,health,tune,locked FROM `ucars`");
samp_mysql_query(ucarsquery);
samp_mysql_store_result();
while(samp_mysql_fetch_row(ucarsquery)) {
split(ucarsquery, usercar, '|');
format(playercar[ucarsn][car_uniqueid],256,"%s",usercar[0]);
format(playercar[ucarsn][car_owner],256,"%s",usercar[1]);
playercar[ucarsn][car_modelid] = strval(usercar[2]);
playercar[ucarsn][car_spawnX] = floatstr(usercar[3]);
playercar[ucarsn][car_spawnY] = floatstr(usercar[4]);
playercar[ucarsn][car_spawnZ] = floatstr(usercar[5]);
playercar[ucarsn][car_spawnA] = floatstr(usercar[6]);
playercar[ucarsn][car_color1] = strval(usercar[7]);
playercar[ucarsn][car_color2] = strval(usercar[8]);
playercar[ucarsn][car_health] = floatstr(usercar[9]);
playercar[ucarsn][car_tune] = strval(usercar[10]);
playercar[ucarsn][car_locked] = strval(usercar[11]);
playercar[ucarsn][car_id] = CreateVehicle(playercar[ucarsn][car_modelid],playercar[ucarsn][car_spawnX],playercar[ucarsn][car_spawnY],playercar[ucarsn][car_spawnZ],playercar[ucarsn][car_spawnA],playercar[ucarsn][car_color1],playercar[ucarsn][car_color2],-1);
SetVehicleHealth(playercar[ucarsn][car_id],playercar[ucarsn][car_health]);
ucarsn++;
}
public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger) {
for (new ucarsn=0;ucarsn<MAX_CARS; ucarsn++) {
if (vehicleid == playercar[ucarsn][car_id]) {
if (playerinfo[playerid][nickname] != playercar[ucarsn][car_owner]) {
new ownermessage[80];
format(ownermessage, sizeof(ownermessage), "|SERVERIS|: Maрina priklauso pilieиiui vardu %s.", playercar[ucarsn][car_owner]);
SendClientMessage(playerid, COLOR_SERVER, ownermessage);
}
}
}
return 1;
}