Jump to content
  • 0

Ajutor salvare in baza de date

Micu_Gamer

Asked by Micu_Gamer,

 Share

Question

Micu_Gamer Apprentice

Micu_Gamer

Posted
Posted

Salut, as vrea sa va intreb daca am facut ceva gresit la aceste comenzi de nu imi salveaza in baza de date ?

 

 

QUITJOB:

CMD:quitjob(playerid, params[])
{
    if(IsPlayerConnected(playerid))
    {
        if(PlayerInfo[playerid][pJob] >= 1)
        {
            SendClientMessage(playerid, COLOR_GREY, "You have quit your job!");
            PlayerInfo[playerid][pJob] = 0;
            DisablePlayerCheckpoint(playerid);
            new szQuery[128];
            mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='0' WHERE `Username`='%s'", PlayerInfo[pJob], PlayerInfo[playerid][pUsername]);
            mysql_tquery(mysql, "szQuery");
        }
        else return SendClientMessage(playerid, COLOR_WHITE, "You don't have a job.");
    }
    return 1;
}

 

GETJOB:

CMD:getjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        new sendername[25],str[256];
        GetPlayerName(playerid,sendername,sizeof(sendername));
        if(PlayerInfo[playerid][pJob] == 0)
        {
            if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,607.8375,-1438.1827,14.0654))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Detective.");
                PlayerInfo[playerid][pJob] = 1;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);
            }
            else if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,359.3762,-2071.5310,10.6953))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Fisherman.");
                PlayerInfo[playerid][pJob] = 2;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);
            }

        }
        else
        {
            SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Ai deja un job, foloseste comanda /quitjob pentru a parasi job ul.");
        }
    }
    return 1;
}

 

SETJOB: 

CMD:setjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        if (PlayerInfo[playerid][pAdmin] >= 6)
        {
            new id,jobid,string[256],giveplayer[30],sendername[30];
            if(sscanf(params, "ui",id,jobid)) return SendClientMessage(playerid, 0xFFFFFFFF, "{0049FF}Syntax: {ffffff}/setjob <Name/Playerid> <Job ID>");
            {
                if(IsPlayerConnected(id))
                {
                    if(id != INVALID_PLAYER_ID)
                    {
                        GetPlayerName(id, giveplayer, sizeof(giveplayer));
                        GetPlayerName(playerid, sendername, sizeof(sendername));
                        PlayerInfo[id][pJob] = jobid;
                        format(string, sizeof(string), "Admin %s has changed you job to %d.", sendername,jobid);
                        SCM(id,COLOR_LIGHTBLUE, string);
                        new str[128];
                        mysql_format(mysql, szQuery, sizeof(szQuery),"UPDATE `users` SET `Job`='%d' WHERE `name`='%s'",PlayerInfo[id][pJob],PlayerInfo[id][pUsername]);
                        mysql_tquery(mysql, szQuery);
                    }
                }
                else
                {
                    SendClientMessage(playerid,COLOR_WHITE, "{FFFFCC}Error: Player not connected.");
                }
            }
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, AdminOnly);
        }
    }
    return 1;
}

 

Mersi!

3 answers to this question

Recommended Posts

  • 0
Destroyed Enthusiast

Destroyed

Posted
Posted
1 hour ago, Micu_Gamer said:

Salut, as vrea sa va intreb daca am facut ceva gresit la aceste comenzi de nu imi salveaza in baza de date ?

 

 

QUITJOB:

CMD:quitjob(playerid, params[])
{
    if(IsPlayerConnected(playerid))
    {
        if(PlayerInfo[playerid][pJob] >= 1)
        {
            SendClientMessage(playerid, COLOR_GREY, "You have quit your job!");
            PlayerInfo[playerid][pJob] = 0;
            DisablePlayerCheckpoint(playerid);
            new szQuery[128];
            mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='0' WHERE `Username`='%s'", PlayerInfo[pJob], PlayerInfo[playerid][pUsername]);
            mysql_tquery(mysql, "szQuery");
        }
        else return SendClientMessage(playerid, COLOR_WHITE, "You don't have a job.");
    }
    return 1;
}

 

GETJOB:

CMD:getjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        new sendername[25],str[256];
        GetPlayerName(playerid,sendername,sizeof(sendername));
        if(PlayerInfo[playerid][pJob] == 0)
        {
            if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,607.8375,-1438.1827,14.0654))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Detective.");
                PlayerInfo[playerid][pJob] = 1;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);
            }
            else if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,359.3762,-2071.5310,10.6953))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Fisherman.");
                PlayerInfo[playerid][pJob] = 2;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);
            }

        }
        else
        {
            SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Ai deja un job, foloseste comanda /quitjob pentru a parasi job ul.");
        }
    }
    return 1;
}

 

SETJOB: 

