1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
Help please
Stop
Banned
Posts: 83
Threads: 44
Joined: Apr 2016
#1

11.08.2016, 15:50
----------
Loaded log file: "server_log.txt".
----------

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[11:37:12] password = "" (string)
[11:37:12]
[11:37:12] Server Plugins
[11:37:12] --------------
[11:37:12] Loading plugin: crashdetect.so
[11:37:12] CrashDetect v4.15.1 is OK.
[11:37:12] Loaded.
[11:37:12] Loading plugin: irc.so
[11:37:12]

*** IRC Plugin v1.4.8 by Incognito loaded ***

[11:37:12] Loaded.
[11:37:12] Loading plugin: streamer.so
[11:37:12]

*** Streamer Plugin v2.7.6 by Incognito loaded ***

[11:37:12] Loaded.
[11:37:12] Loading plugin: sscanf.so
[11:37:12]

[11:37:12] ===============================

[11:37:12] sscanf plugin loaded.

[11:37:12] Version: 2.8.1

[11:37:12] © 2012 Alex "******" Cole

[11:37:12] ===============================

[11:37:12] Loaded.
[11:37:12] Loading plugin: mysqlR39.so
[11:37:12] >> plugin.mysql: R39-5 successfully loaded.
[11:37:12] Loaded.
[11:37:12] Loading plugin: whirlpool.so
[11:37:12]
[11:37:12] ==================
[11:37:12]
[11:37:12] Whirlpool loaded
[11:37:12]
[11:37:12] ==================
[11:37:12]
[11:37:12] Loaded.
[11:37:12] Loading plugin: nativechecker.so
[11:37:12] Loaded.
[11:37:12] Loaded 7 plugins.

[11:37:12]
[11:37:12] Filterscripts
[11:37:12] ---------------
[11:37:12] Loading filterscript 'Objects.amx'...
[11:37:12] Loaded 1 filterscripts.

[11:37:12] Error: Function not registered: 'localtime'
[11:37:12] Error: Function not registered: 'strftime'
[11:37:12] Error: Function not registered: 'sha1'
[11:37:12] [debug] Run time error 19: "File or function is not found"
[11:37:12] [debug] localtime
[11:37:12] [debug] strftime
[11:37:12] [debug] sha1
[11:37:12] [debug] Run time error 19: "File or function is not found"
[11:37:12] [debug] localtime
[11:37:12] [debug] strftime
[11:37:12] [debug] sha1
[11:37:12] Script[gamemodes/xSF.amx]: Run time error 19: "File or function is not found"
[11:37:12] Number of vehicle models: 0


how to fix them please help

my mysql emport
CODE
-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 10, 2016 at 12:11 PM
-- Server version: 10.1.10-MariaDB
-- PHP Version: 7.0.2

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 utf8mb4 */;

--
-- Database: `xsfs_xsf`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`root`@`localhost` PROCEDURE `login` (IN `username` VARCHAR(24), IN `password` VARCHAR(42), IN `ip` VARCHAR(45), OUT `returncode` VARCHAR(24)) BEGIN
DECLARE user_id INT;
DECLARE user_exist TINYINT;
DECLARE user_ban TINYINT;
DECLARE login_attempts INT;
DECLARE error_code INT;

SET user_id = -1;
SET error_code = 0;

SELECT
COUNT(*)
INTO user_exist
FROM players
WHERE name = username;

IF user_exist = 0 THEN
SET error_code = 10;
END IF;

IF error_code = 0 THEN
SELECT
COUNT(*)
INTO login_attempts
FROM pcp_login_attempt
WHERE (la_name = username
OR la_ip = ip)
AND la_error = 40
AND TIMESTAMPDIFF(MINUTE, la_time, NOW()) <= 10;

IF login_attempts >= 3 THEN
SET error_code = 20;
END IF;
END IF;

IF error_code = 0 THEN
SELECT
COUNT(*)
INTO user_ban
FROM bans
WHERE user_banned = username;

