The Old Database
Moderators: SCUMBAG, INKoRP, Clan Leader
The Old Database
Ok. Just so everyone knows.
Without dicking around and beating around the bush for ages. Here is what i can import without troubles.
User accounts
Categories
Forums
Topics
Posts
smileys
In terms of teh usernames, dont worry you can keep your current one...
At the moment this means, none of the old polls, none of the attachments, none of the pictures.
Now since the old database is static, its easier to change it to suit the new tables (ie duplicate primary keys).
No offence to baldrick or the guys at YaBBse , In my opinion the old database is shit (especially for size).
Status: Completed required table conversion (afaik) , testing on test forum to make sure it is compatable with teh current database. If it works, will convert user_ids of old members to the new accounts (so your old posts become your posts).
Without dicking around and beating around the bush for ages. Here is what i can import without troubles.
User accounts
Categories
Forums
Topics
Posts
smileys
In terms of teh usernames, dont worry you can keep your current one...
At the moment this means, none of the old polls, none of the attachments, none of the pictures.
Now since the old database is static, its easier to change it to suit the new tables (ie duplicate primary keys).
No offence to baldrick or the guys at YaBBse , In my opinion the old database is shit (especially for size).
Status: Completed required table conversion (afaik) , testing on test forum to make sure it is compatable with teh current database. If it works, will convert user_ids of old members to the new accounts (so your old posts become your posts).
The distance between insanity and genius is measured only by success
Just to keep everyone informed. My query properly handles the usernames, categories and forums. A few small issues with topics (missing some topics, pretty sure i know why).
So where is the old db at?
Categories - done
Forums - done
Topics - some minor issues being sorted
Usernames - Done and the ppl who have new accounts here, posts have been re-asigned to you.
Smileys .. wont take anything, but i'll do that another time.
So where is the old db at?
Categories - done
Forums - done
Topics - some minor issues being sorted
Usernames - Done and the ppl who have new accounts here, posts have been re-asigned to you.
Smileys .. wont take anything, but i'll do that another time.
The distance between insanity and genius is measured only by success
ah lol. I really should start studying. The import may take a little longer as i wont be spending as much time on it. Majority of the work is done, except I am stuck solving an issue with some of the topics (which i think i know how to fix). ow.. and the bbcode .
I need to start studying for my Maths exams (differential equations and probability). I dont care about computer science which is on saterday , and physics next friday.
I know i made it sound like it would be done pretty soon. Which mind you as long as my solution solves this topic issue it will be
Study during the day, hack databases at night....
From about 7pm ESDT till late (like 2am) I will be doing the database so i will be garunteed to be at my machine if anyone wants to chat while my machine is lagged by sql queries
So to sum that up, hang tight it will be here at some point ^_^ .
I need to start studying for my Maths exams (differential equations and probability). I dont care about computer science which is on saterday , and physics next friday.
I know i made it sound like it would be done pretty soon. Which mind you as long as my solution solves this topic issue it will be
Study during the day, hack databases at night....
From about 7pm ESDT till late (like 2am) I will be doing the database so i will be garunteed to be at my machine if anyone wants to chat while my machine is lagged by sql queries
So to sum that up, hang tight it will be here at some point ^_^ .
The distance between insanity and genius is measured only by success
lol i am Its just this database has become the biggest procrastination tool ever ^_^
lol im not saying "aw sorry guys (and gals) i cant do this , irl needs me" ... its "stfu and wait, it'll be done and ready when i feel like it"
ow and btw, i think i also just fixed the bbcode issues .
lol im not saying "aw sorry guys (and gals) i cant do this , irl needs me" ... its "stfu and wait, it'll be done and ready when i feel like it"
ow and btw, i think i also just fixed the bbcode issues .
Last edited by Kamikazee on Thu Nov 02, 2006 7:43 pm, edited 1 time in total.
The distance between insanity and genius is measured only by success
Return to “Forum Issues and 'Requests'”
Who is online
Users browsing this forum: No registered users and 21 guests