Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

[Заказ] Сделать табличку MySQL

Статус
В этой теме нельзя размещать новые ответы.

dimazhelek

Специалист
Нужно сделать таблицу под этот код




1. Что вам требуется : Создать табличку под этот код
PHP:
///

#include <a_samp>
#include <a_mysql>
#include <sscanf2>
#include <a_http>
#include <regex>
//***************************DEFINE*********************
forward MailResponse(index, response_code, data[]);
#define MAX_MAIL_LENGTH 1024
#define IsValidEmail(%1) \
    regex_match(%1, "[a-zA-Z0-9_\\.]+@([a-zA-Z0-9\\-]+\\.)+[a-zA-Z]{2,4}")
#define public:%1(%2) forward %1(%2);\
                                                                public %1(%2)
#define DEBUG 1
#define ServerName "NewPWN!!!!!!"
#define SQL_HOST "localhost"
#define SQL_DB "samp"
#define SQL_USER "root"
#define SQL_PASS "123"
#define TEAM_AZTECAS_COLOR 0x01FCFFC8

new
    gPlayerLogged[MAX_PLAYERS];
enum
    pInfo
        {
            pId,
            pMoney,
            pEmail,
            pCode,
            pActivated,
            pMember,
            pLeader,
            pQuest,
            pSex,
            pSkin
        }
;

new
    tempding[MAX_PLAYERS];
new
    TextDrawl[MAX_PLAYERS];
new
    PlayerInfo[MAX_PLAYERS][pInfo];
new
    sex[MAX_PLAYERS]=0;
new
    Text3D:Temp3d[MAX_PLAYERS];
    
enum bInfo
{
        bId,
        bOwned,
        bOwner[64],
        bMessage[128],
        bExtortion[MAX_PLAYER_NAME],
        Float:bEntranceX,
        Float:bEntranceY,
        Float:bEntranceZ,
        Float:bExitX,
        Float:bExitY,
        Float:bExitZ,
        bLevelNeeded,
        bBuyPrice,
        bEntranceCost,
        bTill,
        bLocked,
        bInterior,
        bProducts,
        bMaxProducts,
        bPriceProd,
        Text3D:b3d,
        bPickup,
};
new BizzInfo[20][bInfo];
enum hInfo
{
        hId,
        Float:hEntrancex,
        Float:hEntrancey,
        Float:hEntrancez,
        Float:hExitx,
        Float:hExity,
        Float:hExitz,
        hHealthx,
        hHealthy,
        hHealthz,
        hArmourx,
        hArmoury,
        hArmourz,
        hOwner[MAX_PLAYER_NAME],
        hDiscription[MAX_PLAYER_NAME],
        hValue,
        hHel,
        hArm,
        hInt,
        hLock,
        hOwned,
        hRooms,
        hRent,
        hRentabil,
        hTakings,
        hVec,
        hVcol1,
        hVcol2,
        hDate,
        hLevel,
        hVirtual,
        hPickup,
        Text3D:hB3d
};
new
    skins[5][2] = {{20,55},{26,56},{37,69},{60,76},{94,215}};
new
    HouseInfo[681][hInfo];
new
    SpawnTimer[MAX_PLAYERS];
new
    cam[MAX_PLAYERS] = 0;
new
    busines = 0, houses = 0;
    
stock Name(playerid){ new nsame[24]; GetPlayerName(playerid,nsame,24); return nsame;}

new
    gPlayerUsingLoopingAnim[MAX_PLAYERS];
new
    Text:Polosa1[MAX_PLAYERS]; // черный экран
new
    Text:txtSprite1;
new
    quest[MAX_PLAYERS] = 0;

LoopingAnim(playerid,animlib[],animname[], Float:Speed, looping, lockx, locky, lockz, lp){
    gPlayerUsingLoopingAnim[playerid] = 1;
    ApplyAnimation(playerid, animlib, animname, Speed, looping, lockx, locky, lockz, lp,1);}
OnePlayAnim(playerid,animlib[],animname[], Float:Speed, looping, lockx, locky, lockz, lp){
        ApplyAnimation(playerid, animlib, animname, Speed, looping, lockx, locky, lockz, lp,1);}
StopLoopingAnim(playerid){
        gPlayerUsingLoopingAnim[playerid] = 0;
    ApplyAnimation(playerid, "CARRY", "crry_prtial", 4.0, 0, 0, 0, 0, 0);}

