mysql loading houses
#1

PHP код:
forward    LoadHouses();
public 
LoadHouses()
{
    new 
Hstring[250];
    
mysql_format(sql,Hstring,sizeof(Hstring),"SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC");
    
mysql_tquery(sql,Hstring,"","");
    for(new 
i=0i<= MAX_HOUSES i++)
    {
        
HouseInfo[i][hID] = cache_get_field_content_int(0,"ID");
        
cache_get_field_content(0,"Owner",HouseInfo[i][hOwner],sql,129);
        
HouseInfo[i][hPrice] = cache_get_field_content_int(0,"Price");
        
cache_get_field_content(0,"Name",HouseInfo[i][hDiscription],sql,129);
        
HouseInfo[i][hInteriorX] = cache_get_field_content_float(0,"InteriorX");
        
HouseInfo[i][hInteriorX] = cache_get_field_content_float(0,"InteriorY");
        
HouseInfo[i][hInteriorZ] = cache_get_field_content_float(0,"InteriorZ");
        
HouseInfo[i][hExteriorX] = cache_get_field_content_float(0,"ExteriorX");
        
HouseInfo[i][hExteriorY] = cache_get_field_content_float(0,"ExteriorY");
        
HouseInfo[i][hExteriorZ] = cache_get_field_content_float(0,"ExteriorZ");
        
HouseInfo[i][hOwned] = cache_get_field_content_int(0,"Owned");
        
HouseInfo[i][hRentabil] = cache_get_field_content_int(0,"Rentabil");
        
    }
    
CreateTXD();
    
printf("Houses Loaded!");
    return 
1;

When i boot up the gamemode In the server console the Houses loaded message does not appear and in mysql.log i get this
PHP код:
[09:29:25] [DEBUGmysql_format connection1len250format"SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC"
[09:29:25] [DEBUGmysql_tquery connection1query"SELECT * FROM `houses` ORDER BY `houses`.`ID` ASC"callback"(null)"format"(null)"
[09:29:25] [DEBUGcache_get_field_content_int row0field_name"ID"connection1
[09:29:25] [WARNINGcache_get_field_content_int no active cache
[09:29:25] [DEBUGcache_get_field_content row0field_name"Owner"connection1max_len129
[09:29:25] [WARNINGcache_get_field_content no active cache
[09:29:25] [DEBUGcache_get_field_content_int row0field_name"Price"connection1
[09:29:25] [WARNINGcache_get_field_content_int no active cache
[09:29:25] [DEBUGcache_get_field_content row0field_name"Name"connection1max_len129
[09:29:25] [WARNINGcache_get_field_content no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"InteriorX"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"InteriorY"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"InteriorZ"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"ExteriorX"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"ExteriorY"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_float row0field_name"ExteriorZ"connection1
[09:29:25] [WARNINGcache_get_field_content_float no active cache
[09:29:25] [DEBUGcache_get_field_content_int row0field_name"Owned"connection1
[09:29:25] [WARNINGcache_get_field_content_int no active cache
[09:29:25] [DEBUGcache_get_field_content_int row0field_name"Rentabil"connection1
[09:29:25] [WARNINGcache_get_field_content_int no active cache 
And in game the textures are not loaded.
Reply


Messages In This Thread
mysql loading houses - by TheDarkBlade - 24.09.2016, 06:35
Re: mysql loading houses - by Jstylezzz - 24.09.2016, 07:35
Re: mysql loading houses - by TheDarkBlade - 24.09.2016, 08:10
Re: mysql loading houses - by Jstylezzz - 24.09.2016, 08:53
Re: mysql loading houses - by TheDarkBlade - 24.09.2016, 09:21
Re: mysql loading houses - by Jstylezzz - 24.09.2016, 10:06
Re: mysql loading houses - by TheDarkBlade - 24.09.2016, 14:18
Re: mysql loading houses - by TheDarkBlade - 24.09.2016, 16:49
Re: mysql loading houses - by Jstylezzz - 24.09.2016, 19:03
Re: mysql loading houses - by TheDarkBlade - 25.09.2016, 07:40

Forum Jump:


Users browsing this thread: 2 Guest(s)