Re: World of Mendala SMF FORUM HELP

Ah I see, no worries, just think of me as a guinea pig.  At least I found the problem and you could fix it so that's a good thing 🙂

I accidently gave everyone about $77 when I was adding test chapters haha.  If it's simple to reverse it then yes let me know how and I will try it, otherwise everyone will just be getting a slight bonus incentive lol.

I guess whoever did it, was thinking about it from an smf POV maybe not knowing how efiction works perhaps?

Anyway, I will go test it out again and see what it looks like now.

uh, I just remembered what I don't like about the bridging, logging in on efiction, being taken to the forum, and then having to go back again.  Extra steps and a little confusing for members.  I guess that's where your forum header thingy comes in, or do you still get that problem?

Sorry but I still don't think the shop thing is right.  I just checked again with the new member and last night I changed their shop $$$ back to $15 like it should be, and now he has $95.  He has posted 5 times now and he should have $35, so he has $60 too much.

I just posted again myself and it seems to be giving people too much money now on the forum for posting!  I posted once and should have increased by $5 but instead it gave me $19.  I will have to take it off again as I have no idea how much $$$ people have accumulated since last night lol.

edit:
I took the shop code out of stories.php but it is still giving me $20 a post instead of $5 on the forum, so it seems to be overriding what is set in the shop admin in the forum.

does it have something to do with the 'globals' settings? 

post your newchapter function and let me see what you did, because it's working fine for me now, now that I got rid of the $ID_MEMBER (becasue that variable doesn't get populated) so let me see what you have and I can tell you if I see something wrong.

Sorry, I didn't answer your complete question...

Because of the way my forum header works and all, it's really not a problem. the efiction part of my script is "contained" within my entire "community" site, which includes the forum, the gallery, the chatrooms, the story archive, etc. So to the users it's all one big site. So even though whereever you login you get taken back to "the forums" to the user it makes sense anyway. You're more prone to logon from the forums because it's the first thing you see.

You should join my site if you haven't already so you can actually see how things work.

Also, if you have access to mysql to run a query you just need run an update query on the smf_members table. It should say

Update smf_member set money = money - 77

This assumes 77 is the amount of money you want to subtract from everyone. Keep in mind though this will be global so if you already reversed some people manually it may cause an error for them (you may want to add 77 back to those people before going to the database).

Also NOTHING you do in stories.php should be affecting how much money you get in the shop for posting in the forums. Unless you really set something wrong. But even if you did, if you took the shop code out of the stories.php you should be able to go to the Shop Admin and set you $ amount correct again.

Sorry I've been out all afternoon...

here is the new story function:

