Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 20:00

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

 

[Discussion]My [Auth] and [INSERT Query]!

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Talking [Discussion]My [Auth] and [INSERT Query]!

Hello every body !!

I was have a prb in my register script but I ... it any way I have seen allot of reg scripts !! and all of it !!

the query like that :
PHP Code:
"INSERT Accounts( login_name,password,block,withdraw_remain_time,age ,auth_ok,pcbang,last_login_server_idx,event_code,result,ip,email) VALUES('$user','$converted_password',0,0,18,1,0,1,0,1,0,0)"
But my Auth Different WHAY ??!! and all of u the same or just me !!

You must register and activate your account in order to view images.



mohamad512 is offline  
Old   #2
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
Can you please start using the helpthread. There are two different auth databases which has been discussed several times!


c1ph3r is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
first of all !! I'm sorry for not using Help Thread !! But no one @@ even lock at the tread !!

and way ^^ !!

can u give me the another auth ? ^
mohamad512 is offline  
Old   #4
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
One auth account table is old, the other auth account table is new...

One works with older server files and one works with the newer server files clients and sframes.

Wouldn't you want to continue using the one that works with your server files?

The registration script was written for another account table...rewrite the script don't change the auth account table.


ThunderNikk is offline  
Old   #5
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
ok my friend but how can i deal with account_id ^^ ?

I rewrite it ^ is it right ?
PHP Code:
INSERT INTO [Auth].[dbo].[Account] ( account_id,account,password,email,pk_ ,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2 VALUES('','$username','$converted_password','$email','1','','','','','','com.elixir.billing.impl.ImmAccount','','$Apassword2')"; 
mohamad512 is offline  
Old   #6
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Thought you said you fixed it already/

But yes just rewrite the script to match your table column names.

There will probably be more in the script that will have to be rewritten though than just the SQL insert querry.

You will need to rewrite portions of the registration script that generate those column values.
ThunderNikk is offline  
Old   #7
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
You will need to rewrite portions of the registration script that generate those column values

I DON'T NOW HOW TO DO THAT

THE ERROR always show up @@' the $conn is connected !!
but the prob in $sql !!

it seems right !

PHP Code:
if(count($errors) == 0){
    
        
$sql "INSERT INTO [Auth].[dbo].[Account] ( account_id,account,password,email,pk_ ,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2 ) VALUES('','$username','$password','$email','1','NULL','NULL','NULL','NULL','NULL','com.elixir.billing.impl.ImmAccount','NULL','$password2')";
        
        if(
$result odbc_exec($conn,$sql)){
            
$success "Account Successfully Created!";
        }else{
            
            
$errors[] = '<font size ="4"><font color="red"><center>SONTHING WRONG</center></font></size>';
        }
    }

mohamad512 is offline  
Old   #8
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
I am sorry I am not very well versed in PHP...my registration script is the one ismokedrow wrote for ASPX

If you really want me to figure out what is going on with the PHP I am going to need to see the entire script not just the insert SQL query.

"THE ERROR always show up @@' the $conn is connected !!"

Sounds like you have some syntax issues to me.
ThunderNikk is offline  
Old   #9
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
ok do u have skype ?

add me mohamad512-aboatallah
mohamad512 is offline  
Old   #10
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,048
Received Thanks: 982
Sorry I don't have a public skype.
ThunderNikk is offline  
Old   #11
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Mate, you don't need to force people into looking into your problems to solve them, there's a dedicated thread for that and there are alot of experienced people who have dedicated a part of their time to help people in that manner.

Anyways, I'm answering you with the hope that this will be the last help thread by you, and here are the two ways you can solve this problem with:

1. Make a select sub-query inside your insert query to include a special account_id like this:
Code:
DECLARE @account_id int set @account_id = (SELECT MAX(account_id) FROM Account) INSERT INTO [Auth].[dbo].[Account] ( account_id,account,password,email,pk_ ,creationDate_,updateDate_,creatorId_,updatorId_,portId_,type_,accessDate_,password2 ) VALUES((@account_id)+1,'$username','$password','$email','1','NULL','NULL','NULL','NULL','NULL','com.elixir.billing.impl.ImmAccount','NULL','$password2')
2. Go to the Account table, right click it and click Design. Select the 'account_id' column, then on the bottom, change 'Identity Specification' to 'Yes'. This will allow the column to be auto-calculated as a unique identity such as the old accounts table.

And as I've mentioned above, please stop spamming the general forums with questions when there is a special thread for that.
MuStA2222 is offline  
Old   #12
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Done my friend But for the Change pass script :

This is wrong can u tell me the right insert query ?! :

PHP Code:
SELECT From [Auth].[dbo].[AccountWHERE account '$username' And Password '$Password'") or die('Failed to verify is the provided user named already exists.'); 
mohamad512 is offline  
Old   #13
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Quote:
Originally Posted by mohamad512 View Post
Done my friend But for the Change pass script :

This is wrong can u tell me the right insert query ?! :

PHP Code:
SELECT From [Auth].[dbo].[AccountWHERE account '$username' And Password '$Password'") or die('Failed to verify is the provided user named already exists.'); 
You can use an alternative method:

PHP Code:
$exists "SELECT COUNT(*) FROM Auth.dbo.Account WHERE account = '$username' AND password = '$password'";
if (
$exists "1") {
  echo 
"Failed to verify is the provided user named already exists.";
} else {
  echo 
"This account exists, do something here...";

I don't know php that well, but it should look something similar to this.
MuStA2222 is offline  
Thanks
1 User
Old   #14
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Thanks man and chek ur WhatsApp -،-
mohamad512 is offline  
Old   #15
 
elite*gold: 0
Join Date: Oct 2012
Posts: 124
Received Thanks: 12
done ?


MrStubborn is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
INSERT INTO Item Query?
Gibts ne query um items direkt per query ins inventory / als mail zu senden? Insanityflyff hat dieses ja zB,wenn man ein item auf der homepage...
4 Replies - Flyff PServer - Discussions / Questions
INSERT INTO Query.
Whats the INSERT INTO query when you want to add items to a characters inventory?
3 Replies - SRO PServer Ask the Experts
Insert item query
HI all, My commands game001 didnt working, what is the way to inser this : USE GO DECLARE @return_value int EXEC @return_value = .
7 Replies - Rappelz
hab in auth ordner usr/rain/auth den kompletten inhalt gelöscht
hi ich hab in auth ordner also usr/rain/auth den kompletten inhalt gelöscht und eine datei erstellt mit #!/bin/sh ./auth sleep 60*5 ./auth.sh...
2 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 20:00.


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.