Lost connection to MySQL server during query

twizted · March 20, 2007

i dont understand this my host isnt going to be down for like 4 days will it? i mean i havent even goto visit my site lol but the guy supplied the files and setup files heres the file i think

index.php

<?php
include '../runner.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<meta name="description" content="ShimmyShines Runescape Control Panel" />
<meta name="keywords" content="srscp, shimm, shimmscape, shimmyshine, shine, shimmy, status, control, panel, scape, private, runescape, server, high, scores, report, abuse, register, page, dyllon, forum, npc, list, item, command, ban, appeal, change, password, forgot, information" />
<meta name="generator" content="Seditio by Neocrome http://www.neocrome.net" />
<meta http-equiv="expires" content="Fri, Apr 01 1974 00:00:00 GMT" />
<meta http-equiv="pragma" content="no-cache" />
<meta http-equiv="cache-control" content="no-cache" />
<meta http-equiv="last-modified" content="Mon, 31 Jul 2006 00:37:03 GMT" />
<link rel="shortcut icon" href="favicon.ico" />

<script type="text/javascript">
<!--

function popup(code,w,h)
{ window.open('plug.php?o='+code,'','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width='+w+',height='+h+',left=32,top=16'); }

function pfs(id,c1,c2)
{ window.open('pfs.php?userid='+id+'&c1='+c1+'&c2='+c2,'PFS','status=1, toolbar=0,location=0,directories=0,menuBar=0,resizable=1,scrollbars=yes,width=754,height=512,left=32,top=16'); }

function help(rcode,c1,c2)
{ window.open('plug.php?h='+rcode+'&c1='+c1+'&c2='+c2,'Help','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width=480,height=512,left=32,top=16'); }

function comments(rcode)
{ window.open('comments.php?id='+rcode,'Comments','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width=480,height=512,left=16,top=16'); }

function ratings(rcode)
{ window.open('ratings.php?id='+rcode,'Ratings','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width=480,height=512,left=16,top=16'); }

function polls(rcode)
{ window.open('polls.php?id='+rcode,'Polls','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width=608,height=448,left=16,top=16'); }

function pollvote(rcode,rvote)
{ window.open('polls.php?a=send&id='+rcode+'&vote='+rvote,'Polls','toolbar=0,location=0,directories=0,menuBar=0,resizable=0,scrollbars=yes,width=608,height=448,left=16,top=16'); }

function picture(url,sx,sy)
{ window.open('pfs.php?m=view&v='+url,'Picture','toolbar=0,location=0,directories=0,menuBar=0,resizable=1,scrollbars=yes,width='+sx+',height='+sy+',left=0,top=0'); }

function redirect(url)
{ location.href = url.options[url.selectedIndex].value; }

window.name='main';



//-->
</script>
<title>SRSCP Setup</title>

<link href="../SRSCP.css" type="text/css" rel="stylesheet" />

</head>

<body>
<div id="body">
<a name="totop"></a>
<div style="text-align: center">
<div class="titleframe e"><h4>Website Managment</h4>
Unmade
- Unmade </div>

</div>



<br><br>
<div class="frame wide_e"><p><b><a href="index.php">Setup</a></b><br>


