Reaction Posted August 12, 2009 Share Posted August 12, 2009 With some help from danny ive taken the crimes and transformed it into a quests so you can now have both. SQL TABLES You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. after creating your tables youll then need to create a quest.php with this You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now for your doquest.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Read next post for the rest! Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 12, 2009 Author Share Posted August 12, 2009 Re: Quests!! Next create your staff_quests.php with this You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now add this to smenu.php wherever u'd like (i placed it just under crimes and above battle tents for organization purposes) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. ok almost there guys haha! next part is courtesy of danny, thanks man! place this in your global_func.php i placed it just above the crimes section myself but its up to u You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Next is for your globals.php You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Last but certainly not least open up your mainmenu.php and find You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. somewhere in there, wherever you would like ppl to see it place You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Make sure u line it up with the others its pretty simple. soon to come organized quests?! we'll see how it goes XD That should do it! load it all up and check you should have a quests in game and in your staff menu just like u do crimes! This is my first attempt coding anything and its pretty much based straight off the crimes but i hope its helpful, if there are any problems post back and ill see what i can do but im no pro >.< lol. Quote Link to comment Share on other sites More sharing options...
legrolls Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! Interesting idea. Personally, I enjoy programming unique quests that use items, level requirements, and more, but this could be a nice alternative. Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 12, 2009 Author Share Posted August 12, 2009 Re: Quests!! well like i said its just a basic quests works exactly like crimes but no jail time so u can have easy earn xp quests for the players to get through those low lvls a little quicker or whatever u plan, it should pretty pretty easily altered too. and actually if u wanted u could add those into the coding here and have a staff panel for quest creation that does all that for you too! Quote Link to comment Share on other sites More sharing options...
? Sparks ? Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! Got too tired of them being called crimes? Quote Link to comment Share on other sites More sharing options...
Danny696 Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! Can i ask why you are adding the functions into gloabls.php and global_func.php they only need to be in global_func.php ;) Quote Link to comment Share on other sites More sharing options...
weewooz Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! nice well done mate can you make say the quests only say users go do say 5 times aday or with no link jail or hospital there guna keep leveling coz of the exp they get users will go flying through levels mate apart from nice recode of the crimes :0 Quote Link to comment Share on other sites More sharing options...
Danny696 Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! nice well done mate can you make say the quests only say users go do say 5 times aday or with no link jail or hospital there guna keep leveling coz of the exp they get users will go flying through levels mate apart from nice recode of the crimes :0 Well its the owner fault if they go through levels like its water isnt it coz they have set it up too easy so i blame the owner not the coder ;) Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 12, 2009 Author Share Posted August 12, 2009 Re: Quests!! Warning: Invalid argument supplied for foreach() in /home/reaction/public_html/ionicdestiny/quest.php on line 16 --- this is the error im getting for somereason but line 16 is written correctly :/ identical to the criminal.php except it says quests of course :/ any ideas? Quote Link to comment Share on other sites More sharing options...
Danny696 Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! post line 13-19 with a note on line 16 Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 12, 2009 Author Share Posted August 12, 2009 Re: Quests!! You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
Danny696 Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! of quests Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 12, 2009 Author Share Posted August 12, 2009 Re: Quests!! You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. haha sorry they are pretty much identical Quote Link to comment Share on other sites More sharing options...
Uridium Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! I'll +1 ya :) i havent tried it but looked over it Quote Link to comment Share on other sites More sharing options...
Danny696 Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! Do i get +1 lol oj try You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. then where ever you see You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. replace with You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And illusions im sure you could make this more advanced and more widley used than me or Reaction could ;) Quote Link to comment Share on other sites More sharing options...
Uridium Posted August 12, 2009 Share Posted August 12, 2009 Re: Quests!! Do i get +1 lol oj try You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. then where ever you see You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. replace with You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And illusions im sure you could make this more advanced and more widley used than me or Reaction could ;) I think he's doing fine on his own. As a first script i think we can certainly see some more decent scripts from him :) Sorry Danny wasnt aware you took part but yeah i'll +1 you :) Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 13, 2009 Author Share Posted August 13, 2009 Re: Quests!! 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. Quote Link to comment Share on other sites More sharing options...
Reaction Posted August 13, 2009 Author Share Posted August 13, 2009 Re: Quests!! hmm well i fixed all those little syntax error but for some reason when i do the quest it wont show success/failure correctly, it will just show initial text, or both S and F combined and u get no money/xp for completing that way Quote Link to comment Share on other sites More sharing options...
Coly010 Posted December 23, 2009 Share Posted December 23, 2009 the sql wont work for me it comes up [mysql] Error SQL query: 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 ---------------------------------------- CREATE TABLE `questgroups` ( [...] 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 21 [/mysql] i fixed it! Quote Link to comment Share on other sites More sharing options...
kcmajor36 Posted April 26, 2010 Share Posted April 26, 2010 How do I fix the SQL? Quote Link to comment Share on other sites More sharing options...
rowbvp Posted April 26, 2010 Share Posted April 26, 2010 SQL error 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 21 Quote Link to comment Share on other sites More sharing options...
Uridium Posted April 26, 2010 Share Posted April 26, 2010 [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 ; 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] That should work you just missed a ; after COLLATE utf8_unicode_ci Quote Link to comment Share on other sites More sharing options...
DISTORTED Posted April 26, 2010 Share Posted April 26, 2010 nice :D Your SQL query has been executed successfully (Query took 0.165 sec) Thanks mate Quote Link to comment Share on other sites More sharing options...
kcmajor36 Posted April 26, 2010 Share Posted April 26, 2010 Still doesn't work. Hmmm? Quote Link to comment Share on other sites More sharing options...
kcmajor36 Posted April 26, 2010 Share Posted April 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.