Importing gangzones from a SQLite database

Importing gangzones from a SQLite database - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Importing gangzones from a SQLite database (/showthread.php?tid=332836)

Importing gangzones from a SQLite database - TheBetaFox - 09.04.2012

pawn Код:

enum eZone {                         
    Float:zMinX,
    Float:zMinY,
    Float:zMaxX,
    Float:zMaxY,
    zTeam,
    zName[32]
}
new ZoneInfo[][eZone] = {
    {2222.56, -1722.33, 2632.83, -1628.53, TEAM_GROVE, "GAN1"},
    {2222.56, -1852.87, 2632.83, -1722.33, TEAM_GROVE, "GAN2"},
    {2703.58, -2126.9, 2959.35, -1852.87, TEAM_GROVE, "PLS"},
    {2137.4, 1703.23, 2437.39, 1783.23, TEAM_MAFIA, "CALI2"}
};

(I have 73 gangzones in the enum, actually, but I won't show all of them to you. :P)
What I want to know is how could I possibly import these gangzones from a SQLite database? I'm not good at SQL, and I use BUD for user management, so yeah... could I have an example of how could I do so? (and possibly of how could I change something in the 'team' column in the database?)
I don't want you to do the entire thing for me, all I need are some examples, so.. help? :3
The ones who help me the most will be rep'd (and you will get free digital pie, who doesn't want that?).