Jump to content

Photo
* * * * * 2 votes

[YN] DB SQL/Query for all ((₦ulled by Mis✞er₩izard)) Modules


  • Please log in to reply
28 replies to this topic

#1 Les

Les

    Blue Team Lima 1

  • Moderators
  • Level
  • 5,006 points
  • 3,315 posts
    • Gender:Male
    • Location:Westland, Michigan U.S.A.
    • Software:SE 4.8.x


Users Awards

Posted 14 October 2015 - 12:37 PM

"YouNetcore Database Table SQL/Query"

CREATE TABLE IF NOT EXISTS `engine4_younetcore_apisettings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) NOT NULL,
  `value` text NOT NULL,
  `params` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `engine4_younetcore_license` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `title` text NOT NULL,
  `descriptions` text,
  `type` varchar(50) NOT NULL,
  `current_version` varchar(50) NOT NULL,
  `lasted_version` varchar(50) NOT NULL,
  `is_active` int(1) DEFAULT '0',
  `date_active` int(11) DEFAULT NULL,
  `params` text,
  `download_link` varchar(500) DEFAULT NULL,
  `demo_link` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `engine4_younetcore_install` (
  `token` text NOT NULL,
  `params` text NOT NULL,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


Screenshot: Example

 

Attached File  how_to_server.png   84.72KB   15 downloads

 

* [[ Please modify your database. Run SQL query/queries on database above to run all ((₦ulled by Mis✞er₩izard)) Modules.]] * THANKS!


Edited by Les, 22 January 2016 - 04:35 PM.

:emo: Please don't forget to  27-AwardsImgIcon.png "LIKE" if you like this post or if it is helpful to you. This is a way to show gratitude for the help that you received. After all, the "LIKE" costs you nothing. Don't you agree? Also, any and all modules, plug-ins, themes, widgets, or DB entries that are shared or posted by me are for educational purposes. Please visit the developers websites and purchase legitimately, if you like them. Thanks, Les

socialengine-experts.png

 

 


#2 Johannes50

Johannes50

    Level 3

  • Members
  • Level
  • 35 points
  • 84 posts


Users Awards

Posted 23 October 2015 - 11:34 PM

Great Job Les, thxs



#3 Phoenix

Phoenix

    Fresh Developer

  • Members
  • Level
  • 148 points
  • 224 posts
    • Gender:Male
    • Software:SE 4.8.x

Posted 20 November 2015 - 07:10 PM

If, for whatever reason, a module don't work, go to phpmyadmin and set the modules row "is_active" to 1.

 

In table row engine4_younetcore_license


Edited by Phoenix, 20 November 2015 - 07:11 PM.

+ like my posts if you like my post. The more likes I have, the more I can help. ;)

 

post-25643-0-72029900-1428162645.png


#4 yesplease

yesplease

    Level 1

  • Members
  • Level
  • 2 points
  • 9 posts

Posted 20 November 2015 - 07:12 PM

thanks for this!



#5 Yoda

Yoda

    Level 1

  • Members
  • Level
  • 0 points
  • 11 posts
    • Gender:Female
    • Software:SE 4.8.x

Posted 23 November 2015 - 01:08 AM

Les, I love you man. Metaphorically speaking and all. But I do! 



#6 marcp

marcp

    Level 3

  • Members
  • Level
  • 10 points
  • 53 posts
    • Gender:Not Telling
    • Software:SE 4.8.x

Posted 27 December 2015 - 11:48 AM

hello, Do I create a file to run this or do I go into the database itself and input these?



#7 janan

janan

    Level 2

  • Members
  • Level
  • 6 points
  • 38 posts

Posted 06 January 2016 - 05:08 PM

where should i put this codes?

 myphp admin and than where should i past this codes?

can somebody please help me where i exactly can put it?



#8 Les

Les

    Blue Team Lima 1

  • Moderators
  • Level
  • 5,006 points
  • 3,315 posts
    • Gender:Male
    • Location:Westland, Michigan U.S.A.
    • Software:SE 4.8.x


Users Awards

Posted 06 January 2016 - 06:44 PM

where should i put this codes?

 myphp admin and than where should i past this codes?

can somebody please help me where i exactly can put it?

 

Paste the codes in SQL box after you click on it's tab and then click Run.

 

Attached File  how_to_server.png   84.72KB   1 downloads

 


Edited by Les, 22 January 2016 - 04:33 PM.

:emo: Please don't forget to  27-AwardsImgIcon.png "LIKE" if you like this post or if it is helpful to you. This is a way to show gratitude for the help that you received. After all, the "LIKE" costs you nothing. Don't you agree? Also, any and all modules, plug-ins, themes, widgets, or DB entries that are shared or posted by me are for educational purposes. Please visit the developers websites and purchase legitimately, if you like them. Thanks, Les

socialengine-experts.png

 

 


#9 Phoenix

Phoenix

    Fresh Developer

  • Members
  • Level
  • 148 points
  • 224 posts
    • Gender:Male
    • Software:SE 4.8.x

Posted 06 January 2016 - 10:15 PM

http://ge.tt/88hl7LV2/v/0?c

 

SQL format for those who prefer to import via phpmyadmin or other.


+ like my posts if you like my post. The more likes I have, the more I can help. ;)

 

post-25643-0-72029900-1428162645.png


#10 janan

janan

    Level 2

  • Members
  • Level
  • 6 points
  • 38 posts

Posted 08 January 2016 - 04:46 PM

I get this error when i import or copy the codes. i dont know why?
 
Error
SQL query:
CREATE TABLE IF NOT EXISTS `engine4_younetcore_apisettings` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT ,
`type` VARCHAR( 50 ) NOT NULL ,
`value` TEXT NOT NULL ,
`params` TEXT,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =1;
 
 
MySQL said: Documentation
#1046 - No database selected 

 

 

 






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users


All the resources listed here are just for testing purpose and they shouldn't be used at any commercial environment without a valid license.
Those are for users who wants to try them before buy. Help the developer to build it better by purchasing them from original authors.