SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 28/10/2013, 10:03 PM   #1
kingcrome
Big Clucker
 
Join Date: Oct 2013
Posts: 89
Reputation: 0
Default I am getting a mysql register and login script and im getting a error

/*


.Andy47.

MySql R8 Login Register System


*/
// *** Includes

#include <a_samp>
#include <a_mysql>
#include <zcmd>

// *** Defines

#define mysql_host "localhost"
#define mysql_user "root"
#define mysql_db "legend"
#define mysql_pass ""

#define COLOR_GREY 0xAFAFAFAA

#define G "{00FF00}"
#define W "{FFFFFF}"
#define LB "{00C0FF}"
#define O "{FFAF00}"
#define R "{F81414}"
#define SRV "{AFE7FF}"
#define GR "{C3C3C3}"

#define Function::%0(%1) forward%0(%1); public%0(%1)
// *** News
new gQuery[2800], gString[4000];

// *** Functii

#define SPD ShowPlayerDialog
#define SCM SendClientMessage

stock bool:False = false;

#define SCMF(%0,%1,%2,%3)\
do{\
gString[0] = EOS;\
format(gString,256,(%2),%3);\
SendClientMessage((%0),(%1),gString);\
}\
while( False )

// *** Enums

enum
{
THREAD_DIALOG_REGISTER,
THREAD_DIALOG_LOGIN
}
enum PlayerData
{
ID,
pKills,
pDeaths,
pMoney
}
new P_DATA[MAX_PLAYERS][PlayerData];
new bool:Logged[MAX_PLAYERS];

main()
{
print(" MySql Project ");
print(" MySql r8 ");
print(" by .ANdy47. ");
}


public OnGameModeInit()
{
//===============================MySql Connect==================================
mysql_connect(mysql_host,mysql_user,mysql_db,mysql _pass);
if(mysql_ping() == 1)
{
mysql_log(1);
printf("[MySql]: Conexiunea la baza de date [%s] a avut succes!", mysql_db);
}
else
{
printf("[MySql]: Conexiunea la baza de date nu a avut succes!");
}
//================================================== ============================
SetGameModeText("MySql Project");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
UsePlayerPedAnims();
DisableInteriorEnterExits();
SetTimer("SavePlayerData",600000,false); // odata la 10 minute se salveaza conturile
return 1;
}

public OnGameModeExit()
{
return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}

public OnPlayerConnect(playerid)
{
new pName[MAX_PLAYER_NAME],
pName1[MAX_PLAYER_NAME],
string[256];

GetPlayerName(playerid,pName,sizeof(pName));
mysql_real_escape_string(pName,pName1);

format(string,sizeof(string),"SELECT `Name` FROM `Users` WHERE `Name` = '%s' LIMIT 0,1",pName1);
mysql_function_query(1,string,true,"AccountLoad"," is",playerid,pName1);
return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
if(Logged[playerid] == false) // daca playerul nu este logat i se va sterge contul
{
gQuery[0] = EOS;
format(gQuery, 256, "SELECT `Name` FROM `Users` WHERE `Name` = '%s' LIMIT 0,1", GetName(playerid));
mysql_function_query(1, gQuery, true, "DeletePlayerAccount", "s", GetName(playerid));
}
else
{
SavePlayerData(playerid);
}
return 1;
}

public OnPlayerSpawn(playerid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
P_DATA[playerid][pDeaths] ++;
P_DATA[killerid][pKills] ++;
return 1;
}

public OnVehicleSpawn(vehicleid)
{
return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}

public OnPlayerText(playerid, text[])
{
return 1;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}

public OnRconCommand(cmd[])
{
return 1;
}

public OnPlayerRequestSpawn(playerid)
{
return 1;
}

public OnObjectMoved(objectid)
{
return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}

public OnPlayerExitedMenu(playerid)
{
return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}

public OnPlayerUpdate(playerid)
{
return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case THREAD_DIALOG_REGISTER:
{
if(!response)
return SetTimerEx("KickRegister",500,false,"i",playerid);

if(response)
{
new string[256];

gQuery[0] = EOS;
format(gQuery, 256, ""W"Nu ai introdus nici o parola!\n"W"Te rugam introdu parola cu care vrei sa te inregistrezi!");
if(!strlen(inputtext)) return SPD(playerid,THREAD_DIALOG_REGISTER,DIALOG_STYLE_P ASSWORD,""GR"Inregistrare",gQuery,"Register","Kick ");
format(string, sizeof(string),"INSERT INTO `Users`(Name,Password,Kills,Deaths,Money) VALUES('%s','%s','0','0','0')",GetName(playerid),i nputtext);
mysql_function_query(1,string,false,"","");

format(gQuery, 256,""W"Bine ai venit inapoi, "LB"%s!\nPoti sa te loghezi.",GetName(playerid));
SPD(playerid,THREAD_DIALOG_LOGIN,DIALOG_STYLE_PASS WORD,""GR"Logare",gQuery,"Login","Cancel");
}
}
case THREAD_DIALOG_LOGIN:
{
if(!response)
return SetTimerEx("KickRegister",500,false,"i",playerid);
if(response)
{
gQuery[0] = EOS;
new q_str[256];

format(q_str,sizeof(q_str),"SELECT `Name` FROM `Users` WHERE `Name` = '%s' AND `Password` = '%s'", GetName(playerid),inputtext);
mysql_function_query(1,q_str,true,"Query_LoadP_DAT A","is",playerid,GetName(playerid));

Logged[playerid] = true;

SpawnPlayer(playerid);
}
}
}
return 1;
}
public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}

