PDA

View Full Version : [GameMode] [GM] Moderntopia Roleplay: Los Santos 1.0 (MySQL)


Pages : [1] 2 3 4 5 6

Moderntopia
18/01/2008, 07:06 PM
Moderntopia Roleplay: Los Santos
Version 1.0 (Bugfix 2)


Introduction

Moderntopia is a new multigaming community focusing on providing game servers for a range of games. We have a number of experienced scripters and some nice ideas to implement at a later date in future projects. If you would like to learn more, please visit our website http://www.moderntopia.com/ and get in touch with the community. Note: We are not planning to leave SA-MP just yet, there are still quite a few ideas we're going to try out. :)

Since our script was leaked and obtained by another community (Valhalla Gaming) unintentionally, we've decided to release it to the SA-MP community. We hope you will all find it useful, even if you're just ripping out the parts you need. The script has come a long way and we have some pretty nice ideas for future releases on our server.

This script is a variation of the Godfather by FeaR/Astro and includes many new features and bugfixes over the original release (over 50% more code).

Credits: Novice, Luk0r, Ehren and Shehab. Previous works were also contributed by Dizzy and Essy.


Features

The script has all the features of the original Godfather script, as well as the following:


MySQL Integration - All player accounts and the stats associated with them are now stored in a MySQL database. This offers improved speed and manageability over the original storage method; and the possibility to add a control panel or external player management system. Anticheat bans and player logins are also logged in the database.
Car Ownership - Most vehicles in the gamemode must be bought by players to drive. Once a vehicle belongs to a player, it is stored and allows them to /park the vehicle so it respawns in that position when the server is restarted.
Realistic Economy - Unlike most roleplay servers, our script offers a realistic economy resembling real-world currency amounts. All currency transactions within the script are realistic and resemble real-world prices.
House & Business Improvements - We've added/changed a lot of house and business locations, and their prices.
Job Improvements - Jobs within the server have been improved to add content to the game. For example, the bus driver system places checkpoints along the route and informs players of the incoming bus if they are near a stop.
Tested Licensing - Driving, flying and sailing licenses now require a test to be completed beforehand. Flying and sailing licenses have an automated physical test with checkpoints, and the driving test is a knowledge test (there's also a physical test too, but it's disabled).
Anti-Cheat - The advanced anti-cheating system in the script ensures money and weapon hacking results in an account ban. The amount of money, the weapon ID spawned and the player's IP address are logged in the database for further investigation.
And much more...



Notes

IMPORTANT: To compile and run the script on your game server, you're going to need to grab the SA-MP MySQL plugin and include files (by ADreNaLiNe-DJ (http://forum.sa-mp.com/index.php?action=profile;u=3594)) from this thread (http://forum.sa-mp.com/index.php?topic=23931.0). You also need a working MySQL server, which I expect you to have a basic understanding of already. The database.sql file contains the database structure, just execute the SQL queries in that file on your DB.

If your SA-MP MySQL plugin isn't loading or the server is crashing shortly after startup:

in the tutorial it tells you to add: plugins samp-mysql ..... just put: plugins sampmysql


In addition, you need to copy the CFG files in the scriptfiles directory of the archive to the scriptfiles directory on your server. If you don't already have a scriptfiles directory, create one.

Please give some credit if you use parts of the script, we spent a lot of time working on it.


Download

Mirror 1: Download (http://www.sendspace.com/file/suliqy)
Mirror 2: Download (http://www.mediafire.com/?7mwdptvscmi)
Mirror 3: Download (http://rapidshare.com/files/84930814/mtrp-final.zip.html)
Mirror 4: Download (http://www.megaupload.com/?d=WSW0N48N)

Server Map: Large (http://img143.imageshack.us/img143/8508/servermapmc7.jpg) / Small (http://img182.imageshack.us/img182/5769/servermapsmallzd7.jpg)


www.moderntopia.com

eldiablo1337
18/01/2008, 07:08 PM
NICE !

Would you like a mirror?

Luk0r
18/01/2008, 07:09 PM
If you have any problems with the script, please post in this thread and I'll get them sorted as soon as possible.

snipe69
18/01/2008, 07:15 PM
very nice work men :mrgreen:

Gibox
18/01/2008, 07:18 PM
fatal error 100: cannot read from file: "utils"
where i can find that include?

Luk0r
18/01/2008, 07:21 PM
fatal error 100: cannot read from file: "utils"
where i can find that include?


http://www.sendspace.com/file/k5m0e0

Pixels^
18/01/2008, 07:28 PM
Looks like Pen1 a little too much.

Lidor Kalfa
18/01/2008, 07:30 PM
I dont know how use the sql :( I got runtime error "file or function not found"

R@f
18/01/2008, 07:33 PM
39598 lines :o ! Nice script :D

R@f

James Mulder
18/01/2008, 07:33 PM
Pixels^ ]
Looks like Pen1 a little too much.


Dude, Godfather is based off of Pen1 :roll:

Btw I am Ehren mentioned in the first post. You can ask me any questions too, I'll help if I can.

JayC
18/01/2008, 07:34 PM
Pixels^ ]
Looks like Pen1 a little too much.


Godfather is based off Pen1

However, looking at ours you should be able to see the difference, which was also posted above.

shulky
18/01/2008, 07:35 PM
i dont think this guys got clue wot hes doin who posted this also his post count is 1 so hes new am stayin slear of this one moor hassle than its worth ;)

Pixels^
18/01/2008, 07:37 PM
ḾṂĐ ]
If you guys want to discuss about Pen1ls or the Godfather, discuss in the the godfather or pen1ls topic.
We arn't idiot. I'm saying that this script is a real minor modification of the Godfather script. So basically he needs to add credits that it's based of Godfather script.

Luk0r
18/01/2008, 07:39 PM
i dont think this guys got clue wot hes doin who posted this also his post count is 1 so hes new am stayin slear of this one moor hassle than its worth ;)


I could have posted it on this account, but Moderntopia seemed a little more professional.

JayC
18/01/2008, 07:40 PM
i dont think this guys got clue wot hes doin who posted this also his post count is 1 so hes new am stayin slear of this one moor hassle than its worth ;)


There is no virus in any of this. Moderntopia was the account created today to represent our community's script and further announcements. There is no evil scheme to do anything, but to help the scripters. Feel free to post anymore questions or comments.

Pixels^
18/01/2008, 07:43 PM
I guess the godfather credits are added. I take my arguments back ;).

sebihunter
18/01/2008, 07:59 PM
I donґt like godfather edits BUT this is really nice ;)

Luk0r
18/01/2008, 08:09 PM
Pixels^ ]
ḾṂĐ ]
If you guys want to discuss about Pen1ls or the Godfather, discuss in the the godfather or pen1ls topic.
We arn't idiot. I'm saying that this script is a real minor modification of the Godfather script. So basically he needs to add credits that it's based of Godfather script.


Considering the original Godfather script has 26,085 lines and ours has 39,600, I'd say that's a pretty significant modification. No offense, but you don't know what you're talking about.

Pixels^
18/01/2008, 08:10 PM
I never used the godfather script so it's kinda hard to notice :D.

I guess the godfather credits are added. I take my arguments back ;).

Lidor Kalfa
18/01/2008, 08:13 PM
I got
Script[gamemodes/mtrp.amx]: Run time error 19: "File or function is not found"

Pixels^
18/01/2008, 08:13 PM
I got
Script[gamemodes/mtrp.amx]: Run time error 19: "File or function is not found"
Usually means calling a function from an inc failed.

Lidor Kalfa
18/01/2008, 08:15 PM
I fix this proeblom ,now that: :D

