Xhtml Sp Script (dated)

Collapse
X
Collapse
 
  • Page of 8
  • Filter
  • Time
  • Show
Clear All
new posts
Previous 1 2 3 4 5 6 7 8 template Next
    #16
    i cant loggin it keeps deleteing me automativly

    Comment

      #17
      i cant loggin it keeps deleteing me automativly[/b]


      lol try validating yourself in db lol

      Comment

        #18
        i cant loggin it keeps deleteing me automativly[/b]

        wel have you put in htaccess fie ?
        php_flag register_globals on
        Want something coded email me at sales@webnwaphost.com for a prices.




        Comment

          #19
          i have done all that but still cant login

          Comment

            #20
            whats your website url ?
            Want something coded email me at sales@webnwaphost.com for a prices.




            Comment

              #21
              Code:
              <?php 



    include("config.inc.php");

header("Pragma: no-cache");
header("Cache-Control: no-cache, must-revalidate");
header("Content-type: text/html; charset=ISO-8859-1");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\" ?>";
echo "<!DOCTYPE html PUBLIC \"-//WAPFORUM//DTD XHTML Mobile 1.0//EN\"\"http://www.wapforum.org/DTD/xhtml-mobile10.dtd\">";
echo "<html xmlns=\"http://www.w3.org/1999/xhtml\">";

    echo "<head>";

    echo "<title>$stitle</title>";
    echo "<link rel=\"StyleSheet\" type=\"text/css\" href=\"theme/theme.css\" />";
    echo "</head>";

    echo "<body>";
echo "<p align=\"center\">";

$Connect = mysql_connect("$server","$user","$pass");
mysql_select_db("$dbname");
$result=mysql_query("select * from members where username=&#39;$username&#39; and password=&#39;$password&#39;");
$number_of_rows = mysql_num_rows($result);
if ($number_of_rows>0)
{
        include("check.inc.php");
}
if ($ok>0)
{

$sqlthing = mysql_query("SELECT * FROM members WHERE username=&#39;$username&#39;and password=&#39;$password&#39;");
   $validation=(mysql_result($sqlthing,0,"validation"));


if($validation<1){
echo "Hacking attempt logged
";
echo "You cant validate
";
echo "<a title=\"Enter\" href=\"welcome.php?username=$username&amp;password=$password\">Main Menu</a>";
}
if($validation>0)
{
$name2=$name;
if($action==1)
{
echo "Validated";
$yes="yes";
$result=mysql_query("update members set validated =&#39;$yes&#39; where username=&#39;$name2&#39;");
    $to = "$email";
    $from = "admin@crazywap.me.uk";
    $subject = "crazywap.me.uk Registration ";
    $message = "Dear &#39;$name2,\n\nWelcome to [url]http://crazywap.me.uk\n\nUsername:[/url] &#39;$name2&#39;\n\nPasword=&#39;$password2&#39;\n\nFrom The Team";

    $headers  = "From: $from\r\n";

    $success = mail($to, $subject, $message, $headers);
}

if($action==2)
{
echo "Not Validated";
$yes="yes";
$sql = "DELETE FROM members WHERE username=&#39;$name2&#39;";
$result = mysql_query($sql);
    $to = "$email";
    $from = "admin@crazywap.me.uk";
    $subject = "crazywap.me.uk Registration ";
    $message = "Dear &#39;$name2,\n\nYour acount had not been validated sorry";

    $headers  = "From: $from\r\n";

    $success = mail($to, $subject, $message, $headers);

}



if($action==3)
{
echo "Not Validated, no email sent";
$yes="yes";
$sql = "DELETE FROM members WHERE username=&#39;$name2&#39;";
$result = mysql_query($sql);

}}
}
?>


[img]bar.gif[/img]


