22.05.2012, 12:18
(
Последний раз редактировалось danielhertz; 22.05.2012 в 14:30.
)
Code:
Errors:
pawn Код:
#include <a_samp>
#include <a_mysql>
//mysql
#define DIALOG_LOGIN 1
#define DIALOG_REGISTER 2
main()
{
print("\n----------------------------------");
print(" mysql ");
print("----------------------------------\n");
}
public OnGameModeInit()
{
mysql_debug(1);
mysql_connect("localhost", "root", "tutorialdb","");
SetGameModeText("SQL");
AddPlayerClass(16, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0); //TEAM ONE
SetWeather(9);
return true;
}
public OnGameModeExit()
{
mysql_debug();
mysql_close(0);
return 1;
}
public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, -1325.90002441,492,10.80000019);
SetPlayerFacingAngle(playerid,86.8798);
SetPlayerCameraPos(playerid, 2920.7109,-1563.5922,12.0877);
SetPlayerCameraLookAt(playerid, 2924.9727,-1563.8043,11.0469);
return 1;
}
public OnPlayerConnect(playerid)
{
new Query[100];
format(Query,sizeof(Query), "SELECT name FROM tutorialdb WHERE name='%s'",PlayerName(playerid));
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()>0)
{
ShowPlayerDialog(playeird,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","You're register please type your password","Continue","Exit");
}
else
{
ShowPlayerDialog(playeird,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Register","You're not register please type your password","Continue","Exit");
}
mysql_free_result();
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
new Query[100];
format(Query,sizeof(Query),"UPDATE tutorialdb SET money=%d, score=%d WHERE name='%s'",GetPlayerMoney(playerid),GetPlayerScore(playerid), PlayerName(playerid));
mysql_query(Query);
return 1;
}
public OnPlayerSpawn(playerid)
{
return true;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if( dialogid == DIALOG_LOGIN )
{
new Query[100];
if(!response)
{
Kick(playerid);
SendClientMessage(playerid,-1,"Login exit");
return 0;
}
format(Query,sizeof(Query),"SELECT name FROM tutrialdb WHERE name='%s' AND password='%s'",PlayerName(playerid),inputtext);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()>0)
{
SendClientMessage(playerid,-1,"You successfully login ");
load_player_data(playerid);
}
{
SendClientMessage(playeird, -1,"Invalid password");
ShowPlayerDialog(playeird,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","You're register please type your password","Continue","Exit");
}
mysql_free_result();
return 1;
}
if( dialogid == DIALOG_REGISTER )
{
new Query[100];
if(!response)
{
Kick(playerid);
SendClientMessage(playerid,-1,"Register exit-break");
return 0;
}
format(Query,sizeof(Query),"INSERT INTO tutorialdb (name,passworc,score,money) VALUES ('%s,'%s',0,0)", PlayerName(playerid),inputtext);
mysql_query(Query);
SpawnPlayer(playerid);
SendClientMessage(playerid, -1,"You successfully registered!");
}
return 1;
}
stock PlayerName(1)
{
new pname[MAX_PLAYER_NAME];
GetPlayerName(1,pname,MAX_PLAYER_NAME);
return pname;
}
stock load_player_data(playerid);
{
new Query[100];
format(Query,sizeof(Query),"SELECT * FROM tutorialdb WHERE name='%s'".PlayerName(playerid));
mysql_query(Query);
mysql_store_result();
datastr[20];
while(mysql_fetch_row_format(Query,"|"))
{
mysql_fetch_field_row(datastr,"money"); GivePlayerMoney(playerid,strval(datastr));
mysql_fetch_field_row(datastr,"score"); SetPlayerScore(playerid,strval(datastr));
}
mysql_free_result();
SpawnPlayer(playerid);
SendClientMessage(playerid, -1,"Your data succesfully loaded");
return 1;
}
Код:
C:\PC\Yair\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(46) : warning 219: local variable "Query" shadows a variable at a preceding level
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(47) : warning 202: number of arguments does not match definition
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(48) : error 004: function "mysql_query" is not implemented
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(52) : error 017: undefined symbol "playeird"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(57) : error 017: undefined symbol "playeird"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(66) : warning 219: local variable "Query" shadows a variable at a preceding level
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(67) : warning 202: number of arguments does not match definition
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(68) : error 004: function "mysql_query" is not implemented
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(78) : error 029: invalid expression, assumed zero
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(78 -- 79) : warning 215: expression has no effect
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(79) : error 001: expected token: ";", but found "if"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(82) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(86) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(89) : error 021: symbol already defined: "format"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(91) : error 021: symbol already defined: "mysql_store_result"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(92) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(97) : error 054: unmatched closing brace ("}")
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(99) : error 055: start of function body without function header
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(104) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(107) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(109) : error 021: symbol already defined: "Query"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(110) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(114) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(117) : error 021: symbol already defined: "format"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(119) : error 021: symbol already defined: "SpawnPlayer"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(122) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(125) : error 010: invalid function or declaration
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(133) : error 055: start of function body without function header
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(134) : error 021: symbol already defined: "Query"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(137) : error 021: symbol already defined: "mysql_store_result"
C:\Users\PC\Desktop\0.3e SAMP-SERVER\gamemodes\ZASQL.pwn(139) : error 010: invalid function or declaration
Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase
26 Errors.
