1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Problem ORM [+rep]
Z3N0N
Banned
Posts: 13
Threads: 4
Joined: Nov 2014
#1

31.01.2015, 12:17
Hi,
My ORM does not work, it does not load yet nothing all looks good ... Thank you.

PHP код:
new _query[128];
mysql_format(connectSQL, _query, sizeof(_query), "SELECT * FROM `account` WHERE `Name` = '%e'", returnName(playerid));
mysql_tquery(connectSQL, _query, "OnPlayerDataLoad", "d", playerid);
public OnPlayerDataLoad(playerid)
{
        
    if(cache_num_rows() == 1)
    {
           new ORM:ormid = pInfo[playerid][pORM_ID] = orm_create("account");
        orm_addvar_int(ormid, pInfo[playerid][pID], "ID");
        orm_addvar_int(ormid, pInfo[playerid][pAdmin], "AdminLevel");
        orm_addvar_int(ormid, pInfo[playerid][pLevel], "Level");
        orm_addvar_int(ormid, pInfo[playerid][pRespect], "Respect");
        orm_addvar_int(ormid, pInfo[playerid][pBank], "Bank");
        orm_addvar_int(ormid, pInfo[playerid][pSex], "Sex");
        orm_addvar_int(ormid, pInfo[playerid][pOrigin], "Origin");
        orm_addvar_int(ormid, pInfo[playerid][pSkin], "Skin");
        orm_addvar_int(ormid, pInfo[playerid][pBanTime], "BanTime");
        
        orm_addvar_string(ormid, pInfo[playerid][pPassword], 248, "Password");
        orm_addvar_string(ormid, pInfo[playerid][pName], MAX_PLAYER_NAME+1, "Name");
        orm_addvar_string(ormid, pInfo[playerid][pEmail], 248, "Email");
        orm_addvar_string(ormid, pInfo[playerid][pDescription], 248, "Description");
        orm_addvar_string(ormid, pInfo[playerid][pBanReason], 248, "BanReason");
        orm_setkey(ormid, "Name");
        dialogShow(playerid, connectPlayer, DIALOG_STYLE_PASSWORD, "{0197D8}Connexion а votre compte", "{FEFEFE}Salut ! Merci d'entrer ton mot de passe dans la case ci-dessous, vous avez le droit а un maximum de 5 essais, sinon vous aurez un bannissement de 5 heures sans possibilitй d'unban manuellement.", "Connexion", "Dйconnexion");
    }
    orm_setkey(pInfo[playerid][pORM_ID], "ID");
    return true;
}[B][/B] 
Find
Reply
StasWilson
Little Clucker
**
Posts: 14
Threads: 4
Joined: Mar 2014
Reputation: 0
#2

31.01.2015, 12:47
mysql_log eat?
Find
Reply
Z3N0N
Banned
Posts: 13
Threads: 4
Joined: Nov 2014
#3

31.01.2015, 13:15
Код:
[22:07:36] [WARNING] cache_get_row_count - no active cache
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Name")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("AdminLevel")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Level")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Respect")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Bank")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Sex")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Origin")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Skin")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BanTime")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Password")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Email")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Description")
[22:13:06] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BanReason")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Name")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("AdminLevel")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Level")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Respect")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Bank")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Sex")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Origin")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Skin")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BanTime")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Password")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Email")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("Description")
[22:15:39] [WARNING] CMySQLResult::GetRowDataByName - field not found ("BanReason")
Yet these fields exist.
Find
Reply
StasWilson
Little Clucker
**
Posts: 14
Threads: 4
Joined: Mar 2014
Reputation: 0
#4

31.01.2015, 14:50
Quote:

forward LoginCallback(playerid);

new nickname[MAX_PLAYER_NAME];
GetPlayerName(playerid,nickname, MAX_PLAYER_NAME);
new query_m[128];
mysql_format(DBHandle, query_m, sizeof(query_m), "SELECT * FROM `account` WHERE `Name` = '%e'",nickname);
mysql_tquery(DBHandle, query_m, "LoginCallback","i", playerid);

