MySQL code - 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: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL code (/showthread.php?tid=582689)

---

MySQL code - Sam15 - 22.07.2015

Hello, I am having a doubt for coding...can just anyone help me to give the code or any ideas please ?
1. Create a MYSQL connection
2. If tables / rows doesn't exist there should be a query in the script to
create them.
3. Load vehicles from the database
4. A user stat base which logges the user's name , score , IP , passsword (
should be encrypted) & userID ( auto increment ).
5. A ban database

Using zcmd (the include ) create the following stuff
/setscore [id] command
/ giveallscore cmd
/kick [id]
/ban [id]

---

Re: MySQL code - Nimrod - 22.07.2015

The idea is to learn how to code first, then create systems like the ones you mentioned, not ask people to give you entire codes, resulting in you barely picking anything up. There are lots of great MySQL and SAMP scripting tutorials on the internet, in both text and video format. Use ****** and *******.

---

Re: MySQL code - Sam15 - 22.07.2015

I know but I will learn from the code if you provide. Understand the situation.

---

Re: MySQL code - SilentSoul - 22.07.2015

Nimrod is right, and you too. but there are tons of scripts, examples around the forums for what you're looking for at least before creating a thread search first.

1. Mysql connection, registration system
2. Ban system
3. Zcmd setscore command
Just wanted to show that i can find all what you want easily. Please search the others yourself.

---

Re: MySQL code - Sam15 - 23.07.2015

I will try to do this..but can anyone help me for the dialog thing ? It's pretty much hard for me.

---

Re: MySQL code - !damo!spiderman - 23.07.2015

You don't mention dialogs anywhere. What is your issue? What have you tried? What doesn't work?

---

Respuesta: MySQL code - RafaelZam - 23.07.2015

you should learn about it,
we can't just give you a script

---

Re: MySQL code - Gazzy - 23.07.2015

Learn it yourself, then you'll know a lot more about how to code in MySQL than if you were just given the code

---

Re: MySQL code - Sam15 - 23.07.2015

Can a anyone provide me a good PAWN and MYSQL Scripting video ?

---

Re: MySQL code - xPirate - 23.07.2015

https://sampforum.blast.hk/showthread.php?tid=485633

Start here.

---

Re: MySQL code - mamorunl - 23.07.2015

Did you know that if you use the magic that is ****** and use 'site:forum.sa-mp.com' you can find everything you just described and that more magic happens?

If you keep asking for stuff, you are only littering the forum and searching will become harder because of topics like this.

---

Re: MySQL code - Sam15 - 23.07.2015

Also, the dialog thing :-A command which opens up a dialog and does the following:
A dialog which allows the user to be teleported somewhere
A dialog which gives health + armour to the player
A dialog which gives the player weapons

---