[GameMode] Clean, Simple MySQL GM..

[GameMode] Clean, Simple MySQL GM.. - 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] Clean, Simple MySQL GM.. (/showthread.php?tid=208733)

Pages: 1 2

Clean, Simple MySQL GM.. - [L3th4l] - 09.01.2011

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..

Re: Clean, Simple MySQL GM.. - TheYoungCapone - 09.01.2011

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

Re: Clean, Simple MySQL GM.. - playbox12 - 09.01.2011

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

Re: Clean, Simple MySQL GM.. - [L3th4l] - 09.01.2011

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

Re: Clean, Simple MySQL GM.. - mevi - 10.01.2011

when i spawn ingame, everything gets messy

Re: Clean, Simple MySQL GM.. - Georgelopez1 - 14.01.2011

Is this 3c?

Re: Clean, Simple MySQL GM.. - [L3th4l] - 14.01.2011

Quote:

Originally Posted by Georgelopez1

Is this 3c?

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

Re: Clean, Simple MySQL GM.. - Ed2ka49 - 15.01.2011

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

Re: Clean, Simple MySQL GM.. - [L3th4l] - 15.01.2011

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'

Re: Clean, Simple MySQL GM.. - Aroldo - 23.01.2011

Nice work man...I am gonna use this

Re: Clean, Simple MySQL GM.. - CoaPsyFactor - 23.01.2011

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

Re: Clean, Simple MySQL GM.. - Rocketeer - 25.01.2011

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!

Re: Clean, Simple MySQL GM.. - Rocketeer - 25.01.2011

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

Re: Clean, Simple MySQL GM.. - [L3th4l] - 25.01.2011

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

Re: Clean, Simple MySQL GM.. - Anthonyx3' - 25.01.2011

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.

Re: Clean, Simple MySQL GM.. - Rocketeer - 25.01.2011

Yeah i fixed it, thanks a lot mate!

Re: Clean, Simple MySQL GM.. - XFlawless - 26.01.2011

Nice GM release !

Re: Clean, Simple MySQL GM.. - [L3th4l] - 26.01.2011

Quote:

Originally Posted by Meyer

Nice GM release !

Thanks

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

Re: Clean, Simple MySQL GM.. - Rocketeer - 31.01.2011

Lethal, how am i able to change someones passsword?

Re: Clean, Simple MySQL GM.. - [L3th4l] - 31.01.2011

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;
}