[FilterScript] Vehicle Ownership System (MySQL R39-2)

[FilterScript] Vehicle Ownership System (MySQL R39-2) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] Vehicle Ownership System (MySQL R39-2) (/showthread.php?tid=567847)

Pages: 1 2

Vehicle Ownership System (MySQL R39-2) - X337 - 17.03.2015

Hy all, today i make Vehicle Ownership System that used MySQL as saving system.
This is basic vehicle system, so you can easily edit and add more features what you want.

Features
- Saved Vehicle System

- Sell Vehicle To Server
- GPS System to locate your car (thanks to Fj0rtizFredde)
- Sell Vehicle To Players
- Vehicle Control Panel
- For more features you can view pictures in attachments

Instruction
- First, you need to define your Database info

Code:

#define HOST		"Your Host"
#define USER		"root"
#define PASSWORD	"********"
#define DBNAME		"Database Name"

- To change dealership pos, you need to change dealX, dealY, dealZ variables

Code:

Float:dealX = -1663.640014, Float:dealY = 1208.253662, Float:dealZ = 7.254645

- If you have any problems when compile it, you can ask question in this thread

- Another instruction in script

Downloads

Pastebin (Bad Indentation)
SQL File

* The pictures in attachment below, hope you like it!

Re: Vehicle Ownership System (MySQL R39-2) - fonia5 - 17.03.2015

This is really good i like it nice job.

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 17.03.2015

Quote:

Originally Posted by fonia5

This is really good i like it nice job.

Thanks for your feedback

Re: Vehicle Ownership System (MySQL R39-2) - Mya - 17.03.2015

Nice Job

, use [img]your ss link[/img] to show your Screenshot xD

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 17.03.2015

Quote:

Originally Posted by Mya

Nice Job

, use [img]your ss link[/img] to show your Screenshot xD

Thanks, that image is too big to show in post.

Re: Vehicle Ownership System (MySQL R39-2) - Pottus - 17.03.2015

Some of this is copied code you didn't give credits for I'm not sure if there is more copied else where but.

http://users.telenet.be/vge/download...ripts/FGPS.pwn

pawn Code:

public OnPlayerDeath(playerid, killerid, reason)
{
    if(GetPVarInt(playerid,"YEAH") == 1)
    {
        DestroyObject(GPSObject[playerid]);
        SetPVarInt(playerid,"YEAH",0);
        DeletePVar(playerid,"Spongebob");
        DeletePVar(playerid,"Mario");
        DeletePVar(playerid,"SpiderPig");
        DeletePVar(playerid,"FAIL");
        #if defined UseTd
            TextDrawHideForPlayer(playerid, GPSTD);
        #endif
    }
    return 1;
}

Your code.

pawn Code:

public OnPlayerDeath(playerid, killerid, reason)
{
    if(GetPVarInt(playerid, "YEAH") == 1)
    {
        DestroyObject(GPSObject[playerid]);
        SetPVarInt(playerid, "YEAH",0);
        DeletePVar(playerid, "Spongebob");
        DeletePVar(playerid, "Mario");
        DeletePVar(playerid, "SpiderPig");
        DeletePVar(playerid, "FAIL");
    }
    return 1;
}

I would suggest giving credits for any code that isn't yours.

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 17.03.2015

@Pottus Yeah sorry about that, i used GPS system from FGPS, but not with the other code,
btw thanks.

Re: Vehicle Ownership System (MySQL R39-2) - feheristi97 - 17.03.2015

Doesn't matter.. It is a very nice and usefull script, thanks for sharing!

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 17.03.2015

Quote:

Originally Posted by feheristi97

Doesn't matter.. It is a very nice and usefull script, thanks for sharing!

You're welcome, and thanks for feedback

Re: Vehicle Ownership System (MySQL R39-2) - feheristi97 - 17.05.2015

I have many problems with this filterscript. When you buy a car and you leave from server your name will be saved as 0.. next problem is.. where is the MySQL database? please paste somewhere and fix the vehicle saver because for me isn't working.. I leave and I join back and I get that message I dont have any car.. but is created and I do.

Re: Vehicle Ownership System (MySQL R39-2) - RaeF - 17.05.2015

You,must fill max_len parameter at
cache_get_field_content function for minimize bug, i know this is optional but some people will always got bug about the string won't be saved.

cache_get_field_content(row, const field_name[], destination[], connectionHandle = 1, max_len = sizeof(destination))

From wiki:
Source: https://sampwiki.blast.hk/wiki/MySQL/R33..._field_content

Code:

You have to provide the size (''max_len'') by yourself if you use an enum-array as destination.

Re : Vehicle Ownership System (MySQL R39-2) - tysanio - 23.05.2015

Well can with get the MySQL file?

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 23.05.2015

Quote:

Originally Posted by RaeF

You,must fill max_len parameter at
cache_get_field_content function for minimize bug, i know this is optional but some people will always got bug about the string won't be saved.

cache_get_field_content(row, const field_name[], destination[], connectionHandle = 1, max_len = sizeof(destination))

From wiki:
Source: https://sampwiki.blast.hk/wiki/MySQL/R33..._field_content

Code:

You have to provide the size (''max_len'') by yourself if you use an enum-array as destination.

Actually, i didn't use enum-array as destination on my script.
I used temporary string.
Thanks, btw.
I didn't know that thing.

Quote:

Originally Posted by tysanio

Well can with get the MySQL file?

Im sorry about that

You can download sql file here.
Thanks to inform me

Re : Vehicle Ownership System (MySQL R39-2) - tysanio - 23.05.2015

Thank you

Re: Vehicle Ownership System (MySQL R39-2) - feheristi97 - 23.05.2015

bondowocopz, can you fix the saving then? because when I connect, and I write /mycars I get that message: I dont have any car.. I guess because the NAME string isn't working good.

Re: Vehicle Ownership System (MySQL R39-2) - feheristi97 - 23.05.2015

The problem was the MySQL table.. because you wrote to the owner `owner` int(10) NOT NULL, and you need `owner` varchar(20) NOT NULL. Little mistake but I found it!

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 24.05.2015

Quote:

Originally Posted by tysanio

Thank you

You're welcome

Quote:

Originally Posted by feheristi97

The problem was the MySQL table.. because you wrote to the owner `owner` int(10) NOT NULL, and you need `owner` varchar(20) NOT NULL. Little mistake but I found it!

Sorry, my mistake. Thanks to inform me.
Updated

Re: Vehicle Ownership System (MySQL R39-2) - AdHaM612 - 25.05.2015

Good job, keep it up

Re: Vehicle Ownership System (MySQL R39-2) - X337 - 25.05.2015

Quote:

Originally Posted by AdHaM612

Good job, keep it up

Thanks, i'll

Re: Vehicle Ownership System (MySQL R39-2) - rainbowPUKE - 12.07.2015

Saving doesn't appear to work very well, vehicle positions do not update on disconnect - logging back in they all respawn back the dealership even if park was used.

It'd make more sense to save them where they last were, as they all pile up on top of each other at the dealership? Plate was not updating when new plate was entered..

Not really sure what's going on