Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
You last visited: Today at 03:37

  • Please register to post and access all features, it's quick, easy and FREE!


[TUT]How to make account through data base

Reply
 
Old   #1
 
elite*gold: 0
Join Date: May 2011
Posts: 81
Received Thanks: 25
[TUT]How to make account through data base


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



Bucky-69 is offline  
Old 08/02/2011, 11:01   #2
 
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,241
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:
Code:
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.


RebeccaBlack is offline  
Old 08/02/2011, 11:53   #3
 
elite*gold: 0
Join Date: May 2011
Posts: 81
Received Thanks: 25
sure u can edit it for me it was a draft and dont have time to fix it busy atm
Bucky-69 is offline  
Old 08/02/2011, 12:46   #4
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,929
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


JohnHeatz is offline  
Old 08/02/2011, 12:46   #5
 
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,241
You would have to either post your login SP for me, or PM it to me.
RebeccaBlack is offline  
Old 08/03/2011, 03:39   #6
 
elite*gold: 0
Join Date: Oct 2009
Posts: 942
Received Thanks: 1,061
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...
[Admin]Snuggle is offline  
Thanks
5 Users
Old 03/09/2013, 14:46   #7
 
elite*gold: 0
Join Date: Dec 2010
Posts: 3
Received Thanks: 0
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
jhullyz is offline  
Old 03/09/2013, 17:41   #8
 
elite*gold: 10
Join Date: May 2012
Posts: 1,859
Received Thanks: 2,582
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
TeddyBear94 is offline  
Old 04/16/2017, 03:05   #9
 
elite*gold: 0
Join Date: Apr 2017
Posts: 6
Received Thanks: 0
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
DarKMalox is offline  
Old 04/16/2017, 05:43   #10
 
elite*gold: 0
Join Date: Jul 2010
Posts: 403
Received Thanks: 400
Quote:
Originally Posted by DarKMalox View Post
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.


sominus is offline  
Thanks
1 User
Reply



« [Euphoria Dev Team Release] Shaiya Update Downloader | [Release] World Cup Map »

Similar Threads
Help Telecaster New Data Base
07/05/2011 - Rappelz - 2 Replies
Hi all I did Deleted mySql Frome My Pc then i Installe it When I try to Make the Telcaster New database Error Come for me Like thatplz Help and Thank you ImageShack® - Online Photo and Video Hosting
How to change data base password?
10/26/2010 - Metin2 PServer - Discussions / Questions - 2 Replies
How can i change data base password in hamachi server?
help with data base
06/28/2009 - Dekaron Private Server - 3 Replies
hi staff I would like to know who has the database action 5 that can send by email or put a link to download. or a server really dekaron action 4. Man anybody will help me
New server SQL data base
02/22/2009 - Dekaron Private Server - 1 Replies
Hey I need someone who knows how to set up a data base in sql server. It would be much appreciated, and in return with help i could make you a GM if you are interested in my dekaron server. I will be having action 6 Files. Dekaron Destiny...
EO Server - Data Base?!?
04/29/2008 - EO PServer Hosting - 0 Replies
heya evry one! i want to make my server wih help of light _knightxx (spy dude) and i know now how to connect to navicat with my connection - but i need the db forthe server! can anyy one give me a link for a db?! (download) pls



All times are GMT +2. The time now is 03:37.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.