- Joined
- Sep 27, 2008
- Messages
- 598
- Reaction score
- 159
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!function register()
{
$reg_account = secure($_POST['reg_account']);
$reg_password = secure($_POST['reg_password']);
$reg_repassword = secure($_POST['reg_repassword']);
$reg_mail = secure($_POST['reg_mail']);
$reg_question = secure($_POST['reg_question']);
$reg_answer = secure($_POST['reg_answer']);
$reg_code = secure($_POST['reg_code']);
$reg_agree = secure($_POST['reg_agree']);
$reg_time = date('Y-m-d H:i:s');
$acc_len = strlen($reg_account);
$pass_len = strlen($reg_password);
$ques_len = strlen($reg_question);
$answ_len = strlen($reg_answer);
check_inject();
global $md5;
$exists_accq = mssql_query("Select * from MEMB_INFO where memb___id='$reg_account'");
$exists_acc = mssql_num_rows($exists_accq);
$exists_mailq = mssql_query("Select * from MEMB_INFO where mail_addr='$reg_mail'");
$exists_mail = mssql_num_rows($exists_mailq);
if(empty($reg_account) or empty($reg_password) or empty($reg_repassword) or empty($reg_mail) or empty($reg_question) or empty($reg_answer) or empty($reg_code)) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> You can not leave empty fields !</span></td></tr>"; $error=1; }
else{
if($acc_len < 4) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Account must be at least 4 symbols !</span></td></tr>"; $error=1; }
elseif($exists_acc != 0) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Another member has already registered with this account !</span></td></tr>"; $error=1; }
if($pass_len < 4) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Password must be at least 4 symbols !</span></td></tr>"; $error=1; }
elseif($reg_password != $reg_repassword) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Passwords did not match !</span></td></tr>"; $error=1; }
if(!eregi("^[_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,6}$",$reg_mail) && count($_POST)>0 && count($reg_mail)<60) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Invalid email address! Only 0-9 a-z and @ and . and _ and - !</span></td></tr>"; $error=1; }
elseif($exists_mail != 0) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Another member has already registered with this email !</span></td></tr>"; $error=1; }
if($ques_len < 4) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Question must be at least 4 symbols !</span></td></tr>"; $error=1; }
if($answ_len < 4) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Answer must be at least 4 symbols !</span></td></tr>"; $error=1; }
if(md5($reg_code) != $_SESSION['random_value']) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> Please go back and write the code correctly !</span></td></tr>"; $error=1; }
if($reg_agree != agree) { echo"<tr><td align='center' class='modules'><span class=offline><b>Error:</b> You must agree with the terms !</span></td></tr>"; $error=1; }
if($error != 1) {
echo"<tr><td align='center' class='asd'><span class='online'>Account $reg_account successfuly created on $reg_time !</span></td></tr>";
if($md5 == 0) {
$a = mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$reg_account','$reg_password','$servername','1','$reg_mail','$reg_time','$reg_time','$reg_time','$reg_time','1','0','0','$reg_question','$reg_answer')");
$b = mssql_query("INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_Hour,Surplus_Point,Surplus_Minute,Increase_Days ) VALUES ('2010','1',1234,'$reg_account','$reg_account',1,'7','6','3','6','6','$reg_time','0' )");
}
else
{
$a = mssql_query("INSERT INTO MEMB_INFO (memb___id,memb__pwd,memb_name,sno__numb,mail_addr,appl_days,modi_days,out__days,true_days,mail_chek,bloc_code,ctl1_code,fpas_ques,fpas_answ) VALUES ('$reg_account',md5($reg_password),'$servername','1','$reg_mail','$reg_time','$reg_time','$reg_time','$reg_time','1','0','0','$reg_question','$reg_answer')");
$b = mssql_query("INSERT INTO VI_CURR_INFO (ends_days,chek_code,used_time,memb___id,memb_name,memb_guid,sno__numb,Bill_Section,Bill_value,Bill_Hour,Surplus_Point,Surplus_Minute,Increase_Days ) VALUES ('2010','1',1234,'$reg_account','$reg_account',1,'7','6','3','6','6','$reg_time','0' )");
$c = mssql_query("INSERT INTO MEMB_CREDITS (memb___id,credits) VALUES ('$reg_acc','0')");
}
}}}
// Stats Reset
$reset_strg = '25';
$reset_agili = '25';
$reset_vitali = '25';
$reset_energy = '25';
$reset_comm = '25';
// Reset Stats
function stats_reset()
{
$account = secure($_SESSION['user']);
$character = secure($_POST['character']);
require ('config.php');
global $reset_strg;
global $reset_agili;
global $reset_vitali;
global $reset_energy;
global $reset_comm;
check_inject();
$queryonline = mssql_query("Select * from MEMB_STAT where memb___id='$account' and connectstat='1'");
$onlinecheck = mssql_num_rows($queryonline);
$queryaccount = mssql_query("Select * from MEMB_INFO where memb___id='$account'");
$accountcheck = mssql_num_rows($queryaccount);
$querypassword = mssql_query("Select * from MEMB_INFO where memb___id='$account' and memb__pwd='$password'");
$passwordcheck = mssql_num_rows($querypassword);
$querychar = mssql_query("Select * from Character where Name='$character'");
$charcheck = mssql_num_rows($querychar);
$query = mssql_query("Select LevelUpPoint,Strength,Dexterity,Vitality,Energy,LeaderShip from Character where Name='$character'");
$row = mssql_fetch_row($query);
if($row[1] < $reset_strg) { echo"<b>Error:</b> Character $character don't have $reset_strg strength points to be reset!<br>"; $error=1; }
elseif($row[2] < $reset_agili) { echo"<b>Error:</b> Character $character don't have $reset_agili dexterity points to be reset!<br>"; $error=1; }
elseif($row[3] < $reset_vitali) { echo"<b>Error:</b> Character $character don't have $reset_vitali vitality points to be reset!<br>"; $error=1; }
elseif($row[4] < $reset_energy) { echo"<b>Error:</b> Character $character don't have $reset_energy energy points to be reset!<br>"; $error=1; }
if($row[5] < $reset_comm) { echo"<b>Error:</b> Character $character don't have $reset_comm command points to be reset !<br>"; $error=1; }
else
{
if($error != 1) {
echo"<font color='green'>Character $character has successfuly reset stats !</font>";
$a = mssql_query("Update Character Set Strength='$reset_strg',Dexterity='$reset_agili',Vitality='$reset_vitali',Energy='$reset_energy',Leadership='$reset_comm' where name='$character'");
}
}
}
// End stats reset
<? if (eregi("modules/", $_SERVER['SCRIPT_NAME'])) { header("Location: ../?op=news"); } ?>
<?php $user = secure($_SESSION['user']);?>
<form action='' name='' method='post'>
<table align='center' width='400' class='maintable'>
<thead>
<tr>
<td align='center' class='asd'>Clear Stats</td>
</tr>
</thead>
</tr>
<tr>
<td align='center' class='maintable'>Select Character:
<select class='maintable' name='character'><optgroup label='Select a character'>
<?php
$charq = mssql_query("Select name from Character where AccountID='$user'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"
<option value='$row[0]'><span class='maintable'><b>$row[0]</span></option>
";
}
?>
</select></td>
</tr>
<tr>
<td align='center'><input type='submit' value='Clear Stats' class='button' name='clear'></td>
</tr>
<?php
if(isset($_POST['clear'])) { stats_reset(); }
?>
</table>
</form>
<tr><td align='center' class='maintable'><a href='index.php?op=user&char=stats'>Reset Stats</a></td></tr>
website support only s6 hero, so for shop and market it needs sql codes to be insereted and images to be put to support them i havent done this yetI think market does not supoort s6 db? i dont see any items
i made little mistake in install fileshop.sql not work. who can give a working sql ?
shop.sql not work. who can give a working sql ?