[23:24] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[23:24] MYSQL: Attempting to connect to server...
[23:24]
Connection to MySQL database: Failed !
[23:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[23:24] Error in mysql_select_db: MySQL server has gone away
[23:24] MYSQL: Connection error, retrying...
[23:24]
Connection to MySQL database: Failed !
[23:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[23:24] Error in mysql_select_db: MySQL server has gone away
[23:24] MYSQL: Could not reconnect to server, terminating server...
[23:24] --- Server Shutting Down.

Luk0r
18/01/2008, 08:19 PM
I fix this proeblom ,now that: :D

[23:24] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[23:24] MYSQL: Attempting to connect to server...
[23:24]
Connection to MySQL database: Failed !
[23:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[23:24] Error in mysql_select_db: MySQL server has gone away
[23:24] MYSQL: Connection error, retrying...
[23:24]
Connection to MySQL database: Failed !
[23:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[23:24] Error in mysql_select_db: MySQL server has gone away
[23:24] MYSQL: Could not reconnect to server, terminating server...
[23:24] --- Server Shutting Down.


I recommend installing XAMPP (http://www.apachefriends.org/en/xampp.html) if you're on Windows. You can use the included PHPMyAdmin tool to set up your database once it's installed.

Remember to fill in the defines in the script with your connection information.

Chumillas
18/01/2008, 08:59 PM
Hi all:

Thanks for the release! I played in this server, all stuff is good
__________________________________________________ _____________________

Solve: Download SQL and NOT Lite Version (a_samp.inc)

Pixels^
18/01/2008, 09:01 PM
IMPORTANT: To compile and run the script on your game server, you're going to need to grab the SA-MP MySQL plugin and include files (by ADreNaLiNe-DJ) from this thread. You also need a working MySQL server, which I expect you to have a basic understanding of already. The database.sql file contains the database structure, just execute the SQL queries in that file on your DB.
You gotta start reading before asking stupid questions.

xspectorx
18/01/2008, 09:06 PM
when i turn off this line, the mod is off , 7 errors - and compiled the mode thats ok , and When i start server and connect over the client, i see yelow message "Please wait" and client is crashingPLEASE HELP!!!


C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(9993) : error 017: undefined symbol "EnableStuntBonusForAll"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(9995) : error 017: undefined symbol "DisableInteriorEnterExits"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17317) : error 017: undefined symbol "SPECIAL_ACTION_USECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17499) : error 017: undefined symbol "SPECIAL_ACTION_USECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17536) : error 017: undefined symbol "SPECIAL_ACTION_STOPUSECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(25588) : error 017: undefined symbol "EnableStuntBonusForPlayer"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(25604) : error 017: undefined symbol "EnableStuntBonusForPlayer"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


7 Errors.

Luk0r
18/01/2008, 09:10 PM
I have no idea. Looks like you have some issues with your pawn include files/installation.

Ick9
18/01/2008, 09:18 PM
when i turn off this line, the mod is off , 7 errors - and compiled the mode thats ok , and When i start server and connect over the client, i see yelow message "Please wait" and client is crashingPLEASE HELP!!!


C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(9993) : error 017: undefined symbol "EnableStuntBonusForAll"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(9995) : error 017: undefined symbol "DisableInteriorEnterExits"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17317) : error 017: undefined symbol "SPECIAL_ACTION_USECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17499) : error 017: undefined symbol "SPECIAL_ACTION_USECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(17536) : error 017: undefined symbol "SPECIAL_ACTION_STOPUSECELLPHONE"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(25588) : error 017: undefined symbol "EnableStuntBonusForPlayer"
C:\Documents and Settings\SPY\Рабочий стол\mgf.PWN(25604) : error 017: undefined symbol "EnableStuntBonusForPlayer"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


7 Errors.




Its all on the same line so either that line is totally jacked up or your compiler is.

xspectorx
18/01/2008, 09:19 PM
Who can the compile the pawno to me this mod, please friends?


#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_PASS "ghbdtn"
#define MYSQL_DB "database"

xspectorx
18/01/2008, 09:23 PM
Who can to give me the compiler with the libraries, i have old version, very need!

Chumillas
18/01/2008, 09:58 PM
Solve: Download SQL and NOT Lite Version (a_samp.inc)

Luk0r
18/01/2008, 10:00 PM
Read the OP.

leestrong7
18/01/2008, 10:14 PM
[23:18] Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"

Getting this.. i'm pretty sure everything is correct.

cptnsausage
19/01/2008, 12:23 AM
I have to say I'm not a fan of GF or PEN1 and even less, of any mods based on them but this is pretty good :D

nice work guys

Thursday
19/01/2008, 12:24 AM
Whenever I compile it, I get:

mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"

So I'm guessing either you released this with errors for those that know how to code to fix and to keep leechers away, or you're releasing an unfinished script. Either way, you should at least point these things out. I believe I'm doing everything right... so either obviously not or again you want me to manually fix this crap, and I'm not that skilled in pawno so that's kinda hard :/

Moderntopia
19/01/2008, 12:25 AM
Whenever I compile it, I get:

mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"

So I'm guessing either you released this with errors for those that know how to code to fix and to keep leechers away, or you're releasing an unfinished script. Either way, you should at least point these things out. I believe I'm doing everything right... so either obviously not or again you want me to manually fix this crap, and I'm not that skilled in pawno so that's kinda hard :/


READ THE OP.

Thursday
19/01/2008, 12:33 AM
Whenever I compile it, I get:

mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"

So I'm guessing either you released this with errors for those that know how to code to fix and to keep leechers away, or you're releasing an unfinished script. Either way, you should at least point these things out. I believe I'm doing everything right... so either obviously not or again you want me to manually fix this crap, and I'm not that skilled in pawno so that's kinda hard :/


READ THE OP.


I did all the MySQL crap, and I doubt the sql database has anything to do with it other than the include files.. but i've installed samp mysql.. copied all the files right and everything.. but I'm still getting that error? Unless there is some hidden message I'm missing..

Luk0r
19/01/2008, 12:48 AM
Copy the .inc file into your pawno/includes directory. This is all documented in the SA-MP MySQL thread/archive/site.

Thursday
19/01/2008, 12:51 AM
^

Copy the .inc file into your pawno/includes directory. This is all documented in the SA-MP MySQL thread/archive/site.


Yes, I did this.

Also, the SA-MP MySQL site (dev.sa-mp.com, or whatever the full link is) is down, or at least I can't manage to connect to it.. I had to get the rapidshare link.

Luk0r
19/01/2008, 12:58 AM
Well you're not doing it correctly. That's all I can say to you.

Thursday
19/01/2008, 01:03 AM
^

Well you're not doing it correctly. That's all I can say to you.


(There is a quote button, it's very nifty)

Anyways, the original files said includeS, as in plural.. the lite download had one include file. Does the other version have more or something? The download site for it was down, so I couldn't get it.. I found his other site, but I really don't wanna download the larger file if I don't have to..

Carl-
19/01/2008, 01:03 AM
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(1) : error 010: invalid function or declaration
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(2) : error 010: invalid function or declaration
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 221: label name "Float" shadows tag name
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 209: function "GetPointDistanceToPointExMorph" should return a value
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "Float"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "z2"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "y2"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "x2"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "z1"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "y1"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : warning 203: symbol is never used: "x1"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3) : error 025: function heading differs from prototype
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(3 -- 4) : error 021: symbol already defined: "GetPointDistanceToPointExMorph"
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(4 -- 5) : error 029: invalid expression, assumed zero
C:\Program Files\Rockstar Games\GTA San Andreas\pawno\include\morphinc.inc(4 -- 5) : fatal error 107: too many error messages on one line

I get the exact same errors for gf. where can i re-download morphinc.inc?

Thursday
19/01/2008, 01:28 AM
Found the problem, the link in the thread was to an older version. All fixed, thanks for the help :)

Luk0r
19/01/2008, 01:33 AM
Great stuff. Next time you shouldn't jump to the conclusion that it's the script makers' fault so quickly. :)

And yeah, I know about the quote button, thanks for pointing it out though.

Thursday
19/01/2008, 01:46 AM
I didn't say it was his fault, just asking if he purposely did that :P

Anyways, found a new error...

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

Also the plugin failed to load...

Luk0r
19/01/2008, 01:48 AM
Ensure you're using the latest pawno compiler and includes from the LATEST Windows dedicated server package.

Are many others having this issue? Surely there would be more posts in the thread about it...

Thursday
19/01/2008, 01:53 AM
Yes, I'm using the latest compiler... also I think the plugins load before the script right? Why is the plugin failing to load as well... this is kinda strange heh.

This is what it says when compiled:

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

Header size: 9504 bytes
Code size: 1539240 bytes
Data size: 5279856 bytes
Stack/heap size: 16384 bytes; estimated max. usage=4285 cells (17140 bytes)
Total requirements: 6844984 bytes

Carl-
19/01/2008, 01:53 AM
Ok i've got this error now, and ive seen 2 other people with it:
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
C:\Program Files\Rockstar Games\GTA San Andreas\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.

Carl-
19/01/2008, 01:55 AM
Yes, I'm using the latest compiler... also I think the plugins load before the script right? Why is the plugin failing to load as well... this is kinda strange heh.

in the tutorial it tells you to add: plugins samp-mysql ..... just put: plugins sampmysql

Luk0r
19/01/2008, 01:56 AM
Yes, I'm using the latest compiler... also I think the plugins load before the script right? Why is the plugin failing to load as well... this is kinda strange heh.

in the tutorial it tells you to add: plugins samp-mysql ..... just put: plugins sampmysql


Ah yeah, that's true.

Thursday
19/01/2008, 01:58 AM
The biggest mistakes are always the little ones.

Sigh, thanks carl. I did that the first time but when I redid it, I completely forgot to do that.

Carl-
19/01/2008, 02:00 AM
The biggest mistakes are always the little ones.

Sigh, thanks carl. I did that the first time but when I redid it, I completely forgot to do that.

No problem, can you please tell me how you solved the error im getting now (the one you had earlier)

Moderntopia
19/01/2008, 02:00 AM
Added that to the OP. Thanks Carl-.

Carl-
19/01/2008, 02:04 AM
Added that to the OP. Thanks Carl-.

Where do i place this "database.sql" because this might be why mine isnt working?

Thursday
19/01/2008, 02:06 AM
You have to execute it in MySQL bro.

Anyways, now players can connect to the server, but as soon as it starts loading (loading where it says Please Wait and trys to load character skins) it crashes them? I think it has something to do with writing to mysql, but i dunno...

Carl-
19/01/2008, 02:11 AM
Is it possible for me to remove the all MySQL, because i dont know anything about it and dont know what to do?

and how would i completely remove it from the server?

James Mulder
19/01/2008, 02:12 AM
Just want to point out here that Valhalla got screwed twice now, after paying for GF it got released, now after they stole ours we released it, so as you can see Valhalla can't do anything on there own, they steal everyone elses work, not to mention they are now using our script on their server, just want everyone to know what there true colors are.

Luk0r
19/01/2008, 02:14 AM
You have to execute it in MySQL bro.

Anyways, now players can connect to the server, but as soon as it starts loading (loading where it says Please Wait and trys to load character skins) it crashes them? I think it has something to do with writing to mysql, but i dunno...


Is there anything in the server log about it?

Thursday
19/01/2008, 02:16 AM
You'd have to pretty much get rid of almost every modification that was made to it (including anti cheat) minus the new features. You're better off getting used to MySQL, heh.

@ Luk0r: no, it's just showing the account logging off.

Carl-
19/01/2008, 02:19 AM
hmmm.. first i need to sort out my errors.Thursday, you know the errors you posted earlier? how did you solve them?

Thursday
19/01/2008, 02:21 AM
http://www.lostgangwarz.com/samp_mysql_en.php

Download the SAMP SQL package there, rather than the one in the other thread. It has the wrong inc file.

Also, about the error I'm having now... i believe that the script has it loading an object that isn't supposed to be there. You didn't happen to make some sort of modification to the game client and then code off that did you?

Luk0r
19/01/2008, 02:27 AM
Oops, I think I left out a scriptfile.

One sec.

Thursday
19/01/2008, 02:29 AM
MySQLCheckConnection();

// Check if the account exists
new sqlaccountstatus = MySQLCheckAccount(plname);
if(sqlaccountstatus != 0)
{
// Check if the account is locked
if (MySQLCheckAccountLocked(sqlaccountstatus) != 0)
{
SendClientMessage(playerid, COLOR_LIGHTRED, "This account has been locked and cannot be accessed. Please contact an admin.");
Kick(playerid);
return 0;
}
gPlayerAccount[playerid] = 1;
PlayerInfo[playerid][pSQLID] = sqlaccountstatus;
}
else
{
gPlayerAccount[playerid] = 0;
}
SendClientMessage(playerid, COLOR_YELLOW, "Please wait...");
return 1;
}


