[help] Canton load mysql plugin - 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: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: [help] Canton load mysql plugin (
/showthread.php?tid=252519)
[help] Canton load mysql plugin -
mariomako - 01.05.2011
Hello,
i using mysql plugin R5 (
https://sampforum.blast.hk/showthread.php?tid=56564 ).
I have database in phpmyadmin on localhost:
http://slike.hr/slike/u/untitled_0b763.jpg
The MYSQL Database is generated with this SQL CODE:
Код:
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 22 Feb 2011 om 10:32
-- Serverversie: 5.1.36
-- PHP-Versie: 5.3.0
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `sa-mp`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`Name` varchar(24) NOT NULL,
`Password` varchar(129) NOT NULL,
`IP` varchar(16) NOT NULL,
`Admin` int(9) NOT NULL,
`Money` int(9) NOT NULL,
`Score` int(9) NOT NULL,
`Kills` int(9) NOT NULL,
`Deaths` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden uitgevoerd voor tabel `accounts`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`Player` varchar(24) NOT NULL,
`Admin` varchar(24) NOT NULL,
`Reason` varchar(128) NOT NULL,
`IP` varchar(16) NOT NULL,
`Date` varchar(18) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden uitgevoerd voor tabel `bans`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `logs`
--
CREATE TABLE IF NOT EXISTS `logs` (
`Event` varchar(128) NOT NULL,
`Date` varchar(18) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Gegevens worden uitgevoerd voor tabel `logs`
--
I use Hidmin and in the filterscript is good related to mysql with this code:
Код:
// MySQL povrzuvanje
#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_DB "samp"
#define SQL_PASS ""
#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
and if i like to start my server i have this error:
http://slike.hr/slike/u/untitled_8dea6.jpg
Help me, thanks understand
Re: [help] Canton load mysql plugin -
mariomako - 01.05.2011
BUMP!
Re: [help] Canton load mysql plugin -
mariomako - 01.05.2011
BUMP! Help meee please !
Re: [help] Canton load mysql plugin -
Ivan_Pantovic - 01.05.2011
Do you have .net framework?
Re: [help] Canton load mysql plugin -
armyoftwo - 01.05.2011
You need to download libmysql.dll from the MySQL plugin's topic, and put it in the sa-mp's server direcory.
Re: [help] Canton load mysql plugin -
mariomako - 02.05.2011
Yes, limbysql.ddl is in the root directory, and i have netframework 3.0