Xhtml Sp Script (dated)

**crazybrumi** · 05.04.08, 09:30

Code:

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- [url]http://www.phpmyadmin.net[/url]
--
-- Host: localhost
-- Generation Time: Apr 05, 2008 at 10:29 AM
-- 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 `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` VALUES(1, &#39;admin&#39;, &#39;123456&#39;, 1, 0, 1, 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, 1, 1, 1, 1, 1, 1, &#39;P.M&#39;, &#39;Buddy&#39;, &#39;yes&#39;, 0, &#39;r7bqtw0r&#39;, &#39;no&#39;, 0, &#39;0&#39;);

there ya go m8

**opticalpigion** · 05.04.08, 16:23

thanks buddy !!
i think theres no option for shout ?
or there is no shoutbox in your script
but its still great and everyfunction is working !

**nclemale36** · 05.04.08, 16:35

thanks buddy !!
i think theres no option for shout ?
or there is no shoutbox in your script
but its still great and everyfunction is working ![/b]

i aint looked at script properly but used to use similiar . shout may be quotes in owners tools . u also got frontpage which may be called fp in owners tools .

**rukiya** · 05.04.08, 17:18

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 ![/b]

it will be

Code:

UPDATE members  SET owner =&#39;1&#39; WHERE username=&#39;admin&#39;

**crazybrumi** · 05.04.08, 21:27

it will be

Code:

UPDATE members  SET owner =&#39;1&#39; WHERE username=&#39;admin&#39;

[/b]

yeh partly but also

Code:

UPDATE members  SET owner =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET stars =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET validation =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET fp =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET ban =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET unban =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET deletem =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET deletepms =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET pass = &#39;1&#39; WHERE username=&#39;admin&#39;

deletem is the permission that allows someone to delete a member and pass shows everyones password

**opticalpigion** · 06.04.08, 01:01

hey one more question..
when i update my profiles.. its became blank again..
i cant see anything without pw in members n my profile too.

**crazybrumi** · 06.04.08, 10:20

Code:

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

-- 
-- 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(255) NOT NULL default &#39;&#39;,
  `picture` varchar(100) NOT NULL default &#39;&#39;,
  `onlinetime` bigint(255) NOT NULL default &#39;0&#39;,
  `country` varchar(50) NOT NULL default &#39;&#39;,
  `race` varchar(50) NOT NULL default &#39;&#39;,
  `eyes` varchar(50) NOT NULL default &#39;&#39;,
  `body` varchar(50) NOT NULL default &#39;&#39;,
  `height` varchar(100) NOT NULL default &#39;&#39;,
  `waist` varchar(100) NOT NULL default &#39;&#39;,
  `hair` varchar(100) NOT NULL default &#39;&#39;,
  `favfood` varchar(100) NOT NULL default &#39;&#39;,
  `favmusic` varchar(100) NOT NULL default &#39;&#39;,
  `favcolour` varchar(100) NOT NULL default &#39;&#39;,
  `favthing` varchar(100) NOT NULL default &#39;&#39;,
  `favplace` varchar(100) NOT NULL default &#39;&#39;,
  `starsign` varchar(100) NOT NULL default &#39;&#39;,
  `sexuality` varchar(100) NOT NULL default &#39;&#39;,
  `marital` varchar(100) NOT NULL default &#39;&#39;,
  `partner` varchar(100) NOT NULL default &#39;&#39;,
  `interests` varchar(100) NOT NULL default &#39;&#39;,
  `happy` varchar(100) NOT NULL default &#39;&#39;,
  `sad` varchar(100) NOT NULL default &#39;&#39;,
  `badhabits` varchar(100) NOT NULL default &#39;&#39;,
  `here` varchar(30) NOT NULL default &#39;main menu&#39;,
  `page` varchar(120) NOT NULL default &#39;welcome.php?&#39;,
  `showon` tinyint(3) NOT NULL default &#39;1&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

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


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

**crazybrumi** · 06.04.08, 10:21

replace the above with the profile table in ya database

**opticalpigion** · 06.04.08, 15:59

MySQL returned an empty result set (i.e. zero rows). (Query took 0.1335 sec)
it show me this line and then sql query !

and then same blank profile after updating

**rukiya** · 06.04.08, 17:01

yeh partly but also

Code:

UPDATE members  SET owner =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET stars =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET validation =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET fp =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET ban =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET unban =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET deletem =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET deletepms =&#39;1&#39; WHERE username=&#39;admin&#39;

Code:

UPDATE members  SET pass = &#39;1&#39; WHERE username=&#39;admin&#39;

deletem is the permission that allows someone to delete a member and pass shows everyones password [/b]

i have just correted opticalpigion's wrong sql query.
why should any1 use 9 sql update queries when it can be done with only one sql update query?like

Code:

UPDATE members  SET owner =&#39;1&#39;, pass = &#39;1&#39;,validation =&#39;1&#39;,fp =&#39;1&#39;,ban =&#39;1&#39; , unban =&#39;1&#39; , deletem =&#39;1&#39; ,deletepms =&#39;1&#39;,pass = &#39;1&#39; WHERE username=&#39;admin&#39;

**crazybrumi** · 06.04.08, 17:26

i have just correted opticalpigion's wrong sql query.
why should any1 use 9 sql update queries when it can be done with only one sql update query?like

Code:

UPDATE members  SET owner =&#39;1&#39;, pass = &#39;1&#39;,validation =&#39;1&#39;,fp =&#39;1&#39;,ban =&#39;1&#39; , unban =&#39;1&#39; , deletem =&#39;1&#39; ,deletepms =&#39;1&#39;,pass = &#39;1&#39; WHERE username=&#39;admin&#39;

[/b]

he isnt doing this via the script but database! also i have givern him the tools! so your reply was useless as he as alredi got into the site!

**crazybrumi** · 06.04.08, 17:28

MySQL returned an empty result set (i.e. zero rows). (Query took 0.1335 sec)
it show me this line and then sql query !

and then same blank profile after updating[/b]

wel you cant update something when theres nothing to update lol, so insert giberish via the database then go to update profile in the script then it will work and update via the script

**rukiya** · 06.04.08, 20:24

he isnt doing this via the script but database! also i have givern him the tools! so your reply was useless as he as alredi got into the site![/b]

I dont post useless posts.I asked You a question in my post.

why should any1 use 9 sql update queries when it can be done with only one sql update query?[/b]

Code:

UPDATE members  SET owner =&#39;1&#39;, pass = &#39;1&#39;,validation =&#39;1&#39;,fp =&#39;1&#39;,ban =&#39;1&#39; , unban =&#39;1&#39; , deletem =&#39;1&#39; ,deletepms =&#39;1&#39;,pass = &#39;1&#39; WHERE username=&#39;admin&#39;

is a DATABASE code not PHP scripting code,ok?

**crazybrumi** · 06.04.08, 20:44

I dont post useless posts.I asked You a question in my post.

Code:

UPDATE members  SET owner =&#39;1&#39;, pass = &#39;1&#39;,validation =&#39;1&#39;,fp =&#39;1&#39;,ban =&#39;1&#39; , unban =&#39;1&#39; , deletem =&#39;1&#39; ,deletepms =&#39;1&#39;,pass = &#39;1&#39; WHERE username=&#39;admin&#39;

is a DATABASE code not PHP scripting code,ok?[/b]

??

**opticalpigion** · 07.04.08, 11:00

hi i try to update my profile thrue database
but it show me
this error "#1064 - 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 '' at line 1 "
i was use this sql query

Code:

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

-- 
-- 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(255) NOT NULL default &#39;&#39;,
  `picture` varchar(100) NOT NULL default &#39;&#39;,
  `onlinetime` bigint(255) NOT NULL default &#39;0&#39;,
  `country` varchar(50) NOT NULL default &#39;&#39;,
  `race` varchar(50) NOT NULL default &#39;&#39;,
  `eyes` varchar(50) NOT NULL default &#39;&#39;,
  `body` varchar(50) NOT NULL default &#39;&#39;,
  `height` varchar(100) NOT NULL default &#39;&#39;,
  `waist` varchar(100) NOT NULL default &#39;&#39;,
  `hair` varchar(100) NOT NULL default &#39;&#39;,
  `favfood` varchar(100) NOT NULL default &#39;&#39;,
  `favmusic` varchar(100) NOT NULL default &#39;&#39;,
  `favcolour` varchar(100) NOT NULL default &#39;&#39;,
  `favthing` varchar(100) NOT NULL default &#39;&#39;,
  `favplace` varchar(100) NOT NULL default &#39;&#39;,
  `starsign` varchar(100) NOT NULL default &#39;&#39;,
  `sexuality` varchar(100) NOT NULL default &#39;&#39;,
  `marital` varchar(100) NOT NULL default &#39;&#39;,
  `partner` varchar(100) NOT NULL default &#39;&#39;,
  `interests` varchar(100) NOT NULL default &#39;&#39;,
  `happy` varchar(100) NOT NULL default &#39;&#39;,
  `sad` varchar(100) NOT NULL default &#39;&#39;,
  `badhabits` varchar(100) NOT NULL default &#39;&#39;,
  `here` varchar(30) NOT NULL default &#39;main menu&#39;,
  `page` varchar(120) NOT NULL default &#39;welcome.php?&#39;,
  `showon` tinyint(3) NOT NULL default &#39;1&#39;,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

-- 
-- Dumping data for table `profile`
-- 
INSERT INTO `profile` (`id`, `username`, `name`, `age`, `sex`, `location`, `about`, `picture`, `onlinetime`, `country`, `race`, `eyes`, `body`, `height`, `waist`, `hair`, `favfood`, `favmusic`, `favcolour`, `favthing`, `favplace`, `starsign`, `sexuality`, `marital`, `partner`, `intrests`, `happy`, `sad`, `badhabits`, `here`, `page`, `showon`) VALUES (1, &#39;vishal&#39;, &#39;Vishal&#39;, &#39;21&#39;, &#39;male&#39;, &#39;Gujarat&#39;, &#39;Student&#39;, &#39;&#39;, &#39;0&#39;, &#39;India&#39;, &#39;&#39;, &#39;Black&#39;, &#39;Average&#39;, &#39;5.7&#39;, &#39;&#39;, &#39;Black&#39;, &#39;w/e my mammi cook&#39;, &#39;Depents On Mood&#39;, &#39;Red And Sky Blue&#39;, &#39;to make different sites&#39;, &#39;my Home&#39;, &#39;Taurus&#39;, &#39;Straight&#39;, &#39;Single&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;, &#39;&#39;),


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

what to do now?

Xhtml Sp Script (dated)

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment