Problema bunuri personale, wipe.

[Serafim]

Problemă întâlnită (descriere): Am luat gamemod-ul rGaming v2.0 si sunt toate masinile, biz-urile, casele luate, si as vrea sa le dau pe toate deodata la stat sau ceva de genul asta. Fara sa modific pe fiecare Owned 0 si sa fie The State.As vrea sa dau wipe la bunuri
Ero(area / rile) / warning-(ul / urile):  ---
Liniile de cod / sursa / script-ul:---
Imagini / Video (optional):---
Aţi încercat să rezolvaţi singur?:Nu, pentru ca nu ma pricep ..

[WopsS]

Daca ai sistemul pe ini faci un for care sa treca prin toate. Daca ai sistemul pe MySQL doar executi un query de update.

[Serafim]

Salut !Systemul meu ruleaza pe MYSQL, dar, nu stiu cum sa fac acel update query..Ti-am trimis in P.M adresa mea de skype, si mess. Daca vrei, ma poti ajuta

[Iulian]

"SELECT * FROM `tabel` SET `nume-variabila` = valoare"

 

Executi acest query in PHPMyAdmin sau Navicat.

 

 

(Inlocuiesti tabel cu numele tabelului. EX: "SELECT * FROM `users` SET `nume-variabila` = valoare"

Inlocuiesti variabila cu numele variabilei pe care vrei sa o inlocuiesti. EX: "SELECT * FROM `users` SET `owned` = valoare"

Inlocuiesti valoare cu valoarea pe care vrei sa o aiba variabila ta. EX: "SELECT * FROM `users` SET `owned` = 0"

 

 

** ATENTIE! SA NU PUI SI "

[Serafim]

M-a ajutat cineva de pe alt forum, am dat toate masinile la Dealership, insa problema e ca.... nu gasesc dealership, casele, biz, le-am vandut la stat, toate. Si acum astept sa gasesc dealership/sa fac rost de unul

[Gireada]

Uitate in gamemode si cauta isatdealership

[Serafim]

Gireada, am cautat. [pawn]public IsAtDealership(playerid)

{
if(IsPlayerConnected(playerid))
{
if(PlayerToPoint(25.0,playerid,2128.0864,-1135.3912,25.5855) || PlayerToPoint(50,playerid,537.3366,-1293.2140,17.2422) || PlayerToPoint(35,playerid,2521.5544,-1524.4504,23.8365) || PlayerToPoint(50,playerid,2155.0146,-1177.3333,23.8211) || PlayerToPoint(50,playerid,299.1723,-1518.6627,24.6007))
{
return 1;
}
}
return 0;
}[/pawn]

 

Cum pot sa-l gasesc acum?

[Iulian]

Faci o comanda care sa te teleporteze la coordonatele 2128.0864,-1135.3912,25.5855

[Gireada]

Sau te duci cu map editor-ul

[Serafim]

Asa m-a teleportat in MTA, nu am gasit nici o masina, si daca sunt in-game, nu e nimic.

 

http://i.imgur.com/MfbIsZl.png

Edited August 30, 2014 by Serafim

[Iulian]

Foloseste comanda de cumparat masini (/v buy - asta cred ca e) in acea locatie. Nu e checkpoint-ul setat.

[Serafim]

Am facut o comanda /gotods, tot acolo ma da, dar nu merge nici o comanda de cumparat masini.

Ce sa fac?

[Iulian]

Posteaza comanda /v buy (sau care o ai tu pentru cumparat masini)

[Serafim]

Posteaza comanda /v buy (sau care o ai tu pentru cumparat masini)

[pawn] if(strcmp(cmd, "/cumparmasina", true) == 0)

{

new newcar = GetPlayerVehicleID(playerid);

if(CarData[newcar-PreVehicle][cOwned] == 1 && newcar > PreVehicle)

{

return 1;

}

/*if(PlayerData[playerid][pDonateRank] != 3 && IsADonatorCar(newcar))

{

SendClientMessage(playerid, COLOR_GREY, "Nu poti cumpara masina asta deoarece este un infernus/bullet/turismo si nu ai donator de aur!");

return 1;

}*/

if(PlayerData[playerid][pCash] >= CarData[newcar - PreVehicle][cValue])

{

if(PlayerData[playerid][pPcarkey] == 999 && !IsABike(newcar) && !IsAPlane(newcar) && !IsABoat(newcar))

{

PlayerData[playerid][pPcarkey] = newcar - PreVehicle;

TogglePlayerControllable(playerid, 0);

SendClientMessage(playerid,COLOR_LIGHTBLUE,"* Felicitari! Ti-ai cumparat o masina personala");

GivePlayerCash(playerid, - CarData[newcar - PreVehicle][cValue]);

CarData[newcar-PreVehicle][cOwned] = 1;

GetPlayerName(playerid, sendername, sizeof(sendername));

strmid(CarData[newcar-PreVehicle][cOwner], sendername, 0, strlen(sendername), 999);

TogglePlayerControllable(playerid, 1);

new query[MAX_STRING];

format(query, sizeof(query), "UPDATE cars SET Owned='%d' WHERE id=%d", CarData[newcar-PreVehicle][cOwned], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE cars SET Owner='%s' WHERE id=%d", CarData[newcar-PreVehicle][cOwner], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Car='%d' WHERE id=%d", PlayerData[playerid][pPcarkey], PlayerData[playerid][pSQLID]);

mysql_query(query);

new year,month,day,hour,minute,second;

getdate(year, month, day);

gettime(hour,minute,second);

format(query, sizeof(query), "AdmCmd: %s a cumparmasina id %d in %d/%d/%d ora %d-%d-%d",PlayerData[playerid][pNume],newcar-PreVehicle,month,day,year,hour,minute,second);

PropertyLog(query);

return 1;

}

if(PlayerData[playerid][pPcarkey2] == 999 && IsABike(newcar) && !IsAPlane(newcar) && !IsABoat(newcar))

{

PlayerData[playerid][pPcarkey2] = newcar - PreVehicle;

TogglePlayerControllable(playerid, 0);

SendClientMessage(playerid,COLOR_LIGHTBLUE,"* Felicitari! Ti-ai cumparat o motocicleta personala");

GivePlayerCash(playerid, - CarData[newcar - PreVehicle][cValue]);

CarData[newcar-PreVehicle][cOwned] = 1;

GetPlayerName(playerid, sendername, sizeof(sendername));

strmid(CarData[newcar-PreVehicle][cOwner], sendername, 0, strlen(sendername), 999);

TogglePlayerControllable(playerid, 1);

new query[MAX_STRING];

format(query, sizeof(query), "UPDATE cars SET Owned='%d' WHERE id=%d", CarData[newcar-PreVehicle][cOwned], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE cars SET Owner='%s' WHERE id=%d", CarData[newcar-PreVehicle][cOwner], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Car2='%d' WHERE id=%d", PlayerData[playerid][pPcarkey2], PlayerData[playerid][pSQLID]);

mysql_query(query);

new year,month,day,hour,minute,second;

getdate(year, month, day);

gettime(hour,minute,second);

format(query, sizeof(query), "AdmCmd: %s a cumparmasina (moto) id %d in %d/%d/%d ora %d-%d-%d",PlayerData[playerid][pNume],newcar-PreVehicle,month,day,year,hour,minute,second);

PropertyLog(query);

return 1;

}

if(PlayerData[playerid][pPcarkey3] == 999 && !IsABike(newcar) && (IsAPlane(newcar) || IsABoat(newcar)))

{

PlayerData[playerid][pPcarkey3] = newcar - PreVehicle;

TogglePlayerControllable(playerid, 0);

SendClientMessage(playerid,COLOR_LIGHTBLUE,"* Felicitari! Ti-ai cumparat o barca/ un avion personal(a)");

GivePlayerCash(playerid, - CarData[newcar - PreVehicle][cValue]);

CarData[newcar-PreVehicle][cOwned] = 1;

GetPlayerName(playerid, sendername, sizeof(sendername));

strmid(CarData[newcar-PreVehicle][cOwner], sendername, 0, strlen(sendername), 999);

TogglePlayerControllable(playerid, 1);

new query[MAX_STRING];

format(query, sizeof(query), "UPDATE cars SET Owned='%d' WHERE id=%d", CarData[newcar-PreVehicle][cOwned], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE cars SET Owner='%s' WHERE id=%d", CarData[newcar-PreVehicle][cOwner], newcar-PreVehicle);

mysql_query(query);

format(query, sizeof(query), "UPDATE players SET Car3='%d' WHERE id=%d", PlayerData[playerid][pPcarkey3], PlayerData[playerid][pSQLID]);

mysql_query(query);

new year,month,day,hour,minute,second;

getdate(year, month, day);

gettime(hour,minute,second);

format(query, sizeof(query), "AdmCmd: %s a cumparmasina (avion/barca) id %d in %d/%d/%d ora %d-%d-%d",PlayerData[playerid][pNume],newcar-PreVehicle,month,day,year,hour,minute,second);

PropertyLog(query);

return 1;

}

else

{

SendClientMessage(playerid,COLOR_LIGHTRED,"* Deti deja o masina personala.");

return 1;

}

}

else

{

SendClientMessage(playerid,COLOR_LIGHTRED,"* Nu ai bani destui pentru a cumpara aceasta masina.");

}

return 1;

}[/pawn]

 

P.S:Daca scriu comanda scrie : 

/cumparmasina imi zice: SERVER: Command Unknown.

 

Daca scriu orice alta comanda imi zice : Eroare:Aceasta comanda nu exista.Foloseste /help pentru o lista completa cu comenzile existente.

Edited August 31, 2014 by Serafim

[WopsS]

Deja asta e o alta problema. Chiar sunt 3 in acest topic.

 

Topic inchis!