Register for your free account! | Forgot your password?

You last visited: Today at 15:05

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

 

[php]problem

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Exclamation [php]problem

[CENTER]Hello first and foremost! I want to apologize from the member Thndr on dispositive improper in the previous topic.

Now enter the objective:

I have modified a registration page that I received From a Friend !

But no matter how I tried to stay error "Failed to verify is the provided user named already exists." Shows

Now, with CODE: I wish news what's wrong!

Fixed BY Using :
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','NULL','NULL','NULL','NULL','NULL','com.elixir.billing.impl.ImmAccount','NULL','$password2'

Thanks !!



mohamad512 is offline  
Old   #2
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,005
Received Thanks: 961
There is a help thread for questions like these...



That being said...next time please use it.

Are you sure your account table is really named dbo.accounts because mine is dbo.account

You would need to change the PHP to match.


ThunderNikk is offline  
Old   #3
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
Thanks man

Lol xD o_o

dbo.account(s) because mine is dbo.account

-------------------

I try put the same error

I update the topic
mohamad512 is offline  
Old   #4
 
elite*gold: 0
Join Date: May 2011
Posts: 526
Received Thanks: 346
Hello,

First of all, you'll need to verify your connection string, make sure everything matches, and if it contains special characters, use '\' before it. (e.g.: $password = "[email protected][email protected]#\'", the result password: [email protected][email protected]#'.

Secondly, verify that the columns specified in the SQL commands and the table names match your database version, because the database that has the accounts table named 'dbo.Account' is Auth v2, and it uses 'username' instead of 'login_name'.

It'll be better if you provided more information for us, otherwise we'll keep mentioning frequent problems.


MuStA2222 is offline  
Old   #5
 
elite*gold: 0
Join Date: Jan 2013
Posts: 67
Received Thanks: 14
Quote:
Originally Posted by mohamad512 View Post

PHP Code:
$result = @odbc_exec($conn,"SELECT login_name FROM Account WHERE login_name = '$username'") or die('Failed to verify is the provided user named already exists.'); 
PHP Code:
$server "192.168.1.104";
$user =  "sa";
$password"";
$database "Auth";
$conn odbc_connect("Driver={SQL Server Native Client 11.0};Server=$server;Database=$database;"$user$password);
$result odbc_exec($conn,"SELECT login_name FROM Account WHERE login_name = '$username'");
$checked_id odbc_fetch_row($result);
if( (
$checked_id) == ("1") ) 
{
    echo 
"Failed to verify is the provided user named already exists.";
}
else 
{

try
sunnyxie49 is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2013
Posts: 118
Received Thanks: 12
I 'll try ! every thing u gays said

I update the topic with new code that i wanna now if it right !!

I think Accounts wrong ?!

if any one expert in that !

plz give me your skype !!

and i'm gonna send the script yo u to see it

second [php] then the first !! ^^

what about this !


mohamad512 is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
[Problem]Habe ein Problem und zwar spinnt mein VPC etwas(ohne Grund)?!
Also wie schon gesagt meins Server spinnt wodurch kiks usw. kommen :( ich lade euch die Screens in den Anhang, mit der Hoffnung, dass ihr mir helfen...
10 Replies - Metin2 PServer - Discussions / Questions



All times are GMT +2. The time now is 15:05.


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

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