Clean Script (MySQL) by RealCop228

Results 1 to 13 of 13
  1. #1
    Won again lol. propilot is offline
    MemberRank
    Jan 2010 Join Date
    CanadaLocation
    272Posts

    Clean Script (MySQL) by RealCop228


    Current Version: 2.1

    Introduction

    So let's break it down, 'eh? This is a "clean script" which has just enough to get you going on creating your own game-mode. It is "MySQL" based, so it allows for faster (in my opinion) saving and loading, not to mention easier to control. (just harder to script) This author of the script "RealCop228" is me, with some credits located at the end of this thread to the people who helped me - thanks guys!

    Some Insight

    I see a couple of these scripts around this forum, but maybe 2/10 utilize the significance of MySQL! People are too used to using file-based systems, such as Dini or Dudb, yet they fail to see the benefits of MySQL - which is what I'm trying to change. When using MySQL, you don't have to have a whole lot of disk-space for your files and it's a whole lot easier to manage them. Instead of needing to download files one-by-one, or searching through your directory's with FTP, you can log in to your MySQL database through a website. (e.g. www.example.com/phpmyadmin) You can simply add, remove and even modify the "fields" with the click of a couple buttons and keys on your keyboard! No need to search for specific fields like you would in a file-based system, simply scroll left and right until you see what you need - or organize the structure to your benefit. Of course, there are a lot more features available to you when using MySQL, but I won't waste your time you can search yourself.

    Current Features

    Considering what we discussed up above, using this script opens a lot of doors with the extent of using MySQL instead of file-based systems. Many features are included, but some, you need to do yourself - that's the whole point in "creating your own game-mode". This is what I've included already:

    * MySQL Account Saving/Loading
    * MySQL Enhanced Vehicle System (create and save cars in-game)
    * Position, Health, Armour, Score and Skin Saving
    * Whirlpool Hashed Password (impossible to crack a user password)
    * Server-Side Money (impossible to hack money)
    * Automatic High-Ping Kicker (definable)
    * Website Text-Draw Under Player's Money
    * Simple RP Commands (/b, /ooc, /me, /do)
    * 20+ Admin Commands
    * 5+ Player Commands

    I am always updating this script, adding more features along the way so expect more soon... While those features are nice, more still needs to be added. These features do work correctly and after 5+ hours of bug-fixing and testing if you do have any problems please let me know. I have utilized dialogs in these systems as well and plan to continue doing so for all future systems - keep that in mind.

    Installation Process

    The installation process varies from system to system, but I have tested this on my personal VPS which runs (Linux) Debian 5 32-bit and of course my home computer, running Windows 7 Ultimate 32-bit. I found running it on a Linux operating system easier then I imagined, you just need the correct plugins and skills to do so. I have included all of the necessary files and folders for both operating systems, just keep in mind that you may need separate plugins for a 64-bit version of Linux. I'll assume that you know the basics of setting up the server itself on both platforms. When you begin editing the 'server.cfg' line, you must leave the "plugins" line alone, as tampering with it could cause the script not to run. If you don't know already, you must have a MySQL database available to you with the ability to run an SQL query and create tables. Included in the download files, you will find a text file called "MySQL Database Dump", open it, select all of the text and copy it to your clipboard. (CTRL+C) Open your phpMyAdmin database (or whatever you use) and go to the "SQL" section. Paste (CTRL+V) all of the text you just copied into the blank white box and hit "go" or "save". You should have created the tables for the server in your database. Open the script and edit the settings as stated and also configure your MySQL information so the server can connect to the database. If you are confused, ask here and somebody (or I) will help you. If requested enough, I will add a video tutorial with me speaking - not text.

    Special Thanks

    Just a quick thank you to a couple people who helped get this production going.

    * Calgon
    * G-Stylez
    * The Toni
    * Agent Smith
    * Y_Less
    * Cameltoe
    * iLinux
    * playbox12
    * Mimic
    * Kye
    * SA-MP Community
    * FlyingSander


    Download




    *********.com - Get your share!




    *********.com - Get your share!
    Last edited by propilot; 19-11-10 at 04:18 PM.


  2. #2
    Enthusiast HeLMaX is offline
    MemberRank
    Nov 2010 Join Date
    49Posts

    Re: Clean Script (MySQL) by RealCop228

    Okay that's the thing that I need yea?

    EDIT:
    Fix the links:
    Code:
    Not Found
    
    The requested URL /releases/Clean Script was not found on this server.
    Last edited by HeLMaX; 19-11-10 at 01:24 PM.

  3. #3
    Won again lol. propilot is offline
    MemberRank
    Jan 2010 Join Date
    CanadaLocation
    272Posts

    Re: Clean Script (MySQL) by RealCop228

    Quote Originally Posted by HeLMaX View Post
    Okay that's the thing that I need yea?

    EDIT:
    Fix the links:
    Code:
    Not Found
    
    The requested URL /releases/Clean Script was not found on this server.
    fixed

  4. #4
    Alpha Member bramdebouvere is offline
    MemberRank
    Aug 2006 Join Date
    BelgiumLocation
    2,409Posts

    Re: Clean Script (MySQL) by RealCop228

    ok no offence, but file i/o is actually faster then mysql (edit: only a little bit though)

    BUT

    mysql has several things that make it a good choice:
    -you can use the database with a website
    -you can easely run some queries on all players
    -you can use advanced queries for things you can't do with file I/O
    -with mysql you can let the database work for you, so you don't need to filter any data you don't need

    oh, thanks for the release :)

  5. #5

    Re: Clean Script (MySQL) by RealCop228

    Quote Originally Posted by propilot View Post
    fixed
    What do you fixed ?
    Code:
    Not Found
    
    The requested URL /releases/Clean Script was not found on this server.

  6. #6
    Apprentice Homicide is offline
    MemberRank
    Dec 2010 Join Date
    13Posts

    Re: Clean Script (MySQL) by RealCop228

    very Niceee,

  7. #7
    Apprentice QWxx01 is offline
    MemberRank
    Dec 2010 Join Date
    the NetherlandsLocation
    5Posts

    Re: Clean Script (MySQL) by RealCop228

    Links are not working? Care to re-upload?

  8. #8
    I need money in RS. Help? TiMxD is offline
    MemberRank
    Jun 2010 Join Date
    MineCraftLocation
    539Posts

    Re: Clean Script (MySQL) by RealCop228

    They obviously not working because you bumped an old thread, curse you.

  9. #9
    Apprentice QWxx01 is offline
    MemberRank
    Dec 2010 Join Date
    the NetherlandsLocation
    5Posts

    Re: Clean Script (MySQL) by RealCop228

    Quote Originally Posted by TiMxD View Post
    They obviously not working because you bumped an old thread, curse you.
    What's so obvious about that? Why curse me? What's up with your attitude?

  10. #10
    Alpha Member bramdebouvere is offline
    MemberRank
    Aug 2006 Join Date
    BelgiumLocation
    2,409Posts

    Re: Clean Script (MySQL) by RealCop228

    Guys, guys, keep it easy :p

    i'll pm propilot to ask if he reuploads

  11. #11
    I need money in RS. Help? TiMxD is offline
    MemberRank
    Jun 2010 Join Date
    MineCraftLocation
    539Posts

    Re: Clean Script (MySQL) by RealCop228

    Quote Originally Posted by QWxx01 View Post
    What's up with your attitude?
    I was pissed because my computer kept saying the same thing it's been saying for the past 6-7 months.

    "Windows Explorer has stopped working."

    Go away Windows Vista!

  12. #12
    Novice magneto is offline
    MemberRank
    Sep 2012 Join Date
    Sakiai, LithuanLocation
    1Posts

    Re: [Release] Clean Script (MySQL) by RealCop228

    thanks

  13. #13
    Won again lol. propilot is offline
    MemberRank
    Jan 2010 Join Date
    CanadaLocation
    272Posts

    Re: Clean Script (MySQL) by RealCop228

    Didn't pay my server bills, therefore its down. ( bills are over 600 dollars lmao )



Advertisement