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

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 import CSV into forum-db		  New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 01 February 2006 :  06:18:43  Show Profile  Visit MarcelG's Homepage
Okay, I guess my next question is a bit of a newbie question, but I still want to ask it ;
I've got about 100+ avatars I've already uploaded to my site.
I've got the URL's of the avatars, and their names stored in an Excell file. I saved the excell file as CSV.
Here it is:
CSV: http://storage.oxle.com/files/1/avatars.csv
XLS: http://storage.oxle.com/files/1/avatars.xls

I've got the following function to insert the avatars into the db:
Private Function intoDB()
   	Dim strSQL
   	set my_Conn= Server.CreateObject("ADODB.Connection")
	my_Conn.Open strConnString
	
   if request.cookies("jAvatar") = "yes" and Err_Msg = "" Then
	 response.cookies("jAvatar") = ""
	 'user = objUpload.Form.Item("Folder")
	 user = getMemberID(strFolder)
		'## Forum_SQL - Do DB Update
		strSql = "INSERT INTO " & strTablePrefix & "AVATAR ("
		strSql = strSql & "A_URL"
		strSql = strSql & ", A_NAME"
		strSql = strSql & ", A_MEMBER_ID"
		strSql = strSql & ", A_VALIDATED"
		strSql = strSql & ") VALUES ("
		strSql = strSql & "'" & URL   & "'"
		strSql = strSql & ", '" & NAME   & "'"
		strSql = strSql & ", 0"
		strSql = strSql & ", 1"
		strSql = strSql & ")"
		my_Conn.Execute (strSql)
		end if
	
		my_Conn.Close
		set my_Conn = nothing
		
   End Function

How do I quickly import all these avatars into the forum db (MS Access)?
portfolio - linkshrinker - oxle - twitter
Edited by - MarcelG on 01 February 2006 06:19:30

laser
Advanced Member

Australia
3859 Posts
Posted - 01 February 2006 :  06:23:49  Show Profile
Try this :


insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/africanamerican.gif', 'People - African American', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/asian-w-1.gif', 'People - Pink hair', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/av-12.gif', 'Logo - Green', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/avatar_getout.gif', 'Locked in', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/avatar_head_bang_5477_5829.gif', 'Banging head', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/av_apple_colored.gif', 'Apple - Apple1', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/av_ibook.jpg', 'Apple - iBook', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/baaaaaah.jpg', 'Sheep', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/baghead.gif', 'Emofaces - Bag', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/blindfold.gif', 'Emofaces - Blindfold', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/boer.gif', 'Stupid!', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/boobs.gif', 'Bouncing Boobs', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/borg.gif', 'Emofaces - Borg', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/canoworms.gif', 'Can'o'worms', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Caprice2.jpg', 'Jordan Caprice', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_alliesstar_logo_64.jpg', 'COD2 - Allied Star', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_dogtags_64.jpg', 'COD2 - Dogtags', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_flag_brit_64.jpg', 'COD2 - Brits', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_flag_russian_cod_64.jpg', 'COD2 - Russians', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_portrait_germanshoot64x64.jpg', 'COD2 - German', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_portrait_mike64.jpg', 'COD2 - Mike', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_portrait_Tanker64.jpg', 'COD2 - Tanker', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/cod2_soldier_64.jpg', 'COD2 - Soldier', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Cole164.jpg', 'Gun - Cole 1', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Cole364.jpg', 'Gun - Cole 2', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/computer.gif', 'Computer', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_Addcit.jpg', 'Condemned - Addcit', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_AgentThomas.jpg', 'Condemned - Ag. Thomas', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_Mannequin.jpg', 'Condemned - Mannequin', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_weapons001.jpg', 'Condemned - Pistol', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_weapons004.jpg', 'Condemned - Butcher', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/condemned_64_weapons005.jpg', 'Condemned - Ax', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/coolguy.gif', 'Persons - Cool guy', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/das2af.jpg', 'Anime - Unknown', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/deadpuppet.jpg', 'Dead puppet', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/deathgirl.jpg', 'Death Girl', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/default.gif', 'Persons - Peter', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/duke.gif', 'Persons - Duke', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/eitje.gif', 'Egg', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/elderlyman.gif', 'Persons - Pops', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/flux-02.gif', 'Radio-active', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/flux-03.gif', 'Toxic', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/george_thefinger.jpg', 'George W Bush', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/giel.jpg', 'Giel Beelen', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/goldberg.jpg', 'Golberg', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_DaveRcopy.jpg', 'Gun - Dave R', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_12.jpg', 'Gun - 12', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_15.jpg', 'Gun - 15', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_18.jpg', 'Gun - 18', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_19.jpg', 'Gun - 19', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_21.jpg', 'Gun - 21', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_22.jpg', 'Gun - 22', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_icon64_23.jpg', 'Gun - 23', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Jenny164.jpg', 'Gun - Jenny 1', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Lococopy.jpg', 'Gun - Loco', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Magruder64.jpg', 'Gun - Magruder', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Ned.jpg', 'Gun - Ned', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Ned2copy.jpg', 'Gun - Ned 2', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Reed2copy.jpg', 'Gun - Reed 2', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/gun_Reedcopy.jpg', 'Gun - Reed', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/icon_politie2.jpg', 'Logo - Politie', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/itguy.gif', 'Persons - IT Guy', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/jennifer.jpg', 'Jennifer Lopez', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Kameo_Chilla_64.jpg', 'Kameo - Chilla', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Kameo_Kalus_64.jpg', 'Kameo Kalus', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Kameo_majorRuin_64.jpg', 'Kameo - Ruin', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/Kameo_Troll1_64.jpg', 'Kameo - Troll', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/kameo_trollSymbol_64.jpg', 'Kameo - Troll symbol', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/male_prof.gif', 'Persons - Professor', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/mr_niceguy.jpg', 'Persons - Mr Niceguy', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/nerd.gif', 'Emofaces - Nerd', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/ninja.gif', 'Ninja', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/officeguy1.gif', 'Persons - John', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/officeguy6.gif', 'Persons - Fred', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/panicdog.jpg', 'Doggy Horror', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pdzpicturepack1001.jpg', 'PDZ - 01', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pdzpicturepack1002.jpg', 'PDZ - 02', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pdzpicturepack1003.jpg', 'PDZ - 03', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack1001.jpg', 'Penny Arcade - 01', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack1004.jpg', 'Penny Arcade - 02', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack1005.jpg', 'Penny Arcade - 03', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack1007.jpg', 'Penny Arcade - 04', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack2003.jpg', 'Penny Arcade - 05', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pennyarcadepicturepack2008.jpg', 'Penny Arcade - 06', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/pope.gif', 'Pope JP II', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/popje.gif', 'Persons - little guy', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar1.jpg', 'Quake4 - 01', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar2.jpg', 'Quake4 - 02', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar3.jpg', 'Quake4 - 03', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar4.jpg', 'Quake4 - 04', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar5.jpg', 'Quake4 - 05', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar6.jpg', 'Quake4 - 06', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/quake4_avatar7.jpg', 'Quake4 - 07', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/runkeenrun.jpg', 'Commander Keen', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/shit_elife.gif', 'Shite', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/smokinrabbit.gif', 'Smokin Rabbit', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/tech.gif', 'Emofaces - Techie', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/THAW_custom_tile_64_14.jpg', 'Tony Hawk - 01', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/THAW_custom_tile_64_3.jpg', 'Tony Hawk - 02', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/THAW_custom_tile_64_5.jpg', 'Tony Hawk - 03', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/urbanguy.gif', 'Persons - William', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/usflag.gif', 'Flag - USA', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/warnings.gif', 'Warning', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/wheelchair.gif', 'Weelchair', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/WiggleBenassi2.gif', 'Benassi - Wiggle', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x360_controller_green.gif', 'X360 - Controller 1', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_ball.jpg', 'X360 - Ball', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_controller.jpg', 'X360 - Controller 2', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_controller_green2.jpg', 'X360 - Controller 3', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_controller_hands.jpg', 'X360 - Controller 4', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_curves.jpg', 'X360 - Curves', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_orange.jpg', 'X360 - Orange', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_poster.jpg', 'X360 - Poster 1', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_poster2.jpg', 'X360 - Poster 2', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/x_360_power.gif', 'X360 - Powerbutton', 0, 1)
insert into FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED) VALUES('/avatars/2k6/zik.jpg', 'Zik', 0, 1)


