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

[theory18]

Thanks for the upload w@waddict!! +repped you!

but i have a problem now...
1. when running arcemu-world from the funrealm i get db world couldnt be found error,
so i added the database with SQLlyog, and then i added the sql from the file in
Xtools/Keazains Databases/ultimatefun20090411alladdonsNOspawns.rar to the world db
when hes done running and i want to execute i get 2 errors

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype_overwrite` int(11) NOT NULL default '-1',
`cooldown_ovewrite` int(11) NOT NULL default '-1',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2009-05-07 21:04:08
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype_overwrite` int(11) NOT NULL default '-1',
`cooldown_ovewrite` int(11) NOT NULL default '-1',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2009-05-07 21:28:35
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

Query:
CREATE TABLE `ai_agents` (
`entry` int(11) unsigned NOT NULL default '0',
`type` smallint(5) unsigned NOT NULL default '0',
`event` int(11) unsigned NOT NULL default '0',
`chance` int(11) unsigned NOT NULL default '0',
`maxcount` int(11) unsigned NOT NULL default '0',
`spell` int(11) unsigned NOT NULL default '0',
`spelltype` int(11) unsigned NOT NULL default '0',
`targettype_overwrite` int(11) NOT NULL default '-1',
`cooldown_ovewrite` int(11) NOT NULL default '-1',
`floatMisc1` float NOT NULL default '0',
`Misc2` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`entry`,`spell`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='AI System'

Error occured at:2009-05-07 21:44:41
Line no.:27
Error Code: 1050 - Table 'ai_agents' already exists

2. When i run logonserver everything is fine, but when i register an account on the website it just shuts down
when he reaches Prechaching accounts....
and i can't re-run the logonserver anymore after that?

THANKS IN ADVANCE!

[W@WAdict]

theory18,

I have not tried to import that sql file personally, I set up the fun server using the single sql files.

If you delete the ai_agents table that should fix that error, but there may be more tables in there that it is trying to create that already exist. You may have to start with an empty world db, I'm not sure.

I always create my accounts manually using SQLYog, but I only run it for me and family members on a local network. So, I have not tried to create using the Web page. It may be a problem in the Web page or maybe related to the error on importing the sql file.

Did you look at the accounts it created in the accounts table, and see that all the needed information is in there? You can compare it to the admin account already there, just a couple things would be different, such as the gm flag.

Without studying what is going on in the code at account cacheing time, I really can't tell much, it may be loading account_data information as well. I am not able to look the code over at the moment (still at work), but I'll check back in a little while and see if I need to.

Thanks for the rep, always appreciated.

[Rollese]

This pack is pretty awesome, but it would be even better if Keazain wouldn't pack over 450MB of Apache log files with hundrets of visitor IP's in it. God, save us from noobs.

[theory18]

what single files did you use then? the files in Xtools/Keazains Databases/ultimate_single_sql_files.rar??
Cause they seem a little bit small sized comparing with the other sql i used.

Edit: I tried the blizzlike one and that one imported fine with no problems what so ever.
could also run the arcemu-world.exe but when i register my first account through website
the logonserver just crashes again....
(it doesn't freeze and does work when i don't register any account and just play with admin)
And i looked for m account in the worldblizzlike one but can't seem to find a table that says something similar with account

Pls anyone?? I want to run this for public use, so manually editing accounts is not the solution here.

Thanks in advance!
Will rep you again when i can...

[W@WAdict]

theory18,

I just looked on my computer here at home, and I do not have the 2527 version, I have the 2537 which did not include the web site. I am over my bandwidth on file transfers tonight, so I can not download it. I will have to try and set up an account from the web site tomorrow when I get back to work and see what happens.

I believe the single sql files I used were the ones from the svn.

I have some web site files here, but I believe they are from way back like X25 or something like that, so I am not sure what has changed since then.

The reason I used the single sql files, was because the fun db said it was not spawned, and I wanted the mall and such to be spawned. There is a link that said the fun spawned would be available Wednesday, but it failed to say which Wednesday of which week or month or year. lol.

If you do not get it figured out, I'll see what I can do tomorrow. Sorry about that.

[Khar00f]

Theory i had the same problem with the account creation and this is how i fixed it

there's 2 ways

A) Copy the admin line and paste it on a new line, and modify username/pass and gm(AZ for GM and 0 for normal user) and flags (8 for TBC and 24 WoTLK), VIP = 0

B) create a batch file and write this in it, then you can just execute it to make add accounts.(this batch file was created by someone named Johved, as written on the 4th line of the batch file, all credit goes to him, i only edited to make it compatible with keazains pack)

some things need to be adapted to your DB/folders, i'll paint them red (if you haven't played around with the port or folder names inside the keazains pack folder, then you can just put the batch file inside the xpackblizz folder and it'll work, otherwise edit it accordingly.

logon = the database name where the accounts table is located
username = your DB's username
password = your DB's password
mysqlpath = the path where the mysqld.exe is located

