SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 06/04/2016, 06:39 PM   #1
jlalt
High-roller
 
Join Date: Oct 2014
Posts: 1,369
Reputation: 338
Default SATDM~RP.:"V12 MySQL":.

First of all thanks for MoneyPimp to giving me the permission to release this script
SATDM~RP V12 For SA-MP 0.3x and above [ Change Log Or whatever it is ._. ]
  • Compatible with SA-MP 0.3x and above/c/d
  • Compatible with Linux
  • Countdown Teleportation System
  • Very Low CPU-Usage
  • lAdmin Administration Script
  • Yagu's RACE Script 0.4a
  • Simple House Systems Script [ MySQL ]
  • Amazing Business System by tAxI Re Created By Jlalt With same style on MySQL
  • Exactly 53 classes Scread across SA
  • tAxI XVM menu for a vehicle ovnership options
  • Gangs and gang Zone Wars all over SA
  • Incredible Role-Play Job System(Medic, Cops, Criminals)
  • Gamemode loads vehicles using tAxI's XVM system [ Vehicle Load Changed To MySQL By Jlalt ]
  • Vehicle , Business, Houses Systems now based on MySQL
  • Players Accounts Based On MySQL And Passwords Hashed with whirlpool
  • MySQL Ban System Has Been Added
  • Forgot others / not that important to list them

    Stuff Available In Server:
  • Total of 184 Business across SA
  • Total of 1843 Houses across SA
  • Total of 240+ Commands
  • Total of 1957 Vehicles across SA
  • Total of 16,650 Objects across SA

Copyright Notice:
Quote:
MoNeYPiMp™ ©2007-Dec 21, 2012
WARNING: Removing ANY of the credits entitled in the following gamemode is a crime punishable by Kim Jong Il. You are allowed to modify the gamemode, leaving ALL credits in tact, re-releasing a modified version of this gamemode without my consent, will get you nuked!
Download Link:
Solidfiles: https://www.solidfiles.com/v/82PnM3gPMmamd
Medafire: http://www.mediafire.com/download/ks...3/SATDMv12.rar

Note: This gamemode is using mysql so before downloading and using it do some researchs about mysql if you don't know what is it, so you won't face problems with running the gamemode later.

Last edited by jlalt; 11/04/2017 at 05:20 AM.
jlalt is offline   Reply With Quote
Old 06/04/2016, 06:44 PM   #2
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,555
Reputation: 308
Default Re: SATDM~RP.:"V12 MySQL":.

What have you edited/added in this version?
__________________
Join the best DISCORD EVER CLICK ME
Crystallize is offline   Reply With Quote
Old 06/04/2016, 06:47 PM   #3
jlalt
High-roller
 
Join Date: Oct 2014
Posts: 1,369
Reputation: 338
Default Re: SATDM~RP.:"V12 MySQL":.

Quote:
Originally Posted by Wizzard2H View Post
What have you edited/added in this version?
Now it's fully on MySQL, added gate system, Vehicle, House, Biz, systems now on MySQL, changed players password hash to Whirlpool, added /rename command [ re name player without selling stuff ], also /orename, added new Anti Adv [ approved to be used by StickAttack ], added some new features / commands example: pm & chat Ignore system
/ignore [id], /chatignore [id], /unignore...

also added commands to create house / biz in server
/createh
/createb

and for remove
/removeb
/removeh

and a lot more you can find in pwn file.
jlalt is offline   Reply With Quote
Old 06/04/2016, 06:52 PM   #4
Slawiii
Huge Clucker
 
Slawiii's Avatar
 
Join Date: May 2015
Location: Morocco, Missour
Posts: 286
Reputation: 16
Default Re: SATDM~RP.:"V12 MySQL":.

Nice Work Bro
__________________

[FilterScript] SVIP System (0.01%)
Slawiii is offline   Reply With Quote
Old 06/04/2016, 07:34 PM   #5
N0FeaR
High-roller
 
N0FeaR's Avatar
 
Join Date: Nov 2011
Location: Los Santos, Idlewood
Posts: 2,347
Reputation: 152
Default Re: SATDM~RP.:"V12 MySQL":.

Awesome work jlalt, i love it, rep!
__________________
Check out this sh*t

N0FeaR is offline   Reply With Quote
Old 06/04/2016, 08:38 PM   #6
AndySedeyn
High-roller
 
AndySedeyn's Avatar
 
Join Date: Feb 2014
Location: Belgium
Posts: 1,334
Reputation: 681
Default Re: SATDM~RP.:"V12 MySQL":.

Normalize the database. There's a three-part tutorial by Vince about database normalization in my signature.

And something that caught my eye while I was checking whether or not your database is normalized:
PHP Code:
  strcat(Handle,"INSERT INTO accounts (Name,vehicleo1,vehicleo2,vehicleo3,vehicleo4,vehicleo5,vehicleo6,vehicleo7,vehicleo8,vehicle1,vehicle2,vehicle3,noCash,vehicle4,vehicle5,vehicle6,vehicle7,vehicle8,Level,Score,Money,");
  
