Jump to content

Problem with mysql query not running with script

dev0

By dev0
in Third Party Scripts

 Share

Recommended Posts

dev0 Newbie

dev0

Posted
Posted

Hello,

Im new to Mysql / PHP and i just got a Script and only having one problem with it.

 

When you enter a ID / User name and hit submit it says Invalid ID any old id's already in the DB work fine. i think it has to be in one of these fines sadly i don't know what im looking for.

 

index.php

<?
session_start();
if(session_is_registered(fid)){
header("location:home.php");
}
else {
include("function.inc.php");
$sql = "SELECT * FROM xtrm_css WHERE id = '1'";
$res = mysql_query($sql);
echo mysql_error();
$css=mysql_fetch_array($res); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html><head>
<?PHP if($css[passonoff]==1) { ?>
<style type="text/css">
<!--
#sponsorAdDiv {position:absolute; height:1; width:1px; top:0; left:0;}
-->
</style>

<script type="text/javascript">

/******************************************
* DHTML Ad Box (By Matt Gabbert at http://www.nolag.com)
* Visit http://www.dynamicdrive.com/ for full script
* This notice must stay intact for use
******************************************/

adTime=10;  // seconds ad reminder is shown
chanceAd=1; // ad will be shown 1 in X times (put 1 for everytime)

var ns=(document.layers);
var ie=(document.all);
var w3=(document.getElementById && !ie);
var calunit=ns? "" : "px"
adCount=0;
function initAd(){
    if(!ns && !ie && !w3) return;
    if(ie)        adDiv=eval('document.all.sponsorAdDiv.style');
    else if(ns)    adDiv=eval('document.layers["sponsorAdDiv"]');
    else if(w3)    adDiv=eval('document.getElementById("sponsorAdDiv").style');
    randAd=Math.ceil(Math.random()*chanceAd);
        if (ie||w3)
        adDiv.visibility="visible";
        else
        adDiv.visibility ="show";
    if(randAd==1) showAd();
}
function showAd(){
if(adCount<adTime*10){adCount+=1;
    if (ie){documentWidth  =truebody().offsetWidth/2+truebody().scrollLeft-20;
    documentHeight =truebody().offsetHeight/2+truebody().scrollTop-20;}    
    else if (ns){documentWidth=window.innerWidth/2+window.pageXOffset-20;
    documentHeight=window.innerHeight/2+window.pageYOffset-20;} 
    else if (w3){documentWidth=self.innerWidth/2+window.pageXOffset-20;
    documentHeight=self.innerHeight/2+window.pageYOffset-20;} 
    adDiv.left=documentWidth-150+calunit;adDiv.top =documentHeight-100+calunit;
    setTimeout("showAd()",100);}else closeAd();
}
function closeAd(){
if (ie||w3)
adDiv.display="none";
else
adDiv.visibility ="hide";
}

function truebody(){
return (document.compatMode && document.compatMode!="BackCompat")? document.documentElement : document.body
}

onload=initAd;
//End-->
</script>
<?PHP }?>
<style>
body {
margin: 0;
background-color: <?PHP echo "$css[bodybg]";?>;
background-image: url(<?PHP echo "$css[bodyimage]";?>);
font: 12px <?PHP echo "$css[bodyfont]";?>;
color: <?PHP echo "$css[bodyfontcolor]";?>;
}
a img {
border: none;
}
a:hover img {
opacity:.25;
filter:alpha(opacity=25);
}
a:visited img {
opacity:.10;
filter:alpha(opacity=10);
}
A:link {
text-decoration: none;
color: <?PHP echo "$css[link]";?>;
font: 12px;
}
A:visited {
text-decoration: none;
font: 12px;
color: <?PHP echo "$css[visited]";?>;
}
A:active {
text-decoration: none;
font: 12px;
color: <?PHP echo "$css[active]";?>;
}
A:hover {
text-decoration: none;
color: <?PHP echo "$css[hover]";?>;
font: 12px;
}
#container {
position:relative;
margin: 0 auto;
margin-top:15px;
width:950px;
border: 1px solid <?PHP echo "$css[mainborder]";?>;
background: url(<?PHP echo "$css[mainimage]";?>);
background-repeat: repeat-x; 
background-color: <?PHP echo "$css[mainbg]";?>;
}
#header {
height:100px;
background-color: <?PHP echo "$css[headerbg]";?>;
background-image: url(<?PHP echo "$css[headerimage]";?>);
}
#navbar {
margin: 0 auto;
width:570px;
background-color: transparent;
background-image: url(<?PHP echo "$css[navimage]";?>);
text-align:center;
}
#welcome {
margin: 0 auto;
background-image: url(<?PHP echo "$css[welcomeimage]";?>);
background-color: <?PHP echo "$css[welcomebg]";?>;
margin-top:10px;
width:425px;
text-align:center;
}
#left {
float:left;
width:300px;
background:transparent;
margin-left:10px;
margin-bottom:10px;
margin-top:10px;
}
#right {
float:right;
width:620px;
background:transparent;
margin-right:10px;
margin-left:10px;
margin-bottom:10px;
margin-top:10px;
}
.legend {
color: <?PHP echo "$css[legend]";?>;
border:none;
border-left: 1px solid <?PHP echo "$css[legendborder]";?>;
border-right: 1px solid <?PHP echo "$css[legendborder]";?>;
}
.fieldset {
border:none;
border-top: 1px solid <?PHP echo "$css[fieldsetborder]";?>;
}
.userfieldset {
border:none;
border-top: 1px solid <?PHP echo "$css[userfieldset]";?>;
}
.userlegend {
color: <?PHP echo "$css[userlegend]";?>;
border:none;
}

