1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Gamemode Scripts

Threaded Mode
[GameMode] Simple MySQL R39-3 v1.0
JeaSon
Gangsta
****
Posts: 562
Threads: 41
Joined: Aug 2013
Reputation: 0
#1

01.04.2015, 18:35
( Last edited by JeaSon; 08/04/2015 at 09:50 AM. Reason: Updated to v1.1 )
Introduction
hello!

i made this becoz alot of people ask about this so i decided to make a new and simple one where everyone can beign a gamemode with there ideas well this gamemode is very simple with only 3 commands /stats /setlevel /setvip and it also saves kills + deaths


this gamemode have

v1.0
auto login
/stats
/setlevel
/setvip

v1.1
/mute
/unmute
/setkils
/setmoney
/setdeaths
/setscore
/blockcommand /blockcmd
/unblockcommand /unblockcmd


i hope you guys like it

gamemode
pastebin: http://pastebin.com/RX2PwsH7

SQL data: http://pastebin.com/Fr3GAhPa


change this to yours one
pawn Code:
//Let's define our mysql settings
#define host    "localhost" //This will be your mysql host. Default for xampp is localhost
#define user    "root" //This will be your mysql username. Default for xampp is root
#define db      "sami" //This is your database name. Remember we have created a database called server before.
#define pass    "" //This is your mysql password. In xampp, the password didn't set. So leave it empty.
if you found bugs report it here i will fix it and if i get time i will try to update it

credits
newbienoob for tutorial
BlueG for mysql plugin
***** for sscanf and whirlpool
me for creating this gamemode
Find
Reply
Alex Magaсa
High-roller
*****
Posts: 2,137
Threads: 37
Joined: Oct 2012
Reputation: 0
#2

01.04.2015, 18:53
Good job mate.! keep it up!
Find
Reply
Younes44
Gangsta
*****
Posts: 763
Threads: 31
Joined: Oct 2013
Reputation: 0
#3

01.04.2015, 19:26
Good Work dude
Find
Reply
Abagail
High-roller
*****
Posts: 3,133
Threads: 71
Joined: Dec 2013
Reputation: 0
#4

01.04.2015, 20:16
MySQL r9-3? You mean R39- or an outdated version of the plugin?
Find
Reply
JeaSon
Gangsta
****
Posts: 562
Threads: 41
Joined: Aug 2013
Reputation: 0
#5

02.04.2015, 03:36
Quote:
Originally Posted by Younes44
View Post
Good Work dude
thanks

Quote:
Originally Posted by Alex Magaсa
View Post
Good job mate.! keep it up!
thanks

Quote:
Originally Posted by Abagail
View Post
MySQL r9-3? You mean R39- or an outdated version of the plugin?
i mean R9 the latest plugin
Find
Reply
SpikY_
High-roller
*****
Posts: 1,246
Threads: 140
Joined: Jul 2014
Reputation: 0
#6

02.04.2015, 14:13
Good job. Basic gamemode.
SpikY_ here :]
Find
Reply
nicolaskettler
Little Clucker
**
Posts: 38
Threads: 2
Joined: May 2011
Reputation: 0
#7

02.04.2015, 14:17
Quote:
Originally Posted by JeaSon
View Post
thanks



thanks



i mean R9 the latest plugin
Which plugin are you talking about ? The last BlueG's plugin is R39-2 i believe
Find
Reply
JeaSon
Gangsta
****
Posts: 562
Threads: 41
Joined: Aug 2013
Reputation: 0
#8

02.04.2015, 14:43
Quote:
Originally Posted by nicolaskettler
View Post
Which plugin are you talking about ? The last BlueG's plugin is R39-2 i believe
no its r39-3 check it on github

https://github.com/pBlueG/SA-MP-MySQ...ases/tag/R39-3
Find
Reply
MohanedZzZ
Huge Clucker
****
Posts: 254
Threads: 6
Joined: Nov 2013
Reputation: 0
#9

02.04.2015, 15:31
Good work JeaSon.
Find
Reply
nicolaskettler
Little Clucker
**
Posts: 38
Threads: 2
Joined: May 2011
Reputation: 0
#10

02.04.2015, 16:11
Quote:
Originally Posted by JeaSon
View Post
Yeah but you said R9-3
Find
Reply
JeaSon
Gangsta
****
Posts: 562
Threads: 41
Joined: Aug 2013
Reputation: 0
#11

03.04.2015, 04:05
( Последний раз редактировалось dugi; 25.11.2016 в 08:45. )
Quote:
Originally Posted by MohanedZzZ
Посмотреть сообщение
Good work JeaSon.
thanks bro

v1.1
Код:
Added /mute 
Added /unmute
Added /setkills
Added /setdeaths
Added /setscore
Added /setmoney
Added /blockcommand /blockcmd
Added /unblockcmd /unblockcommand
block and unblock system by Threshold
Find
Reply
LazyB0y
Huge Clucker
****
Posts: 276
Threads: 16
Joined: Feb 2014
Reputation: 0
#12

09.04.2015, 13:11
Wow nice omg cool
Find
Reply
yvoms
Huge Clucker
****
Posts: 455
Threads: 83
Joined: Nov 2009
Reputation: 0
#13

08.11.2015, 18:17
( Последний раз редактировалось yvoms; 08.11.2015 в 19:11. )
What are the versions for sscanf2 and zcmd?
I'm trying to get this to work, however it gives me a minor error,

tested with sscanf 2.8.2, doesnt work unfortunately.
mysql r39-3?

