السلام عليكم ورحمه الله وبركاته

بدايه عيد سعيد على كل اعضاء المنتدى وان شاء الله طوله العمر للجميع

اخواني الاعزاء بدي مشكله ولا اعرف ماهو سببها المشكله تحدث في سكربت يحتوي على اعضاء عند التعديل على بيانات اي عضو يظهر لي التالي

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ShowIP = 0,VoiceClip = 1 WHERE Username='AdnanO'' at line 1

دمتم بخير

وشكرا لكم مقدماً

ممكن التوضيح اكتر حتى نساعدك باسرع وقت

شكرا لردك وعيدك سعيد ان شاء الله

عزيزي المشكله انهو عند الدخول للوحه الاعضاء واختيار اي عضو للتعديل عليه مثلا تعديل الايميل تعديل اسم العضو كلمه سر العضو اي شي واضغط على خيار موافق تتطلعلي هلعباره

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ShowIP = 0,VoiceClip = 1 WHERE Username='AdnanO'' at line 1

اين يتم هذا العمل كله على ايا قاعدة بيانات وما هو الاصدار

قاعده البيانات

كـود PHP

-- phpMyAdmin SQL Dump
-- version 2.11.8.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1:3306
-- Generation Time: Nov 08, 2008 at 03:23 PM
-- Server version: 4.1.20
-- PHP Version: 4.3.11

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