When that part of the code loads is where people crash. Possibly some sort of miswrite in it, iono.. I can't really seem to figure this out..

@ Luk0r, haha alright.

Luk0r
19/01/2008, 02:33 AM
OP updated, try it now.

Thursday
19/01/2008, 02:50 AM
Nope, still crashing.

Try connecting to 66.135.35.32 to see what it's doing yourself heh

Luk0r
19/01/2008, 04:09 AM
Apparently it turns out there was a slight issue in the code that was causing it to crash Windows servers. Since our testing box is Linux, we didn't come across these problems while testing the release.

Sorry for the inconvenience.

Mirrors in the OP updated:

Mirror 1: Download (http://www.sendspace.com/file/suliqy)
Mirror 2: Download (http://rapidshare.com/files/84930814/mtrp-final.zip.html)
Mirror 3: Download (http://www.megaupload.com/?d=WSW0N48N)

Thursday
19/01/2008, 04:15 AM
It's all good homes. Glad it all got settled out :)

Thursday
19/01/2008, 05:07 AM
Wow this script is awesome. I've been playing around a bit and found a few things that could use modifications to make the server more fun, but this is just amazing. Thanks for this!

freakshow
19/01/2008, 07:41 AM
Just want to point out here that Valhalla got screwed twice now, after paying for GF it got released, now after they stole ours we released it, so as you can see Valhalla can't do anything on there own, they steal everyone elses work, not to mention they are now using our script on their server, just want everyone to know what there true colors are.


i say to you, without our source, where would you be, mabey you would just be a step down, but we based that script, not me, not corpo, not jay, VALHALLA based that script,

what you say is a fallacy, your logic is fail.. do some research it does alot.

arm33n
19/01/2008, 07:43 AM
Just want to point out here that Valhalla got screwed twice now, after paying for GF it got released, now after they stole ours we released it, so as you can see Valhalla can't do anything on there own, they steal everyone elses work, not to mention they are now using our script on their server, just want everyone to know what there true colors are.



IT WAS NOT YOUR SCRIPT GET THAT THROUGH YOUR HEAD

Moderntopia stole what was ours. I dont know who the hell you are. but you dont know anything mr mulder.

If anything we should of gotten credit and if it wasnt for us there wouldnt even be a decent moderntopia script.

So quit DDOS'ing other servers and admit that you made a bad choice

Joyrider89
19/01/2008, 07:45 AM
Just want to point out here that Valhalla got screwed twice now, after paying for GF it got released, now after they stole ours we released it, so as you can see Valhalla can't do anything on there own, they steal everyone elses work, not to mention they are now using our script on their server, just want everyone to know what there true colors are.


Considering the script that is running our server has been rebuilt from scratch when Moderntopia (JC, and Corpo) took the script straight from the server box, and made their own server using OUR ORIGINAL SCRIPT. Everyone should thank JC and Corpo for giving the source to Joe, cause without that he wouldn't of given it to our Server Owners, thus making this script public. By the way, Joe did was right, they promised him a lot of shit and didn't produce.

freakshow
19/01/2008, 07:48 AM
im still not grasping the fact of releasing it, its not the smartest move, minds as well get your copyright out, and i do admit

the DDoSing is really immature and naive , its no good, you should stop that, just a minor inconvenience to us.. comparing to your server of course

JDornatt
19/01/2008, 07:48 AM
Just want to point out here that Valhalla got screwed twice now, after paying for GF it got released, now after they stole ours we released it, so as you can see Valhalla can't do anything on there own, they steal everyone elses work, not to mention they are now using our script on their server, just want everyone to know what there true colors are.


What the fuck? Mother fucker don't talk shit if you don't know your facts..

Your server would even have a base script if it wasn't for Valhalla.. and if you wanna talk about stealing scripts.. Yeah You guys are perfect examples after you left and wouldn't give the most recent source on Valhalla to the correct owners, You wouldn't even take out the code that Novice scripted and give the rest.. They STOLE it all..

Speaking of true colors, What.. is Lukor's Ddosing gonna help your 0 member server? You guys got all the right talent, in the wrong places.. Before you even started you guys have a bad name.. You Do pointless DDos attacks because.. Why?

What could you guys have done on your own.. with out valhalla you wouldnt have a fucking idea where to start.





Attention All DOWNLOADERS YOU ARE DOWNLOADING CODE THAT IS RIGHTFULLY OWNED BY VALHALLA GAMING AND THEY REFUSE TO GIVE US CREDIT AFTER THEY STOLE IT..

arm33n
19/01/2008, 07:50 AM
QUIT DDOS'ING OTHER SERVERS LIKE VALHALLA

Joyrider89
19/01/2008, 07:52 AM
--Edited--

Amit_B
19/01/2008, 07:54 AM
WOWWWWW 39598 scriptlines!!!

Shehab
19/01/2008, 08:40 AM
Hello guys , i am here to say the truth , i was a scripter in valhallagaming , all they have added to their script, it was me and Novice , and some by Dizzy and Essy , when we left Valhallagaming, we took the script with us and YES we deleted it because we made it all, after that we worked on the script for a month to make it bigger , after Moderntopia server was up , after about 1 week , i meant to leave peicfully because a small problem happened with me and the owner , so i desided to create my own community with JDornatt , i didnt think he will stab me in the back just to get postition in valhallagaming, the script was shared between me and him , but i promiced the owner to remove all the scripts made by Novice and Luk0r and keep mine , but what happened is JDornatt stapped me in the back and gave the script to Valhallagaming which untill now i dont belive it.

I think you understanded the truth now, mtrp-final was made by the scripters of Moderntopia which are, Novice , Luk0r , Ehren and me , and ofcourse based on the God Father script made by Fear.

Thanks for reading.

yaoantn
19/01/2008, 08:44 AM
The damn SQL dont work =/ its not load the script.
As I see that's cool script! :D

Shehab
19/01/2008, 08:46 AM
and about the DDoSing , i know who did it , but its not one of Moderntopia team at all which the owners of Valhallagaming claims... basically JDornatt was DDoSing valhallagaming and LS-RP before he return back to valhallagaming and give them the script to have a position there... and for me, i think i am quitting samp because i lost my position on Moderntopia at all as i caused all these problems by giving the script to JDornatt.

today i will post the steps how to make the script run on your server properly

JDornatt
19/01/2008, 09:00 AM
Quit lying shehab, you know goddamn well i never ddosed them.. And you already lost your position at MT anyway.. the same way tom did it to me.. Dont start lying now to try to suck on lukors balls you asshole.. Im at valhalla right now? and I guess if we went by your information.. Im Ddosing the community I'm in.

Tom Wanted to play Mr. Bigshot and run it all by him self like the selfish little prick he is, and this is where it got him.

After these people screwed you over.. You still try to defend them, Shehab you are weak with these lies.

My actions where not against you in anyway.

For christ sake Shehab.. your about as good as a liar as you are a scripter,

saintagex
19/01/2008, 09:08 AM
Hello guys , i am here to say the truth , i was a scripter in valhallagaming , all they have added to their script, it was me and Novice , and some by Dizzy and Essy , when we left Valhallagaming, we took the script with us and YES we deleted it because we made it all, after that we worked on the script for a month to make it bigger , after Moderntopia server was up , after about 1 week , i meant to leave peicfully because a small problem happened with me and the owner , so i desided to create my own community with JDornatt , i didnt think he will stab me in the back just to get postition in valhallagaming, the script was shared between me and him , but i promiced the owner to remove all the scripts made by Novice and Luk0r and keep mine , but what happened is JDornatt stapped me in the back and gave the script to Valhallagaming which untill now i dont belive it.

I think you understanded the truth now, mtrp-final was made by the scripters of Moderntopia which are, Novice , Luk0r , Ehren and me , and ofcourse based on the God Father script made by Fear.

Thanks for reading.


What are you even talking about Shehab? You came to me on xfire the other day saying you wanted to help us attack Moderntopia, but I told you we are not doing anything against them and you kept asking me why and that they deserved it for doing it to us. (I can provide the logs if you are going to lie about it)

Yes novice did add to the script, but we bought a "custom" script from FeaR himself in which novice used (which therefore makes the source that he gave us and anything he added, a property of valhalla gaming)

Also, your accusing of Joe DDoS'ing us, yet he's in our ventrilo right now trying to play in the server, WHILE its being DDoS at this moment.

ODB
19/01/2008, 09:13 AM
(my first thread :D) Clearly there is a group of immature people here, who think this is an argument thread, its not so GTFO. This thread is here for people to disscuss about this new script which has been released recently, and its a great adittion to all the RP servers, i think.

JDornatt
19/01/2008, 09:16 AM
Posts from Shehab and James Mulder are posts that make it into an argument thread, I'm simply trying to defend my name from the soil of his weak ass lies. Clearly now you are getting desperate Shehab.. Now you blew it. Moderntopia isn't going to take you back no matter how many lies you start up for them.

kyrolos
19/01/2008, 09:22 AM
OMG please i want to Compile the script but it give me this error


C:\Program Files\Rockstar Games\GTA San Andreas\Samp Server\gamemodes\mtrp-final.pwn(14) : fatal error 100: cannot read from file: "a_sampmysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

i need the a_sampmysql file can any1 post a link to download it??

ODB
19/01/2008, 09:22 AM
(i cant belive im joining this argument) Joe, do you know what a two faced monkey means?, after all the shit you say about VG, now you go back and join them, and why? because he didnt get PD/FBI/admin on MT server, can i get a LOL at Joe? seriously people, you are all 20+ years old, but you act like babies. Stop the argument because everyone know that the so called VG script was made by the people who established the MT community, therefore you cant claim any rights for it. I hope that by this thread the argument will close, and this thread would be left for people who are actually interested in scripting.

reynolds1875
19/01/2008, 09:23 AM
You guys moan that they took the script from Valhalla? Well what ever they make is theres and they have the right to keep there own work.

Also Joe i thought you was a good guy when you was in our Vent channel slagging Valhalla off behind there back but it looks like you need to be sneaky about things.There are other ways of making freinds on the internet you know?

JDornatt
19/01/2008, 09:25 AM
Wrong.

Novice was the only person that helped with that script.. Shehab, Barely..


_


I was suppose to be one of the owners.. Until Tom got greedy and decided to put me in the dark (For Nothing), as he is doing/did with shehab.

-

Can I get a lol at the kid that dosnt know what the hell hes talking about?

reynolds1875
19/01/2008, 09:29 AM
WOW

Because you never got your own way you decided to back stab your freinds OMG

kyrolos
19/01/2008, 09:29 AM
guys any 1 have this fuile a_sampmysql [please if you have post it to me..or the link where i can get it

JDornatt
19/01/2008, 09:38 AM
Nobody Publicly released the script other than they're own selves.

Flaming in this thread forever isnt going to change anything.

I got Back stabbed by Tom.

This is just a lesson in life he will just have to learn.

Uhunu
19/01/2008, 09:43 AM
Haven't tested this but... I have to say fantastic. By looking at the features and the site you look very professional! Keep up the good work! :D

[FBI]AG3NT
19/01/2008, 10:21 AM
Hi, This script is very nice but I can't compile it :S

I have 13 errors :S
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1798) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1808) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1830) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1839) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1974) : error 017: undefined symbol "samp_mysql_free_result"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(10989) : error 017: undefined symbol "samp_mysql_strtok"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(10990) : error 017: undefined symbol "samp_mysql_strtok"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.

