Display Promotion Codes on the main page without editing the template

[BuzzedOutHost.com]

Hello,

 

I was working on a way to make so when I add a new Promotion Code in the WHMCS Admin panel it instantly updates on the main page with all the codes.

 

The Script is written in PHP by me I hope you like it

 

 

<?php

mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

$result = mysql_query("SELECT * FROM tblpromotions") 
or die(mysql_error());  

echo "<table border='0' style='color: #FFF'>";
echo "<tr> <th>Promocode</th> <th>Discount</th> <th>Expiration</th> </tr>";

while($row = mysql_fetch_array( $result )) {


echo "<tr><td>"; 
echo $row['code'];
echo "</td><td>"; 
echo $row['value'];
echo $row['type'];
echo "</td><td>"; 
echo $row['expirationdate'];
echo "</td></tr>"; 
} 

echo "</table>";



?>

 

 

-John

[vePortal]

Why not make this a plugin for use the the templates, in the "homepage.tpl" file you could add a nicely styled section below the contents.

 

{php}

$result = mysql_query("SELECT * FROM tblpromotions")

or die(mysql_error());

 

echo "<table border='0' style='color: #FFF'>";

echo "<tr> <th>Promocode</th> <th>Discount</th> <th>Expiration</th> </tr>";

 

while($row = mysql_fetch_array( $result )) {

 

 

echo "<tr><td>";

echo $row['code'];

echo "</td><td>";

echo $row['value'];

echo $row['type'];

echo "</td><td>";

echo $row['expirationdate'];

echo "</td></tr>";

}

{/php}

 

It would make a nice plugin and would probably be used by many hosts!

[BuzzedOutHost.com]

i dont have expierience building scripts into a template system i can code them in php/mysql tough

 

-john

[Cubeboy]

quick tweak to VE PORTAL, just cut and paste where you want this to go inside your homepage.tpl:

 

 

<P><h3 align="center">Promotion Codes</h3></P>

{php}

$result = mysql_query("SELECT * FROM tblpromotions")

or die(mysql_error());

echo "<table width='100%' bgcolor='#cccccc' cellspacing='1'>";

echo "<tr bgcolor='#efefef'> <th bgcolor='#efefef'>Promocode</th> <th bgcolor='#efefef'>Discount</th> <th bgcolor='#efefef'>Type</th> <th bgcolor='#efefef'>Expiration</th> </tr>";

while($row = mysql_fetch_array( $result )) {

echo "<tr bgcolor='#ffffff'><td>";

echo $row['code'];

echo "</td><td>";

echo $row['value'];

echo "</td><td>";

echo $row['type'];

echo "</td><td>";

echo $row['expirationdate'];

echo "</td></tr>";

}

{/php}

Edited January 2, 2010 by Cubeboy

[cuevision]

WORKS FINE!!

 

Just what I was searching for!

 

Ed