<p><center>
Hi there, and welcome to the setup page for the SRSCP!<br>
Lets get started eh?<br><br>
<i>1</i> - 2<br><br>
<form method="post" action="./setup1.php">
Database Server Name<br><input type=text name=dbsname><br>
Database User Name<br><input type=text name=dbuname><br>
Database User Password<br><input type=password name=dbpass><br>
Database Name<br><input type=text name=dbname><br><hr>
Server Name<br><input type=text name=sname><br>
Server IP(Please no no-ip's!)<br><input type=text name=ip><br>
Server Port<br><input type=text name=port><br><hr>
Character Folder(Where is it located? Make sure it is uploaded to your webserver. Once you have chose, do not move it or registration will not work)<br><input type=text name=sfolder><br>
Are your save files .dat or .txt?<br>.dat <b>:</b> <input type=checkbox name=dat> .txt <b>:</b><input type=checkbox name=txt><br><br>
<input type=submit name=submit value=Submit>   <input type=reset name=reset value=Reset>
</form>
</center></p>
</div>
<div class='tandc'>SRSCP is copyright © 2005-2006.</div>

</div>

</body>
</html>

setup.php

<?php
$dbsname = $_POST['dbsname'];
$dbuser = $_POST['dbuname'];
$dbpass = $_POST['dbpass'];
$dbname = $_POST['dbname'];
$sname = $_POST['sname'];
$ip = $_POST['ip'];
$port = $_POST['port'];
$forum = $_POST['forum'];
$sfolder = $_POST['sfolder'];
$dat = $_POST['dat'];
$txt = $_POST['txt'];

$fp = fopen("../include/constants.php", "a");
$content = "<?php

define(\"DB_SERVER\", \"$dbsname\");
define(\"DB_USER\", \"$dbuser\");
define(\"DB_PASS\", \"$dbpass\");
define(\"DB_NAME\", \"$dbname\");

define(\"TBL_USERS\", \"users\");
define(\"TBL_ACTIVE_USERS\",  \"active_users\");
define(\"TBL_ACTIVE_GUESTS\", \"active_guests\");
define(\"TBL_NPC\", \"npclst\");
define(\"TBL_ITEM\", \"itlst\");
define(\"TBL_BUG\", \"bug\");
define(\"TBL_NEWS\", \"news\");
define(\"TBL_AFF\", \"aff\");
define(\"TBL_RULE\", \"rule\");
define(\"TBL_DOWNLOAD\", \"download\");
define(\"TBL_ALERT\", \"alerts\");
define(\"TBL_COMMANDS\", \"commands\");
define(\"TBL_FORUM\", \"forummain\");
define(\"TBL_FORUM2\", \"topics\");
define(\"TBL_REPLY\", \"reply\");
define(\"TBL_CHATRM\", \"chatroom\");

define(\"ADMIN_NAME\", \"admin\");
define(\"MOD_NAME\", \"mod\");
define(\"FORUM_MOD_NAME\", \"forummod\");
define(\"DONATION_NAME\", \"donator\");
define(\"GUEST_NAME\", \"Guest\");
define(\"ADMIN_LEVEL\", 9);
define(\"MOD_LEVEL\", 4);
define(\"FORUM_MOD_LEVEL\", 3);
define(\"DONATION_LEVEL\", 2);
define(\"USER_LEVEL\",  1);
define(\"GUEST_LEVEL\", 0);

define(\"TRACK_VISITORS\", true);

define(\"USER_TIMEOUT\", 10);
define(\"GUEST_TIMEOUT\", 5);

define(\"COOKIE_EXPIRE\", 60*60*24*100);  //100 days by default
define(\"COOKIE_PATH\", \"/\");  //Avaible in whole domain

define(\"EMAIL_FROM_NAME\", \"ShimmyShine\");
define(\"EMAIL_FROM_ADDR\", \"[email protected]\");
define(\"EMAIL_WELCOME\", false);

define(\"ALL_LOWERCASE\", false);
?>";
fwrite($fp,$content);
fclose($fp);

if ($dat) {
$fp = fopen("../runner.php", "a");
$content = "<?php
// Text
\$logo = '$sname';
\$ip = '$ip';
\$port = '$port';
\$forum = './forums.php';
\$serverfolder = '$sfolder';
\$tfile = '.dat';

// Images
?>";
fwrite($fp,$content);
fclose($fp);
} else if ($txt) {
$fp = fopen("../runner.php", "a");
$content = "<?php
// Text
\$logo = '$sname';
\$ip = '$ip';
\$port = '$port';
\$forum = './forums.php';
\$serverfolder = '$sfolder';
\$tfile = '.dat';

// Images
?>";
fwrite($fp,$content);
fclose($fp);
}
mysql_connect($dbsname,$dbuser,$dbpass);
@mysql_select_db($dbname) or die( "Unable to select database");
mysql_query("CREATE TABLE users (username varchar(30) primary key,password varchar(32),userid varchar(32),userlevel tinyint(1) unsigned not null,email varchar(50),timestamp int(11) unsigned not null,ban int(1) unsigned not null)");
mysql_query("CREATE TABLE active_users (username varchar(30) primary key,timestamp int(11) unsigned not null)");
mysql_query("CREATE TABLE active_guests (ip varchar(15) primary key,timestamp int(11) unsigned not null)");
mysql_query("CREATE TABLE itlst (id int(10) primary key,name varchar(50) not null)");
mysql_query("CREATE TABLE npclst (id int(10) primary key,level int(10) not null,name varchar(50) not null)");
mysql_query("CREATE TABLE bug (bgname varchar(50) primary key,bgdesc varchar(200) not null,bgfix varchar(30) not null)");
mysql_query("CREATE TABLE news (name varchar(30) primary key,subname varchar(30) not null,date varchar(30) not null,type varchar(30) not null,content blob(65535) not null)");
mysql_query("CREATE TABLE aff (name varchar(30) primary key, link varchar(70) not null)");
mysql_query("CREATE TABLE rule (name varchar(30) primary key, des varchar(500) not null)");
mysql_query("CREATE TABLE download (name varchar(30) primary key, link varchar(200) not null, des varchar(500) not null)");
mysql_query("CREATE TABLE alerts (alert varchar(50) primary key)");
mysql_query("CREATE TABLE commands (name varchar(50) primary key,des varchar(500) not null,level varchar(50) not null)");
mysql_query("CREATE TABLE forummain (fdate varchar(50) NOT NULL,fname varchar(50) not null,ftopic varchar(100) not null primary key,fbody blob(65535) not null)");
mysql_query("CREATE TABLE `topics` (`tid` tinyint(1) unsigned NOT NULL auto_increment unique key,`tforum` varchar(50) NOT NULL,`tname` varchar(50) NOT NULL primary key,`tstart` varchar(60) NOT NULL,`tbody` blob NOT NULL,`tpin` tinyint(1) NOT NULL,`tclose` tinyint(1) NOT NULL,`tdate` varchar(50) NOT NULL)");
mysql_query("CREATE TABLE `reply` (`rid` tinyint(4) unsigned NOT NULL auto_increment primary key,`rform` varchar(50) NOT NULL,`rname` varchar(50) NOT NULL,`rstart` varchar(50) NOT NULL,`rbody` blob NOT NULL,`rdate` varchar(50) NOT NULL)");
mysql_query("CREATE TABLE `chatroom` (`chid` int(100) unsigned NOT NULL auto_increment primary key,`chlvl` tinyint(1) NOT NULL default '0',`chmsg` blob NOT NULL,`chpstr` varchar(30) NOT NULL default '',`chban` tinyint(1) NOT NULL default '0')");

header("Location: ./index3.php");
?>

these are the 2 codes to setup i guess

trq · March 20, 2007

Do you have an actual question?

twizted · March 20, 2007

yea why do i keep getting that message if im seting it up correctly?

is there anything i have to do to my database to get my site up and running?

Sign In

Lost connection to MySQL server during query

Recommended Posts

twizted

Link to comment

Share on other sites

trq

Link to comment

Share on other sites

twizted

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information