Скачать [FS] Динамическая система домов ( MySQL ) | version 2.0

// by Exclusive | Skype: excl-usive | Распространение скрипта без указания автора ЗАПРЕЩЕНО.  

/* Запрос | Query  

CREATE TABLE IF NOT EXISTS `ExclusiveHouses` (  
  `hID` int(11) NOT NULL AUTO_INCREMENT,  
  `EnterX` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `EnterY` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `EnterZ` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `ExitX` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `ExitY` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `ExitZ` varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0.0',  
  `hOwner` varchar(32) CHARACTER SET utf8 NOT NULL DEFAULT 'None',  
  `hPrice` int(11) NOT NULL DEFAULT '200000',  
  `hInt` int(11) NOT NULL DEFAULT '0',  
  `hVW` int(11) NOT NULL DEFAULT '0',  
  `hLock` int(11) NOT NULL DEFAULT '0',  
  PRIMARY KEY (`hID`)  
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1;  

*/  

#include a_samp  
#include a_mysql  

#define MAX_HOUSES 250  
#define DIALOG_HOUSE 540  

native sscanf(const data[], const format[], {Float,_}:...);  

enum hInfo  
{  
  hID,  
  Float: EnterX,  
  Float: EnterY,  
  Float: EnterZ,  
  Float: ExitX,  
  Float: ExitY,  
  Float: ExitZ,  
  hOwner[32],  
  hPrice,  
  hInt,  
  hVW,  
  hLock,  
  Text3D:hLabel,  
  hMapIcon,  
  hPickup  
};  

enum iInfo { iInt, iName [ 70 ], Float: iX, Float: iY, Float: iZ };  

new  

  Query [ 350 ],  
  strin [ 128 ],  
  HouseInfo [ MAX_HOUSES ][ hInfo ],  
  TOTAL_HOUSES,  
  Interiors[ 11 ][ iInfo ]={  
  { 1, "Небольшая спальня [ • ]", 243.7176,304.9697,999.1484 },  
  { 3, "Дом Johnson'а [ • • • ]", 2495.9456,-1692.0854,1014.7422 },  
  { 10,"Заброшенная башня [ • ]", 422.5720,2536.4568,10.0000 },  
  { 5,"Светлая квартира со спальней [ • • ]", 2233.6184,-1115.2618,1050.8828 },  
  { 9,"Двухэтажный дом с зеркальными полами [ • • • ]", 2317.7410,-1026.7661,1050.2178 },  
  { 10,"Одна из комнат отеля Jefferson [ • ]", 2259.3816,-1135.8962,1050.6403 },  
  { 3,"Двухэтажный пятикомнатный дом [ • • • ]", 235.2910,1186.6793,1080.2578 },  
  { 1,"Небольшая четырехкомнатная квартира [ • • ]", 223.1530,1287.0830,1082.1406 },  
  { 5,"Двухэтажный семикомнатный дом [ • • • ]", 226.2990,1114.3126,1080.9929 },  
  { 2,"Пятикомнатная квартирка [ • • ]", 447.0905,1397.0645,1084.3047 },  
  { 10,"Двухэтажная светлая квартирка [ • • ]", 23.9724,1340.1591,1084.3750 } }  

;  

public OnFilterScriptInit ( ) mysql_connect( "localhost" , "root", "SAMP", "" ), LoadMySQLHouses();  

public OnPlayerSpawn ( playerid )  
{  
  for( new i = 0; i < sizeof( HouseInfo ); i++ )  
  {  
  if(!strcmp( HouseInfo[ i ][ hOwner ], "None", true ) ) HouseInfo[ i ][ hMapIcon ] = SetPlayerMapIcon( playerid, i, HouseInfo[ i ][ EnterX ],HouseInfo[ i ][ EnterY ],HouseInfo[ i ][ EnterZ ], 31, -1 );  
  else HouseInfo[ i ][ hMapIcon ] = SetPlayerMapIcon( playerid, i, HouseInfo[ i ][ EnterX ],HouseInfo[ i ][ EnterY ],HouseInfo[ i ][ EnterZ ], 32, -1 );  
  }  
  if( IsPlayerHouseOwner( playerid ) )  
  {  
  SetPlayerInterior( playerid, HouseInfo[ IsPlayerHouseOwner ( playerid ) ][ hInt ] ), SetPlayerVirtualWorld(playerid, HouseInfo[ IsPlayerHouseOwner ( playerid ) ][ hVW ] );  
  SetPlayerPos( playerid, HouseInfo[ IsPlayerHouseOwner ( playerid ) ][ ExitX ], HouseInfo[ IsPlayerHouseOwner ( playerid ) ][ ExitY ] - 3.0, HouseInfo[ IsPlayerHouseOwner ( playerid ) ][ ExitZ ]);  
  SetPVarInt( playerid, "HouseEnter", IsPlayerHouseOwner ( playerid ) );  
  }  
}  

