HypCosmin

pc LoadFurnitures() { new Cache: db = mysql_query(handle, "SELECT * FROM `fobjects` ORDER BY `fobjects`.`ID` ASC"); new objects = 0, result[180]; for(new i, j = cache_num_rows (); i != j; ++i) { objects ++; cache_get_value_name_int(i, "ID", FurnitureInfo[i][fiID]); cache_get_value_name_int(i, "Model", FurnitureInfo[i][fiModel]); cache_get_value_name_float(i, "X", FurnitureInfo[i][fiX]); cache_get_value_name_float(i, "Y", FurnitureInfo[i][fiY]); cache_get_value_name_float(i, "Z", FurnitureInfo[i][fiZ]); cache_get_value_name_float(i, "RotX", FurnitureInfo[i][fiRotX]); cache_get_value_name_float(i, "RotY", FurnitureInfo[i][fiRotY]); cache_get_value_name_float(i, "RotZ", FurnitureInfo[i][fiRotZ]); cache_get_value_name_int(i, "Virtual", FurnitureInfo[i][fiVirtual]); cache_get_value_name_int(i, "House", FurnitureInfo[i][fiHouse]); FurnitureInfo[i][fiObject] = CreateDynamicObject(FurnitureInfo[i][fiModel], FurnitureInfo[i][fiX], FurnitureInfo[i][fiY], FurnitureInfo[i][fiZ], FurnitureInfo[i][fiRotX], FurnitureInfo[i][fiRotY], FurnitureInfo[i][fiRotZ], FurnitureInfo[i][fiVirtual], -1, -1, 200.0); } printf("Furnitures: %d", objects); cache_delete(db); return 1; } mysql_tquery(handle, "SELECT * FROM `fobjects`", "LoadFurnitures"); - Asta e in ongamemodeinit

Uite aici pc SaveObject(const id) { format(query,sizeof(query),"UPDATE `fobjects` SET `Model`='%d', `X`='%f', `Y`='%f', `Z`='%f', `RotX`='%f', `RotY`='%f', `RotZ`='%f', `Virtual`='%d', `House`='%d' WHERE `ID`='%d'", FurnitureInfo[id][fiModel], FurnitureInfo[id][fiX], FurnitureInfo[id][fiY], FurnitureInfo[id][fiZ], FurnitureInfo[id][fiRotX], FurnitureInfo[id][fiRotY], FurnitureInfo[id][fiRotZ], FurnitureInfo[id][fiVirtual], FurnitureInfo[id][fiHouse], id); mysql_tquery(handle, query); return 1; } Dar pot spune ca nici nu se sterg din baza switch(dialogid) // DE EDITAT { case DIALOG_EDITMOBILA: { if(!response) return 1; SlotSel[playerid] = listitem; ShowPlayerDialog(playerid, DIALOG_EDITMOBILA2, DIALOG_STYLE_MSGBOX, "Optiune:", "Ce vrei sa faci cu acest obiect?\nEditezi/Stergi?", "Editeaza", "Sterge"); } case DIALOG_EDITMOBILA2: { new id = SelMobila[playerid][SlotSel[playerid]]; printf("id = %d", id); EditedObjectID[playerid] = id; EditHouse[playerid] = 2; new obj2 = FurnitureInfo[id][fiObject]; if(!response) { mysql_format(handle,query,128,"DELETE FROM `fobjects` WHERE `ID`='%d'",id); mysql_query(handle, query); //mysql_format(handle, query, sizeof(query), "DELETE FROM `fobjects` WHERE `ID` = %d",FurnitureInfo[id][fiObject]); //mysql_tquery(handle, query); SCM(playerid, COLOR_YELLOW, "Obiect sters!"); DestroyDynamicObject(FurnitureInfo[id][fiObject]); FurnitureInfo[id][fiHouse] = 0; } else { EditHouse[playerid] = 2; SendClientMessage(playerid, COLOR_YELLOW, "Mobilerul ales de tine a fost spawnat. Tot ce trebuie sa faci, este sa-i alegi o pozitie!"); SendClientMessage(playerid, COLOR_YELLOW, "Pentru a misca camera, apasa tasta SPACE iar pentru a misca obiectul, apasa click pe acele axe (X,Y,Z)"); EditDynamicObject(playerid, obj2); } }