</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="EN">
<meta name="description" content="Myspace Whore Train">
<meta name="keywords" content="myspace, whore train">
<title><?PHP echo "$css[title]";?></title>
</head>
<body>

<div id="container">
<div id="header"></div>
<div id="navbar" style="width:700px;"><?PHP include("navbar.php");?></div>
<div id="welcome"><?PHP echo "$css[welcome]";?></div>

<div id="left">
<fieldset class="fieldset"><legend class="legend">User Login</legend>
To find your friend ID:<br>
<b>1.</b> <a href="http://home.myspace.com/index.cfm?fuseaction=user" target="_blank">Goto your Myspace homepage</a><br>
<b>2.</b> Click "Profile" in the <b>View My</b> section.<br>
<b>3.</b> In the address bar of your browser<br>
    copy the numbers after friendid=<br>
<center><small>Example</small><br><img src="/graphics/url.JPG"></center><br><small>You may also just right click your <b>View My Profile</b> link and Copy Shortcut/Copy Link Location, and then paste it in the Friend ID box below!</small><br><br>
<?PHP if($css[passonoff]==1) { ?>
<form action="login.php" method="post">
<table>
<tr><td align=right>Friend ID:</td><td valign=top><input type="text" name="fid" onkeyup="javascript:this.value=this.value.replace(/[^0-9]/g, '');"><?php if(isset($_GET['new'])) { ?>
                 <input type="hidden" name="new" value="<?=$_GET['new']?>" />
          <?php }?></td></tr><td align=right>Password:</td><td>
<input type="password" name="password" value=""></td></tr><td> </td><td><small><font color="red">Password only needed<br> if you set one!<br>This is not your Myspace password!</small></font></td><tr><td> </td><td>
<input type="submit" name="submit" value="Login" style="color:#FFFFFF;background: url(/graphics/nav.gif);"></td></tr></table>
</form>
<br>
You don't need to use a password!  This option is available for you to protect your image and name settings on this site only!  Has someone set a password on your friend ID before you?<br><center><a href="help.php">Fix that here!</a></center><?PHP } else { ?>
<form action="login.php" method="post">
<table>
<tr><td align=right>Friend ID:</td><td valign=top><input type="text" name="fid" onkeyup="javascript:this.value=this.value.replace(/[^0-9]/g, '');"><?php if(isset($_GET['new'])) { ?>
                 <input type="hidden" name="new" value="<?=$_GET['new']?>" />
          <?php }?></td></tr><tr><td> </td><td>
<input type="submit" name="submit" value="Login" style="color:#FFFFFF;background: url(/graphics/nav.gif);"></td></tr></table>
</form><?PHP }?>
</fieldset>
</div> 

