Login

Crazyboobs · 02.09.2012, 02:10

Hello, i scripted 16 functions in mysql like level, kills, death, score etc and everything working fine and saving.
The problem is when i added the 17th function then it wont save anything, the limit is 16 functions.Why it is like that?
And how to increase it?

Camacorn · 02.09.2012, 02:19

Have you tried increasing your Query size?

Crazyboobs · 02.09.2012, 02:22

yes i changed it upto 1600

pawn Код:

new query[1600];

But not saving

Camacorn · 02.09.2012, 02:22

Show me the query.

Crazyboobs · 02.09.2012, 02:29

Last 2 are the query

pawn Код:

//Ongamemodeinit
    new string[1500];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20), kills INT(20), deaths INT(20), registered INT(20), loggedin INT(20), level INT(20), cookies INT(20),");
    strcat(string,"cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20), quickweapon INT(20), vgoto INT(20), playerfly INT(20), TP INT(20))");
    //format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20),kills INT(20), deaths INT(20),");
    //strcat(string,"registered INT(20), loggedin INT(20), level INT(20), cookies INT(20), cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20))");
    mysql_query(string);
    mysql_debug(1);
    
//onplayerdisconnect
new score = GetPlayerScore(playerid);
    new money = GetPlayerMoney(playerid);
    new query[1200], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "UPDATE data SET score=%d, money=%d, kills=%d, deaths=%d, registered=%d, loggedin=%d, level=%d, cookies=%d, cakes=%d, biscuits=%d, icecreams=%d, YG=%d, unlimitedb=%d, quickweapons=%d, vgoto=%d, playerfly=%d, TP=%d  WHERE user='%s'",
    score,
    money,
    PlayerInfo[playerid][Kills],
    PlayerInfo[playerid][Deaths],
    PlayerInfo[playerid][Registered],
    PlayerInfo[playerid][LoggedIn],
    PlayerInfo[playerid][Level],
    PlayerInfo[playerid][Cookies],
    PlayerInfo[playerid][Cakes],
    PlayerInfo[playerid][Biscuits],
    PlayerInfo[playerid][IceCreams],
    PlayerInfo[playerid][Rb],
    PlayerInfo[playerid][Unlimitedb],
    PlayerInfo[playerid][Quickweapon],
    PlayerInfo[playerid][Vgoto],
    PlayerInfo[playerid][PlayerFly],
    PlayerInfo[playerid][TP],
    pname);
    mysql_query(query);
    
//onplayerconnect
new query[300], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT IP FROM `data` WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(!rows)
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
    }
    if(rows == 1)
    {
        new IP[2][15];
        mysql_fetch_field_row(IP[0],"IP");
        GetPlayerIp(playerid, IP[1], 15);
        if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
        {
            MySQL_Login(playerid);
        }
        else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
        {
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
            PlayerInfo[playerid][Registered] = 1;
        }
    }
    mysql_free_result();
    
//query

stock MySQL_Register(playerid, passwordstring[])
{
    new query[1600], pname[24], IP[15];
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 15);
    //format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapons, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,\
    quickweapons, vgoto, playerfly, TP) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    mysql_query(query);
    SendClientMessage(playerid, -1,"Info: You have been registered on this server!");
    PlayerInfo[playerid][LoggedIn] = 1;
    PlayerInfo[playerid][Registered] = 1;
    return 1;
}
stock MySQL_Login(playerid)
{
    new query[1500], pname[24], savingstring[1600];
    new resultline[600];
    GetPlayerName(playerid, pname, 24);
    //format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,quickweapons, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz  WHERE user = '%s'", pname);
    format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapons, vgoto, playerfly, TP  WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    if(mysql_fetch_row_format(resultline))
    {
        mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "registered"); PlayerInfo[playerid][Registered] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "loggedin"); PlayerInfo[playerid][LoggedIn] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][Level] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cakes"); PlayerInfo[playerid][Cakes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "biscuits"); PlayerInfo[playerid][Biscuits] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "icecreams"); PlayerInfo[playerid][IceCreams] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "YG"); PlayerInfo[playerid][Rb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "unlimitedb"); PlayerInfo[playerid][Unlimitedb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "quickweapons"); PlayerInfo[playerid][Quickweapon] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vgoto"); PlayerInfo[playerid][Vgoto] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "playerfly"); PlayerInfo[playerid][PlayerFly] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "TP"); PlayerInfo[playerid][TP] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    PlayerInfo[playerid][LoggedIn] = 1;
    SendClientMessage(playerid, -1,"Info: You have been logged-in!");
    return 1;
}