example 1:
public LoginCallback(playerid)
{
new ORMrmid = PlayerInfo[playerid][ORM_ID] = orm_create("account");
orm_addvar_int(ormid, PlayerInfo[playerid][pMYSQLID], "ID");
orm_addvar_string(ormid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME, "Name");
orm_setkey(ormid, "Name");
orm_addvar_string(ormid, PlayerInfo[playerid][pPassword], 64, "Password");
orm_addvar_int(ormid, PlayerInfo[playerid][pSex], "Sex");
return 1;
}

example 2 :

public LoginCallback(playerid)
{
new ORMrmid = PlayerInfo[playerid][ORM_ID] = orm_create("account");
orm_addvar_int(ormid, PlayerInfo[playerid][pMYSQLID], "ID");
orm_addvar_string(ormid, PlayerInfo[playerid][pName], MAX_PLAYER_NAME, "Name");
orm_setkey(ormid, "Name");
orm_addvar_string(ormid, PlayerInfo[playerid][pPassword], 64, "Password");
orm_addvar_int(ormid, PlayerInfo[playerid][pSex], "Sex");
//
orm_apply_cache(ormid, 0);
return 1;
}
Maybe it will help you
Find
Reply
Z3N0N
Banned
Posts: 13
Threads: 4
Joined: Nov 2014
#5

31.01.2015, 15:07
no load :/

PHP код:
           new ORM:ormid = pInfo[playerid][pORM_ID] = orm_create("account");
           
        orm_addvar_string(ormid, pInfo[playerid][pName], MAX_PLAYER_NAME+1, "Name");
        orm_setkey(ormid, "Name");
        orm_addvar_string(ormid, pInfo[playerid][pPassword], 248, "Password");
        orm_addvar_string(ormid, pInfo[playerid][pName], MAX_PLAYER_NAME+1, "Name");
        orm_addvar_string(ormid, pInfo[playerid][pEmail], 248, "Email");
        orm_addvar_string(ormid, pInfo[playerid][pDescription], 248, "Description");
        orm_addvar_string(ormid, pInfo[playerid][pBanReason], 248, "BanReason");

        orm_addvar_int(ormid, pInfo[playerid][pID], "ID");
        orm_addvar_int(ormid, pInfo[playerid][pAdmin], "AdminLevel");
        orm_addvar_int(ormid, pInfo[playerid][pLevel], "Level");
        orm_addvar_int(ormid, pInfo[playerid][pRespect], "Respect");
        orm_addvar_int(ormid, pInfo[playerid][pBank], "Bank");
        orm_addvar_int(ormid, pInfo[playerid][pSex], "Sex");
        orm_addvar_int(ormid, pInfo[playerid][pOrigin], "Origin");
        orm_addvar_int(ormid, pInfo[playerid][pSkin], "Skin");
        orm_addvar_int(ormid, pInfo[playerid][pBanTime], "BanTime");
        orm_apply_cache(ormid, 0); 
Find
Reply
StasWilson
Little Clucker
**
Posts: 14
Threads: 4
Joined: Mar 2014
Reputation: 0
#6

31.01.2015, 15:14
You have no tables or cells
Find
Reply
Z3N0N
Banned
Posts: 13
Threads: 4
Joined: Nov 2014
#7

31.01.2015, 15:18
Find
Reply
StasWilson
Little Clucker
**
Posts: 14
Threads: 4
Joined: Mar 2014
Reputation: 0
#8

31.01.2015, 15:40
Do not re-created orm_addvar_string, orm_addvar_int

(SELECT `add the values that you want to read or create sequences from ID`)

EXAMPLE 1

SELECT `ID`, `Nickname`, `Password` ....

Example 2

SELECT * - Load all




mysql_format(DBHandle, query_m, sizeof(query_m), "SELECT * FROM `account` WHERE `Name` = '%e'",nickname);
mysql_tquery(DBHandle, query_m, "LoginCallback","i", playerid);
Find
Reply
StasWilson
Little Clucker
**
Posts: 14
Threads: 4
Joined: Mar 2014
Reputation: 0
#9

31.01.2015, 15:42
and check the connection to mysql
Find
Reply
Z3N0N
Banned
Posts: 13
Threads: 4
Joined: Nov 2014
#10

31.01.2015, 16:33
I did not understand sorry: / The connection is not good if it will launch.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 4 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help