v15 In-Depth Setup Guide /w Support

[maggieta2]

sorry there is a page to record the accounts available for these files?

[Sapheon]

Why does the Neuz.exe has a trojan banker in it?
>.<

[harvir4]

I found a bug with the world_server or neuz or something, really not sure which. I noticed when an account has an Authority Level of 1, no '/' commands show up at all, meaning they can't even PM/Shout/Whisper etc. Any ideas on how to fix this? I've tried other Authority Level's but it just makes the account a GM account, which I really don't want to happen.

Harv~

[TazWuzHereLowlz]

Hey When I Goto Char Login Page I Pick Char And Then Press Login and Sasys Cannot Connect To Server
I made the server and it wont let me

[cloud0n3]

so i've gotten the server up and running, my only problem is the admin account. i do exactly what i'm supposed to. even refreshed my DB's but nothing worked :/ just a normal account. any help/advice?

[harvir4]

so i've gotten the server up and running, my only problem is the admin account. i do exactly what i'm supposed to. even refreshed my DB's but nothing worked :/ just a normal account. any help/advice?

Under CHARACTER_TBL_DETAIL, find your account. (You can use a script like [SELECT * FROM CHARACTER_TBL_DETAIL WHERE account = "Your Account Name"].) Then find m_chLoginAuthority [4th Column] and change it to Z. Save the edits then start your server. Hope this helped :D.

Also, does anyone have any idea why normal accounts don't have any '/' functions? Or what Login Authority to normal members need to have? Because the only Level without GM commands is 1, but that disables all '/' commands. Thanks!

[cloud0n3]

in the CHARACTER_TBL_DETAIL all i see us NULL straight across.. but in the CHARACTER_TBL i can change the authority to Z, but when i do that it STILL doesn't give me admin powers :/ is there a certain way i have to activate them

[harvir4]

in the CHARACTER_TBL_DETAIL all i see us NULL straight across.. but in the CHARACTER_TBL i can change the authority to Z, but when i do that it STILL doesn't give me admin powers :/ is there a certain way i have to activate them

Oh sorry, I ment ACCOUNT_TBL_DETAIL under the ACCOUNT_DBF database. There should be an Authority thing there. Also can you use '/' commands as a normal player? Because I can't seem to. :\

[cloud0n3]

i did the account one too and it still says i'm a normal player :/

[King Khyle]

I have a question. How do other people play on the server? And I whenever I try to log on to my character it says I can't connect to the game.

[maggieta2]

exist regpage for this files?

[AaronzitoBr]

Hey guys, Can I use a Portuguese Client with this Database? :) 'Cause here in my country Gpotato have Flyff Brazil.

Ty ; )

[neversofter]

login DB login connected failed

[benjaginov]

Fixed

[Spetsnaz]

how the fuck do i make an account?

[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!