SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 09/01/2011, 05:55 AM   #1
[L3th4l]
Guest
 
Posts: n/a
Default 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..

Last edited by [L3th4l]; 25/01/2011 at 10:51 PM.
  Reply With Quote
Old 09/01/2011, 05:57 AM   #2
TheYoungCapone
Gangsta
 
TheYoungCapone's Avatar
 
Join Date: Nov 2010
Posts: 739
Reputation: 84
Default Re: Clean, Simple MySQL GM..

omg nice i like the * Save location when you disconnect, load it when you spawn
thanks
__________________
- Click HERE to subscribe to my youtube channel.
- Need help with SetObjectMaterial? Click HERE
- Need help using Jernejl's map editor? Click HERE
for a tutorial showing the basics.
- Mapper for hire, pm me if interested.
- Click HERE to see my releases.
TheYoungCapone is offline   Reply With Quote
Old 09/01/2011, 12:54 PM   #3
playbox12
High-roller
 
playbox12's Avatar
 
Join Date: Feb 2010
Location: Netherlands
Posts: 1,639
Reputation: 213
Default Re: Clean, Simple MySQL GM..

Good work nice to see more and more people, are using mysql!
playbox12 is offline   Reply With Quote
Old 09/01/2011, 08:26 PM   #4
[L3th4l]
Guest
 
Posts: n/a
Default Re: Clean, Simple MySQL GM..

Thanks, I've seen many people having trouble with MySQL and here is a simple one to start of with
  Reply With Quote
Old 10/01/2011, 06:16 AM   #5
mevi
Huge Clucker
 
mevi's Avatar
 
Join Date: Feb 2009
Location: Vinewood
Posts: 281
Reputation: 30
Default Re: Clean, Simple MySQL GM..

when i spawn ingame, everything gets messy
__________________
.
mevi is offline   Reply With Quote
Old 14/01/2011, 04:59 PM   #6
Georgelopez1
Huge Clucker
 
Georgelopez1's Avatar
 
Join Date: Sep 2010
Posts: 215
Reputation: 0
Default Re: Clean, Simple MySQL GM..

Is this 3c?
Georgelopez1 is offline   Reply With Quote
Old 14/01/2011, 09:10 PM   #7
[L3th4l]
Guest
 
Posts: n/a
Default Re: Clean, Simple MySQL GM..

Quote:
Originally Posted by Georgelopez1 View Post
Is this 3c?
Yeah this is for .3c. About the messy screen, can you elaborate a little bit more..
  Reply With Quote
Old 15/01/2011, 01:21 PM   #8
Ed2ka49
Big Clucker
 
Join Date: Jan 2009
Posts: 75
Reputation: 0
Default Re: Clean, Simple MySQL GM..

I can't load the database on my Navicat for MYSQL. Do you know why?
Code:
[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
Ed2ka49 is offline   Reply With Quote
Old 15/01/2011, 09:33 PM   #9
[L3th4l]
Guest
 
Posts: n/a
Default Re: Clean, Simple MySQL GM..

Quote:
Originally Posted by Ed2ka49 View Post
I can't load the database on my Navicat for MYSQL. Do you know why?
Code:
[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'
  Reply With Quote
Old 23/01/2011, 11:09 AM   #10
Aroldo
Little Clucker
 
Join Date: Nov 2010
Posts: 8
Reputation: 1
Default Re: Clean, Simple MySQL GM..

Nice work man...I am gonna use this
Aroldo is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Tutorial] Creating a MySQL account system (Simple) Carlton Tutorials 13 19/07/2014 06:45 AM
[Include] C-MYSQL (Remade) - Increased Speed & More Simple Carlton Includes 55 12/07/2013 09:13 AM
File or Function is not found, Clean MYSQL Script Triple X Server Support 1 01/01/2011 09:54 AM
Simple MySQL reading crashes the Server virtualmarc Help Archive 4 20/09/2009 02:28 PM


All times are GMT. The time now is 05:25 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.