CMD:setjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        if (PlayerInfo[playerid][pAdmin] >= 6)
        {
            new id,jobid,string[256],giveplayer[30],sendername[30];
            if(sscanf(params, "ui",id,jobid)) return SendClientMessage(playerid, 0xFFFFFFFF, "{0049FF}Syntax: {ffffff}/setjob <Name/Playerid> <Job ID>");
            {
                if(IsPlayerConnected(id))
                {
                    if(id != INVALID_PLAYER_ID)
                    {
                        GetPlayerName(id, giveplayer, sizeof(giveplayer));
                        GetPlayerName(playerid, sendername, sizeof(sendername));
                        PlayerInfo[id][pJob] = jobid;
                        format(string, sizeof(string), "Admin %s has changed you job to %d.", sendername,jobid);
                        SCM(id,COLOR_LIGHTBLUE, string);
                        new str[128];
                        mysql_format(mysql, szQuery, sizeof(szQuery),"UPDATE `users` SET `Job`='%d' WHERE `name`='%s'",PlayerInfo[id][pJob],PlayerInfo[id][pUsername]);
                        mysql_tquery(mysql, szQuery);
                    }
                }
                else
                {
                    SendClientMessage(playerid,COLOR_WHITE, "{FFFFCC}Error: Player not connected.");
                }
            }
        }
        else
        {
            SendClientMessage(playerid, COLOR_RED, AdminOnly);
        }
    }
    return 1;
}

 

Mersi!

pot sa iti dau comenzile terminate?

Daca da,uitele aici

 

QUITJOB:

CMD:quitjob(playerid, params[])
{
    if(IsPlayerConnected(playerid))
    {
        if(PlayerInfo[playerid][pJob] >= 1)
        {
            SendClientMessage(playerid, COLOR_GREY, "You have quit your job!");
            PlayerInfo[playerid][pJob] = 0;
            DisablePlayerCheckpoint(playerid);
            new szQuery[128];
            mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='0' WHERE `Username`='%s'", PlayerInfo[playerid][pUsername]); //aici am sters PlayerInfo[id][pJob] deoarece in loc sa ii ia numele, ii lua jobul. ii seteaza jobul la 0, si il pune unde ii gaseste numele. zimi daca ai inteles
            mysql_tquery(mysql, "szQuery");
        else return SendClientMessage(playerid, COLOR_WHITE, "You don't have a job.");
    }
    return 1;
}

 

GETJOB:

CMD:getjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        new sendername[25],str[256];
        GetPlayerName(playerid,sendername,sizeof(sendername));
        if(PlayerInfo[playerid][pJob] == 0)
        {
            if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,607.8375,-1438.1827,14.0654))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Detective.");
                PlayerInfo[playerid][pJob] = 1;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);


            else if (GetPlayerState(playerid) == 1 && PlayerToPoint(3.0, playerid,359.3762,-2071.5310,10.6953))
            {
                SendClientMessage(playerid, COLOR_LIGHTBLUE, "Jobul tau este acum Fisherman.");
                PlayerInfo[playerid][pJob] = 2;
                mysql_format(mysql, szQuery, sizeof(szQuery), "UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'", PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
                mysql_tquery(mysql, szQuery);

                return 1;
            }
        else
        {
            SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Ai deja un job, foloseste comanda /quitjob pentru a parasi job ul.");

            return 1;
        }
    }
    return 1;
}

 

SETJOB: 

CMD:setjob(playerid, params[])
{
    new szQuery[256];
    if(IsPlayerConnected(playerid))
    {
        if (PlayerInfo[playerid][pAdmin] >= 6)
        {
            new id,jobid,string[256],giveplayer[30],sendername[30];
            if(sscanf(params, "ui",id,jobid)) return SendClientMessage(playerid, 0xFFFFFFFF, "{0049FF}Syntax: {ffffff}/setjob <Name/Playerid> <Job ID>");
            {
                if(IsPlayerConnected(id))
                {
                    if(id != INVALID_PLAYER_ID)
                    {
                        GetPlayerName(id, giveplayer, sizeof(giveplayer));
                        GetPlayerName(playerid, sendername, sizeof(sendername));
                        PlayerInfo[id][pJob] = jobid;
                        format(string, sizeof(string), "Admin %s has changed you job to %d.", sendername,jobid);
                        SCM(id,COLOR_LIGHTBLUE, string);
                        new str[128];
                        mysql_format(mysql, szQuery, sizeof(szQuery),"UPDATE `users` SET `Job`='%d' WHERE `Username`='%s'",  PlayerInfo[id][pJob], PlayerInfo[id][pUsername]); // aici am schimbat o chestie, WHERE `Username` atat
                        mysql_tquery(mysql, szQuery);

                        return 1;
                    }
                else
                {
                    SendClientMessage(playerid,COLOR_WHITE, "{FFFFCC}Error: Player not connected.");

                    return 1;
                }
           }
        else
        {
            SendClientMessage(playerid, COLOR_RED, AdminOnly);

            return 1;
        }
    }
    return 1;
}

 

sami spui daca ai ceva erori, nu am testat sa fiu sigur

 

  • 0
ASGOOD Rising Star

ASGOOD

Posted
Posted

daca vrei sa-ti functioneze si quitjob  mysql_tquery(mysql, "szQuery"); transforma in  mysql_tquery(mysql, szQuery);

asgood.ro

 

 

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.