Quests!!

[Uridium]

silly thing 1 sec :)

[kcmajor36]

SQL query:

 

--------------------------------------

--

CREATE TABLE `questgroups` (

`qgID` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`qgNAME` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`qgORDER` INT( 11 ) NOT NULL DEFAULT '0' PRIMARY KEY ( `qgID` ) ) ENGINE MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;

 

 

MySQL said:

 

#1064 - 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 '----------------------------------------

CREATE TABLE `questgroups` (

`qgID` ' at line 1

[kcmajor36]

Just login to your IM and we can talk on there. OKay?

[Uridium]

Ive removed the

----------------------------------------

 

from the above SQL so try it now :)

[mysql]CREATE TABLE `quests` (

`questID` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`questNAME` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`questBRAVE` INT( 11 ) NOT NULL DEFAULT '0',

`questPERCFORM` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`questSUCCESSMUNY` INT( 11 ) NOT NULL DEFAULT '0',

`questSUCCESSCRYS` INT( 11 ) NOT NULL DEFAULT '0',

`questSUCCESSITEM` INT( 11 ) NOT NULL DEFAULT '0',

`questGROUP` INT( 11 ) NOT NULL DEFAULT '0',

`questITEXT` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`questSTEXT` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`questFTEXT` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`questXP` INT( 11 ) NOT NULL DEFAULT '0',

PRIMARY KEY ( `questID` ) ,

FULLTEXT (

`questNAME` ,

`questPERCFORM` ,

`questITEXT` ,

`questSTEXT` ,

`questFTEXT` )) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci ;[/mysql]

[mysql]

CREATE TABLE `questgroups` (

`qgID` INT( 11 ) NOT NULL AUTO_INCREMENT ,

`qgNAME` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,

`qgORDER` INT( 11 ) NOT NULL DEFAULT '0',

PRIMARY KEY ( `qgID` ))

ENGINE MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci ;[/mysql]

[kcmajor36]

Okay hold on

[kcmajor36]

GREAT WORKS!

[kcmajor36]

Having a error on the globals.php " Parse error: syntax error, unexpected $end in /home/XXXX/public_html/XXXX/globals.php on line 117 "

[Equinox]

Having a error on the globals.php " Parse error: syntax error, unexpected $end in /home/XXXX/public_html/XXXX/globals.php on line 117 "

Take out what you added into globals.php

Open up global_func.php and add:

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[kcmajor36]

haha well we went from 1 error (which btw danny that $a did fix it) to another error -

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

ive been googling and reading other forums and they said it could be a misplaced curley bracket, i couldnt find it so i redid the script completely again to match docrime.php (but with quests) and its still giving me the same error :/ any ideas? its the doquests.php btw -- here it is again so u dont have to page back

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

I'm having the same problem.

[Uridium]

doquest.php Try this one

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

tested and works for me if your still having issues then remove all that was mentioned for globals.php

[wykydz]

Does this work for MCCODE V2

[sniko]

Does this work for MCCODE V2

It uses the $db class and includes the globals file, so i don't see why not :)

-sniko

[wykydz]

Thats the error im getting

i took out what i added in the globals and put what was said to do for the global_func.php

Parse error: syntax error, unexpected T_STRING, expecting ')' in /home/XXXXXX/public_html/XXXXX/global_func.php on line 2

 

function quest_dropdown($connection,$ddname="quests",$selec ted=-1)

[Danny696]

Theres a space there remove the space between selec and ted

[guy]

Im new here, but been reading alot and learning alot from everyone here. Just want to say thanks!! But im having a problem with this mod. Ive followed everything as stated, but it still doesnt seem to be working for me?????

When choosing to do a quest it says invalid quest???? Everything else works with no errors, but just cant do the quest??

$macropage="doquest.php?c={$_GET['c']}";

include "globals.php";

if($ir['jail'] or $ir['hospital']) { print "This page cannot be accessed while in jail or hospital.";

$h->endpage();

exit;

}

$_GET['c']=abs((int) $_GET['c']);

if(!$_GET['c'])

{

print "Invalid mission";

}

else

Any help is appreciated

Thank you

[AnonymousUser]

Im new here, but been reading alot and learning alot from everyone here. Just want to say thanks!! But im having a problem with this mod. Ive followed everything as stated, but it still doesnt seem to be working for me?????

When choosing to do a quest it says invalid quest???? Everything else works with no errors, but just cant do the quest??

$macropage="doquest.php?c={$_GET['c']}";

include "globals.php";

if($ir['jail'] or $ir['hospital']) { print "This page cannot be accessed while in jail or hospital.";

$h->endpage();

exit;

}

$_GET['c']=abs((int) $_GET['c']);

if(!$_GET['c'])

{

print "Invalid mission";

}

else

Any help is appreciated

Thank you

I dont see why people feel the need to post an error thats already been fixed... LOOK AT THE ENTIRE THREAD BEFORE You try posting 'bugs or errors'