Can someone please post the .amx here ?

Thx

yaoantn
19/01/2008, 10:40 AM
AG3NT ]
Hi, This script is very nice but I can't compile it :S

I have 13 errors :S
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1798) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1808) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1830) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1839) : error 017: undefined symbol "samp_mysql_ping"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(1974) : error 017: undefined symbol "samp_mysql_free_result"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(10989) : error 017: undefined symbol "samp_mysql_strtok"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(10990) : error 017: undefined symbol "samp_mysql_strtok"
C:\DOKUME~1\Amaury\Desktop\SERVERS\Ag3nt\GAMEMO~1\ MTRP-F~1.PWN(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.

Can someone please post the .amx here ?

Thx

You need SQL server stop spamming thoose errors begginers cant Complie that..

[FBI]AG3NT
19/01/2008, 10:43 AM
What is it ? :S

yaoantn
19/01/2008, 10:45 AM
You have the files or MySQL installed in your computer?
or both?

Carl-
19/01/2008, 11:32 AM
OMG please i want to Compile the script but it give me this error


C:\Program Files\Rockstar Games\GTA San Andreas\Samp Server\gamemodes\mtrp-final.pwn(14) : fatal error 100: cannot read from file: "a_sampmysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

i need the a_sampmysql file can any1 post a link to download it??

Here: http://www.lostgangwarz.com/samp_mysql_en.php

Where can i download MySQL? Please

Grove
19/01/2008, 11:34 AM
Try Searching ;)

Carl-
19/01/2008, 11:35 AM
Try Searching ;)

Found it lol.

Carl-
19/01/2008, 11:55 AM
Help:
I have installed everything and it all works, except for MySQL, i have mysql but i cant use it lol. please can someone tell me how i can get it to work?

Zaka
19/01/2008, 12:22 PM
Nice one

Alex706
19/01/2008, 01:23 PM
Give instruction how to start this mod!

Zaka
19/01/2008, 01:39 PM
When i start samp-server.exe it says:
Script[gamemodes/gf.amx]: Run time error 19: "File or function is not found"

What's this, and who can help me?
this is fixed
Thanks,
Zaka