CMDtats(playerid, params[])
{
SCMF(playerid, -1,""SRV"Name: %s Kills: %d Deaths: %d Money: %d",GetName(playerid),P_DATA[playerid][pKills],P_DATA[playerid][pDeaths],P_DATA[playerid][pMoney]);
return 1;
}
Function:: Query_LoadP_DATA(playerid,q_acc[])
{
new q_rows,
q_fields,
q_str[150];

cache_get_data(q_rows,q_fields);

if(!q_rows)
{
new str[300];
format(str,sizeof(str),""W"Hey "LB"%s !\nAi introdus parola gresita\nTe rugam rescrieti parola mai jos pentru a te loga .",GetName(playerid));
SPD(playerid,THREAD_DIALOG_LOGIN,DIALOG_STYLE_PASS WORD,""GR"Login",str,"Login","exit");
}
else
{
format(q_str, sizeof(q_str),"SELECT * FROM `Users` WHERE Name = '%s'",q_acc);
mysql_function_query(1, q_str,true,"OnPlayerCheckedLogin","ds",playerid,q_ acc);
}

return 1;
}
Function:: OnPlayerCheckedLogin(playerid)
{
P_DATA[playerid][ID] = cache_get_field_content_int(0, "ID");
P_DATA[playerid][pKills] = cache_get_field_content_int(0, "Kills");
P_DATA[playerid][pDeaths] = cache_get_field_content_int(0, "Deaths");
P_DATA[playerid][pMoney] = cache_get_field_content_int(0, "Money");
return 1;
}

Function:: AccountLoad(playerid,q_acc[])
{
new q_rows,
q_fields;

cache_get_data(q_rows,q_fields);
if(q_rows)
{
gQuery[0] = EOS;
format(gQuery,256,""W"Bine ai venit inapoi, "LB"%s!\nPoti sa te loghezi.",q_acc);
SPD(playerid,THREAD_DIALOG_LOGIN,DIALOG_STYLE_PASS WORD,""GR"Logare",gQuery,"Login","Cancel");
}
else
{
gQuery[0] = EOS;
format(gQuery, 256,""W"Bun Venit, "LB"%s!\nPoti sa te inregistrezi!",q_acc);
SPD(playerid,THREAD_DIALOG_REGISTER,DIALOG_STYLE_P ASSWORD,""GR"Inregistrare",gQuery,"Register","Kick ");
}

return 1;
}

Function:: SavePlayerData(playerid)
{
new ks = P_DATA[playerid][pKills],
dth = P_DATA[playerid][pDeaths],
mn = P_DATA[playerid][pMoney];

gQuery[0] = EOS;
format(gQuery, 256,"UPDATE `Users` SET `Kills`='%d',`Deaths`='%d',`Money`='%d'WHERE `Name`='%s'",ks,dth,mn,GetName(playerid));

mysql_function_query(1,gQuery,false,"","");

SendClientMessageToAll(-1,""LB"Conturi:"O"Conturile au fost salvate in baza de date.");
return 1;
}

Function:: DeletePlayerAccount(q_acc[])
{
new rows, fields;

cache_get_data(rows, fields);
if(rows)
{
gQuery[0] = EOS;
format(gQuery, 256, "DELETE FROM `Users` WHERE `Name` = '%s'", q_acc);
mysql_function_query(1, gQuery, false, "", "");
}
return 1;
}

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

// *** Kick Function

Function:: KickRegister(playerid)
{
Kick(playerid);
SCMF(playerid,-1,""SRV"%s ai primit kick!",GetName(playerid));
return 1;
}
kingcrome is offline   Reply With Quote
Old 28/10/2013, 10:27 PM   #2
PaulDinam
Gangsta
 
Join Date: Jun 2011
Posts: 887
Reputation: 45
Default Re: I am getting a mysql register and login script and im getting a error

Please.. wrap the code with [PAWN] tag
PaulDinam is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Login and Register script help Zex Tan Scripting Help 2 06/12/2012 04:34 AM
Help for Script of Register/login for RP Parscafe Scripting Help 4 26/06/2012 02:34 PM
MySQL Login/register error xMichaelx Scripting Help 0 06/12/2011 05:08 AM
Error in MySQL Register Script Gforcez Help Archive 3 24/07/2010 12:09 PM


All times are GMT. The time now is 12:30 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.