-
Posts
541 -
Joined
-
Last visited
-
Days Won
21
Content Type
Profiles
Forums
News
Documentation
Everything posted by hanako
-
nu o sa-i mai apara [ House] [ Business], e destul de simplu
-
dupa cum am mentionat, am spus sa stearga linia din server.cfg, nu folderul.
-
daca nu cunosti limbajul asta, sau nu ai niciun devotament fata de el, te-as ruga sa nu mai apari niciodata pe acest forum
-
sterge linia filterscripts din server.cfg
-
da ne o poza cu ce ai tu in server.cfg
-
pai ce ar trebui sa-ti apara? vezi daca in baza de date ai ceva la default acolo
-
Salut, probabil s-a lasat de jocul asta, si de pawn si de tot ce tine SA:MP.
-
arata-ne si codul
-
De ce primesc erori cand este totul corect?
hanako replied to thestafy's question in Ajutor Scripting
format(gString, sizeof(gString), "Parola ta contine %d caractere.", strlen(inputtext)); -
public OnPlayerEditDynamicObject(playerid, playerobject, objectid, response, Float:x, Float:y, Float:z, Float:rx, Float:ry, Float:rz) {
-
add pe discord hanako#0237
-
#include <a_samp> #include <a_mysql> new SQL = -1, gQuery[256], gString[256]; #define function%0(%1) forward %0(%1); public %0(%1) #define SCM SendClientMessage #define COLOR_DARKRED 0XD80003FF new incercariParola[MAX_PLAYERS]; enum pInfo { pSQLID, pName[MAX_PLAYER_NAME], pPassword[32], pEmail[32], pGender } new PlayerInfo[MAX_PLAYERS][pInfo]; enum { //REGISTER DIALOG_REGISTER, DIALOG_EMAIL, DIALOG_GENDER, //LOGIN DIALOG_LOGIN }; main() { print("Se initiaza gamemodeul..."); } public OnGameModeInit() { SQL = mysql_connect("localhos" , "root" , "sv" , ""); // Don't use these lines if it's a filterscript SetGameModeText("Blank Script"); AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0); 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){ incercariParola[playerid] = 0; gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM 'users' WHERE 'Name' = '%s' LIMIT 1" GetName(playerid)); mysql_tquery(SQL, gQuery, "checkAccount" , "i" , playerid); return 1; } public OnDialgResponse(playerid, dialogid, response, listitem, inputtext[]) { switch(dialogid) { case DIALOG_REGISTER: { if(!response) return Kick(playerid); if(strlen(inputtext) <4 || strlen(inputtext) > 32) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Scrie o parola pentru a iti crea contul:", "Select", "Cancel"); gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(qQuery), "INSERT INTO 'users' ('Name' , 'Password') VALUES ('%s' , '%s')" , GetName(playerid), inputtext); mysql_tquery(SQL, gQuery, "insertAccount", "i" , playerid ); gString[0] = EOS; format(gString, sizeof(gString), "Parola ta contine %d caractere." strlen(inputtext)); SCM(playerid, -1 , gString); format(PlayerInfo[playerid][pPassword], 32 , inputtext); ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "EMAIL", "Te rugam sa-ti setezi adresa de email:", "Select", "Cancel"); } case DIALOG_EMAIL: { if(!response) return Kick(playerid); if(strlen(inputtext) <4 || strlen(inputtext) > 32) return ShowPlayerDialog(playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "EMAIL", "Te rugam sa-ti setezi adresa de email:", "Select", "Cancel"); gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(qQuery), "UPDATE 'Users' SET 'Email = '%s' WHERE 'ID' = '%d'" , inputtext, PlayerInfo[playerid][pSQLID]); mysql_tquery(SQL, gQuery, "", "" ); gString[0] = EOS; format(gString, sizeof(gString), "Email setat %s" strlen(inputtext)); SCM(playerid, -1 , gString); format(PlayerInfo[playerid][pEmail], 32 , inputtext); ShowPlayerDialog(playerid, DIALOG_GENDER, DIALOG_STYLE_MSGBOX, "GENDER", "Seteaza-ti sexul:", "Masculin", "Feminin"); } case DIALOG_GENDER: { switch(response) { case 0: { PlayerInfo[playerid][pGender] = 1; SCM(playerid, -1, "Sexul ales este Feminin"); } case 1: { PlayerInfo[playerid][pGender] = 0; SCM(playerid, -1, "Sexul ales este Masculin"); } } gQuery[0] = EOS; mysql_format(SQL, gQuery, sizeof(qQuery), "UPDATE 'Users' SET 'Gender = '%d' WHERE 'ID' = '%d'" , PlayerInfo[playerid][pGender], PlayerInfo[playerid][pSQLID]); mysql_tquery(SQL, gQuery, "", "" ); SpawnPlayer(playerid); } case DIALOG_LOGIN: { if(!response) return Kick(playerid); mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM 'users' WHERE Name' = '%s' AND 'Password'='%s' LIMIT 1" GetName(playerid)inputtext); mysql_tquery(SQL, gQuery, "onlogin" , "i" , playerid); } } return 1; } function onlogin (playerid) { switch(cache_num_rows()) { case 0: { incercariParola[playerid] ++; gString[0] = EOS; format(gString, sizeof(gString),"Parola incorecta! (%d/3 incercari ramase)", incercariParola[playerid]); SCM(palyerid, COLOR_DARKRED, gString); if(incercariParola[playerid] == 3) Kick(playerid); else ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Te rugam sa introduci parola contului tau:", "Select", "Cancel"); } case 1: { new result[64]; PlayerInfo[playerid][pSQLID] = cache_get_row_content_int("0", "ID"); PlayerInfo[playerid][pGender] = cache_get_row_content_int("0", "Gender"); cache_get_field_content(0, "Name" , result); format(PLayerInfo[playerid][pName], MAX_PLAYER_NAME, result); cache_get_field_content(0, "Password" , result); format(PLayerInfo[playerid][pPassword], 32, result); cache_get_field_content(0, "Email" , result); format(PLayerInfo[playerid][pEmail], 32, result); printf("%s (user: %d) s-a conectat. [Gender: %d, Name: %s, Password: %s, Email: %s]" , GetName(playerid), PlayerInfo[playerid][pSQLID], PlayerInfo[playerid][pGender],PlayerInfo[playerid][pPassword], PlayerInfo[palyerid][pEmail]); } } return 1; } function insertAccount(playerid) { PlayerInfo[playerid][pSQLID] = cache_insert_id(); printf("%s s-a inregistrat cu SQLID-ul #%d." , GetName(playerid),PlayerInfo[playerid][pSQLID]); return 1; } function checkAccount(playerid) { switch(cache_num_rows()) { case 0; ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Register", "Scrie o parola pentru a iti crea contul:", "Select", "Cancel"); case 1;ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Te rugam sa introduci parola contului tau:", "Select", "Cancel"); } return 1; } stock GetName(playerid) { new playerName[MAX_PALYER_NAME]; GetPlayerName(playerid, playerName, MAX_PLAYER_NAME); return playerName; }
-
arata-mi te rog cum ai in baza de date ClanMemberSkin
-
mysql_format(handle, query, sizeof(query), "UPDATE `conturi` SET `Skin` = '%d' WHERE `ID` = '%d'", PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pID]);mysql_tquery(handle, query, " ", " ");
-
daca ai sters seif-uriile si nu mai vrei sa-ti inceapa de la 5 in sus, poti sa te duci la 'QUERY' si sa scrii TRUNCATE seif;
-
du-te in baza de date la query si scrie TRUNCATE numeletabelului;
-
incearca asa if(vehicle_personal[vehicleid] > -1) { new id = vehicle_personal[vehicleid]; PersonalVehiclei[id][pvInsurancePoints]--; gQuery[0] = (EOS); mysql_format(SQL, gQuery, sizeof gQuery, "UPDATE `server_personal_vehicles` SET `Insurancepoints` = '%d' WHERE `ID` = '%d'", PersonalVehicle[id][pvInsurancePoints], PersonalVehicle[id][pvID]); mysql_tquery(SQL, gQuery, "", ""); SCMf(getVehOwner(PersonalVehicle[id][pvOwnerID]), -1, "Vehiculul tau %s, a pierdut un punct de asigurare.", GetVehicleName(PersonalVehicle[id][pvModelID])); }
-
pai daca ai 0 insurance points nu iti mai scade
-
if(vehicle_personal[vehicleid] > -1 && PersonalVehicle[vehicleid][pvInsurancePoints] > 0) { new id = vehicle_personal[vehicleid]; PersonalVehicle[id][pvInsurancePoints] --; SCMF(id, -1, "DEBUG: %d", PersonalVehicle[id][pvInsurancePoints]); gQuery[0] = (EOS); mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `server_personal_vehicles` SET `InsurancePoints` = '%d' WHERE `ID` = '%d'", PersonalVehicle[id][pvInsurancePoints], PersonalVehicle[id][pvID]); mysql_tquery(SQL, gQuery, "", ""); }
-
eroarea o ai in VehicleTunning defineste-le acolo
-
sigur, imi poti da mesaj pe discord hanako#0237
-
libmysql : https://mega.nz/file/hK4ilbSS#CjCQLJnoxv4pvIT5JeNvudfvuNSfidSrPDxCdWWCsHY / virus total : https://www.virustotal.com/gui/file/e12cd0d65f329f4f800dacf1c1961a0e96c7e4acc62f374eb61583674db728cd/detection mysql_static.so : https://mega.nz/file/8bwSzToI#VxPBZrdJjkx5ve1kKaJkhoZgh5k4_n_hA125qOFyJUc / virus total : https://www.virustotal.com/gui/file/0c745d9d3127b01f7d823bf984d7e2bccf09a812407b0a416c58f09b3d50f90a/detection
-
[02:16:08] Failed (plugins/mysql_static.so: cannot open shared object file: No such file or directory)[02:16:08] Failed (libmysqlclient.so.18: cannot open shared object file: No such file or directory)
-
pai in loc de mysql_static lasa doar mysql.dll
