The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Sorta Forum Related, didn't see anywhere else to post this.
I'm trying to finish up the Avatars Add-on I am working on. My Database skills are very very weak. I need to do the following and could use some information on the best approach while I attempt to make an Avatar Config file.
New Variables, probably going to post them in the Config.asp file.
Integers '=== Max File Size for New Avatars ===
intAvatarMaxUploadSize
Possible Booleans '=== Allow Members to Upload - Yes | No ===
intAvatarAllowUpload
'=== Restrict to Specific Usergroups - Yes | No ===
intAvatarUseUsergroups
I need to create Database space to hold those values.
Now what does the Application() function do? I've read a few things but still unclear to what it is suppose to do. It seems to hold information in memory for all users. Sorta like a universal cookie.
I just don't understand its main use if the config is always present on most files why the Application Variable is used.
If there are any tutorials anywhere on building a config that would be very helpful. I still would need to know how to call the variables from the Database, assign them different values, submit new information and loop through database information.
I'll be trying to practice elsewhere on this.
Any and every help is appreciated.
<
I'm trying to finish up the Avatars Add-on I am working on. My Database skills are very very weak. I need to do the following and could use some information on the best approach while I attempt to make an Avatar Config file.
New Variables, probably going to post them in the Config.asp file.
Integers '=== Max File Size for New Avatars ===
intAvatarMaxUploadSize
Possible Booleans '=== Allow Members to Upload - Yes | No ===
intAvatarAllowUpload
'=== Restrict to Specific Usergroups - Yes | No ===
intAvatarUseUsergroups
I need to create Database space to hold those values.
Now what does the Application() function do? I've read a few things but still unclear to what it is suppose to do. It seems to hold information in memory for all users. Sorta like a universal cookie.
I just don't understand its main use if the config is always present on most files why the Application Variable is used.
If there are any tutorials anywhere on building a config that would be very helpful. I still would need to know how to call the variables from the Database, assign them different values, submit new information and loop through database information.
I'll be trying to practice elsewhere on this.
Any and every help is appreciated.
<
Postet den
Basically you should define those variables in the database, into the FORUM_CONFIG_NEW. A dbs file for that could be something like this:
For boolean variables '0' meaning No and '1' meaning Yes. The value for upload size is just an example.
Then you need to declare the variables in config.asp, just below the existing definition:
Then get the values from the App Variables (add them below the existing ones):
Once you run the dbs file and add these changes to config.asp, running setup.asp will load the variables values from FORUM_CONFIG_NEW into the app variables, which means that your variables will hold the values as specified in the dbs file.
You can then test and change the variables in your pages. Probably adding a mod administration page where you can change their values would be a good option too.<
Code:
Zuel's Avatar Add-On
[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('intAvatarMaxUploadSize','100000')
(C_VARIABLE,C_VALUE)#('intAvatarAllowUpload','1')
(C_VARIABLE,C_VALUE)#('intAvatarUseUsergroups','0')
[END]
Then you need to declare the variables in config.asp, just below the existing definition:
Code:
Dim SubCount, MySubCount
Dim intAvatarMaxUploadSize, intAvatarAllowUpload, intAvatarUseUsergroups
Code:
intAvatarMaxUploadSize = Application(strCookieURL & "INTAVATARMAXUPLOADSIZE")
intAvatarAllowUpload = Application(strCookieURL & "INTAVATARALLOWUPLOAD")
intAvatarUseUsergroups = Application(strCookieURL & "INTAVATARUSEUSERGROUPS")
Once you run the dbs file and add these changes to config.asp, running setup.asp will load the variables values from FORUM_CONFIG_NEW into the app variables, which means that your variables will hold the values as specified in the dbs file.
You can then test and change the variables in your pages. Probably adding a mod administration page where you can change their values would be a good option too.<
Postet den
Oh man just great! Sounds very simple! I might finish this tonight!
Thanks!<
Thanks!<
Postet den
Hehehe I knocked out 2 big portions out already 
I'm near 85%. Yippppeee!
With those new variables and an array I was able to create the Category Navigation dynamically!
Yeah!
Now with the Avatar_Config file, to update the database all I do is something like:
[CREATE] AVATAR_CATEGORIES
(CATEGORY_ID,CATEGORY_NAME)#('1','EDITME')
[END]
Then to add a new record something like:
strSql = "INSERT INTO " & strTablePrefix & "AVATAR_CATEGORIES (CATEGORY_NAME) VALUES(" & strNewCategory & ")"
I haven't tried the SQL yet, rather get an okay from you guys first so I don't screw stuff up.
Once that is done, how do I pull the information? I don't have a application variable with this one. I need to loop the information out into an array more then likely. Then do a split I think.<
I'm near 85%. Yippppeee!
With those new variables and an array I was able to create the Category Navigation dynamically!
Yeah!
Now with the Avatar_Config file, to update the database all I do is something like:
[CREATE] AVATAR_CATEGORIES
(CATEGORY_ID,CATEGORY_NAME)#('1','EDITME')
[END]
Then to add a new record something like:
strSql = "INSERT INTO " & strTablePrefix & "AVATAR_CATEGORIES (CATEGORY_NAME) VALUES(" & strNewCategory & ")"
I haven't tried the SQL yet, rather get an okay from you guys first so I don't screw stuff up.
Once that is done, how do I pull the information? I don't have a application variable with this one. I need to loop the information out into an array more then likely. Then do a split I think.<
Postet den
To add the record to the table, the dbs file should be:
I'm admiting the table has an automatically assiged category id.
What do you want to pull?<
Code:
[INSERT]
AVATAR_CATEGORIES
(CATEGORY_NAME)#('EDITME')
[END]
What do you want to pull?<
Postet den
The information I added. Also I have to create that table in the DB first.
Like the Value 'EDITME' and the rest of the values that will come.
Could be 'General', 'Misc', 'Funny', etc<
Like the Value 'EDITME' and the rest of the values that will come.
Could be 'General', 'Misc', 'Funny', etc<