<div id="right"><fieldset class="fieldset"><legend class="legend">VIP Users</legend>
<?php
$vips   = $userobject->VipUsers();
$counter = 0;
$columns = 8;
{ ?>
<center>
<table width="50%" border="0" cellspacing="0" cellpadding="5"><tr>
<?php while($user = $dbcon->mysqlfetch($vips)) { ?>

<td align="center"><a href="http://collect.myspace.com/index.cfm?fuseaction=invite.addfriend_verify&friendID=<?=$user['fid']?>" target="_blank"><img src="<?=$user['pic']?>" width="60" height="60" border="0"><br><small><?=$user['days']?> days</small></a></td>
<?php $counter++; if($counter%$columns==0) echo "<tr></tr>"; } ?></tr></table></center>
<?php } ?>
</fieldset>
</div>

<br clear="all" />
</div>
<br>
<center>XtremeAddz.com is not affiliated with myspace in any way.</center>
<center>Please do not spam the bulletin boards. </center>
<?PHP if($css[passonoff]==1) { ?>
<div id="sponsorAdDiv" style="visibility:hidden">
<table width="350px" height="175px" bgcolor="#FFFFFF"><tr><td>
<table width="345px" height="170px" bgcolor="#777777"><tr><td align="center" valign="middle">

<!--*****EDIT THIS MESSAGE*****-->
<h1>Warning!</h1><br>
This page may contain adult content!<br>
If you are not 18 years old or older<br>
Please go <a href="http://myspace.com">here.</a><br>
<br>
<small>This window will close automatically.</small><br>

<!--*****EDIT THE ABOVE MESSAGE*****-->
</td></tr></table></td></tr></table>
</div><?PHP }?>
</body>
</html>
<?PHP  }?>

 

 

 

login.php