Zaka
19/01/2008, 01:44 PM
Yup, i do.

revenge
19/01/2008, 01:47 PM
Can't compile it.

C:\DOCUME~1\VEDAT\Desktop\Modlar\MTRP-F~1\MTRP-F~1.PWN(14) : fatal error 100: cannot read from file: "sampmysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

Zaka
19/01/2008, 02:02 PM
Alright i got it working. But i need help with the MySQL. I have a host with MySQL.
I've seen this lines:
[NVM]
But how do i put the host etc in. How does the 'code' know that it's from my host etc.
Can someone explain me this i really need this. Help is really needed
Never mind


Can't compile it.

C:\DOCUME~1\VEDAT\Desktop\Modlar\MTRP-F~1\MTRP-F~1.PWN(14) : fatal error 100: cannot read from file: "sampmysql"

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


1 Error.

Download this (http://liveyourlife.dotbas.net/Scripts/samp-mysql.zip) and follow the instructions (A file called installation-en.txt)

Thursday
19/01/2008, 03:08 PM
To all the people getting errors.. please read the first few pages, most of those errors are sorted out already.

Zaka
19/01/2008, 03:25 PM
Just want to know how to connect to my MySQL. Which i have from a hosting service.

mikkeman6000
19/01/2008, 04:17 PM
Damn it..
[19:24] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[19:24] MYSQL: Attempting to connect to server...
[19:24]
Connection to MySQL database: Failed !
[19:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[19:24] Error in mysql_select_db: MySQL server has gone away
[19:24] MYSQL: Connection error, retrying...
[19:24]
Connection to MySQL database: Failed !
[19:24] Can't connect to MySQL server on '127.0.0.1' (10061)
[19:24] Error in mysql_select_db: MySQL server has gone away
[19:24] MYSQL: Could not reconnect to server, terminating server...
[19:24] --- Server Shutting Down.
[19:24]
/**************************************************/
/* SAMP-MySQL v0.1 Plugin unloaded successfully ! */
/**************************************************/

Carl-
19/01/2008, 04:36 PM
Can someone try to remake this gamemode with a normal registrastion? because i have no idea how to use MySQL and a nice little registrastion will do me

ODB
19/01/2008, 04:41 PM
If you read the first posts, you will see "Luk0r" says he will help any1 with any problems, so just wait till he gets on, i am sure he can answer all your questions.

Zaka
19/01/2008, 04:55 PM
i made the tabels in PHPMyAdmin etc what now? can someone explain me how to put it in the code

mikkeman6000
19/01/2008, 05:18 PM
I downloaded XAMPP, its now running, I click samp-server, it says:
[20:26] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[20:26] MYSQL: Attempting to connect to server...
[20:26]
Connection to MySQL database: Successfull !
[20:26] Error in mysql_select_db: Unknown database 'samp'
[20:26] MYSQL: Database connection established.

I join my server, and my server just crashes...

mikkeman6000
19/01/2008, 05:27 PM
Hey what means database? What it is?

Zaka
19/01/2008, 05:28 PM
Hey what means database? What it is?

Your MySQL database.

mikkeman6000
19/01/2008, 05:38 PM
But what is the "samp" database?

Curynga
19/01/2008, 05:41 PM
This is one Godfather edited ? And add very options ? :D

Luk0r
19/01/2008, 05:45 PM
The first post pretty much explains the problems you're having.

Create a MySQL database named 'samp' and enter it, then execute the database.sql queries on it. To do this in PHPMyAdmin, click the Import tab and upload the file.

Change the #define MYSQL_* values at the top of the script to reflect your MySQL connection information. With XAMPP on Windows, the default is (host: 127.0.0.1) (user: root) (pass: <blank>) (db: <whatever you called it, probably 'samp'>).


I downloaded XAMPP, its now running, I click samp-server, it says:
[20:26] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[20:26] MYSQL: Attempting to connect to server...
[20:26]
Connection to MySQL database: Successfull !
[20:26] Error in mysql_select_db: Unknown database 'samp'
[20:26] MYSQL: Database connection established.

I join my server, and my server just crashes...


Your MySQL server is up, but you don't have the database prepared. Create the db and execute the SQL and you should be good.

mikkeman6000
19/01/2008, 05:59 PM
How do I run the .exe of PHPMyAdmin thing? I can't find it.

Luk0r
19/01/2008, 06:07 PM
How do I run the .exe of PHPMyAdmin thing? I can't find it.


http://localhost/phpmyadmin

Make sure you have Apache running on the XAMPP control panel.

mikkeman6000
19/01/2008, 06:15 PM
I click on that link and it gives me a error site..

mikkeman6000
19/01/2008, 06:26 PM
Ooh.. Now I got in the site.

Zaka
19/01/2008, 06:29 PM
man the mysql doesnt work :'( can someone make a ingame resgistration

mikkeman6000
19/01/2008, 06:41 PM
I made the database 'samp' in PHPMyAdmin, and now I get this:

[21:47] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[21:47] MYSQL: Attempting to connect to server...
[21:47]
Connection to MySQL database: Successfull !
[21:47] MYSQL: Database connection established.
[21:47] [sac] Auth servers are currently offline.
[21:48] [join] Ian_Lommi has joined the server (0:127.0.0.1)
[21:48] Error in mysql_query: Table 'samp.players' doesn't exist
[21:48] Error in mysql_store_result: Table 'samp.players' doesn't exist

Then my server crashes

mikkeman6000
19/01/2008, 06:44 PM
Ok, now I uploaded the database.sql thing and I connected to my server and it worked! WOOOOOOOT

Luk0r
19/01/2008, 06:50 PM
I made the database 'samp' in PHPMyAdmin, and now I get this:

[21:47] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[21:47] MYSQL: Attempting to connect to server...
[21:47]
Connection to MySQL database: Successfull !
[21:47] MYSQL: Database connection established.
[21:47] [sac] Auth servers are currently offline.
[21:48] [join] Ian_Lommi has joined the server (0:127.0.0.1)
[21:48] Error in mysql_query: Table 'samp.players' doesn't exist
[21:48] Error in mysql_store_result: Table 'samp.players' doesn't exist

Then my server crashes


http://i6.tinypic.com/6jwja4m.png

mikkeman6000
19/01/2008, 07:04 PM
Ok dude I did that, and now I do /register in my server, and nothing happens..

Luk0r
19/01/2008, 07:06 PM
/register <password>

mikkeman6000
19/01/2008, 07:10 PM
I did that, nothing happens after that

Luk0r
19/01/2008, 07:11 PM
That's weird, try /login <password> and see if it works.

Alex706
19/01/2008, 07:15 PM
Please! delete Mysql from this mod!
And all it will be good!

Luk0r
19/01/2008, 07:29 PM
I apologize a bit of effort is required to get this gamemode running, but it's really not that much work.

Zaka
19/01/2008, 07:33 PM
Yeah but i tried the MySQL and it didn't work. Is it hard to make a in-game registration?

Alex706
19/01/2008, 07:37 PM
It is possible the detailed instruction on the settlement of this mod!
If this possibly, on steps
1-
2-
3-

mikkeman6000
19/01/2008, 07:39 PM
I tried /login, but still nothing happens >:(

Luk0r
19/01/2008, 08:11 PM
Yeah but i tried the MySQL and it didn't work. Is it hard to make a in-game registration?


There is ingame registration.

Alex706
19/01/2008, 08:22 PM
Super gamemode!
At last at me all began to work!
All enormous thank you!

swat[786]
19/01/2008, 08:26 PM
Nce gamemode :D i gotta try this out :D

ty

Zaka
19/01/2008, 08:28 PM
Yeah but i tried the MySQL and it didn't work. Is it hard to make a in-game registration?


There is ingame registration.

Yes i know. I don't think you don't understand me. I mean that the savefiles being saved in scriptfiles directory.
But i guess that i said wrong :)
I'm gonna try to replace it.

Luk0r
19/01/2008, 08:30 PM
MySQL is a lot more efficient and uses less space. It's worth the extra effort.

Carl-
19/01/2008, 08:41 PM
MySQL is a lot more efficient and uses less space. It's worth the extra effort.

Luk0r, i dont know anything about MySQL, what do i download? i download MySQL Sever 5.0 but its command based and i cant do command based things lol. what shall i download?

Luk0r
19/01/2008, 08:54 PM
XAMPP.

Zaka
19/01/2008, 09:06 PM
MySQL is a lot more efficient and uses less space. It's worth the extra effort.

I know, and it's true. But i can't get it working :(

Carl-
19/01/2008, 09:21 PM
XAMPP.

I have that now, what do i do next?

Luk0r
19/01/2008, 10:26 PM
I've explained it all in the thread, just look around. :)

magicek
19/01/2008, 11:00 PM
Hello!
Ive got a problem: M:\gta sa multiplayer.exe\Ny mapp (2)\gamemodes\mtrp-final.pwn(14) : fatal error 100: cannot read from file: "a_sampmysql"
What should i do to fix the mtrp-final.amx?

Please help me!
Its sounds like a really good script!

mikkeman6000
20/01/2008, 12:04 AM
Nothing still happens when I type /register and /login.. I even registered to the site but still nothing...

Garteus
20/01/2008, 01:35 AM
-

Dark_Kostas
20/01/2008, 10:00 AM
Can someone give all game server ready with amx and all files in the right folders?I hate sql.I remember when i upload a Lineage server and it needs sql.I make 3 monthes to fix the sql.Plz someone upload all server ready.

mikkeman6000
20/01/2008, 10:05 AM
If someone would send you the files you would still gotta do the SQL stuff. I did the MySQL stuff yesterday and got it working but the login is bugged.

Dark_Kostas
20/01/2008, 10:08 AM
What you mean sql stuff.I read all replys and i see a photo about a program.But in instructions i see nothing about it.Tell me what to download and if you have already ok your server plz send me the files

Zaka
20/01/2008, 11:06 AM
--------

Alex706
20/01/2008, 11:11 AM
There is no nothing new in a script! there in general only LS!
Other cities do not work!

Zaka
20/01/2008, 12:33 PM
Alright i have a quick question. Will the save files be saved in a folder in my FTP?

Bpb
20/01/2008, 12:37 PM
Can anybody help me? I can't execute the .sql file from my sql client or phpMyAdmin ! There are many bugs and 'error in sql syntax' ! My sql is mysql-4.0.18-nt

Lidor Kalfa
20/01/2008, 12:58 PM
why did you remove the driving test? only questsions :X

ODB
20/01/2008, 03:09 PM
I think the driving test had an issue with it, when more than a few people attending it, that wouldve caused some people's checkpoints not working, etc...

Luk0r
20/01/2008, 04:43 PM
The full driving test always worked fine for me, but people were having issues with it so we disabled it and moved the location of the DMV. It's just a theory lesson and quiz now.

Zaka
20/01/2008, 04:53 PM
MySQL still not working for me. I tried everything out for this but i can't get it working. And yes i've seen and read those posts before.

JayC
20/01/2008, 04:58 PM
The problem with the driving test was the checkpoints. During the test we would get stick in a checkpoint and it wouldn't register.

Zaka
20/01/2008, 06:01 PM
I got it fixed. How do i make myself admin in here

Luk0r
20/01/2008, 06:21 PM
Set your admin level to 6 in the database using PHPMyAdmin.

You can then give others admin using /makeadmin.

Zaka
20/01/2008, 06:29 PM
Can't find it
Nvm I think i have it.

mikkeman6000
20/01/2008, 06:40 PM
Ffs.. /register isn't sill working..

Zaka
20/01/2008, 07:00 PM
Hey Luk0r,
Where can i get a MySQL (Or a host) that will work with this gamemode?
I really need info

Luk0r
20/01/2008, 09:24 PM
You can either get XAMPP (or something) to run on your own computer or a server, or you can use an external MySQL host.

reynolds1875
20/01/2008, 09:38 PM
I played on this script for about a week after server released but due to Valhalla taking the script it had to close and during my time in the server i was very impressed with the script.

Pug
20/01/2008, 11:51 PM
First: great script realy love it!

Second: stop the war against copyright, go do it somewhere else

Third: Please read the whole topic before asking stupid qeustions ( mysql compile error, where to place the .sql, where to download sql )
It makes the topic mesed up.

Fourth: Someone made a guide for this script? Like what commands there are and what they do?

Novice
20/01/2008, 11:56 PM
Fourth: Someone made a guide for this script? Like what commands there are and what they do?


Well since there is several unfinished components to the script, there was never a full list created for all the commands other than IG: /help and /manual (car ownership). I believe both of those cover a good portion of the commands.

Jashugan
21/01/2008, 02:02 AM
So no credits to Astro in there? More than half of whats in this script is his... And there are both dcmd and normal commands? Whats that about?

Zaka
21/01/2008, 02:16 PM
You can either get XAMPP (or something) to run on your own computer or a server, or you can use an external MySQL host.

And what if i'm using gta-host.com server?

Eazy
21/01/2008, 02:58 PM
Script is awesome,no doubt. 8)

Rafelder_GRF
21/01/2008, 03:11 PM
Really nice :D
Awesome script, i'll use it ^^
But the servermap link is down, can you upload the picture again?

Zaka
21/01/2008, 03:14 PM
Here you go:
800x600 (http://forums.moderntopia.com/servermap_small.jpg)
1591x1285 (http://forums.moderntopia.com/servermap.jpg)

But someone who can explain me MySQL? To get it on gta-host server

Rafelder_GRF
21/01/2008, 03:20 PM
Thank you very much :D

Zaka
21/01/2008, 03:25 PM
No problems ;)

Luk0r
21/01/2008, 04:28 PM
Really nice :D
Awesome script, i'll use it ^^
But the servermap link is down, can you upload the picture again?


Updated the OP with a new link.

mikkeman6000
21/01/2008, 06:31 PM
I STILL can't play... /register is not working.

Zaka
21/01/2008, 07:07 PM
Do you have MySQL?

Luk0r
22/01/2008, 07:57 AM
I STILL can't play... /register is not working.


I really have no idea why this is, nobody else is having this problem.

Try re-downloading the server package or something.

magicek
22/01/2008, 11:04 AM
Can someone post the mtrp-final.amx? my pawno doesnt work!

yaoantn
22/01/2008, 12:24 PM
Yes, I'm using the latest compiler... also I think the plugins load before the script right? Why is the plugin failing to load as well... this is kinda strange heh.

This is what it says when compiled:

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

Header size: 9504 bytes
Code size: 1539240 bytes
Data size: 5279856 bytes
Stack/heap size: 16384 bytes; estimated max. usage=4285 cells (17140 bytes)
Total requirements: 6844984 bytes


Because its SQL script!! for fuck sake the script not like the GodFather!!

Lidor Kalfa
22/01/2008, 12:58 PM
Yes, I'm using the latest compiler... also I think the plugins load before the script right? Why is the plugin failing to load as well... this is kinda strange heh.

This is what it says when compiled:

Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

Header size: 9504 bytes
Code size: 1539240 bytes
Data size: 5279856 bytes
Stack/heap size: 16384 bytes; estimated max. usage=4285 cells (17140 bytes)
Total requirements: 6844984 bytes


Because its SQL script!! for fuck sake the script not like the GodFather!!


its really not like godfather.. its much much better.. :)

Zaka
22/01/2008, 01:04 PM
Ofcourse with 50% more lines lol

But i have a question,,
how come there arent normal cars? there are only buyable cars and cars like police taxi etc..

magicek
22/01/2008, 01:07 PM
Zaka if you got the mtrp-final.amx can you please post it here? please!!!

Zaka
22/01/2008, 02:31 PM
Download .pwn&.amx here:
Click me (http://liveyourlife.dotbas.net/Scripts/Gamemodes/MTRP.zip)
Scriptfiles not included!

cvanderburgt
22/01/2008, 06:12 PM
What includes do I need? And also for Pen1: LS, what includes? I just don't understand that. And I don't know how to run this one, :'(

magicek
22/01/2008, 06:20 PM
Thank you Zaka now i have same problem as you had. (Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found") how should i do to fix that?

JayC
22/01/2008, 07:07 PM
Ofcourse with 50% more lines lol

But i have a question,,
how come there arent normal cars? there are only buyable cars and cars like police taxi etc..


You can add cars yourself. We decided it would have been better to make all cars buyable.

Zaka
22/01/2008, 07:38 PM
Ofcourse with 50% more lines lol

But i have a question,,
how come there arent normal cars? there are only buyable cars and cars like police taxi etc..


You can add cars yourself. We decided it would have been better to make all cars buyable.

Cool. Thanks for telling.


Thank you Zaka now i have same problem as you had. (Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found") how should i do to fix that?

Download sampmysql. I posted it few pages back.

magicek
22/01/2008, 07:41 PM
thx, now i have downloaded it but what should i do with it?

degika
22/01/2008, 09:27 PM
hi guys
how to create family and HQ ?

Pug
22/01/2008, 09:37 PM
Ive got a problem that everyone else has to have to that downloaded this script.
If you buy a car (/buycar) and get out of the car, step back in it says you have to buy it again. Thats no big deal but! if you try /buycar it doesnt say anything, u cant drive its frozen... You can only step out of the car and get back in if you type /park how come?

Chumillas
22/01/2008, 10:04 PM
Is the trucker job & and pizza boy job fixed?

All is running fine, but have some bugs, like original GM

degika
22/01/2008, 10:12 PM
guys my error /families dont work! /menu dont work /allowcreation dont work vs..
i think, all Family commands dont work
i cant create family and HQ how to creating Family

mikkeman6000
22/01/2008, 10:26 PM
What the.. /register won't work in any of my gamemodes in my server.

Luk0r
23/01/2008, 10:09 AM
But i have a question,,
how come there arent normal cars? there are only buyable cars and cars like police taxi etc..


It's a lot more realistic that way. If you want to place your own cars, there are a huge list of placeholder AddStaticVehicleEx lines somewhere in OnGamemodeInit(), just replace some of those with any cars you want to place that won't be included in the car ownership.


Ive got a problem that everyone else has to have to that downloaded this script.
If you buy a car (/buycar) and get out of the car, step back in it says you have to buy it again. Thats no big deal but! if you try /buycar it doesnt say anything, u cant drive its frozen... You can only step out of the car and get back in if you type /park how come?


We had that bug before with bikes, but NEVER with cars. Are you testing this with a bike?

dafel2
23/01/2008, 11:13 AM
[14:19]
[14:19] Moderntopia: Los Santos
[14:19] _____________________________
[14:19] By Moderntopia Scripting Team
[14:19]
[14:19] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[14:19] MYSQL: Attempting to connect to server...
[14:19]
Connection to MySQL database: Failed !
[14:19] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:19] Error in mysql_select_db: MySQL server has gone away
[14:19] MYSQL: Connection error, retrying...
[14:20]
Connection to MySQL database: Failed !
[14:20] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:20] Error in mysql_select_db: MySQL server has gone away
[14:20] MYSQL: Could not reconnect to server, terminating server...
[14:20] --- Server Shutting Down.
[14:20]
/**************************************************/
/* SAMP-MySQL v0.1 Plugin unloaded successfully ! */
/**************************************************/

WHY I HAVE THIS ? PLEASE HELP!

Lidor Kalfa
23/01/2008, 12:39 PM
there some "bug" the speedometer use GameText and so the fuel system.. when you turn on the fuel they not looks so good.. I think I'll try to do it with textdraw..

edit: another thing..

the speedometer is stupid too..

I got that:


if(distance <10)
{
format(string, 256, "~n~~n~~n~~n~~n~~n~~n~~g~mph : ~w~%.0f",distance);
}
if(distance > 10 && distance < 100)
{
format(string, 256, "~n~~n~~n~~n~~n~~n~~n~~g~mph : ~w~%.0f",distance);
}
if(distance > 100)
{
format(string, 256, "~n~~n~~n~~n~~n~~n~~n~~g~mph : ~w~%.0f",distance);
}


its stupid ,all the same.. just do it like that:


if(distance <10 || distance > 10 && distance < 100 || distance > 100)
{
format(string, 256, "~n~~n~~n~~n~~n~~n~~n~~g~mph : ~w~%.0f",distance);
}

magicek
23/01/2008, 04:50 PM
Can some1 tell me how i fix a mysql server i downloaded the plugin and xampp but i dont know where i should extract all files to. Please help me!

Pug
23/01/2008, 05:10 PM
Ive got a problem that everyone else has to have to that downloaded this script.
If you buy a car (/buycar) and get out of the car, step back in it says you have to buy it again. Thats no big deal but! if you try /buycar it doesnt say anything, u cant drive its frozen... You can only step out of the car and get back in if you type /park how come?


We had that bug before with bikes, but NEVER with cars. Are you testing this with a bike?

also with cars that come from the cardealer biz / job.
What ive done is sell a car (/sellcar [id] [price] and he bought it, drove in it got out wanted to get back in and nothing happend. Same bug as with the bikes.
Normaly i can take out these errors myselfe, but im busy with school dunno the word in english but i have to work 22 weeks at a company for school, after school i got my work so almost no time to sit and take a good look

cvanderburgt
23/01/2008, 05:22 PM
Ive got a problem that everyone else has to have to that downloaded this script.
If you buy a car (/buycar) and get out of the car, step back in it says you have to buy it again. Thats no big deal but! if you try /buycar it doesnt say anything, u cant drive its frozen... You can only step out of the car and get back in if you type /park how come?


We had that bug before with bikes, but NEVER with cars. Are you testing this with a bike?

also with cars that come from the cardealer biz / job.
What ive done is sell a car (/sellcar [id] [price] and he bought it, drove in it got out wanted to get back in and nothing happend. Same bug as with the bikes.
Normaly i can take out these errors myselfe, but im busy with school dunno the word in english but i have to work 22 weeks at a company for school, after school i got my work so almost no time to sit and take a good look


It's very anoying. When I was in Pug's new server I could re-enter! I had to walk -_-. O and HI PUG!

dafel2
23/01/2008, 05:36 PM
[14:19]
[14:19] Moderntopia: Los Santos
[14:19] _____________________________
[14:19] By Moderntopia Scripting Team
[14:19]
[14:19] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[14:19] MYSQL: Attempting to connect to server...
[14:19]
Connection to MySQL database: Failed !
[14:19] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:19] Error in mysql_select_db: MySQL server has gone away
[14:19] MYSQL: Connection error, retrying...
[14:20]
Connection to MySQL database: Failed !
[14:20] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:20] Error in mysql_select_db: MySQL server has gone away
[14:20] MYSQL: Could not reconnect to server, terminating server...
[14:20] --- Server Shutting Down.
[14:20]
/**************************************************/
/* SAMP-MySQL v0.1 Plugin unloaded successfully ! */
/**************************************************/

WHY I HAVE THIS ? PLEASE HELP!

mikkeman6000
23/01/2008, 05:45 PM
Someone help me, when I join my server with this gamemode on and I try to register, the /register won't work
Also same for other gamemodes.

oTTo
23/01/2008, 06:38 PM
How make families and gang zone wars...

Invisible
23/01/2008, 06:43 PM
Ive installed xampp but do i need to get mysql server too and where can i find it this is the errors i get when I compile

D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.

Zaka
23/01/2008, 08:36 PM
Did you edit something in the code? If yes re-download :)

mikkeman6000
23/01/2008, 09:18 PM
/register won't work in any gamemodes when I host a server, neither in this gamemode! Zaka, could you pack your sa-mp server folder and PM the link to me? Thanks.

Luk0r
24/01/2008, 09:00 AM
Ive installed xampp but do i need to get mysql server too and where can i find it this is the errors i get when I compile

D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.


Read the OP.

Alejandro
24/01/2008, 10:08 AM
Mirror (http://bwskilla.x10hosting.com/mtrp-final.zip)

dafel2
24/01/2008, 10:23 AM
[14:19]
[14:19] Moderntopia: Los Santos
[14:19] _____________________________
[14:19] By Moderntopia Scripting Team
[14:19]
[14:19] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[14:19] MYSQL: Attempting to connect to server...
[14:19]
Connection to MySQL database: Failed !
[14:19] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:19] Error in mysql_select_db: MySQL server has gone away
[14:19] MYSQL: Connection error, retrying...
[14:20]
Connection to MySQL database: Failed !
[14:20] Can't connect to MySQL server on '127.0.0.1' (10060)
[14:20] Error in mysql_select_db: MySQL server has gone away
[14:20] MYSQL: Could not reconnect to server, terminating server...
[14:20] --- Server Shutting Down.
[14:20]
/**************************************************/
/* SAMP-MySQL v0.1 Plugin unloaded successfully ! */
/**************************************************/
--------------------------------------------------------------------------------------
can someone help me ?

Zaka
24/01/2008, 01:24 PM
It has been said much times. And i will say it again. You need MySQL. Even in the topic title it says mysql..

dafel2
24/01/2008, 01:30 PM
i already have mysql plugin

Jashugan
24/01/2008, 02:12 PM
Not the plugin, you need the database installed and running.

djmightymark
24/01/2008, 06:53 PM
I have a problem compiling it

C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
C:\Documents and Settings\Mark\Bureaublad\mysqlm\samp022server.win3 2\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


9 Errors.


The plugin is not download

djmightymark
24/01/2008, 07:59 PM
everything is ok now.

i have the very biggest problem.

when is join my server i see my gamename in a black box.

when i type t i see that the gamemode is restarting.

but i didnt restart it?

someone nows?

djmightymark
24/01/2008, 08:20 PM
This problem even sold

Can someone put a working game in a rar or zip and upload it?


when i login my server it says please wait.

then my samp client crash

mikkeman6000
24/01/2008, 10:33 PM
/register won't work in my server's gamemodes, not in even this script.

Luk0r
25/01/2008, 02:29 AM
/register won't work in my server's gamemodes, not in even this script.


This problem isn't caused by the gamemode, so please take it to the support forum.

yaoantn
25/01/2008, 07:14 AM
Luk0r, I saw the DMV system, I tried to copy that but its not successed.
Could you give me the code?

djmightymark
25/01/2008, 02:00 PM
OK dudes i got it worked.

Does anyone need the working one?

if its ok with the gamemode makers i post a link with the whole server on it;)

you dont need to use msql-lite but the clean mysql on gangwars


greets

yaoantn
25/01/2008, 06:43 PM
I would like ;P

Luk0r
26/01/2008, 04:57 AM
Luk0r, I saw the DMV system, I tried to copy that but its not successed.
Could you give me the code?


What do you mean?

Brendan_Thomson
26/01/2008, 06:43 AM
Ive installed xampp but do i need to get mysql server too and where can i find it this is the errors i get when I compile

D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
D:\games\San Andreas\GTA San Andreas\sampserver\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.


I set this up on an Awardspace MySql and it is giving me these errors. How can I fix them?

Zaka
26/01/2008, 09:10 AM
where did you put your mysql things? (database,name,pass etc)

Lidor Kalfa
26/01/2008, 10:26 AM
its bugged.. the familys bugged.. and much more bugs..

its great mode ,but too much bugs (small and mad bugs..)

yaoantn
26/01/2008, 01:51 PM
I need the testing system

GTAScripter
26/01/2008, 02:41 PM
I cant get the MYSQL thing working. I have everything in the Modertopia.pwn made to my own mysql. Still wont work when i try to compile. I getting the errors that was said before.

jonboys
26/01/2008, 04:00 PM
hey SAMP forum users,

im using Moderntopia rp-final (MTRP-final)

but i need to know how i make people members of SAPT (taxi driver) and tht sort of thing.

and yes the serer is mysql so tht u know


thanks,
Jonathan & Ben

croherzegovina
26/01/2008, 04:26 PM
Hi! I have two questions!

Is it possible to copy accounts from old gf not modded to mysql database?

And is it possible to work without mysql like old gf mode?

Thank you!

-John-
26/01/2008, 07:26 PM
Hello, one question, i have these errors when i try to compile:

C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1798) : error 017: undefined symbol "samp_mysql_ping"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1808) : error 017: undefined symbol "samp_mysql_ping"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1830) : error 017: undefined symbol "samp_mysql_ping"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1839) : error 017: undefined symbol "samp_mysql_ping"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1911) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1929) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(1974) : error 017: undefined symbol "samp_mysql_free_result"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(2011) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(2012) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(2027) : error 017: undefined symbol "samp_mysql_real_escape_string"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(10989) : error 017: undefined symbol "samp_mysql_strtok"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(10990) : error 017: undefined symbol "samp_mysql_strtok"
C:\Documents and Settings\John Doe\Desktop\samp022server.win32(2)\gamemodes\mtrp-final.pwn(11097) : error 017: undefined symbol "samp_mysql_free_result"
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase


