Hey,
ich habe mein Login und Register System auf MySQL umgeschrieben, so wie es "Maddin" in seinen MySQL Tutorial beschrieben hat.
Der Server läuft auf Linux
Jetzt,
steht bei mir wenn ich den Server anmache, bei Gamemode: "Unknown"
Hier der mysql_log:
Code
[09:30:40] >> mysql_connect(localhost, samp539, samp539_log, ******) on port 3306
[09:30:40] CMySQLHandler::CMySQLHandler() - constructor called.
[09:30:40] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp539_log" | Username: "samp539"
[09:30:40] CMySQLHandler::Connect() - Connection was successful.
[09:30:40] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[09:30:40] >> mysql_ping( Connection handle: 1 )
[09:30:40] CMySQLHandler::Ping() - Connection is still alive.Hier der server_log:
Code
SA-MP Dedicated Server
----------------------
v0.3e, (C)2005-2012 SA-MP Team
[11:51:20]
[11:51:20] Server Plugins
[11:51:20] --------------
[11:51:20] Loading plugin: streamer.so
[11:51:20]
*** Streamer Plugin v2.6.1 by Incognito loaded ***
[11:51:20] Loaded.
[11:51:20] Loading plugin: mysql.so
[11:51:20]
> MySQL plugin R7 successfully loaded.
[11:51:20] Loaded.
[11:51:20] Loaded 2 plugins.
[11:51:20]
[11:51:20] Filterscripts
[11:51:20] ---------------
[11:51:20] Loaded 0 filterscripts.
[11:51:20] Script[gamemodes/log.amx]: Run time error 19: "File or function is not found"
[11:51:20] Number of vehicle models: 0Hier noch die Datenbank:
SQL
-- phpMyAdmin SQL Dump
-- version 3.3.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 31. August 2012 um 11:54
-- Server Version: 5.1.63
-- PHP-Version: 5.3.3-7+squeeze13
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Datenbank: `samp539_log`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `accounts`
--
CREATE TABLE IF NOT EXISTS `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(24) NOT NULL,
`passwort` varchar(128) NOT NULL,
`Geschlecht` int(11) NOT NULL DEFAULT '1',
`Alter` int(11) NOT NULL DEFAULT '0',
`PayDay` int(11) NOT NULL DEFAULT '0',
`Level` int(11) NOT NULL DEFAULT '1',
`Geld` int(11) NOT NULL DEFAULT '100',
`Skin` int(11) NOT NULL DEFAULT '0',
`Skin2` int(11) NOT NULL DEFAULT '0',
`Haus` int(11) NOT NULL DEFAULT '999',
`Fraktion` int(11) NOT NULL DEFAULT '0',
`Leader` int(11) NOT NULL DEFAULT '0',
`Rank` int(11) NOT NULL DEFAULT '0',
`Adminlevel` int(11) NOT NULL DEFAULT '0',
`Ehrenmember` int(11) NOT NULL DEFAULT '0',
`Gebannt` int(11) NOT NULL DEFAULT '0',
`Wanteds` int(11) NOT NULL DEFAULT '0',
`GWD` int(11) NOT NULL DEFAULT '0',
`Kopfgeld` int(11) NOT NULL DEFAULT '0',
`FSchein` int(11) NOT NULL DEFAULT '0',
`Fightstyle` int(11) NOT NULL DEFAULT '0',
`C4` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=220 ;
--
-- Daten für Tabelle `accounts`
--