I'm guessing that FORUM is your table prefix.
Edited by - laser on 01 February 2006 06:25:04
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 01 February 2006 :  06:31:56  Show Profile
Ah, Access .... "get external data" maybe ?
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 01 February 2006 :  07:23:02  Show Profile  Visit MarcelG's Homepage
laser ; so I simply use that one in a custom script ? Or in the alternative mod setup ?
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 01 February 2006 :  07:32:11  Show Profile  Visit MarcelG's Homepage
Mmm...I just tried it in the Alternative MOD Setup, but it doesn't seem to do anything.
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 February 2006 :  10:22:37  Show Profile  Send ruirib a Yahoo! Message
Marcel, that's SQL, so it needs a script, not the mod setup.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 01 February 2006 :  11:35:18  Show Profile  Visit MarcelG's Homepage
Oh, ok...
I feel a bit stupid now....
I'll try to whip up a script tonight that does this. Thanks
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts
Posted - 01 February 2006 :  12:04:07  Show Profile  Send ruirib a Yahoo! Message
Probably putting this into an array and looping would do the trick.

Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 01 February 2006 :  15:48:58  Show Profile
Sorry guys, I forget the syntax for an INSERT in Mod Setup.
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 01 February 2006 :  17:00:45  Show Profile  Visit AnonJr's Homepage
[INSERT]
TABLENAME
(FIELD1,FIELD2,...)#(valuefor1,valuefor2,....)
[END]
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 01 February 2006 :  20:37:05  Show Profile
So that would make it :