13 Errors.

Can someone pls give me a working a_sampmysql include ?

Thanx in advance...

Brendan_Thomson
26/01/2008, 07:49 PM
where did you put your mysql things? (database,name,pass etc)

#define MYSQL_HOST "db1.awardspace.com"

Under that section.

magicek
27/01/2008, 02:35 PM
Can somebody explane how to fix a mysql server ive got all files i think. but i dont know what i should do so the mysql server open the samp server. please explain or send me a easy tutorial.

Thanks/ Erik :)

-John-
27/01/2008, 03:35 PM
Ok i have edited the MySQL server info and compiled it, now i have this problem:

[17:43] MYSQL: Moderntopia MySQL Player Accounts v0.1 by Luk0r
[17:43] MYSQL: Attempting to connect to server...
[17:44]
Connection to MySQL database: Failed !
[17:44] Can't connect to MySQL server on 'www.balcan-stories.com' (10060)
[17:44] Error in mysql_select_db: MySQL server has gone away
[17:44] MYSQL: Connection error, retrying...
[17:44]
Connection to MySQL database: Failed !
[17:44] Can't connect to MySQL server on 'www.balcan-stories.com' (10060)
[17:44] Error in mysql_select_db: MySQL server has gone away
[17:44] MYSQL: Could not reconnect to server, terminating server...
[17:44] --- Server Shutting Down.
[17:44]

