Klikoka Posted February 7, 2008 Posted February 7, 2008 Make File Called csmuggling.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Goto explore.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add To Day Cron You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And SQL Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And Thats It :-D :-D Quote
Klikoka Posted February 7, 2008 Author Posted February 7, 2008 Re: [V2]Crystal Smuggling Mod[V2] For V1 You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. SQL Is The Same Explore Is Same Cron Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
HITMAN 17 Posted February 7, 2008 Posted February 7, 2008 Re: [V2]Crystal Smuggling Mod[V2] Make File Called csmuggling.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Goto explore.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add To Day Cron You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And SQL Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And Thats It :-D :-D the sql was wrong Quote
POG1 Posted February 7, 2008 Posted February 7, 2008 Re: [V2]Crystal Smuggling Mod[V2] Make File Called csmuggling.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Goto explore.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add To Day Cron You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And SQL Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And Thats It :-D :-D the sql was wrong use your brains and work out the right sql lol Quote
Guest Anonymous Posted February 7, 2008 Posted February 7, 2008 Re: [V2]Crystal Smuggling Mod[V2] Make File Called csmuggling.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Goto explore.php And Add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add To Day Cron You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And SQL Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. And Thats It :-D :-D the sql was wrong use your brains and work out the right sql lol He dosn't have any :lol. Quote
Godhand Posted February 7, 2008 Posted February 7, 2008 Re: [V2]Crystal Smuggling Mod[V2] Whats to stop players from memorizing which one is better on average since they all subtract by 1 per trip? Good idea but there needs to be something to prevent memorization. Or at least make a smuggling level based on crystals. Very nice mod though for concept it gives me quite a few more ideas to expand upon it. Installing a smuggling level then making You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. instead of You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. note: fill in "some number" to be whatever you want. For instance if you want it to be just smuggling level times the scale you could put $smugglinglevel*$randomscale or $smugglinglevel/1*$randomscale. If anyone wants to use the idea feel free to. :-D Quote
HITMAN 17 Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] emm it keeps saying You Can Only Go Sailing Once A Day y i havent teven done it once Quote
Godhand Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] because the default amount of smuggling is 0. Therefore you shouldn't be able to travel unless you make it 5 or whatever. READ the actual coding before adding stuff into your game. Quote
HITMAN 17 Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] so which bit needs editing Quote
Godhand Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] sql You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Note all you have to do is fill in your database name to make it work Assuming you are user id 1 :-D. Quote
HITMAN 17 Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] UPDATE `mydatabase_mydatabase`.`users` SET `smuggling` = '100' WHERE `users`.`userid` =1 LIMIT 1 so i just insert that into database; Quote
Klikoka Posted February 10, 2008 Author Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] yup Quote
HITMAN 17 Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] SQL query: UPDATE `a5069509_a5069509`.`users` SET `smuggling` = '100' WHERE `users`.`userid` =1 LIMIT 1 MySQL said: Documentation #1054 - Unknown column 'smuggling' in 'field list' Quote
Krafty Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] This just takes the games crystal economy higher...I would suggest you make it very hard to find crystals.. Quote
Wookard Posted February 10, 2008 Posted February 10, 2008 Re: [V2]Crystal Smuggling Mod[V2] Hi, this looks like a great Mod! I am a big NOOB hehe. Is there a way for you guys to show me to make it so it requires a item first? Ie maybe buying a Sail Boat!! Maybe even Hiring a crew. So only people that are farther in the game or not cheaters can afford to do this? Again, Awesome Mod. +1 for sure =) Quote
Godhand Posted February 11, 2008 Posted February 11, 2008 Re: [V2]Crystal Smuggling Mod[V2] This just takes the games crystal economy higher...I would suggest you make it very hard to find crystals.. Yes that is true and reading the code it can give up to 400 crystals at a time. I mean as a base mod though its very nice. Yet on the flip side theres more that can be done to prevent memorization. Like for instance making a random chance of getting caught verses the smuggling level. It wouldn't be terribly hard to do but as I'm not going to use this mod I can't be bothered. SQL query: UPDATE `a5069509_a5069509`.`users` SET `smuggling` = '100' WHERE `users`.`userid` =1 LIMIT 1 MySQL said: Documentation #1054 - Unknown column 'smuggling' in 'field list' Thats because you don't have it set up in your database right then. What you need to do is simply put it in the users field then run that query. Quote
Klikoka Posted February 11, 2008 Author Posted February 11, 2008 Re: [V2]Crystal Smuggling Mod[V2] the sql is wrong it is `csmuggling` Quote
Klikoka Posted February 11, 2008 Author Posted February 11, 2008 Re: [V2]Crystal Smuggling Mod[V2] So The Full SQL Is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Klikoka Posted February 11, 2008 Author Posted February 11, 2008 Re: [V2]Crystal Smuggling Mod[V2] This just takes the games crystal economy higher...I would suggest you make it very hard to find crystals.. You Can Change The Amount Of Crystals They Get And How Many Times A Day There Allowed To Do It Quote
HITMAN 17 Posted February 15, 2008 Posted February 15, 2008 Re: [V2]Crystal Smuggling Mod[V2] SQL query: UPDATE `a5069509_a5069509`.`users` SET `smuggling` = '100' WHERE `users`.`userid` =1 LIMIT 1 MySQL said: Documentation #1054 - Unknown column 'smuggling' in 'field list' PDATE `users` ADD `csmuggling` int( 11 ) NOT NULL default '10' MySQL said: Documentation #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 'ADD `csmuggling` int(11) NOT NULL default'10'' at line 1 Quote
Klikoka Posted February 15, 2008 Author Posted February 15, 2008 Re: [V2]Crystal Smuggling Mod[V2] SQL query: UPDATE `a5069509_a5069509`.`users` SET `smuggling` = '100' WHERE `users`.`userid` =1 LIMIT 1 MySQL said: Documentation #1054 - Unknown column 'smuggling' in 'field list' PDATE `users` ADD `csmuggling` int( 11 ) NOT NULL default '10' MySQL said: Documentation #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 'ADD `csmuggling` int(11) NOT NULL default'10'' at line 1 You Must Already Have The SQL Table Added Quote
HITMAN 17 Posted February 15, 2008 Posted February 15, 2008 Re: [V2]Crystal Smuggling Mod[V2] ye i do lol and now i get this You Can Only Go Sailing Once A Day and i have 20 sails Quote
Godhand Posted February 16, 2008 Posted February 16, 2008 Re: [V2]Crystal Smuggling Mod[V2] the sql is wrong it is `csmuggling` apparently my keyboard skipped then. I know I thought I typed it out but I cant be bothered to check for typos when I'm just pointing them to the right direction. Besides they should read what it does before they run it. Why you may ask is because what if I set up coding that basically erased their game? They should know to check what the functions do. Quote
Klikoka Posted February 17, 2008 Author Posted February 17, 2008 Re: [V2]Crystal Smuggling Mod[V2] Parts Of The Code Were Wrong Heres A Fixed One:: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Guest Sniko` Posted February 17, 2008 Posted February 17, 2008 Re: [V2]Crystal Smuggling Mod[V2] ok, Klikoka helped me do this. NOTE: DOESNT WORK! STILL WORKING ON IT... this one is modified so if you are a certain level more places will show up You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
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.