MySQL
#6

It still says ( SELECT name FROM gangs WHERE ID = 3) Cowboy: test

Thanks for helping



EDIT: A fast question

This is from my login dialog. Where should I free the result?

pawn Код:
case 2:
        {
            if(!response) return Kick(playerid);
            GetPlayerName(playerid, pName, sizeof(pName));
            mysql_real_escape_string(inputtext, escapepass);
            format(Query, sizeof(Query), "SELECT `name` FROM users WHERE name = '%s' AND password = '%s'", pName, escapepass);
            mysql_query(Query);
            mysql_store_result();
            if(!mysql_num_rows())
            {
                ShowPlayerDialog(playerid...)
            }
            else if(mysql_num_rows() == 1)
            {
                format(Query, sizeof(Query), "SELECT * FROM users WHERE name = '%s'", pName);
                mysql_query(Query);
                mysql_store_result();
                while(mysql_fetch_row_format(Query,"|"))
                {
                    mysql_fetch_field_row(field, "score");
                    SetPlayerScore(playerid, strval(field));
                    mysql_fetch_field_row(field, "money");
                    GivePlayerMoney(playerid, strval(field));
                    mysql_fetch_field_row(field, "adminlevel");
                    PlayerInfo[playerid][pAdminLevel] = strval(field);
                    mysql_fetch_field_row(field, "gang");
                    PlayerInfo[playerid][Gang] = strval(field);
                }
            //  mysql_free_result();
                PlayerInfo[playerid][pLogged] = 1;
            }
        //  mysql_free_result();
        }
Should I free it with the first one or the second, thanks again
Reply


Messages In This Thread
MySQL - by Cowboy - 29.10.2011, 18:59
Re: MySQL - by DreamOnIt - 29.10.2011, 19:17
Re: MySQL - by woot - 29.10.2011, 19:41
Re: MySQL - by Cowboy - 30.10.2011, 11:20
Re: MySQL - by Pinguinn - 30.10.2011, 11:42
Re: MySQL - by Cowboy - 30.10.2011, 11:51
Re: MySQL - by Cowboy - 30.10.2011, 12:28
Re: MySQL - by Cowboy - 31.10.2011, 16:29

Forum Jump:


Users browsing this thread: 3 Guest(s)