Jump to content
  • 0

Ajutor

BaDB0yIonut

Asked by BaDB0yIonut,

 Share

Question

6 answers to this question

Recommended Posts

Guest Rock

Guest Rock

Posted
Posted

Am si eu o problema cu masinile pers nu imi raman dupa rr pe server o creez din comanda o cumpar apare dupa a cui e tot si dupa rr dispare servarul ruleaza mysql in baza de date trebuie adaugat ceva ca nu stiu cine ma poate ajuta?

De virgule ai auzit?

Posteaza codul de la salvare si extragere.

Nu ma pricep la MYSQL doar poate cineva te va ajuta.

Link to comment
Share on other sites
BaDB0yIonut Contributor

BaDB0yIonut

Posted
  • Author
Posted

Am si eu o problema la masinile personale, nu mi se salveaza in baza de date mysql, uitati comenzile de creat, si cumparat, daca nu, moody_samp sau cum pot sa le fac din mysql, sa nu se mai salveze in baza de date, si sa se salveze in scriptfiles.

if(strcmp(cmd, "/createpersonalcar", true) == 0)

{

if(IsPlayerConnected(playerid))

{

if (PlayerInfo[playerid][pAdmin] < 5)

{

SendClientMessage(playerid, COLOR_GRAD1, ADMIN_TEXT);

return 1;

}

if (CreatedCar != 0)

{

SendClientMessage(playerid, COLOR_LIGHTRED, "Exista o masina spawnata care nu este salvata in baza de date!Sterge-o mai intai!");

return 1;

}

tmp = strtok(cmdtext, idx);

if(!strlen(tmp))

{

SendClientMessage(playerid, COLOR_WHITE, "UTILIZARE: /createpersonalcar [carid/carname] [color1] [color2] [pret]");

return 1;

}

new bool:foundletter = false;

for(new i; i < strlen(tmp); i++)

if(!IsDigit(tmp))

{

foundletter = true;

break;

}

new car,carname[20];

if(!foundletter) // carid

{

car = strval(tmp);

if(car < 400 || car > 611) { SendClientMessage(playerid, COLOR_GREY, "Modelul vehiculului trebuie sa fie intre 400 si 611 !"); return 1; }

}

else // carname

{

if(!strcmp(tmp,"Landstalker",true)) car = 400;

else if(!strcmp(tmp,"Bravura",true)) car = 401;

else if(!strcmp(tmp,"Buffalo",true)) car = 402;

else if(!strcmp(tmp,"Linerunner",true)) car = 403;

else if(!strcmp(tmp,"Pereniel",true)) car = 404;

else if(!strcmp(tmp,"Sentinel",true)) car = 405;

else if(!strcmp(tmp,"Dumper",true)) car = 406;

else if(!strcmp(tmp,"Firetruck1",true)) car = 407;

else if(!strcmp(tmp,"Trashmaster",true)) car = 408;

else if(!strcmp(tmp,"Stretch",true)) car = 409;

else if(!strcmp(tmp,"Manana",true)) car = 410;

else if(!strcmp(tmp,"Infernus",true)) car = 411;

else if(!strcmp(tmp,"Voodoo",true)) car = 412;

else if(!strcmp(tmp,"Pony",true)) car = 413;

else if(!strcmp(tmp,"Mule",true)) car = 414;

else if(!strcmp(tmp,"Cheetah",true)) car = 415;

else if(!strcmp(tmp,"Ambulance",true)) car = 416;

else if(!strcmp(tmp,"Leviathan",true)) car = 417;

else if(!strcmp(tmp,"Moonbeam",true)) car = 418;

else if(!strcmp(tmp,"Esperanto",true)) car = 419;

else if(!strcmp(tmp,"Taxi",true)) car = 420;

else if(!strcmp(tmp,"Washington",true)) car = 421;

else if(!strcmp(tmp,"Bobcat",true)) car = 422;

else if(!strcmp(tmp,"MrWhoopee",true)) car = 423;

else if(!strcmp(tmp,"BFInjection",true)) car = 424;

else if(!strcmp(tmp,"Hunter",true)) car = 425;

else if(!strcmp(tmp,"Premier",true)) car = 426;

else if(!strcmp(tmp,"Enforcer",true)) car = 427;

else if(!strcmp(tmp,"Securicar",true)) car = 428;

else if(!strcmp(tmp,"Banshee",true)) car = 429;

else if(!strcmp(tmp,"Predator",true)) car = 430;

else if(!strcmp(tmp,"Bus",true)) car = 431;

else if(!strcmp(tmp,"Rhino",true)) car = 432;

else if(!strcmp(tmp,"Barracks",true)) car = 433;

else if(!strcmp(tmp,"Hotknife",true)) car = 434;

else if(!strcmp(tmp,"Trailer1",true)) car = 435;

else if(!strcmp(tmp,"Previon",true)) car = 436;

else if(!strcmp(tmp,"Coach",true)) car = 437;

else if(!strcmp(tmp,"Cabbie",true)) car = 438;

else if(!strcmp(tmp,"Stallion",true)) car = 439;

else if(!strcmp(tmp,"Rumpo",true)) car = 440;

else if(!strcmp(tmp,"RCBandit",true)) car = 441;

else if(!strcmp(tmp,"Romero",true)) car = 442;

else if(!strcmp(tmp,"Packer",true)) car = 443;

else if(!strcmp(tmp,"MonsterTruck1",true)) car = 444;

else if(!strcmp(tmp,"Admiral",true)) car = 445;

else if(!strcmp(tmp,"Squalo",true)) car = 446;

else if(!strcmp(tmp,"Seasparrow",true)) car = 447;

else if(!strcmp(tmp,"Pizzaboy",true)) car = 448;

else if(!strcmp(tmp,"Tram",true)) car = 449;

else if(!strcmp(tmp,"Trailer2",true)) car = 450;

else if(!strcmp(tmp,"Turismo",true)) car = 451;

else if(!strcmp(tmp,"Speeder",true)) car = 452;

else if(!strcmp(tmp,"Reefer",true)) car = 453;

else if(!strcmp(tmp,"Tropic",true)) car = 454;

else if(!strcmp(tmp,"Flatbed",true)) car = 455;

else if(!strcmp(tmp,"Yankee",true)) car = 456;

else if(!strcmp(tmp,"Caddy",true)) car = 457;

else if(!strcmp(tmp,"Solair",true)) car = 458;

else if(!strcmp(tmp,"Berkley",true)) car = 459;

else if(!strcmp(tmp,"Skimmer",true)) car = 460;

else if(!strcmp(tmp,"PCJ-600",true) || !strcmp(tmp,"PCJ600",true)) car = 461;

else if(!strcmp(tmp,"Faggio",true)) car = 462;

else if(!strcmp(tmp,"Freeway",true)) car = 463;

else if(!strcmp(tmp,"RCBaron",true)) car = 464;

else if(!strcmp(tmp,"RCRaider",true)) car = 465;

else if(!strcmp(tmp,"Glendale",true)) car = 466;

else if(!strcmp(tmp,"Oceanic",true)) car = 467;

else if(!strcmp(tmp,"Sanchez",true)) car = 468;

else if(!strcmp(tmp,"Sparrow",true)) car = 469;

else if(!strcmp(tmp,"Patriot",true)) car = 470;

else if(!strcmp(tmp,"Quad",true) || !strcmp(tmp,"ATV",true)) car = 471;

else if(!strcmp(tmp,"Coastguard",true)) car = 472;

else if(!strcmp(tmp,"Dinghy",true)) car = 473;

else if(!strcmp(tmp,"Hermes",true)) car = 474;

else if(!strcmp(tmp,"Sabre",true)) car = 475;

else if(!strcmp(tmp,"Rustler",true)) car = 476;

else if(!strcmp(tmp,"ZR-350",true) || !strcmp(tmp,"ZR350",true)) car = 477;

else if(!strcmp(tmp,"Walton",true)) car = 478;

else if(!strcmp(tmp,"Regina",true)) car = 479;

else if(!strcmp(tmp,"Comet",true)) car = 480;

else if(!strcmp(tmp,"BMX",true)) car = 481;

else if(!strcmp(tmp,"Burrito",true)) car = 482;

else if(!strcmp(tmp,"Camper",true)) car = 483;

else if(!strcmp(tmp,"Marquis",true)) car = 484;

else if(!strcmp(tmp,"Baggage",true)) car = 485;

else if(!strcmp(tmp,"Dozer",true)) car = 486;

else if(!strcmp(tmp,"Maverick",true)) car = 487;

else if(!strcmp(tmp,"NewsChopper",true) || !strcmp(tmp,"NewsMaverick",true)) car = 488;

else if(!strcmp(tmp,"Rancher1",true)) car = 489;

else if(!strcmp(tmp,"FBIRancher",true)) car = 490;

else if(!strcmp(tmp,"Virgo",true)) car = 491;

else if(!strcmp(tmp,"Greenwood",true)) car = 492;

else if(!strcmp(tmp,"Jetmax",true)) car = 493;

else if(!strcmp(tmp,"Hotring1",true)) car = 494;

else if(!strcmp(tmp,"Sandking",true)) car = 495;

else if(!strcmp(tmp,"BlistaCompact",true)) car = 496;

else if(!strcmp(tmp,"PoliceMaverick",true)) car = 497;

else if(!strcmp(tmp,"Boxville",true)) car = 498;

else if(!strcmp(tmp,"Benson",true)) car = 499;

else if(!strcmp(tmp,"Mesa",true)) car = 500;

else if(!strcmp(tmp,"RCGoblin",true)) car = 501;

else if(!strcmp(tmp,"Hotring2",true)) car = 502;

else if(!strcmp(tmp,"Hotring3",true)) car = 503;

else if(!strcmp(tmp,"BloodringBanger",true)) car = 504;

else if(!strcmp(tmp,"Rancher2",true)) car = 505;

else if(!strcmp(tmp,"SuperGT",true)) car = 506;

else if(!strcmp(tmp,"Elegant",true)) car = 507;

else if(!strcmp(tmp,"Journey",true)) car = 508;

else if(!strcmp(tmp,"Bike",true)) car = 509;

else if(!strcmp(tmp,"MountainBike",true)) car = 510;

else if(!strcmp(tmp,"Beagle",true)) car = 511;

else if(!strcmp(tmp,"Cropdust",true)) car = 512;

else if(!strcmp(tmp,"Stunt",true)) car = 513;

else if(!strcmp(tmp,"Tanker",true)) car = 514;

else if(!strcmp(tmp,"RoadTrain",true)) car = 515;

else if(!strcmp(tmp,"Nebula",true)) car = 516;

else if(!strcmp(tmp,"Majestic",true)) car = 517;

else if(!strcmp(tmp,"Buccaneer",true)) car = 518;

else if(!strcmp(tmp,"Shamal",true)) car = 519;

else if(!strcmp(tmp,"Hydra",true)) car = 520;

else if(!strcmp(tmp,"FCR-900",true) || !strcmp(tmp,"FCR900",true)) car = 521;

else if(!strcmp(tmp,"NRG-500",true) || !strcmp(tmp,"NRG500",true)) car = 522;

else if(!strcmp(tmp,"HPV-1000",true) || !strcmp(tmp,"HPV1000",true)) car = 523;

else if(!strcmp(tmp,"CementTruck",true)) car = 524;

else if(!strcmp(tmp,"TowTruck",true)) car = 525;

else if(!strcmp(tmp,"Fortune",true)) car = 526;

else if(!strcmp(tmp,"Cadrona",true)) car = 527;

else if(!strcmp(tmp,"FBITruck",true)) car = 528;

else if(!strcmp(tmp,"Willard",true)) car = 529;

else if(!strcmp(tmp,"Forklift",true)) car = 530;

else if(!strcmp(tmp,"Tractor",true)) car = 531;

else if(!strcmp(tmp,"Combine",true)) car = 532;

else if(!strcmp(tmp,"Feltzer",true)) car = 533;

else if(!strcmp(tmp,"Remington",true)) car = 534;

else if(!strcmp(tmp,"Slamvan",true)) car = 535;

else if(!strcmp(tmp,"Blade",true)) car = 536;

else if(!strcmp(tmp,"Freight",true)) car = 537;

else if(!strcmp(tmp,"Streak",true)) car = 538;

else if(!strcmp(tmp,"Vortex",true)) car = 539;

else if(!strcmp(tmp,"Vincent",true)) car = 540;

else if(!strcmp(tmp,"Bullet",true)) car = 541;

else if(!strcmp(tmp,"Clover",true)) car = 542;

else if(!strcmp(tmp,"Sadler",true)) car = 543;

else if(!strcmp(tmp,"Firetruck2",true)) car = 544;

else if(!strcmp(tmp,"Hustler",true)) car = 545;

else if(!strcmp(tmp,"Intruder",true)) car = 546;

else if(!strcmp(tmp,"Primo",true)) car = 547;

else if(!strcmp(tmp,"Cargobob",true)) car = 548;

else if(!strcmp(tmp,"Tampa",true)) car = 549;

else if(!strcmp(tmp,"Sunrise",true)) car = 550;

else if(!strcmp(tmp,"Merit",true)) car = 551;

else if(!strcmp(tmp,"Utility",true) || !strcmp(tmp,"UtilityVan",true)) car = 552;

else if(!strcmp(tmp,"Nevada",true)) car = 553;

else if(!strcmp(tmp,"Yosemite",true)) car = 554;

else if(!strcmp(tmp,"Windsor",true)) car = 555;

else if(!strcmp(tmp,"MonsterTruck2",true)) car = 556;

else if(!strcmp(tmp,"MonsterTruck3",true)) car = 557;

else if(!strcmp(tmp,"Uranus",true)) car = 558;

else if(!strcmp(tmp,"Jester",true)) car = 559;

else if(!strcmp(tmp,"Sultan",true)) car = 560;

else if(!strcmp(tmp,"Stratum",true)) car = 561;

else if(!strcmp(tmp,"Elegy",true)) car = 562;

else if(!strcmp(tmp,"Raindance",true)) car = 563;

else if(!strcmp(tmp,"RCTiger",true)) car = 564;

else if(!strcmp(tmp,"Flash",true)) car = 565;

else if(!strcmp(tmp,"Tahoma",true)) car = 566;

else if(!strcmp(tmp,"Savanna",true)) car = 567;

else if(!strcmp(tmp,"Bandito",true)) car = 568;

else if(!strcmp(tmp,"Freight",true)) car = 569;

else if(!strcmp(tmp,"Trailer3",true)) car = 570;

else if(!strcmp(tmp,"Kart",true)) car = 571;

else if(!strcmp(tmp,"Mower",true)) car = 572;

else if(!strcmp(tmp,"Duneride",true)) car = 573;

else if(!strcmp(tmp,"Sweeper",true)) car = 574;

else if(!strcmp(tmp,"Broadway",true)) car = 575;

else if(!strcmp(tmp,"Tornado",true)) car = 576;

else if(!strcmp(tmp,"AT-400",true) || !strcmp(tmp,"AT400",true)) car = 577;

else if(!strcmp(tmp,"DFT-30",true) || !strcmp(tmp,"DFT30",true)) car = 578;

else if(!strcmp(tmp,"Huntley",true)) car = 579;

else if(!strcmp(tmp,"Stafford",true)) car = 580;

else if(!strcmp(tmp,"BF-400",true) || !strcmp(tmp,"BF400",true)) car = 581;

else if(!strcmp(tmp,"Newsvan",true)) car = 582;

else if(!strcmp(tmp,"Tug",true)) car = 583;

else if(!strcmp(tmp,"Trailer4",true)) car = 584;

else if(!strcmp(tmp,"Emperor",true)) car = 585;

else if(!strcmp(tmp,"Wayfarer",true)) car = 586;

else if(!strcmp(tmp,"Euros",true)) car = 587;

else if(!strcmp(tmp,"Hotdog",true)) car = 588;

else if(!strcmp(tmp,"Club",true)) car = 589;

else if(!strcmp(tmp,"Trailer5",true)) car = 590;

else if(!strcmp(tmp,"Trailer6",true)) car = 591;

else if(!strcmp(tmp,"Andromada",true)) car = 592;

else if(!strcmp(tmp,"Dodo",true)) car = 593;

else if(!strcmp(tmp,"RCCam",true)) car = 594;

else if(!strcmp(tmp,"Launch",true)) car = 595;

else if(!strcmp(tmp,"PoliceCarLSPD",true) || !strcmp(tmp,"PoliceCarLS",true)) car = 596;

else if(!strcmp(tmp,"PoliceCarSFPD",true) || !strcmp(tmp,"PoliceCarSF",true)) car = 597;

else if(!strcmp(tmp,"PoliceCarLVPD",true) || !strcmp(tmp,"PoliceCarLV",true)) car = 598;

else if(!strcmp(tmp,"PoliceRanger",true)) car = 599;

else if(!strcmp(tmp,"Picador",true)) car = 600;

else if(!strcmp(tmp,"S.W.A.T.",true) || !strcmp(tmp,"SWAT",true) || !strcmp(tmp,"SWATVAN",true)) car = 601;

else if(!strcmp(tmp,"Alpha",true)) car = 602;

else if(!strcmp(tmp,"Phoenix",true)) car = 603;

else if(!strcmp(tmp,"Glendale",true)) car = 604;

else if(!strcmp(tmp,"Sadler",true)) car = 605;

else if(!strcmp(tmp,"LuggageTrailer1",true)) car = 606;

else if(!strcmp(tmp,"LuggageTrailer2",true)) car = 607;

else if(!strcmp(tmp,"StairTrailer",true)) car = 608;

else if(!strcmp(tmp,"Boxville",true)) car = 609;

else if(!strcmp(tmp,"FarmPlow",true)) car = 610;

else if(!strcmp(tmp,"UtilityTrailer",true)) car = 611;

else

{

SendClientMessage(playerid,0xCE3E3EAA,"[EROARE]: Nume de vehicul gresit !");

SendClientMessage(playerid,0x80ABEBAA,"[ATENTIE]: Numele la UNELE vehicule au fost schimbate ! Ca de exemplu:");

SendClientMessage(playerid,0xBCEEB9AA,"Trailer1 | Trailer2 | Trailer3 | Trailer4 | Trailer5 | Trailer6 | RCCam | RCBandit | RCRaider | RCBaron | RCGoblin | RCTiger");

SendClientMessage(playerid,0x97D893AA,"Firetruck1 | Firetruck2 | Rancher1 | Rancher2 | Hotring1 | Hotring2 | Hotring3 | BloodringBanger | Utility | MrWhoopee");

SendClientMessage(playerid,0x7ED078AA,"Berkley | StairTrailer | Boxville | FarmPlow | UtilityTrailer | Monstertruck1 | Monstertruck2 | Monstertruck3");

SendClientMessage(playerid,0x60CA59AA,"PoliceCarLS | PoliceCarSF | PoliceCarLV | PoliceRanger | Swat | LuggageTrailer1 | LuggageTrailer2");

return true;

}

}

strmid(carname,tmp,0,strlen(tmp));

tmp = strtok(cmdtext, idx);

if(!strlen(tmp))

{

if(strlen(carname) && foundletter)

SendFormattedMessage(playerid, COLOR_GRAD2, "UTILIZARE: /createpersonalcar %s [color1] [color2] [pret]",carname);

else

SendFormattedMessage(playerid, COLOR_GRAD2, "UTILIZARE: /createpersonalcar %s [color1] [color2] [pret]",GetVehicleModelName(car));

return 1;

}

new color1;

color1 = strval(tmp);

if(color1 < -1 || color1 > 256) { SendClientMessage(playerid, COLOR_GREY, "Prima culoare a vehiculului trebuie sa fie intre 0 si 256 !"); return 1; }

tmp = strtok(cmdtext, idx);

if(!strlen(tmp))

{

if(strlen(carname) && foundletter)

SendFormattedMessage(playerid, COLOR_GRAD3, "UTILIZARE: /createpersonalcar %s [color1] [color2] [pret]",carname);

else

SendFormattedMessage(playerid, COLOR_GRAD3, "UTILIZARE: /createpersonalcar %s [color1] [color2] [pret]",GetVehicleModelName(car));

return 1;

}

new color2;

color2 = strval(tmp);

if(color2 < -1 || color2 > 256) { SendClientMessage(playerid, COLOR_GREY, "A doua culoare a vehiculului trebuie sa fie intre 0 si 256 !"); return 1; }

tmp = strtok(cmdtext, idx);

if(!strlen(tmp))

{

if(strlen(carname) && foundletter)

SendFormattedMessage(playerid, COLOR_GRAD3, "UTILIZARE: /createpersonalcar %s [color1] [color2] [PRET]",carname);

else

SendFormattedMessage(playerid, COLOR_GRAD3, "UTILIZARE: /createpersonalcar %s [color1] [color2] [PRET]",GetVehicleModelName(car));

return 1;

}

new price;

price = strval(tmp);

if(price < 0) { SendClientMessage(playerid, COLOR_GREY, "Pretul trebuie sa fie mai mare decat 0"); return 1; }

new Float:X,Float:Y,Float:Z,Float:A;

GetPlayerPos(playerid, X,Y,Z);

GetPlayerFacingAngle(playerid,A);

new carid = CreateVehicle(car, X,Y,Z,A, color1, color2, -1);

LinkVehicleToInterior(carid,GetPlayerInterior(play erid));

totalcars++;

VehicleInfo[carid][vID] = totalcars;

VehicleInfo[carid][vModel] = car;

VehicleInfo[carid][vLocationx] = X;

VehicleInfo[carid][vLocationy] = Y;

VehicleInfo[carid][vLocationz] = Z;

VehicleInfo[carid][vAngle] = A;

VehicleInfo[carid][vColorOne] = color1;

VehicleInfo[carid][vColorTwo] = color2;

memcpy(VehicleInfo[carid][vOwner], "Nimeni", 0, MAX_PLAYER_NAME*8, MAX_PLAYER_NAME*;

VehicleInfo[carid][vOwned] = 0;

VehicleInfo[carid][vLock] = 0; // Locked

VehicleInfo[carid][vPrice] = price;

InsertPersonalVehicle(carid);

Gas[carid] = GetLiters(carid);

format(string, sizeof(string), "Ai creat un %s!Poate fi cumparat cu /buycar!",GetVehicleModelName(car));

SendClientMessage(playerid, 0x1A94EEFF, string);

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

format(string,sizeof(string),"Admin %s spawned personal car id %d , model %s.",sendername,carid,GetVehicleModelName(car));

AdminLog(string);

}

return 1;

}

if(strcmp(cmd, "/buycar", true) == 0)

{

if(IsPlayerConnected(playerid))

{

if(IsPlayerInAnyVehicle(playerid))

{

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

if(strfind(sendername, "[AOD]", true) != -1)

{

SendClientMessage(playerid, 0xAD7967FF,"Nu poti cumpara o afacere in timp ce esti '[AOD]'.");

return 1;

}

new car = GetPlayerVehicleID(playerid);

if(VehicleInfo[car][vPrice] != 0 && VehicleInfo[car][vModel] != 0 && VehicleInfo[car][vOwned] == 0)

{

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

memcpy(VehicleInfo[car][vOwner], sendername, 0, MAX_PLAYER_NAME*8, MAX_PLAYER_NAME*;

VehicleInfo[car][vOwned] = 1;

PlayerInfo[playerid][pCarKey] = car;

GivePlayerCash(playerid, -VehicleInfo[car][vPrice]);

//printf("%d - %d - %d", VehicleInfo[car][vModel], VehicleInfo[car][vPrice], VehicleInfo[car][vOwned]);

format(string, sizeof(string), "Felicitari! Ai cumparat acest %s pentru suma de %d!", GetVehicleModelName(car), VehicleInfo[car][vPrice]);

SendClientMessage(playerid, COLOR_LIGHTBLUE, string);

SavePersonalVehicle(car);

return 1;

}

else

{

SendClientMessage(playerid, COLOR_WHITE, "Aceasta masina nu este de vanzare sau are deja un proprietar!");

return 1;

}

}

}

}

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.