Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 help		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sbai
New Member

Morocco
71 Posts
Posted - 16 April 2010 :  09:20:08  Show Profile  Visit sbai's Homepage
hello !

I want to add these codes to : inc_create_forum_mssql.asp

these are the codes :



[DROP]
ONLINE
[END]
[DROP]
ACTIVE_USERS
[END]
[CREATE]
ACTIVE_USERS

MEMBER_ID#int#NULL#
AU_IP#varchar(40)#NULL#
AU_LOGINTIME#varchar(100)#NULL#
AU_LASTACTIVETIME#varchar(100)#NULL#
AU_LASTPAGE#varchar(250)#NULL#
AU_QUERYSTRING#text#NULL#
AU_USER_AGENT#text#NULL#
[END]
[ALTER]
MEMBERS
ADD#M_AUHIDE#varchar(1)#NULL#
ALTER#M_AUHIDE#varchar(1)#NULL#
[END]
[ALTER]
MEMBERS_PENDING
ADD#M_AUHIDE#varchar(1)#NULL#
[END]
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRAUANON','1')
(C_VARIABLE,C_VALUE)#('STRAUANONOVERRIDE','2')
(C_VARIABLE,C_VALUE)#('STRAUPALLOW','4')
(C_VARIABLE,C_VALUE)#('STRAUPCOLLAPSE','1')
(C_VARIABLE,C_VALUE)#('STRAUALLOW','3')
(C_VARIABLE,C_VALUE)#('STRAUREFRESH','0')
(C_VARIABLE,C_VALUE)#('STRAUIP','1')
(C_VARIABLE,C_VALUE)#('STRAUUA','2')
(C_VARIABLE,C_VALUE)#('STRAULOCAL','3')
(C_VARIABLE,C_VALUE)#('STRAUTIMEOUT','7')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('STRAUADMINCOLOR','orangered')
(C_VARIABLE,C_VALUE)#('STRAUMODCOLOR','forestgreen')
(C_VARIABLE,C_VALUE)#('intAURecord','0')
(C_VARIABLE,C_VALUE)#('strAURecordDate','11111111111111')
[END]



[ALTER]
TOPICS
ADD#T_MSGICON#int#NULL#1
[END]
[ALTER]
A_TOPICS
ADD#T_MSGICON#int#NULL#1
[END]
[ALTER]
REPLY
ADD#R_MSGICON#int#NULL#1
[END]
[ALTER]
A_REPLY
ADD#R_MSGICON#int#NULL#1
[END]



[ALTER]
TOPICS
ADD#T_MSGICON#int#NULL#
[END]
[ALTER]
A_TOPICS
ADD#T_MSGICON#int#NULL#
[END]
[ALTER]
REPLY
ADD#R_MSGICON#int#NULL#
[END]
[ALTER]
A_REPLY
ADD#R_MSGICON#int#NULL#
[END]
[UPDATE]
TOPICS
T_MSGICON#1#
[END]
[UPDATE]
A_TOPICS
T_MSGICON#1#
[END]
[UPDATE]
REPLY
R_MSGICON#1#
[END]
[UPDATE]
A_REPLY
R_MSGICON#1#
[END]