Chiar aşa mare problemă e asta sau nu vrea nimeni să mă ajute, puteţi da T/C că văd ca toată lumea trece prin topicul ăsta şi egal cu zero. Mulţumesc frumos pentru ajutor!

Oare ma poate ajuta cineva?

Ok, aici s-a rezolvat problema, dar acuma a intervenit o noua problema, nu se salveaza in baza de date nici atunci cand modific un obiect si nici atunci cand doresc sa il sterg! //=================================================================================================================== public OnPlayerEditObject(playerid, playerobject, objectid, response, Float:fX, Float:fY, Float:fZ, Float:fRotX, Float:fRotY, Float:fRotZ) { new Float:oldX, Float:oldY, Float:oldZ, Float:oldRotX, Float:oldRotY, Float:oldRotZ; GetDynamicObjectPos(objectid, oldX, oldY, oldZ); GetDynamicObjectRot(objectid, oldRotX, oldRotY, oldRotZ); if(response == EDIT_RESPONSE_FINAL) { if(EditHouse[playerid] == 1) { new szQuery[256]; mysql_format(handle, szQuery, 256, "INSERT INTO `fobjects` (`House`) VALUES ('0')"); new Cache: result = mysql_query(handle, szQuery); new i = cache_insert_id(); cache_delete(result); FurnitureInfo[i][fiModel] = EditModel[playerid]; FurnitureInfo[i][fiX] = fX; FurnitureInfo[i][fiY] = fY; FurnitureInfo[i][fiZ] = fZ; FurnitureInfo[i][fiRotX] = fRotX; FurnitureInfo[i][fiRotY] = fRotY; FurnitureInfo[i][fiRotZ] = fRotZ; FurnitureInfo[i][fiVirtual] = GetPlayerVirtualWorld(playerid); FurnitureInfo[i][fiHouse] = PlayerInfo[playerid][pHouse]; SaveObject(i); DestroyDynamicObject(ObjectEdited[playerid]); FurnitureInfo[i][fiObject] = CreateDynamicObject(FurnitureInfo[i][fiModel], FurnitureInfo[i][fiX], FurnitureInfo[i][fiY], FurnitureInfo[i][fiZ], FurnitureInfo[i][fiRotX], FurnitureInfo[i][fiRotY], FurnitureInfo[i][fiRotZ], FurnitureInfo[i][fiVirtual], -1, -1, 200.0); format(szQuery, 256, "Obiect adaugat! Total obiecte: %d/50.", GetHouseObjects(PlayerInfo[playerid][pHouse])); SCM(playerid, COLOR_YELLOW, szQuery); GivePlayerCash(playerid, -500); } else if(EditHouse[playerid] == 2) { new i = EditedObjectID[playerid]; FurnitureInfo[i][fiX] = fX; FurnitureInfo[i][fiY] = fY; FurnitureInfo[i][fiZ] = fZ; FurnitureInfo[i][fiRotX] = fRotX; FurnitureInfo[i][fiRotY] = fRotY; FurnitureInfo[i][fiRotZ] = fRotZ; FurnitureInfo[i][fiVirtual] = GetPlayerVirtualWorld(playerid); FurnitureInfo[i][fiHouse] = PlayerInfo[playerid][pHouse]; DestroyDynamicObject(FurnitureInfo[i][fiObject]);// FurnitureInfo[i][fiObject] = CreateDynamicObject(FurnitureInfo[i][fiModel], FurnitureInfo[i][fiX], FurnitureInfo[i][fiY], FurnitureInfo[i][fiZ], FurnitureInfo[i][fiRotX], FurnitureInfo[i][fiRotY], FurnitureInfo[i][fiRotZ], FurnitureInfo[i][fiVirtual], -1, -1, 200.0); SaveObject(i); SCM(playerid, COLOR_YELLOW, "Mobiler editat cu succes!"); } } if(response == EDIT_RESPONSE_CANCEL) { if(EditHouse[playerid] == 1) DestroyDynamicObject(ObjectEdited[playerid]), SCM(playerid, -1, "Ai anulat!"); if(EditHouse[playerid] == 2) SCM(playerid, -1, "Ai anulat!"); } return 1; } si case DIALOG_EDITMOBILA: { if(!response) return 1; SlotSel[playerid] = listitem; ShowPlayerDialog(playerid, DIALOG_EDITMOBILA2, DIALOG_STYLE_MSGBOX, "Optiune:", "Ce vrei sa faci cu acest obiect?\nEditezi/Stergi?", "Editeaza", "Sterge"); } case DIALOG_EDITMOBILA2: { new id = SelMobila[playerid][SlotSel[playerid]]; printf("id = %d", id); EditedObjectID[playerid] = id; EditHouse[playerid] = 2; new obj2 = FurnitureInfo[id][fiObject]; if(!response) { mysql_format(handle,query,128,"DELETE FROM `fobjects` WHERE `ID`='%d'",id); mysql_query(handle, query); SCM(playerid, COLOR_YELLOW, "Obiect sters!"); DestroyDynamicObject(FurnitureInfo[id][fiObject]); FurnitureInfo[id][fiHouse] = 0; } else { EditHouse[playerid] = 2; SendClientMessage(playerid, COLOR_YELLOW, "Mobilerul ales de tine a fost spawnat. Tot ce trebuie sa faci, este sa-i alegi o pozitie!"); SendClientMessage(playerid, COLOR_YELLOW, "Pentru a misca camera, apasa tasta SPACE iar pentru a misca obiectul, apasa click pe acele axe (X,Y,Z)"); EditDynamicObject(playerid, obj2); } } Precizez: Cand adaug obiectul pe server merge sa ii modific/sterg/adaug, cand dau restart la server pot doar sa adaug alte obiecte, nu sa le modific/sterg din db.