everything should be good by default.
------------------------------------------
@echo off
if exist NewAccount.sql del newaccount.sql
echo.
ECHO Test account creator made by Johved.
echo IMORTANT: Always type something in, if you dont need\want to type 0
echo.
ECHO Insert please:
echo.

set /p accname= Desired Account Name:
set /p accpass= Desired Password:
set /p email= account email:
set /p flags= Flags(If you want BC, put 8 and 0 if not):
set /p gm= If its a gm account type AZ, if not type 0:
set /p id= Account ID, (must be different from the other accounts, increase with 1):

ECHO USE `logon`;>NewAccount.sql
ECHO insert into `accounts`(`acct`,`login`,`password`,`encrypted_password`,`gm`,`banned`,`lastlog in`,`lastip`,`email`,`flags`,`forceLanguage`,`muted`) values (%id%,'%accname%','%accpass%','','%gm%',0,'2008-07-25 15:16:00','127.0.0.1','',%flags%,'enUS',0);>>NewAccount.sql

pause
echo.
echo.
echo Collected info:
echo Login:%accname%
echo Password: %accpass%
echo Email: %email%
echo Flags: %flags%
echo GM value: %gm%

SET user=root
SET pass=ascent
SET char_db=logon
SET dumppath=d:\
SET port=3306
SET host=localhost
SET mysqlpath=..\Server\mysql\bin\ (if you put the batch file inside xpackblizz folder you don't need to modify it)

Echo Importing to database...
%mysqlpath%\mysql -h %host% --user=%user% --password=%pass% --port=%port% %char_db% < newaccount.sql



echo.
echo If any errors make sure you have started the mysql server
echo (Start Background.bat)
echo.
ECHO Done. If logonserver is running, type 'reload' in it.
echo.

pause
---------------------------------------------------------------

Hope that helps.

[badot]

1. can someone upload latest arcemu server 2537 or better? just the server dont include the database and the other like website fun so its easy to download.

2. what do you think cause the Unterminated block when i open my arcemu-world.exe?

3. what do you think happened to keazain?

i'll give big rep thanks

i'm still using 2278 server and i think i has less error than the latest

[theory18]

wow khar00f thanks for all the info and explanaition +repped you for that...
i really appreciate it you and wowaddict trying to help me but i'm really looking for just the site to be fixed, it's not supposed to be running a batch file when prolly 2lines of codes need to be changed... but still thanks man !!

And wowaddict if you could pls try making an sql file of your world or just put toghether the singles you had? or wouldn't that be smart cause i have another version?

[theory18]

ok guys i fixed the register page, lucky i'm a proffesional php programmer ^^.
but all the tables scared me a bit that's why i didn't try before...

what you have to change(don't know how to do with SQLyog) when in phpmyadmin, go to table 'accounts' then look for column 'acct' make it the primary key, and then set autoincrement on it (that was mistake 1).

Second open up /forum/reguser.php with notepad and change following code to the code that looks similar to it.
from line 122 to line 139

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','$showprofile')";
       mysql_query($SQL) or die(mysql_error()."<br>SQL ERROR");
	   mysql_select_db($chardb);
	   $SQLwow ="INSERT into accounts (login,password,encrypted_password,gm,vip,banned,lastip,email,flags,forceLanguage,muted,banreason) values ('$username','$pass2','','','0','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enGB','0','')";
	    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,encrypted_password,gm,vip,banned,lastip,email,flags,forceLanguage,muted,banreason) values ('$username','$pass2','','','0','0','".$_SERVER['REMOTE_ADDR']."','$email','24','enGB','0','')";
	    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");
		
      }

where code is red change it to your version of wowserver.

Hope it helps someone...

Now i just need my funlike server fixed ^^!

[W@WAdict]

1. can someone upload latest arcemu server 2537 or better? just the server dont include the database and the other like website fun so its easy to download.

See if this is what you are looking for?

ArcEmu Blizz Rev 2537 Server Only

ArcEmu Fun Rev 2537 Server Only

[marcmk2]

best repack ever!! love you man!

[Khar00f]

Theory18, have you tried playing on your Blizzlike server?

mine works but one hit kill, on me, or ennemies, i can't figure out what's wrong.

Just checking to see if any1 else experienced that problem also.

[in_Flames]

Hey keazain what is the status of your T3 server?

[theory18]

Theory18, have you tried playing on your Blizzlike server?

mine works but one hit kill, on me, or ennemies, i can't figure out what's wrong.

Just checking to see if any1 else experienced that problem also.

jup have that also...
and when you die the spirithealer doesnt revive you...
i wonder why al those other people here don't have that problem..

[Kyratas]

Hey all. I'm trying to get the fun server to work. Have MySQL installed. Tortoise installed. Navicat installed. The thing is that I keep getting the error, "access denied to 'root@localhost' , Password:YES". I have no clue what is going wrong.

Thanks,
Kyratas