public OnPlayerPickUpPickup(playerid, pickupid)  
{  
  for( new i = 0; i < sizeof( HouseInfo ); i++ )  
  {  
  if(IsPlayerInRangeOfPoint( playerid, 1.0, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] ) )  
  {  
  if(!strcmp( HouseInfo[ i ][ hOwner ], "None", true ) ) format(strin,128,"{FFFFFF}Дом продается.\nВы можете его купить.\nЦена: %i.", HouseInfo [ i ] [ hPrice ] ), ShowPlayerDialog( playerid, DIALOG_HOUSE, DIALOG_STYLE_MSGBOX, "{FFFFFF}Недвижимость", strin, "Купить", "Отмена" );  
  else format(strin,128,"{FFFFFF}Владелец дома: %s.", HouseInfo [ i ] [ hOwner ] ), ShowPlayerDialog( playerid, DIALOG_HOUSE, DIALOG_STYLE_MSGBOX, "{FFFFFF}Недвижимость", strin, "Зайти", "Отмена" );  
  }  
  else if(IsPlayerInRangeOfPoint( playerid, 1.0, HouseInfo[ i ][ ExitX ], HouseInfo[ i ][ ExitY ], HouseInfo[ i ][ ExitZ ] ) && GetPVarInt( playerid, "HouseEnter" ) == i ) SetPVarInt( playerid, "HouseEnter", 255 ), SetPlayerInterior( playerid, 0 ), SetPlayerPos( playerid, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] ), SetPlayerVirtualWorld( playerid, 0 );  
  }  
}  

LoadMySQLHouses ( )  
{  
  mysql_query("SELECT * FROM `ExclusiveHouses` ORDER BY `ExclusiveHouses`.`hID` ASC");  
  mysql_store_result();  
  for(new i; i < TOTAL_HOUSES; i++) strmid( HouseInfo[ i ][ hOwner ], "None", 0, strlen("None"), 24);  
  if(mysql_num_rows() > 0)  
  {  
  for(new h = 1; h <= mysql_num_rows(); h++)  
  {  
  mysql_fetch_row(Query);  
  sscanf(Query, "p<|>iffffffs[24]iiii",HouseInfo[ h ][ hID ],HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ],HouseInfo[ h ][ ExitX ],HouseInfo[ h ][ ExitY ],HouseInfo[ h ][ ExitZ ],HouseInfo[ h ][ hOwner ],HouseInfo[ h ][ hPrice ],HouseInfo[ h ][ hInt ],HouseInfo[ h ][ hVW ],HouseInfo[ h ][ hLock ] );  
  if(!strcmp( HouseInfo[ h ][ hOwner ], "None", true ) )  
  {  
  HouseInfo[ h ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );  
  format(strin,sizeof(strin),"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", h, HouseInfo[ h ][ hPrice ]);  
  }  
  else  
  {  
  HouseInfo[ h ][ hPickup ] = CreatePickup(1318, 1, HouseInfo[ h ][ EnterX ], HouseInfo[ h ][ EnterY ], HouseInfo[ h ][ EnterZ ] );  
  format(strin,sizeof(strin),"Номер дома: %i.\nВладелец дома: %s.", h, HouseInfo[ h ][ hOwner ]);  
  }  
  CreatePickup(19134, 1, HouseInfo[ h ][ ExitX ], HouseInfo[ h ][ ExitY ], HouseInfo[ h ][ ExitZ ], HouseInfo [ h ] [ hVW ] );  
  HouseInfo[ h ][ hLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, HouseInfo[ h ][ EnterX ],HouseInfo[ h ][ EnterY ],HouseInfo[ h ][ EnterZ ], 15.0,0,1);  
  ++ TOTAL_HOUSES;  
  }  
  }  
  mysql_free_result(), printf("[ Система домов ]: Загружено %i домов.", TOTAL_HOUSES);  
}  

PlayerName( playerid )  
{  
  new pName [ 24 ];  
  GetPlayerName( playerid, pName, sizeof pName );  
  return pName;  
}  

