undefined symbol "cache_get_data" undefined symbol "cache_get_value_int_ovrld" undefined symbol "cache_get_value_int_ovrld" undefined symbol "cache_get_field_float" undefined symbol "cache_get_field_float" undefined symbol "cache_get_field_float" undefined symbol "cache_get_field_float" undefined symbol "cache_get_value_int_ovrld" undefined symbol "cache_get_value_int_ovrld" |
function Vendor_Load()
{
static rows, fields;
cache_get_data(rows, fields, g_iHandle);
for (new i = 0; i < rows; i ++) if (i < MAX_VENDORS)
{
VendorData[i][vendorExists] = true;
VendorData[i][vendorID] = cache_get_value_int(i, "vendorID");
VendorData[i][vendorType] = cache_get_value_int(i, "vendorType");
VendorData[i][vendorPos][0] = cache_get_field_float(i, "vendorX");
VendorData[i][vendorPos][1] = cache_get_field_float(i, "vendorY");
VendorData[i][vendorPos][2] = cache_get_field_float(i, "vendorZ");
VendorData[i][vendorPos][3] = cache_get_field_float(i, "vendorA");
VendorData[i][vendorInterior] = cache_get_value_int(i, "vendorInterior");
VendorData[i][vendorWorld] = cache_get_value_int(i, "vendorWorld");
Vendor_Refresh(i);
}
return 1;
}
cache_get_value_int(i,"vendorID",VendorData[i][vendorID]); //you do this for every one of them
mysql_tquery(g_SQL, "SELECT * FROM `vendors`", "Vendor_Load", "");
public Vendor_Load()
{
static rows, fields;
for (new i = 0; i < rows; i ++) if (i < MAX_VENDORS)
{
if(cache_num_rows() > 0)
{
VendorData[i][vendorExists] = true;
VendorData[i][vendorID] = cache_get_value_int(i,"vendorID",VendorData[i][vendorID]);
VendorData[i][vendorType] = cache_get_value_int(i,"vendorType",VendorData[i][vendorType]);
VendorData[i][vendorPos][0] = cache_get_value_float(i, "vendorX",VendorData[i][vendorPos][0]);
VendorData[i][vendorPos][1] = cache_get_value_float(i, "vendorY",VendorData[i][vendorPos][1]);
VendorData[i][vendorPos][2] = cache_get_value_float(i, "vendorZ",VendorData[i][vendorPos][2]);
VendorData[i][vendorPos][3] = cache_get_value_float(i, "vendorA",VendorData[i][vendorPos][3]);
VendorData[i][vendorInterior] = cache_get_value_int(i,"vendorInterior",VendorData[i][vendorInterior]);
VendorData[i][vendorWorld] = cache_get_value_int(i,"vendorWorld",VendorData[i][vendorWorld]);
Vendor_Refresh(i);
}
}
return 1;
}
public Vendor_Load()
{
for(new i, j = cache_num_rows(); i != j; i++)
{
if(i < MAX_VENDORS)
{
VendorData[i][vendorExists] = true;
cache_get_value_int(i,"vendorID",VendorData[i][vendorID]);
cache_get_value_int(i,"vendorType",VendorData[i][vendorType]);
cache_get_value_float(i, "vendorX",VendorData[i][vendorPos][0]);
cache_get_value_float(i, "vendorY",VendorData[i][vendorPos][1]);
cache_get_value_float(i, "vendorZ",VendorData[i][vendorPos][2]);
cache_get_value_float(i, "vendorA",VendorData[i][vendorPos][3]);
cache_get_value_int(i,"vendorInterior",VendorData[i][vendorInterior]);
cache_get_value_int(i,"vendorWorld",VendorData[i][vendorWorld]);
Vendor_Refresh(i);
}
}
return 1;
}
[22:35:57] [DEBUG] mysql_tquery(0, "SELECT * FROM `vendors`", "Vendor_Load", "") [22:35:57] [ERROR] mysql_tquery: invalid connection handle \'0\' [22:35:57] [DEBUG] mysql_tquery: return value: \'0\' |
mysql_tquery(g_SQL, "SELECT * FROM `vendors`", "Vendor_Load");
[22:35:57] [ERROR] mysql_tquery: invalid connection handle \'0\'
Just a question OP: How can you select something... before you connect to the mysql server?
|