[Capua]

Introduction

This tutorial covers up how to load object from MySQL (fast solution) instead of from scriptfiles or your gamemode.
Note: If you haven't set up your MySQL and Apache server yet, take a U-turn and find your way to MySQL tutorials. This tutorial is not aimed at persons with poor knowledge of MySQL.


What is required?

• BlueG's MySQL R7 plugin
• Have your server connected to MySQL
• Access to phpMyAdmin

Let's get started!

We'll add this to the top of our gamemode script:

pawn Код:

enum oInfo
{
    ScriptID,
    ModelID,
    Float:X,
    Float:Y,
    Float:Z,
    Float:rX,
    Float:rY,
    Float:rZ
};

new object[2000][oInfo];

I assume you have "mySQL_init();" inside OnGameModeInit, so under mySQL_init line add the following:

pawn Код:

print("**Now loading CreateDynamicObject SQL**");
mysql_function_query(1, "SELECT * FROM `objects`", true, "LoadObjects", "i", sizeof(object));

Then the biggest part:

pawn Код:

forward LoadObjects(limit);
public LoadObjects(limit)
{
    new count, rows, fields, data[50];
    cache_get_data(rows, fields);
    for(new i; i < rows; i++)
    {
        if(count > limit)
        {
            printf("Number of objects exceeded limit!");
            break;
        }
        for(new h; h < sizeof(object); h++)
        {
            if(object[h][ScriptID] == 0)
            {
                cache_get_field_content(i, "ScriptID", data); object[h][ScriptID] = strval(data);
                cache_get_field_content(i, "ModelID", data); object[h][ModelID] = strval(data);
                cache_get_field_content(i, "X", data); object[h][X] = floatstr(data);
                cache_get_field_content(i, "Y", data); object[h][Y] = floatstr(data);
                cache_get_field_content(i, "Z", data); object[h][Z] = floatstr(data);
                cache_get_field_content(i, "rX", data); object[h][rX] = floatstr(data);
                cache_get_field_content(i, "rY", data); object[h][rY] = floatstr(data);
                cache_get_field_content(i, "rZ", data); object[h][rZ] = floatstr(data);
                CreateDynamicObject(object[h][ModelID], object[h][X], object[h][Y], object[h][Z], object[h][rX], object[h][rY], object[h][rZ]);
                count++;
                break;
            }
        }
    }
    printf("Current objects on the server: %d",CountDynamicObjects());
    return 1;
}

Halfway through! Coding in your gamemode part is finished and you can compile.

Next step is to create a SQL table. It can be done with notepad etc etc, but I use Pawno.
So here's the code:

PHP код:

-- phpMyAdmin SQL Dump
-- version 4.2.7.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Oct 31, 2014 at 08:49 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `changeme`
--
-- --------------------------------------------------------
--
-- Table structure for table `objects`
--
CREATE TABLE IF NOT EXISTS `objects` (
`ScriptID` int(10) NOT NULL,
  `ModelID` int(10) NOT NULL,
  `X` float NOT NULL,
  `Y` float NOT NULL,
  `Z` float NOT NULL,
  `rX` float NOT NULL,
  `rY` float NOT NULL,
  `rZ` float NOT NULL,
  `Comment` varchar(30) NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;
INSERT INTO `objects` (`ScriptID`, `ModelID`, `X`, `Y`, `Z`, `rX`, `rY`, `rZ`, `Comment`) VALUES
(985, 777.942, -1330.18, 14.2512, 0, 0, -1, 'Chicago Outfit'),
(19410, 771.941, -1339.76, 14.2527, 0, 0, 90, 'Chicago Outfit'); 


Change "changeme" to whatever your database name is.
I've used 2 objects as example on how to place them in the code.


Now save the file as "objects.sql" and import it from phpMyAdmin into your already existing database. A new table named "objects" will appear in your database, inside "objects" there will be those 2 example objects, unless you changed them.

Congratulations! You have fully set up a fully functioning table for dynamic objects!



A tip:

If you have much objects you'd like to add, it would be time consuming to add them one by one. So copy & paste your object code, for example: CreateDynamicObject(14407, 1121.00830, -1194.85254, 27.83070, 0.00000, 0.00000, 90.26003); - then simply (if you use Pawno) press CTRL + H. First we need to replace CreateDynamicObject with nothing, so leave "Replace with:" empty. That was fast. Now for the part on the right, you could fully remove the "Comment" value to save time, or just suffer a bit and start editing with Replace function. I would do it like this: Replace ); with ), 'changeme'), - REMEMBER, the last line must have a semicolon in the end, every other object line has just a comma ( , ) in the ending.



Credits goes to [HiC]TheKiller for his in-game Object Maker