[GameMode] [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL)
#41

Quote:
Originally Posted by webflashing
--------------------------------------------------------------------
OK, SORRY I FORGOT TO MENTION SOMETHING ON THE TUTORIAL.
I FORGOT TO INCLUDE ON THE .RAR PACKAGE THE .INC FILE
SO NOW I HAVE UPDATED THIS TUTORIAL.
PLEASE FOLLOW IT *AGAIN* WITH ALL OF IT'S STEPS.

SORRY

----
Web
--------------------------------------------------------------------




Ok everybody, as i'm seeing that ALMOST EVERYONE on this topic has a problem with the MYSQL stuff, i'll write a *little* tutorial on how making this script work.

1.- First, download the script from here
http://www.sendspace.com/file/suliqy
Now that you have the script, let's focus on the MYSQL thing.

2.- Next thing to do is to download the MYSQL plugin. As the package was too
heavy, i repacked it with the necessary files ONLY.
You can download it from here
http://www.sendspace.com/file/v5aazt
3.- Now that you have the package, INSIDE it, you will find that the files are
already in their own folders, the ONLY thing you should do now is copy the
content of the .RAR into your server's folder. And after that, you should
open your server.cfg and add the line plugins sampmysql at the end
of the file.
Edit:
Now put the *.inc* file on the includes folders of the pawno.
That should fic the error that some of you were having.


4.- Ok, that was easy until now. This step is going to explain HOW TO set up a
MYSQL server...
5.- First, you will need to download XAMPP (This will be your Mysql server...)

http://ufpr.dl.sourceforge.net/sourc...-installer.exe

After you download it, you sholud install it with the Apache and
PhpMyAdmin features (asked on the installer).
6.- Ok, now after the installation the Mysql server should be running, the only
thing you have to do is to enter http://localhost/xampp and select
the link that says "PhpMyAdmin". Once you clicked on it, you should see a
new page, where there is a lot of stuff.
7.- As i'm not in my computer, I dont really remember how, ut it should be a
textbox somewere where you create a un database. In that textbox, you
should write SAMP, and then click on the button "create" (or something like
that). Once donde this, on the left panel, it should appear now the text
"samp (0)". That means it has 0 tables inside. So now, let's click on the
"samp (0)" link, and then on the right panel, on the top, we should clik
"Import". Here is where we search for the database which comes with the
script, and the we import it.

Ok, by doing this, you just run the server and it should work. Any question, please ask. And remember, the script has too many bugs, if someone WANTS to start fixing them, you'l count with me, cause i'm trying to make the same.

Please let me know if this tutorial was useful for you. Thanks.

----
Web
Ok i did that all but know i get this
:
Fout
SQL-query:

/* * * -- Moderntopia: Los Santos -- * version 1.0 beta * * by Novice, Luk0r, Shehab, Ehren * based on the original Godfather script by FeaR * */#define SCRIPT_VERSION "mtrp-final 1.0 forum release"
#include <a_samp>
#include <a_sampmysql>
#include <core>
#include <float>
#include <time>
#include <file>
#include <utils>
#include <morphinc>
static gTeam[MAX_PLAYERS];



MySQL retourneerde:

#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 'static gTeam[MAX_PLAYERS]' at line 1

Reply
#42

Why when many people on the server, the timer is not in jail!
Reply
#43

man I'm not stupit but how to me me Admin on this GM..In scriptfiles dosn't have admin lvl or something..and if there something /rcon?
Reply
#44

hi where can i find libmysqlclient15 for linux xampp and how can i install this ? please help
Reply
#45

Please help me

Код:
SA:MP Dedicated Server
----------------------
v0.2.2, ©2005-2007 SA:MP Team

[18:10] filterscripts = "" (string)
[18:10] password = "" (string)
[18:10] 
[18:10] Server Plugins
[18:10] --------------
[18:10] Loading plugin: sampmysql.so
[18:10]  Failed (libcrypto.so.0.9.8: cannot open shared object file: No such file or directory)
[18:10] Loaded 0 plugins.

[18:10] 
[18:10] Ban list
[18:10] --------
[18:10] Loaded: samp.ban
[18:10] 
[18:10] 
[18:10] Filter Scripts
[18:10] ---------------
[18:10]  Loaded 0 filter scripts.

[18:10] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
Reply
#46

Help, please:

Код:
C:\Documents and Settings\Ћiga\My Documents\Downloads\Normal Downloads\MTR\mtrp-final.pwn(14) : fatal error 100: cannot read from file: "a_sampmysql"

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


1 Error.
Where can I get this file?
Reply
#47

here http://www.sendspace.com/file/v5aazt
Reply
#48

Dont actually expect it will be any, "have to stay hoping" but still....
Reply
#49

Very nice gamemode, only problem i have is that i have no idea how to remove bans / make myself admin via phpMyAdmin. could someone give me a 'n00b' step-by-step set of instructions please.

Would be appreciated.
Regards,

[BT]JaC
Reply
#50

I personally use a program called 'Navicat Lite for Mysql'. This is a tutorial for the program mentioned to the left.

Quote:

Click file -> new connection.

Set your settings up according to your MySql settings ( which can be found in the MySql server configuration wizard )

Click test connection.

If successfull click Ok on the popup window, and then OK in the Connection Window.

Double Click the new connection you just Configured in Navicat.

Double Click your Modertopia's Database.

Look in Tables for the " Players " table.

Open the Players Table.

Look across your Players string for the "adminlevel" Column ( 5 columns across )

set its value to 1337

Close Navicat

You should now be 1337 level admin. If you have problems reply to this post.


Reply
#51

Quote:
Originally Posted by eldiablo1337
NICE !

Would you like a mirror?
sure make for me one please pm me please
the web site will be www.rphardknocks.smfforfree2.com
and AMX. and PWN. fiels please and all what i need the puligins and server .cfg thx and dont froegt the scipert fiels thxvm
Reply
#52

my error is
C:\DOCUME~1\PC\LOCALS~1\Temp\Rar$DI00.375\mtrp-final.pwn(14) : fatal error 100: cannot read from file: "a_sampmysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


1 Error.
Reply
#53

:S When i am playing with Moderntopia GM in ym server, after 10 min the server shtting down and close....
I have Moderntopia GM Translated, but before server dont crash....

Why?


PD: Srry bad english ^^
Reply
#54

Lol, the problem is that when any player disconnect from the server, the server crash and close....
Why?
Help plis, THX.



(Soz for my bad english ^^)
Reply
#55

One of the best RP mode in the showroom!
Reply
#56

This mode sounds grate, but can someone fix bugs and post fixed .pwn pleaseee, and remove damm mysql
Reply
#57

I need help. I am setting up this script for a friend and neither of us know how to convert to AMX file. How do you do this? I also do not understand what MySQL has to do with this script besides storing player information.
Reply
#58

i did the mysql and still error.
Reply
#59

Quote:
Originally Posted by northarmy
i did the mysql and still error.
Here
Reply
#60

/taketest Bug


This game mode is very nice ~!

But this bug happen .And i can't fix it.

/taketest


◎.When tester on the race check point .Than it not disable
I need support to fix this bug .




Thx for your help .And sorry for my bad english >"<


Reply


Forum Jump:


Users browsing this thread: 10 Guest(s)