public OnGameModeInit()
{
        Connection();
        DisableInteriorEnterExits();
        LoadBizz();
        SetGameModeText("Blank Script");
        //ОСТРОВ
        CreateObject(1337,-8228.61621094,1332.19787598,0.00000000,0.00000000,0.00000000,0.00000000); //object(binnt07_la) (2)
        CreateObject(16192,-8192.00000000,1353.05468750,-41.15000153,0.00000000,0.00000000,347.99743652); //object(cen_bit_01) (2)
        CreateObject(16192,-8218.50000000,1172.36865234,-41.09999847,0.00000000,0.00000000,163.24902344); //object(cen_bit_01) (3)
        CreateObject(711,-8192.00000000,1277.45996094,6.98190022,0.00000000,13.24951172,339.99938965); //object(vgs_palm02) (1)
        CreateObject(806,-8248.38281250,1214.69555664,3.39560008,0.00000000,0.00000000,0.00000000); //object(genveg_tallgrass) (1)
        CreateObject(16192,-8072.71777344,1291.15161133,-81.93499756,0.00000000,0.00000000,307.99743652); //object(cen_bit_01) (2)
        CreateObject(711,-8194.21289062,1278.27026367,6.98190022,0.00000000,13.24401855,189.98840332); //object(vgs_palm02) (1)
        CreateObject(2974,-8155.77539062,1289.44067383,0.25000000,0.00000000,292.25000000,0.00000000); //object(k_cargo1) (1)
        //КОНЕЦ ОСТРОВА
        //БОЛЬНИЦА
        CreateObject(18007,-2619.63574219,647.30010986,51.11289978,0.00000000,0.00000000,270.00000000); //object(int_barbera12) (1)
        CreateObject(1491,-2622.25292969,651.80419922,48.99570084,0.00000000,0.00000000,268.50000000); //object(gen_doorint01) (1)
        CreateObject(2946,-2648.79687500,655.08062744,27.23660088,0.00000000,0.00000000,88.00000000); //object(cr_door_03) (1)
        CreateObject(2946,-2622.75878906,640.74609375,51.32080078,0.00000000,0.00000000,90.74707031); //object(cr_door_03) (2)
        CreateObject(1649,-2619.56152344,647.67138672,51.44219971,0.00000000,0.00000000,269.75000000); //object(wglasssmash) (1)
        CreateObject(1649,-2619.58227539,643.32189941,51.44219971,0.00000000,0.00000000,269.74182129); //object(wglasssmash) (2)
        CreateObject(1671,-2620.86303711,649.27099609,49.46319962,0.00000000,0.00000000,300.75000000); //object(swivelchair_a) (1)
        CreateObject(1998,-2620.83349609,648.45751953,48.89569855,0.00000000,0.00000000,90.75000000); //object(officedesk1l) (1)
        CreateObject(1723,-2619.97167969,640.13977051,49.02450180,0.00000000,0.00000000,182.25000000); //object(mrk_seating1) (1)
        CreateObject(2311,-2620.30053711,641.16870117,48.99570084,0.00000000,0.00000000,181.00000000); //object(cj_tv_table2) (1)
        CreateObject(2601,-2621.24291992,641.15917969,49.58459854,0.00000000,0.00000000,0.00000000); //object(cj_juice_can) (1)
        CreateObject(2251,-2620.97729492,648.28210449,50.55110168,0.00000000,0.00000000,0.00000000); //object(plant_pot_20) (1)
        CreateObject(2826,-2621.75756836,641.11499023,49.50120163,0.00000000,0.00000000,0.00000000); //object(gb_novels04) (1)
        CreateObject(2828,-2621.37622070,648.30169678,49.70819855,0.00000000,0.00000000,0.00000000); //object(gb_ornament02) (1)
        CreateObject(2841,-2621.36059570,653.59472656,49.00299835,0.00000000,0.00000000,0.00000000); //object(gb_bedrug03) (1)
        CreateObject(2131,-2621.35351562,654.81188965,49.00299835,0.00000000,0.00000000,0.00000000); //object(cj_kitch2_fridge) (1)
        CreateObject(14602,-2644.84326172,662.07397461,32.70819855,0.00000000,0.00000000,358.00000000); //object(paperchase01) (1)
        CreateObject(14596,-2656.33007812,679.86999512,37.99129868,0.00000000,0.00000000,177.50000000); //object(paperchase_stairs) (2)
        CreateObject(11455,-2667.97949219,663.16772461,29.51160049,0.00000000,0.00000000,267.75000000); //object(des_medcensgn01) (1)
        CreateObject(7313,-2667.70825195,663.18231201,29.91110039,0.00000000,0.00000000,88.00000000); //object(vgsn_scrollsgn01) (1)
        CreateObject(2773,-2667.85302734,663.06530762,27.70700073,0.00000000,172.50000000,358.00000000); //object(cj_airprt_bar) (1)
        CreateObject(2775,-2668.29125977,650.49890137,30.02260017,0.00000000,0.00000000,87.25000000); //object(cj_airprt_mon) (1)
        CreateObject(2274,-2659.10253906,677.75012207,28.42690086,0.00000000,0.00000000,357.50000000); //object(frame_fab_6) (1)
        CreateObject(2946,-2622.75878906,640.74609375,48.99570084,0.00000000,0.00000000,90.74707031); //object(cr_door_03) (3)
        CreateObject(2946,-2648.79248047,655.00518799,29.53660011,0.00000000,0.00000000,87.99499512); //object(cr_door_03) (4)
        CreateObject(2946,-2648.79199219,655.00488281,29.78660011,0.00000000,0.00000000,87.99499512); //object(cr_door_03) (5)
        CreateObject(9131,-2655.56738281,678.59838867,28.17379951,0.00000000,0.00000000,358.00000000); //object(shbbyhswall13_lvs) (1)
        CreateObject(9131,-2655.56738281,678.59771729,29.57379913,0.00000000,0.00000000,357.98950195); //object(shbbyhswall13_lvs) (2)
        CreateObject(9131,-2652.97753906,678.44531250,29.57379913,0.00000000,0.00000000,357.97851562); //object(shbbyhswall13_lvs) (3)
        CreateObject(9131,-2652.97753906,678.44531250,28.32379913,0.00000000,0.00000000,357.97851562); //object(shbbyhswall13_lvs) (4)
        CreateObject(9131,-2654.29785156,678.55371094,30.12380028,0.00000000,269.74978638,357.97851562); //object(shbbyhswall13_lvs) (5)
        //БОЛЬНИЦА КОНЕЦ
        AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
        //SetObjectRoted("s","3");
        LoadHouse();
        return 1;
}

stock SendMail(mail[], code, nick[]){new string[128];
    format(string, sizeof(string), "mail=%s&code=%d&nick=%s",mail,code,nick);
    HTTP(1, HTTP_POST, "/mail.php", string, "MailResponse");}

public OnGameModeExit(){mysql_close();return 1;}

public OnPlayerRequestClass(playerid, classid)
{
        /*SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
        SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
        SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);*/
        ClearChat(playerid,20);
        SetSpawnInfo( playerid, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 );
        new rand = random(5);
        printf ("%d",rand);
        SetPlayerSkin(playerid,skins[rand][sex[playerid]-1]);
        SpawnPlayer(playerid);
        return 1;
}