// function to add new story to archives.
function newstory( ) {

global $autovalidate, $sid, $action, $sid, $store, $tpl, $storiespath, $admin, $sitename, $siteemail, $allowed_tags, $level, $admincats, $alertson, $dateformat, $url, $tableprefix, $minwords, $maxwords, $useruid, $userpenname, $charlist, $catlist, $classtypelist, $db_prefix, $user_info, $adminloggedin, $ID_MEMBER;

$newchapter = $action == "newchapter";
$output = "<div id="pagetitle">".($newchapter ? _ADDNEWCHAPTER : _ADDNEWSTORY)."</div>";
// to avoid problems with register globals and hackers declare variables and do some clean up.
if(isset($admin) && isset($_POST['uid']) && isNumber($_POST['uid'])) {
$uid = $_POST['uid'];
$author = dbquery("SELECT "._PENNAMEFIELD." FROM "._AUTHORTABLE." WHERE "._UIDFIELD." = '$uid' LIMIT 1");
list($penname) = dbrow($author);
}
else {
$uid = $useruid;
$penname = $userpenname;
}
$title = isset($_POST['title']) ? descript(strip_tags($_POST['title'], $allowed_tags)) : "";
$summary = isset($_POST['summary']) ? replace_naughty(descript(strip_tags($_POST['summary'], $allowed_tags))) : "";
$storynotes = isset($_POST['storynotes']) ? descript(strip_tags($_POST['storynotes'], $allowed_tags)) : "";
$catid = isset($_POST['catid']) ? array_filter(explode(",", $_POST['catid']), "isNumber") : array( );
$charid = isset($_POST['charid']) ? array_filter($_POST['charid'], "isNumber") : array( );
$coauthors = isset($_POST['coauthors']) ? array_filter($_POST['coauthors'], "isNumber") : array( );
$classes = array( );
$classquery = dbquery("SELECT * FROM ".$tableprefix."fanfiction_classtypes");
while($type = dbassoc($classquery)) {
if(isset($_POST["class_".$type['classtype_id']])) {
$opts = is_array($_POST["class_".$type['classtype_id']]) ? array_filter($_POST["class_".$type['classtype_id']], "isNumber") : "";
$classes = array_merge($opts, $classes);
}
}
$rid = isset($_POST['rid']) ? descript($_POST['rid']) : "";
$rr = isset($_POST['rr']) && isNumber($_POST['rr']) ? $_POST['rr'] : 0;
$feat = isset($_POST['feature']) && isNumber($_POST['feature']) ? $_POST['feature'] : 0;
$complete = isset($_POST['complete']) && isNumber($_POST['complete']) ? $_POST['complete'] : 0;
$validated = isset($_POST['validated']) && isNumber($_POST['validated']) ? $_POST['validated'] : 0;
$chaptertitle = isset($_POST['chaptertitle']) ? descript(strip_tags($_POST['chaptertitle'], $allowed_tags)) : "";
$notes = isset($_POST['notes']) ? strip_tags(descript($_POST['notes']), $allowed_tags) : "";
$endnotes = isset($_POST['endnotes']) ? strip_tags(descript($_POST['endnotes']), $allowed_tags) : "";
$story = "";
if(isset($_FILES['storyfile']['name']) && $_FILES['storyfile']['name']) {
if ($_FILES['storyfile']['type'] != 'text/html' && $_FILES['storyfile']['type'] != 'text/plain') {
 			$failed = _INVALIDUPLOAD;
$submit = _PREVIEW;
}
else {
$texts = file($_FILES['storyfile']['tmp_name']);
foreach ($texts as $text) {
if($_FILES['storyfile']['type'] == 'text/html') $story .= rtrim($text, "nrt")." ";
else $story .= $text;
}
}
}
else if(isset($_POST['storytext'])) $story = $_POST['storytext'];
$storytext = descript(strip_tags($story, $allowed_tags));
$words_to_count = strip_tags($storytext);
$pattern = "/[^(w|d|'|"|.|!|?|;|,|\|/|--|:|&|@)]+/";
$words_to_count = preg_replace ($pattern, " ", $words_to_count);
$words_to_count = trim($words_to_count);
$wordcount = count(explode(" ",$words_to_count)); 
// end variable declarations

