[GameMode] Clean, Simple MySQL GM..

Clean, Simple MySQL GM

A while ago i made a GM using djson, after that i was very busy with school, etc... so it took a while to release this GM
Here is a new GM with a simple MySQL system. Dynamic vehicles, icons, pickups, 3dlabels also using MySQL.

Contains:
* Uses MySQL to save stats and other shiznit
* Dynamic system - Add vehicles, map icons, 3d text labels, pickups with a command!
* Few admin commands ( Request commands if you want to )
* Set yourself to whatever admin level you want
* Dialog login - register
* Save location when you disconnect, load it when you spawn
* Type /Commands for a list
* Comes with around 780 vehicles saved!! ( You can of course delete them all with a single click )


Screen Shots:

^ Shows the dynamic 3d text labels and pickups


Credits:
G-Stylezzz - mysql plugin
Y_Less - sscanf
Incognito - streamer plugin
Zeex - zcmd
[HiC]TheKiller - Learned a lot from him!


Usage:
To run this gamemode, simply lauch samp.exe, all server files, includes, and plugins are included!
** To upload the .sql file, open phpmyadmin ( create a new DATABASE - Call it: mysql2 ), after you done that, click 'IMPORT' and browse through this .sql file ) **


Bugs | Problems:
IF you find a bug, or a problem report it here, and for more suggestions, post here.


Download:
Clean, Simple MySQL GM..

[TheYoungCapone]

omg nice i like the * Save location when you disconnect, load it when you spawn
thanks

[playbox12]

Good work nice to see more and more people, are using mysql!

Thanks, I've seen many people having trouble with MySQL and here is a simple one to start of with

[mevi]

when i spawn ingame, everything gets messy

[Georgelopez1]

Is this 3c?

Originally Posted by Georgelopez1

Is this 3c?

Yeah this is for .3c. About the messy screen, can you elaborate a little bit more..

[Ed2ka49]

I can't load the database on my Navicat for MYSQL. Do you know why?

[Err] 1046 - No database selected
[Err] --
-- Database: `mysql2`
--

-- --------------------------------------------------------

--
-- Table structure for table `labels`
--

CREATE TABLE IF NOT EXISTS `labels` (
  `LabelX` float NOT NULL,
  `LabelY` float NOT NULL,
  `LabelZ` float NOT NULL,
  `LabelInfo` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

Originally Posted by Ed2ka49

I can't load the database on my Navicat for MYSQL. Do you know why?

[Err] 1046 - No database selected
[Err] --
-- Database: `mysql2`
--

-- --------------------------------------------------------

--
-- Table structure for table `labels`
--

CREATE TABLE IF NOT EXISTS `labels` (
  `LabelX` float NOT NULL,
  `LabelY` float NOT NULL,
  `LabelZ` float NOT NULL,
  `LabelInfo` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully

You forgot to create the database, create one and name it: mysql2
After you done that, click on the newly created DB, and click 'Import'

[Aroldo]

Nice work man...I am gonna use this