| Welcome, Guest |
You have to register before you can post on our site.
|
| Online Users |
There are currently 427 online users.
» 0 Member(s) | 424 Guest(s)
Bing, Google, Applebot
|
| Latest Threads |
Adding new vehicles and s...
Forum: Programming
Last Post: __.A.__
Yesterday, 07:47 PM
» Replies: 0
» Views: 50
|
Zona América del Sur Free...
Forum: Advertisements
Last Post: kevinberriosflores
Yesterday, 02:16 PM
» Replies: 1
» Views: 71
|
Busco copia de gamemode S...
Forum: Spanish/Espa?ol
Last Post: briancristaldo2021
2025-09-11, 11:14 AM
» Replies: 0
» Views: 60
|
[Tutorial] Registrando o ...
Forum: Portuguese/Portugu?s
Last Post: Crazy_ArKzX
2025-09-09, 08:36 PM
» Replies: 0
» Views: 204
|
San Andreas Police Pursui...
Forum: Advertisements
Last Post: BriBri
2025-09-08, 10:09 PM
» Replies: 1
» Views: 294
|
Problem with plugins load...
Forum: Support
Last Post: MrKacu13
2025-09-08, 07:15 PM
» Replies: 9
» Views: 369
|
Compilation error
Forum: Pawn Scripting
Last Post: MrKacu13
2025-09-07, 07:18 AM
» Replies: 6
» Views: 354
|
Need help, problem when i...
Forum: Programming
Last Post: nonickowned
2025-09-06, 06:21 PM
» Replies: 0
» Views: 145
|
Transfer server from SAMP...
Forum: Support
Last Post: MrKacu13
2025-09-06, 04:03 PM
» Replies: 1
» Views: 238
|
Not relevant anymore
Forum: Questions and Suggestions
Last Post: peti
2025-09-05, 02:00 PM
» Replies: 0
» Views: 194
|
|
|
| help with mysql plugin error |
|
Posted by: Lyonkrs - 2021-07-01, 08:45 AM - Forum: Pawn Scripting
- Replies (2)
|
 |
The error log
Code: cache_delete:?invalid?cache?id?'0'
This is my Pawn Code:
Code: CMD:actorlist(playerid, params[])
{
new list[1024], skin, Float:AcX, Float:AcY, Float:AcZ, id, Descriptions[48];
new query[1024];
new Cache: actorlist;
mysql_format(SQLHandle, query, sizeof(query), "SELECT * FROM `actor`");
mysql_query(SQLHandle, query);
new rows = cache_num_rows();
if(rows)
{
format(list, sizeof(list), "ID\tSkin\tDescriptions\tDistance\n");
for(new i; i < rows; )
{
cache_get_value_name_int(i, "ID", id);
cache_get_value_name_int(i, "SkinID", skin);
cache_get_value_name_float(i,"X", AcX);
cache_get_value_name_float(i,"Y", AcY);
cache_get_value_name_float(i,"Z", AcZ);
cache_get_value_name(i,"Descriptions", Descriptions);
new Float: distance = GetPlayerDistanceFromPoint(playerid, AcX, AcY, AcZ);
format(list, sizeof(list), "%s%d\t%d\t%s\t%.2f\n", list, id, skin, Descriptions, distance);
}
ShowPlayerDialog(playerid, DIALOG_ACTOR_LIST, DIALOG_STYLE_TABLIST_HEADERS, "Actor List Manager", list, "Manage", "Close");
}
else
{
SendClientMessage(playerid, COLOR_GREY, "ERROR: There's no Actor list on server");
return 1;
}
cache_delete(actorlist);
return 1;
}
The system is works perfectly but why it's giving error?
|
|
|
|
| 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)