• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Database Error!!

mrady2001

New Member
Joined
Aug 6, 2010
Messages
115
Reaction score
0
Location
Egypt
I have Problem with Database .. Playerdeath .. when player died , other player dont get its frags .. when i use !frags == 0 day , 0 week , 0 Month

if the problem from database . please tell me how to fix

please edit it

playerdeath.sql :

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- phpMyAdmin
--
-- المزود: localhost
-- أنشئ في: 12 نوفمبر 2012 الساعة 16:48
-- إصدارة المزود: 5.1.41
-- PHP إصدارة: 5.3.1

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

--
-- قاعدة البيانات: `a99`
--

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

--
-- بنية الجدول `player_deaths`
--

CREATE TABLE IF NOT EXISTS `player_deaths` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`date` bigint(20) unsigned NOT NULL,
`level` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `date` (`date`),
KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- إرجاع أو إستيراد بيانات الجدول `player_deaths`
--


--
-- قيود الجداول المحفوظة
--

--
-- القيود للجدول `player_deaths`
--
ALTER TABLE `player_deaths`
ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

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


player-killers.sql :

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- phpMyAdmin
--
-- المزود: localhost
-- أنشئ في: 12 نوفمبر 2012 الساعة 16:50
-- إصدارة المزود: 5.1.41
-- PHP إصدارة: 5.3.1

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

--
-- قاعدة البيانات: `a99`
--

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

--
-- بنية الجدول `player_killers`
--

CREATE TABLE IF NOT EXISTS `player_killers` (
`kill_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
KEY `kill_id` (`kill_id`),
KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- إرجاع أو إستيراد بيانات الجدول `player_killers`
--


--
-- قيود الجداول المحفوظة
--

--
-- القيود للجدول `player_killers`
--
ALTER TABLE `player_killers`
ADD CONSTRAINT `player_killers_ibfk_1` FOREIGN KEY (`kill_id`) REFERENCES `killers` (`id`) ON DELETE CASCADE,
ADD CONSTRAINT `player_killers_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;

/*!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 */;
 
Back
Top