[TUT]How to make account through data base

[Bucky-69]

this is me making a account through database hope this help you guys out there

[RebeccaBlack]

So I watched part of it, my internet is being err weird, and taking forever to load things. But I noticed you have the database "OMG_GameWeb". That database is redundant data, and it's not necessarily needed.

If you have the Login procedure [PS_UserData].[dbo].[usp_Try_GameLogin_Taiwan] for the database that requires "OMG_GameWeb" I can show you how to "bypass" the need for it, and be just fine. Or even better, an example of what I use to check passwords:

SELECT
	@UserUID=[UserUID],
	@Status=[Status],
	@Leave=[Leave],
	@UseQueue=[UseQueue]
FROM Users_Master AS UM
WHERE UM.UserID = @UserID
	AND UM.Pw = CONVERT(VARBINARY,HASHBYTES('SHA1',UM.Salt + CAST(@InPassword AS VARBINARY)));

Ignoring the CONVERT and such on the Pw (My database is encrypted), That's basically what you'd need to bypass the need for "OMG_GameWeb". Of course there is more to it, but yeah. :P

If you post your login SP, I'd be happy to edit it for you.

[Bucky-69]

sure u can edit it for me it was a draft and dont have time to fix it busy atm

[JohnHeatz]

There is a [How to]Register Accounts on the DataBase by AriezOMG already...no point on making threads explaining how to do something when there is already a thread explaining it

[RebeccaBlack]

You would have to either post your login SP for me, or PM it to me.

[[Admin]Snuggle]

Question
Since you are making the accounts in that table
How are you supposed to set someone as an admin, set donation points, find the ip, etc
That's all held in userdata > user_master o.o
Like silent said the OMG_GameWEB is redundant data...

[jhullyz]

Hello friends
Sorry to be reviving the post, but could someone help me how to do the procedure of creating normal account (client) by database?
The esplicação the Bucky-69 was quite efficient, but it can only create accounts AMD / GM.
Could someone help me? pls

[TeddyBear94]

the only difference between normal and GM/ADM account is that u set the value "Admin" to false, "Adminlevel" to 0, "Status" to 0 and "Usertyp" to N

[DarKMalox]

podrian hacer un tuto con fotos o videos de como crear una web de shaiya? es que la guia que hay no se entiende muy bien o almenos yo no la logro entender... levo 3 dias sin saber como se hace.... si alguien podria hacer un pequeño tuto con video o fotos se lo agradeceria mucho

[sominus]

Originally Posted by DarKMalox

podrian hacer un tuto con fotos o videos de como crear una web de shaiya? es que la guia que hay no se entiende muy bien o almenos yo no la logro entender... levo 3 dias sin saber como se hace.... si alguien podria hacer un pequeño tuto con video o fotos se lo agradeceria mucho

Trata de no postear la misma pregunta tantas veces, y sobre todo no revivir posts tan viejos. Te llamarán la atención.

Sobre la página, busca tutoriales de php y html (hay muchos en youtube), y ahí podrás ir entendiendo las guías de aquí.
Ten en cuenta que si instalas una web siguiendo un video, pero sin saber como funciona todo, te arriesgas a que la hackeen por fallas de seguridad, y aquí hay mucha gente esperando la oportunidad de hacer daño a otros servers.