(03:54:42 AM) xmldude485 entered the room.
(03:54:42 AM) timn1991 entered the room.
(03:54:46 AM) timn1991: hello
(03:54:49 AM) xmldude485: hello
(03:54:52 AM) xxsashixx@gmail.com entered the room.
(03:55:03 AM) xmldude485: explain
(03:55:29 AM) xxsashixx@gmail.com: tim, tell us how to tag files lol
(03:55:40 AM) timn1991: yes
(03:55:46 AM) timn1991: ok
(03:55:53 AM) timn1991: i would create a mysql table
(03:56:04 AM) xxsashixx@gmail.com: what about using ini?
(03:56:18 AM) timn1991: ini's are lame
(03:56:34 AM) timn1991: if you don't have a mysql db, you could use a sqlite db
(03:56:40 AM) timn1991: sqlite is filebased
(03:57:01 AM) xxsashixx@gmail.com: no i can use mysql db
(03:57:11 AM) xxsashixx@gmail.com: just that me and xml wanted to use ini
(03:57:23 AM) timn1991: okay
(03:57:34 AM) timn1991: that's difficult
(03:57:52 AM) timn1991: ah I know
(03:57:52 AM) xxsashixx@gmail.com: but do you have any idea how to start it?
(03:58:05 AM) timn1991: here's a sample:
(03:59:05 AM) timn1991: [General]
tags=tag1|tag2|tag3
[a.txt]
tags=0|2
[b.txt]
tags=1|2
(03:59:12 AM) timn1991: that's a good method
(03:59:14 AM) xxsashixx@gmail.com: no we got that part..
(03:59:23 AM) xxsashixx@gmail.com: xml.. what do we have to do?
(04:00:01 AM) timn1991: I thought you wanted to do it with INIs?
(04:00:06 AM) xmldude485: we do
(04:00:09 AM) xxsashixx@gmail.com: we got that far
(04:00:18 AM) xxsashixx@gmail.com: "(6:35:24 PM) xmldude485: first we need to make the actual tag pages. without them, tags are useless."
(04:00:19 AM) xxsashixx@gmail.com: :P
(04:00:26 AM) xmldude485: lol
(04:00:50 AM) xmldude485: we need some way to display al the filenames of the software that's tagged with that tag
(04:01:07 AM) timn1991: okay
(04:01:21 AM) timn1991: why don't you use a db
(04:01:32 AM) xxsashixx@gmail.com: cuz that would make the inis obsolete
(04:01:38 AM) timn1991: using xml or ini's for such things is not a good dicision
(04:01:49 AM) timn1991: you can use a sqlite db
(04:02:03 AM) xmldude485: Ok.
(04:02:11 AM) xmldude485: So how would we do that?
(04:02:22 AM) timn1991: do you use php4 or php5?
(04:02:26 AM) xxsashixx@gmail.com: 5
(04:02:32 AM) timn1991: good
(04:03:39 AM) xmldude485: i g2g
(04:03:47 AM) xmldude485: you 2 discuss it
(04:03:51 AM) xxsashixx@gmail.com: k
(04:03:53 AM) xmldude485: and tell me how tomorrow
(04:03:53 AM) timn1991: what's g2g?
(04:03:55 AM) xmldude485: me
(04:04:01 AM) xmldude485: lol
(04:04:05 AM) xxsashixx@gmail.com: :P
(04:04:06 AM) timn1991: sorry
(04:04:09 AM) xmldude485: np
(04:04:11 AM) xmldude485: cya
(04:04:13 AM) timn1991: cya
(04:04:18 AM) xmldude485 left the room.
(04:04:19 AM) xxsashixx@gmail.com: ok so..
(04:04:23 AM) xxsashixx@gmail.com: how would you do this>
(04:04:28 AM) timn1991: :)
(04:04:31 AM) timn1991: first create the database
(04:04:31 AM) timn1991: sqlite_open('database.db');
(04:04:36 AM) xxsashixx@gmail.com: no
(04:04:39 AM) timn1991: sqlite_open returns the link
(04:04:40 AM) xxsashixx@gmail.com: using mysql
(04:04:43 AM) timn1991: mysql?!
(04:04:54 AM) xxsashixx@gmail.com: cant do it?
(04:04:58 AM) timn1991: sure
(04:05:22 AM) xxsashixx@gmail.com: so..
(04:05:24 AM) xxsashixx@gmail.com: create a db
(04:05:49 AM) timn1991: but first you wanted to do it in INIs. then in xml. i proposed to do it in sqlite and now you want to do it in mysql?!
(04:05:59 AM) timn1991: how do you want to do it?
(04:05:59 AM) xxsashixx@gmail.com: whats wrong with mysql
(04:06:04 AM) timn1991: nothing
(04:06:07 AM) xxsashixx@gmail.com: well.. i want to do it in inis
(04:06:08 AM) timn1991: mysql is a good decision
(04:06:14 AM) xxsashixx@gmail.com: but you said that its bad idea
(04:06:24 AM) timn1991: yes it is
(04:06:37 AM) xxsashixx@gmail.com: then ill do it in mysql..
(04:07:06 AM) timn1991: okay
(04:07:12 AM) xxsashixx@gmail.com: so how?
(04:07:22 AM) timn1991: do you have phpymadmin isntalled?
(04:07:24 AM) timn1991: *installed
(04:07:27 AM) xxsashixx@gmail.com: yea
(04:07:31 AM) timn1991: good
(04:07:34 AM) timn1991: create a database
(04:07:34 AM) xxsashixx@gmail.com: i got a db ready
(04:07:40 AM) timn1991: nice
(04:08:16 AM) timn1991: so you want to tag single files which exist on your hdd?
(04:08:28 AM) xxsashixx@gmail.com: no its for a site
(04:08:31 AM) xxsashixx@gmail.com: but yea
(04:08:33 AM) xxsashixx@gmail.com: same concept
(04:08:55 AM) timn1991: ok
(04:09:02 AM) timn1991: create a table named "files"
(04:09:14 AM) xxsashixx@gmail.com: how many fields
(04:09:18 AM) timn1991: 2
(04:09:25 AM) xxsashixx@gmail.com: k
(04:09:32 AM) xxsashixx@gmail.com: field names?
(04:09:42 AM) timn1991: id int(8) auto_increment index
text varchar(255)
(04:10:59 AM) xxsashixx@gmail.com: done
(04:11:04 AM) timn1991: okay
(04:11:18 AM) timn1991: create another table named "tags"
(04:11:35 AM) xxsashixx@gmail.com: fields?
(04:11:36 AM) timn1991: id int(8) auto_increment index
text varchar(255)
(04:11:49 AM) timn1991: then insert some dummy tags
(04:12:03 AM) xxsashixx@gmail.com: in where?
(04:12:04 AM) xxsashixx@gmail.com: tags?
(04:12:20 AM) timn1991: in the table tags
(04:12:35 AM) xxsashixx@gmail.com: wait..
(04:13:05 AM) timn1991: ok
(04:13:08 AM) xxsashixx@gmail.com: wtf?
(04:13:17 AM) xxsashixx@gmail.com: #1063 - Incorrect column specifier for column 'id'
(04:13:52 AM) xxsashixx@gmail.com: o ooops
(04:14:03 AM) timn1991: hm?
(04:14:12 AM) timn1991: ah g2g = got to go
(04:14:15 AM) xxsashixx@gmail.com: lol
(04:14:18 AM) timn1991: :)
(04:14:29 AM) xxsashixx@gmail.com: ok so in the table tags
(04:14:34 AM) xxsashixx@gmail.com: create dummy tags
(04:14:35 AM) xxsashixx@gmail.com: now what
(04:15:05 AM) timn1991: create another table named "associations"
(04:15:25 AM) xxsashixx@gmail.com: fields?
(04:15:28 AM) timn1991: wait
(04:15:43 AM) timn1991: id int(8) auto_increment index
fileid int(8)
tagid int(8)
(04:16:27 AM) xxsashixx@gmail.com: k done
(04:17:30 AM) timn1991: ok
(04:17:37 AM) timn1991: the db structure is done
(04:17:50 AM) xxsashixx@gmail.com: k
(04:17:59 AM) timn1991: now you can write the script
(04:18:05 AM) xxsashixx@gmail.com: how?
(04:19:05 AM) timn1991: you need to insert the filestructure
(04:19:13 AM) xxsashixx@gmail.com: ?
(04:19:46 AM) timn1991: yes the structure of the directories has to be inserted in table "files"
(04:20:00 AM) xxsashixx@gmail.com: i dont get what your saying..
(04:20:06 AM) timn1991: sorry
(04:20:25 AM) timn1991: ok you need to insert the filenames in the table "files" (into the db)
(04:20:37 AM) timn1991: sorry, I am not concentrated
(04:20:43 AM) xxsashixx@gmail.com: using php right?
(04:20:45 AM) timn1991: it's 4 AM here in Germany
(04:20:48 AM) timn1991: yes
(04:20:54 AM) timn1991: 4.20 am
(04:21:01 AM) xxsashixx@gmail.com: gimme a sec
(04:21:07 AM) timn1991: ok done?
(04:24:28 AM) xxsashixx@gmail.com: ok
(04:24:35 AM) xxsashixx@gmail.com: i added a file name
(04:24:59 AM) timn1991: add another one
(04:25:07 AM) xxsashixx@gmail.com: ?
(04:25:43 AM) timn1991: insert dummy data. the filename can be a imaginary string. the "filename" does not have to exist
(04:25:48 AM) timn1991: *need to exist
(04:26:20 AM) xxsashixx@gmail.com: wel..
(04:26:27 AM) xxsashixx@gmail.com: i have a record in files
(04:26:32 AM) xxsashixx@gmail.com: id 1 text = testing
(04:26:47 AM) timn1991: okay
(04:27:18 AM) xxsashixx@gmail.com: what now?
(04:28:21 AM) timn1991: how many records do files have
(04:28:28 AM) xxsashixx@gmail.com: 2
(04:29:30 AM) timn1991: good
(04:31:12 AM) xxsashixx@gmail.com: now what?
(04:32:14 AM) timn1991: now create the associations
(04:32:42 AM) xxsashixx@gmail.com: ??
(04:34:17 AM) timn1991: you created the table "associations". it consists of id|fileid|tagid
(04:34:23 AM) timn1991: insert a new item
(04:34:34 AM) timn1991: with fileid = 0 and tagid = 0
(04:35:25 AM) xxsashixx@gmail.com: i still think inis are easier to do
(04:35:51 AM) timn1991: probably. but ini's are unprofessional
(04:36:01 AM) timn1991: all php pro's are using mysql databases
(04:36:12 AM) timn1991: ini's are too lame for such purposes
(04:36:47 AM) xxsashixx@gmail.com: well to be honest... you're slow @ responding lol
(04:37:37 AM) timn1991: yes that's because i'm chatting with two other people :)
(04:37:56 AM) timn1991: and i have to think in english. i'm not concentrated as i have already said
(04:38:00 AM) timn1991: it's too late
(04:38:06 AM) timn1991: 4.38 am!
(04:39:21 AM) timn1991: well to be honest.... you're slow @ responding :)
(04:40:03 AM) xxsashixx@gmail.com: lol
(04:47:46 AM) timn1991: are you there?
(04:47:59 AM) timn1991: i'm tired
(04:48:06 AM) timn1991: i will have to go now
(04:48:28 AM) timn1991: tomorrow we can proceed if you'd like to
(05:05:57 AM) timn1991: HELLOO?!!
(05:29:09 AM) timn1991: good night