| Welcome, Guest |
You have to register before you can post on our site.
|
| Forum Statistics |
» Members: 8,021
» Latest member: todrud
» Forum threads: 2,456
» Forum posts: 12,374
Full Statistics
|
| Online Users |
There are currently 136 online users.
» 0 Member(s) | 133 Guest(s)
Bing, Applebot, Google
|
|
|
| system for storing player data |
|
Posted by: Nightmare - 2021-04-11, 05:44 PM - Forum: Support
- Replies (1)
|
 |
i'm looking one system for stroring player data and i found the SQLite and MySQL. The both system are different each other? Or they are the same thing? What system is the for the Data Base? Thx
|
|
|
|
| Help with sqlite floats |
|
Posted by: Turk54721 - 2021-04-11, 12:12 PM - Forum: Pawn Scripting
- Replies (13)
|
|
Hello for some reason floats are being loaded normaly (Armour and health is 1 and cordinates are like 5169131981403219871320)
Code: enum PlayerStats{
Mode,// 0-not logged 1-logged
Team,
Skin,
Money,
Score,
Float:Health,
Float:Armour,
Float:X,
Float:Y,
Float:Z};
new Player[MAX_PLAYERS][PlayerStats];
Code: GetPlayerPos(playerid, Player[playerid][X], Player[playerid][Y], Player[playerid][Z]);
format(Query,sizeof(Query),"UPDATE `USERS` SET TEAM = '%d', SKIN = '%d', MONEY = '%d', SCORE = '%d', HEALTH = '%f', ARMOUR = '%f', X = '%f', Y = '%f', Z = '%f' WHERE `NAME` = '%s' COLLATE NOCASE",
Player[playerid][Team],
Player[playerid][Skin],
GetPlayerMoney(playerid),//
GetPlayerScore(playerid),//
GetPlayerHealth(playerid, Player[playerid][Health]),//
GetPlayerArmour(playerid, Player[playerid][Armour]),//
Player[playerid][X],//
Player[playerid][Y],//
Player[playerid][Z],//
DB_Escape(name));
db_query(Database, Query);
Code: format(Query, sizeof(Query), "SELECT * FROM `USERS` WHERE `NAME` = '%s' COLLATE NOCASE AND `PASSWORD` = '%s'", DB_Escape(name), DB_Escape(inputtext));
Result = db_query(Database, Query);
if(db_num_rows(Result)){
new Field[ 20 ]; //Creating a field to retrieve the data
db_get_field_assoc(Result, "TEAM", Field, 30);
Player[playerid][Team] = strval(Field);
db_get_field_assoc(Result, "SKIN", Field, 30);
Player[playerid][Skin] = strval(Field);
db_get_field_assoc(Result, "MONEY", Field, 30);
Player[playerid][Money] = strval(Field);
db_get_field_assoc(Result, "SCORE", Field, 30);
Player[playerid][Score] = strval(Field);
db_get_field_assoc_float(Result, "HEALTH");
Player[playerid][Health] = floatstr(Field);
db_get_field_assoc_float(Result, "ARMOUR");
Player[playerid][Armour] = floatstr(Field);
db_get_field_assoc_float(Result, "X");
Player[playerid][X] = floatstr(Field);
db_get_field_assoc_float(Result, "Y");
Player[playerid][Y] = floatstr(Field);
db_get_field_assoc_float(Result, "Z");
Player[playerid][Z] = floatstr(Field);
Code: format(Query, sizeof(Query), "INSERT INTO `USERS` (`NAME`, `PASSWORD`, `IP`, `TEAM`, `SKIN`, `MONEY`, `SCORE`, `HEALTH`, `ARMOUR`, `X`, `Y`, `Z`) VALUES('%s','%s','%s', '0', '0', '0', '0', '%f', '%f', '%f', '%f', '%f')", DB_Escape(name), DB_Escape(inputtext), DB_Escape(ip));
Let me know if you need more code to understand, thank you
|
|
|
|
[HELP] Changing the skin when OnPlayerConnect |
|
Posted by: romanstti - 2021-04-10, 02:31 PM - Forum: Pawn Scripting
- Replies (3)
|
 |
Hello there!
First of all, good morning, it is 11:11 here already.
I would like to clarify that I am ALL NEW on this Pawn scripting thing... I spent the whole night reading documents of variables and strings...
I still can not figure out what am I doing wrong!
Maybe someone here can help?
So, I will explain you what I am trying to do, because it is probably one of the most easiest things in Pawn scripting and if you take the time to *explain* me what I am doing wrong and how to apply it as it should, then I will be one of the happiest person alive!
I am trying to change the skin automatically only if the name of the player connected is equal to: "Luna_Beaule"
I have some custom skins added to the server, and I am trying to figure out how to change them if the X (GetPlayerName I GUESS!?!?!?) is the same as: Luna_Beaule.
I'll leave below the code I wrote *so wrong, please do not laugh, thank you*:
Code: public OnPlayerConnect(playerid)
{
SendClientMessage (playerid, -1, "Servidor oficial de pruebas.");
return 1;
}
if (GetPlayerName(playerid, name) == Luna_Beaule) return SetPlayerSkin(playerid, 20003);
return 1;
}
|
|
|
|
| Textdraw Actions |
|
Posted by: ForT - 2021-04-10, 06:28 AM - Forum: Libraries
- Replies (4)
|
 |
Textdraw Actions
A simple include that shows a small action box in the center of the screen with options Y and N for the player to choose.
Download
https://github.com/dimmyi/td-actions
Preview:
Image: https://i.imgur.com/90W43SI.png
![[Image: 8VQLmcn.gif]](https://i.imgur.com/8VQLmcn.gif)
Usage:
PHP Code: #include <td-actions>
CMD:infernus(playerid)
{
? ? ShowActionForPlayer(playerid, ActionInfernus, "Do you really want to spawn a infernus in this position?", .action_time = 10000);
? ? return 1;
}
Action:ActionInfernus(playerid, response)
{
? ? if (response == ACTION_RESPONSE_YES)
? ? {
? ? ? ? new Float:x, Float:y, Float:z, Float:ang;
? ? ? ? GetPlayerPos(playerid, x, y, z);
? ? ? ? GetPlayerFacingAngle(playerid, ang);
? ? ? ? new vehicleid = CreateVehicle(411,
? ? ? ? ? ? x 2.5 * floatsin(-ang, degrees),
? ? ? ? ? ? y 2.5 * floatcos(-ang, degrees),
? ? ? ? ? ? z 0.3,
? ? ? ? ? ? ang,
? ? ? ? ? ? 0,
? ? ? ? ? ? 0,
? ? ? ? ? ? -1);
? ? ? ? LinkVehicleToInterior(vehicleid, GetPlayerInterior(playerid));
? ? ? ? SetVehicleVirtualWorld(vehicleid, GetPlayerVirtualWorld(playerid));
? ? } else {
? ? ? ? SendClientMessage(playerid, -1, "You didn't want to spawn a infernus.");
? ? }
}
Responses:
- ACTION_RESPONSE_NO_CHOOSE - When the player does not choose an option
- ACTION_RESPONSE_NO -?When the player presses the N key
- ACTION_RESPONSE_YES -?When the player presses the Y?key
|
|
|
|
| SHA256 SALT in PHP? |
|
Posted by: CoPete? - 2021-04-08, 08:59 PM - Forum: Programming
- Replies (1)
|
 |
Hi!?please I would like you to help me authenticate the users on the web page, the problem I have is that I use in the gamemode the password settlement system sha256 a salt that I got in forum samp (maybe they know which)?and I don't know how I could do an autiticator?in php, thanks
![[Image: TtrFlqW.png]](http://imgfz.com/i/TtrFlqW.png)
|
|
|
|
| Help |
|
Posted by: Nightmare - 2021-04-08, 04:45 PM - Forum: Pawn Scripting
- Replies (2)
|
|
hello i'm new in pawn scripting, i'm compiling a filterscript, and appears this error: "undefined symbol 'AddSimpleModel'". I searched how solve it but i don't found solutions. Can someone help?
img link:
https://prnt.sc/117hc5z
|
|
|
|
|