IF user_ban <> 0 THEN
SET error_code = 30;
END IF;
END IF;

IF error_code = 0 THEN
SELECT
reg_id
INTO user_id
FROM players
WHERE name = username
AND pass = password;

IF user_id = -1 THEN
SET error_code = 40;
END IF;
END IF;

INSERT INTO pcp_login_attempt
(la_name, la_ip, la_error)
VALUES
(username, ip, error_code);

SET returncode = CONCAT(error_code, '|' , user_id);
END$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_user_data` (IN `user_id` INT) BEGIN
SELECT
P.reg_id AS id,
P.name AS name,
P.adminlevel AS admin,
P.helper AS helper,
P.premium AS premium,
P.saveskin AS skin
FROM players P
WHERE reg_id = user_id
LIMIT 1;
END$$

DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `achievements`
--

CREATE TABLE `achievements` (
`ID` int(7) UNSIGNED NOT NULL,
`reg_id` mediumint(7) UNSIGNED NOT NULL,
`name` varchar(24) CHARACTER SET utf8 NOT NULL,
`a1` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Grim Reaper',
`a2` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Mass Killer',
`a3` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'You''re Rich',
`a4` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Official Stunter',
`a5` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a6` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a7` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a8` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a9` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a10` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a11` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a12` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a13` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a14` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a15` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a16` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a17` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a18` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a19` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a20` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a21` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`a22` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Human Calculator',
`a23` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Derby Pro',
`a24` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pro Cop',
`a25` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pro Theif',
`a26` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Pickpocketer',
`a27` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Ruthless',
`a28` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CookieJar Hunter'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player Achivements';

-- --------------------------------------------------------

--
-- Table structure for table `activity`
--

CREATE TABLE `activity` (
`reg_id` mediumint(7) UNSIGNED NOT NULL DEFAULT '0',
`name` varchar(21) NOT NULL,
`IP` varchar(16) NOT NULL,
`jointime` int(11) UNSIGNED NOT NULL,
`leavetime` int(11) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Activity Log';

-- --------------------------------------------------------

--
-- Table structure for table `adminlog`
--

CREATE TABLE `adminlog` (
`command` varchar(14) NOT NULL,
`admin` varchar(21) NOT NULL,
`adminid` mediumint(7) UNSIGNED NOT NULL,
`player` varchar(21) NOT NULL DEFAULT '*',
`playerid` mediumint(7) NOT NULL DEFAULT '-1',
`str` varchar(12 NOT NULL DEFAULT '*',
`time` int(11) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `bans`
--

CREATE TABLE `bans` (
`BanID` smallint(5) UNSIGNED NOT NULL COMMENT 'Ban ID',
`user_banned` varchar(24) NOT NULL COMMENT 'Banned Player Name',
`bIP` varchar(16) NOT NULL COMMENT 'Banned Player IP',
`user_banner` varchar(24) NOT NULL DEFAULT '*' COMMENT 'Admin Name',
`ban_reason` varchar(60) NOT NULL DEFAULT '*' COMMENT 'Ban Reason',
`ban_timestamp` int(11) UNSIGNED NOT NULL COMMENT 'Ban Date',
`ban_time` int(11) UNSIGNED NOT NULL COMMENT 'Ban Time (0 = Permenant)'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

-- --------------------------------------------------------

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
`Name` text,
`Comment` text,
`Timestamp` text,
`CKey` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
`gID` mediumint(6) NOT NULL,
`gName` varchar(25) NOT NULL,
`gTag` varchar(4) NOT NULL COMMENT 'Group Tag',
`gFounder` varchar(24) NOT NULL COMMENT 'Group Founder',
`gScore` int( NOT NULL DEFAULT '0',
`gDate` int(11) NOT NULL DEFAULT '0',
`gColor` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `houses`
--

CREATE TABLE `houses` (
`house_id` mediumint(4) NOT NULL,
`hname` varchar(35) NOT NULL,
`howner` varchar(21) NOT NULL,
`hlocation` varchar(30) NOT NULL DEFAULT '*',
`hpass` varchar(24) NOT NULL,
`last_visited` int(11) UNSIGNED NOT NULL DEFAULT '0',
`x` float NOT NULL DEFAULT '0',
`y` float NOT NULL DEFAULT '0',
`z` float NOT NULL DEFAULT '0',
`a` float NOT NULL DEFAULT '0',
`cpx` float NOT NULL DEFAULT '0',
`cpy` float NOT NULL DEFAULT '0',
`cpz` float NOT NULL DEFAULT '0',
`hvalue` int(12) UNSIGNED NOT NULL DEFAULT '500',
`hforsale` int(12) UNSIGNED NOT NULL DEFAULT '0',
`hstorage` int(12) UNSIGNED NOT NULL DEFAULT '0',
`hint` tinyint(2) UNSIGNED NOT NULL DEFAULT '4',
`hprivacy` tinyint(1) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `interiors`
--

CREATE TABLE `interiors` (
`int_name` varchar(30) NOT NULL,
`intx` float NOT NULL DEFAULT '0',
`inty` float NOT NULL DEFAULT '0',
`intz` float NOT NULL DEFAULT '0',
`inta` float NOT NULL DEFAULT '0',
`cpx` float NOT NULL DEFAULT '0',
`cpy` float NOT NULL DEFAULT '0',
`cpz` float NOT NULL DEFAULT '0',
`interior` tinyint(2) UNSIGNED NOT NULL DEFAULT '0',
`value` int(12) UNSIGNED NOT NULL DEFAULT '500'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `kicks`
--

CREATE TABLE `kicks` (
`player` varchar(21) NOT NULL,
`player_ip` varchar(16) NOT NULL,
`player_regid` mediumint(7) UNSIGNED NOT NULL,
`admin` varchar(32) NOT NULL DEFAULT 'SYSTEM',
`admin_regid` mediumint(7) UNSIGNED NOT NULL DEFAULT '0',
`reason` varchar(12 NOT NULL,
`time` int(11) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `labels`
--

CREATE TABLE `labels` (
`id` int(11) NOT NULL,
`owner` varchar(24) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`labelnum` int(1) NOT NULL DEFAULT '1',
`text` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`posX` float NOT NULL,
`posY` float NOT NULL,
`posZ` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `monthlycomp`
--

CREATE TABLE `monthlycomp` (
`test` int(11) NOT NULL,
`reg_id` int(11) NOT NULL,
`name` varchar(30) NOT NULL,
`hours` int(11) NOT NULL,
`minutes` int(11) NOT NULL,
`seconds` int(11) NOT NULL,
`kills` int(11) NOT NULL,
`deaths` int(11) NOT NULL,
`score` int(11) NOT NULL,
`rtests` int(11) NOT NULL,
`mb_found` int(11) NOT NULL,
`cookiejars` int(11) NOT NULL,
`events_won` int(11) NOT NULL,
`duels_won` int(11) NOT NULL,
`races_won` int(11) NOT NULL,
`fallouts` int(11) NOT NULL,
`derby_wins` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `namechanges`
--

CREATE TABLE `namechanges` (
`num` smallint(5) UNSIGNED NOT NULL,
`reg_id` int(7) UNSIGNED NOT NULL,
`oldname` varchar(21) NOT NULL,
`newname` varchar(21) NOT NULL,
`time` int(11) UNSIGNED NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `parkourtimes`
--

CREATE TABLE `parkourtimes` (
`parkourid` smallint(3) NOT NULL,
`parkour` varchar(24) NOT NULL,
`holder` varchar(24) NOT NULL DEFAULT 'NONE',
`regid` smallint(5) NOT NULL DEFAULT '-1',
`ms` mediumint(7) NOT NULL DEFAULT '0',
`time` int(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `pcp_login_attempt`
--

CREATE TABLE `pcp_login_attempt` (
`la_id` int(11) NOT NULL,
`la_name` varchar(24) COLLATE utf8_unicode_ci NOT NULL,
`la_ip` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
`la_error` int(11) DEFAULT NULL,
`la_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `pcp_news`
--