UpdateHouseInfo( i )  
{  
  for( new b; b < MAX_PLAYERS; b++ ) RemovePlayerMapIcon( b, HouseInfo[ i ][ hMapIcon ] );  
  DestroyPickup( HouseInfo[ i ][ hPickup ]);  
  if(!strcmp(HouseInfo[ i ][ hOwner ],"None",true))  
  {  
  for( new c; c < MAX_PLAYERS; c++ ) HouseInfo[ i ][ hMapIcon ] = SetPlayerMapIcon( c, i, HouseInfo[ i ][ EnterX ],HouseInfo[ i ][ EnterY ],HouseInfo[ i ][ EnterZ ], 31, -1 );  
  HouseInfo[ i ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] );  
  format( strin, 128,"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", i, HouseInfo[ i ][ hPrice ]);  
  }  
  else  
  {  
  for( new c; c < MAX_PLAYERS; c++ ) HouseInfo[ i ][ hMapIcon ] = SetPlayerMapIcon( c, i, HouseInfo[ i ][ EnterX ],HouseInfo[ i ][ EnterY ],HouseInfo[ i ][ EnterZ ], 32, -1 );  
  HouseInfo[ i ][ hPickup ] = CreatePickup(1318, 1, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] );  
  format( strin, 128,"Номер дома: %i.\nВладелец дома: %s.", i, HouseInfo[ i ][ hOwner ]);  
  }  
  return Update3DTextLabelText( HouseInfo[ i ][ hLabel ], -1, strin);  
}  

public OnPlayerCommandText( playerid, cmdtext[] )  
{  
  if(strcmp("/sellhouse", cmdtext, true) == 0)  
  {  
  for( new i = 0; i < sizeof( HouseInfo ); i++ )  
  {  
  if(IsPlayerInRangeOfPoint( playerid, 1.0, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] ) )  
  {  
  if(!IsPlayerHouseOwner( playerid ) ) SendClientMessage( playerid, -1, "Вы не владелец дома." );  
  format( Query, sizeof( Query ), "UPDATE ExclusiveHouses SET hOwner = 'None' WHERE hID = '%d' LIMIT 1", i );  
  mysql_query( Query ), strmid( HouseInfo[ i ][ hOwner ], "None", 0, strlen( "None" ), 24);  
  GivePlayerMoney( playerid, HouseInfo[ i ][ hPrice ] - 10000 ), SetPlayerPos( playerid, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] ), SetPlayerInterior( playerid, 0 ), SetPlayerVirtualWorld( playerid, 0 );  
  return UpdateHouseInfo ( i );  
  }  
  }  
  }  
  if(strcmp("/createhouse", cmdtext, true) == 0)  
  {  
  if( IsPlayerAdmin ( playerid ) ) ShowPlayerDialog( playerid, DIALOG_HOUSE + 1, DIALOG_STYLE_INPUT, "{FFFFFF}Создание дома", "{FFFFFF}Введите цену дома", "<<<", "Выход" );  
  }  
  return true;  
}  

IsPlayerHouseOwner(playerid)  
{  
  format( Query, sizeof(Query) , "SELECT * FROM ExclusiveHouses WHERE hOwner = '%s'", PlayerName(playerid) );  
  mysql_query( Query );  
  mysql_store_result();  
  if(mysql_num_rows()) return true;  
  return false;  
}  

