04.04.2015, 11:41
Hello im working on Login And Register sistem with Mysql and ive finished but i have errors .Down there is code and errors , Thanks for help i prishied.
Prijava-Login
Odustani-Cancle
errors are
(52) : warning 215: expression has no effect
(53) : error 029: invalid expression, assumed zero
(53) : error 001: expected token: ")", but found ";"
(53 -- 55) : warning 215: expression has no effect
(55) : error 001: expected token: ";", but found "if"
(55) : fatal error 107: too many error messages on one line
Includes and Defines are
#include <a_samp>
#include <sscanf2>
#include <a_mysql>
If i remove this erorr shows , that need to define all of 3 but if i define only first 2 #define mysql_num_rows
dont need to define why ? He told me that need to define all of 3 but its ok to define only 2 pls help ?
#define mysq_query
#define mysql_store_result
#define mysql_num_rows
//================================================== ===================
Prijava-Login
Odustani-Cancle
errors are
(52) : warning 215: expression has no effect
(53) : error 029: invalid expression, assumed zero
(53) : error 001: expected token: ")", but found ";"
(53 -- 55) : warning 215: expression has no effect
(55) : error 001: expected token: ";", but found "if"
(55) : fatal error 107: too many error messages on one line
Includes and Defines are
#include <a_samp>
#include <sscanf2>
#include <a_mysql>
If i remove this erorr shows , that need to define all of 3 but if i define only first 2 #define mysql_num_rows
dont need to define why ? He told me that need to define all of 3 but its ok to define only 2 pls help ?
#define mysq_query
#define mysql_store_result
#define mysql_num_rows
//================================================== ===================
Код:
public OnGameModeInit()
{
// Don't use these lines if it's a filterscript
mysql_connect("localhost", "root", "server", "");
SetGameModeText("Blank Script");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}
//======
public OnPlayerConnect(playerid)
{
new query[124], pName[MAX_PLAYER_NAME];
GetPlayerName(playerid, pName, sizeof(pName));
format(query, sizeof(query), "SELECT * FROM accounts WHERE name = '%s'", pName);
mysq_query(query); -line 50error
mysql_store_result(); -line 51error
if(mysql_num_rows() == 1) -line 53 error
{
SendClientMessage(playerid, -1, "Thats username is registred!");
ShowPlayerDialog(playerid, 0,DIALOG_STYLE_INPUT, "Prijava", "Please login with ur password u made", "Prijava", "Odustani");
}
else
{
SendClientMessage(playerid, -1, "Thats username is not registred, u may register!");
}
return 1;
}
//==========
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case 0:
{
if(response)
{
new query[126], pName[MAX_PLAYER_NAME];
GetPlayerName(playerid, pName, sizeof[pName]);
format(query, sizeof(query), "SELECT password FROM accounts WHERE name = '%s' AND password = '%s'", pName, inputtext);
mysql_query(query);
mysql_store_result();
if(mysql_nun_rows() == 1)
{
SendClientMessage(playerid, -1, "You have successfully signed in!)';
SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 999, 1, 999, 1, 999);
SpawnPlayer(playerid);
}
else
{
SendClientMesage(playerid, -1, "Incorrect Password");
ShowPlayerDialog(playerid, 0, DIALOG_STYLE_INPUT, "Prijava", "Please login with the password u made", "Prijava", "Odustani");
}
}
}
case 1:
{
if(response)
}
new query[126], pName[MAX_PLAYER_NAME];
GetPlayerName(playerid, pName, sizeof[pName]);
format(query, sizeof(query), "INSERT INTO accounts VALUES ('%s', '%s', pName, inputtext)
mysql_query(query);
SendClientMessage(playerid, -1, "You have registred!");
SetSpawnInfo(playerid, 1, 299, 1, 2, 3, 1, 1, 999, 1, 999, 1, 999);
}
}
}
return 1;
}