public OnPlayerConnect(playerid)
{
        new query[256];
        new string[255];
        Polosa1[playerid] = TextDrawCreate(0.000000,0.000000,"-");
        TextDrawUseBox(Polosa1[playerid],1);
        TextDrawBoxColor(Polosa1[playerid],0x0000000);
        TextDrawTextSize(Polosa1[playerid],640.000000,480.000000);
        TextDrawAlignment(Polosa1[playerid],0);
        TextDrawBackgroundColor(Polosa1[playerid],0x00000000);
        TextDrawFont(Polosa1[playerid],3);
        TextDrawLetterSize(Polosa1[playerid],640.000000,480.899999);
        TextDrawColor(Polosa1[playerid],0x00000000);
        TextDrawSetOutline(Polosa1[playerid],1);
        TextDrawSetProportional(Polosa1[playerid],1);
        TextDrawSetShadow(Polosa1[playerid],1);
        TextDrawHideForAll(Polosa1[playerid]);
        txtSprite1 = TextDrawCreate(0.0, 0.0, "loadsc14:loadsc14"); // Text is txdfile:texture
        TextDrawFont(txtSprite1, 4); // Font ID 4 is the sprite draw font
        TextDrawColor(txtSprite1,0xFFFFFFFF);
        TextDrawTextSize(txtSprite1,640.0,480.0); // Text size is the Width:Height
        TextDrawHideForAll(txtSprite1);
        gPlayerLogged[playerid] = 0;
        new ips[13];
        GetPlayerIp(playerid,ips,13);
        cam[playerid]=0;
        format(query, sizeof(query), "INSERT INTO logins (time,ip,username,userid,whence,logged) VALUES (UNIX_TIMESTAMP(),'%s','%s', 0, 2,1)", ips, Name(playerid),PlayerInfo[playerid][pId]);
        mysql_query(query);
        format(query,256,"Select * from users where Username = '%s' and quest = '1'",Name(playerid));
        mysql_query(query);
        mysql_store_result();
        if(mysql_num_rows()==1)
        {
                TextDrawShowForPlayer(playerid,txtSprite1);
                format(string,sizeof(string),"Введите свой пароль для авторизации под аккаунтом: %s",Name(playerid));
                ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Авторизация",string,"OK","Отмена");
        }
        else
        {
                if(sex[playerid]==0)
                {
                        TextDrawBoxColor(Polosa1[playerid],0x000000FF);
                        TextDrawColor(Polosa1[playerid],0x000000FF);
                        TextDrawBackgroundColor(Polosa1[playerid],0x000000FF);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);
                        ShowPlayerDialog(playerid,5,DIALOG_STYLE_MSGBOX,"SL-RP","Выберите ваш пол: ","Мужской","Женский");
                }
                else
                {
                Quest(playerid);
                }
                //SpawnTimer[playerid] = SetTimerEx("MovingCamera",25,1,"i",playerid);
                /*SetPlayerPos(playerid, 1.9173,30.1166,1199.5938);
                SetPlayerFacingAngle(playerid, 0);
                SetCameraBehindPlayer(playerid);
                SetPlayerInterior(playerid, 1);
                SetPlayerVirtualWorld(playerid, 2);*/
                /*format(string,sizeof(string),"Передвижные дома с интами\n- Система личных автомобилей\n- Система домов\n- Система бизнесов\n- Множество фракций\n- Много новых работ\n- Новый город\n- Профессиональная администрация\nВведите свой пароль для регистрации под аккаунтом: %s",Name(playerid));
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Регистрация",string,"OK","Отмена");*/
        }
        mysql_free_result();
        return 1;
}
stock Quest(playerid)
{
                TextDrawHideForPlayer(playerid,Polosa1[playerid]);
                KillTimer(SpawnTimer[playerid]);
                quest[playerid] = 0;
                SpawnPlayer(playerid);
                OnPlayerSpawn(playerid);
                TextDrawHideForPlayer(playerid,Polosa1[playerid]);
                PlayAudioStreamForPlayer(playerid, "http://sl-rp.com/1.mp3");
                return 1;
}
stock OnPlayerLogin(playerid,password[])
{
        if(gPlayerLogged[playerid] == 0)
        {
                //new result[1024];
                new query[256];
                new string[255];
                format(query,256,"Select id,money,activated,member,leader from users where Username = '%s' and Password = '%s'",Name(playerid),password);
                mysql_query(query);
                mysql_store_result();
                if(mysql_num_rows() ==0)
                {
                        mysql_free_result();
                        format(string,sizeof(string),"Неверный пароль\nВведите свой пароль для авторизации под аккаунтом: %s",Name(playerid));
                        ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Добро пожаловать, назад на наш сервер",string,"OK","Отмена");
                        return 1;
                }
                else
                {
                        //загрузка переменных аля  BaseGetInt("название столбца",переменная для записи");
                        mysql_fetch_row_format(query, "|");
                        print(query);
                        sscanf(query,"p<|>iiiiiiii",
                        PlayerInfo[playerid][pId],
                        PlayerInfo[playerid][pMoney],
                        PlayerInfo[playerid][pActivated],
                        PlayerInfo[playerid][pMember],
                        PlayerInfo[playerid][pLeader],
                        PlayerInfo[playerid][pQuest],
                        PlayerInfo[playerid][pSex],
                        PlayerInfo[playerid][pSkin]);
                        printf("Nick: %s,UID: %d,Money: %d,Activated: %d,Member: %d,Leader: %d, Quest: %d, Sex: %d, Skin: %d",Name(playerid),PlayerInfo[playerid][pId],PlayerInfo[playerid][pMoney],PlayerInfo[playerid][pActivated],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pLeader],
                        PlayerInfo[playerid][pQuest],
                        PlayerInfo[playerid][pSex],
                        PlayerInfo[playerid][pSkin]);
                }
                mysql_free_result();
                if(PlayerInfo[playerid][pActivated]==1)
                {
                        TextDrawHideForPlayer(playerid,txtSprite1);
                        gPlayerLogged[playerid] = 1;
                        SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Вы успешно авторизировались");
                        GivePlayerMoney(playerid,PlayerInfo[playerid][pMember]);
                        SetPlayerScore(playerid,PlayerInfo[playerid][pId]);
                        new ips[13];
                        GetPlayerIp(playerid,ips,13);
                        format(query, sizeof(query), "INSERT INTO logins (time,ip,username,userid,whence,logged) VALUES (UNIX_TIMESTAMP(),'%s','%s', %d, 2,2)", ips, Name(playerid),PlayerInfo[playerid][pId]);
                        mysql_query(query);
                }
                else
                {
                        format(string,sizeof(string),"Введите код полученный на электронную почту, указанную ранее.",Name(playerid));
                        ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Активация",string,"OK","Отмена");
                }
                return 1;
        }
        else { SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Вы уже авторизировались"); return 0;}
}
stock OnPlayerRegister(playerid,password[])
{
        if(gPlayerLogged[playerid] == 0)
        {
                mysql_free_result();
                new query[1024];
                new string[255];
                new year, month, day;
                getdate(year, month, day);
                new ips[13];
                GetPlayerIp(playerid,ips,13);
                format(query, sizeof(query), "INSERT INTO users (Username, Password, start_ip, DateReg,Sex,Skin) VALUES ('%s', '%s', '%s', UNIX_TIMESTAMP(),'%d','%d')", Name(playerid), password, ips,sex[playerid],GetPlayerSkin(playerid));
                mysql_query(query);
                mysql_free_result();
                format(string,sizeof(string),"Введите ваш адресс электронной почты.");
                ShowPlayerDialog(playerid,4,DIALOG_STYLE_INPUT,"E-mail",string,"OK","Отмена");
                return 1;
        }
        else { SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Вы уже зарегестрировались"); return 0;}
}
stock OnPlayerEmail(playerid,email[])
{
        new query[128];
        new code= 1000000+ random(9999999);
        printf("%d",code,code);
        SendMail(email, code, Name(playerid));
        format(query, sizeof(query), "UPDATE users SET code = %d WHERE Username = '%s'", code, Name(playerid));
        mysql_query(query);
        mysql_free_result();
        return 1;
}
stock OnPlayerActivated(playerid,code[])
{

        new string[255];
        new query[128];
        format(query,256,"Select * from users where Username = '%s' and Code = '%d'",Name(playerid),strval(code));
        mysql_query(query);
        mysql_store_result();
        if(mysql_num_rows() ==0)
        {
                SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Ошибка активации");
                format(string,sizeof(string),"Введенный код не соответствует действительности.\n Введите код от аккаунта: %s",Name(playerid));
                ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Активация",string,"OK","Отмена");
                return 1;
        }
        PlayerInfo[playerid][pActivated]=1;
        gPlayerLogged[playerid] = 1;
        TextDrawHideForPlayer(playerid,txtSprite1);
        SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Вы успешно активировали ваш аккаунт и авторизировались");
        SetPlayerVirtualWorld(playerid,0);
        format(query, sizeof(query), "UPDATE users SET activated = %d WHERE Username = '%s'", PlayerInfo[playerid][pActivated],Name(playerid));
        mysql_query(query);
        new ips[13];
        GetPlayerIp(playerid,ips,13);
        format(query, sizeof(query), "INSERT INTO logins (time,ip,username,userid,whence,logged) VALUES (UNIX_TIMESTAMP(),'%s','%s', %d, 2,2)", ips, Name(playerid),PlayerInfo[playerid][pId]);
        mysql_query(query);
        mysql_store_result();
        return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
        new str[64];
        switch (reason){
                case 0: format(str, sizeof(str), " %s[%d]вылетел(а) из игры", Name(playerid),playerid);
                case 1: format(str, sizeof(str), " %s[%d] вышeл из игры", Name(playerid),playerid);
                case 2: format(str, sizeof(str), " %s[%d] кикнут(а) или забанен(а)", Name(playerid),playerid);}
        TextDrawDestroy(Polosa1[playerid]);
        KillTimer(TextDrawl[playerid]);
        SendClientMessageToAll(-1, str);
        return 1;
}

public OnPlayerSpawn(playerid)
{
        if(cam[playerid]!=10000){
                SetPlayerVirtualWorld(playerid,playerid+1);
                TextDrawHideForPlayer(playerid,Polosa1[playerid]);
                KillTimer(SpawnTimer[playerid]);
                SetPlayerPos(playerid, 2.966561,28.121681,1200.078125);
                SetPlayerFacingAngle(playerid, 0);
                SetCameraBehindPlayer(playerid);
                SetPlayerInterior(playerid, 1);
                LoopingAnim(playerid,"BEACH", "ParkSit_M_loop", 4.0, 1, 0, 0, 0, 0); // Sit
                SpawnTimer[playerid] = SetTimerEx("MovingCamera",1000,1,"i",playerid);}
        else{
                TextDrawShowForPlayer(playerid,txtSprite1);
                new string[256];
                format(string,sizeof(string),"Введите свой пароль для регистрации под аккаунтом: %s",Name(playerid));
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Регистрация",string,"OK","Отмена");}
        return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
        new cmd[256];
        new tmp[256];
        new string[1024];
        new idx;
        cmd = strtok(cmdtext, idx);
        if(!strcmp(cmd,"/vw",true))
        {
                format(string,sizeof(string),"%d",GetPlayerVirtualWorld(playerid));
                SendClientMessage(playerid,-1,string);
        }
        if(strcmp(cmd, "/enter", true) == 0)
        {
            if(IsPlayerConnected(playerid))
                {
                        new query[256];
                        //new string[255];
                        format(query,256,"Select * from houses");
                        mysql_query(query);
                        mysql_store_result();
                        new l=mysql_num_rows();
                        for(new i = 1; i <= l; i++)
                        {
                                if (IsPlayerInRangeOfPoint(playerid,3,HouseInfo[i][hEntrancex], HouseInfo[i][hEntrancey], HouseInfo[i][hEntrancez]))
                                {
                                        printf("Found House :%d",i);
                                        SetPlayerInterior(playerid,HouseInfo[i][hInt]);
                                        SetPlayerPos(playerid,HouseInfo[i][hExitx],HouseInfo[i][hExity],HouseInfo[i][hExitz]);
                                        GameTextForPlayer(playerid, "~w~Welcome Home", 5000, 1);
                                        SetPlayerVirtualWorld(playerid,HouseInfo[i][hVirtual]);
                                        return 1;

                                }
                        }
                        //new string[255];
                        format(query,256,"Select * from bizz");
                        mysql_query(query);
                        //mysql_store_result();
                        l=mysql_num_rows();
                        for(new i = 1; i <= l; i++)
                        {
                                if (IsPlayerInRangeOfPoint(playerid,3,BizzInfo[i][bEntranceX], BizzInfo[i][bEntranceY], BizzInfo[i][bEntranceZ]))
                                {
                                        printf("Found Bizz :%d",i);
                                        SetPlayerInterior(playerid,BizzInfo[i][bInterior]);
                                        SetPlayerPos(playerid,BizzInfo[i][bExitX],BizzInfo[i][bExitY],BizzInfo[i][bExitZ]);
                                        //PlayerInfo[playerid][pLocal] = i;
                                        return 1;
                                }
                        }
                        mysql_free_result();
                }
        }
        if(strcmp(cmd, "/exit", true) == 0)
        {
            if(IsPlayerConnected(playerid))
                {
                        for(new i = 1; i <= houses; i++)
                        {
                                if (IsPlayerInRangeOfPoint(playerid,3,HouseInfo[i][hExitx], HouseInfo[i][hExity], HouseInfo[i][hExitz]) && GetPlayerVirtualWorld(playerid)==HouseInfo[i][hVirtual])
                                {
                                        //printf("Found House :%d",i);
                                        SetPlayerInterior(playerid,0);
                                        SetPlayerPos(playerid,HouseInfo[i][hEntrancex],HouseInfo[i][hEntrancey],HouseInfo[i][hEntrancez]);
                                        GameTextForPlayer(playerid, "~w~Welcome Home", 5000, 1);
                                        SetPlayerVirtualWorld(playerid,0);
                                        return 1;
                                }
                        }
                        for(new i = 1; i <= busines; i++)
                        {
                                if (IsPlayerInRangeOfPoint(playerid,3,BizzInfo[i][bExitX], BizzInfo[i][bExitY], BizzInfo[i][bExitZ]))
                                {
                                        printf("Found Bizz :%d",i);
                                        SetPlayerInterior(playerid,0);
                                        SetPlayerPos(playerid,BizzInfo[i][bEntranceX],BizzInfo[i][bEntranceY],BizzInfo[i][bEntranceZ]);
                                        //PlayerInfo[playerid][pLocal] = i;
                                        return 1;
                                }
                        }
                        mysql_free_result();
                }
        }
        if(strcmp(cmd, "/saveall", true) == 0)
        {
            new Float:x, Float:y, Float:z, i;
                GetPlayerPos(playerid,x,y,z);
                i = GetPlayerInterior(playerid);
                printf("x: %f y: %f z: %f INT: %i",x,y,z,i);
                return 1;
        }
        if(strcmp(cmd, "/больница", true) == 0)
        {
            SetPlayerPos(playerid,-2648.79687500,655.08062744,27.23660088);
                return 1;
        }
        if(strcmp(cmd, "/vehcar", true) == 0)
        {
            if(IsPlayerConnected(playerid))
            {
                        tmp = strtok(cmdtext, idx);
                        if(!strlen(tmp))
                        {
                                SendClientMessage(playerid, -1, " Используйте: /veh [carid] [color1] [color2]");
                                Lodka(playerid);
                                return 1;
                        }
                        new car;
                        car = strval(tmp);
                        if(car < 400 || car > 611) { SendClientMessage(playerid, -1, "   Число Транспортного средства не может быть ниже 400 или выше 611 !"); return 1; }
                        tmp = strtok(cmdtext, idx);
                        if(!strlen(tmp))
                        {
                                SendClientMessage(playerid, -1, " Используйте: /veh [carid] [color1] [color2]");
                                return 1;
                        }
                        new color1;
                        color1 = strval(tmp);
                        if(color1 < 0 || color1 > 126) { SendClientMessage(playerid, -1, "   Цветное Число не может быть ниже 0 или выше 126 !"); return 1; }
                        tmp = strtok(cmdtext, idx);
                        if(!strlen(tmp))
                        {
                                SendClientMessage(playerid, -1, " Используйте: /veh [carid] [color1] [color2]");
                                return 1;
                        }
                        new color2;
                        color2 = strval(tmp);
                        if(color2 < 0 || color2 > 126) { SendClientMessage(playerid, -1, "   Цветное Число не может быть ниже 0 или выше 126 !"); return 1; }
                        new Float:X,Float:Y,Float:Z;
                        GetPlayerPos(playerid, X,Y,Z);
                        new carid = CreateVehicle(car, X,Y,Z, 0.0, color1, color2, 15);
                        SetVehicleVirtualWorld(carid, playerid+1);
                        format(string, sizeof(string), " Транспорт создан. ID: %d", carid);
                        SendClientMessage(playerid, -1, string);
                }

                return 1;
        }
        return 0;
}

stock ClearChat(playerid,col){
        for(new i=0;i<col;i++){
                SendClientMessage(playerid,-1,"\0");}}
                
new SanFierros[MAX_PLAYERS];
public OnPlayerStateChange(playerid, newstate, oldstate)
{
        if(newstate == PLAYER_STATE_DRIVER)
        {
                if(GetPlayerVehicleID(playerid) == tempding[playerid])
                {
                        TextDrawl[playerid]=SetTimerEx("FadingOutTextDraw",100,1,"%d",playerid);
                        ClearChat(playerid,20);
                        TogglePlayerControllable(playerid,0);
                        Delete3DTextLabel(Temp3d[playerid]);
                        SendClientMessage(playerid,-1,"Вы приплыли в San Fierro. У вас нету ничего кроме тех 100$, которые вы собирались потратить, купив мартини на борту самолета.");
                        SendClientMessage(playerid,-1,"Время начинать новую жизнь, в неизвестном, для вас, городе");
                        GivePlayerMoney(playerid,100);
                        new rand = random(3);
                        SanFierros[playerid]=SetTimerEx("SanFierro",600,1,"ii",playerid,2);
                }
        }
        return 1;
}
public:SanFierro(playerid,endquest)
{
        //KillTimer(TextDrawl[playerid]);
        if(endquest==0)
        {
                KillTimer(SanFierros[playerid]);
                SetVehiclePos(GetPlayerVehicleID(playerid),-2929.6899,-261.3652,1.4619);
                TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",500,1,"%d",playerid);
                TogglePlayerControllable(playerid,1);
                SendClientMessage(playerid,-1,"1 концовка");
                SetPlayerPos(playerid,-2917.381591,-261.691192,1.738175);
                LoopingAnim(playerid,"BEACH", "bather", 4.0, 1, 0, 0, 0, 0); // Lay down
                SetPlayerHealth(playerid,10);
                SendClientMessage(playerid,-1,"Вам очень плохо, нужно что бы кто нибудь вызвал врача.");
                TogglePlayerControllable(playerid,0);

        }
        else if(endquest==1)
        {
                KillTimer(SanFierros[playerid]);
                DestroyVehicle(GetPlayerVehicleID(playerid));
                SetPlayerPos(playerid,-1719.6660,1366.4673,7.1875);
                SetPlayerFacingAngle(playerid,43.9);
                SetPlayerSkin(playerid,167);
                SetPlayerVirtualWorld(playerid,0);
                ClearChat(playerid,20);
                SendClientMessage(playerid,-1,"По пути в San Fierro вы попали в шторм и вас вышвырнуло в районе доков.\nВ поисках еды вы забрели в пиццерию и согласились работать за еду.");
                SendClientMessage(playerid,-1,"В итоге ваша жизнь в этом городе начинается с дополнительным кол-вом денег в кармане.");
                TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",500,1,"%d",playerid);
                TogglePlayerControllable(playerid,1);
                SendClientMessage(playerid,-1,"2 концовка");
        }
        else  if(endquest==2)
        {
                KillTimer(SanFierros[playerid]);
                SetVehiclePos(GetPlayerVehicleID(playerid),-2929.6899,-261.3652,1.4619);
                TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",500,1,"%d",playerid);
                TogglePlayerControllable(playerid,1);
                SendClientMessage(playerid,-1,"3 концовка");
                SendClientMessage(playerid,-1,"Ты везунчик, и выбрался из всей этой заварушки живым, но увы чуть устал");
                SetPlayerHealth(playerid,50);
                SetPlayerVirtualWorld(playerid, 0);
                TextDrawShowForPlayer(playerid,txtSprite1);
                new string[256];
                format(string,sizeof(string),"Введите свой пароль для регистрации под аккаунтом: %s",Name(playerid));
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Регистрация",string,"OK","Отмена");
        }
        else if(endquest==3)
        {
                KillTimer(SanFierros[playerid]);
                SetVehiclePos(GetPlayerVehicleID(playerid),-2929.6899,-261.3652,1.4619);
                TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",500,1,"%d",playerid);
                TogglePlayerControllable(playerid,1);
                SendClientMessage(playerid,-1,"4 концовка");
                SendClientMessage(playerid,-1,"Поздравляем, вам удалось выжить после падения самолета, и добраться до города");
                SendClientMessage(playerid,-1,"Но увы ваши силы на исходе, найдите где можно подкрепится");
                SetPlayerHealth(playerid,10);
        }
        //TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",500,1,"%d",playerid);
        return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
        if((newkeys & KEY_WALK || newkeys & 128)&&IsPlayerInRangeOfPoint(playerid,5.0,-8157.9648,1291.9229,1.4488)){
                SendClientMessage(playerid,-1,"Вы открыли ящик и нашли в нем надувную лодку.\nВы начали надувать лодку");
                TogglePlayerControllable(playerid,0);
                ClearAnimations(playerid);
                OnePlayAnim(playerid, "BOMBER", "BOM_Plant", 4.0, 0, 0, 0, 0, 0); // Place Bomb
                SetTimerEx("Lodka",5000,0,"%d",playerid);}
        return 1;
}
public:Lodka(playerid)
{
        TogglePlayerControllable(playerid,1);
        tempding[playerid]=AddStaticVehicleEx(473,-8151.67382812,1293.02746582,0.00000000,280.00000000,-1,-1,15); //Dinghy
        SetVehicleVirtualWorld(tempding[playerid], playerid+1);
        SendClientMessage(playerid,-1,"Вы надули лодку");
        return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
        new string[255];
        if(dialogid == 1)
        {
                if(response)
                {
                        OnPlayerLogin(playerid,inputtext);
                }
                else
                {
                        format(string,sizeof(string),"Для игры на сервере %s необходимо авторизироваться",ServerName);
                        SendClientMessage(playerid,-1,string);
                        return Kick(playerid);
                }
        }
        if(dialogid == 2)
        {
                if(response)
                {
                        OnPlayerRegister(playerid,inputtext);
                }
                else
                {
                        format(string,sizeof(string),"Для игры на сервере %s необходимо зарегестрироваться",ServerName);
                        SendClientMessage(playerid,-1,string);
                        return Kick(playerid);
                }
        }
        if(dialogid == 3)
        {
                if(response)
                {
                        OnPlayerActivated(playerid,inputtext);
                }
                else
                {
                        format(string,sizeof(string),"Введите код полученный на электронную почту, указанную ранее.",Name(playerid));
                        ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Активация",string,"OK","Отмена");
                        //return Kick(playerid);
                }
        }
        if(dialogid == 4)
        {
                if(response)
                {
                        if (IsValidEmail(inputtext))
                        {
                        new query[128];
                        format(query, sizeof(query), "UPDATE users SET email = '%s' WHERE Username = '%s'", inputtext,Name(playerid));
                        mysql_query(query);
                        format(string,sizeof(string),"Введите код полученный на электронную почту, указанную ранее.",Name(playerid));
                        ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Активация",string,"OK","Отмена");
                        SendClientMessage(playerid, TEAM_AZTECAS_COLOR, "Вы успешно зарегестрировались, проверьте электронную почту на наличие письма с кодом активации");
                        OnPlayerEmail(playerid,inputtext);
                        }
                        else
                        {
                                format(string,sizeof(string),"Ошибка, введеный вами e-mail написан не правильно.\n Пожалуйста повторите попытку");
                                ShowPlayerDialog(playerid,4,DIALOG_STYLE_INPUT,"E-mail",string,"OK","Отмена");
                        }
                }
                else
                {
                        format(string,sizeof(string),"Для игры на сервере %s необходимо ввести электронный адрес.",ServerName);
                        SendClientMessage(playerid,-1,string);
                        return Kick(playerid);
                }
        }
        if(dialogid == 5)
        {
                if(response)
                {
                        sex[playerid]=1;
                        /*new rand = random(5);
                        printf ("%d",rand);
                        SetPlayerSkin(playerid,Mskins[rand]);
                        printf("%d",Mskins[rand]);*/
                        Quest(playerid);
                }
                else
                {
                        sex[playerid]=2;
                        /*new rand = random(5);
                        printf ("%d",rand);
                        SetPlayerSkin(playerid,Jskins[rand]);
                        printf("%d",Jskins[rand]);*/
                        Quest(playerid);
                }
        }
        return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source){return 1;}

stock Connection(){
        mysql_debug(DEBUG);
        mysql_connect(SQL_HOST, SQL_USER,SQL_DB, SQL_PASS);
        SetupTable();
        print("База данных успешно загружена.");
        return 1;}
        
stock SetupTable() 
{
        mysql_query("Select * from `users`");
        mysql_store_result();
        new db[2048];
        new l = mysql_num_rows();
        if(l ==-1)
        {

                format(db,sizeof(db),"CREATE TABLE `users` (");
                format(db,sizeof(db),"%s `id` int(11) NOT NULL auto_increment PRIMARY KEY,",db);
                format(db,sizeof(db),"%s `Username` varchar(30) NOT NULL,",db);
                format(db,sizeof(db),"%s `Password` varchar(50) NOT NULL,",db);
                format(db,sizeof(db),"%s `Money` int(10) NOT NULL default '0',",db);
                format(db,sizeof(db),"%s `start_ip` varchar(15) NOT NULL,",db);
                format(db,sizeof(db),"%s `DateReg` int(15) NOT NULL,",db);
                format(db,sizeof(db),"%s `email` varchar(50) NOT NULL,",db);
                format(db,sizeof(db),"%s `code` varchar(16) NOT NULL,",db);
                format(db,sizeof(db),"%s `activated` int(2) NOT NULL,",db);
                format(db,sizeof(db),"%s `member` int(2) NOT NULL,",db);
                format(db,sizeof(db),"%s `leader` int(2) NOT NULL)",db);
                mysql_query(db);
                print("Database users created");
        }
        mysql_free_result();
        mysql_query("Select * from `logins`");
        mysql_store_result();
        l = mysql_num_rows();
        if(l ==-1)
        {

                format(db,sizeof(db),"CREATE TABLE `logins` (");
                format(db,sizeof(db),"%s `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,",db);
                format(db,sizeof(db),"%s `time` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `ip` varchar(16) NOT NULL DEFAULT '',",db);
                format(db,sizeof(db),"%s `username` varchar(50) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `userid` varchar(50) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `whence` int(15) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `logged` int(15) NOT NULL DEFAULT '0')",db);
                mysql_query(db);
                print("Database logins created");
        }
        mysql_free_result();
        mysql_query("Select * from `houses`");
        mysql_store_result();
        l = mysql_num_rows();
        if(l ==-1)
        {
                format(db,sizeof(db),"CREATE TABLE `houses` (");
                format(db,sizeof(db),"%s `id` smallint(3) NOT NULL AUTO_INCREMENT PRIMARY KEY,",db);
                format(db,sizeof(db),"%s `ent_x` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ent_y` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ent_z` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ext_x` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ext_y` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ext_z` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `h_x` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `h_y` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `h_z` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ar_x` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ar_y` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `ar_z` float(10,5) NOT NULL DEFAULT '0.00000',",db);
                format(db,sizeof(db),"%s `owner` varchar(32) NOT NULL DEFAULT 'No-one',",db);
                format(db,sizeof(db),"%s `description` varchar(32) NOT NULL DEFAULT 'None',",db);
                format(db,sizeof(db),"%s `price` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `hel` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `arm` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `interior` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `locked` tinyint(1) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `owned` tinyint(1) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `rooms` smallint(2) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `rent` smallint(5) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `rentable` tinyint(1) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `takings` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `hvec` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `col1` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `col2` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `hdate` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `level` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `Virtual` smallint(3) NOT NULL DEFAULT '0')",db);
                mysql_query(db);
                print("Database houses created");
        }
        mysql_free_result();
        mysql_query("Select * from `bizz`");
        mysql_store_result();
        l = mysql_num_rows();
        if(l ==-1)
        {
                format(db,sizeof(db),"CREATE TABLE `bizz` (");
                format(db,sizeof(db),"%s `id` smallint(3) NOT NULL AUTO_INCREMENT PRIMARY KEY,",db);
                format(db,sizeof(db),"%s `owned` tinyint(1) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `owner` varchar(32) NOT NULL DEFAULT 'No-one',",db);
                format(db,sizeof(db),"%s `message` varchar(32) NOT NULL DEFAULT 'None',",db);
                format(db,sizeof(db),"%s `extortion` varchar(32) NOT NULL DEFAULT 'No-one',",db);
                format(db,sizeof(db),"%s `ent_x` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `ent_y` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `ent_z` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `ext_x` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `ext_y` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `ext_z` float(20,10) NOT NULL DEFAULT '0.0000000000',",db);
                format(db,sizeof(db),"%s `level` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `price` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `ent_cost` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `till` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `locked` tinyint(1) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `interior` smallint(3) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `products` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `maxprod` int(11) NOT NULL DEFAULT '0',",db);
                format(db,sizeof(db),"%s `priceprod` int(11) NOT NULL DEFAULT '0')",db);
                mysql_query(db);
                print("Database bizz created");
        }
        mysql_free_result();
        return 1;
}
stock Member(playerid){return PlayerInfo[playerid][pMember];}

stock Leader(playerid){
        if(Member(playerid)>0 && PlayerInfo[playerid][pLeader]==1){return Member(playerid);}
        return 0;}
        
stock LoadHouse()
{
        //new result[1024];
        new query[256];
        //new string[255];
        format(query,256,"Select * from houses");
        mysql_query(query);
        mysql_store_result();
        new idx = 1, l=mysql_num_rows();
        while(idx <= 6)
        {
                mysql_fetch_row_format(query, "|");
                sscanf(query,"p<|>iffffffffffffs[32]s[32]iiiiiiiiiiiiiiii",
                HouseInfo[idx][hId],
                HouseInfo[idx][hEntrancex],
                HouseInfo[idx][hEntrancey],
                HouseInfo[idx][hEntrancez],
                HouseInfo[idx][hExitx],
                HouseInfo[idx][hExity],
                HouseInfo[idx][hExitz],
                HouseInfo[idx][hHealthx],
                HouseInfo[idx][hHealthy],
                HouseInfo[idx][hHealthz],
                HouseInfo[idx][hArmourx],
                HouseInfo[idx][hArmoury],
                HouseInfo[idx][hArmourz],
                HouseInfo[idx][hOwner],
                HouseInfo[idx][hDiscription],
                HouseInfo[idx][hValue],
                HouseInfo[idx][hHel],
                HouseInfo[idx][hArm],
                HouseInfo[idx][hInt],
                HouseInfo[idx][hLock],
                HouseInfo[idx][hOwned],
                HouseInfo[idx][hRooms],
                HouseInfo[idx][hRent],
                HouseInfo[idx][hRentabil],
                HouseInfo[idx][hTakings],
                HouseInfo[idx][hVec],
                HouseInfo[idx][hVcol1],
                HouseInfo[idx][hVcol2],
                HouseInfo[idx][hDate],
                HouseInfo[idx][hLevel],
                HouseInfo[idx][hVirtual]);
                //print(query);
                /*if(HouseInfo[idx][hOwned] == 0)
                {
                        HouseInfo[idx][hPickup]=CreatePickup(1273, 2, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez]);
                    new strstr[256];
                format(strstr,sizeof(strstr),"ID: %d\nДом продается\nУровень: %d\nЦена: %d",idx,HouseInfo[idx][hLevel],HouseInfo[idx][hValue]);
                        HouseInfo[idx][hB3d] = Create3DTextLabel(strstr,0xFEFEFEFE,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],40.0,0);

                }
                if(HouseInfo[idx][hOwned] == 1)
                {
                        HouseInfo[idx][hPickup]=CreatePickup(1318, 2, HouseInfo[idx][hEntrancex], HouseInfo[idx][hEntrancey], HouseInfo[idx][hEntrancez]);
                    new strstr[256];
                format(strstr,sizeof(strstr),"ID: %d\nВладелец: %s",idx,HouseInfo[idx][hOwner]);
                        HouseInfo[idx][hB3d] = Create3DTextLabel(strstr,0xFEFEFEFE,HouseInfo[idx][hEntrancex],HouseInfo[idx][hEntrancey],HouseInfo[idx][hEntrancez],40.0,0);

                }*/
                idx++;
                if (idx == l)
                {
                        printf("%d House Load",idx);
                        houses = idx;
                }
        }
        printf("%d House Loaded",houses);
        mysql_free_result();
        return 1;
}
stock LoadBizz()
{
        //new result[1024];
        new query[256];
        //new string[255];
        format(query,256,"Select * from bizz");
        mysql_query(query);
        mysql_store_result();
        new idx = 1, l=mysql_num_rows();
        while(idx <= l)
        {
                mysql_fetch_row_format(query, "|");
                sscanf(query,"p<|>iis[32]s[128]s[32]ffffffiiiiiiiii",
                BizzInfo[idx][bId],
                BizzInfo[idx][bOwned],
                BizzInfo[idx][bOwner],
                BizzInfo[idx][bMessage],
                BizzInfo[idx][bExtortion],
                BizzInfo[idx][bEntranceX],
                BizzInfo[idx][bEntranceY],
                BizzInfo[idx][bEntranceZ],
                BizzInfo[idx][bExitX],
                BizzInfo[idx][bExitY],
                BizzInfo[idx][bExitZ],
                BizzInfo[idx][bLevelNeeded],
                BizzInfo[idx][bBuyPrice],
                BizzInfo[idx][bEntranceCost],
                BizzInfo[idx][bTill],
                BizzInfo[idx][bLocked],
                BizzInfo[idx][bInterior],
                BizzInfo[idx][bProducts],
                BizzInfo[idx][bMaxProducts],
                BizzInfo[idx][bPriceProd]);
                if(BizzInfo[idx][bOwned] == 0)
                {
                        BizzInfo[idx][bPickup]=CreatePickup(1272, 1, BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY], BizzInfo[idx][bEntranceZ]);
                        new temp[255];
                        format(temp,sizeof(temp), " [Бизнесс продаётся]\n [%s]\n [Стоимость: $%d]\n[Уровень: %d]\n[Чтобы купить бизнесс, введите /buybiz]", BizzInfo[idx][bMessage],BizzInfo[idx][bBuyPrice],BizzInfo[idx][bLevelNeeded]);
                        BizzInfo[idx][b3d]=Create3DTextLabel(temp,0x75DDB5FF,BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY],BizzInfo[idx][bEntranceZ],40.0,0);
                }
                if(BizzInfo[idx][bOwned] == 1)
                {
                        BizzInfo[idx][bPickup]=CreatePickup(1318, 1, BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY], BizzInfo[idx][bEntranceZ]);
                        new temp[255];
                        format(temp,sizeof(temp), " [%s]\n [Владелец: %s]\n[Совладелец: %s]\n[Стоимость входа: $%d]\n[Чтобы войти, введите /enter]", BizzInfo[idx][bMessage],BizzInfo[idx][bOwner],BizzInfo[idx][bExtortion],BizzInfo[idx][bEntranceCost],BizzInfo[idx][bLevelNeeded]);
                        BizzInfo[idx][b3d]=Create3DTextLabel(temp,0xE4FF61FF,BizzInfo[idx][bEntranceX], BizzInfo[idx][bEntranceY],BizzInfo[idx][bEntranceZ],40.0,0);
                }
                idx++;
        }
        busines = idx - 1;
        printf("%d Bizz Loaded",busines);
        mysql_free_result();
        return 1;
}
strtok(const string[], &index)
{
        new length = strlen(string);
        while ((index < length) && (string[index] <= ' ')){index++;}
        new offset = index;
        new result[20];
        while ((index < length) && (string[index] > ' ') && ((index - offset) < (sizeof(result) - 1))){
                result[index - offset] = string[index];
                index++;}
        result[index - offset] = EOS;
        return result;
}