<?php
session_start();
if(isset($_POST['submit']))
{
include 'config.php';
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$ip   = $_SERVER['REMOTE_ADDR'];


$fid = $_POST['fid'];

$pass = $_POST['password'];
$sql="SELECT * FROM xtrm_users WHERE fid='$fid'";
$result=mysql_query($sql);
$check=mysql_fetch_array($result);
  if($check[fid]==$fid) {
                   if($check[password]=='XtRmWeB') {
mysql_query("UPDATE xtrm_users SET ip = '$ip' WHERE fid = '$fid'");
          $_SESSION["fid"] = $fid;
         header("location:home.php"); }
                       else {
                          if($pass==$check[password]) {
mysql_query("UPDATE xtrm_users SET ip = '$ip' WHERE fid = '$fid'");
                      $_SESSION["fid"] = $fid;
                     header("location:home.php"); }
               else { ?>
                       

<script language="javascript"><!--
alert("Invalid Password!")
location.replace("index.php")
//-->
</script> <?PHP }


                     }
}
else {
define ("profile_url","http://profile.myspace.com/index.cfm?fuseaction=user.viewprofile&friendID=" );
$full_file_path = profile_url.$fid;
$handle = fopen($full_file_path,"r");
    if (!$handle){
        echo "<p>Sorry Myspace Is Slow Try Again.\n";
        $arr = 0; }
    else {
    $timeout = 300;
    ini_set('max_execution_time','120');
    set_time_limit(120);
    ini_set('default_socket_timeout','120');
    while($contents = fread($handle,'1024'))
    { $hold .= $contents; }
    preg_match("/<a id=\"ctl00_Main_ctl01_UserBasicInformation1_hlDefaultImage\" rel=\"searchMonkey-photo\" href=\"http:\/\/viewmorepics.myspace.com\/index\.cfm\?fuseaction=user\..*?friendID=$fid\">.*?<\s*img [^\>]*src=\"([^\">]+)/is",$hold,$match);
    $pic_url = $match[1];
preg_match("/<span class=\"nametext\">(.*)<br \/>/",$hold,$match);
$name = $match[1];
        if(empty($pic_url))
        {
        preg_match("/<a type=\"text\/javascript\" id=\"ctl00_Main_ctl01_UserBasicInformation1_hlDefaultImage\" rel=\"searchMonkey-photo\" href=\"http:\/\/viewmorepics.myspace.com\/index\.cfm\?fuseaction=user\..*?friendID=$fid\">.*?<\s*img [^\>]*src=\"([^\">]+)/is",$hold,$match);

        $pic_url = $match[1];
        }
        if(empty($name))
        {
        preg_match("/<span class=\"nametext\">(.*)<\/span>/",$hold,$match);
        $name = $match[1];
        }
        
        fclose($handle);
        ini_restore('max_execution_time');
        ini_restore('default_socket_timeout');
        if(empty($pic_url))
        { ?>
<script language="javascript"><!--
alert("Invalid ID!")
location.replace("index.php")
//-->
</script>
<?PHP
        
        }
else
{
$oldip = $_POST['new'];
$sql = "SELECT * FROM xtrm_users WHERE fid = '$oldip'";
$res = mysql_query($sql);
echo mysql_error();
$check = mysql_fetch_array($res);
   $newip = $check['ip']; 
if($newip!=$ip) {
mysql_query("UPDATE xtrm_users SET points = points+25 WHERE fid = '$oldip'");
mysql_query("UPDATE xtrm_users SET refs = refs+1 WHERE fid = '$oldip'");
}
else {
//add a feature here in the future.. mrnightowl
}


$pic = $pic_url;
mysql_query("INSERT INTO xtrm_users SET 
                pic='$pic_url',
                name='$name', 
                ip='$ip', 
                fid='$fid'");
$_SESSION["fid"] = $fid;
header("location:home.php");
}
}
}
}
?>

 

 

 

home.php

<?
session_start();
if(!session_is_registered(fid)) {
header("location:index.php");
}
else {
include("function.inc.php");
$sql = "SELECT * FROM xtrm_css WHERE id = '1'";
$res = mysql_query($sql);
echo mysql_error();
$css=mysql_fetch_array($res); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<style>
body {
margin: 0;
background-color: <?PHP echo "$css[bodybg]";?>;
background-image: url(<?PHP echo "$css[bodyimage]";?>);
font: 12px <?PHP echo "$css[bodyfont]";?>;
color: <?PHP echo "$css[bodyfontcolor]";?>;
}
a img {
border: none;
}
a:hover img {
opacity:.25;
filter:alpha(opacity=25);
}
a:visited img {
opacity:.10;
filter:alpha(opacity=10);
}
a.pic:visited {
border:none;
opacity:.99;
filter:alpha(opacity=99);
}
a.pic:visited img{
border:none;
opacity:.99;
filter:alpha(opacity=99);
}
A:link {
text-decoration: none;
color: <?PHP echo "$css[link]";?>;
font: 12px;
}
A:visited {
text-decoration: none;
font: 12px;
color: <?PHP echo "$css[visited]";?>;
}
A:active {
text-decoration: none;
font: 12px;
color: <?PHP echo "$css[active]";?>;
}
A:hover {
text-decoration: none;
color: <?PHP echo "$css[hover]";?>;
font: 12px;
}
#container {
position:relative;
margin: 0 auto;
margin-top:15px;
width:950px;
border: 1px solid <?PHP echo "$css[mainborder]";?>;
background: url(<?PHP echo "$css[mainimage]";?>);
background-repeat: repeat-x; 
background-color: <?PHP echo "$css[mainbg]";?>;
}
#header {
height:100px;
background-color: <?PHP echo "$css[headerbg]";?>;
background-image: url(<?PHP echo "$css[headerimage]";?>);
}
#navbar {
margin: 0 auto;
width:570px;
background-color: transparent;
background-image: url(<?PHP echo "$css[navimage]";?>);
text-align:center;
}
#news {
margin: 0 auto;
background-image: url(<?PHP echo "$css[newsimage]";?>);
background-color: <?PHP echo "$css[newsbg]";?>;
margin-top:10px;
width:400px;
text-align:center;
}
#left {
float:left;
text-align:center;
width:300px;
background:transparent;
margin-left:10px;
margin-bottom:10px;
margin-top:10px;
}
#right {
float:right;
width:620px;
background:transparent;
margin-right:10px;
margin-left:10px;
margin-bottom:10px;
margin-top:10px;
}
.legend {
color: <?PHP echo "$css[legend]";?>;
border:none;
border-left: 1px solid <?PHP echo "$css[legendborder]";?>;
border-right: 1px solid <?PHP echo "$css[legendborder]";?>;
}
.fieldset {
border:none;
border-top: 1px solid <?PHP echo "$css[fieldsetborder]";?>;
}
.userfieldset {
border:none;
border-top: 1px solid <?PHP echo "$css[userfieldset]";?>;
}
.userlegend {
color: <?PHP echo "$css[userlegend]";?>;
border:none;
}

