v15 In-Depth Setup Guide /w Support

[Blackbox]

how the fuck do i make an account?

By reading the posts, in this thread, or at least trying to search. You'd find your answer rather easily.


Edit: Took 2 seconds. http://forum.ragezone.com/f483/help-...0/#post5957058

Search: Keyword(s): account ; Forum: FlyFF Help and child forums

Showing results 1 to 50 of 250
Search took 2.04 seconds.

Literally.

Creating An Account

This is how you create an account, the CORRECT way.

Find the dbo.CREATEACCOUNT procedure in the release section, it is posted by Reimniess.
DO NOT USE the dbo.ASP.createaccount OR ANYTHING like that, they DO NOT WORK!

Execute the SQL you get from his post and make sure it is executed in the ACCOUNT_DBF databases.

Then go to the procedure and EXECUTE it.

You should see two fields you need to fill. Put in your USERNAME in the first one. MAKE SURE IT IS ALL LOWERCASE.

Then go to here MD5 GENERATOR and in the field put in serusadmin.

Then click the md5 button at the bottom and you should get

ef9e8ddbf4e00ffef8991065a3fdef8c

copy and paste that and put it into the password field under your username.

Now press EXECUTE and execute the script, now you should have an account with the password "admin" with no "" around it.

Hopefully this will be the LAST time i have to post about making an account since it is VERY VERY easy to make an account.

NOTES: serus is the SALT, you need to use this SALT everytime you create an account, i don't know what a SALT is nor do i really care, all i know is that you MUST use this SALT to make your account work. Or ASK SERUS to remove the salt from the neuz.exe or do it yourself.

PS: The CAPS are used only so that it becomes more clear, I'm neither flaming or yelling XD


To create an account an admin, run this query.

Admin Query

I found this:

CreateAccount Function by Reim (If you don't already have it):

Spoiler:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[createaccount] 
@account VARCHAR(15),
@password VARCHAR(32)

AS

SET NOCOUNT ON

DECLARE @DateActivated AS CHAR(8)

IF NOT EXISTS (SELECT account FROM ACCOUNT_TBL WHERE account = @account) BEGIN
INSERT INTO ACCOUNT_TBL (account, [password], id_no2, isuse, member, realname) 
VALUES (@account, @password, @password, 'T', 'A', 'F')

SET @DateActivated = CONVERT(CHAR(8), GETDATE()-1, 112 ) --Is the date today - 1
--UPDATE ACCOUNT_TBL_DETAIL SET BlockTime = @DateYesterday WHERE account = @userid	
--INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
--	VALUES (@account, 'A000', '2', 'F', GETDATE(), '20990101', '20990101', '20050101', 'O')

INSERT INTO ACCOUNT_TBL_DETAIL (account, gamecode, tester, m_chLoginAuthority, regdate, BlockTime, EndTime, WebTime, isuse)
VALUES (@account, 'A000', '2', 'F', GETDATE(), @DateActivated, '20990101', '20050101', 'O')

END

[Spetsnaz]

WELL I DID THAT AND I STILL CANNOT GET THIS THING TO WORK!
sorry for caps
can someone teamviewer me?

[benjaginov]

Im getting an error when starting database server im sure i missed something small some where if any 1 can help please do, ty.

" Can't connect db: CDbControler.CreateQuery "





~~~~~~~~~~~FIXED if any 1 has this problem i spelled character01 "charater01" make sure thats right :P


thx for guide and taking yur time to post and support, it was prity simple.

[Sason]

Delete.

[kinng27]

nice tutor,

[Phant0m]

Can I get some help here?
I'm stuck at selecting Server...

[Dell Honne]

check accountserver.ini

It has something to do with the IP/settings you placed there, or maybe the IP addresses in another ini file.

[Phant0m]

I get this error...

2010/10/21	23:28:04
query:CHARACTER_STR 'S2',@im_idPlayer='0000000',@iserverindex='01',@iaccount='darckalan',@im_szName='NO, YOU DONT GET TO SEE MY PASSWORD...',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@im_aCheckedQuest='(null)'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'CHARACTER_STR'.

[Dell Honne]

[SQL Native Client][SQL Server]Could not find stored procedure 'CHARACTER_STR'.

Something's wrong with your database.

Are you using the AiO? The AiO databases has a lot of sql errors.

[Phant0m]

[SQL Native Client][SQL Server]Could not find stored procedure 'CHARACTER_STR'.

Something's wrong with your database.

Are you using the AiO? The AiO databases has a lot of sql errors.

No, I'm using the DB in this thread...
I am about to try AiO now...

---------- Post added at 04:24 PM ---------- Previous post was at 04:22 PM ----------

Can you make a .SQL script with that creates this procedure? So I can login?

Thanks!

[vivahotpwet]

thanks for the guide.. by the way.. do you have gm commands?..

[Phant0m]

Fixed the previous error... (I'm not using AiO Databases)

Error:

[Dell Honne]

Did you do whats at the bottom of the guide?

Usually that will fix it, changing your IP and the port in neuz.exe

[Phant0m]

Did you do whats at the bottom of the guide?

Usually that will fix it, changing your IP and the port in neuz.exe

I'm not that noob...
I did everything, and followed the guide letter by letter...

[Dell Honne]

I'm not that noob...
I did everything, and followed the guide letter by letter...

I'm not saying your a noob?

I'm asking if you did it or not so I can help fix it.