LANMY.pwN wrote on August 12, 2018, 8:44 am:
Mozes poslati ucitavanje orgi ? Posto ne znam na koji nacin ucitavas 🙂
new q[ 256 ];
mysql_format( _dbConnector, q, sizeof( q ), "SELECT * FROM organizations" );
mysql_pquery( _dbConnector, q, "OnOrganizationsLoad" );
forward OnOrganizationsLoad( );
public OnOrganizationsLoad( ) {
new rows, OrgID, OrgCounter = 1, q[ 128 ];
cache_get_row_count(rows);
if( rows ) {
for( new i = 0; i < rows; i ++ ){
OrgID = OrgCounter;
cache_get_value_name_int( i, "org_id", org_info[ OrgID ][ oID ] );
cache_get_value_name( i, "name", org_info[ OrgID ][ oName ], ORG_IME );
cache_get_value_name( i, "prefix", org_info[ OrgID ][ oPreFix ], 10 );
cache_get_value_name( i, "color", org_info[ OrgID ][ oColor ], 24 );
cache_get_value_name_int( i, "type", org_info[ OrgID ][ oTip ] );
cache_get_value_name_int( i, "suspended", org_info[ OrgID ][ oSuspended ] );
cache_get_value_name_int( i, "max_members", org_info[ OrgID ][ oMaxClanova ] );
org_info[ OrgID ][ oUbacenihClanova ] = 0;
cache_get_value_name_int( i, "male_skin_1", org_info[ OrgID ][ oSkin1 ] );
cache_get_value_name_int( i, "male_skin_2", org_info[ OrgID ][ oSkin2 ] );
cache_get_value_name_int( i, "male_skin_3", org_info[ OrgID ][ oSkin3 ] );
cache_get_value_name_int( i, "male_skin_4", org_info[ OrgID ][ oSkin4 ] );
cache_get_value_name_int( i, "male_skin_5", org_info[ OrgID ][ oSkin5 ] );
cache_get_value_name_int( i, "male_skin_6", org_info[ OrgID ][ oSkin6 ] );
cache_get_value_name_int( i, "female_skin_1", org_info[ OrgID ][ oZSkin1 ] );
cache_get_value_name_int( i, "female_skin_2", org_info[ OrgID ][ oZSkin2 ] );
cache_get_value_name_int( i, "female_skin_3", org_info[ OrgID ][ oZSkin3 ] );
cache_get_value_name_int( i, "female_skin_4", org_info[ OrgID ][ oZSkin4 ] );
cache_get_value_name_int( i, "female_skin_5", org_info[ OrgID ][ oZSkin5 ] );
cache_get_value_name_int( i, "female_skin_6", org_info[ OrgID ][ oZSkin6 ] );
cache_get_value_name( i, "rank_1", org_info[ OrgID ][ oRank1 ], ORG_RANK );
cache_get_value_name( i, "rank_2", org_info[ OrgID ][ oRank2 ], ORG_RANK );
cache_get_value_name( i, "rank_3", org_info[ OrgID ][ oRank3 ], ORG_RANK );
cache_get_value_name( i, "rank_4", org_info[ OrgID ][ oRank4 ], ORG_RANK );
cache_get_value_name( i, "rank_5", org_info[ OrgID ][ oRank5 ], ORG_RANK );
cache_get_value_name( i, "rank_6", org_info[ OrgID ][ oRank6 ], ORG_RANK );
cache_get_value_name_float( i, "enter_pos_x", org_info[ OrgID ][ oPozExtX ] );
cache_get_value_name_float( i, "enter_pos_y", org_info[ OrgID ][ oPozExtY ]);
cache_get_value_name_float( i, "enter_pos_z", org_info[ OrgID ][ oPozExtZ ]);
cache_get_value_name_float( i, "exit_pos_x", org_info[ OrgID ][ oPozIntX ] );
cache_get_value_name_float( i, "exit_pos_y", org_info[ OrgID ][ oPozIntY ] );
cache_get_value_name_float( i, "exit_pos_z", org_info[ OrgID ][ oPozIntZ ] );
cache_get_value_name_int( i, "interior", org_info[ OrgID ][ oInt ] );
cache_get_value_name_int( i, "virtualw", org_info[ OrgID ][ oVw ] );
cache_get_value_name_float( i, "duty_point_pos_x", org_info[ OrgID ][ oDutyPoint ][ 0 ] );
cache_get_value_name_float( i, "duty_point_pos_y", org_info[ OrgID ][ oDutyPoint ][ 1 ] );
cache_get_value_name_float( i, "duty_point_pos_z", org_info[ OrgID ][ oDutyPoint ][ 2 ] );
cache_get_value_name_int( i, "duty_point_int", org_info[ OrgID ][ oDutyInt ] );
cache_get_value_name_int( i, "duty_point_vw", org_info[ OrgID ][ oDutyVW ] );
cache_get_value_name_float( i, "equip_point_pos_x", org_info[ OrgID ][ oEquipPoint ][ 0 ] );
cache_get_value_name_float( i, "equip_point_pos_y", org_info[ OrgID ][ oEquipPoint ][ 1 ] );
cache_get_value_name_float( i, "equip_point_pos_z", org_info[ OrgID ][ oEquipPoint ][ 2 ] );
cache_get_value_name_int( i, "equip_point_int", org_info[ OrgID ][ oEquipInt ] );
cache_get_value_name_int( i, "equip_point_vw", org_info[ OrgID ][ oEquipVW ] );
cache_get_value_name_int( i, "savez", org_info[ OrgID ][ oSavez ] );
cache_get_value_name_float( i, "drug_field_max_x", org_info[ OrgID ][ oDrugFieldMaxX ] );
cache_get_value_name_float( i, "drug_field_min_x", org_info[ OrgID ][ oDrugFieldMinX ] );
cache_get_value_name_float( i, "drug_field_max_y", org_info[ OrgID ][ oDrugFieldMaxY ] );
cache_get_value_name_float( i, "drug_field_min_y", org_info[ OrgID ][ oDrugFieldMinY ] );
cache_get_value_name_float( i, "drug_field_pos_x", org_info[ OrgID ][ oDrugField ][ 0 ] );
cache_get_value_name_float( i, "drug_field_pos_y", org_info[ OrgID ][ oDrugField ][ 1 ] );
cache_get_value_name_float( i, "drug_field_pos_z", org_info[ OrgID ][ oDrugField ][ 2 ] );
cache_get_value_name_float( i, "safe_pos_x", org_info[ OrgID ][ oSafePos ][ 0 ] );
cache_get_value_name_float( i, "safe_pos_y", org_info[ OrgID ][ oSafePos ][ 1 ] );
cache_get_value_name_float( i, "safe_pos_z", org_info[ OrgID ][ oSafePos ][ 2 ] );
cache_get_value_name_int( i, "safe_money", org_info[ OrgID ][ oSafeMoney ] );
cache_get_value_name_int( i, "safe_drug_amount_1", org_info[ OrgID ][ oSafeDrugAmmount ][ 0 ] );
cache_get_value_name_int( i, "safe_drug_amount_2", org_info[ OrgID ][ oSafeDrugAmmount ][ 1 ] );
cache_get_value_name_int( i, "safe_drug_amount_3", org_info[ OrgID ][ oSafeDrugAmmount ][ 2 ] );
cache_get_value_name_int( i, "safe_drug_amount_4", org_info[ OrgID ][ oSafeDrugAmmount ][ 3 ] );
cache_get_value_name_int( i, "safe_mats", org_info[ OrgID ][ oSafeMats ] );
new string[ 256 ];
format( string, sizeof( string ), ""col_white"%s\n{FF6200}Za ulaz u interijer pritisnite\n"col_white"'ENTER'", org_info[ OrgID ][ oName ] );
Org3D[ OrgID ] = Create3DTextLabel( string, -1, org_info[ OrgID ][ oPozExtX ], org_info[ OrgID ][ oPozExtY ], org_info[ OrgID ][ oPozExtZ ], 25, 0, 1);
OrgPickup[ OrgID ] = CreateDynamicPickup(1314, 1, org_info[ OrgID ][ oPozExtX ], org_info[ OrgID ][ oPozExtY ], org_info[ OrgID ][ oPozExtZ ] );
if( org_info[ OrgID ][ oDutyPoint ][ 0 ] != 0 && org_info[ OrgID ][ oDutyPoint ][ 1 ] != 0 ) {
OrgDuty3D[ OrgID ] = CreateDynamic3DTextLabel( ""col_white"[ /undercover ]\n"col_server"[ /duty ]", -1, org_info[ OrgID ][ oDutyPoint ][ 0 ], org_info[ OrgID ][ oDutyPoint ][ 1 ], org_info[ OrgID ][ oDutyPoint ][ 2 ], 5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, org_info[ OrgID ][ oDutyVW ], org_info[ OrgID ][ oDutyInt ], -1, 20.0);
DutyPointPickup[ OrgID ] = CreateDynamicPickup( 1239, 1, org_info[ OrgID ][ oDutyPoint ][ 0 ], org_info[ OrgID ][ oDutyPoint ][ 1 ], org_info[ OrgID ][ oDutyPoint ][ 2 ], org_info[ OrgID ][ oDutyVW ], org_info[ OrgID ][ oDutyInt ], -1, 20.0 );
}
if( org_info[ OrgID ][ oEquipPoint ][ 0 ] != 0 && org_info[ OrgID ][ oEquipPoint ][ 1 ] != 0 ) {
OrgEquip3D[ OrgID ] = CreateDynamic3DTextLabel( ""col_white"Da otvorite meni armorija kucajte\n"col_server"[ /equipment ]", -1, org_info[ OrgID ][ oEquipPoint ][ 0 ], org_info[ OrgID ][ oEquipPoint ][ 1 ], org_info[ OrgID ][ oEquipPoint ][ 2 ], 5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, org_info[ OrgID ][ oEquipVW ], org_info[ OrgID ][ oEquipInt ], -1, 20.0);
EquipPointPickup[ OrgID ] = CreateDynamicPickup( 1239, 1, org_info[ OrgID ][ oEquipPoint ][ 0 ], org_info[ OrgID ][ oEquipPoint ][ 1 ], org_info[ OrgID ][ oEquipPoint ][ 2 ], org_info[ OrgID ][ oEquipVW ], org_info[ OrgID ][ oEquipInt ], -1, 20.0 );
}
if( org_info[ OrgID ][ oDrugField ][ 0 ] != 0 && org_info[ OrgID ][ oDrugField ][ 1 ] != 0 ) {
new stringfield[ 128 ];
format( stringfield, sizeof( stringfield ), ""col_white"Poljana za sadjenje droge\n"col_server"%s", org_info[ OrgID ][ oName ] );
OrgField3d[ OrgID ] = CreateDynamic3DTextLabel( stringfield, -1, org_info[ OrgID ][ oDrugField ][ 0 ], org_info[ OrgID ][ oDrugField ][ 1 ], org_info[ OrgID ][ oDrugField ][ 2 ], 5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, 0, 0, -1, 50.0);
OrgFieldPickup[ OrgID ] = CreateDynamicPickup( 1239, 1, org_info[ OrgID ][ oDrugField ][ 0 ], org_info[ OrgID ][ oDrugField ][ 1 ], org_info[ OrgID ][ oDrugField ][ 2 ], 0, 0, -1, 50.0 );
org_info[ OrgID ][ oDrugFieldRectAngle ] = CreateDynamicRectangle( org_info[ OrgID ][ oDrugFieldMinX ], org_info[ OrgID ][ oDrugFieldMinY ], org_info[ OrgID ][ oDrugFieldMaxX ], org_info[ OrgID ][ oDrugFieldMaxY ], -1, -1, -1 );
}
if( org_info[ OrgID ][ oSafePos ][ 0 ] != 0 && org_info[ OrgID ][ oSafePos ][ 1 ] != 0 ) {
new stringsafe[ 128 ];
format( stringsafe, sizeof( stringsafe ), ""col_white"Sef za koriscenje /orgsef\n"col_server"%s", org_info[ OrgID ][ oName ] );
OrgSafe3d[ OrgID ] = CreateDynamic3DTextLabel( stringsafe, -1, org_info[ OrgID ][ oSafePos ][ 0 ], org_info[ OrgID ][ oSafePos ][ 1 ], org_info[ OrgID ][ oSafePos ][ 2 ], 5, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 0, org_info[ OrgID ][ oVw ], org_info[ OrgID ][ oInt ], -1, 20.0);
OrgSafePickup[ OrgID ] = CreateDynamicPickup( 1239, 1, org_info[ OrgID ][ oSafePos ][ 0 ], org_info[ OrgID ][ oSafePos ][ 1 ], org_info[ OrgID ][ oSafePos ][ 2 ], org_info[ OrgID ][ oVw ], org_info[ OrgID ][ oInt ], -1, 20.0 );
}
org_info[ OrgID ][ oMaxPort ] = 0;
mysql_format( _dbConnector, q, sizeof( q ), "SELECT * FROM org_ports WHERE org_id = '%d'", org_info[ OrgID ][ oID ] );
mysql_pquery( _dbConnector, q, "OnOrganizationPortsLoad", "i", OrgID );
OrgCounter++;
}
new qa[ 256 ];
mysql_format( _dbConnector, qa, sizeof( qa ), "SELECT * FROM `vehicles` WHERE `v_usage` != '1' ORDER BY veh_id ASC" );
mysql_pquery( _dbConnector, qa, "OnVehiclesLoad");
new done = false;
for( new orgica = 1; orgica < MAX_ORG; orgica++ ) {
for( new j = 0; j < 52; j++ ) {
org_members_info[ orgica ][ j ][ o_m_type ] = 0;
strmid( org_members_info[ orgica ][ j ][ o_m_Name ], "Niko", 0, strlen( "Niko" ), MAX_PLAYER_NAME );
org_members_info[ orgica ][ j ][ o_m_sqlID ] = 0;
if( j == 31 ) done = true;
}
}
if( done ) {
mysql_format( _dbConnector, qa, sizeof( qa ), "SELECT org_members.org_id, org_members.memb_rank, org_members.memb_type, org_members.memb_sqlID, users.p_name \
FROM org_members \
INNER JOIN users \
ON org_members.memb_sqlID = users.user_id" );
mysql_pquery( _dbConnector, qa, "OnOrgMembersLoad" );
}
}
else {
//------------
new qa[ 256 ];
mysql_format( _dbConnector, qa, sizeof( qa ), "SELECT * FROM `vehicles` WHERE `v_usage` != '1' ORDER BY veh_id ASC" );
mysql_pquery( _dbConnector, qa, "OnVehiclesLoad");
}
return (true);
}
i imam jos problem kod kreiranja dilera trazi id teritorije
oFile;
format(oFile, sizeof(oFile), FILE_GZONE, strval(inputtext));
if(!fexist(oFile)) return SPD(playerid, dialog_DEALERZONE, DSI, ""server_boja"Server - Diler:", "{FF0000}Ta treitorija ne postoji.\n{FFFFFF}Upišite ID teritorije za dilera:", D_ODABERI, D_ODUSTANI);
Kako da ovo prebacim takodje da prepoznaje u mysql?