</style>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="Content-Language" content="EN">
<meta name="description" content="Myspace Whore Train">
<meta name="keywords" content="myspace, whore train">
<title><?PHP echo "$css[title]";?></title>
</head>
<body>
<?PHP
$you = $_SESSION[fid];
$sql = "SELECT * FROM xtrm_users WHERE fid = '$you'";
$res = mysql_query($sql);
echo mysql_error();
$in=mysql_fetch_array($res); ?>
<div id="container">
<div id="header"></div>

<div id="navbar" style="width:700px;"><?PHP include("navbar.php");?></div>
<div id="news"><?PHP echo "$css[news]";?></div>

<div id="left">
<?PHP include("user.php");?>


</div> 

<div id="right"><fieldset class="fieldset"><legend class="legend">Add Users</legend>
<table align="center" width="100%"><tr>
  <?php        
$page_name="home.php"; 
$start = $_GET['start'];
if(!isset($start)) {                        
$start = 0;
}

$eu = ($start - 0); 
$limit = 25;
$counter = 0;
$columns = 5;                                
$this1 = $eu + $limit; 
$back = $eu - $limit; 
$next = $eu + $limit;
$nume = 500;

$query=" SELECT * FROM xtrm_users ORDER BY days DESC, points DESC LIMIT $eu, $limit ";
$result=mysql_query($query);
echo mysql_error();
while($user = mysql_fetch_array($result))
{
$date = date(Ymd); ?>
<td align=center><fieldset class=userfieldset><legend class=userlegend align=center><small><?PHP echo $user[name]?></small></legend><a href=add.php?id=<?PHP echo $user[fid]?>&date=<?PHP echo $date?> target=_blank><img src=<?PHP echo $user[pic]?> width=74 height=74><br><center><small><?PHP if($user[days]>0){ echo $user[days];?> days.<?php } else { echo $user[points];?> pts.<?PHP }?></small></center></a></fieldset></td> 
<?PHP
$counter++; if($counter%$columns==0) echo "<tr></tr>"; 

}
if($nume > $limit ){ 
///if($back >=0) { 
///print "<a href='$page_name?start=$back'><font face='Verdana' size='2'>PREVIOUS PAGE</font></a> -- "; 
///} 

///$i=0;
///$l=1;
///for($i=0;$i < $nume;$i=$i+$limit){
///if($i <> $eu){
///echo " <a href='$page_name?start=$i'><font face='Verdana' size='2'>$l</font></a> ";
///}
///else { echo "<font face='Verdana' size='4' color=red>$l</font>";}   
///$l=$l+1;
///}

if($this1 < $nume) { 
print "<a href='$page_name?start=$next'> <font face='Verdana' size='2'>CLICK HERE TO ADD MORE!</font> </a>";}
else {
echo "<font face='Verdana' size='2'>DAILY LIMIT REACHED...</font>";
}
}
?>
</tr>
</table>
</fieldset>
</div>

<br clear="all" />
</div>
<br>
<center>XtremeAddz.com is not affiliated with myspace in any way.</center>
<center>Please do not spam the bulletin boards. </center>
</body>
</html>
<?PHP }?>

 

 

function.inc.php

<?php include_once 'config.php';
$userobject = new user();
$dbcon = new connect($host, $username, $password, $db_name); 
?>

