[GameMode] Vortex Roleplay 2 [MySQL, sscanf, streamer, IRC, whirlpool]

[denom]

cant get mysql work... on linux

[ajam112]

Originally Posted by Calgon

nope

I dont know how to use / setting msql.

[Calgon]

Originally Posted by ajam112

I dont know how to use / setting msql.

So learn? It's not rocket science.

[ajam112]

Originally Posted by Calgon

So learn? It's not rocket science.

Oh lol, where can i download it? can teach me how to setting and connect with that?

[Calgon]

Originally Posted by ajam112

Oh lol, where can i download it? can teach me how to setting and connect with that?

For everything you don't yet understand about MySQL, you can probably Google it. The package contains everything you need to start off. Also, there's a tutorial.

[pl1xusz]

Works like a charm
Perfect gamemode
Love it

[sanplayer]

Right,

I'm not a noob at computers or mysql.

It appears in the windows download you got no SQL Defines to define a connection.

[sanplayer]

You'll need to follow these instructions quite precisely to get this game mode working. If you don't, then I can't guarantee you'll be able to get this script working. I'd certainly appreciate it if you read these instructions instead of creating a rather quite stupid response.

1. Download the relevant package for your server's operating system
2. Unzip the package to a folder somewhere on your computer
3. Edit your server.cfg for your server's name and RCON password
4. Download the Scripting Package and unzip it
5. Open Pawno from the Scripting Package from the 'pawno' folder
6. Navigate to the .pwn file from Pawno to where you put the server package, open vx-rp.pwn
7. Create your database/username for MySQL
8. Use phpMyAdmin or some other alternative to import the SQL dump
9. Update the SQL defines in the script from Pawno with your new MySQL info
10. Re-compile the script by hitting F5
11. Upload the server package with the newly updated .pwn & .amx file
12. Confirm all of the correct files have been uploaded. This is everything in your server package - including server.cfg!
13. (Re)Start your server

** NOTES FOR STEP 1 **
If you're not quite sure which operating system the server will be used on, take a look at this list.

Note: Debian is a Linux distribution, 'Win' is an abbreviation of Windows and CentOS is a Linux distribution. If multiple operating systems are listed, you should contact the support staff of the hosting company you're with to ask.

** NOTES FOR STEP 7 **
Assuming you're using a SA-MP host (such as volt-host or serverFFS), you'll be able to create a database for MySQL. To do this, you'll need to navigate to the part of your hosts' control panel which allows you to create a database - if you're unsure where the 'create database' tool will be located, take a look through each section of the hosts' control panel.

To create your database, you might be asked to create a username and password for your database - you'll have to remember this information for your server, because once you've created the database, you're going to need to fill out the information in the 'SQL_*' defines in the script.

** NOTES FOR STEP 8 **
In the server packages, you'll notice there's a file included that retains the file extension of '.sql', most server hosts will give you direct access to phpMyAdmin - where you'll probably be required to login to it with the information you used to create your MySQL database. You'll need to import the data of the sql file in to phpMyAdmin (or whatever you have to your avail). A video tutorial I found on the web which might be useful for this operation is

here

here

.

[dawiisss]

[07:59:24] Number of vehicle models: 0
[07:59:24] Script[gamemodes/vx-rp.amx]: Run time error 19: "File or function is not found"
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_CallbackHook" found (script needs to be recompiled with the latest include file)

[07:59:24] Loaded 1 filterscripts.
[07:59:24] *** MoveDynamicObject: Expecting 8 parameter(s), but found 5
[07:59:24] *** MoveDynamicObject: Expecting 8 parameter(s), but found 5
[07:59:24] *** MoveDynamicObject: Expecting 8 parameter(s), but found 5
[07:59:24] *** MoveDynamicObject: Expecting 8 parameter(s), but found 5
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyCheckpoint" found (script needs to be recompiled with the latest include file)
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_VerifyPickup" found (script needs to be recompiled with the latest include file)
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_RemovePlayer" found (script needs to be recompiled with the latest include file)
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_AddPlayer" found (script needs to be recompiled with the latest include file)
[07:59:24] *** Streamer Plugin: Obsolete or invalid native "Streamer_RegisterInterface" found (script needs to be recompiled with the latest include file)
[07:59:24] Loading filterscript 'ls_elevator.amx'...
[07:59:24] ---------------
[07:59:24] Filterscripts
[07:59:24]

[07:59:24] Loaded 5 plugins.
[07:59:24] Loaded.

Why does this show up 0.o . I recompiled the script with latest streamer.inc and it still shows up with this

anyone please

[Calgon]

Originally Posted by dawiisss

Why does this show up 0.o . I recompiled the script with latest streamer.inc and it still shows up with this

anyone please

Download the latest version of the streamer plugin and the include, move the files for the plugin to the plugins directory in your SA-MP server folder and move the include over to compile it all.