You are not logged in. Please login or register.
PunBB Forums → Posts by lie2815
Another one:
$result = $db->query('SELECT full_name, desc, spec, color FROM '.$db->prefix.'alloys WHERE id='.$id) or error('Unable to fetch alloy information', __FILE__, __LINE__, $db->error());Error message:
Unable to fetch alloy information
Database reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, spec, color FROM inventory_alloys WHERE id=1' at line 1 (Errno: 1064)nice. ur getting there. u need to do the "where you are" links at the top and the bottom of the viewforum and the viewtopic (where it says index >> show off >> crystalx - nalan
EDIT: You're right. No table in viewtopic...
No, your table headers in forum.php, viewforum.php and viewtopic.php, they don't have a width yet. Do something like
<th style="width: 50%;">Forum</th>
<th style="width: 10%;">Topics</th>
<th style="width: 10%;">Posts</th>
<th style="width: 30%;">Last post</th>This example is obviously for forum.php...
EDIT: That would have those certain table cells have the same width every time...
And yes, you should also do width: 100% for the tables...
You need to assign widths to your table cells...
Sorry. Here it comes:
$result = $db->query('SELECT t.name, m.name AS metalname FROM '.$db->prefix.'metaltypes AS t INNER JOIN '.$db->prefix.'metals AS m ON m.id=t.metal_id WHERE t.id='.$id) or error('Unable to fetch metal type info', __FILE__, __LINE__, $db->error());
if ($db->num_rows($result))
{
while($name = $db->fetch_assoc($result))
{
$outputstring = "\t\t\t\t\t".'<li>'."\n\t\t\t\t\t\t".$name['metalname']." - ".$name['name'].'</li>'."\n\t\t\t\t\t"."\n";
}
}
else
message($lang_common['Bad request']);
?>
<div class="block">
<h2><span><?php echo $outputstring ?></span></h2>
<div class="box">
<div class="inbox">you actually did help...it works
GENIUS! 
Thanks a lot!
EDIT: except that you forgot two of these: }...but even I can figure that one out 
I think the while loop is not needed since the query should only return one result.
Anybody pleeeeeaaaasse?
forum design looks a little weird
It is no error, it just doesn't return anything from this:
<?php echo $name['metalname'], " - ", $name['name'] ?>What is wrong about this query?
$result = $db->query('SELECT t.name, m.name AS metalname FROM '.$db->prefix.'metaltypes AS t INNER JOIN '.$db->prefix.'metals AS m ON m.id=t.metal_id WHERE t.id='.$id) or error('Unable to fetch metal type info', __FILE__, __LINE__, $db->error());
if (!$db->result($result))
message($lang_common['Bad request']);
else
$name = $db->fetch_assoc($result);oh so you want a mix of both
i want the registration page smiler to the registration page of http://forums.digitalpoint.com
What do you mean?
Go to Admin->Options->the block "Registration"->select "yes" for "verify registrations"
or maybe not even localhost
PLEEEAAASSEEE post comments!!!
##
##
## Mod title: Deleted posts log
##
## Mod version: 2.0
## Works on PunBB: 1.2.* (as far as I know)
## Release date: 06-10-2007
## Author: Franz Liedke
##
## Description: Provides a plugin that displays a log of all deleted posts. These posts can be restored or deleted forever.
##
## Affects DB: Yes
##
## Affected files: viewtopic.php
## include\functions.php
## delete.php
## viewforum.php
## moderate.php
##
## Notes: Adds columns to the following database tables:
## topics
## posts
## subscriptions
## Adds one config entry
##
## Changelog: Version 1.0.1
## now includes an install_mod.php file
## Version 1.0.2
## full subscription support
## Version 1.1
## now working completely with topics that are deleted
## also fixes number of replies and topics in viewforum.php and index.php
## plugin is now also available for moderators
## Version 1.2
## more user-friendly / idiot-proof
## users aren't able to restore posts as long as the topic post is not restored / does not exist
## Version 2.0
## pagination in the log - only 10 deleted posts per page to keep the number of queries executed at 16 until I can optimize further
## latest post display - seems to work now
## parse bbcode/smilies in log option
## some code optimization - uses POST rather than GET
## now also works with the "delete thread" function from moderate.php
##
## To be fixed yet: Version 2.1
## query optimization
##
## Generated By: Auto Read-Me(by Caleb Champlin) - http://www.rscheatnet.com/Auto_Readme.zip
##
## DISCLAIMER: Please note that 'mods' are not officially supported by
## PunBB. Installation of this modification is done at your
## own risk. Backup your forum database and any and all
## applicable files before proceeding.
##As posted here...
How should I handle copyright for this thing?
without the tlhead.php please lol
the only database stuff that you should keep would be config and users.
yeah mainly just an empty web application without all the forum stuff and maybe one simple page where you can just login (just as starting point).
yeah lets chat later on don't have time today though.
What do you mean by db schematics?
Oh just something I am working on for a friend's website.
I am thinking about writing a new php application and I want to use PunBB's core for that. Is anybody bored enough to delete everything unnecessary from the PunBB files and just leaving the main functions and variables for database, template and users?
what do you mean? like a news mod?
PunBB Forums → Posts by lie2815
Powered by PunBB, supported by Informer Technologies, Inc.