[GameMode] [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - 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: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) (/showthread.php?tid=22818)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) (/showthread.php?tid=22818)
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Richi_Makaveli - 13.03.2008
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 |
:
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
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Zlayer - 13.03.2008
Why when many people on the server, the timer is not in jail!
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - server_making - 13.03.2008
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?
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - mcdjpower - 14.03.2008
hi where can i find libmysqlclient15 for linux xampp and how can i install this ? please help
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - mcdjpower - 14.03.2008
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"
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - [SOA]Spider - 14.03.2008
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.
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Enemy4you - 14.03.2008
here http://www.sendspace.com/file/v5aazt
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Revelator - 10.04.2008
Dont actually expect it will be any, "have to stay hoping" but still....
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - BiTTRaFFiC - 11.04.2008
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
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - paul1488 - 12.04.2008
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. |
Re: [GM] Moderntopia Roleplay: Los Santos - kztz12 - 14.04.2008
Quote:
|
Originally Posted by eldiablo1337
NICE !
Would you like a mirror? |
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
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - kztz12 - 15.04.2008
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.
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - JLeone - 15.04.2008
: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 ^^
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - JLeone - 15.04.2008
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 ^^)
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Yaheli_Faro - 16.04.2008
One of the best RP mode in the showroom!
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Jari - 16.04.2008
This mode sounds grate, but can someone fix bugs and post fixed .pwn pleaseee, and remove damm mysql
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Alfrunn23 - 16.04.2008
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.
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - northarmy - 01.09.2008
i did the mysql and still error.
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - Crazy_Cena - 01.09.2008
Quote:
|
Originally Posted by northarmy
i did the mysql and still error.
|
Re: [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL) - charlins - 02.09.2008
/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 >"<