Configuring Simple Register Website and Data SQL File

[witcherivan]

Original source

Register System is working 4.0 and 1.0 files.

What I want to mention. From the first time, the Registration refused to work and where to fill in the database was also not entirely clear.
I decided to look at the contents of the register.php file.
In this file you should pay attention to the lines: from 269 to 272

[COLOR=#116644]269[/COLOR]     [COLOR=#0055AA]$webhost[/COLOR]=[COLOR=#AA1111]"localhost"[/COLOR];       [COLOR=#AA5500]// host[/COLOR]
[COLOR=#116644]270[/COLOR]     [COLOR=#0055AA]$webuser[/COLOR]=[COLOR=#AA1111]"root"[/COLOR];           [COLOR=#AA5500]// user[/COLOR]
[COLOR=#116644]271[/COLOR]     [COLOR=#0055AA]$webpwd[/COLOR]=[COLOR=#AA1111]""[/COLOR];               [COLOR=#AA5500]// password[/COLOR]
[COLOR=#116644]272[/COLOR]     [COLOR=#0055AA]$webdb[/COLOR]=[COLOR=#AA1111]"account_data"[/COLOR];   [COLOR=#AA5500]// database[/COLOR]

As we can see the database access password was not set.
The host address is registered as: localhost.
The name of the database "account_data" should be noted.
In registration testing, I used a local server with a host: localhost
The user has access to the database: root
Database Access Password: root
Database created in phpMyAdmin: account_data
This is how the contents of the file (fragment) began to look: register.php

[COLOR=#116644]269[/COLOR]     [COLOR=#0055AA]$webhost[/COLOR]=[COLOR=#AA1111]"127.0.0.1"[/COLOR];       [COLOR=#AA5500]// host[/COLOR]
[COLOR=#116644]270[/COLOR]     [COLOR=#0055AA]$webuser[/COLOR]=[COLOR=#AA1111]"root"[/COLOR];           [COLOR=#AA5500]// user[/COLOR]
[COLOR=#116644]271[/COLOR]     [COLOR=#0055AA]$webpwd[/COLOR]=[COLOR=#AA1111]"root"[/COLOR];           [COLOR=#AA5500]// password[/COLOR]
[COLOR=#116644]272[/COLOR]     [COLOR=#0055AA]$webdb[/COLOR]=[COLOR=#AA1111]"account_data"[/COLOR];   [COLOR=#AA5500]// database[/COLOR]

Next, open phpMyAdmin and create a new Database: account_data

Go to the SQL tab and paste the data below and click the "Go" button:

[COLOR=#0055AA][I]SET[/I][/COLOR] [COLOR=#0055AA][I]FOREIGN_KEY_CHECKS[/I][/COLOR]=[COLOR=#116644]0[/COLOR];
[COLOR=#0055AA][I]CREATE[/I][/COLOR] [COLOR=#0055AA][I]TABLE[/I][/COLOR] `account_data` (
  `id` [COLOR=#0055AA]int[/COLOR]([COLOR=#116644]10[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR] [COLOR=#0055AA][I]AUTO_INCREMENT[/I][/COLOR],
  `accountname` [COLOR=#0055AA]varchar[/COLOR]([COLOR=#116644]20[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR],
  `password` [COLOR=#0055AA]varchar[/COLOR]([COLOR=#116644]20[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR],
  `email` [COLOR=#0055AA]varchar[/COLOR]([COLOR=#116644]35[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR],
  `coins` [COLOR=#0055AA]varchar[/COLOR]([COLOR=#116644]255[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR],
  `notice` [COLOR=#0055AA]varchar[/COLOR]([COLOR=#116644]255[/COLOR]) [COLOR=#0055AA][I]NOT[/I][/COLOR] [COLOR=#770088]NULL[/COLOR],
  [COLOR=#0055AA][I]PRIMARY[/I][/COLOR] [COLOR=#0055AA][I]KEY[/I][/COLOR] (`id`)
) [COLOR=#0055AA][I]ENGINE[/I][/COLOR]=InnoDB [COLOR=#0055AA][I]AUTO_INCREMENT[/I][/COLOR]=[COLOR=#116644]11[/COLOR] [COLOR=#770088]DEFAULT[/COLOR] [COLOR=#0055AA][I]CHARSET[/I][/COLOR]=utf8;

It remains the case for small - to register our new game account. But, first check a couple of things:

1. The folder SimpleRegisterScript (it is better to get rid of the spaces in the folder name) with the contents placed in the directory: C:\wamp\www\
2. PostgreSQL, phpMyAdmin, AccountServer - Started.

Now that all the preparations have been completed in the browser, go to:

http:[COLOR=#AA5500]//localhost/SimpleRegisterScript/register.php[/COLOR]

Fill in the fields and confirm the registration.

If everything is done correctly, the account we just created will appear in the PostgreSQL

and phpMyAdmin databases.

attachment:

You must be registered to see links

 

[Paulus]

Nice job ! Thanks for sharing

 

[conantogo]

dear Witcherivan the file "Simple Register Script.zip" not exist anymore .. :/:
can you plz reupload it ?

 

[witcherivan]

dear Witcherivan the file "Simple Register Script.zip" not exist anymore .. :/:
can you plz reupload it ?

Ok. Maybe here link worked: http://forum.ragezone.com/f747/create-account-1144483/#post8853331

 

[conantogo]

Thanks witcherivan u the best
my server works fine ..but there a simple problem .. i did everything correctly .. and the other account was created in the phpmyadmin ..

and in the postgres .. but when i lunch the client and enter the new Account .. i cant found the server "RageZone ForEver" look here in the black box :O:

i fill it manual .. write "RageZone ForEver" and save .. but i still cant see the server in the game .. Although if i enter with the Basic-primary account i see the server normally :?:
whats do you think the problem is ?

 

[witcherivan]

Maybe problem:
Look you last screen.
Parameter: curent_access character var... - User.
Need - Developer.
With the 'User' option on the local server, the game will not start.

Sorry my bad English :/

p.s. - [no advertis]

You must be registered to see links

 

[conantogo]

Maybe problem:
Look you last screen.
Parameter: curent_access character var... - User.
Need - Developer.
With the 'User' option on the local server, the game will not start.

Sorry my bad English :/

p.s. - [no advertis]

You must be registered to see links

Hmmmm is there a way to change this automatically ??
i registered in "eternal-call.info" but i don't have permission yet :ehh:

 

[VictorDarkness]

Good day . Please "Simple Register Script.zip"

 

[xlw00tlx]

sorry for necro post,tried,didnt work,it registers it in mysql but not in the postgres

 

[Niki_zrya]

SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE `account_data` (
`id` int(10) NULL AUTO_INCREMENT,
`accountname` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(35) NOT NULL,
`coins` varchar(255) NOT NULL,
`notice` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
_______________________________________________________
I failed : ( mb is it because I can't extract the Thumbs.db file ???

 

[Kreeate]

SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE `account_data` (
`id` int(10) NULL AUTO_INCREMENT,
`accountname` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(35) NOT NULL,
`coins` varchar(255) NOT NULL,
`notice` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
_______________________________________________________
I failed : ( mb is it because I can't extract the Thumbs.db file ???
View attachment 235961

You missed something in the code...

SET FOREIGN_KEY_CHECKS=0;
CREATE TABLE `account_data` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`accountname` varchar(20) NOT NULL,
`password` varchar(20) NOT NULL,
`email` varchar(35) NOT NULL,
`coins` varchar(255) NOT NULL,
`notice` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

Also, the "Thumbs.db" file is a standard Windows file that saves icon/thumbnail display information. The file is not related to any of the SQL data. You can ignore this file.

 

[Hecssim5]

I tried everything and it didn't work, when I clicked register nothing happened. some help?

 

[Kreeate]

I tried everything and it didn't work, when I clicked register nothing happened. some help?

Please post a full log so that we can try to solve your issue.