#include  <a_actor>

forward  LoadActors();

enum AcInfo
{
            ActorID, // Номер бота
            ActorName[32], // Имя бота
            ActorModel, // ID скина бота
            Float:ActorX, // Координата положения X
            Float:ActorY, // Координата положения Y
            Float:ActorZ, // Координата положения Z
            Float:ActorR // Координата положения R (rotate)
};
new ActorInfo[200][AcInfo], TOTALACTOR = 0;
new Text3D:LABELACTOR[200];

mysql_function_query(DATABASE,"SELECT * FROM `actors`", true, "LoadActors", "");

public LoadActors()
{
               new time = GetTickCount();
               new idx;
               new r, f;
               cache_get_data(r, f);
               for(idx = 1; idx <= r; idx++)
               {
                   ActorInfo[idx][ActorID] = cache_get_row_int(idx-1,0, DATABASE);
                   cache_get_row(idx-1, 1, ActorInfo[idx][ActorName], DATABASE, 32);
                   ActorInfo[idx][ActorModel] = cache_get_row_int(idx-1,2,DATABASE);
                   ActorInfo[idx][ActorX] = cache_get_row_float(idx-1,3, DATABASE);
                   ActorInfo[idx][ActorY] = cache_get_row_float(idx-1,4, DATABASE);
                   ActorInfo[idx][ActorZ] = cache_get_row_float(idx-1,5, DATABASE);
                   ActorInfo[idx][ActorR] = cache_get_row_float(idx-1,6, DATABASE);
                   CreateActor(ActorInfo[idx][ActorModel], ActorInfo[idx][ActorX],ActorInfo[idx][ActorY], ActorInfo[idx][ActorZ], ActorInfo[idx][ActorR]);
               new string[90];
                   format(string, 90, "%s", ActorInfo[idx][ActorName]);
             LABELACTOR[idx] = Create3DTextLabel(string, COLOR_WHITE, ActorInfo[idx][ActorX], ActorInfo[idx][ActorY], ActorInfo[idx][ActorZ] + 1.1, 7.0, 0, 1);
                TOTALACTOR++;
            }
            printf("[загружено актёров]: <%i>. Потрачено: <%i мс>.", TOTALACTOR, GetTickCount()-time);
}

CREATE TABLE IF NOT EXISTS `actors` (
             `ActorID` int(11) NOT NULL AUTO_INCREMENT,
             `ActorName` varchar(32) CHARACTER SET cp1251 COLLATE cp1251_bin NOT NULL,
             `ActorModel` int(11) NOT NULL,
             `ActorX` float NOT NULL,
             `ActorY` float NOT NULL,
             `ActorZ` float NOT NULL,
             `ActorR` float NOT NULL,
             PRIMARY KEY (`ActorID`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=3