what should i do?

LethaL
27/01/2008, 06:42 PM
maybe replace 'www.balcan-stories.com with the ip ?

magicek
28/01/2008, 10:16 AM
Ive got some questions what should i wright in the a_sampmysql.inc?

native samp_mysql_connect(server[my ip], user[?], password[?]);
native samp_mysql_select_db(db[?]);
native samp_mysql_query(query[?]);
native samp_mysql_store_result();
native samp_mysql_fetch_row(line[?]);
native samp_mysql_num_rows(?);
native samp_mysql_num_fields(?);
native samp_mysql_ping(?);
native samp_mysql_real_escape_string(src[?], dest[?]);
native samp_mysql_free_result(?);
native samp_mysql_strtok(dest[?], separator[?], src[?]);
native samp_mysql_close(?);

Thanks.

007jami
28/01/2008, 01:32 PM
when i opened this mode i was seing this error in samp-server.exe windows.

Script[gamemodes/mtrp-final.amx]: Run Time Error 19: "File or function is not found"


What can i do?

-John-
28/01/2008, 01:41 PM
You need a MySQL server that is runing and you need to enter the database info in the mod on the top of the script, like this:
#define MYSQL_HOST "your mysql host"
#define MYSQL_USER "your mysql user"
#define MYSQL_PASS "your mysql password"
#define MYSQL_DB "your mysql database"

