Discover @cavo789 Open Source projects

Christophe Avonture (@cavo789)

cavo789

Stars
483
Global Rank 57,514 (Top 3 %)
Followers 47
Registered almost 14 years ago
Most used languages

PHP
36.1 %

Batchfile 16.4 %

VBScript 10.7 %

JavaScript
6.6 %

VBA 6.6 %

Shell
6.6 %

PowerShell
5.7 %

Dockerfile
2.5 %

CSS
2.5 %

HTML
1.6 %

Visual Basic 1.6 %

Others 3.2 %
Location 🇧🇪 Belgium
Country Total Rank 319
Country Ranking

Batchfile 1

VBA 1

VBScript 1

Hack 5

Visual Basic 10

Pascal 16

PowerShell
29

PHP
50

Dockerfile
55

Shell
160

CSS
168

HTML
404

JavaScript
597

Java
1,075

Python
1,844

marknotes

📝 You’re taking a lot of notes and need a solution to manage them i.e. put your knowledge base in one central place and being able to retrieve quickly information’s, display them nicely through the browser as a HTML page or a slideshow, export them in many file formats (docx, odt, pdf, txt, …). Sensitive information’s can be encrypted and notes can be edited online.

vba_excel_sql

SQL Server to Microsoft Excel. VBA class for Excel to make easy to access records stored in SQL Server and output these data in an Excel sheet; keeping or not the link

vscode_tips

Tutorial about Visual Studio Code and tips and tricks

vba_excel_export_code

Just like me, you write Excel macros and you want a simple way to export your code as text files to your hard disk so that you can manage versions and load the code into e. g. GitHub? My vba_excel_export_code script is made for you. From now on it also manages the export of your ribbon.

tools_xyplorer

xyPlorer is a tremendous software; 10k time better than the prehistoric Windows Explorer. This repo to store and share own scripts

tools_winscp

Tips and tricks and small scripts for automation of the WinSCP FTP client (Windows).

htaccess

Some tips and tricks for your .htaccess file (Apache)

vbs_classes

VBS scripts and classes that will help Windows users to collect a list of files based on extensions and utilities to work with Access, Excel and SQL Server

joomla_free

