Here is a few suggestions that could make your script better:
1. You are using a query per house rather than one single query for all of the houses. A example of this would be
pawn Код:
new query[256];
new count = 0, i = 0;
mysql_query("SELECT * FROM propertyinfo");
mysql_store_result();
while(mysql_fetch_row(query,"|"))
{
printf("\n|------ Loading Property ID: %d" , i );
new field[22][MAX_PLAYER_NAME];
explode(query, field, "|");
count++;
propertyInfo [i] [E_X] = floatstr( field[ 1 ] );
propertyInfo [i] [E_Y] = floatstr( field[ 2 ] );
propertyInfo [i] [E_Z] = floatstr( field[ 3 ] );
propertyInfo [i] [E_INT] = strval ( field[ 4 ] );
propertyInfo [i] [E_VW] = strval ( field[ 5 ] );
printf("|--- Exterior Info| X: %f | Y: %f | Z: %f" , propertyInfo [i] [E_X],propertyInfo [i] [E_Y],propertyInfo [i] [E_Z] );
printf("|--- INT: %d | VW: %d" , propertyInfo [i] [E_INT],propertyInfo [i] [E_VW] );
propertyInfo [i] [I_X] = floatstr( field[ 6 ] );
propertyInfo [i] [I_Y] = floatstr( field[ 7 ] );
propertyInfo [i] [I_Z] = floatstr( field[ 8 ] );
propertyInfo [i] [I_INT] = strval ( field[ 9 ] );
printf("|--- Interior Info| X: %f | Y: %f | Z: %f" , propertyInfo [i] [I_X],propertyInfo [i] [I_Y],propertyInfo [i] [I_Z] );
printf("|--- INT: %d" , propertyInfo [i] [I_INT]);
propertyInfo [i] [TYPE] = strval ( field[ 10 ] );
propertyInfo [i] [LEVEL] = strval ( field[ 11 ] );
propertyInfo [i] [CASHBOX] = strval ( field[ 12 ] );
printf("|--- Property TYPE: %d | Level: %d | Cashbox: %d" , propertyInfo [i] [TYPE] , propertyInfo [i] [LEVEL] , propertyInfo [i] [CASHBOX] );
propertyInfo [i] [NAME] = field[ 13 ];
propertyInfo [i] [OWNER] = field[ 14 ];
propertyInfo [i] [CO_OWNER] = field[ 15 ];
printf("|--- Name: %s | Owner: %s | Co-Owner: %s" , propertyInfo [i] [NAME] , propertyInfo [i] [OWNER] , propertyInfo [i] [CO_OWNER] );
propertyInfo [i] [SOLD] = strval ( field[ 16 ] );
propertyInfo [i] [LOCK] = strval ( field[ 17 ] );
propertyInfo [i] [ALARM] = strval ( field[ 18 ] );
propertyInfo [i] [PRICE] = strval ( field[ 19 ] );
printf("|--- Sold: %b | Lock Level: %d | Alarm Level: %d | Price: %d" , propertyInfo [i] [SOLD] , propertyInfo [i] [LOCK] , propertyInfo [i] [ALARM], propertyInfo [i] [PRICE]);
propertyInfo [i] [USED_SLOT] = true;
///////////////////////////////////////////////////////////
propertyCP [i] = CreateDynamicCP(propertyInfo [i] [E_X] , propertyInfo [i] [E_Y] , propertyInfo [i] [E_Z] , 2 , propertyInfo [i] [E_VW] , propertyInfo [i] [E_INT] , -1 , 4);
printf("|--- PROPERTYID: %d | Loaded propertyCP: ID: %d" , i , propertyCP[i] );
i++;
}
mysql_free_result();
2. Take out the debugging commands such as /pegarumabufunfa and /pd as they can be used by anyone.
3. You use sscanf for some of it and explode for the other part of it. Use sscanf for the whole thing.
