twizted Posted March 20, 2007 Share Posted 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\", \"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 Quote Link to comment https://forums.phpfreaks.com/topic/43489-lost-connection-to-mysql-server-during-query/ Share on other sites More sharing options...
trq Posted March 20, 2007 Share Posted March 20, 2007 Do you have an actual question? Quote Link to comment https://forums.phpfreaks.com/topic/43489-lost-connection-to-mysql-server-during-query/#findComment-211201 Share on other sites More sharing options...
twizted Posted March 20, 2007 Author Share Posted 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? Quote Link to comment https://forums.phpfreaks.com/topic/43489-lost-connection-to-mysql-server-during-query/#findComment-211206 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.