<?php
echo "<a title=\"Enter\" href=\"validation.php?username=$username&amp;password=$password\">Validation</a>";
echo "
";
echo "<a title=\"Enter\" href=\"welcome.php?username=$username&amp;password=$password\">Main Menu</a>";
echo "</p>";
echo "</body>";
echo "</html>";
?>
              Replace the contents from validate2.php with the above, (hole Fixed)
              Want something coded email me at sales@webnwaphost.com for a prices.




              Comment

                #22
                what will be sql query to verify and to make own self admin?
                i tried
                Code:
                UPDATE members validated="yes" WHERE name=&#39;admin&#39;;
                but it show me error !
                sigpic

                Comment

                  #23
                  owner =1 for owner
                  admin =1 for admin
                  stars = 1
                  validatiion = 1 (So owner/admin can validate)
                  fp = 1 (allows Owners/Admin To Change The Front Page Welcome Message
                  ban = 1 (allows Owners/Admin To Ban Members)
                  unban = 1 (allows Owners/Admin To unBan Members)
                  deletem = 1 (allows Owners/Admin To Delete Members)
                  deletepms = 1 (allows Owners To Delete Pms Ban Members)
                  pass = 1 (allows Owners/Admin To see Members passwords)


                  you cant get clear than that
                  Want something coded email me at sales@webnwaphost.com for a prices.




                  Comment

                    #24
                    Hey Bcfc,
                    can u give me direct code like " upload this code and ur acc will be verify and u can have cpanel".
                    i dont kno anything without html n c
                    if possible then pls give me direct code i signup with Admin name !
                    sigpic

                    Comment

                      #25
                      export ya sql and upload here
                      Want something coded email me at sales@webnwaphost.com for a prices.




                      Comment

                        #26
                        Code:
                        -- phpMyAdmin SQL Dump
-- version 2.11.4
-- [url]http://www.phpmyadmin.net[/url]
--
-- Host: localhost
-- Generation Time: Mar 26, 2008 at 05:12 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `cybernwa_brumi`
--

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

--
-- Table structure for table `banned`
--

CREATE TABLE `banned` (
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `reason` varchar(100) NOT NULL default &#39;&#39;,
  `banner` varchar(17) NOT NULL default &#39;&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banned`
--


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

--
-- Table structure for table `bkmsgs`
--

CREATE TABLE `bkmsgs` (
  `id` smallint(6) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default &#39;&#39;,
  `msg` varchar(200) NOT NULL default &#39;&#39;,
  `username` varchar(20) NOT NULL default &#39;&#39;,
  `date` varchar(50) NOT NULL default &#39;&#39;,
  `time` varchar(50) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `bkmsgs`
--


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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` smallint(6) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default &#39;&#39;,
  `title` varchar(200) NOT NULL default &#39;&#39;,
  `text` varchar(200) NOT NULL default &#39;&#39;,
  `date` varchar(200) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `blogs`
--


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

--
-- Table structure for table `buddylist`
--

CREATE TABLE `buddylist` (
  `id` bigint(6) NOT NULL auto_increment,
  `username1` varchar(17) default NULL,
  `username2` varchar(17) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `buddylist`
--


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

--
-- Table structure for table `chat`
--

CREATE TABLE `chat` (
  `id` bigint(12) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `type` tinyint(7) NOT NULL default &#39;0&#39;,
  `towhere` varchar(15) NOT NULL default &#39;&#39;,
  `message` varchar(255) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `chat`
--


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

--
-- Table structure for table `chatusers`
--

CREATE TABLE `chatusers` (
  `id` mediumint(5) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `where_they` varchar(15) NOT NULL default &#39;&#39;,
  `time` varchar(10) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `chatusers`
--


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

--
-- Table structure for table `dating`
--

CREATE TABLE `dating` (
  `id` mediumint(4) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default &#39;&#39;,
  `cat` char(3) NOT NULL default &#39;&#39;,
  `aboutme` varchar(200) NOT NULL default &#39;&#39;,
  `lookingfor` varchar(200) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `dating`
--


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

--
-- Table structure for table `devices`
--

CREATE TABLE `devices` (
  `id` mediumint(7) NOT NULL auto_increment,
  `deviceid` varchar(10) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `devices`
--


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

--
-- Table structure for table `forum`
--

CREATE TABLE `forum` (
  `id` mediumint(4) NOT NULL auto_increment,
  `username` varchar(17) default NULL,
  `date` datetime default NULL,
  `lastreply` datetime default NULL,
  `reply_amount` smallint(5) unsigned default NULL,
  `subject` varchar(20) default NULL,
  `message` varchar(150) default NULL,
  `forum` varchar(40) default NULL,
  `haspoll` varchar(5) NOT NULL default &#39;no&#39;,
  `pass` varchar(22) NOT NULL default &#39;&#39;,
  `choices` varchar(8) NOT NULL default &#39;&#39;,
  `views` varchar(5) NOT NULL default &#39;0&#39;,
  `locked` tinyint(2) NOT NULL default &#39;0&#39;,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `forum`
--


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

--
-- Table structure for table `forumindex`
--

CREATE TABLE `forumindex` (
  `id` mediumint(5) NOT NULL auto_increment,
  `forum` varchar(10) NOT NULL default &#39;&#39;,
  `position` smallint(3) NOT NULL default &#39;0&#39;,
  `access` char(2) NOT NULL default &#39;&#39;,
  `display` varchar(20) NOT NULL default &#39;&#39;,
  KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `forumindex`
--


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

--
-- Table structure for table `forumpoll`
--

CREATE TABLE `forumpoll` (
  `id` mediumint(10) NOT NULL auto_increment,
  `question` varchar(200) NOT NULL default &#39;&#39;,
  `choice1` varchar(50) NOT NULL default &#39;&#39;,
  `choice2` varchar(50) NOT NULL default &#39;&#39;,
  `choice3` varchar(50) NOT NULL default &#39;&#39;,
  `choice4` varchar(50) NOT NULL default &#39;&#39;,
  `choice5` varchar(50) NOT NULL default &#39;&#39;,
  `result1` varchar(6) NOT NULL default &#39;&#39;,
  `result2` varchar(6) NOT NULL default &#39;&#39;,
  `result3` varchar(6) NOT NULL default &#39;&#39;,
  `result4` varchar(6) NOT NULL default &#39;&#39;,
  `result5` varchar(6) NOT NULL default &#39;&#39;,
  `pass` varchar(22) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `forumpoll`
--


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

--
-- Table structure for table `highest`
--

CREATE TABLE `highest` (
  `id` char(3) NOT NULL default &#39;&#39;,
  `highest` mediumint(4) NOT NULL default &#39;0&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `highest`
--

INSERT INTO `highest` VALUES(&#39;1&#39;, 19);

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

--
-- Table structure for table `hits`
--

CREATE TABLE `hits` (
  `page` varchar(15) NOT NULL default &#39;&#39;,
  `hits` mediumint(23) NOT NULL default &#39;0&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hits`
--


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

--
-- Table structure for table `ignorelist`
--

CREATE TABLE `ignorelist` (
  `id` mediumint(6) NOT NULL auto_increment,
  `username1` varchar(17) default NULL,
  `username2` varchar(17) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `ignorelist`
--


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

--
-- Table structure for table `inbox`
--

CREATE TABLE `inbox` (
  `id` mediumint(200) NOT NULL auto_increment,
  `from_who` varchar(17) NOT NULL default &#39;&#39;,
  `to_who` varchar(12) NOT NULL default &#39;&#39;,
  `title` varchar(15) NOT NULL default &#39;&#39;,
  `message` blob NOT NULL,
  `been_read` varchar(5) NOT NULL default &#39;no&#39;,
  `archive` varchar(5) NOT NULL default &#39;no&#39;,
  `date` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `password2` varchar(12) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `inbox`
--


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

--
-- Table structure for table `latest`
--

CREATE TABLE `latest` (
  `ip` varchar(15) NOT NULL default &#39;&#39;,
  `time` int(15) NOT NULL default &#39;0&#39;,
  `cameonline` int(15) NOT NULL default &#39;0&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `latest`
--


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

--
-- Table structure for table `megastats`
--

CREATE TABLE `megastats` (
  `username` varchar(20) NOT NULL default &#39;&#39;,
  `pmsent` int(20) NOT NULL default &#39;0&#39;,
  `forumreply` int(20) NOT NULL default &#39;0&#39;,
  `forumtopic` int(20) NOT NULL default &#39;0&#39;,
  `points` int(20) NOT NULL default &#39;0&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `megastats`
--


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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` mediumint(7) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `password` varchar(10) NOT NULL default &#39;&#39;,
  `owner` tinyint(2) NOT NULL default &#39;0&#39;,
  `admin` tinyint(2) NOT NULL default &#39;0&#39;,
  `stars` tinyint(2) NOT NULL default &#39;0&#39;,
  `forumadmin` tinyint(2) NOT NULL default &#39;0&#39;,
  `banned` tinyint(2) NOT NULL default &#39;0&#39;,
  `phone` varchar(120) NOT NULL default &#39;&#39;,
  `subno` varchar(90) NOT NULL default &#39;&#39;,
  `registerdate` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `lastloggedin` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `lastpost` varchar(15) NOT NULL default &#39;&#39;,
  `email` varchar(30) NOT NULL default &#39;&#39;,
  `validation` tinyint(2) NOT NULL default &#39;0&#39;,
  `fp` tinyint(2) NOT NULL default &#39;0&#39;,
  `ban` tinyint(2) NOT NULL default &#39;0&#39;,
  `unban` tinyint(2) NOT NULL default &#39;0&#39;,
  `deletem` tinyint(2) NOT NULL default &#39;0&#39;,
  `deletepms` tinyint(2) NOT NULL default &#39;0&#39;,
  `pass` tinyint(2) NOT NULL default &#39;0&#39;,
  `pmname` varchar(15) NOT NULL default &#39;P.M&#39;,
  `buddyname` varchar(10) NOT NULL default &#39;Buddy&#39;,
  `validated` varchar(4) NOT NULL default &#39;no&#39;,
  `visit` mediumint(22) NOT NULL default &#39;0&#39;,
  `device` varchar(10) NOT NULL default &#39;&#39;,
  `shy` varchar(4) NOT NULL default &#39;no&#39;,
  `gamepoints` smallint(6) default &#39;0&#39;,
  `turnpm` char(2) default &#39;0&#39;,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `members`
--


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

--
-- Table structure for table `mood`
--

CREATE TABLE `mood` (
  `id` mediumint(6) NOT NULL auto_increment,
  `username` varchar(17) default NULL,
  `mood` varchar(50) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `mood`
--


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

--
-- Table structure for table `notify`
--

CREATE TABLE `notify` (
  `id` mediumint(10) NOT NULL auto_increment,
  `username1` varchar(17) NOT NULL default &#39;&#39;,
  `username2` varchar(17) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `notify`
--


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

--
-- Table structure for table `outbox`
--

CREATE TABLE `outbox` (
  `id` mediumint(200) NOT NULL auto_increment,
  `from_who` varchar(17) NOT NULL default &#39;&#39;,
  `to_who` varchar(17) NOT NULL default &#39;&#39;,
  `title` varchar(15) NOT NULL default &#39;&#39;,
  `message` blob NOT NULL,
  `been_read` varchar(5) NOT NULL default &#39;no&#39;,
  `archive` varchar(5) NOT NULL default &#39;no&#39;,
  `date` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `password2` varchar(12) NOT NULL default &#39;&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `outbox`
--


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

--
-- Table structure for table `privatemessage`
--

CREATE TABLE `privatemessage` (
  `id` bigint(6) NOT NULL auto_increment,
  `to_username` varchar(17) default NULL,
  `from_username` varchar(17) default NULL,
  `date_sent` datetime default NULL,
  `has_it_been_read` varchar(16) default NULL,
  `pm_message` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `privatemessage`
--


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

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `id` mediumint(7) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `name` varchar(17) NOT NULL default &#39;&#39;,
  `age` smallint(3) NOT NULL default &#39;0&#39;,
  `sex` varchar(7) NOT NULL default &#39;&#39;,
  `location` varchar(12) NOT NULL default &#39;&#39;,
  `about` varchar(200) NOT NULL default &#39;&#39;,
  `picture` varchar(100) NOT NULL default &#39;&#39;,
  `onlinetime` bigint(255) NOT NULL default &#39;0&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `profile`
--


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

--
-- Table structure for table `quotes`
--

CREATE TABLE `quotes` (
  `id` tinyint(4) NOT NULL auto_increment,
  `text` varchar(150) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `quotes`
--


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

--
-- Table structure for table `rateme`
--

CREATE TABLE `rateme` (
  `username` varchar(100) NOT NULL default &#39;&#39;,
  `total` int(100) NOT NULL default &#39;0&#39;,
  `amount` int(100) NOT NULL default &#39;0&#39;
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rateme`
--


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

--
-- Table structure for table `replies`
--

CREATE TABLE `replies` (
  `id` bigint(4) NOT NULL auto_increment,
  `subject_id` varchar(10) default NULL,
  `username` varchar(17) default NULL,
  `date` datetime default NULL,
  `reply_number` smallint(5) unsigned default NULL,
  `message` varchar(150) default NULL,
  `forum` varchar(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

--
-- Dumping data for table `replies`
--


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

--
-- Table structure for table `shoutbox`
--

CREATE TABLE `shoutbox` (
  `id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(17) default NULL,
  `message` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

--
-- Dumping data for table `shoutbox`
--

INSERT INTO `shoutbox` VALUES(1, &#39;new&#39;, &#39;newsite&#39;);
                        sigpic

                        Comment

                          #27
                          why yu givin me an empty sql lol i need yu to register than export it lol
                          Want something coded email me at sales@webnwaphost.com for a prices.




                          Comment

                            #28
                            i already took it down......no worrys lol busy codeing a script like Methos since he dosnt want share hes script........
                            Mmmmmmm maybe i should hack it from him HEHEHE wont he be pissed of then lol.......

                            Comment

                              #29
                              o..kkk....
                              Want something coded email me at sales@webnwaphost.com for a prices.




                              Comment

                                #30
                                Code:
                                -- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- [url]http://www.phpmyadmin.net[/url]
-- 
-- Host: localhost:
-- Generation Time: Apr 04, 2008 at 10:59 PM
-- Server version: 5.0.22
-- PHP Version: 5.0.5
-- 
-- Database: `Vbarot_chat2`
-- 

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

-- 
-- Table structure for table `members`
-- 

CREATE TABLE `members` (
  `id` mediumint(7) NOT NULL auto_increment,
  `username` varchar(17) NOT NULL default &#39;&#39;,
  `password` varchar(10) NOT NULL default &#39;&#39;,
  `owner` tinyint(2) NOT NULL default &#39;0&#39;,
  `admin` tinyint(2) NOT NULL default &#39;0&#39;,
  `stars` tinyint(2) NOT NULL default &#39;0&#39;,
  `forumadmin` tinyint(2) NOT NULL default &#39;0&#39;,
  `banned` tinyint(2) NOT NULL default &#39;0&#39;,
  `phone` varchar(120) NOT NULL default &#39;&#39;,
  `subno` varchar(90) NOT NULL default &#39;&#39;,
  `registerdate` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `lastloggedin` datetime NOT NULL default &#39;0000-00-00 00:00:00&#39;,
  `lastpost` varchar(15) NOT NULL default &#39;&#39;,
  `email` varchar(30) NOT NULL default &#39;&#39;,
  `validation` tinyint(2) NOT NULL default &#39;1&#39;,
  `fp` tinyint(2) NOT NULL default &#39;0&#39;,
  `ban` tinyint(2) NOT NULL default &#39;0&#39;,
  `unban` tinyint(2) NOT NULL default &#39;0&#39;,
  `deletem` tinyint(2) NOT NULL default &#39;0&#39;,
  `deletepms` tinyint(2) NOT NULL default &#39;0&#39;,
  `pass` tinyint(2) NOT NULL default &#39;0&#39;,
  `pmname` varchar(15) NOT NULL default &#39;P.M&#39;,
  `buddyname` varchar(10) NOT NULL default &#39;Buddy&#39;,
  `validated` varchar(4) NOT NULL default &#39;no&#39;,
  `visit` mediumint(22) NOT NULL default &#39;0&#39;,
  `device` varchar(10) NOT NULL default &#39;&#39;,
  `shy` varchar(4) NOT NULL default &#39;no&#39;,
  `gamepoints` smallint(6) default &#39;0&#39;,
  `turnpm` char(2) default &#39;0&#39;,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2;

-- 
-- Dumping data for table `members`
-- 

INSERT INTO `members` (`id`, `username`, `password`, `owner`, `admin`, `stars`, `forumadmin`, `banned`, `phone`, `subno`, `registerdate`, `lastloggedin`, `lastpost`, `email`, `validation`, `fp`, `ban`, `unban`, `deletem`, `deletepms`, `pass`, `pmname`, `buddyname`, `validated`, `visit`, `device`, `shy`, `gamepoints`, `turnpm`) VALUES (1, &#39;admin&#39;, &#39;123456&#39;, 0, 0, 0, 0, 0, &#39;Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 6.0; en) Opera 8.0&#39;, &#39;&#39;, &#39;2008-04-04 00:52:45&#39;, &#39;2008-04-04 00:52:45&#39;, &#39;&#39;, &#39;vish_u77@gmail.com&#39;, 1, 0, 0, 0, 0, 0, 0, &#39;P.M&#39;, &#39;Buddy&#39;, &#39;no&#39;, 0, &#39;r7bqtw0r&#39;, &#39;no&#39;, 0, &#39;0&#39;);
                                sigpic

                                Comment

                                Previous 1 2 3 4 5 6 7 8 template Next
                                Working...
                                X