[20:30:44] Error: Function not registered: 'SSCANF_Init'
[20:30:44] Error: Function not registered: 'SSCANF_IsConnected'
[20:30:44] Error: Function not registered: 'SSCANF_Join'
[20:30:44] Error: Function not registered: 'SSCANF_Leave'
[20:30:44] Error: Function not registered: 'sscanf'
[20:30:44] Script[gamemodes/lvcnr.amx]: Run time error 19: "File or function is not found"
Find
Reply
JeaSon
Gangsta
****
Posts: 562
Threads: 41
Joined: Aug 2013
Reputation: 0
#14

09.11.2015, 05:30
yes this gamemode uses 2.8.2 sscanf and mysql r39-3
Find
Reply
yvoms
Huge Clucker
****
Posts: 455
Threads: 83
Joined: Nov 2009
Reputation: 0
#15

09.11.2015, 11:21
( Последний раз редактировалось dugi; 25.11.2016 в 08:45. )
Could you make repack?
Like rar your the gamemode with all required files in it ao its ready to go, i'd like to see what this brings.

Send me the link in a pm if u could.

Nevermind got it to work with debugging
Find
Reply
Banditul18
Huge Clucker
****
Posts: 408
Threads: 40
Joined: Nov 2014
Reputation: 0
#16

27.12.2015, 19:18
( Последний раз редактировалось Banditul18; 28.12.2015 в 18:04. )
How to resolve this error?
Код:
[20:00:28] [DEBUG] mysql_connect - host: "127.0.0.1", user: "port_2531", database: "port_2531", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[20:00:28] [DEBUG] CMySQLHandle::Create - creating new connection..
[20:00:28] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[20:00:28] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful
[20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:00:28] [DEBUG] mysql_errno - connection: 1
[20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful
[20:00:28] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful
[20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:00:28] [DEBUG] CMySQLConnection::Connect - connection was successful
[20:00:28] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[20:01:28] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[20:01:28] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = ", callback: "OnAccountCheck", format: "i"
[20:01:28] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[20:01:28] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.274 milliseconds
[20:01:28] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:01:28] [DEBUG] Calling callback "OnAccountCheck"..
[20:01:28] [DEBUG] cache_get_data - connection: 1
[20:01:28] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:01:31] [DEBUG] mysql_format - connection: 1, len: 300, format: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `VIP`,`Kills`,`Deaths`,`Score`, `Money`) VALUES ('%e', '%s', '%s',..."
[20:01:31] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `players` (`Username`, `Password`, `IP`, `Admin`, `V", callback: "OnAccountRegister", format: "i"
[20:01:31] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - starting query execution
[20:01:32] [DEBUG] CMySQLQuery::Execute[OnAccountRegister] - query was successfully executed within 39.767 milliseconds
[20:01:32] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:01:32] [DEBUG] Calling callback "OnAccountRegister"..
[20:01:32] [DEBUG] cache_insert_id - connection: 1
[20:01:32] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:02:30] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = '%e' LIMIT 1"
[20:02:30] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `IP`, `Password`, `ID` FROM `players` WHERE `Username` = ", callback: "OnAccountCheck", format: "i"
[20:02:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - starting query execution
[20:02:30] [DEBUG] CMySQLQuery::Execute[OnAccountCheck] - query was successfully executed within 0.607 milliseconds
[20:02:30] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[20:02:30] [DEBUG] Calling callback "OnAccountCheck"..
[20:02:30] [DEBUG] cache_get_data - connection: 1
[20:02:30] [DEBUG] cache_get_field_content - row: 0, field_name: "IP", connection: 1, max_len: 16
[20:02:30] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "IP", data: "109.98.164.64"
[20:02:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "VIP", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Money", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Kills", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Deaths", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:02:33] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Score", connection: 1
[20:02:33] [WARNING] cache_get_field_content_int - no active cache
[20:03:19] [DEBUG] mysql_format - connection: 1, len: 100, format: "UPDATE `players` SET `IP`='%s', `Admin`=%d, `VIP`=%d, `Kills`=%d, `Deaths`=%d, `Score`=%d, `Money`=%d WHERE `ID`=%d"
[20:03:19] [ERROR] mysql_format - destination size is too small
[20:03:19] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `IP`='109.98.164.64', `Admin`=0, `VIP`=0, `", callback: "(null)", format: "(null)"
[20:03:19] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[20:03:19] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
[20:03:19] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
On register works perfectly, but when relog.....
Find
Reply
Loinal
Gangsta
*****
Posts: 814
Threads: 190
Joined: Feb 2016
Reputation: 0
#17

22.09.2016, 19:05
It save only level not score and money and kills
Find
Reply
Slawiii
Huge Clucker
****
Posts: 293
Threads: 29
Joined: May 2015
Reputation: 0
#18

23.09.2016, 10:50
Quote:
Originally Posted by Loinal
Посмотреть сообщение
It save only level not score and money and kills
its working fine for me!
i think you aren't installed the database correctly.
Find
Reply
Loinal
Gangsta
*****
Posts: 814
Threads: 190
Joined: Feb 2016
Reputation: 0
#19

24.11.2016, 17:12
( Последний раз редактировалось dugi; 25.11.2016 в 08:45. )
I installed it but the score , money dont save

Add me at skype to look at my code i cant share it here

nournasser1234

I don't know what's the problem

Can you fix your script?
Find
Reply
Tenka
Little Clucker
**
Posts: 39
Threads: 9
Joined: Nov 2016
Reputation: 0
#20

05.12.2016, 09:36
Can you put mysql_log(LOG_ALL); and post mysql_log.txt please
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Gamemode Scripts