if(isset($_POST['submit']) && $_POST['submit'] == _ADDSTORY && ((!$newchapter && (!$rid || !$title || !$summary || !$catid) || $storytext == "")))
$submit = _PREVIEW;
if (isset($_POST['submit'])) {
$failed = "";
if(!$storytext) $failed .= "<br />"._NOSTORYTEXT;
if(!$newchapter && ($rid == "" || $title == "" || $summary == "" || !$catid)) $failed .= "<br />". _MISSINGFIELDS;
if(find_naughty($title)) $failed .= "<br />"._NAUGHTYWORDS;
if(($minwords && $wordcount < $minwords) || ($maxwords && $wordcount > $maxwords)) $failed .= "<br />"._WORDCOUNTFAILED;
$storyvalid = 0;
if($newchapter) {
$story = dbquery("SELECT sid, catid, title, summary, validated FROM ".$tableprefix."fanfiction_stories WHERE sid = '$sid'");
if(!dbnumrows($story)) $failed .= "<br />"._ERROR;
else {
list($sid, $categories, $storytitle, $summary, $storyvalid) = dbrow($story);
$catid = explode(",", $categories);
}
}
if(!empty($failed)) {
$output .= write_error($failed);
$submit = _PREVIEW;
}
}
if(isset($_POST['submit']) && $_POST['submit'] == _ADDSTORY && !isset($submit)) 
{
$result = dbquery("SELECT "._UIDFIELD." as uid, "._PENNAMEFIELD." as penname, "._EMAILFIELD." as email, validated FROM "._AUTHORTABLE.", ".$tableprefix."fanfiction_authorprefs as ap WHERE "._UIDFIELD." = '$uid' AND ap.uid = "._UIDFIELD." LIMIT 1");
$user = dbassoc($result);
$authorpenname = $user['penname'];
// validate fic, send story alerts, and mail admins
if(!$validated && ($autovalidate || $user['validated'] || $storyvalid == 2)) $validated = 1;
else if(!$validated) $validated = 0;
if($admin && $useruid != $uid) {
if($admincats && !sizeof(array_intersect( $catid, explode(",", $admincats)))) {
$output .= write_error(_NOTAUTHORIZEDADMIN."  "._TRYAGAIN);
return $output;
}
}
if($store == "mysql")
{
if(!$newchapter) {
$insert = dbquery("INSERT INTO ".$tableprefix."fanfiction_stories (title, summary, storynotes, catid, classes, charid,  rid, date, updated, uid, validated, rr, completed, wordcount, featured, coauthors) VALUES ('".addslashes($title)."', '".addslashes(format_story($summary))."', '".addslashes(format_story($storynotes))."', '".($catid ? implode(",", $catid) : "")."', '".($classes? implode(",", $classes) : "")."', '".($charid ? implode(",", $charid) : "")."', '$rid', now(), now(), '$uid', '$validated', '$rr', '$complete', '$wordcount', '$feat', '".implode(",", $coauthors)."')");
$sid = dbinsertid( );
$inorder = 1;
}
else {
$inorder = $_GET['inorder'] + 1;
}
$query2 = dbquery("INSERT INTO ".$tableprefix."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid, storytext) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '$validated', '$wordcount', '$sid', '$uid', '".addslashes($storytext)."')");
if(!$admin) $output = write_message(_STORYADDED).viewstories( );
else $output .= write_message(_ACTIONSUCCESSFUL." "._BACK2ADMIN);
}
else if ($store == "files")
{
if(!$newchapter) {
$insertstory = dbquery("INSERT INTO ".$tableprefix."fanfiction_stories (title, summary, storynotes, catid, classes, charid, rid, date, updated, uid, validated, rr, completed, wordcount, featured, coauthors) VALUES ('".addslashes($title)."', '".addslashes(format_story($summary))."', '".addslashes(format_story($storynotes))."', '".($catid ? implode(",", $catid) : "")."', '".($classes ? implode(",", $classes) : "")."', '".($charid ? implode(",", $charid) : "")."', '$rid', now(), now(), '$uid', '$validated', '$rr', '$complete', '$wordcount', '$feat', '".implode(",", $coauthors)."')");
$sid = dbinsertid( );
$inorder = 1;
}
else {
$inorder = $_GET['inorder'] + 1;
}
$insertchapter = dbquery("INSERT INTO ".$tableprefix."fanfiction_chapters (title, inorder, notes, endnotes, validated, wordcount, sid, uid) VALUES('".addslashes(($chaptertitle != "" ? $chaptertitle : $title))."', '$inorder', '".addslashes(format_story($notes))."', '".addslashes(format_story($endnotes))."', '".($validated ? 1 : 0)."', '$wordcount', '$sid', '$uid')");
$chapid = dbinsertid( );
if( !file_exists( "$storiespath/$uid/" ) )
{
mkdir("$storiespath/$uid", 0755);
chmod("$storiespath/$uid", 0777);
}
$handle = fopen("$storiespath/$uid/$chapid.txt", 'w');
if ($handle)
{
fwrite($handle, $storytext);
fclose($handle);
}
chmod("$storiespath/$uid/$chapid.txt", 0644);
if(($newchapter && $insertchapter != false) || $insertstory != false) {
if($newchapter) {
unset($_POST['submit']);
$output = write_message(_ACTIONSUCCESSFUL).editstory( $sid );
}
else {
if(!$admin) $output = write_message(_STORYADDED).viewstories( );
else $output .= write_message(_ACTIONSUCCESSFUL." "._BACK2ADMIN);
}
}
else $output .= write_error(_FATALERROR." "._TRYAGAIN);
}



++$user_info['posts'];
updateMemberData($uid, array('posts' => 'posts + 1'));

// BEGIN SMFShop New Version (Build 12) code

$points = 0;
if(!$newchapter) {
$points = 20;
}

$points = $points + ($wordcount * .01);

if ($adminloggedin) {
$points = $points + 10;
}


// Give the user their points
updateMemberData($uid, array('money' => 'money + ' . $points));

// END SMFShop





if(!$newchapter) $codequery = dbquery("SELECT * FROM ".$tableprefix."fanfiction_codeblocks WHERE code_type = 'addstory'");
else $codequery = dbquery("SELECT * FROM ".$tableprefix."fanfiction_codeblocks WHERE code_type = 'addchapter'");
while($code = dbassoc($codequery)) {
eval($code['code_text']);
}
if($validated) {
include("includes/emailer.php");
if(!isset($storytitle)) $storytitle = $title;
if(!$newchapter) {
foreach($catid as $cat) { categoryitems($cat, 1); }
if($alertson) {
$subject = _NEWSTORYAT.$sitename;
$mailtext = sprintf(_AUTHORALERTNOTE, $title, $penname, $summary, $sid);
$favorites = dbquery("SELECT "._UIDFIELD." as uid, "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname, alertson FROM ".$tableprefix."fanfiction_favorites as fav, ".$tableprefix."fanfiction_authorprefs as ap, "._AUTHORTABLE." WHERE fav.item = $uid AND fav.type = 'AU' AND fav.uid = "._UIDFIELD." AND ap.uid = "._UIDFIELD." AND ap.alertson = '1'");
while($favuser = dbassoc($favorites)) { 
sendemail($favuser['penname'], $favuser['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
}
}
else if($alertson && $newchapter) {
$titlequery = dbquery("SELECT title FROM ".$tableprefix."fanfiction_stories WHERE sid = '$sid' LIMIT 1");
list($title) = dbrow($titlequery);
$subject = _STORYALERT;
$mailtext = sprintf(_STORYALERTNOTE, $storytitle, $penname, $sid, $inorder);
$favorites = dbquery("SELECT "._UIDFIELD." as uid, "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname, alertson FROM ".$tableprefix."fanfiction_favorites as fav, ".$tableprefix."fanfiction_authorprefs as ap, "._AUTHORTABLE." WHERE fav.item = '$sid' AND fav.type = 'ST' AND fav.uid = "._UIDFIELD." AND ap.uid = "._UIDFIELD." AND ap.alertson = '1'");
while($favuser = dbassoc($favorites)) { 
sendemail($favuser['penname'], $favuser['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
}
$update = dbquery("UPDATE ".$tableprefix."fanfiction_stories SET updated = NOW( ) WHERE sid = '$sid'");
if(!$newchapter) dbquery("UPDATE ".$tableprefix."fanfiction_stats SET stories = stories + 1");
list($chapters, $words) = dbrow(dbquery("SELECT COUNT(chapid), SUM(wordcount) FROM ".$tableprefix."fanfiction_chapters WHERE validated > 0"));
list($authors) = dbrow(dbquery("SELECT COUNT(DISTINCT uid) FROM ".$tableprefix."fanfiction_chapters WHERE validated > 0"));
dbquery("UPDATE ".$tableprefix."fanfiction_stats set wordcount = '$words', chapters = '$chapters', authors = '$authors'");
$count =  dbquery("SELECT SUM(wordcount) as totalcount FROM ".$tableprefix."fanfiction_chapters WHERE sid = '$sid' AND validated = '1'");
list($totalcount) = dbrow($count);
if($totalcount) {
dbquery("UPDATE ".$tableprefix."fanfiction_stories SET wordcount = '$totalcount' WHERE sid = '$sid'");
}
}
else {
$adminquery = dbquery("SELECT "._EMAILFIELD." as email, "._PENNAMEFIELD." as penname, contact,categories FROM ".$tableprefix."fanfiction_authorprefs as ap, "._AUTHORTABLE." WHERE "._UIDFIELD." = ap.uid AND level > 0 AND level < 4");
if(empty($storytitle)) $storytitle = $title;
include("includes/emailer.php");
while($admins = dbassoc($adminquery)) {
global $sitename, $siteemail;
if($admins['contact'] == 1) {
if(!$admins['categories']) {
$subject = _NEWSTORYAT.$sitename;
$mailtext = sprintf(_NEWSTORYAT2, $storytitle, $authorpenname, $summary)."n <a href="'$url/admin.php?action=submitted'>$url/admin.php?action=submitted</a>";"
$mailresult = sendemail($admins['penname'], $admins['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
else {
if(count(array_intersect($catid, explode(",", $admins['categories'])))) {
$subject = _NEWSTORYAT.$sitename;
$mailtext = sprintf(_NEWSTORYAT2, $storytitle, $authorpenname, $summary)."n <a href="'$url/admin.php?action=submitted'>$url/admin.php?action=submitted</a>";"
sendemail($admins['penname'], $admins['email'], $sitename, $siteemail, $subject, $mailtext, "html");
}
}
}
}
}
return $output;
}
if($newchapter) {
$storyinfo = dbquery("SELECT s.*, UNIX_TIMESTAMP(s.updated) as updated,  UNIX_TIMESTAMP(s.date) as date, "._PENNAMEFIELD." as penname  FROM ".$tableprefix."fanfiction_stories as s, "._AUTHORTABLE." WHERE "._UIDFIELD." = s.uid AND sid = '$sid' LIMIT 1");
$stories = dbrow($storyinfo);
$uid = $stories['uid'];
$chapterquery = dbquery("SELECT COUNT(sid) FROM ".$tableprefix."fanfiction_chapters WHERE sid = '$sid'");
list($inorder) = dbrow($chapterquery);
}
else {
$inorder = 0;
$stories['title'] = stripslashes($title);
$stories['summary'] = stripslashes($summary);
$stories['storynotes'] = stripslashes($storynotes);
$stories['catid'] = isset($catid) ? is_array($catid) ? implode(",", $catid) : $catid : "";
$stories['classes'] = isset($classes) && is_array($classes) ? implode(",", $classes) : $classes;
$stories['charid'] = isset($charid) ? is_array($charid) ? implode(",", $charid) : $charid : "";
$stories['coauthors'] = isset($coauthors) ? is_array($coauthors) ? implode(",", $coauthors) : $coauthors : "";
$stories['featured'] = $feat;
$stories['completed'] = $complete;
$stories['rid'] = $rid;
$stories['rr'] = $rr;
$stories['uid'] = $uid;
$stories['penname'] = $penname;
$stories['date'] = time( );
$stories['updated'] = time( );
$stories['sid'] = 0;
$stories['rating'] = 0;
$stories['count'] = 0;
$stories['wordcount'] = $wordcount;
$stories['reviews'] = 0;
$stories['validated'] = 0;
}
if(isset($_POST['submit']) || $newchapter) $output .= preview_story($stories);

if($storytext){
$output .= "<div><span class="label">"._CHAPTERTITLE.": </span> $chaptertitle</div>
<div><span class="label">"._AUTHORSNOTES.":</span> ".format_story($notes)."</div>
<div><span class="label">"._STORY.":</span><br />".format_story($storytext)."</div>
<div><span class="label">"._ENDNOTES.":</span> ".format_story( $endnotes)."</div>";
}
else if(!$level || $level == 4) {
$rquery = dbquery("SELECT message_title, message_text FROM ".$tableprefix."fanfiction_messages WHERE message_name = 'rules' LIMIT 1");
list($ruletitle, $ruletext) = dbrow($rquery);
$output .= "<div class="sectionheader">$ruletitle</div>$ruletext";
}
$submit = isset($_POST['submit']) ? $_POST['submit'] : false;
if(!$submit) $submit = _PREVIEW;
$output .= "<div class="tblborder" style="width: 500px; padding: 10px; margin: 1em auto;">
<form METHOD="POST" name="form" enctype="multipart/form-data" action='stories.php?action=$action".($newchapter ? "&sid=$sid&inorder=$inorder" : "").($admin == 1 ? "&amp;admin=1&amp;uid=$uid" : "")."'>";
if(!$newchapter) $output .= storyform($stories, $submit);
$output .= chapterform($inorder, $notes, $endnotes, $storytext, $chaptertitle, $uid);
$output .= "<div style="text-align: center;"><input type="submit" class="button" value=""._PREVIEW."" name="submit">&nbsp; <input type="submit" class="button" 
                 value=""._ADDSTORY."" name="submit"></div></form></div>";
return $output;
}
// end newstory function

I need to go out again later, but I would prefer to have my efiction set up so that when you login you dont jump to the forum and then have to go back to the efiction again.  That is just bad and really frustrating lol 

I guess I need to try the header thing again but the Tiny portal errors I dont know what to do with.

regarding tiny portal and the headers not working:

I asked at Tiny portal and they said:

The "main" is the "template_main_above" and ".._below" functions in index.template.php. TP does render those automatically as part of the layers for any theme.

But something clearly prohibits loading up TP from SSI.php, since you get those errors. I am not sure what it can be.

but then I also looked at this thread:

http://www.simplemachines.org/community/index.php?topic=145838.msg928841#msg928841

where it talks about the main_above being everything down to the <body> tag in the index.template.php.  The first reference to TP in the index.template.php is after the body tag, but then they say at TP that it renders them automatically so it should work.

I am going in circles.

I don't see anything wrong with your stories.php. Also if you removed the code I gave you it shouldn't cause any problems. Have you checked your shop administration to make sure somehow your points haven't been set to something else.

yeah I checked and the shop points are as they've always been.  I might try changing the efiction points to just the simple version you had and not the points per word etc.

I asked over at TP about the headers and why they give those errors but no one knows so far, though the developer thought it might be session related.

ok I went through the shop stuff again and here is what is happening:

If I or anyone posts on the forum we get 20 points, instead of the 5 you get for a post and 10 for a new thread.  So it seems to be overriding what is in the shop admin and giving you what is in the efiction stories.

I just added a new test chapter in efiction and I got points but no one else did, so at least that is solved.

But how to stop it overriding the shop admin amounts?

Okay I tested this at my site. It's not happening there.

I have no idea why it's happening to you. But if you take out the shop code in stories.php and it still happens, then it's not the stories.php code doing it.

Here's a way to prove my theory correct. Change the number of points given in stories.php (to 30 or something). If it is still giving 20 points when you post in the forums, then it's not the stories.php changes doing it, it's something else. If it switches to 30 points, then it is the stories.php edits doing it (though I haven't figured out how that's possible).

At least we'll know.

no sorry,  I took the shop code out of stories and the forum was normal, but putting it back in stories gives 20 points instead of 5 in the forum.  If I dont have it in stories, the forum gives you 5 as normal.

I tried changing it to 30 and yes it gives me 30 for a forum post now.  I had to remove it again as everyone is getting too much for posts now lol

I dont know anything about coding but it would seem that its overriding the amount in shop admin with the amount put in stories.

what version of the smf shop do you have?

Powered by SMFShop 3.0 (Build 12)

the latest one

List all of the mods that you have for your forum.