[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/africanamerican.gif', 'People - African American', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/asian-w-1.gif', 'People - Pink hair', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/av-12.gif', 'Logo - Green', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/avatar_getout.gif', 'Locked in', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/avatar_head_bang_5477_5829.gif', 'Banging head', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/av_apple_colored.gif', 'Apple - Apple1', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/av_ibook.jpg', 'Apple - iBook', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/baaaaaah.jpg', 'Sheep', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/baghead.gif', 'Emofaces - Bag', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/blindfold.gif', 'Emofaces - Blindfold', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/boer.gif', 'Stupid!', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/boobs.gif', 'Bouncing Boobs', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/borg.gif', 'Emofaces - Borg', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/canoworms.gif', 'Can'o'worms', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Caprice2.jpg', 'Jordan Caprice', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_alliesstar_logo_64.jpg', 'COD2 - Allied Star', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_dogtags_64.jpg', 'COD2 - Dogtags', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_flag_brit_64.jpg', 'COD2 - Brits', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_flag_russian_cod_64.jpg', 'COD2 - Russians', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_portrait_germanshoot64x64.jpg', 'COD2 - German', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_portrait_mike64.jpg', 'COD2 - Mike', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_portrait_Tanker64.jpg', 'COD2 - Tanker', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/cod2_soldier_64.jpg', 'COD2 - Soldier', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Cole164.jpg', 'Gun - Cole 1', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Cole364.jpg', 'Gun - Cole 2', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/computer.gif', 'Computer', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_Addcit.jpg', 'Condemned - Addcit', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_AgentThomas.jpg', 'Condemned - Ag. Thomas', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_Mannequin.jpg', 'Condemned - Mannequin', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_weapons001.jpg', 'Condemned - Pistol', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_weapons004.jpg', 'Condemned - Butcher', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/condemned_64_weapons005.jpg', 'Condemned - Ax', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/coolguy.gif', 'Persons - Cool guy', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/das2af.jpg', 'Anime - Unknown', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/deadpuppet.jpg', 'Dead puppet', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/deathgirl.jpg', 'Death Girl', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/default.gif', 'Persons - Peter', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/duke.gif', 'Persons - Duke', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/eitje.gif', 'Egg', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/elderlyman.gif', 'Persons - Pops', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/flux-02.gif', 'Radio-active', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/flux-03.gif', 'Toxic', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/george_thefinger.jpg', 'George W Bush', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/giel.jpg', 'Giel Beelen', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/goldberg.jpg', 'Golberg', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_DaveRcopy.jpg', 'Gun - Dave R', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_12.jpg', 'Gun - 12', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_15.jpg', 'Gun - 15', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_18.jpg', 'Gun - 18', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_19.jpg', 'Gun - 19', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_21.jpg', 'Gun - 21', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_22.jpg', 'Gun - 22', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_icon64_23.jpg', 'Gun - 23', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Jenny164.jpg', 'Gun - Jenny 1', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Lococopy.jpg', 'Gun - Loco', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Magruder64.jpg', 'Gun - Magruder', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Ned.jpg', 'Gun - Ned', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Ned2copy.jpg', 'Gun - Ned 2', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Reed2copy.jpg', 'Gun - Reed 2', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/gun_Reedcopy.jpg', 'Gun - Reed', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/icon_politie2.jpg', 'Logo - Politie', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/itguy.gif', 'Persons - IT Guy', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/jennifer.jpg', 'Jennifer Lopez', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Kameo_Chilla_64.jpg', 'Kameo - Chilla', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Kameo_Kalus_64.jpg', 'Kameo Kalus', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Kameo_majorRuin_64.jpg', 'Kameo - Ruin', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/Kameo_Troll1_64.jpg', 'Kameo - Troll', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/kameo_trollSymbol_64.jpg', 'Kameo - Troll symbol', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/male_prof.gif', 'Persons - Professor', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/mr_niceguy.jpg', 'Persons - Mr Niceguy', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/nerd.gif', 'Emofaces - Nerd', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/ninja.gif', 'Ninja', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/officeguy1.gif', 'Persons - John', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/officeguy6.gif', 'Persons - Fred', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/panicdog.jpg', 'Doggy Horror', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pdzpicturepack1001.jpg', 'PDZ - 01', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pdzpicturepack1002.jpg', 'PDZ - 02', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pdzpicturepack1003.jpg', 'PDZ - 03', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack1001.jpg', 'Penny Arcade - 01', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack1004.jpg', 'Penny Arcade - 02', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack1005.jpg', 'Penny Arcade - 03', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack1007.jpg', 'Penny Arcade - 04', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack2003.jpg', 'Penny Arcade - 05', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pennyarcadepicturepack2008.jpg', 'Penny Arcade - 06', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/pope.gif', 'Pope JP II', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/popje.gif', 'Persons - little guy', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar1.jpg', 'Quake4 - 01', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar2.jpg', 'Quake4 - 02', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar3.jpg', 'Quake4 - 03', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar4.jpg', 'Quake4 - 04', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar5.jpg', 'Quake4 - 05', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar6.jpg', 'Quake4 - 06', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/quake4_avatar7.jpg', 'Quake4 - 07', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/runkeenrun.jpg', 'Commander Keen', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/shit_elife.gif', 'Shite', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/smokinrabbit.gif', 'Smokin Rabbit', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/tech.gif', 'Emofaces - Techie', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/THAW_custom_tile_64_14.jpg', 'Tony Hawk - 01', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/THAW_custom_tile_64_3.jpg', 'Tony Hawk - 02', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/THAW_custom_tile_64_5.jpg', 'Tony Hawk - 03', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/urbanguy.gif', 'Persons - William', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/usflag.gif', 'Flag - USA', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/warnings.gif', 'Warning', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/wheelchair.gif', 'Weelchair', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/WiggleBenassi2.gif', 'Benassi - Wiggle', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x360_controller_green.gif', 'X360 - Controller 1', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_ball.jpg', 'X360 - Ball', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_controller.jpg', 'X360 - Controller 2', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_controller_green2.jpg', 'X360 - Controller 3', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_controller_hands.jpg', 'X360 - Controller 4', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_curves.jpg', 'X360 - Curves', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_orange.jpg', 'X360 - Orange', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_poster.jpg', 'X360 - Poster 1', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_poster2.jpg', 'X360 - Poster 2', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/x_360_power.gif', 'X360 - Powerbutton', 0, 1)[END]
[INSERT]FORUM_AVATAR (A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/zik.jpg', 'Zik', 0, 1)[END]
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts
Posted - 01 February 2006 :  22:50:51  Show Profile  Visit AnonJr's Homepage
As long as none of the names have a single-quote, I think so. I pulled that from the DBS help I'd seen floating around here (and saved locally so I wouldn't have to hunt for it each time I needed it).

Just out of curiosity, do you know if the forum parses the DBS script in a way that doesn't depend on the line-breaks? All the examples I've seen show something like:
[INSERT]
TABLENAME
(FIELD1,FIELD2,...)#(valuefor1,valuefor2,....)
[END]
as opposed to:
[INSERT]TABLENAME (FIELD1,FIELD2,...)#(valuefor1,valuefor2,....)[END]
And I was curious if that made a difference.
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 02 February 2006 :  02:55:21  Show Profile  Visit MarcelG's Homepage
Thanks guys!!! I'm going to try it right away!
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 02 February 2006 :  03:08:38  Show Profile  Visit MarcelG's Homepage
I've tried the oneliner, as well as the threeliners, but all refuse to add an avatar.
I know there exists a DBS file that adds the default smiles to the db, if you're using the Smile Manager.
I've dug that one up, and it looks like this:
Add Default Smiles
[INSERT]
Smiles
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_angry.gif', '', 'yes', 1, 'Angry', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_blackeye.gif', '', 'yes', 1, 'Black Eye', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_dead.gif', '', 'yes', 1, 'Dead', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_dead.gif', '', 'yes', 0, 'Dead', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_shock.gif', '', 'yes', 1, 'Shock', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_shock.gif', '', 'yes', 0, 'Shock', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_shock.gif', '', 'yes', 0, 'Shock', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_blush.gif', '', 'yes', 1, 'Blush', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_sad.gif', '', 'yes', 1, 'Sad', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_shy.gif', '', 'yes', 1, 'Shy', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile.gif', '', 'yes', 1, 'Smile', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_evil.gif', '', 'yes', 1, 'Evil', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_big.gif', '', 'yes', 1, 'Big Smile', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_cool.gif', '', 'yes', 1, 'Cool', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_sleepy.gif', '', 'yes', 1, 'Sleepy', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_clown.gif', '', 'yes', 1, 'Clown', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_clown.gif', '', 'yes', 0, 'Clown', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_clown.gif', '', 'yes', 0, 'Clown', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_tongue.gif', '', 'yes', 1, 'Tongue', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_tongue.gif', '', 'yes', 0, 'Tongue', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_wink.gif', '', 'yes', 1, 'Wink', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_8ball.gif', '', 'yes', 1, 'Eight Ball', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_question.gif', '', 'yes', 1, 'Question', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_approve.gif', '', 'yes', 1, 'Approve', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_disapprove.gif', '', 'yes', 1, 'Disapprove', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_disapprove.gif', '', 'yes', 0, 'Disapprove', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_kisses.gif', '', 'yes', 1, 'Kisses', 1, 1, 0)
(S_URL, S_CODE, S_ENABLED, S_VISIBLE, S_DESC, S_COLSPAN, S_DEFAULT, S_EXCLUDE)#('icon_smile_kisses.gif', '', 'yes', 0, 'Kisses', 1, 1, 0)
[END]

So, this is the format I need to use.

So I tried this one:
[INSERT]
AVATAR
(A_URL, A_NAME, A_MEMBER_ID, A_VALIDATED)#('/avatars/2k6/africanamerican.gif', 'People - African American', 0, 1)
[END]

And it worked perfectly!!
Thanks guys, the rest is not added in a jiffy!!!
portfolio - linkshrinker - oxle - twitter
Go to Top of Page

laser
Advanced Member

Australia
3859 Posts
Posted - 02 February 2006 :  03:17:34  Show Profile
Sorry, I didn't realise that the MOD Setup actually added the forum prefix .. shows how often I use it.
Go to Top of Page

MarcelG
Retired Support Moderator

Netherlands
2625 Posts
Posted - 02 February 2006 :  03:22:52  Show Profile  Visit MarcelG's Homepage
I've made an online 'mental note' of this info here http://oxle.com/topic.asp?tid=3591
Turns out you can only add 100 entries in one go, but next to that it worked perfectly!!!
portfolio - linkshrinker - oxle - twitter
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 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.46 seconds. Powered By: Snitz Forums 2000 Version 3.4.07