[FilterScript] Dynamic Entrance System![MYSQL]
#12

Looks alright.
My suggestion:
pawn Код:
function CreateMySQLConnection(host[], user[], db[], pass[])
{
    mysql_connect(host, user, db, pass);
   
    if (mysql_ping() >= 1)
    {
        print("INFO: Connected To MySQL!");
    }
    else
    {
        print("INFO: Can't Connect To MySQL!");
    }
mysql_query("CREATE TABLE IF NOT EXISTS `entrances` ( \
  `ID` int(3) NOT NULL, \
  `Name` varchar(25) NOT NULL, \
  `X` float NOT NULL, \
  `Y` float NOT NULL, \
  `Z` float NOT NULL, \
  `exitX` float NOT NULL, \
  `exitY` float NOT NULL, \
  `exitZ` float NOT NULL, \
  `Interior` int(5) NOT NULL, \
  `VirtualW` int(3) NOT NULL \
) ENGINE=InnoDB DEFAULT CHARSET=latin1;"
);
}
The plugin will be almost plug & play.
Not sure if you won't need to join strings.
I think it's the best(coded, not featured) released entrance system.
+ You should add a command /createinterior (which automaticly saves it into mysql). That way people could add different places dynamically.
Reply


Messages In This Thread
Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 12:41
Re: Dynamic Entrance System![MYSQL] - by [GTA]AmericanGangster - 16.09.2011, 12:52
Re: Dynamic Entrance System![MYSQL] - by -CaRRoT - 16.09.2011, 12:53
Re: Dynamic Entrance System![MYSQL] - by Issam - 16.09.2011, 12:55
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 12:57
Re: Dynamic Entrance System![MYSQL] - by Scottas - 16.09.2011, 13:02
Re: Dynamic Entrance System![MYSQL] - by Montis123 - 16.09.2011, 13:05
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 13:08
Re: Dynamic Entrance System![MYSQL] - by System64 - 16.09.2011, 13:42
Re: Dynamic Entrance System![MYSQL] - by Z0mBie - 16.09.2011, 13:43
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 14:20
Re: Dynamic Entrance System![MYSQL] - by wups - 16.09.2011, 15:10
Re: Dynamic Entrance System![MYSQL] - by Scottas - 16.09.2011, 15:27
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 15:29
Re : Dynamic Entrance System![MYSQL] - by Naruto_Emilio - 16.09.2011, 15:50
Re: Dynamic Entrance System![MYSQL] - by Fires - 16.09.2011, 16:33
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 17:35
Re: Dynamic Entrance System![MYSQL] - by wups - 16.09.2011, 17:35
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 17:40
Re: Dynamic Entrance System![MYSQL] - by Scottas - 16.09.2011, 17:57
Re: Dynamic Entrance System![MYSQL] - by Raimis_R - 16.09.2011, 18:02
Re: Dynamic Entrance System![MYSQL] - by jtweak - 28.11.2011, 04:36
Re: Dynamic Entrance System![MYSQL] - by Hugh G. Reckshun - 29.12.2011, 17:09
Re: Dynamic Entrance System![MYSQL] - by Jochemd - 29.12.2011, 17:10
Respuesta: Dynamic Entrance System![MYSQL] - by XxX(cena)XxX - 20.04.2012, 00:53
Re: Dynamic Entrance System![MYSQL] - by Lorenzo* - 08.07.2012, 05:04
Re: Dynamic Entrance System![MYSQL] - by alanhutch - 26.10.2012, 12:50
Re: Dynamic Entrance System![MYSQL] - by NoahF - 27.10.2012, 12:23
Re: Dynamic Entrance System![MYSQL] - by prisonliferp - 13.01.2013, 18:48
Re: Dynamic Entrance System![MYSQL] - by ajam123 - 06.04.2013, 02:23
Re: Dynamic Entrance System![MYSQL] - by yvoms - 19.11.2015, 19:49

Forum Jump:


Users browsing this thread: 5 Guest(s)