<?
class connect
{
var $connection;
    
function connect($host,$username,$password,$db_name)
{
$this->connection = mysql_connect($host,$username,$password);
if(!$this->connection) {
echo "<br>".mysql_error()."<br>";
exit(); }

mysql_select_db($db_name); }
    
function run($sql) {
$sql = str_replace("@@))","\"",$sql);
$sql = str_replace("++--","\'",$sql);
$sql = str_replace("**&&"," ",$sql);        
$result = mysql_query($sql,$this->connection) or die(mysql_error());
if($result)    {
return $result; }
else {
echo "<br>".$sql;
echo "<br>".mysql_error()."<br>"; }
}

function count($result) {
$count = mysql_num_rows($result);
return $count; }
    
function mysqlfetch($result) {
$array = mysql_fetch_array($result);
return $array; }

}
?>

<?php
class user {

function Added($fid,$add) {
global $dbcon;
$sql = "SELECT id FROM xtrm_adds WHERE fid = '$fid' AND added = '$add'";
$result = $dbcon->run($sql);        
$count = $dbcon->count($result);
if($count > 0)
return true;
else
return false;
}

function GetTrainRiders($from,$to) {
global $dbcon;
$sql = "SELECT * FROM xtrm_train
ORDER By id DESC LIMIT $from,$to";
$result = $dbcon->run($sql);        
return $result; }

function InsertAdd($fid,$add) {
global $dbcon;
$sql = "INSERT INTO xtrm_adds SET fid = '$fid', added = '$add'";
$result = $dbcon->run($sql);        
}

function Points($fid,$pts) {
global $dbcon;
$sql = "UPDATE xtrm_users SET points = points+'$pts' WHERE fid = '$fid'";
$result = $dbcon->run($sql);        
}

function RefPoints($oldip,$pts) {
global $dbcon;
$sql = "UPDATE xtrm_users SET points = points+'$pts' WHERE fid = '$oldip'";
$result = $dbcon->run($sql);        
}

function CheckVIP($add) {
global $dbcon;
$sql = "SELECT days FROM xtrm_users WHERE fid = '$add'";
$result = $dbcon->run($sql);
$days = $dbcon->mysqlfetch($result);
return $days; }

function CheckIP($oldip) {
global $dbcon;
$sql = "SELECT ip FROM xtrm_users WHERE fid = '$oldip'";
$result = $dbcon->run($sql);
$cip = $dbcon->mysqlfetch($result);
return $cip; }

function AddUsers() {
global $dbcon;
$sql = "SELECT * FROM xtrm_users WHERE active = 1 ORDER BY days DESC, points DESC";
$result = $dbcon->run($sql);        
return $result; }

function VipUsers() {
global $dbcon;
$sql = "SELECT * FROM xtrm_users WHERE days > 0 ORDER BY days DESC";
$result = $dbcon->run($sql);
return $result; }
}?>

 

 

Here is the Sql as well

