Jump to content

Lost connection to MySQL server during query


twizted

Recommended Posts

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\", \"wide_bucs19@hotmail.com\");
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

Link to comment
Share on other sites

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.

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