CREATE TABLE `pcp_news` (
`nw_id` int(11) NOT NULL,
`nw_title` varchar(24) NOT NULL,
`nw_body` longtext,
`nw_sticked` tinyint(1) NOT NULL DEFAULT '0',
`nw_user` int(11) NOT NULL,
`nw_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `pcp_page_perm`
--

CREATE TABLE `pcp_page_perm` (
`pp_page` varchar(256) NOT NULL,
`pp_perm` tinyint(1) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `players`
--

CREATE TABLE `players` (
`reg_id` int(7) UNSIGNED NOT NULL COMMENT 'Players Registration ID',
`name` varchar(24) NOT NULL COMMENT 'Player''s Name',
`IP` varchar(16) NOT NULL COMMENT 'Players IP',
`pass` varchar(42) NOT NULL COMMENT 'Players Password',
`email` varchar(40) NOT NULL DEFAULT '*' COMMENT 'Players Email',
`adminlevel` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player''s Admin Level',
`helper` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Server Helper.',
`premium` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Premium Level',
`gold_coins` mediumint(6) UNSIGNED NOT NULL COMMENT 'Gold Coins (Credits)',
`hours` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Hours',
`minutes` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Minutes',
`seconds` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Online Seconds',
`kills` int(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Kills',
`deaths` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Deaths',
`money` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Cash',
`bmoney` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Bank Money',
`score` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Score',
`group_id` smallint(4) NOT NULL DEFAULT '-1' COMMENT 'Player''s Group',
`group_rank` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players Group Rank',
`saveskin` smallint(4) UNSIGNED NOT NULL DEFAULT '999' COMMENT 'Player''s Saved Skin',
`autoLogin` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Auto Login',
`spawnplace` tinyint(3) NOT NULL DEFAULT '-1' COMMENT 'Player Spawn Area',
`weapon_set` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players Weapon Set',
`seepms` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'View PMs (Admin Only)',
`specoff` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Spectate',
`hidden` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Hidden (Admin Only)',
`autotune` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Vehicle AutoTune',
`cookies` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Cookies',
`events_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Events Won',
`races_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Races Won',
`parkours_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Parkours Won',
`duels_won` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Duels Won',
`fallouts` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Fallout Wins',
`derby_wins` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Derby Wins',
`MB_found` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Moneybags Found',
`cookiejars` mediumint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Cookie Jars Found',
`keyflip` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Speedbreak',
`savedvehicle` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Saved Vehicle',
`speedboost` float UNSIGNED NOT NULL DEFAULT '1.3' COMMENT 'Player Speedboost',
`bounce` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
`superman` tinyint(1) UNSIGNED NOT NULL DEFAULT '0',
`wheels` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Players default wheels',
`reg_time` varchar(20) NOT NULL COMMENT 'Registration Date',
`last_time` varchar(20) NOT NULL COMMENT 'Last Online Date',
`color` int(11) NOT NULL DEFAULT '0' COMMENT 'Player Nick Color',
`chat_color` int(11) NOT NULL DEFAULT '0' COMMENT 'Chat Color (VIP)',
`id_color` int(11) NOT NULL DEFAULT '0' COMMENT 'Player ID Color',
`goto` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Player Teleporting',
`autofix` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Toggle Vehicle Repair',
`god` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player God Mode',
`rtests` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Reactions Won',
`maths` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Math Questions Answered',
`arrests` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player''s Arrests',
`takedowns` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Takedowns',
`robberies` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Robberies',
`probberies` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Player Robberies',
`times_arrested` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'CnR Times Arrested',
`cop_kills` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Cops Killed in CnR.',
`speedo` tinyint(1) UNSIGNED NOT NULL DEFAULT '1' COMMENT 'Speedo Meter',
`killstreak` smallint(3) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Highest Killstreak',
`active` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Online',
`hideMSGs` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide Server Messages',
`duels_off` tinyint(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Toggle Duel Invitations',
`plate` varchar(15) NOT NULL DEFAULT '*' COMMENT 'Vehicle Plate',
`time` tinyint(2) NOT NULL DEFAULT '-1' COMMENT 'Player Time',
`weather` tinyint(2) NOT NULL DEFAULT '-1' COMMENT 'Player Weather',
`description` varchar(40) NOT NULL DEFAULT 'None.' COMMENT 'Player Description',
`country` varchar(30) NOT NULL DEFAULT '*' COMMENT 'Player Country',
`namechange_date` int(12) NOT NULL DEFAULT '0' COMMENT 'Name Change Date',
`v_expired` int(12) NOT NULL DEFAULT '0' COMMENT 'Premium Expiration Date',
`Muted` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Mute Time',
`Jailed` smallint(4) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Jail Time',
`report_points` mediumint(6) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'Player Report Points',
`house_id` smallint(4) NOT NULL DEFAULT '-1' COMMENT 'Player House ID',
`gotpresent` int(12) NOT NULL DEFAULT '0' COMMENT 'Christmas Present',
`togpms` tinyint(1) NOT NULL DEFAULT '0',
`togevent` tinyint(1) NOT NULL DEFAULT '0',
`hitsound` tinyint(1) NOT NULL DEFAULT '0',
`cbugtime` int(11) NOT NULL DEFAULT '0',
`togmsg` int(1) NOT NULL DEFAULT '1',
`fstyle` int(2) NOT NULL DEFAULT '4'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Player Data Storage' ROW_FORMAT=DYNAMIC;

-- --------------------------------------------------------

--
-- Table structure for table `playerstest`
--

CREATE TABLE `playerstest` (
`test` int(1) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `racetimes`
--

CREATE TABLE `racetimes` (
`raceid` smallint(3) NOT NULL,
`race` varchar(32) NOT NULL,
`holder` varchar(24) NOT NULL DEFAULT 'NONE',
`regid` smallint(5) NOT NULL DEFAULT '-1',
`ms` mediumint(7) NOT NULL DEFAULT '0',
`time` int(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `recover`
--

CREATE TABLE `recover` (
`RecoverKey` varchar(255) DEFAULT NULL,
`Username` varchar(255) DEFAULT NULL,
`IP` varchar(255) DEFAULT NULL,
`Date` varchar(255) DEFAULT NULL,
`E-Mail` varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
`SessID` varchar(30) NOT NULL,
`Username` text NOT NULL,
`Password` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `soldhouses`
--

CREATE TABLE `soldhouses` (
`name` varchar(24) NOT NULL,
`hID` mediumint(4) UNSIGNED NOT NULL DEFAULT '0',
`hbuyer` varchar(24) NOT NULL,
`hprice` int(12) UNSIGNED NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `toys`
--

CREATE TABLE `toys` (
`ID` mediumint(6) UNSIGNED NOT NULL,
`Name` varchar(24) NOT NULL,
`Slot0_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot0_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot0_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_ZRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot0_ZScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot1_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot1_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_ZRot` float(20,2) NOT NULL DEFAULT '0.00',
`Slot1_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot1_ZScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot2_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot2_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_ZRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot2_ZScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot3_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot3_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_ZRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot3_ZScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot4_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot4_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_ZRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot4_ZScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_Model` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',
`Slot5_Bone` smallint(2) UNSIGNED NOT NULL DEFAULT '0',
`Slot5_XPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_YPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_ZPos` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_XRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_YRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_ZRot` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_XScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_YScale` float(20,3) NOT NULL DEFAULT '0.000',
`Slot5_ZScale` float(20,3) NOT NULL DEFAULT '0.000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `vehicles`
--

CREATE TABLE `vehicles` (
`ID` mediumint(6) UNSIGNED NOT NULL,
`Owner` varchar(24) NOT NULL,
`Model` mediumint(6) NOT NULL,
`Price` int(10) NOT NULL,
`Locked` tinyint(1) NOT NULL DEFAULT '1',
`PaintJob` smallint(3) NOT NULL DEFAULT '-1',
`Color1` smallint(3) NOT NULL DEFAULT '0',
`Color2` smallint(3) NOT NULL DEFAULT '0',
`Plate` varchar(12) NOT NULL DEFAULT '*',
`Mod1` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod2` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod3` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod4` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod5` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod6` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod7` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod8` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod9` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod10` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod11` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod12` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod13` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod14` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod15` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod16` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Mod17` smallint(5) UNSIGNED NOT NULL DEFAULT '0',
`Model_2` mediumint(6) NOT NULL DEFAULT '0',
`Price_2` int(10) NOT NULL DEFAULT '0',
`Paintjob_2` smallint(3) NOT NULL DEFAULT '-1',
`Color1_2` smallint(3) NOT NULL DEFAULT '0',
`Color2_2` smallint(3) NOT NULL DEFAULT '0',
`Model_3` mediumint(5) NOT NULL DEFAULT '0',
`Price_3` int(10) NOT NULL DEFAULT '0',
`Paintjob_3` smallint(3) NOT NULL DEFAULT '-1',
`Color1_3` smallint(3) NOT NULL DEFAULT '0',
`Color2_3` smallint(3) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `web_adminactivity`
--

CREATE TABLE `web_adminactivity` (
`reg_id` int(11) NOT NULL,
`name` varchar(50) NOT NULL,
`time` varchar(20) NOT NULL,
`week` int(11) NOT NULL,
`year` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `web_groups_images`
--

CREATE TABLE `web_groups_images` (
`groupID` int(11) NOT NULL,
`image_uri` varchar(150) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `web_news`
--

CREATE TABLE `web_news` (
`id` int(11) NOT NULL,
`posted_by` varchar(100) NOT NULL,
`title` varchar(100) NOT NULL,
`body` mediumtext NOT NULL,
`date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `web_test`
--

CREATE TABLE `web_test` (
`name` varchar(30) NOT NULL,
`page` varchar(100) NOT NULL,
`ip` varchar(20) NOT NULL,
`timestamp` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Table structure for table `web_weeklyhours`
--

CREATE TABLE `web_weeklyhours` (
`playerID` int(11) NOT NULL,
`admin_name` varchar(40) NOT NULL,
`admin_hours` varchar(40) NOT NULL,
`year` int(11) NOT NULL,
`week` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `achievements`
--
ALTER TABLE `achievements`
ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `activity`
--
ALTER TABLE `activity`
ADD KEY `reg_id` (`reg_id`);

--
-- Indexes for table `adminlog`
--
ALTER TABLE `adminlog`
ADD KEY `adminid` (`adminid`),
ADD KEY `playerid` (`playerid`),
ADD KEY `time` (`time`);

--
-- Indexes for table `bans`
--
ALTER TABLE `bans`
ADD PRIMARY KEY (`BanID`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
ADD PRIMARY KEY (`gID`);

--
-- Indexes for table `houses`
--
ALTER TABLE `houses`
ADD PRIMARY KEY (`house_id`),
ADD KEY `hname` (`hname`);

--
-- Indexes for table `interiors`
--
ALTER TABLE `interiors`
ADD PRIMARY KEY (`int_name`),
ADD KEY `int_name` (`int_name`);

--
-- Indexes for table `labels`
--
ALTER TABLE `labels`
ADD PRIMARY KEY (`id`);

--
-- Indexes for table `monthlycomp`
--
ALTER TABLE `monthlycomp`
ADD PRIMARY KEY (`test`);

--
-- Indexes for table `namechanges`
--
ALTER TABLE `namechanges`
ADD PRIMARY KEY (`num`),
ADD KEY `reg_id` (`reg_id`);

--
-- Indexes for table `parkourtimes`
--
ALTER TABLE `parkourtimes`
ADD PRIMARY KEY (`parkourid`);

--
-- Indexes for table `pcp_login_attempt`
--
ALTER TABLE `pcp_login_attempt`
ADD PRIMARY KEY (`la_id`);

--
-- Indexes for table `pcp_news`
--
ALTER TABLE `pcp_news`
ADD PRIMARY KEY (`nw_id`);

--
-- Indexes for table `pcp_page_perm`
--
ALTER TABLE `pcp_page_perm`
ADD PRIMARY KEY (`pp_page`);

--
-- Indexes for table `players`
--
ALTER TABLE `players`
ADD PRIMARY KEY (`reg_id`),
ADD KEY `name` (`name`);

--
-- Indexes for table `playerstest`
--
ALTER TABLE `playerstest`
ADD PRIMARY KEY (`test`);

--
-- Indexes for table `racetimes`
--
ALTER TABLE `racetimes`
ADD PRIMARY KEY (`raceid`),
ADD KEY `race` (`race`);

--
-- Indexes for table `soldhouses`
--
ALTER TABLE `soldhouses`
ADD PRIMARY KEY (`name`);

--
-- Indexes for table `toys`
--
ALTER TABLE `toys`
ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `vehicles`
--
ALTER TABLE `vehicles`
ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `web_news`
--
ALTER TABLE `web_news`
ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `achievements`
--
ALTER TABLE `achievements`
MODIFY `ID` int(7) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=909183;
--
-- AUTO_INCREMENT for table `bans`
--
ALTER TABLE `bans`
MODIFY `BanID` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Ban ID', AUTO_INCREMENT=16409;
--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
MODIFY `gID` mediumint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1675;
--
-- AUTO_INCREMENT for table `houses`
--
ALTER TABLE `houses`
MODIFY `house_id` mediumint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=714;
--
-- AUTO_INCREMENT for table `labels`
--
ALTER TABLE `labels`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `monthlycomp`
--
ALTER TABLE `monthlycomp`
MODIFY `test` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `namechanges`
--
ALTER TABLE `namechanges`
MODIFY `num` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20449;
--
-- AUTO_INCREMENT for table `parkourtimes`
--
ALTER TABLE `parkourtimes`
MODIFY `parkourid` smallint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;
--
-- AUTO_INCREMENT for table `pcp_login_attempt`
--
ALTER TABLE `pcp_login_attempt`
MODIFY `la_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;
--
-- AUTO_INCREMENT for table `pcp_news`
--
ALTER TABLE `pcp_news`
MODIFY `nw_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;
--
-- AUTO_INCREMENT for table `players`
--
ALTER TABLE `players`
MODIFY `reg_id` int(7) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Players Registration ID', AUTO_INCREMENT=909872;
--
-- AUTO_INCREMENT for table `racetimes`
--
ALTER TABLE `racetimes`
MODIFY `raceid` smallint(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;
--
-- AUTO_INCREMENT for table `toys`
--
ALTER TABLE `toys`
MODIFY `ID` mediumint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101523;
--
-- AUTO_INCREMENT for table `vehicles`
--
ALTER TABLE `vehicles`
MODIFY `ID` mediumint(6) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65603;
--
-- AUTO_INCREMENT for table `web_news`
--
ALTER TABLE `web_news`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#2

11.08.2016, 16:16
First of all, your post is too long. Use pastebin next time so it will be easier for us to read it.

The problem is that 3 functions are not registered.
pawn Код:
Error: Function not registered: 'localtime'
Error: Function not registered: 'strftime'
Error: Function not registered: 'sha1'
therebefore some plugins haven't been loaded at all.

"localtime" and "strftime" can be found in CTimer Library: https://sampforum.blast.hk/showthread.php?tid=294054
"sha1" can be found in Encrypt: https://sampforum.blast.hk/showthread.php?tid=152682

Consider using "SHA256_PassHash" that was added in 0.3.7 R1 and also includes salt for more security instead of "sha1".
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help