magicek
28/01/2008, 01:42 PM
You need the mysql server to open this mod. But i dont know how to start it :S

007jami
28/01/2008, 02:32 PM
How to start mysql server

-John-
28/01/2008, 02:35 PM
to run this mod you need basic MySQL knowledge or at least how to start your MySQL server, try using ******...

007jami
29/01/2008, 08:19 AM
I didnt find. Can you help me please?

ilia333
29/01/2008, 01:39 PM
can some one upload all server folder whith this mod and sql plugin pleas...
i know that i will have to connect to mysql ijust need all files whith mysql plugin on it
Big tnx to helper :'(

Megalon
29/01/2008, 02:56 PM
everytime i run my samp it says couldn't find any gamemode scripts am i missing something? also what do i need to compile?

magicek
29/01/2008, 03:05 PM
Ive got this problem the whole time :S please help me!

http://img139.imageshack.us/my.php?image=gtasampserver1ts4.png

Bpb
29/01/2008, 03:28 PM
Help me, i have a problem.
When i am running mod on my server, it is starts not completely. For example, mode name field in client not changes. But, mySQL loads succesfully. Then, when I go to my server, I can register, login, mode requests for my origin, and then nothing happens... I am freezed and can't do anything. I tried to unfreeze me by Xadmin, and went to places marked on HUD and found nothing there...
Then, when I am disconnecting, server says "Unknown column: Deagle".

My mySQL version is 5.0.18-nt, mode compiled succesfully and mySQL script imported succesfully too.


Sorry my bad english

mats
29/01/2008, 06:54 PM
when i go to a ! sometimes nothing shows up.
and the only job i found that i can join (because some ! are not working) is a car dealer??

ilia333
30/01/2008, 10:19 AM
pleas help me install this script add me to msn
admin@perffect-x.net
i will give you very nice web hosting for it...

ODB
30/01/2008, 02:04 PM
Most of those errors you are having have been solved on the first pages.. look for it.

reynolds1875
31/01/2008, 07:31 PM
I hate that when people ask something but they just have not read the thread,but on teh whole the script is real good.

lokome
01/02/2008, 04:56 AM
Dudes! I have this when i launch SAMP-SERVER.exe: Script[gamemodes/mtrp-final.amx]: Run time error 19: "File or function is not found"
: But i have mysql, i edited this script, in PAWNO, to my sql server settings, my plugin is working fine, and my .amx file is in gamemodes map, and with no errors compiled! I don`t know where is the prob! :(