creat 2 categorie Help
hello
create sql format
PHP Code:
CREATE TABLE `format` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`cat_desc` varchar(30) NOT NULL default '',
`minclassread` tinyint(3) unsigned NOT NULL,
`vip` enum('yes','no') NOT NULL default 'no',
`type` varchar(1) NOT NULL default 'c',
`pid` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `type` (`type`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;
create admin/format.php
PHP Code:
<?
/***********************************************/
/*=========[TS Special Edition v.5.6]==========*/
/*=============[Special Thanks To]=============*/
/* DrNet - wWw.SpecialCoders.CoM */
/* Vinson - wWw.Decode4u.CoM */
/* MrDecoder - wWw.Fearless-Releases.CoM */
/* Fynnon - wWw.BvList.CoM */
/***********************************************/
function update_format_cache ()
{
global $cache;
$query = sql_query ('SELECT * FROM format WHERE type = \'c\' ORDER by name,id');
while ($_c = mysql_fetch_assoc ($query))
{
$_ccache[] = $_c;
}
$query = sql_query ('SELECT * FROM format WHERE type = \'s\' ORDER by name,id');
while ($_c = mysql_fetch_assoc ($query))
{
$_ccache2[] = $_c;
}
$content = var_export ($_ccache, true);
$content2 = var_export ($_ccache2, true);
$_filename = TSDIR . '/' . $cache . '/format.php';
$_cachefile = @fopen ('' . $_filename, 'w');
$_cachecontents = '<?php
/** TS Generated Cache#7 - Do Not Alter
* Cache Name: Categories
* Generated: ' . gmdate ('r') . '
*/
';
$_cachecontents .= '' . '$_categoriesC = ' . $content . ';
';
$_cachecontents .= '' . '$_categoriesS = ' . $content2 . ';
?>';
@fwrite ($_cachefile, $_cachecontents);
@fclose ($_cachefile);
}
function getimages ($select = '')
{
global $rootpath;
global $pic_base_url;
global $table_cat;
global $BASEURL;
$dir = TSDIR . '/' . $pic_base_url . $table_cat . '/';
$imgdir_ = $BASEURL . '/' . $pic_base_url . $table_cat . '/';
$ext = array ('gif', 'jpg', 'png', 'bmp');
$str = '
<select name=\'image\' OnChange=\'javascript:document.forms[0].showimage.src="' . $imgdir_ . '"+this.value+""\'>';
if ($handle = opendir ($dir))
{
while (false !== $file = readdir ($handle))
{
if ((($file != '.' AND $file != '..') AND in_array (strtolower (get_extension ($file)), $ext)))
{
$str .= '
<option value="' . $file . '"' . ($file == $select ? ' SELECTED' : '') . '>' . $file . '</option>';
continue;
}
}
$str .= '
</select>';
closedir ($handle);
return $str;
}
}
function get_category_list ($cid = 0, $selectname = 'cid')
{
$categories = '<select name="' . $selectname . '">
<option value="0">--select category--</option>';
($query = sql_query ('SELECT id, name FROM format WHERE type = \'c\'') OR sqlerr (__FILE__, 82));
while ($cat = mysql_fetch_assoc ($query))
{
$categories .= '<option value="' . intval ($cat['id']) . '"' . ($cid == $cat['id'] ? ' selected="selected"' : '') . '>' . htmlspecialchars_uni ($cat['name']) . '</option>';
}
$categories .= '</select>';
return $categories;
}
function show__errors ()
{
global $_errors;
global $lang;
if (0 < count ($_errors))
{
$errors = implode ('<br />', $_errors);
echo '
<table class="main" border="1" cellspacing="0" cellpadding="5" width="100%">
<tr>
<td class="thead">
' . $lang->global['error'] . '
</td>
</tr>
<tr>
<td>
<font color="red">
<strong>
' . $errors . '
</strong>
</font>
</td>
</tr>
</table>
<br />
';
}
}
if (!defined ('STAFF_PANEL_TSSEv56'))
{
exit ('<font face=\'verdana\' size=\'2\' color=\'darkred\'><b>Error!</b> Direct initialization of this file is not allowed.</font>');
}
define ('C_VERSION', '1.0 by xam');
$do = (isset ($_POST['do']) ? htmlspecialchars ($_POST['do']) : (isset ($_GET['do']) ? htmlspecialchars ($_GET['do']) : ''));
$what = (isset ($_POST['what']) ? htmlspecialchars ($_POST['what']) : (isset ($_GET['what']) ? htmlspecialchars ($_GET['what']) : ''));
$id = (isset ($_POST['id']) ? intval ($_POST['id']) : (isset ($_GET['id']) ? intval ($_GET['id']) : ''));
$cid = (isset ($_POST['cid']) ? intval ($_POST['cid']) : (isset ($_GET['cid']) ? intval ($_GET['cid']) : ''));
$_errors = array ();
if ($do == 'new')
{
if ($what == 'save')
{
$name = htmlspecialchars_uni ($_POST['name']);
$image = htmlspecialchars_uni ($_POST['image']);
$cat_desc = htmlspecialchars_uni ($_POST['cat_desc']);
$vip = ($_POST['vip'] == 'yes' ? 'yes' : 'no');
$type = (0 < $cid ? 's' : 'c');
if ((empty ($name) OR empty ($image)))
{
$_errors[] = 'Dont leave any fields blank!';
}
else
{
(sql_query ('INSERT INTO format (name,image,cat_desc,vip,type,pid) VALUES (' . sqlesc ($name) . ',' . sqlesc ($image) . ',' . sqlesc ($cat_desc) . ',' . sqlesc ($vip) . ',' . sqlesc ($type) . ',' . sqlesc ($cid) . ')') OR sqlerr (__FILE__, 135));
update_format_cache ();
redirect ('admin/index.php?act=format', 'New Category has been added!');
exit ();
}
}
stdhead ('Manage Tracker Categories - Add Category');
$where = array ('Cancel' => $_this_script_2);
show__errors ();
echo jumpbutton ($where);
_form_header_open_ ('Add Category', 5);
echo '
<form method="post" action="' . $_SERVER['SCRIPT_NAME'] . '">
<input type="hidden" name="act" value="category">
<input type="hidden" name="do" value="new">
<input type="hidden" name="what" value="save">';
echo '
<tr>
<td align="right" class="trow1" width="30%">Category Name</td>
<td align="left"><input type="text" name="name" value="' . $name . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Category Description</td>
<td align="left"><input type="text" name="cat_desc" value="' . $cat_desc . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Sub-Category</td>
<td align="left">' . get_category_list ($cid) . '</td>
</tr>
<tr>
<td align="right" class="trow1" width="30%">Category Image</td>
<td align="left">' . getimages ($image) . ' <img src="" id="showimage"></td>
</tr>
<tr>
<td align="right" class="trow1" width="10%">Is Vip Category?</td>
<td align="left"><select name="vip"><option value="no"' . ($vip == 'no' ? ' SELECTED' : '') . '>no</option><option value="yes"' . ($vip == 'yes' ? ' SELECTED' : '') . '>yes</option></select></td>
</tr>
<tr>
<td align="center" class="trow1" colspan="2"><input type="submit" value="Save"> <input type="reset" value="Reset Fields"></td>
</tr>
</form>';
_form_header_close_ ();
stdfoot ();
exit ();
}
else
{
if ($do == 'delete')
{
if ($what == 'sure')
{
sql_query ('DELETE FROM format WHERE id = ' . sqlesc ($id) . ' LIMIT 1');
update_format_cache ();
redirect ('admin/index.php?act=format', 'Category has been deleted!');
}
else
{
stderr ('Sanity Check', 'Are you sure you want to delete this category? <a href="' . $_this_script_2 . '&do=delete&id=' . $id . '&what=sure">YES</a> / <a href="' . $_this_script_2 . '">NO</a>', false);
}
}
else
{
if ($do == 'edit')
{
if ($what == 'save')
{
$name = htmlspecialchars_uni ($_POST['name']);
$image = htmlspecialchars_uni ($_POST['image']);
$cat_desc = htmlspecialchars_uni ($_POST['cat_desc']);
$vip = ($_POST['vip'] == 'yes' ? 'yes' : 'no');
$type = (0 < $cid ? 's' : 'c');
if ((empty ($name) OR empty ($image)))
{
$_errors[] = 'Dont leave any fields blank!';
}
else
{
sql_query ('' . 'UPDATE format SET type = \'' . $type . '\', pid = \'' . $cid . '\', name = ' . sqlesc ($name) . ', image = ' . sqlesc ($image) . ', cat_desc = ' . sqlesc ($cat_desc) . ', vip = ' . sqlesc ($vip) . ' WHERE id = ' . sqlesc ($id));
update_format_cache ();
redirect ('admin/index.php?act=format', 'Category has been updated!');
exit ();
}
}
$query = sql_query ('SELECT * FROM format WHERE id = ' . sqlesc ($id));
if (mysql_num_rows ($query) == 0)
{
stderr ('Error', 'There is no category with this ID!');
}
$categoryname = mysql_result ($query, 0, 'name');
$name = (!empty ($name) ? $name : $categoryname);
$image = (!empty ($image) ? $image : mysql_result ($query, 0, 'image'));
$cat_desc = (!empty ($cat_desc) ? $cat_desc : mysql_result ($query, 0, 'cat_desc'));
$vip = (!empty ($vip) ? $vip : mysql_result ($query, 0, 'vip'));
$type = mysql_result ($query, 0, 'type');
$pid = mysql_result ($query, 0, 'pid');
stdhead ('Manage Tracker Categories - Edit');
$where = array ('Cancel' => $_this_script_2);
show__errors ();
echo jumpbutton ($where);
_form_header_open_ ('Edit Category "' . $categoryname . '"', 5);
echo '
<form method="post" action="' . $_SERVER['SCRIPT_NAME'] . '">
<input type="hidden" name="act" value="category">
<input type="hidden" name="do" value="edit">
<input type="hidden" name="what" value="save">
<input type="hidden" name="id" value="' . $id . '">';
echo '
<tr>
<td align="right" class="trow1" width="30%">Category Name</td>
<td align="left"><input type="text" name="name" value="' . $name . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Category Description</td>
<td align="left"><input type="text" name="cat_desc" value="' . $cat_desc . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Sub-Category</td>
<td align="left">' . get_category_list (($type == 'c' ? 0 : $pid), 'cid') . '</td>
</tr>
<tr>
<td align="right" class="trow1" width="30%">Category Image</td>
<td align="left">' . getimages ($image) . ' <img src="" id="showimage"></td>
</tr>
<tr>
<td align="right" class="trow1" width="10%">Is Vip Category?</td>
<td align="left"><select name="vip"><option value="no"' . ($vip == 'no' ? ' SELECTED' : '') . '>no</option><option value="yes"' . ($vip == 'yes' ? ' SELECTED' : '') . '>yes</option></select></td>
</tr>
<tr>
<td align="center" class="trow1" colspan="2"><input type="submit" value="Save"> <input type="reset" value="Reset Fields"></td>
</tr>
</form>';
_form_header_close_ ();
stdfoot ();
exit ();
}
else
{
if ($do == 'add_subcategory')
{
if (($what == 'save' AND is_valid_id ($cid)))
{
$name = htmlspecialchars_uni ($_POST['name']);
$image = htmlspecialchars_uni ($_POST['image']);
$cat_desc = htmlspecialchars_uni ($_POST['cat_desc']);
$vip = ($_POST['vip'] == 'yes' ? 'yes' : 'no');
$type = 's';
if ((empty ($name) OR empty ($image)))
{
$_errors[] = 'Dont leave any fields blank!';
}
else
{
(sql_query ('INSERT INTO format (name,image,cat_desc,vip,type,pid) VALUES (' . sqlesc ($name) . ',' . sqlesc ($image) . ',' . sqlesc ($cat_desc) . ',' . sqlesc ($vip) . ',' . sqlesc ($type) . ',' . sqlesc ($cid) . ')') OR sqlerr (__FILE__, 292));
update_format_cache ();
redirect ('admin/index.php?act=format', 'New Sub-Category has been added!');
exit ();
}
}
$query = sql_query ('SELECT name FROM format WHERE type = \'c\' AND id = ' . sqlesc ($cid));
if (mysql_num_rows ($query) == 0)
{
stderr ('Error', 'There is no category with this ID!');
}
$categoryname = mysql_result ($query, 0, name);
stdhead ('Manage Tracker Categories - Add Sub-Category');
$where = array ('Cancel' => $_this_script_2);
show__errors ();
echo jumpbutton ($where);
_form_header_open_ ('Add Sub-Category to "' . $categoryname . '"', 5);
echo '
<form method="post" action="' . $_SERVER['SCRIPT_NAME'] . '">
<input type="hidden" name="act" value="category">
<input type="hidden" name="do" value="add_subcategory">
<input type="hidden" name="what" value="save">';
echo '
<tr>
<td align="right" class="trow1" width="30%">Category Name</td>
<td align="left"><input type="text" name="name" value="' . $name . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Category Description</td>
<td align="left"><input type="text" name="cat_desc" value="' . $cat_desc . '" size="50"></td>
</tr>
<tr>
<td align="right" class="trow1" width="20%">Sub-Category</td>
<td align="left">' . get_category_list ((!empty ($_POST['cid']) ? intval ($_POST['cid']) : $cid)) . '</td>
</tr>
<tr>
<td align="right" class="trow1" width="30%">Category Image</td>
<td align="left">' . getimages ($image) . ' <img src="" id="showimage"></td>
</tr>
<tr>
<td align="right" class="trow1" width="10%">Is Vip Category?</td>
<td align="left"><select name="vip"><option value="no"' . ($vip == 'no' ? ' SELECTED' : '') . '>no</option><option value="yes"' . ($vip == 'yes' ? ' SELECTED' : '') . '>yes</option></select></td>
</tr>
<tr>
<td align="center" class="trow1" colspan="2"><input type="submit" value="Save"> <input type="reset" value="Reset Fields"></td>
</tr>
</form>';
_form_header_close_ ();
stdfoot ();
exit ();
}
}
}
}
stdhead ('Manage Tracker Categories');
$where = array ('Create New Category' => $_this_script_2 . '&do=new');
echo jumpbutton ($where);
_form_header_open_ ('Manage Tracker Categories', 6);
echo '
<tr>
<td align="center" class="subheader" width="3%">ID</td>
<td align="center" class="subheader" width="50%">Name</td>
<td align="center" class="subheader" width="7%">Image</td>
<td align="left" class="subheader" width="25%">Description</td>
<td align="center" class="subheader" width="5%">Is Vip Category?</td>
<td align="center" class="subheader" width="10%">Action</td>
</tr>';
$query = sql_query ('SELECT * FROM format WHERE type = \'s\'');
$subcategories = array ();
while ($subcat = mysql_fetch_assoc ($query))
{
if (0 < $subcat['pid'])
{
$subcategories[$subcat['pid']] = $subcategories[$subcat['pid']] . '<tr><td align="center">' . $subcat['name'] . ' <a href="' . $BASEURL . '/browse.php?cat=' . $subcat['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'viewnfo.gif" title="View Sub-Category" alt="View Sub-Category" border="0" class="inlineimg" width="10" height="10"></a> <a href="' . $_this_script_2 . '&do=edit&id=' . $subcat['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'edit.gif" title="Edit Sub-Category" alt="Edit Sub-Category" border="0" class="inlineimg" width="10" height="10"></a> <a href="' . $_this_script_2 . '&do=delete&id=' . $subcat['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'delete.gif" title="Delete Sub-Category" alt="Delete Sub-Category" border="0" class="inlineimg" width="10" height="10"></a></td></tr>';
continue;
}
}
$query = sql_query ('SELECT * FROM format WHERE type=\'c\'');
if (mysql_num_rows ($query) == 0)
{
echo '<tr><td colspan="6">There is no registered category yet.</td></tr>';
}
else
{
while ($category = mysql_fetch_assoc ($query))
{
echo '
<tr>
<td align="center">' . $category['id'] . '</td>
<td align="center">
<table width="100%"><tr><td class="tborder" align="center">Main Category</td></tr><tr><td align="center">
<b>' . $category['name'] . '</b> <a href="' . $_this_script_2 . '&do=add_subcategory&cid=' . $category['id'] . '">[add subcategory]</a></td></tr><table width="100%"><tr><td class="subheader" align="center">Sub-categories</td></tr>' . ($subcategories[$category['id']] ? $subcategories[$category['id']] : '<tr><td align="center">There is no sub-category!</td></tr>') . '</table></td>
<td align="center"><img src="' . $BASEURL . '/' . $pic_base_url . $table_cat . '/' . $category['image'] . '" border="0" alt="' . $category['name'] . '" title="' . $category['name'] . '"></td>
<td align="left">' . $category['cat_desc'] . '</td>
<td align="center"><font color="' . ($category['vip'] == 'yes' ? 'green' : 'red') . '">' . $category['vip'] . '</font></td>
<td align="center"><a href="' . $BASEURL . '/browse.php?cat=' . $category['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'viewnfo.gif" title="View Category" alt="View Category" border="0"></a> <a href="' . $_this_script_2 . '&do=edit&id=' . $category['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'edit.gif" title="Edit Category" alt="Edit Category" border="0"></a> <a href="' . $_this_script_2 . '&do=delete&id=' . $category['id'] . '"><img src="' . $BASEURL . '/' . $pic_base_url . 'delete.gif" title="Delete Category" alt="Delete Category" border="0"></a></td>
</tr>';
}
}
_form_header_close_ ();
echo '<p>' . jumpbutton ($where) . '</p>';
stdfoot ();
?>
in admin/index.php
find
PHP Code:
$_this_script_ = htmlspecialchars ($_SERVER['SCRIPT_NAME']) . '?act=' . $act;
add
PHP Code:
$_this_script_2 = htmlspecialchars ($_SERVER['SCRIPT_NAME']) . '?act=format';
ok but problem my new category is upload in table 'categories' and not in table 'format' ????? Help me please.
|
7th March 2010, 03:45
