Blank RP. Roleplay starting point using SQL server [UPDATED] - 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: Blank RP. Roleplay starting point using SQL server [UPDATED] (/showthread.php?tid=18457)

---

Blank RP. Roleplay starting point using SQL server [UPDATED] - Jaymzanator - 01.12.2007

Blank RP 1.3.1 7th December 2007
This is my 3rd release of a blank roleplay script

What it does
Forces user to log in before playing
Stores spawn weapon data and gives players spawn weapons (config required )
Saves user's money every 5 minutes
Saves users money on disconnect

How does it do it?
Using a MySQL connection (DLL and SO)

What do i need for it?
Samp server 2.2
MySQL 5.0 or higher (libmysql.so on unix)

What doesnt it do?
It isnt a complete game mode, it is a base for a roleplay to be built off.
It doesnt allow uesrs to buy spawn weapons (yet). it just allows them to be pulled out of a database.

Why 1.3?
There was a big gap in the code. if you downloaded 1.2 then i recommend you to DL this instead

Screenshots
- Before registering
- Logged in
- Scoreboard shows money, not kills
- Auto saves of database when users quit

Download
http://jwnic.net/work/rp/1.3.1/starter_rp.rar
(please help and mirror this)

IF YOU DOWNLOADED 1.2 YOU WILL NEED TO UPDATE TO THIS OR YOURS WILL NOT WORK


If you need any help PM me.
Thanks to LGW for the dll

---

Re: Blank RP. Roleplay starting point using SQL server - Alejandro - 01.12.2007

nice. looks good.

i can mirror when my website is back up.

---

Re: Blank RP. Roleplay starting point using SQL server - Jaymzanator - 01.12.2007

it is designed just to help people new to PAWN.

i am writing a PHP interface for the database atm.

---

Re: Blank RP. Roleplay starting point using SQL server - Alejandro - 01.12.2007

Mirror

---

Re: Blank RP. Roleplay starting point using SQL server - Jaymzanator - 01.12.2007

thanks...

i'll prolly update it in a few days so people can buy sweps

---

Re: Blank RP. Roleplay starting point using SQL server - killertehkarl - 02.12.2007

How do i use it im really confused

---

Re: Blank RP. Roleplay starting point using SQL server - Jaymzanator - 02.12.2007

it is basically a login script. you still need to add cars, players, weapons and activities. I will be providing a detailed line-by-line analysis soon

you should have a basic knowledge of MySQL and an intermediate knowledge of PAWN before integrating this

---

Re: Blank RP. Roleplay starting point using SQL server - killertehkarl - 02.12.2007


C:\Documents and Settings\Killer\Desktop\samp022server.win32\gamemo des\rp.pwn(45) : fatal error 100: cannot read from file: "a_sampmysql"

Huh?

---

Re: Blank RP. Roleplay starting point using SQL server - Jaymzanator - 02.12.2007

make sure you have extracted a_sampmysql.inc TO THE SAME DIRECTORY

if that doesnt work change ln45 to make it

#include "a_sampmysql.inc"
or #include <a_sampmysql>

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - stevvo - 03.12.2007

Kudos for useing SQL instead of textfiles.

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - dank - 03.12.2007

is this a step closer to having actual npc spawns, or is that still out of the question for the future of samp?

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - dococ - 03.12.2007

Basically all this is just the register and such are coded into SQL, nothing to do with NPCs

Very nice, I will download it soon

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - Jaymzanator - 03.12.2007

NPCs = no.

that requires lots of proccessing power. 1 computer (single player) is hard enough, 100 players = impossable.

im not sure if it is possable on samp either

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - James_Bukubiza - 05.12.2007

Hi, I have a problem using this script.
I've set up mySQL databae, edited the DB settings in the script, everything goes fine
Started the server, Everything was loaded successfully, but when entering the SAMP server - the game crashes.
Looking forward to your reply, thanks.

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - Jaymzanator - 05.12.2007

i will have a look for you.

can i just ask...
is it sampserver that crashes or gtasa that crashes?
are you using Windows or Linux?
if you are Windows, are you using x86 or x64 versions?
if you are Windows, are you using windows server 2003?
if you are windows, have you copied libmysql.dll into the same folder as sampserver.exe?
if you are linux, have you got the latest /bin/libmysql.so?

also have you added extra vehicles or models... too many vehicles can cause samp to crash

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - James_Bukubiza - 06.12.2007

First of all, thanks for answering, here's some info:
1. The sampserver crashes - the server itself, not the client.
2. I'm running Windows XP, 32 bit version.
3. Yes, copied libmysql.dll to the same folder as sampserver.exe.
4. No extra vehicles / objects etc., just your blank mySQL RP script.

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - Makoto - 07.12.2007

No instructions about "tables.MySQL", took me half an hour to realize that I need to update the database with that file.

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - Jaymzanator - 08.12.2007

hmm.. it was in the old install guide. but not the new one

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - Jaymzanator - 08.12.2007

You need player classes.
and You need to make sure SQL server is there. it will crash if there is no server (i need to sort that one)

---

Re: Blank RP. Roleplay starting point using SQL server [UPDATED] - James_Bukubiza - 08.12.2007

Thanks, we got that working. nice script, btw like Makoto said,
I'm suggesting you add instructions about the tables.sql file.

p.s. What's new in 1.3.1?
Thx

---