[Need Help] Make DB

[GMCronus]

Heya mabe a stupid request but here goes.

is there anyone out there that know how to connect username (make) from chars to PS_UserData


let's say you messup PS_UserData and you don't have a backup BUT you still have PS_GameData

yes i know password isnt in that db but still password is easy to make.

i just want the dbo.Users_Master to be made from username in .dbo.Chars

becouse dbo.Chars have the useruid too this way there should be a way to make the user account in dbo.Users_Master from the dbo.Chars right?

manual yes i know it can be done LOL but please tell me it's another way?

userid and useruid need to be the same as in char to make the chars work with that account if i'm not 100% wrong or is it just UID that work with the chars?

any way i so wanted to just make the dbo.Users_Master from the dbo.Chars tabel. ios there anyone that can try and help me with that please?

[JohnHeatz]

Not really, knowing how it works, the UserUID is a secondary key which gives reference to the dbo.Users_Master. With just this information you can't recover the usernames, there is no way, unless what you want to do is get the name of a character and make it the account name, which can be done through a simple UPDATE query

[GMCronus]

well in char or charitems or what ever it's both username "Userid" and UserUID that should be the same in User_master too. but User_master have password. points and so on too.

let's say you make a username "bomboom1" but that username is already in Chars, MaxGroth,charitem and so on. but becouse you lost the db User_master (PS_Userdata) and need to make a new i wanted all chars with usernames and Useruid to make matching In User_Master

i'm not that good in sql files to make a update one. but it's kind of like

it's like copy all Userid's + Useruid's from ps_Gamedata.dbo.Chars -
PS_UserData.dbo.User_Master

so if you already have a char created with alot of stuff in them it needs to make a User account for that char.


password isnt listed anywhere in GameData under chars i know but that be be just a word for everyone.

becouse i have gamedata database but lost UserData so i need them to match so they can be uysed. or i have to move all manualy. Like have ppl make an account, thenchange the CharID,Charname and all that manualy after they made it to that UserID and UserUID

manualy i know it works but i'm 99,995 sure sql can understand like:

IF chars and User_Master don't match make a user account with he same Userid and UserUID that match Chars in ps_Gamedata so that account then have those chars..

points set to 0, password set to xxxxx or something. ip set to 127.0.0.1 and make all normal accounts..

that realy can't be done? i'm sorry but i'm ok on sql but this is kind of a script i would use weeks or month on and ppl that know this well would use a short time on

[JohnHeatz]

UserID and UserUID are not the same as the UID is numerical, not a varchar

[GMCronus]

sorry i know userid and uid inst the same hehe. but if you get a new userdata here "clean one" it hacve row id in them too. so there should be a posebility to make both userid and useruid beciouse alot of the db here isnt premade for auto register?

auto made= removed rowid for online register

[JohnHeatz]

Now rowid has even less to do with this as the rowid is actually something that comes directly from SQL as a way to know what was entered first, time wise.

[GMCronus]

i'm not even sure you get me.

becouse id row id is in the databse the rows userUID isnt instance or what ever the name is (none changable) thay need to be made becouse of some auto register php's.

as this is presten UserUID inst "used" as the incance number like rowid is when it's pressent.

that was just what i was trying to point out. but this means it's no possible way to make UserUID and UserID from chars make user account under User_master? that fit the same in chars? so if you loggon you get the right chars in the right username?

like i said before let's say you loose your PS_UserData but you still have PS_Gamedata that have the same UserID and UserUID that's used in ps_Userdata.dbo.User_master to make accounts.

is there no way to restore the User account to fit the working chars?

i think the UserUID is the trigger to have the right chars and so on in the right user account.

[JohnHeatz]

Unless you want to make everyone's username a number, it won't work

[GMCronus]

kk so use both userid and useruid to make a useraccount don't work. good to know..

stupid in a way becouse making in manual is possible :-)

never said microsoft's stuff is smart but anyway stupid he he

[GMCronus]

let's ask another way.

is it possible to make a script that can make x accounts? dummy accounts?


let's say you want 20 000 or 25 000 accounts made only for dummy use..

is that even possible?

same username and password on all of them and all normal. possible or not?

[JohnHeatz]

You can do it with a loop indeed, in which you do an Insert over and over again, changing some digits that you want to change (variables)

[GMCronus]

but i want like a bot/script or anything like that. that can make me 25 accounts.

but for me to change didgit 25 000 times is too much hahaa. i wanted a script that just change like the username from what i put in and then start making 1,2,3,4,5,6 and so on.

mabe make 1000 or something then i can do another but doing 25 000 is too time consuming. LOL

i just hate that 1 db have all the info and sql is so stupid it can't just copy userid to another userid but oh well