A set of php scripts that will probably be useful to you in your life as a webmaster, including, for example, check_db (for quickly check your Joomla's configuration), kill_db_tables for removing tables based on a prefix, ...

vbs_utilities

Small, stand alone and straight forward VBS scripts for working with emails, files, folder, ...

vba_access

MS Access snippets

aesecure_quickscan

PHP script to install on your site (preferably in localhost for better performance) to scan files for viruses. aeSecure QuickScan already RECOGNIZE MORE THAN 45.000 VIRUSES (November 2018) and use whitelist hashes to avoid to scan WordPress and Joomla native files (all versions). Thanks these hashes aeSecure QuickScan already detect more than 700.000 files as healthy.

markdown_encrypt

Proof of concept - Encrypt markdown files and store encrypted version on github

dos_batch_tips

Tips and tricks when writing batch for MS DOS, mainly functions.

marknotes_convert

Utility to convert .docx and .odt to markdown. Script for Windows.

vba_excel_call_webservice

How to call a web service in Excel VBA. The example is built using the European Union's VIES CheckVAT web service.

php_password

Easy interface for generating a hash for a plain text password. Type a plain text password and get his password_hash() hash.

bash_shell_coding

Tips and tricks on how to write powerfull bash scripts

marknotes_html2md

Quick HTML to markdown converter

sql_formatter

Very straight-forward script for formatting SQL statement.

php_grep

This script will allow you to scan files of your website and search for a specific pattern; f.i. a word or a sentence.

excel_ribbon

Programmer's guide to creating a Ribbon for MS Excel

github_clone_all

Get the list of repositories of someone and, repo by repo, check if a clone is already present on disk; if not, make a clone

joomla_log_admin

You've forgot your Joomla admin credentials but you 've access to your FTP? The log_admin.php script will allow you to connect in your administrator interface without the need to fill in credentials.

marknotes_install

Installation script for marknotes (https://github.com/cavo789/marknotes). Download the latest version of the tool, install it, finalize the installation and it's yours !

backup_chrome_bookmarks

Take a copy of the Chrome bookmarks on a Virtual Machine and copy them on your physical computer.

phpmenu

My configuration files

vbs_sql_sp_columns

Connect to SQL Server, iterate every tables and generate a .csv file by table containing the table's structure

git_tips

Tips and tricks and snippets for working with Git

tools_git_scripts

Script and utilities to make life with Git easier

docker_ssl_encrypt

Encrypt/decrypt files using Docker and OpenSSL

vba_excel_image_gallery

Loop all images in a folder and insert them in a worksheet, one image by row

npm_unsplash_background

On every Windows startup use a new background image directly downloaded from Unsplash

jsonlint

A very simple json beautifier

marknotes_xls2md

Excel raw table to markdown converter

base64

Simple javascript base64_encode / base64_decode interface

powershell_tips

Tips and tricks and snippets of PowerShell functions

vbs_xls_import_code

Import code to an Excel workbook, import .bas, .cls and .frm files

oh-my-zsh-tips

Somes tips for Oh-my-zsh

vba_excel_RibbonDropdown

How to very easily load an Excel range into the ribbon as a dropdown

marknotes_csv2md

CSV to markdown converter

vbs_xls_list_references

Retrieve the list of references used in an Excel file (.xlam files f.i.) and display them on the console. Loop and process all Excel files in the current folder

excel_formatter

Improves the readability of Excel formulas. Display long formula into a nice HTML output

getjoomla

Fork of the getjoomla script of BestProject (https://github.com/bestproject/getjoomla.php)

joomla_mod_agency

mod_agency is a module for the Joomla backend and will display informations about the web agency who's responsible for the site. Name, URL, phone number, email, skype, ... of the person in charge of the daily maintenance of the site. mod_agency has been developped by the JUG Wallonie (http://www.jugwallonie.be)

markdown-tips

A few markdown tips and tools

vba_decrypt

Remove VBA password required for viewing code in MS Office documents

kill_folders

Very fast way to remove every files in a folder (subfolders included)

ssis_export_flatfiles_spec

Loop any SSIS packages and export the flatfiles connection managers to csv files. Very usefull for getting the description of files and add them, f.i., in your technical documentation.

json-tools

The idea of these scripts are simple: make easier to work with `.json` files.

_skeleton

Project skeleton

excel_tips

Tips and tricks for Microsoft Excel

php_helpers

Some helpers to develop faster in PHP 7

docker_tips

Some tips & tricks for Docker and docker-compose

json_encode

Very straight-forward script for encoding string in JSON

bash_tips

Some tips & tricks for bash

uses

List of some software I use in software development

vbs_transport

Transport DEV.xlsm to PROD.xlsm and update addins references

folder_size

Do you know the size of your website? How many megabytes/gigabytes?

db_documentor

This script will establish a connection to a MySQL database, retrieve all tables and document them by creating `.csv`, `.md` and `.sql` files. If you're using [Marknotes](https://github.com/cavo789/marknotes), it'll also create the full documentation folder for Marknotes.

test_vuejs

**Personal learning** application to understand VueJS using a step by step approach. Demo are available online.

vbs_access_export

Export every code objects of a MS Access database (forms, macros, modules and reports code) to flat files, in a batch mode

javascript_tips

Some tips & tricks and snippets for javascript

avonture

My homepage website (https://www.avonture.be)

docker_joomla

Support pour la session Docker lors du JoomlaDay FR 2022 (https://www.joomladay.fr/)

check_mod_rewrite

Simple script to check if mod_rewrite is enabled or not; not using php_info but a htaccess redirection.

vba_excel_import_sheets

VBA macro for trying to retrieve worksheets in a corrupt Excel file

php_obfuscator

Utility allowing to make a PHP code unreadable but leaving it perfectly executable.

zip_unzip

Need a simple script to take an archive of your website. The repository contains a script to create a ZIP archive of a website (or part of it).

vbs_sql_extract_stored_proc

VBS script for extracting every stored procedure from SQL Server databases into flat files on disk

vba_excel_dataquery_update

Small demo on how to run a UPDATE query on a worksheet

apache_logreader

Interface that allows you to analyze the log of web access to your site's resources and highlight URL attack attempts. Originally, this script was only intended for my personal use; that's why the interface is not necessarily the easiest to use. The tool is intended to be an aid in log analysis to e. g. understand how a website was attacked, by whom and how.

pandoc

PHP class that encapsulates pandoc in order to convert a text in markdown format to doc/odt/pdf/txt/…

powershell_commands

Some useful commands to run in the PowerShell console

docker_laravel

Easy instructions to install a fresh Laravel site and dockerize it

vba_outlook_CreateRuleSendToTrash

This is an Outlook macro for creating a rule to send emails to the trash (fight against spam)

aesecure_slides_hacked

Est-ce que mon site a été hacké ? Est-il propre ? Comment m'en assurer ? (French slideshow on how to check if our website is hacked)

vba_outlook_save_pdf

Do you need to export one or more emails to your hard disk as PDF files and remove these emails (or not) once done ? Here is my Outlook macro for this. My usage: take a copy of all important emails on my hard disk for archiving and backup on external disk. Once the backup is completed, the emails are deleted.

windows_terminal_tips

Windows Terminal Tips

postgrest

vba_outlook_fight_against_spam

VBA code to enhance the use of Outlook and mainly fight against spam, automatically assign emails to categories, ...

db_dump

Very straightforward script to dump a MySQL database and import it back; locally f.i.

php_tips

Collection of PHP tips and tricks

aesecure_clean_wordpress_options

Search for specific content in the wp_options table and allow to remove the value

bash_git_hooks

A few hooks written in Bash for Git

composer-addon-vscode

This little utility will help you when writing and maintaining your composer.json file

vbs_xls2scv

Convert Excel worksheets to csv files in batch

marknotes_md2html

Quick markdown to HTML converter: type your markdown, convert in HTML and copy in the clipboard, it's done.

vbs_count_lines

Scan the current folder, open every .txt files, count the number of lines and display a summary

ps_remove_duplicates

Find duplicated files on disk between folder A and B and remove them in folder B.

markdown

Various tools around the Markdown language such as a markdown to doc/html/pdf converter, from csv/html to markdown, ...

dos_tips

Some tips & tricks for Dos

slides_jugw

Présentations de la JUG Wallonie (https://jugwallonie.be)

phpunit_tips

Some tips and tricks for phpunit

laravel_tips

Collection of Laravel tips and tricks, including some files like artisan command

msaccess_optimize

Tips for optimizing an MS Access database without any migration to SQL Server

json_tips

Tips and tricks to work with json format

docker_python

**Personnal learning** Play with Python and Docker

composer_tips

Some tips & tricks for composer

chmod

Reset folder's permissions to 755 and 644 for files, this for the folder where the script is stored and any subfolders