News:

Who uses forums anymore?

Main Menu

ospap - Alpha1

Started by iago, September 14, 2005, 06:46:00 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

iago

#45
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 :)

Newby

I liked OPM (opium) more, but eh, ospap for the win! ;p
- 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. 

Sidoh

Why do you wipe the DB anyway, iago?  =p

iago

Because I want to make sure my create_tables.sql file works, and because dropping the tables is easier than modifying them :)

rabbit


Sidoh

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?

iago

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

Sidoh

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! :)

Mythix

I suggest on your next major release, you dub the version "Opium". I'll even make you a catchy slogan for it!
Philosophy, n. A route of many roads leading from nowhere to nothing.

- Ambrose Bierce


iago

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!

Joe

You should make a column for the database version, and have a routine in the code to upgrade the database.
Quote from: Camel on June 09, 2009, 04:12:23 PMI'd personally do as Joe suggests

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


iago

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. 

Sidoh

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.

iago

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"? 

Sidoh

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.