[Jaymzanator]

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

[Alejandro]

nice. looks good.

i can mirror when my website is back up.

[Jaymzanator]

it is designed just to help people new to PAWN.

i am writing a PHP interface for the database atm.

[Alejandro]

Mirror

[Jaymzanator]

thanks...

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

[killertehkarl]

How do i use it im really confused

[Jaymzanator]

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

[killertehkarl]

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

Huh?

[Jaymzanator]

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>

[stevvo]

Kudos for useing SQL instead of textfiles.

[dank]

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

[dococ]

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

[Jaymzanator]

Quote:

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

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

[James_Bukubiza]

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.

[Jaymzanator]

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

[James_Bukubiza]

Quote:

Originally Posted by Jaymzanator 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

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.

[Makoto]

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

[Jaymzanator]

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

[Jaymzanator]

Quote:

Originally Posted by James_Bukubiza 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.

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)

[James_Bukubiza]

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