| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 7,714
» Latest member: Vorgannn
» Forum threads: 2,359
» Forum posts: 12,306
Full Statistics
|
| Online Users |
There are currently 305 online users.
» 1 Member(s) | 301 Guest(s)
Bing, Google, Baidu, saimkhan9647
|
| Latest Threads |
Help me for creating a fr...
Forum: General Discussions
Last Post: [Rs]VeNoM
43 minutes ago
» Replies: 0
» Views: 1
|
The server didn't respond...
Forum: Support
Last Post: richboY
Yesterday, 10:51 AM
» Replies: 0
» Views: 24
|
error when joining server
Forum: Support
Last Post: sanved2008
Yesterday, 09:02 AM
» Replies: 0
» Views: 19
|
Client issue with object
Forum: Support
Last Post: TheDoctor
2025-11-15, 08:00 PM
» Replies: 0
» Views: 82
|
San Andreas Police Pursui...
Forum: Advertisements
Last Post: BriBri
2025-11-15, 12:06 AM
» Replies: 0
» Views: 94
|
[Include] OpenGate (Abrir...
Forum: Portuguese/Portugu?s
Last Post: Crazy_ArKzX
2025-11-13, 06:49 PM
» Replies: 0
» Views: 77
|
OpenGate (Open Proximity ...
Forum: Libraries
Last Post: Crazy_ArKzX
2025-11-13, 06:46 PM
» Replies: 0
» Views: 91
|
LS City Hall
Forum: Maps
Last Post: cosminupgaming
2025-11-12, 04:22 PM
» Replies: 3
» Views: 2,721
|
Crime Base
Forum: Maps
Last Post: cosminupgaming
2025-11-12, 04:19 PM
» Replies: 2
» Views: 1,282
|
GTA SA-MP Scripting: Issu...
Forum: General Discussions
Last Post: williamrhein
2025-11-12, 10:16 AM
» Replies: 0
» Views: 108
|
|
|
| Help with tables |
|
Posted by: Pedxz - 2021-07-01, 01:19 AM - Forum: Pawn Scripting
- No Replies
|
 |
Well, I downloaded a GM and it didn't come with the SQL import file, so it can be uploaded to phpmyadmin! I would like to know if you can help me with some tables, some I created myself, but others, I'm having difficulties, because they are created, but they don't save anything!?
Sample code from a table that is occurring what I said:
Code: stock CarregarFileMySQL(playerid)
[/font][/size][/color]
{
new TmpInt;
format(gStr, sizeof(gStr), "SELECT * FROM `"TABLE_CONTAS"` WHERE `Nick` = BINARY '%s'", pNome(playerid));
mysql_query(IDConexao, gStr);
if(cache_num_rows() == 0)
{
format(gstring, sizeof(gstring), "INSERT INTO `"TABLE_CONTAS"` (`Nick`, `?ltimoLogin`, `Data Registro`, `IP`) VALUES ('%s', '%d', '%d', '%s')", pNome(playerid), gettime(), gettime(), GetPlayerIP(playerid));
mysql_query(IDConexao, gstring, false);
format(gStr, sizeof(gStr), "SELECT * FROM `"TABLE_CONTAS"` WHERE `Nick` = BINARY '%s'", pNome(playerid));
mysql_query(IDConexao, gStr);
}
cache_get_value_name(0, "CorBarraStatus", pInfo[playerid][BarraCor]);
cache_get_value_name_int(0, "ID", pInfo[playerid][PlayerID]);
cache_get_value_name_int(0, "Cargo", aInfo[playerid][Cargo]);
cache_get_value_name_int(0, "Espi?o", aInfo[playerid][Espiao]);
cache_get_value_name_int(0, "?ltimoLogin", pInfo[playerid][UltimoLogin]);
cache_get_value_name_int(0, "TipoVIP", pInfo[playerid][TipoVIP]);
cache_get_value_name_int(0, "TempoVIP", pInfo[playerid][TempoVIP]);
cache_get_value_name_int(0, "Fome", pInfo[playerid][Fome]);
cache_get_value_name_int(0, "Sede", pInfo[playerid][Sede]);
cache_get_value_name_int(0, "SegundosUP", pInfo[playerid][SegundosUP]);
cache_get_value_name_int(0, "Exp", pInfo[playerid][Exp]);
cache_get_value_name_int(0, "Saldo", pInfo[playerid][Saldo]);
// ----- //
cache_get_value_name_int(0, "RUP_Possui", pInfo[playerid][RUP_Possui]);
cache_get_value_name_int(0, "RUP_Ligado", pInfo[playerid][RUP_Ligado]);
cache_get_value_name(0, "RUP_Cor", pInfo[playerid][RUP_Cor]);
cache_get_value_name_int(0, "LCL_Possui", pInfo[playerid][LCL_Possui]);
cache_get_value_name_int(0, "VFC_Possui", pInfo[playerid][VFC_Possui]);
cache_get_value_name_int(0, "SGR_Possui", pInfo[playerid][SGR_Possui]);
cache_get_value_name_int(0, "CPT_Possui", pInfo[playerid][CPT_Possui]);
cache_get_value_name_int(0, "CPT_Modelo", pInfo[playerid][CPT_Modelo]);
cache_get_value_name_int(0, "CVN_Possui", pInfo[playerid][CVN_Possui]);
cache_get_value_name_int(0, "CTB_Possui", pInfo[playerid][CTB_Possui]);
cache_get_value_name_int(0, "CEL_Possui", pInfo[playerid][CEL_Possui]);
cache_get_value_name_int(0, "CEL_SMS", pInfo[playerid][CEL_SMS]);
cache_get_value_name_int(0, "YTP_Possui", pInfo[playerid][YTP_Possui]);
cache_get_value_name_int(0, "GPSC_Possui", pInfo[playerid][GPSC_Possui]);
cache_get_value_name_int(0, "GPSC_Status", pInfo[playerid][GPSC_Status]);
cache_get_value_name_int(0, "GPSL_Possui", pInfo[playerid][GPSL_Possui]);
cache_get_value_name_int(0, "GPSL_Status", pInfo[playerid][GPSL_Status]);
cache_get_value_name_int(0, "KIT_Possui", pInfo[playerid][KIT_Possui]);
cache_get_value_name_int(0, "KITF_Possui", pInfo[playerid][KITF_Possui]);
// ----- //
cache_get_value_name_int(0, "Moedas", TmpInt);
GivePlayerMoedas(playerid, TmpInt);
cache_get_value_name_int(0, "pLevel", TmpInt);
SetPlayerScore(playerid, TmpInt);
cache_get_value_name_int(0, "Dinheiro", TmpInt);
GivePlayerCash(playerid, TmpInt);
cache_get_value_name_int(0, "Procurado", TmpInt);
SetPlayerWantedLevel(playerid, TmpInt);
// --------------------- //
if(GetPlayerCargo(playerid) >= C_MODERADOR) aInfo[playerid][BloqueadoR] = true;
if(pInfo[playerid][TipoVIP] != -1 || GetPlayerCargo(playerid) >= C_MODERADOR) ChatVIP[playerid] = true;
SetPVarInt(playerid, "pID", pInfo[playerid][PlayerID]);
SetPVarInt(playerid, "pCargo", aInfo[playerid][Cargo]);
// ------------------------------------------ //
format(gstring, sizeof(gstring), "UPDATE `"TABLE_CONTAS"` SET `?ltimoLogin` = %d, `IP` = '%s' WHERE `ID` = %d", gettime(), GetPlayerIP(playerid), pInfo[playerid][PlayerID]);
mysql_query(IDConexao, gstring, false);
// ------------------------------------------ //
// blogins
format(gStr, sizeof(gStr), "INSERT INTO `"TABLE_LOGINS"` (`Jogador_ID`, `TS_Logou`) VALUES (%d, %d)", pInfo[playerid][PlayerID], gettime());
mysql_query(IDConexao, gStr);
pInfo[playerid][SessaoID] = cache_insert_id();
pInfo[playerid][TimeLogou] = gettime();
pInfo[playerid][LevelLogou] = pInfo[playerid][Level];
// ------------------------------------------ //
pInfo[playerid][Logado] = true;
// ------------------------------------------ //
format(gstring, sizeof(gstring), "[ %s - %s ] %s logou no servidor. [ IP: %s | Level: %d | Saldo: %d | Grana: %d | Moedas: %d | Frag: %d / %d ]",
Gdata(), Ghora(), pNome(playerid), GetPlayerIP(playerid), pInfo[playerid][Level], pInfo[playerid][Saldo], GetPlayerCash(playerid), GetPlayerMoedas(playerid), pInfo[playerid][fMatou], pInfo[playerid][fMorreu]);
LogLogins(gstring);
[color=#333333][size=small][font=Tahoma, Verdana, Arial, sans-serif]}
|
|
|
|
| (5) warning 213: tag mismatch |
|
Posted by: SAMPZA - 2021-06-30, 12:17 PM - Forum: Pawn Scripting
- Replies (1)
|
 |
Hello guys, i need your help
i want to make an code easier so i create this code bellow but i got 5 warnings 213 ( problem here?PlayerInfo[playerid][AchInfo2[i][AchVar]] )
do you have any ideas about this
Code: #define?MAX_ACHS 2
new verylargestr[4096];
enum ach_info
{
AchID,
AchName[64],
AchScore,
AchNeeded,
AchVar
};
new AchInfo2[MAX_ACHS][ach_info] = { // Here Achievements info
{1,"Killer 1 : Kill 100 players", 10.000, 70, 15}, // 15 meaning the classement of the array of players look at?enum playerinfo
{2,"Killer 2?: kill 500 players", 30.000, 500, 15}
};
CMD:achievements(playerid, params[])
{
new gstr[128];
? ? format(verylargestr, sizeof verylargestr, "");
? ? strcat(verylargestr, ""yellow_e"Buy Gold vip 1 time and get your reward "white"100.000 Scores\n");
? ? strcat(verylargestr, ""yellow_e"Buy Silver vip 1 time and get your reward "white"70.000 Scores\n");
? ? strcat(verylargestr, ""yellow_e"Buy Bronze vip 1 time and get your reward Bronze "white"30.000 Scores\n");
for(new i = 0; i < sizeof(AchInfo2); i)
{
? ? if(PlayerInfo[playerid][AchInfo2[i][AchVar]] >= AchInfo2[i][AchNeeded])
{
format(gstr, sizeof gstr, "\n{2DFF00}%d.) %d/%d %s - %d Scores",i, AchInfo2[i][AchNeeded],AchInfo2[i][AchNeeded],AchInfo2[i][AchName],AchInfo2[i][AchScore]);
strcat(verylargestr, gstr);
}
? ? else if(PlayerInfo[playerid][AchInfo2[i][AchVar]] < AchInfo2[i][AchNeeded])
{
format(gstr, sizeof gstr, "\n{F64B4B}%d.) %d/%d %d - %d Scores", i, PlayerInfo[playerid][AchInfo2[i][AchVar]], AchInfo2[i][AchNeeded],AchInfo2[i][AchName],AchInfo2[i][AchScore]);
strcat(verylargestr, gstr);
}
}
? ? ShowPlayerDialog(playerid, DIALOG_ACHS, DIALOG_STYLE_MSGBOX, "Achievements List", verylargestr, "Ok", "");
? ? return true;
}
enum playerinfo
{
? ? pID, //0
pUsername[26], //1
pPassword[128], //2
.
.
.
pKills // 15
};
new PlayerInfo[MAX_PLAYERS][playerinfo];
|
|
|
|
| ActorGalore - Actor Editor |
|
Posted by: UnuAlex - 2021-06-28, 11:19 AM - Forum: Filterscripts
- Replies (2)
|
 |
Hi! This is my first post on this forum. So...Hi there! Nice to meet u!
I decided to realease this script here too, so that more poeple can have access to it and use it.
This script as the titles suggests its an actor editor i created. Its really usefull to quickly edit actors directly in-game.
If you want to learn how to use it check the video downbellow \/. Or if you don't have the patience just type /actorhelp, that will display all the commands available to you. Ofcourse first make sure you're rcon logged.
Video Presentation:?https://youtu.be/F4ikjwt2wT0?t=67
Download:?https://github.com/UnuAlex/Actor-Galore
|
|
|
|
| Help with enter and exiting an interior |
|
Posted by: XDK6 - 2021-06-28, 03:05 AM - Forum: Pawn Scripting
- No Replies
|
|
Hello Burgershot Community,
I have a problem with my 3dtext label and exiting a property on my script. Whenever I exit the property it tp me to the first 24/7 store that I created instead of the new one.
here is the code I use on creating a property system with printing the ids on 3d text label
variables and enums:
Code: #define MAX_STORES 500
enum sInfo
{
sID,
sType,
Text3D:sLabel,
sName[50],
sMapIcon,
sPickup,
Float:sX,
Float:sY,
Float:sZ,
sInt,
sVirt,
Float:intsX,
Float:intsY,
Float:intsZ,
sintInt,
sintVirt,
bool:sIDUsed
};
new storeinfo[MAX_STORES][sInfo];
new TotalStores;
Code for creating the store
Code: createstore(storeid, type, Float:X, Float:Y, Float:Z, Float:IntX, Float:IntY, Float:IntZ, intInt, intVirt)
{
TotalStores;
storeinfo[storeid][sID] = storeid;
storeinfo[storeid][sX] = X;
storeinfo[storeid][sY] = Y;
storeinfo[storeid][sZ] = Z;
storeinfo[storeid][sInt] = 0;
storeinfo[storeid][sVirt] = 0;
storeinfo[storeid][intsX] = IntX;
storeinfo[storeid][intsY] = IntY;
storeinfo[storeid][intsZ] = IntZ;
storeinfo[storeid][sintInt] = intInt;
storeinfo[storeid][sintVirt] = intVirt;
intVirt = storeinfo[storeid][sID];
storeinfo[storeid][sIDUsed] = true;
storeinfo[storeid][sPickup] = CreateDynamicPickup(1272, 1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 0);
storeinfo[storeid][sType] = type;
new string2[128];
if(storeinfo[storeid][sType] == 1)
{
format(string2, sizeof(string2), "24/7 (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 17, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 2)
{
format(string2, sizeof(string2), "Burgershot (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 10, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 3)
{
format(string2, sizeof(string2), "Cluckin Bell (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 14, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 4)
{
format(string2, sizeof(string2), "Well Stacked Pizza Co. (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 29, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 5)
{
format(string2, sizeof(string2), "Binco (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 45, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 6)
{
format(string2, sizeof(string2), "Zip (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 45, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 7)
{
format(string2, sizeof(string2), "Pro-Laps (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 45, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 8)
{
format(string2, sizeof(string2), "Suburban (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 45, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
if(storeinfo[storeid][sType] == 9)
{
format(string2, sizeof(string2), "Didier Sachs (ID:%d)", storeinfo[storeid][sName], storeinfo[storeid][sID]);
? ? ? ? storeinfo[storeid][sLabel] = Create3DTextLabel(string2, -1, storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 30.0, storeinfo[storeid][sVirt]);
for(new i = 0; i < MAX_PLAYERS; i)
? ? {
storeinfo[storeid][sMapIcon] = CreateDynamicMapIcon(storeinfo[storeid][sX], storeinfo[storeid][sY], storeinfo[storeid][sZ], 45, 1, 0, 0, i, 300, MAPICON_LOCAL);
}
}
new string[128];
format(string, sizeof(string), "Store ID: %d has been created. Total Stores: %d", storeid, TotalStores);
printf(string);
}
Enter and Exit code:
Code: stock SendPlayerInsideStore(playerid, storeid)
{
if(storeid == MAX_STORES) return 0;
new Float:X = storeinfo[storeid][intsX], Float:Y = storeinfo[storeid][intsY], Float:Z = storeinfo[storeid][intsZ], Int = storeinfo[storeid][sintInt], Virt = storeinfo[storeid][sID];
SetPlayerPos(playerid, X, Y, Z);
SetPlayerInterior(playerid, Int);
SetPlayerVirtualWorld(playerid, Virt);
return 1;
}
stock SendPlayerOutsideStore(playerid, storeid)
{
if(storeid != MAX_STORES)
{
? ? ? ? new Float:X = storeinfo[storeid][sX], Float:Y = storeinfo[storeid][sY], Float:Z = storeinfo[storeid][sZ], Int = storeinfo[storeid][sInt];
SetPlayerPos(playerid, X, Y, Z);
SetPlayerInterior(playerid, Int);
SetPlayerVirtualWorld(playerid, 0);
}
else return 0;
return 1;
}
|
|
|
|
| How to make pasword validation? |
|
Posted by: CrypticSin - 2021-06-27, 02:48 PM - Forum: Pawn Scripting
- Replies (2)
|
|
Hello i need help with?password validation, so if registered user types wrong password more than 3 times to login, it should kick the user?
PHP Code: public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
? ? if(dialogid == REGISTER_DIALOG)
? ? {
? ? ? ? if(response)
? ? ? ? {
? ? ? ? ? ? if(strlen(inputtext) < 3 || strlen(inputtext) > 24)
? ? ? ? ? ? {
? ? ? ? ? ? ? ? SendClientMessage(playerid, -1, "SERVER: Your password must be from 3-24 characters.");
? ? ? ? ? ? ? ? return ShowPlayerDialog(playerid, REGISTER_DIALOG, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register Account", "{FFFFFF}Please enter a password below to register an account:", "Enter", "Leave");
? ? ? ? ? ? }
? ? ? ?
? ? ? ? ? ? bcrypt_hash(playerid, "OnPlayerRegister", inputtext, 12);
? ? ? ? ? ? return 1;
? ? ? ? }
? ? ? ? else
? ? ? ? {
? ? ? ? ? ? Kick(playerid);
? ? ? ? }
? ? }
? ? else if(dialogid == LOGIN_DIALOG)
? ? {
? ? ? ? if(response)
? ? ? ? {
? ? ? ? ? ? new query[256], field[64];
? ? ? ? ? ? format(query, sizeof(query), "SELECT `PASS` FROM `USERS` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(ReturnName(playerid)));
? ? ? ? ? ? database_result = db_query(server_database, query);
? ? ? ? ? ? ? if(db_num_rows(database_result))
? ? ? ? ? ? {
? ? ? ? ? ? ? ? db_get_field_assoc(database_result, "PASS", field, sizeof(field));
? ? ? ? ? ? ? ? ? bcrypt_verify(playerid, "OnPlayerLogin", inputtext, field);
? ? ? ? ? ? }
? ? ? ? ? ? return 1;
? ? ? ? }
? ? ? ? else
? ? ? ? {
? ? ? ? ? ? Kick(playerid);
? ? ? ? }
? ? }
? ? return 1;
}
|
|
|
|
SCM() |
|
Posted by: Awide - 2021-06-27, 09:46 AM - Forum: Programming
- Replies (4)
|
 |
jokes on you all haters i use SCM to split long messages?
*grabs popcorn*
|
|
|
|
| How to tell user if they are registered or not? |
|
Posted by: CrypticSin - 2021-06-26, 11:14 AM - Forum: Pawn Scripting
- Replies (1)
|
|
I've got a login and registration system which works using SQLlite.
Im trying to let the server tell the player whether they are registered or not?
So if they are already registered the server should say?"Welcome back 'player' You are already registered on the server please log in to continue." By returning the playername.
But if they are not registered it should prompt the user with "The 'username' is not registered on this server."
PHP Code: public OnPlayerConnect(playerid)
{
SetPlayerCamera(playerid);
? ? SetPlayerScore(playerid, 0);
? ?
? ? PlayerInfo[playerid][pKills] = 0;
PlayerInfo[playerid][pDeaths] = 0;
PlayerInfo[playerid][pLoggedIn] = false;
new query[128];
format(query, sizeof(query), "SELECT `NAME` FROM `USERS` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(ReturnName(playerid)));
? database_result = db_query(server_database, query);
? if(db_num_rows(database_result))
{
// Registered accounts see this login
ShowPlayerDialog(playerid, LOGIN_DIALOG, DIALOG_STYLE_PASSWORD, "{FFFFFF}TWDZS: Account Login", "{FFFFFF}Please enter your password below to login to your account:", "Enter", "Leave");
}
else
{
ShowPlayerDialog(playerid, REGISTER_DIALOG, DIALOG_STYLE_PASSWORD, "{FFFFFF}TWDZS: Register Account", "Please enter a strong password to register your account", "Register", "Cancel");
}
return 1;
}
|
|
|
|
|
![[Image: pic.png]](https://i.postimg.cc/Ssvn9KQh/pic.png)