Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[souiassassin]

hey guys iam jsut learning coding so here is my first mod from scratch there is no recoding or anything build from ground up hope u like it

Replace helptutorial.php
with this

Code: [Select]

<?php
include "globals.php";


$q=mysql_query("SELECT * FROM helppage WHERE pageid=1", $c);
while($r=mysql_fetch_array($q))
{
print "<h3><center>{$r['pagetitle']}</h3>
<hr />
<br /><br />
{$r['helptext']}
</center>";
}
?>
make new page call it
helppage.php

Code: [Select]

<?php
include "sglobals.php";

if($ir['user_level'] > 2)
{
die("403");
}
if ($_POST['submit'])
{
$db->query("UPDATE helppage SET pagetitle='{$_POST['pagetitle']}', helptext='{$_POST['helptext']}' WHERE pageid='1'");

print "Helppage Updated<br /><br />
<a href='helppage.php'>Go Back</a>";
}
else
{
$q=mysql_query("SELECT * FROM helppage WHERE pageid=1", $c);
while($r=mysql_fetch_array($q))
{
print "<h3>Help Edit</h3><hr />
<form action='helppage.php' method='post'>
<input type='hidden' name='submit' value='helppage' />
Header: <input type='text' name='pagetitle' value='{$r['pagetitle']}' /><br />
Help Text:<br />
<textarea rows='7' cols='50' name='helptext'>{$r['helptext']}</textarea><br />
<input type='submit' value='Update' /></form>";
print "<center><font color=red><h3>HTML Allowed</h3></font></center>";
}
}
?>

Your Sql
not really good with them but i will give it a try

Code: [Select]

CREATE TABLE IF NOT EXISTS `helppage` (
  `pageid` int(11) NOT NULL auto_increment,
  `pagetitle` varchar(255) NOT NULL default '',
  `pagetext` text NOT NULL default'',
  PRIMARY KEY  (`pageid`)
);

add to SQL

Code: [Select]

INSERT INTO helppage VALUES('1','Game Tutorial','enter here');
add your like to smenu

Code: [Select]

<a href='helppage.php'>Edit Page Tutorial</a>
and your done. hope u like it

[Cyanide]

Very nice. I hate doing the tutorial for a game, so ill def use this and make one of my peons do it for me!

[strats]

Tried this out get this message when I try to update the tutorial

QUERY ERROR: Unknown column 'helptext' in 'field list'
Query was UPDATE helppage SET pagetitle='Game Tutorial', helptext='test' WHERE pageid='1'

[souiassassin]

strats that earror means u havn't got the sql in ur database

[strats]

Hmmm I put it in, Silly thing
I'll try again

[DeaTH_RideR]

strats that error means u haven't got the sql in ur database

That's because (helptext) is not in the sql that you supplied.

[Cyanide]

hey guys iam jsut learning coding so here is my first mod from scratch there is no recoding or anything build from ground up hope u like it

Replace helptutorial.php
with this

Code: [Select]

<?php
include "globals.php";


$q=mysql_query("SELECT * FROM helppage WHERE pageid=1", $c);
while($r=mysql_fetch_array($q))
{
print "<h3><center>{$r['pagetitle']}</h3>
<hr />
<br /><br />
{$r['pagetext']}
</center>";
}
?>
make new page call it
helppage.php

Code: [Select]

<?php
include "sglobals.php";

if($ir['user_level'] > 2)
{
die("403");
}
if ($_POST['submit'])
{
$db->query("UPDATE helppage SET pagetitle='{$_POST['pagetitle']}', pagetext='{$_POST['helptext']}' WHERE pageid='1'");

print "Helppage Updated<br /><br />
<a href='helppage.php'>Go Back</a>";
}
else
{
$q=mysql_query("SELECT * FROM helppage WHERE pageid=1", $c);
while($r=mysql_fetch_array($q))
{
print "<h3>Help Edit</h3><hr />
<form action='helppage.php' method='post'>
<input type='hidden' name='submit' value='helppage' />
Header: <input type='text' name='pagetitle' value='{$r['pagetitle']}' /><br />
Help Text:<br />
<textarea rows='7' cols='50' name='helptext'>{$r['pagetext']}</textarea><br />
<input type='submit' value='Update' /></form>";
print "<center><font color=red><h3>HTML Allowed</h3></font></center>";
}
}
?>

Your Sql
not really good with them but i will give it a try

Code: [Select]

CREATE TABLE IF NOT EXISTS `helppage` (
  `pageid` int(11) NOT NULL auto_increment,
  `pagetitle` varchar(255) NOT NULL default '',
  `pagetext` text NOT NULL default'',
  PRIMARY KEY  (`pageid`)
);

add to SQL

Code: [Select]

INSERT INTO helppage VALUES('1','Game Tutorial','enter here');
add your like to smenu

Code: [Select]

<a href='helppage.php'>Edit Page Tutorial</a>
and your done. hope u like it

I fixed the pages in my quote....great mod

[souiassassin]

Thanks m8 never even seen what i done until now

[Ganjafreak]

I added this modification and I go to helptutorial.php ad I can see my globals but I don't see the title or anything I've entereded.

[dominion]

did you use the one in Cyanide's quote?

[Zeddicus]

Yeah, I wouldn't suggest using this, If I have some free time later, I'll secure this code.

*Use this code at your own risk.*

[Djkanna]

Allowing Html isn't a good idea really nonetheless well done

[Ganjafreak]

Yes, I used the one in his qoute.

[DJShad]

im going to try it out to see what it does