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 06:49

  • 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   #2
 
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,223
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   #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   #4
 
elite*gold: 150
Join Date: Apr 2010
Posts: 9,739
Received Thanks: 8,915
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   #5
 
elite*gold: 0
Join Date: Sep 2010
Posts: 520
Received Thanks: 1,223
You would have to either post your login SP for me, or PM it to me.
RebeccaBlack is offline  
Old   #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   #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   #8
 
elite*gold: 10
Join Date: May 2012
Posts: 1,858
Received Thanks: 2,566
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   #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   #10
 
elite*gold: 0
Join Date: Jul 2010
Posts: 379
Received Thanks: 379
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



« Previous Thread | Next Thread »

Similar Threads
Help Telecaster New Data Base
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...
2 Replies - Rappelz
How to change data base password?
How can i change data base password in hamachi server?
2 Replies - Metin2 PServer - Discussions / Questions
help with data base
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...
3 Replies - Dekaron Private Server
New server SQL data base
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...
1 Replies - Dekaron Private Server
EO Server - Data Base?!?
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 -...
0 Replies - EO PServer Hosting



All times are GMT +1. The time now is 06:49.


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

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