open.mp forum   ›   Portal

Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  

Search Forums



(Advanced Search)

Forum Statistics
» Members: 7,700
» Latest member: TheDoctor
» Forum threads: 2,356
» Forum posts: 12,303

Full Statistics

Online Users
There are currently 226 online users.
» 0 Member(s) | 224 Guest(s)
Bing, Google

Latest Threads
Client issue with object
Forum: Support
Last Post: TheDoctor
Yesterday, 08:00 PM
» Replies: 0
» Views: 29
San Andreas Police Pursui...
Forum: Advertisements
Last Post: BriBri
Yesterday, 12:06 AM
» Replies: 0
» Views: 33
[Include] OpenGate (Abrir...
Forum: Portuguese/Portugu?s
Last Post: Crazy_ArKzX
2025-11-13, 06:49 PM
» Replies: 0
» Views: 31
OpenGate (Open Proximity ...
Forum: Libraries
Last Post: Crazy_ArKzX
2025-11-13, 06:46 PM
» Replies: 0
» Views: 34
LS City Hall
Forum: Maps
Last Post: cosminupgaming
2025-11-12, 04:22 PM
» Replies: 3
» Views: 2,655
Crime Base
Forum: Maps
Last Post: cosminupgaming
2025-11-12, 04:19 PM
» Replies: 2
» Views: 1,252
GTA SA-MP Scripting: Issu...
Forum: General Discussions
Last Post: williamrhein
2025-11-12, 10:16 AM
» Replies: 0
» Views: 48
is it worth creating a se...
Forum: General Discussions
Last Post: cosminupgaming
2025-11-11, 05:30 PM
» Replies: 13
» Views: 18,327
Looking for an English De...
Forum: General Discussions
Last Post: cosminupgaming
2025-11-11, 05:21 PM
» Replies: 2
» Views: 2,807
Awakeninga an old server.
Forum: Support
Last Post: drwnrbbt
2025-11-11, 02:26 PM
» Replies: 0
» Views: 53

 
  sqlite and inputtext
Posted by: robertocaribbean - 2021-03-21, 05:42 PM - Forum: Pawn Scripting - Replies (6)

I am trying to create an SQLite database, I only have three variables to keep it simple.



The problem is that the password is not saved unless I pass <inputtext> directly to the query.



Variables:



Code:
enum USER_DATA {

? ? USER_ID,

? ? USER_NICKNAME[MAX_PLAYER_NAME],

? ? USER_PASSWORD[20]

};



new gUserData[MAX_PLAYERS][USER_DATA];





Code working:





Code:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) {

? ? switch (dialogid) {

? ? ? ? case DIALOG_REGISTRATION: {

? ? ? ? ? ? if (!response) return Kick(playerid);



? ? ? ? ? ? if (!(3 <= strlen(inputtext) <= 20)) {

? ? ? ? ? ? ? ? SendClientMessage(playerid, -1, "Tu contrase?a debe tener entre 3 y 20 car?cteres");

? ? ? ? ? ? ? ? ShowPlayerDialog(playerid, DIALOG_REGISTRATION, DIALOG_STYLE_PASSWORD, "Register", "Type in a password below to register an account.", "Register", "Leave" );

? ? ? ? ? ? ? ? return 1;

? ? ? ? ? ? }



? ? ? ? ? ? new query[208], DBResult: result;

? ? ? ? ? ?

? ? ? ? ? ? format(query, sizeof query, "INSERT INTO users (nickname, password) VALUES ('%q', '%s')", gUserData[playerid][USER_NICKNAME], inputtext);



? ? ? ? ? ? db_query(db_handle, query);



? ? ? ? ? ? SendClientMessage(playerid, 0x00FF00FF, "[SERVER]: You have just registered to our server! You have been automatically logged in!");



? ? ? ? ? ? result = db_query(db_handle, "SELECT last_insert_rowid()");

? ? ? ? ? ? gUserData[playerid][USER_ID] = db_get_field_int(result);



? ? ? ? ? ? db_free_result(result);

? ? ? ? }

? ? }

? ? return 1;

}



Code isn't working:



Code:
gUserData[playerid][USER_PASSWORD] = inputtext[strlen(inputtext)];? ? ? ? ? ?



? ? ? ? ? ? format(query, sizeof query, "INSERT INTO users (nickname, password) VALUES ('%q', '%s')", gUserData[playerid][USER_NICKNAME], gUserData[playerid][USER_PASSWORD]);



The password field on the database is empty, and other values are ok. No error has given from the compiler.


  How to save the position of a car?
Posted by: Boxi - 2021-03-21, 11:45 AM - Forum: Pawn Scripting - Replies (1)

Hello everyone :'D?



Would anyone know how to make a system to save the position of a car? where the player leaves his car somewhere and when he connects again the car is there, basically how is the saving of the player's position. Obviously I'm not asking for any of you to write that code, just an idea of where I should start if I wanted to do it. Greetings to all.


  Possibility to move dialogs
Posted by: matei_ - 2021-03-19, 10:29 PM - Forum: Questions and Suggestions - Replies (1)

I know that there is a problem with the client, mentioned in this topic too, where you can't move the dialog across the screen.



So, my suggestion is (as the title said) to be able to move the dialog across the screen.


  mysql_query suggest
Posted by: Zow - 2021-03-19, 09:49 PM - Forum: Pawn Scripting - Replies (4)

How can I?improve this code?



PHP Code:
Account_PromptLogin(playerid) {

? ? new

? ? ? ? query[81],

? ? ? ? playerHash[62],

? ? ? ? playerDate[11],

? ? ? ? playerTime[9],

? ? ? ? playerIP[16],

? ? ? ? rows;



? ? mysql_format(MySQL_GetHandle(), query, sizeof query, 

? ? "\

? ? ? ? SELECT * FROM `players` WHERE `username` = '%e' LIMIT 1\

? ? ", 

? ? ? ? Player_GetName(playerid)

? ? );

? ? mysql_query(MySQL_GetHandle(), query);



? ? cache_get_row_count(rows);



? ? if (!rows) {

? ? ? ? Player_Kick(playerid);

? ? ? ? return 0;

? ? }



? ? cache_get_value_name(0, "password", playerHash, sizeof(playerHash));

? ? cache_get_value_name(0, "date_reg", playerDate, sizeof(playerDate));

? ? cache_get_value_name(0, "time_reg", playerTime, sizeof(playerTime));

? ? cache_get_value_name(0, "ip", playerIP, sizeof(playerIP));



? ? Player_SetAccountHash(playerid, playerHash);

? ? Player_SetAccountDate(playerid, playerDate);

? ? Player_SetAccountTime(playerid, playerTime);

? ? Player_SetAccountIP(playerid, playerIP);



? ? Dialog_ShowCallback(playerid,

? ? ? ? using public Account_Login<iiiis>, 

? ? ? ? DIALOG_STYLE_PASSWORD, 

? ? ? ? SERVER_NAME, 

? ? ? ? "Welcome", 

? ? ? ? "Login",

? ? ? ? "Exit"

? ? );

? ? return 1;

}



forward Account_Login(playerid, dialogid, response, listitem, string:inputtext[]);

public Account_Login(playerid, dialogid, response, listitem, string:inputtext[]) {

? ? if (response) {

? ? ? ? bcrypt_verify(playerid, "OnPasswordVerify", inputtext, Player_GetAccountHash(playerid));

? ? }

? ? else {

? ? ? ? Kick(playerid);

? ? }

? ? return 1;

} 



PHP Code:
forward OnPasswordVerify(playerid, bool:success);

public OnPasswordVerify(playerid, bool:success) {

? ? if (success)

? ? {

? ? ? ? CallLocalFunction("OnPlayerLogin", "d", playerid);

? ? }

? ? else

? ? {

? ? ? ? Account_PromptLogin(playerid);

? ? }

} 

  Duplicate CallBack call
Posted by: RhaegarX - 2021-03-19, 04:45 PM - Forum: Support - Replies (9)

In my gamemode I use mysql as a data saving system. Most of the player data I will save the moment it is changed to avoid problems in case of server crash or crash, and I also save the player data when restarting the server (/ gmx).

PHP Code:
public OnPlayerDisconnect()
{
Player_DestroyAllVehicles(playerid);
Player_SaveRanking(playerid);
Player_SaveConfig(playerid);
Player_SaveMoney(playerid);
? ? Player_SaveData(playerid);
? ? Player_ClearVars(playerid);
Player_ClearAcessories(playerid);
Player_ClearInfo(playerid);
Inventory_Reset(playerid);
} 

PHP Code:
public OnGameModeExit()
{
    foreach(new i : Player)
    {
        Player_DestroyAllVehicles(i);
        Player_SaveRanking(i);
        Player_SaveConfig(i);
        Player_SaveMoney(i);
        Player_SaveData(i);
        Player_ClearVars(i);
        Player_ClearAcessories(i);
        Player_ClearInfo(i);
        Inventory_Reset(i);
    }
    DestroyAllDynamicMapIcons();
    DestroyAllDynamic3DTextLabels();
    DestroyAllDynamicPickups();
    mysql_close(ConexaoSQL);
    return 1;
} 



What I noticed is that when I restart the server, OnGameModeExit is saved and OnPlayerDisconnect is saved, doubling each player's save. For example: when I restart the server (/ gmx) the player's money is saved in OnGameModeExit and OnPlayerDisconnect, being saved 2 times without need.
How do I avoid this duplication of calls? Do I need to save player data on OnGameModeExit or just OnPlayerDisconnect?
Is OnPlayerDisconnect called by default by OnGameModeExit?


  Sound ID isn't working
Posted by: robertocaribbean - 2021-03-18, 10:47 PM - Forum: Pawn Scripting - Replies (4)

Hi there,

I want to place in my script, a death sound when a player dies. I looked in the folder "data/audioevents.txt" and found the sound I was looking for:
SOUND_PED_DEATH_CRUNCH 1189.

But unfortunately, that id doesn't play any sound. I tried with other ids and they work perfectly.

Code (I'm using weapon-config):

Code:
public OnPlayerDamageDone(playerid, Float:amount, issuerid, weapon, bodypart) {
? ? if (amount == 0.0) {
? ? ? ? PlayerPlaySound(playerid, 1189, 0.0, 0.0, 0.0);
? ? ? ? SendClientMessage(playerid, -1, "Death");
? ? }
? ? return 1;
}

  So.. i created an inventory system.
Posted by: Allxseiggen - 2021-03-18, 06:07 PM - Forum: Videos and Screenshots - Replies (1)

Wow, this is my frist post on this forum....hi to all, how are you today? :)







https://www.youtube.com/watch?v=361ZaCrC...llxseiggen - video



If you have any suggestions, please let me know with a reply.

Photo robbing a house
Posted by: AndyForelli1988 - 2021-03-18, 10:34 AM - Forum: Videos and Screenshots - Replies (2)

[Image: Screenshot-63.png]


  Unknown Gamemode
Posted by: Snow - 2021-03-18, 03:32 AM - Forum: Pawn Scripting - Replies (16)

My gamemode for some unknown reason fails to work. All plugins load, MySQL connection is successful, but number of vehicle models is 0 and the gamemode shows unknown in the client. Nativechecker fails to point out anything. However this mysterious thing might be the reason but I can't seem to fix it.

Code:
*** YSI Error: y_malloc with JIT requires "#define YSI_NO_HEAP_MALLOC"

*** YSI Warning: JIT disabled

[jit] Compilation was disabled





I tried putting?"#define YSI_NO_HEAP_MALLOC" in the script but this wont go anyway. What could be possibly wrong??


  Dual monitors with San Andreas
Posted by: GospodinX - 2021-03-17, 08:15 PM - Forum: Support - Replies (6)

Hi guys



Does anyone use dual monitors for GTA?

Is possible to use one monitor for GTA and second for other things(scripting,reading forum, facebook etc)



I have problem with it.When I switch to second monitor my GTA freeze.



Thanks