[Realease]CO 2.1 Source

05/13/2008 14:12 keving15#196
Do it yourself remove the Accounts that u dont need .Whats the Problem?
05/13/2008 14:35 Kiyono#197
Quote:
Originally Posted by WHITELIONX View Post
hmmm lol id love to but :/: im clueless how to, The register.php apparently is messed up to start with anyways just wish id read that first lol
how did you do that?
but just the Database is good enough i can just use my own register.php
05/13/2008 18:30 damianpesta#198
IDK how to remove em I cant import db So i cant delete Em And idk how to .... First ... All i know is how to run the server and get some things working i just dunno how to get the DB clean ... i tried manually deleting em and when i imported it comes up with an error So can Someone Clean it up by mySQL??
05/14/2008 02:57 WHITELIONX#199
as i said i dont know how to put my db on here
05/14/2008 09:20 damianpesta#200
erm try to good it the only thing i can tell u is

run>cmd>MySQL -uroot -ppass After that idk how to dump db my friend showed me once i forgot what to do after that any one can help us?
05/14/2008 13:44 Kiyono#201
Quote:
Originally Posted by WHITELIONX View Post
as i said i dont know how to put my db on here
oh...that could be a problem.... well download navicat for mysql

/edit or download this:
[Only registered and activated users can see links. Click Here To Register...] i made it specially for you
READ THE README FOR INSTRUCTIONS
05/14/2008 16:55 damianpesta#202
Djago160 Maybe u can be good and help me to import DB plox I just cant get db In Mysql getting error:

No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

i imported it once by run>cmd>MySQL -uroot -ppass but ... i dont remember how to anymore :/ plOx i will be glad if u can help me
05/14/2008 17:52 b4icn2u#203
Thanks for the files and the help. God i hate sql :(
05/14/2008 17:54 Kiyono#204
*sigh* oh well here is it a cleaned up version of the DB
05/14/2008 20:16 damianpesta#205
eww still Gets error meh maybe u Djago know How To import db by using run>cmd>MySQL -uroot -ppassword... ?? Cuz im stuck im getting error Over n over tried to install other Versions and still doesnt work im stuk help plOx Mastor xD
05/14/2008 22:05 Kiyono#206
Quote:
Originally Posted by damianpesta View Post
eww still Gets error meh maybe u Djago know How To import db by using run>cmd>MySQL -uroot -ppassword... ?? Cuz im stuck im getting error Over n over tried to install other Versions and still doesnt work im stuk help plOx Mastor xD
download this [Only registered and activated users can see links. Click Here To Register...]
05/15/2008 00:00 WHITELIONX#207
:/:\ well yup the webpage opens it up and i put a name in i click register and not sure where it sent it but when i open Qonquer client and put name in click it and server problem :(
05/15/2008 09:10 damianpesta#208
Quote:
Originally Posted by Djago160 View Post
download this [Only registered and activated users can see links. Click Here To Register...]
what 2 do after i've downloaded 8.0 one Ive added the test database n others but idk what 2 do after that i dun c any button called import db Soz :S sorry for bottering u djago :rolleyes:

#edit just add me on msn [Only registered and activated users can see links. Click Here To Register...] djago :p
05/15/2008 13:31 Kiyono#209
Quote:
Originally Posted by WHITELIONX View Post
:/: well yup the webpage opens it up and i put a name in i click register and not sure where it sent it but when i open Qonquer client and put name in click it and server problem :(
did you followed the instructions? cause it does work for me
05/15/2008 16:34 WHITELIONX#210
yup did to instruction but ive no idea where it sent the username o.0 is in c/xampp/htdocs same as appserve i think but is htdocs not www

<title>[conquer_server]</title>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="black">
<tr>
<form name="form1" method="post" action="checkreg.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="white">
<tr>
<td colspan="3"><strong>Choose a username</strong></td>
<div align=center>
<font color=white>[Insert own here]</font>
<br><font color=white>Your password will be set when you login</font>
</tr>
<tr>
<td width="78">Username</td>
<td width="6">:</td>
<td width="294"><input name="regwho" type="text" id="myusername"></td>
</tr>
<tr>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Register"></td>
</tr>
<table>
<font color=white>Note:The server is not always online if it shows "Online",if it shows online then the account creation is online and 8/10 the server is online if the account creation is online.</font>
</table>
</DIV></TD></TR></TBODY></TABLE></FORM>

is regitser and checkreg is now

<?php
$username = "[root]";
$password = "[*********]";
$hostname = "localhost";
$dbh = mysql_connect($hostname, $username, $password)
or die("Unable to connect to MySQL Database.");
mysql_select_db("[conquer_server]");
$serveraddress="127.0.0.1";
$serverport=9958;
$regwho=stripslashes($_POST['regwho']);
$regcred=stripslashes($_POST['regcred']);
mysql_real_escape_string($regwho);
mysql_real_escape_string($regcred);
$regc = ($regcred);
$login = mysql_query("SELECT * FROM account WHERE AccountID='$regwho'
OR AccountID='$regwho' AND Password='$regcred'")
or die ('Error: ' . mysql_error());
if ($row = mysql_fetch_array($login)){
echo 'This username is already taken. Please try again with a different username.
<br><br><a href="register.php">Try again</a>';
}
else {
$sql = "INSERT INTO account VALUES ('$_POST[regwho]', '', '0', '1', '')";
mysql_query($sql)
or die('Error: ' . mysql_error());
echo 'Registration successful.';
echo '<BR><BR>';
}
?>

ive directed it as instructed but as i say it doesnt give an error just when i click register the name dissapears as if to say its registered however ive no idea where it sends the name because im unable to log in with a username.

Ive manually created an account for myself to make sure it still works ok but i cant register it from my webpage still even though it opens the register form and seems to do everything correctly