SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Filterscripts

Reply
 
Thread Tools Display Modes
Old 08/11/2018, 10:21 AM   #11
Calisthenics
Huge Clucker
 
Join Date: May 2018
Posts: 421
Reputation: 69
Default Re: Dynamic MySQL GPS System

I am sorry to say but I see no 'many changes'. You only fixed the unknown columns in line 216, everything else remained the same:

- no escaping input
- not deleting cache in one place
- no affected rows = success message anyway
- no index

Changing LIMIT 10 to LIMIT 100 does not change anything. You do not need LIMIT in the first place, just GROUP BY `S.No` and remove WHERE clause as well.

You also removed global option DUPLICATE_CONNECTIONS for no reason. Now any gamemode connecting to the same database and server will result in warning in mysql logs.
Calisthenics is offline   Reply With Quote
Old 08/11/2018, 11:45 AM   #12
ZigGamerx
Big Clucker
 
ZigGamerx's Avatar
 
Join Date: Jul 2018
Posts: 153
Reputation: 23
Default Re: Dynamic MySQL GPS System

Wow Epic
ZigGamerx is online now   Reply With Quote
Old 08/11/2018, 12:20 PM   #13
CaptainBoi
Huge Clucker
 
Join Date: May 2018
Location: India
Posts: 256
Reputation: 25
Default Re: Dynamic MySQL GPS System

Quote:
Originally Posted by Calisthenics View Post
I am sorry to say but I see no 'many changes'. You only fixed the unknown columns in line 216, everything else remained the same:

- no escaping input
- not deleting cache in one place
- no affected rows = success message anyway
- no index

Changing LIMIT 10 to LIMIT 100 does not change anything. You do not need LIMIT in the first place, just GROUP BY `S.No` and remove WHERE clause as well.

You also removed global option DUPLICATE_CONNECTIONS for no reason. Now any gamemode connecting to the same database and server will result in warning in mysql logs.
Hey dude, can i know the lines?
and i wanna talk about index and affected rows.
What are the problems in them?

Quote:
Originally Posted by ZigGamerx View Post
Wow Epic
Thanks
__________________
Code:
Releases
[FilterScript] Dynamic MySQL GPS System
[Tutorial] How to make TDM Team Selection.
[Include] moneybar.inc || Coloured Moneybar || Released
[Tutorial] PAWN Compiler In Notepad++
[FilterScript] Perks System (v: [On Update]) [DINI, ZCMD]
[FilterScript] Realistic Transmission Speedometer
CaptainBoi is offline   Reply With Quote
Old 08/11/2018, 02:20 PM   #14
CaptainBoi
Huge Clucker
 
Join Date: May 2018
Location: India
Posts: 256
Reputation: 25
Default Re: Dynamic MySQL GPS System

Updates
Code:
-Dialog ids are now in Enum.
-if(dialogid) changed to switch(dialogid);
-if(listitem) changed to switch(listitem);
-Minor bugs fixed and code improved.
-Script final version released.
Thanks to Sys for helping me in improving the codes.
__________________
Code:
Releases
[FilterScript] Dynamic MySQL GPS System
[Tutorial] How to make TDM Team Selection.
[Include] moneybar.inc || Coloured Moneybar || Released
[Tutorial] PAWN Compiler In Notepad++
[FilterScript] Perks System (v: [On Update]) [DINI, ZCMD]
[FilterScript] Realistic Transmission Speedometer
CaptainBoi is offline   Reply With Quote
Old 09/11/2018, 04:12 PM   #15
Venom546
Big Clucker
 
Venom546's Avatar
 
Join Date: Sep 2018
Posts: 51
Reputation: 0
Default Re: Dynamic MySQL GPS System

nice
__________________


join us now we have hosted tab
our hosted forums : http://ggw-gaming.is-great.net/
so what are u waiting for join us now
Venom546 is offline   Reply With Quote
Old 09/11/2018, 05:25 PM   #16
CaptainBoi
Huge Clucker
 
Join Date: May 2018
Location: India
Posts: 256
Reputation: 25
Default Re: Dynamic MySQL GPS System

Quote:
Originally Posted by Venom546 View Post
nice
thanks
__________________
Code:
Releases
[FilterScript] Dynamic MySQL GPS System
[Tutorial] How to make TDM Team Selection.
[Include] moneybar.inc || Coloured Moneybar || Released
[Tutorial] PAWN Compiler In Notepad++
[FilterScript] Perks System (v: [On Update]) [DINI, ZCMD]
[FilterScript] Realistic Transmission Speedometer
CaptainBoi is offline   Reply With Quote
Old 10/11/2018, 04:23 PM   #17
Wherethescripters
Little Clucker
 
Wherethescripters's Avatar
 
Join Date: Dec 2017
Location: Pakistan
Posts: 42
Reputation: 3
Default Re: Dynamic MySQL GPS System

That's nice bro, I like it +Rep
Wherethescripters is offline   Reply With Quote
Old 18/11/2018, 02:42 PM   #18
CaptainBoi
Huge Clucker
 
Join Date: May 2018
Location: India
Posts: 256
Reputation: 25
Default Re: Dynamic MySQL GPS System

Quote:
Originally Posted by Wherethescripters View Post
That's nice bro, I like it +Rep
Thanks.
__________________
Code:
Releases
[FilterScript] Dynamic MySQL GPS System
[Tutorial] How to make TDM Team Selection.
[Include] moneybar.inc || Coloured Moneybar || Released
[Tutorial] PAWN Compiler In Notepad++
[FilterScript] Perks System (v: [On Update]) [DINI, ZCMD]
[FilterScript] Realistic Transmission Speedometer
CaptainBoi is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[FilterScript] Dynamic Actors System [MySQL R41-4] KinderClans Filterscripts 5 23/10/2018 07:58 PM
[FilterScript] Group System (2). [MySQL\Dynamic Rank and permission system] verlaj Filterscripts 11 26/08/2017 08:53 PM
[FilterScript] Dynamic Bus System [MySQL-ZCMD] Skyrise Filterscripts 15 16/05/2013 05:26 AM
[Help] Mysql Dynamic System. tony_fitto Scripting Help 4 07/07/2012 04:10 AM


All times are GMT. The time now is 03:55 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.