Mysidia Adoptables Support Forum
Page 4 of 8 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Addons/Mods Graveyard (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=41)
-   -   Adopts News (http://www.mysidiaadoptables.com/forum/showthread.php?t=881)

Bloodrun 05-28-2009 02:11 PM
RE: Adopts News
 
Quote:
Originally Posted by mapleblade
now its still bugged :( (but its better then earlier)
That is strange =/

Quote:
Originally Posted by Saphira
Quote:
Originally Posted by Bloodrun
Quote:
Originally Posted by Saphira
Hmm, is there any way to make the system recognise new paragraphs? I've tried html and bbcode, and they both fail. Everything shows up in one continuous paragraph.
Did you try <br>?

If that doesn't work, Ill just convert the thing to BBcode.
I tried <br>, and <p>, and neither work. It turns

These

Are

Separate, into

These are separate, etc.
Alright, then ill have to make BBcode work for it.

Saphira 05-30-2009 03:10 PM
RE: Adopts News
 
Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:
    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 
The line of code to insert it, and below, the database layout:

Quote:
nid int(11)
topic varchar(255)
detail longtext
name varchar(65)
datetime varchar(25)
Does this all seem right to you?

Bloodrun 05-30-2009 08:31 PM
RE: Adopts News
 
Quote:
Originally Posted by Saphira
Hmm. I haven't tried this out since I changed the database field for detail to LONGTEXT. I'm trying to post news now, and I'm getting an error on add_news.php. I'm guessing that there's an error inserting it into the database.

PHP Code:
    $query = "INSERT INTO ".$prefix."news(topic, detail, name, nid, datetime) VALUES('".$topic."', '".$detail."', '".$name."', '".$Max_idd."', '".$datetime."')"; 
The line of code to insert it, and below, the database layout:

Quote:
nid int(11)
topic varchar(255)
detail longtext
name varchar(65)
datetime varchar(25)
Does this all seem right to you?
Can you tell me the error please.

And find the '$result' nearest to the line where it says the error is, and place this right after it:

die('Invalid query: ' . mysql_error());

Saphira 05-31-2009 04:36 AM
RE: Adopts News
 
Quote:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm testing this using single quotes.', 'Jon', '31/05/09 02:32:12')' at line 1
I tried to post:

Quote:
I'm testing this using single quotes.
Someone else posted last night after I went to bed, and they managed to post fine, so I'm guessing it has something to do with single quotes. (')

Bloodrun 05-31-2009 04:46 AM
RE: Adopts News
 
Quote:
Originally Posted by Saphira
Quote:
Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'm testing this using single quotes.', 'Jon', '31/05/09 02:32:12')' at line 1
I tried to post:

Quote:
I'm testing this using single quotes.
Someone else posted last night after I went to bed, and they managed to post fine, so I'm guessing it has something to do with single quotes. (')
That's really wierd because it works fine on my test site, and some one else site.

I believe I put stripspalshes in the code, make sure i stripsplashed the name of the poster, the title and the details.

Saphira 05-31-2009 06:07 AM
RE: Adopts News
 
What part of the code are the stripslash parts in? I can double check just to make sure that they're there etc.

Bloodrun 05-31-2009 03:36 PM
RE: Adopts News
 
Quote:
Originally Posted by Saphira
What part of the code are the stripslash parts in? I can double check just to make sure that they're there etc.
They would be right after a query and the items it is calling.

It would look like this:

$something = stripsplash($something)

Saphira 05-31-2009 09:56 PM
RE: Adopts News
 
Okay, I've looked through the files, and the only file I can find the stripslashes in is news.php. Wouldn't it need to be in add_news.php, being's that's the file that adds news to the database (which the script is having trouble doing?) I downloaded a fresh copy of the zip file, and it's the same in there. Only on news.php

Bloodrun 05-31-2009 10:05 PM
RE: Adopts News
 
Quote:
Originally Posted by Saphira
Okay, I've looked through the files, and the only file I can find the stripslashes in is news.php. Wouldn't it need to be in add_news.php, being's that's the file that adds news to the database (which the script is having trouble doing?) I downloaded a fresh copy of the zip file, and it's the same in there. Only on news.php
Oh, well I usually only put the stripsplash in the file that is calling the info, but I should probably do start doing it the other way.

Anyway, um, what was your problem again? Lol I cant remember.

EDIT:

This is really wierd, because the sites I installed this on, don't have that error at all, and they have tons of single quotes in their posts o.0

Saphira 06-01-2009 08:18 AM
RE: Adopts News
 
Yeah it is weird. I just tried uploading a fresh add_news.php, to see if it would change anything, and nada. Still nothing. The problem was posting articles with single quotes in lol.


All times are GMT -5. The time now is 09:50 AM.
Page 4 of 8 « First 23 4 56 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.