How to reset "page_id=xx" on Custom Pages?
Asked Modified Viewed 2,298 times
asked
Little stupid question, but is it possible to reset the 'page_id=' number when making Custom Pages? Tried to make Custom pages "few" times and looks like the counter is going on and on, even deleting the page.
Not a big deal, but little bit annoying ;)
Not a big deal, but little bit annoying ;)
answered
The database increments the counter with each new page. It would be possible to disable this, but it is easier and faster to do it this way.
Unless you create more than 65535 pages, you won't run out of ids, too.
Unless you create more than 65535 pages, you won't run out of ids, too.
answered
eh, sorry, what way ... ?
answered
You can use the code below in a custom page. Make sure that the auto_increment value you specify is higher than the ones you already have and use.
Good luck!
Code Download source
<?php
$result = dbquery("ALTER TABLE ".$db_prefix."custom_pages AUTO_INCREMENT=[color=red]12[/color]");
if ($result) echo "AUTO_INCREMENT decremented successfully. :P<br/>";
else echo "Well... Something's not right. :/<br/>";
?>Good luck!
Edited by kneekoo on 18-07-2007 15:35,
answered
thanks ;)
Category Forum
Official Core Support - 6Labels
None yet
Statistics
- Views 0 views
- Posts 4 posts
- Votes 0 votes
- Topic users 3 members
0 participants
Notifications
Track thread
You are not receiving notifications from this thread.
Related Questions