Write to Table Field

Nuke Cadet Joined: Jul 07, 2003 Posts: 9

Sup.

I'd like to add an extra input field in my admin downloads which would write to specific table field. There for i created another table field in .$prefix."_downloads_downloads and added extra input named "stream" in admin/modules/downloads.php

I added this new field in function DownloadsAddDownload and modified case "DownloadsAddDownload".

But now iam not able to add anything after creating this new table field.
Am I missing something?
Tnx in advance.

Support Mod Joined: Jun 11, 2003 Posts: 245

Paste the modified code here im sure that there is just a ' missing somewhere Very Happy

Nuke Cadet Joined: Jul 07, 2003 Posts: 9

k, tnx for a fast response

Here is my form echo:

Code:

.""._STREAM.": <input type=\"text\" name=\"stream\" size=\"50\" maxlength=\"100\"> "

Here is modification i made in function DownloadsAddDownload:

Code:

function DownloadsAddDownload($new, $lid, $title, $url, $cat, $description, $stream, $name, $email, $submitter, $filesize, $version, $homepage, $hits) {
global $prefix, $dbi;
$result = sql_query("select url from ".$prefix."_downloads_downloads where url='$url'", $dbi);
$numrows = sql_num_rows($result, $dbi);
if ($numrows>0) {
include("header.php");

And the case:

Code:

case "DownloadsAddDownload":
DownloadsAddDownload($new, $lid, $title, $url, $cat, $description, $stream, $name, $email, $submitter, $filesize, $version, $homepage, $hits);
break;

"stream" is the table field name.
So, what could be missing here? Question

Support Mod Joined: Jun 11, 2003 Posts: 245

I only see the " sql_query("select ...."
if you want to add a value must I see the insert code

like sql_query("instert into .....

Nuke Cadet Joined: Jul 07, 2003 Posts: 9

oh, i totally overlooked that Embarassed

inserted the value into INSERT query and its working!!!

And how could i check it?

i mean if i have several extra fields (5 or 6) should i write each script for each field to check?

Like :

Code:

/* Check if URL exist */
if ($url=="") {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center>"._WEBDOWNLOADSADMIN."</center>";
CloseTable();
echo " ";
OpenTable();
echo " <center>"
 .""
 .""._ERRORNOURL." "
 .""._GOBACK." ";
CloseTable();
include("footer.php");
}

or can i do it with several if statements under each other?

Support Mod Joined: Jun 11, 2003 Posts: 245

Quote:

or can i do it with several if statements under each other?

Yes if you want every field to be "required" before a download can be added.

ie:

[php:1:e62c2b44b9]
/* Check if URL exist */
if ($url=="") {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center>"._WEBDOWNLOADSADMIN."</center>";
CloseTable();
echo " ";
OpenTable();
echo " <center>"
.""
.""._ERRORNOURL." "
.""._GOBACK." ";
CloseTable();
include("footer.php");
}

/* Check if stream exist */
if ($stream=="") {
include("header.php");
GraphicAdmin();
OpenTable();
echo "<center>"._WEBDOWNLOADSADMIN."</center>";
CloseTable();
echo " ";
OpenTable();
echo " <center>"
.""
.""._ERRORNOURL." "
.""._GOBACK." ";
CloseTable();
include("footer.php");
}

[/php:1:e62c2b44b9]

The code above

[php:1:e62c2b44b9]
"._ERRORNOURL."
[/php:1:e62c2b44b9]
Must be replased whit ie:

[php:1:e62c2b44b9]
"._ERRORNOSTREAM."
[/php:1:e62c2b44b9]

And then in the language file located in your /admin/language/ dir add a row like

[php:1:e62c2b44b9]
define("_ERRORNOSTREAM","ERROR: You need to type a STREAM!");
[/php:1:e62c2b44b9]

and so on for each if() statement you are adding...

Nuke Cadet Joined: Jul 07, 2003 Posts: 9

this way wouldnt work, ive tried it, "stream" value wont be checked.

Its logical, because

Code:

if ($url=="") {

will only check if input form is not null (not empty).

Its somewhere else.

/* Check if URL exist */ doesnt make sence in this case!

Support Mod Joined: Jun 11, 2003 Posts: 245

I will check in the file hows it's build and then ill be back... Very Happy

But im at work atm so later on today my time....