strcat(Handle,"hID,HOwned,bID,bOwned,Bank,LastOn,RDate,TimeOnServer,weed,Condoms,Skin,SkinID,Kills,Deaths,IP,X,Y,Z,Interior,World,Password,TempDemote,TempDemoteDate,TempDemotel,sboost,VIP,LastY,LastM,LastD,PMBlock,bInterior) VALUES (");
  
format(Query,sizeof Query,"'%s','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','%d','%d','0','0','0','0','0','%s','%s','%d','%d','%d',0,0,'%d','%d','%s',0,0,0,0,0,'%s',0,0,0,0,0,'%d','%d','%d',0,0)"
Use mysql_format instead. It has the %e specifier to escape strings which you should always do to avoid SQL injections!
AndySedeyn is offline   Reply With Quote
Old 06/04/2016, 09:38 PM   #7
Zorono
Huge Clucker
 
Zorono's Avatar
 
Join Date: Dec 2015
Location: Africa, Egypt, Alexandria
Posts: 363
Reputation: 30
Default Re: SATDM~RP.:"V12 MySQL":.

Great Script +Rep
Kids Will Use It
Zorono is offline   Reply With Quote
Old 07/04/2016, 02:23 AM   #8
jlalt
High-roller
 
Join Date: Oct 2014
Posts: 1,369
Reputation: 338
Default Re: SATDM~RP.:"V12 MySQL":.

Quote:
Originally Posted by AndySedeyn View Post
Normalize the database. There's a three-part tutorial by Vince about database normalization in my signature.

And something that caught my eye while I was checking whether or not your database is normalized:
PHP Code:
  strcat(Handle,"INSERT INTO accounts (Name,vehicleo1,vehicleo2,vehicleo3,vehicleo4,vehicleo5,vehicleo6,vehicleo7,vehicleo8,vehicle1,vehicle2,vehicle3,noCash,vehicle4,vehicle5,vehicle6,vehicle7,vehicle8,Level,Score,Money,");
  
strcat(Handle,"hID,HOwned,bID,bOwned,Bank,LastOn,RDate,TimeOnServer,weed,Condoms,Skin,SkinID,Kills,Deaths,IP,X,Y,Z,Interior,World,Password,TempDemote,TempDemoteDate,TempDemotel,sboost,VIP,LastY,LastM,LastD,PMBlock,bInterior) VALUES (");
  
format(Query,sizeof Query,"'%s','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','%d','%d','0','0','0','0','0','%s','%s','%d','%d','%d',0,0,'%d','%d','%s',0,0,0,0,0,'%s',0,0,0,0,0,'%d','%d','%d',0,0)"
Use mysql_format instead. It has the %e specifier to escape strings which you should always do to avoid SQL injections!
Alright thanks for info, but this string / query using hashed password which won't have the characters you gonna write, there're no injections here isn't it?
jlalt is offline   Reply With Quote
Old 07/04/2016, 07:35 AM   #9
Farzam
Little Clucker
 
Farzam's Avatar
 
Join Date: Sep 2015
Location: on Earth
Posts: 46
Reputation: 12
Default Re: SATDM~RP.:"V12 MySQL":.

Awesome job +rep , check your pms btw
Farzam is offline   Reply With Quote
Old 07/04/2016, 12:38 PM   #10
Slayer711
Little Clucker
 
Slayer711's Avatar
 
Join Date: Feb 2016
Location: Islamabad, Pakistan`
Posts: 2
Reputation: 0
Default Re: SATDM~RP.:"V12 MySQL":.

Awesome, glad to see BTTDM community scripters working great always
__________________
[center]
[i][b]I'm releasing SATDM edited version, so need suggestions.
Zombie Survival 3.7 164.132.69.71:7777 Forum.bttdm.com
Slayer711 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
[GameMode] SATDM~RP.:"V11.5 Final":."0.3b/c/d XREVOLUTIONX" -=Revolution Release!=- $$$PiMp Gamemode Scripts 2447 04/02/2018 07:20 PM
MySQL Error: Function is not registered "mysql_connect" "mysql_close" iJohann3s Scripting Help 5 26/06/2016 09:28 AM
warning to some free SATDM and "BTTDM" copy scripts blackturbo Server Support 7 25/06/2016 01:06 AM
5 Dialog errors - Input line too long, undefined symbol "t","is" and "only" Deal-or-die Scripting Help 6 01/05/2012 12:08 PM
xMovie Entertainment (3 vids): "Like a boss" "The rapist" "Jizz in my pants" xMovie Screenshots and Videos 11 27/03/2012 12:10 PM


All times are GMT. The time now is 07:34 PM.


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