Jump to content

dev0

New Members
 View Profile  See their activity

  • Posts

    1

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

dev0's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. dev0
    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
×
×
  • 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.