Support » Plugin: Support Tickets » [Plugin: Support Tickets] display the tickets on page

  • Resolved exactlimon

    (@exactlimon)


    hi all
    a few months ago I started using a support ticket using the plugin, I searched the forums if there was an option for show tickets at the contact page and saw that there was no taking the decision to set myself the code.

    The following code can be inserted into a wordpress theme that allows sidebar and widgets.

    Paste this code into the sidebar.php file in your theme folder.

    <li id="meta" class="widget-container">
    				<h3 class="widget-title"><?php _e( 'Tickets', 'twentyten' ); ?></h3>
    				<ul>
    
    					 <?php global $current_user;
                      get_currentuserinfo();
    			// tickets php code
    			// the name of variables can be changed
    			$cedu = $current_user->ID ;
    
    		       //db connect
                           //there is a function called $wpdb but it dont
                           // for me		       $db=mysqli_connect('localhost','username','passworp','name_of_databse');
    		if($db!=null)
    		{
    		$consulta="select * from wp_suptic_tickets where user_id = '$cedu' ";
    		$resultado=mysqli_query($db,$consulta);
    		$num_res=mysqli_num_rows($resultado);
    
    		if( $num_res == 0 ){
    			echo " ";
    
    		}
    		else{
    
    			for($i=0; $i<$num_res; $i++)
    			{
    			$fila=mysqli_fetch_assoc($resultado);
    
    			echo'<li> number of ticket: ';
    			echo' '.$fila['id'].'</li> ';
    			echo'<li> Subject: ';
    			echo'<a href="?page_id='.$fila['page_id'].'&ticket='.$fila['id'].'&accesskey='.$fila['access_key'].'">'.$fila['subject'].'</a></li>';
    
    			}
    
    			mysqli_close($db);
    		} //corchete de cierre del else
    		} //corchete de cierre del if 
    
    					  ?>
    
    				</ul>
    			</li>

    you can see that in this image: http://i.imgur.com/7DfNH.png

    note: sorry for my english, i used a translator because i am from colombia and my native language is spanish.

    note2: im working to integrate it in the profile wordpress panel.
    if u have question feel free to write

    note3: if u want to donate to me, my paypal is: exactlimon@hotmail.com

    thanks, Santiago

    http://wordpress.org/extend/plugins/support-tickets/

Viewing 3 replies - 1 through 3 (of 3 total)
  • sorry… in the code please delete this part:
    // for me

    because this is a comment line and next to this comment is the database connect.
    $db=mysqli_connect('localhost','username','passworp','name_of_databse');

    hi & thanks
    but
    this is not work for me in wordpress 3.2.1

    resolved last problem but
    dont work Subject Title) for persian language
    please See photo
    can you help me?
    thanks

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: Support Tickets] display the tickets on page’ is closed to new replies.