[Include] Dynamic race system (Can also be used for missions!)

[Lenny the Cup]

Hello!

I've decided to release my race system, so here you go I haven't been testing it for a long time though, so feel free to leave any suggestions

• Requirements

You will need the following plugins/includes to use this script:

• sscanf by Y_Less
• MySQL plugin by G-sTyLeZzZ
• foreach by Y_Less

• Usage

I have made it simple to use with any command processor by making functions that you can call in your commands like so:

public OnPlayerCommandText(playerid, cmdtext[ ])
{
    if(!strcmp(cmdtext, "/mycommandhere"))
    {
        return LR_CMD_RACECARS(playerid);
    }
}

Or (Depending on your command processor)

CMD:mycommandhere(playerid, params[])
{
    return LR_CMD_RACECARS(playerid);
}

• Callbacks

I will put these into two different categories, one named base and one named optional. Base means they're required to be called in the script for the thing to work, optional means they can be used if you want them.

• Base

• LR_LoadRaces() - Has to be called OnGameModeInit
• LR_OnPlayerEnterRaceCheckpoint(playerid)
• LR_OnDialogResponse(playerid, dialogid, response, listitem)

• Optional

• IsVehicleAllowedInRace(model, raceid)
• LR_CMD_ADDRACE(playerid, params[])
• LR_CMD_ADDCHECKPOINT(playerid, params[])
• LR_CMD_LOADRACEFORALL(playerid)
• LR_CMD_LOADRACEFORPLAYER(playerid)
• LR_CMD_JOINRACE(playerid)
• LR_CMD_LEAVERACE(playerid)
• LR_CMD_READY(playerid)
• LR_CMD_READYALL()
• LR_CMD_RACECARS(playerid)

• Download

Include
SQL schema

[Phanto90]

Nice althought i don't suggest to use mysql for a race system, especially to store checkpoint coords (there are also users that cannot administrate their own database, or simply don't want)
Maybe create another version that stores coords simply in a txt files
Anyway nice job

[Lenny the Cup]

Yes, I might add a define and work with textfiles if this turns out to be popular, I only put it here to share though since I don't mind it being used outside my private server

[Basicz]

Looking very nice!
But can you make it on a normal text file, without MYSQL?
Btw, how to make a beautiful ASCII text like that!

Originally Posted by Pantho90

(there are also users that cannot administrate their own database, or simply don't want)

^
|
|

[Lenny the Cup]

I used phpMyAdmin to export the tables

[Resort]

Thanks for the release. =]

[Donya]

Originally Posted by Phanto90

Nice althought i don't suggest to use mysql for a race system, especially to store checkpoint coords (there are also users that cannot administrate their own database, or simply don't want)
Maybe create another version that stores coords simply in a txt files
Anyway nice job

i dont see why, mysql was made to store thousands of rows?

i have a 360,000 row table. it takes like 75 ms to select from it, nothing to much.

anyways, got any videos :P?

[Phanto90]

Originally Posted by Donya

i dont see why, mysql was made to store thousands of rows?

i have a 360,000 row table. it takes like 75 ms to select from it, nothing to much.

anyways, got any videos :P?

You are absolutely right, but many users don't even know what is a database, so the "public release range" will be less than with a second release with a modifyied system. I'm not suggesting to delete what he has done, but modify and release a second version that supports .txt files

And consider that you should have a dabatase running on the same machine where your running samp server if you want good timing result and not all host offer this possibility.

[Basicz]

Hmm, can anyone make a test filterscript?
I don't really understand how it works.

[Donya]

Originally Posted by Phanto90

You are absolutely right, but many users don't even know what is a database, so the "public release range" will be less than with a second release with a modifyied system. I'm not suggesting to delete what he has done, but modify and release a second version that supports .txt files

And consider that you should have a dabatase running on the same machine where your running samp server if you want good timing result and not all host offer this possibility.

hmm, i guess so. mysql does slow down while selecting from a home server. a .txt support will be good too, for other users i guess.

good work anyways!