[[L3th4l]]

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
****** - 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!

[[L3th4l]]

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?

[[L3th4l]]

Quote:

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

[[L3th4l]]

Quote:

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

[CoaPsyFactor]

Quote:

Originally Posted by playbox12 Good work nice to see more and more people, are using mysql!

my whole script is mysql based, it is roleplay script, everything is dynamic, jobs, pickups, map icons, vehicles, houses, business etc

[Rocketeer]

How can i view all my data? what program do i use?
I got it to work. This is a very good begging script, i had no idea what mysql is or was, until i opened this up, followed directions and now i know something, thanks a lot!

[Rocketeer]

Sorry, but the only thing that works are 3dlabel.
Cars - don't save.
Pickups - don't save.

[[L3th4l]]

EDIT: You are actually correct, re-download new version!

[Anthonyx3']

You should add vehicle ownership will help alot of people trying to learn mysql out ^^, like me xD. Nice gamemode, ive been reading it over and over to learn more about saving/loading.

[Rocketeer]

Yeah i fixed it, thanks a lot mate!

[XFlawless]

Nice GM release !

[[L3th4l]]

Quote:

Originally Posted by Meyer Nice GM release !

Thanks

I'll add a vehicle ownership system when i have time!

[Rocketeer]

Lethal, how am i able to change someones passsword?

[[L3th4l]]

Try this command:

pawn Код:

CMD:changepass(playerid, params[])
{
    new
        EscPass[40],
        Query[128],
        iStr[55];

    if(isnull(params)) return SendClientMessage(playerid, -1, ""#CRED"Usage: "#CORANGE"/ChangePass < New Password >");

    mysql_real_escape_string(params, EscPass);
    format(Query, sizeof(Query), "UPDATE `playerinfo` SET `password` = md5('%s') WHERE `user` = '%s'", EscPass, pName(playerid));
    mysql_query(Query);
    
    format(iStr, sizeof(iStr), "You've changed your password to: "#CBLUE"%s", params);
    SendClientMessage(playerid, -1, iStr);
    return 1;
}