public MailResponse(index, response_code, data[])
{
        return 1;
}

stock EncodeURL( szString[ ], iSize = sizeof( szString ) ) // Thanks to g_aSlice :))
{
    for ( new i = 0, l = strlen( szString ); i < l; i++ )
    {
        switch ( szString[ i ] )
        {
            case '!', '(', ')', '\'', '*',
                 '0' .. '9',
                 'A' .. 'Z',
                 'a' .. 'z':
            {
                continue;
            }

            case ' ':
            {
                szString[ i ] = '+';

                continue;
            }
        }

        new
            s_szHex[ 8 ]
        ;

        if ( i + 3 >= iSize )
        {
            szString[ i ] = EOS;

            break;
        }

        if ( l + 3 >= iSize )
            szString[ iSize - 3 ] = EOS;

        format( s_szHex, sizeof( s_szHex ), "%02h", szString[ i ] );

        szString[ i ] = '%';

        strins( szString, s_szHex, i + 1, iSize );

        l += 2;
        i += 2;

        if ( l > iSize - 1 )
            l = iSize - 1;
    }
}
public:FadingOutTextDraw(playerid)
{
        if(GetPVarInt(playerid,"alpha")==5){DeletePVar(playerid,"alpha");KillTimer(TextDrawl[playerid]);}
        else SetPVarInt(playerid,"alpha",GetPVarInt(playerid,"alpha")+1);
        new x=GetPVarInt(playerid,"alpha");
        switch(x)
        {
                case 1:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000022);
                        TextDrawColor(Polosa1[playerid],0x00000022);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000022);}
                case 2:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000044);
                        TextDrawColor(Polosa1[playerid],0x00000044);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000044);}
                case 3:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000066);
                        TextDrawColor(Polosa1[playerid],0x00000066);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000066);}
                case 4:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000099);
                        TextDrawColor(Polosa1[playerid],0x00000099);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000099);}
                case 5:{
                        TextDrawBoxColor(Polosa1[playerid],0x000000FF);
                        TextDrawColor(Polosa1[playerid],0x000000FF);
                        TextDrawBackgroundColor(Polosa1[playerid],0x000000FF);}
                default:{
                        TextDrawBoxColor(Polosa1[playerid],0x000000FF);
                        TextDrawColor(Polosa1[playerid],0x000000FF);
                        TextDrawBackgroundColor(Polosa1[playerid],0x000000FF);}
        }
        TextDrawShowForPlayer(playerid,Polosa1[playerid]);

}
public:FadingInTextDraw(playerid)
{
        if(GetPVarInt(playerid,"alpha")==5){DeletePVar(playerid,"alpha");KillTimer(TextDrawl[playerid]);TextDrawHideForPlayer(playerid,Polosa1[playerid]);}
        else SetPVarInt(playerid,"alpha",GetPVarInt(playerid,"alpha")+1);
        new x=GetPVarInt(playerid,"alpha");
        switch(x)
        {
                case 5:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000022);
                        TextDrawColor(Polosa1[playerid],0x00000022);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000022);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);}
                case 4:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000044);
                        TextDrawColor(Polosa1[playerid],0x00000044);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000044);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);}
                case 3:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000066);
                        TextDrawColor(Polosa1[playerid],0x00000066);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000066);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);}
                case 2:{
                        TextDrawBoxColor(Polosa1[playerid],0x00000099);
                        TextDrawColor(Polosa1[playerid],0x00000099);
                        TextDrawBackgroundColor(Polosa1[playerid],0x00000099);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);}
                case 1:{
                        TextDrawBoxColor(Polosa1[playerid],0x000000FF);
                        TextDrawColor(Polosa1[playerid],0x000000FF);
                        TextDrawBackgroundColor(Polosa1[playerid],0x000000FF);
                        TextDrawShowForPlayer(playerid,Polosa1[playerid]);}
                default:{TextDrawHideForPlayer(playerid,Polosa1[playerid]);}
        }

}
public:MovingCamera(playerid)
{
        cam[playerid]++;
        new string[128];
        if(cam[playerid]==1){format(string,sizeof(string), "Стюардесса: Уважаемые пассажиры рейса NY%d%d%d%d, наш полет проходит нормально на высоте 4км",random(10),random(10),random(10),random(10));SendClientMessage(playerid,-1,string);}
        else if(cam[playerid]==4){SendClientMessage(playerid, -1, "Стюардесса: Температура за бортом -65 градусов по цельсию. В иллюминаторах вы можете видеть штат San Andreas");}
        else if(cam[playerid]==7){SendClientMessage(playerid, -1, "Стюардесса: Все приборы пилотов работают исправно. Отставаний от графика нет");}
        else if(cam[playerid]==14){SendClientMessage(playerid, -1, "Пилот: Всем пристегнуть ремни, у нас поврежден правый двигатель. Будем выполнять экстренную посадку");SetPlayerDrunkLevel (playerid, 50000);}
        else if(cam[playerid]==17){SendClientMessage(playerid,-1,"Пилот: мы падаем...");TextDrawShowForPlayer(playerid,Polosa1[playerid]);TextDrawl[playerid]=SetTimerEx("FadingOutTextDraw",100,1,"%d",playerid);SetPlayerDrunkLevel (playerid, 2000);}
        else if(cam[playerid]==20)
        {
                ClearChat(playerid,20);
                StopAudioStreamForPlayer(playerid);
                SendClientMessage(playerid,-1,"Вам нужно найти что-нибудь, что помогло бы выбраться с острова.");
                TextDrawl[playerid]=SetTimerEx("FadingInTextDraw",100,1,"%d",playerid);
                StopLoopingAnim(playerid);
                SetPlayerPos(playerid,-8266.589843,1259.435791,-0.543622);
                SetPlayerInterior(playerid,0);
                KillTimer(SpawnTimer[playerid]);
                cam[playerid]=10000;
                Temp3d[playerid]=Create3DTextLabel("Нажмите пробел", -1, -8157.7959,1289.7961,2.9042, 20.0, playerid+1, 1);
                tempding[playerid]=AddStaticVehicleEx(473,-8151.67382812,1293.02746582,0.00000000,280.00000000,-1,-1,15); //Dinghy
                SetVehicleVirtualWorld(tempding[playerid], playerid+1);*/
        }
}
И исправить баг с включением мода чо то типа рун тайм 19
2. Цена вопроса : 300р.
3. Связь: Ваши данные, для связи с Вами. viktor.ddd ( ава шахматы )
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу