Introduction

Hi, I'll keep it short and simple.?

This emulates prepared statement when using the MySQL plugin.

Thank you for reading this really long introduction.



Download: Click me

Important: sampctl required! check github repository for installation instructions.



Reading Data (using inline)

Hello to everyone on this forum.



I've stumbled across this marvelous page project, and first of all, I would like to thank Y_Less, Southclaws and many other people that I don't know, that came trough with this project. I am huge fan of their work for more then a decade, since I touched PAWN first time.



I will share you little bit of my details so you can tell me who to contact/how to contribute. I've been scripting actively in PAWN since 2008/2009(currently I am 24 years old), stopped 2013(college), continued 2018 untill present. When I returned last year, I fixed at least 10 000 bugs?on my gamemode(from the smallest to biggest, regarding MySQL, timers, server crashes, and hardcore cheaters who managed to turn off outgoing packages). We even managed to defend ourselves from DDoSers and flooders, but, none of that would be possible without forums and knowledge that many of you shared on SAMP forums. So I'll use this chance to thank all of you that contributed with your knowledge which helped me become even better at scripting. We've been using YSI for almost a decade, literally marvelous library, and I would dare to say subculture of PAWN langauge that countinues to be awesome.



So with everything said, since this is my first day here and that I heard about this whole project, how can I contribute? 10 mins ago, I told Y_Less, and I'm gonna say it again, I plan to contribute as much of my free time as possbile on this project, so show me the way.



Also, another "side question". Does open.mp plan to have custom objects/vehicles/animations/skins?



Thank you for spending time reading my post, hope I didn't bother you. Cheers! :D

I have a problem using y_hooks:

I have the main gamemode (main.pwn), and two "modules" that are included in it: "module1.inc" and "module2.inc".



In both of them, I have to use y_hooks. From what I knew, you had to reinclude y_hooks if you wanted to hook to the same function, so at top of each module, I have

• Pool. It's the perfect example of 2D Physics, with balls that can collide between themselves or?with walls.?Press LMB to hold the ball.Press RMB to shot/pass the ball. Press ALT to lob the ball. Press F to make a cross/high shot.?Hit the ball (press RMB/ALT/F) when it is at head height to make a header. Power bar when you are holding RMB/ALT/F.
  
  [Video: https://www.youtube.com/watch?v=yOtlNQvgJ6Q]
  
  
• Soccer. Here physics are 3D (z-axis is used). This script also uses the "collision cylinder" feature, for the goal post.
  
  [Video: https://www.youtube.com/watch?v=ISTebVTMYog]
  
  
• Throw an object. A more simple example of of 3D physics, with a command to just throw a Deagle in the air.
  
  
  Code:

  command(launch, playerid, params[])

{

#define SPEED (10.0)

#define Z_SPEED (4.0)

#define GRAVITY (13.0)

? ? ? ? new modelid = 348; // Deagle Model ID

new Float:x, Float:y, Float:z, Float:ang;

GetPlayerPos(playerid, x, y, z);

GetPlayerFacingAngle(playerid, ang);

new obj = CreateObject(modelid, x, y - 0.5 * floatcos(-(ang  90.0), degrees), z, 93.7, 120.0, ang  60.0);

? PHY_InitObject(obj);

PHY_SetObjectVelocity(obj, SPEED * floatsin(-ang, degrees), SPEED * floatcos(-ang, degrees), Z_SPEED);

PHY_SetObjectFriction(obj, 100); // This will stop the object when it touchs the ground.

PHY_SetObjectGravity(obj, GRAVITY);

PHY_SetObjectZBound(obj, z - 1.0, _, 0.0);

ApplyAnimation(playerid,"GRENADE","WEAPON_throwu",3.0,0,0,0,0,0);

return 1;

}
  
  
• ColAndreas testing.
  
  [Video: https://www.youtube.com/watch?v=QKHDK_vogYE]
  
  

1. Update physics.inc with the latest library dependencies versions (but still keeping compatibility with the older ones).
   
   The code is very old, so I used old version of the libraries modelsizes, foreach and ColAndreas. For example, I think no one uses foreach now, but use instead?Y_Iterate. Also, I don't know if the current ColAndreas version works well with the include, because at the time I used one of the first versions.
   
   
2. Implement a more advanced object rolling.?DONE
   
   With the way the actual code works, the rolling of a ball is not so realistic, because, when an object changes its direction of movement,?the RZ angle is instantly changed to match that direction.A more realistic way to roll objects should use operations on quaternions, instead of Euler angles. In the past, I try to use that, but it didn't work. In 2016, a chinese guy on SA-MP forum managed to fix that and here's the code: https://mega.nz/#!38QlGaLb!uinmaqDDaTjha...WkP3ubLLYI (version of physics.inc that rolls objects using quaternions). It would be nice if you implement part of his code, in order to have two options of rolling objects, with a function like PHY_SetObjectRollingMode: ROLLING_MODE_DEFAULT for the more simple one I wrote and ROLLING_MODE_ADVANCED?for the quaternions one. In order to do that, you modify the?PHY_ApplyRotation function.This is how the ROLLING_MODE_DEFAULT should look: https://www.youtube.com/watch?v=Kbkm4fXaB7Q. This is how the ROLLING_MODE_ADVANCED should look: https://www.youtube.com/watch?v=xl5Vbd2tfwM. As you can see, the problem of the first one is the sudden change of rotation when two balls collide and thus change their direction of movement.
   
   

Enjoy!

Video Presentation
https://www.youtube.com/watch?v=c_uaGU2qHiE

??? ????????? ??????, ?? ???? ?????, ???????? ? ?????? ? ?????? ? ??. ??????????? ?????? ? ???????Pawn Scripting, ?? ???????? ????????????, ???????, ?????????? ??????? ??? ????, ?? ??? ?? ? ?????? ???????? ??? ????? ?????? ???????? ?????????, ?????? ??? ?? ????? ??????? ??? ?????????? ? ??.?

Ban system by Serial same as MTA (or similiar)



When i had a SAMP server Dayz, i was tired of many times had problems with cheaters and toxic players that comeback to the server everytime.

You ban a player or a toxic player, and a few minutes later, the same player comeback with a different nickname just to annoying and disturb. When i had my server on MTA (2012/2013) i never had that problem. Once the player was banned, he couldn't come back again, even reseting the IP or formatting the PC.

He has really banned from the server.



I hope that you have a system like that, its something that is missing on the other plataform, but could really help people with a server. (Including Dayz, where the number of cheaters is a lot)

IDK if this is the right board for this but sorry in advance



So I was hosting my Att/Def GM in Ultra-H and it's working well. When I transfer all my files to OGP the server crash always. I tried using the default grandlarc and it showed this