You are not logged in. Please login or register.
Active topics Unanswered topics
Search options
StevenBullen wrote:Smartys wrote:And I've seen mods that aren't compatible with MySQL (case in point: PM mod doesn't work with newer versions of MySQL most likely due to strict mode) 
I can vouch for this... 
I read that the later versions of mySQL applied the ANSI standard more closely.
(Slightly OT, I have been trying to get a sql query to run on a copy of IPB 1.3 I have lying around. Seems that with LEFT JOIN the two tables preceding the join statement have to be bracketed because of the way mySQL 5 has been changed. If anyone wants to PM me I can talk further, but I don't want to derail the thread.)
That's the editor I was going to recommend. It has customisable syntax files, which reminds me to look for the sql ones again.
I used textpad almost exclusively for coding outside of VB6 which I also used when I worked in IT.
Ok, thanks, I hadn't realized that I needed to select in both, I'll do that now.,
Just a note while I think of it... the interface (I picked Lithium) really is clean and fast to load. I like the design a lot.
This sounds cool, I am going to check it out shortly. But one question... you mention that you have separate tables per forum, so I guess when someone does a new install so to speak the tables have a unique prefix so as to distinguish them from other forum's tables?
Update:
When I choose a different css style sheet from the drop down list in Options, this does not update the appearance of my forum. That is to say that changing the default style does not work. This may be due to the fact the forum is running off a shared install. Maybe creating a table that tells each board what css sheet to use would help. I am a newbie at this so I am not sure if this is possible.
I would imagine that the style sheet choice is stored in a table, but whether each forum uses the same style table of a different one I don't know. You can look at my forum on the server here.
I downloaded the database backup and restore plugin and uploaded it using wsftp7 to the plugins folder. I was online in my bb at the time and after refreshing the acp page, the plug in appeared. The backup process worked, I havent tested the restore function yet and I need to look at the table schema in the downloaded sql script to test out the sql query functionality. I am a former database developer. My main experience is with sql server 6.5 and 2000 however, and I know mySQL is a lot different 
Thanks.
Posts found: 5