stock GetName(playerid)
{
    new pname[24];
    GetPlayerName(playerid, pname, 24);
    return pname;
}

Crazyboobs · 02.09.2012, 09:42

help please

Kirollos · 02.09.2012, 09:44

you may need to do mysql_debug(true); before connecting to mysql and look on mysql_logs.txt

that will tell you what's wrong with it

Crazyboobs · 02.09.2012, 09:55

It is showing like this

Quote:

[12:08:46] ---------------------------
[12:08:46] MySQL Debugging activated (09/02/12)
[12:08:46] ---------------------------
[12:08:46]
[12:10:12] >> mysql_query( Connection handle: 1 )
[12:10:12] CMySQLHandler::Query(SELECT IP FROM `data` WHERE user = 'Crazyboobs' LIMIT 1) - Successfully executed.
[12:10:12] >> mysql_store_result( Connection handle: 1 )
[12:10:12] CMySQLHandler::StoreResult() - Result was stored.
[12:10:12] >> mysql_num_rows( Connection handle: 1 )
[12:10:12] CMySQLHandler::NumRows() - Returned 0 row(s)
[12:10:12] >> mysql_free_result( Connection handle: 1 )
[12:10:12] CMySQLHandler::FreeResult() - Result was successfully free'd.
[12:10:16] >> mysql_real_escape_string( Connection handle: 1 )
[12:10:16] CMySQLHandler::EscapeString(pass); - Escaped 4 characters to pass.
[12:10:16] >> mysql_query( Connection handle: 1 )
[12:10:16] CMySQLHandler::Query(INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,quickweapons, vgoto, playerfly, TP) VALUES('Crazyboobs', SHA1('pass'), '86.97.40.141', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)) - An error has occured. (Error ID: 1054, Unknown column 'quickweapons' in 'field list')
[12:10:22] >> mysql_query( Connection handle: 1 )
[12:10:22] CMySQLHandler::Query(UPDATE data SET score=0, money=50000, kills=0, deaths=0, registered=1, loggedin=1, level=0, cookies=0, cakes=0, biscuits=0, icecreams=0, YG=0, unlimitedb=0, quickweapons=0, vgoto=0, playerfly=0, TP=0 WHERE user='Crazyboobs') - An error has occured. (Error ID: 1054, Unknown column 'quickweapons' in 'field list')

doreto · 02.09.2012, 09:59

quickweapons you dont have it on your datebase

Kirollos · 02.09.2012, 09:59

alright, you were just writing in the queries quickweapons, it's quickweapon as written in CREATE TABLE IF NOT EXISTS

pawn Код:

//Ongamemodeinit
    new string[1500];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20), kills INT(20), deaths INT(20), registered INT(20), loggedin INT(20), level INT(20), cookies INT(20),");
    strcat(string,"cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20), quickweapon INT(20), vgoto INT(20), playerfly INT(20), TP INT(20))");
    //format(string,sizeof(string),"CREATE TABLE IF NOT EXISTS data(user VARCHAR(24), password VARCHAR(40), IP VARCHAR(15), score INT(20), money INT(20),kills INT(20), deaths INT(20),");
    //strcat(string,"registered INT(20), loggedin INT(20), level INT(20), cookies INT(20), cakes INT(20), biscuits INT(20), icecreams INT(20), YG INT(20), unlimitedb INT(20))");
    mysql_query(string);
    mysql_debug(1);

