airoid3000 — Sat, 10 Apr 2004 15:54:04 +0000

Fixed! There was a small typo in the code you gave me.
This:
$makerandomid = rand(10000,99999));
Should have been this:
$makerandomid = rand(10000,99999);
Thanks for your help!!!

Mark Hensler — Sat, 10 Apr 2004 14:19:45 +0000

try:
while (true)

airoid3000 — Fri, 09 Apr 2004 16:43:35 +0000

Those changes are correct, but I still get a parse error. I think that maybe I'm putting the code in the wrong place or something. Here is what it looks like now:

<?php
if(isset($create)){

    //if the system is public, set some cookies so user information will be recorded for next time
    setcookie(\"cookie_user_name\", $username, time()+31536000);
    setcookie(\"cookie_email\", $email, time()+31536000);
    setcookie(\"cookie_office\", $office, time()+31536000);
    setcookie(\"cookie_phone\", $phone, time()+31536000);

    $time = time() + ($time_offset*3600);
    
    
while(1) 
{ 
$makerandomid = rand(10000,99999)); 

$q = mysql_query(\"SELECT id FROM $mysql_tickets_table WHERE id = $makerandomid\");

if(mysql_num_rows($q) < 1) 
{ 
break; 
} 
} 




    
    if($group == '' || $priority == '' || $username == '' || $description == ''){
        header(\"Location: index.php?t=terr\");
    }
    else{
        if($short == ''){
            $short = \"$lang_nodesc\";
        }
        if($sg == ''){
            $sg = 1;
        }




        $status = getStatus(getLowestRank($mysql_tstatus_table));
        
        $short = addslashes(stripScripts($short));
        $description = addslashes(stripScripts($description));



        $sql = \"INSERT into $mysql_tickets_table values('$makerandomid', '$time', $sg, 'Division', 1, '$priority', '$status',
                '$username', '$email', '$office', '$phone', '$category', '$platform', '$short', '$description', NULL, 0, '$time', ''
)\";
?>

Mark Hensler — Fri, 09 Apr 2004 16:20:18 +0000

I'm assuming the primary key of the table is "id"... so replace with:

$q = mysql_query("SELECT id FROM $mysql_tickets_table WHERE id = $makerandomid");

airoid3000 — Fri, 09 Apr 2004 05:37:02 +0000

Below is an entire section from the script that creates the ticket and its ID. I received an error that says: Parse error: parse error in /hidden/support/tcreate.php on line 68. Line 68 is where the while(1) statement is. (Notice I changed $id to $makerandomid to stop confusing with other $id's in the file.

REMOVED

Mark Hensler — Fri, 09 Apr 2004 03:00:43 +0000

values('$id', '$time'

If you still get an error, copy & paste your entire code segment here (with info about the error your getting).

airoid3000 — Fri, 09 Apr 2004 00:10:34 +0000

I get a parse error. Anything wrong with that code you gave me?

Mark Hensler — Thu, 08 Apr 2004 23:30:26 +0000

swap out NULL for '$id'

airoid3000 — Thu, 08 Apr 2004 23:20:19 +0000

I believe this is where the ID is created:

$sql = "INSERT into $mysql_tickets_table values(~~NULL~~, '$time', $sg, '$division', 1, '$priority', '$status','$username', '$email', '$office', '$phone', '$category', '$platform', '$short', '$description', NULL, 0, '$time', ''

Where the NULL is above (the first one) is where I think it is. Like I said the database automatically increments the ID now.

How can i place the random ID Code there?

airoid3000 — Thu, 08 Apr 2004 22:45:26 +0000

I'm having trouble finding where to put that code. Right now I believe the php sends a null command to mysql and mysql automatically increments the number.

Anyone have an idea or possible look of where it would go?