[Include] Easy MySQL - Simplifying the usage of MySQL queries!
#14

Quote:
Originally Posted by pawnuser
View Post
I will perform this function, it recognizes the name on the account number in the database. (encoding declared at the beginning of fashion after the database connection)

stock GetAccountName(account)
{
new name[MAX_PLAYER_NAME];
if(SQL::RowExists("accounts", "ID", account))
{
new handle = SQL::Open(SQL::READ, "accounts", "ID", account);
SQL::ReadString(handle, "Name", name, MAX_PLAYER_NAME);
SQL::Close(handle);
}
return name;
}

The result of "return" is recognized in the "??"
Use This

Code:
stock GetAccountName(account)
{
    new name[MAX_PLAYER_NAME];
    if(SQL::RowExists("accounts", "ID", account))
    {
        SQL::GetStringEntry("accounts", "Name", "ID", account, name, MAX_PLAYER_NAME);
        return name;
    }
    return 0;
}
Reply


Messages In This Thread
Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 11.05.2016, 16:16
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Evoturk - 11.05.2016, 16:18
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Unrea1 - 11.05.2016, 16:22
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 11.05.2016, 16:25
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Sensation - 11.05.2016, 18:40
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 11.05.2016, 18:41
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Sensation - 11.05.2016, 18:42
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Sensation - 11.05.2016, 18:49
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Luicy. - 19.06.2016, 08:22
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 19.06.2016, 10:22
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by pawnuser - 21.06.2016, 05:30
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 21.06.2016, 10:21
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by pawnuser - 21.06.2016, 10:58
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 21.06.2016, 13:30
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by pawnuser - 21.06.2016, 15:50
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 21.06.2016, 16:47
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by pawnuser - 21.06.2016, 17:07
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Stones - 21.06.2016, 19:45
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 05.09.2016, 21:23
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by morris91 - 06.09.2016, 11:18
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 06.09.2016, 11:23
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by morris91 - 06.09.2016, 11:25
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 06.09.2016, 12:16
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by F1N4L - 06.09.2016, 12:21
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by morris91 - 06.09.2016, 12:52
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 15.09.2016, 15:37
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by vernz - 07.11.2016, 01:30
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by GeneralAref - 19.12.2016, 10:51
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 19.12.2016, 12:09
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Zoie - 04.04.2017, 09:17
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 24.11.2017, 17:36
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by RowdyrideR - 10.01.2018, 15:37
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 10.01.2018, 15:41
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by RowdyrideR - 11.01.2018, 01:07
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by ThePhenix - 11.01.2018, 01:55
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by RowdyrideR - 11.01.2018, 17:35
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by ThePhenix - 11.01.2018, 17:45
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by RowdyrideR - 11.01.2018, 18:26
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 13.05.2018, 16:24
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Private200 - 13.05.2018, 20:58
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 13.05.2018, 21:00
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Private200 - 13.05.2018, 21:08
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 13.05.2018, 21:36
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Akeem - 06.06.2018, 15:21
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 06.06.2018, 16:25
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by altunatively - 14.06.2018, 19:30
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 23.06.2018, 13:46
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 23.06.2018, 13:49
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 23.06.2018, 14:14
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 23.06.2018, 14:21
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 23.06.2018, 14:26
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 23.06.2018, 14:56
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by CantBeJohn - 17.09.2018, 04:34
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 17.09.2018, 16:34
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by CantBeJohn - 18.09.2018, 01:52
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Amagida - 21.09.2018, 16:23
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by solstice_ - 21.09.2018, 17:25
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 29.09.2018, 12:10
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by GameOvr - 12.10.2018, 07:55
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by CantBeJohn - 09.07.2019, 19:24
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Gammix - 09.07.2019, 21:45
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Aerotactics - 17.07.2019, 03:35
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 18.05.2020, 19:48
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 19.05.2020, 12:02
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 20.05.2020, 01:24
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Stefan_Toretto - 22.05.2020, 20:57
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by Max_Andolini - 01.06.2020, 01:03
Re: Easy MySQL - Simplifying the usage of MySQL queries! - by JR_Junior - 23.06.2020, 22:30

Forum Jump:


Users browsing this thread: 1 Guest(s)