[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRPOLLS','1')
(C_VARIABLE,C_VALUE)#('STRFEATUREDPOLL','0')
(C_VARIABLE,C_VALUE)#('STRFEATUREDPOLLID','0')
(C_VARIABLE,C_VALUE)#('STRFPOLLWINDOW','0')
(C_VARIABLE,C_VALUE)#('STRFPOLLTABLE','0')
(C_VARIABLE,C_VALUE)#('STRHIDEPOLL','0')
(C_VARIABLE,C_VALUE)#('STRMAXVOTES','8')
[END]
[ALTER]
TOPICS
ADD#T_ISPOLL#int#NULL#0
ADD#T_POLLSTATUS#int#NULL#1
[END]
[ALTER]
A_TOPICS
ADD#T_ISPOLL#int#NULL#0
ADD#T_POLLSTATUS#int#NULL#1
[END]
[ALTER]
FORUM
ADD#F_POLLS#int#NULL#0
[END]
[CREATE]
POLLS
POLL_ID
CAT_ID#int##
FORUM_ID#int##
TOPIC_ID#int##
P_WHOVOTES#varchar(12)##'everyone'
P_LASTVOTE#varchar(50)#NULL#
ANSWER1#varchar(100)#NULL#
COUNT1#int#NULL#0
ANSWER2#varchar(100)#NULL#
COUNT2#int#NULL#0
ANSWER3#varchar(100)#NULL#
COUNT3#int#NULL#0
ANSWER4#varchar(100)#NULL#
COUNT4#int#NULL#0
ANSWER5#varchar(100)#NULL#
COUNT5#int#NULL#0
ANSWER6#varchar(100)#NULL#
COUNT6#int#NULL#0
ANSWER7#varchar(100)#NULL#
COUNT7#int#NULL#0
ANSWER8#varchar(100)#NULL#
COUNT8#int#NULL#0
ANSWER9#varchar(100)#NULL#
COUNT9#int#NULL#0
ANSWER10#varchar(100)#NULL#
COUNT10#int#NULL#0
ANSWER11#varchar(100)#NULL#
COUNT11#int#NULL#0
ANSWER12#varchar(100)#NULL#
COUNT12#int#NULL#0
ANSWER13#varchar(100)#NULL#
COUNT13#int#NULL#0
ANSWER14#varchar(100)#NULL#
COUNT14#int#NULL#0
ANSWER15#varchar(100)#NULL#
COUNT15#int#NULL#0
[END]
[CREATE]
POLL_VOTES
POLL_ID
CAT_ID#int##
FORUM_ID#int##
TOPIC_ID#int##
MEMBER_ID#int##
GUEST_VOTE#int##0
[END]

MaD2ko0l
Senior Member

United Kingdom
1053 Posts
Posted - 16 April 2010 :  13:40:24  Show Profile  Visit MaD2ko0l's Homepage
2 questions...

1. why would you want to add them to that file?
2. wats stopping you from doing it yourself? you have the code in the file and its simple to follow
© 1999-2010 MaD2ko0l
Go to Top of Page

sbai
New Member

Morocco
71 Posts
Posted - 16 April 2010 :  14:23:05  Show Profile  Visit sbai's Homepage
quote:
Originally posted by MaD2ko0l

2 questions...

1. why would you want to add them to that file?
2. wats stopping you from doing it yourself? you have the code in the file and its simple to follow


1) i want to add them to the file because i didn't setup the forum yet !
Go to Top of Page

leatherlips
Senior Member

USA
1838 Posts
Posted - 16 April 2010 :  15:40:42  Show Profile  Visit leatherlips's Homepage
Couldn't you just go to the Admin Options and add your code in the Alternative MOD Setup?
Mangione Magic Forum - The Music of Chuck Mangione

My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD
Go to Top of Page

sbai
New Member

Morocco
71 Posts
Posted - 16 April 2010 :  16:46:34  Show Profile  Visit sbai's Homepage
quote:
Originally posted by leatherlips

Couldn't you just go to the Admin Options and add your code in the Alternative MOD Setup?


i didn't setup forum yet ! and the files need these codes strsql
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20611 Posts
Posted - 17 April 2010 :  04:35:46  Show Profile  Visit HuwR's Homepage
all you should need to do is upload the forum files, run setup.asp, then load admin_mod_dbsetup2 and paste the code into the box and run it, you should then be able to open the forum pages

MVC .net dev/test site | Snitz .NET Core running on Raspberry Pi

Go to Top of Page

sbai
New Member

Morocco
71 Posts
Posted - 17 April 2010 :  10:25:44  Show Profile  Visit sbai's Homepage
ok , thank you !
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07