[norton2]

I do not correctly extract [ vServerID ] mysql database !
VehiclesInfo[i][vModel],VehiclesInfo[i][vPositionX],VehiclesInfo[i][vPositionY],VehiclesInfo[i][vPositionZ],VehiclesInfo[i][vAngle],VehiclesInfo[i][vColor1],VehiclesInfo[i][vColor2] are extracted correctly !

Код HTML:

stock LoadVehiclesMySQL()
{
    new Str[128], query[128], i = 1;
    mysql_format(handle, query, sizeof(query), "SELECT * FROM `vehicles`");
    mysql_tquery(handle, query, "", "");

    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row(Str))
        {
            sscanf(Str, "p<|>iffffiiiiiiis[16]iiiiiiiiiiiiiiiiiii", VehiclesInfo[i][vModel], VehiclesInfo[i][vPositionX], VehiclesInfo[i][vPositionY], VehiclesInfo[i][vPositionZ], VehiclesInfo[i][vAngle],
            VehiclesInfo[i][vColor1], VehiclesInfo[i][vColor2], VehiclesInfo[i][vPaintJob], VehiclesInfo[i][vOwner], VehiclesInfo[i][vLock], VehiclesInfo[i][vKM], VehiclesInfo[i][vDays], VehiclesInfo[i][vNumberPlate],
            VehiclesInfo[i][vComponent1], VehiclesInfo[i][vComponent2], VehiclesInfo[i][vComponent3], VehiclesInfo[i][vComponent4], VehiclesInfo[i][vComponent5],
            VehiclesInfo[i][vComponent6], VehiclesInfo[i][vComponent7], VehiclesInfo[i][vComponent8], VehiclesInfo[i][vComponent9], VehiclesInfo[i][vComponent10],
            VehiclesInfo[i][vComponent11], VehiclesInfo[i][vComponent12], VehiclesInfo[i][vComponent13], VehiclesInfo[i][vComponent14], VehiclesInfo[i][vComponent15],
            VehiclesInfo[i][vComponent16], VehiclesInfo[i][vComponent17], VehiclesInfo[i][vServerID], VehiclesInfo[i][vSlot]);
            VehiclesInfo[i][vServerID] = CreateVehicle(VehiclesInfo[i][vModel],VehiclesInfo[i][vPositionX],VehiclesInfo[i][vPositionY],VehiclesInfo[i][vPositionZ],VehiclesInfo[i][vAngle],VehiclesInfo[i][vColor1],VehiclesInfo[i][vColor2],60000);
            mysql_format(handle, query, sizeof(query), "UPDATE `vehicles` SET `ServerID` = '%i' WHERE ID = '%i'", VehiclesInfo[i][vServerID], VehiclesInfo[i][vID]);
            mysql_query(handle, query);
            if(i > MotoCros[20])
            {
                Tunen(i);
            }
            SetVehicleToRespawn(i);
            i++;
        }
    }
    mysql_free_result();
    printf("--- %i vehicles loaded from the MySQL Database. ---", i);
    return 1;
}

Database table:

Код HTML:

CREATE TABLE IF NOT EXISTS `vehicles` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Model` int(11) NOT NULL,
  `PositionX` float NOT NULL,
  `PositionY` float NOT NULL,
  `PositionZ` float NOT NULL,
  `Angle` float NOT NULL,
  `Color1` int(11) NOT NULL,
  `Color2` int(11) NOT NULL,
  `PaintJob` int(11) NOT NULL,
  `Owner` int(11) NOT NULL,
  `Lock` int(11) NOT NULL,
  `KM` int(11) NOT NULL,
  `Days` int(11) NOT NULL,
  `NumberPlate` varchar(16) NOT NULL,
  `Component1` int(11) NOT NULL,
  `Component2` int(11) NOT NULL,
  `Component3` int(11) NOT NULL,
  `Component4` int(11) NOT NULL,
  `Component5` int(11) NOT NULL,
  `Component6` int(11) NOT NULL,
  `Component7` int(11) NOT NULL,
  `Component8` int(11) NOT NULL,
  `Component9` int(11) NOT NULL,
  `Component10` int(11) NOT NULL,
  `Component11` int(11) NOT NULL,
  `Component12` int(11) NOT NULL,
  `Component13` int(11) NOT NULL,
  `Component14` int(11) NOT NULL,
  `Component15` int(11) NOT NULL,
  `Component16` int(11) NOT NULL,
  `Component17` int(11) NOT NULL,
  `ServerID` int(11) NOT NULL,
  `Slot` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

Код HTML:

new v;
        v = PlayerInfo[playerid][pCarKey];
        printf("serverid: %i", VehiclesInfo[v][vServerID]); // debugging.

LOG: serverid: 0
correctly should be: serveri:17

[+REP]

[iZN]

Please learn how the plugin works. This version is quite different as compared to previous versions.

Check this tutorial out (made for older versions (R7, R8), but it should be able to tell you enough): https://sampforum.blast.hk/showthread.php?tid=337810
Example registration system made for R33+: https://sampforum.blast.hk/showthread.php?tid=485633

[norton2]

I need loadcar! No MYSQL Account Registration

[norton2]

bump

[HazardouS]

mysql_tquery uses cached results, here: https://sampwiki.blast.hk/wiki/MySQL/R33#mysql_tquery

Read the example, read the syntax, understand both of them, look for tutorials on Threaded Queries, then fix your problem. It's easy, but you have to be willing to do it.