/*
MySQL Data Transfer
Source Host: localhost
Source Database: addz
Target Host: localhost
Target Database: addz
Date: 9/7/2008 7:48:05 PM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for xtrm_adds
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_adds`;
CREATE TABLE `xtrm_adds` (
  `id` int(10) NOT NULL auto_increment,
  `fid` int(15) default NULL,
  `added` int(15) default NULL,
  PRIMARY KEY  (`id`),
  KEY `fid` (`fid`)
) ENGINE=MyISAM AUTO_INCREMENT=32621 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_admin
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_admin`;
CREATE TABLE `xtrm_admin` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(10) NOT NULL,
  `password` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_css
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_css`;
CREATE TABLE `xtrm_css` (
  `id` int(10) NOT NULL default '1',
  `title` varchar(100) character set utf8 default NULL,
  `url` varchar(100) character set utf8 NOT NULL,
  `bulletintop` text character set utf8 NOT NULL,
  `bulletinbottom` text character set utf8 NOT NULL,
  `passonoff` enum('1','0') character set utf8 default '0',
  `bodybg` varchar(10) character set utf8 NOT NULL,
  `bodyfont` varchar(10) character set utf8 NOT NULL,
  `bodyfontcolor` varchar(10) character set utf8 NOT NULL,
  `bodyimage` varchar(100) character set utf8 NOT NULL,
  `link` varchar(10) character set utf8 NOT NULL,
  `visited` varchar(10) character set utf8 NOT NULL,
  `active` varchar(10) character set utf8 NOT NULL,
  `hover` varchar(10) character set utf8 NOT NULL,
  `mainbg` varchar(10) character set utf8 NOT NULL,
  `mainimage` varchar(100) character set utf8 NOT NULL,
  `mainborder` varchar(10) character set utf8 NOT NULL,
  `headerbg` varchar(10) character set utf8 NOT NULL,
  `headerimage` varchar(100) character set utf8 NOT NULL,
  `navbg` varchar(10) character set utf8 NOT NULL,
  `navimage` varchar(100) character set utf8 NOT NULL,
  `welcome` text character set utf8 NOT NULL,
  `welcomebg` varchar(10) character set utf8 NOT NULL,
  `welcomeimage` varchar(100) character set utf8 NOT NULL,
  `legend` varchar(10) character set utf8 NOT NULL,
  `legendborder` varchar(10) character set utf8 NOT NULL,
  `fieldsetborder` varchar(10) character set utf8 NOT NULL,
  `userlegend` varchar(10) character set utf8 NOT NULL,
  `userlegendborder` varchar(10) character set utf8 NOT NULL,
  `userfieldsetborder` varchar(10) character set utf8 NOT NULL,
  `news` text character set utf8 NOT NULL,
  `newsbg` varchar(10) character set utf8 NOT NULL,
  `newsimage` varchar(100) character set utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_pp
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_pp`;
CREATE TABLE `xtrm_pp` (
  `ipnurl` varchar(100) NOT NULL,
  `email` varchar(50) NOT NULL,
  `1day` varchar(10) NOT NULL,
  `7day` varchar(10) NOT NULL,
  `30day` varchar(10) NOT NULL,
  PRIMARY KEY  (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_train
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_train`;
CREATE TABLE `xtrm_train` (
  `id` int(11) NOT NULL auto_increment,
  `fid` varchar(50) default NULL,
  `name` varchar(100) default NULL,
  `pic` varchar(200) default 'http://x.myspace.com/images/no_pic.gif',
  `ip` varchar(100) default NULL,
  `vip` enum('Y','N') default 'N',
  `days` int(3) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_users
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_users`;
CREATE TABLE `xtrm_users` (
  `fid` int(15) NOT NULL,
  `name` varchar(12) character set utf8 NOT NULL default 'Add Me!',
  `pic` varchar(200) character set utf8 NOT NULL default 'http://x.myspace.com/images/no_pic.gif',
  `ip` varchar(15) character set utf8 default NULL,
  `days` int(5) NOT NULL default '0',
  `points` int(10) NOT NULL default '0',
  `refs` int(5) NOT NULL default '0',
  `active` enum('1','0') character set utf8 NOT NULL default '1',
  `custom` varchar(10) character set utf8 default NULL,
  `password` varchar(50) character set utf8 NOT NULL default 'XtRmWeB',
  `verify` enum('1','0') character set utf8 default '0',
  `fc` int(20) NOT NULL default '0',
  PRIMARY KEY  (`fid`),
  KEY `days` (`days`),
  KEY `points` (`points`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for xtrm_vip
-- ----------------------------
DROP TABLE IF EXISTS `xtrm_vip`;
CREATE TABLE `xtrm_vip` (
  `vip_fid` varchar(20) NOT NULL,
  `vip_pic` varchar(200) NOT NULL default 'http://x.myspace.com/images/no_pic.gif',
  `vip_days` int(3) NOT NULL default '0',
  PRIMARY KEY  (`vip_fid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ---------------------------- 

 

 

not sure what to do seems like query is not running, only that the database is connected. Don't know what im really looking for. if anyone see or know what may be the matter or need more info please ask and thank you.

 

 

 

Here is the sites link if you like to see what is happing.

 

xtremeaddz.com

 

 

here is a valid Myspace ID u can use to see what happins.

 

400470903

 

Link to comment
Share on other sites
  • 2 months later...
This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.