Problema rezolvata pc LoadFurnitures() { new objects = 0; Total_FUR_Created = cache_num_rows(); new i,x; for(i=0;i<Total_FUR_Created;i++) { objects ++; cache_get_value_int(i, "ID", FurnitureInfo[i][fiID]); cache_get_value_int(i, "Model", FurnitureInfo[i][fiModel]); cache_get_value_float(i, "X", FurnitureInfo[i][fiX]); cache_get_value_float(i, "Y", FurnitureInfo[i][fiY]); cache_get_value_float(i, "Z", FurnitureInfo[i][fiZ]); cache_get_value_float(i, "RotX", FurnitureInfo[i][fiRotX]); cache_get_value_float(i, "RotY", FurnitureInfo[i][fiRotY]); cache_get_value_float(i, "RotZ", FurnitureInfo[i][fiRotZ]); cache_get_value_int(i, "Virtual", FurnitureInfo[i][fiVirtual]); cache_get_value_int(i, "House", FurnitureInfo[i][fiHouse]); FurnitureInfo[x][fiObject] = CreateDynamicObject(FurnitureInfo[x][fiModel], FurnitureInfo[x][fiX], FurnitureInfo[x][fiY], FurnitureInfo[x][fiZ], FurnitureInfo[x][fiRotX], FurnitureInfo[x][fiRotY], FurnitureInfo[x][fiRotZ], FurnitureInfo[x][fiVirtual], -1, -1, 200.0); } print("============================================================="); printf("[GAMEMODE]: Furniture Sistem Loaded %d object's", objects); print("=============================================================\n"); return 1; }

