« previous next »
Pages: 1 2 3 [4] 5 6 ... 9  All   Go Down

Author Topic: ospap - Alpha1  (Read 27617 times)

0 Members and 2 Guests are viewing this topic.

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #45 on: September 20, 2005, 09:46:25 am »
Question: What about for the tables and the album page?  In a template, how would you indicate a list? 

Again, I could figure this out myself, but there is probably a "right"er way of doing it :)

<edit> Also, do you think each user should be able to choose a different template for his pages?  Or an individual template for each category, maybe?

<edit2> To answer my first question, I've decided to go with a .php template system, like SMF does.  Hopefully that'll work out ok, it seems like the better way for what I need to do :)

<edit3> Warning: once I get this template stuff set up, I'm probably going to wipe the database again, so don't bother uploading anything complicated :)
« Last Edit: September 20, 2005, 10:11:37 am by iago »
Logged

Offline Newby

  • x86
  • Hero Member
  • *****
  • Posts: 10877
  • Thrash!
    • View Profile
Re: ospap - Alpha1
« Reply #46 on: September 20, 2005, 05:24:30 pm »
I liked OPM (opium) more, but eh, ospap for the win! ;p
Logged
- Newby
http://www.x86labs.org

Quote
[17:32:45] * xar sets mode: -oooooooooo algorithm ban chris cipher newby stdio TehUser tnarongi|away vursed warz
[17:32:54] * xar sets mode: +o newby
[17:32:58] <xar> new rule
[17:33:02] <xar> me and newby rule all

Quote from: Rule on June 30, 2008, 01:13:20 pm
Quote from: CrAz3D on June 30, 2008, 10:38:22 am
I'd bet that you're currently bloated like a water ballon on a hot summer's day.

That analogy doesn't even make sense.  Why would a water balloon be especially bloated on a hot summer's day? For your sake, I hope there wasn't too much logic testing on your LSAT. 

Offline Sidoh

  • x86
  • Hero Member
  • *****
  • Posts: 17634
  • MHNATY ~~~~~
    • View Profile
    • sidoh
Re: ospap - Alpha1
« Reply #47 on: September 20, 2005, 05:51:20 pm »
Why do you wipe the DB anyway, iago?  =p
Logged

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #48 on: September 20, 2005, 08:25:24 pm »
Because I want to make sure my create_tables.sql file works, and because dropping the tables is easier than modifying them :)
Logged

Offline rabbit

  • x86
  • Hero Member
  • *****
  • Posts: 8092
  • I speak for the entire clan (except Joe)
    • View Profile
Re: ospap - Alpha1
« Reply #49 on: September 20, 2005, 09:30:08 pm »
ALPHA 1 IS NO LONGER!!!!
Logged

Offline Sidoh

  • x86
  • Hero Member
  • *****
  • Posts: 17634
  • MHNATY ~~~~~
    • View Profile
    • sidoh
Re: ospap - Alpha1
« Reply #50 on: September 20, 2005, 11:14:35 pm »
Quote from: iago on September 20, 2005, 08:25:24 pm
Because I want to make sure my create_tables.sql file works, and because dropping the tables is easier than modifying them :)
Is create_talbes.sql a sort of installation file?
Logged

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #51 on: September 21, 2005, 08:30:14 am »
Quote from: Sidoh on September 20, 2005, 11:14:35 pm
Quote from: iago on September 20, 2005, 08:25:24 pm
Because I want to make sure my create_tables.sql file works, and because dropping the tables is easier than modifying them :)
Is create_talbes.sql a sort of installation file?
Yes. 

mysql -u root -p -D ospap < create_tables.sql
Logged

Offline Sidoh

  • x86
  • Hero Member
  • *****
  • Posts: 17634
  • MHNATY ~~~~~
    • View Profile
    • sidoh
Re: ospap - Alpha1
« Reply #52 on: September 21, 2005, 09:10:54 am »
Quote from: iago on September 21, 2005, 08:30:14 am
Yes. 

mysql -u root -p -D ospap < create_tables.sql
Just put them in a different database! :)
Logged

Offline Mythix

  • The Dude
  • x86
  • Hero Member
  • *****
  • Posts: 1569
  • Victory
    • View Profile
    • Dark-Wire
Re: ospap - Alpha1
« Reply #53 on: September 21, 2005, 11:57:42 am »
I suggest on your next major release, you dub the version "Opium". I'll even make you a catchy slogan for it!
Logged
Philosophy, n. A route of many roads leading from nowhere to nothing.

- Ambrose Bierce

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #54 on: September 21, 2005, 02:36:05 pm »
Quote from: Sidoh on September 21, 2005, 09:10:54 am
Quote from: iago on September 21, 2005, 08:30:14 am
Yes. 

mysql -u root -p -D ospap < create_tables.sql
Just put them in a different database! :)
What difference would that make? Once I change how the database is being used, the original database is completely useless.  It doesn't contain the proper columns!
Logged

Offline Joe

  • B&
  • x86
  • Hero Member
  • *****
  • Posts: 10319
  • In Soviet Russia, text read you!
    • View Profile
    • Github
Re: ospap - Alpha1
« Reply #55 on: September 21, 2005, 04:49:06 pm »
You should make a column for the database version, and have a routine in the code to upgrade the database.
Logged
Quote from: Camel on June 09, 2009, 04:12:23 pm
I'd personally do as Joe suggests

Quote from: AntiVirus on October 19, 2010, 02:36:52 pm
You might be right about that, Joe.

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #56 on: September 21, 2005, 04:57:12 pm »
Two problems there
1. I don't plan on changing the database, which isn't a big deal; but
2. I don't want to give my mysql user that much power over the database.  He has select/insert/update/delete, and that's all I'm comfortable with.  I don't even want create/drop. 
Logged

Offline Sidoh

  • x86
  • Hero Member
  • *****
  • Posts: 17634
  • MHNATY ~~~~~
    • View Profile
    • sidoh
Re: ospap - Alpha1
« Reply #57 on: September 21, 2005, 05:21:45 pm »
Or make new code in a different area, and assign it to another database containing the other tables.  It's your project though, so there's no use in me arguing lol.
Logged

Offline iago

  • Leader
  • Administrator
  • Hero Member
  • *****
  • Posts: 17914
  • Fnord.
    • View Profile
    • SkullSecurity
Re: ospap - Alpha1
« Reply #58 on: September 22, 2005, 02:05:04 am »
Quote from: Sidoh on September 21, 2005, 05:21:45 pm
Or make new code in a different area, and assign it to another database containing the other tables.  It's your project though, so there's no use in me arguing lol.

Well, arguing is good, because it helps me learn! I've never used PHP before this, and I've never used MySQL from a user perspective either. 

I don't really understand what you're saying.  What do you mean by "different area"? 
Logged

Offline Sidoh

  • x86
  • Hero Member
  • *****
  • Posts: 17634
  • MHNATY ~~~~~
    • View Profile
    • sidoh
Re: ospap - Alpha1
« Reply #59 on: September 22, 2005, 09:15:56 am »
Make a copy of the files, then have it get its information from a different database (a near copy of the one that your users are using).  Then you can apply the changes when you're sure it works.  :)

Also -- if you run your queries correctly, you can add and drop columns with little problems.
Logged
Pages: 1 2 3 [4] 5 6 ... 9  All   Go Up
« previous next »