--
-- Database: `seslivo_phpregister-sms`
--

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

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
CREATE TABLE IF NOT EXISTS `admin` (
`username` varchar(50) NOT NULL default '',
`password` varchar(50) NOT NULL default '',
PRIMARY KEY (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`username`, `password`) VALUES
('admin', 'b5244fc43926807d19f2d7efbb0a6277'),
('chatmaster', 'b5244fc43926807d19f2d7efbb0a6277');

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

--
-- Table structure for table `Bans`
--

DROP TABLE IF EXISTS `Bans`;
CREATE TABLE IF NOT EXISTS `Bans` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Ip` varchar(20) NOT NULL default '',
`AdminName` varchar(16) NOT NULL default '',
`Date` date NOT NULL default '0000-00-00',
`Note` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`),
FULLTEXT KEY `Ip` (`Ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

--
-- Dumping data for table `Bans`
--


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

--
-- Table structure for table `config`
--

DROP TABLE IF EXISTS `config`;
CREATE TABLE IF NOT EXISTS `config` (
`msg_length` tinyint(3) unsigned NOT NULL default '0',
`activated` enum('y','n') NOT NULL default 'y',
`bar_speed` tinyint(3) unsigned NOT NULL default '0',
`dir` varchar(30) NOT NULL default 'right',
`logo` varchar(10) NOT NULL default '',
`font` varchar(20) NOT NULL default '',
`font_size` tinyint(3) unsigned NOT NULL default '0',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`level_a_color` varchar(10) NOT NULL default '',
`level_b_color` varchar(10) NOT NULL default '',
`level_c_color` varchar(10) NOT NULL default '',
`msg_limit` tinyint(2) unsigned default '0',
PRIMARY KEY (`activated`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `config`
--


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

--
-- Table structure for table `confirm`
--

DROP TABLE IF EXISTS `confirm`;
CREATE TABLE IF NOT EXISTS `confirm` (
`confirm_id` char(32) NOT NULL default '',
`session_id` char(32) NOT NULL default '',
`code` char(6) NOT NULL default '',
PRIMARY KEY (`session_id`,`confirm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `confirm`
--


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

--
-- Table structure for table `msg`
--

DROP TABLE IF EXISTS `msg`;
CREATE TABLE IF NOT EXISTS `msg` (
`id` int(10) unsigned NOT NULL auto_increment,
`mesg` text NOT NULL,
`username` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=282 ;

--
-- Dumping data for table `msg`
--


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

--
-- Table structure for table `PhpregisterAccInfo`
--

DROP TABLE IF EXISTS `PhpregisterAccInfo`;
CREATE TABLE IF NOT EXISTS `PhpregisterAccInfo` (
`ID` int(10) NOT NULL auto_increment,
`Version` varchar(50) NOT NULL default '1,0,0,236',
`Server` varchar(50) NOT NULL default '72.36.153.66',
`UserAccount` varchar(50) NOT NULL default '0xcd 0x6a 0xbf 0x62 0x1f 0x7a 0x09 0x10',
`AdminPassword` varchar(50) NOT NULL default 'bbc1976',
`KickTM` varchar(50) default '864000',
`TextFONTSTYLE` varchar(50) default 'Comic Sans MS',
`TextFONTSIZE` varchar(50) default '10',
`TextLIMIT` varchar(50) default '100',
`FloodCONTROL` varchar(50) default '500',
`RoomID` varchar(50) default '120',
`TextwindowSIZE` varchar(50) default '450',
`TextWindowBgImage` text,
`AnimationFolder` varchar(50) default '/Animations',
`TextFilter` text,
`JoinRM` tinyint(1) default '1',
`WindowBgCOLOR` varchar(255) default '800000',
`ListBgCOLOR` varchar(255) default '800000',
`TextUSERCOLOR` varchar(255) default '00FFFF',
`TextCOLOR` varchar(255) default 'FFFFFF',
`WelcomeMessage` varchar(255) NOT NULL default 'FFFFFF',
`SuperPassword` varchar(8) NOT NULL default '' COMMENT 'Super Moderator password',
PRIMARY KEY (`ID`),
KEY `Server` (`Server`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `PhpregisterAccInfo`
--


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

--
-- Table structure for table `smiles`
--

DROP TABLE IF EXISTS `smiles`;
CREATE TABLE IF NOT EXISTS `smiles` (
`id` int(10) unsigned NOT NULL auto_increment,
`smile` varchar(50) NOT NULL default '',
`dir` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

--
-- Dumping data for table `smiles`
--

INSERT INTO `smiles` (`id`, `smile`, `dir`) VALUES
(1, ':(', 'smilie01.gif'),
(2, ':x', 'smilie02.gif'),
(3, ':o', 'smilie03.gif'),
(4, ':k', 'smilie04.gif'),
(5, ':P', 'smilie05.gif'),
(6, ';)', 'smilie06.gif'),
(7, ':C', 'smilie07.gif'),
(8, 'B)', 'smilie08.gif'),
(9, ':s', 'smilie09.gif'),
(10, 'x(', 'smilie10.gif'),
(11, ':-w', 'smilie11.gif'),
(12, 'B)', 'smilie12.gif'),
(13, ':|', 'smilie13.gif'),
(14, ':D', 'smilie14.gif'),
(15, ':Q', 'smilie15.gif'),
(16, ':S', 'smilie16.gif'),
(17, '01;', 'smilie17.gif'),
(18, '03;', 'smilie18.gif'),
(20, 'g:', 'smilie19.gif'),
(21, '20;', 'smilie20.gif'),
(22, 'w:', 'smilie21.gif'),
(31, 'bit:', 'smilie22.gif'),
(33, 'K:', 'smilie23.gif'),
(36, 'H:', 'smilie24.gif'),
(38, ':L', 'smilie25.gif');

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

--
-- Table structure for table `SuperUsers`
--

DROP TABLE IF EXISTS `SuperUsers`;
CREATE TABLE IF NOT EXISTS `SuperUsers` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Username` varchar(255) default NULL,
`FirstName` varchar(50) default NULL,
`LastName` varchar(50) default NULL,
`AgeGroup` varchar(50) default NULL,
`Country` varchar(50) default NULL,
`Password` varchar(255) default NULL,
`Email` varchar(255) default '',
`Sms` smallint(6) default '1',
`JoinedDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`BanHISTORY` int(11) NOT NULL default '0',
`TextPM` int(11) NOT NULL default '1',
`VoicePM` int(11) NOT NULL default '1',
`Invisible` int(11) NOT NULL default '0',
`WebCAM` int(11) NOT NULL default '1',
`Mode` int(11) NOT NULL default '0',
`Color` varchar(50) default '1010101',
`isAdmin` int(11) NOT NULL default '0',
`Sex` int(11) NOT NULL default '0',
`random` int(11) NOT NULL default '0',
`Activate` int(11) NOT NULL default '0',
`TalkLimit` int(20) NOT NULL default '300000',
`ShowIP` int(11) NOT NULL default '0',
`VoiceClip` tinyint(1) default '1' COMMENT 'User''s Voice Clip',
PRIMARY KEY (`ID`),
KEY `Username` (`Username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=130 ;

--
-- Dumping data for table `SuperUsers`
--

INSERT INTO `SuperUsers` (`ID`, `Username`, `FirstName`, `LastName`, `AgeGroup`, `Country`, `Password`, `Email`, `Sms`, `JoinedDate`, `BanHISTORY`, `TextPM`, `VoicePM`, `Invisible`, `WebCAM`, `Mode`, `Color`, `isAdmin`, `Sex`, `random`, `Activate`, `TalkLimit`, `ShowIP`, `VoiceClip`) VALUES
(123, 'SuperAdmin', 'Super', 'Admin', '18020', 'United_States', '3DB.@S/MO/', '[email protected]', 0, '2008-07-12 10:35:48', 0, 0, 0, 0, 0, 0, 'CC3366', 0, 2, 58957, 1, 500000, 0, 0),
(129, 'edy', 'Bob', 'Davis', '25029', 'United_States', '3DB.@S/MO/', '[email protected]', 1, '2008-11-08 14:20:22', 1, 1, 1, 1, 1, 1, 'CC3366', 3, 2, 47068, 1, 300000, 1, 1);

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

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) unsigned NOT NULL auto_increment,
`username` varchar(50) NOT NULL default '',
`password` varchar(100) NOT NULL default '',
`email` varchar(50) NOT NULL default '',
`sex` enum('m','f') NOT NULL default 'm',
`activation` enum('y','n') NOT NULL default 'y',
`active_code` varchar(100) NOT NULL default '',
`level` enum('a','b','c') NOT NULL default 'c',
`ip` varchar(50) NOT NULL default '',
`num_msg` int(10) unsigned NOT NULL default '10',
PRIMARY KEY (`id`),
KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Dumping data for table `users`
--

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

--
-- Table structure for table `Users`
--

DROP TABLE IF EXISTS `Users`;
CREATE TABLE IF NOT EXISTS `Users` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Username` varchar(255) default NULL,
`FirstName` varchar(50) default NULL,
`LastName` varchar(50) default NULL,
`AgeGroup` varchar(50) default NULL,
`Country` varchar(50) default NULL,
`Password` varchar(255) default NULL,
`Email` varchar(255) default '',
`Sms` smallint(6) default '1',
`JoinedDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`BanHISTORY` int(11) NOT NULL default '0',
`TextPM` int(11) NOT NULL default '1',
`VoicePM` int(11) NOT NULL default '1',
`Invisible` int(11) NOT NULL default '0',
`WebCAM` int(11) NOT NULL default '1',
`Mode` int(11) NOT NULL default '0',
`Color` varchar(50) default '1010101',
`isAdmin` int(11) NOT NULL default '0',
`Sex` int(11) NOT NULL default '0',
`random` int(11) NOT NULL default '0',
`Activate` int(11) NOT NULL default '0',
`TalkLimit` int(20) NOT NULL default '300000',
`ShowIP` int(11) NOT NULL default '0',
`VoiceClip` tinyint(1) default '1' COMMENT 'User''s Voice Clip',
PRIMARY KEY (`ID`),
KEY `Username` (`Username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=125 ;

--
-- Dumping data for table `Users`
--

INSERT INTO `Users` (`ID`, `Username`, `FirstName`, `LastName`, `AgeGroup`, `Country`, `Password`, `Email`, `Sms`, `JoinedDate`, `BanHISTORY`, `TextPM`, `VoicePM`, `Invisible`, `WebCAM`, `Mode`, `Color`, `isAdmin`, `Sex`, `random`, `Activate`, `TalkLimit`, `ShowIP`, `VoiceClip`) VALUES

أما الاصدار فهو

MySQL client version: 5.0.81

up