public OnDialogResponse( playerid, dialogid, response, listitem, inputtext[] )  
{  
  new  
   
  Float: Pos [ 4 ],  
  str [ 400 ]  
   
  ;  
  switch( dialogid )  
  {  
  case DIALOG_HOUSE:  
  {  
  if( response )  
  {  
  for( new i = 0; i < sizeof( HouseInfo ); i++ )  
  {  
  if(IsPlayerInRangeOfPoint( playerid, 1.0, HouseInfo[ i ][ EnterX ], HouseInfo[ i ][ EnterY ], HouseInfo[ i ][ EnterZ ] ) )  
  {  
  if(!strcmp( HouseInfo[ i ][ hOwner ], "None", true ) )  
  {  
  if( GetPlayerMoney ( playerid ) < HouseInfo[ i ][ hPrice ]) return SendClientMessage( playerid, -1, "У вас нет денег для покупки данной недвижимости!" );  
  format( Query, sizeof( Query ), "UPDATE ExclusiveHouses SET hOwner = '%s' WHERE hID = '%d' LIMIT 1", PlayerName ( playerid ), i );  
  mysql_query( Query ), strmid( HouseInfo[ i ][ hOwner ], PlayerName( playerid ), 0, strlen( PlayerName( playerid ) ), 24);  
  GivePlayerMoney( playerid, - HouseInfo[ i ][ hPrice ] ), SetPlayerPos( playerid, HouseInfo[ i ][ ExitX ], HouseInfo[ i ][ ExitY ] - 3.0, HouseInfo[ i ][ ExitZ ] ), SetPlayerInterior( playerid, HouseInfo[ i ][ hInt ] ), SetPlayerVirtualWorld( playerid, HouseInfo[ i ][ hVW ] ), SetPVarInt( playerid, "HouseEnter", i );  
  return UpdateHouseInfo ( i );  
  }  
  else SetPVarInt( playerid, "HouseEnter", i ), SetPlayerPos( playerid, HouseInfo[ i ][ ExitX ], HouseInfo[ i ][ ExitY ]-3.0, HouseInfo[ i ][ ExitZ ] ), SetPlayerInterior( playerid, HouseInfo[ i ][ hInt ] ), SetPlayerVirtualWorld( playerid, HouseInfo[ i ][ hVW ]);  
  }  
  }  
  }  
  }  
  case DIALOG_HOUSE + 1:  
  {  
  if( response )  
  {  
  SetPVarInt( playerid, "HousePrice", strval ( inputtext ) );  
  for(new x = 0; x < sizeof ( Interiors ); x++)  
  {  
  strcat( str, Interiors[ x ][ iName ] ), strcat( str,"\n" );  
  ShowPlayerDialog(playerid, DIALOG_HOUSE + 2 , DIALOG_STYLE_LIST, "{FFFFFF}Выберите интерьер дома", str, "Готово", "Выход");  
  }  
  }  
  }  
  case DIALOG_HOUSE + 2:  
  {  
  if( response )  
  {  
  ++ TOTAL_HOUSES, GetPlayerPos ( playerid, Pos [ 0 ], Pos [ 1 ], Pos [ 2 ] );  
  HouseInfo[ TOTAL_HOUSES ][ hInt ] = Interiors[ listitem ] [ iInt ], HouseInfo[ TOTAL_HOUSES ][ EnterX ] = Pos [ 0 ], HouseInfo[ TOTAL_HOUSES ] [ EnterY ] = Pos [ 1 ], HouseInfo[ TOTAL_HOUSES ] [ EnterZ ] = Pos [ 2 ];  
  HouseInfo[ TOTAL_HOUSES ][ ExitX ] = Interiors[ listitem ][ iX ], HouseInfo[ TOTAL_HOUSES ] [ ExitY ] = Interiors[ listitem ][ iY ], HouseInfo[ TOTAL_HOUSES ] [ ExitZ ] = Interiors[ listitem ][ iZ ];  
  HouseInfo[ TOTAL_HOUSES ][ hPrice ] = GetPVarInt( playerid, "HousePrice" );  
  HouseInfo[ TOTAL_HOUSES ][ hPickup ] = CreatePickup(1273, 1, HouseInfo[ TOTAL_HOUSES ][ EnterX ], HouseInfo[ TOTAL_HOUSES ][ EnterY ], HouseInfo[ TOTAL_HOUSES ][ EnterZ ] );  
  format(strin,sizeof(strin),"Номер дома: %i.\nДом выставлен на продажу!\nЦена: %i.", TOTAL_HOUSES, HouseInfo[ TOTAL_HOUSES ][ hPrice ]);  
  CreatePickup(19134, 1, HouseInfo[ TOTAL_HOUSES ][ ExitX ], HouseInfo[ TOTAL_HOUSES ][ ExitY ], HouseInfo[ TOTAL_HOUSES ][ ExitZ ] );  
  HouseInfo[ TOTAL_HOUSES ][ hLabel ] = Create3DTextLabel(strin, 0xC4DAADFF, HouseInfo[ TOTAL_HOUSES ][ EnterX ], HouseInfo[ TOTAL_HOUSES ][ EnterY ], HouseInfo[ TOTAL_HOUSES ][ EnterZ ], 15.0,0,1);  
  format(Query,sizeof(Query),"INSERT INTO `ExclusiveHouses` (hID,EnterX,EnterY,EnterZ,ExitX,ExitY,ExitZ,hOwner,hPrice,hInt,hVW,hLock) VALUES ('%d','%f','%f','%f','%f','%f','%f','None','%d','%d','%d',0)",TOTAL_HOUSES, HouseInfo[ TOTAL_HOUSES ][ EnterX ], HouseInfo[ TOTAL_HOUSES ][ EnterY ], HouseInfo[ TOTAL_HOUSES ][ EnterZ ],  
  HouseInfo[ TOTAL_HOUSES ][ ExitX ], HouseInfo[ TOTAL_HOUSES ][ ExitY ], HouseInfo[ TOTAL_HOUSES ][ ExitZ ], HouseInfo[ TOTAL_HOUSES ][ hPrice ], HouseInfo[ TOTAL_HOUSES ][ hInt ], TOTAL_HOUSES );  
  mysql_query(Query);  
  }  
  }  
  }  
  return true;  
}