Salutare, - Am adaugat un sistem de furniture luat dintr-un alt gamemode in gamemode-ul meu si pot spune ca functioneaza totul perfect mai putin o singura chestie. Adaug obiecte din comanda in jos acolo imi arata ca obiectul s-a creeat si salvat (imi arata gen 2/30 obiecte) dar dupa ce dau un restart la server si revin in /housemenu sau si daca adaug un alt obiect imi arata dinou 1/30... nu gasesc problema, oare ma poate ajuta si pe mine cineva? Multumesc si o seara faina * Poze cu obiectele salvate https://imgur.com/EFTrt6C https://imgur.com/xUTcp9Y * Poza dupa restart https://imgur.com/VThxQae https://imgur.com/EXGO6vc pc LoadFurnitures() { new objects = 0; Total_FUR_Created = cache_num_rows(); new i,x; for(i=0;i<Total_FUR_Created;i++) { objects ++; cache_get_value_int(i, "ID", FurnitureInfo[x][fiID]); cache_get_value_int(i, "Model", FurnitureInfo[x][fiModel]); cache_get_value_float(i, "X", FurnitureInfo[x][fiX]); cache_get_value_float(i, "Y", FurnitureInfo[x][fiY]); cache_get_value_float(i, "Z", FurnitureInfo[x][fiZ]); cache_get_value_float(i, "RotX", FurnitureInfo[x][fiRotX]); cache_get_value_float(i, "RotY", FurnitureInfo[x][fiRotY]); cache_get_value_float(i, "RotZ", FurnitureInfo[x][fiRotZ]); cache_get_value_int(i, "Virtual", FurnitureInfo[x][fiVirtual]); cache_get_value_int(i, "House", FurnitureInfo[x][fiHouse]); FurnitureInfo[x][fiObject] = CreateDynamicObject(FurnitureInfo[x][fiModel], FurnitureInfo[x][fiX], FurnitureInfo[x][fiY], FurnitureInfo[x][fiZ], FurnitureInfo[x][fiRotX], FurnitureInfo[x][fiRotY], FurnitureInfo[x][fiRotZ], FurnitureInfo[x][fiVirtual], -1, -1, 200.0); } print("============================================================="); printf("[GAMEMODE]: Furniture Sistem Loaded %d object's", objects); print("=============================================================\n"); return 1; }[/PHP] pc SaveObject(const id) { format(query,sizeof(query),"UPDATE `fobjects` SET `Model`='%d', `X`='%f', `Y`='%f', `Z`='%f', `RotX`='%f', `RotY`='%f', `RotZ`='%f', `Virtual`='%d', `House`='%d' WHERE `ID`='%d'", FurnitureInfo[id][fiModel], FurnitureInfo[id][fiX], FurnitureInfo[id][fiY], FurnitureInfo[id][fiZ], FurnitureInfo[id][fiRotX], FurnitureInfo[id][fiRotY], FurnitureInfo[id][fiRotZ], FurnitureInfo[id][fiVirtual], FurnitureInfo[id][fiHouse], id); mysql_tquery(handle, query); return 1; }[/PHP] [PHP]stock GetHouseObjects(houseid) { new x; for(new i = 0; i != sizeof(FurnitureInfo); i++) { if(FurnitureInfo[i][fiHouse] == houseid) x++; } return x; } and format(strong,sizeof(strong), "{f9f7ce}Numele casei \t%s\n\ {f9f7ce}Chirie \t%s\n\ {f9f7ce}Casa inchisa \t%s\n\ {f9f7ce}Bani in casa \t%s$\n\ {f9f7ce}Materiale in casa \t%s\n\ {f9f7ce}Droguri in casa \t%s grame\n\ {f9f7ce}Mobilier casa \t%d/30 obiecte\n\ {f9f7ce}Editeaza mobilier", HouseInfo[h][hName],renttext,locktext,FormatNumber(HouseInfo[h][hSeif]),FormatNumber(HouseInfo[h][hMats]),FormatNumber(HouseInfo[h][hDrugs]), GetHouseObjects(PlayerInfo[playerid][pHouse])); ShowPlayerDialog(playerid, DIALOG_HM, DIALOG_STYLE_TABLIST, "{02901a}Meniu casa",strong, "Select", "Cancel"); si [pHouse] este Housekey

Recomand!

Salut, atunci cand ma loghez pe server imi spune ca parola este incorecta, oare care ar putea fi problema?