[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

**johnstone** · 12-30-2008

Originally Posted by naultnam

Is in db in worldbroadcast

um ok i dont see that in ArcEmu_1946/dbc
....i dont see any thing named worldbroadcast..
am in in the rite spot?

**AsgardCX** · 12-30-2008

Awesome! Very usefull tread.

**naultnam** · 12-30-2008

Originally Posted by johnstone

um ok i dont see that in ArcEmu_1946/dbc
....i dont see any thing named worldbroadcast..
am in in the rite spot?

No in your database, open navicat or phpmyadmin for view your database and in world_bliizz db you have an worldbroadcast

**naultnam** · 12-30-2008

Go to
C:\Keazains Pack\Server\htdocs\forum

edit: reguser.php
with this

__________________________________________________

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="XHTML namespace">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Account Creation</title>
<style type="text/css">

</style></head>
<body>
<?php
include "../config.php";
if(isset($_POST['submit']))
{
$bademail=0; //trackers for banned e-mails
$email=$_POST['email'];
$email=strip_tags($email);
$email=trim($email);
$getbademails="SELECT * from b_banemails";
$getbademails2=mysql_query($getbademails) or die("SQL ERROR (mail) #1: [".mysql_error()."]");
while($getbademails3=mysql_fetch_array($getbademails2))
{
if(substr_count($email,$getbademails3[email])>0)
{
$bademail++;
}
}
if($bademail>0)
{
die("<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'><tr><td style='background-image: url(../images/transpblack.png)'><center><font style='color: #DACCA2'><strong>Error</strong></font></center></td></tr><tr><td><center>That email is banned from registering</center></td></tr></table>");
}
$valid=1;
$username=$_POST['username'];
$username=strip_tags($username);
$username=trim($username);
$password=$_POST['password'];
$password=trim($password);
$password=strip_tags($password);
$signature=$_POST['signature'];
$signature=trim($signature);
$pass2=$_POST['pass2'];
$usercheck="SELECT*from b_users where username='$username' or email='$email'";
$usercheck2=mysql_query($usercheck);
while ($usercheck3=mysql_fetch_array($usercheck2))
{
$valid=0;
}
if($valid==0)
{
print "<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'>";
print "<tr><td style='background-image: url(../images/transpblack.png)'><center><font style='color: #DACCA2'><strong>Error</strong></font></center></td></tr>";
print "<tr><td><center>";
print "That username has been taken or there is already someone registered with that email or you did not enter email,<br> please <A href='register.php'>try to register again</a>. (or hit back)";
print "</td></tr></table></center>";
}
else if(substr_count($username," ")>0)
{
die("Spaces are not allowed in names");
}
else if(!preg_match("^[A-Za-z0-9]+$^", "$username"))
{
print "There were invalid characters in the username.";
}
else if(strlen($username)>15 || strlen($username)<3)
{
print "<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'>";
print "<tr><td style='background-image: url(../images/transpblack.png)'><center><font style='color: #DACCA2'><strong>Error</strong></font></center></td></tr>";
print "<tr><td><center>";
die("Username must be between 3 and 15 characters in length");
print "</center></td></tr></table>";
}
else if(strlen($email)<4 || substr_count($email," ")>0)
{
die("<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'><tr><td style='background-image: url(../images/transpblack.png)'><center><font style='color: #DACCA2'><strong>Error</strong></font></center></td></tr><tr><td>You did not enter an email or email has not valid format.</center></td></tr></table>");
}
else
{
if ($password==$pass2 && $_POST['password'])
{
$password2=md5($password);
$supervalue=$value;
$day=date("U");
$email=$_POST['email'];
$location=$_POST['location'];
$aim=$_POST['aim'];
$showprofile=$_POST['showprofile'];
$icq=$_POST['icq'];
$seedval=$day%100000;
srand($seedval);
$key=RAND(1000000,2000000);
if($requirekey=="no"||$requirekey=="No") //if you do no require an activation key
{
$SQL ="INSERT into b_users (username,password,email,validated,location,AIM,ICQ,showprofile) values('$username','$password2','$email','1','$location','$aim','$icq','$showpro file')";
mysql_query($SQL) or die(mysql_error()."<br>SQL ERROR");
mysql_select_db($chardb);
$SQLwow ="INSERT into accounts (login,password,gm,banned,lastip,email,flags,forceLanguage) values ('$username','$pass2','','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enUS')";
mysql_query($SQLwow) or die(mysql_error()."<br>Account with that name already exist in server database, this is admin fault, please notify admin about this problem. Go back to register new account with new username.");
}
else //you require an activation key
{
$SQL ="INSERT into b_users (username,password,sig, keynode,email,location,AIM,ICQ,showprofile) values('$username','$password2','$signature','$key','$email','$location','$aim', '$icq','$showprofile')";
mysql_query($SQL) or die(mysql_error());
mysql_select_db($chardb);
$SQLwow ="INSERT into accounts (login,password,gm,banned,lastip,email,flags,forceLanguage) values ('$username','$pass2','','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enUS')";
mysql_query($SQLwow) or die(mysql_error());
mail("$email","Your forum activation key","Paste the URL to activate your account. $boardpath/activate.php?username=$username&password=$password&keynode=$key");

}
print "<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'>";
print "<tr><td style='background-image: url(../images/transpblack.png)'><center><strong><font style='color: #DACCA2'>Success! Account ready to use!</font></strong></center></td></tr>";
print "<tr><td>";
if($requirekey=="no"||$requirekey=="No")
{
print "<center>Forum and Server account are created!<br>You can now login to server with your username and password.<br><br><strong><font color='#DACCA2'>set realmlist $realmlist</font></strong></center><br><br>";
print "";
print "<tr><td style='background-image: url(../images/transp.png)'><center>Your username is $username.<br>Your password is $pass2.</center></td></tr>";
print "<tr><td style='background-image: url(../images/transpblack.png)'><center><A href='login.php'>Click here to Login</a></center></td></tr>";
}
else
{
print "Forum registration completed please check your email for activation key. Go <A href='login.php'>here to Login</a>.";
}
if($notifyme=="Yes" || $notifyme=="yes")
{
mail("$adminemail","Registration at $sitetitle forums","This is just to inform you that $username has just registered in your forums");
}
print "</td></tr></table>";
}
else
{
print "<br><br><br><br><table border='0' cellpadding='3' cellspacing='3' align='center' style='border: 1px solid #575653; background-image: url(../images/transp.png)'>";
print "<tr><td style='background-image: url(../images/transpblack.png)'><center><font style='color: #DACCA2'><strong>Error</strong></font></center></td></tr>";
print "<tr><td><center>";
print "Your passwords didn't match or you did not enter a password";
print "</center></td></tr></table>";
}
}
}
?>
</body>
</html>

________________________________________________

**johnstone** · 12-30-2008

Originally Posted by Hephaestus

If you are setting up a website via. Keazain's CMS.
You need the program called: "WampServer 2.0b"

could u or Keazain`s rite a breaf walk throu on seting a wampsever up or is thar 1 i could falow ?

**~~Mango Jerry~~** · 12-30-2008

Johnstone, you can use the Tool on the Forums called: "Search", do that and Search for:
"Setup WampServer" without the: "

If i had some time to make a Guide about how to setup WampServer, i would.
But unfortunatly im trying to work, and thanks for using our releases.

**naultnam** · 12-30-2008

Download WampServer 2 - Download PHP, Apache, MySQL

**~~Mango Jerry~~** · 12-30-2008

Thanks alot, Naultnam.
But we were looking for a Guide, but thanks for the Download Window.

**naultnam** · 12-30-2008

NP, you're welcome!

**johnstone** · 12-30-2008

yes thanks i have it but i have not a clow on how 2 set it all up ..yes im a noob at most of it 100% at the website

i need a noob gide or ill just go pay some 1 2 set it up i think i know som pl at a computer store mite do it for a bill....o wall thanks all love the work on wotlk keep it up i hope 2 host it and post a link soon for u all...i have a oldy but goody sever its a ibm netfinity 5500 and a netfinity7000 i like the 5500 for it runs 4 xeon only 3's tho lol and max ram..ttla..+rep all the help

**naultnam** · 12-30-2008

Ok if you want help! i can help you johnstone! for configure your server and website

**twidget** · 12-30-2008

Originally Posted by naultnam

Is in db in worldbroadcast

what is the number for??? seconds??? What... I like the announcements, just not so often...

**naultnam** · 12-30-2008

OK go on config folder
edit arcemu-optional.conf

Spot:
___________________
<CommonSchedule AutoBroadCast = "1"
BroadCastInterval = "10"
BroadCastTriggerPercentCap = "2"
BroadCastOrderMode = "0">
________

BroadCastInterval = "10" 10 = 10 secondes before messages

**johnstone** · 12-30-2008

ok iv found a bug i think u should know a bout ok i whant u 2 make a dk and yous the fly guy 2 get down on the ground than run 2 the nexst land if u can o..Oo inviabol wall can get past it ok ...this is just haf the bug not .learn all and hit the .death gate ok .now 1 of the other bugs id the gat drops u on the ground with no whay back up .

.ok this is just part of it .ok now u can get 2 run 2 new lands in noth but 2 get back up u most .cheat fly..now ons thar ...o thars a fly guy but wont tack u back down dam ...and thar a portol and its not working hum u can go up stars tho that works o look thar new npc cool....
this is not mant 2 sound like im make i spell bad and i tipe in thot sorry all hope u under stad it the 1 i yoused is ArcEmu_rev.1946 ..any thos on how i fix or is it fix allrady?or did i do some thing rong?on installing?

**p20ph37** · 12-30-2008

Alright... So I set up the latest revision of ArcEmu, uploaded the logon db and the world dbs...

I downloaded the "T7 Starter" and "Fix" text files, batched them into the world db, however, when I created a hunter (not sure about other classes), the character was created with the WRONG gear, pieces of the wrong gear...

...So I'm wondering if I had to clear the table containing the starting gear and then batch the starter and fixes?

Also on a side note, and I'm sure this isn't the place to ask but... Could someone point me in the direction of custom npc creation? Guide? - Thanks.

Thanks much Keazain. Appriciated =)

Shout-Out

User Tag List

Thread: [X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

Thread Tools

Search Thread

Is in db in worldbroadcast

Configuration for website to set 24 for account creation

setup website>?

Similar Threads

[Selling] ►►►[0,069$ at 0,041$] NEW AND EMPTY PTC Accounts with Verified Email [FOR USE BOT]◀◀◀

[Selling] Undying and Hand of A'dal Account - Ready for Mythic

OwnedCore Forums

casino

CoreCoins

My OwnedCore

About Us

Casino