SA-MP Forums Archive
[FilterScript] [MySQL] Shot recorder - Records shot with appropriate bodytype - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: [FilterScript] [MySQL] Shot recorder - Records shot with appropriate bodytype (/showthread.php?tid=631167)


[MySQL] Shot recorder - Records shot with appropriate bodytype - AjaxM - 24.03.2017

Shot Recorder
Version: v0.1
Last updated: N/A
Description

This filterscript allows to you save all the shots a player shot and saves them with the bodypart type.

Media



Features
Credits

AjaxM - The script
SA-MP Team - SA-MP
BlueG - MySQL
Yashas / Zeex - I-ZCMD
Pottus - Pointed out things to be fixed
oMa37 - Pointed out the fix for github

Bugs

Tested ; No bugs found.

Table Creation

You should manually create the table with the following code:

PHP Code:
CREATE TABLE `YOUR_PORT_HERE`.`ShotRecords`(
    `ID` INT(15) NOT NULL AUTO_INCREMENT ,
    `Name` VARCHAR(25) NOT NULL ,
    `Chest` INT(11) NOT NULL ,
    `Torso` INT(11) NOT NULL ,
    `LeftArm` INT(11) NOT NULL ,
    `RightArm` INT(11) NOT NULL ,
    `LeftLeg` INT(11) NOT NULL ,
    `RightLeg` INT(11) NOT NULL ,
    `Head` INT(11) NOT NULL ,
    `Missed` INT(15) NOT NULL ,
    PRIMARY KEY  (`ID`))
    ENGINE = InnoDB; 
Note: You should change the 'YOUR_PORT_HERE' to your database port.

Download

GITHUB

Thanks & enjoy.

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - Roozevelt - 26.03.2017

good job this is acutally pretty nice

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - Pottus - 26.03.2017

What is this bullshit?

Code:
        if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_CHEST)
	{
	    pInfo[issuerid][Chest] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_TORSO)
	{
	    pInfo[issuerid][Torso] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_LEFT_ARM)
	{
	    pInfo[issuerid][LeftArm] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_RIGHT_ARM)
	{
	    pInfo[issuerid][RightArm] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_LEFT_LEG)
	{
	    pInfo[issuerid][LeftLeg] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_RIGHT_LEG)
	{
	    pInfo[issuerid][RightLeg] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_HEAD)
	{
	    pInfo[issuerid][Head] += 1;
	}
Do it like this.

Code:
	if(issuerid != INVALID_PLAYER_ID)
	{
	    switch(bodypart)
	    {
	        case WEAPON_BODY_PART_CHEST: pInfo[issuerid][Chest] += 1;
	        case WEAPON_BODY_PART_TORSO: pInfo[issuerid][Torso] += 1;
	        case WEAPON_BODY_PART_LEFT_ARM: pInfo[issuerid][LeftArm] += 1;
	        case WEAPON_BODY_PART_RIGHT_ARM: pInfo[issuerid][RightArm] += 1;
	        case WEAPON_BODY_PART_LEFT_LEG: pInfo[issuerid][RightLeg] += 1;
	        case WEAPON_BODY_PART_RIGHT_LEG: pInfo[issuerid][LeftLeg] += 1;
	        case WEAPON_BODY_PART_HEAD: pInfo[issuerid][Head] += 1;
	    }
	}


Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - JustMe.77 - 26.03.2017

Interesting release
Why the code looks so messed up at GitHub? I had the same problem 2 days ago, there must be a fix for it

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - oMa37 - 26.03.2017

Quote:
Originally Posted by JustMe.77
View Post
Why the code looks so messed up at GitHub? I had the same problem 2 days ago, there must be a fix for it
Don't upload the .pwn file directly from your PC to the GitHub repository, Follow these steps;

Open your repository -> Click 'Create new file' -> Name your file and at the end of the name put .pwn -> Copy your script and paste it in the new file you made.

or simply, if you use Sublime Text 3, Open 'View' -> 'Line Endings' -> 'Unix' then save it and upload it to the repository.

Though, I believe there are other simpler ways.


OT: Simple, But there are few things you should note on, such as the string defines in the command and Pottus post.

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - JustMe.77 - 26.03.2017

Quote:
Originally Posted by oMa37
View Post
Don't upload the .pwn file directly from your PC to the GitHub repository, Follow these steps;

or simply, if you use Sublime Text 3, Open 'View' -> 'Line Endings' -> 'Unix' then save it and upload it to the repository.
First step wasn't helping, but the last one does, thanks !

And yea, improve those little things Pottus have mentioned.

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - oMa37 - 26.03.2017

Quote:
Originally Posted by JustMe.77
View Post
First step wasn't helping, but the last one does, thanks !
You must have done a wrong step, It usually work fine with me the first step.
Anyway, Glad it worked.

Re: [MySQL] Shot recorder - Records shot with appropriate bodytype - AjaxM - 27.03.2017

Quote:
Originally Posted by ItzzWesty
View Post
good job this is acutally pretty nice
Thanks!

Quote:
Originally Posted by Pottus
View Post
What is this bullshit?

Code:
        if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_CHEST)
	{
	    pInfo[issuerid][Chest] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_TORSO)
	{
	    pInfo[issuerid][Torso] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_LEFT_ARM)
	{
	    pInfo[issuerid][LeftArm] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_RIGHT_ARM)
	{
	    pInfo[issuerid][RightArm] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_LEFT_LEG)
	{
	    pInfo[issuerid][LeftLeg] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_RIGHT_LEG)
	{
	    pInfo[issuerid][RightLeg] += 1;
	}
	if(issuerid != INVALID_PLAYER_ID && bodypart == WEAPON_BODY_PART_HEAD)
	{
	    pInfo[issuerid][Head] += 1;
	}
Do it like this.

Code:
	if(issuerid != INVALID_PLAYER_ID)
	{
	    switch(bodypart)
	    {
	        case WEAPON_BODY_PART_CHEST: pInfo[issuerid][Chest] += 1;
	        case WEAPON_BODY_PART_TORSO: pInfo[issuerid][Torso] += 1;
	        case WEAPON_BODY_PART_LEFT_ARM: pInfo[issuerid][LeftArm] += 1;
	        case WEAPON_BODY_PART_RIGHT_ARM: pInfo[issuerid][RightArm] += 1;
	        case WEAPON_BODY_PART_LEFT_LEG: pInfo[issuerid][RightLeg] += 1;
	        case WEAPON_BODY_PART_RIGHT_LEG: pInfo[issuerid][LeftLeg] += 1;
	        case WEAPON_BODY_PART_HEAD: pInfo[issuerid][Head] += 1;
	    }
	}
Improved, thanks. (Added to credits)

Quote:
Originally Posted by oMa37
View Post
Don't upload the .pwn file directly from your PC to the GitHub repository, Follow these steps;

Open your repository -> Click 'Create new file' -> Name your file and at the end of the name put .pwn -> Copy your script and paste it in the new file you made.

or simply, if you use Sublime Text 3, Open 'View' -> 'Line Endings' -> 'Unix' then save it and upload it to the repository.

Though, I believe there are other simpler ways.


OT: Simple, But there are few things you should note on, such as the string defines in the command and Pottus post.
Thanks, this is fixed. (Added to credits)