How To Create A Registration Page and Item Shop

• Nov 18, 2007

• #1

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

Extract The Local Server Of O2PS
then download this

You must be registered to see links

then install ultidev
after it install
open it
and configure it to the file
How To Create reistration page

delete the column of id9you

How?


go to start> program files> microsoft sql>enterprise manager

then
click microsoft sql servers> sql server group> (local)(windows nt)
click on databases
on test2 database
now click the tables
find the member table
then design table
after that

right click on id9you
then delete column

The first "Pick Default Document", do i point to the "register.html" in the "Local Server.rar"?

yes
and
first

You must be registered to see links

generate a id
and
pick a default document in "register.html"
and the asp target version is asp 2.0
and save it

it should work by now

How To Create Item Shop


Just Config it to Ultidev
Example of that

You must be registered to see links

need hamachi

 

Attachments

You must be registered for see attachments list

Last edited: Jan 30, 2008

• Nov 20, 2007

• #2

K

kennethng

Newbie Spellweaver

Joined

Sep 19, 2007

Messages

5

Reaction score

0

Re: How To Create A Registration Page

Can you explain how to delete the column of id9you?

I don't know how to remove so I am always getting this error :

Server Error in '/' Application.
--------------------------------------------------------------------------------

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id9you', table 'test2.dbo.member'; column does not allow nulls. INSERT fails.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id9you', table 'test2.dbo.member'; column does not allow nulls. INSERT fails.

Source Error:


Line 53: Function insertdb() As Object
Line 54: sql = "insert into member (userid,usernick,sex,passwd) values('" & f2 & "','" & f3 & "'," & f4 & ",'" & f5 & "')"
Line 55: objConn.Execute(sql, right_if)
Line 56: End Function
Line 57:



Nvm, i got it working by changing the codes a bit, its not removing the id9you column, its adding the column, he said wrongly..

Just download this new get.apsx file below in the attachment, it should work now..

Note : Do remember to change your Server IP, ID & password still.

 

Attachments

You must be registered for see attachments list

• Nov 20, 2007

• #3

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

Re: How To Create A Registration Page

how?

go to start> program files> microsoft sql>enterprise manager

then
click microsoft sql servers> sql server group> (local)(windows nt)
click on databases
on test2 database
now click the tables
find the member table
then design table
after that

right click on id9you
then delete column


it should work by now

 

• Jan 23, 2008

• #4

C

chancsy

Newbie Spellweaver

Joined

Nov 8, 2007

Messages

5

Reaction score

0

Firstly thank you jcgo16 for the guide.

But i'm totally clueless when Cassini Web Server Explorer starts.
Need your help to explain the fields, what do i fill them with?
The first "Pick Default Document", do i point to the "register.html" in the "Local Server.rar"?
How about other fields do you mind explaining a little more because i no nothing of these..

Thanks in advance.

 

• Jan 28, 2008

• #5

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

The first "Pick Default Document", do i point to the "register.html" in the "Local Server.rar"?

yes
and
first

You must be registered to see links

generate a id
and
pick a default document in "register.html"
and the asp target version is asp 2.0
and save it

 

• Feb 4, 2008

• #6

E

eugene93

Newbie Spellweaver

Joined

Jul 22, 2004

Messages

38

Reaction score

0

hey i am usimg hamachi too but how can i let others see my register page? i can view the page from

You must be registered to see links

but the rest of my frens cant

 

• Feb 4, 2008

• #7

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

just
post your network name
and password in pm only
i will solved that

 

• Feb 4, 2008

• #8

E

eugene93

Newbie Spellweaver

Joined

Jul 22, 2004

Messages

38

Reaction score

0

Network : EnyZqn
pw : 123

 

• Feb 5, 2008

• #9

imaginationz

Junior Spellweaver

Joined

Oct 23, 2006

Messages

179

Reaction score

6

by the way, how to delete the old unused member data?

such as

jedi
test01
test02
9youtest001
9youtest002
.
.
.


When I try to delete, it say

"Another user has modified the contents of this table or view; the database row you are modifying no longer exists in the database"

 

• Feb 6, 2008

• #10

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

you cannot delete that

because you restore it without that table

 

• Feb 9, 2008

• #11

E

eugene93

Newbie Spellweaver

Joined

Jul 22, 2004

Messages

38

Reaction score

0

erm about the item shop...after we change to our pw and user in the web.config file then wat we do?

 

• Feb 10, 2008

• #12

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

it should work by now

by the way
someone has kick me in your network
so i cant help you with that

 

• Feb 19, 2008

• #13

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

sticky topic

 

• Feb 20, 2008

• #14

Q

qufaud46

Initiate Mage

Joined

Dec 23, 2007

Messages

2

Reaction score

0

oh..
I want buy item at 'my private' server
... what is payment.rar in movie?
and what is Payment_input.asp?
how can I download 'payment.rar'?
Plz help me..

 

• Feb 20, 2008

• #15

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

payment.rar?
where is that?

 

• Mar 27, 2008

• #16

K

kritus98

Newbie Spellweaver

Joined

Jan 19, 2007

Messages

36

Reaction score

0

to make it work
edit the password in the "get.aspx"
also in the "web.config"

Find this in the "get.aspx" and edit
strDBCon = "DRIVER={SQL Server};SERVER=localhost; database=test2;UID=sa;PWD=your password;"

Also find this in the "web.config"
<add key="MM_CONNECTION_STRING_db" value="Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=localhost;Initial Catalog=test2;User ID=sa;Password=your password;" />

then your done

 

• Jun 3, 2008

• #17

D

DT | Hope

Newbie Spellweaver

Joined

May 29, 2008

Messages

30

Reaction score

0

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DT.O2JAM'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DT.O2JAM'.

Source Error:


Line 60: strDBCon = "DRIVER={SQL Server};SERVER=127.0.0.1; database=test2;UID=DT.O2JAM;PWD=;"
Line 61: objConn = new ADODB.Connection()
Line 62: objConn.Open(strDBCon)
Line 63: End Function
Line 64:


Source File: E:\O2Jam\DT.O2Jam2\Local Server\get.aspx Line: 62


wat happen ??

 

• Jun 3, 2008

• #18

D

DT | Hope

Newbie Spellweaver

Joined

May 29, 2008

Messages

30

Reaction score

0

I adi fix for the register page


now the item shop.... cant work

 

• Jun 3, 2008

• #19

D

DT | Hope

Newbie Spellweaver

Joined

May 29, 2008

Messages

30

Reaction score

0

can help me ?

 

• Jun 4, 2008

• #20

jcgo16

Experienced Elementalist

Joined

Apr 9, 2007

Messages

211

Reaction score

1

change the user into "sa"(w/o quotes)