SA-MP Forums Archive
[GameMode] eB Gaming ~ Gangwars (MySQL, Map Changing) - 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] eB Gaming ~ Gangwars (MySQL, Map Changing) (/showthread.php?tid=401148)

Pages: 1 2


eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 21.12.2012

NOTICE: This server was first called SAMP Battlefield. It then changed to eB Gaming ~ Gangwars after around 2 months, to try and revive the project. (It didn't work well, wasn't active enough ).

Hello!

Today I have decided to release one of my well liked scripts. It's a TDM and based vaguely *around* battlefield.
The server contains 45 ranks - each one being all of the real Battlefield 3 ranks. These ranks are decided upon how many kills/exp your account has.

What's so special about this script?
Well, I believe it's one of the best TDM servers available. I really do. I'm not sure if anyone else thinks the same - I didn't have much time to show everyone the server, as it's popularity did not last very long, thus another reason of why I am releasing it.


Features
Dynamic Map System
The map system on this script is my favourite, and most unique part. Maps can be dynamically added or deleted.
All maps are stored in the /scriptfiles/Maps/ folder with the extension: .map <example.map> - These .map files can be MADE in MTA Map Editor, without the need of converting. A simple drag & drop!

Along with adding the .map file to the server, you add a line to the MySQL Database, which stores data for the map, such as the ID, how many times it's been played, team skins, team spawns and some more information which is needed for the map system!

Structure of the map system database: http://i.imgur.com/7vYb5.png [WARNING: Large width resolution]


I have no experience in running samp servers or using mysql!
Hey. Sadly I do not give support since I do not have much time. If you are not experienced in setting up/using SAMP servers or with low knowledge of MySQL - I really do NOT recommend downloading this script. You should read up on some guides or tutorials beforehand, so you know the basics before spamming this thread posting errors you shouldn't be receiving.


Some media from old server
This will give you a *tiny* insight of what SAMP Battlefield is. A few pictures and a video which I used to advertise the server back in May!

[ame]http://www.youtube.com/watch?v=lFrSFdzxanY[/ame]
(Sorry for such bad quality. That is the FIRST map I ever added. It sucks - You can make ALOT better maps.)

* I thought I had some screenshots. If I find them, i'll be sure to add them soon! *


Credits
Download


Windows Package (Everything!)
REMOVED, sorry.


Setup
I do not give out support, so sadly this is as much help as I will give you:
  1. Download the package from the link above
  2. Download the database file
  3. Import the database file to a MySQL server
  4. Enter the MySQL server details in the script
  5. Compile the script
  6. Edit the server.cfg to your standards
  7. Start the server. It should now run (Windows only).



Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Jernu - 21.12.2012

Wow! Thanks Pizzy!

Best TDM server of the time.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - XtremeR - 21.12.2012

greatest one, +6 reps


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 22.12.2012

Thanks for the comments.

I forgot to add the database download link, it's now up.

Remember: You need the server files + the database for the server to work!


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Jernu - 22.12.2012

Need to re-upload the Database.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 22.12.2012

Done! Re-uploaded it.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Xoomer - 22.12.2012

Ok Great Awesome GM 1000/10 rep for you

*
what mysql version is this ?


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 22.12.2012

Quote:
Originally Posted by Xoomer
View Post
Ok Great Awesome GM 1000/10 rep for you

*
what mysql version is this ?
I'm not too sure. The plugins are included so if you download it you can check.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - McFellow - 22.12.2012

There is a bug when you try to spawn it's says: Stay within the world boundries


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 22.12.2012

Quote:
Originally Posted by McFellow
View Post
There is a bug when you try to spawn it's says: Stay within the world boundries
Did you setup the mysql database? It needs the mysql database set up before it can be used, since it gets the data from it.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - McFellow - 22.12.2012

Ok I did it here is the server log
Code:
SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[00:32:35] weburl = "www.sa-mp.com"  (string)
[00:32:35] 
[00:32:35] Server Plugins
[00:32:35] --------------
[00:32:35]  Loading plugin: mysql
[00:32:35] 

  > MySQL plugin R5 successfully loaded.

[00:32:35]   Loaded.
[00:32:35]  Loading plugin: sscanf
[00:32:35] 

[00:32:35]  ===============================

[00:32:35]       sscanf plugin loaded.     

[00:32:35]    © 2009 Alex "Y_Less" Cole

[00:32:35]    0.3d-R2 500 Players "dnee"

[00:32:35]  ===============================

[00:32:35]   Loaded.
[00:32:35]  Loaded 2 plugins.

[00:32:35] 
[00:32:35] Filterscripts
[00:32:35] ---------------
[00:32:35]   Loaded 0 filterscripts.

