16.11.2013, 19:12
I'm having a problem building the SQL table for my DD's. Anyone able to help me build it?
pawn Код:
cache_get_field_content(iRow, "entranceDBID", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iDBID] = strval(szResult);
cache_get_field_content(iRow, "entranceName", entranceData[iRow][e_szName], g_iConnectionHandle[0], sizeof szResult);
cache_get_field_content(iRow, "entranceExteriorVW", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iVW][0] = strval(szResult);
cache_get_field_content(iRow, "entranceInteriorVW", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iVW][1] = strval(szResult);
cache_get_field_content(iRow, "entranceExteriorIntWorld", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iInteriorWorld][0] = strval(szResult);
cache_get_field_content(iRow, "entranceInteriorIntWorld", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iInteriorWorld][1] = strval(szResult);
cache_get_field_content(iRow, "entranceExteriorPosX", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fExterior][0] = floatstr(szResult);
cache_get_field_content(iRow, "entranceExteriorPosY", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fExterior][1] = floatstr(szResult);
cache_get_field_content(iRow, "entranceExteriorPosZ", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fExterior][2] = floatstr(szResult);
cache_get_field_content(iRow, "entranceExteriorPosA", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fExterior][3] = floatstr(szResult);
cache_get_field_content(iRow, "entranceInteriorPosX", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fInterior][0] = floatstr(szResult);
cache_get_field_content(iRow, "entranceInteriorPosY", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fInterior][1] = floatstr(szResult);
cache_get_field_content(iRow, "entranceInteriorPosZ", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fInterior][2] = floatstr(szResult);
cache_get_field_content(iRow, "entranceInteriorPosA", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_fInterior][3] = floatstr(szResult);
cache_get_field_content(iRow, "entranceStreamedExterior", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iStreamed][0] = strval(szResult);
cache_get_field_content(iRow, "entranceStreamedInterior", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iStreamed][1] = strval(szResult);
cache_get_field_content(iRow, "entranceVIP", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iVIP] = strval(szResult); //
cache_get_field_content(iRow, "entranceGang", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iGang] = strval(szResult);
cache_get_field_content(iRow, "entranceGroup", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iGroup] = strval(szResult);
cache_get_field_content(iRow, "entranceGroupType", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iGroupType] = strval(szResult);
cache_get_field_content(iRow, "entranceAdmin", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iAdmin] = strval(szResult);
cache_get_field_content(iRow, "entranceOwnerDBID", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iOwnerDBID] = strval(szResult);
cache_get_field_content(iRow, "entranceOwnerName", entranceData[iRow][e_szOwnerName], g_iConnectionHandle[0], MAX_PLAYER_NAME);
cache_get_field_content(iRow, "entranceWantedLevel", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iWantedLevel] = strval(szResult);
cache_get_field_content(iRow, "entranceVehicleAble", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iVehicleAble] = strval(szResult);
cache_get_field_content(iRow, "entranceColour", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iColour] = strval(szResult);
cache_get_field_content(iRow, "entrancePickupModel", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iPickupModel] = strval(szResult);
cache_get_field_content(iRow, "entranceLocked", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iLocked] = strval(szResult);
cache_get_field_content(iRow, "entrancePass", entranceData[iRow][e_szPass], g_iConnectionHandle[0], sizeof szResult);
cache_get_field_content(iRow, "entranceTracable", szResult, g_iConnectionHandle[0], sizeof szResult); entranceData[iRow][e_iTraceable] = strval(szResult);