//onplayerdisconnect
new score = GetPlayerScore(playerid);
    new money = GetPlayerMoney(playerid);
    new query[1200], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "UPDATE data SET score=%d, money=%d, kills=%d, deaths=%d, registered=%d, loggedin=%d, level=%d, cookies=%d, cakes=%d, biscuits=%d, icecreams=%d, YG=%d, unlimitedb=%d, quickweapon=%d, vgoto=%d, playerfly=%d, TP=%d  WHERE user='%s'",
    score,
    money,
    PlayerInfo[playerid][Kills],
    PlayerInfo[playerid][Deaths],
    PlayerInfo[playerid][Registered],
    PlayerInfo[playerid][LoggedIn],
    PlayerInfo[playerid][Level],
    PlayerInfo[playerid][Cookies],
    PlayerInfo[playerid][Cakes],
    PlayerInfo[playerid][Biscuits],
    PlayerInfo[playerid][IceCreams],
    PlayerInfo[playerid][Rb],
    PlayerInfo[playerid][Unlimitedb],
    PlayerInfo[playerid][Quickweapon],
    PlayerInfo[playerid][Vgoto],
    PlayerInfo[playerid][PlayerFly],
    PlayerInfo[playerid][TP],
    pname);
    mysql_query(query);

//onplayerconnect
new query[300], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT IP FROM `data` WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(!rows)
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
    }
    if(rows == 1)
    {
        new IP[2][15];
        mysql_fetch_field_row(IP[0],"IP");
        GetPlayerIp(playerid, IP[1], 15);
        if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
        {
            MySQL_Login(playerid);
        }
        else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
        {
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
            PlayerInfo[playerid][Registered] = 1;
        }
    }
    mysql_free_result();

//query

stock MySQL_Register(playerid, passwordstring[])
{
    new query[1600], pname[24], IP[15];
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 15);
    //format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapon, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    format(query, sizeof(query), "INSERT INTO data (user, password, IP, score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,\
    quickweapon, vgoto, playerfly, TP) VALUES('%s', SHA1('%s'), '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", pname, passwordstring, IP);
    mysql_query(query);
    SendClientMessage(playerid, -1,"Info: You have been registered on this server!");
    PlayerInfo[playerid][LoggedIn] = 1;
    PlayerInfo[playerid][Registered] = 1;
    return 1;
}
stock MySQL_Login(playerid)
{
    new query[1500], pname[24], savingstring[1600];
    new resultline[600];
    GetPlayerName(playerid, pname, 24);
    //format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb,quickweapon, vgoto, playerfly, TP, YGFunction1, YGFunction2, YGFunction3, YGFunction4, YGFunction5, YGFunction6, Bank, weed, Condoms, inalcatraz  WHERE user = '%s'", pname);
    format(query, sizeof(query), "SELECT score, money, kills, deaths, registered, loggedin, level, cookies, cakes, biscuits, icecreams, YG, unlimitedb, quickweapon, vgoto, playerfly, TP  WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    if(mysql_fetch_row_format(resultline))
    {
        mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][Kills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][Deaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "registered"); PlayerInfo[playerid][Registered] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "loggedin"); PlayerInfo[playerid][LoggedIn] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][Level] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cookies"); PlayerInfo[playerid][Cookies] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "cakes"); PlayerInfo[playerid][Cakes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "biscuits"); PlayerInfo[playerid][Biscuits] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "icecreams"); PlayerInfo[playerid][IceCreams] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "YG"); PlayerInfo[playerid][Rb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "unlimitedb"); PlayerInfo[playerid][Unlimitedb] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "quickweapon"); PlayerInfo[playerid][Quickweapon] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vgoto"); PlayerInfo[playerid][Vgoto] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "playerfly"); PlayerInfo[playerid][PlayerFly] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "TP"); PlayerInfo[playerid][TP] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    PlayerInfo[playerid][LoggedIn] = 1;
    SendClientMessage(playerid, -1,"Info: You have been logged-in!");
    return 1;
}

stock GetName(playerid)
{
    new pname[24];
    GetPlayerName(playerid, pname, 24);
    return pname;
}

Login
Username:
Password:	Lost Password?
	Remember me