[00:32:35] OnGameo
[00:32:35] [MYSQL]: Connection to `gangwars` succesful!
[00:32:35] ID: 1, ID2: 1, Name: Pizzy's TDM #1, Author: Pizzy, MapName: P_TDM1.map
[00:32:35] ID: 2, ID2: 2, Name: Blue_BattleOfTheOcean, Author: [Boobs]Blue, MapName: Blue_BattleOfTheOcean.map
[00:32:35] ID: 3, ID2: 3, Name: Mexicans vs Police, Author: [Boobs]Blue, MapName: Blue_MexicansVsPolice.map
[00:32:35] ID: 4, ID2: 4, Name: Berlin1945, Author: 0xSATANx0, MapName: Berlin1945.map
[00:32:35] ID: 5, ID2: 5, Name: Arena_91, Author: XX3, MapName: arena_91.map
[00:32:35] ID: 6, ID2: 6, Name: Fight For The Centre, Author: Pizzy, MapName: FightForTheCentre.map
[00:32:35] ID: 7, ID2: 7, Name: LVDam Wankers, Author: Pizzy, MapName: LVDAMWankers.map
[00:32:35] ID: 8, ID2: 8, Name: D-DAY, Author: [Boobs]Bolt, MapName: d-day.map
[00:32:35] ID: 9, ID2: 9, Name: Farm Assault, Author: Habdel, MapName: habdelFarm.map
[00:32:35] ID: 10, ID2: 10, Name: Fastfood Fight, Author: Pizzy, MapName: fastfoodfight.map
[00:32:35] ID: 11, ID2: 11, Name: Nuclear Plant, Author: [Boobs]Gzsume, MapName: Nuclear_Plant.map
[00:32:35] ID: 12, ID2: 12, Name: Bridge War, Author: [Boobs]Kenneth, MapName: BridgeWar.map
[00:32:35] ID: 13, ID2: 13, Name: Pirate Ship, Author: [Boobs]Kenneth, MapName: PirateShip.map
[00:32:35] ID: 14, ID2: 14, Name: Ship Wars, Author: [Boobs]Kenneth, MapName: ShipWars.map
[00:32:35] ID: 15, ID2: 15, Name: Forest, Author: [Boobs]Kenneth, MapName: Forest.map
[00:32:35] ID: 16, ID2: 16, Name: G20 Clusterfuck, Author: Bolt, MapName: G20_Clusterfuck.map
[00:32:35] ID: 17, ID2: 17, Name: Ballas Vs Grove, Author: Overkill, MapName: BallasVsGrove.map
[00:32:35] ** A total of 17 maps were loaded. **
[00:32:35] 2 items loaded from 'Maps/P_TDM1.map' in 0ms
[00:32:35] [MAP ID: 1] Pizzy's TDM #1 by Pizzy loaded!
[00:32:35] ================
[00:32:35] eB Gaming ~ Gangwars by Pizzy
[00:32:35] ================
[00:32:35] Number of vehicle models: 2
But still if I want to spawn it says: Stay within the world boundries


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 22.12.2012

That's really weird. I'm not sure why it would say that.. - It's something wrong with spawning? But if it's connecting to the database fine, then it shouldn't have any trouble.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Morkano - 23.12.2012

where can i put database file


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - yaron0600 - 23.12.2012

Good but How use the MySql Idk


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - McFellow - 23.12.2012

Well if you want to set-up your MYSQL use XAMPP Control Panel if you downloaded it turn on Apache and MYSQL then go to localhost/phpmyadmin and then you make a Datebase there


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Morkano - 23.12.2012

Code:
SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[01:36:45] 
[01:36:45] Server Plugins
[01:36:45] --------------
[01:36:45]  Loading plugin: sscanf
[01:36:45] 

[01:36:45]  ===============================

[01:36:45]       sscanf plugin loaded.     

[01:36:45]    © 2009 Alex "Y_Less" Cole

[01:36:45]    0.3d-R2 500 Players "dnee"

[01:36:45]  ===============================

[01:36:45]   Loaded.
[01:36:45]  Loading plugin: mysql
[01:36:45] 

  > MySQL plugin R5 successfully loaded.

[01:36:45]   Loaded.
[01:36:45]  Loaded 2 plugins.

[01:36:45] 
[01:36:45] Filterscripts
[01:36:45] ---------------
[01:36:45]   Loading filterscript 'Untitled.amx'...
[01:36:45]   Loaded 1 filterscripts.

[01:36:45] OnGameo
[01:36:46] [MYSQL]: [ERROR]: Connection to `` failed!
[01:36:46] ** A total of -1 maps were loaded. **

errors server log


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 23.12.2012

Quote:
Originally Posted by Morkano
View Post
Code:
SA-MP Dedicated Server
----------------------
v0.3e, ©2005-2012 SA-MP Team

[01:36:45] 
[01:36:45] Server Plugins
[01:36:45] --------------
[01:36:45]  Loading plugin: sscanf
[01:36:45] 

[01:36:45]  ===============================

[01:36:45]       sscanf plugin loaded.     

[01:36:45]    © 2009 Alex "Y_Less" Cole

[01:36:45]    0.3d-R2 500 Players "dnee"

[01:36:45]  ===============================

[01:36:45]   Loaded.
[01:36:45]  Loading plugin: mysql
[01:36:45] 

  > MySQL plugin R5 successfully loaded.

[01:36:45]   Loaded.
[01:36:45]  Loaded 2 plugins.

[01:36:45] 
[01:36:45] Filterscripts
[01:36:45] ---------------
[01:36:45]   Loading filterscript 'Untitled.amx'...
[01:36:45]   Loaded 1 filterscripts.

[01:36:45] OnGameo
[01:36:46] [MYSQL]: [ERROR]: Connection to `` failed!
[01:36:46] ** A total of -1 maps were loaded. **

errors server log
You need to setup a mysql server and import the database which is available to download on the thread.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Nicholas. - 23.12.2012

Nice release.


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - Pizzy - 24.12.2012

Thanks.

@McFellow: Are you still having trouble with starting the server?


Re: eB Gaming ~ Gangwars (MySQL, Map Changing) - PureGaming - 24.12.2012

Nice, Pizzy, I'm glad you're an owner at Empire Bay Gaming :] I've played SFRP a couple of times during the beta.